DBA Data[Home] [Help]

APPS.ITG_IP_RELEASES_ALL_ARU dependencies on ITG_DEBUG

Line 28: ITG_Debug.setup(

24: l_syncind VARCHAR2(10) := NULL;
25: l_doc_num VARCHAR2(100);
26: l_clntyp VARCHAR2(30);
27: BEGIN
28: ITG_Debug.setup(
29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);

Line 32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);

28: ITG_Debug.setup(
29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);

Line 33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);

29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);

Line 34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);

30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:

Line 35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);

31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:

Line 36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);

32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:
40: p_id will always be po_header_id

Line 37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);

33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:
40: p_id will always be po_header_id
41: p_param1 will now be po_release_id (formerly, the case code of 1-6)

Line 81: ITG_Debug.msg('RA', 'l_action_cnt', l_action_cnt);

77: OPEN cur_po_action_history_cnt(:new.po_release_id);
78: FETCH cur_po_action_history_cnt INTO l_action_cnt;
79: CLOSE cur_po_action_history_cnt;
80:
81: ITG_Debug.msg('RA', 'l_action_cnt', l_action_cnt);
82:
83: IF ((l_action_cnt > 1 AND
84: UPPER(:new.authorization_status) = 'APPROVED') OR
85: UPPER(:new.authorization_status) = 'REQUIRES REAPPROVAL') THEN

Line 112: ITG_Debug.flush_to_logfile;

108: p_param4 => :new.authorization_status);
109: END IF;
110:
111: END IF;
112: ITG_Debug.flush_to_logfile;
113: END;