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