DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on FND_PROFILE

Line 525: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,

521: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
522: end if;
523:
524: update wip_job_schedule_interface wjsi
525: set wjsi.job_name = fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval,
526: wjsi.last_update_date = sysdate
527: where wjsi.group_id = p_groupID
528: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
529: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

Line 1204: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');

1200: fnd_message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID');
1201: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationError);
1202: end if;
1203:
1204: l_see_eng_items_flag := fnd_profile.value('WIP_SEE_ENG_ITEMS');
1205: update wip_job_schedule_interface wjsi
1206: set wjsi.process_status = WIP_CONSTANTS.ERROR,
1207: wjsi.last_update_date = sysdate
1208: where wjsi.group_id = p_groupID

Line 3103: l_orginalOrgContext := nvl(fnd_profile.value('ORG_ID'), -1);

3099:
3100: validateKanban(line.rowid, p_validationLevel, l_msg);
3101:
3102: -- save the original org context
3103: l_orginalOrgContext := nvl(fnd_profile.value('ORG_ID'), -1);
3104:
3105: -- set the org context for future PJM validation
3106: -- Bug 4890514. Performance Fix
3107: -- saugupta 25th-May-2006

Line 3450: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);

3446: l_errCode varchar2(80);
3447: l_result varchar2(1);
3448: begin
3449: -- fix MOAC, set id so project view works
3450: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
3451: if ( wjsi_row.load_type <> wip_constants.create_sched ) then
3452: begin
3453: if ( wjsi_row.project_number is not null and wjsi_row.project_id is null) then
3454: -- Bug 4890514. Performance Fix