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.JAI_CMN_OM_AR_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 157: (cpv_source = jai_constants.source_wsh

153: AND jspl.order_line_id = jsptl.order_line_id)
154: ) AND
155: jsptl.tax_id = jtc.tax_id AND
156: jtc.tax_type = jrttv.tax_type AND
157: (cpv_source = jai_constants.source_wsh
158: OR cpv_source = jai_constants.source_nsh) AND
159: NOT EXISTS ( SELECT
160: 1
161: FROM

Line 158: OR cpv_source = jai_constants.source_nsh) AND

154: ) AND
155: jsptl.tax_id = jtc.tax_id AND
156: jtc.tax_type = jrttv.tax_type AND
157: (cpv_source = jai_constants.source_wsh
158: OR cpv_source = jai_constants.source_nsh) AND
159: NOT EXISTS ( SELECT
160: 1
161: FROM
162: jai_rgm_trx_records jrtr

Line 192: IF upper(pv_source) = upper(jai_constants.source_ar) THEN

188: r_repo_dtl cur_repository_dtl%ROWTYPE;
189:
190: BEGIN
191:
192: IF upper(pv_source) = upper(jai_constants.source_ar) THEN
193:
194: lv_regime_code := JAI_GST_GENERAL_PKG.get_regime_code(pn_regime_id);
195:
196: IF lv_regime_code in ('CGST', 'SGST') THEN

Line 210: pv_source_trx_type => nvl(pv_source_trx_type, jai_constants.source_ttype_man_ar_inv),

206: pv_organization_type => pv_organization_type,
207: pn_organization_id => pn_organization_id,
208: pn_location_id => pn_location_id,
209: pv_source => pv_source,
210: pv_source_trx_type => nvl(pv_source_trx_type, jai_constants.source_ttype_man_ar_inv),
211: pv_source_table_name => nvl(pv_source_table_name, jai_constants.tname_cus_trx_lines),
212: pn_source_document_id => nvl(pn_source_document_id, rec_cur_get_man_ar_inv_taxes.customer_trx_line_id),
213: pd_transaction_date => nvl(pd_transaction_date, rec_cur_get_man_ar_inv_taxes.creation_date),
214: pv_account_name => jai_constants.liability,

Line 211: pv_source_table_name => nvl(pv_source_table_name, jai_constants.tname_cus_trx_lines),

207: pn_organization_id => pn_organization_id,
208: pn_location_id => pn_location_id,
209: pv_source => pv_source,
210: pv_source_trx_type => nvl(pv_source_trx_type, jai_constants.source_ttype_man_ar_inv),
211: pv_source_table_name => nvl(pv_source_table_name, jai_constants.tname_cus_trx_lines),
212: pn_source_document_id => nvl(pn_source_document_id, rec_cur_get_man_ar_inv_taxes.customer_trx_line_id),
213: pd_transaction_date => nvl(pd_transaction_date, rec_cur_get_man_ar_inv_taxes.creation_date),
214: pv_account_name => jai_constants.liability,
215: pn_charge_account_id => NULL,

Line 214: pv_account_name => jai_constants.liability,

210: pv_source_trx_type => nvl(pv_source_trx_type, jai_constants.source_ttype_man_ar_inv),
211: pv_source_table_name => nvl(pv_source_table_name, jai_constants.tname_cus_trx_lines),
212: pn_source_document_id => nvl(pn_source_document_id, rec_cur_get_man_ar_inv_taxes.customer_trx_line_id),
213: pd_transaction_date => nvl(pd_transaction_date, rec_cur_get_man_ar_inv_taxes.creation_date),
214: pv_account_name => jai_constants.liability,
215: pn_charge_account_id => NULL,
216: pn_balancing_account_id => NULL,
217: pn_amount => rec_cur_get_man_ar_inv_taxes.func_tax_amount,
218: pn_assessable_value => rec_cur_get_man_ar_inv_taxes.gst_assessable_value,

Line 229: pv_balancing_accnt_name => jai_constants.liability_interim,

225: pv_balancing_orgn_type => NULL,
226: pn_balancing_orgn_id => NULL,
227: pn_balancing_location_id => NULL,
228: pv_balancing_tax_type => NULL,
229: pv_balancing_accnt_name => jai_constants.liability_interim,
230: pv_currency_code => jai_constants.func_curr,
231: pd_curr_conv_date => NULL,
232: pv_curr_conv_type => NULL,
233: pn_curr_conv_rate => NULL,

Line 230: pv_currency_code => jai_constants.func_curr,

226: pn_balancing_orgn_id => NULL,
227: pn_balancing_location_id => NULL,
228: pv_balancing_tax_type => NULL,
229: pv_balancing_accnt_name => jai_constants.liability_interim,
230: pv_currency_code => jai_constants.func_curr,
231: pd_curr_conv_date => NULL,
232: pv_curr_conv_type => NULL,
233: pn_curr_conv_rate => NULL,
234: pn_trx_amount => NULL,

Line 235: pv_trx_reference_context => jai_constants.contxt_manual_ar,

231: pd_curr_conv_date => NULL,
232: pv_curr_conv_type => NULL,
233: pn_curr_conv_rate => NULL,
234: pn_trx_amount => NULL,
235: pv_trx_reference_context => jai_constants.contxt_manual_ar,
236: pv_trx_reference1 => rec_cur_get_man_ar_inv_taxes.customer_trx_id,
237: pv_trx_reference2 => rec_cur_get_man_ar_inv_taxes.link_to_cust_trx_line_id,
238: pv_trx_reference3 => NULL,
239: pv_trx_reference4 => NULL,

Line 259: p_account_name => jai_constants.liability

255: p_organization_type => pv_organization_type,
256: p_organization_id => pn_organization_id,
257: p_location_id => pn_location_id,
258: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type,
259: p_account_name => jai_constants.liability
260: );
261:
262: ln_balancing_account_id := JAI_GST_GENERAL_PKG.get_account(
263: p_regime_id => pn_regime_id,

Line 268: p_account_name => jai_constants.liability_interim

264: p_organization_type => pv_organization_type,
265: p_organization_id => pn_organization_id,
266: p_location_id => pn_location_id,
267: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type,
268: p_account_name => jai_constants.liability_interim
269: );
270:
271: /* Add code to process accounting */
272: jai_rgm_gst_accounting_pkg.create_gl_entry

Line 278: pv_je_category_name => jai_constants.je_category_rg_entry,

274: pn_credit_amount => rec_cur_get_man_ar_inv_taxes.func_tax_amount,
275: pn_debit_amount => 0,
276: pn_cc_id => ln_charge_account_id,
277: pv_je_source_name => 'Receivables',
278: pv_je_category_name => jai_constants.je_category_rg_entry,
279: pd_accounting_date => nvl(pd_accounting_date, sysdate),
280: pd_currency_conversion_date => pd_currency_conversion_date,
281: pv_currency_conversion_type => pv_currency_conversion_type,
282: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 287: pv_reference_26 => jai_constants.repository_name);

283: pv_reference_10 => NULL,
284: pv_reference_23 => pv_called_from,
285: pv_reference_24 => r_repo_dtl.source_table_name,
286: pv_reference_25 => r_repo_dtl.source_document_id,
287: pv_reference_26 => jai_constants.repository_name);
288:
289: jai_rgm_gst_accounting_pkg.create_gl_entry
290: (pn_organization_id => pn_organization_id,
291: pn_credit_amount => 0,

Line 295: pv_je_category_name => jai_constants.je_category_rg_entry,

291: pn_credit_amount => 0,
292: pn_debit_amount => rec_cur_get_man_ar_inv_taxes.func_tax_amount,
293: pn_cc_id => ln_balancing_account_id,
294: pv_je_source_name => 'Receivables',
295: pv_je_category_name => jai_constants.je_category_rg_entry,
296: pd_accounting_date => nvl(pd_accounting_date, sysdate),
297: pd_currency_conversion_date => pd_currency_conversion_date,
298: pv_currency_conversion_type => pv_currency_conversion_type,
299: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 304: pv_reference_26 => jai_constants.repository_name);

300: pv_reference_10 => NULL,
301: pv_reference_23 => pv_called_from,
302: pv_reference_24 => r_repo_dtl.source_table_name,
303: pv_reference_25 => r_repo_dtl.source_document_id,
304: pv_reference_26 => jai_constants.repository_name);
305:
306: -- END IF; /* process_accounting */
307:
308: END LOOP;

Line 344: pv_currency_code => jai_constants.func_curr,

340: pn_balancing_orgn_id => NULL,
341: pn_balancing_location_id => NULL,
342: pv_balancing_tax_type => NULL,
343: pv_balancing_accnt_name => pv_balancing_account_name,
344: pv_currency_code => jai_constants.func_curr,
345: pd_curr_conv_date => NULL,
346: pv_curr_conv_type => NULL,
347: pn_curr_conv_rate => NULL,
348: pn_trx_amount => NULL,

Line 349: pv_trx_reference_context => jai_constants.contxt_manual_ar,

345: pd_curr_conv_date => NULL,
346: pv_curr_conv_type => NULL,
347: pn_curr_conv_rate => NULL,
348: pn_trx_amount => NULL,
349: pv_trx_reference_context => jai_constants.contxt_manual_ar,
350: pv_trx_reference1 => NULL,
351: pv_trx_reference2 => NULL,
352: pv_trx_reference3 => NULL,
353: pv_trx_reference4 => NULL,

Line 366: pv_je_category_name => jai_constants.je_category_rg_entry,

362: pn_credit_amount => pn_amount,
363: pn_debit_amount => 0,
364: pn_cc_id => pn_charge_account_id,
365: pv_je_source_name => JAI_GST_GENERAL_PKG.get_regime_code(pn_regime_id),
366: pv_je_category_name => jai_constants.je_category_rg_entry,
367: pd_accounting_date => nvl(pd_accounting_date, sysdate),
368: pd_currency_conversion_date => pd_currency_conversion_date,
369: pv_currency_conversion_type => pv_currency_conversion_type,
370: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 375: pv_reference_26 => jai_constants.repository_name);

371: pv_reference_10 => NULL,
372: pv_reference_23 => pv_called_from,
373: pv_reference_24 => pv_source_table_name,
374: pv_reference_25 => pn_source_document_id,
375: pv_reference_26 => jai_constants.repository_name);
376:
377: jai_rgm_gst_accounting_pkg.create_gl_entry
378: (pn_organization_id => pn_organization_id,
379: pn_credit_amount => 0,

Line 383: pv_je_category_name => jai_constants.je_category_rg_entry,

379: pn_credit_amount => 0,
380: pn_debit_amount => pn_amount,
381: pn_cc_id => pn_balancing_account_id,
382: pv_je_source_name => JAI_GST_GENERAL_PKG.get_regime_code(pn_regime_id),
383: pv_je_category_name => jai_constants.je_category_rg_entry,
384: pd_accounting_date => nvl(pd_accounting_date, sysdate),
385: pd_currency_conversion_date => pd_currency_conversion_date,
386: pv_currency_conversion_type => pv_currency_conversion_type,
387: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 392: pv_reference_26 => jai_constants.repository_name);

388: pv_reference_10 => NULL,
389: pv_reference_23 => pv_called_from,
390: pv_reference_24 => pv_source_table_name,
391: pv_reference_25 => pn_source_document_id,
392: pv_reference_26 => jai_constants.repository_name);
393:
394:
395: END IF; /* Manual Source */
396:

Line 398: IF upper(pv_source) IN (jai_constants.source_nsh,jai_constants.source_wsh) THEN

394:
395: END IF; /* Manual Source */
396:
397:
398: IF upper(pv_source) IN (jai_constants.source_nsh,jai_constants.source_wsh) THEN
399:
400: FOR rec_cur_get_deliveries IN cur_get_deliveries(pv_source,
401: pv_source_trx_type,
402: pv_source_table_name,

Line 409: p_organization_type => jai_constants.orgn_type_io ,

405: LOOP
406:
407: ln_charge_account_id := JAI_GST_GENERAL_PKG.get_account(
408: p_regime_id => pn_regime_id ,
409: p_organization_type => jai_constants.orgn_type_io ,
410: p_organization_id => pn_organization_id ,
411: p_location_id => pn_location_id ,
412: p_tax_type => rec_cur_get_deliveries.tax_type ,
413: p_account_name => jai_constants.liability

Line 413: p_account_name => jai_constants.liability

409: p_organization_type => jai_constants.orgn_type_io ,
410: p_organization_id => pn_organization_id ,
411: p_location_id => pn_location_id ,
412: p_tax_type => rec_cur_get_deliveries.tax_type ,
413: p_account_name => jai_constants.liability
414: ) ;
415:
416: ln_balancing_account_id := JAI_GST_GENERAL_PKG.get_account(
417: p_regime_id => pn_regime_id ,

Line 418: p_organization_type => jai_constants.orgn_type_io ,

414: ) ;
415:
416: ln_balancing_account_id := JAI_GST_GENERAL_PKG.get_account(
417: p_regime_id => pn_regime_id ,
418: p_organization_type => jai_constants.orgn_type_io ,
419: p_organization_id => pn_organization_id ,
420: p_location_id => pn_location_id ,
421: p_tax_type => rec_cur_get_deliveries.tax_type ,
422: p_account_name => jai_constants.liability_interim

Line 422: p_account_name => jai_constants.liability_interim

418: p_organization_type => jai_constants.orgn_type_io ,
419: p_organization_id => pn_organization_id ,
420: p_location_id => pn_location_id ,
421: p_tax_type => rec_cur_get_deliveries.tax_type ,
422: p_account_name => jai_constants.liability_interim
423: ) ;
424:
425: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Accounts : ' || ln_charge_account_id || ':' ||ln_balancing_account_id );
426:

Line 431: pv_organization_type => nvl(pv_organization_type, jai_constants.orgn_type_io),

427: jai_rgm_gst_accounting_pkg.create_repository_entry(
428: pn_repository_id => ln_repository_id,
429: pn_regime_id => pn_regime_id,
430: pv_tax_type => rec_cur_get_deliveries.tax_type,
431: pv_organization_type => nvl(pv_organization_type, jai_constants.orgn_type_io),
432: pn_organization_id => pn_organization_id,
433: pn_location_id => pn_location_id,
434: pv_source => pv_source,
435: pv_source_trx_type => pv_source_trx_type,

Line 439: pv_account_name => nvl(pv_account_name, jai_constants.liability),

435: pv_source_trx_type => pv_source_trx_type,
436: pv_source_table_name => pv_source_table_name,
437: pn_source_document_id => nvl(pn_source_document_id, rec_cur_get_deliveries.delivery_detail_id),
438: pd_transaction_date => nvl(pd_transaction_date, rec_cur_get_deliveries.creation_date),
439: pv_account_name => nvl(pv_account_name, jai_constants.liability),
440: pn_charge_account_id => ln_charge_account_id,
441: pn_balancing_account_id => ln_balancing_account_id,
442: pn_amount => rec_cur_get_deliveries.func_tax_amount,
443: pn_assessable_value => nvl(pn_assessable_value,rec_cur_get_deliveries.gst_assessable_value),

Line 455: pv_currency_code => jai_constants.func_curr,

451: pn_balancing_orgn_id => NULL,
452: pn_balancing_location_id => NULL,
453: pv_balancing_tax_type => NULL,
454: pv_balancing_accnt_name => pv_balancing_account_name,
455: pv_currency_code => jai_constants.func_curr,
456: pd_curr_conv_date => NULL,
457: pv_curr_conv_type => NULL,
458: pn_curr_conv_rate => NULL,
459: pn_trx_amount => NULL,

Line 460: pv_trx_reference_context => jai_constants.contxt_delivery,

456: pd_curr_conv_date => NULL,
457: pv_curr_conv_type => NULL,
458: pn_curr_conv_rate => NULL,
459: pn_trx_amount => NULL,
460: pv_trx_reference_context => jai_constants.contxt_delivery,
461: pv_trx_reference1 => rec_cur_get_deliveries.delivery_id,
462: pv_trx_reference2 => rec_cur_get_deliveries.order_line_id,
463: pv_trx_reference3 => NULL,
464: pv_trx_reference4 => NULL,

Line 478: pv_je_category_name => jai_constants.je_category_rg_entry,

474: pn_credit_amount => nvl(pn_amount,rec_cur_get_deliveries.func_tax_amount),
475: pn_debit_amount => 0,
476: pn_cc_id => ln_charge_account_id,
477: pv_je_source_name => pv_source,
478: pv_je_category_name => jai_constants.je_category_rg_entry,
479: pd_accounting_date => nvl(pd_accounting_date, sysdate),
480: pd_currency_conversion_date => pd_currency_conversion_date,
481: pv_currency_conversion_type => pv_currency_conversion_type,
482: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 487: pv_reference_26 => jai_constants.repository_name);

483: pv_reference_10 => NULL,
484: pv_reference_23 => pv_called_from,
485: pv_reference_24 => pv_source_table_name,
486: pv_reference_25 => rec_cur_get_deliveries.delivery_detail_id,
487: pv_reference_26 => jai_constants.repository_name);
488:
489: jai_rgm_gst_accounting_pkg.create_gl_entry
490: (pn_organization_id => pn_organization_id,
491: pn_credit_amount => 0,

Line 495: pv_je_category_name => jai_constants.je_category_rg_entry,

491: pn_credit_amount => 0,
492: pn_debit_amount => nvl(pn_amount,rec_cur_get_deliveries.func_tax_amount),
493: pn_cc_id => ln_balancing_account_id,
494: pv_je_source_name => pv_source,
495: pv_je_category_name => jai_constants.je_category_rg_entry,
496: pd_accounting_date => nvl(pd_accounting_date, sysdate),
497: pd_currency_conversion_date => pd_currency_conversion_date,
498: pv_currency_conversion_type => pv_currency_conversion_type,
499: pn_currency_conversion_rate => pn_currency_conversion_rate,

Line 504: pv_reference_26 => jai_constants.repository_name);

500: pv_reference_10 => NULL,
501: pv_reference_23 => pv_called_from,
502: pv_reference_24 => pv_source_table_name,
503: pv_reference_25 => rec_cur_get_deliveries.delivery_detail_id,
504: pv_reference_26 => jai_constants.repository_name);
505:
506:
507:
508: END LOOP;

Line 509: pv_process_flag := jai_constants.successful;

505:
506:
507:
508: END LOOP;
509: pv_process_flag := jai_constants.successful;
510:
511: END IF; /* WSH Source */
512:
513: