APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_MESSAGE

Line 762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

758:
759: BEGIN
760: v_wlji_process_status(v_idx) := 3;
761: v_wlji_err_code(v_idx) := -1;
762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
763: fnd_message.set_token('FLD_NAME', p_field);
764: l_err_msg := fnd_message.get;
765: v_wlji_err_msg(v_idx) := l_err_msg;
766: fnd_file.put_line(fnd_file.log,

Line 763: fnd_message.set_token('FLD_NAME', p_field);

759: BEGIN
760: v_wlji_process_status(v_idx) := 3;
761: v_wlji_err_code(v_idx) := -1;
762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
763: fnd_message.set_token('FLD_NAME', p_field);
764: l_err_msg := fnd_message.get;
765: v_wlji_err_msg(v_idx) := l_err_msg;
766: fnd_file.put_line(fnd_file.log,
767: 'Error: (stmt_num: '|| stmt_number ||') '||l_err_msg||' '||p_aux_string);

Line 764: l_err_msg := fnd_message.get;

760: v_wlji_process_status(v_idx) := 3;
761: v_wlji_err_code(v_idx) := -1;
762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
763: fnd_message.set_token('FLD_NAME', p_field);
764: l_err_msg := fnd_message.get;
765: v_wlji_err_msg(v_idx) := l_err_msg;
766: fnd_file.put_line(fnd_file.log,
767: 'Error: (stmt_num: '|| stmt_number ||') '||l_err_msg||' '||p_aux_string);
768: fnd_file.new_line(fnd_file.log, 3);

Line 790: fnd_message.set_name(p_product, p_message_name);

786:
787: BEGIN
788: v_wlji_process_status(v_idx) := 3; --ERROR
789: v_wlji_err_code(v_idx) := -1;
790: fnd_message.set_name(p_product, p_message_name);
791: l_err_msg := fnd_message.get;
792: v_wlji_err_msg(v_idx) := l_err_msg;
793: fnd_file.put_line(fnd_file.log,
794: 'Error: (stmt_num: '|| stmt_number||') '||l_err_msg);

Line 791: l_err_msg := fnd_message.get;

787: BEGIN
788: v_wlji_process_status(v_idx) := 3; --ERROR
789: v_wlji_err_code(v_idx) := -1;
790: fnd_message.set_name(p_product, p_message_name);
791: l_err_msg := fnd_message.get;
792: v_wlji_err_msg(v_idx) := l_err_msg;
793: fnd_file.put_line(fnd_file.log,
794: 'Error: (stmt_num: '|| stmt_number||') '||l_err_msg);
795: fnd_file.new_line(fnd_file.log, 3);

Line 872: fnd_message.set_name('wsm','wsm_net_start_not_found');

868:
869: exception
870: when no_data_found then
871: x_err_code := -2;
872: fnd_message.set_name('wsm','wsm_net_start_not_found');
873: x_err_msg:= fnd_message.get;
874: return;
875:
876: when others then

Line 873: x_err_msg:= fnd_message.get;

869: exception
870: when no_data_found then
871: x_err_code := -2;
872: fnd_message.set_name('wsm','wsm_net_start_not_found');
873: x_err_msg:= fnd_message.get;
874: return;
875:
876: when others then
877: x_err_code := sqlcode;

Line 911: fnd_message.set_name('wsm','wsm_net_end_not_found');

907:
908: exception
909: when no_data_found then
910: x_err_code := -2;
911: fnd_message.set_name('wsm','wsm_net_end_not_found');
912: x_err_msg:= fnd_message.get;
913: return;
914:
915: when others then

Line 912: x_err_msg:= fnd_message.get;

908: exception
909: when no_data_found then
910: x_err_code := -2;
911: fnd_message.set_name('wsm','wsm_net_end_not_found');
912: x_err_msg:= fnd_message.get;
913: return;
914:
915: when others then
916: x_err_code := sqlcode;

Line 970: fnd_message.set_name('WSM','WSM_NULL_FIELD');

966: x_error_msg := '';
967: l_stmt_num := 10;
968: if p_org_id IS NULL then
969: if p_org_code IS NULL then
970: fnd_message.set_name('WSM','WSM_NULL_FIELD');
971: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');
972: x_error_msg := fnd_message.get;
973: x_error_code := -1;
974: return;

Line 971: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');

967: l_stmt_num := 10;
968: if p_org_id IS NULL then
969: if p_org_code IS NULL then
970: fnd_message.set_name('WSM','WSM_NULL_FIELD');
971: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');
972: x_error_msg := fnd_message.get;
973: x_error_code := -1;
974: return;
975: end if;

Line 972: x_error_msg := fnd_message.get;

968: if p_org_id IS NULL then
969: if p_org_code IS NULL then
970: fnd_message.set_name('WSM','WSM_NULL_FIELD');
971: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');
972: x_error_msg := fnd_message.get;
973: x_error_code := -1;
974: return;
975: end if;
976:

Line 991: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

987: where organization_code = p_org_code;
988: -- bug 5051885
989: exception
990: when others then
991: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
992: fnd_message.set_token('FLD_NAME', 'Organization Code');
993: x_error_msg := fnd_message.get;
994: x_error_code := -1;
995: return;

Line 992: fnd_message.set_token('FLD_NAME', 'Organization Code');

988: -- bug 5051885
989: exception
990: when others then
991: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
992: fnd_message.set_token('FLD_NAME', 'Organization Code');
993: x_error_msg := fnd_message.get;
994: x_error_code := -1;
995: return;
996: end;

Line 993: x_error_msg := fnd_message.get;

989: exception
990: when others then
991: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
992: fnd_message.set_token('FLD_NAME', 'Organization Code');
993: x_error_msg := fnd_message.get;
994: x_error_code := -1;
995: return;
996: end;
997: else

Line 1006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1002: -- now p_org_id is always available
1003: l_xst := true;
1004: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1005: if l_xst = false then
1006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1007: fnd_message.set_token('FLD_NAME', 'Organization ID');
1008: x_error_msg := fnd_message.get;
1009: x_error_code := -1;
1010: return;

Line 1007: fnd_message.set_token('FLD_NAME', 'Organization ID');

1003: l_xst := true;
1004: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1005: if l_xst = false then
1006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1007: fnd_message.set_token('FLD_NAME', 'Organization ID');
1008: x_error_msg := fnd_message.get;
1009: x_error_code := -1;
1010: return;
1011: end if;

Line 1008: x_error_msg := fnd_message.get;

1004: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1005: if l_xst = false then
1006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1007: fnd_message.set_token('FLD_NAME', 'Organization ID');
1008: x_error_msg := fnd_message.get;
1009: x_error_code := -1;
1010: return;
1011: end if;
1012: EXCEPTION

Line 1014: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1010: return;
1011: end if;
1012: EXCEPTION
1013: when others then
1014: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1015: fnd_message.set_token('FLD_NAME', 'Organization ID');
1016: x_error_msg := fnd_message.get;
1017: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1018: x_error_code := -1;

Line 1015: fnd_message.set_token('FLD_NAME', 'Organization ID');

1011: end if;
1012: EXCEPTION
1013: when others then
1014: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1015: fnd_message.set_token('FLD_NAME', 'Organization ID');
1016: x_error_msg := fnd_message.get;
1017: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1018: x_error_code := -1;
1019: END validate_org_id_name;

Line 1016: x_error_msg := fnd_message.get;

1012: EXCEPTION
1013: when others then
1014: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1015: fnd_message.set_token('FLD_NAME', 'Organization ID');
1016: x_error_msg := fnd_message.get;
1017: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1018: x_error_code := -1;
1019: END validate_org_id_name;
1020:

Line 1055: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');

1051:
1052: l_stmt_num := 10;
1053: -- Start : Fix for OPMConv project --
1054: -- if LENGTH(p_job_name) > 30 then
1055: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1056:
1057: if LENGTH(p_job_name) > 80 then
1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1059: fnd_message.set_token('FLD_NAME', 'Job Name');

Line 1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');

1054: -- if LENGTH(p_job_name) > 30 then
1055: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1056:
1057: if LENGTH(p_job_name) > 80 then
1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1059: fnd_message.set_token('FLD_NAME', 'Job Name');
1060: fnd_message.set_token('VALUE', '80');
1061: x_error_msg := fnd_message.get;
1062: x_error_code := -1;

Line 1059: fnd_message.set_token('FLD_NAME', 'Job Name');

1055: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1056:
1057: if LENGTH(p_job_name) > 80 then
1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1059: fnd_message.set_token('FLD_NAME', 'Job Name');
1060: fnd_message.set_token('VALUE', '80');
1061: x_error_msg := fnd_message.get;
1062: x_error_code := -1;
1063: return;

Line 1060: fnd_message.set_token('VALUE', '80');

1056:
1057: if LENGTH(p_job_name) > 80 then
1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1059: fnd_message.set_token('FLD_NAME', 'Job Name');
1060: fnd_message.set_token('VALUE', '80');
1061: x_error_msg := fnd_message.get;
1062: x_error_code := -1;
1063: return;
1064: end if;

Line 1061: x_error_msg := fnd_message.get;

1057: if LENGTH(p_job_name) > 80 then
1058: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1059: fnd_message.set_token('FLD_NAME', 'Job Name');
1060: fnd_message.set_token('VALUE', '80');
1061: x_error_msg := fnd_message.get;
1062: x_error_code := -1;
1063: return;
1064: end if;
1065: -- End : Fix for OPMConv project --

Line 1086: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');

1082: from wip_entities
1083: where wip_entity_name = p_job_name
1084: and organization_id = p_org_id;
1085: if l_temp_num = 1 then
1086: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1087: x_error_msg := fnd_message.get;
1088: x_error_code := -1;
1089: return;
1090: end if;

Line 1087: x_error_msg := fnd_message.get;

1083: where wip_entity_name = p_job_name
1084: and organization_id = p_org_id;
1085: if l_temp_num = 1 then
1086: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1087: x_error_msg := fnd_message.get;
1088: x_error_code := -1;
1089: return;
1090: end if;
1091: exception

Line 1095: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');

1091: exception
1092: when no_data_found then
1093: null;
1094: when others then
1095: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1096: x_error_msg := fnd_message.get;
1097: x_error_code := -1;
1098: return;
1099: end;

Line 1096: x_error_msg := fnd_message.get;

1092: when no_data_found then
1093: null;
1094: when others then
1095: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1096: x_error_msg := fnd_message.get;
1097: x_error_code := -1;
1098: return;
1099: end;
1100: p_wip_entity_id := null; -- Ignore wip_entity_id

Line 1107: fnd_message.set_name('WSM','WSM_NULL_FIELD');

1103:
1104: l_xst := false;
1105: if p_wip_entity_id is null then
1106: if p_job_name is null then
1107: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1108: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');
1109: x_error_msg := fnd_message.get;
1110: x_error_code := -1;
1111: return;

Line 1108: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');

1104: l_xst := false;
1105: if p_wip_entity_id is null then
1106: if p_job_name is null then
1107: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1108: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');
1109: x_error_msg := fnd_message.get;
1110: x_error_code := -1;
1111: return;
1112: end if;

Line 1109: x_error_msg := fnd_message.get;

1105: if p_wip_entity_id is null then
1106: if p_job_name is null then
1107: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1108: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');
1109: x_error_msg := fnd_message.get;
1110: x_error_code := -1;
1111: return;
1112: end if;
1113:

Line 1129: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1125: where wip_entity_name = p_job_name
1126: and organization_id = p_org_id;
1127: exception
1128: when others then
1129: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1130: fnd_message.set_token('FLD_NAME', 'Job_Name');
1131: x_error_msg := fnd_message.get;
1132: x_error_code := -1;
1133: return;

Line 1130: fnd_message.set_token('FLD_NAME', 'Job_Name');

1126: and organization_id = p_org_id;
1127: exception
1128: when others then
1129: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1130: fnd_message.set_token('FLD_NAME', 'Job_Name');
1131: x_error_msg := fnd_message.get;
1132: x_error_code := -1;
1133: return;
1134: end;

Line 1131: x_error_msg := fnd_message.get;

1127: exception
1128: when others then
1129: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1130: fnd_message.set_token('FLD_NAME', 'Job_Name');
1131: x_error_msg := fnd_message.get;
1132: x_error_code := -1;
1133: return;
1134: end;
1135: else

Line 1160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1156: and wdj.wip_entity_id = we.wip_entity_id
1157: and we.organization_id = p_org_id;
1158: exception
1159: when others then
1160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1161: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1162: x_error_msg := fnd_message.get;
1163: x_error_code := -1;
1164: return;

Line 1161: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');

1157: and we.organization_id = p_org_id;
1158: exception
1159: when others then
1160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1161: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1162: x_error_msg := fnd_message.get;
1163: x_error_code := -1;
1164: return;
1165: end;

Line 1162: x_error_msg := fnd_message.get;

1158: exception
1159: when others then
1160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1161: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1162: x_error_msg := fnd_message.get;
1163: x_error_code := -1;
1164: return;
1165: end;
1166:

Line 1180: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');

1176: and organization_id = p_org_id
1177: and wip_entity_id <> p_wip_entity_id;
1178:
1179: if (l_temp_num = 1) then
1180: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1181: x_error_msg := fnd_message.get;
1182: x_error_code := -1;
1183: return;
1184: end if;

Line 1181: x_error_msg := fnd_message.get;

1177: and wip_entity_id <> p_wip_entity_id;
1178:
1179: if (l_temp_num = 1) then
1180: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1181: x_error_msg := fnd_message.get;
1182: x_error_code := -1;
1183: return;
1184: end if;
1185: exception

Line 1187: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1183: return;
1184: end if;
1185: exception
1186: when others then
1187: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1188: fnd_message.set_token('FLD_NAME', 'Job_Name');
1189: x_error_msg := fnd_message.get;
1190: x_error_code := -1;
1191: return;

Line 1188: fnd_message.set_token('FLD_NAME', 'Job_Name');

1184: end if;
1185: exception
1186: when others then
1187: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1188: fnd_message.set_token('FLD_NAME', 'Job_Name');
1189: x_error_msg := fnd_message.get;
1190: x_error_code := -1;
1191: return;
1192: end;

Line 1189: x_error_msg := fnd_message.get;

1185: exception
1186: when others then
1187: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1188: fnd_message.set_token('FLD_NAME', 'Job_Name');
1189: x_error_msg := fnd_message.get;
1190: x_error_code := -1;
1191: return;
1192: end;
1193: end if;

Line 1201: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');

1197: end if;
1198:
1199: -- BA: 3512105
1200: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then
1201: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');
1202: x_error_msg := fnd_message.get;
1203: x_error_code := -1;
1204: return;
1205: end if;

Line 1202: x_error_msg := fnd_message.get;

1198:
1199: -- BA: 3512105
1200: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then
1201: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');
1202: x_error_msg := fnd_message.get;
1203: x_error_code := -1;
1204: return;
1205: end if;
1206: -- BA: 3512105

Line 1213: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1209:
1210:
1211: EXCEPTION
1212: when others then
1213: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1214: fnd_message.set_token('FLD_NAME', 'Wip_Entity_ID/Job_Name');
1215: x_error_msg := fnd_message.get;
1216: x_error_msg := 'validate_wip_entity_id_name (#' || l_stmt_num || ') ' || x_error_msg;
1217: x_error_code := -1;

Line 1214: fnd_message.set_token('FLD_NAME', 'Wip_Entity_ID/Job_Name');

1210:
1211: EXCEPTION
1212: when others then
1213: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1214: fnd_message.set_token('FLD_NAME', 'Wip_Entity_ID/Job_Name');
1215: x_error_msg := fnd_message.get;
1216: x_error_msg := 'validate_wip_entity_id_name (#' || l_stmt_num || ') ' || x_error_msg;
1217: x_error_code := -1;
1218: END validate_wip_entity_id_name;

Line 1215: x_error_msg := fnd_message.get;

1211: EXCEPTION
1212: when others then
1213: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1214: fnd_message.set_token('FLD_NAME', 'Wip_Entity_ID/Job_Name');
1215: x_error_msg := fnd_message.get;
1216: x_error_msg := 'validate_wip_entity_id_name (#' || l_stmt_num || ') ' || x_error_msg;
1217: x_error_code := -1;
1218: END validate_wip_entity_id_name;
1219:

Line 1757: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

1753: if l_sub_type not in (WSM_SUB_DEL, WSM_SUB_ADD, WSM_SUB_CHG,
1754: WSM_SUB_REC, WSM_SUB_DIS)
1755: then
1756: -- get error message
1757: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1758: fnd_message.set_token('FLD_NAME', 'substitution_type');
1759: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1760: || fnd_message.get;
1761: p_error_code := -1;

Line 1758: fnd_message.set_token('FLD_NAME', 'substitution_type');

1754: WSM_SUB_REC, WSM_SUB_DIS)
1755: then
1756: -- get error message
1757: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1758: fnd_message.set_token('FLD_NAME', 'substitution_type');
1759: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1760: || fnd_message.get;
1761: p_error_code := -1;
1762: raise e_wljdi_common_error;

Line 1760: || fnd_message.get;

1756: -- get error message
1757: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1758: fnd_message.set_token('FLD_NAME', 'substitution_type');
1759: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1760: || fnd_message.get;
1761: p_error_code := -1;
1762: raise e_wljdi_common_error;
1763: end if;
1764:

Line 1785: fnd_message.set_name('WSM','WSM_NULL_FIELD');

1781: -- Resource New is not used while deleting resource.
1782: if l_sub_type <> WSM_SUB_DEL then
1783: if( v_wljdi_resource_id_new(l_d) IS NULL) then
1784: if v_wljdi_resource_code_new(l_d) IS NULL then
1785: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1786: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
1787: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1788: || fnd_message.get;
1789: p_error_code := -1;

Line 1786: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');

1782: if l_sub_type <> WSM_SUB_DEL then
1783: if( v_wljdi_resource_id_new(l_d) IS NULL) then
1784: if v_wljdi_resource_code_new(l_d) IS NULL then
1785: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1786: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
1787: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1788: || fnd_message.get;
1789: p_error_code := -1;
1790: raise e_wljdi_common_error;

Line 1788: || fnd_message.get;

1784: if v_wljdi_resource_code_new(l_d) IS NULL then
1785: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1786: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
1787: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1788: || fnd_message.get;
1789: p_error_code := -1;
1790: raise e_wljdi_common_error;
1791: else
1792: -- get resource id from item name

Line 1832: fnd_message.set_name('WSM','WSM_NULL_FIELD');

1828: end;
1829: end if;
1830:
1831: if(v_wljdi_resource_id_new(l_d) IS NULL) then
1832: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1833: fnd_message.set_token('FLD_NAME', 'resource_id_new');
1834: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1835: || fnd_message.get;
1836: p_error_code := -1;

Line 1833: fnd_message.set_token('FLD_NAME', 'resource_id_new');

1829: end if;
1830:
1831: if(v_wljdi_resource_id_new(l_d) IS NULL) then
1832: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1833: fnd_message.set_token('FLD_NAME', 'resource_id_new');
1834: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1835: || fnd_message.get;
1836: p_error_code := -1;
1837: raise e_wljdi_common_error;

Line 1835: || fnd_message.get;

1831: if(v_wljdi_resource_id_new(l_d) IS NULL) then
1832: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1833: fnd_message.set_token('FLD_NAME', 'resource_id_new');
1834: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1835: || fnd_message.get;
1836: p_error_code := -1;
1837: raise e_wljdi_common_error;
1838: end if;
1839: else

Line 1894: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');

1890: /* ST : Detailed Scheduling..... end */
1891: --if(v_wljdi_resource_id_new(l_d) IS NULL or
1892: -- v_wljdi_substitute_group_num(l_d) IS NULL )
1893: --then
1894: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1895: -- fnd_message.set_token('FLD_NAME', 'resource_id_new/substitute_group_num');
1896: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1897: -- || fnd_message.get;
1898: -- p_error_code := -1;

