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_AP_DATA dependencies on FND_FILE

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

233: ---03.01.2005 npanandi:
234: l_new_ap boolean default true;
235: l_has_access varchar2(15);
236: BEGIN
237: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
238: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
239:
240: --
241: -- check access privilege

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

234: l_new_ap boolean default true;
235: l_has_access varchar2(15);
236: BEGIN
237: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
238: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
239:
240: --
241: -- check access privilege
242: --

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_interface_id: '||v_interface_id);

288: WHERE BATCH_ID=p_batch_id
289: AND AP_NAME=AP_INV_UPL.AP_NAME
290: AND NVL(AP_APPROVAL_STATUS_CODE,'D') <> AP_INV_UPL.AP_APPROVAL_STATUS_CODE;
291:
292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_interface_id: '||v_interface_id);
293: IF(v_count > 0) THEN
294: RAISE INV_AP_UPL_STATUSES;
295: END IF;
296: EXCEPTION

Line 493: fnd_file.put_line(fnd_file.LOG,'FOR THIS LOOP');

489: update_interface_with_error (v_err_msg
490: ,'AMW_AUDIT_PROCEDURES'
491: ,v_interface_id);
492: ELSE
493: fnd_file.put_line(fnd_file.LOG,'FOR THIS LOOP');
494: fnd_file.put_line(fnd_file.LOG,'L_AUDIT_PROCEDURE_ID: '||L_AUDIT_PROCEDURE_ID||', L_AUDIT_PROCEDURE_REV_ID: '||L_AUDIT_PROCEDURE_REV_ID);
495:
496: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'
497: if(l_has_access = 'T') then

Line 494: fnd_file.put_line(fnd_file.LOG,'L_AUDIT_PROCEDURE_ID: '||L_AUDIT_PROCEDURE_ID||', L_AUDIT_PROCEDURE_REV_ID: '||L_AUDIT_PROCEDURE_REV_ID);

490: ,'AMW_AUDIT_PROCEDURES'
491: ,v_interface_id);
492: ELSE
493: fnd_file.put_line(fnd_file.LOG,'FOR THIS LOOP');
494: fnd_file.put_line(fnd_file.LOG,'L_AUDIT_PROCEDURE_ID: '||L_AUDIT_PROCEDURE_ID||', L_AUDIT_PROCEDURE_REV_ID: '||L_AUDIT_PROCEDURE_REV_ID);
495:
496: ---03.01.2005 npanandi: call for LoadAP reqd. only if this has l_has_access='T'
497: if(l_has_access = 'T') then
498: AMW_AUDIT_PROCEDURES_PVT.INSERT_AP_CONTROL_ASSOC(

Line 542: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));

538: ,last_updated_by = v_user_id
539: WHERE batch_id = p_batch_id;
540: EXCEPTION
541: WHEN OTHERS THEN
542: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));
543: END;
544: ELSE
545: IF NOT v_error_found THEN
546: BEGIN

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

548: WHERE batch_id = p_batch_id;
549:
550: EXCEPTION
551: WHEN OTHERS THEN
552: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));
553: END;
554: END IF;
555: END IF;
556:

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INVALID AP UPLOAD STATUS FOUND' );

557: EXCEPTION
558: ---NPANANDI 11.21.2004 --> CHECK FOR CONSISTENT STATUS PER UPLOAD OF SAME AP
559: WHEN INV_AP_UPL_STATUSES THEN
560: BEGIN
561: FND_FILE.PUT_LINE(FND_FILE.LOG, 'INVALID AP UPLOAD STATUS FOUND' );
562: L_ERR_MSG := 'Multiple Approval Statuses found for this Procedure in this Upload';
563: update_interface_with_error(
564: p_ERR_MSG => L_ERR_MSG
565: ,p_table_name => 'AMW_AUDIT_PROCEDURES_B'

Line 569: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INV_AP_UPL_STATUSES: '||sqlerrm);

565: ,p_table_name => 'AMW_AUDIT_PROCEDURES_B'
566: ,P_INTERFACE_ID => V_INTERFACE_ID);
567: EXCEPTION
568: WHEN OTHERS THEN
569: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INV_AP_UPL_STATUSES: '||sqlerrm);
570: END;
571: ----Exception1
572: WHEN e_invalid_requestor_id THEN
573: fnd_file.put_line (fnd_file.LOG, 'Invalid requestor id.');

