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 511: IF (p_commit = FND_API.G_TRUE) THEN

507: IF g1_debug_mode = 'Y' THEN
508: pa_debug.init_err_stack ('PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS');
509: END IF;
510:
511: IF (p_commit = FND_API.G_TRUE) THEN
512: savepoint UPDATE_ASSIGNMENT_PROGRESS;
513: END IF;
514:
515: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

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

511: IF (p_commit = FND_API.G_TRUE) THEN
512: savepoint UPDATE_ASSIGNMENT_PROGRESS;
513: END IF;
514:
515: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

512: savepoint UPDATE_ASSIGNMENT_PROGRESS;
513: END IF;
514:
515: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
520: FND_MSG_PUB.initialize;

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

515: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: END IF;
518:
519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: IF g1_debug_mode = 'Y' THEN

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'p_rate_based_flag: '||p_rate_based_flag, x_Log_Level=> 3);
543: END IF;
544:
545:
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547:
548: --moved this up for bug 3675107
549: ---4457403, added begin/end block to handle no_data_found exception
550: begin

Line 560: RAISE FND_API.G_EXC_ERROR;

556: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
557: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
558: x_return_status := 'E';
559: x_msg_count := fnd_msg_pub.count_msg;
560: RAISE FND_API.G_EXC_ERROR;
561: end;
562:
563: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
564: --moved this up for bug 3675107

Line 731: RAISE FND_API.G_EXC_ERROR;

727: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
728: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
729: x_msg_data := 'PA_TP_NO_NEG_ACT';
730: x_return_status := 'E';
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733: */
734: --bug 3958686, end
735:

Line 754: RAISE FND_API.G_EXC_ERROR;

750: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
751: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
752: x_msg_data := 'PA_TP_NO_NEG_ETC';
753: x_return_status := 'E';
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: */
757:
758:

Line 829: RAISE FND_API.G_EXC_ERROR;

825: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
826: ,p_msg_name => 'PA_TP_NO_NEG_ACT');
827: x_msg_data := 'PA_TP_NO_NEG_ACT';
828: x_return_status := 'E';
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831: */
832:
833:

Line 859: RAISE FND_API.G_EXC_ERROR;

855: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
856: ,p_msg_name => 'PA_TP_NO_NEG_ETC');
857: x_msg_data := 'PA_TP_NO_NEG_ETC';
858: x_return_status := 'E';
859: RAISE FND_API.G_EXC_ERROR;
860: END IF;
861: */
862:
863: /* Bug 3606627 Shifting this code below

Line 877: RAISE FND_API.G_EXC_ERROR;

873: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
874: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
875: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';
876: x_return_status := 'E';
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: ---- if status is CANCELLED
880:
881: /* Commented by rtarway for BUG 3762650

Line 889: RAISE FND_API.G_EXC_ERROR;

885: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
886: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
887: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';
888: x_return_status := 'E';
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: ---- if status is ON HOLD
892: */
893: --bug no. 3586648 start

Line 910: RAISE FND_API.G_EXC_ERROR;

906: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
907: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
908: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
909: x_return_status := 'E';
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: END IF;*/
913: --- check if structure is shared and actuals are passed
914: --bug no. 3586648 end

Line 926: RAISE FND_API.G_EXC_ERROR;

922: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
923: ,p_msg_name => 'PA_TP_CANT_NTER_ACT_SHR_STR');
924: x_msg_data := 'PA_TP_CANT_NTER_ACT_SHR_STR';
925: x_return_status := 'E';
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928: END IF;
929: --end added by rtarway for 3816022
930:

Line 938: RAISE FND_API.G_EXC_ERROR;

934: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
935: ,p_msg_name => 'PA_TP_WRONG_PRG_MODE4');
936: x_msg_data := 'PA_TP_WRONG_PRG_MODE4';
937: x_return_status := 'E';
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: ----- Wrong MODE
941:
942: ----- Invalid DATE

Line 949: RAISE FND_API.G_EXC_ERROR;

945: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
946: ,p_msg_name => 'PA_TP_INV_AOD');
947: x_msg_data := 'PA_TP_INV_AOD';
948: x_return_status := 'E';
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951: ----- Wrong DATE
952:
953:

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: 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
957: THEN
958: IF (p_estimated_finish_date < p_estimated_start_date)
959: THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: pa_utils.add_message(p_app_short_name => 'PA',
962: p_msg_name => 'PA_EST_DATES_INV');
963: raise fnd_api.g_exc_error;
964: END IF;

Line 963: raise fnd_api.g_exc_error;

959: THEN
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: pa_utils.add_message(p_app_short_name => 'PA',
962: p_msg_name => 'PA_EST_DATES_INV');
963: raise fnd_api.g_exc_error;
964: END IF;
965: END IF;
966: */
967:

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
1060: P_TOKEN1 => 'OBJECT_ID',
1061: P_VALUE1 => l_resource_list_member_id);
1062: x_msg_data := 'PA_TP_INV_ASSGN_AMG';
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END;
1066:
1067:

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060: P_TOKEN1 => 'OBJECT_ID',
1061: P_VALUE1 => l_resource_list_member_id);
1062: x_msg_data := 'PA_TP_INV_ASSGN_AMG';
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END;
1066:
1067:
1068: /* Begin: Fix for Bug # 3988457. */

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

1090: l_estimated_start_date := l_scheduled_start_date;
1091: END IF;
1092:
1093: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: pa_utils.add_message(p_app_short_name => 'PA',
1096: p_msg_name => 'PA_EST_DATES_INV');
1097: raise fnd_api.g_exc_error;
1098: END IF;

Line 1097: raise fnd_api.g_exc_error;

1093: IF l_estimated_finish_date is not null and l_estimated_finish_date < nvl(l_estimated_start_date,l_estimated_finish_date+1) THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: pa_utils.add_message(p_app_short_name => 'PA',
1096: p_msg_name => 'PA_EST_DATES_INV');
1097: raise fnd_api.g_exc_error;
1098: END IF;
1099: -- Bug 3979303 : End
1100:
1101:

Line 1241: raise FND_API.G_EXC_ERROR;

1237: 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);
1238: END IF;
1239:
1240: IF x_return_status <> 'S' THEN
1241: raise FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1245: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)

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

1240: IF x_return_status <> 'S' THEN
1241: raise FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1245: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1246: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1247: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1248: THEN

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

1241: raise FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1245: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1246: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1247: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1248: THEN
1249: l_date_override_flag := 'Y';

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

1242: END IF;
1243:
1244: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1245: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1246: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1247: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1248: THEN
1249: l_date_override_flag := 'Y';
1250: l_estimated_start_date := l_clex_estimated_start_date;

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

1243:
1244: IF nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_start_date,FND_API.g_miss_date)
1245: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_clex_estimated_finish_date,FND_API.g_miss_date)
1246: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_clex_actual_start_date,FND_API.g_miss_date)
1247: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_clex_actual_finish_date,FND_API.g_miss_date)
1248: THEN
1249: l_date_override_flag := 'Y';
1250: l_estimated_start_date := l_clex_estimated_start_date;
1251: l_estimated_finish_date := l_clex_estimated_finish_date;

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

1257: l_date_override_flag := 'Y';
1258: END IF;
1259:
1260: IF l_date_override_flag = 'N' AND
1261: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1262: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1263: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1264: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1265: THEN

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

1258: END IF;
1259:
1260: IF l_date_override_flag = 'N' AND
1261: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1262: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1263: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1264: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1265: THEN
1266: l_date_override_flag := 'Y';

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

1259:
1260: IF l_date_override_flag = 'N' AND
1261: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1262: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1263: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1264: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1265: THEN
1266: l_date_override_flag := 'Y';
1267: END IF;

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

