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

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

153: l_prb_counts number;
154:
155: l_has_proc_acct_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
156: BEGIN
157: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
158: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
159:
160: --
161: -- check access privilege

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

154:
155: l_has_proc_acct_assoc_access varchar2(15) := 'T'; --defaulting to 'T', which means 'has access'
156: BEGIN
157: fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
158: fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
159:
160: --
161: -- check access privilege
162: --

Line 282: fnd_file.put_line (fnd_file.LOG, 'l_process_id '||l_process_id);

278: WHEN NO_DATA_FOUND THEN
279: NULL;
280: END;
281:
282: fnd_file.put_line (fnd_file.LOG, 'l_process_id '||l_process_id);
283: fnd_file.put_line (fnd_file.LOG, 'l_natural_account_id '||l_natural_account_id);
284: fnd_file.put_line (fnd_file.LOG, 'lx_acct_assoc_id '||lx_acct_assoc_id);
285:
286: ---03.02.2005 npanandi: check here to see if this Process has AMW_UPDATE_AP_DETAILS

Line 283: fnd_file.put_line (fnd_file.LOG, 'l_natural_account_id '||l_natural_account_id);

279: NULL;
280: END;
281:
282: fnd_file.put_line (fnd_file.LOG, 'l_process_id '||l_process_id);
283: fnd_file.put_line (fnd_file.LOG, 'l_natural_account_id '||l_natural_account_id);
284: fnd_file.put_line (fnd_file.LOG, 'lx_acct_assoc_id '||lx_acct_assoc_id);
285:
286: ---03.02.2005 npanandi: check here to see if this Process has AMW_UPDATE_AP_DETAILS
287: ---privilege to associate this Control to AP

Line 284: fnd_file.put_line (fnd_file.LOG, 'lx_acct_assoc_id '||lx_acct_assoc_id);

280: END;
281:
282: fnd_file.put_line (fnd_file.LOG, 'l_process_id '||l_process_id);
283: fnd_file.put_line (fnd_file.LOG, 'l_natural_account_id '||l_natural_account_id);
284: fnd_file.put_line (fnd_file.LOG, 'lx_acct_assoc_id '||lx_acct_assoc_id);
285:
286: ---03.02.2005 npanandi: check here to see if this Process has AMW_UPDATE_AP_DETAILS
287: ---privilege to associate this Control to AP
288: l_has_proc_acct_assoc_access := 'T';

Line 295: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%% l_has_proc_acct_assoc_access: '||l_has_proc_acct_assoc_access||' %%%%%%%%%%%%%%%');

291: ,p_object_name => 'AMW_PROCESS_APPR_ETTY'
292: ,p_instance_pk1_value => l_PROCESS_ID
293: ,p_user_id => fnd_global.user_id);
294:
295: fnd_file.put_line(fnd_file.log,'%%%%%%%%%%%%%%% l_has_proc_acct_assoc_access: '||l_has_proc_acct_assoc_access||' %%%%%%%%%%%%%%%');
296:
297: if(l_has_proc_acct_assoc_access = 'T')then
298: IF (L_ACCT_ASSOCIATION_ID is null) THEN
299: --NO ROW RETRIEVED, SO ASSOCIATION DOESN'T EXIST YET

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

354: ,last_updated_by = v_user_id
355: WHERE batch_id = p_batch_id;
356: EXCEPTION
357: WHEN OTHERS THEN
358: fnd_file.put_line (fnd_file.LOG,'err in update process flag: '||SUBSTR (SQLERRM, 1, 200));
359: END;
360: ELSE
361: IF NOT v_error_found THEN
362: BEGIN

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

362: BEGIN
363: DELETE FROM amw_key_acc_interface WHERE batch_id = p_batch_id;
364: EXCEPTION
365: WHEN OTHERS THEN
366: fnd_file.put_line (fnd_file.LOG,'err in delete interface records: '||SUBSTR (SQLERRM, 1, 200));
367: END;
368: END IF;
369: END IF;
370: EXCEPTION

Line 373: fnd_file.put_line (fnd_file.LOG

369: END IF;
370: EXCEPTION
371:
372: WHEN e_invalid_requestor_id THEN
373: fnd_file.put_line (fnd_file.LOG
374: , 'Invalid requestor id.');
375:
376: BEGIN
377: IF v_invalid_requestor_msg is null THEN

Line 386: fnd_file.put_line (fnd_file.LOG

382: ,interface_status = v_invalid_requestor_msg
383: WHERE batch_id = p_batch_id;
384: EXCEPTION
385: WHEN OTHERS THEN
386: fnd_file.put_line (fnd_file.LOG
387: , 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);
388: END;
389: WHEN e_no_import_access THEN
390: fnd_file.put_line (fnd_file.LOG

Line 390: fnd_file.put_line (fnd_file.LOG

386: fnd_file.put_line (fnd_file.LOG
387: , 'unexpected exception in handling e_invalid_requestor_id: '||sqlerrm);
388: END;
389: WHEN e_no_import_access THEN
390: fnd_file.put_line (fnd_file.LOG
391: , 'no import privilege');
392:
393: BEGIN
394: IF v_no_import_privilege_msg is null THEN

Line 403: fnd_file.put_line (fnd_file.LOG

399: ,interface_status = v_no_import_privilege_msg
400: WHERE batch_id = p_batch_id;
401: EXCEPTION
402: WHEN OTHERS THEN
403: fnd_file.put_line (fnd_file.LOG
404: , 'unexpected exception in handling e_no_import_access: '||sqlerrm);
405: END;
406: WHEN others THEN
407: rollback;

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

404: , 'unexpected exception in handling e_no_import_access: '||sqlerrm);
405: END;
406: WHEN others THEN
407: rollback;
408: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in create_controls: '||sqlerrm);
409: END create_key_acc_assoc;
410:
411: PROCEDURE CREATE_AMW_KEY_ACC_ASSOC(
412: P_natural_account_id IN NUMBER

Line 472: fnd_file.put_line (fnd_file.LOG, 'l_security_switch: '||l_security_switch);

468: close c_get_user_name;
469:
470: l_security_switch := NVL(fnd_profile.VALUE ('AMW_DATA_SECURITY_SWITCH'), 'N');
471:
472: fnd_file.put_line (fnd_file.LOG, 'l_security_switch: '||l_security_switch);
473: if(l_security_switch = 'Y') then ---check for Upd prvlg only if Security mode is set on
474: l_has_access := fnd_data_security.check_function(
475: p_api_version => 1
476: ,p_function => p_function

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

510: 'interface_id: = '
511: || p_interface_id
512: || ' '
513: || SUBSTR (SQLERRM, 1, 100);
514: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
515: END;
516:
517: BEGIN
518: UPDATE amw_key_acc_interface

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

525: || '**'
526: ,error_flag = 'Y'
527: WHERE key_acc_interface_id = p_interface_id;
528:
529: fnd_file.put_line (fnd_file.LOG, SUBSTR (l_interface_status, 1, 200));
530: COMMIT;
531: EXCEPTION
532: WHEN OTHERS
533: THEN

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

535: 'Error during package processing '
536: || ' interface_id: = '
537: || p_interface_id
538: || SUBSTR (SQLERRM, 1, 100);
539: fnd_file.put_line (fnd_file.LOG, SUBSTR (v_err_msg, 1, 200));
540: END;
541:
542: COMMIT;
543: END update_interface_with_error;