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

Line 73: AND a.tax_type in (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess)

69: WHERE a.org_unit_id = b.org_unit_id
70: AND b.organization_id = p_organization_id
71: AND b.location_id = p_location_id
72: AND a.register_type = p_register_type
73: AND a.tax_type in (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess)
74: AND a.tax_type = NVL(p_tax_type,a.tax_type);
75: /*Bug 5989740 bduvarag start*/
76: CURSOR c_sh_oth_balances(p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
77: p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,

Line 88: AND a.tax_type in (jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)

84: WHERE a.org_unit_id = b.org_unit_id
85: AND b.organization_id = p_organization_id
86: AND b.location_id = p_location_id
87: AND a.register_type = p_register_type
88: AND a.tax_type in (jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)
89: AND a.tax_type = NVL(p_tax_type,a.tax_type);
90: /*Bug 5989740 bduvarag end*/
91: CURSOR balances_to_exist IS
92: select count(1)

Line 436: v_tax_type := jai_constants.tax_type_exc_edu_cess;

432: FOR i in 1..4 LOOP/*Bug 5989740 bduvarag*/
433: v_tax_type := NULL;
434: v_cess_amount := 0;
435: IF i = 1 AND p_excise_cess_amount > 0 THEN
436: v_tax_type := jai_constants.tax_type_exc_edu_cess;
437: v_cess_amount := p_excise_cess_amount;
438: ELSIF i = 2 AND p_cvd_cess_amount > 0 THEN
439: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
440: v_cess_amount := p_cvd_cess_amount;

Line 439: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

435: IF i = 1 AND p_excise_cess_amount > 0 THEN
436: v_tax_type := jai_constants.tax_type_exc_edu_cess;
437: v_cess_amount := p_excise_cess_amount;
438: ELSIF i = 2 AND p_cvd_cess_amount > 0 THEN
439: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
440: v_cess_amount := p_cvd_cess_amount;
441: /*Bug 5989740 bduvarag start*/
442: ELSIF i = 3 AND p_sh_exc_cess_amount > 0 THEN
443: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

Line 443: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

439: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
440: v_cess_amount := p_cvd_cess_amount;
441: /*Bug 5989740 bduvarag start*/
442: ELSIF i = 3 AND p_sh_exc_cess_amount > 0 THEN
443: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
444: v_cess_amount := p_sh_exc_cess_amount;
445: ELSIF i = 4 AND p_sh_cvd_cess_amount > 0 THEN
446: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
447: v_cess_amount := p_sh_cvd_cess_amount;

Line 446: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

442: ELSIF i = 3 AND p_sh_exc_cess_amount > 0 THEN
443: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
444: v_cess_amount := p_sh_exc_cess_amount;
445: ELSIF i = 4 AND p_sh_cvd_cess_amount > 0 THEN
446: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
447: v_cess_amount := p_sh_cvd_cess_amount;
448: /*Bug 5989740 bduvarag end*/
449: END IF;
450:

Line 551: p_process_flag := jai_constants.unexpected_error;/Bug 5989740 bduvarag/

547:
548: /* Added by Ramananda for bug#4407165 */
549: EXCEPTION
550: WHEN OTHERS THEN
551: p_process_flag := jai_constants.unexpected_error;/*Bug 5989740 bduvarag*/
552: p_process_message := 'error in insert_rg_others proc ' ||sqlerrm;/*Bug 5989740 bduvarag*/
553:
554: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
555: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );

Line 705: v_source_register := jai_constants.reg_rg23a_2; --Added by Sanjikum for cess for Bug #4136939

701: IF p_register = 'RG23A' THEN
702: v_rg23a_bal := nvl(v_rg23a_bal,0) - nvl(p_amount,0);
703: v_check_amount := v_rg23a_bal;
704: v_register := 'A';
705: v_source_register := jai_constants.reg_rg23a_2; --Added by Sanjikum for cess for Bug #4136939
706: ELSIF p_register = 'RG23C' THEN
707: v_rg23c_bal := nvl(v_rg23c_bal,0) - nvl(p_amount,0);
708: v_check_amount := v_rg23c_bal;
709: v_register := 'C';

Line 710: v_source_register := jai_constants.reg_rg23c_2; --Added by Sanjikum for cess for Bug #4136939

706: ELSIF p_register = 'RG23C' THEN
707: v_rg23c_bal := nvl(v_rg23c_bal,0) - nvl(p_amount,0);
708: v_check_amount := v_rg23c_bal;
709: v_register := 'C';
710: v_source_register := jai_constants.reg_rg23c_2; --Added by Sanjikum for cess for Bug #4136939
711: ELSIF p_register = 'PLA' THEN
712: v_pla_bal := nvl(v_pla_bal,0) - nvl(p_amount,0);
713: v_check_amount := v_pla_bal;
714: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939

Line 714: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939

710: v_source_register := jai_constants.reg_rg23c_2; --Added by Sanjikum for cess for Bug #4136939
711: ELSIF p_register = 'PLA' THEN
712: v_pla_bal := nvl(v_pla_bal,0) - nvl(p_amount,0);
713: v_check_amount := v_pla_bal;
714: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939
715: END IF;
716:
717: IF v_check_amount < 0 THEN
718: RAISE_APPLICATION_ERROR(-20120, 'Amount that you want to transfer will turn your --> ' ||

Line 737: OPEN c_oth_balances(p_organization_id, p_location_id, p_register, jai_constants.tax_type_exc_edu_cess);

733: to_char(p_organization_id) || ' and for location_id '|| to_char(p_location_id));
734: END If;
735:
736: --Get the balance for excise cess
737: OPEN c_oth_balances(p_organization_id, p_location_id, p_register, jai_constants.tax_type_exc_edu_cess);
738: FETCH c_oth_balances INTO v_excise_cess_bal;
739: CLOSE c_oth_balances;
740:
741: IF NVL(p_cess_amount,0) > v_excise_cess_bal THEN

Line 762: OPEN c_sh_oth_balances(p_organization_id, p_location_id, p_register, jai_constants.tax_type_sh_exc_edu_cess);

758: to_char(p_organization_id) || ' and for location_id '|| to_char(p_location_id));
759: END If;
760:
761: --Get the balance for excise cess
762: OPEN c_sh_oth_balances(p_organization_id, p_location_id, p_register, jai_constants.tax_type_sh_exc_edu_cess);
763: FETCH c_sh_oth_balances INTO v_sh_excise_cess_bal;
764: CLOSE c_sh_oth_balances;
765:
766: IF NVL(p_sh_cess_amount,0) > v_sh_excise_cess_bal THEN

Line 887: p_process_flag := jai_constants.expected_error;

883: fetch rg23a_account_cur into lv_to_account_id;
884: close rg23a_account_cur;
885: /*added by JMEENA for bug#7260552, start*/
886: if lv_from_account_id IS NULL OR lv_from_cess_account_id.cess_account_id IS NULL OR lv_from_cess_account_id.sh_cess_account_id IS NULL THEN
887: p_process_flag := jai_constants.expected_error;
888: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Source Organization';
889: return;
890: END IF;
891: /* JMEENA for bug#7260552, end*/

Line 928: p_process_flag := jai_constants.expected_error;

924: fetch rg23c_account_cur into lv_to_account_id;
925: close rg23c_account_cur;
926: /*added by JMEENA for bug#7260552, start*/
927: if lv_from_account_id IS NULL OR lv_from_cess_account_id.cess_account_id IS NULL OR lv_from_cess_account_id.sh_cess_account_id IS NULL THEN
928: p_process_flag := jai_constants.expected_error;
929: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Source Organization';
930: return;
931: END IF;
932: /* JMEENA for bug#7260552, end*/

Line 1028: p_process_flag := jai_constants.expected_error;

1024: fetch pla_account_cur into lv_to_account_id;
1025: close pla_account_cur;
1026: /*added by JMEENA for bug#7260552, start*/
1027: if lv_from_account_id IS NULL THEN
1028: p_process_flag := jai_constants.expected_error;
1029: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Source Organization';
1030: return;
1031: END IF;
1032: /* JMEENA for bug#7260552, end*/

Line 1172: p_process_flag := jai_constants.expected_error;

1168: fetch rg23a_account_cur into lv_to_account_id;
1169: close rg23a_account_cur;
1170: /*added by JMEENA for bug#7260552, start*/
1171: if lv_to_account_id IS NULL OR lv_to_cess_account_id.cess_account_id IS NULL OR lv_to_cess_account_id.sh_cess_account_id IS NULL THEN
1172: p_process_flag := jai_constants.expected_error;
1173: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Destination Organization';
1174: return;
1175: END IF;
1176: /*JMEENA for bug#7260552, end*/

Line 1213: p_process_flag := jai_constants.expected_error;

1209: fetch rg23c_account_cur into lv_to_account_id;
1210: close rg23c_account_cur;
1211: /*added by JMEENA for bug#7260552, start*/
1212: if lv_to_account_id IS NULL OR lv_to_cess_account_id.cess_account_id IS NULL OR lv_to_cess_account_id.sh_cess_account_id IS NULL THEN
1213: p_process_flag := jai_constants.expected_error;
1214: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Destination Organization';
1215: return;
1216: END IF;
1217: /*JMEENA for bug#7260552, end*/

Line 1329: p_process_flag := jai_constants.expected_error;

1325: fetch pla_account_cur into lv_to_account_id;
1326: close pla_account_cur;
1327: /*added by JMEENA for bug#7260552, start*/
1328: if lv_to_account_id IS NULL THEN
1329: p_process_flag := jai_constants.expected_error;
1330: p_process_message := 'Cenvat / Cess / SH Cess Accounts not defined for the Destination Organization';
1331: return;
1332: END IF;
1333: /*JMEENA for bug#7260552, end*/

Line 1375: p_process_flag := jai_constants.unexpected_error;

1371: /* Added by Ramananda for bug#4407165 */
1372: EXCEPTION
1373: WHEN OTHERS THEN
1374:
1375: p_process_flag := jai_constants.unexpected_error;
1376: p_process_message := sqlerrm;
1377:
1378: FND_MESSAGE.SET_NAME('JA','JAI_EXCEPTION_OCCURED');
1379: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG', lv_object_name ||'. Err:'||sqlerrm );