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 867: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

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

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

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

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

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

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

Line 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

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

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

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

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

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

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

Line 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

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

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

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

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

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

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

Line 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