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_TAX_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 189: lv_action := JAI_CONSTANTS.inserting;

185: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_event_class_rec.tax_event_type_code);
186:
187: /**Prepayment unapplication*/
188: if p_line_level_action in ('UNAPPLY_FROM') and p_trx_line_id is not NULL then -- Prepayment Unapply Action
189: lv_action := JAI_CONSTANTS.inserting;
190:
191: --Added by Cholei for bug#14189751 begin
192: ------------------------------------------------------------------------------------
193: /*

Line 228: IF lv_return_code <> jai_constants.successful then

224: pv_return_code => lv_return_code ,
225: pv_return_message => lv_return_message
226: );
227:
228: IF lv_return_code <> jai_constants.successful then
229: RAISE le_error;
230: END IF;
231:
232:

Line 239: lv_action := JAI_CONSTANTS.updating;

235: /**Invoice validation*/
236: elsif p_event_class_rec.event_class_code in ('STANDARD INVOICES', 'PREPAYMENT INVOICES') and
237: p_event_class_rec.tax_event_type_code in ('VALIDATE') then -- Validate Action
238:
239: lv_action := JAI_CONSTANTS.updating;
240:
241: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
242: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call validation for invoice: ' || NVL(p_event_class_rec.TRX_ID , p_transaction_rec.TRX_ID));
243: end if;

Line 271: if lv_return_code <> JAI_CONSTANTS.successful then

267: pv_action => lv_action,
268: pv_return_code => lv_return_code,
269: pv_return_message => lv_return_message);
270:
271: if lv_return_code <> JAI_CONSTANTS.successful then
272: RAISE le_error;
273: end if;
274: end loop;
275: --Added by Qiong for AP Open Interface Begin

Line 316: lv_action := JAI_CONSTANTS.inserting;

312: AND p_event_class_rec.event_class_code = 'PO_PA'
313: AND p_event_class_rec.event_type_code IN ('PO_PA_CREATED','PO_PA_ADJUSTED')
314: THEN
315: IF p_event_class_rec.event_type_code = 'PO_PA_CREATED' THEN
316: lv_action := JAI_CONSTANTS.inserting;
317: ELSIF p_event_class_rec.event_type_code = 'PO_PA_ADJUSTED' THEN
318: lv_action := JAI_CONSTANTS.updating;
319: END IF;
320: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

Line 318: lv_action := JAI_CONSTANTS.updating;

314: THEN
315: IF p_event_class_rec.event_type_code = 'PO_PA_CREATED' THEN
316: lv_action := JAI_CONSTANTS.inserting;
317: ELSIF p_event_class_rec.event_type_code = 'PO_PA_ADJUSTED' THEN
318: lv_action := JAI_CONSTANTS.updating;
319: END IF;
320: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_po with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
322: end if;

Line 330: lv_action := JAI_CONSTANTS.inserting;

326: AND p_event_class_rec.event_class_code = 'RELEASE'
327: AND p_event_class_rec.event_type_code IN ('RELEASE_CREATED','RELEASE_ADJUSTED')
328: THEN
329: IF p_event_class_rec.event_type_code = 'RELEASE_CREATED' THEN
330: lv_action := JAI_CONSTANTS.inserting;
331: ELSIF p_event_class_rec.event_type_code = 'RELEASE_ADJUSTED' THEN
332: lv_action := JAI_CONSTANTS.updating;
333: END IF;
334: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

Line 332: lv_action := JAI_CONSTANTS.updating;

328: THEN
329: IF p_event_class_rec.event_type_code = 'RELEASE_CREATED' THEN
330: lv_action := JAI_CONSTANTS.inserting;
331: ELSIF p_event_class_rec.event_type_code = 'RELEASE_ADJUSTED' THEN
332: lv_action := JAI_CONSTANTS.updating;
333: END IF;
334: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_release with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
336: end if;

Line 373: lv_action := JAI_CONSTANTS.inserting;

369: IF p_event_class_rec.tax_event_class_code IN ('SALES_TRANSACTION') AND
370: p_event_class_rec.tax_event_type_code IN ('CREATE') THEN
371:
372: -- for order creation
373: lv_action := JAI_CONSTANTS.inserting;
374: FOR rec_ool in c_order_lines_entry (p_event_class_rec.trx_id)
375: LOOP
376: jai_om_tax_processing_pkg.default_tax (
377: pr_old => null ,

Line 383: if lv_return_code <> JAI_CONSTANTS.successful then

379: pv_action => lv_action ,
380: pv_return_code => lv_return_code ,
381: pv_return_message => lv_return_message
382: );
383: if lv_return_code <> JAI_CONSTANTS.successful then
384: RAISE le_error;
385: end if;
386: jai_om_tax_processing_pkg.populate_tax (
387: pr_old => null ,

Line 393: if lv_return_code <> JAI_CONSTANTS.successful then

389: pv_action => lv_action ,
390: pv_return_code => lv_return_code ,
391: pv_return_message => lv_return_message
392: );
393: if lv_return_code <> JAI_CONSTANTS.successful then
394: RAISE le_error;
395: end if;
396:
397: -- added by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 begin

Line 404: if lv_return_code <> JAI_CONSTANTS.successful then

400: p_rec_new => rec_ool,
401: p_action => lv_action,
402: px_return_code => lv_return_code,
403: px_return_message => lv_return_message);
404: if lv_return_code <> JAI_CONSTANTS.successful then
405: RAISE le_error;
406: end if;
407: -- added by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 end.
408:

Line 411: lv_action := jai_constants.updating;

407: -- added by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 end.
408:
409: END LOOP;
410: -- for order update
411: lv_action := jai_constants.updating;
412: FOR rec_ool in c_order_lines_update (p_event_class_rec.trx_id)
413: LOOP
414:
415:

Line 452: if lv_return_code <> JAI_CONSTANTS.successful then

448: pv_return_code => lv_return_code ,
449: pv_return_message => lv_return_message
450: );
451:
452: if lv_return_code <> JAI_CONSTANTS.successful then
453: RAISE le_error;
454: end if;
455:
456: IF ( nvl(rec_ool.ordered_quantity,0) <> nvl(rec_old_ool.ordered_quantity,0) OR

Line 473: if lv_return_code <> JAI_CONSTANTS.successful then

469: pv_action => lv_action ,
470: pv_return_code => lv_return_code ,
471: pv_return_message => lv_return_message
472: );
473: if lv_return_code <> JAI_CONSTANTS.successful then
474: RAISE le_error;
475: end if;
476:
477: END IF;

Line 513: if lv_return_code <> JAI_CONSTANTS.successful then

509: pv_return_code => lv_return_code ,
510: pv_return_message => lv_return_message
511: );
512:
513: if lv_return_code <> JAI_CONSTANTS.successful then
514: RAISE le_error;
515: end if;
516:
517: -- added by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 begin

Line 524: if lv_return_code <> JAI_CONSTANTS.successful then

520: p_rec_new => rec_ool,
521: p_action => lv_action,
522: px_return_code => lv_return_code,
523: px_return_message => lv_return_message);
524: if lv_return_code <> JAI_CONSTANTS.successful then
525: RAISE le_error;
526: end if;
527: -- added by zhiwei.xin for Trigger Replacement bug #15968958 on 20-Dec-2012 end.
528:

Line 548: IF lv_return_code <> JAI_CONSTANTS.successful THEN

544: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END', 'after jai_ar_tax_processing_pkg.calculate_tax. lv_return_code = '||lv_return_code||
546: ', lv_return_message = '||lv_return_message);
547: END IF;
548: IF lv_return_code <> JAI_CONSTANTS.successful THEN
549: RAISE le_error;
550: END IF;
551: --Added by Qinglei for bug#14627780 end
552: END IF;

Line 645: lv_action := JAI_CONSTANTS.inserting;

641:
642: if p_event_class_rec.event_class_code in ('STANDARD INVOICES') and
643: p_event_class_rec.tax_event_type_code in ('DISTRIBUTE') then -- Prepayment Application Action
644:
645: lv_action := JAI_CONSTANTS.inserting;
646:
647: /*
648: Need update the latest match status flag before perform prepay application,
649: otherwise jai_ap_tds_generation_pkg.status_update_chk_validate will prevent from Appying.

Line 680: IF lv_return_code <> jai_constants.successful then

676: pv_return_code => lv_return_code ,
677: pv_return_message => lv_return_message
678: );
679:
680: IF lv_return_code <> jai_constants.successful then
681: RAISE le_error;
682: END IF;
683:
684: END LOOP;

Line 953: lv_action := JAI_CONSTANTS.inserting;

949: IF p_event_class_rec.entity_code = 'TRANSACTIONS'
950: --AND ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
951: AND p_event_class_rec.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
952: THEN
953: lv_action := JAI_CONSTANTS.inserting;
954:
955:
956:
957: --OPEN c_ra_customer_trx(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id);

Line 1014: IF lv_return_code <> jai_constants.successful then

1010: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out import_projects_taxes() ');
1011: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1012: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1013:
1014: IF lv_return_code <> jai_constants.successful then
1015: raise le_error ;
1016: end if;
1017:
1018: end if;

Line 1039: IF lv_return_code <> jai_constants.successful then

1035: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1036: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1037:
1038:
1039: IF lv_return_code <> jai_constants.successful then
1040: RAISE le_error;
1041: END IF;
1042: end if;
1043: if t_rec_lines.line_type = 'LINE' then

Line 1059: IF lv_return_code <> jai_constants.successful then

1055: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_rmacm() ');
1056: fnd_file.put_line(FND_FILE.LOG,'lv_return_code ' || lv_return_code);
1057: fnd_file.put_line(FND_FILE.LOG,'lv_return_message ' || lv_return_message);
1058:
1059: IF lv_return_code <> jai_constants.successful then
1060: RAISE le_error;
1061: END IF;
1062: end if;
1063:

Line 1161: lv_action := JAI_CONSTANTS.updating;

1157: lv_remark2 varchar2(10);
1158:
1159: BEGIN
1160:
1161: lv_action := JAI_CONSTANTS.updating;
1162:
1163:
1164: OPEN c_ra_customer_trx(pn_customer_trx_id);
1165: FETCH c_ra_customer_trx INTO t_ra_customer_trx_rec;

Line 1185: IF lv_return_code <> jai_constants.successful then

1181: ,pv_return_message => lv_return_message
1182: );
1183:
1184:
1185: IF lv_return_code <> jai_constants.successful then
1186: RAISE le_error;
1187: END IF;
1188:
1189: end if;

Line 1204: IF lv_return_code <> jai_constants.successful then

1200: ,pv_return_message => lv_return_message
1201: );
1202:
1203:
1204: IF lv_return_code <> jai_constants.successful then
1205: RAISE le_error;
1206: END IF;
1207: end if;
1208: if(t_ra_customer_trx_rec.complete_flag = 'Y')then

Line 1219: IF lv_return_code <> jai_constants.successful then

1215: ,pv_return_message => lv_return_message
1216: );
1217:
1218:
1219: IF lv_return_code <> jai_constants.successful then
1220: RAISE le_error;
1221: END IF;
1222:
1223: JAI_AR_IMPORT_SYNC_PKG.process_cm_vat_repo(

Line 1232: IF lv_return_code <> jai_constants.successful then

1228: ,pv_return_code => lv_return_code
1229: ,pv_return_message => lv_return_message
1230: );
1231:
1232: IF lv_return_code <> jai_constants.successful then
1233: RAISE le_error;
1234: END IF;
1235:
1236: end if;

Line 1253: IF lv_return_code <> jai_constants.successful then

1249: );
1250:
1251:
1252:
1253: IF lv_return_code <> jai_constants.successful then
1254: RAISE le_error;
1255: END IF;
1256: end if;*/
1257:

Line 1269: IF lv_return_code <> jai_constants.successful then

1265: pv_action => lv_action ,
1266: pv_return_code => lv_return_code ,
1267: pv_return_message => lv_return_message
1268: );
1269: IF lv_return_code <> jai_constants.successful then
1270: RAISE le_error;
1271: END IF;
1272: end if;
1273:

Line 1441: lv_action := JAI_CONSTANTS.updating;

1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND
1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')
1439: THEN
1440:
1441: lv_action := JAI_CONSTANTS.updating;
1442:
1443: FOR ap_inv_dist_rec in c_get_inv_dists(zx_global_structures_pkg.g_event_class_rec.trx_id)LOOP
1444: JAI_TAX_PROCESSING_PKG.create_accounting(
1445: pr_rec => ap_inv_dist_rec ,

Line 1450: IF lv_return_code <> jai_constants.successful THEN

1446: pv_action => lv_action ,
1447: pv_return_code => lv_return_code ,
1448: pv_return_message => lv_return_message
1449: );
1450: IF lv_return_code <> jai_constants.successful THEN
1451: RAISE le_error;
1452: END IF;
1453:
1454: END LOOP;

Line 1543: AND jrr.registration_type = jai_constants.regn_type_tax_types

1539: AND jcdt.modvat_flag = 'Y'
1540: AND jcdt.tax_id = jcta.tax_id
1541: AND jcta.tax_type = jrr.attribute_code
1542: AND jrr.regime_id = jrd.regime_id
1543: AND jrr.registration_type = jai_constants.regn_type_tax_types
1544: AND jrd.regime_code = jai_constants.service_regime;
1545:
1546: CURSOR get_matched_tax_cur IS
1547: SELECT jamt.tax_amount,jcta.tax_type

Line 1544: AND jrd.regime_code = jai_constants.service_regime;

1540: AND jcdt.tax_id = jcta.tax_id
1541: AND jcta.tax_type = jrr.attribute_code
1542: AND jrr.regime_id = jrd.regime_id
1543: AND jrr.registration_type = jai_constants.regn_type_tax_types
1544: AND jrd.regime_code = jai_constants.service_regime;
1545:
1546: CURSOR get_matched_tax_cur IS
1547: SELECT jamt.tax_amount,jcta.tax_type
1548: FROM jai_ap_match_inv_taxes jamt

Line 1558: AND jrr.registration_type = jai_constants.regn_type_tax_types

1554: AND jamt.tax_id=jcta.tax_id
1555: AND jamt.recoverable_flag = 'Y'
1556: AND jcta.tax_type = jrr.attribute_code
1557: AND jrr.regime_id = jrd.regime_id
1558: AND jrr.registration_type = jai_constants.regn_type_tax_types
1559: AND jrd.regime_code = jai_constants.service_regime;
1560:
1561: CURSOR get_match_item_cur IS
1562: SELECT line.match_type,line.line_number

Line 1559: AND jrd.regime_code = jai_constants.service_regime;

1555: AND jamt.recoverable_flag = 'Y'
1556: AND jcta.tax_type = jrr.attribute_code
1557: AND jrr.regime_id = jrd.regime_id
1558: AND jrr.registration_type = jai_constants.regn_type_tax_types
1559: AND jrd.regime_code = jai_constants.service_regime;
1560:
1561: CURSOR get_match_item_cur IS
1562: SELECT line.match_type,line.line_number
1563: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt

Line 1586: WHERE regime_code = jai_constants.service_regime;

1582:
1583: CURSOR get_regime_id_cur IS
1584: SELECT regime_id
1585: FROM jai_rgm_definitions
1586: WHERE regime_code = jai_constants.service_regime;
1587:
1588: CURSOR get_org_cur IS
1589: SELECT organization_id,location_id
1590: FROM jai_ap_invoice_lines

Line 1657: lv_regime_code VARCHAR2(30) := jai_constants.service_regime;

1653: lv_same_period_flag VARCHAR2(1);
1654:
1655: lv_process_message VARCHAR2(200);
1656: ln_regime_id NUMBER;
1657: lv_regime_code VARCHAR2(30) := jai_constants.service_regime;
1658: lv_tax_type VARCHAR2(30);
1659: ln_organization_id NUMBER;
1660: ln_location_id NUMBER;
1661: ln_charge_account_id NUMBER;

Line 1711: pv_return_code := jai_constants.successful ;

1707:
1708: END check_same_period_func;
1709:
1710: BEGIN
1711: pv_return_code := jai_constants.successful ;
1712:
1713: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1714: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1715: end if;

Line 1718: If pv_action = jai_constants.updating Then

1714: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1715: end if;
1716:
1717:
1718: If pv_action = jai_constants.updating Then
1719:
1720: ld_canceled_date := NULL;
1721: OPEN get_cancell_date_cur;
1722: FETCH get_cancell_date_cur INTO ld_canceled_date;

Line 1810: ln_entered_amt := round(ln_dist_line_amount, jai_constants.service_rgm_rnd_factor);

1806: FETCH c_get_st_accrual_date INTO ld_accrual_date;
1807: CLOSE c_get_st_accrual_date;
1808:
1809: IF pr_rec.accounting_date >= ld_accrual_date THEN
1810: ln_entered_amt := round(ln_dist_line_amount, jai_constants.service_rgm_rnd_factor);
1811: ln_accounted_amt := ln_entered_amt * nvl(ln_curr_conv_rate, 1);
1812:
1813: IF lv_tax_type IS NOT NULL THEN
1814: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN

Line 1816: lv_account_name := jai_constants.liability_interim;

1812:
1813: IF lv_tax_type IS NOT NULL THEN
1814: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
1815: IF lv_event = 'ACCOUNTING' THEN
1816: lv_account_name := jai_constants.liability_interim;
1817: ELSE
1818: lv_account_name := jai_constants.liability;
1819: END IF;
1820: ln_entered_amt := abs(ln_entered_amt);

Line 1818: lv_account_name := jai_constants.liability;

1814: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
1815: IF lv_event = 'ACCOUNTING' THEN
1816: lv_account_name := jai_constants.liability_interim;
1817: ELSE
1818: lv_account_name := jai_constants.liability;
1819: END IF;
1820: ln_entered_amt := abs(ln_entered_amt);
1821: ln_accounted_amt := abs(ln_accounted_amt);
1822: ELSE

Line 1824: lv_account_name := jai_constants.recovery;

1820: ln_entered_amt := abs(ln_entered_amt);
1821: ln_accounted_amt := abs(ln_accounted_amt);
1822: ELSE
1823: IF lv_event = 'ACCOUNTING' THEN
1824: lv_account_name := jai_constants.recovery;
1825: ELSE
1826: lv_account_name := jai_constants.recovery_interim;
1827: END IF;
1828: ln_entered_amt := abs(ln_entered_amt);

Line 1826: lv_account_name := jai_constants.recovery_interim;

1822: ELSE
1823: IF lv_event = 'ACCOUNTING' THEN
1824: lv_account_name := jai_constants.recovery;
1825: ELSE
1826: lv_account_name := jai_constants.recovery_interim;
1827: END IF;
1828: ln_entered_amt := abs(ln_entered_amt);
1829: ln_accounted_amt := abs(ln_accounted_amt);
1830: END IF;

Line 1833: , p_organization_type => jai_constants.service_tax_orgn_type

1829: ln_accounted_amt := abs(ln_accounted_amt);
1830: END IF;
1831: ln_charge_account_id := jai_cmn_rgm_recording_pkg.get_account(
1832: p_regime_id => ln_regime_id
1833: , p_organization_type => jai_constants.service_tax_orgn_type
1834: , p_organization_id => ln_organization_id
1835: , p_location_id => ln_location_id
1836: , p_tax_type => lv_tax_type
1837: , p_account_name => lv_account_name);

Line 1849: p_organization_type => jai_constants.service_tax_orgn_type,

1845:
1846: jai_cmn_rgm_recording_pkg.post_accounting(
1847: p_regime_code => lv_regime_code,
1848: p_tax_type => lv_tax_type,
1849: p_organization_type => jai_constants.service_tax_orgn_type,
1850: p_organization_id => ln_organization_id,
1851: p_source => jai_constants.source_ap,
1852: p_source_trx_type => lv_source_trx_type,
1853: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

Line 1851: p_source => jai_constants.source_ap,

1847: p_regime_code => lv_regime_code,
1848: p_tax_type => lv_tax_type,
1849: p_organization_type => jai_constants.service_tax_orgn_type,
1850: p_organization_id => ln_organization_id,
1851: p_source => jai_constants.source_ap,
1852: p_source_trx_type => lv_source_trx_type,
1853: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1854: p_source_document_id => ln_invoice_dist_id,
1855: p_code_combination_id => ln_charge_account_id,

Line 1875: lv_account_name := jai_constants.liability;

1871: );
1872:
1873: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
1874: IF lv_event = 'ACCOUNTING' THEN
1875: lv_account_name := jai_constants.liability;
1876: ELSE
1877: lv_account_name := jai_constants.liability_interim;
1878: END IF;
1879: ELSE

Line 1877: lv_account_name := jai_constants.liability_interim;

1873: IF lv_invoice_type IN ('CREDIT', 'DEBIT') THEN
1874: IF lv_event = 'ACCOUNTING' THEN
1875: lv_account_name := jai_constants.liability;
1876: ELSE
1877: lv_account_name := jai_constants.liability_interim;
1878: END IF;
1879: ELSE
1880: IF lv_event = 'ACCOUNTING' THEN
1881: lv_account_name := jai_constants.recovery_interim;

Line 1881: lv_account_name := jai_constants.recovery_interim;

1877: lv_account_name := jai_constants.liability_interim;
1878: END IF;
1879: ELSE
1880: IF lv_event = 'ACCOUNTING' THEN
1881: lv_account_name := jai_constants.recovery_interim;
1882: ELSE
1883: IF lv_invoice_type = 'STANDARD' THEN
1884: lv_same_period_flag := check_same_period_func;
1885: IF nvl(lv_same_period_flag, 'N') = 'N' THEN

Line 1886: lv_account_name := jai_constants.liability;

1882: ELSE
1883: IF lv_invoice_type = 'STANDARD' THEN
1884: lv_same_period_flag := check_same_period_func;
1885: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
1886: lv_account_name := jai_constants.liability;
1887: ELSE
1888: lv_account_name := jai_constants.recovery;
1889: END IF;
1890: ELSE

Line 1888: lv_account_name := jai_constants.recovery;

1884: lv_same_period_flag := check_same_period_func;
1885: IF nvl(lv_same_period_flag, 'N') = 'N' THEN
1886: lv_account_name := jai_constants.liability;
1887: ELSE
1888: lv_account_name := jai_constants.recovery;
1889: END IF;
1890: ELSE
1891: lv_account_name := jai_constants.recovery;
1892: END IF;

Line 1891: lv_account_name := jai_constants.recovery;

1887: ELSE
1888: lv_account_name := jai_constants.recovery;
1889: END IF;
1890: ELSE
1891: lv_account_name := jai_constants.recovery;
1892: END IF;
1893: END IF;
1894: END IF;
1895:

Line 1898: , p_organization_type => jai_constants.service_tax_orgn_type

1894: END IF;
1895:
1896: ln_charge_account_id := jai_cmn_rgm_recording_pkg.get_account(
1897: p_regime_id => ln_regime_id
1898: , p_organization_type => jai_constants.service_tax_orgn_type
1899: , p_organization_id => ln_organization_id
1900: , p_location_id => ln_location_id
1901: , p_tax_type => lv_tax_type
1902: , p_account_name => lv_account_name);

Line 1913: p_organization_type => jai_constants.service_tax_orgn_type,

1909:
1910: jai_cmn_rgm_recording_pkg.post_accounting(
1911: p_regime_code => lv_regime_code,
1912: p_tax_type => lv_tax_type,
1913: p_organization_type => jai_constants.service_tax_orgn_type,
1914: p_organization_id => ln_organization_id,
1915: p_source => jai_constants.source_ap,
1916: p_source_trx_type => lv_source_trx_type,
1917: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

Line 1915: p_source => jai_constants.source_ap,

1911: p_regime_code => lv_regime_code,
1912: p_tax_type => lv_tax_type,
1913: p_organization_type => jai_constants.service_tax_orgn_type,
1914: p_organization_id => ln_organization_id,
1915: p_source => jai_constants.source_ap,
1916: p_source_trx_type => lv_source_trx_type,
1917: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1918: p_source_document_id => ln_invoice_dist_id,
1919: p_code_combination_id => ln_charge_account_id,

Line 1949: pv_return_code := jai_constants.unexpected_error;

1945: end if;
1946:
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: pv_return_code := jai_constants.unexpected_error;
1950: pv_return_message := substr(sqlerrm,1,1900);
1951: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.EXCEPTION', G_PKG_NAME || ': '||l_api_name||'()+'||' EXCEPTION Message:'||pv_return_message);
1953: end if;

Line 2074: lv_action := JAI_CONSTANTS.inserting;

2070: p_event_class_rec.event_type_code IN ('STANDARD UPDATED')
2071: )
2072: ) THEN
2073:
2074: lv_action := JAI_CONSTANTS.inserting;
2075:
2076: OPEN c_get_invs(p_event_class_rec.trx_id);
2077: FETCH c_get_invs into inv_rec;
2078: CLOSE c_get_invs;

Line 2087: IF lv_return_code <> jai_constants.successful THEN

2083: pv_action => lv_action,
2084: pv_return_code => lv_return_code,
2085: pv_return_message => lv_return_message
2086: );
2087: IF lv_return_code <> jai_constants.successful THEN
2088: RAISE le_error;
2089: END IF;
2090:
2091:

Line 2127: IF lv_return_code <> jai_constants.successful then

2123: pn_line_number => inv_lines_rec.line_number,
2124: pv_return_code => lv_return_code,
2125: pv_return_message => lv_return_message
2126: );
2127: IF lv_return_code <> jai_constants.successful then
2128: RAISE le_error;
2129: END IF;
2130: end if;
2131: