51: l_error_exists := true;
52: fnd_message.set_name('WIP', 'WIP_JDI_DEL_RES_INFO_MISSING');
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,
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);
62: end if;
63: end loop;
129: l_error_exists := true;
130: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');
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,
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);
140: end if;
141: end loop;
239: l_error_exists := true;
240: fnd_message.set_name('WIP', 'WIP_JDI_RES_APPLIED');
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,
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);
250: end if;
251: end loop;
278: l_error_exists := true;
279: fnd_message.set_name('WIP', 'WIP_JDI_DELETE_RESOURCE');
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,
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);
289: end if;
290: end loop;
419: -- job, we will try to cancel as much as we can, then user need to
420: -- manually cancel the rest.
421: wip_utilities.get_message_stack(p_msg =>l_error_text);
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
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),
431: p_error_type => wip_jdi_utils.msg_warning);
432: END IF;
436: l_warning_exists := true;
437: fnd_message.set_name('WIP', 'WIP_DELETE_OSP_RESOURCE');
438: l_error_text := fnd_message.get;
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
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,
448: p_error_type => wip_jdi_utils.msg_warning);
449: END IF;
635: l_error_exists := true;
636: fnd_message.set_name('WIP', 'WIP_JDI_ADD_RES_INFO_MISSING');
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,
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);
646: end if;
647: end loop;
697: l_error_exists := true;
698: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE_DATES');
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,
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);
708: end if;
709: end loop;
771: l_error_exists := true;
772: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE_DATES');
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,
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);
782: end if;
783: end loop;
865: l_error_exists := true;
866: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');
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,
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);
876: end if;
877: end loop;
966: l_error_exists := true;
967: fnd_message.set_name('WIP', 'WIP_JDI_RES_SEQ_NUM_EXIST');
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,
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);
977: end if;
978: end loop;
1068: l_error_exists := true;
1069: fnd_message.set_name('WIP', 'WIP_JDI_NULL_CHARGE_TYPE');
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,
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);
1079: end if;
1080: end loop;
1108: l_error_exists := true;
1109: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RATE');
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,
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);
1119: end if;
1120: end if;
1214: l_error_exists := true;
1215: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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,
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);
1225: end if;
1226: end loop;
1609: l_error_exists := true;
1610: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_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,
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);
1620: end if;
1621: end loop;
1670: l_error_exists := true;
1671: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_RES_INFO_MISSING');
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,
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);
1681: end if;
1682: end loop;
2233: l_error_exists := true;
2234: fnd_message.set_name('WIP','WIP_JDI_RES_SUB_INFO_MISSING' );
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,
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);
2244: end if;
2245: end loop;
2360: l_error_exists := true;
2361: fnd_message.set_name('WIP', 'WIP_JDI_RES_SUB_INFO_MISSING');
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,
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);
2371: end if;
2372: end loop;
2812: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
2813: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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,
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);
2823: end if;
2824:
2969: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
2970: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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,
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);
2980: end if;
2981:
2990: if (sched_row.substitute_group_num is null) then
2991: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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,
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);
3001: end if;
3002:
3036: (sched_row.replacement_group_num is null)) then
3037: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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,
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);
3047: end if;
3048:
3080:
3081: if (l_status = fnd_api.g_ret_sts_error) then
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,
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);
3091: end if;
3092: end loop;