1260: IF l_date_override_flag = 'N' AND
1261: (nvl(l_estimated_start_date,FND_API.g_miss_date) <> nvl(l_db_estimated_start_date,FND_API.g_miss_date)
1262: OR nvl(l_estimated_finish_date,FND_API.g_miss_date) <> nvl(l_db_estimated_finish_date,FND_API.g_miss_date)
1263: OR nvl(l_actual_start_date,FND_API.g_miss_date) <> nvl(l_db_actual_start_date,FND_API.g_miss_date)
1264: OR nvl(l_actual_finish_date,FND_API.g_miss_date) <> nvl(l_db_actual_finish_date,FND_API.g_miss_date))
1265: THEN
1266: l_date_override_flag := 'Y';
1267: END IF;
1268:

Line 1354: RAISE FND_API.G_EXC_ERROR;

1350: p_token1 => 'AS_OF_DATE',
1351: p_value1 => p_as_of_date );
1352: x_msg_data := 'PA_TP_ASSG_WRONG_PRG_MODE3';
1353: x_return_status := 'E';
1354: RAISE FND_API.G_EXC_ERROR;
1355: --bug# 3821106 Satish start, bug 4185364
1356: /*ELSIF (p_as_of_date = NVL(l_last_progress_date, p_as_of_date + 1 ) AND p_action = 'SAVE')
1357: THEN
1358: if (l_working_aod = p_as_of_date) then

Line 1375: RAISE FND_API.G_EXC_ERROR;

1371: p_token1 => 'AS_OF_DATE',
1372: p_value1 => p_as_of_date );
1373: x_msg_data := 'PA_TP_ASSG_WRONG_ACTION';
1374: x_return_status := 'E';
1375: RAISE FND_API.G_EXC_ERROR;
1376: --bug# 3821106 Satish end
1377: */
1378: ELSE
1379: --Validate as of date

Line 1397: RAISE FND_API.G_EXC_ERROR;

1393: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1394: ,p_msg_name => 'PA_TP_INV_AOD2');
1395: x_msg_data := 'PA_TP_INV_AOD2';
1396: x_return_status := 'E';
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;*/
1399:
1400: IF l_progress_exists_on_aod = 'WORKING'
1401: THEN

Line 1585: RAISE FND_API.G_EXC_ERROR;

1581: WHEN OTHERS THEN
1582: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1583: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1584: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));
1585: RAISE FND_API.G_EXC_ERROR;
1586:
1587: END;
1588:
1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1585: RAISE FND_API.G_EXC_ERROR;
1586:
1587: END;
1588:
1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1590: x_return_status := 'E';
1591: x_msg_data := l_msg_data;
1592: x_msg_count := l_msg_count;
1593: RAISE FND_API.G_EXC_ERROR;

Line 1593: RAISE FND_API.G_EXC_ERROR;

1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1590: x_return_status := 'E';
1591: x_msg_data := l_msg_data;
1592: x_msg_count := l_msg_count;
1593: RAISE FND_API.G_EXC_ERROR;
1594: END IF;
1595:
1596: -- Bug 3696429 currency conversion for resource Satish 03-JUL-2004 start
1597: IF l_txn_currency_code <> l_res_cur_code

Line 1623: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1619: ,x_msg_count => l_msg_count
1620: ,x_msg_data => l_msg_data
1621: );
1622:
1623: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1624: x_return_status := 'E';
1625: x_msg_data := l_msg_data;
1626: x_msg_count := l_msg_count;
1627: RAISE FND_API.G_EXC_ERROR;

Line 1627: RAISE FND_API.G_EXC_ERROR;

1623: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1624: x_return_status := 'E';
1625: x_msg_data := l_msg_data;
1626: x_msg_count := l_msg_count;
1627: RAISE FND_API.G_EXC_ERROR;
1628: END IF;
1629:
1630: IF l_res_raw_rate <> l_res_burden_rate
1631: THEN

Line 1655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1651: ,x_return_status => l_return_status
1652: ,x_msg_count => l_msg_count
1653: ,x_msg_data => l_msg_data
1654: );
1655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1656: x_return_status := 'E';
1657: x_msg_data := l_msg_data;
1658: x_msg_count := l_msg_count;
1659: RAISE FND_API.G_EXC_ERROR;

Line 1659: RAISE FND_API.G_EXC_ERROR;

1655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1656: x_return_status := 'E';
1657: x_msg_data := l_msg_data;
1658: x_msg_count := l_msg_count;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1661:
1662: l_res_burden_rate := l_proj_res_burden_rate;
1663: ELSE

Line 1710: RAISE FND_API.G_EXC_ERROR;

1706: WHEN OTHERS THEN
1707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1708: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1709: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));
1710: RAISE FND_API.G_EXC_ERROR;
1711:
1712: END;
1713:
1714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1710: RAISE FND_API.G_EXC_ERROR;
1711:
1712: END;
1713:
1714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1715: x_return_status := 'E';
1716: x_msg_data := l_msg_data;
1717: x_msg_count := l_msg_count;
1718: RAISE FND_API.G_EXC_ERROR;

Line 1718: RAISE FND_API.G_EXC_ERROR;

1714: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1715: x_return_status := 'E';
1716: x_msg_data := l_msg_data;
1717: x_msg_count := l_msg_count;
1718: RAISE FND_API.G_EXC_ERROR;
1719: END IF;
1720: -- Bug 3784874 currency conversion for ETC Start
1721: --IF l_txn_currency_code <> l_res_cur_code
1722: IF l_txn_currency_code <> l_plan_res_cur_code -- 06-sep-2004,3860575 Satish

Line 1748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1744: ,x_msg_count => l_msg_count
1745: ,x_msg_data => l_msg_data
1746: );
1747:
1748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1749: x_return_status := 'E';
1750: x_msg_data := l_msg_data;
1751: x_msg_count := l_msg_count;
1752: RAISE FND_API.G_EXC_ERROR;

Line 1752: RAISE FND_API.G_EXC_ERROR;

1748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1749: x_return_status := 'E';
1750: x_msg_data := l_msg_data;
1751: x_msg_count := l_msg_count;
1752: RAISE FND_API.G_EXC_ERROR;
1753: END IF;
1754:
1755: IF l_plan_res_raw_rate <> l_plan_res_burden_rate
1756: THEN

Line 1780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1776: ,x_return_status => l_return_status
1777: ,x_msg_count => l_msg_count
1778: ,x_msg_data => l_msg_data
1779: );
1780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1781: x_return_status := 'E';
1782: x_msg_data := l_msg_data;
1783: x_msg_count := l_msg_count;
1784: RAISE FND_API.G_EXC_ERROR;

Line 1784: RAISE FND_API.G_EXC_ERROR;

1780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1781: x_return_status := 'E';
1782: x_msg_data := l_msg_data;
1783: x_msg_count := l_msg_count;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: l_plan_res_burden_rate := l_proj_res_burden_rate;
1788: ELSE

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

1834: ,x_return_status => x_return_status
1835: ,x_msg_count => x_msg_count
1836: ,x_msg_data => x_msg_data
1837: );
1838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
1839: THEN
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:

Line 1840: RAISE FND_API.G_EXC_ERROR;

1836: ,x_msg_data => x_msg_data
1837: );
1838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
1839: THEN
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:
1843: l_act_txn_cost := l_res_txn_cost_tbl(1); -- This is incremental
1844: */

Line 1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1895: ,x_msg_count => x_msg_count
1896: ,x_msg_data => x_msg_data
1897: );
1898:
1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1900: THEN
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903: l_etc_txn_cost := l_etc_res_txn_cost_tbl(1); -- This is cumulative

Line 1901: RAISE FND_API.G_EXC_ERROR;

1897: );
1898:
1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1900: THEN
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903: l_etc_txn_cost := l_etc_res_txn_cost_tbl(1); -- This is cumulative
1904: */
1905: -- Bug 3627315 : Using plan rates instead of actual rates

Line 1974: RAISE FND_API.G_EXC_ERROR;

1970: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1971: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
1972: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
1973: x_return_status := 'E';
1974: RAISE FND_API.G_EXC_ERROR;
1975: END IF;
1976: END IF;*/
1977: --bug no. 3586648
1978:

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

2000: ,x_return_status => x_return_status
2001: ,x_msg_count => x_msg_count
2002: ,x_msg_data => x_msg_data
2003: );
2004: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2005: THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: -- Raw Cost Changes Begin

Line 2006: RAISE FND_API.G_EXC_ERROR;

2002: ,x_msg_data => x_msg_data
2003: );
2004: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2005: THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: -- Raw Cost Changes Begin
2009: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2010: p_project_id => p_project_id

Line 2031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2027: ,x_return_status => x_return_status
2028: ,x_msg_count => x_msg_count
2029: ,x_msg_data => x_msg_data
2030: );
2031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2032: THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035: -- Raw Cost Changes End

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029: ,x_msg_data => x_msg_data
2030: );
2031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2032: THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035: -- Raw Cost Changes End
2036:
2037: ELSE

Line 2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2040: l_act_project_bur_cost := null; --Raw Cost Changes
2041: l_act_projfunc_bur_cost := null; --Raw Cost Changes
2042: END IF;
2043:
2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2045: THEN
2046: RAISE FND_API.G_EXC_ERROR;
2047: END IF;
2048:

Line 2046: RAISE FND_API.G_EXC_ERROR;

2042: END IF;
2043:
2044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2045: THEN
2046: RAISE FND_API.G_EXC_ERROR;
2047: END IF;
2048:
2049: IF g1_debug_mode = 'Y' THEN
2050: -- 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 2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8

2077: ,x_return_status => x_return_status
2078: ,x_msg_count => x_msg_count
2079: ,x_msg_data => x_msg_data
2080: );
2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2082: THEN
2083: RAISE FND_API.G_EXC_ERROR;
2084: END IF;
2085: -- Raw Cost Changes Begin

Line 2083: RAISE FND_API.G_EXC_ERROR;

2079: ,x_msg_data => x_msg_data
2080: );
2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2082: THEN
2083: RAISE FND_API.G_EXC_ERROR;
2084: END IF;
2085: -- Raw Cost Changes Begin
2086: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2087: p_project_id => p_project_id

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

2107: ,x_return_status => x_return_status
2108: ,x_msg_count => x_msg_count
2109: ,x_msg_data => x_msg_data
2110: );
2111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2112: THEN
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115: -- Raw Cost Changes End

Line 2113: RAISE FND_API.G_EXC_ERROR;

2109: ,x_msg_data => x_msg_data
2110: );
2111: IF x_return_status <> FND_API.G_RET_STS_SUCCESS -- FPM Dev CR 8
2112: THEN
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115: -- Raw Cost Changes End
2116: ELSE
2117: l_etc_project_raw_cost := null;

Line 2132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2128: -- Bug 4116080 : End
2129: END IF;
2130: END IF;-- NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2131:
2132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2133: THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:

Line 2134: RAISE FND_API.G_EXC_ERROR;

2130: END IF;-- NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2131:
2132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2133: THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137:
2138: IF g1_debug_mode = 'Y' THEN

Line 2457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2453: x_msg_data => x_msg_data
2454: );
2455: END IF;
2456:
2457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2458: THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: END IF;*/
2461:

Line 2459: RAISE FND_API.G_EXC_ERROR;

2455: END IF;
2456:
2457: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2458: THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: END IF;*/
2461:
2462: IF (p_action='PUBLISH' AND (l_act_txn_raw_cost IS NOT NULL OR l_actual_effort_this_period IS NOT NULL
2463: 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 2486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2482: ,p_proj_element_id => p_task_id --bug# 3764224 Added for RLM
2483: ,p_resource_class_code => l_resource_class_code -- Bug 3836485
2484: );
2485:
2486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2487: THEN
2488: RAISE FND_API.G_EXC_ERROR;
2489: END IF;
2490: --BUG 3630743 (If No progress exists default ETC this period as etc - planned)

Line 2488: RAISE FND_API.G_EXC_ERROR;

2484: );
2485:
2486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2487: THEN
2488: RAISE FND_API.G_EXC_ERROR;
2489: END IF;
2490: --BUG 3630743 (If No progress exists default ETC this period as etc - planned)
2491: -- OPEN c_if_progress_exists(l_assignment_id , l_project_id , l_structure_version_id ); --bug# 3764224 Changes for RLM
2492:

Line 2635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2631: x_msg_count => x_msg_count,
2632: x_msg_data => x_msg_data
2633: );
2634:
2635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2636: THEN
2637: RAISE FND_API.G_EXC_ERROR;
2638: END IF;
2639:

Line 2637: RAISE FND_API.G_EXC_ERROR;

2633: );
2634:
2635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2636: THEN
2637: RAISE FND_API.G_EXC_ERROR;
2638: END IF;
2639:
2640: END IF;
2641: --bug no. 3595585 Satish end

Line 2668: RAISE FND_API.G_EXC_ERROR;

2664: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2665: ,p_msg_name => 'PA_TP_ASSG_NTER_FIN_DATE');
2666: x_msg_data := 'PA_TP_ASSG_NTER_FIN_DATE';
2667: x_return_status := 'E';
2668: RAISE FND_API.G_EXC_ERROR;
2669: END IF;
2670: END IF;
2671: --bug 4341100, end
2672:

Line 2735: RAISE FND_API.G_EXC_ERROR;

2731: ,p_structure_type => p_structure_type
2732: );
2733:
2734: IF Fnd_Msg_Pub.count_msg > 0 THEN -- FPM Dev CR 8
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737:
2738: l_PROGRESS_ROLLUP_ID := null;
2739: --Create record in progress rollup

Line 2759: RAISE FND_API.G_EXC_ERROR;

2755: ,x_record_version_number => l_rollup_rec_ver_number
2756: ,p_proj_element_id => p_task_id --bug# 3764224 Added for RLM
2757: );
2758: IF Fnd_Msg_Pub.count_msg > 0 THEN
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761:
2762:
2763: IF g1_debug_mode = 'Y' THEN

Line 2905: RAISE FND_API.G_EXC_ERROR;

2901: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
2902: );
2903:
2904: IF Fnd_Msg_Pub.count_msg > 0 THEN
2905: RAISE FND_API.G_EXC_ERROR;
2906: END IF;
2907:
2908: IF g1_debug_mode = 'Y' THEN
2909: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPR', x_Log_Level=> 3);

Line 3048: RAISE FND_API.G_EXC_ERROR;

3044: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
3045: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
3046: );
3047: IF Fnd_Msg_Pub.count_msg > 0 THEN
3048: RAISE FND_API.G_EXC_ERROR;
3049: END IF;
3050:
3051:
3052: END IF;

Line 3143: RAISE FND_API.G_EXC_ERROR;

3139: ,p_structure_type => p_structure_type
3140:
3141: );
3142: IF Fnd_Msg_Pub.count_msg > 0 THEN
3143: RAISE FND_API.G_EXC_ERROR;
3144: END IF;
3145:
3146:
3147:

Line 3299: RAISE FND_API.G_EXC_ERROR;

3295: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
3296: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
3297: );
3298: IF Fnd_Msg_Pub.count_msg > 0 THEN
3299: RAISE FND_API.G_EXC_ERROR;
3300: END IF;
3301:
3302: ELSE
3303: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

Line 3433: RAISE FND_API.G_EXC_ERROR;

3429: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
3430: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
3431: );
3432: IF Fnd_Msg_Pub.count_msg > 0 THEN
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;
3435:
3436: END IF;
3437:

Line 3501: RAISE FND_API.G_EXC_ERROR;

3497: WHEN OTHERS THEN
3498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3499: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3500: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
3501: RAISE FND_API.G_EXC_ERROR;
3502: END;
3503: END IF;
3504: END IF;*/
3505: --bug no.3595585 Satish end

Line 3513: when FND_API.G_EXC_ERROR then

3509: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'EXITING ', x_Log_Level=> 3);
3510: END IF;
3511:
3512: EXCEPTION
3513: when FND_API.G_EXC_ERROR then
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: l_msg_count := Fnd_Msg_Pub.count_msg;
3516:
3517: if p_commit = FND_API.G_TRUE then

Line 3514: x_return_status := FND_API.G_RET_STS_ERROR;

3510: END IF;
3511:
3512: EXCEPTION
3513: when FND_API.G_EXC_ERROR then
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: l_msg_count := Fnd_Msg_Pub.count_msg;
3516:
3517: if p_commit = FND_API.G_TRUE then
3518: rollback to UPDATE_ASSIGNMENT_PROGRESS;

Line 3517: if p_commit = FND_API.G_TRUE then

3513: when FND_API.G_EXC_ERROR then
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: l_msg_count := Fnd_Msg_Pub.count_msg;
3516:
3517: if p_commit = FND_API.G_TRUE then
3518: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3519: end if;
3520:
3521: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 3524: ( p_encoded => Fnd_Api.G_TRUE

3520:
3521: IF l_msg_count = 1 AND x_msg_data IS NULL
3522: THEN
3523: Pa_Interface_Utils_Pub.get_messages
3524: ( p_encoded => Fnd_Api.G_TRUE
3525: , p_msg_index => 1
3526: , p_msg_count => l_msg_count
3527: , p_msg_data => l_msg_data
3528: , p_data => l_data

Line 3536: when FND_API.G_EXC_UNEXPECTED_ERROR then

3532: ELSE
3533: x_msg_count := l_msg_count;
3534: END IF;
3535:
3536: when FND_API.G_EXC_UNEXPECTED_ERROR then
3537: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: x_msg_count := 1;
3539: x_msg_data := SQLERRM;
3540:

Line 3537: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3533: x_msg_count := l_msg_count;
3534: END IF;
3535:
3536: when FND_API.G_EXC_UNEXPECTED_ERROR then
3537: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: x_msg_count := 1;
3539: x_msg_data := SQLERRM;
3540:
3541: if p_commit = FND_API.G_TRUE then

Line 3541: if p_commit = FND_API.G_TRUE then

3537: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3538: x_msg_count := 1;
3539: x_msg_data := SQLERRM;
3540:
3541: if p_commit = FND_API.G_TRUE then
3542: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3543: end if;
3544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',

Line 3544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3540:
3541: if p_commit = FND_API.G_TRUE then
3542: rollback to UPDATE_ASSIGNMENT_PROGRESS;
3543: end if;
3544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3546: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3547: p_error_text => SUBSTRB(SQLERRM,1,240));
3548: when OTHERS then

Line 3549: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
3546: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
3547: p_error_text => SUBSTRB(SQLERRM,1,240));
3548: when OTHERS then
3549: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3550: x_msg_count := 1;
3551: x_msg_data := SUBSTRB(SQLERRM,1,240);
3552: if p_commit = FND_API.G_TRUE then
3553: rollback to UPDATE_DELIVERABLE_PROGRESS;

Line 3552: if p_commit = FND_API.G_TRUE then

3548: when OTHERS then
3549: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3550: x_msg_count := 1;
3551: x_msg_data := SUBSTRB(SQLERRM,1,240);
3552: if p_commit = FND_API.G_TRUE then
3553: rollback to UPDATE_DELIVERABLE_PROGRESS;
3554: end if;
3555:
3556: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',