DBA Data[Home] [Help]

APPS.ITG_IP_HEADERS_ALL_ARU dependencies on ITG_DEBUG

Line 33: ITG_Debug.setup(

29: l_syncind VARCHAR2(10);
30: l_clntyp VARCHAR2(30);
31:
32: BEGIN
33: ITG_Debug.setup(
34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_headers_all_ARU');
37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);

Line 37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);

33: ITG_Debug.setup(
34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_headers_all_ARU');
37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);

Line 38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);

34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_headers_all_ARU');
37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);

Line 39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);

35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_headers_all_ARU');
37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);

Line 40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);

36: p_proc_name => 'itg_ip_headers_all_ARU');
37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);

Line 41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);

37: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);

Line 42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);

38: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
46:

Line 43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);

39: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
46:
47: /* Modified all CANCEL PO wf event parms:

Line 44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);

40: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
46:
47: /* Modified all CANCEL PO wf event parms:
48: p_id will always be po_header_id

Line 45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);

41: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
42: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
43: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
44: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
45: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
46:
47: /* Modified all CANCEL PO wf event parms:
48: p_id will always be po_header_id
49: p_param1 will now be po_release_id (formerly, the case code of 1-6)

Line 104: ITG_Debug.msg('HA-1', 'l_action_code', l_action_code);

100: OPEN cur_po_action_history_cnt(:new.po_header_id);
101: FETCH cur_po_action_history_cnt INTO l_action_cnt;
102: CLOSE cur_po_action_history_cnt;
103:
104: ITG_Debug.msg('HA-1', 'l_action_code', l_action_code);
105: ITG_Debug.msg('HA-1', 'l_action_cnt', l_action_cnt);
106:
107: IF l_action_code = 'RELEASE HOLD' OR l_action_cnt > 1 THEN
108: l_syncind := 'C';

Line 105: ITG_Debug.msg('HA-1', 'l_action_cnt', l_action_cnt);

101: FETCH cur_po_action_history_cnt INTO l_action_cnt;
102: CLOSE cur_po_action_history_cnt;
103:
104: ITG_Debug.msg('HA-1', 'l_action_code', l_action_code);
105: ITG_Debug.msg('HA-1', 'l_action_cnt', l_action_cnt);
106:
107: IF l_action_code = 'RELEASE HOLD' OR l_action_cnt > 1 THEN
108: l_syncind := 'C';
109: l_clntyp := 'ITG_SYNC_PO_CHANGE';

Line 132: ITG_Debug.msg('HA-2', 'l_action_code', l_action_code);

128: OPEN cur_po_action_history(:new.po_header_id);
129: FETCH cur_po_action_history INTO l_action_code;
130: CLOSE cur_po_action_history;
131:
132: ITG_Debug.msg('HA-2', 'l_action_code', l_action_code);
133:
134: IF l_action_code <> 'HOLD' THEN
135: itg_outbound_utils.raise_wf_event(
136: p_bsr => 'SYNC_PO',

Line 165: ITG_Debug.flush_to_logfile;

161:
162: END IF;
163:
164: END IF;
165: ITG_Debug.flush_to_logfile;
166: END;