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

APPS.WSM_LBJ_INTERFACE_PVT dependencies on FND_MESSAGE

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

763:
764: BEGIN
765: v_wlji_process_status(v_idx) := 3;
766: v_wlji_err_code(v_idx) := -1;
767: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
768: fnd_message.set_token('FLD_NAME', p_field);
769: l_err_msg := fnd_message.get;
770: v_wlji_err_msg(v_idx) := l_err_msg;
771: fnd_file.put_line(fnd_file.log,

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

764: BEGIN
765: v_wlji_process_status(v_idx) := 3;
766: v_wlji_err_code(v_idx) := -1;
767: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
768: fnd_message.set_token('FLD_NAME', p_field);
769: l_err_msg := fnd_message.get;
770: v_wlji_err_msg(v_idx) := l_err_msg;
771: fnd_file.put_line(fnd_file.log,
772: 'Error: (stmt_num: '|| stmt_number ||') '||l_err_msg||' '||p_aux_string);

Line 769: l_err_msg := fnd_message.get;

765: v_wlji_process_status(v_idx) := 3;
766: v_wlji_err_code(v_idx) := -1;
767: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
768: fnd_message.set_token('FLD_NAME', p_field);
769: l_err_msg := fnd_message.get;
770: v_wlji_err_msg(v_idx) := l_err_msg;
771: fnd_file.put_line(fnd_file.log,
772: 'Error: (stmt_num: '|| stmt_number ||') '||l_err_msg||' '||p_aux_string);
773: fnd_file.new_line(fnd_file.log, 3);

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

791:
792: BEGIN
793: v_wlji_process_status(v_idx) := 3; --ERROR
794: v_wlji_err_code(v_idx) := -1;
795: fnd_message.set_name(p_product, p_message_name);
796: l_err_msg := fnd_message.get;
797: v_wlji_err_msg(v_idx) := l_err_msg;
798: fnd_file.put_line(fnd_file.log,
799: 'Error: (stmt_num: '|| stmt_number||') '||l_err_msg);

Line 796: l_err_msg := fnd_message.get;

792: BEGIN
793: v_wlji_process_status(v_idx) := 3; --ERROR
794: v_wlji_err_code(v_idx) := -1;
795: fnd_message.set_name(p_product, p_message_name);
796: l_err_msg := fnd_message.get;
797: v_wlji_err_msg(v_idx) := l_err_msg;
798: fnd_file.put_line(fnd_file.log,
799: 'Error: (stmt_num: '|| stmt_number||') '||l_err_msg);
800: fnd_file.new_line(fnd_file.log, 3);

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

873:
874: exception
875: when no_data_found then
876: x_err_code := -2;
877: fnd_message.set_name('wsm','wsm_net_start_not_found');
878: x_err_msg:= fnd_message.get;
879: return;
880:
881: when others then

Line 878: x_err_msg:= fnd_message.get;

874: exception
875: when no_data_found then
876: x_err_code := -2;
877: fnd_message.set_name('wsm','wsm_net_start_not_found');
878: x_err_msg:= fnd_message.get;
879: return;
880:
881: when others then
882: x_err_code := sqlcode;

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

912:
913: exception
914: when no_data_found then
915: x_err_code := -2;
916: fnd_message.set_name('wsm','wsm_net_end_not_found');
917: x_err_msg:= fnd_message.get;
918: return;
919:
920: when others then

Line 917: x_err_msg:= fnd_message.get;

913: exception
914: when no_data_found then
915: x_err_code := -2;
916: fnd_message.set_name('wsm','wsm_net_end_not_found');
917: x_err_msg:= fnd_message.get;
918: return;
919:
920: when others then
921: x_err_code := sqlcode;

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

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

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

972: l_stmt_num := 10;
973: if p_org_id IS NULL then
974: if p_org_code IS NULL then
975: fnd_message.set_name('WSM','WSM_NULL_FIELD');
976: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');
977: x_error_msg := fnd_message.get;
978: x_error_code := -1;
979: return;
980: end if;

Line 977: x_error_msg := fnd_message.get;

973: if p_org_id IS NULL then
974: if p_org_code IS NULL then
975: fnd_message.set_name('WSM','WSM_NULL_FIELD');
976: fnd_message.set_token('FLD_NAME', 'Organization ID and Code');
977: x_error_msg := fnd_message.get;
978: x_error_code := -1;
979: return;
980: end if;
981:

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

992: where organization_code = p_org_code;
993: -- bug 5051885
994: exception
995: when others then
996: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
997: fnd_message.set_token('FLD_NAME', 'Organization Code');
998: x_error_msg := fnd_message.get;
999: x_error_code := -1;
1000: return;

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

993: -- bug 5051885
994: exception
995: when others then
996: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
997: fnd_message.set_token('FLD_NAME', 'Organization Code');
998: x_error_msg := fnd_message.get;
999: x_error_code := -1;
1000: return;
1001: end;

Line 998: x_error_msg := fnd_message.get;

994: exception
995: when others then
996: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
997: fnd_message.set_token('FLD_NAME', 'Organization Code');
998: x_error_msg := fnd_message.get;
999: x_error_code := -1;
1000: return;
1001: end;
1002: else

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

1007: -- now p_org_id is always available
1008: l_xst := true;
1009: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1010: if l_xst = false then
1011: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1012: fnd_message.set_token('FLD_NAME', 'Organization ID');
1013: x_error_msg := fnd_message.get;
1014: x_error_code := -1;
1015: return;

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

1008: l_xst := true;
1009: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1010: if l_xst = false then
1011: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1012: fnd_message.set_token('FLD_NAME', 'Organization ID');
1013: x_error_msg := fnd_message.get;
1014: x_error_code := -1;
1015: return;
1016: end if;

Line 1013: x_error_msg := fnd_message.get;

1009: l_xst := WSMPLCVA.v_org.exists(p_org_id);
1010: if l_xst = false then
1011: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1012: fnd_message.set_token('FLD_NAME', 'Organization ID');
1013: x_error_msg := fnd_message.get;
1014: x_error_code := -1;
1015: return;
1016: end if;
1017: EXCEPTION

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

1015: return;
1016: end if;
1017: EXCEPTION
1018: when others then
1019: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1020: fnd_message.set_token('FLD_NAME', 'Organization ID');
1021: x_error_msg := fnd_message.get;
1022: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1023: x_error_code := -1;

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

1016: end if;
1017: EXCEPTION
1018: when others then
1019: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1020: fnd_message.set_token('FLD_NAME', 'Organization ID');
1021: x_error_msg := fnd_message.get;
1022: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1023: x_error_code := -1;
1024: END validate_org_id_name;

Line 1021: x_error_msg := fnd_message.get;

1017: EXCEPTION
1018: when others then
1019: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1020: fnd_message.set_token('FLD_NAME', 'Organization ID');
1021: x_error_msg := fnd_message.get;
1022: x_error_msg := 'validate_org_id_name (#' || l_stmt_num || ') ' || x_error_msg ;
1023: x_error_code := -1;
1024: END validate_org_id_name;
1025:

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

1056:
1057: l_stmt_num := 10;
1058: -- Start : Fix for OPMConv project --
1059: -- if LENGTH(p_job_name) > 30 then
1060: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1061:
1062: if LENGTH(p_job_name) > 80 then
1063: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1064: fnd_message.set_token('FLD_NAME', 'Job Name');

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

1059: -- if LENGTH(p_job_name) > 30 then
1060: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1061:
1062: if LENGTH(p_job_name) > 80 then
1063: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1064: fnd_message.set_token('FLD_NAME', 'Job Name');
1065: fnd_message.set_token('VALUE', '80');
1066: x_error_msg := fnd_message.get;
1067: x_error_code := -1;

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

1060: -- fnd_message.set_name('WSM','WSM_JOB_NAME_THIRTY_CHAR');
1061:
1062: if LENGTH(p_job_name) > 80 then
1063: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1064: fnd_message.set_token('FLD_NAME', 'Job Name');
1065: fnd_message.set_token('VALUE', '80');
1066: x_error_msg := fnd_message.get;
1067: x_error_code := -1;
1068: return;

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

1061:
1062: if LENGTH(p_job_name) > 80 then
1063: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1064: fnd_message.set_token('FLD_NAME', 'Job Name');
1065: fnd_message.set_token('VALUE', '80');
1066: x_error_msg := fnd_message.get;
1067: x_error_code := -1;
1068: return;
1069: end if;

Line 1066: x_error_msg := fnd_message.get;

1062: if LENGTH(p_job_name) > 80 then
1063: fnd_message.set_name('WSM','WSM_EXCEED_MAX_LEN');
1064: fnd_message.set_token('FLD_NAME', 'Job Name');
1065: fnd_message.set_token('VALUE', '80');
1066: x_error_msg := fnd_message.get;
1067: x_error_code := -1;
1068: return;
1069: end if;
1070: -- End : Fix for OPMConv project --

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

1087: from wip_entities
1088: where wip_entity_name = p_job_name
1089: and organization_id = p_org_id;
1090: if l_temp_num = 1 then
1091: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1092: x_error_msg := fnd_message.get;
1093: x_error_code := -1;
1094: return;
1095: end if;

Line 1092: x_error_msg := fnd_message.get;

1088: where wip_entity_name = p_job_name
1089: and organization_id = p_org_id;
1090: if l_temp_num = 1 then
1091: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1092: x_error_msg := fnd_message.get;
1093: x_error_code := -1;
1094: return;
1095: end if;
1096: exception

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

1096: exception
1097: when no_data_found then
1098: null;
1099: when others then
1100: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1101: x_error_msg := fnd_message.get;
1102: x_error_code := -1;
1103: return;
1104: end;

Line 1101: x_error_msg := fnd_message.get;

1097: when no_data_found then
1098: null;
1099: when others then
1100: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1101: x_error_msg := fnd_message.get;
1102: x_error_code := -1;
1103: return;
1104: end;
1105: p_wip_entity_id := null; -- Ignore wip_entity_id

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

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

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

1109: l_xst := false;
1110: if p_wip_entity_id is null then
1111: if p_job_name is null then
1112: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1113: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');
1114: x_error_msg := fnd_message.get;
1115: x_error_code := -1;
1116: return;
1117: end if;

Line 1114: x_error_msg := fnd_message.get;

1110: if p_wip_entity_id is null then
1111: if p_job_name is null then
1112: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1113: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id and Job Name');
1114: x_error_msg := fnd_message.get;
1115: x_error_code := -1;
1116: return;
1117: end if;
1118:

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

1130: where wip_entity_name = p_job_name
1131: and organization_id = p_org_id;
1132: exception
1133: when others then
1134: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1135: fnd_message.set_token('FLD_NAME', 'Job_Name');
1136: x_error_msg := fnd_message.get;
1137: x_error_code := -1;
1138: return;

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

1131: and organization_id = p_org_id;
1132: exception
1133: when others then
1134: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1135: fnd_message.set_token('FLD_NAME', 'Job_Name');
1136: x_error_msg := fnd_message.get;
1137: x_error_code := -1;
1138: return;
1139: end;

Line 1136: x_error_msg := fnd_message.get;

1132: exception
1133: when others then
1134: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1135: fnd_message.set_token('FLD_NAME', 'Job_Name');
1136: x_error_msg := fnd_message.get;
1137: x_error_code := -1;
1138: return;
1139: end;
1140: else

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

1161: and wdj.wip_entity_id = we.wip_entity_id
1162: and we.organization_id = p_org_id;
1163: exception
1164: when others then
1165: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1166: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1167: x_error_msg := fnd_message.get;
1168: x_error_code := -1;
1169: return;

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

1162: and we.organization_id = p_org_id;
1163: exception
1164: when others then
1165: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1166: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1167: x_error_msg := fnd_message.get;
1168: x_error_code := -1;
1169: return;
1170: end;

Line 1167: x_error_msg := fnd_message.get;

1163: exception
1164: when others then
1165: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1166: fnd_message.set_token('FLD_NAME', 'Wip_Entity_Id');
1167: x_error_msg := fnd_message.get;
1168: x_error_code := -1;
1169: return;
1170: end;
1171:

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

1181: and organization_id = p_org_id
1182: and wip_entity_id <> p_wip_entity_id;
1183:
1184: if (l_temp_num = 1) then
1185: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1186: x_error_msg := fnd_message.get;
1187: x_error_code := -1;
1188: return;
1189: end if;

Line 1186: x_error_msg := fnd_message.get;

1182: and wip_entity_id <> p_wip_entity_id;
1183:
1184: if (l_temp_num = 1) then
1185: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');
1186: x_error_msg := fnd_message.get;
1187: x_error_code := -1;
1188: return;
1189: end if;
1190: exception

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

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

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

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

Line 1194: x_error_msg := fnd_message.get;

1190: exception
1191: when others then
1192: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1193: fnd_message.set_token('FLD_NAME', 'Job_Name');
1194: x_error_msg := fnd_message.get;
1195: x_error_code := -1;
1196: return;
1197: end;
1198: end if;

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

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

Line 1207: x_error_msg := fnd_message.get;

1203:
1204: -- BA: 3512105
1205: if(WSMPUTIL.get_internal_copy_type(p_wip_entity_id) = 3) then
1206: fnd_message.set_name('WSM','WSM_NO_VALID_COPY');
1207: x_error_msg := fnd_message.get;
1208: x_error_code := -1;
1209: return;
1210: end if;
1211: -- BA: 3512105

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

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

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

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

Line 1220: x_error_msg := fnd_message.get;

1216: EXCEPTION
1217: when others then
1218: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1219: fnd_message.set_token('FLD_NAME', 'Wip_Entity_ID/Job_Name');
1220: x_error_msg := fnd_message.get;
1221: x_error_msg := 'validate_wip_entity_id_name (#' || l_stmt_num || ') ' || x_error_msg;
1222: x_error_code := -1;
1223: END validate_wip_entity_id_name;
1224:

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

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

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

1759: WSM_SUB_REC, WSM_SUB_DIS)
1760: then
1761: -- get error message
1762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1763: fnd_message.set_token('FLD_NAME', 'substitution_type');
1764: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1765: || fnd_message.get;
1766: p_error_code := -1;
1767: raise e_wljdi_common_error;

Line 1765: || fnd_message.get;

1761: -- get error message
1762: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1763: fnd_message.set_token('FLD_NAME', 'substitution_type');
1764: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1765: || fnd_message.get;
1766: p_error_code := -1;
1767: raise e_wljdi_common_error;
1768: end if;
1769:

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

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

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

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

Line 1793: || fnd_message.get;

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

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

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

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

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

Line 1840: || fnd_message.get;

1836: if(v_wljdi_resource_id_new(l_d) IS NULL) then
1837: fnd_message.set_name('WSM','WSM_NULL_FIELD');
1838: fnd_message.set_token('FLD_NAME', 'resource_id_new');
1839: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1840: || fnd_message.get;
1841: p_error_code := -1;
1842: raise e_wljdi_common_error;
1843: end if;
1844: else

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

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

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

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

Line 1902: -- || fnd_message.get;

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

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

1905: --end if;
1906: --Modiified for Alcoa Enhancement
1907: -- if(v_wljdi_resource_id_new(l_d) IS NULL)
1908: -- then
1909: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1910: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');
1911: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1912: -- || fnd_message.get;
1913: -- p_error_code := -1;

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

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

Line 1912: -- || fnd_message.get;

1908: -- then
1909: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
1910: -- fnd_message.set_token('FLD_NAME', 'resource_id_new');
1911: -- p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
1912: -- || fnd_message.get;
1913: -- p_error_code := -1;
1914: -- raise e_wljdi_common_error;
1915: -- end if;
1916:

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

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

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

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

Line 1974: || fnd_message.get;

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

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

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

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

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

Line 2012: || fnd_message.get;

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

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

2050:
2051: -- check primary_item_id/primary_item
2052: if(v_wljdi_primary_item_id(l_d) IS NULL) then
2053: if v_wljdi_primary_item(l_d) IS NULL then
2054: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2055: fnd_message.set_token('FLD_NAME', 'primary_item_id/primary_item');
2056: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2057: || fnd_message.get;
2058: p_error_code := -1;

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

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

Line 2057: || fnd_message.get;

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

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

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

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

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

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

2116: exception
2117: when others then
2118: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2119: fnd_message.set_token('FLD_NAME', 'Source_phantom_item_id/Source_phantom_item_name');
2120: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2121: p_error_code := -1;
2122: raise e_wljdi_common_error;
2123: end;
2124: end if;

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

2406: l_rpl_grp_num := v_wljdi_replacement_group_num(l_d);
2407:
2408: if(l_resource_id IS NULL) then
2409: if v_wljdi_resource_code_new(l_d) IS NULL then
2410: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2411: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
2412: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2413: || fnd_message.get;
2414: p_error_code := -1;

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

2407:
2408: if(l_resource_id IS NULL) then
2409: if v_wljdi_resource_code_new(l_d) IS NULL then
2410: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2411: fnd_message.set_token('FLD_NAME', 'resource_id_new/resource_code_new');
2412: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2413: || fnd_message.get;
2414: p_error_code := -1;
2415: raise e_wljdi_common_error;

Line 2413: || fnd_message.get;

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

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

2504: end if;
2505: if(--v_wljdi_routing_op_seq_num(l_d) IS NULL or
2506: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2507: then
2508: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2509: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2510: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2511: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2512: || fnd_message.get;

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

2505: if(--v_wljdi_routing_op_seq_num(l_d) IS NULL or
2506: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2507: then
2508: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2509: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2510: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2511: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2512: || fnd_message.get;
2513: p_error_code := -1;

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

2506: v_wljdi_next_rtg_op_seq_num(l_d) IS NULL)
2507: then
2508: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2509: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2510: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2511: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2512: || fnd_message.get;
2513: p_error_code := -1;
2514: raise e_wljdi_common_error;

Line 2512: || fnd_message.get;

2508: fnd_message.set_name('WSM','WSM_NULL_FIELD');
2509: --fnd_message.set_token('FLD_NAME', 'routing_op_seq_num and next_routing_op_seq_num');
2510: fnd_message.set_token('FLD_NAME', 'next_routing_op_seq_num');
2511: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2512: || fnd_message.get;
2513: p_error_code := -1;
2514: raise e_wljdi_common_error;
2515: end if;
2516:

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

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

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

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

Line 2531: || fnd_message.get;

2527: else
2528: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2529: fnd_message.set_token('FLD_NAME', 'load_type');
2530: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2531: || fnd_message.get;
2532: p_error_code := -1;
2533: raise e_wljdi_common_error;
2534: end if;
2535: ---------------------------------------------------------------------------

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

2620: where record_id = l_v_record_id(i);
2621:
2622: EXCEPTION
2623: when e_invalid_sub_load_type then
2624: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2625: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
2626: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2627: || fnd_message.get;
2628: p_error_code := -1;

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

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

Line 2627: || fnd_message.get;

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

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

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

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

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

Line 2635: || fnd_message.get;

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

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

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

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

2638: || p_error_msg, 1, 2000));
2639:
2640: when e_invalid_resource_code then
2641: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2642: fnd_message.set_token('FLD_NAME', 'resource_code_new');
2643: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2644: || fnd_message.get;
2645: p_error_code := -1;
2646: fnd_file.put_line(fnd_file.log,

Line 2644: || fnd_message.get;

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

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

2649:
2650: /* ST : Detailed Scheduling start */
2651:
2652: when e_invalid_resource_id then
2653: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2654: fnd_message.set_token('FLD_NAME', 'resource_id_new');
2655: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2656: || fnd_message.get;
2657: p_error_code := -1;

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

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

Line 2656: || fnd_message.get;

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

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

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

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

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

Line 2666: || fnd_message.get;

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

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

2671:
2672: /* ST : Detailed Scheduling end */
2673:
2674: when e_invalid_item_name then
2675: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2676: fnd_message.set_token('FLD_NAME', 'item_id');
2677: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2678: || fnd_message.get;
2679: p_error_code := -1;

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

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

Line 2678: || fnd_message.get;

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

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

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

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

2695: || p_error_msg, 1, 2000));
2696:
2697: when e_invalid_setup_code then
2698: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2699: fnd_message.set_token('FLD_NAME', 'Setup Code ');
2700: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2701: || fnd_message.get;
2702: p_error_code := -1;
2703: fnd_file.put_line(fnd_file.log,

Line 2701: || fnd_message.get;

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

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

2706:
2707: ---Added for LBJ Enhancement
2708:
2709: when e_res_seq_num_exist then
2710: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2711: fnd_message.set_token('FLD_NAME', 'resource_seq_num/job_op_seq_num combination');
2712: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
2713: || fnd_message.get;
2714: p_error_code := -1;

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

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

Line 2713: || fnd_message.get;

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

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

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

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

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

Line 2723: || fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2743: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2744: p_error_code := -1;
2745: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2746: when e_invalid_backflush_flag then
2747: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2748: fnd_message.set_token('FLD_NAME', 'backflush_flag');
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));

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

2744: p_error_code := -1;
2745: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2746: when e_invalid_backflush_flag then
2747: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2748: fnd_message.set_token('FLD_NAME', 'backflush_flag');
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_dup_op_seq then

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

2745: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2746: when e_invalid_backflush_flag then
2747: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2748: fnd_message.set_token('FLD_NAME', 'backflush_flag');
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_dup_op_seq then
2753: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');

Line 2753: 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_dup_op_seq then
2753: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');
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_op_date 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_dup_op_seq then
2753: fnd_message.set_name('WSM','WSM_INVALID_OPERATION');
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_op_date then
2758: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

Line 2758: 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_op_date then
2758: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
2759: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2760: p_error_code := -1;
2761: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2762: when e_invalid_routing_op_seq then

Line 2759: 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_op_date then
2758: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');
2759: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '|| fnd_message.get;
2760: p_error_code := -1;
2761: fnd_file.put_line(fnd_file.log,substr('default_wljdi_fields: (#'||l_stmt_num||') '|| p_error_msg, 1, 2000));
2762: when e_invalid_routing_op_seq then
2763: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

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

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

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

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

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

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

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

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

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

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

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

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

2843: end loop;
2844:
2845: if(l_cnt <> p_links.COUNT) then
2846: x_error_code := -1;
2847: fnd_message.set_name('WSM','WSM_INVALID_EXTRA_LINKS');
2848: x_error_msg := fnd_message.get;
2849: end if;
2850:
2851: EXCEPTION

Line 2848: x_error_msg := fnd_message.get;

2844:
2845: if(l_cnt <> p_links.COUNT) then
2846: x_error_code := -1;
2847: fnd_message.set_name('WSM','WSM_INVALID_EXTRA_LINKS');
2848: x_error_msg := fnd_message.get;
2849: end if;
2850:
2851: EXCEPTION
2852: when e_invalid_path_end then

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

2850:
2851: EXCEPTION
2852: when e_invalid_path_end then
2853: x_error_code := -1;
2854: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2855: fnd_message.set_token('END',p_end_op_seq_num);
2856: x_error_msg := fnd_message.get;
2857:
2858: when e_invalid_link then

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

2851: EXCEPTION
2852: when e_invalid_path_end then
2853: x_error_code := -1;
2854: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2855: fnd_message.set_token('END',p_end_op_seq_num);
2856: x_error_msg := fnd_message.get;
2857:
2858: when e_invalid_link then
2859: x_error_code := -1;

Line 2856: x_error_msg := fnd_message.get;

2852: when e_invalid_path_end then
2853: x_error_code := -1;
2854: fnd_message.set_name('WSM','WSM_COPY_NO_PATH_END');
2855: fnd_message.set_token('END',p_end_op_seq_num);
2856: x_error_msg := fnd_message.get;
2857:
2858: when e_invalid_link then
2859: x_error_code := -1;
2860: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');

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

2856: x_error_msg := fnd_message.get;
2857:
2858: when e_invalid_link then
2859: x_error_code := -1;
2860: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
2861: x_error_msg := fnd_message.get;
2862:
2863: when others then
2864: x_error_code := -1;

Line 2861: x_error_msg := fnd_message.get;

2857:
2858: when e_invalid_link then
2859: x_error_code := -1;
2860: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
2861: x_error_msg := fnd_message.get;
2862:
2863: when others then
2864: x_error_code := -1;
2865: x_error_msg := 'Error: validate_wljdi_path: (#'|| l_stmt_num||') '

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

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

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

3052: EXCEPTION
3053: when e_invalid_operation then
3054: x_error_code := -1;
3055: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
3056: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');
3057: x_error_msg := fnd_message.get;
3058:
3059: when e_invalid_op_yield then
3060: x_error_code := -1;

Line 3057: x_error_msg := fnd_message.get;

3053: when e_invalid_operation then
3054: x_error_code := -1;
3055: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
3056: fnd_message.set_token('FLD_NAME', 'job_op_seq_num or routing_op_seq_num');
3057: x_error_msg := fnd_message.get;
3058:
3059: when e_invalid_op_yield then
3060: x_error_code := -1;
3061: fnd_message.set_name('WSM','WSM_OP_BAD_YIELD');

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

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

Line 3062: x_error_msg := fnd_message.get;

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

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

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

Line 3067: x_error_msg := fnd_message.get;

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

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

3067: x_error_msg := fnd_message.get;
3068:
3069: when e_sche_qty_not_upd then
3070: x_error_code := -1;
3071: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');
3072: x_error_msg := fnd_message.get;
3073:
3074: when e_invalid_date then
3075: x_error_code := -1;

Line 3072: x_error_msg := fnd_message.get;

3068:
3069: when e_sche_qty_not_upd then
3070: x_error_code := -1;
3071: fnd_message.set_name('WSM','WSM_SCHQTY_NOT_UPDATABLE');
3072: x_error_msg := fnd_message.get;
3073:
3074: when e_invalid_date then
3075: x_error_code := -1;
3076: fnd_message.set_name('WSM','WSM_OP_BAD_DATES');

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

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

Line 3077: x_error_msg := fnd_message.get;

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

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

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

Line 3083: x_error_msg := fnd_message.get;

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

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

3084:
3085: /*Added for bugfix:7248992 */
3086: when e_invalid_rev_cum_yield then
3087: x_error_code := -1;
3088: fnd_message.set_name('WSM','WSM_OP_BAD_REV_CUM_YIELD');
3089: x_error_msg := fnd_message.get;
3090:
3091: when others then
3092: x_error_code := -1;

