eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_LOAD_CTRL_DATA dependencies on FND_FILE

Line 303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);

299: l_new_control boolean default true;
300: l_has_access varchar2(15);
301:
302: BEGIN
303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
305:
306: --
307: -- check access privilege

Line 304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);

300: l_has_access varchar2(15);
301:
302: BEGIN
303: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
304: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
305:
306: --
307: -- check access privilege
308: --

Line 348: fnd_file.put_line (fnd_file.LOG, 'v_interface_id: '||v_interface_id);

344: v_interface_id := ctrl_rec.ctrl_interface_id;
345: l_control_approval_status_code := ctrl_rec.control_approval_status_code;
346: l_revise_control_flag := upper(NVL(ctrl_rec.revise_ctrl_flag, 'N'));
347:
348: fnd_file.put_line (fnd_file.LOG, 'v_interface_id: '||v_interface_id);
349: fnd_file.put_line (fnd_file.LOG, 'l_control_approval_status_code: '||l_control_approval_status_code);
350: fnd_file.put_line (fnd_file.LOG, 'l_revise_control_flag: '||l_revise_control_flag);
351:
352: --

Line 349: fnd_file.put_line (fnd_file.LOG, 'l_control_approval_status_code: '||l_control_approval_status_code);

345: l_control_approval_status_code := ctrl_rec.control_approval_status_code;
346: l_revise_control_flag := upper(NVL(ctrl_rec.revise_ctrl_flag, 'N'));
347:
348: fnd_file.put_line (fnd_file.LOG, 'v_interface_id: '||v_interface_id);
349: fnd_file.put_line (fnd_file.LOG, 'l_control_approval_status_code: '||l_control_approval_status_code);
350: fnd_file.put_line (fnd_file.LOG, 'l_revise_control_flag: '||l_revise_control_flag);
351:
352: --
353: -- process control

Line 350: fnd_file.put_line (fnd_file.LOG, 'l_revise_control_flag: '||l_revise_control_flag);

346: l_revise_control_flag := upper(NVL(ctrl_rec.revise_ctrl_flag, 'N'));
347:
348: fnd_file.put_line (fnd_file.LOG, 'v_interface_id: '||v_interface_id);
349: fnd_file.put_line (fnd_file.LOG, 'l_control_approval_status_code: '||l_control_approval_status_code);
350: fnd_file.put_line (fnd_file.LOG, 'l_revise_control_flag: '||l_revise_control_flag);
351:
352: --
353: -- process control
354: --

Line 372: fnd_file.put_line (fnd_file.LOG, 'l_control_name: '||l_control_name);

368: OPEN c_control_exists(l_control_name);
369: FETCH c_control_exists INTO lx_control_id, v_control_db_approval_status;
370: CLOSE c_control_exists;
371:
372: fnd_file.put_line (fnd_file.LOG, 'l_control_name: '||l_control_name);
373: fnd_file.put_line (fnd_file.LOG, 'lx_control_id: '||lx_control_id);
374: fnd_file.put_line (fnd_file.LOG, 'v_control_db_approval_status: '||v_control_db_approval_status);
375:
376: ---02.28.2005 npanandi: added data security checks

Line 373: fnd_file.put_line (fnd_file.LOG, 'lx_control_id: '||lx_control_id);

369: FETCH c_control_exists INTO lx_control_id, v_control_db_approval_status;
370: CLOSE c_control_exists;
371:
372: fnd_file.put_line (fnd_file.LOG, 'l_control_name: '||l_control_name);
373: fnd_file.put_line (fnd_file.LOG, 'lx_control_id: '||lx_control_id);
374: fnd_file.put_line (fnd_file.LOG, 'v_control_db_approval_status: '||v_control_db_approval_status);
375:
376: ---02.28.2005 npanandi: added data security checks
377: l_has_access := 'T'; ---setting this to 'T' for new Controls

Line 374: fnd_file.put_line (fnd_file.LOG, 'v_control_db_approval_status: '||v_control_db_approval_status);

370: CLOSE c_control_exists;
371:
372: fnd_file.put_line (fnd_file.LOG, 'l_control_name: '||l_control_name);
373: fnd_file.put_line (fnd_file.LOG, 'lx_control_id: '||lx_control_id);
374: fnd_file.put_line (fnd_file.LOG, 'v_control_db_approval_status: '||v_control_db_approval_status);
375:
376: ---02.28.2005 npanandi: added data security checks
377: l_has_access := 'T'; ---setting this to 'T' for new Controls
378: if(lx_control_id is not null) then

Line 381: fnd_file.put_line (fnd_file.LOG, '************** Checking Update Privilege for l_control_name: '||l_control_name);

