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

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

181: BEGIN
182:
183: x_msg_count := 0;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
186:
187: IF l_debug_mode = 'Y' THEN
188: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',
189: p_debug_mode => l_debug_mode );

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

184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
186:
187: IF l_debug_mode = 'Y' THEN
188: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',
189: p_debug_mode => l_debug_mode );
190: END IF;
191:
192: /*==============3435905 : FP M : Deliverables Changes For AMG - START ==============================*/

Line 250: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);

246: FROM Pa_Projects_All
247: WHERE project_id = p_project_id;
248:
249: IF l_debug_mode = 'Y' THEN
250: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);
251: END IF;
252:
253: /*==============3435905 : FP M : Deliverables Changes For AMG - END ============================== */
254: IF l_debug_mode = 'Y' THEN

Line 255: Pa_Debug.g_err_stage:= 'CREATE_DELIVERABLE : Printing Input parameters';

251: END IF;
252:
253: /*==============3435905 : FP M : Deliverables Changes For AMG - END ============================== */
254: IF l_debug_mode = 'Y' THEN
255: Pa_Debug.g_err_stage:= 'CREATE_DELIVERABLE : Printing Input parameters';
256: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
257: l_debug_level3);
258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
259: l_debug_level3);

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

252:
253: /*==============3435905 : FP M : Deliverables Changes For AMG - END ============================== */
254: IF l_debug_mode = 'Y' THEN
255: Pa_Debug.g_err_stage:= 'CREATE_DELIVERABLE : Printing Input parameters';
256: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
257: l_debug_level3);
258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
259: l_debug_level3);
260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,

Line 258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,

254: IF l_debug_mode = 'Y' THEN
255: Pa_Debug.g_err_stage:= 'CREATE_DELIVERABLE : Printing Input parameters';
256: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
257: l_debug_level3);
258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
259: l_debug_level3);
260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
261: l_debug_level3);
262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,

Line 260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,

256: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
257: l_debug_level3);
258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
259: l_debug_level3);
260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
261: l_debug_level3);
262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
263: l_debug_level3);
264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,

Line 262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,

258: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
259: l_debug_level3);
260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
261: l_debug_level3);
262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
263: l_debug_level3);
264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
265: l_debug_level3);
266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,

Line 264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,

260: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
261: l_debug_level3);
262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
263: l_debug_level3);
264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
265: l_debug_level3);
266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
267: l_debug_level3);
268: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,

Line 266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,

262: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
263: l_debug_level3);
264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
265: l_debug_level3);
266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
267: l_debug_level3);
268: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
269: l_debug_level3);
270: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,

Line 268: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,

264: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
265: l_debug_level3);
266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
267: l_debug_level3);
268: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
269: l_debug_level3);
270: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,
271: l_debug_level3);
272: END IF;

Line 270: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,

266: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
267: l_debug_level3);
268: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
269: l_debug_level3);
270: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,
271: l_debug_level3);
272: END IF;
273:
274: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 283: Pa_Debug.g_err_stage:= 'Validating Input parameters';

279: savepoint CREATE_DLVR_PUB;
280: END IF;
281:
282: IF l_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Validating Input parameters';
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
285: l_debug_level3);
286: END IF;
287:

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

280: END IF;
281:
282: IF l_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Validating Input parameters';
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
285: l_debug_level3);
286: END IF;
287:
288: -- Input parameter Validation Logic

Line 325: pa_debug.g_err_stage := 'Validated deliverable returns ['||x_return_status||']';

321: , x_msg_data => x_msg_data
322: );
323:
324: IF p_debug_mode = 'Y' THEN
325: pa_debug.g_err_stage := 'Validated deliverable returns ['||x_return_status||']';
326: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

322: );
323:
324: IF p_debug_mode = 'Y' THEN
325: pa_debug.g_err_stage := 'Validated deliverable returns ['||x_return_status||']';
326: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
327: END IF;
328:
329: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 372: Pa_Debug.WRITE(g_module_name,' Retrieving Carrying Out Organization Information ',

368: END IF;
369: -- Business Logic
370:
371: IF l_debug_mode = 'Y' THEN
372: Pa_Debug.WRITE(g_module_name,' Retrieving Carrying Out Organization Information ',
373: l_debug_level3);
374: END IF;
375:
376: IF l_debug_mode = 'Y' THEN

Line 377: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_carrying_out_org called ',

373: l_debug_level3);
374: END IF;
375:
376: IF l_debug_mode = 'Y' THEN
377: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_carrying_out_org called ',
378: l_debug_level3);
379: END IF;
380:
381: -- retrieve carrying_out_organization_id

Line 398: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',

394: RAISE Invalid_Arg_Exc_WP;
395: END IF;
396:
397: IF l_debug_mode = 'Y' THEN
398: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',
399: l_debug_level3);
400: END IF;
401:
402: IF l_debug_mode = 'Y' THEN

Line 403: Pa_Debug.WRITE(g_module_name,' Retrieving Structure Information ',

399: l_debug_level3);
400: END IF;
401:
402: IF l_debug_mode = 'Y' THEN
403: Pa_Debug.WRITE(g_module_name,' Retrieving Structure Information ',
404: l_debug_level3);
405: END IF;
406:
407: IF l_debug_mode = 'Y' THEN

Line 408: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',

404: l_debug_level3);
405: END IF;
406:
407: IF l_debug_mode = 'Y' THEN
408: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',
409: l_debug_level3);
410: END IF;
411:
412: -- retrieve structure information

Line 426: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',

422: ,x_msg_data => x_msg_data
423: );
424:
425: IF l_debug_mode = 'Y' THEN
426: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',
427: l_debug_level3);
428: END IF;
429:
430:

Line 440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',

436:
437: -- call PA_DELIVERABLE_UTILS.get_dlvr_type_info to retrieve default status code
438:
439: IF l_debug_mode = 'Y' THEN
440: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_dlvr_type_info called ',
441: l_debug_level3);
442: END IF;
443:
444: PA_DELIVERABLE_UTILS.get_dlvr_type_info

Line 453: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_dlvr_type_info ',

449: x_dlvr_default_status_code => l_status_code
450: );
451:
452: IF l_debug_mode = 'Y' THEN
453: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_dlvr_type_info ',
454: l_debug_level3);
455: END IF;
456:
457: END IF;

Line 461: Pa_Debug.WRITE(g_module_name,' Checking Uniqueness for Deliverable Number ',

457: END IF;
458:
459:
460: IF l_debug_mode = 'Y' THEN
461: Pa_Debug.WRITE(g_module_name,' Checking Uniqueness for Deliverable Number ',
462: l_debug_level3);
463: END IF;
464:
465: -- check for dlvr_number uniqueness

Line 477: Pa_Debug.WRITE(g_module_name,' Dlvr Num Unique['||p_dlvr_number||']['||is_dlvr_number_unique||']', l_debug_level3);

473: ,p_structure_id => l_structure_id
474: ,p_object_type => p_object_type
475: );
476: IF l_debug_mode = 'Y' THEN
477: Pa_Debug.WRITE(g_module_name,' Dlvr Num Unique['||p_dlvr_number||']['||is_dlvr_number_unique||']', l_debug_level3);
478: END IF;
479: -- if is_dlvr_number_unique is 'N' return with error
480:
481: IF (is_dlvr_number_unique = 'N' ) THEN

Line 510: Pa_Debug.WRITE(g_module_name,' Calling PA_DELIVERABLE_PVT.Create_Deliverable',

506:
507: -- else call create_deliveable procedure of pa_deliveable_pvt package
508:
509: IF l_debug_mode = 'Y' THEN
510: Pa_Debug.WRITE(g_module_name,' Calling PA_DELIVERABLE_PVT.Create_Deliverable',
511: l_debug_level3);
512: END IF;
513:
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 575: Pa_Debug.WRITE(g_module_name,' Returned from PA_DELIVERABLE_PVT.Create_Deliverable['||x_return_status||']',

571: ,x_msg_data => l_msg_data
572: );
573:
574: IF l_debug_mode = 'Y' THEN
575: Pa_Debug.WRITE(g_module_name,' Returned from PA_DELIVERABLE_PVT.Create_Deliverable['||x_return_status||']',
576: l_debug_level3);
577: END IF;
578:
579: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 688: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']',

684:
685: END IF;
686:
687: IF l_debug_mode = 'Y' THEN
688: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']',
689: l_debug_level3);
690: END IF;
691:
692: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 707: pa_debug.reset_curr_function;

703: COMMIT;
704: END IF;
705:
706: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
707: pa_debug.reset_curr_function;
708: END IF ;
709:
710: EXCEPTION
711:

Line 736: Pa_Debug.reset_curr_function;

732: ELSE
733: x_msg_count := l_msg_count;
734: END IF;
735: IF l_debug_mode = 'Y' THEN
736: Pa_Debug.reset_curr_function;
737: END IF;
738:
739: WHEN Invalid_Arg_Exc_WP THEN
740:

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

751: , p_procedure_name => 'Create_Deliverable'
752: , p_error_text => x_msg_data);
753:
754: IF l_debug_mode = 'Y' THEN
755: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
756: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
757: l_debug_level5);
758: Pa_Debug.reset_curr_function;
759: END IF;

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

752: , p_error_text => x_msg_data);
753:
754: IF l_debug_mode = 'Y' THEN
755: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
756: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
757: l_debug_level5);
758: Pa_Debug.reset_curr_function;
759: END IF;
760: RAISE;

Line 758: Pa_Debug.reset_curr_function;

754: IF l_debug_mode = 'Y' THEN
755: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
756: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
757: l_debug_level5);
758: Pa_Debug.reset_curr_function;
759: END IF;
760: RAISE;
761:
762: WHEN OTHERS THEN

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

774: , p_procedure_name => 'Create_Deliverable'
775: , p_error_text => x_msg_data);
776:
777: IF l_debug_mode = 'Y' THEN
778: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
779: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
780: l_debug_level5);
781: Pa_Debug.reset_curr_function;
782: END IF;

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

775: , p_error_text => x_msg_data);
776:
777: IF l_debug_mode = 'Y' THEN
778: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
779: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
780: l_debug_level5);
781: Pa_Debug.reset_curr_function;
782: END IF;
783: RAISE;

Line 781: Pa_Debug.reset_curr_function;

777: IF l_debug_mode = 'Y' THEN
778: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
779: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
780: l_debug_level5);
781: Pa_Debug.reset_curr_function;
782: END IF;
783: RAISE;
784:
785: END Create_Deliverable;

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

987: BEGIN
988:
989: x_msg_count := 0;
990: x_return_status := FND_API.G_RET_STS_SUCCESS;
991: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
992:
993: IF l_debug_mode = 'Y' THEN
994: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',
995: p_debug_mode => l_debug_mode );

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

990: x_return_status := FND_API.G_RET_STS_SUCCESS;
991: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
992:
993: IF l_debug_mode = 'Y' THEN
994: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',
995: p_debug_mode => l_debug_mode );
996: END IF;
997:
998: IF l_debug_mode = 'Y' THEN

Line 999: Pa_Debug.g_err_stage:= 'UPDATE_DELIVERABLE : Printing Input parameters';

995: p_debug_mode => l_debug_mode );
996: END IF;
997:
998: IF l_debug_mode = 'Y' THEN
999: Pa_Debug.g_err_stage:= 'UPDATE_DELIVERABLE : Printing Input parameters';
1000: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1001: l_debug_level3);
1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1003: l_debug_level3);

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

996: END IF;
997:
998: IF l_debug_mode = 'Y' THEN
999: Pa_Debug.g_err_stage:= 'UPDATE_DELIVERABLE : Printing Input parameters';
1000: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1001: l_debug_level3);
1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1003: l_debug_level3);
1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,

Line 1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,

998: IF l_debug_mode = 'Y' THEN
999: Pa_Debug.g_err_stage:= 'UPDATE_DELIVERABLE : Printing Input parameters';
1000: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1001: l_debug_level3);
1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1003: l_debug_level3);
1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
1005: l_debug_level3);
1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,

Line 1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,

1000: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1001: l_debug_level3);
1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1003: l_debug_level3);
1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
1005: l_debug_level3);
1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
1007: l_debug_level3);
1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,

Line 1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,

1002: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1003: l_debug_level3);
1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
1005: l_debug_level3);
1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
1007: l_debug_level3);
1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
1009: l_debug_level3);
1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,

Line 1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,

1004: Pa_Debug.WRITE(g_module_name,' P_DLVR_NUMBER '||':'|| p_dlvr_number,
1005: l_debug_level3);
1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
1007: l_debug_level3);
1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
1009: l_debug_level3);
1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
1011: l_debug_level3);
1012: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,

Line 1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,

1006: Pa_Debug.WRITE(g_module_name,' P_DLVR_NAME '||':'|| p_dlvr_name,
1007: l_debug_level3);
1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
1009: l_debug_level3);
1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
1011: l_debug_level3);
1012: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
1013: l_debug_level3);
1014: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,

Line 1012: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,

1008: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_ID '||':'|| p_dlvr_type_id,
1009: l_debug_level3);
1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
1011: l_debug_level3);
1012: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
1013: l_debug_level3);
1014: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,
1015: l_debug_level3);
1016: END IF;

Line 1014: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,

1010: Pa_Debug.WRITE(g_module_name,' P_DLVR_TYPE_NAME '||':'|| p_dlvr_type_name,
1011: l_debug_level3);
1012: Pa_Debug.WRITE(g_module_name,' P_TASK_VERSION_ID '||':'|| p_task_version_id,
1013: l_debug_level3);
1014: Pa_Debug.WRITE(g_module_name,' P_TASK_NAME '||':'|| p_task_name,
1015: l_debug_level3);
1016: END IF;
1017:
1018: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 1027: Pa_Debug.g_err_stage:= 'Validating Input parameters';

1023: savepoint UPDATE_DLVR_PUB;
1024: END IF;
1025:
1026: IF l_debug_mode = 'Y' THEN
1027: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1028: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1029: l_debug_level3);
1030: END IF;
1031:

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

1024: END IF;
1025:
1026: IF l_debug_mode = 'Y' THEN
1027: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1028: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1029: l_debug_level3);
1030: END IF;
1031:
1032: -- Input parameter Validation Logic

Line 1165: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',

1161: RAISE Invalid_Arg_Exc_WP;
1162: END IF;
1163:
1164: IF l_debug_mode = 'Y' THEN
1165: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_carrying_out_org ',
1166: l_debug_level3);
1167: END IF;
1168:
1169: IF l_debug_mode = 'Y' THEN

Line 1170: Pa_Debug.WRITE(g_module_name,' Retrieving Structure Information ',

1166: l_debug_level3);
1167: END IF;
1168:
1169: IF l_debug_mode = 'Y' THEN
1170: Pa_Debug.WRITE(g_module_name,' Retrieving Structure Information ',
1171: l_debug_level3);
1172: END IF;
1173:
1174: IF l_debug_mode = 'Y' THEN

Line 1175: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',

1171: l_debug_level3);
1172: END IF;
1173:
1174: IF l_debug_mode = 'Y' THEN
1175: Pa_Debug.WRITE(g_module_name,' PA_DELIVERABLE_UTILS.get_structure_info called ',
1176: l_debug_level3);
1177: END IF;
1178:
1179: -- retrieve structure information

Line 1193: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',

1189: ,x_msg_data => x_msg_data
1190: );
1191:
1192: IF l_debug_mode = 'Y' THEN
1193: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_UTILS.get_structure_info ',
1194: l_debug_level3);
1195: END IF;
1196:
1197: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1202: Pa_Debug.WRITE(g_module_name,' Checking Uniqueness for Deliverable Number ',

1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:
1201: IF l_debug_mode = 'Y' THEN
1202: Pa_Debug.WRITE(g_module_name,' Checking Uniqueness for Deliverable Number ',
1203: l_debug_level3);
1204: END IF;
1205:
1206: -- check for dlvr_number uniqueness

Line 1232: Pa_Debug.WRITE(g_module_name,' Deliverable Number is unique',

1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: IF l_debug_mode = 'Y' THEN
1232: Pa_Debug.WRITE(g_module_name,' Deliverable Number is unique',
1233: l_debug_level3);
1234: END IF;
1235:
1236: IF l_debug_mode = 'Y' THEN

Line 1237: Pa_Debug.WRITE(g_module_name,' Calling PA_DELIVERABLE_PVT.Update_Deliverable',

1233: l_debug_level3);
1234: END IF;
1235:
1236: IF l_debug_mode = 'Y' THEN
1237: Pa_Debug.WRITE(g_module_name,' Calling PA_DELIVERABLE_PVT.Update_Deliverable',
1238: l_debug_level3);
1239: END IF;
1240:
1241: PA_DELIVERABLE_PVT.Update_Deliverable

Line 1298: Pa_Debug.WRITE(g_module_name,' Returned from PA_DELIVERABLE_PVT.Update_Deliverable',

1294: ,x_msg_data => l_msg_data
1295: );
1296:
1297: IF l_debug_mode = 'Y' THEN
1298: Pa_Debug.WRITE(g_module_name,' Returned from PA_DELIVERABLE_PVT.Update_Deliverable',
1299: l_debug_level3);
1300: END IF;
1301:
1302:

Line 1410: pa_debug.reset_curr_function;

1406: COMMIT;
1407: END IF;
1408:
1409: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
1410: pa_debug.reset_curr_function;
1411: END IF ;
1412:
1413: EXCEPTION
1414:

Line 1439: Pa_Debug.reset_curr_function;

1435: ELSE
1436: x_msg_count := l_msg_count;
1437: END IF;
1438: IF l_debug_mode = 'Y' THEN
1439: Pa_Debug.reset_curr_function;
1440: END IF;
1441:
1442: WHEN Invalid_Arg_Exc_WP THEN
1443:

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

1454: , p_procedure_name => 'Update_Deliverable'
1455: , p_error_text => x_msg_data);
1456:
1457: IF l_debug_mode = 'Y' THEN
1458: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1459: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1460: l_debug_level5);
1461: Pa_Debug.reset_curr_function;
1462: END IF;

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

1455: , p_error_text => x_msg_data);
1456:
1457: IF l_debug_mode = 'Y' THEN
1458: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1459: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1460: l_debug_level5);
1461: Pa_Debug.reset_curr_function;
1462: END IF;
1463: RAISE;

Line 1461: Pa_Debug.reset_curr_function;

1457: IF l_debug_mode = 'Y' THEN
1458: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1459: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1460: l_debug_level5);
1461: Pa_Debug.reset_curr_function;
1462: END IF;
1463: RAISE;
1464:
1465: WHEN OTHERS THEN

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

1477: , p_procedure_name => 'Update_Deliverable'
1478: , p_error_text => x_msg_data);
1479:
1480: IF l_debug_mode = 'Y' THEN
1481: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1482: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1483: l_debug_level5);
1484: Pa_Debug.reset_curr_function;
1485: END IF;

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

1478: , p_error_text => x_msg_data);
1479:
1480: IF l_debug_mode = 'Y' THEN
1481: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1482: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1483: l_debug_level5);
1484: Pa_Debug.reset_curr_function;
1485: END IF;
1486: RAISE;

Line 1484: Pa_Debug.reset_curr_function;

1480: IF l_debug_mode = 'Y' THEN
1481: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1482: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1483: l_debug_level5);
1484: Pa_Debug.reset_curr_function;
1485: END IF;
1486: RAISE;
1487:
1488: END Update_Deliverable;

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

1548: BEGIN
1549:
1550: x_msg_count := 0;
1551: x_return_status := FND_API.G_RET_STS_SUCCESS;
1552: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1553:
1554: IF l_debug_mode = 'Y' THEN
1555: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
1556: p_debug_mode => l_debug_mode );

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

1551: x_return_status := FND_API.G_RET_STS_SUCCESS;
1552: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1553:
1554: IF l_debug_mode = 'Y' THEN
1555: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
1556: p_debug_mode => l_debug_mode );
1557: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
1558: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1559: END IF;

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

1553:
1554: IF l_debug_mode = 'Y' THEN
1555: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
1556: p_debug_mode => l_debug_mode );
1557: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
1558: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1559: END IF;
1560:
1561: IF l_debug_mode = 'Y' THEN

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

1554: IF l_debug_mode = 'Y' THEN
1555: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
1556: p_debug_mode => l_debug_mode );
1557: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
1558: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1559: END IF;
1560:
1561: IF l_debug_mode = 'Y' THEN
1562: pa_debug.g_err_stage:= 'Printing Input parameters';

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

1558: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1559: END IF;
1560:
1561: IF l_debug_mode = 'Y' THEN
1562: pa_debug.g_err_stage:= 'Printing Input parameters';
1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;

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

1559: END IF;
1560:
1561: IF l_debug_mode = 'Y' THEN
1562: pa_debug.g_err_stage:= 'Printing Input parameters';
1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;

Line 1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;

1560:
1561: IF l_debug_mode = 'Y' THEN
1562: pa_debug.g_err_stage:= 'Printing Input parameters';
1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;

Line 1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;

1561: IF l_debug_mode = 'Y' THEN
1562: pa_debug.g_err_stage:= 'Printing Input parameters';
1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;
1569: END IF;

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

1562: pa_debug.g_err_stage:= 'Printing Input parameters';
1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;
1569: END IF;
1570:

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

1563: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;
1569: END IF;
1570:
1571: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;

1564: pa_debug.write(g_module_name,'p_task_element_id '||':'||p_task_element_id,3) ;
1565: pa_debug.write(g_module_name,'p_task_version_id'||':'||p_task_version_id,3) ;
1566: pa_debug.write(g_module_name,'p_dlv_element_id '||':'||p_dlv_element_id,3) ;
1567: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;
1569: END IF;
1570:
1571: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1572: FND_MSG_PUB.initialize;

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

1576: savepoint DEL_DLV_TASK_ASSCN_PUB_SP ;
1577: END IF;
1578:
1579: IF l_debug_mode = 'Y' THEN
1580: pa_debug.g_err_stage:= 'Validating Input parameters';
1581: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1582: END IF;
1583:
1584: IF (p_dlv_element_id IS NULL OR p_dlv_element_id IS NULL ) OR

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

1577: END IF;
1578:
1579: IF l_debug_mode = 'Y' THEN
1580: pa_debug.g_err_stage:= 'Validating Input parameters';
1581: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1582: END IF;
1583:
1584: IF (p_dlv_element_id IS NULL OR p_dlv_element_id IS NULL ) OR
1585: (p_task_element_id IS NULL OR p_task_version_id IS NULL)

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

1584: IF (p_dlv_element_id IS NULL OR p_dlv_element_id IS NULL ) OR
1585: (p_task_element_id IS NULL OR p_task_version_id IS NULL)
1586: THEN
1587: IF l_debug_mode = 'Y' THEN
1588: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1589: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1590: END IF;
1591:
1592: x_return_status := FND_API.G_RET_STS_ERROR;

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

1585: (p_task_element_id IS NULL OR p_task_version_id IS NULL)
1586: THEN
1587: IF l_debug_mode = 'Y' THEN
1588: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1589: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1590: END IF;
1591:
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 1599: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_TASK_ASSOCIATION ';

1595: RAISE Invalid_Arg_Exc_Dlv;
1596: END IF;
1597:
1598: IF l_debug_mode = 'Y' THEN
1599: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_TASK_ASSOCIATION ';
1600: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1601: END IF;
1602:
1603: -- Call PA_DELIVERAB_PVT.DELETE_DLV_TASK_ASSOCIATION

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

1596: END IF;
1597:
1598: IF l_debug_mode = 'Y' THEN
1599: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_TASK_ASSOCIATION ';
1600: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1601: END IF;
1602:
1603: -- Call PA_DELIVERAB_PVT.DELETE_DLV_TASK_ASSOCIATION
1604: PA_DELIVERABLE_PVT.DELETE_DLV_TASK_ASSOCIATION

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

1627: RAISE Invalid_Arg_Exc_Dlv ;
1628: END IF ;
1629:
1630: IF l_debug_mode = 'Y' THEN
1631: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
1632: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1633: pa_debug.reset_curr_function;
1634: END IF;
1635:

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

1628: END IF ;
1629:
1630: IF l_debug_mode = 'Y' THEN
1631: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
1632: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1633: pa_debug.reset_curr_function;
1634: END IF;
1635:
1636: EXCEPTION

Line 1633: pa_debug.reset_curr_function;

1629:
1630: IF l_debug_mode = 'Y' THEN
1631: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSOCIATION' ;
1632: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1633: pa_debug.reset_curr_function;
1634: END IF;
1635:
1636: EXCEPTION
1637: WHEN Invalid_Arg_Exc_Dlv THEN

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

1642: ROLLBACK TO DEL_DLV_TASK_ASSCN_PUB_SP;
1643: END IF ;
1644:
1645: IF l_debug_mode = 'Y' THEN
1646: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSOCIATION';
1647: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1648: END IF;
1649:
1650: IF l_msg_count = 1 THEN

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

1643: END IF ;
1644:
1645: IF l_debug_mode = 'Y' THEN
1646: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSOCIATION';
1647: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1648: END IF;
1649:
1650: IF l_msg_count = 1 THEN
1651: PA_INTERFACE_UTILS_PUB.get_messages

Line 1664: pa_debug.reset_curr_function;

1660: ELSE
1661: x_msg_count := l_msg_count;
1662: END IF;
1663: IF l_debug_mode = 'Y' THEN
1664: pa_debug.reset_curr_function;
1665: END IF ;
1666: RETURN;
1667: WHEN OTHERS THEN
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1676: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
1677: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
1678:
1679: IF p_debug_mode = 'Y' THEN
1680: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1681: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
1682: pa_debug.reset_curr_function;
1683: END IF;
1684: RAISE;

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

1677: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
1678:
1679: IF p_debug_mode = 'Y' THEN
1680: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1681: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
1682: pa_debug.reset_curr_function;
1683: END IF;
1684: RAISE;
1685: END DELETE_DLV_TASK_ASSOCIATION ;

Line 1682: pa_debug.reset_curr_function;

1678:
1679: IF p_debug_mode = 'Y' THEN
1680: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1681: pa_debug.write('DELETE_DLV_TASK_ASSOCIATION: ' || g_module_name,pa_debug.g_err_stage,5);
1682: pa_debug.reset_curr_function;
1683: END IF;
1684: RAISE;
1685: END DELETE_DLV_TASK_ASSOCIATION ;
1686:

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

1752:
1753: BEGIN
1754: l_msg_count := 0;
1755: l_return_status := FND_API.G_RET_STS_SUCCESS;
1756: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1757: j := 0 ;
1758:
1759: IF l_debug_mode = 'Y' THEN
1760: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLES_IN_BULK',

Line 1760: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLES_IN_BULK',

1756: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1757: j := 0 ;
1758:
1759: IF l_debug_mode = 'Y' THEN
1760: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLES_IN_BULK',
1761: p_debug_mode => l_debug_mode );
1762: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLES_IN_BULK ';
1763: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1764: END IF;

Line 1762: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLES_IN_BULK ';

1758:
1759: IF l_debug_mode = 'Y' THEN
1760: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLES_IN_BULK',
1761: p_debug_mode => l_debug_mode );
1762: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLES_IN_BULK ';
1763: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1764: END IF;
1765:
1766: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

1759: IF l_debug_mode = 'Y' THEN
1760: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLES_IN_BULK',
1761: p_debug_mode => l_debug_mode );
1762: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLES_IN_BULK ';
1763: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1764: END IF;
1765:
1766: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1767: FND_MSG_PUB.initialize;

Line 1774: pa_debug.debug('Some row is fetched for deletion');

1770: SAVEPOINT DELETE_DELIVERABLES ;
1771:
1772: IF nvl(p_dlv_element_id_tbl.LAST,0)>0 THEN
1773: IF l_debug_mode = 'Y' THEN
1774: pa_debug.debug('Some row is fetched for deletion');
1775: END IF ;
1776: FOR i in p_dlv_element_id_tbl.FIRST..p_dlv_element_id_tbl.LAST LOOP
1777:
1778: IF l_debug_mode = 'Y' THEN

Line 1779: pa_debug.debug('Deliverable Element Id is :'||p_dlv_element_id_tbl(i));

1775: END IF ;
1776: FOR i in p_dlv_element_id_tbl.FIRST..p_dlv_element_id_tbl.LAST LOOP
1777:
1778: IF l_debug_mode = 'Y' THEN
1779: pa_debug.debug('Deliverable Element Id is :'||p_dlv_element_id_tbl(i));
1780: pa_debug.debug('record version id is :'||p_rec_ver_number_tbl(i));
1781: END IF ;
1782:
1783: -- initialization is required for every loop

Line 1780: pa_debug.debug('record version id is :'||p_rec_ver_number_tbl(i));

1776: FOR i in p_dlv_element_id_tbl.FIRST..p_dlv_element_id_tbl.LAST LOOP
1777:
1778: IF l_debug_mode = 'Y' THEN
1779: pa_debug.debug('Deliverable Element Id is :'||p_dlv_element_id_tbl(i));
1780: pa_debug.debug('record version id is :'||p_rec_ver_number_tbl(i));
1781: END IF ;
1782:
1783: -- initialization is required for every loop
1784: l_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1858: pa_debug.reset_curr_function;

1854: x_return_status := 'E' ;
1855: END IF ;
1856:
1857: IF l_debug_mode = 'Y' THEN
1858: pa_debug.reset_curr_function;
1859: END IF ;
1860:
1861: EXCEPTION
1862: WHEN OTHERS THEN

Line 1872: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,SQLERRM,4);

1868: FND_MSG_PUB.add_exc_msg
1869: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
1870: ,p_procedure_name => 'DELETE_DELIVERABLES_IN_BULK' );
1871: IF l_debug_mode = 'Y' THEN
1872: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,SQLERRM,4);
1873: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
1874: pa_debug.reset_curr_function;
1875: END IF;
1876: RAISE ;

Line 1873: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);

1869: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
1870: ,p_procedure_name => 'DELETE_DELIVERABLES_IN_BULK' );
1871: IF l_debug_mode = 'Y' THEN
1872: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,SQLERRM,4);
1873: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
1874: pa_debug.reset_curr_function;
1875: END IF;
1876: RAISE ;
1877: END DELETE_DELIVERABLES_IN_BULK ;

Line 1874: pa_debug.reset_curr_function;

1870: ,p_procedure_name => 'DELETE_DELIVERABLES_IN_BULK' );
1871: IF l_debug_mode = 'Y' THEN
1872: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,SQLERRM,4);
1873: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);
1874: pa_debug.reset_curr_function;
1875: END IF;
1876: RAISE ;
1877: END DELETE_DELIVERABLES_IN_BULK ;
1878:

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

1953:
1954: BEGIN
1955: l_msg_count := 0;
1956: x_return_status := FND_API.G_RET_STS_SUCCESS;
1957: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1958:
1959: IF l_debug_mode = 'Y' THEN
1960: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK',
1961: p_debug_mode => l_debug_mode );

Line 1960: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK',

1956: x_return_status := FND_API.G_RET_STS_SUCCESS;
1957: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1958:
1959: IF l_debug_mode = 'Y' THEN
1960: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK',
1961: p_debug_mode => l_debug_mode );
1962: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1964: END IF;

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

1958:
1959: IF l_debug_mode = 'Y' THEN
1960: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK',
1961: p_debug_mode => l_debug_mode );
1962: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1964: END IF;
1965:
1966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

1959: IF l_debug_mode = 'Y' THEN
1960: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK',
1961: p_debug_mode => l_debug_mode );
1962: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1964: END IF;
1965:
1966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1967: FND_MSG_PUB.initialize;

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

1973:
1974: IF (p_task_or_dlv IS NULL OR p_task_or_dlv_elt_id IS NULL OR p_task_or_dlv_ver_id IS NULL )
1975: THEN
1976: IF l_debug_mode = 'Y' THEN
1977: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_ERROR;

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

1974: IF (p_task_or_dlv IS NULL OR p_task_or_dlv_elt_id IS NULL OR p_task_or_dlv_ver_id IS NULL )
1975: THEN
1976: IF l_debug_mode = 'Y' THEN
1977: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1978: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_ERROR;
1982: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 2016: pa_debug.reset_curr_function;

2012: RAISE Invalid_Arg_Exc_Dlv ;
2013: END IF ;
2014:
2015: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2016: pa_debug.reset_curr_function;
2017: END IF ;
2018:
2019: EXCEPTION
2020: WHEN Invalid_Arg_Exc_Dlv THEN

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

2025: ROLLBACK TO CREATE_ASSOCIATIONS_SP;
2026: END IF ;
2027:
2028: IF l_debug_mode = 'Y' THEN
2029: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2030: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2031: END IF;
2032:
2033: IF l_msg_count = 1 THEN

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

2026: END IF ;
2027:
2028: IF l_debug_mode = 'Y' THEN
2029: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2030: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2031: END IF;
2032:
2033: IF l_msg_count = 1 THEN
2034: PA_INTERFACE_UTILS_PUB.get_messages

Line 2047: pa_debug.reset_curr_function;

2043: ELSE
2044: x_msg_count := l_msg_count;
2045: END IF;
2046: IF l_debug_mode = 'Y' THEN
2047: pa_debug.reset_curr_function;
2048: END IF ;
2049: RETURN;
2050: WHEN OTHERS THEN
2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2059: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
2060: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK');
2061:
2062: IF p_debug_mode = 'Y' THEN
2063: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2064: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2065: pa_debug.reset_curr_function;
2066: END IF;
2067: RAISE;

Line 2064: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

2060: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK');
2061:
2062: IF p_debug_mode = 'Y' THEN
2063: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2064: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2065: pa_debug.reset_curr_function;
2066: END IF;
2067: RAISE;
2068: END CREATE_ASSOCIATIONS_IN_BULK ;

Line 2065: pa_debug.reset_curr_function;

2061:
2062: IF p_debug_mode = 'Y' THEN
2063: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2064: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2065: pa_debug.reset_curr_function;
2066: END IF;
2067: RAISE;
2068: END CREATE_ASSOCIATIONS_IN_BULK ;
2069:

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

2115:
2116: BEGIN
2117: l_msg_count := 0;
2118: l_return_status := FND_API.G_RET_STS_SUCCESS;
2119: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2120:
2121:
2122: IF l_debug_mode = 'Y' THEN
2123: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',

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

2119: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2120:
2121:
2122: IF l_debug_mode = 'Y' THEN
2123: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2124: p_debug_mode => l_debug_mode );
2125: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2126: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2127: END IF;

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

2121:
2122: IF l_debug_mode = 'Y' THEN
2123: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2124: p_debug_mode => l_debug_mode );
2125: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2126: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2127: END IF;
2128:
2129: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

2122: IF l_debug_mode = 'Y' THEN
2123: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2124: p_debug_mode => l_debug_mode );
2125: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2126: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2127: END IF;
2128:
2129: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2130: FND_MSG_PUB.initialize;

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

2136:
2137: IF (p_project_id IS NULL )
2138: THEN
2139: IF l_debug_mode = 'Y' THEN
2140: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2141: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2142: END IF;
2143:
2144: x_return_status := FND_API.G_RET_STS_ERROR;

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

2137: IF (p_project_id IS NULL )
2138: THEN
2139: IF l_debug_mode = 'Y' THEN
2140: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2141: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2142: END IF;
2143:
2144: x_return_status := FND_API.G_RET_STS_ERROR;
2145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 2151: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DELIVERABLE_STRUCTURE';

2147: RAISE Invalid_Arg_Exc_Dlv;
2148: END IF;
2149:
2150: IF l_debug_mode = 'Y' THEN
2151: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DELIVERABLE_STRUCTURE';
2152: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2153: END IF;
2154:
2155: -- Call the pvt API

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

2148: END IF;
2149:
2150: IF l_debug_mode = 'Y' THEN
2151: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DELIVERABLE_STRUCTURE';
2152: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2153: END IF;
2154:
2155: -- Call the pvt API
2156: PA_DELIVERABLE_PVT.DELETE_DELIVERABLE_STRUCTURE

Line 2170: pa_debug.reset_curr_function;

2166: END IF ;
2167:
2168:
2169: IF l_debug_mode = 'Y' THEN
2170: pa_debug.reset_curr_function;
2171: END IF ;
2172: EXCEPTION
2173: WHEN Invalid_Arg_Exc_Dlv THEN
2174: x_return_status := FND_API.G_RET_STS_ERROR;

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

2178: ROLLBACK TO DELETE_DELIVERABLE_STRUCTURE;
2179: END IF ;
2180:
2181: IF l_debug_mode = 'Y' THEN
2182: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';
2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2184: END IF;
2185:
2186: IF l_msg_count = 1 THEN

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

2179: END IF ;
2180:
2181: IF l_debug_mode = 'Y' THEN
2182: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';
2183: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2184: END IF;
2185:
2186: IF l_msg_count = 1 THEN
2187: PA_INTERFACE_UTILS_PUB.get_messages

Line 2200: pa_debug.reset_curr_function;

2196: ELSE
2197: x_msg_count := l_msg_count;
2198: END IF;
2199: IF l_debug_mode = 'Y' THEN
2200: pa_debug.reset_curr_function;
2201: END IF ;
2202: RETURN;
2203: WHEN OTHERS THEN
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2212: FND_MSG_PUB.add_exc_msg
2213: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
2214: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
2215: IF l_debug_mode = 'Y' THEN
2216: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
2217: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
2218: pa_debug.reset_curr_function;
2219: END IF;
2220: RAISE ;

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

2213: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
2214: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
2215: IF l_debug_mode = 'Y' THEN
2216: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
2217: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
2218: pa_debug.reset_curr_function;
2219: END IF;
2220: RAISE ;
2221: END DELETE_DELIVERABLE_STRUCTURE ;

Line 2218: pa_debug.reset_curr_function;

2214: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
2215: IF l_debug_mode = 'Y' THEN
2216: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
2217: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);
2218: pa_debug.reset_curr_function;
2219: END IF;
2220: RAISE ;
2221: END DELETE_DELIVERABLE_STRUCTURE ;
2222:

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

2249: BEGIN
2250:
2251: x_msg_count := 0;
2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2254:
2255: IF l_debug_mode = 'Y' THEN
2256: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSCN_IN_BULK',
2257: p_debug_mode => l_debug_mode );

Line 2256: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSCN_IN_BULK',

2252: x_return_status := FND_API.G_RET_STS_SUCCESS;
2253: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2254:
2255: IF l_debug_mode = 'Y' THEN
2256: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSCN_IN_BULK',
2257: p_debug_mode => l_debug_mode );
2258: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSCN_IN_BULK ';
2259: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2260: END IF;

Line 2258: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSCN_IN_BULK ';

2254:
2255: IF l_debug_mode = 'Y' THEN
2256: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSCN_IN_BULK',
2257: p_debug_mode => l_debug_mode );
2258: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSCN_IN_BULK ';
2259: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2260: END IF;
2261:
2262: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

2255: IF l_debug_mode = 'Y' THEN
2256: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSCN_IN_BULK',
2257: p_debug_mode => l_debug_mode );
2258: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSCN_IN_BULK ';
2259: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2260: END IF;
2261:
2262: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2263: FND_MSG_PUB.initialize;

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

2271: -- IF (p_task_element_id IS NULL OR p_task_version_id IS NULL OR p_project_id IS NULL )
2272: IF (p_task_element_id IS NULL OR p_project_id IS NULL )
2273: THEN
2274: IF l_debug_mode = 'Y' THEN
2275: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2276: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2277: END IF;
2278:
2279: x_return_status := FND_API.G_RET_STS_ERROR;

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

2272: IF (p_task_element_id IS NULL OR p_project_id IS NULL )
2273: THEN
2274: IF l_debug_mode = 'Y' THEN
2275: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2276: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2277: END IF;
2278:
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

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

2305: RAISE Invalid_Arg_Exc_Dlv ;
2306: END IF ;
2307:
2308: IF l_debug_mode = 'Y' THEN
2309: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
2310: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2311: pa_debug.reset_curr_function;
2312: END IF;
2313:

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

2306: END IF ;
2307:
2308: IF l_debug_mode = 'Y' THEN
2309: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
2310: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2311: pa_debug.reset_curr_function;
2312: END IF;
2313:
2314: EXCEPTION

Line 2311: pa_debug.reset_curr_function;

2307:
2308: IF l_debug_mode = 'Y' THEN
2309: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_TASK_ASSCN_IN_BULK' ;
2310: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2311: pa_debug.reset_curr_function;
2312: END IF;
2313:
2314: EXCEPTION
2315: WHEN Invalid_Arg_Exc_Dlv THEN

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

2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: l_msg_count := FND_MSG_PUB.count_msg;
2318:
2319: IF l_debug_mode = 'Y' THEN
2320: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
2321: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2322: END IF;
2323:
2324: IF (p_commit = FND_API.G_TRUE) THEN

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

2317: l_msg_count := FND_MSG_PUB.count_msg;
2318:
2319: IF l_debug_mode = 'Y' THEN
2320: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
2321: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2322: END IF;
2323:
2324: IF (p_commit = FND_API.G_TRUE) THEN
2325: ROLLBACK TO DELETE_DLV_TASK_ASSCN_IN_BULK ;

Line 2342: pa_debug.reset_curr_function;

2338: ELSE
2339: x_msg_count := l_msg_count;
2340: END IF;
2341: IF l_debug_mode = 'Y' THEN
2342: pa_debug.reset_curr_function;
2343: END IF ;
2344: RETURN;
2345: WHEN OTHERS THEN
2346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2354: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2355: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
2356:
2357: IF p_debug_mode = 'Y' THEN
2358: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2359: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2360: pa_debug.reset_curr_function;
2361: END IF;
2362: RAISE;

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

2355: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
2356:
2357: IF p_debug_mode = 'Y' THEN
2358: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2359: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2360: pa_debug.reset_curr_function;
2361: END IF;
2362: RAISE;
2363: END DELETE_DLV_TASK_ASSCN_IN_BULK ;

Line 2360: pa_debug.reset_curr_function;

2356:
2357: IF p_debug_mode = 'Y' THEN
2358: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2359: pa_debug.write('DELETE_DLV_TASK_ASSCN_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
2360: pa_debug.reset_curr_function;
2361: END IF;
2362: RAISE;
2363: END DELETE_DLV_TASK_ASSCN_IN_BULK ;
2364:

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

2388: BEGIN
2389:
2390: x_msg_count := 0;
2391: x_return_status := FND_API.G_RET_STS_SUCCESS;
2392: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2393:
2394: IF l_debug_mode = 'Y' THEN
2395: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
2396: p_debug_mode => l_debug_mode );

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

2391: x_return_status := FND_API.G_RET_STS_SUCCESS;
2392: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2393:
2394: IF l_debug_mode = 'Y' THEN
2395: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
2396: p_debug_mode => l_debug_mode );
2397: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2398: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2399: END IF;

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

2393:
2394: IF l_debug_mode = 'Y' THEN
2395: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
2396: p_debug_mode => l_debug_mode );
2397: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2398: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2399: END IF;
2400:
2401: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

2394: IF l_debug_mode = 'Y' THEN
2395: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
2396: p_debug_mode => l_debug_mode );
2397: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2398: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2399: END IF;
2400:
2401: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2402: FND_MSG_PUB.initialize;

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

2404:
2405: IF (p_project_id IS NULL )
2406: THEN
2407: IF l_debug_mode = 'Y' THEN
2408: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2409: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2410: END IF;
2411:
2412: x_return_status := FND_API.G_RET_STS_ERROR;

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

2405: IF (p_project_id IS NULL )
2406: THEN
2407: IF l_debug_mode = 'Y' THEN
2408: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2409: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2410: END IF;
2411:
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'

Line 2419: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_ASSOCIATIONS';

2415: RAISE Invalid_Arg_Exc_Dlv;
2416: END IF;
2417:
2418: IF l_debug_mode = 'Y' THEN
2419: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_ASSOCIATIONS';
2420: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2421: END IF ;
2422:
2423: PA_DELIVERABLE_PVT.DELETE_DLV_ASSOCIATIONS

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

2416: END IF;
2417:
2418: IF l_debug_mode = 'Y' THEN
2419: pa_debug.g_err_stage:= 'Calling PA_DELIVERABLE_PVT.DELETE_DLV_ASSOCIATIONS';
2420: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2421: END IF ;
2422:
2423: PA_DELIVERABLE_PVT.DELETE_DLV_ASSOCIATIONS
2424: (p_api_version => p_api_version

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

2439: RAISE Invalid_Arg_Exc_Dlv ;
2440: END IF ;
2441:
2442: IF l_debug_mode = 'Y' THEN
2443: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
2444: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2445: pa_debug.reset_curr_function;
2446: END IF;
2447:

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

2440: END IF ;
2441:
2442: IF l_debug_mode = 'Y' THEN
2443: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
2444: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2445: pa_debug.reset_curr_function;
2446: END IF;
2447:
2448: EXCEPTION

Line 2445: pa_debug.reset_curr_function;

2441:
2442: IF l_debug_mode = 'Y' THEN
2443: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;
2444: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2445: pa_debug.reset_curr_function;
2446: END IF;
2447:
2448: EXCEPTION
2449: WHEN Invalid_Arg_Exc_Dlv THEN

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

2450: x_return_status := FND_API.G_RET_STS_ERROR;
2451: l_msg_count := FND_MSG_PUB.count_msg;
2452:
2453: IF l_debug_mode = 'Y' THEN
2454: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
2455: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2456: END IF;
2457:
2458: IF l_msg_count = 1 THEN

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

2451: l_msg_count := FND_MSG_PUB.count_msg;
2452:
2453: IF l_debug_mode = 'Y' THEN
2454: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
2455: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2456: END IF;
2457:
2458: IF l_msg_count = 1 THEN
2459: PA_INTERFACE_UTILS_PUB.get_messages

Line 2472: pa_debug.reset_curr_function;

2468: ELSE
2469: x_msg_count := l_msg_count;
2470: END IF;
2471: IF l_debug_mode = 'Y' THEN
2472: pa_debug.reset_curr_function;
2473: END IF ;
2474: RETURN;
2475: WHEN OTHERS THEN
2476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2480: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2481: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
2482:
2483: IF p_debug_mode = 'Y' THEN
2484: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2485: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2486: pa_debug.reset_curr_function;
2487: END IF;
2488: RAISE;

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

2481: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
2482:
2483: IF p_debug_mode = 'Y' THEN
2484: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2485: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2486: pa_debug.reset_curr_function;
2487: END IF;
2488: RAISE;
2489: END DELETE_DLV_ASSOCIATIONS ;

Line 2486: pa_debug.reset_curr_function;

2482:
2483: IF p_debug_mode = 'Y' THEN
2484: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2485: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2486: pa_debug.reset_curr_function;
2487: END IF;
2488: RAISE;
2489: END DELETE_DLV_ASSOCIATIONS ;
2490:

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

2524: l_return_flag VARCHAR2(1) ;
2525: BEGIN
2526: x_msg_count := 0;
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2529:
2530: IF l_debug_mode = 'Y' THEN
2531: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
2532: p_debug_mode => l_debug_mode );

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

2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2529:
2530: IF l_debug_mode = 'Y' THEN
2531: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
2532: p_debug_mode => l_debug_mode );
2533: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
2534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2535: END IF;

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

2529:
2530: IF l_debug_mode = 'Y' THEN
2531: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
2532: p_debug_mode => l_debug_mode );
2533: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
2534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2535: END IF;
2536:
2537: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

2530: IF l_debug_mode = 'Y' THEN
2531: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',
2532: p_debug_mode => l_debug_mode );
2533: pa_debug.g_err_stage:= 'Inside COPY_DELIVERABLES ';
2534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2535: END IF;
2536:
2537: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2538: FND_MSG_PUB.initialize;

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

2541: SAVEPOINT COPY_DELIVERABLES_SP ;
2542: END IF ;
2543: --Bug 3429393
2544: IF l_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;

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

2542: END IF ;
2543: --Bug 3429393
2544: IF l_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

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

2543: --Bug 3429393
2544: IF l_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;

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

2544: IF l_debug_mode = 'Y' THEN
2545: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;

2545: pa_debug.g_err_stage:= 'p_source_project_id is '||p_source_project_id;
2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;

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

2546: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;
2554: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;

2547: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;
2554: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2555: END IF;

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

2548: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;
2554: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2555: END IF;
2556:

Line 2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;

2549: pa_debug.g_err_stage:= 'p_calling_context is '||p_calling_context;
2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;
2554: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2555: END IF;
2556:
2557: PA_DELIVERABLE_PVT.COPY_DELIVERABLES

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

2550: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2551: pa_debug.g_err_stage:= 'p_task_id is '||p_task_id;
2552: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2553: pa_debug.g_err_stage:= 'p_task_version_id is '||p_task_version_id;
2554: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2555: END IF;
2556:
2557: PA_DELIVERABLE_PVT.COPY_DELIVERABLES
2558: (p_api_version => p_api_version

Line 2583: pa_debug.reset_curr_function;

2579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2580: RAISE Invalid_Arg_Exc_Dlv ;
2581: END IF ;
2582: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2583: pa_debug.reset_curr_function;
2584: END IF ;
2585: EXCEPTION
2586: WHEN Invalid_Arg_Exc_Dlv THEN
2587: x_return_status := FND_API.G_RET_STS_ERROR;

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

2591: ROLLBACK TO COPY_DELIVERABLES_SP ;
2592: END IF ;
2593:
2594: IF l_debug_mode = 'Y' THEN
2595: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';
2596: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2597: END IF;
2598:
2599: IF l_msg_count = 1 THEN

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

2592: END IF ;
2593:
2594: IF l_debug_mode = 'Y' THEN
2595: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';
2596: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2597: END IF;
2598:
2599: IF l_msg_count = 1 THEN
2600: PA_INTERFACE_UTILS_PUB.get_messages

Line 2613: pa_debug.reset_curr_function;

2609: ELSE
2610: x_msg_count := l_msg_count;
2611: END IF;
2612: IF l_debug_mode = 'Y' THEN
2613: pa_debug.reset_curr_function;
2614: END IF ;
2615: RETURN;
2616: WHEN OTHERS THEN
2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2625: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'
2626: ,p_procedure_name => 'COPY_DELIVERABLES');
2627:
2628: IF p_debug_mode = 'Y' THEN
2629: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2630: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2631: pa_debug.reset_curr_function;
2632: END IF;
2633: RAISE;

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

2626: ,p_procedure_name => 'COPY_DELIVERABLES');
2627:
2628: IF p_debug_mode = 'Y' THEN
2629: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2630: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2631: pa_debug.reset_curr_function;
2632: END IF;
2633: RAISE;
2634: END COPY_DELIVERABLES ;

Line 2631: pa_debug.reset_curr_function;

2627:
2628: IF p_debug_mode = 'Y' THEN
2629: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2630: pa_debug.write('DELETE_DLV_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2631: pa_debug.reset_curr_function;
2632: END IF;
2633: RAISE;
2634: END COPY_DELIVERABLES ;
2635:

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

2700:
2701: BEGIN
2702: x_msg_count := 0;
2703: x_return_status := FND_API.G_RET_STS_SUCCESS;
2704: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2705:
2706: IF l_debug_mode = 'Y' THEN
2707: PA_DEBUG.set_curr_function( p_function => 'COPY_ASSOCIATIONS',
2708: p_debug_mode => l_debug_mode );

Line 2707: PA_DEBUG.set_curr_function( p_function => 'COPY_ASSOCIATIONS',

2703: x_return_status := FND_API.G_RET_STS_SUCCESS;
2704: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2705:
2706: IF l_debug_mode = 'Y' THEN
2707: PA_DEBUG.set_curr_function( p_function => 'COPY_ASSOCIATIONS',
2708: p_debug_mode => l_debug_mode );
2709: pa_debug.g_err_stage:= 'Inside COPY_ASSOCIATIONS ';
2710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2711: END IF;

Line 2709: pa_debug.g_err_stage:= 'Inside COPY_ASSOCIATIONS ';

2705:
2706: IF l_debug_mode = 'Y' THEN
2707: PA_DEBUG.set_curr_function( p_function => 'COPY_ASSOCIATIONS',
2708: p_debug_mode => l_debug_mode );
2709: pa_debug.g_err_stage:= 'Inside COPY_ASSOCIATIONS ';
2710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2711: END IF;
2712:
2713: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

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

2706: IF l_debug_mode = 'Y' THEN
2707: PA_DEBUG.set_curr_function( p_function => 'COPY_ASSOCIATIONS',
2708: p_debug_mode => l_debug_mode );
2709: pa_debug.g_err_stage:= 'Inside COPY_ASSOCIATIONS ';
2710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2711: END IF;
2712:
2713: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2714: FND_MSG_PUB.initialize;

Line 2769: pa_debug.reset_curr_function;

2765: END IF ;
2766: END LOOP ;
2767:
2768: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2769: pa_debug.reset_curr_function;
2770: END IF ;
2771:
2772: EXCEPTION
2773: WHEN Invalid_Arg_Exc_Dlv THEN

Line 2782: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ASSOCIATIONS';

2778: ROLLBACK TO COPY_ASSOCIATIONS_SP ;
2779: END IF ;
2780:
2781: IF l_debug_mode = 'Y' THEN
2782: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ASSOCIATIONS';
2783: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2784: END IF;
2785:
2786: IF l_msg_count = 1 THEN

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

2779: END IF ;
2780:
2781: IF l_debug_mode = 'Y' THEN
2782: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ASSOCIATIONS';
2783: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2784: END IF;
2785:
2786: IF l_msg_count = 1 THEN
2787: PA_INTERFACE_UTILS_PUB.get_messages

Line 2800: pa_debug.reset_curr_function;

2796: ELSE
2797: x_msg_count := l_msg_count;
2798: END IF;
2799: IF l_debug_mode = 'Y' THEN
2800: pa_debug.reset_curr_function;
2801: END IF ;
2802: RETURN;
2803: WHEN OTHERS THEN
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2812: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'
2813: ,p_procedure_name => 'COPY_ASSOCIATIONS');
2814:
2815: IF p_debug_mode = 'Y' THEN
2816: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2817: pa_debug.write('COPY_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2818: pa_debug.reset_curr_function;
2819: END IF;
2820: RAISE;

Line 2817: pa_debug.write('COPY_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);

2813: ,p_procedure_name => 'COPY_ASSOCIATIONS');
2814:
2815: IF p_debug_mode = 'Y' THEN
2816: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2817: pa_debug.write('COPY_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2818: pa_debug.reset_curr_function;
2819: END IF;
2820: RAISE;
2821: END COPY_ASSOCIATIONS ;

Line 2818: pa_debug.reset_curr_function;

2814:
2815: IF p_debug_mode = 'Y' THEN
2816: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
2817: pa_debug.write('COPY_ASSOCIATIONS: ' || g_module_name,pa_debug.g_err_stage,5);
2818: pa_debug.reset_curr_function;
2819: END IF;
2820: RAISE;
2821: END COPY_ASSOCIATIONS ;
2822: