DBA Data[Home] [Help]

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.19.12020000.3 2013/03/19 15:34:31 svmohamm ship $
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: G_user_id NUMBER:=-999;

Line 667: if pa_control_items_utils.CheckCIActionAllowed(

663: -- this logic NOT executed for CREATE page
664: if p_ci_id is NOT NULL
665: AND p_status_control is not null then
666: l_ci_status := getCIStatus(p_ci_id) ;
667: if pa_control_items_utils.CheckCIActionAllowed(
668: 'CONTROL_ITEM',
669: l_ci_status ,
670: p_status_control ) <> 'Y' then
671: return 'N';

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

945: x_msg_data := '';
946:
947: -- Initialize the Error Stack
948: IF P_PA_DEBUG_MODE = 'Y' THEN
949: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
950: END IF;
951:
952: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
953:

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

1115:
1116: ROLLBACK;
1117:
1118: x_return_status := 'U';
1119: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
1120: p_procedure_name => 'ChangeCIStatus',
1121: p_error_text => SUBSTRB(SQLERRM,1,240));
1122:
1123: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1785: if pa_control_items_utils.CheckCIActionAllowed(

1781: -- this logic NOT executed for CREATE or LIST page
1782: if p_ci_id is NOT NULL
1783: AND p_status_control is not null then
1784: l_ci_status := getCIStatus(p_ci_id) ;
1785: if pa_control_items_utils.CheckCIActionAllowed(
1786: 'CONTROL_ITEM',
1787: l_ci_status ,
1788: p_status_control ) <> 'Y' then
1789: return 'N';

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

1928: EXCEPTION
1929: WHEN OTHERS THEN
1930:
1931: x_return_status := 'U';
1932: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
1933: p_procedure_name => 'GetDiagramUrl',
1934: p_error_text => SUBSTRB(SQLERRM,1,240));
1935:
1936: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2003: x_msg_count,
2004: x_msg_data,
2005: x_return_status);
2006:
2007: /* call pa_control_items_utils.changecistatus api to revert the status;
2008: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
2009: p_init_msg_list => FND_API.G_TRUE
2010: ,p_validate_only => FND_API.G_FALSE
2011: ,p_ci_id => p_ci_id

Line 2008: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (

2004: x_msg_data,
2005: x_return_status);
2006:
2007: /* call pa_control_items_utils.changecistatus api to revert the status;
2008: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
2009: p_init_msg_list => FND_API.G_TRUE
2010: ,p_validate_only => FND_API.G_FALSE
2011: ,p_ci_id => p_ci_id
2012: ,p_status => l_prev_status

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

2048: EXCEPTION
2049: WHEN OTHERS THEN
2050:
2051: x_return_status := 'U';
2052: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2053: p_procedure_name => 'AbortWorkflow',
2054: p_error_text => SUBSTRB(SQLERRM,1,240));
2055:
2056: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2151: WHEN FND_API.G_EXC_ERROR THEN
2152: x_return_status := 'E';
2153: WHEN OTHERS THEN
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2156: p_procedure_name => 'ADD_STATUS_CHANGE_COMMENT',
2157: p_error_text => SUBSTRB(SQLERRM,1,240));
2158: RAISE;
2159: END ADD_STATUS_CHANGE_COMMENT;

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

2175:
2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2180: p_procedure_name => 'DELETE_OBJ_STATUS_CHANGES',
2181: p_error_text => SUBSTRB(SQLERRM,1,240));
2182: RAISE;
2183: END DELETE_OBJ_STATUS_CHANGES;

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

2278: x_start_wf := l_start_wf;
2279:
2280: -- Initialize the Error Stack
2281: IF P_PA_DEBUG_MODE = 'Y' THEN
2282: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2283: END IF;
2284:
2285: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2286:

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

2684:
2685: ROLLBACK;
2686:
2687: x_return_status := 'U';
2688: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2689: p_procedure_name => 'ChangeCIStatus',
2690: p_error_text => SUBSTRB(SQLERRM,1,240));
2691:
2692: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2732: x_msg_data := '';
2733:
2734: -- Initialize the Error Stack
2735: IF P_PA_DEBUG_MODE = 'Y' THEN
2736: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2737: END IF;
2738:
2739: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2740:

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

2850:
2851: ROLLBACK;
2852:
2853: x_return_status := 'U';
2854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2855: p_procedure_name => 'ChangeCIStatus',
2856: p_error_text => SUBSTRB(SQLERRM,1,240));
2857:
2858: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');

2885: x_msg_data := '';
2886:
2887: -- Initialize the Error Stack
2888: IF P_PA_DEBUG_MODE = 'Y' THEN
2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');
2890: END IF;
2891:
2892: pa_debug.write_file('ChangeCIStatusWorking: p_pa_debug_mode :'||p_pa_debug_mode);
2893:

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

2949:
2950: ROLLBACK;
2951:
2952: x_return_status := 'U';
2953: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2954: p_procedure_name => 'ChangeCIStatusWorking',
2955: p_error_text => SUBSTRB(SQLERRM,1,240));
2956:
2957: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2964: END PA_CONTROL_ITEMS_UTILS;

2960: END ChangeCIStatusWorking;
2961:
2962: -- Bug#13683760 changes end.
2963:
2964: END PA_CONTROL_ITEMS_UTILS;