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_ASSIGNMENT_PROGRESS_PUB dependencies on FND_API

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

6: --g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
7:
8: PROCEDURE UPDATE_ASSIGNMENT_PROGRESS(
9: p_api_version IN NUMBER := 1.0 ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,

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

7:
8: PROCEDURE UPDATE_ASSIGNMENT_PROGRESS(
9: p_api_version IN NUMBER := 1.0 ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
15: p_action IN VARCHAR2 := 'SAVE' ,

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

8: PROCEDURE UPDATE_ASSIGNMENT_PROGRESS(
9: p_api_version IN NUMBER := 1.0 ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
15: p_action IN VARCHAR2 := 'SAVE' ,
16: p_bulk_load_flag IN VARCHAR2 := 'N' ,

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

9: p_api_version IN NUMBER := 1.0 ,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
15: p_action IN VARCHAR2 := 'SAVE' ,
16: p_bulk_load_flag IN VARCHAR2 := 'N' ,
17: p_progress_mode IN VARCHAR2 := 'FUTURE' ,

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

523: IF g1_debug_mode = 'Y' THEN
524: pa_debug.init_err_stack ('PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS');
525: END IF;
526:
527: IF (p_commit = FND_API.G_TRUE) THEN
528: savepoint UPDATE_ASSIGNMENT_PROGRESS;
529: END IF;
530:
531: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 531: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

527: IF (p_commit = FND_API.G_TRUE) THEN
528: savepoint UPDATE_ASSIGNMENT_PROGRESS;
529: END IF;
530:
531: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: savepoint UPDATE_ASSIGNMENT_PROGRESS;
529: END IF;
530:
531: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
536: FND_MSG_PUB.initialize;

Line 535: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

531: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538:
539: IF g1_debug_mode = 'Y' THEN

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578: --DEBUG_DJ('p_resource_class_code: '||p_resource_class_code);
579: --DEBUG_DJ('p_rate_based_flag: '||p_rate_based_flag);
580:
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: SELECT DECODE(ptt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', DECODE(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N')
585: INTO l_est_remaining_eff_flag
586: FROM pa_proj_elements ppe,

Line 606: RAISE FND_API.G_EXC_ERROR;

602: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
603: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
604: x_return_status := 'E';
605: x_msg_count := fnd_msg_pub.count_msg;
606: RAISE FND_API.G_EXC_ERROR;
607: end;
608:
609: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
610: --moved this up for bug 3675107

Line 783: RAISE FND_API.G_EXC_ERROR;

779: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
780: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
781: x_msg_data := 'PA_TP_NO_NEG_ACT';
782: x_return_status := 'E';
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: */
786: --bug 3958686, end
787:

Line 806: RAISE FND_API.G_EXC_ERROR;

802: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
803: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
804: x_msg_data := 'PA_TP_NO_NEG_ETC';
805: x_return_status := 'E';
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808: */
809:
810:

Line 881: RAISE FND_API.G_EXC_ERROR;

877: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
878: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
879: x_msg_data := 'PA_TP_NO_NEG_ACT';
880: x_return_status := 'E';
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883: */
884:
885:

Line 911: RAISE FND_API.G_EXC_ERROR;

907: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
908: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
909: x_msg_data := 'PA_TP_NO_NEG_ETC';
910: x_return_status := 'E';
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: */
914:
915: /* Bug 3606627 Shifting this code below

Line 938: RAISE FND_API.G_EXC_ERROR;

934: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
935: ,p_msg_name => 'PA_WP_VD_CANT_UPDATE_ETC');
936: x_msg_data := 'PA_WP_VD_CANT_UPDATE_ETC';
937: x_return_status := 'E';
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: END IF;
941: */
942: -- Bug 16573693 End

Line 950: RAISE FND_API.G_EXC_ERROR;

946: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
947: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
948: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';
949: x_return_status := 'E';
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: ---- if status is CANCELLED
953:
954: /* Commented by rtarway for BUG 3762650

Line 962: RAISE FND_API.G_EXC_ERROR;

958: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
959: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
960: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';
961: x_return_status := 'E';
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: ---- if status is ON HOLD
965: */
966: --bug no. 3586648 start

Line 983: RAISE FND_API.G_EXC_ERROR;

979: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
980: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
981: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
982: x_return_status := 'E';
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985: END IF;*/
986: --- check if structure is shared and actuals are passed
987: --bug no. 3586648 end

Line 999: RAISE FND_API.G_EXC_ERROR;

995: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
996: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
997: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
998: x_return_status := 'E';
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001: END IF;
1002: --end added by rtarway for 3816022
1003:

Line 1011: RAISE FND_API.G_EXC_ERROR;

1007: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1008: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
1009: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
1010: x_return_status := 'E';
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: ----- Wrong MODE
1014:
1015: ----- Invalid DATE

Line 1022: RAISE FND_API.G_EXC_ERROR;

1018: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1019: ,p_msg_name => 'PA_TP_INV_AOD');
1020: x_msg_data := 'PA_TP_INV_AOD';
1021: x_return_status := 'E';
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024: ----- Wrong DATE
1025:
1026:

Line 1033: x_return_status := FND_API.G_RET_STS_ERROR;

1029: IF p_estimated_finish_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND p_estimated_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1030: THEN
1031: IF (p_estimated_finish_date < p_estimated_start_date)
1032: THEN
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: pa_utils.add_message(p_app_short_name => 'PA',
1035: p_msg_name => 'PA_EST_DATES_INV');
1036: raise fnd_api.g_exc_error;
1037: END IF;

Line 1036: raise fnd_api.g_exc_error;

1032: THEN
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: pa_utils.add_message(p_app_short_name => 'PA',
1035: p_msg_name => 'PA_EST_DATES_INV');
1036: raise fnd_api.g_exc_error;
1037: END IF;
1038: END IF;
1039: */
1040:

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
1142: P_TOKEN1 => 'OBJECT_ID',
1143: P_VALUE1 => l_resource_list_member_id);
1144: x_msg_data := 'PA_TP_INV_ASSGN_AMG';
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: RAISE FND_API.G_EXC_ERROR;
1147: ELSE
1148: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1149: p_msg_name => 'PA_CBS_TP_INV_ASSGN_AMG',

Line 1146: RAISE FND_API.G_EXC_ERROR;

1142: P_TOKEN1 => 'OBJECT_ID',
1143: P_VALUE1 => l_resource_list_member_id);
1144: x_msg_data := 'PA_TP_INV_ASSGN_AMG';
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: RAISE FND_API.G_EXC_ERROR;
1147: ELSE
1148: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1149: p_msg_name => 'PA_CBS_TP_INV_ASSGN_AMG',
1150: P_TOKEN1 => 'OBJECT_ID',

Line 1153: x_return_status := FND_API.G_RET_STS_ERROR;

1149: p_msg_name => 'PA_CBS_TP_INV_ASSGN_AMG',
1150: P_TOKEN1 => 'OBJECT_ID',
1151: P_VALUE1 => l_resource_list_member_id);
1152: x_msg_data := 'PA_CBS_TP_INV_ASSGN_AMG';
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: RAISE FND_API.G_EXC_ERROR;
1155:
1156: END IF;
1157: END;

Line 1154: RAISE FND_API.G_EXC_ERROR;

1150: P_TOKEN1 => 'OBJECT_ID',
1151: P_VALUE1 => l_resource_list_member_id);
1152: x_msg_data := 'PA_CBS_TP_INV_ASSGN_AMG';
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: RAISE FND_API.G_EXC_ERROR;
1155:
1156: END IF;
1157: END;
1158:

Line 1188: x_return_status := FND_API.G_RET_STS_ERROR;

1184: l_estimated_start_date := l_scheduled_start_date;
1185: END IF;
1186:
1187: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: pa_utils.add_message(p_app_short_name => 'PA',
1190: p_msg_name => 'PA_EST_DATES_INV');
1191: raise fnd_api.g_exc_error;
1192: END IF;

Line 1191: raise fnd_api.g_exc_error;

1187: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: pa_utils.add_message(p_app_short_name => 'PA',
1190: p_msg_name => 'PA_EST_DATES_INV');
1191: raise fnd_api.g_exc_error;
1192: END IF;
1193: -- Bug 3979303 : End
1194:
1195:

Line 1348: raise FND_API.G_EXC_ERROR;

1344: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_clex_actual_finish_date='||l_clex_actual_finish_date, x_Log_Level=> 3);
1345: END IF;
1346:
1347: IF x_return_status <> 'S' THEN
1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)

Line 1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)

1347: IF x_return_status <> 'S' THEN
1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1353: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1354: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1355: THEN

Line 1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)

1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1353: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1354: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1355: THEN
1356: l_date_override_flag := 'Y';

Line 1353: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)

1349: END IF;
1350:
1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1353: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1354: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1355: THEN
1356: l_date_override_flag := 'Y';
1357: l_estimated_start_date := l_clex_estimated_start_date;

Line 1354: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)

1350:
1351: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1352: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1353: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1354: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1355: THEN
1356: l_date_override_flag := 'Y';
1357: l_estimated_start_date := l_clex_estimated_start_date;
1358: l_estimated_finish_date := l_clex_estimated_finish_date;

Line 1368: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)

1364: l_date_override_flag := 'Y';
1365: END IF;
1366:
1367: IF l_date_override_flag = 'N' AND
1368: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1369: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1370: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1371: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1372: THEN

Line 1369: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)

1365: END IF;
1366:
1367: IF l_date_override_flag = 'N' AND
1368: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1369: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1370: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1371: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1372: THEN
1373: l_date_override_flag := 'Y';

Line 1370: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)

1366:
1367: IF l_date_override_flag = 'N' AND
1368: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1369: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1370: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1371: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1372: THEN
1373: l_date_override_flag := 'Y';
1374: END IF;

Line 1371: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))

1367: IF l_date_override_flag = 'N' AND
1368: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1369: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1370: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1371: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1372: THEN
1373: l_date_override_flag := 'Y';
1374: END IF;
1375:

Line 1464: RAISE FND_API.G_EXC_ERROR;

1460: p_token1 => 'AS_OF_DATE',
1461: p_value1 => p_as_of_date );
1462: x_msg_data := 'PA_TP_ASSG_WRONG_PRG_MODE3';
1463: x_return_status := 'E';
1464: RAISE FND_API.G_EXC_ERROR;
1465: --bug# 3821106 Satish start, bug 4185364
1466: /*ELSIF (p_as_of_date = NVL(l_last_progress_date, p_as_of_date + 1 ) AND p_action = 'SAVE')
1467: THEN
1468: if (l_working_aod = p_as_of_date) then

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: p_token1 => 'AS_OF_DATE',
1482: p_value1 => p_as_of_date );
1483: x_msg_data := 'PA_TP_ASSG_WRONG_ACTION';
1484: x_return_status := 'E';
1485: RAISE FND_API.G_EXC_ERROR;
1486: --bug# 3821106 Satish end
1487: */
1488: ELSE
1489: --Validate as of date

Line 1507: RAISE FND_API.G_EXC_ERROR;

1503: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1504: ,p_msg_name => 'PA_TP_INV_AOD2');
1505: x_msg_data := 'PA_TP_INV_AOD2';
1506: x_return_status := 'E';
1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;*/
1509:
1510: IF l_progress_exists_on_aod = 'WORKING'
1511: THEN

Line 1699: RAISE FND_API.G_EXC_ERROR;

1695: WHEN OTHERS THEN
1696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1697: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1698: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));
1699: RAISE FND_API.G_EXC_ERROR;
1700:
1701: END;
1702:
1703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1699: RAISE FND_API.G_EXC_ERROR;
1700:
1701: END;
1702:
1703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1704: x_return_status := 'E';
1705: x_msg_data := l_msg_data;
1706: x_msg_count := l_msg_count;
1707: RAISE FND_API.G_EXC_ERROR;

Line 1707: RAISE FND_API.G_EXC_ERROR;

1703: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1704: x_return_status := 'E';
1705: x_msg_data := l_msg_data;
1706: x_msg_count := l_msg_count;
1707: RAISE FND_API.G_EXC_ERROR;
1708: END IF;
1709:
1710: -- Bug 3696429 currency conversion for resource Satish 03-JUL-2004 start
1711: IF l_txn_currency_code <> l_res_cur_code

Line 1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1733: ,x_msg_count => l_msg_count
1734: ,x_msg_data => l_msg_data
1735: );
1736:
1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: x_return_status := 'E';
1739: x_msg_data := l_msg_data;
1740: x_msg_count := l_msg_count;
1741: RAISE FND_API.G_EXC_ERROR;

Line 1741: RAISE FND_API.G_EXC_ERROR;

1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: x_return_status := 'E';
1739: x_msg_data := l_msg_data;
1740: x_msg_count := l_msg_count;
1741: RAISE FND_API.G_EXC_ERROR;
1742: END IF;
1743:
1744: IF l_res_raw_rate <> l_res_burden_rate
1745: THEN

Line 1769: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1765: ,x_return_status => l_return_status
1766: ,x_msg_count => l_msg_count
1767: ,x_msg_data => l_msg_data
1768: );
1769: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1770: x_return_status := 'E';
1771: x_msg_data := l_msg_data;
1772: x_msg_count := l_msg_count;
1773: RAISE FND_API.G_EXC_ERROR;

Line 1773: RAISE FND_API.G_EXC_ERROR;

1769: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1770: x_return_status := 'E';
1771: x_msg_data := l_msg_data;
1772: x_msg_count := l_msg_count;
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775:
1776: l_res_burden_rate := l_proj_res_burden_rate;
1777: ELSE

Line 1824: RAISE FND_API.G_EXC_ERROR;

1820: WHEN OTHERS THEN
1821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1822: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1823: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));
1824: RAISE FND_API.G_EXC_ERROR;
1825:
1826: END;
1827:
1828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1824: RAISE FND_API.G_EXC_ERROR;
1825:
1826: END;
1827:
1828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1829: x_return_status := 'E';
1830: x_msg_data := l_msg_data;
1831: x_msg_count := l_msg_count;
1832: RAISE FND_API.G_EXC_ERROR;

Line 1832: RAISE FND_API.G_EXC_ERROR;

1828: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1829: x_return_status := 'E';
1830: x_msg_data := l_msg_data;
1831: x_msg_count := l_msg_count;
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;
1834: -- Bug 3784874 currency conversion for ETC Start
1835: --IF l_txn_currency_code <> l_res_cur_code
1836: IF l_txn_currency_code <> l_plan_res_cur_code -- 06-sep-2004,3860575 Satish

Line 1862: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1858: ,x_msg_count => l_msg_count
1859: ,x_msg_data => l_msg_data
1860: );
1861:
1862: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1863: x_return_status := 'E';
1864: x_msg_data := l_msg_data;
1865: x_msg_count := l_msg_count;
1866: RAISE FND_API.G_EXC_ERROR;

Line 1866: RAISE FND_API.G_EXC_ERROR;

1862: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1863: x_return_status := 'E';
1864: x_msg_data := l_msg_data;
1865: x_msg_count := l_msg_count;
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: IF l_plan_res_raw_rate <> l_plan_res_burden_rate
1870: THEN

Line 1894: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1890: ,x_return_status => l_return_status
1891: ,x_msg_count => l_msg_count
1892: ,x_msg_data => l_msg_data
1893: );
1894: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1895: x_return_status := 'E';
1896: x_msg_data := l_msg_data;
1897: x_msg_count := l_msg_count;
1898: RAISE FND_API.G_EXC_ERROR;

Line 1898: RAISE FND_API.G_EXC_ERROR;

1894: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1895: x_return_status := 'E';
1896: x_msg_data := l_msg_data;
1897: x_msg_count := l_msg_count;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900:
1901: l_plan_res_burden_rate := l_proj_res_burden_rate;
1902: ELSE

Line 1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8

1948: ,x_return_status => x_return_status
1949: ,x_msg_count => x_msg_count
1950: ,x_msg_data => x_msg_data
1951: );
1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
1953: THEN
1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956:

Line 1954: RAISE FND_API.G_EXC_ERROR;

1950: ,x_msg_data => x_msg_data
1951: );
1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
1953: THEN
1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956:
1957: l_act_txn_cost := l_res_txn_cost_tbl(1); -- This is incremental
1958: */

Line 2013: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2009: ,x_msg_count => x_msg_count
2010: ,x_msg_data => x_msg_data
2011: );
2012:
2013: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2014: THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: l_etc_txn_cost := l_etc_res_txn_cost_tbl(1); -- This is cumulative

Line 2015: RAISE FND_API.G_EXC_ERROR;

2011: );
2012:
2013: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2014: THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: END IF;
2017: l_etc_txn_cost := l_etc_res_txn_cost_tbl(1); -- This is cumulative
2018: */
2019: -- Bug 3627315 : Using plan rates instead of actual rates

Line 2088: RAISE FND_API.G_EXC_ERROR;

2084: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2085: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2086: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2087: x_return_status := 'E';
2088: RAISE FND_API.G_EXC_ERROR;
2089: END IF;
2090: END IF;*/
2091: --bug no. 3586648
2092:

Line 2118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8

2114: ,x_return_status => x_return_status
2115: ,x_msg_count => x_msg_count
2116: ,x_msg_data => x_msg_data
2117: );
2118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2119: THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122: -- Raw Cost Changes Begin

Line 2120: RAISE FND_API.G_EXC_ERROR;

2116: ,x_msg_data => x_msg_data
2117: );
2118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2119: THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122: -- Raw Cost Changes Begin
2123: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2124: p_project_id => p_project_id

Line 2145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2141: ,x_return_status => x_return_status
2142: ,x_msg_count => x_msg_count
2143: ,x_msg_data => x_msg_data
2144: );
2145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2146: THEN
2147: RAISE FND_API.G_EXC_ERROR;
2148: END IF;
2149: -- Raw Cost Changes End

Line 2147: RAISE FND_API.G_EXC_ERROR;

2143: ,x_msg_data => x_msg_data
2144: );
2145: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2146: THEN
2147: RAISE FND_API.G_EXC_ERROR;
2148: END IF;
2149: -- Raw Cost Changes End
2150:
2151: ELSE

Line 2158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2154: l_act_project_bur_cost := null; --Raw Cost Changes
2155: l_act_projfunc_bur_cost := null; --Raw Cost Changes
2156: END IF;
2157:
2158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2159: THEN
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:

Line 2160: RAISE FND_API.G_EXC_ERROR;

2156: END IF;
2157:
2158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2159: THEN
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2163: IF g1_debug_mode = 'Y' THEN
2164: -- pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_txn_cost'||l_act_txn_cost, x_Log_Level=> 3);

Line 2195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8

2191: ,x_return_status => x_return_status
2192: ,x_msg_count => x_msg_count
2193: ,x_msg_data => x_msg_data
2194: );
2195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2196: THEN
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: -- Raw Cost Changes Begin

Line 2197: RAISE FND_API.G_EXC_ERROR;

2193: ,x_msg_data => x_msg_data
2194: );
2195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2196: THEN
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: -- Raw Cost Changes Begin
2200: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2201: p_project_id => p_project_id

Line 2225: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8

2221: ,x_return_status => x_return_status
2222: ,x_msg_count => x_msg_count
2223: ,x_msg_data => x_msg_data
2224: );
2225: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229: -- Raw Cost Changes End

Line 2227: RAISE FND_API.G_EXC_ERROR;

2223: ,x_msg_data => x_msg_data
2224: );
2225: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229: -- Raw Cost Changes End
2230: ELSE
2231: l_etc_project_raw_cost := null;

Line 2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2242: -- Bug 4116080 : End
2243: END IF;
2244: END IF;-- NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2245:
2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2247: THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250:

Line 2248: RAISE FND_API.G_EXC_ERROR;

2244: END IF;-- NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2245:
2246: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2247: THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: END IF;
2250:
2251:
2252: IF g1_debug_mode = 'Y' THEN

Line 2571: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2567: x_msg_data => x_msg_data
2568: );
2569: END IF;
2570:
2571: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2572: THEN
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;*/
2575:

Line 2573: RAISE FND_API.G_EXC_ERROR;

2569: END IF;
2570:
2571: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2572: THEN
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;*/
2575:
2576: IF (p_action='PUBLISH' AND (l_act_txn_raw_cost IS NOT NULL OR l_actual_effort_this_period IS NOT NULL
2577: OR l_etc_txn_raw_cost IS NOT NULL OR l_etc_effort_this_period IS NOT NULL)) --bug etc was not getting pushed to PJI due to this statement.

Line 2601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2597: ,p_resource_class_code => l_resource_class_code -- Bug 3836485
2598: ,p_cbs_element_id => l_cbs_element_id -- Added for Bug16200605
2599: );
2600:
2601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2602: THEN
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2605: --BUG 3630743 (If No progress exists default ETC this period as etc - planned)

Line 2603: RAISE FND_API.G_EXC_ERROR;

2599: );
2600:
2601: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2602: THEN
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2605: --BUG 3630743 (If No progress exists default ETC this period as etc - planned)
2606: -- OPEN c_if_progress_exists(l_assignment_id , l_project_id , l_structure_version_id ); --bug# 3764224 Changes for RLM
2607:

Line 2752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2748: x_msg_data => x_msg_data
2749: ,p_cbs_element_id => l_cbs_element_id -- Added for Bug16200605
2750: );
2751:
2752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2753: THEN
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756:

Line 2754: RAISE FND_API.G_EXC_ERROR;

2750: );
2751:
2752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2753: THEN
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756:
2757: END IF;
2758: --bug no. 3595585 Satish end

Line 2785: RAISE FND_API.G_EXC_ERROR;

2781: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2782: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2783: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2784: x_return_status := 'E';
2785: RAISE FND_API.G_EXC_ERROR;
2786: END IF;
2787: END IF;
2788: --bug 4341100, end
2789:

Line 2858: RAISE FND_API.G_EXC_ERROR;

2854: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
2855: );
2856:
2857: IF Fnd_Msg_Pub.count_msg > 0 THEN -- FPM Dev CR 8
2858: RAISE FND_API.G_EXC_ERROR;
2859: END IF;
2860:
2861: l_PROGRESS_ROLLUP_ID := null;
2862: --Create record in progress rollup

Line 2883: RAISE FND_API.G_EXC_ERROR;

2879: ,p_proj_element_id => p_task_id --bug# 3764224 Added for RLM
2880: ,p_cbs_element_id => l_cbs_element_id --Added for 16200605
2881: );
2882: IF Fnd_Msg_Pub.count_msg > 0 THEN
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885:
2886:
2887: IF g1_debug_mode = 'Y' THEN

Line 3030: RAISE FND_API.G_EXC_ERROR;

3026: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
3027: );
3028:
3029: IF Fnd_Msg_Pub.count_msg > 0 THEN
3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;
3032:
3033: IF g1_debug_mode = 'Y' THEN
3034: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPR', x_Log_Level=> 3);

Line 3174: RAISE FND_API.G_EXC_ERROR;

3170: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
3171: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
3172: );
3173: IF Fnd_Msg_Pub.count_msg > 0 THEN
3174: RAISE FND_API.G_EXC_ERROR;
3175: END IF;
3176:
3177:
3178: END IF;

Line 3275: RAISE FND_API.G_EXC_ERROR;

3271: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
3272:
3273: );
3274: IF Fnd_Msg_Pub.count_msg > 0 THEN
3275: RAISE FND_API.G_EXC_ERROR;
3276: END IF;
3277:
3278:
3279:

Line 3434: RAISE FND_API.G_EXC_ERROR;

3430: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
3431:
3432: );
3433: IF Fnd_Msg_Pub.count_msg > 0 THEN
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436:
3437: ELSE
3438: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

Line 3570: RAISE FND_API.G_EXC_ERROR;

3566: ,X_CBS_ELEMENT_ID => l_cbs_element_id --Added for 16200605
3567:
3568: );
3569: IF Fnd_Msg_Pub.count_msg > 0 THEN
3570: RAISE FND_API.G_EXC_ERROR;
3571: END IF;
3572:
3573: END IF;
3574:

Line 3638: RAISE FND_API.G_EXC_ERROR;

3634: WHEN OTHERS THEN
3635: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3636: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3637: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
3638: RAISE FND_API.G_EXC_ERROR;
3639: END;
3640: END IF;
3641: END IF;*/
3642: --bug no.3595585 Satish end

Line 3650: when FND_API.G_EXC_ERROR then

3646: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'EXITING ', x_Log_Level=> 3);
3647: END IF;
3648:
3649: EXCEPTION
3650: when FND_API.G_EXC_ERROR then
3651: x_return_status := FND_API.G_RET_STS_ERROR;
3652: l_msg_count := Fnd_Msg_Pub.count_msg;
3653:
3654: if p_commit = FND_API.G_TRUE then

Line 3651: x_return_status := FND_API.G_RET_STS_ERROR;

3647: END IF;
3648:
3649: EXCEPTION
3650: when FND_API.G_EXC_ERROR then
3651: x_return_status := FND_API.G_RET_STS_ERROR;
3652: l_msg_count := Fnd_Msg_Pub.count_msg;
3653:
3654: if p_commit = FND_API.G_TRUE then
3655: rollback to UPDATE_ASSIGNMENT_PROGRESS;

Line 3654: if p_commit = FND_API.G_TRUE then

3650: when FND_API.G_EXC_ERROR then
3651: x_return_status := FND_API.G_RET_STS_ERROR;
3652: l_msg_count := Fnd_Msg_Pub.count_msg;
3653:
3654: if p_commit = FND_API.G_TRUE then
3655: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3656: end if;
3657:
3658: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 3661: ( p_encoded => Fnd_Api.G_TRUE

3657:
3658: IF l_msg_count = 1 AND x_msg_data IS NULL
3659: THEN
3660: Pa_Interface_Utils_Pub.get_messages
3661: ( p_encoded => Fnd_Api.G_TRUE
3662: , p_msg_index => 1
3663: , p_msg_count => l_msg_count
3664: , p_msg_data => l_msg_data
3665: , p_data => l_data

Line 3673: when FND_API.G_EXC_UNEXPECTED_ERROR then

3669: ELSE
3670: x_msg_count := l_msg_count;
3671: END IF;
3672:
3673: when FND_API.G_EXC_UNEXPECTED_ERROR then
3674: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3675: x_msg_count := 1;
3676: x_msg_data := SQLERRM;
3677:

Line 3674: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3670: x_msg_count := l_msg_count;
3671: END IF;
3672:
3673: when FND_API.G_EXC_UNEXPECTED_ERROR then
3674: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3675: x_msg_count := 1;
3676: x_msg_data := SQLERRM;
3677:
3678: if p_commit = FND_API.G_TRUE then

Line 3678: if p_commit = FND_API.G_TRUE then

3674: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3675: x_msg_count := 1;
3676: x_msg_data := SQLERRM;
3677:
3678: if p_commit = FND_API.G_TRUE then
3679: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3680: end if;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',

Line 3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3677:
3678: if p_commit = FND_API.G_TRUE then
3679: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3680: end if;
3681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3683: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3684: p_error_text => SUBSTRB(SQLERRM,1,240));
3685: when OTHERS then

Line 3686: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3683: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3684: p_error_text => SUBSTRB(SQLERRM,1,240));
3685: when OTHERS then
3686: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3687: x_msg_count := 1;
3688: x_msg_data := SUBSTRB(SQLERRM,1,240);
3689: if p_commit = FND_API.G_TRUE then
3690: rollback to UPDATE_DELIVERABLE_PROGRESS;

Line 3689: if p_commit = FND_API.G_TRUE then

3685: when OTHERS then
3686: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3687: x_msg_count := 1;
3688: x_msg_data := SUBSTRB(SQLERRM,1,240);
3689: if p_commit = FND_API.G_TRUE then
3690: rollback to UPDATE_DELIVERABLE_PROGRESS;
3691: end if;
3692:
3693: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',