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

Line 85: PA_DEBUG.init_err_stack('PA_task_type_PUB.Create_Task_Type');

81:
82: BEGIN
83:
84: -- Initialize the Error Stack
85: PA_DEBUG.init_err_stack('PA_task_type_PUB.Create_Task_Type');
86:
87: -- Initialize the return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:

Line 101: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'

97: SAVEPOINT CREATE_TASK_TYPE_PUB;
98: END IF;
99:
100: --Log Message
101: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'
102: ,x_msg => 'Beginning of Create_Task_Type pub'
103: ,x_log_level => 5);
104:
105:

Line 164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'

160: end if ;
161:
162: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
163: --Log Message
164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Create_Task_Type.begin'
165: ,x_msg => 'calling create_Task_Type pvt'
166: ,x_log_level => 5);
167:
168: PA_TASK_TYPE_PVT.create_Task_Type

Line 223: PA_DEBUG.Reset_Err_Stack;

219: );
220: END IF;
221:
222: -- Reset the error stack when returning to the calling program
223: PA_DEBUG.Reset_Err_Stack;
224: -- If any errors exist then set the x_return_status to 'E'
225:
226: IF x_msg_count > 0 THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;

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

311: END IF;
312:
313: -- Set the excetption Message and the stack
314: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Create_Task_Type'
315: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
316: --
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: RAISE;
319:

Line 395: PA_DEBUG.init_err_stack('PA_TASK_TYPES_PUB.Update_Task_Type');

391:
392: BEGIN
393:
394: -- Initialize the Error Stack
395: PA_DEBUG.init_err_stack('PA_TASK_TYPES_PUB.Update_Task_Type');
396:
397: -- Initialize the return status to success
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:

Line 411: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'

407: SAVEPOINT UPDATE_TASK_TYPE_PUB;
408: END IF;
409:
410: --Log Message
411: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'
412: ,x_msg => 'Beginning of Update_Task_Type pub'
413: ,x_log_level => 5);
414:
415:

Line 507: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'

503: end if ;
504:
505: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
506: --Log Message
507: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Update_Task_Type.begin'
508: ,x_msg => 'calling Update_Task_Type pvt'
509: ,x_log_level => 5);
510:
511: PA_TASK_TYPE_PVT.Update_Task_Type

Line 566: PA_DEBUG.Reset_Err_Stack;

562: );
563: END IF;
564:
565: -- Reset the error stack when returning to the calling program
566: PA_DEBUG.Reset_Err_Stack;
567: -- If any errors exist then set the x_return_status to 'E'
568:
569: IF x_msg_count > 0 THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;

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

761: ROLLBACK TO UPDATE_TASK_TYPE_PUB;
762: END IF;
763: -- Set the excetption Message and the stack
764: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Update_Task_Type'
765: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
766: --
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
768: RAISE;
769:

Line 793: PA_DEBUG.init_err_stack('PA_task_types_PUB.Delete_Task_Type');

789:
790: BEGIN
791:
792: -- Initialize the Error Stack
793: PA_DEBUG.init_err_stack('PA_task_types_PUB.Delete_Task_Type');
794:
795: -- Initialize the return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:

Line 809: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PUB.Delete_Task_Type.begin'

805: SAVEPOINT DELETE_TASK_TYPE_PUB;
806: END IF;
807:
808: --Log Message
809: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_task_types_PUB.Delete_Task_Type.begin'
810: ,x_msg => 'Beginning of Delete_Task_Type pub'
811: ,x_log_level => 5);
812:
813: --Log Message

Line 814: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Delete_Task_Type.begin'

810: ,x_msg => 'Beginning of Delete_Task_Type pub'
811: ,x_log_level => 5);
812:
813: --Log Message
814: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_TASK_TYPES_PUB.Delete_Task_Type.begin'
815: ,x_msg => 'calling Delete_Task_Type pvt'
816: ,x_log_level => 5);
817:
818: -- Check whether the task type is the seeded task type.

Line 846: PA_DEBUG.Reset_Err_Stack;

842: );
843: END IF;
844:
845: -- Reset the error stack when returning to the calling program
846: PA_DEBUG.Reset_Err_Stack;
847: -- If any errors exist then set the x_return_status to 'E'
848:
849: IF x_msg_count > 0 THEN
850: x_return_status := FND_API.G_RET_STS_ERROR;

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

898: END IF;
899:
900: -- Set the exception Message and the stack
901: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPES_PUB.Delete_Task_Type'
902: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
904: RAISE;
905:
906: END Delete_Task_Type;

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

972: l_debug_mode := p_debug_mode;
973:
974: IF l_debug_mode = 'Y'
975: THEN
976: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE_TYPE',
977: p_debug_mode => l_debug_mode );
978: END IF;
979:
980: IF l_debug_mode = 'Y'

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

978: END IF;
979:
980: IF l_debug_mode = 'Y'
981: THEN
982: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
983: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
984: l_debug_level3);
985:
986: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,

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

979:
980: IF l_debug_mode = 'Y'
981: THEN
982: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
983: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
984: l_debug_level3);
985:
986: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
987: l_debug_level3);

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

982: PA_DEBUG.g_err_stage:= 'CREATE_DELIVERABLE_TYPE : Printing Input parameters';
983: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
984: l_debug_level3);
985:
986: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
987: l_debug_level3);
988: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
989: l_debug_level3);
990: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

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

984: l_debug_level3);
985:
986: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
987: l_debug_level3);
988: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
989: l_debug_level3);
990: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
991: l_debug_level3);
992: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

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

986: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
987: l_debug_level3);
988: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
989: l_debug_level3);
990: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
991: l_debug_level3);
992: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
993: l_debug_level3);
994: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

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

988: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
989: l_debug_level3);
990: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
991: l_debug_level3);
992: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
993: l_debug_level3);
994: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
995: l_debug_level3);
996: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

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

990: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
991: l_debug_level3);
992: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
993: l_debug_level3);
994: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
995: l_debug_level3);
996: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
997: l_debug_level3);
998: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

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

992: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
993: l_debug_level3);
994: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
995: l_debug_level3);
996: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
997: l_debug_level3);
998: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
999: l_debug_level3);
1000: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

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

994: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
995: l_debug_level3);
996: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
997: l_debug_level3);
998: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
999: l_debug_level3);
1000: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1001: l_debug_level3);
1002: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

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

996: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
997: l_debug_level3);
998: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
999: l_debug_level3);
1000: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1001: l_debug_level3);
1002: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1003: l_debug_level3);
1004: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

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

998: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
999: l_debug_level3);
1000: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1001: l_debug_level3);
1002: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1003: l_debug_level3);
1004: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1005: l_debug_level3);
1006: END IF;

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

1000: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1001: l_debug_level3);
1002: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1003: l_debug_level3);
1004: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1005: l_debug_level3);
1006: END IF;
1007:
1008: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))

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

1016: END IF;
1017:
1018: IF l_debug_mode = 'Y'
1019: THEN
1020: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1021: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1022: l_debug_level3);
1023: END IF;
1024:

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

1017:
1018: IF l_debug_mode = 'Y'
1019: THEN
1020: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1021: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1022: l_debug_level3);
1023: END IF;
1024:
1025: --Check whether p_deliverable_type_name or effective start date is null

Line 1035: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE';

1031:
1032: --Place a call to PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE
1033: IF l_debug_mode = 'Y'
1034: THEN
1035: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE';
1036: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1037: l_debug_level3);
1038: END IF;
1039:

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

1032: --Place a call to PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE
1033: IF l_debug_mode = 'Y'
1034: THEN
1035: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE';
1036: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1037: l_debug_level3);
1038: END IF;
1039:
1040: PA_TASK_TYPE_PVT.CREATE_DELIVERABLE_TYPE

Line 1076: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Create DlvType)!';

1072: END IF;
1073:
1074: IF l_debug_mode = 'Y'
1075: THEN
1076: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Create DlvType)!';
1077: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1078: l_debug_level3);
1079: END IF;
1080:

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

1073:
1074: IF l_debug_mode = 'Y'
1075: THEN
1076: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Create DlvType)!';
1077: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1078: l_debug_level3);
1079: END IF;
1080:
1081:

Line 1111: Pa_Debug.reset_curr_function;

1107: END IF;
1108:
1109: IF l_debug_mode = 'Y'
1110: THEN
1111: Pa_Debug.reset_curr_function;
1112: END IF;
1113:
1114: WHEN PA_DLV_INV_PARAM_EXC THEN
1115:

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

1128: , p_error_text => x_msg_data);
1129:
1130: IF l_debug_mode = 'Y'
1131: THEN
1132: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1133: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1134: l_debug_level5);
1135: Pa_Debug.reset_curr_function;
1136: END IF;

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

1129:
1130: IF l_debug_mode = 'Y'
1131: THEN
1132: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1133: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1134: l_debug_level5);
1135: Pa_Debug.reset_curr_function;
1136: END IF;
1137: RAISE;

Line 1135: Pa_Debug.reset_curr_function;

1131: THEN
1132: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1133: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1134: l_debug_level5);
1135: Pa_Debug.reset_curr_function;
1136: END IF;
1137: RAISE;
1138:
1139: WHEN OTHERS THEN

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

1154: , p_error_text => x_msg_data);
1155:
1156: IF l_debug_mode = 'Y'
1157: THEN
1158: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1159: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1160: l_debug_level5);
1161: Pa_Debug.reset_curr_function;
1162: END IF;

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

1155:
1156: IF l_debug_mode = 'Y'
1157: THEN
1158: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1159: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1160: l_debug_level5);
1161: Pa_Debug.reset_curr_function;
1162: END IF;
1163: RAISE;

Line 1161: Pa_Debug.reset_curr_function;

1157: THEN
1158: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1159: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1160: l_debug_level5);
1161: Pa_Debug.reset_curr_function;
1162: END IF;
1163: RAISE;
1164: END CREATE_DELIVERABLE_TYPE ;
1165:

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

1233: l_debug_mode := p_debug_mode;
1234:
1235: IF l_debug_mode = 'Y'
1236: THEN
1237: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE_TYPE',
1238: p_debug_mode => l_debug_mode );
1239: END IF;
1240:
1241: IF l_debug_mode = 'Y'

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

1239: END IF;
1240:
1241: IF l_debug_mode = 'Y'
1242: THEN
1243: PA_DEBUG.g_err_stage:= 'UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
1244: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1245: l_debug_level3);
1246:
1247: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,

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

1240:
1241: IF l_debug_mode = 'Y'
1242: THEN
1243: PA_DEBUG.g_err_stage:= 'UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
1244: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1245: l_debug_level3);
1246:
1247: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1248: l_debug_level3);

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

1243: PA_DEBUG.g_err_stage:= 'UPDATE_DELIVERABLE_TYPE : Printing Input parameters';
1244: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1245: l_debug_level3);
1246:
1247: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1248: l_debug_level3);
1249: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1250: l_debug_level3);
1251: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

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

1245: l_debug_level3);
1246:
1247: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1248: l_debug_level3);
1249: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1250: l_debug_level3);
1251: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1252: l_debug_level3);
1253: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

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

1247: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1248: l_debug_level3);
1249: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1250: l_debug_level3);
1251: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1252: l_debug_level3);
1253: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1254: l_debug_level3);
1255: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

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

1249: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1250: l_debug_level3);
1251: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1252: l_debug_level3);
1253: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1254: l_debug_level3);
1255: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1256: l_debug_level3);
1257: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

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

1251: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1252: l_debug_level3);
1253: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1254: l_debug_level3);
1255: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1256: l_debug_level3);
1257: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1258: l_debug_level3);
1259: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

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

1253: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1254: l_debug_level3);
1255: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1256: l_debug_level3);
1257: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1258: l_debug_level3);
1259: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1260: l_debug_level3);
1261: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

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

1255: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1256: l_debug_level3);
1257: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1258: l_debug_level3);
1259: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1260: l_debug_level3);
1261: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1262: l_debug_level3);
1263: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

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

1257: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1258: l_debug_level3);
1259: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1260: l_debug_level3);
1261: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1262: l_debug_level3);
1263: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1264: l_debug_level3);
1265: PA_DEBUG.WRITE(g_module_name,'rec_ver_num is '||p_record_version_number,l_debug_level3);

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

1259: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1260: l_debug_level3);
1261: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1262: l_debug_level3);
1263: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1264: l_debug_level3);
1265: PA_DEBUG.WRITE(g_module_name,'rec_ver_num is '||p_record_version_number,l_debug_level3);
1266: END IF;
1267:

Line 1265: PA_DEBUG.WRITE(g_module_name,'rec_ver_num is '||p_record_version_number,l_debug_level3);

1261: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1262: l_debug_level3);
1263: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1264: l_debug_level3);
1265: PA_DEBUG.WRITE(g_module_name,'rec_ver_num is '||p_record_version_number,l_debug_level3);
1266: END IF;
1267:
1268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))
1269: THEN

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

1276: END IF;
1277:
1278: IF l_debug_mode = 'Y'
1279: THEN
1280: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1281: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1282: l_debug_level3);
1283: END IF;
1284:

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

1277:
1278: IF l_debug_mode = 'Y'
1279: THEN
1280: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1281: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1282: l_debug_level3);
1283: END IF;
1284:
1285: --Check whether any of p_deliverable_type_id or p_record_version_number or name or startdate is null

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

1315: ,p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1316:
1317: IF l_debug_mode = 'Y'
1318: THEN
1319: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1320: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1321: l_debug_level5);
1322: Pa_Debug.reset_curr_function;
1323: END IF;

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

1316:
1317: IF l_debug_mode = 'Y'
1318: THEN
1319: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1320: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1321: l_debug_level5);
1322: Pa_Debug.reset_curr_function;
1323: END IF;
1324: RAISE;

Line 1322: Pa_Debug.reset_curr_function;

1318: THEN
1319: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1320: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1321: l_debug_level5);
1322: Pa_Debug.reset_curr_function;
1323: END IF;
1324: RAISE;
1325:
1326:

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

1338: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
1339:
1340: IF l_debug_mode = 'Y'
1341: THEN
1342: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1343: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1344: l_debug_level5);
1345: Pa_Debug.reset_curr_function;
1346: END IF;

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

1339:
1340: IF l_debug_mode = 'Y'
1341: THEN
1342: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1343: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1344: l_debug_level5);
1345: Pa_Debug.reset_curr_function;
1346: END IF;
1347: RAISE;

Line 1345: Pa_Debug.reset_curr_function;

1341: THEN
1342: Pa_Debug.g_err_stage:= ' Error'||x_msg_data;
1343: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1344: l_debug_level5);
1345: Pa_Debug.reset_curr_function;
1346: END IF;
1347: RAISE;
1348:
1349: WHEN OTHERS THEN

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

1361: ,p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1362:
1363: IF l_debug_mode = 'Y'
1364: THEN
1365: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1366: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1367: l_debug_level5);
1368: Pa_Debug.reset_curr_function;
1369: END IF;

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

1362:
1363: IF l_debug_mode = 'Y'
1364: THEN
1365: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1366: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1367: l_debug_level5);
1368: Pa_Debug.reset_curr_function;
1369: END IF;
1370:

Line 1368: Pa_Debug.reset_curr_function;

1364: THEN
1365: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1366: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1367: l_debug_level5);
1368: Pa_Debug.reset_curr_function;
1369: END IF;
1370:
1371: ELSE
1372: RAISE;

Line 1397: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';

1393: END IF;
1394: --Place a call to PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE
1395: IF l_debug_mode = 'Y'
1396: THEN
1397: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';
1398: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1399: l_debug_level3);
1400: END IF;
1401:

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

1394: --Place a call to PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE
1395: IF l_debug_mode = 'Y'
1396: THEN
1397: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';
1398: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1399: l_debug_level3);
1400: END IF;
1401:
1402: PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE

Line 1427: Pa_Debug.g_err_stage:= 'After Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';

1423: ,x_msg_data => x_msg_data
1424: );
1425: IF l_debug_mode = 'Y'
1426: THEN
1427: Pa_Debug.g_err_stage:= 'After Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';
1428: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1429: l_debug_level3);
1430: END IF;
1431:

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

1424: );
1425: IF l_debug_mode = 'Y'
1426: THEN
1427: Pa_Debug.g_err_stage:= 'After Calling PA_TASK_TYPE_PVT.UPDATE_DELIVERABLE_TYPE';
1428: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1429: l_debug_level3);
1430: END IF;
1431:
1432: --After returning from the API check for the return status

Line 1446: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls UPDATE DlvType)!';

1442: END IF;
1443:
1444: IF l_debug_mode = 'Y'
1445: THEN
1446: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls UPDATE DlvType)!';
1447: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1448: l_debug_level3);
1449: END IF;
1450:

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

1443:
1444: IF l_debug_mode = 'Y'
1445: THEN
1446: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls UPDATE DlvType)!';
1447: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1448: l_debug_level3);
1449: END IF;
1450:
1451:

Line 1478: Pa_Debug.reset_curr_function;

1474: ELSE
1475: x_msg_count := l_msg_count;
1476: END IF;
1477: IF l_debug_mode = 'Y' THEN
1478: Pa_Debug.reset_curr_function;
1479: END IF;
1480:
1481: WHEN PA_DLV_INV_PARAM_EXC THEN
1482:

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

1495: , p_error_text => x_msg_data);
1496:
1497: IF l_debug_mode = 'Y'
1498: THEN
1499: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1500: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1501: l_debug_level5);
1502: Pa_Debug.reset_curr_function;
1503: END IF;

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

1496:
1497: IF l_debug_mode = 'Y'
1498: THEN
1499: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1500: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1501: l_debug_level5);
1502: Pa_Debug.reset_curr_function;
1503: END IF;
1504: RAISE;

Line 1502: Pa_Debug.reset_curr_function;

1498: THEN
1499: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1500: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1501: l_debug_level5);
1502: Pa_Debug.reset_curr_function;
1503: END IF;
1504: RAISE;
1505:
1506: WHEN OTHERS THEN

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

1521: , p_error_text => x_msg_data);
1522:
1523: IF l_debug_mode = 'Y'
1524: THEN
1525: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1526: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1527: l_debug_level5);
1528: Pa_Debug.reset_curr_function;
1529: END IF;

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

1522:
1523: IF l_debug_mode = 'Y'
1524: THEN
1525: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1526: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1527: l_debug_level5);
1528: Pa_Debug.reset_curr_function;
1529: END IF;
1530: RAISE;

Line 1528: Pa_Debug.reset_curr_function;

1524: THEN
1525: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1526: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1527: l_debug_level5);
1528: Pa_Debug.reset_curr_function;
1529: END IF;
1530: RAISE;
1531: END UPDATE_DELIVERABLE_TYPE ;
1532:

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

1577: BEGIN
1578:
1579: x_msg_count := 0;
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1582:
1583: IF l_debug_mode = 'Y'
1584: THEN
1585: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_TYPE',

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

1581: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1582:
1583: IF l_debug_mode = 'Y'
1584: THEN
1585: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_TYPE',
1586: p_debug_mode => l_debug_mode );
1587: END IF;
1588:
1589: IF l_debug_mode = 'Y'

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

1587: END IF;
1588:
1589: IF l_debug_mode = 'Y'
1590: THEN
1591: PA_DEBUG.g_err_stage:= 'DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1592: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1593: l_debug_level3);
1594: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1595: l_debug_level3);

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

1588:
1589: IF l_debug_mode = 'Y'
1590: THEN
1591: PA_DEBUG.g_err_stage:= 'DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1592: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1593: l_debug_level3);
1594: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1595: l_debug_level3);
1596: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

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

1590: THEN
1591: PA_DEBUG.g_err_stage:= 'DELETE_DELIVERABLE_TYPE : Printing Input parameters';
1592: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1593: l_debug_level3);
1594: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1595: l_debug_level3);
1596: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1597: l_debug_level3);
1598: END IF;

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

1592: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1593: l_debug_level3);
1594: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1595: l_debug_level3);
1596: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1597: l_debug_level3);
1598: END IF;
1599:
1600: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))

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

1608: END IF;
1609:
1610: IF l_debug_mode = 'Y'
1611: THEN
1612: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1613: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1614: l_debug_level3);
1615: END IF;
1616:

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

1609:
1610: IF l_debug_mode = 'Y'
1611: THEN
1612: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1613: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1614: l_debug_level3);
1615: END IF;
1616:
1617: --Check whether p_deliverable_type_id or p_record_version_number is null

Line 1634: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';

1630:
1631: --Place a call to PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE
1632: IF l_debug_mode = 'Y'
1633: THEN
1634: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';
1635: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1636: l_debug_level3);
1637: END IF;
1638: PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE

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

1631: --Place a call to PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE
1632: IF l_debug_mode = 'Y'
1633: THEN
1634: Pa_Debug.g_err_stage:= 'Calling PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';
1635: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1636: l_debug_level3);
1637: END IF;
1638: PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE
1639: (p_api_version => p_api_version

Line 1655: Pa_Debug.g_err_stage:= 'After coming from PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';

1651: ,x_msg_data => x_msg_data
1652: );
1653: IF l_debug_mode = 'Y'
1654: THEN
1655: Pa_Debug.g_err_stage:= 'After coming from PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';
1656: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1657: l_debug_level3);
1658: END IF;
1659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

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

1652: );
1653: IF l_debug_mode = 'Y'
1654: THEN
1655: Pa_Debug.g_err_stage:= 'After coming from PA_TASK_TYPE_PVT.DELETE_DELIVERABLE_TYPE';
1656: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1657: l_debug_level3);
1658: END IF;
1659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1660: THEN

Line 1671: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Deleted the DlvType)!';

1667: END IF;
1668:
1669: IF l_debug_mode = 'Y'
1670: THEN
1671: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Deleted the DlvType)!';
1672: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1673: l_debug_level3);
1674: END IF;
1675:

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

1668:
1669: IF l_debug_mode = 'Y'
1670: THEN
1671: Pa_Debug.g_err_stage:= 'Successful Commit Done(In PATTPUBB.pls Deleted the DlvType)!';
1672: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1673: l_debug_level3);
1674: END IF;
1675:
1676:

Line 1721: Pa_Debug.reset_curr_function;

1717: END IF;
1718:
1719: IF l_debug_mode = 'Y'
1720: THEN
1721: Pa_Debug.reset_curr_function;
1722: END IF;
1723:
1724: WHEN PA_DLV_INV_PARAM_EXC THEN
1725:

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

1738: , p_error_text => x_msg_data);
1739:
1740: IF l_debug_mode = 'Y'
1741: THEN
1742: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1743: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1744: l_debug_level5);
1745: Pa_Debug.reset_curr_function;
1746: END IF;

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

1739:
1740: IF l_debug_mode = 'Y'
1741: THEN
1742: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1743: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1744: l_debug_level5);
1745: Pa_Debug.reset_curr_function;
1746: END IF;
1747: RAISE;

Line 1745: Pa_Debug.reset_curr_function;

1741: THEN
1742: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
1743: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1744: l_debug_level5);
1745: Pa_Debug.reset_curr_function;
1746: END IF;
1747: RAISE;
1748:
1749: WHEN OTHERS THEN

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

1764: , p_error_text => x_msg_data);
1765:
1766: IF l_debug_mode = 'Y'
1767: THEN
1768: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1769: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1770: l_debug_level5);
1771: Pa_Debug.reset_curr_function;
1772: END IF;

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

1765:
1766: IF l_debug_mode = 'Y'
1767: THEN
1768: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1769: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1770: l_debug_level5);
1771: Pa_Debug.reset_curr_function;
1772: END IF;
1773: RAISE;

Line 1771: Pa_Debug.reset_curr_function;

1767: THEN
1768: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1769: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1770: l_debug_level5);
1771: Pa_Debug.reset_curr_function;
1772: END IF;
1773: RAISE;
1774: END DELETE_DELIVERABLE_TYPE ;
1775:

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

1835: BEGIN
1836:
1837: x_msg_count := 0;
1838: x_return_status := FND_API.G_RET_STS_SUCCESS;
1839: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1840:
1841: IF l_debug_mode = 'Y' THEN
1842: PA_DEBUG.set_curr_function( p_function => 'CR_UP_DELIVERABLE_TYPE',
1843: p_debug_mode => l_debug_mode );

Line 1842: PA_DEBUG.set_curr_function( p_function => 'CR_UP_DELIVERABLE_TYPE',

1838: x_return_status := FND_API.G_RET_STS_SUCCESS;
1839: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1840:
1841: IF l_debug_mode = 'Y' THEN
1842: PA_DEBUG.set_curr_function( p_function => 'CR_UP_DELIVERABLE_TYPE',
1843: p_debug_mode => l_debug_mode );
1844: END IF;
1845:
1846: IF (p_commit = FND_API.G_TRUE)

Line 1853: PA_DEBUG.g_err_stage:= 'CR_UP_DELIVERABLE_TYPE : Printing Input parameters';

1849: END IF;
1850:
1851: IF l_debug_mode = 'Y'
1852: THEN
1853: PA_DEBUG.g_err_stage:= 'CR_UP_DELIVERABLE_TYPE : Printing Input parameters';
1854: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1855: l_debug_level3);
1856:
1857: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,

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

1850:
1851: IF l_debug_mode = 'Y'
1852: THEN
1853: PA_DEBUG.g_err_stage:= 'CR_UP_DELIVERABLE_TYPE : Printing Input parameters';
1854: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1855: l_debug_level3);
1856:
1857: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1858: l_debug_level3);

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

1853: PA_DEBUG.g_err_stage:= 'CR_UP_DELIVERABLE_TYPE : Printing Input parameters';
1854: PA_DEBUG.WRITE(g_module_name,Pa_Debug.g_err_stage,
1855: l_debug_level3);
1856:
1857: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1858: l_debug_level3);
1859: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1860: l_debug_level3);
1861: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,

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

1855: l_debug_level3);
1856:
1857: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1858: l_debug_level3);
1859: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1860: l_debug_level3);
1861: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1862: l_debug_level3);
1863: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,

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

1857: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_name'||':'||p_deliverable_type_name,
1858: l_debug_level3);
1859: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1860: l_debug_level3);
1861: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1862: l_debug_level3);
1863: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1864: l_debug_level3);
1865: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,

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

1859: PA_DEBUG.WRITE(g_module_name,'p_prog_entry_enable_flag'||':'||p_prog_entry_enable_flag,
1860: l_debug_level3);
1861: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1862: l_debug_level3);
1863: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1864: l_debug_level3);
1865: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1866: l_debug_level3);
1867: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,

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

1861: PA_DEBUG.WRITE(g_module_name,'p_initial_deliverable_status'||':'||p_initial_deliverable_status,
1862: l_debug_level3);
1863: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1864: l_debug_level3);
1865: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1866: l_debug_level3);
1867: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1868: l_debug_level3);
1869: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,

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

1863: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_class'||':'||p_deliverable_type_class,
1864: l_debug_level3);
1865: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1866: l_debug_level3);
1867: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1868: l_debug_level3);
1869: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1870: l_debug_level3);
1871: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,

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

1865: PA_DEBUG.WRITE(g_module_name,'p_enable_dlvr_actions_flag'||':'||p_enable_dlvr_actions_flag,
1866: l_debug_level3);
1867: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1868: l_debug_level3);
1869: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1870: l_debug_level3);
1871: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1872: l_debug_level3);
1873: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,

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

1867: PA_DEBUG.WRITE(g_module_name,'p_effective_from'||':'||p_effective_from,
1868: l_debug_level3);
1869: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1870: l_debug_level3);
1871: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1872: l_debug_level3);
1873: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1874: l_debug_level3);
1875: PA_DEBUG.WRITE(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,

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

1869: PA_DEBUG.WRITE(g_module_name,'p_effective_to'||':'||p_effective_to,
1870: l_debug_level3);
1871: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1872: l_debug_level3);
1873: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1874: l_debug_level3);
1875: PA_DEBUG.WRITE(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,
1876: l_debug_level3);
1877: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,

Line 1875: PA_DEBUG.WRITE(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,

1871: PA_DEBUG.WRITE(g_module_name,'p_description'||':'||p_description,
1872: l_debug_level3);
1873: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1874: l_debug_level3);
1875: PA_DEBUG.WRITE(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,
1876: l_debug_level3);
1877: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1878: l_debug_level3);
1879:

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

1873: PA_DEBUG.WRITE(g_module_name,'p_deliverable_type_id'||':'||p_deliverable_type_id,
1874: l_debug_level3);
1875: PA_DEBUG.WRITE(g_module_name,'p_insert_or_update'||':'||p_insert_or_update,
1876: l_debug_level3);
1877: PA_DEBUG.WRITE(g_module_name,'p_record_version_number'||':'||p_record_version_number,
1878: l_debug_level3);
1879:
1880: END IF;
1881:

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

1890: END IF;
1891:
1892: IF l_debug_mode = 'Y'
1893: THEN
1894: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1895: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1896: l_debug_level3);
1897: END IF;
1898:

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

1891:
1892: IF l_debug_mode = 'Y'
1893: THEN
1894: Pa_Debug.g_err_stage:= 'Validating Input parameters';
1895: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1896: l_debug_level3);
1897: END IF;
1898:
1899: --Check whether the Deliverable Type Name /Start date IS NULL

Line 1909: Pa_Debug.g_err_stage:= 'Calling insert/update';

1905: END IF;
1906:
1907: IF l_debug_mode = 'Y'
1908: THEN
1909: Pa_Debug.g_err_stage:= 'Calling insert/update';
1910: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1911: l_debug_level3);
1912: END IF;
1913:

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

1906:
1907: IF l_debug_mode = 'Y'
1908: THEN
1909: Pa_Debug.g_err_stage:= 'Calling insert/update';
1910: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1911: l_debug_level3);
1912: END IF;
1913:
1914: IF (p_insert_or_update = 'INSERT')

Line 1998: Pa_Debug.reset_curr_function;

1994: END IF;
1995:
1996: IF l_debug_mode = 'Y'
1997: THEN
1998: Pa_Debug.reset_curr_function;
1999: END IF;
2000:
2001: WHEN PA_DLV_INV_PARAM_EXC THEN
2002:

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

2015: , p_error_text => x_msg_data);
2016:
2017: IF l_debug_mode = 'Y'
2018: THEN
2019: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
2020: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2021: l_debug_level5);
2022: Pa_Debug.reset_curr_function;
2023: END IF;

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

2016:
2017: IF l_debug_mode = 'Y'
2018: THEN
2019: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
2020: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2021: l_debug_level5);
2022: Pa_Debug.reset_curr_function;
2023: END IF;
2024: RAISE;

Line 2022: Pa_Debug.reset_curr_function;

2018: THEN
2019: Pa_Debug.g_err_stage:= 'Error'||x_msg_data;
2020: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2021: l_debug_level5);
2022: Pa_Debug.reset_curr_function;
2023: END IF;
2024: RAISE;
2025:
2026: WHEN OTHERS THEN

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

2041: , p_error_text => x_msg_data);
2042:
2043: IF l_debug_mode = 'Y'
2044: THEN
2045: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2046: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2047: l_debug_level5);
2048: Pa_Debug.reset_curr_function;
2049: END IF;

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

2042:
2043: IF l_debug_mode = 'Y'
2044: THEN
2045: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2046: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2047: l_debug_level5);
2048: Pa_Debug.reset_curr_function;
2049: END IF;
2050: RAISE;

Line 2048: Pa_Debug.reset_curr_function;

2044: THEN
2045: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
2046: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2047: l_debug_level5);
2048: Pa_Debug.reset_curr_function;
2049: END IF;
2050: RAISE;
2051: END CR_UP_DELIVERABLE_TYPE ;
2052: