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_CONTROL_ITEMS_UTILS dependencies on PA_CONTROL_ITEMS_UTILS

Line 1: PACKAGE BODY PA_CONTROL_ITEMS_UTILS AS

1: PACKAGE BODY PA_CONTROL_ITEMS_UTILS AS
2: --$Header: PACICIUB.pls 120.12.12010000.2 2008/08/22 16:08:05 mumohan ship $
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: G_user_id NUMBER:=-999;

Line 623: if pa_control_items_utils.CheckCIActionAllowed(

619: -- this logic NOT executed for CREATE page
620: if p_ci_id is NOT NULL
621: AND p_status_control is not null then
622: l_ci_status := getCIStatus(p_ci_id) ;
623: if pa_control_items_utils.CheckCIActionAllowed(
624: 'CONTROL_ITEM',
625: l_ci_status ,
626: p_status_control ) <> 'Y' then
627: return 'N';

Line 899: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

895: x_msg_data := '';
896:
897: -- Initialize the Error Stack
898: IF P_PA_DEBUG_MODE = 'Y' THEN
899: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
900: END IF;
901:
902: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
903:

Line 1041: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

1037:
1038: ROLLBACK;
1039:
1040: x_return_status := 'U';
1041: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
1042: p_procedure_name => 'ChangeCIStatus',
1043: p_error_text => SUBSTRB(SQLERRM,1,240));
1044:
1045: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1689: if pa_control_items_utils.CheckCIActionAllowed(

1685: -- this logic NOT executed for CREATE or LIST page
1686: if p_ci_id is NOT NULL
1687: AND p_status_control is not null then
1688: l_ci_status := getCIStatus(p_ci_id) ;
1689: if pa_control_items_utils.CheckCIActionAllowed(
1690: 'CONTROL_ITEM',
1691: l_ci_status ,
1692: p_status_control ) <> 'Y' then
1693: return 'N';

Line 1836: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

1832: EXCEPTION
1833: WHEN OTHERS THEN
1834:
1835: x_return_status := 'U';
1836: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
1837: p_procedure_name => 'GetDiagramUrl',
1838: p_error_text => SUBSTRB(SQLERRM,1,240));
1839:
1840: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1911: /* call pa_control_items_utils.changecistatus api to revert the status;

1907: x_msg_count,
1908: x_msg_data,
1909: x_return_status);
1910:
1911: /* call pa_control_items_utils.changecistatus api to revert the status;
1912: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1913: p_init_msg_list => FND_API.G_TRUE
1914: ,p_validate_only => FND_API.G_FALSE
1915: ,p_ci_id => p_ci_id

Line 1912: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (

1908: x_msg_data,
1909: x_return_status);
1910:
1911: /* call pa_control_items_utils.changecistatus api to revert the status;
1912: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1913: p_init_msg_list => FND_API.G_TRUE
1914: ,p_validate_only => FND_API.G_FALSE
1915: ,p_ci_id => p_ci_id
1916: ,p_status => l_prev_status

Line 1956: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

1952: EXCEPTION
1953: WHEN OTHERS THEN
1954:
1955: x_return_status := 'U';
1956: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
1957: p_procedure_name => 'AbortWorkflow',
1958: p_error_text => SUBSTRB(SQLERRM,1,240));
1959:
1960: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2059: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

2055: WHEN FND_API.G_EXC_ERROR THEN
2056: x_return_status := 'E';
2057: WHEN OTHERS THEN
2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2060: p_procedure_name => 'ADD_STATUS_CHANGE_COMMENT',
2061: p_error_text => SUBSTRB(SQLERRM,1,240));
2062: RAISE;
2063: END ADD_STATUS_CHANGE_COMMENT;

Line 2083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

2079:
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2084: p_procedure_name => 'DELETE_OBJ_STATUS_CHANGES',
2085: p_error_text => SUBSTRB(SQLERRM,1,240));
2086: RAISE;
2087: END DELETE_OBJ_STATUS_CHANGES;

Line 2185: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

2181: x_start_wf := l_start_wf;
2182:
2183: -- Initialize the Error Stack
2184: IF P_PA_DEBUG_MODE = 'Y' THEN
2185: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2186: END IF;
2187:
2188: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2189:

Line 2577: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

2573:
2574: ROLLBACK;
2575:
2576: x_return_status := 'U';
2577: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2578: p_procedure_name => 'ChangeCIStatus',
2579: p_error_text => SUBSTRB(SQLERRM,1,240));
2580:
2581: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2625: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

2621: x_msg_data := '';
2622:
2623: -- Initialize the Error Stack
2624: IF P_PA_DEBUG_MODE = 'Y' THEN
2625: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2626: END IF;
2627:
2628: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2629:

Line 2743: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

2739:
2740: ROLLBACK;
2741:
2742: x_return_status := 'U';
2743: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2744: p_procedure_name => 'ChangeCIStatus',
2745: p_error_text => SUBSTRB(SQLERRM,1,240));
2746:
2747: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2753: END PA_CONTROL_ITEMS_UTILS;

2749:
2750: END PostChangeCIStatus;
2751:
2752:
2753: END PA_CONTROL_ITEMS_UTILS;