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

Line 63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPE_PVT.Create_Task_Type.begin'

59: -- Initialize the return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: --Log Message
63: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPE_PVT.Create_Task_Type.begin'
64: ,x_msg => 'Beginning of Create_Task_Type pvt'
65: ,x_log_level => 5);
66:
67:

Line 117: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

113: EXCEPTION
114: WHEN OTHERS THEN
115: -- Set the excetption Message and the stack
116: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Create_Task_Type'
117: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
118: --
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
120: RAISE;
121:

Line 181: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PVT.Update_Task_Type.begin'

177: -- Initialize the return status to success
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: --Log Message
181: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PVT.Update_Task_Type.begin'
182: ,x_msg => 'Beginning of Update_Task_Type pvt'
183: ,x_log_level => 5);
184:
185:

Line 235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

231: EXCEPTION
232: WHEN OTHERS THEN
233: -- Set the excetption Message and the stack
234: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Update_Task_Type'
235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
236: --
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: RAISE;
239:

Line 259: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PVT.Delete_Task_Type.begin'

255: -- Initialize the return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --Log Message
259: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PVT.Delete_Task_Type.begin'
260: ,x_msg => 'Beginning of Delete_Task_Type pvt'
261: ,x_log_level => 5);
262:
263:

Line 275: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

271: EXCEPTION
272: WHEN OTHERS THEN
273: -- Set the excetption Message and the stack
274: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PVT.Delete_Task_Type'
275: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: RAISE;
278:
279: END Delete_Task_Type;

Line 354: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE_TYPE',

350: l_debug_mode :=p_debug_mode;
351:
352: IF l_debug_mode = 'Y'
353: THEN
354: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE_TYPE',
355: p_debug_mode => l_debug_mode );
356: END IF;
357:
358: IF l_debug_mode = 'Y'

Line 360: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';

356: END IF;
357:
358: IF l_debug_mode = 'Y'
359: THEN
360: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
361: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
362: l_debug_level3);
363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
364: l_debug_level3);

Line 361: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,

357:
358: IF l_debug_mode = 'Y'
359: THEN
360: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
361: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
362: l_debug_level3);
363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
364: l_debug_level3);
365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,

Line 363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,

359: THEN
360: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
361: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
362: l_debug_level3);
363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
364: l_debug_level3);
365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
366: l_debug_level3);
367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

Line 365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,

361: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
362: l_debug_level3);
363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
364: l_debug_level3);
365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
366: l_debug_level3);
367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
368: l_debug_level3);
369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

Line 367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

363: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
364: l_debug_level3);
365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
366: l_debug_level3);
367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
368: l_debug_level3);
369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
370: l_debug_level3);
371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

Line 369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

365: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
366: l_debug_level3);
367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
368: l_debug_level3);
369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
370: l_debug_level3);
371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
372: l_debug_level3);
373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

Line 371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

367: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
368: l_debug_level3);
369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
370: l_debug_level3);
371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
372: l_debug_level3);
373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
374: l_debug_level3);
375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

Line 373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

369: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
370: l_debug_level3);
371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
372: l_debug_level3);
373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
374: l_debug_level3);
375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
376: l_debug_level3);
377: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

Line 375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

371: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
372: l_debug_level3);
373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
374: l_debug_level3);
375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
376: l_debug_level3);
377: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
378: l_debug_level3);
379: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

Line 377: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

373: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
374: l_debug_level3);
375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
376: l_debug_level3);
377: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
378: l_debug_level3);
379: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
380: l_debug_level3);
381: END IF;

Line 379: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

375: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
376: l_debug_level3);
377: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
378: l_debug_level3);
379: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
380: l_debug_level3);
381: END IF;
382:
383: -- Initialize the Message Stack

Line 404: PA_DEBUG.WRITE(g_module_name,'After Unique Chk',

400: p_msg_name => 'PA_DLV_TYPE_EXISTS');
401: x_return_status :=FND_API.G_RET_STS_ERROR;
402: END IF;
403:
404: PA_DEBUG.WRITE(g_module_name,'After Unique Chk',
405: l_debug_level3);
406: --Check if the date range is valid
407: l_return_status :=PA_DELIVERABLE_UTILS.IS_EFF_FROM_TO_DATE_VALID(p_effective_from,p_effective_to);
408: IF(l_return_status = 'N')

Line 421: PA_DEBUG.WRITE(g_module_name,'Before Insert',

417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: PA_DEBUG.WRITE(g_module_name,'Before Insert',
422: l_debug_level3);
423: --Call the PA_TASK_TYPE_PKG.insert_row
424: PA_TASK_TYPE_PKG.insert_row
425: (p_task_type_id => p_deliverable_type_id

Line 442: PA_DEBUG.WRITE(g_module_name,'After Insert',

438: ,x_msg_count => x_msg_count
439: ,x_msg_data => x_msg_data
440: );
441:
442: PA_DEBUG.WRITE(g_module_name,'After Insert',
443: l_debug_level3);
444: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
445: THEN
446: RAISE FND_API.G_EXC_ERROR;

Line 478: Pa_Debug.reset_curr_function;

474: END IF;
475:
476: IF l_debug_mode = 'Y'
477: THEN
478: Pa_Debug.reset_curr_function;
479: END IF;
480: RETURN;
481:
482: WHEN INV_ARG_EXC THEN

Line 500: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;

496: , p_error_text => x_msg_data);
497:
498: IF l_debug_mode = 'Y'
499: THEN
500: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
501: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
502: l_debug_level5);
503: Pa_Debug.reset_curr_function;
504: END IF;

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

497:
498: IF l_debug_mode = 'Y'
499: THEN
500: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
501: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
502: l_debug_level5);
503: Pa_Debug.reset_curr_function;
504: END IF;
505: RAISE;

Line 503: Pa_Debug.reset_curr_function;

499: THEN
500: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
501: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
502: l_debug_level5);
503: Pa_Debug.reset_curr_function;
504: END IF;
505: RAISE;
506:
507: WHEN OTHERS THEN

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

522: , p_error_text => x_msg_data);
523:
524: IF l_debug_mode = 'Y'
525: THEN
526: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
527: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
528: l_debug_level5);
529: Pa_Debug.reset_curr_function;
530: END IF;

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

523:
524: IF l_debug_mode = 'Y'
525: THEN
526: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
527: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
528: l_debug_level5);
529: Pa_Debug.reset_curr_function;
530: END IF;
531: RAISE;

Line 529: Pa_Debug.reset_curr_function;

525: THEN
526: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
527: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
528: l_debug_level5);
529: Pa_Debug.reset_curr_function;
530: END IF;
531: RAISE;
532:
533: END CREATE_DELIVERABLE_TYPE;

Line 637: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE_TYPE',

633: l_debug_mode := p_debug_mode;
634:
635: IF l_debug_mode = 'Y'
636: THEN
637: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE_TYPE',
638: p_debug_mode => l_debug_mode );
639: END IF;
640:
641: IF l_debug_mode = 'Y'

Line 643: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';

639: END IF;
640:
641: IF l_debug_mode = 'Y'
642: THEN
643: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
645: l_debug_level3);
646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);

Line 644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,

640:
641: IF l_debug_mode = 'Y'
642: THEN
643: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
645: l_debug_level3);
646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);
648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,

Line 646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,

642: THEN
643: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPES_PVT.UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
645: l_debug_level3);
646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);
648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
649: l_debug_level3);
650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

Line 648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,

644: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
645: l_debug_level3);
646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);
648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
649: l_debug_level3);
650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
651: l_debug_level3);
652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

Line 650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

646: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
647: l_debug_level3);
648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
649: l_debug_level3);
650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
651: l_debug_level3);
652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
653: l_debug_level3);
654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

Line 652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

648: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
649: l_debug_level3);
650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
651: l_debug_level3);
652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
653: l_debug_level3);
654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
655: l_debug_level3);
656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

Line 654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

650: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
651: l_debug_level3);
652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
653: l_debug_level3);
654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
655: l_debug_level3);
656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
657: l_debug_level3);
658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

Line 656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

652: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
653: l_debug_level3);
654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
655: l_debug_level3);
656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
657: l_debug_level3);
658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
659: l_debug_level3);
660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

Line 658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

654: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
655: l_debug_level3);
656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
657: l_debug_level3);
658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
659: l_debug_level3);
660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
661: l_debug_level3);
662: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

Line 660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

656: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
657: l_debug_level3);
658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
659: l_debug_level3);
660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
661: l_debug_level3);
662: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
663: l_debug_level3);
664: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

Line 662: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

658: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
659: l_debug_level3);
660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
661: l_debug_level3);
662: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
663: l_debug_level3);
664: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
665: l_debug_level3);
666:

Line 664: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

660: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
661: l_debug_level3);
662: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
663: l_debug_level3);
664: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
665: l_debug_level3);
666:
667: END IF;
668:

Line 681: PA_DEBUG.WRITE(g_module_name,'After issuing save point in UPDATE_DLV_TYPE :PA_TASK_TYPES_PVT',

677: THEN
678: savepoint UPDATE_DELIVERABLE_TYPE;
679: END IF;
680:
681: PA_DEBUG.WRITE(g_module_name,'After issuing save point in UPDATE_DLV_TYPE :PA_TASK_TYPES_PVT',
682: l_debug_level3);
683:
684: --the cursor contents into local variable
685: OPEN c_original_value_rec;

Line 689: PA_DEBUG.WRITE(g_module_name,'After fetching the cursor value in to local variable',

685: OPEN c_original_value_rec;
686: FETCH c_original_value_rec into l_original_value_rec ;
687: CLOSE c_original_value_rec;
688:
689: PA_DEBUG.WRITE(g_module_name,'After fetching the cursor value in to local variable',
690: l_debug_level3);
691:
692: --Check whether Deliverable Type Id or record version number or deliverable type name or start date is null.
693: --If Yes,then due to some internal error it is lost,so throw error

Line 699: Pa_Debug.g_err_stage:= 'PA_TASK_TYPES_PVT : UPDATE_DELIVERABLE_TYPE : The DeliverableTypeID/NAME/Startdate/RecVersionNumber is null';

695: OR (p_deliverable_type_name IS NULL) OR (p_effective_from IS NULL)
696: THEN
697: IF l_debug_mode = 'Y'
698: THEN
699: Pa_Debug.g_err_stage:= 'PA_TASK_TYPES_PVT : UPDATE_DELIVERABLE_TYPE : The DeliverableTypeID/NAME/Startdate/RecVersionNumber is null';
700: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
701: l_debug_level3);
702: END IF;
703: RAISE INV_ARG_EXC;

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

696: THEN
697: IF l_debug_mode = 'Y'
698: THEN
699: Pa_Debug.g_err_stage:= 'PA_TASK_TYPES_PVT : UPDATE_DELIVERABLE_TYPE : The DeliverableTypeID/NAME/Startdate/RecVersionNumber is null';
700: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
701: l_debug_level3);
702: END IF;
703: RAISE INV_ARG_EXC;
704: END IF;

Line 720: PA_DEBUG.WRITE(g_module_name,'After Checking for unique name',

716:
717: x_return_status :=FND_API.G_RET_STS_ERROR;
718: END IF;
719: END IF;
720: PA_DEBUG.WRITE(g_module_name,'After Checking for unique name',
721: l_debug_level3);
722:
723: --If the date values have changed then check for valid dates
724:

Line 741: PA_DEBUG.WRITE(g_module_name,'After checking for invalid dates',

737: x_return_status :=FND_API.G_RET_STS_ERROR;
738: END IF;
739: END IF;
740: END IF;
741: PA_DEBUG.WRITE(g_module_name,'After checking for invalid dates',
742: l_debug_level3);
743:
744: --If the Deliverable Type Class has changed then check whether it is in use
745: --If Yes,Throw Error

Line 794: Pa_Debug.g_err_stage:= ' Error:PA_DLV_TYPE_PROG_ERR';

790: x_return_status := FND_API.G_RET_STS_ERROR;
791:
792: IF l_debug_mode = 'Y'
793: THEN
794: Pa_Debug.g_err_stage:= ' Error:PA_DLV_TYPE_PROG_ERR';
795: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
796: l_debug_level5);
797: END IF;
798: ELSE -- Bug 3627161

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

791:
792: IF l_debug_mode = 'Y'
793: THEN
794: Pa_Debug.g_err_stage:= ' Error:PA_DLV_TYPE_PROG_ERR';
795: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
796: l_debug_level5);
797: END IF;
798: ELSE -- Bug 3627161
799: l_allow_prog_entry_disable := 'Y' ;

Line 928: Pa_Debug.reset_curr_function;

924: END IF;
925:
926: IF l_debug_mode = 'Y'
927: THEN
928: Pa_Debug.reset_curr_function;
929: END IF;
930:
931: WHEN INV_ARG_EXC THEN
932: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 958: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;

954: , p_error_text => x_msg_data);
955:
956: IF l_debug_mode = 'Y'
957: THEN
958: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
959: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
960: l_debug_level5);
961: Pa_Debug.reset_curr_function;
962: END IF;

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

955:
956: IF l_debug_mode = 'Y'
957: THEN
958: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
959: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
960: l_debug_level5);
961: Pa_Debug.reset_curr_function;
962: END IF;
963: RAISE;

Line 961: Pa_Debug.reset_curr_function;

957: THEN
958: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
959: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
960: l_debug_level5);
961: Pa_Debug.reset_curr_function;
962: END IF;
963: RAISE;
964:
965: WHEN OTHERS THEN

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

989: , p_error_text => x_msg_data);
990:
991: IF l_debug_mode = 'Y'
992: THEN
993: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
994: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
995: l_debug_level5);
996: Pa_Debug.reset_curr_function;
997: END IF;

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

990:
991: IF l_debug_mode = 'Y'
992: THEN
993: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
994: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
995: l_debug_level5);
996: Pa_Debug.reset_curr_function;
997: END IF;
998: RAISE;

Line 996: Pa_Debug.reset_curr_function;

992: THEN
993: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
994: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
995: l_debug_level5);
996: Pa_Debug.reset_curr_function;
997: END IF;
998: RAISE;
999:
1000: END UPDATE_DELIVERABLE_TYPE;

Line 1052: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_TYPE',

1048: l_debug_mode :=p_debug_mode;
1049:
1050: IF l_debug_mode = 'Y'
1051: THEN
1052: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_TYPE',
1053: p_debug_mode => l_debug_mode );
1054: END IF;
1055: --savepoint
1056: IF (p_commit = FND_API.G_TRUE)

Line 1063: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE : Printing Input parameters';

1059: END IF;
1060:
1061: IF l_debug_mode = 'Y'
1062: THEN
1063: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1064: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1065: l_debug_level3);
1066: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1067: l_debug_level3);

Line 1064: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,

1060:
1061: IF l_debug_mode = 'Y'
1062: THEN
1063: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1064: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1065: l_debug_level3);
1066: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1067: l_debug_level3);
1068: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

Line 1066: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

1062: THEN
1063: PA_DEBUG.g_err_stage:= 'PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1064: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1065: l_debug_level3);
1066: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1067: l_debug_level3);
1068: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1069: l_debug_level3);
1070: END IF;

Line 1068: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

1064: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1065: l_debug_level3);
1066: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1067: l_debug_level3);
1068: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1069: l_debug_level3);
1070: END IF;
1071:
1072: --Initialize the Message Stack

Line 1080: PA_DEBUG.g_err_stage:= 'BEFORE CALLING PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';

1076: END IF;
1077:
1078: IF l_debug_mode = 'Y'
1079: THEN
1080: PA_DEBUG.g_err_stage:= 'BEFORE CALLING PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';
1081: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1082: l_debug_level3);
1083: END IF;
1084: --Call Delete Deliverable Actions API

Line 1081: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,

1077:
1078: IF l_debug_mode = 'Y'
1079: THEN
1080: PA_DEBUG.g_err_stage:= 'BEFORE CALLING PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';
1081: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1082: l_debug_level3);
1083: END IF;
1084: --Call Delete Deliverable Actions API
1085: PA_ACTIONS_PUB.DELETE_DLV_ACTIONS_IN_BULK

Line 1102: PA_DEBUG.g_err_stage:= 'AFTER RETURNING FROM PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';

1098: ,x_msg_count => x_msg_count);
1099:
1100: IF l_debug_mode = 'Y'
1101: THEN
1102: PA_DEBUG.g_err_stage:= 'AFTER RETURNING FROM PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';
1103: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1104: l_debug_level3);
1105: END IF;
1106:

Line 1103: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,

1099:
1100: IF l_debug_mode = 'Y'
1101: THEN
1102: PA_DEBUG.g_err_stage:= 'AFTER RETURNING FROM PA_ACTIONS_PUB.DELETE_DLV_ACTIONS';
1103: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1104: l_debug_level3);
1105: END IF;
1106:
1107: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 1152: Pa_Debug.reset_curr_function;

1148: END IF;
1149:
1150: IF l_debug_mode = 'Y'
1151: THEN
1152: Pa_Debug.reset_curr_function;
1153: END IF;
1154:
1155: WHEN OTHERS THEN
1156: -- Set the exception Message and the stack

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

1169: , p_error_text => x_msg_data);
1170:
1171: IF l_debug_mode = 'Y'
1172: THEN
1173: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1174: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1175: l_debug_level5);
1176: Pa_Debug.reset_curr_function;
1177: END IF;

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

1170:
1171: IF l_debug_mode = 'Y'
1172: THEN
1173: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1174: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1175: l_debug_level5);
1176: Pa_Debug.reset_curr_function;
1177: END IF;
1178: RAISE;

Line 1176: Pa_Debug.reset_curr_function;

1172: THEN
1173: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1174: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1175: l_debug_level5);
1176: Pa_Debug.reset_curr_function;
1177: END IF;
1178: RAISE;
1179: END DELETE_DELIVERABLE_TYPE;
1180: END PA_TASK_TYPE_PVT;