48: begin
49:
50: for l_inv_row in c_invalid_rows loop
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),
49:
50: for l_inv_row in c_invalid_rows loop
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);
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,
60: p_text => substr(fnd_message.get,1,500),
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;
64:
126: begin
127:
128: for l_inv_row in c_invalid_rows 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),
127:
128: for l_inv_row in c_invalid_rows 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);
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,
138: p_text => substr(fnd_message.get,1,500),
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;
142:
236:
237: -- applied_resource_units in WIP_OPERATION_RESOURCES must be 0
238: for l_inv_row in c_invalid_wor_rows 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),
237: -- applied_resource_units in WIP_OPERATION_RESOURCES must be 0
238: for l_inv_row in c_invalid_wor_rows 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);
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,
248: p_text => substr(fnd_message.get,1,500),
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;
252:
275:
276: --now check for [pending] transactions
277: for l_inv_row in c_invalid_txn_rows 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),
276: --now check for [pending] transactions
277: for l_inv_row in c_invalid_txn_rows 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);
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,
287: p_text => substr(fnd_message.get,1,500),
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;
291:
433: END IF; -- check return status
434: ELSE
435: -- propagate_job_change_to_po is manual or customer does not have PO FPJ
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,
434: ELSE
435: -- propagate_job_change_to_po is manual or customer does not have PO FPJ
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,
632: begin
633:
634: for l_inv_row in c_invalid_rows loop
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),
633:
634: for l_inv_row in c_invalid_rows loop
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);
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,
644: p_text => substr(fnd_message.get,1,500),
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;
648:
694: -- Validate when adding/updating resources
695: -- resource dates must be valid
696: for l_inv_row in c_invalid_rows 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),
695: -- resource dates must be valid
696: for l_inv_row in c_invalid_rows 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);
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,
706: p_text => substr(fnd_message.get,1,500),
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;
710:
768: -- Validate when adding/updating resources
769: -- resource dates must be valid
770: for l_inv_row in c_invalid_rows 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),
769: -- resource dates must be valid
770: for l_inv_row in c_invalid_rows 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);
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,
780: p_text => substr(fnd_message.get,1,500),
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;
784:
863: -- Validate when adding resources
864: -- resources to be added must exist in BOM_RESOURCES, not disabled
865: for l_inv_row in c_invalid_rows loop
866: l_error_exists := true;
867: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');
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),
864: -- resources to be added must exist in BOM_RESOURCES, not disabled
865: for l_inv_row in c_invalid_rows loop
866: l_error_exists := true;
867: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');
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);
867: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');
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),
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);
877: end if;
878: end loop;
879:
965: -- Validate when adding resources
966: -- resource_seq_num must not exist
967: for l_inv_row in c_invalid_rows loop
968: l_error_exists := true;
969: fnd_message.set_name('WIP', 'WIP_JDI_RES_SEQ_NUM_EXIST');
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),
966: -- resource_seq_num must not exist
967: for l_inv_row in c_invalid_rows loop
968: l_error_exists := true;
969: fnd_message.set_name('WIP', 'WIP_JDI_RES_SEQ_NUM_EXIST');
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);
969: fnd_message.set_name('WIP', 'WIP_JDI_RES_SEQ_NUM_EXIST');
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),
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);
979: end if;
980: end loop;
981:
1068: if(l_autocharge_type is null) then
1069:
1070: for l_inv_row in c_invalid_rows loop
1071: l_error_exists := true;
1072: fnd_message.set_name('WIP', 'WIP_JDI_NULL_CHARGE_TYPE');
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),
1069:
1070: for l_inv_row in c_invalid_rows loop
1071: l_error_exists := true;
1072: fnd_message.set_name('WIP', 'WIP_JDI_NULL_CHARGE_TYPE');
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);
1072: fnd_message.set_name('WIP', 'WIP_JDI_NULL_CHARGE_TYPE');
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),
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);
1082: end if;
1083: end loop;
1084:
1109: (l_autocharge_type in (3,4) or l_uom_time_class_flag)) then
1110: for l_inv_row in c_invalid_rows loop
1111: if(l_inv_row.usage_rate_or_amount = p_usage_rate_or_amount) then
1112: l_error_exists := true;
1113: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RATE');
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),
1110: for l_inv_row in c_invalid_rows loop
1111: if(l_inv_row.usage_rate_or_amount = p_usage_rate_or_amount) then
1112: l_error_exists := true;
1113: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RATE');
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);
1113: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RATE');
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),
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);
1123: end if;
1124: end if;
1125: end loop;
1243: */
1244:
1245: for l_inv_row in c_invalid_rows loop
1246: l_error_exists := true;
1247: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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),
1244:
1245: for l_inv_row in c_invalid_rows loop
1246: l_error_exists := true;
1247: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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);
1247: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');
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),
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);
1257: end if;
1258: end loop;
1259:
1638: end;
1639:
1640: for l_inv_row in c_invalid_rows loop
1641: l_error_exists := true;
1642: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_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),
1639:
1640: for l_inv_row in c_invalid_rows loop
1641: l_error_exists := true;
1642: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_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);
1642: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_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),
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);
1652: end if;
1653: end loop;
1654: if(l_error_exists) then
1699: /* we don't check up to usage_rate_or_amount since we assume up to
1700: resource_id_old and resource_id_new, it should be unique */
1701: for l_inv_row in c_invalid_rows loop
1702: l_error_exists := true;
1703: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_RES_INFO_MISSING');
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),
1700: resource_id_old and resource_id_new, it should be unique */
1701: for l_inv_row in c_invalid_rows loop
1702: l_error_exists := true;
1703: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_RES_INFO_MISSING');
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);
1703: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_RES_INFO_MISSING');
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),
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);
1713: end if;
1714: end loop;
1715:
2275: BEGIN
2276:
2277: for l_inv_row in c_invalid_rows loop
2278: l_error_exists := true;
2279: fnd_message.set_name('WIP','WIP_JDI_RES_SUB_INFO_MISSING' );
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),
2276:
2277: for l_inv_row in c_invalid_rows loop
2278: l_error_exists := true;
2279: fnd_message.set_name('WIP','WIP_JDI_RES_SUB_INFO_MISSING' );
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);
2279: fnd_message.set_name('WIP','WIP_JDI_RES_SUB_INFO_MISSING' );
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),
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);
2289: end if;
2290: end loop;
2291:
2404: begin
2405:
2406: for l_inv_row in c_invalid_rows loop
2407: l_error_exists := true;
2408: fnd_message.set_name('WIP', 'WIP_JDI_RES_SUB_INFO_MISSING');
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),
2405:
2406: for l_inv_row in c_invalid_rows loop
2407: l_error_exists := true;
2408: fnd_message.set_name('WIP', 'WIP_JDI_RES_SUB_INFO_MISSING');
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);
2408: fnd_message.set_name('WIP', 'WIP_JDI_RES_SUB_INFO_MISSING');
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),
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);
2418: end if;
2419: end loop;
2420:
2862: (sched_row.replacement_group_num <= 0 AND
2863: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
2864:
2865: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
2866: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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),
2863: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
2864:
2865: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
2866: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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);
2866: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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),
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);
2876: end if;
2877:
2878: update wip_job_dtls_interface
3039: (sched_row.schedule_seq_num <= 0) OR
3040: (sched_row.replacement_group_num <= 0 AND
3041: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
3042: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
3043: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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),
3040: (sched_row.replacement_group_num <= 0 AND
3041: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
3042: /*Bug 5227753 - Added AND condition above for p_substitution_type in replacement group check*/
3043: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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);
3043: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');
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),
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);
3053: end if;
3054:
3055: update wip_job_dtls_interface
3060: end if;
3061:
3062: if (sched_row.substitution_type = wip_job_details.wip_add) then
3063: if (sched_row.substitute_group_num is null) then
3064: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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),
3061:
3062: if (sched_row.substitution_type = wip_job_details.wip_add) then
3063: if (sched_row.substitute_group_num is null) then
3064: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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);
3064: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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),
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);
3074: end if;
3075:
3076: update wip_job_dtls_interface
3106: where current of sched_rows;
3107: elsif (sched_row.substitute_group_num is not null) then
3108: if ((sched_row.substitute_group_num <> sub_group) AND
3109: (sched_row.replacement_group_num is null)) then
3110: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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),
3107: elsif (sched_row.substitute_group_num is not null) then
3108: if ((sched_row.substitute_group_num <> sub_group) AND
3109: (sched_row.replacement_group_num is null)) then
3110: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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);
3110: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');
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),
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);
3120: end if;
3121:
3122: update wip_job_dtls_interface