36: l_clntyp VARCHAR2(30);
37: l_docnum VARCHAR2(100);
38:
39: BEGIN
40: ITG_Debug.setup(
41: p_reset => TRUE,
42: p_pkg_name => 'TRIGGER',
43: p_proc_name => 'itg_ip_rcv_transactions_ARI');
44: ITG_Debug.msg('RT', 'new.po_header_id', :new.po_header_id);
40: ITG_Debug.setup(
41: p_reset => TRUE,
42: p_pkg_name => 'TRIGGER',
43: p_proc_name => 'itg_ip_rcv_transactions_ARI');
44: ITG_Debug.msg('RT', 'new.po_header_id', :new.po_header_id);
45: ITG_Debug.msg('RT', 'new.transaction_type', :new.transaction_type);
46:
47: -- get the org id
48: OPEN getOrgId(:new.po_header_id);
41: p_reset => TRUE,
42: p_pkg_name => 'TRIGGER',
43: p_proc_name => 'itg_ip_rcv_transactions_ARI');
44: ITG_Debug.msg('RT', 'new.po_header_id', :new.po_header_id);
45: ITG_Debug.msg('RT', 'new.transaction_type', :new.transaction_type);
46:
47: -- get the org id
48: OPEN getOrgId(:new.po_header_id);
49: FETCH getOrgId INTO l_orgid;
73: p_doc => l_docnum,
74: p_param1 => to_char(requestId),
75: p_param2 => to_char(:new.transaction_id));
76:
77: ITG_Debug.flush_to_logfile;
78: END;