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_DEBUG

Line 62: pa_debug.debug('CREATE_LIFECYCLE PVT: Inside create_lifecycle...');

58: BEGIN
59:
60:
61: IF(p_debug_mode = 'Y') THEN
62: pa_debug.debug('CREATE_LIFECYCLE PVT: Inside create_lifecycle...');
63: END IF;
64:
65: IF(p_commit = FND_API.G_TRUE) THEN
66: SAVEPOINT LCYL_CREATE_LIFECYCLE_PVT;

Line 70: pa_debug.debug('CREATE_LIFECYCLE PVT: Checking api compatibility...');

66: SAVEPOINT LCYL_CREATE_LIFECYCLE_PVT;
67: END IF;
68:
69: IF(p_debug_mode = 'Y') THEN
70: pa_debug.debug('CREATE_LIFECYCLE PVT: Checking api compatibility...');
71: END IF;
72:
73: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
74: p_api_version ,

Line 85: pa_debug.debug('CREATE_LIFECYCLE PVT: Checking for validations on parameters...');

81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: IF(p_debug_mode = 'Y') THEN
85: pa_debug.debug('CREATE_LIFECYCLE PVT: Checking for validations on parameters...');
86: END IF;
87:
88: BEGIN
89: SELECT 'N'

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 135: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining lifecycle_id...');

131: End if;
132:
133:
134: IF(p_debug_mode = 'Y') THEN
135: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining lifecycle_id...');
136: END IF;
137:
138: SELECT PA_TASKS_S.NEXTVAL
139: INTO l_lifecycle_id

Line 143: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elements...');

139: INTO l_lifecycle_id
140: FROM dual;
141:
142: IF(p_debug_mode = 'Y') THEN
143: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elements...');
144: END IF;
145:
146: PA_PROJ_ELEMENTS_PKG.Insert_Row(
147: X_ROW_ID => l_row_id ,

Line 199: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_id...');

195: X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
196: );
197:
198: IF(p_debug_mode = 'Y') THEN
199: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_id...');
200: END IF;
201:
202:
203: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL

Line 208: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_element_versions...');

204: INTO l_pev_id
205: FROM dual;
206:
207: IF(p_debug_mode = 'Y') THEN
208: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_element_versions...');
209: END IF;
210:
211: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
212: X_ROW_ID => l_row_id ,

Line 243: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_structure_id...');

239: X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
240: );
241:
242: IF(p_debug_mode = 'Y') THEN
243: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_structure_id...');
244: END IF;
245:
246: SELECT PA_PROJ_ELEM_VER_STRUCTURE_S.NEXTVAL
247: INTO l_pev_struct_id

Line 251: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elem_version_structure...');

247: INTO l_pev_struct_id
248: FROM dual;
249:
250: IF(p_debug_mode = 'Y') THEN
251: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elem_version_structure...');
252: END IF;
253:
254:
255: PA_PROJ_ELEM_VER_STRUCTURE_PKG.insert_row(

Line 286: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_structure_type_id...');

282: X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
283: );
284:
285: IF(p_debug_mode = 'Y') THEN
286: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_structure_type_id...');
287: END IF;
288:
289: SELECT PA_PROJ_STRUCTURE_TYPES_S.NEXTVAL
290: INTO l_proj_struct_type_id

Line 298: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_structure_types...');

294: FETCH cur_struc_type_id INTO l_structure_type_id;
295: CLOSE cur_struc_type_id;
296:
297: IF(p_debug_mode = 'Y') THEN
298: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_structure_types...');
299: END IF;
300:
301:
302: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

Line 327: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_LIFECYCLE_USAGES..');

323: X_ATTRIBUTE15 => NULL
324: );
325:
326: IF(p_debug_mode = 'Y') THEN
327: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_LIFECYCLE_USAGES..');
328: END IF;
329:
330: IF (p_lifecycle_project_usage_type = 'Y') THEN
331: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

Line 357: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_PROJ_ELEM_VER_SCHEDULE..');

353: );
354: END IF;
355:
356: IF(p_debug_mode = 'Y') THEN
357: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_PROJ_ELEM_VER_SCHEDULE..');
358: END IF;
359:
360: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL
361: INTO l_pev_sched_id

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 530: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Inside create_lifecycle_phase ...');

526:
527: BEGIN
528:
529: IF(p_debug_mode = 'Y') THEN
530: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Inside create_lifecycle_phase ...');
531: END IF;
532:
533: IF(p_commit = FND_API.G_TRUE) THEN
534: SAVEPOINT LCYL_CREATE_LCYL_PHASES_PVT;

Line 538: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Calling api compatilbility check...');

534: SAVEPOINT LCYL_CREATE_LCYL_PHASES_PVT;
535: END IF;
536:
537: IF(p_debug_mode = 'Y') THEN
538: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Calling api compatilbility check...');
539: END IF;
540:
541: IF NOT FND_API.COMPATIBLE_API_CALL(
542: l_api_version ,

Line 555: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Checking for valid parameters..');

551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: IF(p_debug_mode = 'Y') THEN
555: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Checking for valid parameters..');
556: END IF;
557:
558: OPEN l_get_life_elem_ver_id;
559: FETCH l_get_life_elem_ver_id INTO l_life_elem_ver_id;

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 600: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Obtaining lifecycle_phase_id...');

596: RAISE FND_API.G_EXC_ERROR;
597: END IF;
598:
599: IF(p_debug_mode = 'Y') THEN
600: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase: Obtaining lifecycle_phase_id...');
601: END IF;
602:
603: SELECT PA_TASKS_S.NEXTVAL
604: INTO l_phase_id

Line 609: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase:Inserting into pa_proj_elements...');

605: FROM dual;
606:
607:
608: if(p_debug_mode = 'Y') then
609: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase:Inserting into pa_proj_elements...');
610: end if;
611:
612: PA_PROJ_ELEMENTS_PKG.Insert_Row(
613: X_ROW_ID => l_row_id ,

Line 666: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining proj_element_version_id...');

662: );
663:
664:
665: IF(p_debug_mode = 'Y') THEN
666: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining proj_element_version_id...');
667: END IF;
668:
669:
670: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL

Line 675: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into pa_proj_element_versions...');

671: INTO l_pev_id
672: FROM dual;
673:
674: IF(p_debug_mode = 'Y') THEN
675: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into pa_proj_element_versions...');
676: END IF;
677:
678: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
679: X_ROW_ID => l_row_id ,

Line 710: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining pev_schedule_id...');

706: X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
707: );
708:
709: IF(p_debug_mode = 'Y') THEN
710: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining pev_schedule_id...');
711: END IF;
712:
713: SELECT PA_PROJ_ELEM_VER_SCHEDULE_S.NEXTVAL
714: INTO l_pev_sched_id

Line 718: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_PROJ_ELEMENT_VER_SCHEDULE...');

714: INTO l_pev_sched_id
715: FROM dual;
716:
717: IF(p_debug_mode = 'Y') THEN
718: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_PROJ_ELEMENT_VER_SCHEDULE...');
719: END IF;
720:
721:
722: PA_PROJ_ELEMENT_SCH_PKG.Insert_Row (

Line 754: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining OBJECT_RELATIONSHIP_ID...');

750: );
751:
752:
753: IF(p_debug_mode = 'Y') THEN
754: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining OBJECT_RELATIONSHIP_ID...');
755: END IF;
756:
757: SELECT pa_object_relationships_s.NEXTVAL
758: INTO l_obj_relnship_id

Line 762: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_OBJECT_RELATIONSHIPS...');

758: INTO l_obj_relnship_id
759: FROM dual;
760:
761: IF(p_debug_mode = 'Y') THEN
762: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_OBJECT_RELATIONSHIPS...');
763: END IF;
764:
765: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
766: p_user_id => FND_GLOBAL.USER_ID ,

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 939: pa_debug.debug('CREATE_LIFECYCLE_PVT: inside delete_lifecycle.....');

935:
936: Begin
937:
938: IF(p_debug_mode = 'Y') THEN
939: pa_debug.debug('CREATE_LIFECYCLE_PVT: inside delete_lifecycle.....');
940: END IF;
941:
942: IF(p_commit = FND_API.G_TRUE) THEN
943: SAVEPOINT LCYL_DEL_PVT;

Line 947: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Checking for call compatability...');

943: SAVEPOINT LCYL_DEL_PVT;
944: END IF;
945:
946: IF(p_debug_mode = 'Y') THEN
947: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Checking for call compatability...');
948: END IF;
949:
950: IF NOT FND_API.COMPATIBLE_API_CALL(
951: l_api_version ,

Line 963: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Locking on pa_proj_elements...');

959:
960: x_return_status := FND_API.G_RET_STS_SUCCESS;
961:
962: IF(p_debug_mode = 'Y') THEN
963: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Locking on pa_proj_elements...');
964: end if;
965:
966:
967: --Lock record

Line 1040: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle: checking message count');

1036: END;
1037: END IF;
1038:
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:

Line 1062: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');

1058: RAISE FND_API.G_EXC_ERROR;
1059: End if;
1060:
1061: IF (p_debug_mode = 'Y') THEN
1062: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1063: END IF;
1064:
1065: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1066:

Line 1069: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');

1065: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1066:
1067:
1068: IF (p_debug_mode = 'Y') THEN
1069: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');
1070: END IF;
1071:
1072: OPEN l_row_proj_element_versions;
1073: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id;

Line 1079: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_SCH_PKG.delete_Row');

1075:
1076: PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row(l_rowid);
1077:
1078: IF (p_debug_mode = 'Y') THEN
1079: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_SCH_PKG.delete_Row');
1080: END IF;
1081:
1082: OPEN l_row_proj_elem_ver_schedule;
1083: FETCH l_row_proj_elem_ver_schedule into l_rowid;

Line 1091: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row');

1087:
1088:
1089:
1090: IF (p_debug_mode = 'Y') THEN
1091: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row');
1092: END IF;
1093:
1094: OPEN l_row_proj_elem_ver_structure;
1095: FETCH l_row_proj_elem_ver_structure into l_rowid;

Line 1101: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row');

1097:
1098: PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row(l_rowid);
1099:
1100: IF (p_debug_mode = 'Y') THEN
1101: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row');
1102: END IF;
1103:
1104: OPEN l_row_proj_structure_types;
1105: FETCH l_row_proj_structure_types into l_rowid;

Line 1111: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_LIFECYCLE_USAGES_PKG.delete_Row');

1107:
1108: PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row(l_rowid);
1109:
1110: IF (p_debug_mode = 'Y') THEN
1111: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_LIFECYCLE_USAGES_PKG.delete_Row');
1112: END IF;
1113:
1114: OPEN l_row_lifecycle_usages;
1115: LOOP

Line 1127: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle: checking message count');

1123: -- No need to delete object relationship here. It will be deleted in phase deletion
1124:
1125:
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:

Line 1250: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phases:inside delete_lifecycle_phase..');

1246:
1247: BEGIN
1248:
1249: IF(p_debug_mode = 'Y') THEN
1250: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phases:inside delete_lifecycle_phase..');
1251: END IF;
1252:
1253:
1254: IF(p_commit = FND_API.G_TRUE) THEN

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 1331: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases: checking message count');

1327: raise;
1328: END;
1329: END IF;
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:

Line 1353: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');

1349: RAISE FND_API.G_EXC_ERROR;
1350: End if;
1351:
1352: IF (p_debug_mode = 'Y') THEN
1353: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1354: END IF;
1355:
1356:
1357: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);

Line 1360: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');

1356:
1357: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1358:
1359: IF (p_debug_mode = 'Y') THEN
1360: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');
1361: END IF;
1362:
1363: OPEN l_row_proj_element_versions;
1364: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id, l_par_element_version_id;

Line 1373: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_SCH_PKG.delete_Row');

1369:
1370:
1371:
1372: IF (p_debug_mode = 'Y') THEN
1373: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_SCH_PKG.delete_Row');
1374: END IF;
1375:
1376: OPEN l_row_proj_elem_ver_schedule;
1377: FETCH l_row_proj_elem_ver_schedule into l_rowid;

Line 1384: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_OBJECT_RELATIONSHIPS_PKG.delete_Row');

1380: PA_PROJ_ELEMENT_SCH_PKG.delete_Row(l_rowid);
1381:
1382:
1383: IF (p_debug_mode = 'Y') THEN
1384: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_OBJECT_RELATIONSHIPS_PKG.delete_Row');
1385: END IF;
1386:
1387: OPEN l_row_object_relationship;
1388: FETCH l_row_object_relationship INTO l_obj_rel_id, l_record_version_number;

Line 1411: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phases: checking message count');

1407: x_return_status => l_return_status
1408: );
1409:
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:

Line 1533: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Inside check_delete_lifecycle_ok...');

1529: From pa_proj_workplan_attr
1530: Where lifecycle_version_id = P_lifecycle_version_id);
1531: Begin
1532: IF(p_debug_mode = 'Y') THEN
1533: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Inside check_delete_lifecycle_ok...');
1534: END IF;
1535:
1536:
1537: IF NOT FND_API.COMPATIBLE_API_CALL(

Line 1550: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Checking for valid parameters..');

1546:
1547: x_return_status := FND_API.G_RET_STS_SUCCESS;
1548:
1549: IF(p_debug_mode = 'Y') THEN
1550: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Checking for valid parameters..');
1551: END IF;
1552:
1553: l_is_project :='N';
1554: OPEN l_check_project_csr;

Line 1559: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Checking for assigned to workplan..');

1555: FETCH l_check_project_csr INTO l_is_project;
1556: CLOSE l_check_project_csr;
1557:
1558: IF(p_debug_mode = 'Y') THEN
1559: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: Checking for assigned to workplan..');
1560: END IF;
1561:
1562: IF(l_is_project= 'Y') THEN
1563: l_is_project :='N';

Line 1576: pa_debug.debug('CREATE_LIFECYCLE_PVT.check_delete_lifecycle_ok: checking message count');

1572: END IF;
1573: END IF;
1574:
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:

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 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 2436: pa_debug.debug('PA_LIFECYCLE PVT.check_delete_lcyl_phase_ok: Checking api compatibility...');

2432: l_child_elem_ver_id number;
2433: BEGIN
2434:
2435: IF(p_debug_mode = 'Y') THEN
2436: pa_debug.debug('PA_LIFECYCLE PVT.check_delete_lcyl_phase_ok: Checking api compatibility...');
2437: END IF;
2438:
2439: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2440: p_api_version,

Line 2504: pa_debug.debug('PA_LIFECYCLE PVT.check_delete_lcyl_phase_ok: After checking for usuage type checking for top task assigned');

2500: then we cannot allow update of sequence number and phase code
2501: */
2502:
2503: IF(p_debug_mode = 'Y') THEN
2504: pa_debug.debug('PA_LIFECYCLE PVT.check_delete_lcyl_phase_ok: After checking for usuage type checking for top task assigned');
2505: END IF;
2506:
2507: IF(l_project_usage_exists = 'Y') then
2508: begin

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;