Line 573: fnd_file.put_line (fnd_file.LOG, 'Invalid requestor id.');

569: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INV_AP_UPL_STATUSES: '||sqlerrm);
570: END;
571: ----Exception1
572: WHEN e_invalid_requestor_id THEN
573: fnd_file.put_line (fnd_file.LOG, 'Invalid requestor id.');
574: BEGIN
575: IF v_invalid_requestor_msg is null THEN
576: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
577: END IF;

Line 584: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);

580: ,interface_status = v_invalid_requestor_msg
581: WHERE batch_id = p_batch_id;
582: EXCEPTION
583: WHEN OTHERS THEN
584: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);
585: END;
586:
587: ----Exception2
588: WHEN e_no_import_access THEN

Line 589: fnd_file.put_line (fnd_file.LOG, 'no import privilege');

585: END;
586:
587: ----Exception2
588: WHEN e_no_import_access THEN
589: fnd_file.put_line (fnd_file.LOG, 'no import privilege');
590: BEGIN
591: IF v_no_import_privilege_msg is null THEN
592: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
593: END IF;

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

590: BEGIN
591: IF v_no_import_privilege_msg is null THEN
592: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
593: END IF;
594: fnd_file.put_line(fnd_file.LOG,'v_no_import_privilege_msg: '||v_no_import_privilege_msg);
595: UPDATE amw_ap_interface
596: SET error_flag = 'Y'
597: ,interface_status = v_no_import_privilege_msg
598: WHERE batch_id = p_batch_id;

Line 601: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_no_import_access: '||sqlerrm);

597: ,interface_status = v_no_import_privilege_msg
598: WHERE batch_id = p_batch_id;
599: EXCEPTION
600: WHEN OTHERS THEN
601: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling e_no_import_access: '||sqlerrm);
602: END;
603:
604: ----Exception3
605: WHEN others THEN

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

603:
604: ----Exception3
605: WHEN others THEN
606: rollback;
607: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_audit_procedures: '||sqlerrm);
608: END create_audit_procedures;
609:
610: ---
611: ---03.01.2005 npanandi: add Audit Procedure Owner privilege here for data security

Line 700: fnd_file.put_line (fnd_file.LOG, '&&&&&&&&&&&&&&& inside check_function --> l_security_switch: '||l_security_switch||', l_has_access: '||l_has_access);

696: ,p_object_name => p_object_name
697: ,p_instance_pk1_value => p_instance_pk1_value
698: ,p_user_name => l_user_name);
699: end if;
700: fnd_file.put_line (fnd_file.LOG, '&&&&&&&&&&&&&&& inside check_function --> l_security_switch: '||l_security_switch||', l_has_access: '||l_has_access);
701:
702: return l_has_access;
703: end;
704: ---03.01.2005 npanandi: end function to check access privilege

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

730: 'interface_id: = '
731: || p_interface_id
732: || ' '
733: || SUBSTR (SQLERRM, 1, 100);
734: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
735: END;
736:
737: BEGIN
738: UPDATE amw_ap_interface

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

745: || '**'
746: ,error_flag = 'Y'
747: WHERE ap_interface_id = p_interface_id;
748:
749: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
750: COMMIT;
751: EXCEPTION
752: WHEN OTHERS
753: THEN

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

755: 'Error during package processing '
756: || ' interface_id: = '
757: || p_interface_id
758: || SUBSTR (SQLERRM, 1, 100);
759: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
760: END;
761:
762: COMMIT;
763: END update_interface_with_error;