DBA Data[Home] [Help]

APPS.ITG_IP_REQUISITION_HEADERS_ARU dependencies on ITG_DEBUG

Line 33: ITG_Debug.setup(

29:
30: v_action_code po_action_history.action_code%TYPE;
31: v_action_cnt NUMBER;
32: BEGIN
33: ITG_Debug.setup(
34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:

Line 38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);

34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>

Line 39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);

35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>
43: upper(nvl(:new.authorization_status,'z')) THEN

Line 40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);

36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>
43: upper(nvl(:new.authorization_status,'z')) THEN
44: IF upper(:new.authorization_status) = 'APPROVED' THEN

Line 53: ITG_Debug.msg('RH', 'v_action_code', v_action_code);

49: OPEN cur_req_action_history_cnt(:new.requisition_header_id);
50: FETCH cur_req_action_history_cnt into v_action_cnt;
51: CLOSE cur_req_action_history_cnt;
52:
53: ITG_Debug.msg('RH', 'v_action_code', v_action_code);
54: ITG_Debug.msg('RH', 'v_action_cnt', v_action_cnt);
55:
56: IF v_action_code = 'WITHDRAW' AND v_action_cnt > 1 THEN
57: itg_outbound_utils.raise_wf_event (

Line 54: ITG_Debug.msg('RH', 'v_action_cnt', v_action_cnt);

50: FETCH cur_req_action_history_cnt into v_action_cnt;
51: CLOSE cur_req_action_history_cnt;
52:
53: ITG_Debug.msg('RH', 'v_action_code', v_action_code);
54: ITG_Debug.msg('RH', 'v_action_cnt', v_action_cnt);
55:
56: IF v_action_code = 'WITHDRAW' AND v_action_cnt > 1 THEN
57: itg_outbound_utils.raise_wf_event (
58: p_bsr => 'CHANGE_REQUISITN',

Line 84: ITG_Debug.flush_to_logfile;

80: p_doc => :new.segment1,
81: p_param1 => '1');
82: END IF;
83: END IF;
84: ITG_Debug.flush_to_logfile;
85: END;