eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PROCESS_RULE_PVT dependencies on AS_UTILITY_PVT

Line 73: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

69:
70: -- Debug Message
71: IF (AS_DEBUG_HIGH_ON) THEN
72:
73: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
74: END IF;
75:
76:
77: -- Initialize API return status to SUCCESS

Line 100: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');

96:
97: -- Debug message
98: IF (AS_DEBUG_HIGH_ON) THEN
99:
100: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');
101: END IF;
102:
103: -- Invoke validation procedures
104: Validate_process_rule(

Line 107: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

103: -- Invoke validation procedures
104: Validate_process_rule(
105: p_init_msg_list => FND_API.G_FALSE,
106: p_validation_level => p_validation_level,
107: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
108: P_PROCESS_RULE_Rec => p_PROCESS_RULE_rec,
109: x_return_status => x_return_status,
110: x_msg_count => x_msg_count,
111: x_msg_data => x_msg_data);

Line 130: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

126: -- ========================================================================
127: */
128: Validate_rank(
129: P_Init_Msg_List => FND_API.G_FALSE,
130: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
131: P_Parent_Rule_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID,
132: P_Child_Rule_ID => x_PROCESS_RULE_ID,
133: P_RANK => p_PROCESS_RULE_rec.rank,
134: X_Return_Status => x_return_status,

Line 144: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

140: END IF;
141:
142: Validate_enddate(
143: P_Init_Msg_List => FND_API.G_FALSE,
144: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
145: P_START_DATE => p_PROCESS_RULE_rec.start_date,
146: P_END_DATE => p_PROCESS_RULE_rec.end_date,
147: X_Return_Status => x_return_status,
148: X_Msg_Count => x_msg_count,

Line 157: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

153: END IF;
154:
155: Validate_startdate(
156: P_Init_Msg_List => FND_API.G_FALSE,
157: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
158: P_Parent_Rule_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID,
159: P_START_DATE => p_PROCESS_RULE_rec.start_date,
160: X_Return_Status => x_return_status,
161: X_Msg_Count => x_msg_count,

Line 170: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

166: END IF;
167:
168: Validate_status(
169: P_Init_Msg_List => FND_API.G_FALSE,
170: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
171: P_Parent_Rule_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID,
172: P_STATUS => p_PROCESS_RULE_rec.status_code,
173: X_Return_Status => x_return_status,
174: X_Msg_Count => x_msg_count,

Line 184: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

180:
181: -- Debug Message
182: IF (AS_DEBUG_HIGH_ON) THEN
183:
184: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
185: END IF;
186:
187:
188: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Insert_Row)

Line 249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

245:
246: -- Debug Message
247: IF (AS_DEBUG_HIGH_ON) THEN
248:
249: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
250: END IF;
251:
252:
253: -- Standard call to get message count and if count is 1, get message info.

Line 261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
265: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 265: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

261: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
265: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:

Line 271: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
275: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 275: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

271: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
275: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
276: ,X_MSG_COUNT => X_MSG_COUNT
277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
279:

Line 281: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
279:
280: WHEN OTHERS THEN
281: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
285: ,P_SQLCODE => SQLCODE

Line 284: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

280: WHEN OTHERS THEN
281: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
285: ,P_SQLCODE => SQLCODE
286: ,P_SQLERRM => SQLERRM
287: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
288: ,X_MSG_COUNT => X_MSG_COUNT

Line 287: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
285: ,P_SQLCODE => SQLCODE
286: ,P_SQLERRM => SQLERRM
287: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
288: ,X_MSG_COUNT => X_MSG_COUNT
289: ,X_MSG_DATA => X_MSG_DATA
290: ,X_RETURN_STATUS => X_RETURN_STATUS);
291: End Create_process_rule;

Line 344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

340:
341: -- Debug Message
342: IF (AS_DEBUG_HIGH_ON) THEN
343:
344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
345: END IF;
346:
347:
348: -- Initialize API return status to SUCCESS

Line 358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

354:
355: -- Debug Message
356: IF (AS_DEBUG_HIGH_ON) THEN
357:
358: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
359: END IF;
360:
361:
362: Open C_Get_process_rule( l_tar_PROCESS_RULE_rec.PROCESS_RULE_ID);

Line 380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

376: END IF;
377: -- Debug Message
378: IF (AS_DEBUG_HIGH_ON) THEN
379:
380: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
381: END IF;
382: Close C_Get_process_rule;
383:
384: If (l_tar_PROCESS_RULE_rec.object_version_number is NULL or

Line 408: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');

404:
405: -- Debug message
406: IF (AS_DEBUG_HIGH_ON) THEN
407:
408: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');
409: END IF;
410:
411: -- Invoke validation procedures
412: Validate_process_rule(

Line 415: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

411: -- Invoke validation procedures
412: Validate_process_rule(
413: p_init_msg_list => FND_API.G_FALSE,
414: p_validation_level => p_validation_level,
415: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
416: P_PROCESS_RULE_Rec => P_PROCESS_RULE_Rec,
417: x_return_status => x_return_status,
418: x_msg_count => x_msg_count,
419: x_msg_data => x_msg_data);

Line 428: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

424:
425:
426: Validate_rank(
427: P_Init_Msg_List => FND_API.G_FALSE,
428: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
429: P_Parent_Rule_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID,
430: P_Child_Rule_ID => P_PROCESS_RULE_Rec.PROCESS_RULE_ID,
431: P_RANK => p_PROCESS_RULE_rec.rank,
432: X_Return_Status => x_return_status,

Line 443: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

439:
440:
441: Validate_enddate(
442: P_Init_Msg_List => FND_API.G_FALSE,
443: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
444: P_START_DATE => p_PROCESS_RULE_rec.start_date,
445: P_END_DATE => p_PROCESS_RULE_rec.end_date,
446: X_Return_Status => x_return_status,
447: X_Msg_Count => x_msg_count,

Line 456: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

452: END IF;
453:
454: Validate_startdate(
455: P_Init_Msg_List => FND_API.G_FALSE,
456: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
457: P_Parent_Rule_ID => p_PROCESS_RULE_rec.PARENT_RULE_ID,
458: P_START_DATE => p_PROCESS_RULE_rec.start_date,
459: X_Return_Status => x_return_status,
460: X_Msg_Count => x_msg_count,

Line 472: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

468: G_ACTION := 'UPDATE';
469:
470: Validate_status(
471: P_Init_Msg_List => FND_API.G_FALSE,
472: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
473: P_Parent_Rule_ID => p_PROCESS_RULE_rec.process_RULE_ID,
474: P_STATUS => p_PROCESS_RULE_rec.status_code,
475: X_Return_Status => x_return_status,
476: X_Msg_Count => x_msg_count,

Line 487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

483:
484: -- Debug Message
485: IF (AS_DEBUG_HIGH_ON) THEN
486:
487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
488: END IF;
489:
490: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Update_Row)
491: PV_PROCESS_RULES_PKG.Update_Row(

Line 545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

541:
542: -- Debug Message
543: IF (AS_DEBUG_HIGH_ON) THEN
544:
545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
546: END IF;
547:
548:
549: -- Standard call to get message count and if count is 1, get message info.

Line 557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

553: );
554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_API_NAME => L_API_NAME
559: ,P_PKG_NAME => G_PKG_NAME
560: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
561: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 561: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

557: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_API_NAME => L_API_NAME
559: ,P_PKG_NAME => G_PKG_NAME
560: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
561: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
562: ,X_MSG_COUNT => X_MSG_COUNT
563: ,X_MSG_DATA => X_MSG_DATA
564: ,X_RETURN_STATUS => X_RETURN_STATUS);
565:

Line 567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

563: ,X_MSG_DATA => X_MSG_DATA
564: ,X_RETURN_STATUS => X_RETURN_STATUS);
565:
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
568: P_API_NAME => L_API_NAME
569: ,P_PKG_NAME => G_PKG_NAME
570: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
571: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 571: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

567: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
568: P_API_NAME => L_API_NAME
569: ,P_PKG_NAME => G_PKG_NAME
570: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
571: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
572: ,X_MSG_COUNT => X_MSG_COUNT
573: ,X_MSG_DATA => X_MSG_DATA
574: ,X_RETURN_STATUS => X_RETURN_STATUS);
575:

Line 577: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

573: ,X_MSG_DATA => X_MSG_DATA
574: ,X_RETURN_STATUS => X_RETURN_STATUS);
575:
576: WHEN OTHERS THEN
577: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
578: P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
581: ,P_SQLCODE => SQLCODE

Line 580: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

576: WHEN OTHERS THEN
577: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
578: P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
581: ,P_SQLCODE => SQLCODE
582: ,P_SQLERRM => SQLERRM
583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
584: ,X_MSG_COUNT => X_MSG_COUNT

Line 583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
581: ,P_SQLCODE => SQLCODE
582: ,P_SQLERRM => SQLERRM
583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
584: ,X_MSG_COUNT => X_MSG_COUNT
585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
587: End Update_process_rule;

Line 718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

714:
715: -- Debug Message
716: IF (AS_DEBUG_HIGH_ON) THEN
717:
718: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
719: END IF;
720:
721:
722: -- Initialize API return status to SUCCESS

Line 910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: PV_PROCESS_RULES_PKG.Delete_Row');

906:
907: -- Debug Message
908: IF (AS_DEBUG_HIGH_ON) THEN
909:
910: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: PV_PROCESS_RULES_PKG.Delete_Row');
911: END IF;
912:
913: -- Invoke table handler(PV_PROCESS_RULES_B_PKG.Delete_Row)
914: PV_PROCESS_RULES_PKG.Delete_Row(

Line 960: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

956:
957: -- Debug Message
958: IF (AS_DEBUG_HIGH_ON) THEN
959:
960: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
961: END IF;
962:
963:
964: -- Standard call to get message count and if count is 1, get message info.

Line 972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

968: );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
973: P_API_NAME => L_API_NAME
974: ,P_PKG_NAME => G_PKG_NAME
975: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
973: P_API_NAME => L_API_NAME
974: ,P_PKG_NAME => G_PKG_NAME
975: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
976: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
977: ,X_MSG_COUNT => X_MSG_COUNT
978: ,X_MSG_DATA => X_MSG_DATA
979: ,X_RETURN_STATUS => X_RETURN_STATUS);
980:

Line 982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

978: ,X_MSG_DATA => X_MSG_DATA
979: ,X_RETURN_STATUS => X_RETURN_STATUS);
980:
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
983: P_API_NAME => L_API_NAME
984: ,P_PKG_NAME => G_PKG_NAME
985: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
986: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 986: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
983: P_API_NAME => L_API_NAME
984: ,P_PKG_NAME => G_PKG_NAME
985: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
986: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
987: ,X_MSG_COUNT => X_MSG_COUNT
988: ,X_MSG_DATA => X_MSG_DATA
989: ,X_RETURN_STATUS => X_RETURN_STATUS);
990:

Line 992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

988: ,X_MSG_DATA => X_MSG_DATA
989: ,X_RETURN_STATUS => X_RETURN_STATUS);
990:
991: WHEN OTHERS THEN
992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
993: P_API_NAME => L_API_NAME
994: ,P_PKG_NAME => G_PKG_NAME
995: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
996: ,P_SQLCODE => SQLCODE

Line 995: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

991: WHEN OTHERS THEN
992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
993: P_API_NAME => L_API_NAME
994: ,P_PKG_NAME => G_PKG_NAME
995: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
996: ,P_SQLCODE => SQLCODE
997: ,P_SQLERRM => SQLERRM
998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
999: ,X_MSG_COUNT => X_MSG_COUNT

Line 998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

994: ,P_PKG_NAME => G_PKG_NAME
995: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
996: ,P_SQLCODE => SQLCODE
997: ,P_SQLERRM => SQLERRM
998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
999: ,X_MSG_COUNT => X_MSG_COUNT
1000: ,X_MSG_DATA => X_MSG_DATA
1001: ,X_RETURN_STATUS => X_RETURN_STATUS);
1002: End Delete_process_rule;

Line 1125: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1121:
1122: -- Debug Message
1123: IF (AS_DEBUG_HIGH_ON) THEN
1124:
1125: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1126: END IF;
1127:
1128:
1129: -- Initialize API return status to SUCCESS

Line 1152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');

1148:
1149: -- Debug message
1150: IF (AS_DEBUG_HIGH_ON) THEN
1151:
1152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_process_rule');
1153: END IF;
1154:
1155: -- Invoke validation procedures
1156: Validate_process_rule(

Line 1159: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

1155: -- Invoke validation procedures
1156: Validate_process_rule(
1157: p_init_msg_list => FND_API.G_FALSE,
1158: p_validation_level => p_validation_level,
1159: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1160: P_PROCESS_RULE_Rec => P_PROCESS_RULE_Rec,
1161: x_return_status => x_return_status,
1162: x_msg_count => x_msg_count,
1163: x_msg_data => x_msg_data);

Line 1306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1302:
1303: -- Debug Message
1304: IF (AS_DEBUG_HIGH_ON) THEN
1305:
1306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1307: END IF;
1308:
1309:
1310: -- Standard call to get message count and if count is 1, get message info.

Line 1318: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1314: );
1315:
1316: EXCEPTION
1317: WHEN FND_API.G_EXC_ERROR THEN
1318: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1319: P_API_NAME => L_API_NAME
1320: ,P_PKG_NAME => G_PKG_NAME
1321: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1322: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1322: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1318: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1319: P_API_NAME => L_API_NAME
1320: ,P_PKG_NAME => G_PKG_NAME
1321: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1322: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1323: ,X_MSG_COUNT => X_MSG_COUNT
1324: ,X_MSG_DATA => X_MSG_DATA
1325: ,X_RETURN_STATUS => X_RETURN_STATUS);
1326:

Line 1328: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1324: ,X_MSG_DATA => X_MSG_DATA
1325: ,X_RETURN_STATUS => X_RETURN_STATUS);
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1329: P_API_NAME => L_API_NAME
1330: ,P_PKG_NAME => G_PKG_NAME
1331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1328: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1329: P_API_NAME => L_API_NAME
1330: ,P_PKG_NAME => G_PKG_NAME
1331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1333: ,X_MSG_COUNT => X_MSG_COUNT
1334: ,X_MSG_DATA => X_MSG_DATA
1335: ,X_RETURN_STATUS => X_RETURN_STATUS);
1336:

Line 1338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1334: ,X_MSG_DATA => X_MSG_DATA
1335: ,X_RETURN_STATUS => X_RETURN_STATUS);
1336:
1337: WHEN OTHERS THEN
1338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1339: P_API_NAME => L_API_NAME
1340: ,P_PKG_NAME => G_PKG_NAME
1341: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1342: ,P_SQLCODE => SQLCODE

Line 1341: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1337: WHEN OTHERS THEN
1338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1339: P_API_NAME => L_API_NAME
1340: ,P_PKG_NAME => G_PKG_NAME
1341: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1342: ,P_SQLCODE => SQLCODE
1343: ,P_SQLERRM => SQLERRM
1344: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1345: ,X_MSG_COUNT => X_MSG_COUNT

Line 1344: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1340: ,P_PKG_NAME => G_PKG_NAME
1341: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1342: ,P_SQLCODE => SQLCODE
1343: ,P_SQLERRM => SQLERRM
1344: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1345: ,X_MSG_COUNT => X_MSG_COUNT
1346: ,X_MSG_DATA => X_MSG_DATA
1347: ,X_RETURN_STATUS => X_RETURN_STATUS);
1348: End Copy_process_rule;

Line 1379: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1375:
1376: -- Initialize API return status to SUCCESS
1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1380: THEN
1381: IF (p_process_rule_id IS NOT NULL) AND
1382: (p_process_rule_id <> FND_API.G_MISS_NUM)
1383: THEN

Line 1389: AS_UTILITY_PVT.Set_Message(

1385: FETCH C_Process_Rule_Id_Exists into l_val;
1386:
1387: IF C_Process_Rule_Id_Exists%NOTFOUND
1388: THEN
1389: AS_UTILITY_PVT.Set_Message(
1390: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1391: p_msg_name => 'API_INVALID_ID',
1392: p_token1 => 'COLUMN',
1393: p_token1_value => 'PROCESS_RULE_ID',

Line 1402: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1398: END IF;
1399: CLOSE C_Process_Rule_Id_Exists ;
1400: END IF;
1401:
1402: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1403: THEN
1404: -- validate NOT NULL column
1405: IF (p_process_rule_id IS NULL) OR
1406: (p_process_rule_id = FND_API.G_MISS_NUM)

Line 1408: AS_UTILITY_PVT.Set_Message(

1404: -- validate NOT NULL column
1405: IF (p_process_rule_id IS NULL) OR
1406: (p_process_rule_id = FND_API.G_MISS_NUM)
1407: THEN
1408: AS_UTILITY_PVT.Set_Message(
1409: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1410: p_msg_name => 'API_MISSING_ID',
1411: p_token1 => 'COLUMN',
1412: p_token1_value => 'PROCESS_RULE_ID');

Line 1421: AS_UTILITY_PVT.Set_Message(

1417: FETCH C_Process_Rule_Id_Exists into l_val;
1418:
1419: IF C_Process_Rule_Id_Exists%NOTFOUND
1420: THEN
1421: AS_UTILITY_PVT.Set_Message(
1422: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1423: p_msg_name => 'API_INVALID_ID',
1424: p_token1 => 'COLUMN',
1425: p_token1_value => 'PROCESS_RULE_ID',

Line 1480: AS_UTILITY_PVT.Set_Message(

1476: OPEN C_Check_Resource_Id (p_owner_resource_id);
1477: FETCH C_Check_Resource_Id INTO l_val;
1478: IF (C_Check_Resource_Id%NOTFOUND)
1479: THEN
1480: AS_UTILITY_PVT.Set_Message(
1481: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1482: p_msg_name => 'API_INVALID_ID',
1483: p_token1 => 'COLUMN',
1484: p_token1_value => 'OWNER_RESOURCE_ID',

Line 1538: AS_UTILITY_PVT.Set_Message(

1534: THEN
1535: OPEN C_Currency_Exists ( p_currency_code );
1536: FETCH C_Currency_Exists into l_val;
1537: IF C_Currency_Exists%NOTFOUND THEN
1538: AS_UTILITY_PVT.Set_Message(
1539: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1540: p_msg_name => 'API_INVALID_ID',
1541: p_token1 => 'COLUMN',
1542: p_token1_value => 'CURRENCY',

Line 1596: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR

1592:
1593: -- Initialize API return status to SUCCESS
1594: x_return_status := FND_API.G_RET_STS_SUCCESS;
1595:
1596: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR
1597: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1598: THEN
1599: IF (p_rank IS NULL) OR (p_rank = FND_API.G_MISS_NUM) THEN
1600: AS_UTILITY_PVT.Set_Message(

Line 1597: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1593: -- Initialize API return status to SUCCESS
1594: x_return_status := FND_API.G_RET_STS_SUCCESS;
1595:
1596: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR
1597: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1598: THEN
1599: IF (p_rank IS NULL) OR (p_rank = FND_API.G_MISS_NUM) THEN
1600: AS_UTILITY_PVT.Set_Message(
1601: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1600: AS_UTILITY_PVT.Set_Message(

1596: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR
1597: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1598: THEN
1599: IF (p_rank IS NULL) OR (p_rank = FND_API.G_MISS_NUM) THEN
1600: AS_UTILITY_PVT.Set_Message(
1601: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1602: p_msg_name => 'API_MISSING_RANK',
1603: p_token1 => 'RANK',
1604: p_token1_value => p_rank);

Line 1627: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

1623:
1624: -- Debug Message
1625: IF (AS_DEBUG_HIGH_ON) THEN
1626:
1627: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
1628: END IF;
1629: CLOSE lc_chk_criterion_dups;
1630: END IF;
1631: END IF;

Line 1663: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR

1659:
1660: -- Initialize API return status to SUCCESS
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR
1664: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1665: THEN
1666: IF (P_START_DATE is not null and P_END_DATE is not null)
1667: THEN

Line 1664: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1660: -- Initialize API return status to SUCCESS
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR
1664: p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1665: THEN
1666: IF (P_START_DATE is not null and P_END_DATE is not null)
1667: THEN
1668: IF P_END_DATE < P_START_DATE

Line 1677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

1673: END IF;
1674: END IF;
1675: -- Debug Message
1676: IF (AS_DEBUG_HIGH_ON) THEN
1677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
1678: END IF;
1679: END IF;
1680:
1681: -- Standard call to get message count and if count is 1, get message info.

Line 1710: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1706:
1707: -- Initialize API return status to SUCCESS
1708: x_return_status := FND_API.G_RET_STS_SUCCESS;
1709:
1710: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1711: THEN
1712: IF (P_PARENT_RULE_ID is null or P_PARENT_RULE_ID = FND_API.G_MISS_NUM) then
1713: IF (P_START_DATE is null or P_START_DATE = FND_API.G_MISS_DATE) then
1714: FND_MESSAGE.Set_Name('PV', 'PV_STARTDATE_NOTNULL');

Line 1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718: END IF;
1719: IF (AS_DEBUG_HIGH_ON) THEN
1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
1721: END IF;
1722: END IF;
1723: -- Standard call to get message count and if count is 1, get message info.
1724: FND_MSG_PUB.Count_And_Get

Line 1767: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1763:
1764: -- Initialize API return status to SUCCESS
1765: x_return_status := FND_API.G_RET_STS_SUCCESS;
1766:
1767: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE OR p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1768: THEN
1769: IF (P_PARENT_RULE_ID is null or P_PARENT_RULE_ID = FND_API.G_MISS_NUM) then
1770: IF (P_STATUS is null or P_STATUS = FND_API.G_MISS_CHAR) then
1771: FND_MESSAGE.Set_Name('PV', 'PV_STATUS_NOTNULL');

Line 1777: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775: END IF;
1776: IF (AS_DEBUG_HIGH_ON) THEN
1777: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
1778: END IF;
1779: END IF;
1780:
1781: -- ---------------------------------------------------------------------

Line 1844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1840:
1841: -- Debug Message
1842: IF (AS_DEBUG_HIGH_ON) THEN
1843:
1844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1845: END IF;
1846:
1847:
1848: -- Initialize API return status to SUCCESS

Line 1951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1947:
1948: -- Debug Message
1949: IF (AS_DEBUG_HIGH_ON) THEN
1950:
1951: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1952: END IF;
1953:
1954: END Validate_process_rule;
1955: