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_LIFECYCLES_PVT dependencies on FND_MSG_PUB

Line 114: l_msg_count := FND_MSG_PUB.count_msg;

110: IF (p_debug_mode = 'Y') THEN
111: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle : checking message count');
112: END IF;
113:
114: l_msg_count := FND_MSG_PUB.count_msg;
115:
116:
117: If l_msg_count > 0 THEN
118: x_msg_count := l_msg_count;

Line 401: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 435: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

431: IF p_commit = FND_API.G_TRUE THEN
432: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PVT;
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
436: p_procedure_name => 'create_lifecycle',
437: p_error_text => SUBSTRB(SQLERRM,1,240));
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439:

Line 451: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

447: IF p_commit = FND_API.G_TRUE THEN
448: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PVT;
449: END IF;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
452: p_procedure_name => 'create_lifecycle',
453: p_error_text => SUBSTRB(SQLERRM,1,240));
454: raise;
455:

Line 581: l_msg_count := FND_MSG_PUB.count_msg;

577: IF (p_debug_mode = 'Y') THEN
578: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle_phase : checking message count');
579: END IF;
580:
581: l_msg_count := FND_MSG_PUB.count_msg;
582:
583: IF l_msg_count > 0 THEN
584: x_msg_count := l_msg_count;
585: IF l_msg_count = 1 THEN

Line 793: l_msg_count := FND_MSG_PUB.count_msg;

789: IF (p_debug_mode = 'Y') THEN
790: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle_phase : checking message count');
791: END IF;
792:
793: l_msg_count := FND_MSG_PUB.count_msg;
794:
795: If l_msg_count > 0 THEN
796: x_msg_count := l_msg_count;
797: If l_msg_count = 1 THEN

Line 826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

822: IF p_commit = FND_API.G_TRUE THEN
823: ROLLBACK TO LCYL_CREATE_LCYL_PHASES_PVT;
824: END IF;
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
827: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
828: p_error_text => SUBSTRB(SQLERRM,1,240));
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830:

Line 842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

838: IF p_commit = FND_API.G_TRUE THEN
839: ROLLBACK TO LCYL_CREATE_LCYL_PHASES_PVT;
840: END IF;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
843: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
844: p_error_text => SUBSTRB(SQLERRM,1,240));
845: raise;
846:

Line 1043: l_msg_count := FND_MSG_PUB.count_msg;

1039: IF (p_debug_mode = 'Y') THEN
1040: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle: checking message count');
1041: END IF;
1042:
1043: l_msg_count := FND_MSG_PUB.count_msg;
1044:
1045: IF l_msg_count > 0 THEN
1046: x_msg_count := l_msg_count;
1047: IF l_msg_count = 1 THEN

Line 1130: l_msg_count := FND_MSG_PUB.count_msg;

1126: IF (p_debug_mode = 'Y') THEN
1127: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle: checking message count');
1128: END IF;
1129:
1130: l_msg_count := FND_MSG_PUB.count_msg;
1131:
1132: If l_msg_count > 0 THEN
1133: x_msg_count := l_msg_count;
1134: If l_msg_count = 1 THEN

Line 1158: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1154: IF p_commit = FND_API.G_TRUE THEN
1155: ROLLBACK TO LCYL_DEL_PVT;
1156: END IF;
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1159: p_procedure_name => 'DELETE_LIFECYCLE',
1160: p_error_text => SUBSTRB(SQLERRM,1,240));
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162:

Line 1175: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1171: IF p_commit = FND_API.G_TRUE THEN
1172: ROLLBACK TO LCYL_DEL_PVT;
1173: END IF;
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1176: p_procedure_name => 'DELETE_LIFECYCLE',
1177: p_error_text => SUBSTRB(SQLERRM,1,240));
1178: raise;
1179:

Line 1334: l_msg_count := FND_MSG_PUB.count_msg;

1330: IF (p_debug_mode = 'Y') THEN
1331: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases: checking message count');
1332: END IF;
1333:
1334: l_msg_count := FND_MSG_PUB.count_msg;
1335:
1336: If l_msg_count > 0 THEN
1337: x_msg_count := l_msg_count;
1338: If l_msg_count = 1 THEN

Line 1414: l_msg_count := FND_MSG_PUB.count_msg;

1410: IF (p_debug_mode = 'Y') THEN
1411: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phases: checking message count');
1412: END IF;
1413:
1414: l_msg_count := FND_MSG_PUB.count_msg;
1415:
1416: IF l_msg_count > 0 THEN
1417: x_msg_count := l_msg_count;
1418: IF l_msg_count = 1 THEN

Line 1443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1439: IF p_commit = FND_API.G_TRUE THEN
1440: ROLLBACK TO LCYL_DEL_PHASE_PVT;
1441: END IF;
1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1444: p_procedure_name => 'delete_lifecycle_phase',
1445: p_error_text => SUBSTRB(SQLERRM,1,240));
1446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1447:

Line 1460: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1456: IF p_commit = FND_API.G_TRUE THEN
1457: ROLLBACK TO LCYL_DEL_PHASE_PVT;
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1461: p_procedure_name => 'delete_lifecycle_phase',
1462: p_error_text => SUBSTRB(SQLERRM,1,240));
1463: raise;
1464:

Line 1579: l_msg_count := FND_MSG_PUB.count_msg;

1575: IF (p_debug_mode = 'Y') THEN
1576: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: checking message count');
1577: END IF;
1578:
1579: l_msg_count := FND_MSG_PUB.count_msg;
1580:
1581: If l_msg_count > 0 THEN
1582: x_msg_count := l_msg_count;
1583: If l_msg_count = 1 THEN

Line 1601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1597: x_del_lifecycle_ok:=FND_API.G_TRUE;
1598:
1599: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1602: p_procedure_name => 'delete_lifecycle_phase_ok',
1603: p_error_text => SUBSTRB(SQLERRM,1,240));
1604:
1605:

Line 1611: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608:
1609: WHEN OTHERS THEN
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
1612: p_procedure_name => 'delete_lifecycle_phase_ok',
1613: p_error_text => SUBSTRB(SQLERRM,1,240));
1614: raise;
1615:

Line 1802: l_msg_count := FND_MSG_PUB.count_msg;

1798: IF (p_debug_mode = 'Y') THEN
1799: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: checking message count');
1800: END IF;
1801:
1802: l_msg_count := FND_MSG_PUB.count_msg;
1803:
1804: If l_msg_count > 0 THEN
1805: x_msg_count := l_msg_count;
1806: If l_msg_count = 1 THEN

Line 1881: l_msg_count := FND_MSG_PUB.count_msg;

1877: raise;
1878: END;
1879: END IF;
1880:
1881: l_msg_count := FND_MSG_PUB.count_msg;
1882:
1883: If l_msg_count > 0 THEN
1884: x_msg_count := l_msg_count;
1885: If l_msg_count = 1 THEN

Line 2037: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

2033: IF p_commit = FND_API.G_TRUE THEN
2034: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PVT;
2035: END IF;
2036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2037: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
2038: p_procedure_name => 'UPDATE_LIFECYCLE',
2039: p_error_text => SUBSTRB(SQLERRM,1,240));
2040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2041:

Line 2054: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

2050: IF p_commit = FND_API.G_TRUE THEN
2051: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PVT;
2052: END IF;
2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2054: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
2055: p_procedure_name => 'UPDATE_LIFECYCLE',
2056: p_error_text => SUBSTRB(SQLERRM,1,240));
2057: raise;
2058:

Line 2226: l_msg_count := FND_MSG_PUB.count_msg;

2222: IF(p_debug_mode = 'Y') THEN
2223: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking message count...');
2224: END IF;
2225:
2226: l_msg_count := FND_MSG_PUB.count_msg;
2227:
2228: If l_msg_count > 0 THEN
2229: x_msg_count := l_msg_count;
2230: If l_msg_count = 1 THEN

Line 2342: l_msg_count := FND_MSG_PUB.count_msg;

2338: IF(p_debug_mode = 'Y') THEN
2339: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking message count after Updating tables.');
2340: END IF;
2341:
2342: l_msg_count := FND_MSG_PUB.count_msg;
2343:
2344: If l_msg_count > 0 THEN
2345: x_msg_count := l_msg_count;
2346: If l_msg_count = 1 THEN

Line 2373: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT' ,

2369: IF p_commit = FND_API.G_TRUE THEN
2370: ROLLBACK TO LCYL_UPD_LCYL_PHASE_PVT;
2371: END IF;
2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2373: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT' ,
2374: p_procedure_name => 'update_lifecycle_phase' ,
2375: p_error_text => SUBSTRB(SQLERRM,1,240)
2376: );
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT' ,

2386: IF p_commit = FND_API.G_TRUE THEN
2387: ROLLBACK TO LCYL_UPD_LCYL_PHASE_PVT;
2388: END IF;
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT' ,
2391: p_procedure_name => 'update_lifecycle_phase' ,
2392: p_error_text => SUBSTRB(SQLERRM,1,240));
2393: raise;
2394:

Line 2564: l_msg_count := FND_MSG_PUB.count_msg;

2560: END if;
2561:
2562: /* Similarly it shd be done for PLM item category */
2563:
2564: l_msg_count := FND_MSG_PUB.count_msg;
2565: IF (p_debug_mode = 'Y') THEN
2566: pa_debug.debug('PA_LIFECYCLES_PVT.check_delete_lcyl_phase_ok: checking message count ');
2567: END IF;
2568:

Line 2592: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

2588: EXCEPTION
2589:
2590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2592: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
2593: p_procedure_name => 'check_delete_lcyl_phase_ok',
2594: p_error_text => SUBSTRB(SQLERRM,1,240));
2595:
2596: WHEN FND_API.G_EXC_ERROR THEN

Line 2601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',

2597: x_return_status := FND_API.G_RET_STS_ERROR;
2598:
2599: WHEN OTHERS THEN
2600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2601: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PVT',
2602: p_procedure_name => 'check_delete_lcyl_phase_ok',
2603: p_error_text => SUBSTRB(SQLERRM,1,240));
2604: raise;
2605: