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:
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:
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
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;
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:
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:
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:
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
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;
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:
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:
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
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.
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;
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;
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'
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,
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);
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,
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,
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,
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,
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,
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,
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,
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,
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;
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))
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:
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
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:
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
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:
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:
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:
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;
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;
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
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;
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;
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:
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'
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,
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);
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,
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,
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,
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,
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,
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,
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,
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);
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:
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
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:
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
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;
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;
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:
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;
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;
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
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;
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:
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;
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:
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
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:
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
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:
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:
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:
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;
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;
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
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;
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;
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:
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',
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'
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);
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,
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;
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))
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:
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
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
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
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)
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
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:
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:
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:
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;
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;
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
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;
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;
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:
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 );
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)
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,
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);
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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:
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:
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
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:
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')
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:
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;
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;
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
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;
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;
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: