APPS.JAI_OE_OHA_ARIUD_T1 dependencies on OE_DEBUG_PUB

Line 7: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3: ON "APPS"."OE_ORDER_HEADERS_ALL" for each row
4: DECLARE
5:
6: v_operating_id NUMBER :=:NEW.ORG_ID;
7: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8: v_gl_set_of_bks_id gl_sets_of_books.set_of_books_id%type;
9: r_new OE_ORDER_HEADERS_ALL%ROWTYPE ;
10: r_old OE_ORDER_HEADERS_ALL%ROWTYPE ;
11: le_error EXCEPTION ;

Line 61: oe_debug_pub.add( 'Entered Trigger JAI_OE_ARIUD_T1') ;

57:
58: BEGIN
59: -- Main body Start.
60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'Entered Trigger JAI_OE_ARIUD_T1') ;
62: END IF;
63:
64:
65: --Get id for set of books in a local variable v_gl_set_of_bks_id.

Line 79: oe_debug_pub.add( 'After jai_cmn_utils_pkg.check_jai_exists') ;

75: RETURN;
76:
77: END IF;
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add( 'After jai_cmn_utils_pkg.check_jai_exists') ;
80: END IF;
81:
82:
83: lv_object := 'JAI_OE_ARIUD_T1' ;

Line 93: oe_debug_pub.add( 'After checking for Update or Insert') ;

89: init_new;
90: end if;
91:
92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add( 'After checking for Update or Insert') ;
94: END IF;
95:
96:
97: lv_action := 'INIT_OLD';

Line 105: oe_debug_pub.add( 'After Checking for Update or Delete') ;

101: end if;
102:
103:
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'After Checking for Update or Delete') ;
106: END IF;
107:
108:
109:

Line 118: oe_debug_pub.add( 'Before Passing Values to jai_ar_tcs_rep_pkg.process_transactions') ;

114: ) AND
115: nvl(:new.flow_status_code,'###') = jai_constants.order_booked
116: THEN
117: IF l_debug_level > 0 THEN
118: oe_debug_pub.add( 'Before Passing Values to jai_ar_tcs_rep_pkg.process_transactions') ;
119: END IF;
120: jai_cmn_utils_pkg.print_log('oeh.log','before call to the tcs_rep_package');
121: jai_ar_tcs_rep_pkg.process_transactions ( p_ooh => r_new ,
122: p_event => jai_constants.order_booked ,

Line 129: oe_debug_pub.add( 'After jai_ar_tcs_rep_pkg.process_transactions'||'p_process_flag'|| lv_process_flag ||'p_process_message'|| lv_process_message) ;

125: );
126: jai_cmn_utils_pkg.print_log('oeh.log','after call to the tcs_rep pkg error is
127: ' || lv_process_message || lv_process_flag);
128: IF l_debug_level > 0 THEN
129: oe_debug_pub.add( 'After jai_ar_tcs_rep_pkg.process_transactions'||'p_process_flag'|| lv_process_flag ||'p_process_message'|| lv_process_message) ;
130: END IF;
131: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Passed values to jai_ar_tcs_rep_pkg.process_transactions ') ;
132: END IF;
133:

Line 131: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Passed values to jai_ar_tcs_rep_pkg.process_transactions ') ;

127: ' || lv_process_message || lv_process_flag);
128: IF l_debug_level > 0 THEN
129: oe_debug_pub.add( 'After jai_ar_tcs_rep_pkg.process_transactions'||'p_process_flag'|| lv_process_flag ||'p_process_message'|| lv_process_message) ;
130: END IF;
131: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Passed values to jai_ar_tcs_rep_pkg.process_transactions ') ;
132: END IF;
133:
134:
135:

Line 144: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Reached end of trigger ') ;

140: END IF;
141:
142: END IF;
143:
144: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Reached end of trigger ') ;
145: END IF;
146:
147:
148: EXCEPTION

Line 169: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Added the message to the ont stack ') ;

165: ||add the message to the ont stack also
166: */
167: oe_msg_pub.add;
168: RAISE fnd_api.g_exc_error;
169: IF l_debug_level > 0 THEN oe_debug_pub.add( 'Added the message to the ont stack ') ;
170: END IF;
171: WHEN others THEN
172: jai_cmn_utils_pkg.print_log('oeh.log','in the exception' ||
173: lv_process_message || lv_object || lv_action);