DBA Data[Home] [Help]

APPS.WIP_JOB_DETAILS dependencies on FND_MESSAGE

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

1134: end if;
1135:
1136: for l_inv_row in c_invalid_rows loop
1137: l_error_exists := true;
1138: fnd_message.set_name('WIP', l_err_msg);
1139: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1140: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1141: p_text => substr(fnd_message.get,1,500),
1142: p_error_type => wip_jdi_utils.msg_error);

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

1135:
1136: for l_inv_row in c_invalid_rows loop
1137: l_error_exists := true;
1138: fnd_message.set_name('WIP', l_err_msg);
1139: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1140: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1141: p_text => substr(fnd_message.get,1,500),
1142: p_error_type => wip_jdi_utils.msg_error);
1143: end loop;

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

1137: l_error_exists := true;
1138: fnd_message.set_name('WIP', l_err_msg);
1139: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
1140: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
1141: p_text => substr(fnd_message.get,1,500),
1142: p_error_type => wip_jdi_utils.msg_error);
1143: end loop;
1144: if(l_error_exists) then
1145: update wip_job_dtls_interface wjdi

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

1174: END IF;
1175:
1176: exception
1177: when no_data_found then --could not find the ML row
1178: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
1179: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
1180: x_err_code := SQLCODE;
1181: x_err_msg := substr(fnd_message.get, 1, 500);
1182: x_return_status := FND_API.G_RET_STS_ERROR;

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

1175:
1176: exception
1177: when no_data_found then --could not find the ML row
1178: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
1179: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
1180: x_err_code := SQLCODE;
1181: x_err_msg := substr(fnd_message.get, 1, 500);
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: when others then

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

1177: when no_data_found then --could not find the ML row
1178: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
1179: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
1180: x_err_code := SQLCODE;
1181: x_err_msg := substr(fnd_message.get, 1, 500);
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: when others then
1184: x_err_code := SQLCODE;
1185: x_err_msg := 'WIPJDLDB default wip_entity_id '||SQLERRM;