APPS.WIP_RESOURCE_VALIDATIONS dependencies on WIP_JDI_UTILS

Line 57: p_error_type => wip_jdi_utils.msg_error);

53: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
54: if (wip_job_details.std_alone = 1) then
55: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
56: p_text => substr(fnd_message.get,1,500),
57: p_error_type => wip_jdi_utils.msg_error);
58: else
59: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
60: p_text => substr(fnd_message.get,1,500),
61: p_error_type => wip_jdi_utils.msg_error);

Line 61: p_error_type => wip_jdi_utils.msg_error);

57: p_error_type => wip_jdi_utils.msg_error);
58: else
59: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
60: p_text => substr(fnd_message.get,1,500),
61: p_error_type => wip_jdi_utils.msg_error);
62: end if;
63: end loop;
64:
65: if(l_error_exists) then

Line 135: p_error_type => wip_jdi_utils.msg_error);

131: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
132: if(wip_job_details.std_alone = 1) then
133: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
134: p_text => substr(fnd_message.get,1,500),
135: p_error_type => wip_jdi_utils.msg_error);
136: else
137: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);

Line 139: p_error_type => wip_jdi_utils.msg_error);

135: p_error_type => wip_jdi_utils.msg_error);
136: else
137: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
138: p_text => substr(fnd_message.get,1,500),
139: p_error_type => wip_jdi_utils.msg_error);
140: end if;
141: end loop;
142:
143: if(l_error_exists) then

Line 245: p_error_type => wip_jdi_utils.msg_error);

241: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
242: if(wip_job_details.std_alone = 1) then
243: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
244: p_text => substr(fnd_message.get,1,500),
245: p_error_type => wip_jdi_utils.msg_error);
246: else
247: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
248: p_text => substr(fnd_message.get,1,500),
249: p_error_type => wip_jdi_utils.msg_error);

Line 249: p_error_type => wip_jdi_utils.msg_error);

245: p_error_type => wip_jdi_utils.msg_error);
246: else
247: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
248: p_text => substr(fnd_message.get,1,500),
249: p_error_type => wip_jdi_utils.msg_error);
250: end if;
251: end loop;
252:
253: if(l_error_exists) then

Line 284: p_error_type => wip_jdi_utils.msg_error);

280: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
281: if(wip_job_details.std_alone = 1) then
282: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
283: p_text => substr(fnd_message.get,1,500),
284: p_error_type => wip_jdi_utils.msg_error);
285: else
286: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
287: p_text => substr(fnd_message.get,1,500),
288: p_error_type => wip_jdi_utils.msg_error);

Line 288: p_error_type => wip_jdi_utils.msg_error);

284: p_error_type => wip_jdi_utils.msg_error);
285: else
286: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
287: p_text => substr(fnd_message.get,1,500),
288: p_error_type => wip_jdi_utils.msg_error);
289: end if;
290: end loop;
291:
292: if(l_error_exists) then

Line 426: p_error_type => wip_jdi_utils.msg_warning);

422: IF(wip_job_details.std_alone = 1) THEN
423: wip_interface_err_Utils.add_error(
424: p_interface_id => l_inv_row.interface_id,
425: p_text => substrb(l_error_text,1,500),
426: p_error_type => wip_jdi_utils.msg_warning);
427: ELSE
428: wip_interface_err_Utils.add_error(
429: p_interface_id => wip_jsi_utils.current_interface_id,
430: p_text => substrb(l_error_text,1,500),

Line 431: p_error_type => wip_jdi_utils.msg_warning);

427: ELSE
428: wip_interface_err_Utils.add_error(
429: p_interface_id => wip_jsi_utils.current_interface_id,
430: p_text => substrb(l_error_text,1,500),
431: p_error_type => wip_jdi_utils.msg_warning);
432: END IF;
433: END IF; -- check return status
434: ELSE
435: -- propagate_job_change_to_po is manual or customer does not have PO FPJ

Line 443: p_error_type => wip_jdi_utils.msg_warning);

439: IF(wip_job_details.std_alone = 1) THEN
440: wip_interface_err_Utils.add_error(
441: p_interface_id => l_inv_row.interface_id,
442: p_text => l_error_text,
443: p_error_type => wip_jdi_utils.msg_warning);
444: ELSE
445: wip_interface_err_Utils.add_error(
446: p_interface_id => wip_jsi_utils.current_interface_id,
447: p_text => l_error_text,

Line 448: p_error_type => wip_jdi_utils.msg_warning);