Line 3089: x_error_msg := fnd_message.get;

3085: /*Added for bugfix:7248992 */
3086: when e_invalid_rev_cum_yield then
3087: x_error_code := -1;
3088: fnd_message.set_name('WSM','WSM_OP_BAD_REV_CUM_YIELD');
3089: x_error_msg := fnd_message.get;
3090:
3091: when others then
3092: x_error_code := -1;
3093: x_error_msg := 'Error: validate_wljdi_operation: (#'||l_stmt_num||') '

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4245: /* ST : Detailed Scheduling start */
4246: when e_invalid_max_assg_units then
4247: x_error_code := -1;
4248: fnd_message.set_name('WSM','WSM_INVALID_MAX_ASSG');
4249: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4250: fnd_file.put_line(fnd_file.log,x_error_msg );
4251:
4252: when e_invalid_setup_max_assg_units then
4253: x_error_code := -1;

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

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

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

4251:
4252: when e_invalid_setup_max_assg_units then
4253: x_error_code := -1;
4254: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
4255: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4256: fnd_file.put_line(fnd_file.log,x_error_msg );
4257:
4258: when e_invalid_seq then
4259: x_error_code := -1;

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

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

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

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

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

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

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

4263:
4264: when e_invalid_batch_max_assg_units then
4265: x_error_code := -1;
4266: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
4267: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4268: fnd_file.put_line(fnd_file.log,x_error_msg );
4269:
4270: when e_invalid_setup_id then
4271: x_error_code := -1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4305: --Alcoa Enhancements Changes
4306: when e_res_id_null THEN
4307: x_error_code := -1;
4308: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4309: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');
4310: x_error_msg := fnd_message.get;
4311:
4312: when e_assgnd_units_null then
4313: x_error_code := -1;

Line 4310: x_error_msg := fnd_message.get;

4306: when e_res_id_null THEN
4307: x_error_code := -1;
4308: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4309: fnd_message.set_token('FLD_NAME', 'Resource_code/ Resource_id combination');
4310: x_error_msg := fnd_message.get;
4311:
4312: when e_assgnd_units_null then
4313: x_error_code := -1;
4314: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

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

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

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

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

4312: when e_assgnd_units_null then
4313: x_error_code := -1;
4314: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4315: fnd_message.set_token('FLD_NAME', 'Assigned_units');
4316: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4317: fnd_file.put_line(fnd_file.log,x_error_msg );
4318:
4319: when e_inv_appl_res_units THEN
4320: x_error_code := -1;

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

4317: fnd_file.put_line(fnd_file.log,x_error_msg );
4318:
4319: when e_inv_appl_res_units THEN
4320: x_error_code := -1;
4321: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4322: fnd_message.set_token('FLD_NAME', 'Applied_units');
4323: x_error_msg := fnd_message.get;
4324:
4325: when e_wt_or_wcit_rec_exists THEN

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

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

Line 4323: x_error_msg := fnd_message.get;

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

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

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

Line 4328: x_error_msg := fnd_message.get;

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

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

4328: x_error_msg := fnd_message.get;
4329:
4330: when e_po_req_rec_exists THEN
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');
4333: x_error_msg := fnd_message.get;
4334:
4335: when e_invalid_res_sub_grp_num then
4336: x_error_code := -1;

Line 4333: x_error_msg := fnd_message.get;

4329:
4330: when e_po_req_rec_exists THEN
4331: x_error_code := -1;
4332: fnd_message.set_name('WSM','WSM_PO_REC_REC_EXIS');
4333: x_error_msg := fnd_message.get;
4334:
4335: when e_invalid_res_sub_grp_num then
4336: x_error_code := -1;
4337: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4373: x_error_msg := fnd_message.get;

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

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

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

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

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

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

4376: when e_invalid_usg_rate then
4377: x_error_code := -1;
4378: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4379: fnd_message.set_token('FLD_NAME', 'usage_rate_or_amount');
4380: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4381: fnd_file.put_line(fnd_file.log,x_error_msg );
4382:
4383: when e_invalid_res_dept THEN
4384: x_error_code := -1;

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

4381: fnd_file.put_line(fnd_file.log,x_error_msg );
4382:
4383: when e_invalid_res_dept THEN
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
4386: x_error_msg := fnd_message.get;
4387:
4388: when e_inv_resource_charge_type then
4389: x_error_code := -1;

Line 4386: x_error_msg := fnd_message.get;

4382:
4383: when e_invalid_res_dept THEN
4384: x_error_code := -1;
4385: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
4386: x_error_msg := fnd_message.get;
4387:
4388: when e_inv_resource_charge_type then
4389: x_error_code := -1;
4390: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

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

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

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

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

4388: when e_inv_resource_charge_type then
4389: x_error_code := -1;
4390: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4391: fnd_message.set_token('FLD_NAME', 'Autocharge_type');
4392: x_error_msg := 'Error: validate_wljdi_op_resource: (#'|| l_stmt_num||') ' || fnd_message.get;
4393: fnd_file.put_line(fnd_file.log,x_error_msg );
4394:
4395: when others then
4396: x_error_code := -1;

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

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

Line 4770: x_error_msg := fnd_message.get;

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

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

4771: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4772:
4773: when e_not_on_reco_path then
4774: x_error_code := -1;
4775: fnd_message.set_name('WSM','WSM_INS_USE_NON_RECO');
4776: x_error_msg := fnd_message.get;
4777: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4778:
4779:

Line 4776: x_error_msg := fnd_message.get;

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

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

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

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

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

Line 4784: x_error_msg := fnd_message.get;

4780: when e_invalid_rtg_op_seq then
4781: x_error_code := -1;
4782: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4783: fnd_message.set_token('FLD_NAME', 'routing_op_seq_num');
4784: x_error_msg := fnd_message.get;
4785:
4786: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4787:
4788:

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

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

Line 4792: x_error_msg := fnd_message.get;

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

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

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

Line 4800: x_error_msg := fnd_message.get;

4796:
4797: when e_ins_not_exists then
4798: x_error_code := -1;
4799: fnd_message.set_name('WSM','WSM_INS_NOT_EXISTS');
4800: x_error_msg := fnd_message.get;
4801:
4802: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4803:
4804:

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

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

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

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

Line 4809: x_error_msg := fnd_message.get;

4805: when e_null_ins_id then
4806: x_error_code := -1;
4807: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4808: fnd_message.set_token('FLD_NAME', 'Instance_id');
4809: x_error_msg := fnd_message.get;
4810:
4811: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4812:
4813:

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

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

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

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

Line 4818: x_error_msg := fnd_message.get;

4814: when e_invalid_ins_id then
4815: x_error_code := -1;
4816: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4817: fnd_message.set_token('FLD_NAME', 'Instance_id and Serial_number');
4818: x_error_msg := fnd_message.get;
4819:
4820: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4821:
4822:

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

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

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

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

Line 4827: x_error_msg := fnd_message.get;

4823: when e_null_date then
4824: x_error_code := -1;
4825: fnd_message.set_name('WSM','WSM_NULL_FIELD');
4826: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
4827: x_error_msg := fnd_message.get;
4828:
4829: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4830:
4831:

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

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

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

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

Line 4836: x_error_msg := fnd_message.get;

4832: when e_invalid_date then
4833: x_error_code := -1;
4834: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
4835: fnd_message.set_token('FLD_NAME', 'Resource instance scheduled dates');
4836: x_error_msg := fnd_message.get;
4837:
4838: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4839:
4840:

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

4839:
4840:
4841: when e_invalid_time_slot then
4842: x_error_code := -1;
4843: fnd_message.set_name('WSM','WSM_INS_BAD_TIME_SLOT');
4844: x_error_msg := fnd_message.get;
4845:
4846: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4847:

Line 4844: x_error_msg := fnd_message.get;

4840:
4841: when e_invalid_time_slot then
4842: x_error_code := -1;
4843: fnd_message.set_name('WSM','WSM_INS_BAD_TIME_SLOT');
4844: x_error_msg := fnd_message.get;
4845:
4846: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_instance : ' || l_stmt_num || ' error : ' || x_error_msg);
4847:
4848: -- ST : Detailed Scheduling...

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

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

Line 5287: x_error_msg := fnd_message.get;

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

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

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

Line 5293: x_error_msg := fnd_message.get;

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

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

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

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

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

Line 5300: x_error_msg := fnd_message.get;

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

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

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

Line 5306: x_error_msg := fnd_message.get;

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

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

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

Line 5312: x_error_msg := fnd_message.get;

5308:
5309: when e_instances_exist then
5310: x_error_code := -1;
5311: fnd_message.set_name('WSM','WSM_INS_EXISTS');
5312: x_error_msg := fnd_message.get;
5313: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5314:
5315: when e_invalid_instance_id then
5316: x_error_code := -1;

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

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

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

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

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

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

Line 5320: x_error_msg := fnd_message.get;

5316: x_error_code := -1;
5317: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5318: --fnd_message.set_token('FLD_NAME', ' l_stmt_num : ' || l_stmt_num || ' Resource_seq_num / Instance_id / Serial_number');
5319: fnd_message.set_token('FLD_NAME', ' Resource_seq_num / Instance_id / Serial_number'); /*Bug 5488016 */
5320: x_error_msg := fnd_message.get;
5321: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5322:
5323: when e_invalid_asgned_units then
5324: x_error_code := -1;

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

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

Line 5326: x_error_msg := fnd_message.get;

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

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

5328:
5329: /* ST : Detailed Scheduling start */
5330: when e_invalid_ins_assigned_units then
5331: x_error_code := -1;
5332: fnd_message.set_name('WSM','WSM_INVALID_INS_ASSG_UNITS');
5333: x_error_msg := fnd_message.get;
5334: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5335:
5336: when e_no_res_seq_num then

Line 5333: x_error_msg := fnd_message.get;

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

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

5341: /* ST : Detailed Scheduling end */
5342:
5343: when e_usage_not_exists then
5344: x_error_code := -1;
5345: fnd_message.set_name('WSM','WSM_USE_NOT_EXISTS');
5346: x_error_msg := fnd_message.get;
5347: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5348:
5349: when e_null_date then

Line 5346: x_error_msg := fnd_message.get;

5342:
5343: when e_usage_not_exists then
5344: x_error_code := -1;
5345: fnd_message.set_name('WSM','WSM_USE_NOT_EXISTS');
5346: x_error_msg := fnd_message.get;
5347: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5348:
5349: when e_null_date then
5350: x_error_code := -1;

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

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

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

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

Line 5353: x_error_msg := fnd_message.get;

5349: when e_null_date then
5350: x_error_code := -1;
5351: fnd_message.set_name('WSM','WSM_NULL_FIELD');
5352: fnd_message.set_token('FLD_NAME', 'Start date and Completion date');
5353: x_error_msg := fnd_message.get;
5354: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5355:
5356: when e_invalid_date then
5357: x_error_code := -1;

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

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

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

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

Line 5360: x_error_msg := fnd_message.get;

5356: when e_invalid_date then
5357: x_error_code := -1;
5358: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
5359: fnd_message.set_token('FLD_NAME', 'Resource usage scheduled dates');
5360: x_error_msg := fnd_message.get;
5361: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5362:
5363: when e_date_overlap then
5364: x_error_code := -1;

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

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

Line 5366: x_error_msg := fnd_message.get;

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

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

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

Line 5372: x_error_msg := fnd_message.get;

5368:
5369: when e_invalid_time_slot then
5370: x_error_code := -1;
5371: fnd_message.set_name('WSM','WSM_USE_BAD_TIME_SLOT');
5372: x_error_msg := fnd_message.get;
5373: fnd_file.put_line(fnd_file.log,'validate_wljdi_res_usage : ' || l_stmt_num || ' : ' || x_error_msg);
5374:
5375: when others then
5376: x_error_code := -1;

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

6077:
6078: EXCEPTION
6079: when e_invalid_component then
6080: x_error_code := -1;
6081: fnd_message.set_name('WSM','WSM_COMP_NOT_REQUIRED');
6082: x_error_msg := fnd_message.get;
6083:
6084: when e_invalid_comp_yield then
6085: x_error_code := -1;

Line 6082: x_error_msg := fnd_message.get;

6078: EXCEPTION
6079: when e_invalid_component then
6080: x_error_code := -1;
6081: fnd_message.set_name('WSM','WSM_COMP_NOT_REQUIRED');
6082: x_error_msg := fnd_message.get;
6083:
6084: when e_invalid_comp_yield then
6085: x_error_code := -1;
6086: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');

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

6082: x_error_msg := fnd_message.get;
6083:
6084: when e_invalid_comp_yield then
6085: x_error_code := -1;
6086: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');
6087: x_error_msg := fnd_message.get;
6088:
6089: when e_req_qty_not_upd then
6090: x_error_code := -1;

Line 6087: x_error_msg := fnd_message.get;

6083:
6084: when e_invalid_comp_yield then
6085: x_error_code := -1;
6086: fnd_message.set_name('WSM','WSM_COMP_BAD_YIELD');
6087: x_error_msg := fnd_message.get;
6088:
6089: when e_req_qty_not_upd then
6090: x_error_code := -1;
6091: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');

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

6087: x_error_msg := fnd_message.get;
6088:
6089: when e_req_qty_not_upd then
6090: x_error_code := -1;
6091: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');
6092: x_error_msg := fnd_message.get;
6093:
6094: /*when e_req_qty_negative then
6095: x_error_code := -1;

Line 6092: x_error_msg := fnd_message.get;

6088:
6089: when e_req_qty_not_upd then
6090: x_error_code := -1;
6091: fnd_message.set_name('WSM','WSM_COMP_REQQTY_NON_RECO');
6092: x_error_msg := fnd_message.get;
6093:
6094: /*when e_req_qty_negative then
6095: x_error_code := -1;
6096: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');

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

6092: x_error_msg := fnd_message.get;
6093:
6094: /*when e_req_qty_negative then
6095: x_error_code := -1;
6096: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');
6097: x_error_msg := fnd_message.get;*/
6098:
6099: when e_invalid_phantom then
6100: x_error_code := -1;

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

6093:
6094: /*when e_req_qty_negative then
6095: x_error_code := -1;
6096: fnd_message.set_name('WSM','WSM_COMP_BAD_REQQTY');
6097: x_error_msg := fnd_message.get;*/
6098:
6099: when e_invalid_phantom then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');

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

6097: x_error_msg := fnd_message.get;*/
6098:
6099: when e_invalid_phantom then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');
6102: x_error_msg := fnd_message.get;
6103:
6104: when e_invalid_date then
6105: x_error_code := -1;

Line 6102: x_error_msg := fnd_message.get;

6098:
6099: when e_invalid_phantom then
6100: x_error_code := -1;
6101: fnd_message.set_name('WSM','WSM_COMP_PARTIAL_PHANTOM');
6102: x_error_msg := fnd_message.get;
6103:
6104: when e_invalid_date then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');

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

6102: x_error_msg := fnd_message.get;
6103:
6104: when e_invalid_date then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');
6107: x_error_msg := fnd_message.get;
6108:
6109: ---Alcoa Enhancement Changes
6110: when e_parent_phantom then

Line 6107: x_error_msg := fnd_message.get;

6103:
6104: when e_invalid_date then
6105: x_error_code := -1;
6106: fnd_message.set_name('WSM','WSM_COMP_BAD_DATE');
6107: x_error_msg := fnd_message.get;
6108:
6109: ---Alcoa Enhancement Changes
6110: when e_parent_phantom then
6111: x_error_code := -1;

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

6108:
6109: ---Alcoa Enhancement Changes
6110: when e_parent_phantom then
6111: x_error_code := -1;
6112: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM');
6113: x_error_msg := fnd_message.get;
6114:
6115: when e_parent_phantom_comp then
6116: x_error_code := -1;

Line 6113: x_error_msg := fnd_message.get;

6109: ---Alcoa Enhancement Changes
6110: when e_parent_phantom then
6111: x_error_code := -1;
6112: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM');
6113: x_error_msg := fnd_message.get;
6114:
6115: when e_parent_phantom_comp then
6116: x_error_code := -1;
6117: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');

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

6113: x_error_msg := fnd_message.get;
6114:
6115: when e_parent_phantom_comp then
6116: x_error_code := -1;
6117: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');
6118: x_error_msg := fnd_message.get;
6119:
6120: when e_no_parent_phantom then
6121: x_error_code := -1;

Line 6118: x_error_msg := fnd_message.get;

6114:
6115: when e_parent_phantom_comp then
6116: x_error_code := -1;
6117: fnd_message.set_name('WSM','WSM_PARENT_PHANTOM_CHILD');
6118: x_error_msg := fnd_message.get;
6119:
6120: when e_no_parent_phantom then
6121: x_error_code := -1;
6122: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');

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

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

Line 6123: x_error_msg := fnd_message.get;

6119:
6120: when e_no_parent_phantom then
6121: x_error_code := -1;
6122: fnd_message.set_name('WSM','WSM_NO_PARENT_PHANTOM');
6123: x_error_msg := fnd_message.get;
6124:
6125: when e_invalid_item then
6126: x_error_code := -1;
6127: fnd_message.set_name('WSM','WSM_INVALID_ITEM');

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

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

Line 6128: x_error_msg := fnd_message.get;

6124:
6125: when e_invalid_item then
6126: x_error_code := -1;
6127: fnd_message.set_name('WSM','WSM_INVALID_ITEM');
6128: x_error_msg := fnd_message.get;
6129:
6130: when e_quantity_issued_error 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_quantity_issued_error then
6131: x_error_code := -1;
6132: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6133: fnd_message.set_token('FLD_NAME', 'Quantity_issued');
6134: x_error_msg := fnd_message.get;
6135:
6136: when e_material_trans_err then

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

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

Line 6134: x_error_msg := fnd_message.get;

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

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

6134: x_error_msg := fnd_message.get;
6135:
6136: when e_material_trans_err then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');
6139: x_error_msg := fnd_message.get;
6140:
6141: when e_phantom_comp then
6142: x_error_code := -1;

Line 6139: x_error_msg := fnd_message.get;

6135:
6136: when e_material_trans_err then
6137: x_error_code := -1;
6138: fnd_message.set_name('WSM','WSM_MATERIAL_TRX');
6139: x_error_msg := fnd_message.get;
6140:
6141: when e_phantom_comp then
6142: x_error_code := -1;
6143: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');

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

6139: x_error_msg := fnd_message.get;
6140:
6141: when e_phantom_comp then
6142: x_error_code := -1;
6143: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');
6144: x_error_msg := fnd_message.get;
6145:
6146: when e_invalid_wip_supply_type then
6147: x_error_code := -1;

Line 6144: x_error_msg := fnd_message.get;

6140:
6141: when e_phantom_comp then
6142: x_error_code := -1;
6143: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENT');
6144: x_error_msg := fnd_message.get;
6145:
6146: when e_invalid_wip_supply_type then
6147: x_error_code := -1;
6148: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

6144: x_error_msg := fnd_message.get;
6145:
6146: when e_invalid_wip_supply_type then
6147: x_error_code := -1;
6148: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6149: fnd_message.set_token('FLD_NAME', 'Supply_type');
6150: x_error_msg := fnd_message.get;
6151:
6152: when e_invalid_qpa then

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

6145:
6146: when e_invalid_wip_supply_type then
6147: x_error_code := -1;
6148: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6149: fnd_message.set_token('FLD_NAME', 'Supply_type');
6150: x_error_msg := fnd_message.get;
6151:
6152: when e_invalid_qpa then
6153: x_error_code := -1;

Line 6150: x_error_msg := fnd_message.get;

6146: when e_invalid_wip_supply_type then
6147: x_error_code := -1;
6148: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6149: fnd_message.set_token('FLD_NAME', 'Supply_type');
6150: x_error_msg := fnd_message.get;
6151:
6152: when e_invalid_qpa then
6153: x_error_code := -1;
6154: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

6150: x_error_msg := fnd_message.get;
6151:
6152: when e_invalid_qpa then
6153: x_error_code := -1;
6154: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6155: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6156: x_error_msg := fnd_message.get;
6157:
6158: when e_inv_supply_info then

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

6151:
6152: when e_invalid_qpa then
6153: x_error_code := -1;
6154: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6155: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6156: x_error_msg := fnd_message.get;
6157:
6158: when e_inv_supply_info then
6159: x_error_code := -1;

Line 6156: x_error_msg := fnd_message.get;

6152: when e_invalid_qpa then
6153: x_error_code := -1;
6154: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6155: fnd_message.set_token('FLD_NAME', 'Quantity_per_assembly');
6156: x_error_msg := fnd_message.get;
6157:
6158: when e_inv_supply_info then
6159: x_error_code := -1;
6160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

6156: x_error_msg := fnd_message.get;
6157:
6158: when e_inv_supply_info then
6159: x_error_code := -1;
6160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6161: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_job then

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

6157:
6158: when e_inv_supply_info then
6159: x_error_code := -1;
6160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6161: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_job then
6165: x_error_code := -1;

Line 6162: x_error_msg := fnd_message.get;

6158: when e_inv_supply_info then
6159: x_error_code := -1;
6160: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6161: fnd_message.set_token('FLD_NAME', 'Supply subinventory/locator combination');
6162: x_error_msg := fnd_message.get;
6163:
6164: when e_invalid_job 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_job then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6168: x_error_msg := fnd_message.get;
6169:
6170: when e_dup_component then

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

6163:
6164: when e_invalid_job then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6168: x_error_msg := fnd_message.get;
6169:
6170: when e_dup_component then
6171: x_error_code := -1;

Line 6168: x_error_msg := fnd_message.get;

6164: when e_invalid_job then
6165: x_error_code := -1;
6166: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6167: fnd_message.set_token('FLD_NAME', 'Job_op_seq_num / Routing_op_seq_num');
6168: x_error_msg := fnd_message.get;
6169:
6170: when e_dup_component then
6171: x_error_code := -1;
6172: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');

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

6168: x_error_msg := fnd_message.get;
6169:
6170: when e_dup_component then
6171: x_error_code := -1;
6172: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');
6173: x_error_msg := fnd_message.get;
6174:
6175: when e_no_assy_as_comp then
6176: x_error_code := -1;

Line 6173: x_error_msg := fnd_message.get;

6169:
6170: when e_dup_component then
6171: x_error_code := -1;
6172: fnd_message.set_name('WSM','WSM_COMPONENT_DUP');
6173: x_error_msg := fnd_message.get;
6174:
6175: when e_no_assy_as_comp then
6176: x_error_code := -1;
6177: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');

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

6173: x_error_msg := fnd_message.get;
6174:
6175: when e_no_assy_as_comp then
6176: x_error_code := -1;
6177: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');
6178: x_error_msg := fnd_message.get;
6179:
6180: when e_invalid_mrp_net_flag then
6181: x_error_code := -1;

Line 6178: x_error_msg := fnd_message.get;

6174:
6175: when e_no_assy_as_comp then
6176: x_error_code := -1;
6177: fnd_message.set_name('WSM','WSM_ASSY_AS_COMP');
6178: x_error_msg := fnd_message.get;
6179:
6180: when e_invalid_mrp_net_flag then
6181: x_error_code := -1;
6182: fnd_message.set_name('WSM','WSM_INVALID_FIELD');

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

6178: x_error_msg := fnd_message.get;
6179:
6180: when e_invalid_mrp_net_flag then
6181: x_error_code := -1;
6182: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6183: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6184: x_error_msg := fnd_message.get;
6185:
6186: --Added for bug Fix #7197440

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

6179:
6180: when e_invalid_mrp_net_flag then
6181: x_error_code := -1;
6182: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6183: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6184: x_error_msg := fnd_message.get;
6185:
6186: --Added for bug Fix #7197440
6187: when e_req_qty_zero then -- bug #7197440

Line 6184: x_error_msg := fnd_message.get;

6180: when e_invalid_mrp_net_flag then
6181: x_error_code := -1;
6182: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
6183: fnd_message.set_token('FLD_NAME', 'Mrp_net_flag');
6184: x_error_msg := fnd_message.get;
6185:
6186: --Added for bug Fix #7197440
6187: when e_req_qty_zero then -- bug #7197440
6188: x_error_code := -1;

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

6185:
6186: --Added for bug Fix #7197440
6187: when e_req_qty_zero then -- bug #7197440
6188: x_error_code := -1;
6189: fnd_message.set_name('WSM','WSM_COPY_QTY_NON_ZERO');
6190: x_error_msg := fnd_message.get;
6191:
6192: when e_req_qty_sign_chg then -- bug #7197440
6193: x_error_code := -1;

Line 6190: x_error_msg := fnd_message.get;

6186: --Added for bug Fix #7197440
6187: when e_req_qty_zero then -- bug #7197440
6188: x_error_code := -1;
6189: fnd_message.set_name('WSM','WSM_COPY_QTY_NON_ZERO');
6190: x_error_msg := fnd_message.get;
6191:
6192: when e_req_qty_sign_chg then -- bug #7197440
6193: x_error_code := -1;
6194: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');

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

6190: x_error_msg := fnd_message.get;
6191:
6192: when e_req_qty_sign_chg then -- bug #7197440
6193: x_error_code := -1;
6194: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');
6195: x_error_msg := fnd_message.get;
6196:
6197: when others then
6198: x_error_code := -1;

Line 6195: x_error_msg := fnd_message.get;

6191:
6192: when e_req_qty_sign_chg then -- bug #7197440
6193: x_error_code := -1;
6194: fnd_message.set_name('WSM','WSM_COPY_QTY_SIGN');
6195: x_error_msg := fnd_message.get;
6196:
6197: when others then
6198: x_error_code := -1;
6199: x_error_msg := 'Error: validate_wljdi_op_component: (#'||l_stmt_num||') '

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

7662: -- x_err_code => l_error_code,
7663: -- x_err_msg => l_error_msg,
7664: -- p_organization_id => v_wlji_org_id(v_idx) );
7665: --IF (l_return_value <> 0) THEN
7666: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7667: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7668: -- l_error_msg := fnd_message.get;
7669: -- l_error_code := -1;
7670: -- handle_error( l_error_code, l_error_msg, l_stmt_num);

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

7663: -- x_err_msg => l_error_msg,
7664: -- p_organization_id => v_wlji_org_id(v_idx) );
7665: --IF (l_return_value <> 0) THEN
7666: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7667: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7668: -- l_error_msg := fnd_message.get;
7669: -- l_error_code := -1;
7670: -- handle_error( l_error_code, l_error_msg, l_stmt_num);
7671: -- GOTO skip_job_id_valid;

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

7664: -- p_organization_id => v_wlji_org_id(v_idx) );
7665: --IF (l_return_value <> 0) THEN
7666: -- FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
7667: -- fnd_message.set_token('TABLE', 'WSM_SPLIT_MERGE_TRANSACTIONS');
7668: -- l_error_msg := fnd_message.get;
7669: -- l_error_code := -1;
7670: -- handle_error( l_error_code, l_error_msg, l_stmt_num);
7671: -- GOTO skip_job_id_valid;
7672: --ELSE

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

8323: -- Default description
8324: -- this is to be called only for job creation.
8325: if RTRIM(v_wlji_description(v_idx)) is NULL then
8326: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1);
8327: fnd_message.set_name('WIP','WIP_MLD_DESC');
8328: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8329: v_wlji_description(v_idx) := FND_Message.get;
8330: else
8331: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));

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

8324: -- this is to be called only for job creation.
8325: if RTRIM(v_wlji_description(v_idx)) is NULL then
8326: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1);
8327: fnd_message.set_name('WIP','WIP_MLD_DESC');
8328: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8329: v_wlji_description(v_idx) := FND_Message.get;
8330: else
8331: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));
8332: end if;

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

8325: if RTRIM(v_wlji_description(v_idx)) is NULL then
8326: l_date_text := fnd_date.date_to_charDT(dateval =>sysdate,calendar_aware => 1);
8327: fnd_message.set_name('WIP','WIP_MLD_DESC');
8328: fnd_message.set_token('LOAD_DATE', l_date_text, false);
8329: v_wlji_description(v_idx) := FND_Message.get;
8330: else
8331: v_wlji_description(v_idx) := RTRIM(v_wlji_description(v_idx));
8332: end if;
8333: if lbji_debug = 'Y' then

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

8545:
8546: IF floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx) THEN
8547: -- error out...
8548: -- Start qty cannot be non-integer...
8549: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8550: l_aux_mesg := fnd_message.get;
8551: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
8552: l_error_code := -1;
8553: l_error_count := l_error_count + 1;

Line 8550: l_aux_mesg := fnd_message.get;

8546: IF floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx) THEN
8547: -- error out...
8548: -- Start qty cannot be non-integer...
8549: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8550: l_aux_mesg := fnd_message.get;
8551: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
8552: l_error_code := -1;
8553: l_error_count := l_error_count + 1;
8554: GOTO abort_this_job;

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

8556:
8557: IF floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx) THEN
8558: -- error out...
8559: -- Start qty cannot be non-integer...
8560: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8561: l_aux_mesg := fnd_message.get;
8562: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
8563: l_error_code := -1;
8564: l_error_count := l_error_count + 1;

Line 8561: l_aux_mesg := fnd_message.get;

8557: IF floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx) THEN
8558: -- error out...
8559: -- Start qty cannot be non-integer...
8560: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
8561: l_aux_mesg := fnd_message.get;
8562: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
8563: l_error_code := -1;
8564: l_error_count := l_error_count + 1;
8565: GOTO abort_this_job;

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

9035: and nvl(mmtt2.locator_id, -9999) = nvl(v_wsli(v_wlji_src_line_id(v_idx)).locator_id, -9999)
9036: );
9037: end if;
9038: If l_temp_num <> 0 then
9039: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
9040: fnd_message.set_token('TABLE','Starting Lot:' ||
9041: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
9042: 'Table: mtl_transaction_lots_temp ');
9043: l_error_msg := fnd_message.get;

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

9036: );
9037: end if;
9038: If l_temp_num <> 0 then
9039: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
9040: fnd_message.set_token('TABLE','Starting Lot:' ||
9041: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
9042: 'Table: mtl_transaction_lots_temp ');
9043: l_error_msg := fnd_message.get;
9044: l_error_code := -1;

Line 9043: l_error_msg := fnd_message.get;

9039: fnd_message.set_name('WSM', 'WSM_PENDING_TXN');
9040: fnd_message.set_token('TABLE','Starting Lot:' ||
9041: v_wsli(v_wlji_src_line_id(v_idx)).lot_number ||
9042: 'Table: mtl_transaction_lots_temp ');
9043: l_error_msg := fnd_message.get;
9044: l_error_code := -1;
9045: handle_error( l_error_code, l_error_msg, l_stmt_num);
9046: l_error_count := l_error_count + 1;
9047: GOTO abort_this_job;

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

9973: null,
9974: v_wlji_org_id(v_idx),
9975: null, 5)
9976: then
9977: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
9978: l_error_msg := fnd_message.get;
9979: l_warning_count := l_warning_count + 1;
9980: handle_warning(
9981: p_err_msg => l_error_msg,

Line 9978: l_error_msg := fnd_message.get;

9974: v_wlji_org_id(v_idx),
9975: null, 5)
9976: then
9977: fnd_message.set_name('WSM', 'WSM_JOB_PURCHASE_REQ');
9978: l_error_msg := fnd_message.get;
9979: l_warning_count := l_warning_count + 1;
9980: handle_warning(
9981: p_err_msg => l_error_msg,
9982: p_header_id => v_wlji_header_id(v_idx),

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

10014:
10015: if l_est_scrap_account is null or
10016: l_est_scrap_var_account is null
10017: then
10018: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10019: fnd_message.set_token('CC', l_temp_class);
10020: l_error_msg := fnd_message.get;
10021: l_error_code := -1;
10022: handle_error(l_error_code, l_error_msg, l_stmt_num);

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

10015: if l_est_scrap_account is null or
10016: l_est_scrap_var_account is null
10017: then
10018: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10019: fnd_message.set_token('CC', l_temp_class);
10020: l_error_msg := fnd_message.get;
10021: l_error_code := -1;
10022: handle_error(l_error_code, l_error_msg, l_stmt_num);
10023: GOTO skip_resched_validations;

Line 10020: l_error_msg := fnd_message.get;

10016: l_est_scrap_var_account is null
10017: then
10018: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10019: fnd_message.set_token('CC', l_temp_class);
10020: l_error_msg := fnd_message.get;
10021: l_error_code := -1;
10022: handle_error(l_error_code, l_error_msg, l_stmt_num);
10023: GOTO skip_resched_validations;
10024: end if;

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

10024: end if;
10025: if l_est_scrap_account is null or
10026: l_est_scrap_var_account is null
10027: then
10028: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10029: fnd_message.set_token('CC', l_temp_class);
10030: l_error_msg := fnd_message.get;
10031: l_error_code := -1;
10032: handle_error(l_error_code, l_error_msg, l_stmt_num);

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

10025: if l_est_scrap_account is null or
10026: l_est_scrap_var_account is null
10027: then
10028: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10029: fnd_message.set_token('CC', l_temp_class);
10030: l_error_msg := fnd_message.get;
10031: l_error_code := -1;
10032: handle_error(l_error_code, l_error_msg, l_stmt_num);
10033: GOTO skip_resched_validations;

Line 10030: l_error_msg := fnd_message.get;

10026: l_est_scrap_var_account is null
10027: then
10028: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
10029: fnd_message.set_token('CC', l_temp_class);
10030: l_error_msg := fnd_message.get;
10031: l_error_code := -1;
10032: handle_error(l_error_code, l_error_msg, l_stmt_num);
10033: GOTO skip_resched_validations;
10034: end if;

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

10195: (floor(v_wlji_start_quantity(v_idx)) <> v_wlji_start_quantity(v_idx))
10196: THEN
10197: -- error out...
10198: -- Start qty cannot be non-integer...
10199: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10200: l_aux_mesg := fnd_message.get;
10201: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
10202: l_error_code := -1;
10203: l_error_count := l_error_count + 1;

Line 10200: l_aux_mesg := fnd_message.get;

10196: THEN
10197: -- error out...
10198: -- Start qty cannot be non-integer...
10199: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10200: l_aux_mesg := fnd_message.get;
10201: handle_invalid_field('START QUANTITY', l_aux_mesg, l_stmt_num);
10202: l_error_code := -1;
10203: l_error_count := l_error_count + 1;
10204: GOTO skip_resched_validations;

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

10208: floor(v_wlji_net_quantity(v_idx)) <> v_wlji_net_quantity(v_idx)
10209: THEN
10210: -- error out...
10211: -- Start qty cannot be non-integer...
10212: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10213: l_aux_mesg := fnd_message.get;
10214: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
10215: l_error_code := -1;
10216: l_error_count := l_error_count + 1;

Line 10213: l_aux_mesg := fnd_message.get;

10209: THEN
10210: -- error out...
10211: -- Start qty cannot be non-integer...
10212: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
10213: l_aux_mesg := fnd_message.get;
10214: handle_invalid_field('NET QUANTITY', l_aux_mesg, l_stmt_num);
10215: l_error_code := -1;
10216: l_error_count := l_error_count + 1;
10217: GOTO skip_resched_validations;

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

10511: v_wlji_rtg_rev_date(v_idx),
10512: l_error_code,
10513: l_error_msg) = 1)
10514: then
10515: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
10516: l_error_msg := fnd_message.get;
10517: l_warning_count := l_warning_count + 1;
10518: handle_warning(
10519: p_err_msg => l_error_msg,

Line 10516: l_error_msg := fnd_message.get;

10512: l_error_code,
10513: l_error_msg) = 1)
10514: then
10515: fnd_message.set_name('WSM','WSM_NET_HAS_DISABLED_OP');
10516: l_error_msg := fnd_message.get;
10517: l_warning_count := l_warning_count + 1;
10518: handle_warning(
10519: p_err_msg => l_error_msg,
10520: p_header_id => v_wlji_header_id(v_idx),

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

10703: -- wcro.operation_seq_num= 1);
10704: --if(l_required_qpa = 0) then -- bug 2963225
10705: if(NVL(l_required_qpa, 0) = 0) then -- bug 2963225
10706: l_error_code := -1;
10707: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
10708: l_error_msg := fnd_message.get;
10709: handle_error(l_error_code, l_error_msg, l_stmt_num);
10710: l_error_count := l_error_count + 1;
10711: GOTO abort_this_job;

Line 10708: l_error_msg := fnd_message.get;

10704: --if(l_required_qpa = 0) then -- bug 2963225
10705: if(NVL(l_required_qpa, 0) = 0) then -- bug 2963225
10706: l_error_code := -1;
10707: fnd_message.set_name('WSM','WSM_INVALID_BOM_ROUT');
10708: l_error_msg := fnd_message.get;
10709: handle_error(l_error_code, l_error_msg, l_stmt_num);
10710: l_error_count := l_error_count + 1;
10711: GOTO abort_this_job;
10712: end if;

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

11170: and bd.department_id = wo.department_id;
11171:
11172: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11173: l_error_code := -1;
11174: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11175: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11176: l_error_msg := fnd_message.get;
11177: handle_error(l_error_code, l_error_msg, l_stmt_num);
11178: l_error_count := l_error_count + 1;

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

11171:
11172: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11173: l_error_code := -1;
11174: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11175: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11176: l_error_msg := fnd_message.get;
11177: handle_error(l_error_code, l_error_msg, l_stmt_num);
11178: l_error_count := l_error_count + 1;
11179: GOTO abort_this_job;

Line 11176: l_error_msg := fnd_message.get;

11172: if l_scrap_account_10 is null or l_est_scrap_abs_account_10 is null then
11173: l_error_code := -1;
11174: fnd_message.set_name('WSM','WSM_NO_SCRAP_ACC');
11175: fnd_message.set_token('DEPT_ID',to_char(l_department_id));
11176: l_error_msg := fnd_message.get;
11177: handle_error(l_error_code, l_error_msg, l_stmt_num);
11178: l_error_count := l_error_count + 1;
11179: GOTO abort_this_job;
11180: end if;

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

11226: null,
11227: v_wlji_org_id(v_idx),
11228: null, 5)
11229: then
11230: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
11231: l_error_msg := fnd_message.get;
11232: l_warning_count := l_warning_count + 1;
11233: handle_warning(
11234: p_err_msg => l_error_msg,

Line 11231: l_error_msg := fnd_message.get;

11227: v_wlji_org_id(v_idx),
11228: null, 5)
11229: then
11230: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
11231: l_error_msg := fnd_message.get;
11232: l_warning_count := l_warning_count + 1;
11233: handle_warning(
11234: p_err_msg => l_error_msg,
11235: p_header_id => v_wlji_header_id(v_idx),

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

11319: p_supply_status => inv_kanban_pvt.g_supply_status_exception);
11320:
11321: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11322: l_error_code := -1;
11323: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11324: l_stmt_num := 960.1;
11325: select meaning
11326: into l_meaning
11327: from mfg_lookups

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

11328: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11329: and lookup_code = 7
11330: and upper(enabled_flag) = 'Y';
11331:
11332: fnd_message.set_token('STATUS',l_meaning);
11333: l_error_msg := fnd_message.get;
11334: handle_error(l_error_code, l_error_msg, l_stmt_num);
11335: l_error_count := l_error_count + 1;
11336: GOTO abort_this_job;

Line 11333: l_error_msg := fnd_message.get;

11329: and lookup_code = 7
11330: and upper(enabled_flag) = 'Y';
11331:
11332: fnd_message.set_token('STATUS',l_meaning);
11333: l_error_msg := fnd_message.get;
11334: handle_error(l_error_code, l_error_msg, l_stmt_num);
11335: l_error_count := l_error_count + 1;
11336: GOTO abort_this_job;
11337: end if;

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

11944: p_Supply_Status => inv_kanban_pvt.g_supply_status_Exception);
11945:
11946: if ( l_return_status <> fnd_api.g_ret_sts_success ) then
11947: l_error_code := -1;
11948: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
11949: select meaning
11950: into l_meaning
11951: from mfg_lookups
11952: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'

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

11952: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
11953: and lookup_code = 7
11954: and upper(enabled_flag) = 'Y';
11955:
11956: fnd_message.set_token('STATUS',l_meaning);
11957: l_error_msg := fnd_message.get;
11958: handle_error(l_error_code, l_error_msg, l_stmt_num);
11959: l_error_count := l_error_count + 1;
11960: end if;

Line 11957: l_error_msg := fnd_message.get;

11953: and lookup_code = 7
11954: and upper(enabled_flag) = 'Y';
11955:
11956: fnd_message.set_token('STATUS',l_meaning);
11957: l_error_msg := fnd_message.get;
11958: handle_error(l_error_code, l_error_msg, l_stmt_num);
11959: l_error_count := l_error_count + 1;
11960: end if;
11961:

Line 12157: fnd_message.set_name(

12153: x_msg_data := fnd_msg_pub.get(x, 'F');
12154: fnd_file.put_line(fnd_file.log,'Inventory API Error at statement number ' || l_stmt_num || ' : ' || x_msg_data);
12155: end loop;
12156: ELSE
12157: fnd_message.set_name(
12158: application => 'INV',
12159: name => 'INV_PROCESS_FAILED');
12160: fnd_message.set_token(
12161: token => 'PROCESS',

Line 12160: fnd_message.set_token(

12156: ELSE
12157: fnd_message.set_name(
12158: application => 'INV',
12159: name => 'INV_PROCESS_FAILED');
12160: fnd_message.set_token(
12161: token => 'PROCESS',
12162: value => 'TRXNS',
12163: translate => TRUE);
12164: x_msg_data := fnd_message.get;

Line 12164: x_msg_data := fnd_message.get;

12160: fnd_message.set_token(
12161: token => 'PROCESS',
12162: value => 'TRXNS',
12163: translate => TRUE);
12164: x_msg_data := fnd_message.get;
12165: fnd_file.put_line(fnd_file.log,'Inventory API Error at statement number ' || l_stmt_num || ' : ' || x_msg_data);
12166: END IF;
12167: end;
12168:

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

13260:
13261: exception
13262: when e_res_costed then
13263:
13264: fnd_message.set_name('WSM','WSM_OP_RES_COSTED');
13265: x_error_msg := fnd_message.get;
13266: x_error_code := -1;
13267: fnd_file.put_line(fnd_file.log,'delete_setup_info : ' || l_stmt_num || ' : ' || x_error_msg);
13268:

Line 13265: x_error_msg := fnd_message.get;

13261: exception
13262: when e_res_costed then
13263:
13264: fnd_message.set_name('WSM','WSM_OP_RES_COSTED');
13265: x_error_msg := fnd_message.get;
13266: x_error_code := -1;
13267: fnd_file.put_line(fnd_file.log,'delete_setup_info : ' || l_stmt_num || ' : ' || x_error_msg);
13268:
13269: when others then

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

13993: exception
13994:
13995: when e_invalid_res_seq_num then
13996:
13997: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13998: fnd_message.set_token('FLD_NAME', ' resource sequence number ');
13999: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14000:
14001: fnd_file.put_line(fnd_file.log,x_error_msg);

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

13994:
13995: when e_invalid_res_seq_num then
13996:
13997: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
13998: fnd_message.set_token('FLD_NAME', ' resource sequence number ');
13999: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14000:
14001: fnd_file.put_line(fnd_file.log,x_error_msg);
14002:

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

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

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

14002:
14003: x_error_code := -1;
14004:
14005: when e_invalid_par_seq then
14006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14007: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
14008: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14009: fnd_file.put_line(fnd_file.log,x_error_msg);
14010: x_error_code := -1;

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

14003: x_error_code := -1;
14004:
14005: when e_invalid_par_seq then
14006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14007: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
14008: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14009: fnd_file.put_line(fnd_file.log,x_error_msg);
14010: x_error_code := -1;
14011:

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

14004:
14005: when e_invalid_par_seq then
14006: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14007: fnd_message.set_token('FLD_NAME', ' parent resource sequence number ');
14008: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14009: fnd_file.put_line(fnd_file.log,x_error_msg);
14010: x_error_code := -1;
14011:
14012: when e_invalid_res then

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

14011:
14012: when e_invalid_res then
14013: --Bug 4704351:Resource id validation is already done in the prev sql.So
14014: --this exception is used for resource and department mismatch.
14015: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14016: --fnd_message.set_token('FLD_NAME', ' resource id ');
14017: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
14018: --Set up Resource should be from the same department as Parent Resource
14019: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;

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

14012: when e_invalid_res then
14013: --Bug 4704351:Resource id validation is already done in the prev sql.So
14014: --this exception is used for resource and department mismatch.
14015: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14016: --fnd_message.set_token('FLD_NAME', ' resource id ');
14017: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
14018: --Set up Resource should be from the same department as Parent Resource
14019: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14020: fnd_file.put_line(fnd_file.log,x_error_msg);

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

14013: --Bug 4704351:Resource id validation is already done in the prev sql.So
14014: --this exception is used for resource and department mismatch.
14015: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14016: --fnd_message.set_token('FLD_NAME', ' resource id ');
14017: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
14018: --Set up Resource should be from the same department as Parent Resource
14019: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14020: fnd_file.put_line(fnd_file.log,x_error_msg);
14021: x_error_code := -1;

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

14015: --fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14016: --fnd_message.set_token('FLD_NAME', ' resource id ');
14017: fnd_message.set_name('WSM','WSM_INVALID_RES_DEPT');
14018: --Set up Resource should be from the same department as Parent Resource
14019: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14020: fnd_file.put_line(fnd_file.log,x_error_msg);
14021: x_error_code := -1;
14022:
14023: when e_invalid_res_dates then

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

14020: fnd_file.put_line(fnd_file.log,x_error_msg);
14021: x_error_code := -1;
14022:
14023: when e_invalid_res_dates then
14024: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14025: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
14026: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14027: fnd_file.put_line(fnd_file.log,x_error_msg);
14028: x_error_code := -1;

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

14021: x_error_code := -1;
14022:
14023: when e_invalid_res_dates then
14024: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14025: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
14026: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14027: fnd_file.put_line(fnd_file.log,x_error_msg);
14028: x_error_code := -1;
14029:

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

14022:
14023: when e_invalid_res_dates then
14024: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14025: fnd_message.set_token('FLD_NAME', ' resource start/completion dates ');
14026: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14027: fnd_file.put_line(fnd_file.log,x_error_msg);
14028: x_error_code := -1;
14029:
14030: when e_invalid_res_seq then

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

14028: x_error_code := -1;
14029:
14030: when e_invalid_res_seq then
14031:
14032: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14033: fnd_message.set_token('FLD_NAME', ' resource seq num ');
14034: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14035: fnd_file.put_line(fnd_file.log,x_error_msg);
14036: x_error_code := -1;

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

14029:
14030: when e_invalid_res_seq then
14031:
14032: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14033: fnd_message.set_token('FLD_NAME', ' resource seq num ');
14034: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14035: fnd_file.put_line(fnd_file.log,x_error_msg);
14036: x_error_code := -1;
14037:

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

14030: when e_invalid_res_seq then
14031:
14032: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14033: fnd_message.set_token('FLD_NAME', ' resource seq num ');
14034: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14035: fnd_file.put_line(fnd_file.log,x_error_msg);
14036: x_error_code := -1;
14037:
14038: when e_invalid_seq then

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

14035: fnd_file.put_line(fnd_file.log,x_error_msg);
14036: x_error_code := -1;
14037:
14038: when e_invalid_seq then
14039: fnd_message.set_name('WSM','WSM_INVALID_SEQ');
14040: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
14041: fnd_file.put_line(fnd_file.log,x_error_msg);
14042: x_error_code := -1;
14043:

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

14036: x_error_code := -1;
14037:
14038: when e_invalid_seq then
14039: fnd_message.set_name('WSM','WSM_INVALID_SEQ');
14040: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
14041: fnd_file.put_line(fnd_file.log,x_error_msg);
14042: x_error_code := -1;
14043:
14044: when e_invalid_setup_id then

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

14041: fnd_file.put_line(fnd_file.log,x_error_msg);
14042: x_error_code := -1;
14043:
14044: when e_invalid_setup_id then
14045: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14046: fnd_message.set_token('FLD_NAME', ' setup id ');
14047: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
14048: fnd_file.put_line(fnd_file.log,x_error_msg);
14049: x_error_code := -1;

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

14042: x_error_code := -1;
14043:
14044: when e_invalid_setup_id then
14045: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14046: fnd_message.set_token('FLD_NAME', ' setup id ');
14047: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
14048: fnd_file.put_line(fnd_file.log,x_error_msg);
14049: x_error_code := -1;
14050:

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

14043:
14044: when e_invalid_setup_id then
14045: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14046: fnd_message.set_token('FLD_NAME', ' setup id ');
14047: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get ;
14048: fnd_file.put_line(fnd_file.log,x_error_msg);
14049: x_error_code := -1;
14050:
14051: when e_invalid_field then

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

14049: x_error_code := -1;
14050:
14051: when e_invalid_field then
14052: /*Modified error handling mechanism for bug 5469917. */
14053: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14054: fnd_message.set_token('FLD_NAME', l_field_name);
14055: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14056: fnd_file.put_line(fnd_file.log,x_error_msg);
14057: x_error_code := -1;

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

14050:
14051: when e_invalid_field then
14052: /*Modified error handling mechanism for bug 5469917. */
14053: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14054: fnd_message.set_token('FLD_NAME', l_field_name);
14055: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14056: fnd_file.put_line(fnd_file.log,x_error_msg);
14057: x_error_code := -1;
14058:

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

14051: when e_invalid_field then
14052: /*Modified error handling mechanism for bug 5469917. */
14053: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14054: fnd_message.set_token('FLD_NAME', l_field_name);
14055: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14056: fnd_file.put_line(fnd_file.log,x_error_msg);
14057: x_error_code := -1;
14058:
14059: when e_invalid_max_assg_units then

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

14057: x_error_code := -1;
14058:
14059: when e_invalid_max_assg_units then
14060:
14061: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14062: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
14063: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14064: fnd_file.put_line(fnd_file.log,x_error_msg);
14065: x_error_code := -1;

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

14058:
14059: when e_invalid_max_assg_units then
14060:
14061: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14062: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
14063: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14064: fnd_file.put_line(fnd_file.log,x_error_msg);
14065: x_error_code := -1;
14066:

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

14059: when e_invalid_max_assg_units then
14060:
14061: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14062: fnd_message.set_token('FLD_NAME', ' maximum assigned units ');
14063: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14064: fnd_file.put_line(fnd_file.log,x_error_msg);
14065: x_error_code := -1;
14066:
14067: when e_invalid_setup_max_assg_units then

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

14065: x_error_code := -1;
14066:
14067: when e_invalid_setup_max_assg_units then
14068:
14069: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
14070:
14071: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14072:
14073: fnd_file.put_line(fnd_file.log,x_error_msg);

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

14067: when e_invalid_setup_max_assg_units then
14068:
14069: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
14070:
14071: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14072:
14073: fnd_file.put_line(fnd_file.log,x_error_msg);
14074: x_error_code := -1;
14075:

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

14074: x_error_code := -1;
14075:
14076: when e_setup_costed then
14077:
14078: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
14079:
14080: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14081: fnd_file.put_line(fnd_file.log,x_error_msg);
14082: x_error_code := -1;

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

14076: when e_setup_costed then
14077:
14078: fnd_message.set_name('WSM','WSM_INVALID_SETUP_MAX_ASSG');
14079:
14080: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14081: fnd_file.put_line(fnd_file.log,x_error_msg);
14082: x_error_code := -1;
14083:
14084: when e_invalid_batch_max_assg_units then

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

14082: x_error_code := -1;
14083:
14084: when e_invalid_batch_max_assg_units then
14085:
14086: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
14087:
14088: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14089: x_error_code := -1;
14090: fnd_file.put_line(fnd_file.log,x_error_msg);

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

14084: when e_invalid_batch_max_assg_units then
14085:
14086: fnd_message.set_name('WSM','WSM_INVALID_BATCH_MAX_ASSG');
14087:
14088: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14089: x_error_code := -1;
14090: fnd_file.put_line(fnd_file.log,x_error_msg);
14091:
14092: when e_res_not_batchable then

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

14090: fnd_file.put_line(fnd_file.log,x_error_msg);
14091:
14092: when e_res_not_batchable then
14093:
14094: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14095: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
14096:
14097: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14098: fnd_file.put_line(fnd_file.log,x_error_msg);

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

14091:
14092: when e_res_not_batchable then
14093:
14094: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14095: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
14096:
14097: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14098: fnd_file.put_line(fnd_file.log,x_error_msg);
14099: x_error_code := -1;

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

14093:
14094: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
14095: fnd_message.set_token('FLD_NAME', ' batch id for resource ');
14096:
14097: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14098: fnd_file.put_line(fnd_file.log,x_error_msg);
14099: x_error_code := -1;
14100:
14101: when e_no_po_move_res then

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

14098: fnd_file.put_line(fnd_file.log,x_error_msg);
14099: x_error_code := -1;
14100:
14101: when e_no_po_move_res then
14102: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
14103: fnd_message.set_token('FLD_NAME', ' resource ');
14104: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14105: fnd_file.put_line(fnd_file.log,x_error_msg);
14106: x_error_code := -1;

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

14099: x_error_code := -1;
14100:
14101: when e_no_po_move_res then
14102: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
14103: fnd_message.set_token('FLD_NAME', ' resource ');
14104: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14105: fnd_file.put_line(fnd_file.log,x_error_msg);
14106: x_error_code := -1;
14107:

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

14100:
14101: when e_no_po_move_res then
14102: fnd_message.set_name('WSM','WSM_CURR_OP_RES_PO_MOVE');
14103: fnd_message.set_token('FLD_NAME', ' resource ');
14104: x_error_msg := ' validate_new_resource : ' || l_stmt_num || ': ' || fnd_message.get;
14105: fnd_file.put_line(fnd_file.log,x_error_msg);
14106: x_error_code := -1;
14107:
14108: when others then

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

14298:
14299: end if;
14300: else
14301: /* error out.... */
14302: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14303: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14304: x_error_msg := fnd_message.get;
14305: x_error_code := -1;
14306: return; --raise e_wljdi_common_error;

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

14299: end if;
14300: else
14301: /* error out.... */
14302: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14303: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14304: x_error_msg := fnd_message.get;
14305: x_error_code := -1;
14306: return; --raise e_wljdi_common_error;
14307: end if;

Line 14304: x_error_msg := fnd_message.get;

14300: else
14301: /* error out.... */
14302: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14303: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14304: x_error_msg := fnd_message.get;
14305: x_error_code := -1;
14306: return; --raise e_wljdi_common_error;
14307: end if;
14308: l_stmt_num := 80;

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

14656:
14657: else
14658:
14659: /* error out.... cannt delete previous op resources.... */
14660: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14661: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14662: x_error_msg := fnd_message.get;
14663: x_error_code := -1;
14664: return; --raise e_wljdi_common_error;

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

14657: else
14658:
14659: /* error out.... cannt delete previous op resources.... */
14660: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14661: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14662: x_error_msg := fnd_message.get;
14663: x_error_code := -1;
14664: return; --raise e_wljdi_common_error;
14665:

Line 14662: x_error_msg := fnd_message.get;

14658:
14659: /* error out.... cannt delete previous op resources.... */
14660: fnd_message.set_name('WSM','WSM_NULL_FIELD');
14661: fnd_message.set_token('FLD_NAME', 'job_op_seq_num/rtg_op_seq_num');
14662: x_error_msg := fnd_message.get;
14663: x_error_code := -1;
14664: return; --raise e_wljdi_common_error;
14665:
14666: end if;

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

16073: l_res_ins_first := l_d;
16074: end if;
16075:
16076: else
16077: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16078: fnd_message.set_token('FLD_NAME', 'Load_type');
16079: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
16080: || fnd_message.get;
16081: p_error_code := -1;

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

16074: end if;
16075:
16076: else
16077: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16078: fnd_message.set_token('FLD_NAME', 'Load_type');
16079: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
16080: || fnd_message.get;
16081: p_error_code := -1;
16082: raise e_wljdi_common_error;

Line 16080: || fnd_message.get;

16076: else
16077: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16078: fnd_message.set_token('FLD_NAME', 'Load_type');
16079: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
16080: || fnd_message.get;
16081: p_error_code := -1;
16082: raise e_wljdi_common_error;
16083: end if;
16084: ---------------------------------------------------------------------------

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

16115: end if;
16116:
16117: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
16118: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
16119: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16120: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
16121: p_error_msg := fnd_message.get;
16122: p_error_code := - 1;
16123: raise e_wljdi_common_error;

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

16116:
16117: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
16118: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
16119: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16120: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
16121: p_error_msg := fnd_message.get;
16122: p_error_code := - 1;
16123: raise e_wljdi_common_error;
16124: end if;

Line 16121: p_error_msg := fnd_message.get;

16117: if v_wljdi_scheduled_quantity(l_d) IS NOT NULL then
16118: if v_wljdi_scheduled_quantity(l_d) <= 0 or v_wljdi_scheduled_quantity(l_d) > l_cur_job_qty then
16119: fnd_message.set_name('WSM','WSM_NULL_FIELD');
16120: fnd_message.set_token('FLD_NAME', 'scheduled_quantity');
16121: p_error_msg := fnd_message.get;
16122: p_error_code := - 1;
16123: raise e_wljdi_common_error;
16124: end if;
16125: else

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

16297: FROM bom_std_sub_op_resources bsor
16298: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16299: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE);
16300: if l_temp=1 then
16301: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
16302: p_error_msg := fnd_message.get;
16303: p_error_code := - 1;
16304: raise e_wljdi_common_error;
16305: end if;

Line 16302: p_error_msg := fnd_message.get;

16298: WHERE bsor.standard_operation_id = v_wljdi_std_op_id(l_d)
16299: AND bsor.autocharge_type = WIP_CONSTANTS.PO_MOVE);
16300: if l_temp=1 then
16301: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
16302: p_error_msg := fnd_message.get;
16303: p_error_code := - 1;
16304: raise e_wljdi_common_error;
16305: end if;
16306: exception

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

16306: exception
16307: when no_data_found then
16308: null;
16309: when others then
16310: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
16311: p_error_msg := fnd_message.get;
16312: p_error_code := - 1;
16313: raise e_wljdi_common_error;
16314: end;

Line 16311: p_error_msg := fnd_message.get;

16307: when no_data_found then
16308: null;
16309: when others then
16310: fnd_message.set_name('WSM','WSM_OP_PO_MOVE');
16311: p_error_msg := fnd_message.get;
16312: p_error_code := - 1;
16313: raise e_wljdi_common_error;
16314: end;
16315: l_temp :=0;

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

16660: and from_op_seq_num= v_wljdi_routing_op_seq_num(l_d)
16661: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16662:
16663: if sql%notfound then
16664: fnd_message.set_name('WSM','WSM_INV_DEL_LINK');
16665: p_error_msg := fnd_message.get;
16666: p_error_code := - 1;
16667: raise e_wljdi_common_error;
16668: end if;

Line 16665: p_error_msg := fnd_message.get;

16661: and to_op_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16662:
16663: if sql%notfound then
16664: fnd_message.set_name('WSM','WSM_INV_DEL_LINK');
16665: p_error_msg := fnd_message.get;
16666: p_error_code := - 1;
16667: raise e_wljdi_common_error;
16668: end if;
16669: else /* This is for substitution_type add. */

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

16676: exception
16677: when no_data_found then
16678: l_link_exists := 0;
16679: when too_many_rows then
16680: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16681: p_error_msg := fnd_message.get;
16682: p_error_code := - 1;
16683: raise e_wljdi_common_error;
16684: end;

Line 16681: p_error_msg := fnd_message.get;

16677: when no_data_found then
16678: l_link_exists := 0;
16679: when too_many_rows then
16680: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16681: p_error_msg := fnd_message.get;
16682: p_error_code := - 1;
16683: raise e_wljdi_common_error;
16684: end;
16685:

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

16683: raise e_wljdi_common_error;
16684: end;
16685:
16686: if l_link_exists <> 0 then
16687: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16688: p_error_msg := fnd_message.get;
16689: p_error_code := - 1;
16690: raise e_wljdi_common_error;
16691: end if;

Line 16688: p_error_msg := fnd_message.get;

16684: end;
16685:
16686: if l_link_exists <> 0 then
16687: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16688: p_error_msg := fnd_message.get;
16689: p_error_code := - 1;
16690: raise e_wljdi_common_error;
16691: end if;
16692:

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

16705: and operation_seq_num = v_wljdi_next_rtg_op_seq_num(l_d);
16706:
16707: exception
16708: when no_data_found then
16709: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16710: p_error_msg := fnd_message.get;
16711: p_error_code := - 1;
16712: raise e_wljdi_common_error;
16713: when others then

Line 16710: p_error_msg := fnd_message.get;

16706:
16707: exception
16708: when no_data_found then
16709: fnd_message.set_name('WSM','WSM_DUP_NETWORK_LINK');
16710: p_error_msg := fnd_message.get;
16711: p_error_code := - 1;
16712: raise e_wljdi_common_error;
16713: when others then
16714: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');

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

16710: p_error_msg := fnd_message.get;
16711: p_error_code := - 1;
16712: raise e_wljdi_common_error;
16713: when others then
16714: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');
16715: p_error_msg := fnd_message.get;
16716: p_error_code := - 1;
16717: raise e_wljdi_common_error;
16718: end;

Line 16715: p_error_msg := fnd_message.get;

16711: p_error_code := - 1;
16712: raise e_wljdi_common_error;
16713: when others then
16714: fnd_message.set_name('WSM','WSM_INV_NETWORK_LINK');
16715: p_error_msg := fnd_message.get;
16716: p_error_code := - 1;
16717: raise e_wljdi_common_error;
16718: end;
16719:

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

16919: raise e_invalid_recommend_path;
16920: end if;
16921: else
16922: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16923: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16924: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16925: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16926: p_error_code := - 1;
16927: raise e_wljdi_common_error;

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

16920: end if;
16921: else
16922: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16923: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16924: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16925: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16926: p_error_code := - 1;
16927: raise e_wljdi_common_error;
16928: end if;

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

16921: else
16922: if ( (l_fm_op IS NULL) or (l_to_op IS NULL) )then
16923: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
16924: fnd_message.set_token('FLD_NAME', 'Routing_op_seq and Next_routing_op_seq Combination.');
16925: p_error_msg := 'WLJDI(record_id ='||v_wljdi_record_id(l_d)||') '||fnd_message.get;
16926: p_error_code := - 1;
16927: raise e_wljdi_common_error;
16928: end if;
16929: end if;

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

17393: -- Added For LBJ Interface Alcoa Enhancement
17394: else
17395: if l_sub_type = WSM_SUB_DEL then
17396: if l_rtg_op_seq_num is null then
17397: fnd_message.set_name('WSM','WSM_NULL_FIELD');
17398: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
17399: p_error_msg := fnd_message.get;
17400: p_error_code := -1;
17401: raise e_wljdi_common_error;

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

17394: else
17395: if l_sub_type = WSM_SUB_DEL then
17396: if l_rtg_op_seq_num is null then
17397: fnd_message.set_name('WSM','WSM_NULL_FIELD');
17398: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
17399: p_error_msg := fnd_message.get;
17400: p_error_code := -1;
17401: raise e_wljdi_common_error;
17402: else

Line 17399: p_error_msg := fnd_message.get;

17395: if l_sub_type = WSM_SUB_DEL then
17396: if l_rtg_op_seq_num is null then
17397: fnd_message.set_name('WSM','WSM_NULL_FIELD');
17398: fnd_message.set_token('FLD_NAME', 'Routing_op_seq_num');
17399: p_error_msg := fnd_message.get;
17400: p_error_code := -1;
17401: raise e_wljdi_common_error;
17402: else
17403: -- Validate for start or end operation.

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

17411: and wco.operation_seq_num = l_rtg_op_seq_num
17412: and wco.network_start_end is null;
17413: exception
17414: when others then
17415: fnd_message.set_name('WSM','WSM_NW_START_END_NO_DEL');
17416: p_error_msg := fnd_message.get;
17417: p_error_code := -1;
17418: raise e_wljdi_common_error;
17419: end;

Line 17416: p_error_msg := fnd_message.get;

17412: and wco.network_start_end is null;
17413: exception
17414: when others then
17415: fnd_message.set_name('WSM','WSM_NW_START_END_NO_DEL');
17416: p_error_msg := fnd_message.get;
17417: p_error_code := -1;
17418: raise e_wljdi_common_error;
17419: end;
17420: -- Validate for any existing links with this operation.

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

17436: and to_op_seq_num = l_rtg_op_seq_num);
17437:
17438: if l_temp=1 THEN
17439:
17440: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17441: p_error_msg := fnd_message.get;
17442: p_error_code := -1;
17443: raise e_wljdi_common_error;
17444: end if;

Line 17441: p_error_msg := fnd_message.get;

17437:
17438: if l_temp=1 THEN
17439:
17440: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17441: p_error_msg := fnd_message.get;
17442: p_error_code := -1;
17443: raise e_wljdi_common_error;
17444: end if;
17445:

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

17446: exception
17447: when no_data_found then
17448: null;
17449: when others then
17450: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17451: p_error_msg := fnd_message.get;
17452: p_error_code := -1;
17453: raise e_wljdi_common_error;
17454: end;

Line 17451: p_error_msg := fnd_message.get;

17447: when no_data_found then
17448: null;
17449: when others then
17450: fnd_message.set_name('WSM','WSM_NET_LINK_EXIST');
17451: p_error_msg := fnd_message.get;
17452: p_error_code := -1;
17453: raise e_wljdi_common_error;
17454: end;
17455: end if;

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

18517: when too_many_rows then
18518: l_exists := 1;
18519: end;
18520: if(l_exists = 1) then
18521: fnd_message.set_name(application => 'WIP',
18522: name => 'WIP_REPLACE_APPLIED_RES');
18523: p_error_msg := fnd_message.get;
18524: p_error_code := -1;
18525: raise e_wljdi_common_error;

Line 18523: p_error_msg := fnd_message.get;

18519: end;
18520: if(l_exists = 1) then
18521: fnd_message.set_name(application => 'WIP',
18522: name => 'WIP_REPLACE_APPLIED_RES');
18523: p_error_msg := fnd_message.get;
18524: p_error_code := -1;
18525: raise e_wljdi_common_error;
18526: end if;
18527: l_stmt_num := 250.5;

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

19922: if l_sub_type in (WSM_SUB_DEL, WSM_SUB_ADD) then
19923: -- Modified for Alcoa Enhancement
19924: -- if(l_job_op_seq_num IS NULL) then
19925: --l_stmt_num := 510;
19926: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19927: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19928: -- p_error_msg := fnd_message.get;
19929: -- p_error_code := -1;
19930: -- raise e_wljdi_common_error;

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

19923: -- Modified for Alcoa Enhancement
19924: -- if(l_job_op_seq_num IS NULL) then
19925: --l_stmt_num := 510;
19926: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19927: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19928: -- p_error_msg := fnd_message.get;
19929: -- p_error_code := -1;
19930: -- raise e_wljdi_common_error;
19931: -- else

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

19924: -- if(l_job_op_seq_num IS NULL) then
19925: --l_stmt_num := 510;
19926: -- fnd_message.set_name('WSM','WSM_NULL_FIELD');
19927: -- fnd_message.set_token('FLD_NAME', 'job_op_seq_num');
19928: -- p_error_msg := fnd_message.get;
19929: -- p_error_code := -1;
19930: -- raise e_wljdi_common_error;
19931: -- else
19932: -- fnd_file.put_line(fnd_file.log,

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

20434: FROM BOM_PARAMETERS
20435: WHERE ORGANIZATION_ID = p_org_id;
20436:
20437: IF (l_use_phantom_routings = 1 and l_sub_type = WSM_SUB_REC) THEN
20438: fnd_message.set_name('WSM','WSM_COMP_USE_PHANTOM_RTG');
20439: p_error_msg := fnd_message.get;
20440: p_error_code := -1;
20441: raise e_wljdi_common_error;
20442: end if;

Line 20439: p_error_msg := fnd_message.get;

20435: WHERE ORGANIZATION_ID = p_org_id;
20436:
20437: IF (l_use_phantom_routings = 1 and l_sub_type = WSM_SUB_REC) THEN
20438: fnd_message.set_name('WSM','WSM_COMP_USE_PHANTOM_RTG');
20439: p_error_msg := fnd_message.get;
20440: p_error_code := -1;
20441: raise e_wljdi_common_error;
20442: end if;
20443:

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

20646:
20647: EXCEPTION
20648: when e_invalid_recommend_path then
20649: ROLLBACK to start_import_details;
20650: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
20651: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20652: || fnd_message.get;
20653: p_error_code := -1;
20654: fnd_file.put_line(fnd_file.log,

Line 20652: || fnd_message.get;

20648: when e_invalid_recommend_path then
20649: ROLLBACK to start_import_details;
20650: fnd_message.set_name('WSM','WSM_INVALID_RECO_LINK');
20651: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20652: || fnd_message.get;
20653: p_error_code := -1;
20654: fnd_file.put_line(fnd_file.log,
20655: substr('import_lot_job_details: (#'||l_stmt_num||') '
20656: || p_error_msg, 1, 2000));

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

20656: || p_error_msg, 1, 2000));
20657:
20658: when e_invalid_discommend_path then
20659: ROLLBACK to start_import_details;
20660: fnd_message.set_name('WSM','WSM_INVALID_DISCO_LINK');
20661: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20662: || fnd_message.get;
20663: p_error_code := -1;
20664: fnd_file.put_line(fnd_file.log,

Line 20662: || fnd_message.get;

20658: when e_invalid_discommend_path then
20659: ROLLBACK to start_import_details;
20660: fnd_message.set_name('WSM','WSM_INVALID_DISCO_LINK');
20661: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20662: || fnd_message.get;
20663: p_error_code := -1;
20664: fnd_file.put_line(fnd_file.log,
20665: substr('import_lot_job_details: (#'||l_stmt_num||') '
20666: || p_error_msg, 1, 2000));

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

20667:
20668:
20669: when e_invalid_sub_load_type then
20670: ROLLBACK to start_import_details;
20671: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20672: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20673: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20674: || fnd_message.get;
20675: p_error_code := -1;

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

20668:
20669: when e_invalid_sub_load_type then
20670: ROLLBACK to start_import_details;
20671: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20672: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20673: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20674: || fnd_message.get;
20675: p_error_code := -1;
20676: fnd_file.put_line(fnd_file.log,

Line 20674: || fnd_message.get;

20670: ROLLBACK to start_import_details;
20671: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
20672: fnd_message.set_token('FLD_NAME', 'load_type and substitution_type');
20673: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20674: || fnd_message.get;
20675: p_error_code := -1;
20676: fnd_file.put_line(fnd_file.log,
20677: substr('import_lot_job_details: (#'||l_stmt_num||') '
20678: || p_error_msg, 1, 2000));

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

20678: || p_error_msg, 1, 2000));
20679:
20680: when e_invalid_op_seq_num then
20681: ROLLBACK to start_import_details;
20682: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20683: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20684: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20685: || fnd_message.get;
20686: p_error_code := -1;

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

20679:
20680: when e_invalid_op_seq_num then
20681: ROLLBACK to start_import_details;
20682: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20683: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20684: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20685: || fnd_message.get;
20686: p_error_code := -1;
20687: fnd_file.put_line(fnd_file.log,

Line 20685: || fnd_message.get;

20681: ROLLBACK to start_import_details;
20682: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20683: fnd_message.set_token('FLD_NAME', 'job_op_seq_num and routing_op_seq_num');
20684: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20685: || fnd_message.get;
20686: p_error_code := -1;
20687: fnd_file.put_line(fnd_file.log,
20688: substr('import_lot_job_details: (#'||l_stmt_num||') '
20689: || p_error_msg, 1, 2000));

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

20698: || p_error_msg, 1, 2000));
20699:
20700: when e_null_comp_seq_id then
20701: ROLLBACK to start_import_details;
20702: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20703: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20704: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20705: || fnd_message.get;
20706: p_error_code := -1;

Line 20703: fnd_message.set_token('FLD_NAME', 'component_seq_id');

20699:
20700: when e_null_comp_seq_id then
20701: ROLLBACK to start_import_details;
20702: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20703: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20704: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20705: || fnd_message.get;
20706: p_error_code := -1;
20707: fnd_file.put_line(fnd_file.log,

Line 20705: || fnd_message.get;

20701: ROLLBACK to start_import_details;
20702: fnd_message.set_name('WSM','WSM_NULL_FIELD');
20703: fnd_message.set_token('FLD_NAME', 'component_seq_id');
20704: p_error_msg := 'WLJDI(record_id =' || v_wljdi_record_id(l_d) || ') '
20705: || fnd_message.get;
20706: p_error_code := -1;
20707: fnd_file.put_line(fnd_file.log,
20708: substr('import_lot_job_details: (#'||l_stmt_num||') '
20709: || p_error_msg, 1, 2000));

Line 21113: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

21109: -- p_organization_id => p_organization_id,
21110: -- p_date => trunc(nvl(p_release_date, sysdate)) );
21111: --if(p_error_code <> 0) then
21112: -- p_error_code := -1;
21113: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21114: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21115: -- p_err_msg := fnd_message.get;
21116: -- return;
21117: --end if;

Line 21114: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');

21110: -- p_date => trunc(nvl(p_release_date, sysdate)) );
21111: --if(p_error_code <> 0) then
21112: -- p_error_code := -1;
21113: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21114: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21115: -- p_err_msg := fnd_message.get;
21116: -- return;
21117: --end if;
21118: -- ED: bugfix 3299811

Line 21115: -- p_err_msg := fnd_message.get;

21111: --if(p_error_code <> 0) then
21112: -- p_error_code := -1;
21113: -- fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21114: -- fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21115: -- p_err_msg := fnd_message.get;
21116: -- return;
21117: --end if;
21118: -- ED: bugfix 3299811
21119:

Line 21213: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');

21209:
21210: --if SQL%NOTFOUND then -- bug 3571360
21211: if l_cnt <= 0 then -- bug 3571360
21212: p_error_code := -1;
21213: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21214: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21215: p_err_msg := fnd_message.get;
21216: end if;
21217:

Line 21214: fnd_message.set_token('FLD_NAME','Wip Accounting Period');

21210: --if SQL%NOTFOUND then -- bug 3571360
21211: if l_cnt <= 0 then -- bug 3571360
21212: p_error_code := -1;
21213: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21214: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21215: p_err_msg := fnd_message.get;
21216: end if;
21217:
21218: exception

Line 21215: p_err_msg := fnd_message.get;

21211: if l_cnt <= 0 then -- bug 3571360
21212: p_error_code := -1;
21213: fnd_message.set_name('WIP', 'WIP_NO_ACCT_PERIOD');
21214: fnd_message.set_token('FLD_NAME','Wip Accounting Period');
21215: p_err_msg := fnd_message.get;
21216: end if;
21217:
21218: exception
21219: when others then

Line 21336: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');

21332: p_routing_rev_date => p_routing_revision_date,
21333: x_err_code => p_error_code,
21334: x_err_msg => p_error_msg)
21335: then
21336: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
21337: p_error_code := -1;
21338: p_error_msg := fnd_message.get;
21339: raise e_build_job_dtl;
21340: end if;

Line 21338: p_error_msg := fnd_message.get;

21334: x_err_msg => p_error_msg)
21335: then
21336: fnd_message.set_name('WSM','WSM_FIRST_OP_PO_MOVE');
21337: p_error_code := -1;
21338: p_error_msg := fnd_message.get;
21339: raise e_build_job_dtl;
21340: end if;
21341: end if;
21342: --osp end

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

21694: p_org_id => p_org_id,
21695: p_job_type => p_job_type) = 1 and
21696: (l_est_scrap_account is null or l_est_scrap_var_account is null)
21697: then
21698: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21699: fnd_message.set_token('CC',p_class_code);
21700: p_error_code := -1;
21701: p_error_msg := fnd_message.get;
21702: raise e_build_job;

Line 21699: fnd_message.set_token('CC',p_class_code);

21695: p_job_type => p_job_type) = 1 and
21696: (l_est_scrap_account is null or l_est_scrap_var_account is null)
21697: then
21698: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21699: fnd_message.set_token('CC',p_class_code);
21700: p_error_code := -1;
21701: p_error_msg := fnd_message.get;
21702: raise e_build_job;
21703: end if;

Line 21701: p_error_msg := fnd_message.get;

21697: then
21698: fnd_message.set_name('WSM','WSM_NO_WAC_SCRAP_ACC');
21699: fnd_message.set_token('CC',p_class_code);
21700: p_error_code := -1;
21701: p_error_msg := fnd_message.get;
21702: raise e_build_job;
21703: end if;
21704:
21705:

Line 21964: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');

21960: mtl_gen_object_id_s.nextval
21961: );
21962: exception
21963: when others then
21964: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');
21965: p_error_code := -1;
21966: p_error_msg := fnd_message.get;
21967: raise e_build_job;
21968: end;

Line 21966: p_error_msg := fnd_message.get;

21962: exception
21963: when others then
21964: fnd_message.set_name('WSM', 'WSM_UNIQUE_LOT_CREATE');
21965: p_error_code := -1;
21966: p_error_msg := fnd_message.get;
21967: raise e_build_job;
21968: end;
21969: if lbji_debug = 'Y' then
21970: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into we');

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

21991: where lookup_type = 'MTL_KANBAN_SUPPLY_STATUS'
21992: and lookup_code = 5
21993: and upper(enabled_flag) = 'Y';
21994:
21995: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21996: fnd_message.set_token('STATUS',l_translated_meaning);
21997: p_error_code := -1;
21998: p_error_msg := fnd_message.get;
21999: raise e_build_job;

Line 21996: fnd_message.set_token('STATUS',l_translated_meaning);

21992: and lookup_code = 5
21993: and upper(enabled_flag) = 'Y';
21994:
21995: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21996: fnd_message.set_token('STATUS',l_translated_meaning);
21997: p_error_code := -1;
21998: p_error_msg := fnd_message.get;
21999: raise e_build_job;
22000: end if;

Line 21998: p_error_msg := fnd_message.get;

21994:
21995: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
21996: fnd_message.set_token('STATUS',l_translated_meaning);
21997: p_error_code := -1;
21998: p_error_msg := fnd_message.get;
21999: raise e_build_job;
22000: end if;
22001: end if;
22002: