eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_RX_IR_PKG dependencies on FA_RX_UTIL_PKG

Line 191: fa_rx_util_pkg.log('* START JG_RX_IR_PKG.AP_RX_INVOICE_RUN *');

187: p_line_org_where VARCHAR2(2000);
188:
189: begin
190:
191: fa_rx_util_pkg.log('***** START JG_RX_IR_PKG.AP_RX_INVOICE_RUN *****');
192:
193: /* Print debug parameters */
194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);

Line 194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);

190:
191: fa_rx_util_pkg.log('***** START JG_RX_IR_PKG.AP_RX_INVOICE_RUN *****');
192:
193: /* Print debug parameters */
194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);

Line 195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);

191: fa_rx_util_pkg.log('***** START JG_RX_IR_PKG.AP_RX_INVOICE_RUN *****');
192:
193: /* Print debug parameters */
194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);

Line 196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);

192:
193: /* Print debug parameters */
194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);

Line 197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);

193: /* Print debug parameters */
194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);

Line 198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);

194: fa_rx_util_pkg.log('p_reporting_level :'||p_reporting_level);
195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);

Line 199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);

195: fa_rx_util_pkg.log('p_reporting_entity_id :'||p_reporting_entity_id);
196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);

Line 200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);

196: fa_rx_util_pkg.log('p_request_id :'||p_request_id);
197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);

Line 201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);

197: fa_rx_util_pkg.log('p_login_id :'||p_login_id);
198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);

Line 202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);

198: fa_rx_util_pkg.log('p_set_of_book_id :'||p_set_of_book_id);
199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);

Line 203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);

199: fa_rx_util_pkg.log('p_chart_of_acct_id :'||p_chart_of_acct_id);
200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);

Line 204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);

200: fa_rx_util_pkg.log('p_line_inv :'||p_line_inv);
201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);

Line 205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);

201: fa_rx_util_pkg.log('p_acct_date_min :'||p_acct_date_min);
202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);

Line 206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);

202: fa_rx_util_pkg.log('p_acct_date_max :'||p_acct_date_max);
203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);

Line 207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);

203: fa_rx_util_pkg.log('p_batch_id :'||p_batch_id);
204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);

Line 208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);

204: fa_rx_util_pkg.log('p_invoice_type :'||p_invoice_type);
205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);

Line 209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);

205: fa_rx_util_pkg.log('p_entry_person :'||p_entry_person_id);
206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);

Line 210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);

206: fa_rx_util_pkg.log('p_doc_sequence_name :'||p_doc_sequence_id);
207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);

Line 211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);

207: fa_rx_util_pkg.log('p_doc_sequence_value_min :'||p_doc_sequence_value_min);
208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);

Line 212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);

208: fa_rx_util_pkg.log('p_doc_sequence_value_max :'||p_doc_sequence_value_max);
209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);

Line 213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);

209: fa_rx_util_pkg.log('p_supplier_min :'||p_supplier_min);
210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);

Line 214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);

210: fa_rx_util_pkg.log('p_supplier_max :'||p_supplier_max);
211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);
218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);

Line 215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);

211: fa_rx_util_pkg.log('p_liability_min :'||p_liability_min);
212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);
218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);
219:

Line 216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);

212: fa_rx_util_pkg.log('p_liability_max :'||p_liability_max);
213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);
218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);
219:
220: /* Added for MOAC change */

Line 217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);

213: fa_rx_util_pkg.log('p_dist_acct_min :'||p_dist_acct_min);
214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);
218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);
219:
220: /* Added for MOAC change */
221: if p_reporting_level is null then

Line 218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);

214: fa_rx_util_pkg.log('p_dist_acct_max :'||p_dist_acct_max);
215: fa_rx_util_pkg.log('p_dist_amount_min :'||p_dist_amount_min);
216: fa_rx_util_pkg.log('p_dist_amount_max :'||p_dist_amount_max);
217: fa_rx_util_pkg.log('p_entered_date_min :'||p_entered_date_min);
218: fa_rx_util_pkg.log('p_entered_date_max :'||p_entered_date_max);
219:
220: /* Added for MOAC change */
221: if p_reporting_level is null then
222: h_reporting_level := '3000'; -- OU level

Line 252: fa_rx_util_pkg.debug('p_inv_org_where :'||p_inv_org_where);

248: p_dist_org_where := XLA_MO_REPORTING_API.GET_PREDICATE(p_alias => 'DIST');
249: --* AP_INVOICE_LINES_ALL (Alias = INV_LINE)
250: p_line_org_where := XLA_MO_REPORTING_API.GET_PREDICATE(p_alias => 'INV_LINE');
251:
252: fa_rx_util_pkg.debug('p_inv_org_where :'||p_inv_org_where);
253: fa_rx_util_pkg.debug('p_dist_org_where :'||p_dist_org_where);
254: fa_rx_util_pkg.debug('p_line_org_where :'||p_line_org_where);
255:
256: /*Get Functoinal currncy code */

Line 253: fa_rx_util_pkg.debug('p_dist_org_where :'||p_dist_org_where);

249: --* AP_INVOICE_LINES_ALL (Alias = INV_LINE)
250: p_line_org_where := XLA_MO_REPORTING_API.GET_PREDICATE(p_alias => 'INV_LINE');
251:
252: fa_rx_util_pkg.debug('p_inv_org_where :'||p_inv_org_where);
253: fa_rx_util_pkg.debug('p_dist_org_where :'||p_dist_org_where);
254: fa_rx_util_pkg.debug('p_line_org_where :'||p_line_org_where);
255:
256: /*Get Functoinal currncy code */
257: Select currency_code,

Line 254: fa_rx_util_pkg.debug('p_line_org_where :'||p_line_org_where);

250: p_line_org_where := XLA_MO_REPORTING_API.GET_PREDICATE(p_alias => 'INV_LINE');
251:
252: fa_rx_util_pkg.debug('p_inv_org_where :'||p_inv_org_where);
253: fa_rx_util_pkg.debug('p_dist_org_where :'||p_dist_org_where);
254: fa_rx_util_pkg.debug('p_line_org_where :'||p_line_org_where);
255:
256: /*Get Functoinal currncy code */
257: Select currency_code,
258: short_name,

Line 266: fa_rx_util_pkg.debug('h_currency_code :'||h_currency_code);

262: h_mrc_sob_type_code
263: From GL_LEDGERS
264: where ledger_id = p_set_of_book_id;
265:
266: fa_rx_util_pkg.debug('h_currency_code :'||h_currency_code);
267: fa_rx_util_pkg.debug('h_book_short_name :'||h_book_short_name);
268: fa_rx_util_pkg.debug('h_mrc_sob_type_code :'||h_mrc_sob_type_code);
269:
270: /* Switch User Context */

Line 267: fa_rx_util_pkg.debug('h_book_short_name :'||h_book_short_name);

263: From GL_LEDGERS
264: where ledger_id = p_set_of_book_id;
265:
266: fa_rx_util_pkg.debug('h_currency_code :'||h_currency_code);
267: fa_rx_util_pkg.debug('h_book_short_name :'||h_book_short_name);
268: fa_rx_util_pkg.debug('h_mrc_sob_type_code :'||h_mrc_sob_type_code);
269:
270: /* Switch User Context */
271: if h_mrc_sob_type_code = 'R' then

Line 268: fa_rx_util_pkg.debug('h_mrc_sob_type_code :'||h_mrc_sob_type_code);

264: where ledger_id = p_set_of_book_id;
265:
266: fa_rx_util_pkg.debug('h_currency_code :'||h_currency_code);
267: fa_rx_util_pkg.debug('h_book_short_name :'||h_book_short_name);
268: fa_rx_util_pkg.debug('h_mrc_sob_type_code :'||h_mrc_sob_type_code);
269:
270: /* Switch User Context */
271: if h_mrc_sob_type_code = 'R' then
272: fnd_client_info.set_currency_context(p_set_of_book_id);

Line 293: fa_rx_util_pkg.debug('h_sort_by_alternate :'||h_sort_by_alternate);

289: exception when others then
290: h_sort_by_alternate := 'N';
291: end;
292:
293: fa_rx_util_pkg.debug('h_sort_by_alternate :'||h_sort_by_alternate);
294:
295: /* ==================================================
296: Create sql statement:
297: From parameters, create sql statment

Line 313: fa_rx_util_pkg.debug('l_acct_date_where :'||l_acct_date_where);

309: l_acct_date_where :=
310: ' and DIST.ACCOUNTING_DATE between :c_acct_date_min and :c_acct_date_max ';
311: end if;
312:
313: fa_rx_util_pkg.debug('l_acct_date_where :'||l_acct_date_where);
314:
315: /* Entered by */
316: if p_entry_person_id is null then
317: l_entry_person_where := to_char(null);

Line 322: fa_rx_util_pkg.debug('l_entry_person_where :'||l_entry_person_where);

318: else
319: l_entry_person_where := 'and AP_INV.CREATED_BY = :c_entry_person_id '; -- ||p_entry_person_id;
320: end if;
321:
322: fa_rx_util_pkg.debug('l_entry_person_where :'||l_entry_person_where);
323:
324: /*Invoice Type */
325: if p_invoice_type is null then
326: l_inv_type_where := to_char(null);

Line 333: fa_rx_util_pkg.debug('l_inv_type_where :'||l_inv_type_where);

329: ' and AP_INV.INVOICE_TYPE_LOOKUP_CODE= :c_invoice_type '; -- '''||p_invoice_type||'''
330:
331: end if;
332:
333: fa_rx_util_pkg.debug('l_inv_type_where :'||l_inv_type_where);
334:
335: /* Batch ID */
336: if p_batch_id is null then
337: l_batch_id_where := to_char(null);

Line 343: fa_rx_util_pkg.debug('l_batch_id_where :'||l_batch_id_where);

339: l_batch_id_where := ' and AP_INV.BATCH_ID = :c_batch_id '; -- '''||p_batch_id||'''
340:
341: end if;
342:
343: fa_rx_util_pkg.debug('l_batch_id_where :'||l_batch_id_where);
344:
345: /* Document Sequence Id */
346: if p_doc_sequence_id is null then
347: l_doc_seq_id_where := to_char(null);

Line 352: fa_rx_util_pkg.debug('l_doc_seq_id_where :'||l_doc_seq_id_where);

348: else
349: l_doc_seq_id_where := ' and AP_INV.DOC_SEQUENCE_ID= :c_doc_sequence_id '; --||p_doc_sequence_id;
350: end if;
351:
352: fa_rx_util_pkg.debug('l_doc_seq_id_where :'||l_doc_seq_id_where);
353:
354: /* Document Sequence value range */
355: if p_doc_sequence_value_min is null and p_doc_sequence_value_max is null then
356: l_doc_seq_value_where := to_char(null);

Line 369: fa_rx_util_pkg.debug('l_doc_seq_value_where :'||l_doc_seq_value_where);

365: ' and AP_INV.DOC_SEQUENCE_VALUE between :c_doc_sequence_value_min and :c_doc_sequence_value_max ';
366: -- || p_doc_sequence_value_min||' and '||p_doc_sequence_value_max;
367: end if;
368:
369: fa_rx_util_pkg.debug('l_doc_seq_value_where :'||l_doc_seq_value_where);
370:
371: /* Supplier name range */
372: if p_supplier_min is null and p_supplier_max is null then
373: l_supplier_where := to_char(null);

Line 384: fa_rx_util_pkg.debug('l_supplier_where :'||l_supplier_where);

380: ' and PO_PV.VENDOR_NAME between :c_supplier_min and :c_supplier_max ';
381: -- '''||p_supplier_min||''' and '''||p_supplier_max||''' ';
382: end if;
383:
384: fa_rx_util_pkg.debug('l_supplier_where :'||l_supplier_where);
385:
386: /* Liability account range */
387: if p_liability_min is null or p_liability_max is null then
388: l_liability_range_where := to_char(null);

Line 396: fa_rx_util_pkg.debug('l_liability_range_where :'||l_liability_range_where);

392: 'GC2','SELECT', 'ALL') || ' BETWEEN :c_liability_min and :c_liability_max ';
393: -- ,'BETWEEN',p_liability_min,p_liability_max);
394: end if;
395:
396: fa_rx_util_pkg.debug('l_liability_range_where :'||l_liability_range_where);
397:
398: /* Distribution account range */
399:
400: if p_dist_acct_min is null or p_dist_acct_max is null then

Line 408: fa_rx_util_pkg.debug('l_dist_acct_range_where :'||l_dist_acct_range_where);

404: fa_rx_flex_pkg.flex_sql(101,'GL#', p_chart_of_acct_id,
405: 'GC1','SELECT', 'ALL') ||' BETWEEN :c_dist_acct_min and :c_dist_acct_max ';
406: end if;
407:
408: fa_rx_util_pkg.debug('l_dist_acct_range_where :'||l_dist_acct_range_where);
409:
410: /* Invoice Currency Code */
411: if p_inv_currency_code is null then
412: l_inv_currency_code_where := to_char(null);

Line 418: fa_rx_util_pkg.debug('l_inv_currency_code_where :'||l_inv_currency_code_where);

414: l_inv_currency_code_where :=
415: ' and AP_INV.INVOICE_CURRENCY_CODE = :c_inv_currency_code '; -- '''||p_inv_currency_code||''
416: end if;
417:
418: fa_rx_util_pkg.debug('l_inv_currency_code_where :'||l_inv_currency_code_where);
419:
420: /* Distribution mount range */
421: if p_dist_amount_min is null and p_dist_amount_max is null then
422: l_dist_amount_range_where := to_char(null);

Line 435: fa_rx_util_pkg.debug('l_dist_amount_range_where :'||l_dist_amount_range_where);

431: ' and DIST.AMOUNT between :c_dist_amount_min and :c_dist_amount_max ';
432: -- '||p_dist_amount_min||' and '||p_dist_amount_max;
433: end if;
434:
435: fa_rx_util_pkg.debug('l_dist_amount_range_where :'||l_dist_amount_range_where);
436:
437: /* Entered date range */
438: if p_entered_date_min is null and p_entered_date_max is null then
439: l_entered_date_where := to_char(null);

Line 448: fa_rx_util_pkg.debug('l_entered_date_where :'||l_entered_date_where);

444: elsif p_entered_date_min is not null and p_entered_date_max is not null then
445: l_entered_date_where := ' and trunc(AP_INV.CREATION_DATE) between :c_entered_date_min and :c_entered_date_max ';
446: end if;
447:
448: fa_rx_util_pkg.debug('l_entered_date_where :'||l_entered_date_where);
449:
450: /* Cancelled Invoice only */
451: if p_cancelled_inv = true then
452: l_cancelled_where := ' and AP_INV.CANCELLED_DATE is not null ';

Line 457: fa_rx_util_pkg.debug('l_cancelled_where :'||l_cancelled_where);

453: else
454: l_cancelled_where := to_char(null);
455: end if;
456:
457: fa_rx_util_pkg.debug('l_cancelled_where :'||l_cancelled_where);
458:
459: /* Unapproved Invoice only */
460: if p_unapproved_inv = true then
461: l_unapproved_inv_where :=

Line 467: fa_rx_util_pkg.debug('l_unapproved_inv_where :'||l_unapproved_inv_where);

463: else
464: l_unapproved_inv_where :=to_char(null);
465: end if;
466:
467: fa_rx_util_pkg.debug('l_unapproved_inv_where :'||l_unapproved_inv_where);
468:
469: /* Parameter 'Line or INVOICE', WHERE PHASE */
470:
471: if p_line_inv ='I' then /* 'Line or INVOICE' = Invoice */

Line 517: fa_rx_util_pkg.debug('l_line_inv_where :'||l_line_inv_where);

513: l_line_inv_where := l_dist_acct_range_where || l_dist_amount_range_where
514: ||l_acct_date_where||l_unapproved_inv_where;
515: end if;
516:
517: fa_rx_util_pkg.debug('l_line_inv_where :'||l_line_inv_where);
518:
519: if h_mrc_sob_type_code = 'R' then
520: l_main_from := 'AP_INVOICES_MRC_V AP_INV,
521: AP_INVOICE_LINES_MRC_V INV_LINE, -- Added for AP Invoice Line Project

Line 581: fa_rx_util_pkg.debug('Main SQL:');

577: decode(:c_sort_by_alternate, ''Y'', upper(po_pv.vendor_name_alt), upper(po_pv.vendor_name)),
578: ap_inv.invoice_num,
579: dist.distribution_line_number';
580:
581: fa_rx_util_pkg.debug('Main SQL:');
582: fa_rx_util_pkg.debug(l_main_sql);
583:
584: /* Open v_MainCursor */
585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;

Line 582: fa_rx_util_pkg.debug(l_main_sql);

578: ap_inv.invoice_num,
579: dist.distribution_line_number';
580:
581: fa_rx_util_pkg.debug('Main SQL:');
582: fa_rx_util_pkg.debug(l_main_sql);
583:
584: /* Open v_MainCursor */
585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;
586: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');

Line 586: fa_rx_util_pkg.debug('* OPEN CURSOR: v_MainCursor *');

582: fa_rx_util_pkg.debug(l_main_sql);
583:
584: /* Open v_MainCursor */
585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;
586: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
588:
589: /* PARSE v_MainCursor */
590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);

Line 587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);

583:
584: /* Open v_MainCursor */
585: v_MainCursor :=DBMS_SQL.OPEN_CURSOR;
586: fa_rx_util_pkg.debug('***** OPEN CURSOR: v_MainCursor *****');
587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
588:
589: /* PARSE v_MainCursor */
590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
591: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');

Line 591: fa_rx_util_pkg.debug('* PARSE: v_MainCursor *');

587: fa_rx_util_pkg.debug('v_MainCursor :'||v_MainCursor);
588:
589: /* PARSE v_MainCursor */
590: DBMS_SQL.PARSE (v_MainCursor,l_main_sql,DBMS_SQL.V7);
591: fa_rx_util_pkg.debug('***** PARSE: v_MainCursor *****');
592:
593: /* DEFINE COLUMN v_MainCursor */
594: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,1,h_invoice_id);
595: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,2,h_liability_ccid);

Line 605: fa_rx_util_pkg.debug('* DEFINE COLUMN: v_MainCursor *');

601: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,8,h_dist_acct_date); -- Newly Added
602: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,9,h_line_number); -- Newly Added
603: DBMS_SQL.DEFINE_COLUMN(v_MainCursor,10,h_line_type,25); -- Newly Added
604:
605: fa_rx_util_pkg.debug('***** DEFINE COLUMN: v_MainCursor *****');
606:
607: /* BIND BARIABLE v_MainCursor */
608: if p_acct_date_min is not null then
609: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':c_acct_date_min',p_acct_date_min);

Line 702: fa_rx_util_pkg.debug('h_reporting_entity_id :'||h_reporting_entity_id);

698:
699: /* MOAC Change - bind p_reporting_entity_id */
700: if p_reporting_level = '3000' then
701: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_reporting_entity_id', h_reporting_entity_id);
702: fa_rx_util_pkg.debug('h_reporting_entity_id :'||h_reporting_entity_id);
703: end if;
704:
705: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');
706:

Line 705: fa_rx_util_pkg.debug('* BIND VARIABLE: v_MainCursor *');

701: DBMS_SQL.BIND_VARIABLE(v_MainCursor,':p_reporting_entity_id', h_reporting_entity_id);
702: fa_rx_util_pkg.debug('h_reporting_entity_id :'||h_reporting_entity_id);
703: end if;
704:
705: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');
706:
707:
708: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
709: fa_rx_util_pkg.debug('***** EXECUTE: v_MainCursor *****');

Line 709: fa_rx_util_pkg.debug('* EXECUTE: v_MainCursor *');

705: fa_rx_util_pkg.debug('***** BIND VARIABLE: v_MainCursor *****');
706:
707:
708: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
709: fa_rx_util_pkg.debug('***** EXECUTE: v_MainCursor *****');
710: fa_rx_util_pkg.debug('v_MainReturn :'||v_MainReturn);
711:
712: /* Loop and Fetch v_MainCursor */
713: Loop

Line 710: fa_rx_util_pkg.debug('v_MainReturn :'||v_MainReturn);

706:
707:
708: v_MainReturn := DBMS_SQL.EXECUTE(v_MainCursor);
709: fa_rx_util_pkg.debug('***** EXECUTE: v_MainCursor *****');
710: fa_rx_util_pkg.debug('v_MainReturn :'||v_MainReturn);
711:
712: /* Loop and Fetch v_MainCursor */
713: Loop
714:

Line 716: fa_rx_util_pkg.debug('* FETCH ROWS: v_MainCursor *');

712: /* Loop and Fetch v_MainCursor */
713: Loop
714:
715: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);
716: fa_rx_util_pkg.debug('***** FETCH ROWS: v_MainCursor *****');
717: fa_rx_util_pkg.debug('v_MainFetch :'||v_MainFetch);
718:
719: If v_MainFetch =0 then
720: Exit;

Line 717: fa_rx_util_pkg.debug('v_MainFetch :'||v_MainFetch);

713: Loop
714:
715: v_MainFetch := DBMS_SQL.FETCH_ROWS(v_MainCursor);
716: fa_rx_util_pkg.debug('***** FETCH ROWS: v_MainCursor *****');
717: fa_rx_util_pkg.debug('v_MainFetch :'||v_MainFetch);
718:
719: If v_MainFetch =0 then
720: Exit;
721: end if;

Line 734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);

730: DBMS_SQL.COLUMN_VALUE(v_MainCursor,8,h_dist_acct_date); -- Newly Added
731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER

Line 735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);

731: DBMS_SQL.COLUMN_VALUE(v_MainCursor,9,h_line_number); -- Newly Added
732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type

Line 736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);

732: DBMS_SQL.COLUMN_VALUE(v_MainCursor,10,h_line_type); -- Newly Added
733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);

Line 737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);

733:
734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added

Line 738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER

734: fa_rx_util_pkg.debug('h_invoice_id: '||h_invoice_id);
735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added

Line 739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type

735: fa_rx_util_pkg.debug('h_liability_ccid: '||h_liability_ccid);
736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added
743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added

Line 740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);

736: fa_rx_util_pkg.debug('h_invoice_type: '||h_invoice_type);
737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added
743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added
744:

Line 741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added

737: fa_rx_util_pkg.debug('h_inv_dist_id :'||h_inv_dist_id);
738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added
743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added
744:
745: /* Get Liability account and description, natural account and description */

Line 742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added

738: fa_rx_util_pkg.debug('h_dist_number :'||h_dist_number); -- Changed to DIST NUMBER
739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added
743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added
744:
745: /* Get Liability account and description, natural account and description */
746:

Line 743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added

739: fa_rx_util_pkg.debug('h_dist_type :'||h_dist_type); -- Changed to DIST Type
740: fa_rx_util_pkg.debug('h_dist_ccid :'||h_inv_dist_id);
741: fa_rx_util_pkg.debug('h_line_number :'||h_line_number); -- Newly Added
742: fa_rx_util_pkg.debug('h_line_type :'||h_line_type); -- Newly Added
743: fa_rx_util_pkg.debug('h_dist_acct_date :'|| h_dist_acct_date); -- Newly Added
744:
745: /* Get Liability account and description, natural account and description */
746:
747: if h_liability_ccid is not null then

Line 784: fa_rx_util_pkg.debug('h_liability_acct : '||h_liability_acct);

780: h_liability_natacct := to_char(null);
781: h_liability_natdesc := to_char(null);
782: end if;
783:
784: fa_rx_util_pkg.debug('h_liability_acct : '||h_liability_acct);
785: fa_rx_util_pkg.debug('h_liability_desc : '||h_liability_desc);
786: fa_rx_util_pkg.debug('h_liability_natacct : '||h_liability_natacct);
787: fa_rx_util_pkg.debug('h_liability_natdesc : '||h_liability_natdesc);
788:

Line 785: fa_rx_util_pkg.debug('h_liability_desc : '||h_liability_desc);

781: h_liability_natdesc := to_char(null);
782: end if;
783:
784: fa_rx_util_pkg.debug('h_liability_acct : '||h_liability_acct);
785: fa_rx_util_pkg.debug('h_liability_desc : '||h_liability_desc);
786: fa_rx_util_pkg.debug('h_liability_natacct : '||h_liability_natacct);
787: fa_rx_util_pkg.debug('h_liability_natdesc : '||h_liability_natdesc);
788:
789: /*Get Distribution account and description, natural account and description */

Line 786: fa_rx_util_pkg.debug('h_liability_natacct : '||h_liability_natacct);

782: end if;
783:
784: fa_rx_util_pkg.debug('h_liability_acct : '||h_liability_acct);
785: fa_rx_util_pkg.debug('h_liability_desc : '||h_liability_desc);
786: fa_rx_util_pkg.debug('h_liability_natacct : '||h_liability_natacct);
787: fa_rx_util_pkg.debug('h_liability_natdesc : '||h_liability_natdesc);
788:
789: /*Get Distribution account and description, natural account and description */
790:

Line 787: fa_rx_util_pkg.debug('h_liability_natdesc : '||h_liability_natdesc);

783:
784: fa_rx_util_pkg.debug('h_liability_acct : '||h_liability_acct);
785: fa_rx_util_pkg.debug('h_liability_desc : '||h_liability_desc);
786: fa_rx_util_pkg.debug('h_liability_natacct : '||h_liability_natacct);
787: fa_rx_util_pkg.debug('h_liability_natdesc : '||h_liability_natdesc);
788:
789: /*Get Distribution account and description, natural account and description */
790:
791: if h_dist_ccid is not null then

Line 828: fa_rx_util_pkg.debug('h_dist_acct : '||h_dist_acct);

824: h_dist_natacct := to_char(null);
825: h_dist_natdesc := to_char(null);
826: end if;
827:
828: fa_rx_util_pkg.debug('h_dist_acct : '||h_dist_acct);
829: fa_rx_util_pkg.debug('h_dist_desc : '||h_dist_desc);
830: fa_rx_util_pkg.debug('h_dist_natacct : '||h_dist_natacct);
831: fa_rx_util_pkg.debug('h_dist_natdesc : '||h_dist_natdesc);
832:

Line 829: fa_rx_util_pkg.debug('h_dist_desc : '||h_dist_desc);

825: h_dist_natdesc := to_char(null);
826: end if;
827:
828: fa_rx_util_pkg.debug('h_dist_acct : '||h_dist_acct);
829: fa_rx_util_pkg.debug('h_dist_desc : '||h_dist_desc);
830: fa_rx_util_pkg.debug('h_dist_natacct : '||h_dist_natacct);
831: fa_rx_util_pkg.debug('h_dist_natdesc : '||h_dist_natdesc);
832:
833:

Line 830: fa_rx_util_pkg.debug('h_dist_natacct : '||h_dist_natacct);

826: end if;
827:
828: fa_rx_util_pkg.debug('h_dist_acct : '||h_dist_acct);
829: fa_rx_util_pkg.debug('h_dist_desc : '||h_dist_desc);
830: fa_rx_util_pkg.debug('h_dist_natacct : '||h_dist_natacct);
831: fa_rx_util_pkg.debug('h_dist_natdesc : '||h_dist_natdesc);
832:
833:
834: /* Insert to JG_ZZ_AP_IR_REP_ITF */

Line 831: fa_rx_util_pkg.debug('h_dist_natdesc : '||h_dist_natdesc);

827:
828: fa_rx_util_pkg.debug('h_dist_acct : '||h_dist_acct);
829: fa_rx_util_pkg.debug('h_dist_desc : '||h_dist_desc);
830: fa_rx_util_pkg.debug('h_dist_natacct : '||h_dist_natacct);
831: fa_rx_util_pkg.debug('h_dist_natdesc : '||h_dist_natdesc);
832:
833:
834: /* Insert to JG_ZZ_AP_IR_REP_ITF */
835: Insert into JG_ZZ_AP_IR_REP_ITF (

Line 892: fa_rx_util_pkg.debug('Inserted invoice_id: '||h_invoice_id||' inv_dist_id : '||h_inv_dist_id);

888: h_dist_natacct,
889: h_dist_natdesc
890: );
891:
892: fa_rx_util_pkg.debug('Inserted invoice_id: '||h_invoice_id||' inv_dist_id : '||h_inv_dist_id);
893:
894: End Loop;
895:
896: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);

Line 898: fa_rx_util_pkg.debug('* Close Cursor v_MainCursor *');

894: End Loop;
895:
896: DBMS_SQL.CLOSE_CURSOR(v_MainCursor);
897:
898: fa_rx_util_pkg.debug('***** Close Cursor v_MainCursor *****');
899:
900: commit;
901:
902: Exception