4707:
4708: RETURN l_Dum;
4709: EXCEPTION
4710: WHEN OTHERS THEN
4711: hr_utility.set_message(801, 'ZaTxGlb_01011001: '||TO_CHAR(SQLCODE));
4712: hr_utility.raise_error;
4713: END ZaTxGlb_01011001;
4714:
4715: -- Function to Initialise Globals - Database Item Values
4708: RETURN l_Dum;
4709: EXCEPTION
4710: WHEN OTHERS THEN
4711: hr_utility.set_message(801, 'ZaTxGlb_01011001: '||TO_CHAR(SQLCODE));
4712: hr_utility.raise_error;
4713: END ZaTxGlb_01011001;
4714:
4715: -- Function to Initialise Globals - Database Item Values
4716: --
4764:
4765: RETURN l_Dum;
4766: EXCEPTION
4767: WHEN OTHERS THEN
4768: hr_utility.set_message(801, 'ZaTxDbi_01011001: '||TO_CHAR(SQLCODE));
4769: hr_utility.raise_error;
4770:
4771: END ZaTxDbi_01011001;
4772:
4765: RETURN l_Dum;
4766: EXCEPTION
4767: WHEN OTHERS THEN
4768: hr_utility.set_message(801, 'ZaTxDbi_01011001: '||TO_CHAR(SQLCODE));
4769: hr_utility.raise_error;
4770:
4771: END ZaTxDbi_01011001;
4772:
4773:
4974:
4975: RETURN l_Dum;
4976: EXCEPTION
4977: WHEN OTHERS THEN
4978: hr_utility.set_message(801, 'ZaTxBal1_01011001: '||TO_CHAR(SQLCODE));
4979: hr_utility.raise_error;
4980: END ZaTxBal1_01011001;
4981:
4982:
4975: RETURN l_Dum;
4976: EXCEPTION
4977: WHEN OTHERS THEN
4978: hr_utility.set_message(801, 'ZaTxBal1_01011001: '||TO_CHAR(SQLCODE));
4979: hr_utility.raise_error;
4980: END ZaTxBal1_01011001;
4981:
4982:
4983: -- Function to Initialise Globals - Balance Values
5171:
5172: RETURN l_Dum;
5173: EXCEPTION
5174: WHEN OTHERS THEN
5175: hr_utility.set_message(801, 'ZaTxBal2_01011001: '||TO_CHAR(SQLCODE));
5176: hr_utility.raise_error;
5177: END ZaTxBal2_01011001;
5178:
5179:
5172: RETURN l_Dum;
5173: EXCEPTION
5174: WHEN OTHERS THEN
5175: hr_utility.set_message(801, 'ZaTxBal2_01011001: '||TO_CHAR(SQLCODE));
5176: hr_utility.raise_error;
5177: END ZaTxBal2_01011001;
5178:
5179:
5180: -- Function to Initialise Globals - Balance Values
5352:
5353: RETURN l_Dum;
5354: EXCEPTION
5355: WHEN OTHERS THEN
5356: hr_utility.set_message(801, 'ZaTxBal3_01011001: '||TO_CHAR(SQLCODE));
5357: hr_utility.raise_error;
5358: END ZaTxBal3_01011001;
5359:
5360:
5353: RETURN l_Dum;
5354: EXCEPTION
5355: WHEN OTHERS THEN
5356: hr_utility.set_message(801, 'ZaTxBal3_01011001: '||TO_CHAR(SQLCODE));
5357: hr_utility.raise_error;
5358: END ZaTxBal3_01011001;
5359:
5360:
5361: -- Main Tax Function
5469: trc_LibFpAB := 0;
5470: trc_LibFpAP := 0;
5471: trc_LibFpPO := 0;
5472: ELSE
5473: hr_utility.set_message(801, 'ERROR: Invalid Tax Status');
5474: hr_utility.raise_error;
5475: END IF;
5476:
5477: -- Execute the Arrear Processing
5470: trc_LibFpAP := 0;
5471: trc_LibFpPO := 0;
5472: ELSE
5473: hr_utility.set_message(801, 'ERROR: Invalid Tax Status');
5474: hr_utility.raise_error;
5475: END IF;
5476:
5477: -- Execute the Arrear Processing
5478: --
5527: RETURN l_Dum;
5528:
5529: EXCEPTION
5530: WHEN xpt_E THEN
5531: hr_utility.set_message(801, xpt_Msg);
5532: hr_utility.raise_error;
5533: WHEN OTHERS THEN
5534: hr_utility.set_message(801, 'ZaTx_01011001: '||TO_CHAR(SQLCODE));
5535: hr_utility.raise_error;
5528:
5529: EXCEPTION
5530: WHEN xpt_E THEN
5531: hr_utility.set_message(801, xpt_Msg);
5532: hr_utility.raise_error;
5533: WHEN OTHERS THEN
5534: hr_utility.set_message(801, 'ZaTx_01011001: '||TO_CHAR(SQLCODE));
5535: hr_utility.raise_error;
5536:
5530: WHEN xpt_E THEN
5531: hr_utility.set_message(801, xpt_Msg);
5532: hr_utility.raise_error;
5533: WHEN OTHERS THEN
5534: hr_utility.set_message(801, 'ZaTx_01011001: '||TO_CHAR(SQLCODE));
5535: hr_utility.raise_error;
5536:
5537:
5538: END ZaTx_01011001;
5531: hr_utility.set_message(801, xpt_Msg);
5532: hr_utility.raise_error;
5533: WHEN OTHERS THEN
5534: hr_utility.set_message(801, 'ZaTx_01011001: '||TO_CHAR(SQLCODE));
5535: hr_utility.raise_error;
5536:
5537:
5538: END ZaTx_01011001;
5539: