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.PA_RESOURCE_UTILS dependencies on PA_DEBUG

Line 1550: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');

1546: BEGIN
1547:
1548:
1549: -- initialize the error stack
1550: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');
1551: -- initialize the return status to success
1552: x_return_status := FND_API.G_RET_STS_SUCCESS;
1553:
1554:

Line 1579: PA_DEBUG.reset_err_stack;

1575: and (PEP.current_employee_flag = 'Y' or PEP.current_npw_flag = 'Y');
1576: -- Bug 4684198 - remove nvl on effective_end_date - col is not null
1577:
1578: -- reset the error stack
1579: PA_DEBUG.reset_err_stack;
1580:
1581: EXCEPTION
1582: WHEN NO_DATA_FOUND THEN
1583: -- as discussed with Mr.Ramesh,this is not a business rule violation

Line 1616: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_manager_id_name');

1612: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1613: IS
1614: BEGIN
1615: -- initialize the error stack
1616: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_manager_id_name');
1617: -- initialize the return status to success
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: --Modified code for future dated person

Line 1635: PA_DEBUG.reset_err_stack;

1631: AND primary_flag = 'Y'
1632: AND assignment_type in ('C', 'E');
1633:
1634: -- reset the error stack
1635: PA_DEBUG.reset_err_stack;
1636:
1637: EXCEPTION
1638: WHEN NO_DATA_FOUND THEN
1639: -- as discussed with Mr.Ramesh,this is not a business rule violation

Line 1725: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_id');

1721: IS
1722: BEGIN
1723:
1724: -- initialize the error stack
1725: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_id');
1726: -- initialize the return status to success
1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728:
1729: -- pick the Organization id for the Current Assignment

Line 1742: PA_DEBUG.reset_err_stack;

1738: AND primary_flag = 'Y'
1739: AND assignment_type in ('E', 'C'); /* added for bug 2745823 */
1740:
1741: -- reset the error stack
1742: PA_DEBUG.reset_err_stack;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: -- set the exception message and stack

Line 1748: -- ,PA_DEBUG.g_err_stack);

1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: -- set the exception message and stack
1747: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1748: -- ,PA_DEBUG.g_err_stack);
1749: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: -- raise;
1751: -- null; 4537865
1752: x_orgid := NULL ;

Line 1774: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_id');

1770:
1771: BEGIN
1772:
1773: -- initialize the error stack
1774: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_id');
1775: -- initialize the return status to success
1776: x_return_status := FND_API.G_RET_STS_SUCCESS;
1777:
1778: IF P_resourceid is NOT NULL then

Line 1819: PA_DEBUG.reset_err_stack;

1815:
1816: END IF;
1817:
1818: -- reset the error stack
1819: PA_DEBUG.reset_err_stack;
1820:
1821:
1822: EXCEPTION
1823: WHEN NO_DATA_FOUND THEN

Line 1838: ,PA_DEBUG.g_err_stack);

1834: WHEN OTHERS THEN
1835: -- set the exception message and stack
1836: x_PersonId := NULL ; -- 4537865
1837: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1838: ,PA_DEBUG.g_err_stack);
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: raise;
1841:
1842: END get_person_id;

Line 1853: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_object_id');

1849: IS
1850: BEGIN
1851:
1852: -- initialize the error stack
1853: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_object_id');
1854: -- initialize the return status to success
1855: x_return_status := FND_API.G_RET_STS_SUCCESS;
1856:
1857:

Line 1866: PA_DEBUG.reset_err_stack;

1862: WHERE obj_name = P_objname;
1863:
1864:
1865: -- reset the error stack
1866: PA_DEBUG.reset_err_stack;
1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: x_objid := NULL ; -- 4537865

Line 1917: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_primary_contact');

1913: l_start_date DATE;
1914:
1915: BEGIN
1916: -- initialize the error stack
1917: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_primary_contact');
1918:
1919: -- initialize the return status to success
1920: x_return_status := FND_API.G_RET_STS_SUCCESS;
1921:

Line 2035: PA_DEBUG.reset_err_stack;

2031: x_msg_count := v_msg_count;
2032: END IF;
2033:
2034: -- reset the error stack
2035: PA_DEBUG.reset_err_stack;
2036:
2037:
2038: EXCEPTION
2039:

Line 2051: ,PA_DEBUG.g_err_stack);

2047: x_return_Status := NULL ;
2048:
2049: -- set the exception message and stack
2050: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'
2051: ,PA_DEBUG.g_err_stack);
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: -- dbms_output.put_line('missing');
2054: raise;
2055:

