DBA Data[Home] [Help]

APPS.PAY_IN_ETW_STRUCT dependencies on PAY_IN_UTILS

Line 26: pay_in_utils.set_location(g_debug, 'Entering: '||l_procedure,10);

22: l_procedure CONSTANT VARCHAR2(100):= g_package||'init_code';
23: l_message VARCHAR2(255);
24: BEGIN
25: g_debug := hr_utility.debug_enabled;
26: pay_in_utils.set_location(g_debug, 'Entering: '||l_procedure,10);
27:
28: /* Various Templates are as follows
29:
30: ----------------------------------------------------------------

Line 52: pay_in_utils.set_location(g_debug, l_procedure,20);

48: */
49: ----------------------------------------------------------------
50: -- TEMPLATE FOR FRINGE BENEFITS STARTS
51: ----------------------------------------------------------------
52: pay_in_utils.set_location(g_debug, l_procedure,20);
53: g_template_obj(1).template_name := 'Fringe Benefits';
54: g_template_obj(1).category := 'Fringe Benefits';
55: g_template_obj(1).priority := 19000;
56:

Line 624: pay_in_utils.set_location(g_debug, l_procedure,30);

620:
621: ----------------------------------------------------------------
622: -- TEMPLATE FOR FIXED ALLOWANCES STARTS
623: ----------------------------------------------------------------
624: pay_in_utils.set_location(g_debug, l_procedure,30);
625: g_template_obj(2).template_name := 'Fixed Allowance';
626: g_template_obj(2).category := 'Allowances';
627: g_template_obj(2).priority := 9000;
628:

Line 1069: pay_in_utils.set_location(g_debug, l_procedure,40);

1065:
1066: ----------------------------------------------------------------
1067: -- TEMPLATE FOR ACTUAL EXPENDITURE ALLOWANCE STARTS
1068: ----------------------------------------------------------------
1069: pay_in_utils.set_location(g_debug, l_procedure,40);
1070: g_template_obj(3).template_name := 'Actual Expense Allowances';
1071: g_template_obj(3).category := 'Allowances';
1072: g_template_obj(3).priority := 9000;
1073:

Line 1595: pay_in_utils.set_location(g_debug, l_procedure,50);

1591:
1592: ----------------------------------------------------------------
1593: -- TEMPLATE FOR FREE EDUCATION STARTS
1594: ----------------------------------------------------------------
1595: pay_in_utils.set_location(g_debug, l_procedure,50);
1596: g_template_obj(4).template_name := 'Free Education';
1597: g_template_obj(4).category := 'Perquisites';
1598: g_template_obj(4).priority := 9000;
1599:

Line 1894: pay_in_utils.set_location(g_debug, l_procedure,60);

1890:
1891: ----------------------------------------------------------------
1892: -- TEMPLATE FOR ACCOMMODATION STARTS
1893: ----------------------------------------------------------------
1894: pay_in_utils.set_location(g_debug, l_procedure,60);
1895: g_template_obj(5).template_name := 'Company Accommodation';
1896: g_template_obj(5).category := 'Perquisites';
1897: g_template_obj(5).priority := 9000;
1898:

Line 2288: pay_in_utils.set_location(g_debug, l_procedure,70);

2284:
2285: ----------------------------------------------------------------
2286: -- TEMPLATE FOR CONCESSIONAL LOAN STARTS
2287: ----------------------------------------------------------------
2288: pay_in_utils.set_location(g_debug, l_procedure,70);
2289: g_template_obj(6).template_name := 'Loan at Concessional Rate';
2290: g_template_obj(6).category := 'Perquisites';
2291: g_template_obj(6).priority := 17000;
2292:

Line 2636: pay_in_utils.set_location(g_debug, l_procedure,80);

2632:
2633: ----------------------------------------------------------------
2634: -- TEMPLATE FOR COMPANY ASSETS STARTS
2635: ----------------------------------------------------------------
2636: pay_in_utils.set_location(g_debug, l_procedure,80);
2637: g_template_obj(7).template_name := 'Company Movable Assets';
2638: g_template_obj(7).category := 'Perquisites';
2639: g_template_obj(7).priority := 17000;
2640:

Line 2933: pay_in_utils.set_location(g_debug, l_procedure,90);

2929:
2930: ----------------------------------------------------------------
2931: -- TEMPLATE FOR OTHER PERQUISITES STARTS
2932: ----------------------------------------------------------------
2933: pay_in_utils.set_location(g_debug, l_procedure,90);
2934: g_template_obj(8).template_name := 'Other Perquisites';
2935: g_template_obj(8).category := 'Perquisites';
2936: g_template_obj(8).priority := 17000;
2937:

Line 3204: pay_in_utils.set_location(g_debug, l_procedure,100);

3200:
3201: ----------------------------------------------------------------
3202: -- TEMPLATE FOR LEAVE TRAVEL CONCESSION STARTS
3203: ----------------------------------------------------------------
3204: pay_in_utils.set_location(g_debug, l_procedure,100);
3205: g_template_obj(9).template_name := 'Leave Travel Concession';
3206: g_template_obj(9).category := 'Earnings';
3207: g_template_obj(9).priority := 9000;
3208:

Line 3643: pay_in_utils.set_location(g_debug, l_procedure,120);

3639: ----------------------------------------------------------------
3640: ----------------------------------------------------------------
3641: -- TEMPLATE FOR EARNINGS STARTS
3642: ----------------------------------------------------------------
3643: pay_in_utils.set_location(g_debug, l_procedure,120);
3644: g_template_obj(10).template_name := 'Earnings';
3645: g_template_obj(10).category := 'Earnings';
3646: g_template_obj(10).priority := 9000;
3647:

Line 3882: pay_in_utils.set_location(g_debug, l_procedure, 130 );

3878: -------------------------------------------------------------
3879: ---- TEMPLATE FOR TRANSFER OF COMPANY ASSETS STARTS
3880: -------------------------------------------------------------
3881:
3882: pay_in_utils.set_location(g_debug, l_procedure, 130 );
3883: g_template_obj(11).template_name := 'Transfer of Company Assets';
3884: g_template_obj(11).category := 'Perquisites';
3885: g_template_obj(11).priority := 17000;
3886:

Line 4085: pay_in_utils.set_location(g_debug, l_procedure,110);

4081:
4082: ----------------------------------------------------------------
4083: -- TEMPLATE FOR Employer Charges STARTS
4084: ----------------------------------------------------------------
4085: pay_in_utils.set_location(g_debug, l_procedure,110);
4086: g_template_obj(12).template_name := 'Pension Fund 80CCD';
4087: g_template_obj(12).category := 'Employer Charges';
4088: g_template_obj(12).priority := 21000;
4089:

Line 4198: pay_in_utils.set_location(g_debug, l_procedure,50);

4194:
4195: ----------------------------------------------------------------
4196: -- TEMPLATE FOR LUNCH PERQUISITE STARTS
4197: ----------------------------------------------------------------
4198: pay_in_utils.set_location(g_debug, l_procedure,50);
4199: g_template_obj(13).template_name := 'Lunch Perquisite';
4200: g_template_obj(13).category := 'Perquisites';
4201: g_template_obj(13).priority := 9000;
4202:

Line 4468: pay_in_utils.set_location(g_debug, l_procedure,50);

4464: ----------------------------------------------------------------
4465: ----------------------------------------------------------------
4466: -- TEMPLATE FOR CAR PERQUISITE STARTS
4467: ----------------------------------------------------------------
4468: pay_in_utils.set_location(g_debug, l_procedure,50);
4469: g_template_obj(14).template_name := 'Motor Car Perquisite';
4470: g_template_obj(14).category := 'Perquisites';
4471: g_template_obj(14).priority := 9000;
4472:

Line 4800: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);

4796: ----------------------------------------------------------------
4797: -- TEMPLATE FOR CAR PERQUISITE ENDS
4798: ----------------------------------------------------------------
4799:
4800: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4801: EXCEPTION
4802: WHEN OTHERS THEN
4803: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4804: l_message := pay_in_utils.get_pay_message

Line 4803: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);

4799:
4800: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4801: EXCEPTION
4802: WHEN OTHERS THEN
4803: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4804: l_message := pay_in_utils.get_pay_message
4805: ('PER_IN_ORACLE_GENERIC_ERROR',
4806: 'FUNCTION:'||l_procedure,
4807: 'SQLERRMC:'||SQLERRM);

Line 4804: l_message := pay_in_utils.get_pay_message

4800: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4801: EXCEPTION
4802: WHEN OTHERS THEN
4803: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4804: l_message := pay_in_utils.get_pay_message
4805: ('PER_IN_ORACLE_GENERIC_ERROR',
4806: 'FUNCTION:'||l_procedure,
4807: 'SQLERRMC:'||SQLERRM);
4808: pay_in_utils.trace('SQLERRM',l_message);

Line 4808: pay_in_utils.trace('SQLERRM',l_message);

4804: l_message := pay_in_utils.get_pay_message
4805: ('PER_IN_ORACLE_GENERIC_ERROR',
4806: 'FUNCTION:'||l_procedure,
4807: 'SQLERRMC:'||SQLERRM);
4808: pay_in_utils.trace('SQLERRM',l_message);
4809: RAISE ;
4810:
4811: END init_code;
4812:

Line 4834: pay_in_utils.set_location(g_debug, 'Entering: '||l_procedure,10);

4830: l_procedure CONSTANT VARCHAR2(100):= g_package||'init_formula';
4831:
4832: BEGIN
4833: g_debug := hr_utility.debug_enabled;
4834: pay_in_utils.set_location(g_debug, 'Entering: '||l_procedure,10);
4835:
4836: ----------------------------------------------------------------
4837: -- FORMULA FOR FIXED ALLOWANCES
4838: ----------------------------------------------------------------

Line 4839: pay_in_utils.set_location(g_debug, l_procedure,20);

4835:
4836: ----------------------------------------------------------------
4837: -- FORMULA FOR FIXED ALLOWANCES
4838: ----------------------------------------------------------------
4839: pay_in_utils.set_location(g_debug, l_procedure,20);
4840: g_formula_obj(1).name := '_FIXED_CALC';
4841: g_formula_obj(1).text :=
4842: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
4843: /* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */

Line 4945: pay_in_utils.set_location(g_debug, l_procedure,40);

4941:
4942: ----------------------------------------------------------------
4943: -- FORMULA FOR ACTUAL EXPENSE ALLOWANCE
4944: ----------------------------------------------------------------
4945: pay_in_utils.set_location(g_debug, l_procedure,40);
4946: g_formula_obj(2).name := '_ACTEXP_CALC';
4947: g_formula_obj(2).text :=
4948: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
4949: /*----------------------------------------------------------------------

Line 5063: pay_in_utils.set_location(g_debug, l_procedure,50);

5059:
5060: ----------------------------------------------------------------
5061: -- FORMULA FOR LTC EARNINGS
5062: ----------------------------------------------------------------
5063: pay_in_utils.set_location(g_debug, l_procedure,50);
5064: g_formula_obj(3).name := '_LTC_CALC';
5065: g_formula_obj(3).text :=
5066: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5067: /*----------------------------------------------------------------------

Line 5132: pay_in_utils.set_location(g_debug, l_procedure,60);

5128:
5129: ----------------------------------------------------------------
5130: -- FORMULA FOR ADVANCES ON EARNINGS
5131: ----------------------------------------------------------------
5132: pay_in_utils.set_location(g_debug, l_procedure,60);
5133: g_formula_obj(4).name := '_LTC_ADV_CALC';
5134: g_formula_obj(4).text :=
5135: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5136: /*----------------------------------------------------------------------

Line 5177: pay_in_utils.set_location(g_debug, l_procedure,70);

5173:
5174: ----------------------------------------------------------------
5175: -- FORMULA FOR FRINGE BENEFIT CALCULATIONS
5176: ----------------------------------------------------------------
5177: pay_in_utils.set_location(g_debug, l_procedure,70);
5178: g_formula_obj(5).name := '_FB_CALC';
5179: g_formula_obj(5).text :=
5180: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5181:

Line 5388: pay_in_utils.set_location(g_debug, l_procedure,80);

5384:
5385: ----------------------------------------------------------------
5386: -- FORMULA FOR ADVANCES ON FRINGE BENEFITS
5387: ----------------------------------------------------------------
5388: pay_in_utils.set_location(g_debug, l_procedure,80);
5389: g_formula_obj(6).name := '_FB_ADV_CALC';
5390: g_formula_obj(6).text :=
5391: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5392:

Line 5433: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);

5429:
5430: /* End of Formula */
5431: ';
5432:
5433: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5434:
5435: ----------------------------------------------------------------
5436: -- FORMULA FOR ADVANCES ON FIXED ALLOWANCES
5437: ----------------------------------------------------------------

Line 5438: pay_in_utils.set_location(g_debug, l_procedure,80);

5434:
5435: ----------------------------------------------------------------
5436: -- FORMULA FOR ADVANCES ON FIXED ALLOWANCES
5437: ----------------------------------------------------------------
5438: pay_in_utils.set_location(g_debug, l_procedure,80);
5439: g_formula_obj(7).name := '_FX_ADV_CALC';
5440: g_formula_obj(7).text :=
5441: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5442: /*----------------------------------------------------------------------

Line 5485: pay_in_utils.set_location(g_debug, l_procedure,80);

5481:
5482: ----------------------------------------------------------------
5483: -- FORMULA FOR ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5484: ----------------------------------------------------------------
5485: pay_in_utils.set_location(g_debug, l_procedure,80);
5486: g_formula_obj(8).name := '_AE_ADV_CALC';
5487: g_formula_obj(8).text :=
5488: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5489: /*----------------------------------------------------------------------

Line 5601: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);

5597:
5598: /* End of Formula */
5599: ';
5600:
5601: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5602:
5603: ----------------------------------------------------------------
5604: -- FORMULA FOR EXCESS ADVANCES ON FIXED ALLOWANCES
5605: ----------------------------------------------------------------

Line 5606: pay_in_utils.set_location(g_debug, l_procedure,80);

5602:
5603: ----------------------------------------------------------------
5604: -- FORMULA FOR EXCESS ADVANCES ON FIXED ALLOWANCES
5605: ----------------------------------------------------------------
5606: pay_in_utils.set_location(g_debug, l_procedure,80);
5607: g_formula_obj(10).name := '_FX_EXC_ADV';
5608: g_formula_obj(10).text :=
5609: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5610: /*----------------------------------------------------------------------

Line 5676: pay_in_utils.set_location(g_debug, l_procedure,80);

5672:
5673: ----------------------------------------------------------------
5674: -- FORMULA FOR excess ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5675: ----------------------------------------------------------------
5676: pay_in_utils.set_location(g_debug, l_procedure,80);
5677: g_formula_obj(11).name := '_AE_EXC_ADV';
5678: g_formula_obj(11).text :=
5679: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5680: /*----------------------------------------------------------------------

Line 5746: pay_in_utils.set_location(g_debug, l_procedure,80);

5742: ';
5743: ----------------------------------------------------------------
5744: -- FORMULA FOR excess ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5745: ----------------------------------------------------------------
5746: pay_in_utils.set_location(g_debug, l_procedure,80);
5747: g_formula_obj(12).name := '_LTC_EXC_ADV';
5748: g_formula_obj(12).text :=
5749: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5750: /*----------------------------------------------------------------------

Line 5817: pay_in_utils.set_location(g_debug, l_procedure,60);

5813:
5814: ----------------------------------------------------------------
5815: -- FORMULA FOR EMPLOYER CHARGES
5816: ----------------------------------------------------------------
5817: pay_in_utils.set_location(g_debug, l_procedure,60);
5818: g_formula_obj(13).name := '_EC_CALC';
5819: g_formula_obj(13).text :=
5820: '/* $Header: pyinetst.pkb 120.16.12020000.3 2012/07/06 11:03:20 vmaripal ship $ */
5821: /*----------------------------------------------------------------------

Line 5851: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);

5847:
5848: /* End of Formula */ ';
5849:
5850:
5851: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5852: END init_formula;
5853:
5854: END pay_in_etw_struct;