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.ZPB_AW_WRITE_BACK dependencies on ZPB_LOG

Line 44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

40: P_ORDER IN NUMBER,
41: P_QDR IN VARCHAR2)
42: IS
43: BEGIN
44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
45: 'ZPB_WRITEMGR_PROCESS_TASK',
46: 'TASK_NUMBER', to_char(p_task));
47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',

Line 47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

43: BEGIN
44: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
45: 'ZPB_WRITEMGR_PROCESS_TASK',
46: 'TASK_NUMBER', to_char(p_task));
47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',
49: 'USER', p_user,
50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

Line 51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

47: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
48: 'ZPB_WRITEMGR_SUBMITTED_BY',
49: 'USER', p_user,
50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
52: 'ZPB_WRITEMGR_EXECUTE',
53: 'ORDER', to_char(p_order));
54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
55: 'ZPB_WRITEMGR_PROCEDURE',

Line 54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',

50: 'RESP', p_resp);
51: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
52: 'ZPB_WRITEMGR_EXECUTE',
53: 'ORDER', to_char(p_order));
54: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_log_user',
55: 'ZPB_WRITEMGR_PROCEDURE',
56: 'PROC', p_qdr);
57: END l_log_user;
58:

Line 73: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','Begin program :');

69: rcd_ct number;
70: prof_name varchar2(35);
71: l_aws varchar2(256);
72: BEGIN
73: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','Begin program :');
74:
75: prof_name := 'ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS';
76: fnd_profile.get(prof_name, prof_num_of_days);
77: if prof_num_of_days is null then

Line 89: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_remove_old_records',

85: where (status = COMPLETED or status = FAILED)
86: and completion_date <= (SYSDATE - num_of_days);
87:
88: if rcd_ct > 0 then
89: ZPB_LOG.WRITE_EVENT_TR ('zpb_aw_write_back.l_remove_old_records',
90: 'ZPB_WRITEMGR_CLEANUP',
91: 'DATE', (SYSDATE - (num_of_days - 1)));
92:
93: delete from ZPB_WRITEBACK_TASKS

Line 97: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','End program :');

93: delete from ZPB_WRITEBACK_TASKS
94: where (status = COMPLETED or status = FAILED)
95: and completion_date <= (SYSDATE - num_of_days);
96: end if;
97: zpb_log.write ('ZPB_AW_WRITE_BACK.l_remove_old_records','End program :');
98: END l_remove_old_records;
99:
100: ------------------------------------------------------------------------------
101: -- SUBMIT_WRITEBACK_REQUEST - Submits the writeback request

Line 512: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','Begin program :');

508: AND a.task_type = 'DO'
509: ORDER BY b.exec_order ASC;
510:
511: BEGIN
512: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','Begin program :');
513: errbuf := ' ';
514: retcode := '0';
515:
516: -- Added for Bug:5475982

Line 530: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

526: errbuf);
527: l_initialized := true;
528: end if;
529:
530: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
531: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
532: --set the initial status to failed
533: update zpb_writeback_tasks set
534: status = FAILED, completion_date = SYSDATE,

Line 594: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

590: retcode := '2';
591: END;
592: end if;
593:
594: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
595: 'Checking for Read access in accounts_states table for User'||l_user_id);
596:
597: --check this user for read access and update has_read_access flag in zpb_account_states
598: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,

Line 615: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

611: else
612: x_has_read_acc := 0;
613: end if;
614:
615: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
616: 'Updating accounts_states table has_read_access col for User'||l_user_id);
617: update zpb_account_states
618: set has_read_access = x_has_read_acc
619: where user_id = l_user_id

Line 637: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

633: errbuf);
634: l_initialized := true;
635: end if;
636:
637: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
638: 'Updating writeback_tasks table with Status as FAILED for Task Seq: '||task );
639: --set the initial status to failed
640: update zpb_writeback_tasks set
641: status = FAILED, completion_date = SYSDATE,

Line 655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

651: v_task.exorder, v_task.token);
652: ZPB_AW.EXECUTE(v_task.token);
653: end if;
654:
655: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
656: 'Checking for Read access in accounts_states table for User'||l_user_id);
657:
658: --check this user for read access and update has_read_access flag in zpb_account_states
659: ZPB_SECURITY_UTIL_PVT.validate_user(l_user_id,

Line 676: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

672: else
673: x_has_read_acc := 0;
674: end if;
675:
676: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
677: 'Updating accounts_states table has_read_access col for User'||l_user_id);
678: update zpb_account_states
679: set has_read_access = x_has_read_acc
680: where user_id = l_user_id

Line 696: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

692: --update the tasks table
693: -- Added for Bug: 5475982
694: IF p_conc_request_id > 0 THEN
695:
696: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
697: 'Updating writeback_tasks table with Status as COMPLETED for SessionID: '||p_conc_request_id );
698:
699: UPDATE zpb_writeback_tasks
700: SET status = COMPLETED,

Line 709: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',

705: WHERE session_id = p_conc_request_id;
706:
707: ELSE
708:
709: zpb_log.write_statement ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks',
710: 'Updating writeback_tasks table with Status as COMPLETED for Task Seq: '||task );
711:
712: UPDATE zpb_writeback_tasks
713: SET status = COMPLETED,

Line 733: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','End program :');

729: -- then the retcode is set to '2'.
730:
731: -- RETCODE := '0';
732:
733: zpb_log.write ('ZPB_AW_WRITE_BACK.process_scoping_admin_tasks','End program :');
734:
735: EXCEPTION
736: when others then
737: ZPB_ERROR_HANDLER.HANDLE_EXCEPTION (G_PKG_NAME,

Line 801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');

797: into l_user_name
798: from FND_USER
799: where USER_ID = FND_GLOBAL.USER_ID;
800:
801: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Begin program :');
802:
803: INITIALIZE (l_user_name,
804: p_business_area,
805: l_retcode,

Line 808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');

804: p_business_area,
805: l_retcode,
806: errbuf);
807:
808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');
809:
810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');
811: for each in all_readaccess loop
812: l_query_path := each.query_path;

Line 810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');

806: errbuf);
807:
808: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Initialization done :');
809:
810: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Read Access');
811: for each in all_readaccess loop
812: l_query_path := each.query_path;
813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');
814: end loop;

Line 816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');

812: l_query_path := each.query_path;
813: ZPB_AW.EXECUTE('call sc.set.scope('''||l_query_path||''')');
814: end loop;
815:
816: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Write Access');
817: for each in all_writeaccess loop
818: l_query_path := each.query_path;
819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');
820: end loop;

Line 822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');

818: l_query_path := each.query_path;
819: ZPB_AW.EXECUTE('call sc.set.write.acc('''||l_query_path||''')');
820: end loop;
821:
822: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Process Ownership Access');
823: for each in all_ownership loop
824: l_query_path := each.query_path;
825: ZPB_AW.EXECUTE('call sc.set.ownership('''||l_query_path||''')');
826: end loop;

Line 830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');

826: end loop;
827:
828: DELETE FROM zpb_validation_temp_data WHERE business_area_id = p_business_area;
829:
830: zpb_log.write ('ZPB_AW_WRITE_BACK.reapply_all_scopes','Done');
831:
832: ZPB_AW.EXECUTE ('update');
833: commit;
834: