DBA Data[Home] [Help]

APPS.JAI_OE_OHA_ARIUD_T1 dependencies on JAI_CONSTANTS

Line 113: :old.flow_status_code <> jai_constants.order_booked

109:
110: --Pass values for further processing
111:
112: IF ( :old.flow_status_code IS NULL OR
113: :old.flow_status_code <> jai_constants.order_booked
114: ) AND
115: nvl(:new.flow_status_code,'###') = jai_constants.order_booked
116: THEN
117: IF l_debug_level > 0 THEN

Line 115: nvl(:new.flow_status_code,'###') = jai_constants.order_booked

111:
112: IF ( :old.flow_status_code IS NULL OR
113: :old.flow_status_code <> jai_constants.order_booked
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;

Line 122: p_event => jai_constants.order_booked ,

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 ,
123: p_process_flag => lv_process_flag ,
124: 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

Line 136: IF lv_process_flag = jai_constants.expected_error OR

132: END IF;
133:
134:
135:
136: IF lv_process_flag = jai_constants.expected_error OR
137: lv_process_flag = jai_constants.unexpected_error
138: THEN
139: raise le_error;
140: END IF;

Line 137: lv_process_flag = jai_constants.unexpected_error

133:
134:
135:
136: IF lv_process_flag = jai_constants.expected_error OR
137: lv_process_flag = jai_constants.unexpected_error
138: THEN
139: raise le_error;
140: END IF;
141:

Line 153: IF lv_process_flag = jai_constants.unexpected_error THEN

149: WHEN le_error THEN
150:
151: jai_cmn_utils_pkg.print_log('oeh.log','in the exception' ||
152: lv_process_message || lv_object || lv_action);
153: IF lv_process_flag = jai_constants.unexpected_error THEN
154: lv_process_message := substr (lv_process_message || ' Object=' || lv_object || ' Action=' || lv_action, 1,1999) ;
155: END IF;
156:
157: fnd_message.set_name ( application => 'JA',