DBA Data[Home] [Help]

APPS.WIP_RESOURCE_VALIDATIONS dependencies on FND_MESSAGE

Line 52: fnd_message.set_name('WIP', 'WIP_JDI_DEL_RES_INFO_MISSING');

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),

Line 53: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 56: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 130: fnd_message.set_name('WIP', 'WIP_JDI_RES_NOT_IN_JOB');

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),

Line 131: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 134: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 240: fnd_message.set_name('WIP', 'WIP_JDI_RES_APPLIED');

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),

Line 241: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 244: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 279: fnd_message.set_name('WIP', 'WIP_JDI_DELETE_RESOURCE');

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),

Line 280: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 283: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 437: fnd_message.set_name('WIP', 'WIP_DELETE_OSP_RESOURCE');

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,

Line 438: l_error_text := fnd_message.get;

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,

Line 636: fnd_message.set_name('WIP', 'WIP_JDI_ADD_RES_INFO_MISSING');

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),

Line 637: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 640: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 698: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE_DATES');

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),

Line 699: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 702: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 772: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE_DATES');

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),

Line 773: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

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);

Line 776: p_text => substr(fnd_message.get,1,500),

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),

Line 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:

Line 866: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');

862: -- Validate when adding resources
863: -- resources to be added must exist in BOM_RESOURCES, not disabled
864: for l_inv_row in c_invalid_rows 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),

Line 867: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

863: -- resources to be added must exist in BOM_RESOURCES, not disabled
864: for l_inv_row in c_invalid_rows 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);

Line 870: p_text => substr(fnd_message.get,1,500),

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,
874: p_text => substr(fnd_message.get,1,500),

Line 874: p_text => substr(fnd_message.get,1,500),

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;
878:

Line 967: fnd_message.set_name('WIP', 'WIP_JDI_RES_SEQ_NUM_EXIST');

963: -- Validate when adding resources
964: -- resource_seq_num must not exist
965: for l_inv_row in c_invalid_rows 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),

Line 968: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

964: -- resource_seq_num must not exist
965: for l_inv_row in c_invalid_rows 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);

Line 971: p_text => substr(fnd_message.get,1,500),

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,
975: p_text => substr(fnd_message.get,1,500),

Line 975: p_text => substr(fnd_message.get,1,500),

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;
979:

Line 1069: fnd_message.set_name('WIP', 'WIP_JDI_NULL_CHARGE_TYPE');

1065: if(l_autocharge_type is null) then
1066:
1067: for l_inv_row in c_invalid_rows 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),

Line 1070: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1066:
1067: for l_inv_row in c_invalid_rows 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);

Line 1073: p_text => substr(fnd_message.get,1,500),

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,
1077: p_text => substr(fnd_message.get,1,500),

Line 1077: p_text => substr(fnd_message.get,1,500),

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;
1081:

Line 1109: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_RATE');

1105: (l_autocharge_type in (3,4) or l_uom_time_class_flag)) then
1106: for l_inv_row in c_invalid_rows loop
1107: if(l_inv_row.usage_rate_or_amount = p_usage_rate_or_amount) then
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),

Line 1110: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1106: for l_inv_row in c_invalid_rows loop
1107: if(l_inv_row.usage_rate_or_amount = p_usage_rate_or_amount) then
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);

Line 1113: p_text => substr(fnd_message.get,1,500),

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,
1117: p_text => substr(fnd_message.get,1,500),

Line 1117: p_text => substr(fnd_message.get,1,500),

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;
1121: end loop;

Line 1215: fnd_message.set_name('WIP', 'WIP_INV_ASSIGNED_UNITS');

1211: end if;
1212:
1213: for l_inv_row in c_invalid_rows loop
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),

Line 1216: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1212:
1213: for l_inv_row in c_invalid_rows loop
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);

Line 1219: p_text => substr(fnd_message.get,1,500),

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,
1223: p_text => substr(fnd_message.get,1,500),

Line 1223: p_text => substr(fnd_message.get,1,500),

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;
1227:

Line 1610: fnd_message.set_name('WIP', 'WIP_ASSIGNED_UNITS_ERROR');

1606: end;
1607:
1608: for l_inv_row in c_invalid_rows 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),

Line 1611: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1607:
1608: for l_inv_row in c_invalid_rows 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);

Line 1614: p_text => substr(fnd_message.get,1,500),

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,
1618: p_text => substr(fnd_message.get,1,500),

Line 1618: p_text => substr(fnd_message.get,1,500),

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;
1622: if(l_error_exists) then

Line 1671: fnd_message.set_name('WIP', 'WIP_JDI_CHNG_RES_INFO_MISSING');

1667: /* we don't check up to usage_rate_or_amount since we assume up to
1668: resource_id_old and resource_id_new, it should be unique */
1669: for l_inv_row in c_invalid_rows 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),

Line 1672: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

1668: resource_id_old and resource_id_new, it should be unique */
1669: for l_inv_row in c_invalid_rows 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);

Line 1675: p_text => substr(fnd_message.get,1,500),

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,
1679: p_text => substr(fnd_message.get,1,500),

Line 1679: p_text => substr(fnd_message.get,1,500),

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;
1683:

Line 2234: fnd_message.set_name('WIP','WIP_JDI_RES_SUB_INFO_MISSING' );

2230: BEGIN
2231:
2232: for l_inv_row in c_invalid_rows 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),

Line 2235: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

2231:
2232: for l_inv_row in c_invalid_rows 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);

Line 2238: p_text => substr(fnd_message.get,1,500),

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,
2242: p_text => substr(fnd_message.get,1,500),

Line 2242: p_text => substr(fnd_message.get,1,500),

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;
2246:

Line 2361: fnd_message.set_name('WIP', 'WIP_JDI_RES_SUB_INFO_MISSING');

2357: begin
2358:
2359: for l_inv_row in c_invalid_rows 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),

Line 2362: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

2358:
2359: for l_inv_row in c_invalid_rows 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);

Line 2365: p_text => substr(fnd_message.get,1,500),

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,
2369: p_text => substr(fnd_message.get,1,500),

Line 2369: p_text => substr(fnd_message.get,1,500),

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;
2373:

Line 2813: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');

2809: (sched_row.schedule_seq_num <= 0) OR
2810: (sched_row.replacement_group_num <= 0 AND
2811: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
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),

Line 2814: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));

2810: (sched_row.replacement_group_num <= 0 AND
2811: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
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);

Line 2817: p_text => substr(fnd_message.get,1,500),

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,
2821: p_text => substr(fnd_message.get,1,500),

Line 2821: p_text => substr(fnd_message.get,1,500),

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:
2825: update wip_job_dtls_interface

Line 2970: fnd_message.set_name('WIP', 'WIP_JDI_INVALID_SCHED_SUB');

2966: (sched_row.schedule_seq_num <= 0) OR
2967: (sched_row.replacement_group_num <= 0 AND
2968: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
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),

Line 2971: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));

2967: (sched_row.replacement_group_num <= 0 AND
2968: p_substitution_type = WIP_JOB_DETAILS.WIP_ADD)) then
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);

Line 2974: p_text => substr(fnd_message.get,1,500),

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,
2978: p_text => substr(fnd_message.get,1,500),

Line 2978: p_text => substr(fnd_message.get,1,500),

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:
2982: update wip_job_dtls_interface

Line 2991: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');

2987: end if;
2988:
2989: if (sched_row.substitution_type = wip_job_details.wip_add) then
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),

Line 2992: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));

2988:
2989: if (sched_row.substitution_type = wip_job_details.wip_add) then
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);

Line 2995: p_text => substr(fnd_message.get,1,500),

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,
2999: p_text => substr(fnd_message.get,1,500),

Line 2999: p_text => substr(fnd_message.get,1,500),

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:
3003: update wip_job_dtls_interface

Line 3037: fnd_message.set_name('WIP', 'WIP_JDI_ALT_SUB_MISSING');

3033: where current of sched_rows;
3034: elsif (sched_row.substitute_group_num is not null) then
3035: if ((sched_row.substitute_group_num <> sub_group) AND
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),

Line 3038: fnd_message.set_token('INTERFACE', to_char(sched_row.interface_id));

3034: elsif (sched_row.substitute_group_num is not null) then
3035: if ((sched_row.substitute_group_num <> sub_group) AND
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);

Line 3041: p_text => substr(fnd_message.get,1,500),

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,
3045: p_text => substr(fnd_message.get,1,500),

Line 3045: p_text => substr(fnd_message.get,1,500),

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:
3049: update wip_job_dtls_interface