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

Line 153: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

149: BEGIN
150:
151: x_msg_count := 0;
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
154:
155: IF l_debug_mode = 'Y' THEN
156: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',
157: p_debug_mode => l_debug_mode );

Line 156: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',

152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
154:
155: IF l_debug_mode = 'Y' THEN
156: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',
157: p_debug_mode => l_debug_mode );
158: END IF;
159:
160: IF (p_commit = FND_API.G_TRUE) THEN

Line 181: Pa_Debug.WRITE(g_module_name,' l_dlvr_prg_flag ' || l_dlvr_prg_flag, l_debug_level3);

177: ,x_dlvr_default_status_code => l_dlvr_dflt_status
178: );
179:
180: IF l_debug_mode = 'Y' THEN
181: Pa_Debug.WRITE(g_module_name,' l_dlvr_prg_flag ' || l_dlvr_prg_flag, l_debug_level3);
182: END IF;
183:
184: -- 3570283
185: -- added one if contion l_dlvr_prg_flag = 'Y'

Line 197: Pa_Debug.WRITE(g_module_name,' l_prog_rollup_method ' || l_prog_rollup_method, l_debug_level3);

193: p_task_id => p_task_id
194: );
195:
196: IF l_debug_mode = 'Y' THEN
197: Pa_Debug.WRITE(g_module_name,' l_prog_rollup_method ' || l_prog_rollup_method, l_debug_level3);
198: END IF;
199:
200: IF l_prog_rollup_method = g_deliverable_based THEN
201: IF p_progress_weight IS NULL THEN

Line 211: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Insert_Row Called ',

207:
208: END IF;
209:
210: IF l_debug_mode = 'Y' THEN
211: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Insert_Row Called ',
212: l_debug_level3);
213: END IF;
214:
215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 293: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Insert_Row Element ['||p_dlvr_number||']['||p_dlvr_number||']',

289:
290: p_dlvr_item_id := l_proj_element_id;
291:
292: IF l_debug_mode = 'Y' THEN
293: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Insert_Row Element ['||p_dlvr_number||']['||p_dlvr_number||']',
294: l_debug_level3);
295: END IF;
296:
297: IF l_debug_mode = 'Y' THEN

Line 298: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Called ',

294: l_debug_level3);
295: END IF;
296:
297: IF l_debug_mode = 'Y' THEN
298: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Called ',
299: l_debug_level3);
300: END IF;
301:
302: -- call insert_row of pa_proj_element_versions package

Line 339: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Element['||l_dlvr_version_id||']',

335: ,X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
336: );
337:
338: IF l_debug_mode = 'Y' THEN
339: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Element['||l_dlvr_version_id||']',
340: l_debug_level3);
341: END IF;
342:
343: IF l_debug_mode = 'Y' THEN

Line 344: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_SCH_PKG.Insert_Row Called ',

340: l_debug_level3);
341: END IF;
342:
343: IF l_debug_mode = 'Y' THEN
344: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_SCH_PKG.Insert_Row Called ',
345: l_debug_level3);
346: END IF;
347:
348: -- call insert_row of pa_proj_element_sch package

Line 398: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_SCH_PKG.Insert_Row schedule ['||l_new_pev_schedule_id||']',

394: ,X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
395: );
396:
397: IF l_debug_mode = 'Y' THEN
398: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_SCH_PKG.Insert_Row schedule ['||l_new_pev_schedule_id||']',
399: l_debug_level3);
400: END IF;
401:
402: IF l_debug_mode = 'Y' THEN

Line 403: Pa_Debug.WRITE(g_module_name,' PA_OBJECT_RELATIONSHIPS_PKG.Insert_Row Called Structure-To-Deliverable',

399: l_debug_level3);
400: END IF;
401:
402: IF l_debug_mode = 'Y' THEN
403: Pa_Debug.WRITE(g_module_name,' PA_OBJECT_RELATIONSHIPS_PKG.Insert_Row Called Structure-To-Deliverable',
404: l_debug_level3);
405: END IF;
406:
407: -- call insert_row of pa_object_relationships package

Line 440: Pa_Debug.WRITE(g_module_name,' Out of PA_OBJECT_RELATIONSHIPS_PKG.Insert_Row Structure-To-Deliverable str vers ['

436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438:
439: IF l_debug_mode = 'Y' THEN
440: Pa_Debug.WRITE(g_module_name,' Out of PA_OBJECT_RELATIONSHIPS_PKG.Insert_Row Structure-To-Deliverable str vers ['
441: ||p_parent_struct_ver_id||']str ['||p_parent_struct_ver_id||']' , l_debug_level3);
442: END IF;
443:
444: IF (P_TASK_ID IS NOT NULL ) THEN

Line 447: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_PVT.CREATE_DLV_TASK_ASSOCIATION Called Task-To-Deliverable',

443:
444: IF (P_TASK_ID IS NOT NULL ) THEN
445:
446: IF l_debug_mode = 'Y' THEN
447: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_PVT.CREATE_DLV_TASK_ASSOCIATION Called Task-To-Deliverable',
448: l_debug_level3);
449: END IF;
450:
451: -- if task_id is not null , i.e. create_deliverable is called from task page

Line 495: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_PVT.CREATE_DLV_TASK_ASSOCIATION Task-To-Dlvr['||x_return_status||']',

491: );
492:
493:
494: IF l_debug_mode = 'Y' THEN
495: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_PVT.CREATE_DLV_TASK_ASSOCIATION Task-To-Dlvr['||x_return_status||']',
496: l_debug_level3);
497: END IF;
498:
499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 506: Pa_Debug.WRITE(g_module_name,' PA_ACTIONS_PUB.COPY_ACTIONS Called ',

502:
503: END IF;
504:
505: IF l_debug_mode = 'Y' THEN
506: Pa_Debug.WRITE(g_module_name,' PA_ACTIONS_PUB.COPY_ACTIONS Called ',
507: l_debug_level3);
508: END IF;
509:
510: IF (p_calling_module <> 'AMG') THEN

Line 535: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ['||x_return_status||']', l_debug_level3);

531: ) ;
532:
533:
534: IF l_debug_mode = 'Y' THEN
535: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ['||x_return_status||']', l_debug_level3);
536: END IF;
537:
538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
539: RAISE FND_API.G_EXC_ERROR;

Line 544: pa_debug.reset_curr_function;

540: END IF;
541: END IF; --p_calling_module <> 'AMG'
542:
543: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
544: pa_debug.reset_curr_function;
545: END IF ;
546:
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548:

Line 574: Pa_Debug.reset_curr_function;

570: ELSE
571: x_msg_count := l_msg_count;
572: END IF;
573: IF l_debug_mode = 'Y' THEN
574: Pa_Debug.reset_curr_function;
575: END IF;
576:
577: WHEN OTHERS THEN
578:

Line 593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

589: , p_procedure_name => 'Create_Deliverable'
590: , p_error_text => x_msg_data);
591:
592: IF l_debug_mode = 'Y' THEN
593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
594: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
595: l_debug_level5);
596: Pa_Debug.reset_curr_function;
597: END IF;

Line 594: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

590: , p_error_text => x_msg_data);
591:
592: IF l_debug_mode = 'Y' THEN
593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
594: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
595: l_debug_level5);
596: Pa_Debug.reset_curr_function;
597: END IF;
598: RAISE;

Line 596: Pa_Debug.reset_curr_function;

592: IF l_debug_mode = 'Y' THEN
593: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
594: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
595: l_debug_level5);
596: Pa_Debug.reset_curr_function;
597: END IF;
598: RAISE;
599:
600: END Create_Deliverable;

Line 857: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

853:
854: BEGIN
855: x_msg_count := 0;
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
858:
859: IF l_debug_mode = 'Y' THEN
860: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',
861: p_debug_mode => l_debug_mode );

Line 860: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',

856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
858:
859: IF l_debug_mode = 'Y' THEN
860: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',
861: p_debug_mode => l_debug_mode );
862: END IF;
863:
864: IF (p_commit = FND_API.G_TRUE) THEN

Line 869: Pa_Debug.WRITE(g_module_name,' Printing Input Params in UPDATE_DELIVERABLE : PADLVPVB.pls ####()',

865: savepoint UPDATE_DLVR_PVT;
866: END IF;
867:
868: IF l_debug_mode = 'Y' THEN
869: Pa_Debug.WRITE(g_module_name,' Printing Input Params in UPDATE_DELIVERABLE : PADLVPVB.pls ####()',
870: l_debug_level3);
871: Pa_Debug.WRITE(g_module_name,' ####() p_project_id is '||p_project_id,
872: l_debug_level3);
873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,

Line 871: Pa_Debug.WRITE(g_module_name,' ####() p_project_id is '||p_project_id,

867:
868: IF l_debug_mode = 'Y' THEN
869: Pa_Debug.WRITE(g_module_name,' Printing Input Params in UPDATE_DELIVERABLE : PADLVPVB.pls ####()',
870: l_debug_level3);
871: Pa_Debug.WRITE(g_module_name,' ####() p_project_id is '||p_project_id,
872: l_debug_level3);
873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,
874: l_debug_level3);
875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,

Line 873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,

869: Pa_Debug.WRITE(g_module_name,' Printing Input Params in UPDATE_DELIVERABLE : PADLVPVB.pls ####()',
870: l_debug_level3);
871: Pa_Debug.WRITE(g_module_name,' ####() p_project_id is '||p_project_id,
872: l_debug_level3);
873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,
874: l_debug_level3);
875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,
876: l_debug_level3);
877: Pa_Debug.WRITE(g_module_name,' ####() p_status_code' || p_status_code,

Line 875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,

871: Pa_Debug.WRITE(g_module_name,' ####() p_project_id is '||p_project_id,
872: l_debug_level3);
873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,
874: l_debug_level3);
875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,
876: l_debug_level3);
877: Pa_Debug.WRITE(g_module_name,' ####() p_status_code' || p_status_code,
878: l_debug_level3);
879: Pa_Debug.WRITE(g_module_name,' ####() p_dlvr_type_id ' || p_dlvr_type_id,

Line 877: Pa_Debug.WRITE(g_module_name,' ####() p_status_code' || p_status_code,

873: Pa_Debug.WRITE(g_module_name,' ####()p_dlvr_item_id is '||p_dlvr_item_id,
874: l_debug_level3);
875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,
876: l_debug_level3);
877: Pa_Debug.WRITE(g_module_name,' ####() p_status_code' || p_status_code,
878: l_debug_level3);
879: Pa_Debug.WRITE(g_module_name,' ####() p_dlvr_type_id ' || p_dlvr_type_id,
880: l_debug_level3);
881: END IF;

Line 879: Pa_Debug.WRITE(g_module_name,' ####() p_dlvr_type_id ' || p_dlvr_type_id,

875: Pa_Debug.WRITE(g_module_name,' ###() p_dlvr_version_id is ' || p_dlvr_version_id,
876: l_debug_level3);
877: Pa_Debug.WRITE(g_module_name,' ####() p_status_code' || p_status_code,
878: l_debug_level3);
879: Pa_Debug.WRITE(g_module_name,' ####() p_dlvr_type_id ' || p_dlvr_type_id,
880: l_debug_level3);
881: END IF;
882:
883: -- Business Logic

Line 912: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.GET_DLVR_TYPE_INFO Called ',

908:
909: -- retrieve dlvr_progress_flag and enale_dlvr_action_flag for deliveable type
910:
911: IF l_debug_mode = 'Y' THEN
912: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.GET_DLVR_TYPE_INFO Called ',
913: l_debug_level3);
914: END IF;
915:
916: PA_DELIVERABLE_UTILS.GET_DLVR_TYPE_INFO

Line 925: Pa_Debug.WRITE(g_module_name,' Out of A_DELIVERABLE_UTILS.GET_DLVR_TYPE_INFO ',

921: x_dlvr_default_status_code => l_dlvr_default_status_code
922: );
923:
924: IF l_debug_mode = 'Y' THEN
925: Pa_Debug.WRITE(g_module_name,' Out of A_DELIVERABLE_UTILS.GET_DLVR_TYPE_INFO ',
926: l_debug_level3);
927: END IF;
928:
929: IF l_debug_mode = 'Y' THEN

Line 930: Pa_Debug.WRITE(g_module_name,' l_dlvr_prg_enabled ' || l_dlvr_prg_enabled, l_debug_level3);

926: l_debug_level3);
927: END IF;
928:
929: IF l_debug_mode = 'Y' THEN
930: Pa_Debug.WRITE(g_module_name,' l_dlvr_prg_enabled ' || l_dlvr_prg_enabled, l_debug_level3);
931: END IF;
932:
933: -- added the following code
934:

Line 978: Pa_Debug.WRITE(g_module_name,' Scheduled_finish_date is changed in update dlvr',

974:
975: IF trim(l_dlvr_info_rec.scheduled_finish_date) <> trim(p_scheduled_finish_date) THEN
976:
977: IF l_debug_mode = 'Y' THEN
978: Pa_Debug.WRITE(g_module_name,' Scheduled_finish_date is changed in update dlvr',
979: l_debug_level3);
980: END IF;
981:
982: IF l_debug_mode = 'Y' THEN

Line 983: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.GET_OKE_FLAGS Called ',

979: l_debug_level3);
980: END IF;
981:
982: IF l_debug_mode = 'Y' THEN
983: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.GET_OKE_FLAGS Called ',
984: l_debug_level3);
985: END IF;
986:
987: PA_DELIVERABLE_UTILS.GET_OKE_FLAGS

Line 1011: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.GET_OKE_FLAGS ',

1007: ,X_MSG_DATA => l_utl_msg_data
1008: );
1009:
1010: IF l_debug_mode = 'Y' THEN
1011: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.GET_OKE_FLAGS ',
1012: l_debug_level3);
1013: END IF;
1014:
1015: -- set l_function_call_done to 'Y' if PA_DELIVERABLE_UTILS.PA_DLVR_OKE_INTEGRATION

Line 1025: Pa_Debug.WRITE(g_module_name,' l_ship_procure_flag_dlv ' || l_ship_procure_flag_dlv,

1021: END IF;
1022:
1023:
1024: IF l_debug_mode = 'Y' THEN
1025: Pa_Debug.WRITE(g_module_name,' l_ship_procure_flag_dlv ' || l_ship_procure_flag_dlv,
1026: l_debug_level3);
1027: END IF;
1028:
1029: IF l_ship_procure_flag_dlv = 'Y' THEN

Line 1038: Pa_Debug.WRITE(g_module_name,' 1st validation status ' || x_return_status,

1034:
1035: END IF;
1036:
1037: IF l_debug_mode = 'Y' THEN
1038: Pa_Debug.WRITE(g_module_name,' 1st validation status ' || x_return_status,
1039: l_debug_level3);
1040: END IF;
1041:
1042: */

Line 1101: Pa_Debug.WRITE(g_module_name,' 3rd validation status ' || x_return_status,

1097: END IF;
1098: END IF;
1099:
1100: IF l_debug_mode = 'Y' THEN
1101: Pa_Debug.WRITE(g_module_name,' 3rd validation status ' || x_return_status,
1102: l_debug_level3);
1103: END IF;
1104:
1105:

Line 1114: Pa_Debug.WRITE(g_module_name,' dlvr status is changed ',

1110:
1111: IF l_dlvr_info_rec.status_code <> p_status_code THEN
1112:
1113: IF l_debug_mode = 'Y' THEN
1114: Pa_Debug.WRITE(g_module_name,' dlvr status is changed ',
1115: l_debug_level3);
1116: END IF;
1117:
1118: IF l_dlvr_prg_enabled = 'Y' THEN

Line 1129: Pa_Debug.WRITE(g_module_name,' For Deliverable progress and action is enabled ',

1125: p_project_id => p_project_id,
1126: p_proj_element_id => p_dlvr_item_id
1127: );
1128: IF l_debug_mode = 'Y' THEN
1129: Pa_Debug.WRITE(g_module_name,' For Deliverable progress and action is enabled ',
1130: l_debug_level3);
1131: END IF;
1132:
1133: IF l_dlvr_has_progress = 'N' THEN

Line 1135: Pa_Debug.WRITE(g_module_name,' Deliverable does not have progress records ',

1131: END IF;
1132:
1133: IF l_dlvr_has_progress = 'N' THEN
1134: IF l_debug_mode = 'Y' THEN
1135: Pa_Debug.WRITE(g_module_name,' Deliverable does not have progress records ',
1136: l_debug_level3);
1137: END IF;
1138:
1139: IF l_system_status_code <> l_not_started_sys_status_code THEN

Line 1150: Pa_Debug.WRITE(g_module_name,' 2nd validation status ' || x_return_status,

1146: END IF;
1147: END IF;
1148:
1149: IF l_debug_mode = 'Y' THEN
1150: Pa_Debug.WRITE(g_module_name,' 2nd validation status ' || x_return_status,
1151: l_debug_level3);
1152: END IF;
1153:
1154: -- if user changes status to 'cancelled' or 'on hold ', delivearble action functions needs to be validated

Line 1198: Pa_Debug.WRITE(g_module_name,' 4th validation status ' || x_return_status,

1194: END IF;
1195: END IF;
1196:
1197: IF l_debug_mode = 'Y' THEN
1198: Pa_Debug.WRITE(g_module_name,' 4th validation status ' || x_return_status,
1199: l_debug_level3);
1200: END IF;
1201:
1202: -- if user changes dlvr type, check wether deliverable actions for that delivearble exists or not

Line 1234: Pa_Debug.WRITE(g_module_name,'5th validation status ' || x_return_status,

1230:
1231: END IF;
1232:
1233: IF l_debug_mode = 'Y' THEN
1234: Pa_Debug.WRITE(g_module_name,'5th validation status ' || x_return_status,
1235: l_debug_level3);
1236: END IF;
1237:
1238:

Line 1244: Pa_Debug.WRITE(g_module_name,' x_return_status ' || x_return_status,

1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: IF l_debug_mode = 'Y' THEN
1244: Pa_Debug.WRITE(g_module_name,' x_return_status ' || x_return_status,
1245: l_debug_level3);
1246: END IF;
1247:
1248: IF l_debug_mode = 'Y' THEN

Line 1249: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Update_Row Called ',

1245: l_debug_level3);
1246: END IF;
1247:
1248: IF l_debug_mode = 'Y' THEN
1249: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Update_Row Called ',
1250: l_debug_level3);
1251: END IF;
1252:
1253: -- call update_row of pa_proj_elements package

Line 1329: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Update_Row ',

1325: );
1326:
1327:
1328: IF l_debug_mode = 'Y' THEN
1329: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Update_Row ',
1330: l_debug_level3);
1331: END IF;
1332:
1333: IF l_debug_mode = 'Y' THEN

Line 1334: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row Called ',

1330: l_debug_level3);
1331: END IF;
1332:
1333: IF l_debug_mode = 'Y' THEN
1334: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row Called ',
1335: l_debug_level3);
1336: END IF;
1337:
1338: -- call update_row of pa_proj_element_versions package

Line 1376: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row ',

1372: ,X_TASK_UNPUB_VER_STATUS_CODE => NULL
1373: );
1374:
1375: IF l_debug_mode = 'Y' THEN
1376: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row ',
1377: l_debug_level3);
1378: END IF;
1379:
1380: IF l_debug_mode = 'Y' THEN

Line 1381: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_SCH_PKG.Update_Row Called ',

1377: l_debug_level3);
1378: END IF;
1379:
1380: IF l_debug_mode = 'Y' THEN
1381: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_SCH_PKG.Update_Row Called ',
1382: l_debug_level3);
1383: END IF;
1384:
1385: -- call update_row of pa_proj_element_sch package

Line 1441: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_SCH_PKG.Update_Row ',

1437: ,X_ATTRIBUTE15 => p_attribute15
1438: );
1439:
1440: IF l_debug_mode = 'Y' THEN
1441: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_SCH_PKG.Update_Row ',
1442: l_debug_level3);
1443: END IF;
1444:
1445: -- if deliverable type is changed , copy the actions of that deliverable type

Line 1454: Pa_Debug.WRITE(g_module_name,' PA_ACTIONS_PUB.COPY_ACTIONS Called ',

1450:
1451: IF p_calling_module <> 'AMG' AND l_dlvr_info_rec.type_id <> p_dlvr_type_id THEN
1452:
1453: IF l_debug_mode = 'Y' THEN
1454: Pa_Debug.WRITE(g_module_name,' PA_ACTIONS_PUB.COPY_ACTIONS Called ',
1455: l_debug_level3);
1456: END IF;
1457:
1458: PA_ACTIONS_PUB.COPY_ACTIONS

Line 1481: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ',

1477: ,x_msg_data => x_msg_data
1478: ) ;
1479:
1480: IF l_debug_mode = 'Y' THEN
1481: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ',
1482: l_debug_level3);
1483: END IF;
1484:
1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1517: pa_debug.reset_curr_function;

1513: END IF;
1514:
1515: x_return_status := FND_API.G_RET_STS_SUCCESS;
1516: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
1517: pa_debug.reset_curr_function;
1518: END IF ;
1519:
1520: EXCEPTION
1521:

Line 1565: Pa_Debug.reset_curr_function;

1561: ELSE
1562: x_msg_count := l_msg_count;
1563: END IF;
1564: IF l_debug_mode = 'Y' THEN
1565: Pa_Debug.reset_curr_function;
1566: END IF;
1567:
1568: WHEN OTHERS THEN
1569:

Line 1604: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1600: , p_procedure_name => 'Update_Deliverable'
1601: , p_error_text => x_msg_data);
1602:
1603: IF l_debug_mode = 'Y' THEN
1604: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1605: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1606: l_debug_level5);
1607: Pa_Debug.reset_curr_function;
1608: END IF;

Line 1605: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1601: , p_error_text => x_msg_data);
1602:
1603: IF l_debug_mode = 'Y' THEN
1604: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1605: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1606: l_debug_level5);
1607: Pa_Debug.reset_curr_function;
1608: END IF;
1609: RAISE;

Line 1607: Pa_Debug.reset_curr_function;

1603: IF l_debug_mode = 'Y' THEN
1604: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1605: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1606: l_debug_level5);
1607: Pa_Debug.reset_curr_function;
1608: END IF;
1609: RAISE;
1610:
1611: END Update_Deliverable;

Line 1676: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1672: BEGIN
1673:
1674: x_msg_count := 0;
1675: x_return_status := FND_API.G_RET_STS_SUCCESS;
1676: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1677:
1678: IF l_debug_mode = 'Y' THEN
1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',
1680: p_debug_mode => l_debug_mode );

Line 1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',

1675: x_return_status := FND_API.G_RET_STS_SUCCESS;
1676: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1677:
1678: IF l_debug_mode = 'Y' THEN
1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',
1680: p_debug_mode => l_debug_mode );
1681: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE ';
1682: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1683: END IF;

Line 1681: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE ';

1677:
1678: IF l_debug_mode = 'Y' THEN
1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',
1680: p_debug_mode => l_debug_mode );
1681: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE ';
1682: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1683: END IF;
1684:
1685: IF l_debug_mode = 'Y' THEN

Line 1682: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1678: IF l_debug_mode = 'Y' THEN
1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',
1680: p_debug_mode => l_debug_mode );
1681: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE ';
1682: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1683: END IF;
1684:
1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:= 'Printing Input parameters';

Line 1686: pa_debug.g_err_stage:= 'Printing Input parameters';

1682: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1683: END IF;
1684:
1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:= 'Printing Input parameters';
1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;

Line 1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1683: END IF;
1684:
1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:= 'Printing Input parameters';
1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;

Line 1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;

1684:
1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:= 'Printing Input parameters';
1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;
1692:

Line 1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;

1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:= 'Printing Input parameters';
1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;
1692:
1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;

1686: pa_debug.g_err_stage:= 'Printing Input parameters';
1687: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1688: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;
1692:
1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1694: FND_MSG_PUB.initialize;

Line 1702: pa_debug.g_err_stage:= 'Validating Input parameters';

1698: savepoint DELETE_DELIVERABLE_SP ;
1699: END IF;
1700:
1701: IF l_debug_mode = 'Y' THEN
1702: pa_debug.g_err_stage:= 'Validating Input parameters';
1703: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1704: END IF;
1705:
1706: IF ( p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL )

Line 1703: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1699: END IF;
1700:
1701: IF l_debug_mode = 'Y' THEN
1702: pa_debug.g_err_stage:= 'Validating Input parameters';
1703: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1704: END IF;
1705:
1706: IF ( p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL )
1707: THEN

Line 1709: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';

1705:
1706: IF ( p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL )
1707: THEN
1708: IF l_debug_mode = 'Y' THEN
1709: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1711: END IF;
1712:
1713: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1706: IF ( p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL )
1707: THEN
1708: IF l_debug_mode = 'Y' THEN
1709: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1711: END IF;
1712:
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 1854: Pa_Debug.WRITE(g_module_name,' After deleting records from Project table, deleting OKE records['||x_return_status||']', 3);

1850: DELETE FROM PA_PROJ_ELEMENTS
1851: WHERE PROJ_ELEMENT_ID = p_dlv_element_id ;
1852:
1853: IF l_debug_mode = 'Y' THEN
1854: Pa_Debug.WRITE(g_module_name,' After deleting records from Project table, deleting OKE records['||x_return_status||']', 3);
1855: END IF;
1856:
1857: --Start Bug 3538320 <>
1858: --Delete the Attachment records of the deliverable

Line 1922: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']', 3);

1918: ) ;
1919: END IF;
1920:
1921: IF l_debug_mode = 'Y' THEN
1922: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']', 3);
1923: END IF;
1924:
1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1962: pa_debug.g_err_stage:= 'Exiting DELETE_DELIVERABLE' ;

1958:
1959: --End Bug 3431156
1960:
1961: IF l_debug_mode = 'Y' THEN
1962: pa_debug.g_err_stage:= 'Exiting DELETE_DELIVERABLE' ;
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1964: pa_debug.reset_curr_function;
1965: END IF;
1966:

Line 1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

1959: --End Bug 3431156
1960:
1961: IF l_debug_mode = 'Y' THEN
1962: pa_debug.g_err_stage:= 'Exiting DELETE_DELIVERABLE' ;
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1964: pa_debug.reset_curr_function;
1965: END IF;
1966:
1967: EXCEPTION

Line 1964: pa_debug.reset_curr_function;

1960:
1961: IF l_debug_mode = 'Y' THEN
1962: pa_debug.g_err_stage:= 'Exiting DELETE_DELIVERABLE' ;
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1964: pa_debug.reset_curr_function;
1965: END IF;
1966:
1967: EXCEPTION
1968: WHEN Invalid_Arg_Exc_Dlv THEN

Line 1977: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE';

1973: ROLLBACK TO DELETE_DELIVERABLE_SP;
1974: END IF;
1975:
1976: IF l_debug_mode = 'Y' THEN
1977: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE';
1978: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1979: END IF;
1980:
1981: IF l_msg_count = 1 THEN

Line 1978: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1974: END IF;
1975:
1976: IF l_debug_mode = 'Y' THEN
1977: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE';
1978: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1979: END IF;
1980:
1981: IF l_msg_count = 1 THEN
1982: PA_INTERFACE_UTILS_PUB.get_messages

Line 1995: pa_debug.reset_curr_function;

1991: ELSE
1992: x_msg_count := l_msg_count;
1993: END IF;
1994: IF l_debug_mode = 'Y' THEN
1995: pa_debug.reset_curr_function;
1996: END IF ;
1997: RETURN;
1998:
1999: WHEN FND_API.G_EXC_ERROR THEN

Line 2023: pa_debug.write( g_module_name,'DELETE_DELIVERABLE: G_EXC_ERROR msg_count' ||l_msg_count ,5);

2019: x_msg_count := l_msg_count;
2020: END IF;
2021:
2022: IF l_debug_mode = 'Y' THEN
2023: pa_debug.write( g_module_name,'DELETE_DELIVERABLE: G_EXC_ERROR msg_count' ||l_msg_count ,5);
2024: Pa_Debug.reset_curr_function;
2025: END IF;
2026:
2027: WHEN OTHERS THEN

Line 2024: Pa_Debug.reset_curr_function;

2020: END IF;
2021:
2022: IF l_debug_mode = 'Y' THEN
2023: pa_debug.write( g_module_name,'DELETE_DELIVERABLE: G_EXC_ERROR msg_count' ||l_msg_count ,5);
2024: Pa_Debug.reset_curr_function;
2025: END IF;
2026:
2027: WHEN OTHERS THEN
2028: IF p_commit = FND_API.G_TRUE THEN

Line 2040: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2036: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2037: ,p_procedure_name => 'DELETE_DELIVERABLE');
2038:
2039: IF p_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2041: pa_debug.write('DELETE_DELIVERABLE: ' || g_module_name,pa_debug.g_err_stage,5);
2042: pa_debug.reset_curr_function;
2043: END IF;
2044: RAISE;

Line 2041: pa_debug.write('DELETE_DELIVERABLE: ' || g_module_name,pa_debug.g_err_stage,5);

2037: ,p_procedure_name => 'DELETE_DELIVERABLE');
2038:
2039: IF p_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2041: pa_debug.write('DELETE_DELIVERABLE: ' || g_module_name,pa_debug.g_err_stage,5);
2042: pa_debug.reset_curr_function;
2043: END IF;
2044: RAISE;
2045: END delete_deliverable ;

Line 2042: pa_debug.reset_curr_function;

2038:
2039: IF p_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2041: pa_debug.write('DELETE_DELIVERABLE: ' || g_module_name,pa_debug.g_err_stage,5);
2042: pa_debug.reset_curr_function;
2043: END IF;
2044: RAISE;
2045: END delete_deliverable ;
2046:

Line 2107: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

2103: BEGIN
2104:
2105: x_msg_count := 0;
2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2108:
2109: IF l_debug_mode = 'Y' THEN
2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
2111: p_debug_mode => l_debug_mode );

Line 2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',

2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2108:
2109: IF l_debug_mode = 'Y' THEN
2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
2111: p_debug_mode => l_debug_mode );
2112: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2114: END IF;

Line 2112: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';

2108:
2109: IF l_debug_mode = 'Y' THEN
2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
2111: p_debug_mode => l_debug_mode );
2112: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2114: END IF;
2115:
2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2109: IF l_debug_mode = 'Y' THEN
2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
2111: p_debug_mode => l_debug_mode );
2112: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2114: END IF;
2115:
2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2117: FND_MSG_PUB.initialize;

Line 2140: pa_debug.g_err_stage:= 'Call IS_DISASSOCIATION_ALLOWED ';

2136: -- populate the error stack with proper error message if
2137: -- disassociation is not allowed .
2138:
2139: IF l_debug_mode = 'Y' THEN
2140: pa_debug.g_err_stage:= 'Call IS_DISASSOCIATION_ALLOWED ';
2141: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2142: END IF ;
2143:
2144: PA_DELIVERABLE_PVT.IS_DISASSOCIATION_ALLOWED

Line 2141: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2137: -- disassociation is not allowed .
2138:
2139: IF l_debug_mode = 'Y' THEN
2140: pa_debug.g_err_stage:= 'Call IS_DISASSOCIATION_ALLOWED ';
2141: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2142: END IF ;
2143:
2144: PA_DELIVERABLE_PVT.IS_DISASSOCIATION_ALLOWED
2145: (p_api_version => p_api_version

Line 2166: pa_debug.g_err_stage:= 'l_disassociation_allowed is'||l_disassociation_allowed;

2162: ,x_msg_data => x_msg_data
2163: ) ;
2164:
2165: IF l_debug_mode = 'Y' THEN
2166: pa_debug.g_err_stage:= 'l_disassociation_allowed is'||l_disassociation_allowed;
2167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2168: END IF ;
2169:
2170: IF l_debug_mode = 'Y' THEN

Line 2167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2163: ) ;
2164:
2165: IF l_debug_mode = 'Y' THEN
2166: pa_debug.g_err_stage:= 'l_disassociation_allowed is'||l_disassociation_allowed;
2167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2168: END IF ;
2169:
2170: IF l_debug_mode = 'Y' THEN
2171: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;

Line 2171: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;

2167: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2168: END IF ;
2169:
2170: IF l_debug_mode = 'Y' THEN
2171: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;
2172: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2173: END IF ;
2174:
2175:

Line 2172: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2168: END IF ;
2169:
2170: IF l_debug_mode = 'Y' THEN
2171: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;
2172: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2173: END IF ;
2174:
2175:
2176: IF (nvl(l_disassociation_allowed,'Y') = 'N' OR x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

Line 2182: pa_debug.g_err_stage:= ' No Validation Required For TA To Dlvr Deletion ' ;

2178: END IF ;
2179: ELSE
2180:
2181: IF l_debug_mode = 'Y' THEN
2182: pa_debug.g_err_stage:= ' No Validation Required For TA To Dlvr Deletion ' ;
2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2184: END IF ;
2185:
2186: END IF;

Line 2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2179: ELSE
2180:
2181: IF l_debug_mode = 'Y' THEN
2182: pa_debug.g_err_stage:= ' No Validation Required For TA To Dlvr Deletion ' ;
2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2184: END IF ;
2185:
2186: END IF;
2187:

Line 2210: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;

2206: ,x_return_status => x_return_status
2207: );
2208:
2209: IF l_debug_mode = 'Y' THEN
2210: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;
2211: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2212: END IF ;
2213:
2214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2211: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2207: );
2208:
2209: IF l_debug_mode = 'Y' THEN
2210: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;
2211: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2212: END IF ;
2213:
2214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2215: RAISE Invalid_Arg_Exc_Dlv ;

Line 2219: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;

2215: RAISE Invalid_Arg_Exc_Dlv ;
2216: END IF ;
2217:
2218: IF l_debug_mode = 'Y' THEN
2219: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
2220: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2221: pa_debug.reset_curr_function;
2222: END IF;
2223:

Line 2220: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2216: END IF ;
2217:
2218: IF l_debug_mode = 'Y' THEN
2219: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
2220: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2221: pa_debug.reset_curr_function;
2222: END IF;
2223:
2224: EXCEPTION

Line 2221: pa_debug.reset_curr_function;

2217:
2218: IF l_debug_mode = 'Y' THEN
2219: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
2220: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2221: pa_debug.reset_curr_function;
2222: END IF;
2223:
2224: EXCEPTION
2225: WHEN Invalid_Arg_Exc_Dlv THEN

Line 2234: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSOCIATION';

2230: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;
2231: END IF ;
2232:
2233: IF l_debug_mode = 'Y' THEN
2234: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSOCIATION';
2235: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2236: END IF;
2237:
2238: IF l_msg_count = 1 THEN

Line 2235: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

2231: END IF ;
2232:
2233: IF l_debug_mode = 'Y' THEN
2234: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSOCIATION';
2235: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2236: END IF;
2237:
2238: IF l_msg_count = 1 THEN
2239: PA_INTERFACE_UTILS_PUB.get_messages

Line 2252: pa_debug.reset_curr_function;

2248: ELSE
2249: x_msg_count := l_msg_count;
2250: END IF;
2251: IF l_debug_mode = 'Y' THEN
2252: pa_debug.reset_curr_function;
2253: END IF ;
2254: RETURN;
2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2268: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2264: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2265: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
2266:
2267: IF p_debug_mode = 'Y' THEN
2268: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2269: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2270: pa_debug.reset_curr_function;
2271: END IF;
2272: RAISE;

Line 2269: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);

2265: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
2266:
2267: IF p_debug_mode = 'Y' THEN
2268: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2269: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2270: pa_debug.reset_curr_function;
2271: END IF;
2272: RAISE;
2273: END DELETE_DLV_TASK_ASSOCIATION ;

Line 2270: pa_debug.reset_curr_function;

2266:
2267: IF p_debug_mode = 'Y' THEN
2268: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2269: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2270: pa_debug.reset_curr_function;
2271: END IF;
2272: RAISE;
2273: END DELETE_DLV_TASK_ASSOCIATION ;
2274:

Line 2327: pa_debug.set_curr_function( p_function => 'IS_DISASSOCIATION_ALLOWED',

2323: x_msg_count := 0;
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: IF p_debug_mode = 'Y' THEN
2327: pa_debug.set_curr_function( p_function => 'IS_DISASSOCIATION_ALLOWED',
2328: p_debug_mode => p_debug_mode );
2329: pa_debug.g_err_stage:= 'Inside IS_DISASSOCIATION_ALLOWED ,Calling Context is ' || p_calling_context;
2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2331: END IF;

Line 2329: pa_debug.g_err_stage:= 'Inside IS_DISASSOCIATION_ALLOWED ,Calling Context is ' || p_calling_context;

2325:
2326: IF p_debug_mode = 'Y' THEN
2327: pa_debug.set_curr_function( p_function => 'IS_DISASSOCIATION_ALLOWED',
2328: p_debug_mode => p_debug_mode );
2329: pa_debug.g_err_stage:= 'Inside IS_DISASSOCIATION_ALLOWED ,Calling Context is ' || p_calling_context;
2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2331: END IF;
2332:
2333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2326: IF p_debug_mode = 'Y' THEN
2327: pa_debug.set_curr_function( p_function => 'IS_DISASSOCIATION_ALLOWED',
2328: p_debug_mode => p_debug_mode );
2329: pa_debug.g_err_stage:= 'Inside IS_DISASSOCIATION_ALLOWED ,Calling Context is ' || p_calling_context;
2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2331: END IF;
2332:
2333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2334: FND_MSG_PUB.initialize;

Line 2379: pa_debug.reset_curr_function;

2375: x_disassociation_allowed := 'N';
2376: END IF ;*/
2377:
2378: IF p_debug_mode = 'Y' THEN --Added for bug 4945876
2379: pa_debug.reset_curr_function;
2380: END IF ;
2381:
2382: EXCEPTION
2383: WHEN OTHERS THEN

Line 2392: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2388: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
2389: ,p_procedure_name => 'IS_DISASSOCIATION_ALLOWED');
2390:
2391: IF p_debug_mode = 'Y' THEN
2392: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2393: pa_debug.write('IS_DISASSOCIATION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
2394: pa_debug.reset_curr_function;
2395: END IF;
2396: RAISE;

Line 2393: pa_debug.write('IS_DISASSOCIATION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);

2389: ,p_procedure_name => 'IS_DISASSOCIATION_ALLOWED');
2390:
2391: IF p_debug_mode = 'Y' THEN
2392: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2393: pa_debug.write('IS_DISASSOCIATION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
2394: pa_debug.reset_curr_function;
2395: END IF;
2396: RAISE;
2397: END IS_DISASSOCIATION_ALLOWED;

Line 2394: pa_debug.reset_curr_function;

2390:
2391: IF p_debug_mode = 'Y' THEN
2392: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2393: pa_debug.write('IS_DISASSOCIATION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
2394: pa_debug.reset_curr_function;
2395: END IF;
2396: RAISE;
2397: END IS_DISASSOCIATION_ALLOWED;
2398:

Line 2461: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK'

2457: x_msg_count := 0;
2458: x_return_status := FND_API.G_RET_STS_SUCCESS;
2459:
2460: IF p_debug_mode = 'Y' THEN
2461: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK'
2462: ,p_debug_mode => p_debug_mode );
2463: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2465: END IF;

Line 2463: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';

2459:
2460: IF p_debug_mode = 'Y' THEN
2461: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK'
2462: ,p_debug_mode => p_debug_mode );
2463: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2465: END IF;
2466:
2467: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2460: IF p_debug_mode = 'Y' THEN
2461: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK'
2462: ,p_debug_mode => p_debug_mode );
2463: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2465: END IF;
2466:
2467: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2468: FND_MSG_PUB.initialize;

Line 2603: pa_debug.reset_curr_function;

2599: ) ;
2600:
2601:
2602: IF p_debug_mode = 'Y' THEN
2603: pa_debug.reset_curr_function;
2604: END IF ;
2605:
2606: EXCEPTION
2607: WHEN Invalid_Arg_Exc_Dlv THEN

Line 2611: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';

2607: WHEN Invalid_Arg_Exc_Dlv THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_msg_count := FND_MSG_PUB.count_msg;
2610: IF p_debug_mode = 'Y' THEN
2611: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2612: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2613: END IF;
2614:
2615: IF x_msg_count = 1 THEN

Line 2612: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_msg_count := FND_MSG_PUB.count_msg;
2610: IF p_debug_mode = 'Y' THEN
2611: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2612: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2613: END IF;
2614:
2615: IF x_msg_count = 1 THEN
2616: PA_INTERFACE_UTILS_PUB.get_messages

Line 2629: pa_debug.reset_curr_function;

2625: ELSE
2626: x_msg_count := l_msg_count;
2627: END IF;
2628: IF p_debug_mode = 'Y' THEN
2629: pa_debug.reset_curr_function;
2630: END IF ;
2631: RETURN;
2632: WHEN OTHERS THEN
2633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2640: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,SQLERRM,4);

2636: FND_MSG_PUB.add_exc_msg
2637: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
2638: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK' );
2639: IF p_debug_mode = 'Y' THEN
2640: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,SQLERRM,4);
2641: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
2642: pa_debug.reset_curr_function;
2643: END IF;
2644: RAISE ;

Line 2641: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);

2637: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
2638: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK' );
2639: IF p_debug_mode = 'Y' THEN
2640: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,SQLERRM,4);
2641: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
2642: pa_debug.reset_curr_function;
2643: END IF;
2644: RAISE ;
2645: END CREATE_ASSOCIATIONS_IN_BULK ;

Line 2642: pa_debug.reset_curr_function;

2638: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK' );
2639: IF p_debug_mode = 'Y' THEN
2640: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,SQLERRM,4);
2641: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
2642: pa_debug.reset_curr_function;
2643: END IF;
2644: RAISE ;
2645: END CREATE_ASSOCIATIONS_IN_BULK ;
2646:

Line 2719: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_TASK_ASSOCIATION'

2715: x_msg_count := 0;
2716: x_return_status := FND_API.G_RET_STS_SUCCESS;
2717:
2718: IF p_debug_mode = 'Y' THEN
2719: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_TASK_ASSOCIATION'
2720: ,p_debug_mode => p_debug_mode );
2721: pa_debug.g_err_stage:= 'Inside CREATE_DLV_TASK_ASSOCIATION ';
2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2723: END IF;

Line 2721: pa_debug.g_err_stage:= 'Inside CREATE_DLV_TASK_ASSOCIATION ';

2717:
2718: IF p_debug_mode = 'Y' THEN
2719: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_TASK_ASSOCIATION'
2720: ,p_debug_mode => p_debug_mode );
2721: pa_debug.g_err_stage:= 'Inside CREATE_DLV_TASK_ASSOCIATION ';
2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2723: END IF;
2724:
2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2718: IF p_debug_mode = 'Y' THEN
2719: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_TASK_ASSOCIATION'
2720: ,p_debug_mode => p_debug_mode );
2721: pa_debug.g_err_stage:= 'Inside CREATE_DLV_TASK_ASSOCIATION ';
2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2723: END IF;
2724:
2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2726: FND_MSG_PUB.initialize;

Line 2737: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';

2733: IF ((p_task_element_id IS NULL )OR --p_task_version_id IS NULL) OR
2734: (p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL ))
2735: THEN
2736: IF p_debug_mode = 'Y' THEN
2737: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2738: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2739: END IF;
2740:
2741: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2738: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2734: (p_dlv_element_id IS NULL OR p_dlv_version_id IS NULL ))
2735: THEN
2736: IF p_debug_mode = 'Y' THEN
2737: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2738: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2739: END IF;
2740:
2741: x_return_status := FND_API.G_RET_STS_ERROR;
2742: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 2768: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS';

2764: RAISE Invalid_Arg_Exc_Dlv ;
2765: END IF ;
2766:
2767: IF p_debug_mode = 'Y' THEN
2768: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS';
2769: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2770: END IF;
2771:
2772: -- 3651542 added below call to check whether task assignment to deliverable relation ship is

Line 2769: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

2765: END IF ;
2766:
2767: IF p_debug_mode = 'Y' THEN
2768: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS';
2769: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2770: END IF;
2771:
2772: -- 3651542 added below call to check whether task assignment to deliverable relation ship is
2773: -- existing or not

Line 2861: pa_debug.reset_curr_function;

2857: ) ;
2858: END IF;
2859:
2860: IF p_debug_mode = 'Y' THEN
2861: pa_debug.reset_curr_function;
2862: END IF ;
2863: EXCEPTION
2864: WHEN Invalid_Arg_Exc_Dlv THEN
2865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2873: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_DLV_TASK_ASSOCIATION';

2869: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;
2870: END IF ;
2871:
2872: IF p_debug_mode = 'Y' THEN
2873: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_DLV_TASK_ASSOCIATION';
2874: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2875: END IF;
2876:
2877: IF l_msg_count = 1 THEN

Line 2874: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

2870: END IF ;
2871:
2872: IF p_debug_mode = 'Y' THEN
2873: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_DLV_TASK_ASSOCIATION';
2874: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2875: END IF;
2876:
2877: IF l_msg_count = 1 THEN
2878: PA_INTERFACE_UTILS_PUB.get_messages

Line 2891: pa_debug.reset_curr_function;

2887: ELSE
2888: x_msg_count := l_msg_count;
2889: END IF;
2890: IF l_debug_mode = 'Y' THEN
2891: pa_debug.reset_curr_function;
2892: END IF ;
2893: RETURN;
2894: WHEN OTHERS THEN
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2907: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

2903: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_VT'
2904: ,p_procedure_name => 'CREATE_DLV_TASK_ASSOCIATION');
2905:
2906: IF p_debug_mode = 'Y' THEN
2907: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2908: pa_debug.write('CREATE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2909: pa_debug.reset_curr_function;
2910: END IF;
2911: RAISE;

Line 2908: pa_debug.write('CREATE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);

2904: ,p_procedure_name => 'CREATE_DLV_TASK_ASSOCIATION');
2905:
2906: IF p_debug_mode = 'Y' THEN
2907: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2908: pa_debug.write('CREATE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2909: pa_debug.reset_curr_function;
2910: END IF;
2911: RAISE;
2912: END CREATE_DLV_TASK_ASSOCIATION ;

Line 2909: pa_debug.reset_curr_function;

2905:
2906: IF p_debug_mode = 'Y' THEN
2907: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2908: pa_debug.write('CREATE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
2909: pa_debug.reset_curr_function;
2910: END IF;
2911: RAISE;
2912: END CREATE_DLV_TASK_ASSOCIATION ;
2913:

Line 2951: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',

2947: l_msg_count := 0;
2948: l_return_status := FND_API.G_RET_STS_SUCCESS;
2949:
2950: IF p_debug_mode = 'Y' THEN
2951: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2952: p_debug_mode => p_debug_mode );
2953: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;

Line 2953: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';

2949:
2950: IF p_debug_mode = 'Y' THEN
2951: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2952: p_debug_mode => p_debug_mode );
2953: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

2950: IF p_debug_mode = 'Y' THEN
2951: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2952: p_debug_mode => p_debug_mode );
2953: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2958: FND_MSG_PUB.initialize;

Line 3102: pa_debug.reset_curr_function;

3098:
3099: -- <> Included by avaithia on 12-Feb-2004 Bug # 3431156
3100:
3101: IF p_debug_mode = 'Y' THEN
3102: pa_debug.reset_curr_function;
3103: END IF ;
3104:
3105: EXCEPTION
3106: WHEN Invalid_Arg_Exc_Dlv THEN

Line 3111: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';

3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: l_msg_count := FND_MSG_PUB.count_msg;
3109:
3110: IF p_debug_mode = 'Y' THEN
3111: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';
3112: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3113: END IF;
3114:
3115: IF l_msg_count = 1 THEN

Line 3112: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

3108: l_msg_count := FND_MSG_PUB.count_msg;
3109:
3110: IF p_debug_mode = 'Y' THEN
3111: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';
3112: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3113: END IF;
3114:
3115: IF l_msg_count = 1 THEN
3116: PA_INTERFACE_UTILS_PUB.get_messages

Line 3129: pa_debug.reset_curr_function;

3125: ELSE
3126: x_msg_count := l_msg_count;
3127: END IF;
3128: IF p_debug_mode = 'Y' THEN
3129: pa_debug.reset_curr_function;
3130: END IF ;
3131: RETURN;
3132: WHEN OTHERS THEN
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3141: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);

3137: FND_MSG_PUB.add_exc_msg
3138: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
3139: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
3140: IF p_debug_mode = 'Y' THEN
3141: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
3142: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
3143: pa_debug.reset_curr_function;
3144: END IF;
3145: RAISE ;

Line 3142: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);

3138: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
3139: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
3140: IF p_debug_mode = 'Y' THEN
3141: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
3142: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
3143: pa_debug.reset_curr_function;
3144: END IF;
3145: RAISE ;
3146: END DELETE_DELIVERABLE_STRUCTURE ;

Line 3143: pa_debug.reset_curr_function;

3139: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
3140: IF p_debug_mode = 'Y' THEN
3141: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
3142: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
3143: pa_debug.reset_curr_function;
3144: END IF;
3145: RAISE ;
3146: END DELETE_DELIVERABLE_STRUCTURE ;
3147:

Line 3262: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',

3258: x_msg_count := 0;
3259: x_return_status := FND_API.G_RET_STS_SUCCESS;
3260:
3261: IF p_debug_mode = 'Y' THEN
3262: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
3263: p_debug_mode => p_debug_mode );
3264: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3266: END IF;

Line 3264: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';

3260:
3261: IF p_debug_mode = 'Y' THEN
3262: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
3263: p_debug_mode => p_debug_mode );
3264: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3266: END IF;
3267:
3268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3261: IF p_debug_mode = 'Y' THEN
3262: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
3263: p_debug_mode => p_debug_mode );
3264: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3266: END IF;
3267:
3268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3269: FND_MSG_PUB.initialize;

Line 3273: pa_debug.g_err_stage:= 'Opening cursor ';

3269: FND_MSG_PUB.initialize;
3270: END IF;
3271:
3272: IF p_debug_mode = 'Y' THEN
3273: pa_debug.g_err_stage:= 'Opening cursor ';
3274: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3275: END IF ;
3276:
3277: /* Following Comment introduced for Bug 3906015*/

Line 3274: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3270: END IF;
3271:
3272: IF p_debug_mode = 'Y' THEN
3273: pa_debug.g_err_stage:= 'Opening cursor ';
3274: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3275: END IF ;
3276:
3277: /* Following Comment introduced for Bug 3906015*/
3278: -- *******************************************************************************************************************

Line 3305: pa_debug.g_err_stage:= 'Delete the association';

3301:
3302: END IF;
3303:
3304: IF p_debug_mode = 'Y' THEN
3305: pa_debug.g_err_stage:= 'Delete the association';
3306: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3307: END IF ;
3308:
3309: -- 3955848 Added following if condition to check for p_delete_or_validate

Line 3306: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3302: END IF;
3303:
3304: IF p_debug_mode = 'Y' THEN
3305: pa_debug.g_err_stage:= 'Delete the association';
3306: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3307: END IF ;
3308:
3309: -- 3955848 Added following if condition to check for p_delete_or_validate
3310: -- if p_delete_or_validate is B , do both validation and deletion ( default behaviour )

Line 3333: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;

3329: AND relationship_subtype = 'ASSIGNMENT_TO_DELIVERABLE' ;
3330: END IF ;
3331:
3332: IF p_debug_mode = 'Y' THEN
3333: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
3334: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3335: pa_debug.reset_curr_function;
3336: END IF;
3337:

Line 3334: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3330: END IF ;
3331:
3332: IF p_debug_mode = 'Y' THEN
3333: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
3334: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3335: pa_debug.reset_curr_function;
3336: END IF;
3337:
3338: EXCEPTION

Line 3335: pa_debug.reset_curr_function;

3331:
3332: IF p_debug_mode = 'Y' THEN
3333: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
3334: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3335: pa_debug.reset_curr_function;
3336: END IF;
3337:
3338: EXCEPTION
3339: WHEN Invalid_Arg_Exc_Dlv THEN

Line 3344: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';

3340: x_return_status := FND_API.G_RET_STS_ERROR;
3341: l_msg_count := FND_MSG_PUB.count_msg;
3342:
3343: IF p_debug_mode = 'Y' THEN
3344: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
3345: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3346: END IF;
3347:
3348: IF l_msg_count = 1 THEN

Line 3345: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

3341: l_msg_count := FND_MSG_PUB.count_msg;
3342:
3343: IF p_debug_mode = 'Y' THEN
3344: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
3345: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3346: END IF;
3347:
3348: IF l_msg_count = 1 THEN
3349: PA_INTERFACE_UTILS_PUB.get_messages

Line 3362: pa_debug.reset_curr_function;

3358: ELSE
3359: x_msg_count := l_msg_count;
3360: END IF;
3361: IF p_debug_mode = 'Y' THEN
3362: pa_debug.reset_curr_function;
3363: END IF ;
3364: RETURN;
3365: WHEN OTHERS THEN
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3374: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

3370: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
3371: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
3372:
3373: IF p_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3375: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
3376: pa_debug.reset_curr_function;
3377: END IF;
3378: RAISE;

Line 3375: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

3371: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
3372:
3373: IF p_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3375: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
3376: pa_debug.reset_curr_function;
3377: END IF;
3378: RAISE;
3379: END DELETE_DLV_TASK_ASSCN_IN_BULK ;

Line 3376: pa_debug.reset_curr_function;

3372:
3373: IF p_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3375: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
3376: pa_debug.reset_curr_function;
3377: END IF;
3378: RAISE;
3379: END DELETE_DLV_TASK_ASSCN_IN_BULK ;
3380:

Line 3497: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',

3493: x_msg_count := 0;
3494: x_return_status := FND_API.G_RET_STS_SUCCESS;
3495:
3496: IF p_debug_mode = 'Y' THEN
3497: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
3498: p_debug_mode => p_debug_mode );
3499: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3501: END IF;

Line 3499: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';

3495:
3496: IF p_debug_mode = 'Y' THEN
3497: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
3498: p_debug_mode => p_debug_mode );
3499: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3501: END IF;
3502:
3503: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3496: IF p_debug_mode = 'Y' THEN
3497: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
3498: p_debug_mode => p_debug_mode );
3499: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3501: END IF;
3502:
3503: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3504: FND_MSG_PUB.initialize;

Line 3533: pa_debug.g_err_stage:= 'Delete the associations';

3529: CLOSE C;
3530: -- Bug 3906015 : End
3531:
3532: IF p_debug_mode = 'Y' THEN
3533: pa_debug.g_err_stage:= 'Delete the associations';
3534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3535: END IF ;
3536:
3537: DELETE FROM pa_object_relationships

Line 3534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3530: -- Bug 3906015 : End
3531:
3532: IF p_debug_mode = 'Y' THEN
3533: pa_debug.g_err_stage:= 'Delete the associations';
3534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3535: END IF ;
3536:
3537: DELETE FROM pa_object_relationships
3538: WHERE object_type_from = 'PA_TASKS'

Line 3547: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;

3543: FROM pa_proj_elements
3544: WHERE project_id = p_project_id ) ;
3545:
3546: IF p_debug_mode = 'Y' THEN
3547: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
3548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3549: pa_debug.reset_curr_function;
3550: END IF;
3551:

Line 3548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

3544: WHERE project_id = p_project_id ) ;
3545:
3546: IF p_debug_mode = 'Y' THEN
3547: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
3548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3549: pa_debug.reset_curr_function;
3550: END IF;
3551:
3552: EXCEPTION

Line 3549: pa_debug.reset_curr_function;

3545:
3546: IF p_debug_mode = 'Y' THEN
3547: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
3548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
3549: pa_debug.reset_curr_function;
3550: END IF;
3551:
3552: EXCEPTION
3553: WHEN Invalid_Arg_Exc_Dlv THEN

Line 3558: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';

3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: l_msg_count := FND_MSG_PUB.count_msg;
3556:
3557: IF p_debug_mode = 'Y' THEN
3558: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
3559: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3560: END IF;
3561:
3562: IF l_msg_count = 1 THEN

Line 3559: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

3555: l_msg_count := FND_MSG_PUB.count_msg;
3556:
3557: IF p_debug_mode = 'Y' THEN
3558: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
3559: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
3560: END IF;
3561:
3562: IF l_msg_count = 1 THEN
3563: PA_INTERFACE_UTILS_PUB.get_messages

Line 3576: pa_debug.reset_curr_function;

3572: ELSE
3573: x_msg_count := l_msg_count;
3574: END IF;
3575: IF p_debug_mode = 'Y' THEN
3576: pa_debug.reset_curr_function;
3577: END IF ;
3578: RETURN;
3579: WHEN OTHERS THEN
3580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3588: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

3584: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
3585: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
3586:
3587: IF p_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3589: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
3590: pa_debug.reset_curr_function;
3591: END IF;
3592: RAISE;

Line 3589: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);

3585: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
3586:
3587: IF p_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3589: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
3590: pa_debug.reset_curr_function;
3591: END IF;
3592: RAISE;
3593: END DELETE_DLV_ASSOCIATIONS ;

Line 3590: pa_debug.reset_curr_function;

3586:
3587: IF p_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3589: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
3590: pa_debug.reset_curr_function;
3591: END IF;
3592: RAISE;
3593: END DELETE_DLV_ASSOCIATIONS ;
3594:

Line 3895: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

3891: BEGIN
3892:
3893: l_msg_count := 0;
3894: x_return_status := FND_API.G_RET_STS_SUCCESS;
3895: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3896:
3897: IF l_debug_mode = 'Y' THEN
3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
3899: p_debug_mode => l_debug_mode );

Line 3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',

3894: x_return_status := FND_API.G_RET_STS_SUCCESS;
3895: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3896:
3897: IF l_debug_mode = 'Y' THEN
3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
3899: p_debug_mode => l_debug_mode );
3900: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
3901: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3902: END IF;

Line 3900: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';

3896:
3897: IF l_debug_mode = 'Y' THEN
3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
3899: p_debug_mode => l_debug_mode );
3900: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
3901: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3902: END IF;
3903:
3904: IF l_debug_mode = 'Y' THEN

Line 3901: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3897: IF l_debug_mode = 'Y' THEN
3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
3899: p_debug_mode => l_debug_mode );
3900: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
3901: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3902: END IF;
3903:
3904: IF l_debug_mode = 'Y' THEN
3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;

Line 3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;

3901: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3902: END IF;
3903:
3904: IF l_debug_mode = 'Y' THEN
3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
3906: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;

Line 3906: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3902: END IF;
3903:
3904: IF l_debug_mode = 'Y' THEN
3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
3906: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;
3910:

Line 3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;

3903:
3904: IF l_debug_mode = 'Y' THEN
3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
3906: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;
3910:
3911: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

3904: IF l_debug_mode = 'Y' THEN
3905: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
3906: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;
3910:
3911: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3912: FND_MSG_PUB.initialize;

Line 4215: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENTS ';

4211:
4212: END IF ;
4213:
4214: IF l_debug_mode = 'Y' THEN
4215: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENTS ';
4216: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4217: END IF;
4218:
4219: -- Validate unique deliverable number

Line 4216: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4212: END IF ;
4213:
4214: IF l_debug_mode = 'Y' THEN
4215: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENTS ';
4216: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4217: END IF;
4218:
4219: -- Validate unique deliverable number
4220: IF l_debug_mode = 'Y' THEN

Line 4221: pa_debug.g_err_stage := 'Check for Duplicate Deliverable Number ';

4217: END IF;
4218:
4219: -- Validate unique deliverable number
4220: IF l_debug_mode = 'Y' THEN
4221: pa_debug.g_err_stage := 'Check for Duplicate Deliverable Number ';
4222: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4223: END IF ;
4224:
4225: IF p_calling_context <> 'COPY_PROJECT' THEN

Line 4222: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4218:
4219: -- Validate unique deliverable number
4220: IF l_debug_mode = 'Y' THEN
4221: pa_debug.g_err_stage := 'Check for Duplicate Deliverable Number ';
4222: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4223: END IF ;
4224:
4225: IF p_calling_context <> 'COPY_PROJECT' THEN
4226:

Line 4242: pa_debug.g_err_stage := 'Duplicate Deliverable Number ';

4238: PA_UTILS.ADD_MESSAGE('PA','PA_ENTER_OTHER_PREFIX') ;
4239: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4240: RAISE Invalid_Arg_Exc_Dlv ;
4241: -- END IF ;
4242: pa_debug.g_err_stage := 'Duplicate Deliverable Number ';
4243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4244: END IF ;
4245:
4246: END LOOP ;

Line 4243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4239: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4240: RAISE Invalid_Arg_Exc_Dlv ;
4241: -- END IF ;
4242: pa_debug.g_err_stage := 'Duplicate Deliverable Number ';
4243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4244: END IF ;
4245:
4246: END LOOP ;
4247: END IF ; -- Included for 4468344

Line 4340: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENT_VERSIONS ';

4336: RETURNING proj_element_id
4337: BULK COLLECT INTO l_proj_element_id_tbl ;
4338:
4339: IF l_debug_mode = 'Y' THEN
4340: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENT_VERSIONS ';
4341: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4342: END IF;
4343:
4344: -- Populate pa_proj_element_version table

Line 4341: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4337: BULK COLLECT INTO l_proj_element_id_tbl ;
4338:
4339: IF l_debug_mode = 'Y' THEN
4340: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENT_VERSIONS ';
4341: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4342: END IF;
4343:
4344: -- Populate pa_proj_element_version table
4345: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST

Line 4380: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEM_VER_SCHEDULE ';

4376: RETURNING element_version_id
4377: BULK COLLECT INTO l_target_element_ver_id_tbl ;
4378:
4379: IF l_debug_mode = 'Y' THEN
4380: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEM_VER_SCHEDULE ';
4381: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4382: END IF;
4383:
4384:

Line 4381: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4377: BULK COLLECT INTO l_target_element_ver_id_tbl ;
4378:
4379: IF l_debug_mode = 'Y' THEN
4380: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEM_VER_SCHEDULE ';
4381: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4382: END IF;
4383:
4384:
4385: -- Populate pa_proj_elem_ver_schedule table

Line 4427: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS ';

4423: ,'PA_PROJECTS'
4424: ) ;
4425:
4426: IF l_debug_mode = 'Y' THEN
4427: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS ';
4428: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4429: END IF;
4430:
4431:

Line 4428: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4424: ) ;
4425:
4426: IF l_debug_mode = 'Y' THEN
4427: pa_debug.g_err_stage:= 'Populating PA_OBJECT_RELATIONSHIPS ';
4428: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4429: END IF;
4430:
4431:
4432: -- populate the object relationships table for STRUCTURE_TO_DELIVERABLE

Line 4634: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.COPY_ACTIONS';

4630:
4631: IF (nvl(p_dlv_actions_flag,'N') = 'Y' OR p_calling_context = 'COPY_PROJECT') THEN
4632:
4633: IF l_debug_mode = 'Y' THEN
4634: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.COPY_ACTIONS';
4635: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4636: END IF;
4637: PA_ACTIONS_PUB.COPY_ACTIONS
4638: (p_api_version => p_api_version

Line 4635: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

4631: IF (nvl(p_dlv_actions_flag,'N') = 'Y' OR p_calling_context = 'COPY_PROJECT') THEN
4632:
4633: IF l_debug_mode = 'Y' THEN
4634: pa_debug.g_err_stage:= 'Calling PA_ACTIONS_PUB.COPY_ACTIONS';
4635: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4636: END IF;
4637: PA_ACTIONS_PUB.COPY_ACTIONS
4638: (p_api_version => p_api_version
4639: ,p_init_msg_list => p_init_msg_list

Line 4719: pa_debug.g_err_stage:= 'Project Type is :'||l_project_type ;

4715: FETCH c_project_details INTO l_project_type,l_status_code,l_project_sys_status_code, l_project_number ;
4716: CLOSE c_project_details;
4717:
4718: IF p_debug_mode = 'Y' THEN
4719: pa_debug.g_err_stage:= 'Project Type is :'||l_project_type ;
4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408

Line 4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4716: CLOSE c_project_details;
4717:
4718: IF p_debug_mode = 'Y' THEN
4719: pa_debug.g_err_stage:= 'Project Type is :'||l_project_type ;
4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408
4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;

Line 4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;

4717:
4718: IF p_debug_mode = 'Y' THEN
4719: pa_debug.g_err_stage:= 'Project Type is :'||l_project_type ;
4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408
4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;
4725: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

Line 4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4718: IF p_debug_mode = 'Y' THEN
4719: pa_debug.g_err_stage:= 'Project Type is :'||l_project_type ;
4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408
4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;
4725: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4726: END IF;

Line 4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;

4720: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408
4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;
4725: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4726: END IF;
4727:
4728: --Check whether the project's system status code is Approved

Line 4725: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4721: pa_debug.g_err_stage:= 'Project Status Code is :'||l_status_code ;
4722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4723: -- added for bug# 3671408
4724: pa_debug.g_err_stage:= 'Project System Status Code is :'||l_project_sys_status_code ;
4725: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4726: END IF;
4727:
4728: --Check whether the project's system status code is Approved
4729: IF nvl(l_project_sys_status_code,'-99') = 'APPROVED' THEN

Line 4746: pa_debug.g_err_stage:= 'The Error Code is ' ||l_err_code ;

4742: --Workflow is NOT coupled to changing statues.
4743: -- So, the x_err_code for the aforementioned Check_Wf_Enabled
4744: --- is IGNORED if x_err_code > 0.
4745: IF p_debug_mode = 'Y' THEN
4746: pa_debug.g_err_stage:= 'The Error Code is ' ||l_err_code ;
4747: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4748: pa_debug.g_err_stage:= 'The Workflow Enabled Flag is ' ||l_wf_enabled_flag ;
4749: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4750: END IF;

Line 4747: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4743: -- So, the x_err_code for the aforementioned Check_Wf_Enabled
4744: --- is IGNORED if x_err_code > 0.
4745: IF p_debug_mode = 'Y' THEN
4746: pa_debug.g_err_stage:= 'The Error Code is ' ||l_err_code ;
4747: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4748: pa_debug.g_err_stage:= 'The Workflow Enabled Flag is ' ||l_wf_enabled_flag ;
4749: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4750: END IF;
4751:

Line 4748: pa_debug.g_err_stage:= 'The Workflow Enabled Flag is ' ||l_wf_enabled_flag ;

4744: --- is IGNORED if x_err_code > 0.
4745: IF p_debug_mode = 'Y' THEN
4746: pa_debug.g_err_stage:= 'The Error Code is ' ||l_err_code ;
4747: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4748: pa_debug.g_err_stage:= 'The Workflow Enabled Flag is ' ||l_wf_enabled_flag ;
4749: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4750: END IF;
4751:
4752: IF (l_err_code > 0) THEN

Line 4749: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4745: IF p_debug_mode = 'Y' THEN
4746: pa_debug.g_err_stage:= 'The Error Code is ' ||l_err_code ;
4747: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4748: pa_debug.g_err_stage:= 'The Workflow Enabled Flag is ' ||l_wf_enabled_flag ;
4749: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4750: END IF;
4751:
4752: IF (l_err_code > 0) THEN
4753: l_err_code := 0;

Line 4784: pa_debug.g_err_stage:= 'Exiting COPY_DELIVERABLES' ;

4780:
4781: End of Commenting for Bug 3819086 */
4782:
4783: IF p_debug_mode = 'Y' THEN
4784: pa_debug.g_err_stage:= 'Exiting COPY_DELIVERABLES' ;
4785: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4786: pa_debug.reset_curr_function;
4787: END IF;
4788:

Line 4785: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

4781: End of Commenting for Bug 3819086 */
4782:
4783: IF p_debug_mode = 'Y' THEN
4784: pa_debug.g_err_stage:= 'Exiting COPY_DELIVERABLES' ;
4785: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4786: pa_debug.reset_curr_function;
4787: END IF;
4788:
4789: EXCEPTION

Line 4786: pa_debug.reset_curr_function;

4782:
4783: IF p_debug_mode = 'Y' THEN
4784: pa_debug.g_err_stage:= 'Exiting COPY_DELIVERABLES' ;
4785: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4786: pa_debug.reset_curr_function;
4787: END IF;
4788:
4789: EXCEPTION
4790: WHEN Invalid_Arg_Exc_Dlv THEN

Line 4795: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';

4791: x_return_status := FND_API.G_RET_STS_ERROR;
4792: l_msg_count := FND_MSG_PUB.count_msg;
4793:
4794: IF l_debug_mode = 'Y' THEN
4795: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';
4796: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
4797: END IF;
4798:
4799: IF l_msg_count = 1 THEN

Line 4796: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

4792: l_msg_count := FND_MSG_PUB.count_msg;
4793:
4794: IF l_debug_mode = 'Y' THEN
4795: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';
4796: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
4797: END IF;
4798:
4799: IF l_msg_count = 1 THEN
4800: PA_INTERFACE_UTILS_PUB.get_messages

Line 4813: pa_debug.reset_curr_function;

4809: ELSE
4810: x_msg_count := l_msg_count;
4811: END IF;
4812: IF l_debug_mode = 'Y' THEN
4813: pa_debug.reset_curr_function;
4814: END IF ;
4815: RETURN;
4816: WHEN OTHERS THEN
4817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4825: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

4821: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
4822: ,p_procedure_name => 'COPY_DELIVERABLES');
4823:
4824: IF p_debug_mode = 'Y' THEN
4825: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4826: pa_debug.write('COPY_DELIVERABLES: ' || g_module_name,pa_debug.g_err_stage,5);
4827: pa_debug.reset_curr_function;
4828: END IF;
4829: RAISE;

Line 4826: pa_debug.write('COPY_DELIVERABLES: ' || g_module_name,pa_debug.g_err_stage,5);

4822: ,p_procedure_name => 'COPY_DELIVERABLES');
4823:
4824: IF p_debug_mode = 'Y' THEN
4825: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4826: pa_debug.write('COPY_DELIVERABLES: ' || g_module_name,pa_debug.g_err_stage,5);
4827: pa_debug.reset_curr_function;
4828: END IF;
4829: RAISE;
4830: END COPY_DELIVERABLES ;

Line 4827: pa_debug.reset_curr_function;

4823:
4824: IF p_debug_mode = 'Y' THEN
4825: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4826: pa_debug.write('COPY_DELIVERABLES: ' || g_module_name,pa_debug.g_err_stage,5);
4827: pa_debug.reset_curr_function;
4828: END IF;
4829: RAISE;
4830: END COPY_DELIVERABLES ;
4831: