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 2619: pay_in_utils.set_location(g_debug, l_procedure,80);

2615:
2616: ----------------------------------------------------------------
2617: -- TEMPLATE FOR COMPANY ASSETS STARTS
2618: ----------------------------------------------------------------
2619: pay_in_utils.set_location(g_debug, l_procedure,80);
2620: g_template_obj(7).template_name := 'Company Movable Assets';
2621: g_template_obj(7).category := 'Perquisites';
2622: g_template_obj(7).priority := 17000;
2623:

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

2912:
2913: ----------------------------------------------------------------
2914: -- TEMPLATE FOR OTHER PERQUISITES STARTS
2915: ----------------------------------------------------------------
2916: pay_in_utils.set_location(g_debug, l_procedure,90);
2917: g_template_obj(8).template_name := 'Other Perquisites';
2918: g_template_obj(8).category := 'Perquisites';
2919: g_template_obj(8).priority := 17000;
2920:

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

3183:
3184: ----------------------------------------------------------------
3185: -- TEMPLATE FOR LEAVE TRAVEL CONCESSION STARTS
3186: ----------------------------------------------------------------
3187: pay_in_utils.set_location(g_debug, l_procedure,100);
3188: g_template_obj(9).template_name := 'Leave Travel Concession';
3189: g_template_obj(9).category := 'Earnings';
3190: g_template_obj(9).priority := 9000;
3191:

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

3622: ----------------------------------------------------------------
3623: ----------------------------------------------------------------
3624: -- TEMPLATE FOR EARNINGS STARTS
3625: ----------------------------------------------------------------
3626: pay_in_utils.set_location(g_debug, l_procedure,120);
3627: g_template_obj(10).template_name := 'Earnings';
3628: g_template_obj(10).category := 'Earnings';
3629: g_template_obj(10).priority := 9000;
3630:

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

3861: -------------------------------------------------------------
3862: ---- TEMPLATE FOR TRANSFER OF COMPANY ASSETS STARTS
3863: -------------------------------------------------------------
3864:
3865: pay_in_utils.set_location(g_debug, l_procedure, 130 );
3866: g_template_obj(11).template_name := 'Transfer of Company Assets';
3867: g_template_obj(11).category := 'Perquisites';
3868: g_template_obj(11).priority := 17000;
3869:

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

4064:
4065: ----------------------------------------------------------------
4066: -- TEMPLATE FOR Employer Charges STARTS
4067: ----------------------------------------------------------------
4068: pay_in_utils.set_location(g_debug, l_procedure,110);
4069: g_template_obj(12).template_name := 'Pension Fund 80CCD';
4070: g_template_obj(12).category := 'Employer Charges';
4071: g_template_obj(12).priority := 21000;
4072:

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

4177:
4178: ----------------------------------------------------------------
4179: -- TEMPLATE FOR LUNCH PERQUISITE STARTS
4180: ----------------------------------------------------------------
4181: pay_in_utils.set_location(g_debug, l_procedure,50);
4182: g_template_obj(13).template_name := 'Lunch Perquisite';
4183: g_template_obj(13).category := 'Perquisites';
4184: g_template_obj(13).priority := 9000;
4185:

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

4447: ----------------------------------------------------------------
4448: ----------------------------------------------------------------
4449: -- TEMPLATE FOR CAR PERQUISITE STARTS
4450: ----------------------------------------------------------------
4451: pay_in_utils.set_location(g_debug, l_procedure,50);
4452: g_template_obj(14).template_name := 'Motor Car Perquisite';
4453: g_template_obj(14).category := 'Perquisites';
4454: g_template_obj(14).priority := 9000;
4455:

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

4779: ----------------------------------------------------------------
4780: -- TEMPLATE FOR CAR PERQUISITE ENDS
4781: ----------------------------------------------------------------
4782:
4783: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4784: EXCEPTION
4785: WHEN OTHERS THEN
4786: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4787: l_message := pay_in_utils.get_pay_message

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

4782:
4783: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4784: EXCEPTION
4785: WHEN OTHERS THEN
4786: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4787: l_message := pay_in_utils.get_pay_message
4788: ('PER_IN_ORACLE_GENERIC_ERROR',
4789: 'FUNCTION:'||l_procedure,
4790: 'SQLERRMC:'||SQLERRM);

Line 4787: l_message := pay_in_utils.get_pay_message

4783: pay_in_utils.set_location(g_debug,'Leaving:'|| l_procedure,150);
4784: EXCEPTION
4785: WHEN OTHERS THEN
4786: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure,160);
4787: l_message := pay_in_utils.get_pay_message
4788: ('PER_IN_ORACLE_GENERIC_ERROR',
4789: 'FUNCTION:'||l_procedure,
4790: 'SQLERRMC:'||SQLERRM);
4791: pay_in_utils.trace('SQLERRM',l_message);

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

4787: l_message := pay_in_utils.get_pay_message
4788: ('PER_IN_ORACLE_GENERIC_ERROR',
4789: 'FUNCTION:'||l_procedure,
4790: 'SQLERRMC:'||SQLERRM);
4791: pay_in_utils.trace('SQLERRM',l_message);
4792: RAISE ;
4793:
4794: END init_code;
4795:

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

4813: l_procedure CONSTANT VARCHAR2(100):= g_package||'init_formula';
4814:
4815: BEGIN
4816: g_debug := hr_utility.debug_enabled;
4817: pay_in_utils.set_location(g_debug, 'Entering: '||l_procedure,10);
4818:
4819: ----------------------------------------------------------------
4820: -- FORMULA FOR FIXED ALLOWANCES
4821: ----------------------------------------------------------------

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

4818:
4819: ----------------------------------------------------------------
4820: -- FORMULA FOR FIXED ALLOWANCES
4821: ----------------------------------------------------------------
4822: pay_in_utils.set_location(g_debug, l_procedure,20);
4823: g_formula_obj(1).name := '_FIXED_CALC';
4824: g_formula_obj(1).text :=
4825: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
4826: /* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */

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

4924:
4925: ----------------------------------------------------------------
4926: -- FORMULA FOR ACTUAL EXPENSE ALLOWANCE
4927: ----------------------------------------------------------------
4928: pay_in_utils.set_location(g_debug, l_procedure,40);
4929: g_formula_obj(2).name := '_ACTEXP_CALC';
4930: g_formula_obj(2).text :=
4931: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
4932: /*----------------------------------------------------------------------

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

5042:
5043: ----------------------------------------------------------------
5044: -- FORMULA FOR LTC EARNINGS
5045: ----------------------------------------------------------------
5046: pay_in_utils.set_location(g_debug, l_procedure,50);
5047: g_formula_obj(3).name := '_LTC_CALC';
5048: g_formula_obj(3).text :=
5049: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5050: /*----------------------------------------------------------------------

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

5113:
5114: ----------------------------------------------------------------
5115: -- FORMULA FOR ADVANCES ON EARNINGS
5116: ----------------------------------------------------------------
5117: pay_in_utils.set_location(g_debug, l_procedure,60);
5118: g_formula_obj(4).name := '_LTC_ADV_CALC';
5119: g_formula_obj(4).text :=
5120: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5121: /*----------------------------------------------------------------------

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

5158:
5159: ----------------------------------------------------------------
5160: -- FORMULA FOR FRINGE BENEFIT CALCULATIONS
5161: ----------------------------------------------------------------
5162: pay_in_utils.set_location(g_debug, l_procedure,70);
5163: g_formula_obj(5).name := '_FB_CALC';
5164: g_formula_obj(5).text :=
5165: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5166:

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

5369:
5370: ----------------------------------------------------------------
5371: -- FORMULA FOR ADVANCES ON FRINGE BENEFITS
5372: ----------------------------------------------------------------
5373: pay_in_utils.set_location(g_debug, l_procedure,80);
5374: g_formula_obj(6).name := '_FB_ADV_CALC';
5375: g_formula_obj(6).text :=
5376: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5377:

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

5414:
5415: /* End of Formula */
5416: ';
5417:
5418: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5419:
5420: ----------------------------------------------------------------
5421: -- FORMULA FOR ADVANCES ON FIXED ALLOWANCES
5422: ----------------------------------------------------------------

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

5419:
5420: ----------------------------------------------------------------
5421: -- FORMULA FOR ADVANCES ON FIXED ALLOWANCES
5422: ----------------------------------------------------------------
5423: pay_in_utils.set_location(g_debug, l_procedure,80);
5424: g_formula_obj(7).name := '_FX_ADV_CALC';
5425: g_formula_obj(7).text :=
5426: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5427: /*----------------------------------------------------------------------

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

5466:
5467: ----------------------------------------------------------------
5468: -- FORMULA FOR ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5469: ----------------------------------------------------------------
5470: pay_in_utils.set_location(g_debug, l_procedure,80);
5471: g_formula_obj(8).name := '_AE_ADV_CALC';
5472: g_formula_obj(8).text :=
5473: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5474: /*----------------------------------------------------------------------

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

5582:
5583: /* End of Formula */
5584: ';
5585:
5586: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5587:
5588: ----------------------------------------------------------------
5589: -- FORMULA FOR EXCESS ADVANCES ON FIXED ALLOWANCES
5590: ----------------------------------------------------------------

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

5587:
5588: ----------------------------------------------------------------
5589: -- FORMULA FOR EXCESS ADVANCES ON FIXED ALLOWANCES
5590: ----------------------------------------------------------------
5591: pay_in_utils.set_location(g_debug, l_procedure,80);
5592: g_formula_obj(10).name := '_FX_EXC_ADV';
5593: g_formula_obj(10).text :=
5594: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5595: /*----------------------------------------------------------------------

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

5657:
5658: ----------------------------------------------------------------
5659: -- FORMULA FOR excess ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5660: ----------------------------------------------------------------
5661: pay_in_utils.set_location(g_debug, l_procedure,80);
5662: g_formula_obj(11).name := '_AE_EXC_ADV';
5663: g_formula_obj(11).text :=
5664: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5665: /*----------------------------------------------------------------------

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

5727: ';
5728: ----------------------------------------------------------------
5729: -- FORMULA FOR excess ADVANCES ON ACTUAL EXPENSE ALLOWANCES
5730: ----------------------------------------------------------------
5731: pay_in_utils.set_location(g_debug, l_procedure,80);
5732: g_formula_obj(12).name := '_LTC_EXC_ADV';
5733: g_formula_obj(12).text :=
5734: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5735: /*----------------------------------------------------------------------

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

5798:
5799: ----------------------------------------------------------------
5800: -- FORMULA FOR EMPLOYER CHARGES
5801: ----------------------------------------------------------------
5802: pay_in_utils.set_location(g_debug, l_procedure,60);
5803: g_formula_obj(13).name := '_EC_CALC';
5804: g_formula_obj(13).text :=
5805: '/* $Header: pyinetst.pkb 120.12.12010000.4 2008/09/17 10:50:33 lnagaraj ship $ */
5806: /*----------------------------------------------------------------------

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

5832:
5833: /* End of Formula */ ';
5834:
5835:
5836: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,100);
5837: END init_formula;
5838:
5839: END pay_in_etw_struct;