DBA Data[Home] [Help]

APPS.PAY_IN_TAX_DECLARATION dependencies on FND_MSG_PUB

Line 1511: fnd_msg_pub.initialize; -- Bug 13767307

1507:
1508: --
1509: BEGIN
1510:
1511: fnd_msg_pub.initialize; -- Bug 13767307
1512: l_procedure := g_package || 'declare_house_rent';
1513: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1514:
1515: IF g_debug THEN

Line 1820: fnd_msg_pub.add_exc_msg

1816: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1817: --
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: fnd_msg_pub.add_exc_msg
1821: (p_pkg_name => g_package
1822: ,p_procedure_name => 'declare_house_rent'
1823: ,p_error_text => substr(sqlerrm, 1, 240)
1824: );

Line 1899: fnd_msg_pub.initialize; -- Bug 13767307

1895: FROM ff_globals_f
1896: WHERE global_name = 'IN_PERMANENT_PHYSICAL_DISABILITY_80U'
1897: AND legislation_code = g_legislation_code;
1898: BEGIN
1899: fnd_msg_pub.initialize; -- Bug 13767307
1900: l_procedure := g_package || 'declare_chapter6a';
1901: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1902:
1903: IF g_debug THEN

Line 2175: fnd_msg_pub.add_exc_msg

2171: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
2172: --
2173: EXCEPTION
2174: WHEN OTHERS THEN
2175: fnd_msg_pub.add_exc_msg
2176: (p_pkg_name => g_package
2177: ,p_procedure_name => 'declare_chapter6a'
2178: ,p_error_text => substr(sqlerrm, 1, 240)
2179: );

Line 2253: fnd_msg_pub.initialize; -- Bug 13767307

2249: l_effective_date DATE;
2250: l_warnings VARCHAR2(6);
2251: --
2252: BEGIN
2253: fnd_msg_pub.initialize; -- Bug 13767307
2254: l_procedure := g_package || 'declare_section88';
2255: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2256:
2257: IF g_debug THEN

Line 2285: fnd_msg_pub.add_exc_msg

2281: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2282: --
2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: fnd_msg_pub.add_exc_msg
2286: (p_pkg_name => g_package
2287: ,p_procedure_name => 'declare_section88'
2288: ,p_error_text => substr(sqlerrm, 1, 240)
2289: );

Line 2345: fnd_msg_pub.initialize; -- Bug 13767307

2341: l_effective_date DATE;
2342: l_warnings VARCHAR2(6);
2343: --
2344: BEGIN
2345: fnd_msg_pub.initialize; -- Bug 13767307
2346: l_procedure := g_package || 'declare_other_income';
2347: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2348:
2349: IF g_debug THEN

Line 2503: fnd_msg_pub.add_exc_msg

2499: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_procedure, 80);
2500: --
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: fnd_msg_pub.add_exc_msg
2504: (p_pkg_name => g_package
2505: ,p_procedure_name => 'declare_other_income'
2506: ,p_error_text => substr(sqlerrm, 1, 240)
2507: );

Line 2609: fnd_msg_pub.initialize; -- Bug 13767307

2605: AND assgn.effective_end_date;
2606: BEGIN
2607: --
2608:
2609: fnd_msg_pub.initialize; -- Bug 13767307
2610: l_procedure := g_package || 'declare_section80dd';
2611: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2612:
2613: IF g_debug THEN

Line 2789: fnd_msg_pub.add_exc_msg

2785: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_procedure, 90);
2786: --
2787: EXCEPTION
2788: WHEN OTHERS THEN
2789: fnd_msg_pub.add_exc_msg
2790: (p_pkg_name => g_package
2791: ,p_procedure_name => 'declare_section80dd'
2792: ,p_error_text => substr(sqlerrm, 1, 240)
2793: );

Line 2892: fnd_msg_pub.initialize; -- Bug 13767307

2888: AND entries.effective_end_date
2889: AND c_effective_date BETWEEN assgn.effective_start_date
2890: AND assgn.effective_end_date;
2891: BEGIN
2892: fnd_msg_pub.initialize; -- Bug 13767307
2893: l_procedure := g_package || 'declare_section80g';
2894: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2895:
2896: IF g_debug THEN

Line 3069: fnd_msg_pub.add_exc_msg

3065: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_procedure, 90);
3066: --
3067: EXCEPTION
3068: WHEN OTHERS THEN
3069: fnd_msg_pub.add_exc_msg
3070: (p_pkg_name => g_package
3071: ,p_procedure_name => 'declare_section80g'
3072: ,p_error_text => substr(sqlerrm, 1, 240)
3073: );

Line 3174: fnd_msg_pub.initialize; -- Bug 13767307

3170: WHERE legislation_code = 'IN'
3171: AND element_name = p_element_name
3172: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
3173: BEGIN
3174: fnd_msg_pub.initialize; -- Bug 13767307
3175: l_procedure := g_package || 'declare_life_insurance_premium';
3176: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3177:
3178: IF g_debug THEN

Line 3363: fnd_msg_pub.add_exc_msg

3359: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_procedure, 90);
3360:
3361: EXCEPTION
3362: WHEN OTHERS THEN
3363: fnd_msg_pub.add_exc_msg
3364: (p_pkg_name => g_package
3365: ,p_procedure_name => 'declare_life_insurance_premium'
3366: ,p_error_text => substr(sqlerrm, 1, 240)
3367: );

Line 3424: fnd_msg_pub.initialize; -- Bug 13767307

3420: l_warnings VARCHAR2(6);
3421: l_current_date pay_element_entries_f.effective_start_date%TYPE;
3422: --
3423: BEGIN
3424: fnd_msg_pub.initialize; -- Bug 13767307
3425: l_procedure := g_package || 'declare_vpf';
3426: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3427:
3428: IF g_debug THEN

Line 3552: fnd_msg_pub.add_exc_msg

3548: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
3549: --
3550: EXCEPTION
3551: WHEN OTHERS THEN
3552: fnd_msg_pub.add_exc_msg
3553: (p_pkg_name => g_package
3554: ,p_procedure_name => 'declare_vpf'
3555: ,p_error_text => substr(sqlerrm, 1, 240)
3556: );

Line 3605: fnd_msg_pub.initialize; -- Bug 13767307

3601: l_effective_date DATE;
3602: l_warnings VARCHAR2(6);
3603: --
3604: BEGIN
3605: fnd_msg_pub.initialize; -- Bug 13767307
3606: l_procedure := g_package || 'declare_tuition_fee';
3607: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3608:
3609: IF g_debug THEN

Line 3623: fnd_msg_pub.add_exc_msg

3619: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
3620: --
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: fnd_msg_pub.add_exc_msg
3624: (p_pkg_name => g_package
3625: ,p_procedure_name => 'declare_tuition_fee'
3626: ,p_error_text => substr(sqlerrm, 1, 240)
3627: );

Line 3787: fnd_msg_pub.initialize; -- Bug 13767307

3783: AND p_effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date
3784: AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
3785:
3786: BEGIN
3787: fnd_msg_pub.initialize; -- Bug 13767307
3788: l_procedure := g_package || 'declare_section80cce';
3789: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3790:
3791: IF g_debug THEN

Line 4015: fnd_msg_pub.add_exc_msg

4011: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
4012: --
4013: EXCEPTION
4014: WHEN OTHERS THEN
4015: fnd_msg_pub.add_exc_msg
4016: (p_pkg_name => g_package
4017: ,p_procedure_name => 'declare_section80cce'
4018: ,p_error_text => substr(sqlerrm, 1, 240)
4019: );

Line 4066: fnd_msg_pub.initialize; -- Bug 13767307

4062: l_endation_date DATE;
4063: l_warnings VARCHAR2(6);
4064: --
4065: BEGIN
4066: fnd_msg_pub.initialize; -- Bug 13767307
4067: l_procedure := g_package || 'declare_section80gg';
4068: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4069:
4070: IF g_debug THEN

Line 4193: fnd_msg_pub.add_exc_msg

4189: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
4190: --
4191: EXCEPTION
4192: WHEN OTHERS THEN
4193: fnd_msg_pub.add_exc_msg
4194: (p_pkg_name => g_package
4195: ,p_procedure_name => 'declare_section80gg'
4196: ,p_error_text => substr(sqlerrm, 1, 240)
4197: );

Line 4244: fnd_msg_pub.initialize; -- Bug 13767307

4240: l_endation_date DATE;
4241: l_warnings VARCHAR2(6);
4242: --
4243: BEGIN
4244: fnd_msg_pub.initialize; -- Bug 13767307
4245: l_procedure := g_package || 'declare_section80e';
4246: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4247:
4248: IF g_debug THEN

Line 4385: fnd_msg_pub.add_exc_msg

4381: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
4382: --
4383: EXCEPTION
4384: WHEN OTHERS THEN
4385: fnd_msg_pub.add_exc_msg
4386: (p_pkg_name => g_package
4387: ,p_procedure_name => 'declare_section80e'
4388: ,p_error_text => substr(sqlerrm, 1, 240)
4389: );

Line 4436: fnd_msg_pub.initialize; -- Bug 13767307

4432: l_endation_date DATE;
4433: l_warnings VARCHAR2(6);
4434: --
4435: BEGIN
4436: fnd_msg_pub.initialize; -- Bug 13767307
4437: l_procedure := g_package || 'declare_section80ccf';
4438: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4439:
4440: IF g_debug THEN

Line 4576: fnd_msg_pub.add_exc_msg

4572: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
4573: --
4574: EXCEPTION
4575: WHEN OTHERS THEN
4576: fnd_msg_pub.add_exc_msg
4577: (p_pkg_name => g_package
4578: ,p_procedure_name => 'declare_section80ccf'
4579: ,p_error_text => substr(sqlerrm, 1, 240)
4580: );

Line 4628: fnd_msg_pub.initialize; -- Bug 13767307

4624: l_endation_date DATE;
4625: l_warnings VARCHAR2(6);
4626: --
4627: BEGIN
4628: fnd_msg_pub.initialize; -- Bug 13767307
4629: l_procedure := g_package || 'declare_section80ccg';
4630: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4631:
4632: IF g_debug THEN

Line 4772: fnd_msg_pub.add_exc_msg

4768: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
4769: --
4770: EXCEPTION
4771: WHEN OTHERS THEN
4772: fnd_msg_pub.add_exc_msg
4773: (p_pkg_name => g_package
4774: ,p_procedure_name => 'declare_section80ccg'
4775: ,p_error_text => substr(sqlerrm, 1, 240)
4776: );

Line 4824: fnd_msg_pub.initialize; -- Bug 13767307

4820: l_endation_date DATE;
4821: l_warnings VARCHAR2(6);
4822: --
4823: BEGIN
4824: fnd_msg_pub.initialize; -- Bug 13767307
4825: l_procedure := g_package || 'declare_section80gga';
4826: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4827:
4828: IF g_debug THEN

Line 4963: fnd_msg_pub.add_exc_msg

4959: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
4960: --
4961: EXCEPTION
4962: WHEN OTHERS THEN
4963: fnd_msg_pub.add_exc_msg
4964: (p_pkg_name => g_package
4965: ,p_procedure_name => 'declare_section80gga'
4966: ,p_error_text => substr(sqlerrm, 1, 240)
4967: );

Line 5020: fnd_msg_pub.initialize; -- Bug 13767307

5016: l_endation_date DATE;
5017: l_warnings VARCHAR2(6);
5018: --
5019: BEGIN
5020: fnd_msg_pub.initialize; -- Bug 13767307
5021: l_procedure := g_package || 'declare_section80d';
5022: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5023:
5024: IF g_debug THEN

Line 5176: fnd_msg_pub.add_exc_msg

5172: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
5173: --
5174: EXCEPTION
5175: WHEN OTHERS THEN
5176: fnd_msg_pub.add_exc_msg
5177: (p_pkg_name => g_package
5178: ,p_procedure_name => 'declare_section80d'
5179: ,p_error_text => substr(sqlerrm, 1, 240)
5180: );

Line 5228: fnd_msg_pub.initialize; -- Bug 13767307

5224: l_endation_date DATE;
5225: l_warnings VARCHAR2(6);
5226: --
5227: BEGIN
5228: fnd_msg_pub.initialize; -- Bug 13767307
5229: l_procedure := g_package || 'declare_section80ddb';
5230: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5231:
5232: IF g_debug THEN

Line 5374: fnd_msg_pub.add_exc_msg

5370: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
5371: --
5372: EXCEPTION
5373: WHEN OTHERS THEN
5374: fnd_msg_pub.add_exc_msg
5375: (p_pkg_name => g_package
5376: ,p_procedure_name => 'declare_section80ddb'
5377: ,p_error_text => substr(sqlerrm, 1, 240)
5378: );

Line 5423: fnd_msg_pub.initialize; -- Bug 13767307

5419: l_endation_date DATE;
5420: l_warnings VARCHAR2(6);
5421: --
5422: BEGIN
5423: fnd_msg_pub.initialize; -- Bug 13767307
5424: l_procedure := g_package || 'declare_section80U';
5425: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5426:
5427: IF g_debug THEN

Line 5496: fnd_msg_pub.add_exc_msg

5492: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
5493: --
5494: EXCEPTION
5495: WHEN OTHERS THEN
5496: fnd_msg_pub.add_exc_msg
5497: (p_pkg_name => g_package
5498: ,p_procedure_name => 'declare_section80u'
5499: ,p_error_text => substr(sqlerrm, 1, 240)
5500: );

Line 5607: fnd_msg_pub.initialize; -- Bug 13767307

5603: WHERE global_name = 'IN_PERMANENT_PHYSICAL_DISABILITY_80U'
5604: AND legislation_code = g_legislation_code;
5605: --
5606: BEGIN
5607: fnd_msg_pub.initialize; -- Bug 13767307
5608:
5609: l_procedure := g_package || 'declare_tax';
5610: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
5611:

Line 5867: fnd_msg_pub.add_exc_msg

5863: END IF;
5864: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,150);
5865: EXCEPTION
5866: WHEN OTHERS THEN
5867: fnd_msg_pub.add_exc_msg
5868: (p_pkg_name => g_package
5869: ,p_procedure_name => 'declare_tax'
5870: ,p_error_text => substr(sqlerrm, 1, 240)
5871: );

Line 5920: fnd_msg_pub.initialize; -- Bug 13767307

5916: AND c_effective_date BETWEEN effective_start_date
5917: AND effective_end_date;
5918: --
5919: BEGIN
5920: fnd_msg_pub.initialize; -- Bug 13767307
5921: p_warnings := 'FALSE';
5922:
5923: l_procedure := g_package || 'delete_declaration';
5924: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 5992: fnd_msg_pub.add_exc_msg

5988: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
5989: --
5990: EXCEPTION
5991: WHEN OTHERS THEN
5992: fnd_msg_pub.add_exc_msg
5993: (p_pkg_name => g_package
5994: ,p_procedure_name => 'delete_declaration'
5995: ,p_error_text => substr(sqlerrm, 1, 240)
5996: );

Line 6039: fnd_msg_pub.initialize; -- Bug 13767307

6035: FROM per_assignment_extra_info
6036: WHERE assignment_extra_info_id = c_extra_info_id;
6037: --
6038: BEGIN
6039: fnd_msg_pub.initialize; -- Bug 13767307
6040: l_procedure := g_package || 'approve_declaration';
6041: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
6042:
6043: IF g_debug THEN

Line 6103: fnd_msg_pub.add_exc_msg

6099: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
6100: --
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: fnd_msg_pub.add_exc_msg
6104: (p_pkg_name => g_package
6105: ,p_procedure_name => 'approve_declaration'
6106: ,p_error_text => substr(sqlerrm, 1, 240)
6107: );