DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_PVT dependencies on FND_MSG_PUB

Line 120: IF FND_MSG_PUB.Count_Msg =0 THEN

116: END IF;
117:
118: END IF;
119:
120: IF FND_MSG_PUB.Count_Msg =0 THEN
121:
122: --Log Message: 4403338
123: IF l_debug_mode = 'Y' THEN
124: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'

Line 169: IF FND_MSG_PUB.Count_Msg > 0 THEN

165: ,x_msg => 'x_action_set_id = '|| x_action_set_id
166: ,x_log_level => 5);
167: END IF;
168:
169: IF FND_MSG_PUB.Count_Msg > 0 THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172:
173: EXCEPTION

Line 177: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set'

173: EXCEPTION
174: WHEN OTHERS THEN
175:
176: -- Set the excetption Message and the stack
177: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set'
178: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
179: --
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: RAISE;

Line 293: IF FND_MSG_PUB.Count_Msg =0 THEN

289: END IF;
290:
291: END IF;
292:
293: IF FND_MSG_PUB.Count_Msg =0 THEN
294:
295: PA_ACTION_SETS_PKG.update_row
296: (p_action_set_id => p_action_set_id
297: ,p_action_set_name => p_action_set_name

Line 331: IF l_action_set_template_flag = 'N' AND FND_MSG_PUB.Count_Msg = 0 THEN

327: p_action_set_id => p_action_set_id,
328: p_action_set_template_flag => l_action_set_template_flag,
329: x_return_status => l_return_status);
330:
331: IF l_action_set_template_flag = 'N' AND FND_MSG_PUB.Count_Msg = 0 THEN
332:
333: PA_ACTION_SETS_PUB.perform_single_action_set
334: (p_action_set_id => p_action_set_id,
335: p_init_msg_list => FND_API.G_FALSE,

Line 346: IF FND_MSG_PUB.Count_Msg > 0 THEN

342: END IF;
343:
344: END IF;
345:
346: IF FND_MSG_PUB.Count_Msg > 0 THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: END IF;
349:
350: EXCEPTION

Line 354: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'

350: EXCEPTION
351: WHEN OTHERS THEN
352:
353: -- Set the excetption Message and the stack
354: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'
355: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
356: --
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: RAISE;

Line 411: IF FND_MSG_PUB.Count_Msg = 0 THEN

407: END IF;
408:
409: END IF;
410:
411: IF FND_MSG_PUB.Count_Msg = 0 THEN
412:
413: l_action_set_lines_tbl := pa_action_set_utils.get_action_set_lines(p_action_set_id => p_action_set_id);
414:
415: IF l_action_set_lines_tbl.COUNT > 0 THEN

Line 429: IF FND_MSG_PUB.Count_Msg = 0 THEN

425: END IF;
426:
427: END IF;
428:
429: IF FND_MSG_PUB.Count_Msg = 0 THEN
430:
431: l_do_lines_exist := PA_ACTION_SET_UTILS.do_lines_exist(p_action_set_id => p_action_set_id);
432:
433: IF l_do_lines_exist = 'N' THEN

Line 462: IF FND_MSG_PUB.Count_Msg > 0 THEN

458: END IF;
459:
460: END IF;
461:
462: IF FND_MSG_PUB.Count_Msg > 0 THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465:
466: EXCEPTION

Line 470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'

466: EXCEPTION
467: WHEN OTHERS THEN
468:
469: -- Set the excetption Message and the stack
470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'
471: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
472: --
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: RAISE;

Line 572: IF FND_MSG_PUB.Count_Msg = 0 THEN

568: ,x_msg => 'After validate_action_set_line: x_retun_status = '||l_return_status
569: ,x_log_level => 5);
570: END IF;
571:
572: IF FND_MSG_PUB.Count_Msg = 0 THEN
573:
574: PA_ACTION_SET_LINES_PKG.Insert_Row
575: (p_action_set_id => p_action_set_id
576: ,p_action_set_line_number => p_action_set_line_number

Line 619: IF FND_MSG_PUB.Count_Msg > 0 THEN

615:
616: END IF;
617:
618: -- If any errors exist then set the x_return_status to 'E'
619: IF FND_MSG_PUB.Count_Msg > 0 THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: END IF;
622:
623:

Line 628: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set_Line'

624: EXCEPTION
625: WHEN OTHERS THEN
626:
627: -- Set the excetption Message and the stack
628: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set_Line'
629: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
630: --
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
632: RAISE;

Line 722: IF FND_MSG_PUB.Count_Msg = 0 THEN

718: x_return_status => l_return_status);
719:
720:
721:
722: IF FND_MSG_PUB.Count_Msg = 0 THEN
723:
724: PA_ACTION_SET_LINES_PKG.Update_Row
725: (p_action_set_line_id => p_action_set_line_id
726: ,p_action_set_line_number => p_action_set_line_number

Line 768: IF FND_MSG_PUB.Count_Msg > 0 THEN

764:
765: END IF;
766:
767: -- If any errors exist then set the x_return_status to 'E'
768: IF FND_MSG_PUB.Count_Msg > 0 THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771:
772: EXCEPTION

Line 776: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'

772: EXCEPTION
773: WHEN OTHERS THEN
774:
775: -- Set the excetption Message and the stack
776: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'
777: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
778: --
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: RAISE;

Line 922: IF FND_MSG_PUB.Count_Msg > 0 THEN

918: END IF;
919:
920: END IF;
921:
922: IF FND_MSG_PUB.Count_Msg > 0 THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: END IF;
925:
926: EXCEPTION

Line 930: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'

926: EXCEPTION
927: WHEN OTHERS THEN
928:
929: -- Set the excetption Message and the stack
930: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'
931: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
932: --
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: RAISE;

Line 987: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.reverse_action_audit_lines'

983: EXCEPTION
984: WHEN OTHERS THEN
985:
986: -- Set the excetption Message and the stack
987: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.reverse_action_audit_lines'
988: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
989: --
990: RAISE;
991:

Line 1090: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'

1086: EXCEPTION
1087: WHEN OTHERS THEN
1088:
1089: -- Set the excetption Message and the stack
1090: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'
1091: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1092: --
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1094: RAISE;

Line 1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'

1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: WHEN OTHERS THEN
1139:
1140: -- Set the excetption Message and the stack
1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'
1142: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1143: --
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: RAISE;

Line 1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'

1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187:
1188: WHEN OTHERS THEN
1189: -- Set the excetption Message and the stack
1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'
1191: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1192: --
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: RAISE;

Line 1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'

1234: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: WHEN OTHERS THEN
1237: -- Set the excetption Message and the stack
1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'
1239: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1240: --
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1242: RAISE;

Line 1359: IF l_new_line_status_code = 'REVERSED' AND FND_MSG_PUB.Count_Msg > 0 THEN

1355: END IF;
1356:
1357: /*
1358: HOW SHOULD THIS BE HANDLED???
1359: IF l_new_line_status_code = 'REVERSED' AND FND_MSG_PUB.Count_Msg > 0 THEN
1360: l_line_deleted_flag := 'N';
1361: ELSE
1362: l_line_deleted_flag := FND_API.G_MISS_CHAR;
1363: END IF;

Line 1389: IF FND_MSG_PUB.Count_Msg > 0 AND FND_GLOBAL.CONC_REQUEST_ID = -1 THEN

1385: END IF;
1386: /*
1387:
1388: --only do if line not performed from concurrent program
1389: IF FND_MSG_PUB.Count_Msg > 0 AND FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1390: FOR i IN 1 .. FND_MSG_PUB.Count_Msg LOOP
1391: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1392: ,p_msg_index => i
1393: ,p_data => l_msg_data

Line 1390: FOR i IN 1 .. FND_MSG_PUB.Count_Msg LOOP

1386: /*
1387:
1388: --only do if line not performed from concurrent program
1389: IF FND_MSG_PUB.Count_Msg > 0 AND FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1390: FOR i IN 1 .. FND_MSG_PUB.Count_Msg LOOP
1391: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1392: ,p_msg_index => i
1393: ,p_data => l_msg_data
1394: ,p_msg_index_out => l_msg_index_out

Line 1413: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1409: */
1410:
1411: EXCEPTION
1412: WHEN e_invalid_result_code THEN
1413: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1414: ,p_procedure_name => PA_DEBUG.G_Err_Stack
1415: ,p_error_text => 'INVALID RESULT CODE: '||l_action_line_result_code);
1416: --
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1422: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1418: RAISE e_invalid_result_code;
1419:
1420: WHEN OTHERS THEN
1421: -- Set the excetption Message and the stack
1422: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1423: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1424: --
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1426: RAISE;