DBA Data[Home] [Help]

APPS.AMW_PARAMETERS_PVT_PKG dependencies on FND_FILE

Line 443: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Option provided. Defaulting from Risk Library');

439: errbuf :='';
440:
441: -- first check whether the options available or not.
442: if p_proc_approval_option is null then
443: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Option provided. Defaulting from Risk Library');
444: -- Select the Values from Risk Library...
445: select parameter_value
446: into l_proc_approval_option
447: from amw_parameters

Line 455: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Required Parameter provided. Defaulting from Risk Library');

451: l_proc_approval_option := p_proc_approval_option;
452: end if;
453:
454: if p_approval_required is null then
455: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Required Parameter provided. Defaulting from Risk Library');
456: select parameter_value
457: into l_proc_auto_approve
458: from amw_parameters
459: where parameter_name = 'PROCESS_AUTO_APPROVE'

Line 470: fnd_file.put_line (fnd_file.LOG, 'Updating Existing Org Parameters. Skipping Organizations where Process are in pending approval.');

466: end if;
467: if 'ALL' = p_all_orgs OR 'NOCONF' = p_all_orgs then
468: -- Now check p_all_orgs
469: if 'ALL' = p_all_orgs then
470: fnd_file.put_line (fnd_file.LOG, 'Updating Existing Org Parameters. Skipping Organizations where Process are in pending approval.');
471: -- now update those that are configured..
472: for org in orgs_to_update loop
473: exit when orgs_to_update%notfound;
474: