DBA Data[Home] [Help]

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 872: p_error_type => wip_jdi_utils.msg_error);

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

Line 876: p_error_type => wip_jdi_utils.msg_error);

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

Line 974: p_error_type => wip_jdi_utils.msg_error);

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

Line 978: p_error_type => wip_jdi_utils.msg_error);

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

Line 1077: p_error_type => wip_jdi_utils.msg_error);

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

Line 1081: p_error_type => wip_jdi_utils.msg_error);

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

Line 1118: p_error_type => wip_jdi_utils.msg_error);

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

Line 1122: p_error_type => wip_jdi_utils.msg_error);

1118: p_error_type => wip_jdi_utils.msg_error);
1119: else
1120: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1121: p_text => substr(fnd_message.get,1,500),
1122: p_error_type => wip_jdi_utils.msg_error);
1123: end if;
1124: end if;
1125: end loop;
1126:

Line 1252: p_error_type => wip_jdi_utils.msg_error);

1248: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1249: if(wip_job_details.std_alone = 1) then
1250: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1251: p_text => substr(fnd_message.get,1,500),
1252: p_error_type => wip_jdi_utils.msg_error);
1253: else
1254: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1255: p_text => substr(fnd_message.get,1,500),
1256: p_error_type => wip_jdi_utils.msg_error);

Line 1256: p_error_type => wip_jdi_utils.msg_error);

1252: p_error_type => wip_jdi_utils.msg_error);
1253: else
1254: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1255: p_text => substr(fnd_message.get,1,500),
1256: p_error_type => wip_jdi_utils.msg_error);
1257: end if;
1258: end loop;
1259:
1260: if(l_error_exists) then

Line 1647: p_error_type => wip_jdi_utils.msg_error);

1643: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1644: if(wip_job_details.std_alone = 1) then
1645: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1646: p_text => substr(fnd_message.get,1,500),
1647: p_error_type => wip_jdi_utils.msg_error);
1648: else
1649: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1650: p_text => substr(fnd_message.get,1,500),
1651: p_error_type => wip_jdi_utils.msg_error);

Line 1651: p_error_type => wip_jdi_utils.msg_error);

1647: p_error_type => wip_jdi_utils.msg_error);
1648: else
1649: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1650: p_text => substr(fnd_message.get,1,500),
1651: p_error_type => wip_jdi_utils.msg_error);
1652: end if;
1653: end loop;
1654: if(l_error_exists) then
1655: update wip_job_dtls_interface wjdi

Line 1708: p_error_type => wip_jdi_utils.msg_error);

1704: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1705: if(wip_job_details.std_alone = 1) then
1706: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1707: p_text => substr(fnd_message.get,1,500),
1708: p_error_type => wip_jdi_utils.msg_error);
1709: else
1710: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1711: p_text => substr(fnd_message.get,1,500),
1712: p_error_type => wip_jdi_utils.msg_error);

Line 1712: p_error_type => wip_jdi_utils.msg_error);

1708: p_error_type => wip_jdi_utils.msg_error);
1709: else
1710: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
1711: p_text => substr(fnd_message.get,1,500),
1712: p_error_type => wip_jdi_utils.msg_error);
1713: end if;
1714: end loop;
1715:
1716: if(l_error_exists) then

Line 2284: p_error_type => wip_jdi_utils.msg_error);

2280: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2281: if(wip_job_details.std_alone = 1) then
2282: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2283: p_text => substr(fnd_message.get,1,500),
2284: p_error_type => wip_jdi_utils.msg_error);
2285: else
2286: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2287: p_text => substr(fnd_message.get,1,500),
2288: p_error_type => wip_jdi_utils.msg_error);

Line 2288: p_error_type => wip_jdi_utils.msg_error);

2284: p_error_type => wip_jdi_utils.msg_error);
2285: else
2286: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2287: p_text => substr(fnd_message.get,1,500),
2288: p_error_type => wip_jdi_utils.msg_error);
2289: end if;
2290: end loop;
2291:
2292: if(l_error_exists) then

Line 2413: p_error_type => wip_jdi_utils.msg_error);

2409: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2410: if(wip_job_details.std_alone = 1) then
2411: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2412: p_text => substr(fnd_message.get,1,500),
2413: p_error_type => wip_jdi_utils.msg_error);
2414: else
2415: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2416: p_text => substr(fnd_message.get,1,500),
2417: p_error_type => wip_jdi_utils.msg_error);

Line 2417: p_error_type => wip_jdi_utils.msg_error);

2413: p_error_type => wip_jdi_utils.msg_error);
2414: else
2415: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2416: p_text => substr(fnd_message.get,1,500),
2417: p_error_type => wip_jdi_utils.msg_error);
2418: end if;
2419: end loop;
2420:
2421: if(l_error_exists) then

Line 2871: p_error_type => wip_jdi_utils.msg_error);

2867: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
2868: if(wip_job_details.std_alone = 1) then
2869: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
2870: p_text => substr(fnd_message.get,1,500),
2871: p_error_type => wip_jdi_utils.msg_error);
2872: else
2873: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2874: p_text => substr(fnd_message.get,1,500),
2875: p_error_type => wip_jdi_utils.msg_error);

Line 2875: p_error_type => wip_jdi_utils.msg_error);

2871: p_error_type => wip_jdi_utils.msg_error);
2872: else
2873: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2874: p_text => substr(fnd_message.get,1,500),
2875: p_error_type => wip_jdi_utils.msg_error);
2876: end if;
2877:
2878: update wip_job_dtls_interface
2879: set process_status = wip_constants.error

Line 3048: p_error_type => wip_jdi_utils.msg_error);

3044: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
3045: if(wip_job_details.std_alone = 1) then
3046: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
3047: p_text => substr(fnd_message.get,1,500),
3048: p_error_type => wip_jdi_utils.msg_error);
3049: else
3050: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3051: p_text => substr(fnd_message.get,1,500),
3052: p_error_type => wip_jdi_utils.msg_error);

Line 3052: p_error_type => wip_jdi_utils.msg_error);

3048: p_error_type => wip_jdi_utils.msg_error);
3049: else
3050: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3051: p_text => substr(fnd_message.get,1,500),
3052: p_error_type => wip_jdi_utils.msg_error);
3053: end if;
3054:
3055: update wip_job_dtls_interface
3056: set process_status = wip_constants.error

Line 3069: p_error_type => wip_jdi_utils.msg_error);

3065: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
3066: if(wip_job_details.std_alone = 1) then
3067: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
3068: p_text => substr(fnd_message.get,1,500),
3069: p_error_type => wip_jdi_utils.msg_error);
3070: else
3071: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3072: p_text => substr(fnd_message.get,1,500),
3073: p_error_type => wip_jdi_utils.msg_error);

Line 3073: p_error_type => wip_jdi_utils.msg_error);

3069: p_error_type => wip_jdi_utils.msg_error);
3070: else
3071: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3072: p_text => substr(fnd_message.get,1,500),
3073: p_error_type => wip_jdi_utils.msg_error);
3074: end if;
3075:
3076: update wip_job_dtls_interface
3077: set process_status = wip_constants.error

Line 3115: p_error_type => wip_jdi_utils.msg_error);

3111: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));
3112: if(wip_job_details.std_alone = 1) then
3113: wip_interface_err_Utils.add_error(p_interface_id => sched_row.interface_id,
3114: p_text => substr(fnd_message.get,1,500),
3115: p_error_type => wip_jdi_utils.msg_error);
3116: else
3117: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3118: p_text => substr(fnd_message.get,1,500),
3119: p_error_type => wip_jdi_utils.msg_error);

Line 3119: p_error_type => wip_jdi_utils.msg_error);

3115: p_error_type => wip_jdi_utils.msg_error);
3116: else
3117: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3118: p_text => substr(fnd_message.get,1,500),
3119: p_error_type => wip_jdi_utils.msg_error);
3120: end if;
3121:
3122: update wip_job_dtls_interface
3123: set process_status = wip_constants.error

Line 3159: p_error_type => wip_jdi_utils.msg_error);

3155: for l_inv_row in c_invalid_rows(l_op_seq) loop
3156: if(wip_job_details.std_alone = 1) then
3157: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
3158: p_text => substr(l_error_msg,1,500),
3159: p_error_type => wip_jdi_utils.msg_error);
3160: else
3161: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3162: p_text => substr(l_error_msg,1,500),
3163: p_error_type => wip_jdi_utils.msg_error);

Line 3163: p_error_type => wip_jdi_utils.msg_error);

3159: p_error_type => wip_jdi_utils.msg_error);
3160: else
3161: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
3162: p_text => substr(l_error_msg,1,500),
3163: p_error_type => wip_jdi_utils.msg_error);
3164: end if;
3165: end loop;
3166:
3167: update wip_job_dtls_interface wjdi