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 1471: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');

1467: BEGIN
1468:
1469:
1470: -- initialize the error stack
1471: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');
1472: -- initialize the return status to success
1473: x_return_status := FND_API.G_RET_STS_SUCCESS;
1474:
1475:

Line 1499: PA_DEBUG.reset_err_stack;

1495: AND pep.effective_end_date;
1496: -- Bug 4684198 - remove nvl on effective_end_date - col is not null
1497:
1498: -- reset the error stack
1499: PA_DEBUG.reset_err_stack;
1500:
1501: EXCEPTION
1502: WHEN NO_DATA_FOUND THEN
1503: -- as discussed with Mr.Ramesh,this is not a business rule violation

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

1533: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1534: IS
1535: BEGIN
1536: -- initialize the error stack
1537: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_manager_id_name');
1538: -- initialize the return status to success
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541: --Modified code for future dated person

Line 1555: PA_DEBUG.reset_err_stack;

1551: AND pep.effective_end_date
1552: AND primary_flag = 'Y'
1553: AND assignment_type in ('C', 'E'); /* added for bug 2745823 */
1554: -- reset the error stack
1555: PA_DEBUG.reset_err_stack;
1556:
1557: EXCEPTION
1558: WHEN NO_DATA_FOUND THEN
1559: -- as discussed with Mr.Ramesh,this is not a business rule violation

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

1609: IS
1610: BEGIN
1611:
1612: -- initialize the error stack
1613: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_id');
1614: -- initialize the return status to success
1615: x_return_status := FND_API.G_RET_STS_SUCCESS;
1616:
1617: -- pick the Organization id for the Current Assignment

Line 1630: PA_DEBUG.reset_err_stack;

1626: AND primary_flag = 'Y'
1627: AND assignment_type in ('E', 'C'); /* added for bug 2745823 */
1628:
1629: -- reset the error stack
1630: PA_DEBUG.reset_err_stack;
1631:
1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: -- set the exception message and stack

Line 1636: -- ,PA_DEBUG.g_err_stack);

1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: -- set the exception message and stack
1635: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1636: -- ,PA_DEBUG.g_err_stack);
1637: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: -- raise;
1639: -- null; 4537865
1640: x_orgid := NULL ;

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

1658:
1659: BEGIN
1660:
1661: -- initialize the error stack
1662: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_id');
1663: -- initialize the return status to success
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: IF P_resourceid is NOT NULL then

Line 1707: PA_DEBUG.reset_err_stack;

1703:
1704: END IF;
1705:
1706: -- reset the error stack
1707: PA_DEBUG.reset_err_stack;
1708:
1709:
1710: EXCEPTION
1711: WHEN NO_DATA_FOUND THEN

Line 1726: ,PA_DEBUG.g_err_stack);

1722: WHEN OTHERS THEN
1723: -- set the exception message and stack
1724: x_PersonId := NULL ; -- 4537865
1725: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1726: ,PA_DEBUG.g_err_stack);
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: raise;
1729:
1730: END get_person_id;

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

1737: IS
1738: BEGIN
1739:
1740: -- initialize the error stack
1741: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_object_id');
1742: -- initialize the return status to success
1743: x_return_status := FND_API.G_RET_STS_SUCCESS;
1744:
1745:

Line 1754: PA_DEBUG.reset_err_stack;

1750: WHERE obj_name = P_objname;
1751:
1752:
1753: -- reset the error stack
1754: PA_DEBUG.reset_err_stack;
1755:
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: x_objid := NULL ; -- 4537865

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

1801: l_start_date DATE;
1802:
1803: BEGIN
1804: -- initialize the error stack
1805: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_primary_contact');
1806:
1807: -- initialize the return status to success
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809:

Line 1918: PA_DEBUG.reset_err_stack;

1914: x_msg_count := v_msg_count;
1915: END IF;
1916:
1917: -- reset the error stack
1918: PA_DEBUG.reset_err_stack;
1919:
1920:
1921: EXCEPTION
1922:

Line 1934: ,PA_DEBUG.g_err_stack);

1930: x_return_Status := NULL ;
1931:
1932: -- set the exception message and stack
1933: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'
1934: ,PA_DEBUG.g_err_stack);
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: -- dbms_output.put_line('missing');
1937: raise;
1938:

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

2444: IS
2445: BEGIN
2446:
2447: -- initialize the error stack
2448: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_name');
2449: -- initialize the return status to success
2450: x_return_status := FND_API.G_RET_STS_SUCCESS;
2451:
2452: IF p_person_id IS NOT NULL then

Line 2472: PA_DEBUG.reset_err_stack;

2468: x_person_name := null;
2469: END IF;
2470:
2471: -- reset the error stack
2472: PA_DEBUG.reset_err_stack;
2473:
2474: EXCEPTION
2475: WHEN NO_DATA_FOUND THEN
2476: x_person_name := null;

Line 2486: ,PA_DEBUG.g_err_stack);

2482: x_person_name := null;
2483:
2484: -- set the exception message and stack
2485: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'
2486: ,PA_DEBUG.g_err_stack);
2487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2488: raise;
2489:
2490: END get_person_name;

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

2509: IS
2510: BEGIN
2511:
2512: -- initialize the error stack
2513: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_location_details');
2514: -- initialize the return status to success
2515: x_return_status := FND_API.G_RET_STS_SUCCESS;
2516:
2517: IF p_location_id IS NOT NULL then

Line 2544: PA_DEBUG.reset_err_stack;

2540: x_country := null;
2541: END IF;
2542:
2543: -- reset the error stack
2544: PA_DEBUG.reset_err_stack;
2545:
2546: EXCEPTION
2547: WHEN NO_DATA_FOUND THEN
2548: x_address_line_1 := null;

Line 2567: ,PA_DEBUG.g_err_stack);

2563: x_country := null;
2564:
2565: -- set the exception message and stack
2566: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'
2567: ,PA_DEBUG.g_err_stack);
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2569: raise;
2570:
2571: END get_location_details;

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

2586: IS
2587: BEGIN
2588:
2589: -- initialize the error stack
2590: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_defaults');
2591: -- initialize the return status to success
2592: x_return_status := FND_API.G_RET_STS_SUCCESS;
2593:
2594: IF p_organization_id IS NOT NULL then

Line 2627: PA_DEBUG.reset_err_stack;

2623: x_default_cal_id := null;
2624: END IF;
2625:
2626: -- reset the error stack
2627: PA_DEBUG.reset_err_stack;
2628:
2629: EXCEPTION
2630: WHEN NO_DATA_FOUND THEN
2631: x_default_ou := null;

Line 2642: ,PA_DEBUG.g_err_stack);

2638: x_default_cal_id := null;
2639:
2640: -- set the exception message and stack
2641: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'
2642: ,PA_DEBUG.g_err_stack);
2643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2644: raise;
2645:
2646: END get_org_defaults;

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

2665: IS
2666: BEGIN
2667:
2668: -- initialize the error stack
2669: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_exp_org');
2670: -- initialize the return status to success
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672:
2673: x_valid := 'N';

Line 2700: PA_DEBUG.reset_err_stack;

2696:
2697: END IF;
2698:
2699: -- reset the error stack
2700: PA_DEBUG.reset_err_stack;
2701:
2702: EXCEPTION
2703: WHEN NO_DATA_FOUND THEN
2704: x_valid := 'N';

Line 2715: ,PA_DEBUG.g_err_stack);

2711: x_valid := 'N';
2712:
2713: -- set the exception message and stack
2714: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'
2715: ,PA_DEBUG.g_err_stack);
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2717: raise;
2718:
2719: END check_exp_org;

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

2737: IS
2738: BEGIN
2739:
2740: -- initialize the error stack
2741: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_res_exists');
2742: -- initialize the return status to success
2743: x_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: x_valid := 'N';

Line 2765: PA_DEBUG.reset_err_stack;

2761:
2762: END IF;
2763:
2764: -- reset the error stack
2765: PA_DEBUG.reset_err_stack;
2766:
2767: EXCEPTION
2768: WHEN NO_DATA_FOUND THEN
2769: x_valid := 'N';

Line 2778: ,PA_DEBUG.g_err_stack);

2774: x_valid := 'N';
2775:
2776: -- set the exception message and stack
2777: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'
2778: ,PA_DEBUG.g_err_stack);
2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2780: raise;
2781:
2782: END check_res_exists;

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

3593: and resource_effective_end_date;
3594:
3595:
3596: BEGIN
3597: PA_DEBUG.set_err_stack('Validate_person');
3598:
3599: -------------------------------------------------------------------------
3600: --Cursor which checks if record exists in pa_resources_denorm
3601: --as of the p_Start_date

Line 3613: PA_DEBUG.Reset_Err_Stack;

3609: END IF;
3610: CLOSE validate_resource;
3611:
3612: IF x_return_status = 'S' THEN
3613: PA_DEBUG.Reset_Err_Stack;
3614: return;
3615: END IF;
3616:
3617: ------------------------------------------------------------

Line 3663: PA_DEBUG.Reset_Err_Stack;

3659: END IF;
3660: END IF;
3661: END IF;
3662:
3663: PA_DEBUG.Reset_Err_Stack;
3664:
3665: EXCEPTION
3666:
3667: WHEN OTHERS THEN

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

3666:
3667: WHEN OTHERS THEN
3668: -- Set the exception Message and the stack
3669: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'
3670: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3672: RAISE;
3673:
3674: END validate_person;

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

4583:
4584: BEGIN
4585:
4586: -- initialize the error stack
4587: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');
4588: -- initialize the return status to success
4589: x_return_status := FND_API.G_RET_STS_SUCCESS;
4590:
4591: l_term_type := pa_resource_utils.get_term_type(p_person_id) ;

Line 4688: PA_DEBUG.reset_err_stack;

4684:
4685: x_invol_term := l_invol_term ;
4686:
4687: -- reset the error stack
4688: PA_DEBUG.reset_err_stack;
4689:
4690:
4691: EXCEPTION
4692: WHEN OTHERS THEN

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

4728: l_msg_index_out NUMBER;
4729:
4730: BEGIN
4731: -- initialize the error stack
4732: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');
4733: -- initialize the return status to success
4734: x_return_status := FND_API.G_RET_STS_SUCCESS;
4735:
4736: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 4754: PA_DEBUG.reset_err_stack;

4750:
4751: END IF ; --IF l_resource_id <> -999
4752:
4753: -- reset the error stack
4754: PA_DEBUG.reset_err_stack;
4755:
4756: EXCEPTION
4757: WHEN OTHERS THEN
4758: x_return_status := FND_API.G_RET_STS_ERROR;

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

4794: l_msg_index_out NUMBER;
4795:
4796: BEGIN
4797: -- initialize the error stack
4798: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');
4799: -- initialize the return status to success
4800: x_return_status := FND_API.G_RET_STS_SUCCESS;
4801:
4802: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 4821: PA_DEBUG.reset_err_stack;

4817:
4818: x_future_term_wf_flag := l_future_term_wf_flag ;
4819:
4820: -- reset the error stack
4821: PA_DEBUG.reset_err_stack;
4822:
4823: EXCEPTION
4824: WHEN OTHERS THEN
4825: x_future_term_wf_flag := NULL;

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

4866: l_msg_index_out NUMBER;
4867:
4868: BEGIN
4869: -- initialize the error stack
4870: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_fte');
4871: -- initialize the return status to success
4872: x_return_status := FND_API.G_RET_STS_SUCCESS;
4873:
4874: SELECT distinct(resource_person_type)

Line 4920: PA_DEBUG.reset_err_stack;

4916:
4917: END IF ; --(trunc(l_end_date) > trunc(sysdate))
4918:
4919: -- reset the error stack
4920: PA_DEBUG.reset_err_stack;
4921:
4922: EXCEPTION
4923: WHEN OTHERS THEN
4924: x_return_status := FND_API.G_RET_STS_ERROR;

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

4960: l_msg_index_out NUMBER;
4961:
4962: BEGIN
4963: -- initialize the error stack
4964: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_valid_enddate');
4965: -- initialize the return status to success
4966: x_return_status := FND_API.G_RET_STS_SUCCESS;
4967:
4968:

Line 4988: PA_DEBUG.reset_err_stack;

4984:
4985: END IF ;
4986:
4987: -- reset the error stack
4988: PA_DEBUG.reset_err_stack;
4989:
4990: EXCEPTION
4991: WHEN OTHERS THEN
4992: x_return_status := FND_API.G_RET_STS_ERROR;

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

5045: l_msg_count NUMBER;
5046: l_msg_data VARCHAR(2000);
5047: l_return_status VARCHAR2(1);
5048:
5049: l_pa_debug_mode VARCHAR2(1):= NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5050:
5051: BEGIN
5052: -- initialize the error stack
5053: --

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

5050:
5051: BEGIN
5052: -- initialize the error stack
5053: --
5054: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5055:
5056: IF (l_pa_debug_mode = 'Y') THEN
5057: pa_debug.write('PA_RESOURCE_UTILS',
5058: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);

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

5052: -- initialize the error stack
5053: --
5054: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5055:
5056: IF (l_pa_debug_mode = 'Y') THEN
5057: pa_debug.write('PA_RESOURCE_UTILS',
5058: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);
5059: END IF;
5060:

Line 5057: pa_debug.write('PA_RESOURCE_UTILS',

5053: --
5054: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5055:
5056: IF (l_pa_debug_mode = 'Y') THEN
5057: pa_debug.write('PA_RESOURCE_UTILS',
5058: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);
5059: END IF;
5060:
5061:

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

5072: x_msg_data => l_msg_data,
5073: x_msg_count => l_msg_count,
5074: x_return_status => l_return_status);
5075:
5076: IF (l_pa_debug_mode = 'Y') THEN
5077: pa_debug.write('PA_RESOURCE_UTILS',
5078: 'log: ' || 'in procedure is_term_as_of_sys_date, l_future_term_wf_flag: '||l_future_term_wf_flag, 3);
5079: END IF ;
5080:

Line 5077: pa_debug.write('PA_RESOURCE_UTILS',

5073: x_msg_count => l_msg_count,
5074: x_return_status => l_return_status);
5075:
5076: IF (l_pa_debug_mode = 'Y') THEN
5077: pa_debug.write('PA_RESOURCE_UTILS',
5078: 'log: ' || 'in procedure is_term_as_of_sys_date, l_future_term_wf_flag: '||l_future_term_wf_flag, 3);
5079: END IF ;
5080:
5081: OPEN c_act_term_date(l_person_id);

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

5083:
5084: IF c_act_term_date%NOTFOUND THEN
5085: CLOSE c_act_term_date;
5086: resultout := wf_engine.eng_completed||':'||'E';
5087: IF (l_pa_debug_mode = 'Y') THEN
5088: pa_debug.write('PA_RESOURCE_UTILS',
5089: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5090: END IF;
5091:

Line 5088: pa_debug.write('PA_RESOURCE_UTILS',

5084: IF c_act_term_date%NOTFOUND THEN
5085: CLOSE c_act_term_date;
5086: resultout := wf_engine.eng_completed||':'||'E';
5087: IF (l_pa_debug_mode = 'Y') THEN
5088: pa_debug.write('PA_RESOURCE_UTILS',
5089: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5090: END IF;
5091:
5092: ELSE --IF c_act_term_date%NOTFOUND

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

5091:
5092: ELSE --IF c_act_term_date%NOTFOUND
5093:
5094: CLOSE c_act_term_date;
5095: IF (l_pa_debug_mode = 'Y') THEN
5096: pa_debug.write('PA_RESOURCE_UTILS',
5097: 'log: ' || 'in procedure is_term_as_of_sys_date, l_end_date: '||l_end_date, 3);
5098: END IF;
5099:

Line 5096: pa_debug.write('PA_RESOURCE_UTILS',

5092: ELSE --IF c_act_term_date%NOTFOUND
5093:
5094: CLOSE c_act_term_date;
5095: IF (l_pa_debug_mode = 'Y') THEN
5096: pa_debug.write('PA_RESOURCE_UTILS',
5097: 'log: ' || 'in procedure is_term_as_of_sys_date, l_end_date: '||l_end_date, 3);
5098: END IF;
5099:
5100:

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

5105: END IF ;
5106:
5107: END IF ; --IF c_act_term_date%NOTFOUND
5108:
5109: IF (l_pa_debug_mode = 'Y') THEN
5110: pa_debug.write('PA_RESOURCE_UTILS',
5111: 'log: ' || 'in procedure is_term_as_of_sys_date, resultout: '||resultout, 3);
5112: END IF;
5113:

Line 5110: pa_debug.write('PA_RESOURCE_UTILS',

5106:
5107: END IF ; --IF c_act_term_date%NOTFOUND
5108:
5109: IF (l_pa_debug_mode = 'Y') THEN
5110: pa_debug.write('PA_RESOURCE_UTILS',
5111: 'log: ' || 'in procedure is_term_as_of_sys_date, resultout: '||resultout, 3);
5112: END IF;
5113:
5114: