203: begin
204: x_returnStatus := fnd_api.g_ret_sts_success;
205:
206: --Fix for bug#4186944. Update REQUEST_ID
207: x_request_id := fnd_global.conc_request_id ;
208: x_program_id := fnd_global.conc_program_id ;
209: x_application_id := fnd_global.prog_appl_id ;
210:
211: if (l_logLevel <= wip_constants.trace_logging) then
204: x_returnStatus := fnd_api.g_ret_sts_success;
205:
206: --Fix for bug#4186944. Update REQUEST_ID
207: x_request_id := fnd_global.conc_request_id ;
208: x_program_id := fnd_global.conc_program_id ;
209: x_application_id := fnd_global.prog_appl_id ;
210:
211: if (l_logLevel <= wip_constants.trace_logging) then
212: l_params(1).paramName := 'p_groupID';
205:
206: --Fix for bug#4186944. Update REQUEST_ID
207: x_request_id := fnd_global.conc_request_id ;
208: x_program_id := fnd_global.conc_program_id ;
209: x_application_id := fnd_global.prog_appl_id ;
210:
211: if (l_logLevel <= wip_constants.trace_logging) then
212: l_params(1).paramName := 'p_groupID';
213: l_params(1).paramValue := p_groupID;
810: select l_schedGroupID,
811: wds.name,
812: wjsi.organization_id,
813: to_char(sysdate),
814: fnd_global.user_id,
815: fnd_global.user_id,
816: sysdate,
817: sysdate
818: from wsh_new_deliveries wds,
811: wds.name,
812: wjsi.organization_id,
813: to_char(sysdate),
814: fnd_global.user_id,
815: fnd_global.user_id,
816: sysdate,
817: sysdate
818: from wsh_new_deliveries wds,
819: wip_job_schedule_interface wjsi
5028: p_type,
5029: substr(p_text,1,500),
5030: sysdate,
5031: sysdate,
5032: fnd_global.user_id,
5033: fnd_global.login_id,
5034: fnd_global.user_id);
5035: end loop;
5036: -- clear the interface id table
5029: substr(p_text,1,500),
5030: sysdate,
5031: sysdate,
5032: fnd_global.user_id,
5033: fnd_global.login_id,
5034: fnd_global.user_id);
5035: end loop;
5036: -- clear the interface id table
5037: p_interfaceTbl.delete;
5030: sysdate,
5031: sysdate,
5032: fnd_global.user_id,
5033: fnd_global.login_id,
5034: fnd_global.user_id);
5035: end loop;
5036: -- clear the interface id table
5037: p_interfaceTbl.delete;
5038: end loadInterfaceError;
5069: p_type,
5070: substr(p_text,1,500),
5071: sysdate,
5072: sysdate,
5073: fnd_global.user_id,
5074: fnd_global.login_id,
5075: fnd_global.user_id
5076: );
5077: end setInterfaceError;
5070: substr(p_text,1,500),
5071: sysdate,
5072: sysdate,
5073: fnd_global.user_id,
5074: fnd_global.login_id,
5075: fnd_global.user_id
5076: );
5077: end setInterfaceError;
5078:
5071: sysdate,
5072: sysdate,
5073: fnd_global.user_id,
5074: fnd_global.login_id,
5075: fnd_global.user_id
5076: );
5077: end setInterfaceError;
5078:
5079: end wip_validateMLHeader_pvt;