DBA Data[Home] [Help]

APPS.ITG_IP_HEADERS_ALL_ARU dependencies on ITG_DEBUG

Line 32: ITG_Debug.setup(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 164: ITG_Debug.flush_to_logfile;

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