444: ELSE
445: wip_interface_err_Utils.add_error(
446: p_interface_id => wip_jsi_utils.current_interface_id,
447: p_text => l_error_text,
448: p_error_type => wip_jdi_utils.msg_warning);
449: END IF;
450: END IF; -- propagate_job_change_to_po check
451: end loop;
452:

Line 641: p_error_type => wip_jdi_utils.msg_error);

637: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
638: if(wip_job_details.std_alone = 1) then
639: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
640: p_text => substr(fnd_message.get,1,500),
641: p_error_type => wip_jdi_utils.msg_error);
642: else
643: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
644: p_text => substr(fnd_message.get,1,500),
645: p_error_type => wip_jdi_utils.msg_error);

Line 645: p_error_type => wip_jdi_utils.msg_error);

641: p_error_type => wip_jdi_utils.msg_error);
642: else
643: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
644: p_text => substr(fnd_message.get,1,500),
645: p_error_type => wip_jdi_utils.msg_error);
646: end if;
647: end loop;
648:
649: if(l_error_exists) then

Line 703: p_error_type => wip_jdi_utils.msg_error);

699: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
700: if(wip_job_details.std_alone = 1) then
701: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
702: p_text => substr(fnd_message.get,1,500),
703: p_error_type => wip_jdi_utils.msg_error);
704: else
705: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
706: p_text => substr(fnd_message.get,1,500),
707: p_error_type => wip_jdi_utils.msg_error);

Line 707: p_error_type => wip_jdi_utils.msg_error);

703: p_error_type => wip_jdi_utils.msg_error);
704: else
705: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
706: p_text => substr(fnd_message.get,1,500),
707: p_error_type => wip_jdi_utils.msg_error);
708: end if;
709: end loop;
710:
711: if(l_error_exists) then

Line 777: p_error_type => wip_jdi_utils.msg_error);

773: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
774: if(wip_job_details.std_alone = 1) then
775: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
776: p_text => substr(fnd_message.get,1,500),
777: p_error_type => wip_jdi_utils.msg_error);
778: else
779: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
780: p_text => substr(fnd_message.get,1,500),
781: p_error_type => wip_jdi_utils.msg_error);

Line 781: p_error_type => wip_jdi_utils.msg_error);

777: p_error_type => wip_jdi_utils.msg_error);
778: else
779: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
780: p_text => substr(fnd_message.get,1,500),
781: p_error_type => wip_jdi_utils.msg_error);
782: end if;
783: end loop;
784:
785: if(l_error_exists) then

Line 871: p_error_type => wip_jdi_utils.msg_error);

867: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
868: if(wip_job_details.std_alone = 1) then
869: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
870: p_text => substr(fnd_message.get,1,500),
871: p_error_type => wip_jdi_utils.msg_error);
872: else
873: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
874: p_text => substr(fnd_message.get,1,500),
875: p_error_type => wip_jdi_utils.msg_error);

Line 875: p_error_type => wip_jdi_utils.msg_error);

871: p_error_type => wip_jdi_utils.msg_error);
872: else
873: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
874: p_text => substr(fnd_message.get,1,500),
875: p_error_type => wip_jdi_utils.msg_error);
876: end if;
877: end loop;
878:
879: if(l_error_exists) then

Line 972: p_error_type => wip_jdi_utils.msg_error);

968: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
969: if(wip_job_details.std_alone = 1) then
970: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
971: p_text => substr(fnd_message.get,1,500),
972: p_error_type => wip_jdi_utils.msg_error);
973: else
974: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
975: p_text => substr(fnd_message.get,1,500),
976: p_error_type => wip_jdi_utils.msg_error);

Line 976: p_error_type => wip_jdi_utils.msg_error);

972: p_error_type => wip_jdi_utils.msg_error);
973: else
974: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
975: p_text => substr(fnd_message.get,1,500),
976: p_error_type => wip_jdi_utils.msg_error);
977: end if;
978: end loop;
979:
980: if(l_error_exists) then

Line 1074: p_error_type => wip_jdi_utils.msg_error);

1070: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1071: if(wip_job_details.std_alone = 1) then
1072: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1073: p_text => substr(fnd_message.get,1,500),
1074: p_error_type => wip_jdi_utils.msg_error);
1075: else
1076: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1077: p_text => substr(fnd_message.get,1,500),
1078: p_error_type => wip_jdi_utils.msg_error);

Line 1078: p_error_type => wip_jdi_utils.msg_error);

1074: p_error_type => wip_jdi_utils.msg_error);
1075: else
1076: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1077: p_text => substr(fnd_message.get,1,500),
1078: p_error_type => wip_jdi_utils.msg_error);
1079: end if;
1080: end loop;
1081:
1082: if(l_error_exists) then

Line 1114: p_error_type => wip_jdi_utils.msg_error);

1110: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1111: if(wip_job_details.std_alone = 1) then
1112: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1113: p_text => substr(fnd_message.get,1,500),
1114: p_error_type => wip_jdi_utils.msg_error);
1115: else
1116: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1117: p_text => substr(fnd_message.get,1,500),
1118: p_error_type => wip_jdi_utils.msg_error);

Line 1118: p_error_type => wip_jdi_utils.msg_error);

1114: p_error_type => wip_jdi_utils.msg_error);
1115: else
1116: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1117: p_text => substr(fnd_message.get,1,500),
1118: p_error_type => wip_jdi_utils.msg_error);
1119: end if;
1120: end if;
1121: end loop;
1122:

Line 1220: p_error_type => wip_jdi_utils.msg_error);

1216: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1217: if(wip_job_details.std_alone = 1) then
1218: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1219: p_text => substr(fnd_message.get,1,500),
1220: p_error_type => wip_jdi_utils.msg_error);
1221: else
1222: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1223: p_text => substr(fnd_message.get,1,500),
1224: p_error_type => wip_jdi_utils.msg_error);

Line 1224: p_error_type => wip_jdi_utils.msg_error);

1220: p_error_type => wip_jdi_utils.msg_error);
1221: else
1222: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1223: p_text => substr(fnd_message.get,1,500),
1224: p_error_type => wip_jdi_utils.msg_error);
1225: end if;
1226: end loop;
1227:
1228: if(l_error_exists) then

Line 1615: p_error_type => wip_jdi_utils.msg_error);

1611: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1612: if(wip_job_details.std_alone = 1) then
1613: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1614: p_text => substr(fnd_message.get,1,500),
1615: p_error_type => wip_jdi_utils.msg_error);
1616: else
1617: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1618: p_text => substr(fnd_message.get,1,500),
1619: p_error_type => wip_jdi_utils.msg_error);

Line 1619: p_error_type => wip_jdi_utils.msg_error);

1615: p_error_type => wip_jdi_utils.msg_error);
1616: else
1617: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1618: p_text => substr(fnd_message.get,1,500),
1619: p_error_type => wip_jdi_utils.msg_error);
1620: end if;
1621: end loop;
1622: if(l_error_exists) then
1623: update wip_job_dtls_interface wjdi

Line 1676: p_error_type => wip_jdi_utils.msg_error);

1672: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1673: if(wip_job_details.std_alone = 1) then
1674: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1675: p_text => substr(fnd_message.get,1,500),
1676: p_error_type => wip_jdi_utils.msg_error);
1677: else
1678: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1679: p_text => substr(fnd_message.get,1,500),
1680: p_error_type => wip_jdi_utils.msg_error);

Line 1680: p_error_type => wip_jdi_utils.msg_error);

1676: p_error_type => wip_jdi_utils.msg_error);
1677: else
1678: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1679: p_text => substr(fnd_message.get,1,500),
1680: p_error_type => wip_jdi_utils.msg_error);
1681: end if;
1682: end loop;
1683:
1684: if(l_error_exists) then

Line 2239: p_error_type => wip_jdi_utils.msg_error);

2235: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2236: if(wip_job_details.std_alone = 1) then
2237: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2238: p_text => substr(fnd_message.get,1,500),
2239: p_error_type => wip_jdi_utils.msg_error);
2240: else
2241: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2242: p_text => substr(fnd_message.get,1,500),
2243: p_error_type => wip_jdi_utils.msg_error);

Line 2243: p_error_type => wip_jdi_utils.msg_error);

2239: p_error_type => wip_jdi_utils.msg_error);
2240: else
2241: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2242: p_text => substr(fnd_message.get,1,500),
2243: p_error_type => wip_jdi_utils.msg_error);
2244: end if;
2245: end loop;
2246:
2247: if(l_error_exists) then

Line 2366: p_error_type => wip_jdi_utils.msg_error);

2362: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2363: if(wip_job_details.std_alone = 1) then
2364: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2365: p_text => substr(fnd_message.get,1,500),
2366: p_error_type => wip_jdi_utils.msg_error);
2367: else
2368: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2369: p_text => substr(fnd_message.get,1,500),
2370: p_error_type => wip_jdi_utils.msg_error);

Line 2370: p_error_type => wip_jdi_utils.msg_error);

2366: p_error_type => wip_jdi_utils.msg_error);
2367: else
2368: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2369: p_text => substr(fnd_message.get,1,500),
2370: p_error_type => wip_jdi_utils.msg_error);
2371: end if;
2372: end loop;
2373:
2374: if(l_error_exists) then

Line 2818: p_error_type => wip_jdi_utils.msg_error);

2814: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
2815: if(wip_job_details.std_alone = 1) then
2816: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
2817: p_text => substr(fnd_message.get,1,500),
2818: p_error_type => wip_jdi_utils.msg_error);
2819: else
2820: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2821: p_text => substr(fnd_message.get,1,500),
2822: p_error_type => wip_jdi_utils.msg_error);

Line 2822: p_error_type => wip_jdi_utils.msg_error);

2818: p_error_type => wip_jdi_utils.msg_error);
2819: else
2820: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2821: p_text => substr(fnd_message.get,1,500),
2822: p_error_type => wip_jdi_utils.msg_error);
2823: end if;
2824:
2825: update wip_job_dtls_interface
2826: set process_status = wip_constants.error

Line 2975: p_error_type => wip_jdi_utils.msg_error);

2971: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
2972: if(wip_job_details.std_alone = 1) then
2973: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
2974: p_text => substr(fnd_message.get,1,500),
2975: p_error_type => wip_jdi_utils.msg_error);
2976: else
2977: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2978: p_text => substr(fnd_message.get,1,500),
2979: p_error_type => wip_jdi_utils.msg_error);

Line 2979: p_error_type => wip_jdi_utils.msg_error);

2975: p_error_type => wip_jdi_utils.msg_error);
2976: else
2977: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2978: p_text => substr(fnd_message.get,1,500),
2979: p_error_type => wip_jdi_utils.msg_error);
2980: end if;
2981:
2982: update wip_job_dtls_interface
2983: set process_status = wip_constants.error

Line 2996: p_error_type => wip_jdi_utils.msg_error);

2992: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
2993: if(wip_job_details.std_alone = 1) then
2994: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
2995: p_text => substr(fnd_message.get,1,500),
2996: p_error_type => wip_jdi_utils.msg_error);
2997: else
2998: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2999: p_text => substr(fnd_message.get,1,500),
3000: p_error_type => wip_jdi_utils.msg_error);

Line 3000: p_error_type => wip_jdi_utils.msg_error);

2996: p_error_type => wip_jdi_utils.msg_error);
2997: else
2998: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2999: p_text => substr(fnd_message.get,1,500),
3000: p_error_type => wip_jdi_utils.msg_error);
3001: end if;
3002:
3003: update wip_job_dtls_interface
3004: set process_status = wip_constants.error

Line 3042: p_error_type => wip_jdi_utils.msg_error);

3038: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
3039: if(wip_job_details.std_alone = 1) then
3040: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
3041: p_text => substr(fnd_message.get,1,500),
3042: p_error_type => wip_jdi_utils.msg_error);
3043: else
3044: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3045: p_text => substr(fnd_message.get,1,500),
3046: p_error_type => wip_jdi_utils.msg_error);

Line 3046: p_error_type => wip_jdi_utils.msg_error);

3042: p_error_type => wip_jdi_utils.msg_error);
3043: else
3044: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3045: p_text => substr(fnd_message.get,1,500),
3046: p_error_type => wip_jdi_utils.msg_error);
3047: end if;
3048:
3049: update wip_job_dtls_interface
3050: set process_status = wip_constants.error

Line 3086: p_error_type => wip_jdi_utils.msg_error);

3082: for l_inv_row in c_invalid_rows(l_op_seq) loop
3083: if(wip_job_details.std_alone = 1) then
3084: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
3085: p_text => substr(l_error_msg,1,500),
3086: p_error_type => wip_jdi_utils.msg_error);
3087: else
3088: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3089: p_text => substr(l_error_msg,1,500),
3090: p_error_type => wip_jdi_utils.msg_error);

Line 3090: p_error_type => wip_jdi_utils.msg_error);

3086: p_error_type => wip_jdi_utils.msg_error);
3087: else
3088: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3089: p_text => substr(l_error_msg,1,500),
3090: p_error_type => wip_jdi_utils.msg_error);
3091: end if;
3092: end loop;
3093:
3094: update wip_job_dtls_interface wjdi