DBA Data[Home] [Help]

APPS.WIP_JOB_DETAILS dependencies on FND_MESSAGE

Line 842: fnd_message.set_name('WIP', l_err_msg);

838: end if;
839:
840: for l_inv_row in c_invalid_rows loop
841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);

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

839:
840: for l_inv_row in c_invalid_rows loop
841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;

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

841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;
848: if(l_error_exists) then
849: update wip_job_dtls_interface wjdi

Line 882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');

878: END IF;
879:
880: exception
881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;

Line 883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));

879:
880: exception
881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: when others then

Line 885: x_err_msg := substr(fnd_message.get, 1, 500);

881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: when others then
888: x_err_code := SQLCODE;
889: x_err_msg := 'WIPJDLDB default wip_entity_id '||SQLERRM;