DBA Data[Home] [Help]

APPS.ITG_IP_REQUISITION_HEADERS_ARU dependencies on ITG_DEBUG

Line 34: ITG_Debug.setup(

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

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

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

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

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

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

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

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

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

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

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

Line 85: ITG_Debug.flush_to_logfile;

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