DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on FND_API

Line 625: x_return_status := FND_API.g_ret_sts_success;

621: INVALID_BATCH_TYPE_ID EXCEPTION;
622: UNSUPPORTED_ECO_CREATION_TYPE EXCEPTION;
623:
624: BEGIN
625: x_return_status := FND_API.g_ret_sts_success;
626: --l_user_id := FND_GLOBAL.User_Id;
627:
628: -------------------------------------------------------
629: --- Validate Batch Header ---

Line 1027: x_return_status := FND_API.g_ret_sts_error;

1023:
1024: EXCEPTION
1025: WHEN INVALID_ORGANIZATION_ID THEN
1026: x_error_msg := 'Invalid Organization ID';
1027: x_return_status := FND_API.g_ret_sts_error;
1028:
1029: WHEN INVALID_SSM_ID THEN
1030: x_error_msg := 'Invalid Source System Code or ID';
1031: x_return_status := FND_API.g_ret_sts_error;

Line 1031: x_return_status := FND_API.g_ret_sts_error;

1027: x_return_status := FND_API.g_ret_sts_error;
1028:
1029: WHEN INVALID_SSM_ID THEN
1030: x_error_msg := 'Invalid Source System Code or ID';
1031: x_return_status := FND_API.g_ret_sts_error;
1032:
1033: WHEN INVALID_STRUCTURE_TYPE_ID THEN
1034: x_error_msg := 'Invalid Structure Type Name or ID';
1035: IF Ego_Structure_Type_Csr%ISOPEN THEN

Line 1038: x_return_status := FND_API.g_ret_sts_error;

1034: x_error_msg := 'Invalid Structure Type Name or ID';
1035: IF Ego_Structure_Type_Csr%ISOPEN THEN
1036: CLOSE Ego_Structure_Type_Csr;
1037: END IF;
1038: x_return_status := FND_API.g_ret_sts_error;
1039:
1040: WHEN INVALID_STRUCTURE_EFF_TYPE THEN
1041: x_error_msg := 'Invalid Structure Effectivity Type';
1042: x_return_status := FND_API.g_ret_sts_error;

Line 1042: x_return_status := FND_API.g_ret_sts_error;

1038: x_return_status := FND_API.g_ret_sts_error;
1039:
1040: WHEN INVALID_STRUCTURE_EFF_TYPE THEN
1041: x_error_msg := 'Invalid Structure Effectivity Type';
1042: x_return_status := FND_API.g_ret_sts_error;
1043:
1044: WHEN INVALID_DEF_MAT_RULE_CODE THEN
1045: x_error_msg := 'Invalid Default Match Rule Code';
1046: IF Ego_Def_Match_Rule_Csr%ISOPEN THEN

Line 1049: x_return_status := FND_API.g_ret_sts_error;

1045: x_error_msg := 'Invalid Default Match Rule Code';
1046: IF Ego_Def_Match_Rule_Csr%ISOPEN THEN
1047: CLOSE Ego_Def_Match_Rule_Csr;
1048: END IF;
1049: x_return_status := FND_API.g_ret_sts_error;
1050:
1051: WHEN INVALID_CHG_ORDER_TYPE THEN
1052: x_error_msg := 'Invalid Change Order Type';
1053: IF Change_Order_Type_Csr%ISOPEN THEN

Line 1056: x_return_status := FND_API.g_ret_sts_error;

1052: x_error_msg := 'Invalid Change Order Type';
1053: IF Change_Order_Type_Csr%ISOPEN THEN
1054: CLOSE Change_Order_Type_Csr;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057:
1058: WHEN INVALID_CHG_ORDER_NOTICE THEN
1059: x_error_msg := 'Invalid Change Order Notice';
1060: IF Change_Order_Notice_Csr%ISOPEN THEN

Line 1063: x_return_status := FND_API.g_ret_sts_error;

1059: x_error_msg := 'Invalid Change Order Notice';
1060: IF Change_Order_Notice_Csr%ISOPEN THEN
1061: CLOSE Change_Order_Notice_Csr;
1062: END IF;
1063: x_return_status := FND_API.g_ret_sts_error;
1064:
1065: WHEN INVALID_BATCH_TYPE_ID THEN
1066: x_error_msg := 'Invalid Import Batch Type';
1067: x_return_status := FND_API.g_ret_sts_error;

Line 1067: x_return_status := FND_API.g_ret_sts_error;

1063: x_return_status := FND_API.g_ret_sts_error;
1064:
1065: WHEN INVALID_BATCH_TYPE_ID THEN
1066: x_error_msg := 'Invalid Import Batch Type';
1067: x_return_status := FND_API.g_ret_sts_error;
1068:
1069: WHEN UNSUPPORTED_ECO_CREATION_TYPE THEN
1070: x_error_msg := 'Not support create new ECO';
1071: x_return_status := FND_API.g_ret_sts_error;

Line 1071: x_return_status := FND_API.g_ret_sts_error;

1067: x_return_status := FND_API.g_ret_sts_error;
1068:
1069: WHEN UNSUPPORTED_ECO_CREATION_TYPE THEN
1070: x_error_msg := 'Not support create new ECO';
1071: x_return_status := FND_API.g_ret_sts_error;
1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.g_ret_sts_error;
1075: l_err_text := SUBSTRB(SQLERRM, 1, 240);

Line 1074: x_return_status := FND_API.g_ret_sts_error;

1070: x_error_msg := 'Not support create new ECO';
1071: x_return_status := FND_API.g_ret_sts_error;
1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.g_ret_sts_error;
1075: l_err_text := SUBSTRB(SQLERRM, 1, 240);
1076: x_error_msg := l_err_text;
1077:
1078: END Create_Import_Batch;

Line 1117: x_return_status := FND_API.g_ret_sts_success;

1113: INVALID_BATCH_NAME EXCEPTION;
1114: INVALID_BATCH_STATUS EXCEPTION;
1115:
1116: BEGIN
1117: x_return_status := FND_API.g_ret_sts_success;
1118:
1119: --Validate import batch id and name
1120: OPEN Ego_Import_Batch_Csr(v_batch_id => NVL(p_batch_id, 0));
1121: FETCH Ego_Import_Batch_Csr

Line 1149: x_return_status := FND_API.g_ret_sts_error;

1145: WHERE BATCH_ID = p_batch_id;
1146:
1147: EXCEPTION
1148: WHEN INVALID_BATCH_ID THEN
1149: x_return_status := FND_API.g_ret_sts_error;
1150: x_error_msg := 'Invalid Import Batch ID';
1151: IF Ego_Import_Batch_Csr%ISOPEN THEN
1152: CLOSE Ego_Import_Batch_Csr;
1153: END IF;

Line 1156: x_return_status := FND_API.g_ret_sts_error;

1152: CLOSE Ego_Import_Batch_Csr;
1153: END IF;
1154:
1155: WHEN INVALID_BATCH_NAME THEN
1156: x_return_status := FND_API.g_ret_sts_error;
1157: x_error_msg := 'Invalid Import Batch Name';
1158: IF Ego_Batch_Status_Csr%ISOPEN THEN
1159: CLOSE Ego_Batch_Status_Csr;
1160: END IF;

Line 1163: x_return_status := FND_API.g_ret_sts_error;

1159: CLOSE Ego_Batch_Status_Csr;
1160: END IF;
1161:
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.g_ret_sts_error;
1164: l_err_text := SUBSTRB(SQLERRM, 1, 240);
1165: x_error_msg := l_err_text;
1166:
1167: END UPDATE_BATCH_STATUS;