DBA Data[Home] [Help]

APPS.PA_LIFECYCLES_PUB dependencies on FND_MSG_PUB

Line 71: fnd_msg_pub.initialize;

67:
68: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE');
69:
70: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
71: fnd_msg_pub.initialize;
72: END IF;
73:
74: IF(p_debug_mode = 'Y') THEN
75: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :After initialising the stack...');

Line 137: l_msg_count := FND_MSG_PUB.count_msg;

133: IF (p_debug_mode = 'Y') THEN
134: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : checking message count');
135: END IF;
136:
137: l_msg_count := FND_MSG_PUB.count_msg;
138:
139: If l_msg_count > 0 THEN
140: x_msg_count := l_msg_count;
141: If l_msg_count = 1 THEN

Line 183: l_msg_count := FND_MSG_PUB.count_msg;

179: IF (p_debug_mode = 'Y') THEN
180: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : checking message count after call to private create API ');
181: END IF;
182:
183: l_msg_count := FND_MSG_PUB.count_msg;
184:
185: If l_msg_count > 0 THEN
186: x_msg_count := l_msg_count;
187: If l_msg_count = 1 THEN

Line 216: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

212: IF p_commit = FND_API.G_TRUE THEN
213: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
214: END IF;
215:
216: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
217: p_procedure_name => 'CREATE_LIFECYCLE',
218: p_error_text => SUBSTRB(SQLERRM,1,240));
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:

Line 232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF p_commit = FND_API.G_TRUE THEN
230: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
231: END IF;
232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
233: p_procedure_name => 'CREATE_LIFECYCLE',
234: p_error_text => SUBSTRB(SQLERRM,1,240));
235:
236:

Line 334: fnd_msg_pub.initialize;

330:
331: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE_PHASES');
332:
333: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
334: fnd_msg_pub.initialize;
335: END IF;
336:
337: IF(p_debug_mode = 'Y') THEN
338: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase :After initialising the stack...');

Line 399: l_msg_count := FND_MSG_PUB.count_msg;

395: IF (p_debug_mode = 'Y') THEN
396: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : checking message count');
397: END IF;
398:
399: l_msg_count := FND_MSG_PUB.count_msg;
400:
401: If l_msg_count > 0 THEN
402: x_msg_count := l_msg_count;
403: If l_msg_count = 1 THEN

Line 446: l_msg_count := FND_MSG_PUB.count_msg;

442: IF (p_debug_mode = 'Y') THEN
443: pa_debug.debug(' PA_LIFECYCLES_PUB.create_lifecycle_phase :: checking message count');
444: END IF;
445:
446: l_msg_count := FND_MSG_PUB.count_msg;
447:
448: If l_msg_count > 0 THEN
449: x_msg_count := l_msg_count;
450: If l_msg_count = 1 THEN

Line 479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

475: IF p_commit = FND_API.G_TRUE THEN
476: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
477: END IF;
478:
479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
480: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:

Line 495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF p_commit = FND_API.G_TRUE THEN
493: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
494: END IF;
495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
496: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
497: p_error_text => SUBSTRB(SQLERRM,1,240));
498:
499:

Line 607: fnd_msg_pub.initialize;

603:
604: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE');
605:
606: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
607: fnd_msg_pub.initialize;
608: END IF;
609:
610: IF(p_debug_mode = 'Y') THEN
611: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle :After initialising the stack...');

Line 659: l_msg_count := FND_MSG_PUB.count_msg;

655: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');
656: END IF;
657:
658:
659: l_msg_count := FND_MSG_PUB.count_msg;
660:
661: If l_msg_count > 0 THEN
662: x_msg_count := l_msg_count;
663: If l_msg_count = 1 THEN

Line 720: l_msg_count := FND_MSG_PUB.count_msg;

716: IF (p_debug_mode = 'Y') THEN
717: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');
718: END IF;
719:
720: l_msg_count := FND_MSG_PUB.count_msg;
721:
722: If l_msg_count > 0 THEN
723: x_msg_count := l_msg_count;
724: If l_msg_count = 1 THEN

Line 770: l_msg_count := FND_MSG_PUB.count_msg;

766: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');
767: END IF;
768:
769:
770: l_msg_count := FND_MSG_PUB.count_msg;
771: If l_msg_count > 0 THEN
772: x_msg_count := l_msg_count;
773: If l_msg_count = 1 THEN
774: pa_interface_utils_pub.get_messages

Line 822: l_msg_count := FND_MSG_PUB.count_msg;

818: IF (p_debug_mode = 'Y') THEN
819: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');
820: END IF;
821:
822: l_msg_count := FND_MSG_PUB.count_msg;
823:
824: If l_msg_count > 0 THEN
825: x_msg_count := l_msg_count;
826: If l_msg_count = 1 THEN

Line 854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

850: IF p_commit = FND_API.G_TRUE THEN
851: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
852: END IF;
853:
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
855: p_procedure_name => 'DELETE_LIFECYCLE',
856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:

Line 870: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF p_commit = FND_API.G_TRUE THEN
868: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
869: END IF;
870: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
871: p_procedure_name => 'DELETE_LIFECYCLE',
872: p_error_text => SUBSTRB(SQLERRM,1,240));
873:
874: END delete_lifecycle;

Line 968: fnd_msg_pub.initialize;

964:
965: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE_PHASE');
966:
967: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
968: fnd_msg_pub.initialize;
969: END IF;
970:
971: IF(p_debug_mode = 'Y') THEN
972: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase :After initialising the stack...');

Line 1033: l_msg_count := FND_MSG_PUB.count_msg;

1029: IF (p_debug_mode = 'Y') THEN
1030: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase: checking message count');
1031: END IF;
1032:
1033: l_msg_count := FND_MSG_PUB.count_msg;
1034:
1035: If l_msg_count > 0 THEN
1036: x_msg_count := l_msg_count;
1037: If l_msg_count = 1 THEN

Line 1094: l_msg_count := FND_MSG_PUB.count_msg;

1090: IF (p_debug_mode = 'Y') THEN
1091: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');
1092: END IF;
1093:
1094: l_msg_count := FND_MSG_PUB.count_msg;
1095:
1096: If l_msg_count > 0 THEN
1097: x_msg_count := l_msg_count;
1098: If l_msg_count = 1 THEN

Line 1152: l_msg_count := FND_MSG_PUB.count_msg;

1148: IF (p_debug_mode = 'Y') THEN
1149: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : checking message count');
1150: END IF;
1151:
1152: l_msg_count := FND_MSG_PUB.count_msg;
1153:
1154: If l_msg_count > 0 THEN
1155: x_msg_count := l_msg_count;
1156: If l_msg_count = 1 THEN

Line 1184: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1180: IF p_commit = FND_API.G_TRUE THEN
1181: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1182: END IF;
1183:
1184: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1185: p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
1186: p_error_text => SUBSTRB(SQLERRM,1,240));
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188:

Line 1200: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF p_commit = FND_API.G_TRUE THEN
1198: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1199: END IF;
1200: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1201: p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
1202: p_error_text => SUBSTRB(SQLERRM,1,240));
1203:
1204:

Line 1290: fnd_msg_pub.initialize;

1286:
1287: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE');
1288:
1289: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1290: fnd_msg_pub.initialize;
1291: END IF;
1292:
1293:
1294:

Line 1389: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count'||FND_MSG_PUB.count_msg);

1385: l_lifecycle_description := P_lifecycle_description;
1386: END IF;
1387:
1388: IF (p_debug_mode = 'Y') THEN
1389: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count'||FND_MSG_PUB.count_msg);
1390: END IF;
1391:
1392:
1393: IF(p_debug_mode = 'Y') THEN

Line 1471: l_msg_count := FND_MSG_PUB.count_msg;

1467: IF (p_debug_mode = 'Y') THEN
1468: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');
1469: END IF;
1470:
1471: l_msg_count := FND_MSG_PUB.count_msg;
1472:
1473: If l_msg_count > 0 THEN
1474: x_msg_count := l_msg_count;
1475: If l_msg_count = 1 THEN

Line 1522: l_msg_count := FND_MSG_PUB.count_msg;

1518: IF (p_debug_mode = 'Y') THEN
1519: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');
1520: END IF;
1521:
1522: l_msg_count := FND_MSG_PUB.count_msg;
1523:
1524: If l_msg_count > 0 THEN
1525: x_msg_count := l_msg_count;
1526: If l_msg_count = 1 THEN

Line 1555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1551: IF p_commit = FND_API.G_TRUE THEN
1552: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1553: END IF;
1554:
1555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1556: p_procedure_name => 'UPDATE_LIFECYCLE',
1557: p_error_text => SUBSTRB(SQLERRM,1,240));
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:

Line 1571: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF p_commit = FND_API.G_TRUE THEN
1569: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1570: END IF;
1571: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1572: p_procedure_name => 'UPDATE_LIFECYCLE',
1573: p_error_text => SUBSTRB(SQLERRM,1,240));
1574:
1575:

Line 1674: fnd_msg_pub.initialize;

1670:
1671: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE_PHASE');
1672:
1673: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1674: fnd_msg_pub.initialize;
1675: END IF;
1676:
1677: IF(p_debug_mode = 'Y') THEN
1678: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase :After initialising the stack..and getting the old data from database.');

Line 1798: l_msg_count := FND_MSG_PUB.count_msg;

1794: IF (p_debug_mode = 'Y') THEN
1795: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');
1796: END IF;
1797:
1798: l_msg_count := FND_MSG_PUB.count_msg;
1799:
1800: If l_msg_count > 0 THEN
1801: x_msg_count := l_msg_count;
1802: If l_msg_count = 1 THEN

Line 1835: l_msg_count := FND_MSG_PUB.count_msg;

1831: x_msg_count =>l_msg_count ,
1832: X_msg_data =>l_data
1833: );
1834:
1835: l_msg_count := FND_MSG_PUB.count_msg;
1836: IF (p_debug_mode = 'Y') THEN
1837: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');
1838: END IF;
1839: If l_msg_count > 0 THEN

Line 1890: l_msg_count := FND_MSG_PUB.count_msg;

1886: IF (p_debug_mode = 'Y') THEN
1887: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : checking message count after call to private API update_lifecycle_phase');
1888: END IF;
1889:
1890: l_msg_count := FND_MSG_PUB.count_msg;
1891:
1892: If l_msg_count > 0 THEN
1893: x_msg_count := l_msg_count;
1894: If l_msg_count = 1 THEN

Line 1922: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1918: IF p_commit = FND_API.G_TRUE THEN
1919: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1920: END IF;
1921:
1922: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1923: p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
1924: p_error_text => SUBSTRB(SQLERRM,1,240));
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926:

Line 1938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF p_commit = FND_API.G_TRUE THEN
1936: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1937: END IF;
1938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1939: p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
1940: p_error_text => SUBSTRB(SQLERRM,1,240));
1941:
1942: