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_PUB dependencies on PA_DEBUG

Line 44: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Entered create_lifecycle...');

40:
41: BEGIN
42:
43: IF(p_debug_mode = 'Y') then
44: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Entered create_lifecycle...');
45: END IF;
46:
47: IF (p_commit = FND_API.G_TRUE) then
48: SAVEPOINT LCYL_CREATE_LIFECYCLE_PUB;

Line 65: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Initialising message stack...');

61:
62: -- Initialise message stack
63:
64: IF( p_debug_mode = 'Y') THEN
65: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Initialising message stack...');
66: END IF;
67:
68: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE');
69:

Line 68: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE');

64: IF( p_debug_mode = 'Y') THEN
65: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Initialising message stack...');
66: END IF;
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;

Line 75: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :After initialising the stack...');

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...');
76: END IF;
77:
78: IF(p_debug_mode = 'Y') THEN
79: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :Checking for checkboxes...');

Line 79: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :Checking for checkboxes...');

75: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :After initialising the stack...');
76: END IF;
77:
78: IF(p_debug_mode = 'Y') THEN
79: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :Checking for checkboxes...');
80: END IF;
81:
82: IF (P_lifecycle_name is NULL)
83: THEN

Line 114: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :Checking for validity of required parameters...');

110: l_lifecycle_product_usage_type := P_lifecycle_product_usage_type;
111: END IF;
112:
113: IF(p_debug_mode = 'Y') THEN
114: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle :Checking for validity of required parameters...');
115: END IF;
116:
117:
118: IF (nvl(l_lifecycle_project_usage_type,'N') = 'N' AND

Line 134: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : checking message count');

130: l_lifecycle_description := P_lifecycle_description;
131: END IF;
132:
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:

Line 157: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Before call to private create API');

153: End if;
154:
155:
156: IF(p_debug_mode = 'Y') THEN
157: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Before call to private create API');
158: END IF;
159:
160: pa_lifecycles_pvt.create_lifecycle (
161: P_api_version => P_api_version ,

Line 180: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : checking message count after call to private create API ');

176: X_msg_data => l_msg_data
177: );
178:
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:

Line 308: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase :Entered create_lifecycle_phase...');

304: /* This procedure does not take care of uniqueness of phase sequence. This is responsibility of
305: calling environment */
306:
307: IF(p_debug_mode = 'Y') THEN
308: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase :Entered create_lifecycle_phase...');
309: END IF;
310:
311: IF (p_commit = FND_API.G_TRUE) THEN
312: SAVEPOINT CREATE_LCYL_PHASES_PUB;

Line 328: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : Initialising message stack...');

324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326:
327: IF( p_debug_mode = 'Y') THEN
328: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : Initialising message stack...');
329: END IF;
330:
331: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE_PHASES');
332:

Line 331: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE_PHASES');

327: IF( p_debug_mode = 'Y') THEN
328: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : Initialising message stack...');
329: END IF;
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;

Line 338: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase :After initialising the stack...');

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...');
339: END IF;
340:
341: IF (P_phase_name is NULL )
342: THEN

Line 396: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : checking message count');

392: l_phase_description := P_phase_description;
393: END IF;
394:
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:

Line 419: pa_debug.debug('CREATE_LIFECYCLE_PHASES PUB: Before call to private API');

415:
416:
417:
418: IF(p_debug_mode = 'Y') THEN
419: pa_debug.debug('CREATE_LIFECYCLE_PHASES PUB: Before call to private API');
420: END IF;
421:
422: pa_lifecycles_pvt.create_lifecycle_phase (
423: P_api_version => P_api_version

Line 443: pa_debug.debug(' PA_LIFECYCLES_PUB.create_lifecycle_phase :: checking message count');

439: ,X_msg_data => l_msg_data
440: );
441:
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:

Line 580: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Entered delete_lifecycle...');

576:
577: BEGIN
578:
579: IF(p_debug_mode = 'Y') then
580: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Entered delete_lifecycle...');
581: END IF;
582:
583: IF (p_commit = FND_API.G_TRUE) then
584: SAVEPOINT LCYL_DELETE_LIFECYCLE_PUB;

Line 601: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Initialising message stack...');

597:
598: -- Initialise message stack
599:
600: IF( p_debug_mode = 'Y') THEN
601: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Initialising message stack...');
602: END IF;
603:
604: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE');
605:

Line 604: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE');

600: IF( p_debug_mode = 'Y') THEN
601: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Initialising message stack...');
602: END IF;
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;

Line 611: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle :After initialising the stack...');

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...');
612: END IF;
613:
614: -- dbms_output.put_line('After initializing the stack');
615:

Line 655: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

651: l_product_usage_exists := 'N';
652: END;
653:
654: IF (p_debug_mode = 'Y') THEN
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;

Line 681: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_phase_ok');

677: FETCH l_get_life_elem_ver_id INTO l_life_elem_ver_id;
678: CLOSE l_get_life_elem_ver_id;
679:
680: IF(p_debug_mode = 'Y') THEN
681: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_phase_ok');
682: END IF;
683:
684:
685: IF(l_project_usage_exists = 'Y') then

Line 717: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

713: END IF;
714:
715:
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:

Line 742: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');

738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: IF (p_debug_mode = 'Y') THEN
742: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');
743: END IF;
744:
745: FOR r IN l_phases_csr LOOP
746: pa_lifecycles_pub.delete_lifecycle_phase(

Line 766: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

762:
763: END LOOP;
764:
765: IF (p_debug_mode = 'Y') THEN
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;

Line 800: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API delete_lifecycle');

796: x_msg_count => l_msg_count ,
797: x_msg_data => l_msg_data);
798: END IF;
799: IF(p_debug_mode = 'Y') THEN
800: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API delete_lifecycle');
801: END IF;
802:
803: pa_lifecycles_pvt.delete_lifecycle(
804: P_api_version => P_api_version,

Line 819: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

815: X_msg_data => l_msg_data
816: );
817:
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:

Line 941: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Entered delete_lifecycle_phase...');

937:
938: BEGIN
939:
940: IF(p_debug_mode = 'Y') then
941: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Entered delete_lifecycle_phase...');
942: END IF;
943:
944: IF (p_commit = FND_API.G_TRUE) then
945: SAVEPOINT LCYL_DELETE_LCYL_PHASE_PUB;

Line 962: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Initialising message stack...');

958:
959: -- Initialise message stack
960:
961: IF( p_debug_mode = 'Y') THEN
962: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Initialising message stack...');
963: END IF;
964:
965: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE_PHASE');
966:

Line 965: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE_PHASE');

961: IF( p_debug_mode = 'Y') THEN
962: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Initialising message stack...');
963: END IF;
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;

Line 972: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase :After initialising the stack...');

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...');
973: END IF;
974:
975: -- dbms_output.put_line('After initializing the stack');
976:

Line 1030: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase: checking message count');

1026: l_product_usage_exists := 'N';
1027: END;
1028:
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:

Line 1053: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_lcyl_phase_ok');

1049:
1050: IF(l_project_usage_exists = 'Y') then
1051:
1052: IF(p_debug_mode = 'Y') THEN
1053: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_lcyl_phase_ok');
1054: END IF;
1055:
1056: pa_lifecycles_pvt.check_delete_lcyl_phase_ok(
1057: P_api_version => P_api_version ,

Line 1074: pa_debug.debug('PA_EGO_WRAPPER_PUB.check_delete_phase_ok : Before call to private API check_delete_lcyl_phase_ok');

1070:
1071: IF(l_product_usage_exists = 'Y') then
1072:
1073: IF(p_debug_mode = 'Y') THEN
1074: pa_debug.debug('PA_EGO_WRAPPER_PUB.check_delete_phase_ok : Before call to private API check_delete_lcyl_phase_ok');
1075: END IF;
1076:
1077: PA_EGO_WRAPPER_PUB.check_delete_phase_ok (
1078: p_api_version => P_api_version ,

Line 1091: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

1087:
1088: END IF;
1089:
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:

Line 1129: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');

1125: x_msg_data => l_msg_data);
1126: END IF;
1127:
1128: IF (p_debug_mode = 'Y') THEN
1129: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');
1130: END IF;
1131:
1132:
1133: pa_lifecycles_pvt.delete_lifecycle_phase(

Line 1149: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : checking message count');

1145: X_msg_data => l_msg_data
1146: );
1147:
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:

Line 1257: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Entered update_lifecycle...');

1253:
1254: BEGIN
1255:
1256: IF(p_debug_mode = 'Y') THEN
1257: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Entered update_lifecycle...');
1258: END IF;
1259:
1260: IF (p_commit = FND_API.G_TRUE) then
1261: SAVEPOINT LCYL_UPDATE_LIFECYCLE_PUB;

Line 1265: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Checking api compatibility...');

1261: SAVEPOINT LCYL_UPDATE_LIFECYCLE_PUB;
1262: END IF;
1263:
1264: IF(p_debug_mode = 'Y') THEN
1265: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Checking api compatibility...');
1266: END IF;
1267:
1268: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
1269: p_api_version ,

Line 1284: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Initialising message stack...');

1280:
1281: -- Initialise message stack
1282:
1283: IF( p_debug_mode = 'Y') THEN
1284: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Initialising message stack...');
1285: END IF;
1286:
1287: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE');
1288:

Line 1287: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE');

1283: IF( p_debug_mode = 'Y') THEN
1284: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Initialising message stack...');
1285: END IF;
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;

Line 1296: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After initialising the stack..getting the data from database.');

1292:
1293:
1294:
1295: IF(p_debug_mode = 'Y') THEN
1296: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After initialising the stack..getting the data from database.');
1297: END IF;
1298:
1299:
1300:

Line 1317: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:Checking for null values assigning the updated values');

1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: END;
1315:
1316: IF(p_debug_mode = 'Y') THEN
1317: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:Checking for null values assigning the updated values');
1318: END IF;
1319:
1320: -- Explicit NUlling of name not allowed
1321: IF (P_lifecycle_name is NULL)

Line 1323: pa_debug.debug('Lifecycle name is NULL....');

1319:
1320: -- Explicit NUlling of name not allowed
1321: IF (P_lifecycle_name is NULL)
1322: THEN
1323: pa_debug.debug('Lifecycle name is NULL....');
1324: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1325: p_msg_name => 'PA_LCYL_NAME_REQUIRED');
1326: x_msg_data := 'PA_LCYL_NAME_REQUIRED';
1327: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1338: pa_debug.debug('Lifecycle short name is NULL....');

1334:
1335:
1336: IF (P_lifecycle_short_name is NULL)
1337: THEN
1338: pa_debug.debug('Lifecycle short name is NULL....');
1339: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1340: p_msg_name => 'PA_LCYL_SHORT_NAME_REQUIRED');
1341: x_msg_data := 'PA_LCYL_SHORT_NAME_REQUIRED';
1342: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1346: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for existing parameters for uniqueness..');

1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: ELSIF (P_lifecycle_short_name <> G_MISS_CHAR)
1344: THEN
1345: IF(p_debug_mode = 'Y') THEN
1346: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for existing parameters for uniqueness..');
1347: END IF;
1348:
1349: IF l_short_name <> P_lifecycle_short_name THEN
1350: BEGIN

Line 1364: pa_debug.debug('The short name is in use...');

1360: l_shname_uniq := 'Y';
1361: END;
1362:
1363: IF(l_shname_uniq <> 'Y') THEN
1364: pa_debug.debug('The short name is in use...');
1365: PA_UTILS.ADD_MESSAGE(
1366: p_app_short_name => 'PA',
1367: p_msg_name => 'PA_LCYL_SHORT_NAME_EXISTS');
1368: x_msg_data := 'PA_LCYL_SHORT_NAME_EXISTS';

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 1394: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Before call to private API');

1390: END IF;
1391:
1392:
1393: IF(p_debug_mode = 'Y') THEN
1394: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Before call to private API');
1395: END IF;
1396:
1397:
1398:

Line 1464: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After checking for null values assigning the updated values');

1460: END IF;
1461: */
1462:
1463: IF(p_debug_mode = 'Y') THEN
1464: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After checking for null values assigning the updated values');
1465: END IF;
1466:
1467: IF (p_debug_mode = 'Y') THEN
1468: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

Line 1468: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

1464: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After checking for null values assigning the updated values');
1465: END IF;
1466:
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:

Line 1490: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Before call to private update API');

1486: End if;
1487:
1488:
1489: IF(p_debug_mode = 'Y') THEN
1490: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Before call to private update API');
1491: END IF;
1492:
1493: pa_lifecycles_pvt.update_lifecycle (
1494: P_api_version => P_api_version ,

Line 1515: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count After call to private update API');

1511: );
1512:
1513:
1514: IF (p_debug_mode = 'Y') THEN
1515: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count After call to private update API');
1516: END IF;
1517:
1518: IF (p_debug_mode = 'Y') THEN
1519: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

Line 1519: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

1515: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count After call to private update API');
1516: END IF;
1517:
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:

Line 1642: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Entered update_lifecycle_phase...');

1638: /* Note that check for duplicate shortname and sequence can not be done here. as user may want to update
1639: two records at the same time, swapping the values */
1640:
1641: IF(p_debug_mode = 'Y') then
1642: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Entered update_lifecycle_phase...');
1643: END IF;
1644:
1645: IF (p_commit = FND_API.G_TRUE) then
1646: SAVEPOINT LCYL_UPD_LC_PHASE_PUB;

Line 1650: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle_phases: Checking api compatibility...');

1646: SAVEPOINT LCYL_UPD_LC_PHASE_PUB;
1647: END IF;
1648:
1649: IF(p_debug_mode = 'Y') THEN
1650: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle_phases: Checking api compatibility...');
1651: END IF;
1652:
1653: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
1654: p_api_version ,

Line 1668: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Initialising message stack...');

1664:
1665: -- Initialise message stack
1666:
1667: IF( p_debug_mode = 'Y') THEN
1668: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Initialising message stack...');
1669: END IF;
1670:
1671: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE_PHASE');
1672:

Line 1671: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE_PHASE');

1667: IF( p_debug_mode = 'Y') THEN
1668: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Initialising message stack...');
1669: END IF;
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;

Line 1678: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase :After initialising the stack..and getting the old data from database.');

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.');
1679: END IF;
1680:
1681: BEGIN
1682: select prj.name,prj.element_number,prj.description,prj.phase_code,elem.display_sequence

Line 1704: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:Checking for null values assigning the updated values');

1700: END;
1701:
1702:
1703: IF(p_debug_mode = 'Y') THEN
1704: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:Checking for null values assigning the updated values');
1705: END IF;
1706:
1707: -- Explicit NULLing not allowed
1708: IF (P_phase_name is NULL)

Line 1782: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:After checking for null values assigning the updated values');

1778: l_phase_description := P_phase_description;
1779: END IF;
1780:
1781: IF(p_debug_mode = 'Y') THEN
1782: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:After checking for null values assigning the updated values');
1783: END IF;
1784:
1785: /* The below code could be used to dod not hit the data if nothing is changed
1786: IF (NOT (l_data_changed)) THEN

Line 1795: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');

1791: END IF;
1792: */
1793:
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:

Line 1819: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: Calling private api check_delete_lcyl_phase_ok');

1815: IF ((P_phase_display_sequence <> G_MISS_NUM AND l_seqn <> l_org_seq)
1816: OR (P_phase_status_name <> G_MISS_CHAR AND l_phase_code <> l_org_phase_code))
1817: THEN
1818: IF (p_debug_mode = 'Y') THEN
1819: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: Calling private api check_delete_lcyl_phase_ok');
1820: END IF;
1821:
1822: pa_lifecycles_pvt.check_delete_lcyl_phase_ok(
1823: P_api_version =>l_api_version ,

Line 1837: pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');

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
1840: x_msg_count := l_msg_count;
1841: If l_msg_count = 1 THEN

Line 1862: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Before call to private API update_lifecycle_phase');

1858: END IF;
1859:
1860:
1861: IF(p_debug_mode = 'Y') THEN
1862: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Before call to private API update_lifecycle_phase');
1863: END IF;
1864:
1865: pa_lifecycles_pvt.update_lifecycle_phase (
1866: P_api_version =>1.0 ,

Line 1887: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : checking message count after call to private API update_lifecycle_phase');

1883: X_msg_data =>l_data
1884: );
1885:
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: