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

Line 117: p_override => jai_constants.no

113: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
114: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
115:
116: 2. Procedure call generate_schedule is changed:
117: p_override => jai_constants.no
118:
119: Dependency Due to this Bug:-
120: File jai_rcv_tax.plb (120.4) is changed as part of this Bug,
121: so this object is dependent on current Bug and object jai_rcv_tax.plb(120.4)

Line 234: p_process_status := jai_constants.successful;

230: 115.4 4279050 4279050 jai_rcv_rgm_claims_s.sql 115.1 Sanjikum 07/04/2005
231: 115.4 4279050 4279050 ja_in_create_4279050.sql 115.0 Sanjikum 07/04/2005
232: --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
233: ****************************************************************************************************************************************************************************************/
234: p_process_status := jai_constants.successful;
235: p_process_message := NULL;
236:
237: OPEN c_trx(p_transaction_id);
238: FETCH c_trx INTO r_trx;

Line 351: p_process_status := jai_constants.unexpected_error;

347:
348: p_location_id := ln_location_id;
349: EXCEPTION
350: WHEN OTHERS THEN
351: p_process_status := jai_constants.unexpected_error;
352: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);
353: END get_location;
354:
355: PROCEDURE generate_schedule(

Line 407: DECODE(a.currency, jai_constants.func_curr, a.tax_amount(b.mod_cr_percentage/100), a.tax_amountcp_currency_conversion_rate*(b.mod_cr_percentage/100)),

403: CURSOR cur_tax(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
404: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
405: IS
406: SELECT ROUND(--added by Nitin for bug no 6681800
407: DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*cp_currency_conversion_rate*(b.mod_cr_percentage/100)),
408: NVL(b.rounding_factor, 0)
409: ) tax_amount
410: /*DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
411: NVL(b.rounding_factor, 0) Commented by Nitin for Bug:# 6681800

Line 410: /DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amountcp_currency_conversion_rate),

406: SELECT ROUND(--added by Nitin for bug no 6681800
407: DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*cp_currency_conversion_rate*(b.mod_cr_percentage/100)),
408: NVL(b.rounding_factor, 0)
409: ) tax_amount
410: /*DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
411: NVL(b.rounding_factor, 0) Commented by Nitin for Bug:# 6681800
412: ) tax_amount*/,
413: a.tax_type,
414: a.tax_id,

Line 421: where regime_code = jai_constants.vat_regime

417: JAI_CMN_TAXES_ALL b
418: WHERE a.transaction_id = cp_transaction_id
419: AND a.tax_type IN ( select tax_type
420: from jai_regime_tax_types_v
421: where regime_code = jai_constants.vat_regime
422: )
423: AND a.tax_id = b.tax_id
424: AND a.modvat_flag = 'Y'
425: --Added for Bug#4950914

Line 468: p_process_status := jai_constants.successful;

464: ln_apportion_factor NUMBER;
465:
466: BEGIN
467:
468: p_process_status := jai_constants.successful;
469: p_process_message := NULL;
470:
471: IF p_override = 'Y' THEN
472: DELETE jai_rcv_rgm_claims

Line 519: IF lv_process_flag <> jai_constants.successful THEN

515: p_schedule_id => ln_schedule_id,
516: p_process_flag => lv_process_flag,
517: p_process_msg => lv_process_msg);
518:
519: IF lv_process_flag <> jai_constants.successful THEN
520:
521: --Added for Bug#4950914
522: DELETE jai_rgm_trm_schedules_t
523: WHERE schedule_id = ln_schedule_id;

Line 546: p_process_status := jai_constants.expected_error;

542: DELETE jai_rgm_trm_schedules_t
543: WHERE schedule_id = ln_schedule_id;
544:
545: IF p_simulate_flag = 'Y' THEN
546: p_process_status := jai_constants.expected_error;
547: p_process_message := 'Duplicate Records in jai_rcv_rgm_claims';
548: --This message text is being compared for duplication check, so don't change this.
549: --Or search for the same text in this package and change it at all the places
550: RETURN;

Line 611: jai_constants.vat_regime,

607: SELECT jai_rcv_rgm_claims_s.NEXTVAL,
608: r_term.rcv_rgm_line_id,
609: rec_lines.shipment_header_id,
610: rec_lines.shipment_line_id,
611: jai_constants.vat_regime,
612: rec_txns.tax_transaction_id,
613: rec_txns.transaction_type,
614: rec_txns.transaction_id,
615: rec_txns.parent_transaction_type,

Line 645: p_process_status := jai_constants.unexpected_error;

641: END LOOP;
642: END LOOP;
643: EXCEPTION
644: WHEN OTHERS THEN
645: p_process_status := jai_constants.unexpected_error;
646: p_process_message := SUBSTR(SQLERRM,1,200);
647: fnd_file.put_line(fnd_file.log, 'gone into error ');
648: END generate_schedule;
649:

Line 684: nvl(rtl.currency, jai_constants.func_curr) currency,

680: CURSOR c_tax_amount (cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
681: IS
682: SELECT nvl(rtl.tax_amount, 0) tax_amount,
683: nvl(rtl.modvat_flag, 'N') modvat_flag,
684: nvl(rtl.currency, jai_constants.func_curr) currency,
685: nvl(jtc.rounding_factor, 0) rnd,
686: nvl(jtc.mod_cr_percentage, 0) modvat_percentage /*Added by Nitin for bug # 6681800*/
687: FROM JAI_RCV_LINE_TAXES rtl,
688: JAI_CMN_TAXES_ALL jtc

Line 694: where regime_code = jai_constants.vat_regime);

690: AND jtc.tax_id = rtl.tax_id
691: AND rtl.modvat_flag = 'Y'
692: AND jtc.tax_type IN (select tax_type
693: from jai_regime_tax_types_v
694: where regime_code = jai_constants.vat_regime);
695:
696: CURSOR c_shipment_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
697: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
698: IS

Line 741: b.regime_code= jai_constants.vat_regime

737: IS
738: SELECT 1
739: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
740: WHERE shipment_line_id = cp_shipment_line_id AND
741: b.regime_code= jai_constants.vat_regime
742: and b.tax_type = a.tax_type ;
743:
744: ln_vat_exists NUMBER ;
745:

Line 767: p_process_status := jai_constants.successful;

763: END IF ;
764:
765: -- ended, Ramananda for bug # 4519719
766:
767: p_process_status := jai_constants.successful;
768: p_process_message := NULL;
769:
770: /* File.Sql.35 by Brathod */
771: ln_recoverable_amount := 0;

Line 777: OPEN c_regime(NULL, jai_constants.vat_regime);

773: ln_dup_chk := 0;
774: lv_localpath := '';
775: /* End of File.Sql.35 by Brathod */
776:
777: OPEN c_regime(NULL, jai_constants.vat_regime);
778: FETCH c_regime INTO r_regime;
779: CLOSE c_regime;
780:
781: OPEN c_receipt_source_code(p_shipment_header_id, p_shipment_line_id);

Line 815: IF tax_rec.currency <> jai_constants.func_curr THEN

811: ln_recoverable_amount := 0;
812:
813: FOR tax_rec IN c_tax_amount(rec_lines.shipment_line_id)
814: LOOP
815: IF tax_rec.currency <> jai_constants.func_curr THEN
816: ln_curr_conv := NVL(r_trx.currency_conversion_rate, 1);
817: ELSE
818: ln_curr_conv := 1;
819: END IF;

Line 829: p_process_status := jai_constants.successful;

825: END IF;
826:
827: --In the Final Observation Change
828: if ln_recoverable_amount = 0 then
829: p_process_status := jai_constants.successful;
830: p_process_message := NULL;
831: RETURN;
832: end if;
833:

Line 849: IF lv_process_flag <> jai_constants.successful THEN

845: p_location_id => ln_location_id,
846: p_process_status => lv_process_flag,
847: p_process_message => lv_process_msg);
848:
849: IF lv_process_flag <> jai_constants.successful THEN
850: p_process_status := lv_process_flag;
851: p_process_message := 'Error in Line Number '||rec_lines.line_num||' - '||lv_process_msg;
852: RETURN;
853: END IF;

Line 869: IF lv_process_flag <> jai_constants.successful THEN

865: p_attribute_value => lv_item_class,
866: p_process_flag => lv_process_flag,
867: p_process_msg => lv_process_msg
868: );
869: IF lv_process_flag <> jai_constants.successful THEN
870: p_process_status := lv_process_flag;
871: p_process_message := 'Error in Line Number '||rec_lines.line_num||' - '||lv_process_msg;
872: RETURN;
873: END IF;

Line 880: p_party_type => jai_constants.orgn_type_io,

876: jai_cmn_rgm_terms_pkg.get_term_id(
877: p_regime_id => r_regime.regime_id,
878: p_item_id => rec_lines.inventory_item_id,
879: p_organization_id => r_base_trx.organization_id,
880: p_party_type => jai_constants.orgn_type_io,
881: p_location_id => ln_location_id,
882: p_term_id => ln_term_id,
883: p_process_flag => lv_process_flag,
884: p_process_msg => lv_process_msg

Line 886: IF lv_process_flag <> jai_constants.successful THEN

882: p_term_id => ln_term_id,
883: p_process_flag => lv_process_flag,
884: p_process_msg => lv_process_msg
885: );
886: IF lv_process_flag <> jai_constants.successful THEN
887: p_process_status := lv_process_flag;
888: p_process_message := 'Error in Line Number '||rec_lines.line_num||' - '||lv_process_msg;
889: RETURN;
890: END IF;

Line 898: IF lv_process_flag <> jai_constants.successful THEN

894: p_process_flag => lv_process_flag,
895: p_process_msg => lv_process_msg
896: );
897:
898: IF lv_process_flag <> jai_constants.successful THEN
899: p_process_status := lv_process_flag;
900: p_process_message := 'Error in Line Number '||rec_lines.line_num||' - '||lv_process_msg;
901: RETURN;
902: END IF;

Line 907: pv_regime_code => jai_constants.vat_regime,

903:
904: -- even if there is no VAT, then the data goes into this table
905: /*bduvarag Bug 5899383 start*/
906: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
907: pv_regime_code => jai_constants.vat_regime,
908: pv_organization_type => jai_constants.orgn_type_io,
909: pn_organization_id => r_trx.organization_id,
910: pn_location_id => ln_location_id,
911: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',

Line 908: pv_organization_type => jai_constants.orgn_type_io,

904: -- even if there is no VAT, then the data goes into this table
905: /*bduvarag Bug 5899383 start*/
906: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
907: pv_regime_code => jai_constants.vat_regime,
908: pv_organization_type => jai_constants.orgn_type_io,
909: pn_organization_id => r_trx.organization_id,
910: pn_location_id => ln_location_id,
911: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
912: pv_attribute_type_code => NULL,

Line 911: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',

907: pv_regime_code => jai_constants.vat_regime,
908: pv_organization_type => jai_constants.orgn_type_io,
909: pn_organization_id => r_trx.organization_id,
910: pn_location_id => ln_location_id,
911: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
912: pv_attribute_type_code => NULL,
913: pv_attribute_code => 'DEFAULT_INVOICE_DETAILS' ); --'DEFAULT_INVOICE_DETAILS');
914:
915:

Line 996: jai_constants.vat_regime,

992: ln_location_id,
993: rec_lines.inventory_item_id,
994: rec_lines.receipt_num,
995: r_base_trx.transaction_date,
996: jai_constants.vat_regime,
997: lv_item_class,
998: r_trx.transaction_id,
999: ln_recoverable_amount,
1000: 0,

Line 1021: p_process_status := jai_constants.unexpected_error;

1017: END IF;
1018: END LOOP;
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: p_process_status := jai_constants.unexpected_error;
1022: p_process_message := SUBSTR(SQLERRM,1,200);
1023: END insert_rcv_lines;
1024:
1025: PROCEDURE update_rcv_lines(

Line 1057: p_process_status := jai_constants.successful;

1053: AND shipment_line_id = cp_shipment_line_id;
1054:
1055: r_total_amount c_total_amount%ROWTYPE;
1056: BEGIN
1057: p_process_status := jai_constants.successful;
1058: p_process_message := NULL;
1059:
1060: IF p_shipment_line_id IS NULL AND p_receipt_num IS NULL THEN
1061: p_process_status := jai_constants.expected_error;

Line 1061: p_process_status := jai_constants.expected_error;

1057: p_process_status := jai_constants.successful;
1058: p_process_message := NULL;
1059:
1060: IF p_shipment_line_id IS NULL AND p_receipt_num IS NULL THEN
1061: p_process_status := jai_constants.expected_error;
1062: p_process_message := 'Either of Shipment_line_id or receipt_num is mandatory';
1063: RETURN;
1064: END IF;
1065:

Line 1096: p_process_status := jai_constants.unexpected_error;

1092: END IF;
1093:
1094: EXCEPTION
1095: WHEN OTHERS THEN
1096: p_process_status := jai_constants.unexpected_error;
1097: p_process_message := SUBSTR(SQLERRM,1,200);
1098: END update_rcv_lines;
1099:
1100: PROCEDURE process_vat(

Line 1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount

1134:
1135: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1136: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1137: IS
1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1139: FROM JAI_RCV_LINE_TAXES
1140: WHERE transaction_id = cp_transaction_id
1141: AND tax_type in (select tax_type
1142: from jai_regime_tax_types_v

Line 1143: where regime_code = jai_constants.vat_regime)

1139: FROM JAI_RCV_LINE_TAXES
1140: WHERE transaction_id = cp_transaction_id
1141: AND tax_type in (select tax_type
1142: from jai_regime_tax_types_v
1143: where regime_code = jai_constants.vat_regime)
1144: AND NVL(modvat_flag,'N') = 'Y';*/
1145:
1146: CURSOR c_regime (cp_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL,
1147: cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE DEFAULT NULL)

Line 1229: lv_simulate_flag := jai_constants.no; --File.Sql.35 Cbabu

1225: /* End of File.Sql.35 by Brathod */
1226:
1227: ln_statement_id := 1;
1228:
1229: lv_simulate_flag := jai_constants.no; --File.Sql.35 Cbabu
1230: p_process_status := jai_constants.successful;
1231: p_process_message := NULL;
1232:
1233: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'rgm_claim_pkg.process_vat', 'START');

Line 1230: p_process_status := jai_constants.successful;

1226:
1227: ln_statement_id := 1;
1228:
1229: lv_simulate_flag := jai_constants.no; --File.Sql.35 Cbabu
1230: p_process_status := jai_constants.successful;
1231: p_process_message := NULL;
1232:
1233: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'rgm_claim_pkg.process_vat', 'START');
1234:

Line 1241: IF r_trx.process_vat_status = jai_constants.successful THEN

1237: CLOSE c_trx;
1238:
1239: --Start for Bug#4950914
1240: --means transacrion has already completed
1241: IF r_trx.process_vat_status = jai_constants.successful THEN
1242: RETURN;
1243: END IF;
1244:
1245: --this is just to check, if the transaction has already been processed by checking the records from

Line 1258: IF lv_process_status = jai_constants.expected_error AND

1254: p_term_id => NULL,
1255: p_tax_id => NULL,
1256: p_override => NULL
1257: );
1258: IF lv_process_status = jai_constants.expected_error AND
1259: lv_process_message = 'Duplicate Records in jai_rcv_rgm_claims' THEN
1260: --This process message is being passed from the procedure generate_schedule
1261: --So shouldn't be changed OR should be changed at all the places in the in this package
1262: RETURN;

Line 1294: p_override => jai_constants.no --File.Sql.35 Added by Ramananda for bug#4530112

1290: p_shipment_line_id => r_base_trx.shipment_line_id,
1291: p_transaction_id => r_trx.transaction_id,
1292: p_process_message => lv_process_message,
1293: p_process_status => lv_process_status,
1294: p_override => jai_constants.no --File.Sql.35 Added by Ramananda for bug#4530112
1295: );
1296:
1297: IF lv_process_status <> jai_constants.successful THEN
1298: p_process_status := lv_process_status;

Line 1297: IF lv_process_status <> jai_constants.successful THEN

1293: p_process_status => lv_process_status,
1294: p_override => jai_constants.no --File.Sql.35 Added by Ramananda for bug#4530112
1295: );
1296:
1297: IF lv_process_status <> jai_constants.successful THEN
1298: p_process_status := lv_process_status;
1299: p_process_message := lv_process_message;
1300: GOTO EXIT_POINT;
1301: END IF;

Line 1326: IF lv_process_status <> jai_constants.successful THEN

1322: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35
1323: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35
1324: );
1325:
1326: IF lv_process_status <> jai_constants.successful THEN
1327: p_process_status := lv_process_status;
1328: p_process_message := lv_process_message;
1329: GOTO EXIT_POINT;
1330: END IF;

Line 1337: OPEN c_regime(NULL, jai_constants.vat_regime);

1333:
1334: END IF;
1335: --End Added by Ramananda for Bug #4530112
1336:
1337: OPEN c_regime(NULL, jai_constants.vat_regime);
1338: FETCH c_regime INTO r_regime;
1339: CLOSE c_regime;
1340: /* Bug 5243532. Added by Lakshmi Gopalsami
1341: * Removed the commented codes for cursr cur_txn

Line 1358: lv_currency_code := jai_constants.func_curr;

1354: ELSE
1355: lv_reference_10 := 'India Local VAT Entries for Receipt:'||r_trx.receipt_num||'. Transaction Type '||r_trx.transaction_type||' for the Organization code '||lv_organization_code;
1356: END IF;
1357:
1358: lv_currency_code := jai_constants.func_curr;
1359:
1360: IF gv_debug THEN
1361: fnd_file.put_line(fnd_file.log, 'r_base_trx.transaction_type:'||r_base_trx.transaction_type);
1362: END IF;

Line 1376: p_regime_code => jai_constants.vat_regime,

1372: --Populate the lines for quantity and Recoverable amount
1373: insert_rcv_lines(p_shipment_header_id => r_base_trx.shipment_header_id,
1374: p_shipment_line_id => r_base_trx.shipment_line_id,
1375: p_transaction_id => r_trx.transaction_id,
1376: p_regime_code => jai_constants.vat_regime,
1377: p_process_message => lv_process_message,
1378: p_process_status => lv_process_status,
1379: p_simulate_flag => lv_simulate_flag --File.Sql.35 Cbabu
1380: );

Line 1386: IF lv_process_status <> jai_constants.successful THEN

1382: IF gv_debug THEN
1383: fnd_file.put_line(fnd_file.log, '1.1 RECEIVE: After insert_rcv_lines:');
1384: END IF;
1385:
1386: IF lv_process_status <> jai_constants.successful THEN
1387: p_process_status := lv_process_status;
1388: p_process_message := lv_process_message;
1389: GOTO EXIT_POINT;
1390: END IF;

Line 1401: p_override => jai_constants.no --File.Sql.35 Cbabu

1397: p_shipment_line_id => r_base_trx.shipment_line_id,
1398: p_transaction_id => r_trx.transaction_id,
1399: p_process_message => lv_process_message,
1400: p_process_status => lv_process_status,
1401: p_override => jai_constants.no --File.Sql.35 Cbabu
1402: );
1403:
1404: IF lv_process_status <> jai_constants.successful THEN
1405: p_process_status := lv_process_status;

Line 1404: IF lv_process_status <> jai_constants.successful THEN

1400: p_process_status => lv_process_status,
1401: p_override => jai_constants.no --File.Sql.35 Cbabu
1402: );
1403:
1404: IF lv_process_status <> jai_constants.successful THEN
1405: p_process_status := lv_process_status;
1406: p_process_message := lv_process_message;
1407: GOTO EXIT_POINT;
1408: END IF;

Line 1416: IF lv_process_status <> jai_constants.successful THEN

1412: p_process_message => lv_process_message,
1413: p_process_status => lv_process_status
1414: );
1415:
1416: IF lv_process_status <> jai_constants.successful THEN
1417: p_process_status := lv_process_status;
1418: p_process_message := lv_process_message;
1419: GOTO EXIT_POINT;
1420: END IF;

Line 1442: p_override => jai_constants.no --File.Sql.35 Cbabu

1438: p_shipment_line_id => r_base_trx.shipment_line_id,
1439: p_transaction_id => r_trx.transaction_id,
1440: p_process_message => lv_process_message,
1441: p_process_status => lv_process_status,
1442: p_override => jai_constants.no --File.Sql.35 Cbabu
1443: );
1444:
1445: IF lv_process_status <> jai_constants.successful THEN
1446: p_process_status := lv_process_status;

Line 1445: IF lv_process_status <> jai_constants.successful THEN

1441: p_process_status => lv_process_status,
1442: p_override => jai_constants.no --File.Sql.35 Cbabu
1443: );
1444:
1445: IF lv_process_status <> jai_constants.successful THEN
1446: p_process_status := lv_process_status;
1447: p_process_message := lv_process_message;
1448: GOTO EXIT_POINT;
1449: END IF;

Line 1479: IF lv_process_status <> jai_constants.successful THEN

1475: p_invoice_date => r_trx.vat_invoice_date, --TRUNC(SYSDATE),
1476: p_process_status => lv_process_status,
1477: p_process_message => lv_process_message);
1478:
1479: IF lv_process_status <> jai_constants.successful THEN
1480: p_process_status := lv_process_status;
1481: p_process_message := lv_process_message;
1482: GOTO EXIT_POINT;
1483: END IF;

Line 1500: IF lv_process_status <> jai_constants.successful THEN

1496: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1497: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1498: );
1499:
1500: IF lv_process_status <> jai_constants.successful THEN
1501: p_process_status := lv_process_status;
1502: p_process_message := lv_process_message;
1503: GOTO EXIT_POINT;
1504: END IF;

Line 1528: p_override => jai_constants.no --File.Sql.35 Cbabu

1524: p_shipment_line_id => r_base_trx.shipment_line_id,
1525: p_transaction_id => r_trx.transaction_id,
1526: p_process_message => lv_process_message,
1527: p_process_status => lv_process_status,
1528: p_override => jai_constants.no --File.Sql.35 Cbabu
1529: );
1530:
1531: IF lv_process_status <> jai_constants.successful THEN
1532: p_process_status := lv_process_status;

Line 1531: IF lv_process_status <> jai_constants.successful THEN

1527: p_process_status => lv_process_status,
1528: p_override => jai_constants.no --File.Sql.35 Cbabu
1529: );
1530:
1531: IF lv_process_status <> jai_constants.successful THEN
1532: p_process_status := lv_process_status;
1533: p_process_message := lv_process_message;
1534: GOTO EXIT_POINT;
1535: END IF;

Line 1568: IF lv_process_status <> jai_constants.successful THEN

1564: p_process_message => lv_process_message,
1565: p_process_status => lv_process_status
1566: );
1567:
1568: IF lv_process_status <> jai_constants.successful THEN
1569: p_process_status := lv_process_status;
1570: p_process_message := lv_process_message;
1571: GOTO EXIT_POINT;
1572: END IF;

Line 1580: IF lv_process_status <> jai_constants.successful THEN

1576: p_process_message => lv_process_message,
1577: p_process_status => lv_process_status
1578: );
1579:
1580: IF lv_process_status <> jai_constants.successful THEN
1581: p_process_status := lv_process_status;
1582: p_process_message := lv_process_message;
1583: GOTO EXIT_POINT;
1584: END IF;

Line 1605: IF lv_process_status <> jai_constants.successful THEN

1601: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1602: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1603: );
1604:
1605: IF lv_process_status <> jai_constants.successful THEN
1606: p_process_status := lv_process_status;
1607: p_process_message := lv_process_message;
1608: GOTO EXIT_POINT;
1609: END IF;

Line 1631: p_override => jai_constants.no --File.Sql.35 Cbabu

1627: p_shipment_line_id => r_base_trx.shipment_line_id,
1628: p_transaction_id => r_trx.transaction_id,
1629: p_process_message => lv_process_message,
1630: p_process_status => lv_process_status,
1631: p_override => jai_constants.no --File.Sql.35 Cbabu
1632: );
1633:
1634: IF lv_process_status <> jai_constants.successful THEN
1635: p_process_status := lv_process_status;

Line 1634: IF lv_process_status <> jai_constants.successful THEN

1630: p_process_status => lv_process_status,
1631: p_override => jai_constants.no --File.Sql.35 Cbabu
1632: );
1633:
1634: IF lv_process_status <> jai_constants.successful THEN
1635: p_process_status := lv_process_status;
1636: p_process_message := lv_process_message;
1637: GOTO EXIT_POINT;
1638: END IF;

Line 1674: IF lv_process_status <> jai_constants.successful THEN

1670: p_invoice_date => TRUNC(SYSDATE),
1671: p_process_status => lv_process_status,
1672: p_process_message => lv_process_message);
1673:
1674: IF lv_process_status <> jai_constants.successful THEN
1675: p_process_status := lv_process_status;
1676: p_process_message := lv_process_message;
1677: GOTO EXIT_POINT;
1678: END IF;

Line 1693: IF lv_process_status <> jai_constants.successful THEN

1689: p_process_message => lv_process_message,
1690: p_process_status => lv_process_status
1691: );
1692:
1693: IF lv_process_status <> jai_constants.successful THEN
1694: p_process_status := lv_process_status;
1695: p_process_message := lv_process_message;
1696: GOTO EXIT_POINT;
1697: END IF;

Line 1717: IF lv_process_status <> jai_constants.successful THEN

1713: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1714: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1715: );
1716:
1717: IF lv_process_status <> jai_constants.successful THEN
1718: p_process_status := lv_process_status;
1719: p_process_message := lv_process_message;
1720: GOTO EXIT_POINT;
1721: END IF;

Line 1737: p_process_status := jai_constants.unexpected_error;

1733: WHERE transaction_id = p_transaction_id;
1734:
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: p_process_status := jai_constants.unexpected_error;
1738: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
1739: fnd_file.put_line(fnd_file.log, 'PROCESS_VAT ERROR:'||p_process_message);
1740:
1741: END process_vat;

Line 1786: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'

1782: JAI_RGM_DEFINITIONS c
1783: WHERE a.regime_code = c.regime_code
1784: AND c.regime_id = cp_regime_id
1785: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
1786: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'
1787: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'
1788: AND a.organization_id = NVL(cp_organization_id, a.organization_id)
1789: AND a.location_id = NVL(cp_location_id, a.location_id)
1790: AND b.shipment_header_id = NVL(cp_shipment_header_id,b.shipment_header_id)

Line 1787: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'

1783: WHERE a.regime_code = c.regime_code
1784: AND c.regime_id = cp_regime_id
1785: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
1786: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'
1787: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'
1788: AND a.organization_id = NVL(cp_organization_id, a.organization_id)
1789: AND a.location_id = NVL(cp_location_id, a.location_id)
1790: AND b.shipment_header_id = NVL(cp_shipment_header_id,b.shipment_header_id)
1791: AND b.shipment_line_id = NVL(cp_shipment_line_id, b.shipment_line_id)

Line 1870: p_process_status := jai_constants.successful;

1866: ld_excise_invoice_Date DATE;
1867: /*bduvarag Bug 5899383 End*/
1868: BEGIN
1869:
1870: p_process_status := jai_constants.successful;
1871: p_process_message := NULL;
1872:
1873: /* File.Sql.35 by Brathod */
1874: lv_account_nature := 'VAT CLAIM';

Line 1931: pv_regime_code => jai_constants.vat_regime,

1927: WHERE transaction_id = r_vat_invoice.transaction_id;
1928: END IF;
1929: /*bduvarag Bug 5899383 start*/
1930: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
1931: pv_regime_code => jai_constants.vat_regime,
1932: pv_organization_type => jai_constants.orgn_type_io,
1933: pn_organization_id => rec_claims.organization_id,
1934: pn_location_id => rec_claims.location_id,
1935: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',

Line 1932: pv_organization_type => jai_constants.orgn_type_io,

1928: END IF;
1929: /*bduvarag Bug 5899383 start*/
1930: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
1931: pv_regime_code => jai_constants.vat_regime,
1932: pv_organization_type => jai_constants.orgn_type_io,
1933: pn_organization_id => rec_claims.organization_id,
1934: pn_location_id => rec_claims.location_id,
1935: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
1936: pv_attribute_type_code => NULL,

Line 1935: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',

1931: pv_regime_code => jai_constants.vat_regime,
1932: pv_organization_type => jai_constants.orgn_type_io,
1933: pn_organization_id => rec_claims.organization_id,
1934: pn_location_id => rec_claims.location_id,
1935: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
1936: pv_attribute_type_code => NULL,
1937: pv_attribute_code => 'DEFAULT_INVOICE_DETAILS' ); --'DEFAULT_INVOICE_DETAILS');
1938: If upper(lv_default_invoice_setup) in ( 'Y', 'YES') then
1939:

Line 1986: lv_currency_code := jai_constants.func_curr;

1982: fnd_file.put_line(fnd_file.log, 'Before Start of Accounting');
1983: END IF;
1984:
1985: --Accounting
1986: lv_currency_code := jai_constants.func_curr;
1987:
1988: --for Balancing Accountid for register entry
1989: ln_interim_recovery_account :=
1990: jai_cmn_rgm_recording_pkg.get_account(

Line 1992: p_organization_type => jai_constants.orgn_type_io,

1988: --for Balancing Accountid for register entry
1989: ln_interim_recovery_account :=
1990: jai_cmn_rgm_recording_pkg.get_account(
1991: p_regime_id => r_regime.regime_id,
1992: p_organization_type => jai_constants.orgn_type_io,
1993: p_organization_id => rec_claims.organization_id,
1994: p_location_id => rec_claims.location_id,
1995: p_tax_type => rec_claims.tax_type,
1996: p_account_name => jai_constants.recovery_interim);

Line 1996: p_account_name => jai_constants.recovery_interim);

1992: p_organization_type => jai_constants.orgn_type_io,
1993: p_organization_id => rec_claims.organization_id,
1994: p_location_id => rec_claims.location_id,
1995: p_tax_type => rec_claims.tax_type,
1996: p_account_name => jai_constants.recovery_interim);
1997:
1998: IF ln_interim_recovery_account IS NULL THEN
1999: p_process_status := jai_constants.expected_error;
2000: p_process_message := 'Interim recovery Account not defined in VAT Setup';

Line 1999: p_process_status := jai_constants.expected_error;

1995: p_tax_type => rec_claims.tax_type,
1996: p_account_name => jai_constants.recovery_interim);
1997:
1998: IF ln_interim_recovery_account IS NULL THEN
1999: p_process_status := jai_constants.expected_error;
2000: p_process_message := 'Interim recovery Account not defined in VAT Setup';
2001: RETURN;
2002: END IF;
2003:

Line 2007: p_organization_type => jai_constants.orgn_type_io,

2003:
2004: ln_code_combination_id :=
2005: jai_cmn_rgm_recording_pkg.get_account(
2006: p_regime_id => r_regime.regime_id,
2007: p_organization_type => jai_constants.orgn_type_io,
2008: p_organization_id => rec_claims.organization_id,
2009: p_location_id => rec_claims.location_id,
2010: p_tax_type => rec_claims.tax_type,
2011: p_account_name => jai_constants.recovery);

Line 2011: p_account_name => jai_constants.recovery);

2007: p_organization_type => jai_constants.orgn_type_io,
2008: p_organization_id => rec_claims.organization_id,
2009: p_location_id => rec_claims.location_id,
2010: p_tax_type => rec_claims.tax_type,
2011: p_account_name => jai_constants.recovery);
2012:
2013: IF ln_code_combination_id IS NULL THEN
2014: p_process_status := jai_constants.expected_error;
2015: p_process_message := 'Recovery Account not defined in VAT Setup';

Line 2014: p_process_status := jai_constants.expected_error;

2010: p_tax_type => rec_claims.tax_type,
2011: p_account_name => jai_constants.recovery);
2012:
2013: IF ln_code_combination_id IS NULL THEN
2014: p_process_status := jai_constants.expected_error;
2015: p_process_message := 'Recovery Account not defined in VAT Setup';
2016: RETURN;
2017: END IF;
2018:

Line 2027: lv_account_name := jai_constants.recovery;

2023: ln_entered_dr := ln_entered_cr*-1;
2024: ln_entered_cr := NULL;
2025: END IF;
2026:
2027: lv_account_name := jai_constants.recovery;
2028: /*
2029: IF p_called_from = 'RETURN TO VENDOR' THEN
2030: lv_source_trx_type := 'VAT CLAIM for RTV';
2031: ELSIF p_called_from = 'CORRECT OF RETURN TO VENDOR' THEN

Line 2066: pv_organization_type => jai_constants.orgn_type_io,

2062: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2063: pn_repository_id => ln_repository_id,
2064: pn_regime_id => r_regime.regime_id,
2065: pv_tax_type => rec_claims.tax_type,
2066: pv_organization_type => jai_constants.orgn_type_io,
2067: pn_organization_id => rec_claims.organization_id,
2068: pn_location_id => rec_claims.location_id,
2069: pv_source => jai_constants.source_rcv,
2070: pv_source_trx_type => lv_source_trx_type,

Line 2069: pv_source => jai_constants.source_rcv,

2065: pv_tax_type => rec_claims.tax_type,
2066: pv_organization_type => jai_constants.orgn_type_io,
2067: pn_organization_id => rec_claims.organization_id,
2068: pn_location_id => rec_claims.location_id,
2069: pv_source => jai_constants.source_rcv,
2070: pv_source_trx_type => lv_source_trx_type,
2071: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
2072: pn_source_id => nvl(r_vat_invoice.tax_transaction_id, r_vat_invoice.transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay */
2073: pd_transaction_date => trunc(sysdate),

Line 2102: IF lv_process_status <> jai_constants.successful THEN

2098: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
2099: END IF;
2100:
2101:
2102: IF lv_process_status <> jai_constants.successful THEN
2103: p_process_status := lv_process_status;
2104: p_process_message := lv_process_message;
2105: RETURN;
2106: END IF;

Line 2142: IF lv_process_status <> jai_constants.successful THEN

2138: p_process_status => lv_process_status,
2139: p_reference_name => 'JAI_RCV_RGM_CLAIMS',
2140: p_reference_id => r_claim_schedule.claim_schedule_id);
2141:
2142: IF lv_process_status <> jai_constants.successful THEN
2143: p_process_status := lv_process_status;
2144: p_process_message := lv_process_message;
2145: RETURN;
2146: END IF;

Line 2154: p_organization_type => jai_constants.orgn_type_io,

2150: -- Cr Vat Interim
2151: ln_code_combination_id :=
2152: jai_cmn_rgm_recording_pkg.get_account(
2153: p_regime_id => r_regime.regime_id,
2154: p_organization_type => jai_constants.orgn_type_io,
2155: p_organization_id => rec_claims.organization_id,
2156: p_location_id => rec_claims.location_id,
2157: p_tax_type => rec_claims.tax_type,
2158: p_account_name => jai_constants.recovery_interim);

Line 2158: p_account_name => jai_constants.recovery_interim);

2154: p_organization_type => jai_constants.orgn_type_io,
2155: p_organization_id => rec_claims.organization_id,
2156: p_location_id => rec_claims.location_id,
2157: p_tax_type => rec_claims.tax_type,
2158: p_account_name => jai_constants.recovery_interim);
2159:
2160: IF ln_interim_recovery_account IS NULL THEN
2161: p_process_status := jai_constants.expected_error;
2162: p_process_message := 'Interim recovery Account not defined in VAT Setup';

Line 2161: p_process_status := jai_constants.expected_error;

2157: p_tax_type => rec_claims.tax_type,
2158: p_account_name => jai_constants.recovery_interim);
2159:
2160: IF ln_interim_recovery_account IS NULL THEN
2161: p_process_status := jai_constants.expected_error;
2162: p_process_message := 'Interim recovery Account not defined in VAT Setup';
2163: RETURN;
2164: END IF;
2165: */

Line 2195: IF lv_process_status <> jai_constants.successful THEN

2191: p_process_status => lv_process_status,
2192: p_reference_name => 'JAI_RCV_RGM_CLAIMS',
2193: p_reference_id => r_claim_schedule.claim_schedule_id);
2194:
2195: IF lv_process_status <> jai_constants.successful THEN
2196: p_process_status := lv_process_status;
2197: p_process_message := lv_process_message;
2198: RETURN;
2199: END IF;

Line 2226: IF lv_process_status <> jai_constants.successful THEN

2222: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
2223: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
2224: );
2225:
2226: IF lv_process_status <> jai_constants.successful THEN
2227: p_process_status := lv_process_status;
2228: p_process_message := lv_process_message;
2229: RETURN;
2230: END IF;

Line 2238: p_process_status := jai_constants.unexpected_error;

2234: END LOOP;
2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: p_process_status := jai_constants.unexpected_error;
2239: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.process_claim Error:'||SQLERRM,1,200);
2240: END process_claim;
2241:
2242: /*PROCEDURE process_no_claim(

Line 2300: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'

2296: JAI_RGM_DEFINITIONS c
2297: WHERE a.regime_code = c.regime_code
2298: AND c.regime_id = cp_regime_id
2299: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
2300: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'
2301: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'
2302: AND a.organization_id = NVL(cp_organization_id, a.organization_id)
2303: AND a.location_id = NVL(cp_location_id, a.location_id)
2304: AND b.shipment_header_id = NVL(cp_shipment_header_id,b.shipment_header_id)

Line 2301: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'

2297: WHERE a.regime_code = c.regime_code
2298: AND c.regime_id = cp_regime_id
2299: AND a.attribute_value = NVL(cp_regime_regno, a.attribute_value)
2300: AND a.attribute_type_code = jai_constants.rgm_attr_type_code_primary --'PRIMARY'
2301: AND a.attribute_code = jai_constants.attr_code_regn_no --'REGISTRATION_NO'
2302: AND a.organization_id = NVL(cp_organization_id, a.organization_id)
2303: AND a.location_id = NVL(cp_location_id, a.location_id)
2304: AND b.shipment_header_id = NVL(cp_shipment_header_id,b.shipment_header_id)
2305: AND b.shipment_line_id = NVL(cp_shipment_line_id, b.shipment_line_id)

Line 2317: /Added by Nitin for Bug # 6681800 / SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount(rtl.mod_cr_percentage/100), jtl.tax_amount(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount

2313: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2314: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2315: IS
2316: SELECT jtl.tax_type,
2317: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount
2318: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2320: WHERE jtl.transaction_id = cp_transaction_id
2321: AND jtl.tax_type in (select tax_type

Line 2318: /Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amountcp_currency_conversion_rate)) tax_amount*/

2314: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2315: IS
2316: SELECT jtl.tax_type,
2317: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount
2318: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/
2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2320: WHERE jtl.transaction_id = cp_transaction_id
2321: AND jtl.tax_type in (select tax_type
2322: from jai_regime_tax_types_v

Line 2323: where regime_code = jai_constants.vat_regime)

2319: FROM JAI_RCV_LINE_TAXES jtl ,JAI_CMN_TAXES_ALL rtl /* Need to have join with JAI_CMN_TAXES_ALL*/
2320: WHERE jtl.transaction_id = cp_transaction_id
2321: AND jtl.tax_type in (select tax_type
2322: from jai_regime_tax_types_v
2323: where regime_code = jai_constants.vat_regime)
2324: AND NVL(jtl.modvat_flag,'N') = 'Y'
2325: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2326: GROUP BY jtl.tax_type;
2327:

Line 2331: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /Added by Nitin for bug # 6681800/a.tax_amount(b.mod_cr_percentage/100), a.tax_amount(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount

2327:
2328: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2329: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2330: IS
2331: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2332: FROM JAI_RCV_LINE_TAXES a,
2333: JAI_CMN_TAXES_ALL b
2334: WHERE a.transaction_id = cp_transaction_id
2335: AND a.tax_type in (select tax_type

Line 2337: where regime_code = jai_constants.vat_regime)

2333: JAI_CMN_TAXES_ALL b
2334: WHERE a.transaction_id = cp_transaction_id
2335: AND a.tax_type in (select tax_type
2336: from jai_regime_tax_types_v
2337: where regime_code = jai_constants.vat_regime)
2338: AND a.tax_id = b.tax_id
2339: AND NVL(a.modvat_flag,'N') = 'Y';
2340:
2341: CURSOR c_receive_transaction(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 2448: p_process_status := jai_constants.successful;

2444: lv_reference_26 := 'transaction_id';
2445: lv_destination := 'G';
2446: /* End of File.Sql.35 by Brathod */
2447:
2448: p_process_status := jai_constants.successful;
2449: p_process_message := NULL;
2450:
2451:
2452: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');

Line 2454: OPEN c_regime(NULL, jai_constants.vat_regime);

2450:
2451:
2452: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2453:
2454: OPEN c_regime(NULL, jai_constants.vat_regime);
2455: FETCH c_regime INTO r_regime;
2456: CLOSE c_regime;
2457:
2458: /*FOR r_shipment_lines IN c_shipment_lines(p_shipment_header_id,

Line 2499: lv_currency_code := jai_constants.func_curr;

2495: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(r_receive_correct_txns.transaction_id);
2496:
2497: FOR rec_tax IN cur_tax(r_receive_transaction.transaction_id, r_receive_transaction.currency_conversion_rate)
2498: LOOP
2499: lv_currency_code := jai_constants.func_curr;
2500:
2501: --DR Inventory Receiving
2502: ln_code_combination_id := r_rcv_parameters.receiving_account_id;
2503:

Line 2532: IF lv_process_status <> jai_constants.successful THEN

2528: p_process_status => lv_process_status,
2529: p_reference_name => rec_tax.tax_type,
2530: p_reference_id => NULL);
2531:
2532: IF lv_process_status <> jai_constants.successful THEN
2533: p_process_status := lv_process_status;
2534: p_process_message := lv_process_message;
2535: RETURN;
2536: END IF;

Line 2543: p_organization_type => jai_constants.orgn_type_io,

2539: --CR VAT Interrim
2540: ln_code_combination_id :=
2541: jai_cmn_rgm_recording_pkg.get_account(
2542: p_regime_id => r_regime.regime_id,
2543: p_organization_type => jai_constants.orgn_type_io,
2544: p_organization_id => r_receive_transaction.organization_id,
2545: p_location_id => r_receive_transaction.location_id,
2546: p_tax_type => rec_tax.tax_type,
2547: p_account_name => jai_constants.recovery_interim);

Line 2547: p_account_name => jai_constants.recovery_interim);

2543: p_organization_type => jai_constants.orgn_type_io,
2544: p_organization_id => r_receive_transaction.organization_id,
2545: p_location_id => r_receive_transaction.location_id,
2546: p_tax_type => rec_tax.tax_type,
2547: p_account_name => jai_constants.recovery_interim);
2548:
2549: ln_entered_dr := NULL;
2550: ln_entered_cr := rec_tax.tax_amount*ln_apportion_factor;
2551:

Line 2577: IF lv_process_status <> jai_constants.successful THEN

2573: p_process_status => lv_process_status,
2574: p_reference_name => rec_tax.tax_type,
2575: p_reference_id => NULL);
2576:
2577: IF lv_process_status <> jai_constants.successful THEN
2578: p_process_status := lv_process_status;
2579: p_process_message := lv_process_message;
2580: RETURN;
2581: END IF;

Line 2623: p_simulate => jai_constants.no,

2619: END IF;
2620:
2621: jai_rcv_deliver_rtr_pkg.process_transaction(
2622: p_transaction_id => r_deliver_rtr_txns.transaction_id,
2623: p_simulate => jai_constants.no,
2624: p_codepath => lv_code_path,
2625: p_process_message => lv_process_message,
2626: p_process_status => lv_process_status,
2627: p_process_special_source => jai_constants.vat_noclaim,

Line 2627: p_process_special_source => jai_constants.vat_noclaim,

2623: p_simulate => jai_constants.no,
2624: p_codepath => lv_code_path,
2625: p_process_message => lv_process_message,
2626: p_process_status => lv_process_status,
2627: p_process_special_source => jai_constants.vat_noclaim,
2628: p_process_special_amount => ln_process_special_amount);
2629:
2630:
2631: IF lv_process_status = 'E' THEN

Line 2632: p_process_status := jai_constants.expected_error;

2628: p_process_special_amount => ln_process_special_amount);
2629:
2630:
2631: IF lv_process_status = 'E' THEN
2632: p_process_status := jai_constants.expected_error;
2633: p_process_message := lv_process_message;
2634: RETURN;
2635: END IF;
2636:

Line 2648: where regime_code = jai_constants.vat_regime)

2644: WHERE shipment_header_id = r_shipment_lines.shipment_header_id
2645: AND shipment_line_id = r_shipment_lines.shipment_line_id
2646: AND tax_type IN (select tax_type
2647: from jai_regime_tax_types_v
2648: where regime_code = jai_constants.vat_regime)
2649: AND modvat_flag = 'Y';
2650:
2651: --To update the Status, so that It should not be considered for claiming
2652: UPDATE jai_rcv_rgm_lines

Line 2669: p_process_status := jai_constants.unexpected_error;

2665:
2666: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2667: EXCEPTION
2668: WHEN OTHERS THEN
2669: p_process_status := jai_constants.unexpected_error;
2670: p_process_message := SUBSTR(SQLERRM,1,200);
2671: END process_no_claim;
2672:
2673: PROCEDURE process_batch(

Line 2721: IF r_regime.regime_code <> jai_constants.vat_regime THEN

2717: OPEN c_regime(p_regime_id, NULL);
2718: FETCH c_regime INTO r_regime;
2719: CLOSE c_regime;
2720:
2721: IF r_regime.regime_code <> jai_constants.vat_regime THEN
2722: errbuf := 'This program is for VAT Regime Only';
2723: retcode := jai_constants.request_error;
2724: RETURN;
2725: END IF;

Line 2723: retcode := jai_constants.request_error;

2719: CLOSE c_regime;
2720:
2721: IF r_regime.regime_code <> jai_constants.vat_regime THEN
2722: errbuf := 'This program is for VAT Regime Only';
2723: retcode := jai_constants.request_error;
2724: RETURN;
2725: END IF;
2726:
2727: --commented the below for Bug#4950914

Line 2730: retcode := jai_constants.request_error;

2726:
2727: --commented the below for Bug#4950914
2728: /*IF p_batch_id IS NULL AND p_shipment_header_id IS NULL AND p_shipment_line_id IS NULL THEN
2729: errbuf := 'Invalid Parameters Passed';
2730: retcode := jai_constants.request_error;
2731: RETURN;
2732: END IF;*/
2733:
2734: lv_codepath := jai_general_pkg.plot_codepath(2, lv_codepath);

Line 2750: IF lv_process_status <> jai_constants.successful THEN

2746: p_called_from => p_called_from,
2747: p_process_status => lv_process_status,
2748: p_process_message => lv_process_message);
2749:
2750: IF lv_process_status <> jai_constants.successful THEN
2751: retcode := jai_constants.request_error;
2752: errbuf := lv_process_message;
2753: RETURN;
2754: END IF;

Line 2751: retcode := jai_constants.request_error;

2747: p_process_status => lv_process_status,
2748: p_process_message => lv_process_message);
2749:
2750: IF lv_process_status <> jai_constants.successful THEN
2751: retcode := jai_constants.request_error;
2752: errbuf := lv_process_message;
2753: RETURN;
2754: END IF;
2755:

Line 2771: IF lv_process_status <> jai_constants.successful THEN

2767: p_process_status => lv_process_status,
2768: p_process_message => lv_process_message);
2769:
2770:
2771: IF lv_process_status <> jai_constants.successful THEN
2772: retcode := jai_constants.request_error;
2773: errbuf := lv_process_message;
2774: RETURN;
2775: END IF;

Line 2772: retcode := jai_constants.request_error;

2768: p_process_message => lv_process_message);
2769:
2770:
2771: IF lv_process_status <> jai_constants.successful THEN
2772: retcode := jai_constants.request_error;
2773: errbuf := lv_process_message;
2774: RETURN;
2775: END IF;
2776:

Line 2912: p_process_status := jai_constants.successful;

2908: lv_destination := 'G';
2909: /* End of File.Sql.35 by Brathod */
2910:
2911: ln_statement_id := 100;
2912: p_process_status := jai_constants.successful;
2913: p_process_message := NULL;
2914:
2915: OPEN c_regime(NULL, jai_constants.vat_regime);
2916: FETCH c_regime INTO r_regime;

Line 2915: OPEN c_regime(NULL, jai_constants.vat_regime);

2911: ln_statement_id := 100;
2912: p_process_status := jai_constants.successful;
2913: p_process_message := NULL;
2914:
2915: OPEN c_regime(NULL, jai_constants.vat_regime);
2916: FETCH c_regime INTO r_regime;
2917: CLOSE c_regime;
2918:
2919: OPEN c_min_installment_no(p_shipment_header_id, p_shipment_line_id, 'RECEIVE');

Line 2928: lv_currency_code := jai_constants.func_curr;

2924: OPEN c_trx(p_transaction_id);
2925: FETCH c_trx INTO r_trx;
2926: CLOSE c_trx;
2927:
2928: lv_currency_code := jai_constants.func_curr;
2929:
2930: ln_statement_id := 101;
2931: FOR rec_taxes IN c_total_vat_amount(p_transaction_id)
2932: LOOP

Line 2951: p_organization_type => jai_constants.orgn_type_io,

2947: ln_statement_id := 102.2;
2948: ln_rec_ccid :=
2949: jai_cmn_rgm_recording_pkg.get_account(
2950: p_regime_id => r_regime.regime_id,
2951: p_organization_type => jai_constants.orgn_type_io,
2952: p_organization_id => rec_taxes.organization_id,
2953: p_location_id => rec_taxes.location_id,
2954: p_tax_type => rec_taxes.tax_type,
2955: p_account_name => jai_constants.recovery);

Line 2955: p_account_name => jai_constants.recovery);

2951: p_organization_type => jai_constants.orgn_type_io,
2952: p_organization_id => rec_taxes.organization_id,
2953: p_location_id => rec_taxes.location_id,
2954: p_tax_type => rec_taxes.tax_type,
2955: p_account_name => jai_constants.recovery);
2956:
2957: IF ln_rec_ccid IS NULL THEN
2958: p_process_status := jai_constants.expected_error;
2959: p_process_message := 'Recovery Account not defined in VAT Setup';

Line 2958: p_process_status := jai_constants.expected_error;

2954: p_tax_type => rec_taxes.tax_type,
2955: p_account_name => jai_constants.recovery);
2956:
2957: IF ln_rec_ccid IS NULL THEN
2958: p_process_status := jai_constants.expected_error;
2959: p_process_message := 'Recovery Account not defined in VAT Setup';
2960: RETURN;
2961: END IF;
2962:

Line 2967: p_organization_type => jai_constants.orgn_type_io,

2963: ln_statement_id := 102.3;
2964: ln_int_ccid :=
2965: jai_cmn_rgm_recording_pkg.get_account(
2966: p_regime_id => r_regime.regime_id,
2967: p_organization_type => jai_constants.orgn_type_io,
2968: p_organization_id => rec_taxes.organization_id,
2969: p_location_id => rec_taxes.location_id,
2970: p_tax_type => rec_taxes.tax_type,
2971: p_account_name => jai_constants.recovery_interim);

Line 2971: p_account_name => jai_constants.recovery_interim);

2967: p_organization_type => jai_constants.orgn_type_io,
2968: p_organization_id => rec_taxes.organization_id,
2969: p_location_id => rec_taxes.location_id,
2970: p_tax_type => rec_taxes.tax_type,
2971: p_account_name => jai_constants.recovery_interim);
2972:
2973: IF ln_int_ccid IS NULL THEN
2974: p_process_status := jai_constants.expected_error;
2975: p_process_message := 'Internal Recovery Account not defined in VAT Setup';

Line 2974: p_process_status := jai_constants.expected_error;

2970: p_tax_type => rec_taxes.tax_type,
2971: p_account_name => jai_constants.recovery_interim);
2972:
2973: IF ln_int_ccid IS NULL THEN
2974: p_process_status := jai_constants.expected_error;
2975: p_process_message := 'Internal Recovery Account not defined in VAT Setup';
2976: RETURN;
2977: END IF;
2978:

Line 3010: IF lv_process_status <> jai_constants.successful THEN

3006: p_process_status => lv_process_status,
3007: p_reference_name => rec_taxes.tax_type||'1',
3008: p_reference_id => NULL);
3009:
3010: IF lv_process_status <> jai_constants.successful THEN
3011: p_process_status := lv_process_status;
3012: p_process_message := lv_process_message;
3013: RETURN;
3014: END IF;

Line 3046: IF lv_process_status <> jai_constants.successful THEN

3042: p_process_status => lv_process_status,
3043: p_reference_name => rec_taxes.tax_type||'1',
3044: p_reference_id => NULL);
3045:
3046: IF lv_process_status <> jai_constants.successful THEN
3047: p_process_status := lv_process_status;
3048: p_process_message := lv_process_message;
3049: RETURN;
3050: END IF;

Line 3083: IF lv_process_status <> jai_constants.successful THEN

3079: p_process_status => lv_process_status,
3080: p_reference_name => rec_taxes.tax_type||'2',
3081: p_reference_id => NULL);
3082:
3083: IF lv_process_status <> jai_constants.successful THEN
3084: p_process_status := lv_process_status;
3085: p_process_message := lv_process_message;
3086: RETURN;
3087: END IF;

Line 3119: IF lv_process_status <> jai_constants.successful THEN

3115: p_process_status => lv_process_status,
3116: p_reference_name => rec_taxes.tax_type||'2',
3117: p_reference_id => NULL);
3118:
3119: IF lv_process_status <> jai_constants.successful THEN
3120: p_process_status := lv_process_status;
3121: p_process_message := lv_process_message;
3122: RETURN;
3123: END IF;

Line 3143: pv_organization_type => jai_constants.orgn_type_io,

3139: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
3140: pn_repository_id => ln_repository_id,
3141: pn_regime_id => r_regime.regime_id,
3142: pv_tax_type => rec_taxes.tax_type,
3143: pv_organization_type => jai_constants.orgn_type_io,
3144: pn_organization_id => rec_taxes.organization_id,
3145: pn_location_id => rec_taxes.location_id,
3146: pv_source => jai_constants.source_rcv,
3147: pv_source_trx_type => 'VAT CLAIM',

Line 3146: pv_source => jai_constants.source_rcv,

3142: pv_tax_type => rec_taxes.tax_type,
3143: pv_organization_type => jai_constants.orgn_type_io,
3144: pn_organization_id => rec_taxes.organization_id,
3145: pn_location_id => rec_taxes.location_id,
3146: pv_source => jai_constants.source_rcv,
3147: pv_source_trx_type => 'VAT CLAIM',
3148: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3149: pn_source_id => p_transaction_id, /* r_claim_schedule.claim_schedule_id, Vijay */
3150: pd_transaction_date => trunc(sysdate),

Line 3151: pv_account_name => jai_constants.recovery,

3147: pv_source_trx_type => 'VAT CLAIM',
3148: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3149: pn_source_id => p_transaction_id, /* r_claim_schedule.claim_schedule_id, Vijay */
3150: pd_transaction_date => trunc(sysdate),
3151: pv_account_name => jai_constants.recovery,
3152: pn_charge_account_id => ln_rec_ccid,
3153: pn_balancing_account_id => ln_int_ccid,
3154: pn_credit_amount => ln_entered_cr,
3155: pn_debit_amount => ln_entered_dr,

Line 3178: IF lv_process_status <> jai_constants.successful THEN

3174: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3175: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3176: END IF;
3177:
3178: IF lv_process_status <> jai_constants.successful THEN
3179: p_process_status := lv_process_status;
3180: p_process_message := lv_process_message;
3181: RETURN;
3182: END IF;

Line 3203: pv_organization_type => jai_constants.orgn_type_io,

3199: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
3200: pn_repository_id => ln_repository_id,
3201: pn_regime_id => r_regime.regime_id,
3202: pv_tax_type => rec_taxes.tax_type,
3203: pv_organization_type => jai_constants.orgn_type_io,
3204: pn_organization_id => rec_taxes.organization_id,
3205: pn_location_id => rec_taxes.location_id,
3206: pv_source => jai_constants.source_rcv,
3207: pv_source_trx_type => 'VAT CLAIM for RTV',

Line 3206: pv_source => jai_constants.source_rcv,

3202: pv_tax_type => rec_taxes.tax_type,
3203: pv_organization_type => jai_constants.orgn_type_io,
3204: pn_organization_id => rec_taxes.organization_id,
3205: pn_location_id => rec_taxes.location_id,
3206: pv_source => jai_constants.source_rcv,
3207: pv_source_trx_type => 'VAT CLAIM for RTV',
3208: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3209: pn_source_id => nvl(r_trx.tax_transaction_id, p_transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay*/
3210: pd_transaction_date => TRUNC(SYSDATE),

Line 3211: pv_account_name => jai_constants.recovery,

3207: pv_source_trx_type => 'VAT CLAIM for RTV',
3208: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3209: pn_source_id => nvl(r_trx.tax_transaction_id, p_transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay*/
3210: pd_transaction_date => TRUNC(SYSDATE),
3211: pv_account_name => jai_constants.recovery,
3212: pn_charge_account_id => ln_rec_ccid,
3213: pn_balancing_account_id => ln_int_ccid,
3214: pn_credit_amount => ln_entered_cr,
3215: pn_debit_amount => ln_entered_dr,

Line 3239: IF lv_process_status <> jai_constants.successful THEN

3235: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3236: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3237: END IF;
3238:
3239: IF lv_process_status <> jai_constants.successful THEN
3240: p_process_status := lv_process_status;
3241: p_process_message := lv_process_message;
3242: RETURN;
3243: END IF;

Line 3261: p_process_status := jai_constants.unexpected_error;

3257: AND status = 'N';
3258:
3259: EXCEPTION
3260: WHEN OTHERS THEN
3261: p_process_status := jai_constants.unexpected_error;
3262: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
3263: END do_rtv_accounting;
3264:
3265: PROCEDURE do_rma_accounting(

Line 3275: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount(b.mod_cr_percentage/100), a.tax_amount(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount

3271: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
3272: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3273: IS
3274: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3275: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount
3276: FROM JAI_RCV_LINE_TAXES a,
3277: JAI_CMN_TAXES_ALL b
3278: WHERE a.transaction_id = cp_transaction_id
3279: AND a.tax_type in (select tax_type

Line 3281: where regime_code = jai_constants.vat_regime)

3277: JAI_CMN_TAXES_ALL b
3278: WHERE a.transaction_id = cp_transaction_id
3279: AND a.tax_type in (select tax_type
3280: from jai_regime_tax_types_v
3281: where regime_code = jai_constants.vat_regime)
3282: AND NVL(a.modvat_flag,'N') = 'Y'
3283: AND a.tax_id = b.tax_id
3284: GROUP BY a.tax_type;
3285:

Line 3342: p_process_status := jai_constants.successful;

3338: lv_reference_26 := 'transaction_id';
3339: lv_destination := 'G';
3340: /* End of File.Sql.35 by Brathod */
3341:
3342: p_process_status := jai_constants.successful;
3343: p_process_message := NULL;
3344:
3345: OPEN c_trx(p_transaction_id);
3346: FETCH c_trx INTO r_trx;

Line 3349: OPEN c_regime(NULL, jai_constants.vat_regime);

3345: OPEN c_trx(p_transaction_id);
3346: FETCH c_trx INTO r_trx;
3347: CLOSE c_trx;
3348:
3349: OPEN c_regime(NULL, jai_constants.vat_regime);
3350: FETCH c_regime INTO r_regime;
3351: CLOSE c_regime;
3352:
3353: ld_accounting_date := trunc(r_trx.transaction_date);

Line 3354: lv_currency_code := jai_constants.func_curr;

3350: FETCH c_regime INTO r_regime;
3351: CLOSE c_regime;
3352:
3353: ld_accounting_date := trunc(r_trx.transaction_date);
3354: lv_currency_code := jai_constants.func_curr;
3355: lv_reference_10 := 'India Local VAT RMA Entries for Receipt:'||r_trx.receipt_num
3356: ||'. Transaction Type '||r_trx.transaction_type;
3357:
3358: if r_trx.transaction_type = 'CORRECT' then

Line 3384: p_organization_type => jai_constants.orgn_type_io,

3380:
3381: ln_debit_ccid :=
3382: jai_cmn_rgm_recording_pkg.get_account(
3383: p_regime_id => r_regime.regime_id,
3384: p_organization_type => jai_constants.orgn_type_io,
3385: p_organization_id => r_trx.organization_id,
3386: p_location_id => r_trx.location_id,
3387: p_tax_type => rec_tax.tax_type,
3388: p_account_name => jai_constants.recovery_interim);

Line 3388: p_account_name => jai_constants.recovery_interim);

3384: p_organization_type => jai_constants.orgn_type_io,
3385: p_organization_id => r_trx.organization_id,
3386: p_location_id => r_trx.location_id,
3387: p_tax_type => rec_tax.tax_type,
3388: p_account_name => jai_constants.recovery_interim);
3389:
3390: IF ln_debit_ccid IS NULL THEN
3391: p_process_status := jai_constants.expected_error;
3392: p_process_message := 'Interim recovery Account not defined in VAT Setup';

Line 3391: p_process_status := jai_constants.expected_error;

3387: p_tax_type => rec_tax.tax_type,
3388: p_account_name => jai_constants.recovery_interim);
3389:
3390: IF ln_debit_ccid IS NULL THEN
3391: p_process_status := jai_constants.expected_error;
3392: p_process_message := 'Interim recovery Account not defined in VAT Setup';
3393: RETURN;
3394: END IF;
3395:

Line 3426: IF lv_process_status <> jai_constants.successful THEN

3422: p_process_status => lv_process_status,
3423: p_reference_name => rec_tax.tax_type,
3424: p_reference_id => NULL);
3425:
3426: IF lv_process_status <> jai_constants.successful THEN
3427: p_process_status := lv_process_status;
3428: p_process_message := lv_process_message;
3429: RETURN;
3430: END IF;

Line 3436: p_organization_type => jai_constants.orgn_type_io,

3432: --CR Interim Liability
3433: ln_credit_ccid :=
3434: jai_cmn_rgm_recording_pkg.get_account(
3435: p_regime_id => r_regime.regime_id,
3436: p_organization_type => jai_constants.orgn_type_io,
3437: p_organization_id => r_trx.organization_id,
3438: p_location_id => r_trx.location_id,
3439: p_tax_type => rec_tax.tax_type,
3440: p_account_name => jai_constants.liability_interim);

Line 3440: p_account_name => jai_constants.liability_interim);

3436: p_organization_type => jai_constants.orgn_type_io,
3437: p_organization_id => r_trx.organization_id,
3438: p_location_id => r_trx.location_id,
3439: p_tax_type => rec_tax.tax_type,
3440: p_account_name => jai_constants.liability_interim);
3441:
3442: IF ln_credit_ccid IS NULL THEN
3443: p_process_status := jai_constants.expected_error;
3444: p_process_message := 'Interim Liability Account not defined in VAT Setup';

Line 3443: p_process_status := jai_constants.expected_error;

3439: p_tax_type => rec_tax.tax_type,
3440: p_account_name => jai_constants.liability_interim);
3441:
3442: IF ln_credit_ccid IS NULL THEN
3443: p_process_status := jai_constants.expected_error;
3444: p_process_message := 'Interim Liability Account not defined in VAT Setup';
3445: RETURN;
3446: END IF;
3447:

Line 3477: IF lv_process_status <> jai_constants.successful THEN

3473: p_process_status => lv_process_status,
3474: p_reference_name => rec_tax.tax_type,
3475: p_reference_id => NULL);
3476:
3477: IF lv_process_status <> jai_constants.successful THEN
3478: p_process_status := lv_process_status;
3479: p_process_message := lv_process_message;
3480: RETURN;
3481: END IF;

Line 3490: p_process_status := jai_constants.unexpected_error;

3486:
3487: END LOOP;
3488: EXCEPTION
3489: WHEN OTHERS THEN
3490: p_process_status := jai_constants.unexpected_error;
3491: p_process_message := SUBSTR(SQLERRM,1,200);
3492: END do_rma_accounting;
3493:
3494: END jai_rcv_rgm_claims_pkg;