[Home] [Help]
112:
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;
230:
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;
270:
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:
381: END IF;
382:
383: -- Initialize the Message Stack
384: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: --Check whether any of p_deliverable_type_name,start date is null
389: --If it is null,then raise Invalid parameter exception
449: EXCEPTION
450: -- Set the exception Message and the stack
451: WHEN FND_API.G_EXC_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: l_msg_count := FND_MSG_PUB.count_msg;
454:
455: -- Rollback to the savepoint defined
456: IF p_commit = FND_API.G_TRUE
457: THEN
489: ROLLBACK TO CREATE_DELIVERABLE_TYPE;
490: END IF;
491:
492:
493: Fnd_Msg_Pub.add_exc_msg
494: ( p_pkg_name => 'PA_TASK_TYPE_PVT'
495: , p_procedure_name => 'CREATE_DELIVERABLE_TYPE'
496: , p_error_text => x_msg_data);
497:
515: THEN
516: ROLLBACK TO CREATE_DELIVERABLE_TYPE;
517: END IF;
518:
519: Fnd_Msg_Pub.add_exc_msg
520: ( p_pkg_name => 'PA_TASK_TYPE_PVT'
521: , p_procedure_name => 'CREATE_DELIVERABLE_TYPE'
522: , p_error_text => x_msg_data);
523:
668:
669: -- Initialize the Message Stack
670: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))
671: THEN
672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: -- Save point
676: IF (p_commit = FND_API.G_TRUE)
890: EXCEPTION
891:
892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: l_msg_count := FND_MSG_PUB.count_msg;
895:
896: IF p_commit = FND_API.G_TRUE
897: THEN
898: ROLLBACK TO UPDATE_DELIVERABLE_TYPE;
947: THEN
948: CLOSE c_progress_rec_exists;
949: END IF;
950:
951: Fnd_Msg_Pub.add_exc_msg
952: ( p_pkg_name => 'PA_TASK_TYPE_PVT'
953: , p_procedure_name => 'UPDATE_DELIVERABLE_TYPE'
954: , p_error_text => x_msg_data);
955:
982: THEN
983: CLOSE c_progress_rec_exists;
984: END IF;
985:
986: Fnd_Msg_Pub.add_exc_msg
987: (p_pkg_name => 'PA_TASK_TYPE_PVT'
988: , p_procedure_name => 'UPDATE_DELIVERABLE_TYPE'
989: , p_error_text => x_msg_data);
990:
1071:
1072: --Initialize the Message Stack
1073: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE))
1074: THEN
1075: FND_MSG_PUB.initialize;
1076: END IF;
1077:
1078: IF l_debug_mode = 'Y'
1079: THEN
1124: EXCEPTION
1125:
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: l_msg_count := FND_MSG_PUB.count_msg;
1129:
1130: IF p_commit = FND_API.G_TRUE
1131: THEN
1132: ROLLBACK TO DELETE_DELIVERABLE_TYPE;
1162: THEN
1163: ROLLBACK TO DELETE_DELIVERABLE_TYPE;
1164: END IF;
1165:
1166: Fnd_Msg_Pub.add_exc_msg
1167: ( p_pkg_name => 'PA_TASK_TYPE_PVT'
1168: , p_procedure_name => 'DELETE_DELIVERABLE_TYPE'
1169: , p_error_text => x_msg_data);
1170: