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 PA_LIFECYCLES_PVT

Line 1: PACKAGE BODY PA_LIFECYCLES_PVT AS

1: PACKAGE BODY PA_LIFECYCLES_PVT AS
2: /* $Header: PALCDFVB.pls 120.1 2005/08/19 16:35:32 mwasowic noship $ */
3:
4: /*-----------------------------------------------------------+
5: | For Details/Comments Refer Package Specification Comments |

Line 111: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle : checking message count');

107: x_return_status := FND_API.G_RET_STS_ERROR;
108: END IF;
109:
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:

Line 398: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle : checking message count');

394:
395: -- No need to populate pa_object relationship at thi stage, it will be populated at the time of phase creation
396:
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:

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 578: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle_phase : checking message count');

574: x_return_status := FND_API.G_RET_STS_ERROR;
575: END IF;
576:
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:

Line 790: pa_debug.debug('PA_LIFECYCLES_PVT.create_lifecycle_phase : checking message count');

786: x_return_status => l_return_status
787: );
788:
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:

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 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 1272: pa_debug.debug('PA_LIFECYCLES_PVT.delete_lifecycle_phase:Locking record for pa_proj_elements...');

1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270:
1271: if(p_debug_mode = 'Y') then
1272: pa_debug.debug('PA_LIFECYCLES_PVT.delete_lifecycle_phase:Locking record for pa_proj_elements...');
1273: end if;
1274:
1275: --Lock record
1276: IF (p_validate_only <> FND_API.G_TRUE) 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 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 1708: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Inside update_lifecycle...');

1704:
1705: BEGIN
1706:
1707: IF(p_debug_mode = 'Y') THEN
1708: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Inside update_lifecycle...');
1709: END IF;
1710:
1711: IF(p_commit = FND_API.G_TRUE) THEN
1712: SAVEPOINT LCYL_UPDATE_LIFECYCLE_PVT;

Line 1716: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking api compatibility...');

1712: SAVEPOINT LCYL_UPDATE_LIFECYCLE_PVT;
1713: END IF;
1714:
1715: IF(p_debug_mode = 'Y') THEN
1716: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking api compatibility...');
1717: END IF;
1718:
1719: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1720: p_api_version,

Line 1755: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for used by workplan structure or not..');

1751: l_prod_usg_exists := 'Y';
1752: END IF;
1753:
1754: IF(p_debug_mode = 'Y') THEN
1755: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for used by workplan structure or not..');
1756: END IF;
1757:
1758: IF l_proj_usg_exists = 'Y' THEN
1759: BEGIN

Line 1799: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: checking message count');

1795: END;
1796: END IF;
1797:
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:

Line 1820: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: After checking message count and applying locking ');

1816: RAISE FND_API.G_EXC_ERROR;
1817: End if;
1818:
1819: IF (p_debug_mode = 'Y') THEN
1820: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: After checking message count and applying locking ');
1821: END IF;
1822:
1823: IF (p_validate_only <> FND_API.G_TRUE) THEN
1824: BEGIN

Line 1899: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into pa_proj_elements...');

1895: RAISE FND_API.G_EXC_ERROR;
1896: End if;
1897:
1898: IF(p_debug_mode = 'Y') THEN
1899: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into pa_proj_elements...');
1900: END IF;
1901:
1902:
1903:

Line 1960: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_PROJ_ELEM_VER_STRUCTURE...');

1956: FETCH l_row_proj_elem_ver_structure into l_rowid,l_pev_id,l_elem_vers_id,l_record_version_number;
1957: CLOSE l_row_proj_elem_ver_structure;
1958:
1959: IF(p_debug_mode = 'Y') THEN
1960: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_PROJ_ELEM_VER_STRUCTURE...');
1961: END IF;
1962:
1963: PA_PROJ_ELEM_VER_STRUCTURE_PKG.UPDATE_ROW (
1964: X_ROWID =>l_rowid ,

Line 1995: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_LIFECYCLE_USAGES...');

1991:
1992:
1993:
1994: IF(p_debug_mode = 'Y') THEN
1995: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_LIFECYCLE_USAGES...');
1996: END IF;
1997:
1998: IF (l_proj_usg_exists = 'N' AND P_lifecycle_project_usage_type = 'Y') THEN
1999: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

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 2132: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Inside update_lifecycle_phase...');

2128:
2129: BEGIN
2130:
2131: IF(p_debug_mode = 'Y') THEN
2132: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Inside update_lifecycle_phase...');
2133: END IF;
2134:
2135: IF(p_debug_mode = 'Y') THEN
2136: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking api compatibility...');

Line 2136: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking api compatibility...');

2132: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Inside update_lifecycle_phase...');
2133: END IF;
2134:
2135: IF(p_debug_mode = 'Y') THEN
2136: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking api compatibility...');
2137: END IF;
2138:
2139: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2140: p_api_version,

Line 2159: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Locking record ..');

2155:
2156: --Lock record
2157:
2158: IF(p_debug_mode = 'Y') THEN
2159: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Locking record ..');
2160: END IF;
2161:
2162: IF (p_validate_only <> FND_API.G_TRUE) THEN
2163: BEGIN

Line 2223: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking message count...');

2219: END;
2220: END IF;
2221:
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:

Line 2244: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENTS...');

2240: RAISE FND_API.G_EXC_ERROR;
2241: End if;
2242:
2243: IF(p_debug_mode = 'Y') THEN
2244: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENTS...');
2245: END IF;
2246:
2247: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(
2248: X_ROW_ID => l_rowid ,

Line 2303: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENT_VERSIONS...');

2299: FETCH l_row_proj_elem_vers into l_rowid, l_elem_vers_id,l_parent_elem_vers_id,l_record_version_number ;
2300: CLOSE l_row_proj_elem_vers;
2301:
2302: IF(p_debug_mode = 'Y') THEN
2303: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENT_VERSIONS...');
2304: END IF;
2305:
2306: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row(
2307: X_ROW_ID => l_rowid ,

Line 2339: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Checking message count after Updating tables.');

2335: end if;
2336:
2337:
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:

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 2566: pa_debug.debug('PA_LIFECYCLES_PVT.check_delete_lcyl_phase_ok: checking message count ');

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:
2569: IF l_msg_count > 0 THEN
2570: x_msg_count := l_msg_count;

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:

Line 2610: END PA_LIFECYCLES_PVT;

2606:
2607: END check_delete_lcyl_phase_ok;
2608:
2609:
2610: END PA_LIFECYCLES_PVT;