eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DELIVERABLE_PVT dependencies on FND_API

Line 18: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE

14:
15: -- Parameters Type Required Description and Purpose
16: -- --------------------------- ------ -------- --------------------------------------------------------
17: -- p_api_version NUMBER N 1.0
18: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
19: -- p_commit VARCHAR2 N := FND_API.G_FALSE
20: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
21: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
22: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'

Line 19: -- p_commit VARCHAR2 N := FND_API.G_FALSE

15: -- Parameters Type Required Description and Purpose
16: -- --------------------------- ------ -------- --------------------------------------------------------
17: -- p_api_version NUMBER N 1.0
18: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
19: -- p_commit VARCHAR2 N := FND_API.G_FALSE
20: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
21: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
22: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
23: -- p_debug_mode VARCHAR2 N := 'N'

Line 20: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE

16: -- --------------------------- ------ -------- --------------------------------------------------------
17: -- p_api_version NUMBER N 1.0
18: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
19: -- p_commit VARCHAR2 N := FND_API.G_FALSE
20: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
21: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
22: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
23: -- p_debug_mode VARCHAR2 N := 'N'
24: -- p_max_msg_count NUMBER N := NULL

Line 21: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL

17: -- p_api_version NUMBER N 1.0
18: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
19: -- p_commit VARCHAR2 N := FND_API.G_FALSE
20: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
21: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
22: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
23: -- p_debug_mode VARCHAR2 N := 'N'
24: -- p_max_msg_count NUMBER N := NULL
25: -- p_record_version_number NUMBER N := 1

Line 71: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

67:
68: PROCEDURE Create_Deliverable
69: (
70: p_api_version IN NUMBER := 1.0
71: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
72: , p_commit IN VARCHAR2 := FND_API.G_FALSE
73: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
74: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 72: , p_commit IN VARCHAR2 := FND_API.G_FALSE

68: PROCEDURE Create_Deliverable
69: (
70: p_api_version IN NUMBER := 1.0
71: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
72: , p_commit IN VARCHAR2 := FND_API.G_FALSE
73: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
74: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
76: , p_debug_mode IN VARCHAR2 := 'N'

Line 73: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE

69: (
70: p_api_version IN NUMBER := 1.0
71: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
72: , p_commit IN VARCHAR2 := FND_API.G_FALSE
73: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
74: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
76: , p_debug_mode IN VARCHAR2 := 'N'
77: , p_max_msg_count IN NUMBER := NULL

Line 74: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

70: p_api_version IN NUMBER := 1.0
71: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
72: , p_commit IN VARCHAR2 := FND_API.G_FALSE
73: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
74: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
75: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
76: , p_debug_mode IN VARCHAR2 := 'N'
77: , p_max_msg_count IN NUMBER := NULL
78: , p_record_version_number IN NUMBER := 1

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148:
149: BEGIN
150:
151: x_msg_count := 0;
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
154:
155: IF l_debug_mode = 'Y' THEN
156: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',

Line 160: IF (p_commit = FND_API.G_TRUE) THEN

156: PA_DEBUG.set_curr_function( p_function => 'CREATE_DELIVERABLE',
157: p_debug_mode => l_debug_mode );
158: END IF;
159:
160: IF (p_commit = FND_API.G_TRUE) THEN
161: savepoint CREATE_DLVR_PVT;
162: END IF;
163:
164: -- Business Logic

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: IF l_prog_rollup_method = g_deliverable_based THEN
201: IF p_progress_weight IS NULL THEN
202: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
203: p_msg_name => 'PA_DLVR_PROG_WEIGHT_MISSING');
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: END IF;
206: END IF;
207:
208: END IF;

Line 215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

211: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Insert_Row Called ',
212: l_debug_level3);
213: END IF;
214:
215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: -- 3570283 added

Line 216: RAISE FND_API.G_EXC_ERROR;

212: l_debug_level3);
213: END IF;
214:
215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: -- 3570283 added
220: -- if deliverable type is changed from progress enabled type to disabled type

Line 435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

431: ,x_object_relationship_id => l_new_obj_rel_id
432: ,x_return_status => x_return_status
433: );
434:
435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438:
439: IF l_debug_mode = 'Y' THEN

Line 436: RAISE FND_API.G_EXC_ERROR;

432: ,x_return_status => x_return_status
433: );
434:
435: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;
438:
439: IF l_debug_mode = 'Y' THEN
440: Pa_Debug.WRITE(g_module_name,' Out of PA_OBJECT_RELATIONSHIPS_PKG.Insert_Row Structure-To-Deliverable str vers ['

Line 499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

495: Pa_Debug.WRITE(g_module_name,' Out of PA_DELIVERABLE_PVT.CREATE_DLV_TASK_ASSOCIATION Task-To-Dlvr['||x_return_status||']',
496: l_debug_level3);
497: END IF;
498:
499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
503: END IF;

Line 500: RAISE FND_API.G_EXC_ERROR;

496: l_debug_level3);
497: END IF;
498:
499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
503: END IF;
504:

Line 538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

534: IF l_debug_mode = 'Y' THEN
535: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ['||x_return_status||']', l_debug_level3);
536: END IF;
537:
538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: END IF; --p_calling_module <> 'AMG'
542:

Line 539: RAISE FND_API.G_EXC_ERROR;

535: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ['||x_return_status||']', l_debug_level3);
536: END IF;
537:
538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: END IF; --p_calling_module <> 'AMG'
542:
543: IF l_debug_mode = 'Y' THEN --Added for bug 4945876

Line 547: x_return_status := FND_API.G_RET_STS_SUCCESS;

543: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
544: pa_debug.reset_curr_function;
545: END IF ;
546:
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548:
549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN

Line 551: WHEN FND_API.G_EXC_ERROR THEN

547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548:
549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
553: l_msg_count := Fnd_Msg_Pub.count_msg;
554:
555: IF p_commit = FND_API.G_TRUE THEN

Line 552: x_return_status := Fnd_Api.G_RET_STS_ERROR;

548:
549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
553: l_msg_count := Fnd_Msg_Pub.count_msg;
554:
555: IF p_commit = FND_API.G_TRUE THEN
556: ROLLBACK TO CREATE_DLVR_PVT;

Line 555: IF p_commit = FND_API.G_TRUE THEN

551: WHEN FND_API.G_EXC_ERROR THEN
552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
553: l_msg_count := Fnd_Msg_Pub.count_msg;
554:
555: IF p_commit = FND_API.G_TRUE THEN
556: ROLLBACK TO CREATE_DLVR_PVT;
557: END IF;
558:
559: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 562: ( p_encoded => Fnd_Api.G_TRUE

558:
559: IF l_msg_count = 1 AND x_msg_data IS NULL
560: THEN
561: Pa_Interface_Utils_Pub.get_messages
562: ( p_encoded => Fnd_Api.G_TRUE
563: , p_msg_index => 1
564: , p_msg_count => l_msg_count
565: , p_msg_data => l_msg_data
566: , p_data => l_data

Line 579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

575: END IF;
576:
577: WHEN OTHERS THEN
578:
579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
580: x_msg_count := 1;
581: x_msg_data := SQLERRM;
582:
583: IF p_commit = FND_API.G_TRUE THEN

Line 583: IF p_commit = FND_API.G_TRUE THEN

579: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
580: x_msg_count := 1;
581: x_msg_data := SQLERRM;
582:
583: IF p_commit = FND_API.G_TRUE THEN
584: ROLLBACK TO CREATE_DLVR_PVT;
585: END IF;
586:
587: Fnd_Msg_Pub.add_exc_msg

Line 613: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE

609:
610: -- Parameters Type Required Description and Purpose
611: -- --------------------------- ------ -------- --------------------------------------------------------
612: -- p_api_version NUMBER N 1.0
613: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
614: -- p_commit VARCHAR2 N := FND_API.G_FALSE
615: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
616: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
617: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'

Line 614: -- p_commit VARCHAR2 N := FND_API.G_FALSE

610: -- Parameters Type Required Description and Purpose
611: -- --------------------------- ------ -------- --------------------------------------------------------
612: -- p_api_version NUMBER N 1.0
613: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
614: -- p_commit VARCHAR2 N := FND_API.G_FALSE
615: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
616: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
617: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
618: -- p_debug_mode VARCHAR2 N := 'N'

Line 615: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE

611: -- --------------------------- ------ -------- --------------------------------------------------------
612: -- p_api_version NUMBER N 1.0
613: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
614: -- p_commit VARCHAR2 N := FND_API.G_FALSE
615: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
616: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
617: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
618: -- p_debug_mode VARCHAR2 N := 'N'
619: -- p_max_msg_count NUMBER N := NULL

Line 616: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL

612: -- p_api_version NUMBER N 1.0
613: -- p_init_msg_list VARCHAR2 N := FND_API.G_TRUE
614: -- p_commit VARCHAR2 N := FND_API.G_FALSE
615: -- p_validate_only VARCHAR2 N := FND_API.G_TRUE
616: -- p_validation_level NUMBER N := FND_API.G_VALID_LEVEL_FULL
617: -- p_calling_module VARCHAR2 N := 'SELF_SERVICE'
618: -- p_debug_mode VARCHAR2 N := 'N'
619: -- p_max_msg_count NUMBER N := NULL
620: -- p_record_version_number NUMBER N := 1

Line 666: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

662:
663: PROCEDURE Update_Deliverable
664: (
665: p_api_version IN NUMBER := 1.0
666: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
667: , p_commit IN VARCHAR2 := FND_API.G_FALSE
668: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
669: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
670: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 667: , p_commit IN VARCHAR2 := FND_API.G_FALSE

663: PROCEDURE Update_Deliverable
664: (
665: p_api_version IN NUMBER := 1.0
666: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
667: , p_commit IN VARCHAR2 := FND_API.G_FALSE
668: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
669: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
670: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
671: , p_debug_mode IN VARCHAR2 := 'N'

Line 668: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE

664: (
665: p_api_version IN NUMBER := 1.0
666: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
667: , p_commit IN VARCHAR2 := FND_API.G_FALSE
668: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
669: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
670: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
671: , p_debug_mode IN VARCHAR2 := 'N'
672: , p_max_msg_count IN NUMBER := NULL

Line 669: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

665: p_api_version IN NUMBER := 1.0
666: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
667: , p_commit IN VARCHAR2 := FND_API.G_FALSE
668: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
669: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
670: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
671: , p_debug_mode IN VARCHAR2 := 'N'
672: , p_max_msg_count IN NUMBER := NULL
673: , p_record_version_number IN NUMBER := 1

Line 856: x_return_status := FND_API.G_RET_STS_SUCCESS;

852:
853:
854: BEGIN
855: x_msg_count := 0;
856: x_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
858:
859: IF l_debug_mode = 'Y' THEN
860: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',

Line 864: IF (p_commit = FND_API.G_TRUE) THEN

860: PA_DEBUG.set_curr_function( p_function => 'UPDATE_DELIVERABLE',
861: p_debug_mode => l_debug_mode );
862: END IF;
863:
864: IF (p_commit = FND_API.G_TRUE) THEN
865: savepoint UPDATE_DLVR_PVT;
866: END IF;
867:
868: IF l_debug_mode = 'Y' THEN

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900: IF l_prog_rollup_method = g_deliverable_based THEN
901: IF p_progress_weight IS NULL THEN
902: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
903: p_msg_name => 'PA_DLVR_PROG_WEIGHT_MISSING');
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: END IF;
907: */
908:

Line 949: x_return_status := FND_API.G_RET_STS_ERROR;

945: IF l_dlvr_based_assc_exists = 'Y' THEN
946: IF p_progress_weight IS NULL THEN
947: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
948: p_msg_name => 'PA_DLVR_PROG_WEIGHT_MISSING');
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: END IF;
951: END IF;
952:
953: END IF;

Line 1019: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1015: -- set l_function_call_done to 'Y' if PA_DELIVERABLE_UTILS.PA_DLVR_OKE_INTEGRATION
1016: -- if l_function_call_done is set to 'Y' , the above function will not be called again
1017: l_function_call_done := 'Y';
1018:
1019: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021: END IF;
1022:
1023:

Line 1020: x_return_status := FND_API.G_RET_STS_ERROR;

1016: -- if l_function_call_done is set to 'Y' , the above function will not be called again
1017: l_function_call_done := 'Y';
1018:
1019: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021: END IF;
1022:
1023:
1024: IF l_debug_mode = 'Y' THEN

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR;

1028:
1029: IF l_ship_procure_flag_dlv = 'Y' THEN
1030: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1031: p_msg_name => 'PA_DLV_DUEDATECHG_NOT_ALLOWED');
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: END IF;
1034:
1035: END IF;
1036:

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059:
1060: IF p_actual_finish_date IS NOT NULL AND l_system_status_code <> l_complete_sys_status_code THEN
1061: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1062: p_msg_name => 'PA_DLVR_STATUS_NOT_COMPLETED');
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1065:
1066: -- if user changes deliverable status to dlvr_completed , user must enter actual_finish_date ( i.e. completion date )
1067: -- if user doesn't enter completion date, set return status to error

Line 1072: x_return_status := FND_API.G_RET_STS_ERROR;

1068:
1069: IF l_system_status_code = l_complete_sys_status_code AND p_actual_finish_date IS NULL THEN
1070: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1071: p_msg_name => 'PA_DLVR_COMPLT_DATE_MISSING');
1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073: END IF;
1074:
1075: -- if status is completed, check for the deliverable completion validations
1076: -- 1. document is defined or not ( if document based deliverable )

Line 1095: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1091: ,x_msg_count => l_utl_msg_count
1092: ,x_msg_data => l_utl_msg_data
1093: );
1094:
1095: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098: END IF;
1099:

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092: ,x_msg_data => l_utl_msg_data
1093: );
1094:
1095: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098: END IF;
1099:
1100: IF l_debug_mode = 'Y' THEN

Line 1142: x_return_status := FND_API.G_RET_STS_ERROR;

1138:
1139: IF l_system_status_code <> l_not_started_sys_status_code THEN
1140: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1141: p_msg_name => 'PA_DLV_NOT_START_ONLY_ALLOWED');
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: END IF;
1144: END IF;
1145: -- END IF;
1146: END IF;

Line 1180: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1176: ,x_msg_data => l_utl_msg_data
1177: );
1178:
1179: -- 4229934 based on the return status , setting x_return_status
1180: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: END IF;
1183:
1184: -- commented below code which populates error message

Line 1181: x_return_status := FND_API.G_RET_STS_ERROR;

1177: );
1178:
1179: -- 4229934 based on the return status , setting x_return_status
1180: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: END IF;
1183:
1184: -- commented below code which populates error message
1185: -- because above api call takes care of populating it

Line 1187: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1183:
1184: -- commented below code which populates error message
1185: -- because above api call takes care of populating it
1186: /*
1187: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1188: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1189: p_msg_name => 'PA_DLV_STATUS_CHG_NOT_ALLOWED');
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: END IF;

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

1186: /*
1187: IF l_utl_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1188: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1189: p_msg_name => 'PA_DLV_STATUS_CHG_NOT_ALLOWED');
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: END IF;
1192: */
1193: -- 4229934 end
1194: END IF;

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR;

1210: );
1211: IF is_dlvr_actions_exists = 'Y' THEN
1212: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1213: p_msg_name => 'PA_DLVR_ACTION_EXISTS');
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: END IF;
1216:
1217: l_dlvr_has_progress := PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS
1218: (

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224:
1225: IF l_dlvr_has_progress = 'Y' THEN
1226: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1227: p_msg_name => 'PA_DLVR_PROGRESS_EXISTS');
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: END IF;
1230:
1231: END IF;
1232:

Line 1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1235: l_debug_level3);
1236: END IF;
1237:
1238:
1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: IF l_debug_mode = 'Y' THEN

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: END IF;
1237:
1238:
1239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: IF l_debug_mode = 'Y' THEN
1244: Pa_Debug.WRITE(g_module_name,' x_return_status ' || x_return_status,

Line 1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1481: Pa_Debug.WRITE(g_module_name,' Out of PA_ACTIONS_PUB.COPY_ACTIONS ',
1482: l_debug_level3);
1483: END IF;
1484:
1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: RAISE FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489: END IF;

Line 1486: RAISE FND_API.G_EXC_ERROR;

1482: l_debug_level3);
1483: END IF;
1484:
1485: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1486: RAISE FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489: END IF;
1490:

Line 1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1505: ,x_msg_count => x_msg_count
1506: ,x_msg_data => x_msg_data
1507: );
1508:
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1510: RAISE FND_API.G_EXC_ERROR;
1511: END IF;
1512:
1513: END IF;

Line 1510: RAISE FND_API.G_EXC_ERROR;

1506: ,x_msg_data => x_msg_data
1507: );
1508:
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1510: RAISE FND_API.G_EXC_ERROR;
1511: END IF;
1512:
1513: END IF;
1514:

Line 1515: x_return_status := FND_API.G_RET_STS_SUCCESS;

1511: END IF;
1512:
1513: END IF;
1514:
1515: x_return_status := FND_API.G_RET_STS_SUCCESS;
1516: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
1517: pa_debug.reset_curr_function;
1518: END IF ;
1519:

Line 1522: WHEN FND_API.G_EXC_ERROR THEN

1518: END IF ;
1519:
1520: EXCEPTION
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1524: l_msg_count := Fnd_Msg_Pub.count_msg;
1525:
1526: IF l_row_id_ppe_csr%ISOPEN THEN

Line 1523: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1519:
1520: EXCEPTION
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1524: l_msg_count := Fnd_Msg_Pub.count_msg;
1525:
1526: IF l_row_id_ppe_csr%ISOPEN THEN
1527: CLOSE l_row_id_ppe_csr;

Line 1546: IF p_commit = FND_API.G_TRUE THEN

1542: IF l_dlvr_info_csr%ISOPEN THEN
1543: CLOSE l_dlvr_info_csr;
1544: END IF;
1545:
1546: IF p_commit = FND_API.G_TRUE THEN
1547: ROLLBACK TO UPDATE_DLVR_PVT;
1548: END IF;
1549:
1550: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 1553: ( p_encoded => Fnd_Api.G_TRUE

1549:
1550: IF l_msg_count = 1 AND x_msg_data IS NULL
1551: THEN
1552: Pa_Interface_Utils_Pub.get_messages
1553: ( p_encoded => Fnd_Api.G_TRUE
1554: , p_msg_index => 1
1555: , p_msg_count => l_msg_count
1556: , p_msg_data => l_msg_data
1557: , p_data => l_data

Line 1570: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1566: END IF;
1567:
1568: WHEN OTHERS THEN
1569:
1570: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1571: x_msg_count := 1;
1572: x_msg_data := SQLERRM;
1573:
1574: IF l_row_id_ppe_csr%ISOPEN THEN

Line 1594: IF p_commit = FND_API.G_TRUE THEN

1590: IF l_dlvr_info_csr%ISOPEN THEN
1591: CLOSE l_dlvr_info_csr;
1592: END IF;
1593:
1594: IF p_commit = FND_API.G_TRUE THEN
1595: ROLLBACK TO UPDATE_DLVR_PVT;
1596: END IF;
1597:
1598: Fnd_Msg_Pub.add_exc_msg

Line 1638: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

1634:
1635:
1636: PROCEDURE delete_deliverable
1637: (p_api_version IN NUMBER :=1.0
1638: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1639: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 1639: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

1635:
1636: PROCEDURE delete_deliverable
1637: (p_api_version IN NUMBER :=1.0
1638: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1639: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1643: ,p_debug_mode IN VARCHAR2 :='N'

Line 1640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

1636: PROCEDURE delete_deliverable
1637: (p_api_version IN NUMBER :=1.0
1638: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1639: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1643: ,p_debug_mode IN VARCHAR2 :='N'
1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

1637: (p_api_version IN NUMBER :=1.0
1638: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1639: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1640: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1643: ,p_debug_mode IN VARCHAR2 :='N'
1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

Line 1675: x_return_status := FND_API.G_RET_STS_SUCCESS;

1671:
1672: BEGIN
1673:
1674: x_msg_count := 0;
1675: x_return_status := FND_API.G_RET_STS_SUCCESS;
1676: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1677:
1678: IF l_debug_mode = 'Y' THEN
1679: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE',

Line 1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1689: pa_debug.write(g_module_name,'p_dlv_version_id'||':'||p_dlv_version_id,3) ;
1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;
1692:
1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1694: FND_MSG_PUB.initialize;
1695: END IF;
1696:
1697: IF (p_commit = FND_API.G_TRUE) THEN

Line 1697: IF (p_commit = FND_API.G_TRUE) THEN

1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1694: FND_MSG_PUB.initialize;
1695: END IF;
1696:
1697: IF (p_commit = FND_API.G_TRUE) THEN
1698: savepoint DELETE_DELIVERABLE_SP ;
1699: END IF;
1700:
1701: IF l_debug_mode = 'Y' THEN

Line 1713: x_return_status := FND_API.G_RET_STS_ERROR;

1709: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
1710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1711: END IF;
1712:
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1715: ,p_msg_name => 'PA_INV_PARAM_PASSED');
1716: RAISE Invalid_Arg_Exc_Dlv;
1717: END IF;

Line 1749: x_return_status := FND_API.G_RET_STS_ERROR;

1745: END IF ;
1746:
1747:
1748: IF nvl(PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,p_dlv_element_id),'N') = 'Y' THEN
1749: x_return_status := FND_API.G_RET_STS_ERROR;
1750: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_PROGRESS_NO_DLTN') ;
1751: END IF ;
1752:
1753: -- 3555460 added validation for checking shipping action is initiated or not

Line 1759: x_return_status := FND_API.G_RET_STS_ERROR;

1755: -- else check for ready to ship flags for shipping action
1756: -- if ready to ship flag is set for shipping action, throw error message for ready to ship
1757:
1758: IF nvl(PA_DELIVERABLE_UTILS.IS_SHIPPING_INITIATED(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_SHIP_INIT_ERR') ;
1761: ELSE
1762: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_SHIP_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1763: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1763: x_return_status := FND_API.G_RET_STS_ERROR;

1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_SHIP_INIT_ERR') ;
1761: ELSE
1762: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_SHIP_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1763: x_return_status := FND_API.G_RET_STS_ERROR;
1764: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_SHIP_ACTION_NO_DLTN') ;
1765: END IF ;
1766: END IF;
1767:

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771: -- if ready to ship flag is set for procurement action, throw error message for ready to procure
1772:
1773:
1774: IF nvl(PA_DELIVERABLE_UTILS.IS_PROCUREMENT_INITIATED(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_PROC_INIT_ERR') ;
1777: ELSE
1778: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_PROC_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1779: x_return_status := FND_API.G_RET_STS_ERROR;

1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_PROC_INIT_ERR') ;
1777: ELSE
1778: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_PROC_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_PROC_ACTION_NO_DLTN') ;
1781: END IF ;
1782: END IF;
1783:

Line 1792: x_return_status := FND_API.G_RET_STS_ERROR;

1788: -- end if
1789:
1790: IF nvl(PA_DELIVERABLE_UTILS.IS_BILLING_FUNCTION_EXISTS(p_project_id,p_dlv_element_id),'N') = 'Y' THEN
1791: IF nvl(PA_DELIVERABLE_UTILS.IS_BILLING_EVENT_PROCESSED(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_BILL_PROC_ERR') ;
1794: ELSE
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_BILLING_FUNC_NO_DLTN') ;

Line 1795: x_return_status := FND_API.G_RET_STS_ERROR;

1791: IF nvl(PA_DELIVERABLE_UTILS.IS_BILLING_EVENT_PROCESSED(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DLVR_BILL_PROC_ERR') ;
1794: ELSE
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_BILLING_FUNC_NO_DLTN') ;
1797: END IF;
1798: END IF ;
1799:

Line 1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1796: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_BILLING_FUNC_NO_DLTN') ;
1797: END IF;
1798: END IF ;
1799:
1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: RAISE FND_API.G_EXC_ERROR;
1802: END IF;
1803:
1804: -- 3733321 Added code to retrieve deliverable deliverable type

Line 1801: RAISE FND_API.G_EXC_ERROR;

1797: END IF;
1798: END IF ;
1799:
1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: RAISE FND_API.G_EXC_ERROR;
1802: END IF;
1803:
1804: -- 3733321 Added code to retrieve deliverable deliverable type
1805:

Line 1901: , p_commit => FND_API.G_FALSE

1897:
1898: oke_amg_grp.manage_dlv
1899: ( p_api_version => p_api_version
1900: , p_init_msg_list => p_init_msg_list
1901: , p_commit => FND_API.G_FALSE
1902: , p_action => 'DELETE'
1903: , p_item_dlv => l_item_dlv
1904: , p_master_inv_org_id => l_master_inv_org_id
1905: , p_dlv_rec => l_dlv_rec

Line 1912: x_return_status := FND_API.G_RET_STS_SUCCESS;

1908: , x_msg_count => x_msg_count
1909: );
1910:
1911: ELSE
1912: x_return_status := FND_API.G_RET_STS_SUCCESS;
1913: OKE_DELIVERABLE_UTILS_PUB.DELETE_DELIVERABLE
1914: ( P_DELIVERABLE_ID => p_dlv_version_id
1915: , X_Return_Status => x_return_status
1916: , X_Msg_Count => x_msg_count

Line 1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1921: IF l_debug_mode = 'Y' THEN
1922: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']', 3);
1923: END IF;
1924:
1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;

Line 1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1922: Pa_Debug.WRITE(g_module_name,' Returned from oke_amg_grp.manage_dlv['||x_return_status||']', 3);
1923: END IF;
1924:
1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;
1930:

Line 1927: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1923: END IF;
1924:
1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;
1930:
1931: -- delete the deliverable actions which are associated with this deliverable

Line 1928: RAISE FND_API.G_EXC_ERROR;

1924:
1925: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: END IF;
1930:
1931: -- delete the deliverable actions which are associated with this deliverable
1932: -- and delete the action's association with the deliverable

Line 1969: x_return_status := FND_API.G_RET_STS_ERROR;

1965: END IF;
1966:
1967: EXCEPTION
1968: WHEN Invalid_Arg_Exc_Dlv THEN
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: l_msg_count := FND_MSG_PUB.count_msg;
1971:
1972: IF p_commit = FND_API.G_TRUE THEN
1973: ROLLBACK TO DELETE_DELIVERABLE_SP;

Line 1972: IF p_commit = FND_API.G_TRUE THEN

1968: WHEN Invalid_Arg_Exc_Dlv THEN
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: l_msg_count := FND_MSG_PUB.count_msg;
1971:
1972: IF p_commit = FND_API.G_TRUE THEN
1973: ROLLBACK TO DELETE_DELIVERABLE_SP;
1974: END IF;
1975:
1976: IF l_debug_mode = 'Y' THEN

Line 1983: (p_encoded => FND_API.G_FALSE,

1979: END IF;
1980:
1981: IF l_msg_count = 1 THEN
1982: PA_INTERFACE_UTILS_PUB.get_messages
1983: (p_encoded => FND_API.G_FALSE,
1984: p_msg_index => 1,
1985: p_msg_count => l_msg_count,
1986: p_msg_data => l_msg_data,
1987: p_data => l_data,

Line 1999: WHEN FND_API.G_EXC_ERROR THEN

1995: pa_debug.reset_curr_function;
1996: END IF ;
1997: RETURN;
1998:
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2001: l_msg_count := Fnd_Msg_Pub.count_msg;
2002:
2003: IF p_commit = FND_API.G_TRUE THEN

Line 2000: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1996: END IF ;
1997: RETURN;
1998:
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2001: l_msg_count := Fnd_Msg_Pub.count_msg;
2002:
2003: IF p_commit = FND_API.G_TRUE THEN
2004: ROLLBACK TO DELETE_DELIVERABLE_SP;

Line 2003: IF p_commit = FND_API.G_TRUE THEN

1999: WHEN FND_API.G_EXC_ERROR THEN
2000: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2001: l_msg_count := Fnd_Msg_Pub.count_msg;
2002:
2003: IF p_commit = FND_API.G_TRUE THEN
2004: ROLLBACK TO DELETE_DELIVERABLE_SP;
2005: END IF;
2006:
2007: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 2010: ( p_encoded => Fnd_Api.G_FALSE

2006:
2007: IF l_msg_count = 1 AND x_msg_data IS NULL
2008: THEN
2009: Pa_Interface_Utils_Pub.get_messages
2010: ( p_encoded => Fnd_Api.G_FALSE
2011: , p_msg_index => 1
2012: , p_msg_count => l_msg_count
2013: , p_msg_data => l_msg_data
2014: , p_data => l_data

Line 2028: IF p_commit = FND_API.G_TRUE THEN

2024: Pa_Debug.reset_curr_function;
2025: END IF;
2026:
2027: WHEN OTHERS THEN
2028: IF p_commit = FND_API.G_TRUE THEN
2029: ROLLBACK TO DELETE_DELIVERABLE_SP;
2030: END IF;
2031:
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2028: IF p_commit = FND_API.G_TRUE THEN
2029: ROLLBACK TO DELETE_DELIVERABLE_SP;
2030: END IF;
2031:
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: x_msg_count := 1;
2034: x_msg_data := SQLERRM;
2035:
2036: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

Line 2076: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2072: -- x_msg_data OUT VARCHAR2 N Standard Out Parameter
2073:
2074: PROCEDURE DELETE_DLV_TASK_ASSOCIATION
2075: (p_api_version IN NUMBER :=1.0
2076: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2077: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2078: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2077: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2073:
2074: PROCEDURE DELETE_DLV_TASK_ASSOCIATION
2075: (p_api_version IN NUMBER :=1.0
2076: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2077: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2078: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2081: ,p_debug_mode IN VARCHAR2 :='N'

Line 2078: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2074: PROCEDURE DELETE_DLV_TASK_ASSOCIATION
2075: (p_api_version IN NUMBER :=1.0
2076: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2077: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2078: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2081: ,p_debug_mode IN VARCHAR2 :='N'
2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2075: (p_api_version IN NUMBER :=1.0
2076: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2077: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2078: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2081: ,p_debug_mode IN VARCHAR2 :='N'
2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

Line 2106: x_return_status := FND_API.G_RET_STS_SUCCESS;

2102:
2103: BEGIN
2104:
2105: x_msg_count := 0;
2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2108:
2109: IF l_debug_mode = 'Y' THEN
2110: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',

Line 2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2112: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2114: END IF;
2115:
2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2117: FND_MSG_PUB.initialize;
2118: END IF;
2119:
2120: IF (p_commit = FND_API.G_TRUE) THEN

Line 2120: IF (p_commit = FND_API.G_TRUE) THEN

2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2117: FND_MSG_PUB.initialize;
2118: END IF;
2119:
2120: IF (p_commit = FND_API.G_TRUE) THEN
2121: savepoint DEL_DLV_TASK_ASSOCIATION_SP ;
2122: END IF;
2123:
2124: -- 3888280 start

Line 2146: ,p_init_msg_list => FND_API.G_FALSE

2142: END IF ;
2143:
2144: PA_DELIVERABLE_PVT.IS_DISASSOCIATION_ALLOWED
2145: (p_api_version => p_api_version
2146: ,p_init_msg_list => FND_API.G_FALSE
2147: ,p_commit => p_commit
2148: ,p_validate_only => p_validate_only
2149: ,p_validation_level => p_validation_level
2150: ,p_calling_module => p_calling_module

Line 2176: IF (nvl(l_disassociation_allowed,'Y') = 'N' OR x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2172: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2173: END IF ;
2174:
2175:
2176: IF (nvl(l_disassociation_allowed,'Y') = 'N' OR x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2177: RAISE Invalid_Arg_Exc_Dlv ;
2178: END IF ;
2179: ELSE
2180:

Line 2214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2210: pa_debug.g_err_stage:= 'x_return_status is'|| x_return_status;
2211: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2212: END IF ;
2213:
2214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2215: RAISE Invalid_Arg_Exc_Dlv ;
2216: END IF ;
2217:
2218: IF l_debug_mode = 'Y' THEN

Line 2226: x_return_status := FND_API.G_RET_STS_ERROR;

2222: END IF;
2223:
2224: EXCEPTION
2225: WHEN Invalid_Arg_Exc_Dlv THEN
2226: x_return_status := FND_API.G_RET_STS_ERROR;
2227: l_msg_count := FND_MSG_PUB.count_msg;
2228:
2229: IF (p_commit = FND_API.G_TRUE) THEN
2230: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;

Line 2229: IF (p_commit = FND_API.G_TRUE) THEN

2225: WHEN Invalid_Arg_Exc_Dlv THEN
2226: x_return_status := FND_API.G_RET_STS_ERROR;
2227: l_msg_count := FND_MSG_PUB.count_msg;
2228:
2229: IF (p_commit = FND_API.G_TRUE) THEN
2230: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;
2231: END IF ;
2232:
2233: IF l_debug_mode = 'Y' THEN

Line 2240: (p_encoded => FND_API.G_TRUE,

2236: END IF;
2237:
2238: IF l_msg_count = 1 THEN
2239: PA_INTERFACE_UTILS_PUB.get_messages
2240: (p_encoded => FND_API.G_TRUE,
2241: p_msg_index => 1,
2242: p_msg_count => l_msg_count,
2243: p_msg_data => l_msg_data,
2244: p_data => l_data,

Line 2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2252: pa_debug.reset_curr_function;
2253: END IF ;
2254: RETURN;
2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: x_msg_count := 1;
2258: x_msg_data := SQLERRM;
2259:
2260: IF (p_commit = FND_API.G_TRUE) THEN

Line 2260: IF (p_commit = FND_API.G_TRUE) THEN

2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: x_msg_count := 1;
2258: x_msg_data := SQLERRM;
2259:
2260: IF (p_commit = FND_API.G_TRUE) THEN
2261: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;
2262: END IF ;
2263:
2264: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

Line 2303: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2299: -- x_msg_data OUT VARCHAR2 N Standard Out Parameter
2300:
2301: PROCEDURE IS_DISASSOCIATION_ALLOWED
2302: (p_api_version IN NUMBER :=1.0
2303: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2304: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2305: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2304: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2300:
2301: PROCEDURE IS_DISASSOCIATION_ALLOWED
2302: (p_api_version IN NUMBER :=1.0
2303: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2304: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2305: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2308: ,p_debug_mode IN VARCHAR2 :='N'

Line 2305: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2301: PROCEDURE IS_DISASSOCIATION_ALLOWED
2302: (p_api_version IN NUMBER :=1.0
2303: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2304: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2305: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2308: ,p_debug_mode IN VARCHAR2 :='N'
2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2302: (p_api_version IN NUMBER :=1.0
2303: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2304: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2305: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2308: ,p_debug_mode IN VARCHAR2 :='N'
2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

Line 2324: x_return_status := FND_API.G_RET_STS_SUCCESS;

2320: )
2321: IS
2322: BEGIN
2323: x_msg_count := 0;
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: IF p_debug_mode = 'Y' THEN
2327: pa_debug.set_curr_function( p_function => 'IS_DISASSOCIATION_ALLOWED',
2328: p_debug_mode => p_debug_mode );

Line 2333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2329: pa_debug.g_err_stage:= 'Inside IS_DISASSOCIATION_ALLOWED ,Calling Context is ' || p_calling_context;
2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2331: END IF;
2332:
2333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2334: FND_MSG_PUB.initialize;
2335: END IF;
2336:
2337:

Line 2351: x_return_status := FND_API.G_RET_STS_ERROR;

2347: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_PROGRESS_NO_DISASCN') ;
2348: ELSIF p_calling_context = 'DELIVERABLES' THEN
2349: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_PROGRESS_NO_DISASCN') ;
2350: END IF ;
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: x_disassociation_allowed := 'N';
2353: END IF ;
2354: END IF ;
2355: END IF ;

Line 2362: x_return_status := FND_API.G_RET_STS_ERROR;

2358: --If the workplan task is deliverable based, and deliverable associated to the task has progress records
2359: --So,Rest of the validations need to be commented out .
2360: /*IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_SHIP_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
2361: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_SHIP_ACTION_NO_DISASCN') ;
2362: x_return_status := FND_API.G_RET_STS_ERROR;
2363: x_disassociation_allowed := 'N';
2364: END IF ;
2365:
2366: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_PROC_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN

Line 2368: x_return_status := FND_API.G_RET_STS_ERROR;

2364: END IF ;
2365:
2366: IF nvl(PA_DELIVERABLE_UTILS.GET_READY_TO_PROC_FLAG(p_dlv_element_id,p_dlv_version_id),'N') = 'Y' THEN
2367: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_PROC_ACTION_NO_DISASCN') ;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: x_disassociation_allowed := 'N';
2370: END IF ;
2371:
2372: IF nvl(PA_DELIVERABLE_UTILS.IS_BILLING_FUNCTION_EXISTS(p_project_id,p_dlv_element_id),'N') = 'Y' THEN

Line 2374: x_return_status := FND_API.G_RET_STS_ERROR;

2370: END IF ;
2371:
2372: IF nvl(PA_DELIVERABLE_UTILS.IS_BILLING_FUNCTION_EXISTS(p_project_id,p_dlv_element_id),'N') = 'Y' THEN
2373: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_BILLING_FUNC_NO_DISASCN') ;
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375: x_disassociation_allowed := 'N';
2376: END IF ;*/
2377:
2378: IF p_debug_mode = 'Y' THEN --Added for bug 4945876

Line 2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2380: END IF ;
2381:
2382: EXCEPTION
2383: WHEN OTHERS THEN
2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: x_msg_count := 1;
2386: x_msg_data := SQLERRM;
2387:
2388: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'

Line 2427: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2423: -- x_msg_data OUT VARCHAR2 N Standard Out Parameter
2424:
2425: PROCEDURE CREATE_ASSOCIATIONS_IN_BULK
2426: (p_api_version IN NUMBER :=1.0
2427: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2428: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2429: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2430: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2431: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2428: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2424:
2425: PROCEDURE CREATE_ASSOCIATIONS_IN_BULK
2426: (p_api_version IN NUMBER :=1.0
2427: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2428: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2429: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2430: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2431: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2432: ,p_debug_mode IN VARCHAR2 :='N'

Line 2429: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2425: PROCEDURE CREATE_ASSOCIATIONS_IN_BULK
2426: (p_api_version IN NUMBER :=1.0
2427: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2428: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2429: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2430: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2431: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2432: ,p_debug_mode IN VARCHAR2 :='N'
2433: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2430: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2426: (p_api_version IN NUMBER :=1.0
2427: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2428: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2429: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2430: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2431: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2432: ,p_debug_mode IN VARCHAR2 :='N'
2433: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2434: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 2458: x_return_status := FND_API.G_RET_STS_SUCCESS;

2454:
2455: BEGIN
2456:
2457: x_msg_count := 0;
2458: x_return_status := FND_API.G_RET_STS_SUCCESS;
2459:
2460: IF p_debug_mode = 'Y' THEN
2461: PA_DEBUG.set_curr_function( p_function => 'CREATE_ASSOCIATIONS_IN_BULK'
2462: ,p_debug_mode => p_debug_mode );

Line 2467: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2463: pa_debug.g_err_stage:= 'Inside CREATE_ASSOCIATIONS_IN_BULK ';
2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2465: END IF;
2466:
2467: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2468: FND_MSG_PUB.initialize;
2469: END IF;
2470:
2471: -- Perform following validation

Line 2608: x_return_status := FND_API.G_RET_STS_ERROR;

2604: END IF ;
2605:
2606: EXCEPTION
2607: WHEN Invalid_Arg_Exc_Dlv THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_msg_count := FND_MSG_PUB.count_msg;
2610: IF p_debug_mode = 'Y' THEN
2611: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2612: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 2617: (p_encoded => FND_API.G_TRUE,

2613: END IF;
2614:
2615: IF x_msg_count = 1 THEN
2616: PA_INTERFACE_UTILS_PUB.get_messages
2617: (p_encoded => FND_API.G_TRUE,
2618: p_msg_index => 1,
2619: p_msg_count => l_msg_count,
2620: p_msg_data => l_msg_data,
2621: p_data => l_data,

Line 2633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2629: pa_debug.reset_curr_function;
2630: END IF ;
2631: RETURN;
2632: WHEN OTHERS THEN
2633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2634: x_msg_count := 1;
2635: x_msg_data := SQLERRM;
2636: FND_MSG_PUB.add_exc_msg
2637: ( p_pkg_name => 'PA_DELIVERABLE_PVT'

Line 2674: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2670: -- x_msg_data OUT VARCHAR2 N Standard Out Parameter
2671:
2672: PROCEDURE CREATE_DLV_TASK_ASSOCIATION
2673: (p_api_version IN NUMBER :=1.0
2674: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2675: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2676: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2677: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2678: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2675: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2671:
2672: PROCEDURE CREATE_DLV_TASK_ASSOCIATION
2673: (p_api_version IN NUMBER :=1.0
2674: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2675: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2676: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2677: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2678: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2679: ,p_debug_mode IN VARCHAR2 :='N'

Line 2676: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2672: PROCEDURE CREATE_DLV_TASK_ASSOCIATION
2673: (p_api_version IN NUMBER :=1.0
2674: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2675: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2676: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2677: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2678: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2679: ,p_debug_mode IN VARCHAR2 :='N'
2680: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2677: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2673: (p_api_version IN NUMBER :=1.0
2674: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2675: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2676: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2677: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2678: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2679: ,p_debug_mode IN VARCHAR2 :='N'
2680: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2681: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'

Line 2716: x_return_status := FND_API.G_RET_STS_SUCCESS;

2712: is_asscn_exists VARCHAR2(1) := 'N';
2713:
2714: BEGIN
2715: x_msg_count := 0;
2716: x_return_status := FND_API.G_RET_STS_SUCCESS;
2717:
2718: IF p_debug_mode = 'Y' THEN
2719: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_TASK_ASSOCIATION'
2720: ,p_debug_mode => p_debug_mode );

Line 2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2721: pa_debug.g_err_stage:= 'Inside CREATE_DLV_TASK_ASSOCIATION ';
2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2723: END IF;
2724:
2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728:
2729: IF (p_commit = FND_API.G_TRUE) THEN

Line 2729: IF (p_commit = FND_API.G_TRUE) THEN

2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728:
2729: IF (p_commit = FND_API.G_TRUE) THEN
2730: SAVEPOINT CREATE_DLV_TASK_ASSOCIATION_SP ;
2731: END IF ;
2732:
2733: IF ((p_task_element_id IS NULL )OR --p_task_version_id IS NULL) OR

Line 2741: x_return_status := FND_API.G_RET_STS_ERROR;

2737: pa_debug.g_err_stage:= 'INVALID INPUT PARAMETER';
2738: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2739: END IF;
2740:
2741: x_return_status := FND_API.G_RET_STS_ERROR;
2742: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
2743: ,p_msg_name => 'PA_INV_PARAM_PASSED');
2744: RAISE Invalid_Arg_Exc_Dlv;
2745: END IF ;

Line 2758: x_return_status := FND_API.G_RET_STS_ERROR;

2754: THEN
2755: IF nvl(PA_DELIVERABLE_UTILS.GET_PROGRESS_ROLLUP_METHOD(p_task_element_id),'X') = g_deliverable_based THEN
2756: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
2757: ,p_msg_name => 'PA_DLV_ASSCN_ERR');
2758: x_return_status := FND_API.G_RET_STS_ERROR;
2759: END IF ;
2760: END IF ;
2761:
2762: IF x_return_status <>FND_API.G_RET_STS_SUCCESS

Line 2762: IF x_return_status <>FND_API.G_RET_STS_SUCCESS

2758: x_return_status := FND_API.G_RET_STS_ERROR;
2759: END IF ;
2760: END IF ;
2761:
2762: IF x_return_status <>FND_API.G_RET_STS_SUCCESS
2763: THEN
2764: RAISE Invalid_Arg_Exc_Dlv ;
2765: END IF ;
2766:

Line 2865: x_return_status := FND_API.G_RET_STS_ERROR;

2861: pa_debug.reset_curr_function;
2862: END IF ;
2863: EXCEPTION
2864: WHEN Invalid_Arg_Exc_Dlv THEN
2865: x_return_status := FND_API.G_RET_STS_ERROR;
2866: l_msg_count := FND_MSG_PUB.count_msg;
2867:
2868: IF (p_commit = FND_API.G_TRUE) THEN
2869: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;

Line 2868: IF (p_commit = FND_API.G_TRUE) THEN

2864: WHEN Invalid_Arg_Exc_Dlv THEN
2865: x_return_status := FND_API.G_RET_STS_ERROR;
2866: l_msg_count := FND_MSG_PUB.count_msg;
2867:
2868: IF (p_commit = FND_API.G_TRUE) THEN
2869: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;
2870: END IF ;
2871:
2872: IF p_debug_mode = 'Y' THEN

Line 2879: (p_encoded => FND_API.G_TRUE,

2875: END IF;
2876:
2877: IF l_msg_count = 1 THEN
2878: PA_INTERFACE_UTILS_PUB.get_messages
2879: (p_encoded => FND_API.G_TRUE,
2880: p_msg_index => 1,
2881: p_msg_count => l_msg_count,
2882: p_msg_data => l_msg_data,
2883: p_data => l_data,

Line 2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2891: pa_debug.reset_curr_function;
2892: END IF ;
2893: RETURN;
2894: WHEN OTHERS THEN
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: x_msg_count := 1;
2897: x_msg_data := SQLERRM;
2898:
2899: IF (p_commit = FND_API.G_TRUE) THEN

Line 2899: IF (p_commit = FND_API.G_TRUE) THEN

2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896: x_msg_count := 1;
2897: x_msg_data := SQLERRM;
2898:
2899: IF (p_commit = FND_API.G_TRUE) THEN
2900: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;
2901: END IF ;
2902:
2903: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_VT'

Line 2916: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

2912: END CREATE_DLV_TASK_ASSOCIATION ;
2913:
2914: PROCEDURE DELETE_DELIVERABLE_STRUCTURE
2915: (p_api_version IN NUMBER :=1.0
2916: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2917: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2918: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2920: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 2917: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

2913:
2914: PROCEDURE DELETE_DELIVERABLE_STRUCTURE
2915: (p_api_version IN NUMBER :=1.0
2916: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2917: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2918: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2920: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2921: ,p_debug_mode IN VARCHAR2 :='N'

Line 2918: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

2914: PROCEDURE DELETE_DELIVERABLE_STRUCTURE
2915: (p_api_version IN NUMBER :=1.0
2916: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2917: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2918: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2920: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2921: ,p_debug_mode IN VARCHAR2 :='N'
2922: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

2915: (p_api_version IN NUMBER :=1.0
2916: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
2917: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
2918: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2919: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2920: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2921: ,p_debug_mode IN VARCHAR2 :='N'
2922: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2923: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2948: l_return_status := FND_API.G_RET_STS_SUCCESS;

2944: l_dlv_proj_elt_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2945:
2946: BEGIN
2947: l_msg_count := 0;
2948: l_return_status := FND_API.G_RET_STS_SUCCESS;
2949:
2950: IF p_debug_mode = 'Y' THEN
2951: PA_DEBUG.set_curr_function( p_function => 'DELETE_DELIVERABLE_STRUCTURE',
2952: p_debug_mode => p_debug_mode );

Line 2957: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

2953: pa_debug.g_err_stage:= 'Inside DELETE_DELIVERABLE_STRUCTURE ';
2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2958: FND_MSG_PUB.initialize;
2959: END IF;
2960:
2961: -- Validate mandatory input parameter

Line 2971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2967: ,x_msg_count => x_msg_count
2968: ,x_msg_data => x_msg_data
2969: ) ;
2970:
2971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2972: RAISE Invalid_Arg_Exc_Dlv ;
2973: END IF ;
2974:
2975: /* Bug 3597178 We can still go about Disabling Deliverable Structure ,Even If Deliverable Based Tasks Exist for that project

Line 3073: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

3069: , X_Return_Status => x_return_status
3070: , X_Msg_Count => x_msg_count
3071: , X_Msg_Data => x_msg_data
3072: ) ;
3073: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3074: RAISE Invalid_Arg_Exc_Dlv ;
3075: END IF ;
3076:
3077: --Start Bug 3538320 <>

Line 3107: x_return_status := FND_API.G_RET_STS_ERROR;

3103: END IF ;
3104:
3105: EXCEPTION
3106: WHEN Invalid_Arg_Exc_Dlv THEN
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: l_msg_count := FND_MSG_PUB.count_msg;
3109:
3110: IF p_debug_mode = 'Y' THEN
3111: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';

Line 3117: (p_encoded => FND_API.G_TRUE,

3113: END IF;
3114:
3115: IF l_msg_count = 1 THEN
3116: PA_INTERFACE_UTILS_PUB.get_messages
3117: (p_encoded => FND_API.G_TRUE,
3118: p_msg_index => 1,
3119: p_msg_count => l_msg_count,
3120: p_msg_data => l_msg_data,
3121: p_data => l_data,

Line 3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3129: pa_debug.reset_curr_function;
3130: END IF ;
3131: RETURN;
3132: WHEN OTHERS THEN
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: x_msg_count := 1;
3135: x_msg_data := SQLERRM;
3136:
3137: FND_MSG_PUB.add_exc_msg

Line 3171: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

3167: -- FOR ANY FIX DONE FOR p_calling_context ='PA_TASKS' case ,SAME FIX HAS TO DONE FOR DELETE_DLV_ASSOCIATIONS API ALSO
3168: -- *******************************************************************************************************************
3169: PROCEDURE DELETE_DLV_TASK_ASSCN_IN_BULK
3170: (p_api_version IN NUMBER :=1.0
3171: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3172: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3173: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3174: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3175: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 3172: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

3168: -- *******************************************************************************************************************
3169: PROCEDURE DELETE_DLV_TASK_ASSCN_IN_BULK
3170: (p_api_version IN NUMBER :=1.0
3171: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3172: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3173: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3174: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3175: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3176: ,p_debug_mode IN VARCHAR2 :='N'

Line 3173: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

3169: PROCEDURE DELETE_DLV_TASK_ASSCN_IN_BULK
3170: (p_api_version IN NUMBER :=1.0
3171: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3172: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3173: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3174: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3175: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3176: ,p_debug_mode IN VARCHAR2 :='N'
3177: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3174: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

3170: (p_api_version IN NUMBER :=1.0
3171: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3172: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3173: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3174: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3175: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3176: ,p_debug_mode IN VARCHAR2 :='N'
3177: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3178: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'

Line 3259: x_return_status := FND_API.G_RET_STS_SUCCESS;

3255:
3256: BEGIN
3257:
3258: x_msg_count := 0;
3259: x_return_status := FND_API.G_RET_STS_SUCCESS;
3260:
3261: IF p_debug_mode = 'Y' THEN
3262: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_TASK_ASSOCIATION',
3263: p_debug_mode => p_debug_mode );

Line 3268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

3264: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3266: END IF;
3267:
3268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3269: FND_MSG_PUB.initialize;
3270: END IF;
3271:
3272: IF p_debug_mode = 'Y' THEN

Line 3340: x_return_status := FND_API.G_RET_STS_ERROR;

3336: END IF;
3337:
3338: EXCEPTION
3339: WHEN Invalid_Arg_Exc_Dlv THEN
3340: x_return_status := FND_API.G_RET_STS_ERROR;
3341: l_msg_count := FND_MSG_PUB.count_msg;
3342:
3343: IF p_debug_mode = 'Y' THEN
3344: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';

Line 3350: (p_encoded => FND_API.G_TRUE,

3346: END IF;
3347:
3348: IF l_msg_count = 1 THEN
3349: PA_INTERFACE_UTILS_PUB.get_messages
3350: (p_encoded => FND_API.G_TRUE,
3351: p_msg_index => 1,
3352: p_msg_count => l_msg_count,
3353: p_msg_data => l_msg_data,
3354: p_data => l_data,

Line 3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3362: pa_debug.reset_curr_function;
3363: END IF ;
3364: RETURN;
3365: WHEN OTHERS THEN
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3367: x_msg_count := 1;
3368: x_msg_data := SQLERRM;
3369:
3370: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

Line 3404: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

3400: -- The Vice versa also applies .
3401: --******************************************************************************************************************
3402: PROCEDURE DELETE_DLV_ASSOCIATIONS
3403: (p_api_version IN NUMBER :=1.0
3404: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3405: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3406: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3407: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3408: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 3405: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

3401: --******************************************************************************************************************
3402: PROCEDURE DELETE_DLV_ASSOCIATIONS
3403: (p_api_version IN NUMBER :=1.0
3404: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3405: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3406: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3407: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3408: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3409: ,p_debug_mode IN VARCHAR2 :='N'

Line 3406: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

3402: PROCEDURE DELETE_DLV_ASSOCIATIONS
3403: (p_api_version IN NUMBER :=1.0
3404: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3405: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3406: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3407: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3408: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3409: ,p_debug_mode IN VARCHAR2 :='N'
3410: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3407: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

3403: (p_api_version IN NUMBER :=1.0
3404: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3405: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3406: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3407: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3408: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3409: ,p_debug_mode IN VARCHAR2 :='N'
3410: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3411: ,p_project_id IN NUMBER

Line 3494: x_return_status := FND_API.G_RET_STS_SUCCESS;

3490:
3491: BEGIN
3492:
3493: x_msg_count := 0;
3494: x_return_status := FND_API.G_RET_STS_SUCCESS;
3495:
3496: IF p_debug_mode = 'Y' THEN
3497: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ASSOCIATIONS',
3498: p_debug_mode => p_debug_mode );

Line 3503: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

3499: pa_debug.g_err_stage:= 'Inside DELETE_DLV_TASK_ASSOCIATION ';
3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3501: END IF;
3502:
3503: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3504: FND_MSG_PUB.initialize;
3505: END IF;
3506:
3507: /* Commented for Bug 3906015 : Incorrect Check was being performed

Line 3518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3514: ,x_msg_count => x_msg_count
3515: ,x_msg_data => x_msg_data
3516: ) ;
3517:
3518: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3519: RAISE Invalid_Arg_Exc_Dlv ;
3520: END IF ;
3521: */
3522: -- Bug 3906015 : Start

Line 3554: x_return_status := FND_API.G_RET_STS_ERROR;

3550: END IF;
3551:
3552: EXCEPTION
3553: WHEN Invalid_Arg_Exc_Dlv THEN
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: l_msg_count := FND_MSG_PUB.count_msg;
3556:
3557: IF p_debug_mode = 'Y' THEN
3558: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';

Line 3564: (p_encoded => FND_API.G_TRUE,

3560: END IF;
3561:
3562: IF l_msg_count = 1 THEN
3563: PA_INTERFACE_UTILS_PUB.get_messages
3564: (p_encoded => FND_API.G_TRUE,
3565: p_msg_index => 1,
3566: p_msg_count => l_msg_count,
3567: p_msg_data => l_msg_data,
3568: p_data => l_data,

Line 3580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3576: pa_debug.reset_curr_function;
3577: END IF ;
3578: RETURN;
3579: WHEN OTHERS THEN
3580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3581: x_msg_count := 1;
3582: x_msg_data := SQLERRM;
3583:
3584: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

Line 3656: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

3652: -- based on quick entry dates.
3653:
3654: PROCEDURE COPY_DELIVERABLES
3655: (p_api_version IN NUMBER :=1.0
3656: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3657: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3658: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3659: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3660: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

Line 3657: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE

3653:
3654: PROCEDURE COPY_DELIVERABLES
3655: (p_api_version IN NUMBER :=1.0
3656: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3657: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3658: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3659: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3660: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3661: ,p_debug_mode IN VARCHAR2 :='N'

Line 3658: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE

3654: PROCEDURE COPY_DELIVERABLES
3655: (p_api_version IN NUMBER :=1.0
3656: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3657: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3658: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3659: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3660: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3661: ,p_debug_mode IN VARCHAR2 :='N'
3662: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3659: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

3655: (p_api_version IN NUMBER :=1.0
3656: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3657: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3658: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3659: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3660: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3661: ,p_debug_mode IN VARCHAR2 :='N'
3662: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3663: ,p_source_project_id IN NUMBER

Line 3894: x_return_status := FND_API.G_RET_STS_SUCCESS;

3890:
3891: BEGIN
3892:
3893: l_msg_count := 0;
3894: x_return_status := FND_API.G_RET_STS_SUCCESS;
3895: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3896:
3897: IF l_debug_mode = 'Y' THEN
3898: PA_DEBUG.set_curr_function( p_function => 'COPY_DELIVERABLES',

Line 3911: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

3907: pa_debug.g_err_stage:= 'p_target_project_id is '||p_target_project_id;
3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;
3910:
3911: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3912: FND_MSG_PUB.initialize;
3913: END IF;
3914:
3915: IF p_calling_context = 'COPY_PROJECT' THEN

Line 4239: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4235: );
4236:
4237: IF nvl(l_y_or_n,'Y') = 'N' THEN
4238: PA_UTILS.ADD_MESSAGE('PA','PA_ENTER_OTHER_PREFIX') ;
4239: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4240: RAISE Invalid_Arg_Exc_Dlv ;
4241: -- END IF ;
4242: pa_debug.g_err_stage := 'Duplicate Deliverable Number ';
4243: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 4625: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4621: ,x_msg_count => x_msg_count
4622: ,x_msg_data => x_msg_data
4623: );
4624:
4625: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4626: RAISE Invalid_Arg_Exc_Dlv ;
4627: END IF ;
4628:
4629: -- END IF ;

Line 4662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4658: ,x_msg_count => x_msg_count
4659: ,x_msg_data => x_msg_data
4660: ) ;
4661:
4662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4663: RAISE Invalid_Arg_Exc_Dlv ;
4664: END IF ;
4665: END IF ;
4666:

Line 4702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4698: );
4699: END IF;
4700:
4701:
4702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4703: RAISE Invalid_Arg_Exc_Dlv ;
4704: END IF ;
4705:
4706: /*Stubbed Out Auto Initiate Demand on Project Approval Functionality

Line 4771: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4767: ,x_msg_count => x_msg_count
4768: ,x_msg_data => x_msg_data
4769: ,x_return_status => x_return_status
4770: );
4771: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4772: RAISE FND_API.G_EXC_ERROR;
4773: END IF;
4774: END IF;
4775: END IF;

Line 4772: RAISE FND_API.G_EXC_ERROR;

4768: ,x_msg_data => x_msg_data
4769: ,x_return_status => x_return_status
4770: );
4771: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4772: RAISE FND_API.G_EXC_ERROR;
4773: END IF;
4774: END IF;
4775: END IF;
4776: END IF;

Line 4791: x_return_status := FND_API.G_RET_STS_ERROR;

4787: END IF;
4788:
4789: EXCEPTION
4790: WHEN Invalid_Arg_Exc_Dlv THEN
4791: x_return_status := FND_API.G_RET_STS_ERROR;
4792: l_msg_count := FND_MSG_PUB.count_msg;
4793:
4794: IF l_debug_mode = 'Y' THEN
4795: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';

Line 4801: (p_encoded => FND_API.G_TRUE,

4797: END IF;
4798:
4799: IF l_msg_count = 1 THEN
4800: PA_INTERFACE_UTILS_PUB.get_messages
4801: (p_encoded => FND_API.G_TRUE,
4802: p_msg_index => 1,
4803: p_msg_count => l_msg_count,
4804: p_msg_data => l_msg_data,
4805: p_data => l_data,

Line 4817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4813: pa_debug.reset_curr_function;
4814: END IF ;
4815: RETURN;
4816: WHEN OTHERS THEN
4817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4818: x_msg_count := 1;
4819: x_msg_data := SQLERRM;
4820:
4821: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'