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.PA_CONTROL_API_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.initialize;

94: END IF;
95:
96: --initializing the message stack.
97: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:
101: IF p_commit = FND_API.G_TRUE THEN
102: savepoint ADD_WORKPLAN_IMPACT_SVPT;

Line 155: l_msg_count := FND_MSG_PUB.count_msg;

151: Exception
152: when FND_API.G_EXC_ERROR then
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: l_msg_count := FND_MSG_PUB.count_msg;
156:
157: IF p_commit = FND_API.G_TRUE THEN
158: ROLLBACK TO ADD_WORKPLAN_IMPACT_SVPT;
159: END IF;

Line 187: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

183:
184: IF p_commit = FND_API.G_TRUE THEN
185: ROLLBACK TO ADD_WORKPLAN_IMPACT_SVPT;
186: END IF;
187: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
188: p_procedure_name => 'Add_Workplan_Impact',
189: p_error_text => x_msg_data);
190: x_msg_count := FND_MSG_PUB.count_msg;
191: if l_debug_mode = 'Y' then

Line 190: x_msg_count := FND_MSG_PUB.count_msg;

186: END IF;
187: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
188: p_procedure_name => 'Add_Workplan_Impact',
189: p_error_text => x_msg_data);
190: x_msg_count := FND_MSG_PUB.count_msg;
191: if l_debug_mode = 'Y' then
192: pa_debug.reset_err_stack;
193: end if;
194:

Line 229: FND_MSG_PUB.initialize;

225: PA_DEBUG.set_curr_function(p_function => 'Add_Staffing_Impact', p_debug_mode => l_debug_mode);
226: END IF;
227:
228: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231:
232: IF p_commit = FND_API.G_TRUE THEN
233: savepoint ADD_STAFFING_IMPACT_SVPT;

Line 284: l_msg_count := FND_MSG_PUB.count_msg;

280: Exception
281: when FND_API.G_EXC_ERROR then
282:
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: l_msg_count := FND_MSG_PUB.count_msg;
285:
286: IF p_commit = FND_API.G_TRUE THEN
287: ROLLBACK TO ADD_STAFFING_IMPACT_SVPT;
288: END IF;

Line 314: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

310: x_msg_data := substr(SQLERRM,1,240);
311: IF p_commit = FND_API.G_TRUE THEN
312: ROLLBACK TO ADD_STAFFING_IMPACT_SVPT;
313: END IF;
314: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
315: p_procedure_name => 'Add_Staffing_Impact',
316: p_error_text => x_msg_data);
317: x_msg_count := FND_MSG_PUB.count_msg;
318: if l_debug_mode = 'Y' then

Line 317: x_msg_count := FND_MSG_PUB.count_msg;

313: END IF;
314: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
315: p_procedure_name => 'Add_Staffing_Impact',
316: p_error_text => x_msg_data);
317: x_msg_count := FND_MSG_PUB.count_msg;
318: if l_debug_mode = 'Y' then
319: pa_debug.reset_err_stack;
320: end if;
321:

Line 357: FND_MSG_PUB.initialize;

353: PA_DEBUG.set_curr_function(p_function => 'Add_Contract_Impact', p_debug_mode => l_debug_mode);
354: END IF;
355:
356: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: IF p_commit = FND_API.G_TRUE THEN
361: savepoint ADD_CONTRACT_IMPACT_SVPT;

Line 412: l_msg_count := FND_MSG_PUB.count_msg;

408: Exception
409: when FND_API.G_EXC_ERROR then
410:
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: l_msg_count := FND_MSG_PUB.count_msg;
413:
414: IF p_commit = FND_API.G_TRUE THEN
415: ROLLBACK TO ADD_CONTRACT_IMPACT_SVPT;
416: END IF;

Line 442: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

438:
439: IF p_commit = FND_API.G_TRUE THEN
440: ROLLBACK TO ADD_CONTRACT_IMPACT_SVPT;
441: END IF;
442: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
443: p_procedure_name => 'Add_Contract_Impact',
444: p_error_text => x_msg_data);
445: x_msg_count := FND_MSG_PUB.count_msg;
446: if l_debug_mode = 'Y' then

Line 445: x_msg_count := FND_MSG_PUB.count_msg;

441: END IF;
442: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
443: p_procedure_name => 'Add_Contract_Impact',
444: p_error_text => x_msg_data);
445: x_msg_count := FND_MSG_PUB.count_msg;
446: if l_debug_mode = 'Y' then
447: pa_debug.reset_err_stack;
448: end if;
449: End Add_Contract_Impact;

Line 482: FND_MSG_PUB.initialize;

478: PA_DEBUG.set_curr_function(p_function => 'Add_Other_Impact', p_debug_mode => l_debug_mode);
479: END IF;
480:
481: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
482: FND_MSG_PUB.initialize;
483: END IF;
484:
485: IF p_commit = FND_API.G_TRUE THEN
486: savepoint ADD_OTHER_IMPACT_SVPT;

Line 537: l_msg_count := FND_MSG_PUB.count_msg;

533: Exception
534: when FND_API.G_EXC_ERROR then
535:
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: l_msg_count := FND_MSG_PUB.count_msg;
538:
539: IF p_commit = FND_API.G_TRUE THEN
540: ROLLBACK TO ADD_OTHER_IMPACT_SVPT;
541: END IF;

Line 567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

563:
564: IF p_commit = FND_API.G_TRUE THEN
565: ROLLBACK TO ADD_OTHER_IMPACT_SVPT;
566: END IF;
567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
568: p_procedure_name => 'Add_Other_Impact',
569: p_error_text => x_msg_data);
570: x_msg_count := FND_MSG_PUB.count_msg;
571:

Line 570: x_msg_count := FND_MSG_PUB.count_msg;

566: END IF;
567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
568: p_procedure_name => 'Add_Other_Impact',
569: p_error_text => x_msg_data);
570: x_msg_count := FND_MSG_PUB.count_msg;
571:
572: if l_debug_mode = 'Y' then
573: pa_debug.reset_err_stack;
574: end if;

Line 623: FND_MSG_PUB.initialize;

619: PA_DEBUG.set_curr_function(p_function => 'Add_Supplier_Impact', p_debug_mode => l_debug_mode);
620: END IF;
621:
622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
623: FND_MSG_PUB.initialize;
624: END IF;
625:
626: IF p_commit = FND_API.G_TRUE THEN
627: savepoint ADD_SUPPLIER_IMPACT_SVPT;

Line 697: l_msg_count := fnd_msg_pub.count_msg;

693: Exception
694: when FND_API.G_EXC_ERROR then
695:
696: x_return_status := fnd_api.g_ret_sts_error;
697: l_msg_count := fnd_msg_pub.count_msg;
698:
699: IF p_commit = 'T' THEN
700: ROLLBACK to ADD_SUPPLIER_IMPACT_SVPT;
701: END IF;

Line 731: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

727: x_msg_data := substr(SQLERRM,1,240);
728: IF p_commit = FND_API.G_TRUE THEN
729: ROLLBACK TO ADD_SUPPLIER_IMPACT_SVPT;
730: END IF;
731: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
732: p_procedure_name => 'Add_Supplier_Impact',
733: p_error_text => x_msg_data);
734: x_msg_count := FND_MSG_PUB.count_msg;
735: --Reset the stack

Line 734: x_msg_count := FND_MSG_PUB.count_msg;

730: END IF;
731: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
732: p_procedure_name => 'Add_Supplier_Impact',
733: p_error_text => x_msg_data);
734: x_msg_count := FND_MSG_PUB.count_msg;
735: --Reset the stack
736: if l_debug_mode = 'Y' then
737: Pa_Debug.reset_curr_function;
738: end if;

Line 774: FND_MSG_PUB.initialize;

770: PA_DEBUG.set_curr_function(p_function => 'Update_Workplan_Impact', p_debug_mode => l_debug_mode);
771: END IF;
772:
773: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776:
777: IF p_commit = FND_API.G_TRUE THEN
778: savepoint UPDATE_WORKPLAN_IMPACT_SVPT;

Line 829: l_msg_count := fnd_msg_pub.count_msg;

825: Exception
826: when FND_API.G_EXC_ERROR then
827:
828: x_return_status := fnd_api.g_ret_sts_error;
829: l_msg_count := fnd_msg_pub.count_msg;
830:
831: IF p_commit = 'T' THEN
832: ROLLBACK to UPDATE_WORKPLAN_IMPACT_SVPT;
833: END IF;

Line 863: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

859: ROLLBACK TO UPDATE_WORKPLAN_IMPACT_SVPT;
860: END IF;
861:
862:
863: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
864: p_procedure_name => 'UPDATE_WORKPLAN_IMPACT',
865: p_error_text => x_msg_data);
866: x_msg_count := FND_MSG_PUB.count_msg;
867: --Reset the stack

Line 866: x_msg_count := FND_MSG_PUB.count_msg;

862:
863: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
864: p_procedure_name => 'UPDATE_WORKPLAN_IMPACT',
865: p_error_text => x_msg_data);
866: x_msg_count := FND_MSG_PUB.count_msg;
867: --Reset the stack
868: if l_debug_mode = 'Y' then
869: Pa_Debug.reset_curr_function;
870: end if;

Line 906: FND_MSG_PUB.initialize;

902: PA_DEBUG.set_curr_function(p_function => 'Update_Staffing_Impact', p_debug_mode => l_debug_mode);
903: END IF;
904:
905: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
906: FND_MSG_PUB.initialize;
907: END IF;
908:
909: IF p_commit = FND_API.G_TRUE THEN
910: savepoint UPDATE_STAFFING_IMPACT_SVPT;

Line 962: l_msg_count := fnd_msg_pub.count_msg;

958: Exception
959: when FND_API.G_EXC_ERROR then
960:
961: x_return_status := fnd_api.g_ret_sts_error;
962: l_msg_count := fnd_msg_pub.count_msg;
963:
964: IF p_commit = 'T' THEN
965: ROLLBACK to UPDATE_STAFFING_IMPACT_SVPT;
966: END IF;

Line 996: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

992: ROLLBACK TO UPDATE_STAFFING_IMPACT_SVPT;
993: END IF;
994:
995:
996: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
997: p_procedure_name => 'UPDATE_STAFFING_IMPACT',
998: p_error_text => x_msg_data);
999: x_msg_count := FND_MSG_PUB.count_msg;
1000: --Reset the stack

Line 999: x_msg_count := FND_MSG_PUB.count_msg;

995:
996: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
997: p_procedure_name => 'UPDATE_STAFFING_IMPACT',
998: p_error_text => x_msg_data);
999: x_msg_count := FND_MSG_PUB.count_msg;
1000: --Reset the stack
1001: if l_debug_mode = 'Y' then
1002: Pa_Debug.reset_curr_function;
1003: end if;

Line 1040: FND_MSG_PUB.initialize;

1036: PA_DEBUG.set_curr_function(p_function => 'Update_Contract_Impact', p_debug_mode => l_debug_mode);
1037: END IF;
1038:
1039: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
1040: FND_MSG_PUB.initialize;
1041: END IF;
1042:
1043: IF p_commit = FND_API.G_TRUE THEN
1044: savepoint UPDATE_CONTRACT_IMPACT_SVPT;

Line 1095: l_msg_count := fnd_msg_pub.count_msg;

1091: Exception
1092: when FND_API.G_EXC_ERROR then
1093:
1094: x_return_status := fnd_api.g_ret_sts_error;
1095: l_msg_count := fnd_msg_pub.count_msg;
1096:
1097: IF p_commit = 'T' THEN
1098: ROLLBACK to UPDATE_CONTRACT_IMPACT_SVPT;
1099: END IF;

Line 1128: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

1124: IF p_commit = FND_API.G_TRUE THEN
1125: ROLLBACK TO UPDATE_CONTRACT_IMPACT_SVPT;
1126: END IF;
1127:
1128: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1129: p_procedure_name => 'UPDATE_CONTRACT_IMPACT',
1130: p_error_text => x_msg_data);
1131: x_msg_count := FND_MSG_PUB.count_msg;
1132: --Reset the stack

Line 1131: x_msg_count := FND_MSG_PUB.count_msg;

1127:
1128: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1129: p_procedure_name => 'UPDATE_CONTRACT_IMPACT',
1130: p_error_text => x_msg_data);
1131: x_msg_count := FND_MSG_PUB.count_msg;
1132: --Reset the stack
1133: if l_debug_mode = 'Y' then
1134: Pa_Debug.reset_curr_function;
1135: end if;

Line 1172: FND_MSG_PUB.initialize;

1168: PA_DEBUG.set_curr_function(p_function => 'Update_Other_Impact', p_debug_mode => l_debug_mode);
1169: END IF;
1170:
1171: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
1172: FND_MSG_PUB.initialize;
1173: END IF;
1174:
1175: IF p_commit = FND_API.G_TRUE THEN
1176: savepoint UPDATE_OTHER_IMPACT_SVPT;

Line 1228: l_msg_count := fnd_msg_pub.count_msg;

1224: Exception
1225: when FND_API.G_EXC_ERROR then
1226:
1227: x_return_status := fnd_api.g_ret_sts_error;
1228: l_msg_count := fnd_msg_pub.count_msg;
1229:
1230: IF p_commit = 'T' THEN
1231: ROLLBACK to UPDATE_OTHER_IMPACT_SVPT;
1232: END IF;

Line 1262: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

1258: ROLLBACK TO UPDATE_OTHER_IMPACT_SVPT;
1259: END IF;
1260:
1261:
1262: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1263: p_procedure_name => 'Update_Other_Impact',
1264: p_error_text => x_msg_data);
1265: x_msg_count := FND_MSG_PUB.count_msg;
1266: --Reset the stack

Line 1265: x_msg_count := FND_MSG_PUB.count_msg;

1261:
1262: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1263: p_procedure_name => 'Update_Other_Impact',
1264: p_error_text => x_msg_data);
1265: x_msg_count := FND_MSG_PUB.count_msg;
1266: --Reset the stack
1267: if l_debug_mode = 'Y' then
1268: Pa_Debug.reset_curr_function;
1269: end if;

Line 1303: FND_MSG_PUB.initialize;

1299: PA_DEBUG.set_curr_function(p_function => 'Update_Supplier_Impact', p_debug_mode => l_debug_mode);
1300: END IF;
1301:
1302: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
1303: FND_MSG_PUB.initialize;
1304: END IF;
1305:
1306: IF p_commit = FND_API.G_TRUE THEN
1307: savepoint UPDATE_SUPPLIER_IMPACT_SVPT;

Line 1357: l_msg_count := fnd_msg_pub.count_msg;

1353: Exception
1354: when FND_API.G_EXC_ERROR then
1355:
1356: x_return_status := fnd_api.g_ret_sts_error;
1357: l_msg_count := fnd_msg_pub.count_msg;
1358:
1359: IF p_commit = 'T' THEN
1360: ROLLBACK to UPDATE_SUPPLIER_IMPACT_SVPT;
1361: END IF;

Line 1390: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

1386: IF p_commit = FND_API.G_TRUE THEN
1387: ROLLBACK TO UPDATE_SUPPLIER_IMPACT_SVPT;
1388: END IF;
1389:
1390: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1391: p_procedure_name => 'Update_Supplier_Impact',
1392: p_error_text => x_msg_data);
1393: x_msg_count := FND_MSG_PUB.count_msg;
1394: --Reset the stack

Line 1393: x_msg_count := FND_MSG_PUB.count_msg;

1389:
1390: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1391: p_procedure_name => 'Update_Supplier_Impact',
1392: p_error_text => x_msg_data);
1393: x_msg_count := FND_MSG_PUB.count_msg;
1394: --Reset the stack
1395: if l_debug_mode = 'Y' then
1396: Pa_Debug.reset_curr_function;
1397: end if;

Line 1448: FND_MSG_PUB.Initialize;

1444: x_Msg_Count := 0;
1445:
1446: -- Clear the Global PL/SQL Message table.
1447: IF (FND_API.To_Boolean (p_Init_Msg_List)) THEN
1448: FND_MSG_PUB.Initialize;
1449: END IF;
1450:
1451: IF p_commit = FND_API.G_TRUE THEN
1452: savepoint DELETE_SUPP_DETAIL_SVPT;

Line 1537: l_msg_count := FND_MSG_PUB.count_msg;

1533: Exception
1534: when FND_API.G_EXC_ERROR then
1535:
1536: x_return_status := FND_API.G_RET_STS_ERROR;
1537: l_msg_count := FND_MSG_PUB.count_msg;
1538:
1539: IF p_commit = FND_API.G_TRUE THEN
1540: ROLLBACK TO DELETE_SUPP_DETAIL_SVPT;
1541: END IF;

Line 1567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

1563:
1564: IF p_commit = FND_API.G_TRUE THEN
1565: ROLLBACK TO ADD_CONTRACT_IMPACT_SVPT;
1566: END IF;
1567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1568: p_procedure_name => 'Delete_Supplier_Impact_Details',
1569: p_error_text => x_msg_data);
1570: x_msg_count := FND_MSG_PUB.count_msg;
1571: if l_debug_mode = 'Y' then

Line 1570: x_msg_count := FND_MSG_PUB.count_msg;

1566: END IF;
1567: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
1568: p_procedure_name => 'Delete_Supplier_Impact_Details',
1569: p_error_text => x_msg_data);
1570: x_msg_count := FND_MSG_PUB.count_msg;
1571: if l_debug_mode = 'Y' then
1572: pa_debug.reset_err_stack;
1573: end if;
1574: End Delete_Supplier_Impact_Details;

Line 1749: FND_MSG_PUB.initialize;

1745: PA_DEBUG.set_curr_function(p_function => 'UPDATE_PROGRESS', p_debug_mode => l_debug_mode);
1746: END IF;
1747:
1748: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
1749: FND_MSG_PUB.initialize;
1750: END IF;
1751:
1752: IF p_commit = FND_API.G_TRUE THEN
1753: savepoint UPDATE_PROGRESS_SVPT;

Line 2301: l_msg_count := fnd_msg_pub.count_msg;

2297: Exception
2298: when FND_API.G_EXC_ERROR then
2299:
2300: x_return_status := FND_API.G_RET_STS_ERROR;
2301: l_msg_count := fnd_msg_pub.count_msg;
2302: IF p_commit = 'T' THEN
2303: ROLLBACK to UPDATE_PROGRESS_SVPT;
2304: END IF;
2305:

Line 2331: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

2327: x_msg_data := substr(SQLERRM,1,240);
2328: IF p_commit = FND_API.G_TRUE THEN
2329: ROLLBACK TO UPDATE_PROGRESS_SVPT;
2330: END IF;
2331: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
2332: p_procedure_name => 'Update_Progress',
2333: p_error_text => x_msg_data);
2334: x_msg_count := FND_MSG_PUB.count_msg;
2335: --Reset the stack

Line 2334: x_msg_count := FND_MSG_PUB.count_msg;

2330: END IF;
2331: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
2332: p_procedure_name => 'Update_Progress',
2333: p_error_text => x_msg_data);
2334: x_msg_count := FND_MSG_PUB.count_msg;
2335: --Reset the stack
2336: if l_debug_mode = 'Y' then
2337: Pa_Debug.reset_curr_function;
2338: end if;

Line 2486: fnd_msg_pub.initialize;

2482: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_issue', p_debug_mode => l_debug_mode);
2483: end if;
2484:
2485: if fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) then
2486: fnd_msg_pub.initialize;
2487: end if;
2488:
2489: if p_commit = fnd_api.g_true then
2490: savepoint create_issue;

Line 2911: FND_MSG_PUB.Count_And_Get(

2907: --do a rollback;
2908: if p_commit = fnd_api.g_true then
2909: rollback to create_issue;
2910: end if;
2911: FND_MSG_PUB.Count_And_Get(
2912: p_count => x_msg_count ,
2913: p_data => x_msg_data );
2914:
2915: /*Initialize the out variables back to null*/

Line 2932: l_msg_count := fnd_msg_pub.count_msg;

2928: --do a rollback;
2929: if p_commit = fnd_api.g_true then
2930: rollback to create_issue;
2931: end if;
2932: l_msg_count := fnd_msg_pub.count_msg;
2933: if l_msg_count = 1 then
2934: pa_interface_utils_pub.get_messages
2935: (p_encoded => fnd_api.g_false,
2936: p_msg_index => 1,

Line 2963: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',

2959: --do a rollback;
2960: if p_commit = fnd_api.g_true then
2961: rollback to create_issue;
2962: end if;
2963: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
2964: p_procedure_name => 'create_issue',
2965: p_error_text => substrb(sqlerrm,1,240));
2966: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2967: p_data => x_msg_data);

Line 2966: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2962: end if;
2963: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
2964: p_procedure_name => 'create_issue',
2965: p_error_text => substrb(sqlerrm,1,240));
2966: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2967: p_data => x_msg_data);
2968:
2969: /*Initialize the out variables back to null*/
2970: x_ci_id := null;

Line 3121: fnd_msg_pub.initialize;

3117: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_change_request', p_debug_mode => l_debug_mode);
3118: end if;
3119:
3120: if fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) then
3121: fnd_msg_pub.initialize;
3122: end if;
3123:
3124: if p_commit = fnd_api.g_true then
3125: savepoint create_change_request;

Line 3546: FND_MSG_PUB.Count_And_Get(

3542: --do a rollback;
3543: if p_commit = fnd_api.g_true then
3544: rollback to create_change_request;
3545: end if;
3546: FND_MSG_PUB.Count_And_Get(
3547: p_count => x_msg_count ,
3548: p_data => x_msg_data );
3549:
3550: /*Initialize the out variables back to null*/

Line 3567: l_msg_count := fnd_msg_pub.count_msg;

3563: --do a rollback;
3564: if p_commit = fnd_api.g_true then
3565: rollback to create_change_request;
3566: end if;
3567: l_msg_count := fnd_msg_pub.count_msg;
3568: if l_msg_count = 1 then
3569: pa_interface_utils_pub.get_messages
3570: (p_encoded => fnd_api.g_false,
3571: p_msg_index => 1,

Line 3598: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',

3594: --do a rollback;
3595: if p_commit = fnd_api.g_true then
3596: rollback to create_change_request;
3597: end if;
3598: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
3599: p_procedure_name => 'create_change_request',
3600: p_error_text => substrb(sqlerrm,1,240));
3601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3602: p_data => x_msg_data);

Line 3601: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3597: end if;
3598: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
3599: p_procedure_name => 'create_change_request',
3600: p_error_text => substrb(sqlerrm,1,240));
3601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3602: p_data => x_msg_data);
3603:
3604: /*Initialize the out variables back to null*/
3605: x_ci_id := null;

Line 3756: fnd_msg_pub.initialize;

3752: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_change_order', p_debug_mode => l_debug_mode);
3753: end if;
3754:
3755: if fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) then
3756: fnd_msg_pub.initialize;
3757: end if;
3758:
3759: if p_commit = fnd_api.g_true then
3760: savepoint create_change_order;

Line 4181: FND_MSG_PUB.Count_And_Get(

4177: --do a rollback;
4178: if p_commit = fnd_api.g_true then
4179: rollback to create_change_order;
4180: end if;
4181: FND_MSG_PUB.Count_And_Get(
4182: p_count => x_msg_count ,
4183: p_data => x_msg_data );
4184:
4185: /*Initialize the out variables back to null*/

Line 4202: l_msg_count := fnd_msg_pub.count_msg;

4198: --do a rollback;
4199: if p_commit = fnd_api.g_true then
4200: rollback to create_change_order;
4201: end if;
4202: l_msg_count := fnd_msg_pub.count_msg;
4203: if l_msg_count = 1 then
4204: pa_interface_utils_pub.get_messages
4205: (p_encoded => fnd_api.g_false,
4206: p_msg_index => 1,

Line 4233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',

4229: --do a rollback;
4230: if p_commit = fnd_api.g_true then
4231: rollback to create_change_order;
4232: end if;
4233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4234: p_procedure_name => 'create_change_order',
4235: p_error_text => substrb(sqlerrm,1,240));
4236: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4237: p_data => x_msg_data);

Line 4236: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4232: end if;
4233: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4234: p_procedure_name => 'create_change_order',
4235: p_error_text => substrb(sqlerrm,1,240));
4236: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4237: p_data => x_msg_data);
4238:
4239: /*Initialize the out variables back to null*/
4240: x_ci_id := null;

Line 4288: fnd_msg_pub.initialize;

4284: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.create_action', p_debug_mode => l_debug_mode);
4285: end if;
4286:
4287: if fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) then
4288: fnd_msg_pub.initialize;
4289: end if;
4290:
4291: if p_commit = fnd_api.g_true then
4292: savepoint create_action;

Line 4374: l_msg_count := fnd_msg_pub.count_msg;

4370: if p_commit = fnd_api.g_true then
4371: rollback to create_action;
4372: end if;
4373:
4374: l_msg_count := fnd_msg_pub.count_msg;
4375: if l_msg_count = 1 then
4376: pa_interface_utils_pub.get_messages
4377: (p_encoded => fnd_api.g_false,
4378: p_msg_index => 1,

Line 4411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pub',

4407: rollback to create_action;
4408:
4409: end if;
4410:
4411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pub',
4412: p_procedure_name => 'create_action',
4413: p_error_text => substrb(sqlerrm,1,240));
4414: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4415: p_data => x_msg_data);

Line 4414: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4410:
4411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pub',
4412: p_procedure_name => 'create_action',
4413: p_error_text => substrb(sqlerrm,1,240));
4414: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4415: p_data => x_msg_data);
4416:
4417: /*Initialize the out variables back to null*/
4418: /*set the elements in the out table to null here*/

Line 4510: fnd_msg_pub.initialize;

4506: pa_debug.set_curr_function(p_function => 'pa_control_api_pub.take_action', p_debug_mode => l_debug_mode);
4507: end if;
4508:
4509: if fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) then
4510: fnd_msg_pub.initialize;
4511: end if;
4512:
4513: if p_commit = fnd_api.g_true then
4514: savepoint take_action;

Line 4935: l_msg_count := fnd_msg_pub.count_msg;

4931: rollback to take_action;
4932: end if;
4933:
4934: x_return_status := fnd_api.g_ret_sts_error;
4935: l_msg_count := fnd_msg_pub.count_msg;
4936: if l_msg_count = 1 then
4937: pa_interface_utils_pub.get_messages
4938: (p_encoded => fnd_api.g_false,
4939: p_msg_index => 1,

Line 4965: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',

4961: rollback to take_action;
4962: end if;
4963:
4964: x_return_status := fnd_api.g_ret_sts_unexp_error;
4965: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4966: p_procedure_name => 'take_action',
4967: p_error_text => substrb(sqlerrm,1,240));
4968: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4969: p_data => x_msg_data);

Line 4968: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4964: x_return_status := fnd_api.g_ret_sts_unexp_error;
4965: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4966: p_procedure_name => 'take_action',
4967: p_error_text => substrb(sqlerrm,1,240));
4968: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4969: p_data => x_msg_data);
4970:
4971: /*no out variables to intialise back to null*/
4972: /*no inout variables to initialize to their initial values*/

Line 4986: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',

4982: rollback to take_action;
4983: end if;
4984:
4985: x_return_status := fnd_api.g_ret_sts_unexp_error;
4986: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4987: p_procedure_name => 'take_action',
4988: p_error_text => substrb(sqlerrm,1,240));
4989: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4990: p_data => x_msg_data);

Line 4989: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4985: x_return_status := fnd_api.g_ret_sts_unexp_error;
4986: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_API_PUB',
4987: p_procedure_name => 'take_action',
4988: p_error_text => substrb(sqlerrm,1,240));
4989: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4990: p_data => x_msg_data);
4991:
4992: /*no out variables to intialise back to null*/
4993: /*no inout variables to initialize to their initial values*/

Line 5052: FND_MSG_PUB.initialize;

5048: PA_DEBUG.set_curr_function(p_function => 'Cancel_Action', p_debug_mode => l_debug_mode);
5049: END IF;
5050:
5051: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
5052: FND_MSG_PUB.initialize;
5053: END IF;
5054:
5055: IF p_commit = FND_API.G_TRUE THEN
5056: savepoint CANCEL_ACTION_SVPT;

Line 5179: l_msg_count := FND_MSG_PUB.COUNT_MSG;

5175:
5176: EXCEPTION
5177: WHEN FND_API.G_EXC_ERROR THEN
5178: x_return_status := FND_API.G_RET_STS_ERROR;
5179: l_msg_count := FND_MSG_PUB.COUNT_MSG;
5180:
5181: IF p_commit = 'T' THEN
5182: ROLLBACK to CANCEL_ACTION_SVPT;
5183: END IF;

Line 5214: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',

5210: ROLLBACK TO CANCEL_ACTION_SVPT;
5211: END IF;
5212:
5213:
5214: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
5215: p_procedure_name => 'CANCEL_ACTION',
5216: p_error_text => x_msg_data);
5217: x_msg_count := FND_MSG_PUB.count_msg;
5218: --Reset the stack

Line 5217: x_msg_count := FND_MSG_PUB.count_msg;

5213:
5214: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PUB',
5215: p_procedure_name => 'CANCEL_ACTION',
5216: p_error_text => x_msg_data);
5217: x_msg_count := FND_MSG_PUB.count_msg;
5218: --Reset the stack
5219: if l_debug_mode = 'Y' then
5220: Pa_Debug.reset_curr_function;
5221: end if;

Line 5262: FND_MSG_PUB.initialize;

5258: END IF;
5259:
5260: -- Clear the Global PL/SQL Message table.
5261: IF FND_API.TO_BOOLEAN(nvl(p_Init_Msg_List, FND_API.G_TRUE)) THEN
5262: FND_MSG_PUB.initialize;
5263: END IF;
5264:
5265: IF p_commit = FND_API.G_TRUE THEN
5266: savepoint DELETE_ISSUE_SVPT;

Line 5329: l_Msg_Count := FND_MSG_PUB.Count_Msg;

5325: WHEN FND_API.G_EXC_ERROR THEN
5326: -- Set the Return Status as Error.
5327: x_Return_Status := FND_API.g_Ret_Sts_Error;
5328: -- Get the Message Count.
5329: l_Msg_Count := FND_MSG_PUB.Count_Msg;
5330: --Roll back
5331: IF p_commit = FND_API.G_TRUE THEN
5332: ROLLBACK TO DELETE_ISSUE_SVPT;
5333: END IF;

Line 5363: FND_MSG_PUB.Add_Exc_Msg (

5359: ROLLBACK TO DELETE_ISSUE_SVPT;
5360: END IF;
5361:
5362: -- Add the message that is reported in SQL Error.
5363: FND_MSG_PUB.Add_Exc_Msg (
5364: p_Pkg_Name => 'PA_CONTROL_API_PUB',
5365: p_Procedure_Name => 'Delete_Issue',
5366: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5367: );

Line 5369: FND_MSG_PUB.Count_And_Get (

5365: p_Procedure_Name => 'Delete_Issue',
5366: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5367: );
5368:
5369: FND_MSG_PUB.Count_And_Get (
5370: p_Count => x_Msg_Count,
5371: p_Data => x_Msg_Data
5372: );
5373:

Line 5414: FND_MSG_PUB.initialize;

5410: END IF;
5411:
5412: -- Clear the Global PL/SQL Message table.
5413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
5414: FND_MSG_PUB.initialize;
5415: END IF;
5416:
5417: IF p_commit = FND_API.G_TRUE THEN
5418: savepoint DELETE_CR_SVPT;

Line 5484: l_Msg_Count := FND_MSG_PUB.Count_Msg;

5480: WHEN FND_API.G_EXC_ERROR THEN
5481: -- Set the Return Status as Error.
5482: x_Return_Status := FND_API.g_Ret_Sts_Error;
5483: -- Get the Message Count.
5484: l_Msg_Count := FND_MSG_PUB.Count_Msg;
5485:
5486: IF p_commit = FND_API.G_TRUE THEN
5487: ROLLBACK TO DELETE_CR_SVPT;
5488: END IF;

Line 5520: FND_MSG_PUB.Add_Exc_Msg (

5516: ROLLBACK TO DELETE_CR_SVPT;
5517: END IF;
5518:
5519: -- Add the message that is reported in SQL Error.
5520: FND_MSG_PUB.Add_Exc_Msg (
5521: p_Pkg_Name => 'PA_CONTROL_API_PUB',
5522: p_Procedure_Name => 'Delete_Change_Request',
5523: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5524: );

Line 5526: FND_MSG_PUB.Count_And_Get (

5522: p_Procedure_Name => 'Delete_Change_Request',
5523: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5524: );
5525:
5526: FND_MSG_PUB.Count_And_Get (
5527: p_Count => x_Msg_Count,
5528: p_Data => x_Msg_Data
5529: );
5530:

Line 5571: FND_MSG_PUB.initialize;

5567: END IF;
5568:
5569: -- Clear the Global PL/SQL Message table.
5570: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
5571: FND_MSG_PUB.initialize;
5572: END IF;
5573:
5574: IF p_commit = FND_API.G_TRUE THEN
5575: savepoint DELETE_CO_SVPT;

Line 5637: l_Msg_Count := FND_MSG_PUB.Count_Msg;

5633: WHEN FND_API.G_EXC_ERROR THEN
5634: -- Set the Return Status as Error.
5635: x_Return_Status := FND_API.g_Ret_Sts_Error;
5636: -- Get the Message Count.
5637: l_Msg_Count := FND_MSG_PUB.Count_Msg;
5638:
5639: IF p_commit = FND_API.G_TRUE THEN
5640: ROLLBACK TO DELETE_CO_SVPT;
5641: END IF;

Line 5672: FND_MSG_PUB.Add_Exc_Msg (

5668: ROLLBACK TO DELETE_CO_SVPT;
5669: END IF;
5670:
5671: -- Add the message that is reported in SQL Error.
5672: FND_MSG_PUB.Add_Exc_Msg (
5673: p_Pkg_Name => 'PA_CONTROL_API_PUB',
5674: p_Procedure_Name => 'Delete_Change_Order',
5675: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5676: );

Line 5678: FND_MSG_PUB.Count_And_Get (

5674: p_Procedure_Name => 'Delete_Change_Order',
5675: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5676: );
5677:
5678: FND_MSG_PUB.Count_And_Get (
5679: p_Count => x_Msg_Count,
5680: p_Data => x_Msg_Data
5681: );
5682:

Line 5733: FND_MSG_PUB.initialize;

5729: END IF;
5730:
5731: -- Clear the Global PL/SQL Message table.
5732: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
5733: FND_MSG_PUB.initialize;
5734: END IF;
5735:
5736: IF l_debug_mode = 'Y' THEN
5737: pa_debug.write(l_module_name, 'Start of Add_Comments', l_debug_level3);

Line 5870: l_Msg_Count := FND_MSG_PUB.Count_Msg;

5866:
5867: -- Set the Return Status as Error.
5868: x_Return_Status := FND_API.g_Ret_Sts_Error;
5869: -- Get the Message Count.
5870: l_Msg_Count := FND_MSG_PUB.Count_Msg;
5871:
5872: IF (l_Msg_Count = 1) THEN
5873: PA_INTERFACE_UTILS_PUB.Get_Messages (
5874: p_Encoded => FND_API.g_False

Line 5902: FND_MSG_PUB.Add_Exc_Msg (

5898: -- Set the Return Status as Error.
5899: x_Return_Status := FND_API.g_Ret_Sts_Unexp_Error;
5900:
5901: -- Add the message that is reported in SQL Error.
5902: FND_MSG_PUB.Add_Exc_Msg (
5903: p_Pkg_Name => 'PA_CONTROL_API_PUB',
5904: p_Procedure_Name => 'Add_Comments',
5905: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5906: );

Line 5908: FND_MSG_PUB.Count_And_Get (

5904: p_Procedure_Name => 'Add_Comments',
5905: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
5906: );
5907:
5908: FND_MSG_PUB.Count_And_Get (
5909: p_Count => x_Msg_Count,
5910: p_Data => x_Msg_Data
5911: );
5912:

Line 5967: FND_MSG_PUB.initialize;

5963: END IF;
5964:
5965: -- Clear the Global PL/SQL Message table.
5966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
5967: FND_MSG_PUB.initialize;
5968: END IF;
5969:
5970: IF l_debug_mode = 'Y' THEN
5971: pa_debug.write(l_module_name, 'Start of Add_Related_Items', l_debug_level3);

Line 6180: l_Msg_Count := FND_MSG_PUB.Count_Msg;

6176:
6177: -- Set the Return Status as Error.
6178: x_Return_Status := FND_API.g_Ret_Sts_Error;
6179: -- Get the Message Count.
6180: l_Msg_Count := FND_MSG_PUB.Count_Msg;
6181:
6182: IF (l_Msg_Count = 1) THEN
6183: PA_INTERFACE_UTILS_PUB.Get_Messages (
6184: p_Encoded => FND_API.g_False

Line 6212: FND_MSG_PUB.Add_Exc_Msg (

6208: -- Set the Return Status as Error.
6209: x_Return_Status := FND_API.g_Ret_Sts_Unexp_Error;
6210:
6211: -- Add the message that is reported in SQL Error.
6212: FND_MSG_PUB.Add_Exc_Msg (
6213: p_Pkg_Name => 'PA_CONTROL_API_PUB',
6214: p_Procedure_Name => 'Add_Related_Items',
6215: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
6216: );

Line 6218: FND_MSG_PUB.Count_And_Get (

6214: p_Procedure_Name => 'Add_Related_Items',
6215: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
6216: );
6217:
6218: FND_MSG_PUB.Count_And_Get (
6219: p_Count => x_Msg_Count,
6220: p_Data => x_Msg_Data
6221: );
6222:

Line 6273: FND_MSG_PUB.initialize;

6269: END IF;
6270:
6271: -- Clear the Global PL/SQL Message table.
6272: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
6273: FND_MSG_PUB.initialize;
6274: END IF;
6275:
6276: -- Set the SavePoint if we have been requested to Commit the Data.
6277: IF (p_Commit = FND_API.G_TRUE) THEN

Line 6462: l_Msg_Count := FND_MSG_PUB.Count_Msg;

6458: WHEN FND_API.G_EXC_ERROR THEN
6459: -- Set the Return Status as Error.
6460: x_Return_Status := FND_API.g_Ret_Sts_Error;
6461: -- Get the Message Count.
6462: l_Msg_Count := FND_MSG_PUB.Count_Msg;
6463:
6464: -- Rollback.
6465: IF (p_Commit = FND_API.G_TRUE) THEN
6466: ROLLBACK TO DELETE_RELATED_ITEMS_SVPT;

Line 6499: FND_MSG_PUB.Add_Exc_Msg (

6495: ROLLBACK TO DELETE_RELATED_ITEMS_SVPT;
6496: END IF;
6497:
6498: -- Add the message that is reported in SQL Error.
6499: FND_MSG_PUB.Add_Exc_Msg (
6500: p_Pkg_Name => 'PA_CONTROL_API_PUB',
6501: p_Procedure_Name => 'Delete_Related_Item',
6502: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
6503: );

Line 6505: FND_MSG_PUB.Count_And_Get (

6501: p_Procedure_Name => 'Delete_Related_Item',
6502: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
6503: );
6504:
6505: FND_MSG_PUB.Count_And_Get (
6506: p_Count => x_Msg_Count,
6507: p_Data => x_Msg_Data
6508: );
6509:

Line 6781: FND_MSG_PUB.initialize;

6777: PA_DEBUG.set_curr_function(p_function => 'UPDATE_ISSUE', p_debug_mode => l_debug_mode);
6778: END IF;
6779:
6780: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
6781: FND_MSG_PUB.initialize;
6782: END IF;
6783:
6784: IF p_commit = FND_API.G_TRUE THEN
6785: savepoint UPDATE_ISSUE_SVPT;

Line 7726: l_msg_count := FND_MSG_PUB.count_msg;

7722: IF l_debug_mode = 'Y' THEN
7723: pa_debug.write(l_module, 'in FND_API.G_EXC_ERROR exception', l_debug_level3);
7724: END IF;
7725: x_return_status := FND_API.G_RET_STS_ERROR;
7726: l_msg_count := FND_MSG_PUB.count_msg;
7727:
7728: IF p_commit = FND_API.G_TRUE THEN
7729: ROLLBACK TO UPDATE_ISSUE_SVPT;
7730: END IF;

Line 7763: FND_MSG_PUB.add_exc_msg

7759: IF p_commit = FND_API.G_TRUE THEN
7760: ROLLBACK TO UPDATE_ISSUE_SVPT;
7761: END IF;
7762:
7763: FND_MSG_PUB.add_exc_msg
7764: ( p_pkg_name => 'PA_CONTROL_API_PUB'
7765: , p_procedure_name => 'UPDATE_ISSUE'
7766: , p_error_text => x_msg_data);
7767:

Line 7768: x_msg_count := FND_MSG_PUB.count_msg;

7764: ( p_pkg_name => 'PA_CONTROL_API_PUB'
7765: , p_procedure_name => 'UPDATE_ISSUE'
7766: , p_error_text => x_msg_data);
7767:
7768: x_msg_count := FND_MSG_PUB.count_msg;
7769:
7770: IF l_debug_mode = 'Y' THEN
7771: PA_DEBUG.reset_curr_function;
7772: END IF;

Line 8041: FND_MSG_PUB.initialize;

8037: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CHANGE_REQUEST', p_debug_mode => l_debug_mode);
8038: END IF;
8039:
8040: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
8041: FND_MSG_PUB.initialize;
8042: END IF;
8043:
8044: IF p_commit = FND_API.G_TRUE THEN
8045: savepoint UPDATE_CR_SVPT;

Line 8983: l_msg_count := FND_MSG_PUB.count_msg;

8979: IF l_debug_mode = 'Y' THEN
8980: pa_debug.write(l_module, 'in FND_API.G_EXC_ERROR exception', l_debug_level3);
8981: END IF;
8982: x_return_status := FND_API.G_RET_STS_ERROR;
8983: l_msg_count := FND_MSG_PUB.count_msg;
8984:
8985: IF p_commit = FND_API.G_TRUE THEN
8986: ROLLBACK TO UPDATE_CR_SVPT;
8987: END IF;

Line 9020: FND_MSG_PUB.add_exc_msg

9016: IF p_commit = FND_API.G_TRUE THEN
9017: ROLLBACK TO UPDATE_CR_SVPT;
9018: END IF;
9019:
9020: FND_MSG_PUB.add_exc_msg
9021: ( p_pkg_name => 'PA_CONTROL_API_PUB'
9022: , p_procedure_name => 'UPDATE_CHANGE_REQUEST'
9023: , p_error_text => x_msg_data);
9024:

Line 9025: x_msg_count := FND_MSG_PUB.count_msg;

9021: ( p_pkg_name => 'PA_CONTROL_API_PUB'
9022: , p_procedure_name => 'UPDATE_CHANGE_REQUEST'
9023: , p_error_text => x_msg_data);
9024:
9025: x_msg_count := FND_MSG_PUB.count_msg;
9026:
9027: IF l_debug_mode = 'Y' THEN
9028: PA_DEBUG.reset_curr_function;
9029: END IF;

Line 9298: FND_MSG_PUB.initialize;

9294: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CHANGE_ORDER', p_debug_mode => l_debug_mode);
9295: END IF;
9296:
9297: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
9298: FND_MSG_PUB.initialize;
9299: END IF;
9300:
9301: IF p_commit = FND_API.G_TRUE THEN
9302: savepoint UPDATE_CO_SVPT;

Line 10242: l_msg_count := FND_MSG_PUB.count_msg;

10238: IF l_debug_mode = 'Y' THEN
10239: pa_debug.write(l_module, 'in FND_API.G_EXC_ERROR exception', l_debug_level3);
10240: END IF;
10241: x_return_status := FND_API.G_RET_STS_ERROR;
10242: l_msg_count := FND_MSG_PUB.count_msg;
10243:
10244: IF p_commit = FND_API.G_TRUE THEN
10245: ROLLBACK TO UPDATE_CO_SVPT;
10246: END IF;

Line 10279: FND_MSG_PUB.add_exc_msg

10275: IF p_commit = FND_API.G_TRUE THEN
10276: ROLLBACK TO UPDATE_CO_SVPT;
10277: END IF;
10278:
10279: FND_MSG_PUB.add_exc_msg
10280: ( p_pkg_name => 'PA_CONTROL_API_PUB'
10281: , p_procedure_name => 'UPDATE_CHANGE_ORDER'
10282: , p_error_text => x_msg_data);
10283:

Line 10284: x_msg_count := FND_MSG_PUB.count_msg;

10280: ( p_pkg_name => 'PA_CONTROL_API_PUB'
10281: , p_procedure_name => 'UPDATE_CHANGE_ORDER'
10282: , p_error_text => x_msg_data);
10283:
10284: x_msg_count := FND_MSG_PUB.count_msg;
10285:
10286: IF l_debug_mode = 'Y' THEN
10287: PA_DEBUG.reset_curr_function;
10288: END IF;