Line 2565: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_name');

2561: IS
2562: BEGIN
2563:
2564: -- initialize the error stack
2565: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_name');
2566: -- initialize the return status to success
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;
2568:
2569: IF p_person_id IS NOT NULL then

Line 2589: PA_DEBUG.reset_err_stack;

2585: x_person_name := null;
2586: END IF;
2587:
2588: -- reset the error stack
2589: PA_DEBUG.reset_err_stack;
2590:
2591: EXCEPTION
2592: WHEN NO_DATA_FOUND THEN
2593: x_person_name := null;

Line 2603: ,PA_DEBUG.g_err_stack);

2599: x_person_name := null;
2600:
2601: -- set the exception message and stack
2602: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'
2603: ,PA_DEBUG.g_err_stack);
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: raise;
2606:
2607: END get_person_name;

Line 2630: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_location_details');

2626: IS
2627: BEGIN
2628:
2629: -- initialize the error stack
2630: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_location_details');
2631: -- initialize the return status to success
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633:
2634: IF p_location_id IS NOT NULL then

Line 2661: PA_DEBUG.reset_err_stack;

2657: x_country := null;
2658: END IF;
2659:
2660: -- reset the error stack
2661: PA_DEBUG.reset_err_stack;
2662:
2663: EXCEPTION
2664: WHEN NO_DATA_FOUND THEN
2665: x_address_line_1 := null;

Line 2684: ,PA_DEBUG.g_err_stack);

2680: x_country := null;
2681:
2682: -- set the exception message and stack
2683: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'
2684: ,PA_DEBUG.g_err_stack);
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: raise;
2687:
2688: END get_location_details;

Line 2707: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_defaults');

2703: IS
2704: BEGIN
2705:
2706: -- initialize the error stack
2707: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_defaults');
2708: -- initialize the return status to success
2709: x_return_status := FND_API.G_RET_STS_SUCCESS;
2710:
2711: IF p_organization_id IS NOT NULL then

Line 2744: PA_DEBUG.reset_err_stack;

2740: x_default_cal_id := null;
2741: END IF;
2742:
2743: -- reset the error stack
2744: PA_DEBUG.reset_err_stack;
2745:
2746: EXCEPTION
2747: WHEN NO_DATA_FOUND THEN
2748: x_default_ou := null;

Line 2759: ,PA_DEBUG.g_err_stack);

2755: x_default_cal_id := null;
2756:
2757: -- set the exception message and stack
2758: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'
2759: ,PA_DEBUG.g_err_stack);
2760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2761: raise;
2762:
2763: END get_org_defaults;

Line 2786: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_exp_org');

2782: IS
2783: BEGIN
2784:
2785: -- initialize the error stack
2786: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_exp_org');
2787: -- initialize the return status to success
2788: x_return_status := FND_API.G_RET_STS_SUCCESS;
2789:
2790: x_valid := 'N';

Line 2817: PA_DEBUG.reset_err_stack;

2813:
2814: END IF;
2815:
2816: -- reset the error stack
2817: PA_DEBUG.reset_err_stack;
2818:
2819: EXCEPTION
2820: WHEN NO_DATA_FOUND THEN
2821: x_valid := 'N';

Line 2832: ,PA_DEBUG.g_err_stack);

2828: x_valid := 'N';
2829:
2830: -- set the exception message and stack
2831: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'
2832: ,PA_DEBUG.g_err_stack);
2833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2834: raise;
2835:
2836: END check_exp_org;

Line 2858: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_res_exists');

2854: IS
2855: BEGIN
2856:
2857: -- initialize the error stack
2858: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_res_exists');
2859: -- initialize the return status to success
2860: x_return_status := FND_API.G_RET_STS_SUCCESS;
2861:
2862: x_valid := 'N';

Line 2882: PA_DEBUG.reset_err_stack;

2878:
2879: END IF;
2880:
2881: -- reset the error stack
2882: PA_DEBUG.reset_err_stack;
2883:
2884: EXCEPTION
2885: WHEN NO_DATA_FOUND THEN
2886: x_valid := 'N';

Line 2895: ,PA_DEBUG.g_err_stack);

2891: x_valid := 'N';
2892:
2893: -- set the exception message and stack
2894: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'
2895: ,PA_DEBUG.g_err_stack);
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897: raise;
2898:
2899: END check_res_exists;

Line 3933: PA_DEBUG.set_err_stack('Validate_person');

3929: and resource_effective_end_date;
3930:
3931:
3932: BEGIN
3933: PA_DEBUG.set_err_stack('Validate_person');
3934:
3935: -------------------------------------------------------------------------
3936: --Cursor which checks if record exists in pa_resources_denorm
3937: --as of the p_Start_date

Line 3949: PA_DEBUG.Reset_Err_Stack;

3945: END IF;
3946: CLOSE validate_resource;
3947:
3948: IF x_return_status = 'S' THEN
3949: PA_DEBUG.Reset_Err_Stack;
3950: return;
3951: END IF;
3952:
3953: ------------------------------------------------------------

Line 3999: PA_DEBUG.Reset_Err_Stack;

3995: END IF;
3996: END IF;
3997: END IF;
3998:
3999: PA_DEBUG.Reset_Err_Stack;
4000:
4001: EXCEPTION
4002:
4003: WHEN OTHERS THEN

Line 4006: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

4002:
4003: WHEN OTHERS THEN
4004: -- Set the exception Message and the stack
4005: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'
4006: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4008: RAISE;
4009:
4010: END validate_person;

Line 4943: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');

4939:
4940: BEGIN
4941:
4942: -- initialize the error stack
4943: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');
4944: -- initialize the return status to success
4945: x_return_status := FND_API.G_RET_STS_SUCCESS;
4946:
4947: l_term_type := pa_resource_utils.get_term_type(p_person_id) ;

Line 5044: PA_DEBUG.reset_err_stack;

5040:
5041: x_invol_term := l_invol_term ;
5042:
5043: -- reset the error stack
5044: PA_DEBUG.reset_err_stack;
5045:
5046:
5047: EXCEPTION
5048: WHEN OTHERS THEN

Line 5088: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');

5084: l_msg_index_out NUMBER;
5085:
5086: BEGIN
5087: -- initialize the error stack
5088: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');
5089: -- initialize the return status to success
5090: x_return_status := FND_API.G_RET_STS_SUCCESS;
5091:
5092: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 5110: PA_DEBUG.reset_err_stack;

5106:
5107: END IF ; --IF l_resource_id <> -999
5108:
5109: -- reset the error stack
5110: PA_DEBUG.reset_err_stack;
5111:
5112: EXCEPTION
5113: WHEN OTHERS THEN
5114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5154: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');

5150: l_msg_index_out NUMBER;
5151:
5152: BEGIN
5153: -- initialize the error stack
5154: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');
5155: -- initialize the return status to success
5156: x_return_status := FND_API.G_RET_STS_SUCCESS;
5157:
5158: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 5177: PA_DEBUG.reset_err_stack;

5173:
5174: x_future_term_wf_flag := l_future_term_wf_flag ;
5175:
5176: -- reset the error stack
5177: PA_DEBUG.reset_err_stack;
5178:
5179: EXCEPTION
5180: WHEN OTHERS THEN
5181: x_future_term_wf_flag := NULL;

Line 5226: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_fte');

5222: l_msg_index_out NUMBER;
5223:
5224: BEGIN
5225: -- initialize the error stack
5226: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_fte');
5227: -- initialize the return status to success
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;
5229:
5230: SELECT distinct(resource_person_type)

Line 5276: PA_DEBUG.reset_err_stack;

5272:
5273: END IF ; --(trunc(l_end_date) > trunc(sysdate))
5274:
5275: -- reset the error stack
5276: PA_DEBUG.reset_err_stack;
5277:
5278: EXCEPTION
5279: WHEN OTHERS THEN
5280: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5320: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_valid_enddate');

5316: l_msg_index_out NUMBER;
5317:
5318: BEGIN
5319: -- initialize the error stack
5320: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_valid_enddate');
5321: -- initialize the return status to success
5322: x_return_status := FND_API.G_RET_STS_SUCCESS;
5323:
5324:

Line 5344: PA_DEBUG.reset_err_stack;

5340:
5341: END IF ;
5342:
5343: -- reset the error stack
5344: PA_DEBUG.reset_err_stack;
5345:
5346: EXCEPTION
5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5405: l_pa_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

5401: l_msg_count NUMBER;
5402: l_msg_data VARCHAR(2000);
5403: l_return_status VARCHAR2(1);
5404:
5405: l_pa_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5406:
5407: BEGIN
5408: -- initialize the error stack
5409: --

Line 5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');

5406:
5407: BEGIN
5408: -- initialize the error stack
5409: --
5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5411:
5412: IF (l_pa_debug_mode = 'Y') THEN
5413: pa_debug.write('PA_RESOURCE_UTILS',
5414: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);

Line 5412: IF (l_pa_debug_mode = 'Y') THEN

5408: -- initialize the error stack
5409: --
5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5411:
5412: IF (l_pa_debug_mode = 'Y') THEN
5413: pa_debug.write('PA_RESOURCE_UTILS',
5414: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);
5415: END IF;
5416:

Line 5413: pa_debug.write('PA_RESOURCE_UTILS',

5409: --
5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5411:
5412: IF (l_pa_debug_mode = 'Y') THEN
5413: pa_debug.write('PA_RESOURCE_UTILS',
5414: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);
5415: END IF;
5416:
5417:

Line 5432: IF (l_pa_debug_mode = 'Y') THEN

5428: x_msg_data => l_msg_data,
5429: x_msg_count => l_msg_count,
5430: x_return_status => l_return_status);
5431:
5432: IF (l_pa_debug_mode = 'Y') THEN
5433: pa_debug.write('PA_RESOURCE_UTILS',
5434: 'log: ' || 'in procedure is_term_as_of_sys_date, l_future_term_wf_flag: '||l_future_term_wf_flag, 3);
5435: END IF ;
5436:

Line 5433: pa_debug.write('PA_RESOURCE_UTILS',

5429: x_msg_count => l_msg_count,
5430: x_return_status => l_return_status);
5431:
5432: IF (l_pa_debug_mode = 'Y') THEN
5433: pa_debug.write('PA_RESOURCE_UTILS',
5434: 'log: ' || 'in procedure is_term_as_of_sys_date, l_future_term_wf_flag: '||l_future_term_wf_flag, 3);
5435: END IF ;
5436:
5437: OPEN c_act_term_date(l_person_id);

Line 5443: IF (l_pa_debug_mode = 'Y') THEN

5439:
5440: IF c_act_term_date%NOTFOUND THEN
5441: CLOSE c_act_term_date;
5442: resultout := wf_engine.eng_completed||':'||'E';
5443: IF (l_pa_debug_mode = 'Y') THEN
5444: pa_debug.write('PA_RESOURCE_UTILS',
5445: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5446: END IF;
5447:

Line 5444: pa_debug.write('PA_RESOURCE_UTILS',

5440: IF c_act_term_date%NOTFOUND THEN
5441: CLOSE c_act_term_date;
5442: resultout := wf_engine.eng_completed||':'||'E';
5443: IF (l_pa_debug_mode = 'Y') THEN
5444: pa_debug.write('PA_RESOURCE_UTILS',
5445: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5446: END IF;
5447:
5448: ELSE --IF c_act_term_date%NOTFOUND

Line 5451: IF (l_pa_debug_mode = 'Y') THEN

5447:
5448: ELSE --IF c_act_term_date%NOTFOUND
5449:
5450: CLOSE c_act_term_date;
5451: IF (l_pa_debug_mode = 'Y') THEN
5452: pa_debug.write('PA_RESOURCE_UTILS',
5453: 'log: ' || 'in procedure is_term_as_of_sys_date, l_end_date: '||l_end_date, 3);
5454: END IF;
5455:

Line 5452: pa_debug.write('PA_RESOURCE_UTILS',

5448: ELSE --IF c_act_term_date%NOTFOUND
5449:
5450: CLOSE c_act_term_date;
5451: IF (l_pa_debug_mode = 'Y') THEN
5452: pa_debug.write('PA_RESOURCE_UTILS',
5453: 'log: ' || 'in procedure is_term_as_of_sys_date, l_end_date: '||l_end_date, 3);
5454: END IF;
5455:
5456:

Line 5465: IF (l_pa_debug_mode = 'Y') THEN

5461: END IF ;
5462:
5463: END IF ; --IF c_act_term_date%NOTFOUND
5464:
5465: IF (l_pa_debug_mode = 'Y') THEN
5466: pa_debug.write('PA_RESOURCE_UTILS',
5467: 'log: ' || 'in procedure is_term_as_of_sys_date, resultout: '||resultout, 3);
5468: END IF;
5469:

Line 5466: pa_debug.write('PA_RESOURCE_UTILS',

5462:
5463: END IF ; --IF c_act_term_date%NOTFOUND
5464:
5465: IF (l_pa_debug_mode = 'Y') THEN
5466: pa_debug.write('PA_RESOURCE_UTILS',
5467: 'log: ' || 'in procedure is_term_as_of_sys_date, resultout: '||resultout, 3);
5468: END IF;
5469:
5470: