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.WSMPUTIL dependencies on FND_MESSAGE

Line 205: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');

201: WHERE routing_sequence_id = p_routing_sequence_id
202: );
203: IF(l_count = 0) THEN
204: x_err_code := -1;
205: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');
206: x_err_msg := FND_MESSAGE.GET;
207: RETURN;
208: END IF;
209: -- EA: CZH.I_OED-1.BUG2558058

Line 206: x_err_msg := FND_MESSAGE.GET;

202: );
203: IF(l_count = 0) THEN
204: x_err_code := -1;
205: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');
206: x_err_msg := FND_MESSAGE.GET;
207: RETURN;
208: END IF;
209: -- EA: CZH.I_OED-1.BUG2558058
210:

Line 217: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_FOUND');

213: FETCH get_start INTO start_op_seq_id;
214:
215: IF get_start%NOTFOUND THEN
216: x_err_code := -2; -- CZH I_OED-1, BUG2558058 changed to -2
217: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_FOUND');
218: x_err_msg:= FND_MESSAGE.GET;
219: RETURN;
220: END IF;
221:

Line 218: x_err_msg:= FND_MESSAGE.GET;

214:
215: IF get_start%NOTFOUND THEN
216: x_err_code := -2; -- CZH I_OED-1, BUG2558058 changed to -2
217: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_FOUND');
218: x_err_msg:= FND_MESSAGE.GET;
219: RETURN;
220: END IF;
221:
222: LOOP

Line 225: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_STARTS');

221:
222: LOOP
223: IF get_start%ROWCOUNT >1 THEN
224: x_err_code := -2; -- CZH I_OED-1
225: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_STARTS');
226: x_err_msg:= FND_MESSAGE.GET;
227: RETURN;
228: END IF;
229:

Line 226: x_err_msg:= FND_MESSAGE.GET;

222: LOOP
223: IF get_start%ROWCOUNT >1 THEN
224: x_err_code := -2; -- CZH I_OED-1
225: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_STARTS');
226: x_err_msg:= FND_MESSAGE.GET;
227: RETURN;
228: END IF;
229:
230: FETCH get_start INTO start_op_seq_id;

Line 254: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_EFFECTIVE');

250: IF(NVL(WSMPUTIL.replacement_op_seq_id(
251: start_op_seq_id,
252: l_rtg_rev_date), -1) = -1) THEN -- ADD: CZH.I_OED-2
253: x_err_code := -3;
254: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_EFFECTIVE');
255: x_err_msg:= FND_MESSAGE.GET;
256: RETURN;
257: END IF; -- ADD: CZH.I_OED-2
258: END IF;

Line 255: x_err_msg:= FND_MESSAGE.GET;

251: start_op_seq_id,
252: l_rtg_rev_date), -1) = -1) THEN -- ADD: CZH.I_OED-2
253: x_err_code := -3;
254: FND_MESSAGE.SET_NAME('WSM','WSM_NET_START_NOT_EFFECTIVE');
255: x_err_msg:= FND_MESSAGE.GET;
256: RETURN;
257: END IF; -- ADD: CZH.I_OED-2
258: END IF;
259:

Line 272: FND_MESSAGE.SET_NAME('WSM','WSM_FIRST_OP_PO_MOVE');

268: x_err_code => x_err_code ,
269: x_err_msg => x_err_msg ) then
270:
271: x_err_code := -4;
272: FND_MESSAGE.SET_NAME('WSM','WSM_FIRST_OP_PO_MOVE');
273: x_err_msg:= FND_MESSAGE.GET;
274: RETURN;
275: end if;
276:

Line 273: x_err_msg:= FND_MESSAGE.GET;

269: x_err_msg => x_err_msg ) then
270:
271: x_err_code := -4;
272: FND_MESSAGE.SET_NAME('WSM','WSM_FIRST_OP_PO_MOVE');
273: x_err_msg:= FND_MESSAGE.GET;
274: RETURN;
275: end if;
276:
277: -- OSP End Changes

Line 373: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');

369: WHERE routing_sequence_id = p_routing_sequence_id
370: );
371: IF(l_count = 0) THEN
372: x_err_code := -1;
373: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');
374: x_err_msg := FND_MESSAGE.GET;
375: RETURN;
376: END IF;
377: -- EA: CZH.I_OED-1.BUG2558058

Line 374: x_err_msg := FND_MESSAGE.GET;

370: );
371: IF(l_count = 0) THEN
372: x_err_code := -1;
373: FND_MESSAGE.SET_NAME('WSM','WSM_NO_NETWORK_EXISTS');
374: x_err_msg := FND_MESSAGE.GET;
375: RETURN;
376: END IF;
377: -- EA: CZH.I_OED-1.BUG2558058
378:

Line 384: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_FOUND');

380: FETCH get_end INTO end_op_seq_id;
381:
382: IF get_end%NOTFOUND THEN
383: x_err_code := -2; -- CZH I_OED-1, BUG2558058 changed to -2
384: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_FOUND');
385: x_err_msg:= FND_MESSAGE.GET;
386: RETURN;
387: END IF;
388:

Line 385: x_err_msg:= FND_MESSAGE.GET;

381:
382: IF get_end%NOTFOUND THEN
383: x_err_code := -2; -- CZH I_OED-1, BUG2558058 changed to -2
384: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_FOUND');
385: x_err_msg:= FND_MESSAGE.GET;
386: RETURN;
387: END IF;
388:
389: LOOP

Line 392: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_ENDS');

388:
389: LOOP
390: IF get_end%ROWCOUNT >1 THEN
391: x_err_code := -2; -- CZH I_OED-1
392: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_ENDS');
393: x_err_msg:= FND_MESSAGE.GET;
394: RETURN;
395: END IF;
396: FETCH get_end INTO end_op_seq_id;

Line 393: x_err_msg:= FND_MESSAGE.GET;

389: LOOP
390: IF get_end%ROWCOUNT >1 THEN
391: x_err_code := -2; -- CZH I_OED-1
392: FND_MESSAGE.SET_NAME('WSM','WSM_NET_MULTIPLE_ENDS');
393: x_err_msg:= FND_MESSAGE.GET;
394: RETURN;
395: END IF;
396: FETCH get_end INTO end_op_seq_id;
397: EXIT WHEN get_end%NOTFOUND;

Line 420: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_EFFECTIVE');

416: IF(NVL(WSMPUTIL.replacement_op_seq_id(
417: end_op_seq_id,
418: l_rtg_rev_date), -1) = -1) THEN -- ADD: CZH.I_OED-2
419: x_err_code := -3;
420: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_EFFECTIVE');
421: x_err_msg:= FND_MESSAGE.GET;
422: RETURN;
423: END IF; -- ADD: CZH.I_OED-2
424: END IF;

Line 421: x_err_msg:= FND_MESSAGE.GET;

417: end_op_seq_id,
418: l_rtg_rev_date), -1) = -1) THEN -- ADD: CZH.I_OED-2
419: x_err_code := -3;
420: FND_MESSAGE.SET_NAME('WSM','WSM_NET_END_NOT_EFFECTIVE');
421: x_err_msg:= FND_MESSAGE.GET;
422: RETURN;
423: END IF; -- ADD: CZH.I_OED-2
424: END IF;
425:

Line 901: FND_MESSAGE.SET_NAME('WSM','WSM_NET_DUP_OP_SEQ_NUM');

897: begin
898: op_seq_ids.delete;
899: for op_rec in get_ops loop
900: if op_seq_ids.exists(op_rec.op_seq_num) then
901: FND_MESSAGE.SET_NAME('WSM','WSM_NET_DUP_OP_SEQ_NUM');
902: x_err_msg:= FND_MESSAGE.GET;
903: RETURN 1;
904: else
905: op_seq_ids(op_rec.op_seq_num) := op_rec.op_seq_id;

Line 902: x_err_msg:= FND_MESSAGE.GET;

898: op_seq_ids.delete;
899: for op_rec in get_ops loop
900: if op_seq_ids.exists(op_rec.op_seq_num) then
901: FND_MESSAGE.SET_NAME('WSM','WSM_NET_DUP_OP_SEQ_NUM');
902: x_err_msg:= FND_MESSAGE.GET;
903: RETURN 1;
904: else
905: op_seq_ids(op_rec.op_seq_num) := op_rec.op_seq_id;
906: end if;

Line 925: FND_MESSAGE.SET_NAME('WSM','WSM_START_SHOULD_BE_PRIMARY');

921:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924:
925: FND_MESSAGE.SET_NAME('WSM','WSM_START_SHOULD_BE_PRIMARY');
926: x_err_msg:= FND_MESSAGE.GET;
927: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
928: RETURN 1;
929:

Line 926: x_err_msg:= FND_MESSAGE.GET;

922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924:
925: FND_MESSAGE.SET_NAME('WSM','WSM_START_SHOULD_BE_PRIMARY');
926: x_err_msg:= FND_MESSAGE.GET;
927: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
928: RETURN 1;
929:
930: WHEN TOO_MANY_ROWS THEN

Line 932: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_STARTS');

928: RETURN 1;
929:
930: WHEN TOO_MANY_ROWS THEN
931:
932: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_STARTS');
933: x_err_msg:= FND_MESSAGE.GET;
934: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
935: RETURN 1;
936: END;

Line 933: x_err_msg:= FND_MESSAGE.GET;

929:
930: WHEN TOO_MANY_ROWS THEN
931:
932: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_STARTS');
933: x_err_msg:= FND_MESSAGE.GET;
934: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
935: RETURN 1;
936: END;
937:

Line 951: FND_MESSAGE.SET_NAME('WSM','WSM_END_SHOULD_BE_PRIMARY');

947:
948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950:
951: FND_MESSAGE.SET_NAME('WSM','WSM_END_SHOULD_BE_PRIMARY');
952: x_err_msg := FND_MESSAGE.GET;
953: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
954: RETURN 1;
955:

Line 952: x_err_msg := FND_MESSAGE.GET;

948: EXCEPTION
949: WHEN NO_DATA_FOUND THEN
950:
951: FND_MESSAGE.SET_NAME('WSM','WSM_END_SHOULD_BE_PRIMARY');
952: x_err_msg := FND_MESSAGE.GET;
953: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
954: RETURN 1;
955:
956: WHEN TOO_MANY_ROWS THEN

Line 957: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_ENDS');

953: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
954: RETURN 1;
955:
956: WHEN TOO_MANY_ROWS THEN
957: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_ENDS');
958: x_err_msg:= FND_MESSAGE.GET;
959: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
960: RETURN 1;
961:

Line 958: x_err_msg:= FND_MESSAGE.GET;

954: RETURN 1;
955:
956: WHEN TOO_MANY_ROWS THEN
957: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_ENDS');
958: x_err_msg:= FND_MESSAGE.GET;
959: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
960: RETURN 1;
961:
962: END;

Line 991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');

987: , bos2.operation_seq_num
988: having count(bon.from_op_seq_id) > 1;
989:
990: If sql%rowcount <> 0 Then
991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');
992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);
993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);
994: x_err_msg:= FND_MESSAGE.GET;
995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);

Line 992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);

988: having count(bon.from_op_seq_id) > 1;
989:
990: If sql%rowcount <> 0 Then
991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');
992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);
993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);
994: x_err_msg:= FND_MESSAGE.GET;
995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
996: RETURN 1;

Line 993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);

989:
990: If sql%rowcount <> 0 Then
991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');
992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);
993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);
994: x_err_msg:= FND_MESSAGE.GET;
995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
996: RETURN 1;
997: End If;

Line 994: x_err_msg:= FND_MESSAGE.GET;

990: If sql%rowcount <> 0 Then
991: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINK');
992: fnd_message.set_token('FROM_OPSEQ_NUM', l_from_opseq_num);
993: fnd_message.set_token('TO_OPSEQ_NUM', l_to_opseq_num);
994: x_err_msg:= FND_MESSAGE.GET;
995: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
996: RETURN 1;
997: End If;
998:

Line 1004: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINKS_EXIST');

1000: WHEN NO_DATA_FOUND THEN
1001: Null; -- NO duplicates found.
1002:
1003: WHEN TOO_MANY_ROWS THEN
1004: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINKS_EXIST');
1005: x_err_msg:= FND_MESSAGE.GET;
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1007: RETURN 1;
1008:

Line 1005: x_err_msg:= FND_MESSAGE.GET;

1001: Null; -- NO duplicates found.
1002:
1003: WHEN TOO_MANY_ROWS THEN
1004: FND_MESSAGE.SET_NAME('WSM','WSM_DUPLICATE_LINKS_EXIST');
1005: x_err_msg:= FND_MESSAGE.GET;
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1007: RETURN 1;
1008:
1009: END;

Line 1030: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS');

1026: WHERE routing_sequence_id = p_routing_sequence_id
1027: AND transition_type = 1 );
1028:
1029: IF p_count > 1 THEN
1030: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS');
1031: x_err_msg:= FND_MESSAGE.GET;
1032: END IF;
1033:
1034: END ;

Line 1031: x_err_msg:= FND_MESSAGE.GET;

1027: AND transition_type = 1 );
1028:
1029: IF p_count > 1 THEN
1030: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS');
1031: x_err_msg:= FND_MESSAGE.GET;
1032: END IF;
1033:
1034: END ;
1035:

Line 1051: FND_MESSAGE.SET_NAME('WSM','WSM_MULTIPLE_PRIMARY_PATHS_START');

1047: AND transition_type = 1;
1048:
1049: EXCEPTION
1050: WHEN TOO_MANY_ROWS then
1051: FND_MESSAGE.SET_NAME('WSM','WSM_MULTIPLE_PRIMARY_PATHS_START');
1052: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1053: x_err_msg:= FND_MESSAGE.GET;
1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1055: RETURN 1;

Line 1052: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);

1048:
1049: EXCEPTION
1050: WHEN TOO_MANY_ROWS then
1051: FND_MESSAGE.SET_NAME('WSM','WSM_MULTIPLE_PRIMARY_PATHS_START');
1052: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1053: x_err_msg:= FND_MESSAGE.GET;
1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1055: RETURN 1;
1056:

Line 1053: x_err_msg:= FND_MESSAGE.GET;

1049: EXCEPTION
1050: WHEN TOO_MANY_ROWS then
1051: FND_MESSAGE.SET_NAME('WSM','WSM_MULTIPLE_PRIMARY_PATHS_START');
1052: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1053: x_err_msg:= FND_MESSAGE.GET;
1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1055: RETURN 1;
1056:
1057: WHEN NO_DATA_FOUND THEN

Line 1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');

1054: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1055: RETURN 1;
1056:
1057: WHEN NO_DATA_FOUND THEN
1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
1059: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1060: x_err_msg:= FND_MESSAGE.GET;
1061: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1062: RETURN 1;

Line 1059: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);

1055: RETURN 1;
1056:
1057: WHEN NO_DATA_FOUND THEN
1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
1059: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1060: x_err_msg:= FND_MESSAGE.GET;
1061: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1062: RETURN 1;
1063: END;

Line 1060: x_err_msg:= FND_MESSAGE.GET;

1056:
1057: WHEN NO_DATA_FOUND THEN
1058: FND_MESSAGE.SET_NAME('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
1059: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1060: x_err_msg:= FND_MESSAGE.GET;
1061: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1062: RETURN 1;
1063: END;
1064:

Line 1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');

1076: INTO x_meet_num
1077: FROM BOM_OPERATION_NETWORKS_V
1078: WHERE from_op_seq_id = x_from_id;
1079:
1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');
1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1082: x_err_msg:= FND_MESSAGE.GET;
1083: END IF;
1084:

Line 1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);

1077: FROM BOM_OPERATION_NETWORKS_V
1078: WHERE from_op_seq_id = x_from_id;
1079:
1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');
1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1082: x_err_msg:= FND_MESSAGE.GET;
1083: END IF;
1084:
1085: END;

Line 1082: x_err_msg:= FND_MESSAGE.GET;

1078: WHERE from_op_seq_id = x_from_id;
1079:
1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');
1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);
1082: x_err_msg:= FND_MESSAGE.GET;
1083: END IF;
1084:
1085: END;
1086:

Line 1165: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');

1161: EXCEPTION
1162:
1163: WHEN NO_SUB THEN
1164: x_err_code := -1;
1165: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1166: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1168:
1169: -- BA NSO-WLT

Line 1166: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;

1162:
1163: WHEN NO_SUB THEN
1164: x_err_code := -1;
1165: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1166: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1168:
1169: -- BA NSO-WLT
1170: WHEN NOT_STD_OP THEN

Line 1172: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');

1168:
1169: -- BA NSO-WLT
1170: WHEN NOT_STD_OP THEN
1171: x_err_code := -1;
1172: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1173: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1175: -- EA NSO-WLT
1176:

Line 1173: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;

1169: -- BA NSO-WLT
1170: WHEN NOT_STD_OP THEN
1171: x_err_code := -1;
1172: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1173: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1175: -- EA NSO-WLT
1176:
1177: WHEN NO_DATA_FOUND THEN

Line 1179: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');

1175: -- EA NSO-WLT
1176:
1177: WHEN NO_DATA_FOUND THEN
1178: x_err_code := -1;
1179: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1180: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1181: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1182:
1183: WHEN OTHERS THEN

Line 1180: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;

1176:
1177: WHEN NO_DATA_FOUND THEN
1178: x_err_code := -1;
1179: FND_MESSAGE.SET_NAME('WSM','WSM_END_OPERATION_STK_PT');
1180: x_err_msg:= FND_MESSAGE.GET||' '||x_completion_subinventory;
1181: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1182:
1183: WHEN OTHERS THEN
1184: x_err_code := SQLCODE;

Line 1302: fnd_message.set_name('WSM', 'WSM_ORG_NOT_STD_COST');

1298: And MTL.organization_id = WIP.organization_id (+);
1299:
1300: If l_primaryCostMethod <> 1 Then
1301: -- NON_STANDARD costing method
1302: fnd_message.set_name('WSM', 'WSM_ORG_NOT_STD_COST');
1303: raise e_primaryCostMethod;
1304:
1305: ElsIf l_lotNumberUniqueness <> 2 Then
1306: -- LotNumber is NOT Non-UNIQUE

Line 1307: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');

1303: raise e_primaryCostMethod;
1304:
1305: ElsIf l_lotNumberUniqueness <> 2 Then
1306: -- LotNumber is NOT Non-UNIQUE
1307: fnd_message.set_name('WSM', 'WSM_ORG_LOT_NONUNIQUE');
1308: raise e_lotNumberUniqueness;
1309:
1310: ElsIf l_lotNumberDefaultType <> 1 Then
1311: -- Default Type is NOT JOBNAME

Line 1312: fnd_message.set_name('WSM', 'WSM_ORG_LOT_DEFAULT_TYPE');

1308: raise e_lotNumberUniqueness;
1309:
1310: ElsIf l_lotNumberDefaultType <> 1 Then
1311: -- Default Type is NOT JOBNAME
1312: fnd_message.set_name('WSM', 'WSM_ORG_LOT_DEFAULT_TYPE');
1313: raise e_lotNumberDefaultType;
1314:
1315: -- Start comments to fix bug #2006687
1316: -- Commented out the following check and moved this code to WSMFPARM.fmb

Line 1321: -- fnd_message.set_name('WSM', 'WSM_ORG_WPS_ENABLED');

1317: -- This is done to enable Agilent to have a WPS enabled OSFM org.
1318: -- ElsIf NVL(l_wpsEnabledFlag, 2) = 1 Then
1319: -- -- Org is WPS Enabled. Raise exception.
1320: --
1321: -- fnd_message.set_name('WSM', 'WSM_ORG_WPS_ENABLED');
1322: -- raise e_wpsEnabled;
1323: -- End comments to fix bug #2006687
1324:
1325: /*BA#1490834*/

Line 1332: -- fnd_message.set_name('WSM', 'WSM_ORG_WM$

1328:
1329: -- ElsIf NVL(l_wmsEnabledFlag, 'N') = 'Y' Then
1330: -- -- Org is WMS Enabled. Raise exception.
1331: --
1332: -- fnd_message.set_name('WSM', 'WSM_ORG_WM$
1333: -- raise e_wmsEnabled;
1334: /*EA#1490834*/
1335: Else
1336:

Line 1345: fnd_message.set_name('WSM', 'WSM_ORG_PJM_ENABLED');

1341: l_pjm_enabled := PJM_INSTALL.check_implementation_status(
1342: p_organization_id => p_organization_id);
1343:
1344: If l_pjm_enabled = TRUE Then
1345: fnd_message.set_name('WSM', 'WSM_ORG_PJM_ENABLED');
1346: raise e_pjmEnabled;
1347: End If;
1348:
1349: -- Bug#2131807 PJM enabled check.

Line 1358: x_err_msg := fnd_message.get;

1354:
1355: EXCEPTION
1356: When e_primaryCostMethod Then
1357: x_err_code := 1;
1358: x_err_msg := fnd_message.get;
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1360: return(x_err_code);
1361:
1362: When e_lotNumberUniqueness Then

Line 1364: x_err_msg := fnd_message.get;

1360: return(x_err_code);
1361:
1362: When e_lotNumberUniqueness Then
1363: x_err_code := 2;
1364: x_err_msg := fnd_message.get;
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1366: return(x_err_code);
1367:
1368: When e_lotNumberDefaultType Then

Line 1370: x_err_msg := fnd_message.get;

1366: return(x_err_code);
1367:
1368: When e_lotNumberDefaultType Then
1369: x_err_code := 3;
1370: x_err_msg := fnd_message.get;
1371: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1372: return(x_err_code);
1373:
1374: When e_wpsEnabled Then

Line 1376: x_err_msg := fnd_message.get;

1372: return(x_err_code);
1373:
1374: When e_wpsEnabled Then
1375: x_err_code := 4;
1376: x_err_msg := fnd_message.get;
1377: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1378: return(x_err_code);
1379:
1380: /*BA#1490834*/

Line 1383: x_err_msg := fnd_message.get;

1379:
1380: /*BA#1490834*/
1381: When e_wmsEnabled Then
1382: x_err_code := 5;
1383: x_err_msg := fnd_message.get;
1384: return(x_err_code);
1385: /*EA#1490834*/
1386:
1387: -- Bug#2131807 PJM enabled check.

Line 1390: x_err_msg := fnd_message.get;

1386:
1387: -- Bug#2131807 PJM enabled check.
1388: When e_pjmEnabled Then -- Bug#2131807 check PJM enabled
1389: x_err_code := 6;
1390: x_err_msg := fnd_message.get;
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, x_err_msg);
1392: return(x_err_code);
1393:
1394: WHEN OTHERS Then

Line 1823: FND_MESSAGE.SET_NAME('WSM','WSM_%_SUM_NOT_100');

1819: AND routing_sequence_id = p_routing_sequence_id ;
1820:
1821: IF( var_total_planning_pct <> 100) THEN
1822:
1823: FND_MESSAGE.SET_NAME('WSM','WSM_%_SUM_NOT_100');
1824: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',p_from_seq_num);
1825: x_err_msg:= FND_MESSAGE.GET;
1826: x_err_code := -1 ;
1827: RETURN 0;

Line 1824: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',p_from_seq_num);

1820:
1821: IF( var_total_planning_pct <> 100) THEN
1822:
1823: FND_MESSAGE.SET_NAME('WSM','WSM_%_SUM_NOT_100');
1824: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',p_from_seq_num);
1825: x_err_msg:= FND_MESSAGE.GET;
1826: x_err_code := -1 ;
1827: RETURN 0;
1828: EXIT;

Line 1825: x_err_msg:= FND_MESSAGE.GET;

1821: IF( var_total_planning_pct <> 100) THEN
1822:
1823: FND_MESSAGE.SET_NAME('WSM','WSM_%_SUM_NOT_100');
1824: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',p_from_seq_num);
1825: x_err_msg:= FND_MESSAGE.GET;
1826: x_err_code := -1 ;
1827: RETURN 0;
1828: EXIT;
1829:

Line 2242: fnd_message.set_name('WSM','WSM_NS_RTNG_REF_NULL');

2238: -- routing reference cannot be null
2239: if validation_level = 0 then
2240:
2241: if p_routing_reference_id is null then
2242: fnd_message.set_name('WSM','WSM_NS_RTNG_REF_NULL');
2243: x_err_msg := fnd_message.get;
2244: x_error_code := 1;
2245: return;
2246: end if;

Line 2243: x_err_msg := fnd_message.get;

2239: if validation_level = 0 then
2240:
2241: if p_routing_reference_id is null then
2242: fnd_message.set_name('WSM','WSM_NS_RTNG_REF_NULL');
2243: x_err_msg := fnd_message.get;
2244: x_error_code := 1;
2245: return;
2246: end if;
2247:

Line 2255: fnd_message.set_name('WSM','WSM_NS_ASS_NULL');

2251: -- assembly cannot be null
2252: if validation_level = 0 then
2253:
2254: if p_assembly_item_id is null then
2255: fnd_message.set_name('WSM','WSM_NS_ASS_NULL');
2256: x_err_msg := fnd_message.get;
2257: x_error_code := 1;
2258: return;
2259: end if;

Line 2256: x_err_msg := fnd_message.get;

2252: if validation_level = 0 then
2253:
2254: if p_assembly_item_id is null then
2255: fnd_message.set_name('WSM','WSM_NS_ASS_NULL');
2256: x_err_msg := fnd_message.get;
2257: x_error_code := 1;
2258: return;
2259: end if;
2260:

Line 2279: fnd_message.set_name('WSM','WSM_ASSEMBLY_NO_LOT');

2275: EXCEPTION
2276: when too_many_rows then l_no_of_records := 1;
2277: when no_data_found then
2278: x_error_code := 2;
2279: fnd_message.set_name('WSM','WSM_ASSEMBLY_NO_LOT');
2280: x_err_msg := fnd_message.get;
2281: return;
2282: END;
2283:

Line 2280: x_err_msg := fnd_message.get;

2276: when too_many_rows then l_no_of_records := 1;
2277: when no_data_found then
2278: x_error_code := 2;
2279: fnd_message.set_name('WSM','WSM_ASSEMBLY_NO_LOT');
2280: x_err_msg := fnd_message.get;
2281: return;
2282: END;
2283:
2284: l_stmt_num := 30;

Line 2304: fnd_message.set_name('WSM','WSM_ASSEMBLY_NOT_SERIAL');

2300: EXCEPTION
2301: when too_many_rows then l_no_of_records := 1;
2302: when no_data_found then
2303: x_error_code := 2;
2304: fnd_message.set_name('WSM','WSM_ASSEMBLY_NOT_SERIAL');
2305: x_err_msg := fnd_message.get;
2306: return;
2307: END;
2308: end if;

Line 2305: x_err_msg := fnd_message.get;

2301: when too_many_rows then l_no_of_records := 1;
2302: when no_data_found then
2303: x_error_code := 2;
2304: fnd_message.set_name('WSM','WSM_ASSEMBLY_NOT_SERIAL');
2305: x_err_msg := fnd_message.get;
2306: return;
2307: END;
2308: end if;
2309:

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

2321: and msi.organization_id = p_organization_id;
2322: EXCEPTION
2323: when too_many_rows then null;
2324: when no_data_found then
2325: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2326: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID');
2327: x_err_msg := fnd_message.get;
2328: x_error_code := 3;
2329: return;

Line 2326: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID');

2322: EXCEPTION
2323: when too_many_rows then null;
2324: when no_data_found then
2325: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2326: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID');
2327: x_err_msg := fnd_message.get;
2328: x_error_code := 3;
2329: return;
2330: END;

Line 2327: x_err_msg := fnd_message.get;

2323: when too_many_rows then null;
2324: when no_data_found then
2325: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2326: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID');
2327: x_err_msg := fnd_message.get;
2328: x_error_code := 3;
2329: return;
2330: END;
2331: end if;

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

2343: and msi.organization_id = p_organization_id;
2344: EXCEPTION
2345: when too_many_rows then null;
2346: when no_data_found then
2347: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2348: fnd_message.set_token('FLD_NAME', 'BOM_REFERENCE_ID');
2349: x_err_msg := fnd_message.get;
2350: x_error_code := 4;
2351: return;

Line 2348: fnd_message.set_token('FLD_NAME', 'BOM_REFERENCE_ID');

2344: EXCEPTION
2345: when too_many_rows then null;
2346: when no_data_found then
2347: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2348: fnd_message.set_token('FLD_NAME', 'BOM_REFERENCE_ID');
2349: x_err_msg := fnd_message.get;
2350: x_error_code := 4;
2351: return;
2352: END;

Line 2349: x_err_msg := fnd_message.get;

2345: when too_many_rows then null;
2346: when no_data_found then
2347: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2348: fnd_message.set_token('FLD_NAME', 'BOM_REFERENCE_ID');
2349: x_err_msg := fnd_message.get;
2350: x_error_code := 4;
2351: return;
2352: END;
2353: end if;

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

2377: and bor.routing_type = 1
2378: and bor.cfm_routing_flag = 3;
2379: EXCEPTION
2380: when no_data_found then
2381: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2382: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID/ALTERNATE_ROUTING_DESIGNATOR');
2383: x_err_msg := fnd_message.get;
2384: x_error_code := 5;
2385: return;

Line 2382: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID/ALTERNATE_ROUTING_DESIGNATOR');

2378: and bor.cfm_routing_flag = 3;
2379: EXCEPTION
2380: when no_data_found then
2381: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2382: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID/ALTERNATE_ROUTING_DESIGNATOR');
2383: x_err_msg := fnd_message.get;
2384: x_error_code := 5;
2385: return;
2386: END;

Line 2383: x_err_msg := fnd_message.get;

2379: EXCEPTION
2380: when no_data_found then
2381: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2382: fnd_message.set_token('FLD_NAME', 'ROUTING_REFERENCE_ID/ALTERNATE_ROUTING_DESIGNATOR');
2383: x_err_msg := fnd_message.get;
2384: x_error_code := 5;
2385: return;
2386: END;
2387:

Line 2405: fnd_message.set_name('WIP','WIP_BILL_DOES_NOT_EXIST');

2401: AND BOM.assembly_item_id = p_bom_reference_id
2402: AND bom.organization_id = p_organization_id;
2403: EXCEPTION
2404: when no_data_found then
2405: fnd_message.set_name('WIP','WIP_BILL_DOES_NOT_EXIST');
2406: x_err_msg := fnd_message.get;
2407: --SpUA bugfix 3154345 Not really a SpUA bugfix!!
2408: --Now we will enable wrong alt_bom_desig to error out
2409: x_error_code := 6;

Line 2406: x_err_msg := fnd_message.get;

2402: AND bom.organization_id = p_organization_id;
2403: EXCEPTION
2404: when no_data_found then
2405: fnd_message.set_name('WIP','WIP_BILL_DOES_NOT_EXIST');
2406: x_err_msg := fnd_message.get;
2407: --SpUA bugfix 3154345 Not really a SpUA bugfix!!
2408: --Now we will enable wrong alt_bom_desig to error out
2409: x_error_code := 6;
2410: --End SpUA bugfix

Line 2421: fnd_message.set_name('WSM','WSM_NS_NULL_DATE');

2417: -- date validations
2418:
2419: l_stmt_num := 80;
2420: if p_start_date is null or p_end_date is null then
2421: fnd_message.set_name('WSM','WSM_NS_NULL_DATE');
2422: x_err_msg := fnd_message.get;
2423: x_error_code := 8;
2424: return;
2425: end if;

Line 2422: x_err_msg := fnd_message.get;

2418:
2419: l_stmt_num := 80;
2420: if p_start_date is null or p_end_date is null then
2421: fnd_message.set_name('WSM','WSM_NS_NULL_DATE');
2422: x_err_msg := fnd_message.get;
2423: x_error_code := 8;
2424: return;
2425: end if;
2426:

Line 2428: fnd_message.set_name('WSM','WSM_FUSD_GT_LUCD');

2424: return;
2425: end if;
2426:
2427: if p_start_date > p_end_date then
2428: fnd_message.set_name('WSM','WSM_FUSD_GT_LUCD');
2429: x_err_msg := fnd_message.get;
2430: x_error_code := 7;
2431: return;
2432: end if;

Line 2429: x_err_msg := fnd_message.get;

2425: end if;
2426:
2427: if p_start_date > p_end_date then
2428: fnd_message.set_name('WSM','WSM_FUSD_GT_LUCD');
2429: x_err_msg := fnd_message.get;
2430: x_error_code := 7;
2431: return;
2432: end if;
2433:

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

2438: if validation_level = 0 then
2439:
2440: l_stmt_num := 90;
2441: if p_start_quantity is null or (p_start_quantity is not null and p_start_quantity <= 0) then
2442: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2443: fnd_message.set_token('FLD_NAME', 'START_QUANTITY');
2444: x_err_msg := fnd_message.get;
2445: x_error_code := 9;
2446: return;

Line 2443: fnd_message.set_token('FLD_NAME', 'START_QUANTITY');

2439:
2440: l_stmt_num := 90;
2441: if p_start_quantity is null or (p_start_quantity is not null and p_start_quantity <= 0) then
2442: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2443: fnd_message.set_token('FLD_NAME', 'START_QUANTITY');
2444: x_err_msg := fnd_message.get;
2445: x_error_code := 9;
2446: return;
2447: end if;

Line 2444: x_err_msg := fnd_message.get;

2440: l_stmt_num := 90;
2441: if p_start_quantity is null or (p_start_quantity is not null and p_start_quantity <= 0) then
2442: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2443: fnd_message.set_token('FLD_NAME', 'START_QUANTITY');
2444: x_err_msg := fnd_message.get;
2445: x_error_code := 9;
2446: return;
2447: end if;
2448:

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

2449: -- ST : Serial Support Project -----------------------------
2450: IF l_serial_control_code = 2 THEN
2451: IF floor(p_start_quantity) <> p_start_quantity THEN
2452: -- ST : Serial Support Project -----------------------------
2453: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
2454: x_err_msg := fnd_message.get;
2455: x_error_code := 9;
2456: return;
2457: END IF;

Line 2454: x_err_msg := fnd_message.get;

2450: IF l_serial_control_code = 2 THEN
2451: IF floor(p_start_quantity) <> p_start_quantity THEN
2452: -- ST : Serial Support Project -----------------------------
2453: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
2454: x_err_msg := fnd_message.get;
2455: x_error_code := 9;
2456: return;
2457: END IF;
2458: END IF;

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

2466: if p_mrp_net_quantity is null then
2467: p_mrp_net_quantity := 0;
2468: else
2469: if p_mrp_net_quantity < 0 or p_mrp_net_quantity > p_start_quantity then
2470: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2471: fnd_message.set_token('FLD_NAME', 'MRP_NET_QUANTITY');
2472: x_err_msg := fnd_message.get;
2473: x_error_code := 9;
2474: return;

Line 2471: fnd_message.set_token('FLD_NAME', 'MRP_NET_QUANTITY');

2467: p_mrp_net_quantity := 0;
2468: else
2469: if p_mrp_net_quantity < 0 or p_mrp_net_quantity > p_start_quantity then
2470: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2471: fnd_message.set_token('FLD_NAME', 'MRP_NET_QUANTITY');
2472: x_err_msg := fnd_message.get;
2473: x_error_code := 9;
2474: return;
2475: end if;

Line 2472: x_err_msg := fnd_message.get;

2468: else
2469: if p_mrp_net_quantity < 0 or p_mrp_net_quantity > p_start_quantity then
2470: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2471: fnd_message.set_token('FLD_NAME', 'MRP_NET_QUANTITY');
2472: x_err_msg := fnd_message.get;
2473: x_error_code := 9;
2474: return;
2475: end if;
2476:

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

2477: -- ST : Serial Support Project -----------------------------
2478: IF l_serial_control_code = 2 THEN
2479: IF floor(p_mrp_net_quantity) <> p_mrp_net_quantity THEN
2480: -- ST : Serial Support Project -----------------------------
2481: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
2482: x_err_msg := fnd_message.get;
2483: x_error_code := 9;
2484: return;
2485: END IF;

Line 2482: x_err_msg := fnd_message.get;

2478: IF l_serial_control_code = 2 THEN
2479: IF floor(p_mrp_net_quantity) <> p_mrp_net_quantity THEN
2480: -- ST : Serial Support Project -----------------------------
2481: fnd_message.set_name('WSM','WSM_INVALID_JOB_TXN_QTY');
2482: x_err_msg := fnd_message.get;
2483: x_error_code := 9;
2484: return;
2485: END IF;
2486: END IF;

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

2503: and class_type = 7;
2504: EXCEPTION
2505: when too_many_rows then null;
2506: when no_data_found then
2507: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2508: fnd_message.set_token('FLD_NAME', 'CLASS_CODE');
2509: x_err_msg := fnd_message.get;
2510: x_error_code := 11;
2511: return;

Line 2508: fnd_message.set_token('FLD_NAME', 'CLASS_CODE');

2504: EXCEPTION
2505: when too_many_rows then null;
2506: when no_data_found then
2507: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2508: fnd_message.set_token('FLD_NAME', 'CLASS_CODE');
2509: x_err_msg := fnd_message.get;
2510: x_error_code := 11;
2511: return;
2512: END;

Line 2509: x_err_msg := fnd_message.get;

2505: when too_many_rows then null;
2506: when no_data_found then
2507: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2508: fnd_message.set_token('FLD_NAME', 'CLASS_CODE');
2509: x_err_msg := fnd_message.get;
2510: x_error_code := 11;
2511: return;
2512: END;
2513:

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

2533: and organization_id = p_organization_id;
2534: EXCEPTION
2535: when too_many_rows then null;
2536: when no_data_found then
2537: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2538: fnd_message.set_token('FLD_NAME', 'COMPLETION_SUBINVENTORY');
2539: x_err_msg := fnd_message.get;
2540: x_error_code := 13;
2541: return;

Line 2538: fnd_message.set_token('FLD_NAME', 'COMPLETION_SUBINVENTORY');

2534: EXCEPTION
2535: when too_many_rows then null;
2536: when no_data_found then
2537: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2538: fnd_message.set_token('FLD_NAME', 'COMPLETION_SUBINVENTORY');
2539: x_err_msg := fnd_message.get;
2540: x_error_code := 13;
2541: return;
2542: END;

Line 2539: x_err_msg := fnd_message.get;

2535: when too_many_rows then null;
2536: when no_data_found then
2537: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2538: fnd_message.set_token('FLD_NAME', 'COMPLETION_SUBINVENTORY');
2539: x_err_msg := fnd_message.get;
2540: x_error_code := 13;
2541: return;
2542: END;
2543: end if;

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

2598: l_loc_success := FALSE;
2599: end;
2600:
2601: IF not l_loc_success THEN
2602: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2603: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2604: x_err_msg := fnd_message.get;
2605: x_error_code := 12;
2606: return;

Line 2603: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');

2599: end;
2600:
2601: IF not l_loc_success THEN
2602: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2603: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2604: x_err_msg := fnd_message.get;
2605: x_error_code := 12;
2606: return;
2607: end if;

Line 2604: x_err_msg := fnd_message.get;

2600:
2601: IF not l_loc_success THEN
2602: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2603: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2604: x_err_msg := fnd_message.get;
2605: x_error_code := 12;
2606: return;
2607: end if;
2608: /*** ST bugfix 3336844

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

2607: end if;
2608: /*** ST bugfix 3336844
2609: elsif p_completion_locator_id is null then
2610: if l_mtl_locator_type = 2 then
2611: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2612: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2613: x_err_msg := fnd_message.get;
2614: x_error_code := 12;
2615: return;

Line 2612: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');

2608: /*** ST bugfix 3336844
2609: elsif p_completion_locator_id is null then
2610: if l_mtl_locator_type = 2 then
2611: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2612: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2613: x_err_msg := fnd_message.get;
2614: x_error_code := 12;
2615: return;
2616: end if;

Line 2613: x_err_msg := fnd_message.get;

2609: elsif p_completion_locator_id is null then
2610: if l_mtl_locator_type = 2 then
2611: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2612: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2613: x_err_msg := fnd_message.get;
2614: x_error_code := 12;
2615: return;
2616: end if;
2617: end if;

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

2618: end fix 3336844 ***/
2619: elsif p_completion_subinventory is null and p_completion_locator_id is null then
2620: null;
2621: elsif p_completion_subinventory is null and p_completion_locator_id is not null then
2622: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2623: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2624: x_err_msg := fnd_message.get;
2625: x_error_code := 12;
2626: return;

Line 2623: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');

2619: elsif p_completion_subinventory is null and p_completion_locator_id is null then
2620: null;
2621: elsif p_completion_subinventory is null and p_completion_locator_id is not null then
2622: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2623: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2624: x_err_msg := fnd_message.get;
2625: x_error_code := 12;
2626: return;
2627: end if;

Line 2624: x_err_msg := fnd_message.get;

2620: null;
2621: elsif p_completion_subinventory is null and p_completion_locator_id is not null then
2622: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2623: fnd_message.set_token('FLD_NAME', 'COMPLETION_LOCATOR_ID');
2624: x_err_msg := fnd_message.get;
2625: x_error_code := 12;
2626: return;
2627: end if;
2628:

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

2634:
2635: l_stmt_num:= 130;
2636:
2637: if p_firm_planned_flag is not null and p_firm_planned_flag <> 2 then
2638: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2639: fnd_message.set_token('FLD_NAME', 'FIRM_PLANNED_FLAG');
2640: x_err_msg := fnd_message.get;
2641: x_error_code := 14;
2642: return;

Line 2639: fnd_message.set_token('FLD_NAME', 'FIRM_PLANNED_FLAG');

2635: l_stmt_num:= 130;
2636:
2637: if p_firm_planned_flag is not null and p_firm_planned_flag <> 2 then
2638: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2639: fnd_message.set_token('FLD_NAME', 'FIRM_PLANNED_FLAG');
2640: x_err_msg := fnd_message.get;
2641: x_error_code := 14;
2642: return;
2643: end if;

Line 2640: x_err_msg := fnd_message.get;

2636:
2637: if p_firm_planned_flag is not null and p_firm_planned_flag <> 2 then
2638: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
2639: fnd_message.set_token('FLD_NAME', 'FIRM_PLANNED_FLAG');
2640: x_err_msg := fnd_message.get;
2641: x_error_code := 14;
2642: return;
2643: end if;
2644: if p_firm_planned_flag is null then

Line 4524: fnd_message.set_name('INV', 'INV_ERR_CREATETREE');

4520: , P_LOT_EXPIRATION_DATE => null
4521: , X_TREE_ID => lv_tree_id);
4522:
4523: if( lv_return_status <> 'S' ) then
4524: fnd_message.set_name('INV', 'INV_ERR_CREATETREE');
4525: p_err_msg := fnd_message.get;
4526: p_err_code := -1;
4527: return;
4528: end if;

Line 4525: p_err_msg := fnd_message.get;

4521: , X_TREE_ID => lv_tree_id);
4522:
4523: if( lv_return_status <> 'S' ) then
4524: fnd_message.set_name('INV', 'INV_ERR_CREATETREE');
4525: p_err_msg := fnd_message.get;
4526: p_err_code := -1;
4527: return;
4528: end if;
4529:

Line 4551: fnd_message.set_name('INV', 'INV-CANNOT QUERY TREE');

4547: );
4548:
4549:
4550: if( lv_return_status <> 'S' ) then
4551: fnd_message.set_name('INV', 'INV-CANNOT QUERY TREE');
4552: p_err_msg := fnd_message.get;
4553: p_err_code := -1;
4554: return;
4555: end if;

Line 4552: p_err_msg := fnd_message.get;

4548:
4549:
4550: if( lv_return_status <> 'S' ) then
4551: fnd_message.set_name('INV', 'INV-CANNOT QUERY TREE');
4552: p_err_msg := fnd_message.get;
4553: p_err_code := -1;
4554: return;
4555: end if;
4556:

Line 4571: FND_MESSAGE.set_name('WSM','WSM_ZERO_ON_HAND');

4567: , x_msg_data => lv_msg_data
4568: );
4569:
4570: IF(p_qoh = 0) THEN
4571: FND_MESSAGE.set_name('WSM','WSM_ZERO_ON_HAND');
4572: p_err_msg := fnd_message.get;
4573: p_err_code := -1;
4574: return;
4575: END IF;

Line 4572: p_err_msg := fnd_message.get;

4568: );
4569:
4570: IF(p_qoh = 0) THEN
4571: FND_MESSAGE.set_name('WSM','WSM_ZERO_ON_HAND');
4572: p_err_msg := fnd_message.get;
4573: p_err_code := -1;
4574: return;
4575: END IF;
4576:

Line 4578: FND_MESSAGE.set_name('WSM','WSM_LOT_FULL_RESERVED');

4574: return;
4575: END IF;
4576:
4577: IF p_atr = 0 THEN
4578: FND_MESSAGE.set_name('WSM','WSM_LOT_FULL_RESERVED');
4579: p_err_msg := fnd_message.get;
4580: p_err_code := -1;
4581: return;
4582: END IF;

Line 4579: p_err_msg := fnd_message.get;

4575: END IF;
4576:
4577: IF p_atr = 0 THEN
4578: FND_MESSAGE.set_name('WSM','WSM_LOT_FULL_RESERVED');
4579: p_err_msg := fnd_message.get;
4580: p_err_code := -1;
4581: return;
4582: END IF;
4583:

Line 5814: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');

5810: /*-------------------------------------------------------------+
5811: | 0 : No data found. |
5812: | -1 : some exception occured in the called API ...........|
5813: +-------------------------------------------------------------*/
5814: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5815: x_err_code := -1;
5816: x_err_msg := FND_MESSAGE.GET;
5817: IF (l_debug = 'Y') THEN -- bug 3373637
5818: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg

Line 5816: x_err_msg := FND_MESSAGE.GET;

5812: | -1 : some exception occured in the called API ...........|
5813: +-------------------------------------------------------------*/
5814: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5815: x_err_code := -1;
5816: x_err_msg := FND_MESSAGE.GET;
5817: IF (l_debug = 'Y') THEN -- bug 3373637
5818: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg
5819: || ' (organization_id = ' || p_organization_id || ')');
5820: END IF;

Line 5833: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');

5829:
5830: /* ST : Bug 3205363 Commented the following for LE Time zone change */
5831: /*WHEN NO_DATA_FOUND then
5832: x_err_code := -1;
5833: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5834: x_err_msg := FND_MESSAGE.GET;
5835: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg);
5836: l_acct_period_id := 0; -- Date passed is in a NON-OPEN Period.
5837: Return l_acct_period_id;*/

Line 5834: x_err_msg := FND_MESSAGE.GET;

5830: /* ST : Bug 3205363 Commented the following for LE Time zone change */
5831: /*WHEN NO_DATA_FOUND then
5832: x_err_code := -1;
5833: fnd_message.set_name('WSM', 'WSM_ACCT_PERIOD_NOT_OPEN');
5834: x_err_msg := FND_MESSAGE.GET;
5835: fnd_file.put_line(fnd_file.log, 'WSMPUTIL.GET_INV_ACCT_PERIOD: '||x_err_msg);
5836: l_acct_period_id := 0; -- Date passed is in a NON-OPEN Period.
5837: Return l_acct_period_id;*/
5838:

Line 6075: FND_MESSAGE.SET_NAME('WSM','WSM_TRX_SUBINV_NA_DUE_MS');

6071:
6072: END IF; --End of p_inventory_item_id IS NOT NULL and p_sub_code IS NOT NULL
6073:
6074: IF l_status_applicable = 'N' THEN
6075: FND_MESSAGE.SET_NAME('WSM','WSM_TRX_SUBINV_NA_DUE_MS');
6076: FND_MESSAGE.SET_TOKEN('TOKEN1', p_sub_code);
6077: x_error_msg := fnd_message.get;
6078:
6079: return l_status_applicable;

Line 6076: FND_MESSAGE.SET_TOKEN('TOKEN1', p_sub_code);

6072: END IF; --End of p_inventory_item_id IS NOT NULL and p_sub_code IS NOT NULL
6073:
6074: IF l_status_applicable = 'N' THEN
6075: FND_MESSAGE.SET_NAME('WSM','WSM_TRX_SUBINV_NA_DUE_MS');
6076: FND_MESSAGE.SET_TOKEN('TOKEN1', p_sub_code);
6077: x_error_msg := fnd_message.get;
6078:
6079: return l_status_applicable;
6080: END IF;

Line 6077: x_error_msg := fnd_message.get;

6073:
6074: IF l_status_applicable = 'N' THEN
6075: FND_MESSAGE.SET_NAME('WSM','WSM_TRX_SUBINV_NA_DUE_MS');
6076: FND_MESSAGE.SET_TOKEN('TOKEN1', p_sub_code);
6077: x_error_msg := fnd_message.get;
6078:
6079: return l_status_applicable;
6080: END IF;
6081:

Line 6104: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOCATOR_NA_DUE_MS');

6100: from mtl_item_locations_kfv
6101: where inventory_location_id = p_locator_id
6102: and organization_id = p_organization_id;
6103:
6104: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOCATOR_NA_DUE_MS');
6105: FND_MESSAGE.SET_TOKEN('TOKEN1', l_locator);
6106: x_error_msg := fnd_message.get;
6107: return l_status_applicable;
6108: END IF;

Line 6105: FND_MESSAGE.SET_TOKEN('TOKEN1', l_locator);

6101: where inventory_location_id = p_locator_id
6102: and organization_id = p_organization_id;
6103:
6104: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOCATOR_NA_DUE_MS');
6105: FND_MESSAGE.SET_TOKEN('TOKEN1', l_locator);
6106: x_error_msg := fnd_message.get;
6107: return l_status_applicable;
6108: END IF;
6109:

Line 6106: x_error_msg := fnd_message.get;

6102: and organization_id = p_organization_id;
6103:
6104: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOCATOR_NA_DUE_MS');
6105: FND_MESSAGE.SET_TOKEN('TOKEN1', l_locator);
6106: x_error_msg := fnd_message.get;
6107: return l_status_applicable;
6108: END IF;
6109:
6110: IF (p_lot_number IS NOT NULL) THEN

Line 6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');

6128: from mtl_system_items_kfv
6129: where inventory_item_id = p_inventory_item_id
6130: and organization_id = p_organization_id;
6131:
6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');
6133: FND_MESSAGE.SET_TOKEN('TOKEN1', p_lot_number);
6134: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6135: x_error_msg := fnd_message.get;
6136: return l_status_applicable;

Line 6133: FND_MESSAGE.SET_TOKEN('TOKEN1', p_lot_number);

6129: where inventory_item_id = p_inventory_item_id
6130: and organization_id = p_organization_id;
6131:
6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');
6133: FND_MESSAGE.SET_TOKEN('TOKEN1', p_lot_number);
6134: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6135: x_error_msg := fnd_message.get;
6136: return l_status_applicable;
6137: END IF;

Line 6134: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);

6130: and organization_id = p_organization_id;
6131:
6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');
6133: FND_MESSAGE.SET_TOKEN('TOKEN1', p_lot_number);
6134: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6135: x_error_msg := fnd_message.get;
6136: return l_status_applicable;
6137: END IF;
6138:

Line 6135: x_error_msg := fnd_message.get;

6131:
6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');
6133: FND_MESSAGE.SET_TOKEN('TOKEN1', p_lot_number);
6134: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6135: x_error_msg := fnd_message.get;
6136: return l_status_applicable;
6137: END IF;
6138:
6139: IF (p_serial_number IS NOT NULL) THEN

Line 6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');

6157: from mtl_system_items_kfv
6158: where inventory_item_id = p_inventory_item_id
6159: and organization_id = p_organization_id;
6160:
6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');
6162: FND_MESSAGE.SET_TOKEN('TOKEN1', p_serial_number);
6163: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6164: x_error_msg := fnd_message.get;
6165: END IF;

Line 6162: FND_MESSAGE.SET_TOKEN('TOKEN1', p_serial_number);

6158: where inventory_item_id = p_inventory_item_id
6159: and organization_id = p_organization_id;
6160:
6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');
6162: FND_MESSAGE.SET_TOKEN('TOKEN1', p_serial_number);
6163: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6164: x_error_msg := fnd_message.get;
6165: END IF;
6166:

Line 6163: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);

6159: and organization_id = p_organization_id;
6160:
6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');
6162: FND_MESSAGE.SET_TOKEN('TOKEN1', p_serial_number);
6163: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6164: x_error_msg := fnd_message.get;
6165: END IF;
6166:
6167: return l_status_applicable;

Line 6164: x_error_msg := fnd_message.get;

6160:
6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');
6162: FND_MESSAGE.SET_TOKEN('TOKEN1', p_serial_number);
6163: FND_MESSAGE.SET_TOKEN('TOKEN2', l_item);
6164: x_error_msg := fnd_message.get;
6165: END IF;
6166:
6167: return l_status_applicable;
6168:

Line 6362: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_STARTS');

6358: EXCEPTION
6359:
6360: when e_multiple_start_op then
6361: x_err_code := -1;
6362: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_STARTS');
6363: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6364: return 1;
6365:
6366: when e_multiple_end_op then

Line 6363: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;

6359:
6360: when e_multiple_start_op then
6361: x_err_code := -1;
6362: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_STARTS');
6363: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6364: return 1;
6365:
6366: when e_multiple_end_op then
6367: x_err_code := -1;

Line 6368: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_ENDS');

6364: return 1;
6365:
6366: when e_multiple_end_op then
6367: x_err_code := -1;
6368: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_ENDS');
6369: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6370: return 1;
6371:
6372: when e_multiple_primary_path then

Line 6369: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;

6365:
6366: when e_multiple_end_op then
6367: x_err_code := -1;
6368: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_ENDS');
6369: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6370: return 1;
6371:
6372: when e_multiple_primary_path then
6373: x_err_code := -1;

Line 6374: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_PATHS');

6370: return 1;
6371:
6372: when e_multiple_primary_path then
6373: x_err_code := -1;
6374: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_PATHS');
6375: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6376: return 1;
6377:
6378: when e_network_loop then

Line 6375: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;

6371:
6372: when e_multiple_primary_path then
6373: x_err_code := -1;
6374: fnd_message.set_name('WSM','WSM_MULT_PRIMARY_PATHS');
6375: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6376: return 1;
6377:
6378: when e_network_loop then
6379: x_err_code := -1;

Line 6380: fnd_message.set_name('WSM','WSM_NTWK_LOOP_EXISTS');

6376: return 1;
6377:
6378: when e_network_loop then
6379: x_err_code := -1;
6380: fnd_message.set_name('WSM','WSM_NTWK_LOOP_EXISTS');
6381: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6382: return 1;
6383:
6384: when e_no_continuous_path then

Line 6381: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;

6377:
6378: when e_network_loop then
6379: x_err_code := -1;
6380: fnd_message.set_name('WSM','WSM_NTWK_LOOP_EXISTS');
6381: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6382: return 1;
6383:
6384: when e_no_continuous_path then
6385: x_err_code := -1;

Line 6386: fnd_message.set_name('WSM','WSM_PRIMARY_PATH_END_IMPROPER');

6382: return 1;
6383:
6384: when e_no_continuous_path then
6385: x_err_code := -1;
6386: fnd_message.set_name('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
6387: fnd_message.set_token('WSM_SEQ_NUM',l_counter);
6388: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6389: return 1;
6390:

Line 6387: fnd_message.set_token('WSM_SEQ_NUM',l_counter);

6383:
6384: when e_no_continuous_path then
6385: x_err_code := -1;
6386: fnd_message.set_name('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
6387: fnd_message.set_token('WSM_SEQ_NUM',l_counter);
6388: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6389: return 1;
6390:
6391: when others then

Line 6388: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;

6384: when e_no_continuous_path then
6385: x_err_code := -1;
6386: fnd_message.set_name('WSM','WSM_PRIMARY_PATH_END_IMPROPER');
6387: fnd_message.set_token('WSM_SEQ_NUM',l_counter);
6388: x_err_msg := 'Error: validate_job_network: (#'||l_stmt_num||') ' ||fnd_message.get;
6389: return 1;
6390:
6391: when others then
6392: x_err_code := -1;