377: l_has_access := 'T'; ---setting this to 'T' for new Controls
378: if(lx_control_id is not null) then
379: ---Check for Update privilege here
380: l_new_control := false;
381: fnd_file.put_line (fnd_file.LOG, '************** Checking Update Privilege for l_control_name: '||l_control_name);
382: l_has_access := check_function(
383: p_function => 'AMW_CTRL_UPDATE_PRVLG'
384: ,p_object_name => 'AMW_CONTROL'
385: ,p_instance_pk1_value => lx_control_id

Line 387: fnd_file.put_line (fnd_file.LOG, 'l_has_access: '||l_has_access);

383: p_function => 'AMW_CTRL_UPDATE_PRVLG'
384: ,p_object_name => 'AMW_CONTROL'
385: ,p_instance_pk1_value => lx_control_id
386: ,p_user_id => fnd_global.user_id);
387: fnd_file.put_line (fnd_file.LOG, 'l_has_access: '||l_has_access);
388: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for l_control_name: '||l_control_name);
389:
390: IF l_has_access <> 'T' then
391: v_err_msg := 'Cannot update this Ctrl';

Line 388: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for l_control_name: '||l_control_name);

384: ,p_object_name => 'AMW_CONTROL'
385: ,p_instance_pk1_value => lx_control_id
386: ,p_user_id => fnd_global.user_id);
387: fnd_file.put_line (fnd_file.LOG, 'l_has_access: '||l_has_access);
388: fnd_file.put_line (fnd_file.LOG, '************** Checked Update Privilege for l_control_name: '||l_control_name);
389:
390: IF l_has_access <> 'T' then
391: v_err_msg := 'Cannot update this Ctrl';
392: update_interface_with_error (v_err_msg

Line 430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');

426: L_CONTROL_REC.CONTROL_FREQUENCY := CTRL_REC.CONTROL_FREQUENCY;
427: ---NPANANDI 12.13.2004: ADDED BELOW FOR CTRL CLASSIFICATION ENH.
428: L_CONTROL_REC.CLASSIFICATION := CTRL_REC.CLASSIFICATION;
429:
430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');
431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);

Line 431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);

427: ---NPANANDI 12.13.2004: ADDED BELOW FOR CTRL CLASSIFICATION ENH.
428: L_CONTROL_REC.CLASSIFICATION := CTRL_REC.CLASSIFICATION;
429:
430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');
431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);

Line 432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);

428: L_CONTROL_REC.CLASSIFICATION := CTRL_REC.CLASSIFICATION;
429:
430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');
431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);

Line 433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);

429:
430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');
431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);

Line 434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);

430: fnd_file.put_line (fnd_file.LOG,'%%%%%%%%%%%%%% AMW_CONTROL_PVT.Load_Control calling below, checking values passed');
431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);

Line 435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);

431: fnd_file.put_line (fnd_file.LOG,'l_control_rec.name: '||l_control_rec.name);
432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);

Line 436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);

432: fnd_file.put_line (fnd_file.LOG,'l_control_rec.description: '||l_control_rec.description);
433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);

Line 437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);

433: fnd_file.put_line (fnd_file.LOG,'l_control_rec.approval_status: '||l_control_rec.approval_status);
434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);

Line 438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);

434: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_location: '||l_control_rec.control_location);
435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);

Line 439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);

435: fnd_file.put_line (fnd_file.LOG,'l_control_rec.control_type: '||l_control_rec.control_type);
436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);

Line 440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);

436: fnd_file.put_line (fnd_file.LOG,'l_control_rec.automation_type: '||l_control_rec.automation_type);
437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);

Line 441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);

437: fnd_file.put_line (fnd_file.LOG,'l_control_rec.application_id: '||l_control_rec.application_id);
438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);

Line 442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);

438: fnd_file.put_line (fnd_file.LOG,'l_control_rec.source: '||l_control_rec.source);
439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);

Line 443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);

439: fnd_file.put_line (fnd_file.LOG,'l_control_rec.physical_evidence: '||l_control_rec.physical_evidence);
440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);

Line 444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);

440: fnd_file.put_line (fnd_file.LOG,'l_control_rec.job_id: '||l_control_rec.job_id);
441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);

Line 445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);

441: fnd_file.put_line (fnd_file.LOG,'l_control_rec.preventive_control: '||l_control_rec.preventive_control);
442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);

Line 446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);

442: fnd_file.put_line (fnd_file.LOG,'l_control_rec.detective_control: '||l_control_rec.detective_control);
443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);
450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);

Line 447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);

443: fnd_file.put_line (fnd_file.LOG,'l_control_rec.disclosure_control: '||l_control_rec.disclosure_control);
444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);
450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);
451:

Line 448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);

444: fnd_file.put_line (fnd_file.LOG,'l_control_rec.key_mitigating: '||l_control_rec.key_mitigating);
445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);
450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);
451:
452: AMW_CONTROL_PVT.Load_Control(

Line 449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);

445: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source: '||l_control_rec.verification_source);
446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);
450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);
451:
452: AMW_CONTROL_PVT.Load_Control(
453: p_api_version_number => l_api_version_number,

Line 450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);

446: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_source_name: '||l_control_rec.verification_source_name);
447: fnd_file.put_line (fnd_file.LOG,'l_control_rec.verification_instruction: '||l_control_rec.verification_instruction);
448: fnd_file.put_line (fnd_file.LOG,'l_control_rec.UOM_CODE: '||l_control_rec.UOM_CODE);
449: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CONTROL_FREQUENCY: '||l_control_rec.CONTROL_FREQUENCY);
450: fnd_file.put_line (fnd_file.LOG,'l_control_rec.CLASSIFICATION: '||l_control_rec.CLASSIFICATION);
451:
452: AMW_CONTROL_PVT.Load_Control(
453: p_api_version_number => l_api_version_number,
454: p_init_msg_list => FND_API.G_TRUE,

Line 477: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);

473: ,p_user_id => FND_GLOBAL.USER_ID);
474: end if;
475: ---02.28.2005 npanandi: if new Control, grant CtrlOwner prvlg
476:
477: fnd_file.put_line (fnd_file.LOG,'lx_return_status: '||lx_return_status);
478: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS then
479: v_err_msg := ' ';
480: FOR x IN 1..lx_msg_count LOOP
481: if(length(v_err_msg) < 1800) then

Line 643: fnd_file.put_line (fnd_file.LOG, 'err in interface rec '||v_interface_id

639: || ' '
640: || SUBSTR (SQLERRM, 1, 100);
641: v_table_name := 'UNKNOWN';
642: update_interface_with_error (v_err_msg,v_table_name,v_interface_id);
643: fnd_file.put_line (fnd_file.LOG, 'err in interface rec '||v_interface_id
644: ||': '||SUBSTR (v_err_msg, 1, 200));
645: END;
646: END LOOP;
647:

Line 668: fnd_file.put_line (fnd_file.LOG

664: ,last_updated_by = v_user_id
665: WHERE batch_id = p_batch_id;
666: EXCEPTION
667: WHEN OTHERS THEN
668: fnd_file.put_line (fnd_file.LOG
669: ,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));
670: END;
671: ELSE
672: IF NOT v_error_found THEN

Line 679: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));

675: WHERE batch_id = p_batch_id;
676:
677: EXCEPTION
678: WHEN OTHERS THEN
679: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));
680: END;
681: END IF;
682: END IF;
683: EXCEPTION

Line 686: fnd_file.put_line (fnd_file.LOG

682: END IF;
683: EXCEPTION
684:
685: WHEN e_invalid_requestor_id THEN
686: fnd_file.put_line (fnd_file.LOG
687: , 'Invalid requestor id.');
688:
689: BEGIN
690: IF v_invalid_requestor_msg is null THEN

Line 699: fnd_file.put_line (fnd_file.LOG

695: ,interface_status = v_invalid_requestor_msg
696: WHERE batch_id = p_batch_id;
697: EXCEPTION
698: WHEN OTHERS THEN
699: fnd_file.put_line (fnd_file.LOG
700: , 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);
701: END;
702: WHEN e_no_import_access THEN
703: fnd_file.put_line (fnd_file.LOG,'no import privilege --> p_batch_id: '||p_batch_id);

Line 703: fnd_file.put_line (fnd_file.LOG,'no import privilege --> p_batch_id: '||p_batch_id);

699: fnd_file.put_line (fnd_file.LOG
700: , 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);
701: END;
702: WHEN e_no_import_access THEN
703: fnd_file.put_line (fnd_file.LOG,'no import privilege --> p_batch_id: '||p_batch_id);
704: BEGIN
705: IF v_no_import_privilege_msg is null THEN
706: fnd_file.put_line (fnd_file.LOG,'1 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
707: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');

Line 706: fnd_file.put_line (fnd_file.LOG,'1 v_no_import_privilege_msg: '||v_no_import_privilege_msg);

702: WHEN e_no_import_access THEN
703: fnd_file.put_line (fnd_file.LOG,'no import privilege --> p_batch_id: '||p_batch_id);
704: BEGIN
705: IF v_no_import_privilege_msg is null THEN
706: fnd_file.put_line (fnd_file.LOG,'1 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
707: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
708: fnd_file.put_line (fnd_file.LOG,'2 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
709: END IF;
710: UPDATE amw_ctrl_interface

Line 708: fnd_file.put_line (fnd_file.LOG,'2 v_no_import_privilege_msg: '||v_no_import_privilege_msg);

704: BEGIN
705: IF v_no_import_privilege_msg is null THEN
706: fnd_file.put_line (fnd_file.LOG,'1 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
707: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
708: fnd_file.put_line (fnd_file.LOG,'2 v_no_import_privilege_msg: '||v_no_import_privilege_msg);
709: END IF;
710: UPDATE amw_ctrl_interface
711: SET error_flag = 'Y'
712: ,interface_status = v_no_import_privilege_msg

Line 714: fnd_file.put_line (fnd_file.LOG,'updated the Intf table');

710: UPDATE amw_ctrl_interface
711: SET error_flag = 'Y'
712: ,interface_status = v_no_import_privilege_msg
713: WHERE batch_id = p_batch_id;
714: fnd_file.put_line (fnd_file.LOG,'updated the Intf table');
715: EXCEPTION
716: WHEN OTHERS THEN
717: fnd_file.put_line (fnd_file.LOG
718: , 'unexpected exception in handling e_no_import_access: '||sqlerrm);

Line 717: fnd_file.put_line (fnd_file.LOG

713: WHERE batch_id = p_batch_id;
714: fnd_file.put_line (fnd_file.LOG,'updated the Intf table');
715: EXCEPTION
716: WHEN OTHERS THEN
717: fnd_file.put_line (fnd_file.LOG
718: , 'unexpected exception in handling e_no_import_access: '||sqlerrm);
719: END;
720: WHEN others THEN
721: rollback;

Line 722: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_controls: '||sqlerrm);

718: , 'unexpected exception in handling e_no_import_access: '||sqlerrm);
719: END;
720: WHEN others THEN
721: rollback;
722: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_controls: '||sqlerrm);
723: END create_controls;
724:
725: --
726: -- Insert or update the control components

Line 745: ---fnd_file.put_line(fnd_file.log,'control_objectives --> p_ctrl_obj_flag: '||p_ctrl_obj_flag||'p_lookup_tag: '||p_lookup_tag);

741: l_comp_exists number;
742: e_invalid_comp EXCEPTION;
743: e_invalid_flag EXCEPTION;
744: BEGIN
745: ---fnd_file.put_line(fnd_file.log,'control_objectives --> p_ctrl_obj_flag: '||p_ctrl_obj_flag||'p_lookup_tag: '||p_lookup_tag);
746:
747: IF p_ctrl_comp_flag is not null THEN
748: IF UPPER (p_ctrl_comp_flag) = 'Y' THEN
749: l_ctrl_comp_flag := 'Y';

Line 883: ---fnd_file.put_line(fnd_file.log,'control_objectives --> p_ctrl_obj_flag: '||p_ctrl_obj_flag||'p_lookup_tag: '||p_lookup_tag);

879: l_obj_exists number;
880: e_invalid_obj EXCEPTION;
881: e_invalid_flag EXCEPTION;
882: BEGIN
883: ---fnd_file.put_line(fnd_file.log,'control_objectives --> p_ctrl_obj_flag: '||p_ctrl_obj_flag||'p_lookup_tag: '||p_lookup_tag);
884:
885: IF p_ctrl_obj_flag is not null THEN
886: IF UPPER (p_ctrl_obj_flag) = 'Y' THEN
887: l_ctrl_obj_flag := 'Y';

Line 1018: -----fnd_file.put_line(fnd_file.log,'control_assertions --> p_ctrl_assert_flag: '||p_ctrl_assert_flag||'p_lookup_tag: '||p_lookup_tag);

1014: l_assert_exists number;
1015: e_invalid_assert EXCEPTION;
1016: e_invalid_flag EXCEPTION;
1017: BEGIN
1018: -----fnd_file.put_line(fnd_file.log,'control_assertions --> p_ctrl_assert_flag: '||p_ctrl_assert_flag||'p_lookup_tag: '||p_lookup_tag);
1019:
1020: IF (p_ctrl_assert_flag is not null) THEN
1021: IF UPPER (p_ctrl_assert_flag) = 'Y' THEN
1022: l_ctrl_assert_flag := 'Y';

Line 1390: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1386: 'interface_id: = '
1387: || p_interface_id
1388: || ' '
1389: || SUBSTR (SQLERRM, 1, 100);
1390: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1391: END;
1392:
1393: BEGIN
1394: UPDATE amw_ctrl_interface

Line 1405: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));

1401: || '**'
1402: ,error_flag = 'Y'
1403: WHERE ctrl_interface_id = p_interface_id;
1404:
1405: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
1406: COMMIT;
1407: EXCEPTION
1408: WHEN OTHERS
1409: THEN

Line 1415: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));

1411: 'Error during package processing '
1412: || ' interface_id: = '
1413: || p_interface_id
1414: || SUBSTR (SQLERRM, 1, 100);
1415: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
1416: END;
1417:
1418: COMMIT;
1419: END update_interface_with_error;