Line 1895: -- fnd_message.set_token('FLD_NAME', 'resource_id_new/substitute_group_num');

1891: --if(v_wljdi_resource_id_new(l_d) IS NULL or
1892: -- v_wljdi_substitute_group_num(l_d) IS NULL )
1893: --then
1894: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1895: -- fnd_message.set_token('FLD_NAME', 'resource_id_new/substitute_group_num');
1896: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1897: -- || fnd_message.get;
1898: -- p_error_code := -1;
1899: -- raise e_wljdi_common_error;

Line 1897: -- || fnd_message.get;

1893: --then
1894: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1895: -- fnd_message.set_token('FLD_NAME', 'resource_id_new/substitute_group_num');
1896: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1897: -- || fnd_message.get;
1898: -- p_error_code := -1;
1899: -- raise e_wljdi_common_error;
1900: --end if;
1901: --Modiified for Alcoa Enhancement

Line 1904: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');

1900: --end if;
1901: --Modiified for Alcoa Enhancement
1902: -- if(v_wljdi_resource_id_new(l_d) IS NULL)
1903: -- then
1904: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1905: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');
1906: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1907: -- || fnd_message.get;
1908: -- p_error_code := -1;

Line 1905: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');

1901: --Modiified for Alcoa Enhancement
1902: -- if(v_wljdi_resource_id_new(l_d) IS NULL)
1903: -- then
1904: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1905: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');
1906: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1907: -- || fnd_message.get;
1908: -- p_error_code := -1;
1909: -- raise e_wljdi_common_error;

Line 1907: -- || fnd_message.get;

1903: -- then
1904: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1905: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');
1906: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1907: -- || fnd_message.get;
1908: -- p_error_code := -1;
1909: -- raise e_wljdi_common_error;
1910: -- end if;
1911:

Line 1966: fnd_message.set_name('WSM','WSM_NULL_FIELD');

1962: -- Added For LBJ Interface Alcoa Enhancement
1963: if l_sub_type = WSM_SUB_DEL then
1964: if(v_wljdi_inventory_item_id_old(l_d) IS NULL) then
1965: if v_wljdi_inventory_item_old(l_d) IS NULL THEN
1966: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1967: fnd_message.set_token('FLD_NAME', 'inventory_item_id_old/inventory_item_old');
1968: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1969: || fnd_message.get;
1970: p_error_code := -1;

Line 1967: fnd_message.set_token('FLD_NAME', 'inventory_item_id_old/inventory_item_old');

1963: if l_sub_type = WSM_SUB_DEL then
1964: if(v_wljdi_inventory_item_id_old(l_d) IS NULL) then
1965: if v_wljdi_inventory_item_old(l_d) IS NULL THEN
1966: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1967: fnd_message.set_token('FLD_NAME', 'inventory_item_id_old/inventory_item_old');
1968: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1969: || fnd_message.get;
1970: p_error_code := -1;
1971: raise e_wljdi_common_error;

Line 1969: || fnd_message.get;

1965: if v_wljdi_inventory_item_old(l_d) IS NULL THEN
1966: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1967: fnd_message.set_token('FLD_NAME', 'inventory_item_id_old/inventory_item_old');
1968: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1969: || fnd_message.get;
1970: p_error_code := -1;
1971: raise e_wljdi_common_error;
1972: else
1973: l_stmt_num := 50;

Line 2004: fnd_message.set_name('WSM','WSM_NULL_FIELD');

2000: -- Modified For LBJ Interface Alcoa Enhancement
2001: if l_sub_type not in (WSM_SUB_DEL) then
2002: if(v_wljdi_inventory_item_id_new(l_d) IS NULL) then
2003: if v_wljdi_inventory_item_new(l_d) IS NULL then
2004: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2005: fnd_message.set_token('FLD_NAME', 'inventory_item_id_new/inventory_item_new');
2006: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2007: || fnd_message.get;
2008: p_error_code := -1;

Line 2005: fnd_message.set_token('FLD_NAME', 'inventory_item_id_new/inventory_item_new');

2001: if l_sub_type not in (WSM_SUB_DEL) then
2002: if(v_wljdi_inventory_item_id_new(l_d) IS NULL) then
2003: if v_wljdi_inventory_item_new(l_d) IS NULL then
2004: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2005: fnd_message.set_token('FLD_NAME', 'inventory_item_id_new/inventory_item_new');
2006: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2007: || fnd_message.get;
2008: p_error_code := -1;
2009: raise e_wljdi_common_error;

Line 2007: || fnd_message.get;

2003: if v_wljdi_inventory_item_new(l_d) IS NULL then
2004: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2005: fnd_message.set_token('FLD_NAME', 'inventory_item_id_new/inventory_item_new');
2006: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2007: || fnd_message.get;
2008: p_error_code := -1;
2009: raise e_wljdi_common_error;
2010: else
2011: l_stmt_num := 50.2;

Line 2049: fnd_message.set_name('WSM','WSM_NULL_FIELD');

2045:
2046: -- check primary_item_id/primary_item
2047: if(v_wljdi_primary_item_id(l_d) IS NULL) then
2048: if v_wljdi_primary_item(l_d) IS NULL then
2049: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2050: fnd_message.set_token('FLD_NAME', 'primary_item_id/primary_item');
2051: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2052: || fnd_message.get;
2053: p_error_code := -1;

Line 2050: fnd_message.set_token('FLD_NAME', 'primary_item_id/primary_item');

2046: -- check primary_item_id/primary_item
2047: if(v_wljdi_primary_item_id(l_d) IS NULL) then
2048: if v_wljdi_primary_item(l_d) IS NULL then
2049: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2050: fnd_message.set_token('FLD_NAME', 'primary_item_id/primary_item');
2051: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2052: || fnd_message.get;
2053: p_error_code := -1;
2054: raise e_wljdi_common_error;

Line 2052: || fnd_message.get;

2048: if v_wljdi_primary_item(l_d) IS NULL then
2049: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2050: fnd_message.set_token('FLD_NAME', 'primary_item_id/primary_item');
2051: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2052: || fnd_message.get;
2053: p_error_code := -1;
2054: raise e_wljdi_common_error;
2055: else
2056: l_stmt_num := 50.3;

Line 2113: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2109: where inventory_item_id = v_wljdi_src_phantom_item_id(l_d)
2110: and organization_id = p_org_id;
2111: exception
2112: when others then
2113: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2114: fnd_message.set_token('FLD_NAME', 'Source_phantom_item_id/Source_phantom_item_name');
2115: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2116: p_error_code := -1;
2117: raise e_wljdi_common_error;

Line 2114: fnd_message.set_token('FLD_NAME', 'Source_phantom_item_id/Source_phantom_item_name');

2110: and organization_id = p_org_id;
2111: exception
2112: when others then
2113: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2114: fnd_message.set_token('FLD_NAME', 'Source_phantom_item_id/Source_phantom_item_name');
2115: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2116: p_error_code := -1;
2117: raise e_wljdi_common_error;
2118: end;

Line 2115: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2111: exception
2112: when others then
2113: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2114: fnd_message.set_token('FLD_NAME', 'Source_phantom_item_id/Source_phantom_item_name');
2115: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2116: p_error_code := -1;
2117: raise e_wljdi_common_error;
2118: end;
2119: end if;

Line 2405: fnd_message.set_name('WSM','WSM_NULL_FIELD');

2401: l_rpl_grp_num := v_wljdi_replacement_group_num(l_d);
2402:
2403: if(l_resource_id IS NULL) then
2404: if v_wljdi_resource_code_new(l_d) IS NULL then
2405: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2406: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
2407: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2408: || fnd_message.get;
2409: p_error_code := -1;

Line 2406: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');

2402:
2403: if(l_resource_id IS NULL) then
2404: if v_wljdi_resource_code_new(l_d) IS NULL then
2405: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2406: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
2407: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2408: || fnd_message.get;
2409: p_error_code := -1;
2410: raise e_wljdi_common_error;

Line 2408: || fnd_message.get;

2404: if v_wljdi_resource_code_new(l_d) IS NULL then
2405: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2406: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
2407: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2408: || fnd_message.get;
2409: p_error_code := -1;
2410: raise e_wljdi_common_error;
2411: else
2412: -- get resource id from item name

Line 2503: fnd_message.set_name('WSM','WSM_NULL_FIELD');

2499: end if;
2500: if(--v_wljdi_routing_op_seq_num(l_d) IS NULL or
2501: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2502: then
2503: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2504: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2505: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2506: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2507: || fnd_message.get;

Line 2504: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');

2500: if(--v_wljdi_routing_op_seq_num(l_d) IS NULL or
2501: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2502: then
2503: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2504: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2505: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2506: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2507: || fnd_message.get;
2508: p_error_code := -1;

Line 2505: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');

2501: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2502: then
2503: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2504: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2505: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2506: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2507: || fnd_message.get;
2508: p_error_code := -1;
2509: raise e_wljdi_common_error;

Line 2507: || fnd_message.get;

2503: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2504: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2505: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2506: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2507: || fnd_message.get;
2508: p_error_code := -1;
2509: raise e_wljdi_common_error;
2510: end if;
2511:

Line 2523: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2519: raise e_invalid_op_seq_num;
2520: end if;
2521:
2522: else
2523: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2524: fnd_message.set_token('FLD_NAME', 'load_type');
2525: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2526: || fnd_message.get;
2527: p_error_code := -1;

Line 2524: fnd_message.set_token('FLD_NAME', 'load_type');

2520: end if;
2521:
2522: else
2523: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2524: fnd_message.set_token('FLD_NAME', 'load_type');
2525: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2526: || fnd_message.get;
2527: p_error_code := -1;
2528: raise e_wljdi_common_error;

Line 2526: || fnd_message.get;

2522: else
2523: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2524: fnd_message.set_token('FLD_NAME', 'load_type');
2525: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2526: || fnd_message.get;
2527: p_error_code := -1;
2528: raise e_wljdi_common_error;
2529: end if;
2530: ---------------------------------------------------------------------------

Line 2619: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2615: where record_id = l_v_record_id(i);
2616:
2617: EXCEPTION
2618: when e_invalid_sub_load_type then
2619: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2620: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
2621: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2622: || fnd_message.get;
2623: p_error_code := -1;

Line 2620: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');

2616:
2617: EXCEPTION
2618: when e_invalid_sub_load_type then
2619: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2620: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
2621: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2622: || fnd_message.get;
2623: p_error_code := -1;
2624: fnd_file.put_line(fnd_file.log, substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2622: || fnd_message.get;

2618: when e_invalid_sub_load_type then
2619: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2620: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
2621: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2622: || fnd_message.get;
2623: p_error_code := -1;
2624: fnd_file.put_line(fnd_file.log, substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2625:
2626: when e_invalid_op_seq_num then

Line 2627: fnd_message.set_name('WSM','WSM_NULL_FIELD');

2623: p_error_code := -1;
2624: fnd_file.put_line(fnd_file.log, substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2625:
2626: when e_invalid_op_seq_num then
2627: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2628: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
2629: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2630: || fnd_message.get;
2631: p_error_code := -1;

Line 2628: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');

2624: fnd_file.put_line(fnd_file.log, substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2625:
2626: when e_invalid_op_seq_num then
2627: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2628: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
2629: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2630: || fnd_message.get;
2631: p_error_code := -1;
2632: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '

Line 2630: || fnd_message.get;

2626: when e_invalid_op_seq_num then
2627: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2628: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
2629: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2630: || fnd_message.get;
2631: p_error_code := -1;
2632: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '
2633: || p_error_msg, 1, 2000));
2634:

Line 2636: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2632: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '
2633: || p_error_msg, 1, 2000));
2634:
2635: when e_invalid_resource_code then
2636: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2637: fnd_message.set_token('FLD_NAME', 'resource_code_new');
2638: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2639: || fnd_message.get;
2640: p_error_code := -1;

Line 2637: fnd_message.set_token('FLD_NAME', 'resource_code_new');

2633: || p_error_msg, 1, 2000));
2634:
2635: when e_invalid_resource_code then
2636: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2637: fnd_message.set_token('FLD_NAME', 'resource_code_new');
2638: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2639: || fnd_message.get;
2640: p_error_code := -1;
2641: fnd_file.put_line(fnd_file.log,

Line 2639: || fnd_message.get;

2635: when e_invalid_resource_code then
2636: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2637: fnd_message.set_token('FLD_NAME', 'resource_code_new');
2638: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2639: || fnd_message.get;
2640: p_error_code := -1;
2641: fnd_file.put_line(fnd_file.log,
2642: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2643: || p_error_msg, 1, 2000));

Line 2648: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2644:
2645: /* ST : Detailed Scheduling start */
2646:
2647: when e_invalid_resource_id then
2648: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2649: fnd_message.set_token('FLD_NAME', 'resource_id_new');
2650: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2651: || fnd_message.get;
2652: p_error_code := -1;

Line 2649: fnd_message.set_token('FLD_NAME', 'resource_id_new');

2645: /* ST : Detailed Scheduling start */
2646:
2647: when e_invalid_resource_id then
2648: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2649: fnd_message.set_token('FLD_NAME', 'resource_id_new');
2650: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2651: || fnd_message.get;
2652: p_error_code := -1;
2653: fnd_file.put_line(fnd_file.log,

Line 2651: || fnd_message.get;

2647: when e_invalid_resource_id then
2648: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2649: fnd_message.set_token('FLD_NAME', 'resource_id_new');
2650: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2651: || fnd_message.get;
2652: p_error_code := -1;
2653: fnd_file.put_line(fnd_file.log,
2654: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2655: || p_error_msg, 1, 2000));

Line 2658: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2654: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2655: || p_error_msg, 1, 2000));
2656:
2657: when e_invalid_dept_code then
2658: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2659: fnd_message.set_token('FLD_NAME', 'department_code/department id combination');
2660: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2661: || fnd_message.get;
2662: p_error_code := -1;

Line 2659: fnd_message.set_token('FLD_NAME', 'department_code/department id combination');

2655: || p_error_msg, 1, 2000));
2656:
2657: when e_invalid_dept_code then
2658: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2659: fnd_message.set_token('FLD_NAME', 'department_code/department id combination');
2660: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2661: || fnd_message.get;
2662: p_error_code := -1;
2663: fnd_file.put_line(fnd_file.log,

Line 2661: || fnd_message.get;

2657: when e_invalid_dept_code then
2658: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2659: fnd_message.set_token('FLD_NAME', 'department_code/department id combination');
2660: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2661: || fnd_message.get;
2662: p_error_code := -1;
2663: fnd_file.put_line(fnd_file.log,
2664: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2665: || p_error_msg, 1, 2000));

Line 2670: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2666:
2667: /* ST : Detailed Scheduling end */
2668:
2669: when e_invalid_item_name then
2670: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2671: fnd_message.set_token('FLD_NAME', 'item_id');
2672: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2673: || fnd_message.get;
2674: p_error_code := -1;

Line 2671: fnd_message.set_token('FLD_NAME', 'item_id');

2667: /* ST : Detailed Scheduling end */
2668:
2669: when e_invalid_item_name then
2670: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2671: fnd_message.set_token('FLD_NAME', 'item_id');
2672: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2673: || fnd_message.get;
2674: p_error_code := -1;
2675: fnd_file.put_line(fnd_file.log,

Line 2673: || fnd_message.get;

2669: when e_invalid_item_name then
2670: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2671: fnd_message.set_token('FLD_NAME', 'item_id');
2672: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2673: || fnd_message.get;
2674: p_error_code := -1;
2675: fnd_file.put_line(fnd_file.log,
2676: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2677: || p_error_msg, 1, 2000));

Line 2693: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2689: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2690: || p_error_msg, 1, 2000));
2691:
2692: when e_invalid_setup_code then
2693: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2694: fnd_message.set_token('FLD_NAME', 'Setup Code ');
2695: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2696: || fnd_message.get;
2697: p_error_code := -1;

Line 2694: fnd_message.set_token('FLD_NAME', 'Setup Code ');

2690: || p_error_msg, 1, 2000));
2691:
2692: when e_invalid_setup_code then
2693: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2694: fnd_message.set_token('FLD_NAME', 'Setup Code ');
2695: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2696: || fnd_message.get;
2697: p_error_code := -1;
2698: fnd_file.put_line(fnd_file.log,

Line 2696: || fnd_message.get;

2692: when e_invalid_setup_code then
2693: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2694: fnd_message.set_token('FLD_NAME', 'Setup Code ');
2695: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2696: || fnd_message.get;
2697: p_error_code := -1;
2698: fnd_file.put_line(fnd_file.log,
2699: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2700: || p_error_msg, 1, 2000));

Line 2705: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2701:
2702: ---Added for LBJ Enhancement
2703:
2704: when e_res_seq_num_exist then
2705: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2706: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2707: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2708: || fnd_message.get;
2709: p_error_code := -1;

Line 2706: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');

2702: ---Added for LBJ Enhancement
2703:
2704: when e_res_seq_num_exist then
2705: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2706: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2707: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2708: || fnd_message.get;
2709: p_error_code := -1;
2710: fnd_file.put_line(fnd_file.log,

Line 2708: || fnd_message.get;

2704: when e_res_seq_num_exist then
2705: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2706: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2707: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2708: || fnd_message.get;
2709: p_error_code := -1;
2710: fnd_file.put_line(fnd_file.log,
2711: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2712: || p_error_msg, 1, 2000));

Line 2715: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2711: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2712: || p_error_msg, 1, 2000));
2713:
2714: when e_invalid_res_seq_num then
2715: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2716: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2717: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2718: || fnd_message.get;
2719: p_error_code := -1;

Line 2716: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');

2712: || p_error_msg, 1, 2000));
2713:
2714: when e_invalid_res_seq_num then
2715: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2716: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2717: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2718: || fnd_message.get;
2719: p_error_code := -1;
2720: fnd_file.put_line(fnd_file.log,

Line 2718: || fnd_message.get;

2714: when e_invalid_res_seq_num then
2715: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2716: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2717: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2718: || fnd_message.get;
2719: p_error_code := -1;
2720: fnd_file.put_line(fnd_file.log,
2721: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2722: || p_error_msg, 1, 2000));

Line 2724: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2720: fnd_file.put_line(fnd_file.log,
2721: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2722: || p_error_msg, 1, 2000));
2723: when e_inv_std_op then
2724: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2725: fnd_message.set_token('FLD_NAME', 'standard_operation_id/standard_operation_code combination');
2726: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2727: p_error_code := -1;
2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2725: fnd_message.set_token('FLD_NAME', 'standard_operation_id/standard_operation_code combination');

2721: substr('default_wljdi_fields: (#'||l_stmt_num||') '
2722: || p_error_msg, 1, 2000));
2723: when e_inv_std_op then
2724: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2725: fnd_message.set_token('FLD_NAME', 'standard_operation_id/standard_operation_code combination');
2726: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2727: p_error_code := -1;
2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2729: when e_invalid_min_trf_qty then

Line 2726: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2722: || p_error_msg, 1, 2000));
2723: when e_inv_std_op then
2724: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2725: fnd_message.set_token('FLD_NAME', 'standard_operation_id/standard_operation_code combination');
2726: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2727: p_error_code := -1;
2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2729: when e_invalid_min_trf_qty then
2730: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 2730: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2726: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2727: p_error_code := -1;
2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2729: when e_invalid_min_trf_qty then
2730: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2731: fnd_message.set_token('FLD_NAME', 'minimum_transfer_quantity');
2732: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2733: p_error_code := -1;
2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2731: fnd_message.set_token('FLD_NAME', 'minimum_transfer_quantity');

2727: p_error_code := -1;
2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2729: when e_invalid_min_trf_qty then
2730: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2731: fnd_message.set_token('FLD_NAME', 'minimum_transfer_quantity');
2732: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2733: p_error_code := -1;
2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2735: when e_invalid_count_point then

Line 2732: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2728: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2729: when e_invalid_min_trf_qty then
2730: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2731: fnd_message.set_token('FLD_NAME', 'minimum_transfer_quantity');
2732: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2733: p_error_code := -1;
2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2735: when e_invalid_count_point then
2736: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 2736: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2732: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2733: p_error_code := -1;
2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2735: when e_invalid_count_point then
2736: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2737: fnd_message.set_token('FLD_NAME', 'count_point_type');
2738: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2739: p_error_code := -1;
2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2737: fnd_message.set_token('FLD_NAME', 'count_point_type');

2733: p_error_code := -1;
2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2735: when e_invalid_count_point then
2736: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2737: fnd_message.set_token('FLD_NAME', 'count_point_type');
2738: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2739: p_error_code := -1;
2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2741: when e_invalid_backflush_flag then

Line 2738: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2734: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2735: when e_invalid_count_point then
2736: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2737: fnd_message.set_token('FLD_NAME', 'count_point_type');
2738: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2739: p_error_code := -1;
2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2741: when e_invalid_backflush_flag then
2742: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 2742: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2738: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2739: p_error_code := -1;
2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2741: when e_invalid_backflush_flag then
2742: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2743: fnd_message.set_token('FLD_NAME', 'backflush_flag');
2744: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2745: p_error_code := -1;
2746: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2743: fnd_message.set_token('FLD_NAME', 'backflush_flag');

2739: p_error_code := -1;
2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2741: when e_invalid_backflush_flag then
2742: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2743: fnd_message.set_token('FLD_NAME', 'backflush_flag');
2744: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2745: p_error_code := -1;
2746: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2747: when e_dup_op_seq then

Line 2744: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2740: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2741: when e_invalid_backflush_flag then
2742: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2743: fnd_message.set_token('FLD_NAME', 'backflush_flag');
2744: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2745: p_error_code := -1;
2746: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2747: when e_dup_op_seq then
2748: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');

Line 2748: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');

2744: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2745: p_error_code := -1;
2746: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2747: when e_dup_op_seq then
2748: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');
2749: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2750: p_error_code := -1;
2751: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2752: when e_invalid_op_date then

Line 2749: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2745: p_error_code := -1;
2746: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2747: when e_dup_op_seq then
2748: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');
2749: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2750: p_error_code := -1;
2751: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2752: when e_invalid_op_date then
2753: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

Line 2753: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

2749: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2750: p_error_code := -1;
2751: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2752: when e_invalid_op_date then
2753: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
2754: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2755: p_error_code := -1;
2756: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2757: when e_invalid_routing_op_seq then

Line 2754: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2750: p_error_code := -1;
2751: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2752: when e_invalid_op_date then
2753: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
2754: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2755: p_error_code := -1;
2756: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2757: when e_invalid_routing_op_seq then
2758: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 2758: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2754: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2755: p_error_code := -1;
2756: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2757: when e_invalid_routing_op_seq then
2758: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2759: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
2760: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2761: p_error_code := -1;
2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2759: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');

2755: p_error_code := -1;
2756: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2757: when e_invalid_routing_op_seq then
2758: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2759: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
2760: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2761: p_error_code := -1;
2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2763: when e_invalid_job_op_seq then

Line 2760: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2756: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2757: when e_invalid_routing_op_seq then
2758: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2759: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
2760: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2761: p_error_code := -1;
2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2763: when e_invalid_job_op_seq then
2764: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 2764: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

2760: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2761: p_error_code := -1;
2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2763: when e_invalid_job_op_seq then
2764: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2765: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num');
2766: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2767: p_error_code := -1;
2768: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));

Line 2765: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num');

2761: p_error_code := -1;
2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2763: when e_invalid_job_op_seq then
2764: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2765: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num');
2766: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2767: p_error_code := -1;
2768: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2769:

Line 2766: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;

2762: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2763: when e_invalid_job_op_seq then
2764: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2765: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num');
2766: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2767: p_error_code := -1;
2768: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2769:
2770: when others then

Line 2842: fnd_message.set_name('WSM','WSM_INVALID_EXTRA_LINKS');

2838: end loop;
2839:
2840: if(l_cnt <> p_links.COUNT) then
2841: x_error_code := -1;
2842: fnd_message.set_name('WSM','WSM_INVALID_EXTRA_LINKS');
2843: x_error_msg := fnd_message.get;
2844: end if;
2845:
2846: EXCEPTION

Line 2843: x_error_msg := fnd_message.get;

2839:
2840: if(l_cnt <> p_links.COUNT) then
2841: x_error_code := -1;
2842: fnd_message.set_name('WSM','WSM_INVALID_EXTRA_LINKS');
2843: x_error_msg := fnd_message.get;
2844: end if;
2845:
2846: EXCEPTION
2847: when e_invalid_path_end then

Line 2849: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');

2845:
2846: EXCEPTION
2847: when e_invalid_path_end then
2848: x_error_code := -1;
2849: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2850: fnd_message.set_token('END',p_end_op_seq_num);
2851: x_error_msg := fnd_message.get;
2852:
2853: when e_invalid_link then

Line 2850: fnd_message.set_token('END',p_end_op_seq_num);

2846: EXCEPTION
2847: when e_invalid_path_end then
2848: x_error_code := -1;
2849: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2850: fnd_message.set_token('END',p_end_op_seq_num);
2851: x_error_msg := fnd_message.get;
2852:
2853: when e_invalid_link then
2854: x_error_code := -1;

Line 2851: x_error_msg := fnd_message.get;

2847: when e_invalid_path_end then
2848: x_error_code := -1;
2849: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2850: fnd_message.set_token('END',p_end_op_seq_num);
2851: x_error_msg := fnd_message.get;
2852:
2853: when e_invalid_link then
2854: x_error_code := -1;
2855: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');

Line 2855: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');

2851: x_error_msg := fnd_message.get;
2852:
2853: when e_invalid_link then
2854: x_error_code := -1;
2855: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
2856: x_error_msg := fnd_message.get;
2857:
2858: when others then
2859: x_error_code := -1;

Line 2856: x_error_msg := fnd_message.get;

2852:
2853: when e_invalid_link then
2854: x_error_code := -1;
2855: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
2856: x_error_msg := fnd_message.get;
2857:
2858: when others then
2859: x_error_code := -1;
2860: x_error_msg := 'Error: validate_wljdi_path: (#'|| l_stmt_num||') '

Line 3050: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

3046:
3047: EXCEPTION
3048: when e_invalid_operation then
3049: x_error_code := -1;
3050: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
3051: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');
3052: x_error_msg := fnd_message.get;
3053:
3054: when e_invalid_op_yield then

Line 3051: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');

3047: EXCEPTION
3048: when e_invalid_operation then
3049: x_error_code := -1;
3050: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
3051: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');
3052: x_error_msg := fnd_message.get;
3053:
3054: when e_invalid_op_yield then
3055: x_error_code := -1;

Line 3052: x_error_msg := fnd_message.get;

3048: when e_invalid_operation then
3049: x_error_code := -1;
3050: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
3051: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');
3052: x_error_msg := fnd_message.get;
3053:
3054: when e_invalid_op_yield then
3055: x_error_code := -1;
3056: fnd_message.set_name('WSM','WSM_OP_BAD_YIELD');

Line 3056: fnd_message.set_name('WSM','WSM_OP_BAD_YIELD');

3052: x_error_msg := fnd_message.get;
3053:
3054: when e_invalid_op_yield then
3055: x_error_code := -1;
3056: fnd_message.set_name('WSM','WSM_OP_BAD_YIELD');
3057: x_error_msg := fnd_message.get;
3058:
3059: when e_invalid_sche_qty then
3060: x_error_code := -1;

Line 3057: x_error_msg := fnd_message.get;

3053:
3054: when e_invalid_op_yield then
3055: x_error_code := -1;
3056: fnd_message.set_name('WSM','WSM_OP_BAD_YIELD');
3057: x_error_msg := fnd_message.get;
3058:
3059: when e_invalid_sche_qty then
3060: x_error_code := -1;
3061: fnd_message.set_name('WSM','WSM_OP_BAD_SCHQTY');

Line 3061: fnd_message.set_name('WSM','WSM_OP_BAD_SCHQTY');

3057: x_error_msg := fnd_message.get;
3058:
3059: when e_invalid_sche_qty then
3060: x_error_code := -1;
3061: fnd_message.set_name('WSM','WSM_OP_BAD_SCHQTY');
3062: x_error_msg := fnd_message.get;
3063:
3064: when e_sche_qty_not_upd then
3065: x_error_code := -1;

Line 3062: x_error_msg := fnd_message.get;

3058:
3059: when e_invalid_sche_qty then
3060: x_error_code := -1;
3061: fnd_message.set_name('WSM','WSM_OP_BAD_SCHQTY');
3062: x_error_msg := fnd_message.get;
3063:
3064: when e_sche_qty_not_upd then
3065: x_error_code := -1;
3066: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');

Line 3066: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');

3062: x_error_msg := fnd_message.get;
3063:
3064: when e_sche_qty_not_upd then
3065: x_error_code := -1;
3066: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');
3067: x_error_msg := fnd_message.get;
3068:
3069: when e_invalid_date then
3070: x_error_code := -1;

Line 3067: x_error_msg := fnd_message.get;

3063:
3064: when e_sche_qty_not_upd then
3065: x_error_code := -1;
3066: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');
3067: x_error_msg := fnd_message.get;
3068:
3069: when e_invalid_date then
3070: x_error_code := -1;
3071: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

Line 3071: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

3067: x_error_msg := fnd_message.get;
3068:
3069: when e_invalid_date then
3070: x_error_code := -1;
3071: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
3072: x_error_msg := fnd_message.get;
3073:
3074: /*Added for bugfix:7248992 */
3075: when e_invalid_cum_yield then

Line 3072: x_error_msg := fnd_message.get;

3068:
3069: when e_invalid_date then
3070: x_error_code := -1;
3071: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
3072: x_error_msg := fnd_message.get;
3073:
3074: /*Added for bugfix:7248992 */
3075: when e_invalid_cum_yield then
3076: x_error_code := -1;

Line 3077: fnd_message.set_name('WSM','WSM_OP_BAD_CUM_YIELD');

3073:
3074: /*Added for bugfix:7248992 */
3075: when e_invalid_cum_yield then
3076: x_error_code := -1;
3077: fnd_message.set_name('WSM','WSM_OP_BAD_CUM_YIELD');
3078: x_error_msg := fnd_message.get;
3079:
3080: /*Added for bugfix:7248992 */
3081: when e_invalid_rev_cum_yield then

Line 3078: x_error_msg := fnd_message.get;

3074: /*Added for bugfix:7248992 */
3075: when e_invalid_cum_yield then
3076: x_error_code := -1;
3077: fnd_message.set_name('WSM','WSM_OP_BAD_CUM_YIELD');
3078: x_error_msg := fnd_message.get;
3079:
3080: /*Added for bugfix:7248992 */
3081: when e_invalid_rev_cum_yield then
3082: x_error_code := -1;

Line 3083: fnd_message.set_name('WSM','WSM_OP_BAD_REV_CUM_YIELD');

3079:
3080: /*Added for bugfix:7248992 */
3081: when e_invalid_rev_cum_yield then
3082: x_error_code := -1;
3083: fnd_message.set_name('WSM','WSM_OP_BAD_REV_CUM_YIELD');
3084: x_error_msg := fnd_message.get;
3085:
3086: when others then
3087: x_error_code := -1;

Line 3084: x_error_msg := fnd_message.get;

3080: /*Added for bugfix:7248992 */
3081: when e_invalid_rev_cum_yield then
3082: x_error_code := -1;
3083: fnd_message.set_name('WSM','WSM_OP_BAD_REV_CUM_YIELD');
3084: x_error_msg := fnd_message.get;
3085:
3086: when others then
3087: x_error_code := -1;
3088: x_error_msg := 'Error: validate_wljdi_operation: (#'||l_stmt_num||') '

Line 4224: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');

4220:
4221: EXCEPTION
4222: when e_invalid_resource then
4223: x_error_code := -1;
4224: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
4225: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4226: fnd_file.put_line(fnd_file.log,x_error_msg );
4227:
4228: when e_invalid_rpl_grp then

Line 4225: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4221: EXCEPTION
4222: when e_invalid_resource then
4223: x_error_code := -1;
4224: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
4225: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4226: fnd_file.put_line(fnd_file.log,x_error_msg );
4227:
4228: when e_invalid_rpl_grp then
4229: x_error_code := -1;

Line 4230: fnd_message.set_name('WSM','WSM_RES_PARTIAL_RPLGRP');

4226: fnd_file.put_line(fnd_file.log,x_error_msg );
4227:
4228: when e_invalid_rpl_grp then
4229: x_error_code := -1;
4230: fnd_message.set_name('WSM','WSM_RES_PARTIAL_RPLGRP');
4231: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4232: fnd_file.put_line(fnd_file.log,x_error_msg );
4233:
4234: when e_invalid_date then

Line 4231: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4227:
4228: when e_invalid_rpl_grp then
4229: x_error_code := -1;
4230: fnd_message.set_name('WSM','WSM_RES_PARTIAL_RPLGRP');
4231: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4232: fnd_file.put_line(fnd_file.log,x_error_msg );
4233:
4234: when e_invalid_date then
4235: x_error_code := -1;

Line 4236: fnd_message.set_name('WSM','WSM_RES_BAD_DATES');

4232: fnd_file.put_line(fnd_file.log,x_error_msg );
4233:
4234: when e_invalid_date then
4235: x_error_code := -1;
4236: fnd_message.set_name('WSM','WSM_RES_BAD_DATES');
4237: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4238: fnd_file.put_line(fnd_file.log,x_error_msg );
4239:
4240: /* ST : Detailed Scheduling start */

Line 4237: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4233:
4234: when e_invalid_date then
4235: x_error_code := -1;
4236: fnd_message.set_name('WSM','WSM_RES_BAD_DATES');
4237: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4238: fnd_file.put_line(fnd_file.log,x_error_msg );
4239:
4240: /* ST : Detailed Scheduling start */
4241: when e_invalid_max_assg_units then

Line 4243: fnd_message.set_name('WSM','WSM_INVALID_MAX_ASSG');

4239:
4240: /* ST : Detailed Scheduling start */
4241: when e_invalid_max_assg_units then
4242: x_error_code := -1;
4243: fnd_message.set_name('WSM','WSM_INVALID_MAX_ASSG');
4244: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4245: fnd_file.put_line(fnd_file.log,x_error_msg );
4246:
4247: when e_invalid_setup_max_assg_units then

Line 4244: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4240: /* ST : Detailed Scheduling start */
4241: when e_invalid_max_assg_units then
4242: x_error_code := -1;
4243: fnd_message.set_name('WSM','WSM_INVALID_MAX_ASSG');
4244: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4245: fnd_file.put_line(fnd_file.log,x_error_msg );
4246:
4247: when e_invalid_setup_max_assg_units then
4248: x_error_code := -1;

Line 4249: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');

4245: fnd_file.put_line(fnd_file.log,x_error_msg );
4246:
4247: when e_invalid_setup_max_assg_units then
4248: x_error_code := -1;
4249: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
4250: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4251: fnd_file.put_line(fnd_file.log,x_error_msg );
4252:
4253: when e_invalid_seq then

Line 4250: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4246:
4247: when e_invalid_setup_max_assg_units then
4248: x_error_code := -1;
4249: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
4250: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4251: fnd_file.put_line(fnd_file.log,x_error_msg );
4252:
4253: when e_invalid_seq then
4254: x_error_code := -1;

Line 4255: fnd_message.set_name('WSM','WSM_INVALID_SEQ'); /* group seq nyum and group seq id... */

4251: fnd_file.put_line(fnd_file.log,x_error_msg );
4252:
4253: when e_invalid_seq then
4254: x_error_code := -1;
4255: fnd_message.set_name('WSM','WSM_INVALID_SEQ'); /* group seq nyum and group seq id... */
4256: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4257: fnd_file.put_line(fnd_file.log,x_error_msg );
4258:
4259: when e_invalid_batch_max_assg_units then

Line 4256: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4252:
4253: when e_invalid_seq then
4254: x_error_code := -1;
4255: fnd_message.set_name('WSM','WSM_INVALID_SEQ'); /* group seq nyum and group seq id... */
4256: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4257: fnd_file.put_line(fnd_file.log,x_error_msg );
4258:
4259: when e_invalid_batch_max_assg_units then
4260: x_error_code := -1;

Line 4261: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');

4257: fnd_file.put_line(fnd_file.log,x_error_msg );
4258:
4259: when e_invalid_batch_max_assg_units then
4260: x_error_code := -1;
4261: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
4262: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4263: fnd_file.put_line(fnd_file.log,x_error_msg );
4264:
4265: when e_invalid_setup_id then

Line 4262: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4258:
4259: when e_invalid_batch_max_assg_units then
4260: x_error_code := -1;
4261: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
4262: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4263: fnd_file.put_line(fnd_file.log,x_error_msg );
4264:
4265: when e_invalid_setup_id then
4266: x_error_code := -1;

Line 4267: --fnd_message.set_name('WSM','WSM_INVALID_SETUP');

4263: fnd_file.put_line(fnd_file.log,x_error_msg );
4264:
4265: when e_invalid_setup_id then
4266: x_error_code := -1;
4267: --fnd_message.set_name('WSM','WSM_INVALID_SETUP');
4268: fnd_message.set_name('WSM','WSM_INVALID_FIELD'); /*Bug 5488082*/
4269: fnd_message.set_token('FLD_NAME', ' setup_id ');
4270: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4271: fnd_file.put_line(fnd_file.log,x_error_msg );

Line 4268: fnd_message.set_name('WSM','WSM_INVALID_FIELD'); /*Bug 5488082*/

4264:
4265: when e_invalid_setup_id then
4266: x_error_code := -1;
4267: --fnd_message.set_name('WSM','WSM_INVALID_SETUP');
4268: fnd_message.set_name('WSM','WSM_INVALID_FIELD'); /*Bug 5488082*/
4269: fnd_message.set_token('FLD_NAME', ' setup_id ');
4270: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4271: fnd_file.put_line(fnd_file.log,x_error_msg );
4272:

Line 4269: fnd_message.set_token('FLD_NAME', ' setup_id ');

4265: when e_invalid_setup_id then
4266: x_error_code := -1;
4267: --fnd_message.set_name('WSM','WSM_INVALID_SETUP');
4268: fnd_message.set_name('WSM','WSM_INVALID_FIELD'); /*Bug 5488082*/
4269: fnd_message.set_token('FLD_NAME', ' setup_id ');
4270: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4271: fnd_file.put_line(fnd_file.log,x_error_msg );
4272:
4273: when e_invalid_firm_type then

Line 4270: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4266: x_error_code := -1;
4267: --fnd_message.set_name('WSM','WSM_INVALID_SETUP');
4268: fnd_message.set_name('WSM','WSM_INVALID_FIELD'); /*Bug 5488082*/
4269: fnd_message.set_token('FLD_NAME', ' setup_id ');
4270: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4271: fnd_file.put_line(fnd_file.log,x_error_msg );
4272:
4273: when e_invalid_firm_type then
4274: x_error_code := -1;

Line 4276: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4272:
4273: when e_invalid_firm_type then
4274: x_error_code := -1;
4275: /* add the error message..... */
4276: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4277: fnd_message.set_token('FLD_NAME', ' firm type ');
4278: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4279: fnd_file.put_line(fnd_file.log,x_error_msg );
4280:

Line 4277: fnd_message.set_token('FLD_NAME', ' firm type ');

4273: when e_invalid_firm_type then
4274: x_error_code := -1;
4275: /* add the error message..... */
4276: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4277: fnd_message.set_token('FLD_NAME', ' firm type ');
4278: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4279: fnd_file.put_line(fnd_file.log,x_error_msg );
4280:
4281: when e_res_not_batchable then

Line 4278: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4274: x_error_code := -1;
4275: /* add the error message..... */
4276: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4277: fnd_message.set_token('FLD_NAME', ' firm type ');
4278: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4279: fnd_file.put_line(fnd_file.log,x_error_msg );
4280:
4281: when e_res_not_batchable then
4282: x_error_code := -1;

Line 4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4279: fnd_file.put_line(fnd_file.log,x_error_msg );
4280:
4281: when e_res_not_batchable then
4282: x_error_code := -1;
4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');
4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */
4286: --x_error_msg := fnd_message.get;
4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

Line 4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');

4280:
4281: when e_res_not_batchable then
4282: x_error_code := -1;
4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');
4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */
4286: --x_error_msg := fnd_message.get;
4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4288: fnd_file.put_line(fnd_file.log,x_error_msg );

Line 4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */

4281: when e_res_not_batchable then
4282: x_error_code := -1;
4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');
4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */
4286: --x_error_msg := fnd_message.get;
4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4288: fnd_file.put_line(fnd_file.log,x_error_msg );
4289:

Line 4286: --x_error_msg := fnd_message.get;

4282: x_error_code := -1;
4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');
4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */
4286: --x_error_msg := fnd_message.get;
4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4288: fnd_file.put_line(fnd_file.log,x_error_msg );
4289:
4290: when e_invalid_setup_code then

Line 4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4283: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4284: --fnd_message.set_token('FLD_NAME', ' batch id for resource');
4285: fnd_message.set_token('FLD_NAME', ' batch_id'); /*Bug 5487540 */
4286: --x_error_msg := fnd_message.get;
4287: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4288: fnd_file.put_line(fnd_file.log,x_error_msg );
4289:
4290: when e_invalid_setup_code then
4291: x_error_code := -1;

Line 4293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4289:
4290: when e_invalid_setup_code then
4291: x_error_code := -1;
4292: /* add the error message..... */
4293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4294: fnd_message.set_token('FLD_NAME', 'Setup Code ');
4295: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4296: fnd_file.put_line(fnd_file.log,x_error_msg );
4297:

Line 4294: fnd_message.set_token('FLD_NAME', 'Setup Code ');

4290: when e_invalid_setup_code then
4291: x_error_code := -1;
4292: /* add the error message..... */
4293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4294: fnd_message.set_token('FLD_NAME', 'Setup Code ');
4295: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4296: fnd_file.put_line(fnd_file.log,x_error_msg );
4297:
4298: /* ST : Detailed Scheduling end */

Line 4295: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4291: x_error_code := -1;
4292: /* add the error message..... */
4293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4294: fnd_message.set_token('FLD_NAME', 'Setup Code ');
4295: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4296: fnd_file.put_line(fnd_file.log,x_error_msg );
4297:
4298: /* ST : Detailed Scheduling end */
4299:

Line 4303: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4299:
4300: --Alcoa Enhancements Changes
4301: when e_res_id_null THEN
4302: x_error_code := -1;
4303: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4304: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');
4305: x_error_msg := fnd_message.get;
4306:
4307: when e_assgnd_units_null then

Line 4304: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');

4300: --Alcoa Enhancements Changes
4301: when e_res_id_null THEN
4302: x_error_code := -1;
4303: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4304: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');
4305: x_error_msg := fnd_message.get;
4306:
4307: when e_assgnd_units_null then
4308: x_error_code := -1;

Line 4305: x_error_msg := fnd_message.get;

4301: when e_res_id_null THEN
4302: x_error_code := -1;
4303: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4304: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');
4305: x_error_msg := fnd_message.get;
4306:
4307: when e_assgnd_units_null then
4308: x_error_code := -1;
4309: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 4309: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4305: x_error_msg := fnd_message.get;
4306:
4307: when e_assgnd_units_null then
4308: x_error_code := -1;
4309: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4310: fnd_message.set_token('FLD_NAME', 'Assigned_units');
4311: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4312: fnd_file.put_line(fnd_file.log,x_error_msg );
4313:

Line 4310: fnd_message.set_token('FLD_NAME', 'Assigned_units');

4306:
4307: when e_assgnd_units_null then
4308: x_error_code := -1;
4309: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4310: fnd_message.set_token('FLD_NAME', 'Assigned_units');
4311: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4312: fnd_file.put_line(fnd_file.log,x_error_msg );
4313:
4314: when e_inv_appl_res_units THEN

Line 4311: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4307: when e_assgnd_units_null then
4308: x_error_code := -1;
4309: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4310: fnd_message.set_token('FLD_NAME', 'Assigned_units');
4311: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4312: fnd_file.put_line(fnd_file.log,x_error_msg );
4313:
4314: when e_inv_appl_res_units THEN
4315: x_error_code := -1;

Line 4316: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4312: fnd_file.put_line(fnd_file.log,x_error_msg );
4313:
4314: when e_inv_appl_res_units THEN
4315: x_error_code := -1;
4316: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4317: fnd_message.set_token('FLD_NAME', 'Applied_units');
4318: x_error_msg := fnd_message.get;
4319:
4320: when e_wt_or_wcit_rec_exists THEN

Line 4317: fnd_message.set_token('FLD_NAME', 'Applied_units');

4313:
4314: when e_inv_appl_res_units THEN
4315: x_error_code := -1;
4316: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4317: fnd_message.set_token('FLD_NAME', 'Applied_units');
4318: x_error_msg := fnd_message.get;
4319:
4320: when e_wt_or_wcit_rec_exists THEN
4321: x_error_code := -1;

Line 4318: x_error_msg := fnd_message.get;

4314: when e_inv_appl_res_units THEN
4315: x_error_code := -1;
4316: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4317: fnd_message.set_token('FLD_NAME', 'Applied_units');
4318: x_error_msg := fnd_message.get;
4319:
4320: when e_wt_or_wcit_rec_exists THEN
4321: x_error_code := -1;
4322: fnd_message.set_name('WSM','WSM_WT_OR_WCIT_REC_EXIS');

Line 4322: fnd_message.set_name('WSM','WSM_WT_OR_WCIT_REC_EXIS');

4318: x_error_msg := fnd_message.get;
4319:
4320: when e_wt_or_wcit_rec_exists THEN
4321: x_error_code := -1;
4322: fnd_message.set_name('WSM','WSM_WT_OR_WCIT_REC_EXIS');
4323: x_error_msg := fnd_message.get;
4324:
4325: when e_po_req_rec_exists THEN
4326: x_error_code := -1;

Line 4323: x_error_msg := fnd_message.get;

4319:
4320: when e_wt_or_wcit_rec_exists THEN
4321: x_error_code := -1;
4322: fnd_message.set_name('WSM','WSM_WT_OR_WCIT_REC_EXIS');
4323: x_error_msg := fnd_message.get;
4324:
4325: when e_po_req_rec_exists THEN
4326: x_error_code := -1;
4327: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');

Line 4327: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');

4323: x_error_msg := fnd_message.get;
4324:
4325: when e_po_req_rec_exists THEN
4326: x_error_code := -1;
4327: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');
4328: x_error_msg := fnd_message.get;
4329:
4330: when e_invalid_res_sub_grp_num then
4331: x_error_code := -1;

Line 4328: x_error_msg := fnd_message.get;

4324:
4325: when e_po_req_rec_exists THEN
4326: x_error_code := -1;
4327: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');
4328: x_error_msg := fnd_message.get;
4329:
4330: when e_invalid_res_sub_grp_num then
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 4332: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4328: x_error_msg := fnd_message.get;
4329:
4330: when e_invalid_res_sub_grp_num then
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4333: fnd_message.set_token('FLD_NAME', 'substitution_group_num');
4334: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4335: fnd_file.put_line(fnd_file.log,x_error_msg );
4336:

Line 4333: fnd_message.set_token('FLD_NAME', 'substitution_group_num');

4329:
4330: when e_invalid_res_sub_grp_num then
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4333: fnd_message.set_token('FLD_NAME', 'substitution_group_num');
4334: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4335: fnd_file.put_line(fnd_file.log,x_error_msg );
4336:
4337: when e_invalid_res_reco_flag then

Line 4334: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4330: when e_invalid_res_sub_grp_num then
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4333: fnd_message.set_token('FLD_NAME', 'substitution_group_num');
4334: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4335: fnd_file.put_line(fnd_file.log,x_error_msg );
4336:
4337: when e_invalid_res_reco_flag then
4338: x_error_code := -1;

Line 4339: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4335: fnd_file.put_line(fnd_file.log,x_error_msg );
4336:
4337: when e_invalid_res_reco_flag then
4338: x_error_code := -1;
4339: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4340: fnd_message.set_token('FLD_NAME', 'recommended_flag');
4341: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4342: fnd_file.put_line(fnd_file.log,x_error_msg );
4343:

Line 4340: fnd_message.set_token('FLD_NAME', 'recommended_flag');

4336:
4337: when e_invalid_res_reco_flag then
4338: x_error_code := -1;
4339: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4340: fnd_message.set_token('FLD_NAME', 'recommended_flag');
4341: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4342: fnd_file.put_line(fnd_file.log,x_error_msg );
4343:
4344: when e_inv_res_basis_type then

Line 4341: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4337: when e_invalid_res_reco_flag then
4338: x_error_code := -1;
4339: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4340: fnd_message.set_token('FLD_NAME', 'recommended_flag');
4341: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4342: fnd_file.put_line(fnd_file.log,x_error_msg );
4343:
4344: when e_inv_res_basis_type then
4345: x_error_code := -1;

Line 4346: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4342: fnd_file.put_line(fnd_file.log,x_error_msg );
4343:
4344: when e_inv_res_basis_type then
4345: x_error_code := -1;
4346: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4347: fnd_message.set_token('FLD_NAME', 'basis_type');
4348: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4349: fnd_file.put_line(fnd_file.log,x_error_msg );
4350:

Line 4347: fnd_message.set_token('FLD_NAME', 'basis_type');

4343:
4344: when e_inv_res_basis_type then
4345: x_error_code := -1;
4346: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4347: fnd_message.set_token('FLD_NAME', 'basis_type');
4348: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4349: fnd_file.put_line(fnd_file.log,x_error_msg );
4350:
4351: when e_inv_res_charge_type then

Line 4348: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4344: when e_inv_res_basis_type then
4345: x_error_code := -1;
4346: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4347: fnd_message.set_token('FLD_NAME', 'basis_type');
4348: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4349: fnd_file.put_line(fnd_file.log,x_error_msg );
4350:
4351: when e_inv_res_charge_type then
4352: x_error_code := -1;

Line 4353: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');

4349: fnd_file.put_line(fnd_file.log,x_error_msg );
4350:
4351: when e_inv_res_charge_type then
4352: x_error_code := -1;
4353: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
4354: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4355: fnd_file.put_line(fnd_file.log,x_error_msg );
4356:
4357: when e_inv_res_sch_flag then

Line 4354: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4350:
4351: when e_inv_res_charge_type then
4352: x_error_code := -1;
4353: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
4354: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4355: fnd_file.put_line(fnd_file.log,x_error_msg );
4356:
4357: when e_inv_res_sch_flag then
4358: x_error_code := -1;

Line 4359: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4355: fnd_file.put_line(fnd_file.log,x_error_msg );
4356:
4357: when e_inv_res_sch_flag then
4358: x_error_code := -1;
4359: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4360: fnd_message.set_token('FLD_NAME', 'scheduled_flag');
4361: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4362: fnd_file.put_line(fnd_file.log,x_error_msg );
4363:

Line 4360: fnd_message.set_token('FLD_NAME', 'scheduled_flag');

4356:
4357: when e_inv_res_sch_flag then
4358: x_error_code := -1;
4359: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4360: fnd_message.set_token('FLD_NAME', 'scheduled_flag');
4361: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4362: fnd_file.put_line(fnd_file.log,x_error_msg );
4363:
4364: when e_invalid_res_seq_num then

Line 4361: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4357: when e_inv_res_sch_flag then
4358: x_error_code := -1;
4359: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4360: fnd_message.set_token('FLD_NAME', 'scheduled_flag');
4361: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4362: fnd_file.put_line(fnd_file.log,x_error_msg );
4363:
4364: when e_invalid_res_seq_num then
4365: x_error_code := -1;

Line 4366: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4362: fnd_file.put_line(fnd_file.log,x_error_msg );
4363:
4364: when e_invalid_res_seq_num then
4365: x_error_code := -1;
4366: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4367: fnd_message.set_token('FLD_NAME', 'resource_seq_num');
4368: x_error_msg := fnd_message.get;
4369: fnd_file.put_line(fnd_file.log,x_error_msg );
4370:

Line 4367: fnd_message.set_token('FLD_NAME', 'resource_seq_num');

4363:
4364: when e_invalid_res_seq_num then
4365: x_error_code := -1;
4366: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4367: fnd_message.set_token('FLD_NAME', 'resource_seq_num');
4368: x_error_msg := fnd_message.get;
4369: fnd_file.put_line(fnd_file.log,x_error_msg );
4370:
4371: when e_invalid_usg_rate then

Line 4368: x_error_msg := fnd_message.get;

4364: when e_invalid_res_seq_num then
4365: x_error_code := -1;
4366: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4367: fnd_message.set_token('FLD_NAME', 'resource_seq_num');
4368: x_error_msg := fnd_message.get;
4369: fnd_file.put_line(fnd_file.log,x_error_msg );
4370:
4371: when e_invalid_usg_rate then
4372: x_error_code := -1;

Line 4373: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4369: fnd_file.put_line(fnd_file.log,x_error_msg );
4370:
4371: when e_invalid_usg_rate then
4372: x_error_code := -1;
4373: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4374: fnd_message.set_token('FLD_NAME', 'usage_rate_or_amount');
4375: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4376: fnd_file.put_line(fnd_file.log,x_error_msg );
4377:

Line 4374: fnd_message.set_token('FLD_NAME', 'usage_rate_or_amount');

4370:
4371: when e_invalid_usg_rate then
4372: x_error_code := -1;
4373: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4374: fnd_message.set_token('FLD_NAME', 'usage_rate_or_amount');
4375: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4376: fnd_file.put_line(fnd_file.log,x_error_msg );
4377:
4378: when e_invalid_res_dept THEN

Line 4375: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4371: when e_invalid_usg_rate then
4372: x_error_code := -1;
4373: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4374: fnd_message.set_token('FLD_NAME', 'usage_rate_or_amount');
4375: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4376: fnd_file.put_line(fnd_file.log,x_error_msg );
4377:
4378: when e_invalid_res_dept THEN
4379: x_error_code := -1;

Line 4380: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');

4376: fnd_file.put_line(fnd_file.log,x_error_msg );
4377:
4378: when e_invalid_res_dept THEN
4379: x_error_code := -1;
4380: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
4381: x_error_msg := fnd_message.get;
4382:
4383: when e_inv_resource_charge_type then
4384: x_error_code := -1;

Line 4381: x_error_msg := fnd_message.get;

4377:
4378: when e_invalid_res_dept THEN
4379: x_error_code := -1;
4380: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
4381: x_error_msg := fnd_message.get;
4382:
4383: when e_inv_resource_charge_type then
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 4385: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4381: x_error_msg := fnd_message.get;
4382:
4383: when e_inv_resource_charge_type then
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4386: fnd_message.set_token('FLD_NAME', 'Autocharge_type');
4387: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4388: fnd_file.put_line(fnd_file.log,x_error_msg );
4389:

Line 4386: fnd_message.set_token('FLD_NAME', 'Autocharge_type');

4382:
4383: when e_inv_resource_charge_type then
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4386: fnd_message.set_token('FLD_NAME', 'Autocharge_type');
4387: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4388: fnd_file.put_line(fnd_file.log,x_error_msg );
4389:
4390: when others then

Line 4387: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;

4383: when e_inv_resource_charge_type then
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4386: fnd_message.set_token('FLD_NAME', 'Autocharge_type');
4387: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4388: fnd_file.put_line(fnd_file.log,x_error_msg );
4389:
4390: when others then
4391: x_error_code := -1;

Line 4764: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');

4760:
4761: EXCEPTION
4762: when e_res_not_reco then
4763: x_error_code := -1;
4764: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
4765: x_error_msg := fnd_message.get;
4766: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4767:
4768: when e_not_on_reco_path then

Line 4765: x_error_msg := fnd_message.get;

4761: EXCEPTION
4762: when e_res_not_reco then
4763: x_error_code := -1;
4764: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
4765: x_error_msg := fnd_message.get;
4766: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4767:
4768: when e_not_on_reco_path then
4769: x_error_code := -1;

Line 4770: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');

4766: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4767:
4768: when e_not_on_reco_path then
4769: x_error_code := -1;
4770: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
4771: x_error_msg := fnd_message.get;
4772: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4773:
4774:

Line 4771: x_error_msg := fnd_message.get;

4767:
4768: when e_not_on_reco_path then
4769: x_error_code := -1;
4770: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
4771: x_error_msg := fnd_message.get;
4772: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4773:
4774:
4775: when e_invalid_rtg_op_seq then

Line 4777: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4773:
4774:
4775: when e_invalid_rtg_op_seq then
4776: x_error_code := -1;
4777: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4778: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
4779: x_error_msg := fnd_message.get;
4780:
4781: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);

Line 4778: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');

4774:
4775: when e_invalid_rtg_op_seq then
4776: x_error_code := -1;
4777: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4778: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
4779: x_error_msg := fnd_message.get;
4780:
4781: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4782:

Line 4779: x_error_msg := fnd_message.get;

4775: when e_invalid_rtg_op_seq then
4776: x_error_code := -1;
4777: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4778: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
4779: x_error_msg := fnd_message.get;
4780:
4781: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4782:
4783:

Line 4786: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');

4782:
4783:
4784: when e_invalid_res_seq_num then
4785: x_error_code := -1;
4786: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
4787: x_error_msg := fnd_message.get;
4788:
4789: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4790:

Line 4787: x_error_msg := fnd_message.get;

4783:
4784: when e_invalid_res_seq_num then
4785: x_error_code := -1;
4786: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
4787: x_error_msg := fnd_message.get;
4788:
4789: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4790:
4791:

Line 4794: fnd_message.set_name('WSM','WSM_INS_NOT_EXISTS');

4790:
4791:
4792: when e_ins_not_exists then
4793: x_error_code := -1;
4794: fnd_message.set_name('WSM','WSM_INS_NOT_EXISTS');
4795: x_error_msg := fnd_message.get;
4796:
4797: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4798:

Line 4795: x_error_msg := fnd_message.get;

4791:
4792: when e_ins_not_exists then
4793: x_error_code := -1;
4794: fnd_message.set_name('WSM','WSM_INS_NOT_EXISTS');
4795: x_error_msg := fnd_message.get;
4796:
4797: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4798:
4799:

Line 4802: fnd_message.set_name('WSM','WSM_NULL_FIELD');

4798:
4799:
4800: when e_null_ins_id then
4801: x_error_code := -1;
4802: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4803: fnd_message.set_token('FLD_NAME', 'Instance_id');
4804: x_error_msg := fnd_message.get;
4805:
4806: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);

Line 4803: fnd_message.set_token('FLD_NAME', 'Instance_id');

4799:
4800: when e_null_ins_id then
4801: x_error_code := -1;
4802: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4803: fnd_message.set_token('FLD_NAME', 'Instance_id');
4804: x_error_msg := fnd_message.get;
4805:
4806: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4807:

Line 4804: x_error_msg := fnd_message.get;

4800: when e_null_ins_id then
4801: x_error_code := -1;
4802: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4803: fnd_message.set_token('FLD_NAME', 'Instance_id');
4804: x_error_msg := fnd_message.get;
4805:
4806: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4807:
4808:

Line 4811: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4807:
4808:
4809: when e_invalid_ins_id then
4810: x_error_code := -1;
4811: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4812: fnd_message.set_token('FLD_NAME', 'Instance_id and Serial_number');
4813: x_error_msg := fnd_message.get;
4814:
4815: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);

Line 4812: fnd_message.set_token('FLD_NAME', 'Instance_id and Serial_number');

4808:
4809: when e_invalid_ins_id then
4810: x_error_code := -1;
4811: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4812: fnd_message.set_token('FLD_NAME', 'Instance_id and Serial_number');
4813: x_error_msg := fnd_message.get;
4814:
4815: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4816:

Line 4813: x_error_msg := fnd_message.get;

4809: when e_invalid_ins_id then
4810: x_error_code := -1;
4811: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4812: fnd_message.set_token('FLD_NAME', 'Instance_id and Serial_number');
4813: x_error_msg := fnd_message.get;
4814:
4815: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4816:
4817:

Line 4820: fnd_message.set_name('WSM','WSM_NULL_FIELD');

4816:
4817:
4818: when e_null_date then
4819: x_error_code := -1;
4820: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4821: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
4822: x_error_msg := fnd_message.get;
4823:
4824: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);

Line 4821: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');

4817:
4818: when e_null_date then
4819: x_error_code := -1;
4820: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4821: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
4822: x_error_msg := fnd_message.get;
4823:
4824: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4825:

Line 4822: x_error_msg := fnd_message.get;

4818: when e_null_date then
4819: x_error_code := -1;
4820: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4821: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
4822: x_error_msg := fnd_message.get;
4823:
4824: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4825:
4826:

Line 4829: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

4825:
4826:
4827: when e_invalid_date then
4828: x_error_code := -1;
4829: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4830: fnd_message.set_token('FLD_NAME', 'Resource instance scheduled dates');
4831: x_error_msg := fnd_message.get;
4832:
4833: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);

Line 4830: fnd_message.set_token('FLD_NAME', 'Resource instance scheduled dates');

4826:
4827: when e_invalid_date then
4828: x_error_code := -1;
4829: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4830: fnd_message.set_token('FLD_NAME', 'Resource instance scheduled dates');
4831: x_error_msg := fnd_message.get;
4832:
4833: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4834:

Line 4831: x_error_msg := fnd_message.get;

4827: when e_invalid_date then
4828: x_error_code := -1;
4829: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4830: fnd_message.set_token('FLD_NAME', 'Resource instance scheduled dates');
4831: x_error_msg := fnd_message.get;
4832:
4833: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4834:
4835:

Line 4838: fnd_message.set_name('WSM','WSM_INS_BAD_TIME_SLOT');

4834:
4835:
4836: when e_invalid_time_slot then
4837: x_error_code := -1;
4838: fnd_message.set_name('WSM','WSM_INS_BAD_TIME_SLOT');
4839: x_error_msg := fnd_message.get;
4840:
4841: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4842:

Line 4839: x_error_msg := fnd_message.get;

4835:
4836: when e_invalid_time_slot then
4837: x_error_code := -1;
4838: fnd_message.set_name('WSM','WSM_INS_BAD_TIME_SLOT');
4839: x_error_msg := fnd_message.get;
4840:
4841: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4842:
4843: -- ST : Detailed Scheduling...

Line 5281: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');

5277:
5278: EXCEPTION
5279: when e_not_on_reco_path then
5280: x_error_code := -1;
5281: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
5282: x_error_msg := fnd_message.get;
5283: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5284:
5285: when e_res_not_reco then

Line 5282: x_error_msg := fnd_message.get;

5278: EXCEPTION
5279: when e_not_on_reco_path then
5280: x_error_code := -1;
5281: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
5282: x_error_msg := fnd_message.get;
5283: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5284:
5285: when e_res_not_reco then
5286: x_error_code := -1;

Line 5287: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');

5283: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5284:
5285: when e_res_not_reco then
5286: x_error_code := -1;
5287: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
5288: x_error_msg := fnd_message.get;
5289: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5290:
5291: when e_invalid_rtg_op_seq then

Line 5288: x_error_msg := fnd_message.get;

5284:
5285: when e_res_not_reco then
5286: x_error_code := -1;
5287: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
5288: x_error_msg := fnd_message.get;
5289: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5290:
5291: when e_invalid_rtg_op_seq then
5292: x_error_code := -1;

Line 5293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

5289: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5290:
5291: when e_invalid_rtg_op_seq then
5292: x_error_code := -1;
5293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5294: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
5295: x_error_msg := fnd_message.get;
5296: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5297:

Line 5294: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');

5290:
5291: when e_invalid_rtg_op_seq then
5292: x_error_code := -1;
5293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5294: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
5295: x_error_msg := fnd_message.get;
5296: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5297:
5298: when e_invalid_res_seq_num then

Line 5295: x_error_msg := fnd_message.get;

5291: when e_invalid_rtg_op_seq then
5292: x_error_code := -1;
5293: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5294: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
5295: x_error_msg := fnd_message.get;
5296: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5297:
5298: when e_invalid_res_seq_num then
5299: x_error_code := -1;

Line 5300: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');

5296: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5297:
5298: when e_invalid_res_seq_num then
5299: x_error_code := -1;
5300: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
5301: x_error_msg := fnd_message.get;
5302: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5303:
5304: when e_instances_exist then

Line 5301: x_error_msg := fnd_message.get;

5297:
5298: when e_invalid_res_seq_num then
5299: x_error_code := -1;
5300: fnd_message.set_name('WSM','WSM_RES_NOT_REQUIRED');
5301: x_error_msg := fnd_message.get;
5302: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5303:
5304: when e_instances_exist then
5305: x_error_code := -1;

Line 5306: fnd_message.set_name('WSM','WSM_INS_EXISTS');

5302: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5303:
5304: when e_instances_exist then
5305: x_error_code := -1;
5306: fnd_message.set_name('WSM','WSM_INS_EXISTS');
5307: x_error_msg := fnd_message.get;
5308: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5309:
5310: when e_invalid_instance_id then

Line 5307: x_error_msg := fnd_message.get;

5303:
5304: when e_instances_exist then
5305: x_error_code := -1;
5306: fnd_message.set_name('WSM','WSM_INS_EXISTS');
5307: x_error_msg := fnd_message.get;
5308: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5309:
5310: when e_invalid_instance_id then
5311: x_error_code := -1;

Line 5312: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

5308: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5309:
5310: when e_invalid_instance_id then
5311: x_error_code := -1;
5312: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5313: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');
5314: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */
5315: x_error_msg := fnd_message.get;
5316: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);

Line 5313: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');

5309:
5310: when e_invalid_instance_id then
5311: x_error_code := -1;
5312: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5313: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');
5314: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */
5315: x_error_msg := fnd_message.get;
5316: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5317:

Line 5314: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */

5310: when e_invalid_instance_id then
5311: x_error_code := -1;
5312: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5313: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');
5314: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */
5315: x_error_msg := fnd_message.get;
5316: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5317:
5318: when e_invalid_asgned_units then

Line 5315: x_error_msg := fnd_message.get;

5311: x_error_code := -1;
5312: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5313: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');
5314: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */
5315: x_error_msg := fnd_message.get;
5316: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5317:
5318: when e_invalid_asgned_units then
5319: x_error_code := -1;

Line 5320: fnd_message.set_name('WSM','WSM_USE_BAD_ASGN_UNITS');

5316: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5317:
5318: when e_invalid_asgned_units then
5319: x_error_code := -1;
5320: fnd_message.set_name('WSM','WSM_USE_BAD_ASGN_UNITS');
5321: x_error_msg := fnd_message.get;
5322: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5323:
5324: /* ST : Detailed Scheduling start */

Line 5321: x_error_msg := fnd_message.get;

5317:
5318: when e_invalid_asgned_units then
5319: x_error_code := -1;
5320: fnd_message.set_name('WSM','WSM_USE_BAD_ASGN_UNITS');
5321: x_error_msg := fnd_message.get;
5322: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5323:
5324: /* ST : Detailed Scheduling start */
5325: when e_invalid_ins_assigned_units then

Line 5327: fnd_message.set_name('WSM','WSM_INVALID_INS_ASSG_UNITS');

5323:
5324: /* ST : Detailed Scheduling start */
5325: when e_invalid_ins_assigned_units then
5326: x_error_code := -1;
5327: fnd_message.set_name('WSM','WSM_INVALID_INS_ASSG_UNITS');
5328: x_error_msg := fnd_message.get;
5329: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5330:
5331: when e_no_res_seq_num then

Line 5328: x_error_msg := fnd_message.get;

5324: /* ST : Detailed Scheduling start */
5325: when e_invalid_ins_assigned_units then
5326: x_error_code := -1;
5327: fnd_message.set_name('WSM','WSM_INVALID_INS_ASSG_UNITS');
5328: x_error_msg := fnd_message.get;
5329: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5330:
5331: when e_no_res_seq_num then
5332: x_error_msg := 'validate_wljdi_res_usage : resource_seq_num cannot be uniquely found'; -- CZHDBG_MSG

Line 5340: fnd_message.set_name('WSM','WSM_USE_NOT_EXISTS');

5336: /* ST : Detailed Scheduling end */
5337:
5338: when e_usage_not_exists then
5339: x_error_code := -1;
5340: fnd_message.set_name('WSM','WSM_USE_NOT_EXISTS');
5341: x_error_msg := fnd_message.get;
5342: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5343:
5344: when e_null_date then

Line 5341: x_error_msg := fnd_message.get;

5337:
5338: when e_usage_not_exists then
5339: x_error_code := -1;
5340: fnd_message.set_name('WSM','WSM_USE_NOT_EXISTS');
5341: x_error_msg := fnd_message.get;
5342: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5343:
5344: when e_null_date then
5345: x_error_code := -1;

Line 5346: fnd_message.set_name('WSM','WSM_NULL_FIELD');

5342: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5343:
5344: when e_null_date then
5345: x_error_code := -1;
5346: fnd_message.set_name('WSM','WSM_NULL_FIELD');
5347: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
5348: x_error_msg := fnd_message.get;
5349: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5350:

Line 5347: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');

5343:
5344: when e_null_date then
5345: x_error_code := -1;
5346: fnd_message.set_name('WSM','WSM_NULL_FIELD');
5347: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
5348: x_error_msg := fnd_message.get;
5349: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5350:
5351: when e_invalid_date then

Line 5348: x_error_msg := fnd_message.get;

5344: when e_null_date then
5345: x_error_code := -1;
5346: fnd_message.set_name('WSM','WSM_NULL_FIELD');
5347: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
5348: x_error_msg := fnd_message.get;
5349: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5350:
5351: when e_invalid_date then
5352: x_error_code := -1;

Line 5353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

5349: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5350:
5351: when e_invalid_date then
5352: x_error_code := -1;
5353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5354: fnd_message.set_token('FLD_NAME', 'Resource usage scheduled dates');
5355: x_error_msg := fnd_message.get;
5356: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5357:

Line 5354: fnd_message.set_token('FLD_NAME', 'Resource usage scheduled dates');

5350:
5351: when e_invalid_date then
5352: x_error_code := -1;
5353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5354: fnd_message.set_token('FLD_NAME', 'Resource usage scheduled dates');
5355: x_error_msg := fnd_message.get;
5356: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5357:
5358: when e_date_overlap then

Line 5355: x_error_msg := fnd_message.get;

5351: when e_invalid_date then
5352: x_error_code := -1;
5353: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5354: fnd_message.set_token('FLD_NAME', 'Resource usage scheduled dates');
5355: x_error_msg := fnd_message.get;
5356: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5357:
5358: when e_date_overlap then
5359: x_error_code := -1;

Line 5360: fnd_message.set_name('WSM','WSM_USE_TIME_OVERLAP');

5356: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5357:
5358: when e_date_overlap then
5359: x_error_code := -1;
5360: fnd_message.set_name('WSM','WSM_USE_TIME_OVERLAP');
5361: x_error_msg := fnd_message.get;
5362: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5363:
5364: when e_invalid_time_slot then

Line 5361: x_error_msg := fnd_message.get;

5357:
5358: when e_date_overlap then
5359: x_error_code := -1;
5360: fnd_message.set_name('WSM','WSM_USE_TIME_OVERLAP');
5361: x_error_msg := fnd_message.get;
5362: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5363:
5364: when e_invalid_time_slot then
5365: x_error_code := -1;

Line 5366: fnd_message.set_name('WSM','WSM_USE_BAD_TIME_SLOT');

5362: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5363:
5364: when e_invalid_time_slot then
5365: x_error_code := -1;
5366: fnd_message.set_name('WSM','WSM_USE_BAD_TIME_SLOT');
5367: x_error_msg := fnd_message.get;
5368: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5369:
5370: when others then

Line 5367: x_error_msg := fnd_message.get;

5363:
5364: when e_invalid_time_slot then
5365: x_error_code := -1;
5366: fnd_message.set_name('WSM','WSM_USE_BAD_TIME_SLOT');
5367: x_error_msg := fnd_message.get;
5368: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5369:
5370: when others then
5371: x_error_code := -1;

Line 6065: fnd_message.set_name('WSM','WSM_COMP_NOT_REQUIRED');

6061:
6062: EXCEPTION
6063: when e_invalid_component then
6064: x_error_code := -1;
6065: fnd_message.set_name('WSM','WSM_COMP_NOT_REQUIRED');
6066: x_error_msg := fnd_message.get;
6067:
6068: when e_invalid_comp_yield then
6069: x_error_code := -1;

Line 6066: x_error_msg := fnd_message.get;

6062: EXCEPTION
6063: when e_invalid_component then
6064: x_error_code := -1;
6065: fnd_message.set_name('WSM','WSM_COMP_NOT_REQUIRED');
6066: x_error_msg := fnd_message.get;
6067:
6068: when e_invalid_comp_yield then
6069: x_error_code := -1;
6070: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');

Line 6070: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');

6066: x_error_msg := fnd_message.get;
6067:
6068: when e_invalid_comp_yield then
6069: x_error_code := -1;
6070: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');
6071: x_error_msg := fnd_message.get;
6072:
6073: when e_req_qty_not_upd then
6074: x_error_code := -1;

Line 6071: x_error_msg := fnd_message.get;

6067:
6068: when e_invalid_comp_yield then
6069: x_error_code := -1;
6070: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');
6071: x_error_msg := fnd_message.get;
6072:
6073: when e_req_qty_not_upd then
6074: x_error_code := -1;
6075: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');

Line 6075: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');

6071: x_error_msg := fnd_message.get;
6072:
6073: when e_req_qty_not_upd then
6074: x_error_code := -1;
6075: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');
6076: x_error_msg := fnd_message.get;
6077:
6078: /*when e_req_qty_negative then
6079: x_error_code := -1;

Line 6076: x_error_msg := fnd_message.get;

6072:
6073: when e_req_qty_not_upd then
6074: x_error_code := -1;
6075: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');
6076: x_error_msg := fnd_message.get;
6077:
6078: /*when e_req_qty_negative then
6079: x_error_code := -1;
6080: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');

Line 6080: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');

6076: x_error_msg := fnd_message.get;
6077:
6078: /*when e_req_qty_negative then
6079: x_error_code := -1;
6080: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');
6081: x_error_msg := fnd_message.get;*/
6082:
6083: when e_invalid_phantom then
6084: x_error_code := -1;

Line 6081: x_error_msg := fnd_message.get;*/

6077:
6078: /*when e_req_qty_negative then
6079: x_error_code := -1;
6080: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');
6081: x_error_msg := fnd_message.get;*/
6082:
6083: when e_invalid_phantom then
6084: x_error_code := -1;
6085: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');

Line 6085: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');

6081: x_error_msg := fnd_message.get;*/
6082:
6083: when e_invalid_phantom then
6084: x_error_code := -1;
6085: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');
6086: x_error_msg := fnd_message.get;
6087:
6088: when e_invalid_date then
6089: x_error_code := -1;

Line 6086: x_error_msg := fnd_message.get;

6082:
6083: when e_invalid_phantom then
6084: x_error_code := -1;
6085: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');
6086: x_error_msg := fnd_message.get;
6087:
6088: when e_invalid_date then
6089: x_error_code := -1;
6090: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');

Line 6090: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');

6086: x_error_msg := fnd_message.get;
6087:
6088: when e_invalid_date then
6089: x_error_code := -1;
6090: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');
6091: x_error_msg := fnd_message.get;
6092:
6093: ---Alcoa Enhancement Changes
6094: when e_parent_phantom then

Line 6091: x_error_msg := fnd_message.get;

6087:
6088: when e_invalid_date then
6089: x_error_code := -1;
6090: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');
6091: x_error_msg := fnd_message.get;
6092:
6093: ---Alcoa Enhancement Changes
6094: when e_parent_phantom then
6095: x_error_code := -1;

Line 6096: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM');

6092:
6093: ---Alcoa Enhancement Changes
6094: when e_parent_phantom then
6095: x_error_code := -1;
6096: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM');
6097: x_error_msg := fnd_message.get;
6098:
6099: when e_parent_phantom_comp then
6100: x_error_code := -1;

Line 6097: x_error_msg := fnd_message.get;

6093: ---Alcoa Enhancement Changes
6094: when e_parent_phantom then
6095: x_error_code := -1;
6096: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM');
6097: x_error_msg := fnd_message.get;
6098:
6099: when e_parent_phantom_comp then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');

Line 6101: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');

6097: x_error_msg := fnd_message.get;
6098:
6099: when e_parent_phantom_comp then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');
6102: x_error_msg := fnd_message.get;
6103:
6104: when e_no_parent_phantom then
6105: x_error_code := -1;

Line 6102: x_error_msg := fnd_message.get;

6098:
6099: when e_parent_phantom_comp then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');
6102: x_error_msg := fnd_message.get;
6103:
6104: when e_no_parent_phantom then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');

Line 6106: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');

6102: x_error_msg := fnd_message.get;
6103:
6104: when e_no_parent_phantom then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');
6107: x_error_msg := fnd_message.get;
6108:
6109: when e_invalid_item then
6110: x_error_code := -1;

Line 6107: x_error_msg := fnd_message.get;

6103:
6104: when e_no_parent_phantom then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');
6107: x_error_msg := fnd_message.get;
6108:
6109: when e_invalid_item then
6110: x_error_code := -1;
6111: fnd_message.set_name('WSM','WSM_INVALID_ITEM');

Line 6111: fnd_message.set_name('WSM','WSM_INVALID_ITEM');

6107: x_error_msg := fnd_message.get;
6108:
6109: when e_invalid_item then
6110: x_error_code := -1;
6111: fnd_message.set_name('WSM','WSM_INVALID_ITEM');
6112: x_error_msg := fnd_message.get;
6113:
6114: when e_quantity_issued_error then
6115: x_error_code := -1;

Line 6112: x_error_msg := fnd_message.get;

6108:
6109: when e_invalid_item then
6110: x_error_code := -1;
6111: fnd_message.set_name('WSM','WSM_INVALID_ITEM');
6112: x_error_msg := fnd_message.get;
6113:
6114: when e_quantity_issued_error then
6115: x_error_code := -1;
6116: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6116: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6112: x_error_msg := fnd_message.get;
6113:
6114: when e_quantity_issued_error then
6115: x_error_code := -1;
6116: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6117: fnd_message.set_token('FLD_NAME', 'Quantity_issued');
6118: x_error_msg := fnd_message.get;
6119:
6120: when e_material_trans_err then

Line 6117: fnd_message.set_token('FLD_NAME', 'Quantity_issued');

6113:
6114: when e_quantity_issued_error then
6115: x_error_code := -1;
6116: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6117: fnd_message.set_token('FLD_NAME', 'Quantity_issued');
6118: x_error_msg := fnd_message.get;
6119:
6120: when e_material_trans_err then
6121: x_error_code := -1;

Line 6118: x_error_msg := fnd_message.get;

6114: when e_quantity_issued_error then
6115: x_error_code := -1;
6116: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6117: fnd_message.set_token('FLD_NAME', 'Quantity_issued');
6118: x_error_msg := fnd_message.get;
6119:
6120: when e_material_trans_err then
6121: x_error_code := -1;
6122: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');

Line 6122: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');

6118: x_error_msg := fnd_message.get;
6119:
6120: when e_material_trans_err then
6121: x_error_code := -1;
6122: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');
6123: x_error_msg := fnd_message.get;
6124:
6125: when e_phantom_comp then
6126: x_error_code := -1;

Line 6123: x_error_msg := fnd_message.get;

6119:
6120: when e_material_trans_err then
6121: x_error_code := -1;
6122: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');
6123: x_error_msg := fnd_message.get;
6124:
6125: when e_phantom_comp then
6126: x_error_code := -1;
6127: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');

Line 6127: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');

6123: x_error_msg := fnd_message.get;
6124:
6125: when e_phantom_comp then
6126: x_error_code := -1;
6127: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');
6128: x_error_msg := fnd_message.get;
6129:
6130: when e_invalid_wip_supply_type then
6131: x_error_code := -1;

Line 6128: x_error_msg := fnd_message.get;

6124:
6125: when e_phantom_comp then
6126: x_error_code := -1;
6127: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');
6128: x_error_msg := fnd_message.get;
6129:
6130: when e_invalid_wip_supply_type then
6131: x_error_code := -1;
6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6128: x_error_msg := fnd_message.get;
6129:
6130: when e_invalid_wip_supply_type then
6131: x_error_code := -1;
6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6133: fnd_message.set_token('FLD_NAME', 'Supply_type');
6134: x_error_msg := fnd_message.get;
6135:
6136: when e_invalid_qpa then

Line 6133: fnd_message.set_token('FLD_NAME', 'Supply_type');

6129:
6130: when e_invalid_wip_supply_type then
6131: x_error_code := -1;
6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6133: fnd_message.set_token('FLD_NAME', 'Supply_type');
6134: x_error_msg := fnd_message.get;
6135:
6136: when e_invalid_qpa then
6137: x_error_code := -1;

Line 6134: x_error_msg := fnd_message.get;

6130: when e_invalid_wip_supply_type then
6131: x_error_code := -1;
6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6133: fnd_message.set_token('FLD_NAME', 'Supply_type');
6134: x_error_msg := fnd_message.get;
6135:
6136: when e_invalid_qpa then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6138: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6134: x_error_msg := fnd_message.get;
6135:
6136: when e_invalid_qpa then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6139: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6140: x_error_msg := fnd_message.get;
6141:
6142: when e_inv_supply_info then

Line 6139: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');

6135:
6136: when e_invalid_qpa then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6139: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6140: x_error_msg := fnd_message.get;
6141:
6142: when e_inv_supply_info then
6143: x_error_code := -1;

Line 6140: x_error_msg := fnd_message.get;

6136: when e_invalid_qpa then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6139: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6140: x_error_msg := fnd_message.get;
6141:
6142: when e_inv_supply_info then
6143: x_error_code := -1;
6144: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6144: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6140: x_error_msg := fnd_message.get;
6141:
6142: when e_inv_supply_info then
6143: x_error_code := -1;
6144: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6145: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6146: x_error_msg := fnd_message.get;
6147:
6148: when e_invalid_job then

Line 6145: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');

6141:
6142: when e_inv_supply_info then
6143: x_error_code := -1;
6144: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6145: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6146: x_error_msg := fnd_message.get;
6147:
6148: when e_invalid_job then
6149: x_error_code := -1;

Line 6146: x_error_msg := fnd_message.get;

6142: when e_inv_supply_info then
6143: x_error_code := -1;
6144: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6145: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6146: x_error_msg := fnd_message.get;
6147:
6148: when e_invalid_job then
6149: x_error_code := -1;
6150: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6150: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6146: x_error_msg := fnd_message.get;
6147:
6148: when e_invalid_job then
6149: x_error_code := -1;
6150: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6151: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6152: x_error_msg := fnd_message.get;
6153:
6154: when e_dup_component then

Line 6151: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');

6147:
6148: when e_invalid_job then
6149: x_error_code := -1;
6150: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6151: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6152: x_error_msg := fnd_message.get;
6153:
6154: when e_dup_component then
6155: x_error_code := -1;

Line 6152: x_error_msg := fnd_message.get;

6148: when e_invalid_job then
6149: x_error_code := -1;
6150: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6151: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6152: x_error_msg := fnd_message.get;
6153:
6154: when e_dup_component then
6155: x_error_code := -1;
6156: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');

Line 6156: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');

6152: x_error_msg := fnd_message.get;
6153:
6154: when e_dup_component then
6155: x_error_code := -1;
6156: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');
6157: x_error_msg := fnd_message.get;
6158:
6159: when e_no_assy_as_comp then
6160: x_error_code := -1;

Line 6157: x_error_msg := fnd_message.get;

6153:
6154: when e_dup_component then
6155: x_error_code := -1;
6156: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');
6157: x_error_msg := fnd_message.get;
6158:
6159: when e_no_assy_as_comp then
6160: x_error_code := -1;
6161: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');

Line 6161: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');

6157: x_error_msg := fnd_message.get;
6158:
6159: when e_no_assy_as_comp then
6160: x_error_code := -1;
6161: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');
6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_mrp_net_flag then
6165: x_error_code := -1;

Line 6162: x_error_msg := fnd_message.get;

6158:
6159: when e_no_assy_as_comp then
6160: x_error_code := -1;
6161: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');
6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_mrp_net_flag then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

Line 6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_mrp_net_flag then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6168: x_error_msg := fnd_message.get;
6169:
6170: --Added for bug Fix #7197440

Line 6167: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');

6163:
6164: when e_invalid_mrp_net_flag then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6168: x_error_msg := fnd_message.get;
6169:
6170: --Added for bug Fix #7197440
6171: when e_req_qty_zero then -- bug #7197440

Line 6168: x_error_msg := fnd_message.get;

6164: when e_invalid_mrp_net_flag then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6168: x_error_msg := fnd_message.get;
6169:
6170: --Added for bug Fix #7197440
6171: when e_req_qty_zero then -- bug #7197440
6172: x_error_code := -1;

Line 6173: fnd_message.set_name('WSM','WSM_COPY_QTY_NON_ZERO');

6169:
6170: --Added for bug Fix #7197440
6171: when e_req_qty_zero then -- bug #7197440
6172: x_error_code := -1;
6173: fnd_message.set_name('WSM','WSM_COPY_QTY_NON_ZERO');
6174: x_error_msg := fnd_message.get;
6175:
6176: when e_req_qty_sign_chg then -- bug #7197440
6177: x_error_code := -1;

Line 6174: x_error_msg := fnd_message.get;

6170: --Added for bug Fix #7197440
6171: when e_req_qty_zero then -- bug #7197440
6172: x_error_code := -1;
6173: fnd_message.set_name('WSM','WSM_COPY_QTY_NON_ZERO');
6174: x_error_msg := fnd_message.get;
6175:
6176: when e_req_qty_sign_chg then -- bug #7197440
6177: x_error_code := -1;
6178: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');

Line 6178: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');

6174: x_error_msg := fnd_message.get;
6175:
6176: when e_req_qty_sign_chg then -- bug #7197440
6177: x_error_code := -1;
6178: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');
6179: x_error_msg := fnd_message.get;
6180:
6181: when others then
6182: x_error_code := -1;

Line 6179: x_error_msg := fnd_message.get;

6175:
6176: when e_req_qty_sign_chg then -- bug #7197440
6177: x_error_code := -1;
6178: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');
6179: x_error_msg := fnd_message.get;
6180:
6181: when others then
6182: x_error_code := -1;
6183: x_error_msg := 'Error: validate_wljdi_op_component: (#'||l_stmt_num||') '

Line 7650: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

7646: -- x_err_code => l_error_code,
7647: -- x_err_msg => l_error_msg,
7648: -- p_organization_id => v_wlji_org_id(v_idx) );
7649: --IF (l_return_value <> 0) THEN
7650: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7651: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7652: -- l_error_msg := fnd_message.get;
7653: -- l_error_code := -1;
7654: -- handle_error( l_error_code, l_error_msg, l_stmt_num);

Line 7651: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');

7647: -- x_err_msg => l_error_msg,
7648: -- p_organization_id => v_wlji_org_id(v_idx) );
7649: --IF (l_return_value <> 0) THEN
7650: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7651: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7652: -- l_error_msg := fnd_message.get;
7653: -- l_error_code := -1;
7654: -- handle_error( l_error_code, l_error_msg, l_stmt_num);
7655: -- GOTO skip_job_id_valid;

Line 7652: -- l_error_msg := fnd_message.get;

7648: -- p_organization_id => v_wlji_org_id(v_idx) );
7649: --IF (l_return_value <> 0) THEN
7650: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7651: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7652: -- l_error_msg := fnd_message.get;
7653: -- l_error_code := -1;
7654: -- handle_error( l_error_code, l_error_msg, l_stmt_num);
7655: -- GOTO skip_job_id_valid;
7656: --ELSE

Line 8229: fnd_message.set_name('WIP','WIP_MLD_DESC');

8225: -- Default description
8226: -- this is to be called only for job creation.
8227: if RTRIM(v_wlji_description(v_idx)) is NULL then
8228: l_date_text := fnd_date.date_to_charDT(sysdate);
8229: fnd_message.set_name('WIP','WIP_MLD_DESC');
8230: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8231: v_wlji_description(v_idx) := FND_Message.get;
8232: else
8233: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));

Line 8230: fnd_message.set_token('LOAD_DATE', l_date_text, false);

8226: -- this is to be called only for job creation.
8227: if RTRIM(v_wlji_description(v_idx)) is NULL then
8228: l_date_text := fnd_date.date_to_charDT(sysdate);
8229: fnd_message.set_name('WIP','WIP_MLD_DESC');
8230: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8231: v_wlji_description(v_idx) := FND_Message.get;
8232: else
8233: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));
8234: end if;

Line 8231: v_wlji_description(v_idx) := FND_Message.get;

8227: if RTRIM(v_wlji_description(v_idx)) is NULL then
8228: l_date_text := fnd_date.date_to_charDT(sysdate);
8229: fnd_message.set_name('WIP','WIP_MLD_DESC');
8230: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8231: v_wlji_description(v_idx) := FND_Message.get;
8232: else
8233: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));
8234: end if;
8235: if lbji_debug = 'Y' then

Line 8451: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');

8447:
8448: IF floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx) THEN
8449: -- error out...
8450: -- Start qty cannot be non-integer...
8451: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8452: l_aux_mesg := fnd_message.get;
8453: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
8454: l_error_code := -1;
8455: l_error_count := l_error_count + 1;

Line 8452: l_aux_mesg := fnd_message.get;

8448: IF floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx) THEN
8449: -- error out...
8450: -- Start qty cannot be non-integer...
8451: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8452: l_aux_mesg := fnd_message.get;
8453: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
8454: l_error_code := -1;
8455: l_error_count := l_error_count + 1;
8456: GOTO abort_this_job;

Line 8462: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');

8458:
8459: IF floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx) THEN
8460: -- error out...
8461: -- Start qty cannot be non-integer...
8462: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8463: l_aux_mesg := fnd_message.get;
8464: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
8465: l_error_code := -1;
8466: l_error_count := l_error_count + 1;

Line 8463: l_aux_mesg := fnd_message.get;

8459: IF floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx) THEN
8460: -- error out...
8461: -- Start qty cannot be non-integer...
8462: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8463: l_aux_mesg := fnd_message.get;
8464: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
8465: l_error_code := -1;
8466: l_error_count := l_error_count + 1;
8467: GOTO abort_this_job;

Line 8941: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');

8937: and nvl(mmtt2.locator_id, -9999) = nvl(v_wsli(v_wlji_src_line_id(v_idx)).locator_id, -9999)
8938: );
8939: end if;
8940: If l_temp_num <> 0 then
8941: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
8942: fnd_message.set_token('TABLE','Starting Lot:' ||
8943: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
8944: 'Table: mtl_transaction_lots_temp ');
8945: l_error_msg := fnd_message.get;

Line 8942: fnd_message.set_token('TABLE','Starting Lot:' ||

8938: );
8939: end if;
8940: If l_temp_num <> 0 then
8941: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
8942: fnd_message.set_token('TABLE','Starting Lot:' ||
8943: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
8944: 'Table: mtl_transaction_lots_temp ');
8945: l_error_msg := fnd_message.get;
8946: l_error_code := -1;

Line 8945: l_error_msg := fnd_message.get;

8941: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
8942: fnd_message.set_token('TABLE','Starting Lot:' ||
8943: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
8944: 'Table: mtl_transaction_lots_temp ');
8945: l_error_msg := fnd_message.get;
8946: l_error_code := -1;
8947: handle_error( l_error_code, l_error_msg, l_stmt_num);
8948: l_error_count := l_error_count + 1;
8949: GOTO abort_this_job;

Line 9879: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');

9875: null,
9876: v_wlji_org_id(v_idx),
9877: null, 5)
9878: then
9879: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
9880: l_error_msg := fnd_message.get;
9881: l_warning_count := l_warning_count + 1;
9882: handle_warning(
9883: p_err_msg => l_error_msg,

Line 9880: l_error_msg := fnd_message.get;

9876: v_wlji_org_id(v_idx),
9877: null, 5)
9878: then
9879: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
9880: l_error_msg := fnd_message.get;
9881: l_warning_count := l_warning_count + 1;
9882: handle_warning(
9883: p_err_msg => l_error_msg,
9884: p_header_id => v_wlji_header_id(v_idx),

Line 9920: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

9916:
9917: if l_est_scrap_account is null or
9918: l_est_scrap_var_account is null
9919: then
9920: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9921: fnd_message.set_token('CC', l_temp_class);
9922: l_error_msg := fnd_message.get;
9923: l_error_code := -1;
9924: handle_error(l_error_code, l_error_msg, l_stmt_num);

Line 9921: fnd_message.set_token('CC', l_temp_class);

9917: if l_est_scrap_account is null or
9918: l_est_scrap_var_account is null
9919: then
9920: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9921: fnd_message.set_token('CC', l_temp_class);
9922: l_error_msg := fnd_message.get;
9923: l_error_code := -1;
9924: handle_error(l_error_code, l_error_msg, l_stmt_num);
9925: GOTO skip_resched_validations;

Line 9922: l_error_msg := fnd_message.get;

9918: l_est_scrap_var_account is null
9919: then
9920: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9921: fnd_message.set_token('CC', l_temp_class);
9922: l_error_msg := fnd_message.get;
9923: l_error_code := -1;
9924: handle_error(l_error_code, l_error_msg, l_stmt_num);
9925: GOTO skip_resched_validations;
9926: end if;

Line 9930: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

9926: end if;
9927: if l_est_scrap_account is null or
9928: l_est_scrap_var_account is null
9929: then
9930: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9931: fnd_message.set_token('CC', l_temp_class);
9932: l_error_msg := fnd_message.get;
9933: l_error_code := -1;
9934: handle_error(l_error_code, l_error_msg, l_stmt_num);

Line 9931: fnd_message.set_token('CC', l_temp_class);

9927: if l_est_scrap_account is null or
9928: l_est_scrap_var_account is null
9929: then
9930: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9931: fnd_message.set_token('CC', l_temp_class);
9932: l_error_msg := fnd_message.get;
9933: l_error_code := -1;
9934: handle_error(l_error_code, l_error_msg, l_stmt_num);
9935: GOTO skip_resched_validations;

Line 9932: l_error_msg := fnd_message.get;

9928: l_est_scrap_var_account is null
9929: then
9930: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
9931: fnd_message.set_token('CC', l_temp_class);
9932: l_error_msg := fnd_message.get;
9933: l_error_code := -1;
9934: handle_error(l_error_code, l_error_msg, l_stmt_num);
9935: GOTO skip_resched_validations;
9936: end if;

Line 10101: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');

10097: (floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx))
10098: THEN
10099: -- error out...
10100: -- Start qty cannot be non-integer...
10101: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10102: l_aux_mesg := fnd_message.get;
10103: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
10104: l_error_code := -1;
10105: l_error_count := l_error_count + 1;

Line 10102: l_aux_mesg := fnd_message.get;

10098: THEN
10099: -- error out...
10100: -- Start qty cannot be non-integer...
10101: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10102: l_aux_mesg := fnd_message.get;
10103: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
10104: l_error_code := -1;
10105: l_error_count := l_error_count + 1;
10106: GOTO skip_resched_validations;

Line 10114: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');

10110: floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx)
10111: THEN
10112: -- error out...
10113: -- Start qty cannot be non-integer...
10114: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10115: l_aux_mesg := fnd_message.get;
10116: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
10117: l_error_code := -1;
10118: l_error_count := l_error_count + 1;

Line 10115: l_aux_mesg := fnd_message.get;

10111: THEN
10112: -- error out...
10113: -- Start qty cannot be non-integer...
10114: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10115: l_aux_mesg := fnd_message.get;
10116: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
10117: l_error_code := -1;
10118: l_error_count := l_error_count + 1;
10119: GOTO skip_resched_validations;

Line 10417: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');

10413: v_wlji_rtg_rev_date(v_idx),
10414: l_error_code,
10415: l_error_msg) = 1)
10416: then
10417: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
10418: l_error_msg := fnd_message.get;
10419: l_warning_count := l_warning_count + 1;
10420: handle_warning(
10421: p_err_msg => l_error_msg,

Line 10418: l_error_msg := fnd_message.get;

10414: l_error_code,
10415: l_error_msg) = 1)
10416: then
10417: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
10418: l_error_msg := fnd_message.get;
10419: l_warning_count := l_warning_count + 1;
10420: handle_warning(
10421: p_err_msg => l_error_msg,
10422: p_header_id => v_wlji_header_id(v_idx),

Line 10605: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');

10601: -- wcro.operation_seq_num= 1);
10602: --if(l_required_qpa = 0) then -- bug 2963225
10603: if(NVL(l_required_qpa, 0) = 0) then -- bug 2963225
10604: l_error_code := -1;
10605: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
10606: l_error_msg := fnd_message.get;
10607: handle_error(l_error_code, l_error_msg, l_stmt_num);
10608: l_error_count := l_error_count + 1;
10609: GOTO abort_this_job;

Line 10606: l_error_msg := fnd_message.get;

10602: --if(l_required_qpa = 0) then -- bug 2963225
10603: if(NVL(l_required_qpa, 0) = 0) then -- bug 2963225
10604: l_error_code := -1;
10605: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
10606: l_error_msg := fnd_message.get;
10607: handle_error(l_error_code, l_error_msg, l_stmt_num);
10608: l_error_count := l_error_count + 1;
10609: GOTO abort_this_job;
10610: end if;

Line 11072: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');

11068: and bd.department_id = wo.department_id;
11069:
11070: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11071: l_error_code := -1;
11072: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11073: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11074: l_error_msg := fnd_message.get;
11075: handle_error(l_error_code, l_error_msg, l_stmt_num);
11076: l_error_count := l_error_count + 1;

Line 11073: fnd_message.set_token('DEPT_ID',to_char(l_department_id));

11069:
11070: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11071: l_error_code := -1;
11072: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11073: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11074: l_error_msg := fnd_message.get;
11075: handle_error(l_error_code, l_error_msg, l_stmt_num);
11076: l_error_count := l_error_count + 1;
11077: GOTO abort_this_job;

Line 11074: l_error_msg := fnd_message.get;

11070: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11071: l_error_code := -1;
11072: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11073: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11074: l_error_msg := fnd_message.get;
11075: handle_error(l_error_code, l_error_msg, l_stmt_num);
11076: l_error_count := l_error_count + 1;
11077: GOTO abort_this_job;
11078: end if;

Line 11128: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

11124: null,
11125: v_wlji_org_id(v_idx),
11126: null, 5)
11127: then
11128: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
11129: l_error_msg := fnd_message.get;
11130: l_warning_count := l_warning_count + 1;
11131: handle_warning(
11132: p_err_msg => l_error_msg,

Line 11129: l_error_msg := fnd_message.get;

11125: v_wlji_org_id(v_idx),
11126: null, 5)
11127: then
11128: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
11129: l_error_msg := fnd_message.get;
11130: l_warning_count := l_warning_count + 1;
11131: handle_warning(
11132: p_err_msg => l_error_msg,
11133: p_header_id => v_wlji_header_id(v_idx),

Line 11221: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

11217: p_supply_status => inv_kanban_pvt.g_supply_status_exception);
11218:
11219: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11220: l_error_code := -1;
11221: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11222: l_stmt_num := 960.1;
11223: select meaning
11224: into l_meaning
11225: from mfg_lookups

Line 11230: fnd_message.set_token('STATUS',l_meaning);

11226: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11227: and lookup_code = 7
11228: and upper(enabled_flag) = 'Y';
11229:
11230: fnd_message.set_token('STATUS',l_meaning);
11231: l_error_msg := fnd_message.get;
11232: handle_error(l_error_code, l_error_msg, l_stmt_num);
11233: l_error_count := l_error_count + 1;
11234: GOTO abort_this_job;

Line 11231: l_error_msg := fnd_message.get;

11227: and lookup_code = 7
11228: and upper(enabled_flag) = 'Y';
11229:
11230: fnd_message.set_token('STATUS',l_meaning);
11231: l_error_msg := fnd_message.get;
11232: handle_error(l_error_code, l_error_msg, l_stmt_num);
11233: l_error_count := l_error_count + 1;
11234: GOTO abort_this_job;
11235: end if;

Line 11844: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

11840: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
11841:
11842: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11843: l_error_code := -1;
11844: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11845: select meaning
11846: into l_meaning
11847: from mfg_lookups
11848: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'

Line 11852: fnd_message.set_token('STATUS',l_meaning);

11848: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11849: and lookup_code = 7
11850: and upper(enabled_flag) = 'Y';
11851:
11852: fnd_message.set_token('STATUS',l_meaning);
11853: l_error_msg := fnd_message.get;
11854: handle_error(l_error_code, l_error_msg, l_stmt_num);
11855: l_error_count := l_error_count + 1;
11856: end if;

Line 11853: l_error_msg := fnd_message.get;

11849: and lookup_code = 7
11850: and upper(enabled_flag) = 'Y';
11851:
11852: fnd_message.set_token('STATUS',l_meaning);
11853: l_error_msg := fnd_message.get;
11854: handle_error(l_error_code, l_error_msg, l_stmt_num);
11855: l_error_count := l_error_count + 1;
11856: end if;
11857:

Line 12053: fnd_message.set_name(

12049: x_msg_data := fnd_msg_pub.get(x, 'F');
12050: fnd_file.put_line(fnd_file.log,'Inventory API Error at statement number ' || l_stmt_num || ' : ' || x_msg_data);
12051: end loop;
12052: ELSE
12053: fnd_message.set_name(
12054: application => 'INV',
12055: name => 'INV_PROCESS_FAILED');
12056: fnd_message.set_token(
12057: token => 'PROCESS',

Line 12056: fnd_message.set_token(

12052: ELSE
12053: fnd_message.set_name(
12054: application => 'INV',
12055: name => 'INV_PROCESS_FAILED');
12056: fnd_message.set_token(
12057: token => 'PROCESS',
12058: value => 'TRXNS',
12059: translate => TRUE);
12060: x_msg_data := fnd_message.get;

Line 12060: x_msg_data := fnd_message.get;

12056: fnd_message.set_token(
12057: token => 'PROCESS',
12058: value => 'TRXNS',
12059: translate => TRUE);
12060: x_msg_data := fnd_message.get;
12061: fnd_file.put_line(fnd_file.log,'Inventory API Error at statement number ' || l_stmt_num || ' : ' || x_msg_data);
12062: END IF;
12063: end;
12064:

Line 13160: fnd_message.set_name('WSM','WSM_OP_RES_COSTED');

13156:
13157: exception
13158: when e_res_costed then
13159:
13160: fnd_message.set_name('WSM','WSM_OP_RES_COSTED');
13161: x_error_msg := fnd_message.get;
13162: x_error_code := -1;
13163: fnd_file.put_line(fnd_file.log,'delete_setup_info : ' || l_stmt_num || ' : ' || x_error_msg);
13164:

Line 13161: x_error_msg := fnd_message.get;

13157: exception
13158: when e_res_costed then
13159:
13160: fnd_message.set_name('WSM','WSM_OP_RES_COSTED');
13161: x_error_msg := fnd_message.get;
13162: x_error_code := -1;
13163: fnd_file.put_line(fnd_file.log,'delete_setup_info : ' || l_stmt_num || ' : ' || x_error_msg);
13164:
13165: when others then

Line 13893: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13889: exception
13890:
13891: when e_invalid_res_seq_num then
13892:
13893: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13894: fnd_message.set_token('FLD_NAME', ' resource sequence number ');
13895: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13896:
13897: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 13894: fnd_message.set_token('FLD_NAME', ' resource sequence number ');

13890:
13891: when e_invalid_res_seq_num then
13892:
13893: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13894: fnd_message.set_token('FLD_NAME', ' resource sequence number ');
13895: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13896:
13897: fnd_file.put_line(fnd_file.log,x_error_msg);
13898:

Line 13895: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13891: when e_invalid_res_seq_num then
13892:
13893: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13894: fnd_message.set_token('FLD_NAME', ' resource sequence number ');
13895: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13896:
13897: fnd_file.put_line(fnd_file.log,x_error_msg);
13898:
13899: x_error_code := -1;

Line 13902: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13898:
13899: x_error_code := -1;
13900:
13901: when e_invalid_par_seq then
13902: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13903: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
13904: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13905: fnd_file.put_line(fnd_file.log,x_error_msg);
13906: x_error_code := -1;

Line 13903: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');

13899: x_error_code := -1;
13900:
13901: when e_invalid_par_seq then
13902: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13903: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
13904: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13905: fnd_file.put_line(fnd_file.log,x_error_msg);
13906: x_error_code := -1;
13907:

Line 13904: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13900:
13901: when e_invalid_par_seq then
13902: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13903: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
13904: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13905: fnd_file.put_line(fnd_file.log,x_error_msg);
13906: x_error_code := -1;
13907:
13908: when e_invalid_res then

Line 13911: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13907:
13908: when e_invalid_res then
13909: --Bug 4704351:Resource id validation is already done in the prev sql.So
13910: --this exception is used for resource and department mismatch.
13911: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13912: --fnd_message.set_token('FLD_NAME', ' resource id ');
13913: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
13914: --Set up Resource should be from the same department as Parent Resource
13915: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

Line 13912: --fnd_message.set_token('FLD_NAME', ' resource id ');

13908: when e_invalid_res then
13909: --Bug 4704351:Resource id validation is already done in the prev sql.So
13910: --this exception is used for resource and department mismatch.
13911: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13912: --fnd_message.set_token('FLD_NAME', ' resource id ');
13913: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
13914: --Set up Resource should be from the same department as Parent Resource
13915: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13916: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 13913: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');

13909: --Bug 4704351:Resource id validation is already done in the prev sql.So
13910: --this exception is used for resource and department mismatch.
13911: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13912: --fnd_message.set_token('FLD_NAME', ' resource id ');
13913: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
13914: --Set up Resource should be from the same department as Parent Resource
13915: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13916: fnd_file.put_line(fnd_file.log,x_error_msg);
13917: x_error_code := -1;

Line 13915: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13911: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13912: --fnd_message.set_token('FLD_NAME', ' resource id ');
13913: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
13914: --Set up Resource should be from the same department as Parent Resource
13915: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13916: fnd_file.put_line(fnd_file.log,x_error_msg);
13917: x_error_code := -1;
13918:
13919: when e_invalid_res_dates then

Line 13920: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13916: fnd_file.put_line(fnd_file.log,x_error_msg);
13917: x_error_code := -1;
13918:
13919: when e_invalid_res_dates then
13920: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13921: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
13922: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13923: fnd_file.put_line(fnd_file.log,x_error_msg);
13924: x_error_code := -1;

Line 13921: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');

13917: x_error_code := -1;
13918:
13919: when e_invalid_res_dates then
13920: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13921: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
13922: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13923: fnd_file.put_line(fnd_file.log,x_error_msg);
13924: x_error_code := -1;
13925:

Line 13922: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13918:
13919: when e_invalid_res_dates then
13920: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13921: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
13922: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13923: fnd_file.put_line(fnd_file.log,x_error_msg);
13924: x_error_code := -1;
13925:
13926: when e_invalid_res_seq then

Line 13928: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13924: x_error_code := -1;
13925:
13926: when e_invalid_res_seq then
13927:
13928: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13929: fnd_message.set_token('FLD_NAME', ' resource seq num ');
13930: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13931: fnd_file.put_line(fnd_file.log,x_error_msg);
13932: x_error_code := -1;

Line 13929: fnd_message.set_token('FLD_NAME', ' resource seq num ');

13925:
13926: when e_invalid_res_seq then
13927:
13928: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13929: fnd_message.set_token('FLD_NAME', ' resource seq num ');
13930: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13931: fnd_file.put_line(fnd_file.log,x_error_msg);
13932: x_error_code := -1;
13933:

Line 13930: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13926: when e_invalid_res_seq then
13927:
13928: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13929: fnd_message.set_token('FLD_NAME', ' resource seq num ');
13930: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13931: fnd_file.put_line(fnd_file.log,x_error_msg);
13932: x_error_code := -1;
13933:
13934: when e_invalid_seq then

Line 13935: fnd_message.set_name('WSM','WSM_INVALID_SEQ');

13931: fnd_file.put_line(fnd_file.log,x_error_msg);
13932: x_error_code := -1;
13933:
13934: when e_invalid_seq then
13935: fnd_message.set_name('WSM','WSM_INVALID_SEQ');
13936: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
13937: fnd_file.put_line(fnd_file.log,x_error_msg);
13938: x_error_code := -1;
13939:

Line 13936: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;

13932: x_error_code := -1;
13933:
13934: when e_invalid_seq then
13935: fnd_message.set_name('WSM','WSM_INVALID_SEQ');
13936: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
13937: fnd_file.put_line(fnd_file.log,x_error_msg);
13938: x_error_code := -1;
13939:
13940: when e_invalid_setup_id then

Line 13941: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13937: fnd_file.put_line(fnd_file.log,x_error_msg);
13938: x_error_code := -1;
13939:
13940: when e_invalid_setup_id then
13941: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13942: fnd_message.set_token('FLD_NAME', ' setup id ');
13943: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
13944: fnd_file.put_line(fnd_file.log,x_error_msg);
13945: x_error_code := -1;

Line 13942: fnd_message.set_token('FLD_NAME', ' setup id ');

13938: x_error_code := -1;
13939:
13940: when e_invalid_setup_id then
13941: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13942: fnd_message.set_token('FLD_NAME', ' setup id ');
13943: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
13944: fnd_file.put_line(fnd_file.log,x_error_msg);
13945: x_error_code := -1;
13946:

Line 13943: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;

13939:
13940: when e_invalid_setup_id then
13941: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13942: fnd_message.set_token('FLD_NAME', ' setup id ');
13943: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
13944: fnd_file.put_line(fnd_file.log,x_error_msg);
13945: x_error_code := -1;
13946:
13947: when e_invalid_field then

Line 13949: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13945: x_error_code := -1;
13946:
13947: when e_invalid_field then
13948: /*Modified error handling mechanism for bug 5469917. */
13949: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13950: fnd_message.set_token('FLD_NAME', l_field_name);
13951: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13952: fnd_file.put_line(fnd_file.log,x_error_msg);
13953: x_error_code := -1;

Line 13950: fnd_message.set_token('FLD_NAME', l_field_name);

13946:
13947: when e_invalid_field then
13948: /*Modified error handling mechanism for bug 5469917. */
13949: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13950: fnd_message.set_token('FLD_NAME', l_field_name);
13951: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13952: fnd_file.put_line(fnd_file.log,x_error_msg);
13953: x_error_code := -1;
13954:

Line 13951: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13947: when e_invalid_field then
13948: /*Modified error handling mechanism for bug 5469917. */
13949: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13950: fnd_message.set_token('FLD_NAME', l_field_name);
13951: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13952: fnd_file.put_line(fnd_file.log,x_error_msg);
13953: x_error_code := -1;
13954:
13955: when e_invalid_max_assg_units then

Line 13957: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13953: x_error_code := -1;
13954:
13955: when e_invalid_max_assg_units then
13956:
13957: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13958: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
13959: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13960: fnd_file.put_line(fnd_file.log,x_error_msg);
13961: x_error_code := -1;

Line 13958: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');

13954:
13955: when e_invalid_max_assg_units then
13956:
13957: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13958: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
13959: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13960: fnd_file.put_line(fnd_file.log,x_error_msg);
13961: x_error_code := -1;
13962:

Line 13959: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13955: when e_invalid_max_assg_units then
13956:
13957: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13958: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
13959: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13960: fnd_file.put_line(fnd_file.log,x_error_msg);
13961: x_error_code := -1;
13962:
13963: when e_invalid_setup_max_assg_units then

Line 13965: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');

13961: x_error_code := -1;
13962:
13963: when e_invalid_setup_max_assg_units then
13964:
13965: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
13966:
13967: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13968:
13969: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 13967: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13963: when e_invalid_setup_max_assg_units then
13964:
13965: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
13966:
13967: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13968:
13969: fnd_file.put_line(fnd_file.log,x_error_msg);
13970: x_error_code := -1;
13971:

Line 13974: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');

13970: x_error_code := -1;
13971:
13972: when e_setup_costed then
13973:
13974: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
13975:
13976: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13977: fnd_file.put_line(fnd_file.log,x_error_msg);
13978: x_error_code := -1;

Line 13976: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13972: when e_setup_costed then
13973:
13974: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
13975:
13976: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13977: fnd_file.put_line(fnd_file.log,x_error_msg);
13978: x_error_code := -1;
13979:
13980: when e_invalid_batch_max_assg_units then

Line 13982: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');

13978: x_error_code := -1;
13979:
13980: when e_invalid_batch_max_assg_units then
13981:
13982: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
13983:
13984: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13985: x_error_code := -1;
13986: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 13984: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13980: when e_invalid_batch_max_assg_units then
13981:
13982: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
13983:
13984: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13985: x_error_code := -1;
13986: fnd_file.put_line(fnd_file.log,x_error_msg);
13987:
13988: when e_res_not_batchable then

Line 13990: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

13986: fnd_file.put_line(fnd_file.log,x_error_msg);
13987:
13988: when e_res_not_batchable then
13989:
13990: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13991: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
13992:
13993: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13994: fnd_file.put_line(fnd_file.log,x_error_msg);

Line 13991: fnd_message.set_token('FLD_NAME', ' batch id for resource ');

13987:
13988: when e_res_not_batchable then
13989:
13990: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13991: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
13992:
13993: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13994: fnd_file.put_line(fnd_file.log,x_error_msg);
13995: x_error_code := -1;

Line 13993: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13989:
13990: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13991: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
13992:
13993: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
13994: fnd_file.put_line(fnd_file.log,x_error_msg);
13995: x_error_code := -1;
13996:
13997: when e_no_po_move_res then

Line 13998: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');

13994: fnd_file.put_line(fnd_file.log,x_error_msg);
13995: x_error_code := -1;
13996:
13997: when e_no_po_move_res then
13998: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
13999: fnd_message.set_token('FLD_NAME', ' resource ');
14000: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14001: fnd_file.put_line(fnd_file.log,x_error_msg);
14002: x_error_code := -1;

Line 13999: fnd_message.set_token('FLD_NAME', ' resource ');

13995: x_error_code := -1;
13996:
13997: when e_no_po_move_res then
13998: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
13999: fnd_message.set_token('FLD_NAME', ' resource ');
14000: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14001: fnd_file.put_line(fnd_file.log,x_error_msg);
14002: x_error_code := -1;
14003:

Line 14000: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

13996:
13997: when e_no_po_move_res then
13998: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
13999: fnd_message.set_token('FLD_NAME', ' resource ');
14000: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14001: fnd_file.put_line(fnd_file.log,x_error_msg);
14002: x_error_code := -1;
14003:
14004: when others then

Line 14198: fnd_message.set_name('WSM','WSM_NULL_FIELD');

14194:
14195: end if;
14196: else
14197: /* error out.... */
14198: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14199: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14200: x_error_msg := fnd_message.get;
14201: x_error_code := -1;
14202: return; --raise e_wljdi_common_error;

Line 14199: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');

14195: end if;
14196: else
14197: /* error out.... */
14198: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14199: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14200: x_error_msg := fnd_message.get;
14201: x_error_code := -1;
14202: return; --raise e_wljdi_common_error;
14203: end if;

Line 14200: x_error_msg := fnd_message.get;

14196: else
14197: /* error out.... */
14198: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14199: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14200: x_error_msg := fnd_message.get;
14201: x_error_code := -1;
14202: return; --raise e_wljdi_common_error;
14203: end if;
14204: l_stmt_num := 80;

Line 14556: fnd_message.set_name('WSM','WSM_NULL_FIELD');

14552:
14553: else
14554:
14555: /* error out.... cannt delete previous op resources.... */
14556: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14557: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14558: x_error_msg := fnd_message.get;
14559: x_error_code := -1;
14560: return; --raise e_wljdi_common_error;

Line 14557: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');

14553: else
14554:
14555: /* error out.... cannt delete previous op resources.... */
14556: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14557: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14558: x_error_msg := fnd_message.get;
14559: x_error_code := -1;
14560: return; --raise e_wljdi_common_error;
14561:

Line 14558: x_error_msg := fnd_message.get;

14554:
14555: /* error out.... cannt delete previous op resources.... */
14556: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14557: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14558: x_error_msg := fnd_message.get;
14559: x_error_code := -1;
14560: return; --raise e_wljdi_common_error;
14561:
14562: end if;

Line 15701: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

15697: l_res_ins_first := l_d;
15698: end if;
15699:
15700: else
15701: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
15702: fnd_message.set_token('FLD_NAME', 'Load_type');
15703: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
15704: || fnd_message.get;
15705: p_error_code := -1;

Line 15702: fnd_message.set_token('FLD_NAME', 'Load_type');

15698: end if;
15699:
15700: else
15701: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
15702: fnd_message.set_token('FLD_NAME', 'Load_type');
15703: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
15704: || fnd_message.get;
15705: p_error_code := -1;
15706: raise e_wljdi_common_error;

Line 15704: || fnd_message.get;

15700: else
15701: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
15702: fnd_message.set_token('FLD_NAME', 'Load_type');
15703: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
15704: || fnd_message.get;
15705: p_error_code := -1;
15706: raise e_wljdi_common_error;
15707: end if;
15708: ---------------------------------------------------------------------------

Line 15743: fnd_message.set_name('WSM','WSM_NULL_FIELD');

15739: end if;
15740:
15741: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
15742: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
15743: fnd_message.set_name('WSM','WSM_NULL_FIELD');
15744: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
15745: p_error_msg := fnd_message.get;
15746: p_error_code := - 1;
15747: raise e_wljdi_common_error;

Line 15744: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');

15740:
15741: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
15742: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
15743: fnd_message.set_name('WSM','WSM_NULL_FIELD');
15744: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
15745: p_error_msg := fnd_message.get;
15746: p_error_code := - 1;
15747: raise e_wljdi_common_error;
15748: end if;

Line 15745: p_error_msg := fnd_message.get;

15741: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
15742: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
15743: fnd_message.set_name('WSM','WSM_NULL_FIELD');
15744: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
15745: p_error_msg := fnd_message.get;
15746: p_error_code := - 1;
15747: raise e_wljdi_common_error;
15748: end if;
15749: else

Line 15925: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');

15921: FROM bom_std_sub_op_resources bsor
15922: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
15923: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE);
15924: if l_temp=1 then
15925: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
15926: p_error_msg := fnd_message.get;
15927: p_error_code := - 1;
15928: raise e_wljdi_common_error;
15929: end if;

Line 15926: p_error_msg := fnd_message.get;

15922: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
15923: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE);
15924: if l_temp=1 then
15925: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
15926: p_error_msg := fnd_message.get;
15927: p_error_code := - 1;
15928: raise e_wljdi_common_error;
15929: end if;
15930: exception

Line 15934: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');

15930: exception
15931: when no_data_found then
15932: null;
15933: when others then
15934: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
15935: p_error_msg := fnd_message.get;
15936: p_error_code := - 1;
15937: raise e_wljdi_common_error;
15938: end;

Line 15935: p_error_msg := fnd_message.get;

15931: when no_data_found then
15932: null;
15933: when others then
15934: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
15935: p_error_msg := fnd_message.get;
15936: p_error_code := - 1;
15937: raise e_wljdi_common_error;
15938: end;
15939: l_temp :=0;

Line 16288: fnd_message.set_name('WSM','WSM_INV_DEL_LINK');

16284: and from_op_seq_num= v_wljdi_routing_op_seq_num(l_d)
16285: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16286:
16287: if sql%notfound then
16288: fnd_message.set_name('WSM','WSM_INV_DEL_LINK');
16289: p_error_msg := fnd_message.get;
16290: p_error_code := - 1;
16291: raise e_wljdi_common_error;
16292: end if;

Line 16289: p_error_msg := fnd_message.get;

16285: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16286:
16287: if sql%notfound then
16288: fnd_message.set_name('WSM','WSM_INV_DEL_LINK');
16289: p_error_msg := fnd_message.get;
16290: p_error_code := - 1;
16291: raise e_wljdi_common_error;
16292: end if;
16293: else /* This is for substitution_type add. */

Line 16304: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');

16300: exception
16301: when no_data_found then
16302: l_link_exists := 0;
16303: when too_many_rows then
16304: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16305: p_error_msg := fnd_message.get;
16306: p_error_code := - 1;
16307: raise e_wljdi_common_error;
16308: end;

Line 16305: p_error_msg := fnd_message.get;

16301: when no_data_found then
16302: l_link_exists := 0;
16303: when too_many_rows then
16304: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16305: p_error_msg := fnd_message.get;
16306: p_error_code := - 1;
16307: raise e_wljdi_common_error;
16308: end;
16309:

Line 16311: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');

16307: raise e_wljdi_common_error;
16308: end;
16309:
16310: if l_link_exists <> 0 then
16311: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16312: p_error_msg := fnd_message.get;
16313: p_error_code := - 1;
16314: raise e_wljdi_common_error;
16315: end if;

Line 16312: p_error_msg := fnd_message.get;

16308: end;
16309:
16310: if l_link_exists <> 0 then
16311: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16312: p_error_msg := fnd_message.get;
16313: p_error_code := - 1;
16314: raise e_wljdi_common_error;
16315: end if;
16316:

Line 16333: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');

16329: and operation_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16330:
16331: exception
16332: when no_data_found then
16333: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16334: p_error_msg := fnd_message.get;
16335: p_error_code := - 1;
16336: raise e_wljdi_common_error;
16337: when others then

Line 16334: p_error_msg := fnd_message.get;

16330:
16331: exception
16332: when no_data_found then
16333: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16334: p_error_msg := fnd_message.get;
16335: p_error_code := - 1;
16336: raise e_wljdi_common_error;
16337: when others then
16338: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');

Line 16338: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');

16334: p_error_msg := fnd_message.get;
16335: p_error_code := - 1;
16336: raise e_wljdi_common_error;
16337: when others then
16338: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');
16339: p_error_msg := fnd_message.get;
16340: p_error_code := - 1;
16341: raise e_wljdi_common_error;
16342: end;

Line 16339: p_error_msg := fnd_message.get;

16335: p_error_code := - 1;
16336: raise e_wljdi_common_error;
16337: when others then
16338: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');
16339: p_error_msg := fnd_message.get;
16340: p_error_code := - 1;
16341: raise e_wljdi_common_error;
16342: end;
16343:

Line 16529: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

16525: raise e_invalid_recommend_path;
16526: end if;
16527: else
16528: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16529: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16530: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16531: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16532: p_error_code := - 1;
16533: raise e_wljdi_common_error;

Line 16530: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');

16526: end if;
16527: else
16528: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16529: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16530: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16531: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16532: p_error_code := - 1;
16533: raise e_wljdi_common_error;
16534: end if;

Line 16531: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;

16527: else
16528: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16529: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16530: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16531: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16532: p_error_code := - 1;
16533: raise e_wljdi_common_error;
16534: end if;
16535: end if;

Line 16955: fnd_message.set_name('WSM','WSM_NULL_FIELD');

16951: -- Added For LBJ Interface Alcoa Enhancement
16952: else
16953: if l_sub_type = WSM_SUB_DEL then
16954: if l_rtg_op_seq_num is null then
16955: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16956: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
16957: p_error_msg := fnd_message.get;
16958: p_error_code := -1;
16959: raise e_wljdi_common_error;

Line 16956: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');

16952: else
16953: if l_sub_type = WSM_SUB_DEL then
16954: if l_rtg_op_seq_num is null then
16955: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16956: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
16957: p_error_msg := fnd_message.get;
16958: p_error_code := -1;
16959: raise e_wljdi_common_error;
16960: else

Line 16957: p_error_msg := fnd_message.get;

16953: if l_sub_type = WSM_SUB_DEL then
16954: if l_rtg_op_seq_num is null then
16955: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16956: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
16957: p_error_msg := fnd_message.get;
16958: p_error_code := -1;
16959: raise e_wljdi_common_error;
16960: else
16961: -- Validate for start or end operation.

Line 16973: fnd_message.set_name('WSM','WSM_NW_START_END_NO_DEL');

16969: and wco.operation_seq_num = l_rtg_op_seq_num
16970: and wco.network_start_end is null;
16971: exception
16972: when others then
16973: fnd_message.set_name('WSM','WSM_NW_START_END_NO_DEL');
16974: p_error_msg := fnd_message.get;
16975: p_error_code := -1;
16976: raise e_wljdi_common_error;
16977: end;

Line 16974: p_error_msg := fnd_message.get;

16970: and wco.network_start_end is null;
16971: exception
16972: when others then
16973: fnd_message.set_name('WSM','WSM_NW_START_END_NO_DEL');
16974: p_error_msg := fnd_message.get;
16975: p_error_code := -1;
16976: raise e_wljdi_common_error;
16977: end;
16978: -- Validate for any existing links with this operation.

Line 16998: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');

16994: and to_op_seq_num = l_rtg_op_seq_num);
16995:
16996: if l_temp=1 THEN
16997:
16998: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
16999: p_error_msg := fnd_message.get;
17000: p_error_code := -1;
17001: raise e_wljdi_common_error;
17002: end if;

Line 16999: p_error_msg := fnd_message.get;

16995:
16996: if l_temp=1 THEN
16997:
16998: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
16999: p_error_msg := fnd_message.get;
17000: p_error_code := -1;
17001: raise e_wljdi_common_error;
17002: end if;
17003:

Line 17008: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');

17004: exception
17005: when no_data_found then
17006: null;
17007: when others then
17008: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17009: p_error_msg := fnd_message.get;
17010: p_error_code := -1;
17011: raise e_wljdi_common_error;
17012: end;

Line 17009: p_error_msg := fnd_message.get;

17005: when no_data_found then
17006: null;
17007: when others then
17008: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17009: p_error_msg := fnd_message.get;
17010: p_error_code := -1;
17011: raise e_wljdi_common_error;
17012: end;
17013: end if;

Line 18042: fnd_message.set_name(application => 'WIP',

18038: when too_many_rows then
18039: l_exists := 1;
18040: end;
18041: if(l_exists = 1) then
18042: fnd_message.set_name(application => 'WIP',
18043: name => 'WIP_REPLACE_APPLIED_RES');
18044: p_error_msg := fnd_message.get;
18045: p_error_code := -1;
18046: raise e_wljdi_common_error;

Line 18044: p_error_msg := fnd_message.get;

18040: end;
18041: if(l_exists = 1) then
18042: fnd_message.set_name(application => 'WIP',
18043: name => 'WIP_REPLACE_APPLIED_RES');
18044: p_error_msg := fnd_message.get;
18045: p_error_code := -1;
18046: raise e_wljdi_common_error;
18047: end if;
18048: l_stmt_num := 250.5;

Line 19334: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');

19330: if l_sub_type in (WSM_SUB_DEL, WSM_SUB_ADD) then
19331: -- Modified for Alcoa Enhancement
19332: -- if(l_job_op_seq_num IS NULL) then
19333: --l_stmt_num := 510;
19334: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19335: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19336: -- p_error_msg := fnd_message.get;
19337: -- p_error_code := -1;
19338: -- raise e_wljdi_common_error;

Line 19335: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');

19331: -- Modified for Alcoa Enhancement
19332: -- if(l_job_op_seq_num IS NULL) then
19333: --l_stmt_num := 510;
19334: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19335: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19336: -- p_error_msg := fnd_message.get;
19337: -- p_error_code := -1;
19338: -- raise e_wljdi_common_error;
19339: -- else

Line 19336: -- p_error_msg := fnd_message.get;

19332: -- if(l_job_op_seq_num IS NULL) then
19333: --l_stmt_num := 510;
19334: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19335: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19336: -- p_error_msg := fnd_message.get;
19337: -- p_error_code := -1;
19338: -- raise e_wljdi_common_error;
19339: -- else
19340: -- fnd_file.put_line(fnd_file.log,

Line 19830: fnd_message.set_name('WSM','WSM_COMP_USE_PHANTOM_RTG');

19826: FROM BOM_PARAMETERS
19827: WHERE ORGANIZATION_ID = p_org_id;
19828:
19829: IF (l_use_phantom_routings = 1 and l_sub_type = WSM_SUB_REC) THEN
19830: fnd_message.set_name('WSM','WSM_COMP_USE_PHANTOM_RTG');
19831: p_error_msg := fnd_message.get;
19832: p_error_code := -1;
19833: raise e_wljdi_common_error;
19834: end if;

Line 19831: p_error_msg := fnd_message.get;

19827: WHERE ORGANIZATION_ID = p_org_id;
19828:
19829: IF (l_use_phantom_routings = 1 and l_sub_type = WSM_SUB_REC) THEN
19830: fnd_message.set_name('WSM','WSM_COMP_USE_PHANTOM_RTG');
19831: p_error_msg := fnd_message.get;
19832: p_error_code := -1;
19833: raise e_wljdi_common_error;
19834: end if;
19835:

Line 19994: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');

19990:
19991: EXCEPTION
19992: when e_invalid_recommend_path then
19993: ROLLBACK to start_import_details;
19994: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
19995: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
19996: || fnd_message.get;
19997: p_error_code := -1;
19998: fnd_file.put_line(fnd_file.log,

Line 19996: || fnd_message.get;

19992: when e_invalid_recommend_path then
19993: ROLLBACK to start_import_details;
19994: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
19995: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
19996: || fnd_message.get;
19997: p_error_code := -1;
19998: fnd_file.put_line(fnd_file.log,
19999: substr('import_lot_job_details: (#'||l_stmt_num||') '
20000: || p_error_msg, 1, 2000));

Line 20004: fnd_message.set_name('WSM','WSM_INVALID_DISCO_LINK');

20000: || p_error_msg, 1, 2000));
20001:
20002: when e_invalid_discommend_path then
20003: ROLLBACK to start_import_details;
20004: fnd_message.set_name('WSM','WSM_INVALID_DISCO_LINK');
20005: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20006: || fnd_message.get;
20007: p_error_code := -1;
20008: fnd_file.put_line(fnd_file.log,

Line 20006: || fnd_message.get;

20002: when e_invalid_discommend_path then
20003: ROLLBACK to start_import_details;
20004: fnd_message.set_name('WSM','WSM_INVALID_DISCO_LINK');
20005: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20006: || fnd_message.get;
20007: p_error_code := -1;
20008: fnd_file.put_line(fnd_file.log,
20009: substr('import_lot_job_details: (#'||l_stmt_num||') '
20010: || p_error_msg, 1, 2000));

Line 20015: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

20011:
20012:
20013: when e_invalid_sub_load_type then
20014: ROLLBACK to start_import_details;
20015: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20016: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20017: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20018: || fnd_message.get;
20019: p_error_code := -1;

Line 20016: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');

20012:
20013: when e_invalid_sub_load_type then
20014: ROLLBACK to start_import_details;
20015: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20016: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20017: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20018: || fnd_message.get;
20019: p_error_code := -1;
20020: fnd_file.put_line(fnd_file.log,

Line 20018: || fnd_message.get;

20014: ROLLBACK to start_import_details;
20015: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20016: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20017: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20018: || fnd_message.get;
20019: p_error_code := -1;
20020: fnd_file.put_line(fnd_file.log,
20021: substr('import_lot_job_details: (#'||l_stmt_num||') '
20022: || p_error_msg, 1, 2000));

Line 20026: fnd_message.set_name('WSM','WSM_NULL_FIELD');

20022: || p_error_msg, 1, 2000));
20023:
20024: when e_invalid_op_seq_num then
20025: ROLLBACK to start_import_details;
20026: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20027: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20028: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20029: || fnd_message.get;
20030: p_error_code := -1;

Line 20027: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');

20023:
20024: when e_invalid_op_seq_num then
20025: ROLLBACK to start_import_details;
20026: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20027: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20028: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20029: || fnd_message.get;
20030: p_error_code := -1;
20031: fnd_file.put_line(fnd_file.log,

Line 20029: || fnd_message.get;

20025: ROLLBACK to start_import_details;
20026: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20027: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20028: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20029: || fnd_message.get;
20030: p_error_code := -1;
20031: fnd_file.put_line(fnd_file.log,
20032: substr('import_lot_job_details: (#'||l_stmt_num||') '
20033: || p_error_msg, 1, 2000));

Line 20046: fnd_message.set_name('WSM','WSM_NULL_FIELD');

20042: || p_error_msg, 1, 2000));
20043:
20044: when e_null_comp_seq_id then
20045: ROLLBACK to start_import_details;
20046: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20047: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20048: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20049: || fnd_message.get;
20050: p_error_code := -1;

Line 20047: fnd_message.set_token('FLD_NAME', 'component_seq_id');

20043:
20044: when e_null_comp_seq_id then
20045: ROLLBACK to start_import_details;
20046: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20047: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20048: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20049: || fnd_message.get;
20050: p_error_code := -1;
20051: fnd_file.put_line(fnd_file.log,

Line 20049: || fnd_message.get;

20045: ROLLBACK to start_import_details;
20046: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20047: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20048: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20049: || fnd_message.get;
20050: p_error_code := -1;
20051: fnd_file.put_line(fnd_file.log,
20052: substr('import_lot_job_details: (#'||l_stmt_num||') '
20053: || p_error_msg, 1, 2000));

Line 20448: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

20444: -- p_organization_id => p_organization_id,
20445: -- p_date => trunc(nvl(p_release_date, sysdate)) );
20446: --if(p_error_code <> 0) then
20447: -- p_error_code := -1;
20448: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20449: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20450: -- p_err_msg := fnd_message.get;
20451: -- return;
20452: --end if;

Line 20449: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');

20445: -- p_date => trunc(nvl(p_release_date, sysdate)) );
20446: --if(p_error_code <> 0) then
20447: -- p_error_code := -1;
20448: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20449: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20450: -- p_err_msg := fnd_message.get;
20451: -- return;
20452: --end if;
20453: -- ED: bugfix 3299811

Line 20450: -- p_err_msg := fnd_message.get;

20446: --if(p_error_code <> 0) then
20447: -- p_error_code := -1;
20448: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20449: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20450: -- p_err_msg := fnd_message.get;
20451: -- return;
20452: --end if;
20453: -- ED: bugfix 3299811
20454:

Line 20548: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

20544:
20545: --if SQL%NOTFOUND then -- bug 3571360
20546: if l_cnt <= 0 then -- bug 3571360
20547: p_error_code := -1;
20548: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20549: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20550: p_err_msg := fnd_message.get;
20551: end if;
20552:

Line 20549: fnd_message.set_token('FLD_NAME','Wip Accounting Period');

20545: --if SQL%NOTFOUND then -- bug 3571360
20546: if l_cnt <= 0 then -- bug 3571360
20547: p_error_code := -1;
20548: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20549: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20550: p_err_msg := fnd_message.get;
20551: end if;
20552:
20553: exception

Line 20550: p_err_msg := fnd_message.get;

20546: if l_cnt <= 0 then -- bug 3571360
20547: p_error_code := -1;
20548: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
20549: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
20550: p_err_msg := fnd_message.get;
20551: end if;
20552:
20553: exception
20554: when others then

Line 20671: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');

20667: p_routing_rev_date => p_routing_revision_date,
20668: x_err_code => p_error_code,
20669: x_err_msg => p_error_msg)
20670: then
20671: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
20672: p_error_code := -1;
20673: p_error_msg := fnd_message.get;
20674: raise e_build_job_dtl;
20675: end if;

Line 20673: p_error_msg := fnd_message.get;

20669: x_err_msg => p_error_msg)
20670: then
20671: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
20672: p_error_code := -1;
20673: p_error_msg := fnd_message.get;
20674: raise e_build_job_dtl;
20675: end if;
20676: end if;
20677: --osp end

Line 21033: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');

21029: p_org_id => p_org_id,
21030: p_job_type => p_job_type) = 1 and
21031: (l_est_scrap_account is null or l_est_scrap_var_account is null)
21032: then
21033: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21034: fnd_message.set_token('CC',p_class_code);
21035: p_error_code := -1;
21036: p_error_msg := fnd_message.get;
21037: raise e_build_job;

Line 21034: fnd_message.set_token('CC',p_class_code);

21030: p_job_type => p_job_type) = 1 and
21031: (l_est_scrap_account is null or l_est_scrap_var_account is null)
21032: then
21033: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21034: fnd_message.set_token('CC',p_class_code);
21035: p_error_code := -1;
21036: p_error_msg := fnd_message.get;
21037: raise e_build_job;
21038: end if;

Line 21036: p_error_msg := fnd_message.get;

21032: then
21033: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21034: fnd_message.set_token('CC',p_class_code);
21035: p_error_code := -1;
21036: p_error_msg := fnd_message.get;
21037: raise e_build_job;
21038: end if;
21039:
21040:

Line 21298: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');

21294: mtl_gen_object_id_s.nextval
21295: );
21296: exception
21297: when others then
21298: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');
21299: p_error_code := -1;
21300: p_error_msg := fnd_message.get;
21301: raise e_build_job;
21302: end;

Line 21300: p_error_msg := fnd_message.get;

21296: exception
21297: when others then
21298: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');
21299: p_error_code := -1;
21300: p_error_msg := fnd_message.get;
21301: raise e_build_job;
21302: end;
21303: if lbji_debug = 'Y' then
21304: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into we');

Line 21329: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');

21325: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
21326: and lookup_code = 5
21327: and upper(enabled_flag) = 'Y';
21328:
21329: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21330: fnd_message.set_token('STATUS',l_translated_meaning);
21331: p_error_code := -1;
21332: p_error_msg := fnd_message.get;
21333: raise e_build_job;

Line 21330: fnd_message.set_token('STATUS',l_translated_meaning);

21326: and lookup_code = 5
21327: and upper(enabled_flag) = 'Y';
21328:
21329: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21330: fnd_message.set_token('STATUS',l_translated_meaning);
21331: p_error_code := -1;
21332: p_error_msg := fnd_message.get;
21333: raise e_build_job;
21334: end if;

Line 21332: p_error_msg := fnd_message.get;

21328:
21329: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21330: fnd_message.set_token('STATUS',l_translated_meaning);
21331: p_error_code := -1;
21332: p_error_msg := fnd_message.get;
21333: raise e_build_job;
21334: end if;
21335: end if;
21336: