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

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 130: from pa_control_items ci,pa_ci_types_b ci_type1 ,pa_ci_types_b ci_type2

126: if(impact_bud_type_code = 'DIRECT_COST_ENTRY') then
127: begin
128: select 'Y'
129: into temp
130: from pa_control_items ci,pa_ci_types_b ci_type1 ,pa_ci_types_b ci_type2
131: where ci.ci_type_id = ci_type2.ci_type_id
132: and ci_type2.impact_budget_type_code=impact_bud_type_code
133: and ci.ci_id = p_ci_id_2
134: and ci_type1.ci_type_id = p_ci_type_id_1

Line 146: from pa_control_items ci,pa_ci_types_b ci_type

142: begin
143: if(impact_bud_type_code = 'EDIT_PLANNED_AMOUNTS') then
144: select 'Y'
145: into temp
146: from pa_control_items ci,pa_ci_types_b ci_type
147: where ci.ci_type_id = ci_type.ci_type_id
148: and ci_type.impact_budget_type_code=impact_bud_type_code
149: and ci.ci_id = p_ci_id_2;
150: end if;

Line 257: FROM pa_control_items

253:
254: CURSOR get_current_status
255: IS
256: SELECT status_code
257: FROM pa_control_items
258: WHERE ci_id = p_ci_id;
259:
260:
261: BEGIN

Line 316: from pa_control_items ci

312: ,status_code
313: ,ps.project_system_status_code system_status_code
314: ,cit.ci_type_class_code ci_type_class
315: ,cit.approval_required_flag approval_required_flag
316: from pa_control_items ci
317: ,pa_ci_types_b cit
318: ,pa_project_statuses ps
319: where ci.ci_id = p_ci_id
320: and ci.ci_type_id = cit.ci_type_id

Line 427: from pa_control_items

423:
424: IF g_CI_id is NULL or g_CI_id <> p_ci_id then
425: select status_code
426: into l_ci_status
427: from pa_control_items
428: where ci_id = p_ci_id ;
429: g_ci_status := l_ci_status ;
430: END IF ;
431:

Line 459: ,pa_control_items CI

455: into l_ci_type_has_impact
456: from dual
457: where exists ( select '1'
458: from pa_ci_impact_type_usage CIIU
459: ,pa_control_items CI
460: where CIIU.ci_type_id= CI.ci_type_id
461: and CI.CI_id = p_ci_id ) ;
462: g_ci_type_has_impact := l_ci_type_has_impact ;
463: END IF ;

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 727: pa_control_items_workflow.start_workflow

723: l_wf_process_name IS NOT NULL THEN
724:
725: --debug_msg_s1 ('start workflow ' || l_wf_item_type || ':' || l_wf_process_name);
726:
727: pa_control_items_workflow.start_workflow
728: (
729: l_wf_item_type
730: , l_wf_process_name
731: , p_ci_id

Line 797: FROM pa_control_items

793:
794: CURSOR get_project_id
795: IS
796: SELECT project_id
797: FROM pa_control_items
798: WHERE ci_id = p_ci_id;
799:
800: BEGIN
801:

Line 825: pa_control_items_workflow.cancel_workflow

821:
822: else
823:
824: --debug_msg_s1 ('b4 canceling workflow ' || x_return_status);
825: pa_control_items_workflow.cancel_workflow
826: (
827: l_wf_item_type
828: , l_item_key
829: , x_msg_count

Line 867: FROM pa_control_items pci

863: IS
864: CURSOR get_ci_info
865: IS
866: SELECT pci.status_code, pci.project_id
867: FROM pa_control_items pci
868: WHERE ci_id = p_ci_id;
869:
870: CURSOR get_status_name(l_code varchar2)
871: IS SELECT meaning

Line 879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

875:
876: CURSOR get_control_item_type
877: IS
878: SELECT pl.meaning,pl.lookup_code
879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
880: WHERE
881: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
882: and pci.ci_type_id = pcit.ci_type_id
883: and pl.lookup_code = pcit.ci_type_class_code

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 985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

981: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
982: -- debug_msg_s1 ('6 ' || x_return_status);
983:
984: IF P_PA_DEBUG_MODE = 'Y' THEN
985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
986: END IF;
987:
988: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
989: 1.0,

Line 988: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

984: IF P_PA_DEBUG_MODE = 'Y' THEN
985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
986: END IF;
987:
988: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
989: 1.0,
990: p_init_msg_list,
991: p_commit,
992: p_validate_only,

Line 1002: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

998: x_msg_count,
999: x_msg_data
1000: );
1001: IF P_PA_DEBUG_MODE = 'Y' THEN
1002: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
1003: END IF;
1004:
1005:
1006: --Bug # 4618856 - if statement is added to check the return status

Line 1070: pa_control_items_workflow.START_NOTIFICATION_WF

1066: l_process_name := 'PA_CI_ACTION_ASMT_SIGN_OFF';
1067: else
1068: l_process_name := 'PA_CI_ACTION_ASMT_NO_SIGN_OFF';
1069: end if;
1070: pa_control_items_workflow.START_NOTIFICATION_WF
1071: ( p_item_type => 'PAWFCIAC'
1072: ,p_process_name => l_process_name
1073: ,p_ci_id => p_ci_id
1074: ,p_action_id => l_ci_action_id

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 1251: pa_control_items ci

1247: /***
1248: SELECT ci_type_class_code, approval_required_flag
1249: INTO l_type, l_approval_required
1250: FROM pa_ci_types_b cit,
1251: pa_control_items ci
1252: WHERE ci.ci_id = p_ci_id
1253: and cit.ci_type_id = ci.ci_type_id;
1254:
1255: IF l_type IN ('CHANGE_ORDER', 'CHANGE_REQUEST') THEN

Line 1273: pa_control_items ci

1269: else 'A'
1270: end ) l_approval_required
1271: INTO l_approval_required
1272: FROM pa_ci_types_b cit,
1273: pa_control_items ci
1274: WHERE ci.ci_id = p_ci_id
1275: and cit.ci_type_id = ci.ci_type_id
1276: and cit.ci_type_class_code IN ('CHANGE_ORDER', 'CHANGE_REQUEST', 'ISSUE'); --9882753
1277:

Line 1302: ,pa_control_items ci

1298:
1299: select
1300: resolution_required_flag into l_resolution_required
1301: from pa_ci_types_b cit
1302: ,pa_control_items ci
1303: where ci.ci_id = p_ci_id
1304: and cit.ci_type_id = ci.ci_type_id;
1305:
1306: return l_resolution_required;

Line 1321: ,pa_control_items ci

1317: cursor get_resolution_info is
1318: select
1319: resolution_required_flag, resolution_code_id, resolution
1320: from pa_ci_types_b cit
1321: ,pa_control_items ci
1322: where ci.ci_id = p_ci_id
1323: and cit.ci_type_id = ci.ci_type_id;
1324:
1325: l_has_resolution varchar2(1) := 'Y';

Line 1327: l_res_code pa_control_items.resolution_code_id%TYPE;

1323: and cit.ci_type_id = ci.ci_type_id;
1324:
1325: l_has_resolution varchar2(1) := 'Y';
1326: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;
1327: l_res_code pa_control_items.resolution_code_id%TYPE;
1328: l_res_comment pa_control_items.resolution%TYPE;
1329: BEGIN
1330: if p_ci_id is NULL then
1331: return NULL;

Line 1328: l_res_comment pa_control_items.resolution%TYPE;

1324:
1325: l_has_resolution varchar2(1) := 'Y';
1326: l_res_required pa_ci_types_vl.resolution_required_flag%TYPE;
1327: l_res_code pa_control_items.resolution_code_id%TYPE;
1328: l_res_comment pa_control_items.resolution%TYPE;
1329: BEGIN
1330: if p_ci_id is NULL then
1331: return NULL;
1332: end if;

Line 1360: ,pa_control_items ci

1356:
1357: select
1358: ci_type_class_code into l_type_class_code
1359: from pa_ci_types_b cit
1360: ,pa_control_items ci
1361: where ci.ci_id = p_ci_id
1362: and cit.ci_type_id = ci.ci_type_id;
1363:
1364: return l_type_class_code;

Line 1384: from pa_control_items ci

1380: BEGIN
1381: IF p_CI_id is not NULL then
1382: select ps.project_system_status_code
1383: into l_ci_system_status
1384: from pa_control_items ci
1385: ,pa_project_statuses ps
1386: where ci_id = p_ci_id
1387: and ps.project_status_code = nvl(ci.status_code,' ');
1388: END IF ;

Line 1534: from pa_control_items

1530: is
1531: cursor c_non_draft_ci is
1532: select
1533: ci_id
1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';

Line 1536: where pa_control_items.project_id = p_project_id

1532: select
1533: ci_id
1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1539:
1540: publishedCI c_non_draft_ci%rowtype;

Line 1537: and pa_control_items.status_code = pa_project_statuses.project_status_code

1533: ci_id
1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1539:
1540: publishedCI c_non_draft_ci%rowtype;
1541: hasNonDraftCI VARCHAR2(1) := 'Y';

Line 1585: FROM pa_control_items

1581: tmp NUMBER;
1582: BEGIN
1583: SELECT 1
1584: INTO tmp
1585: FROM pa_control_items
1586: WHERE project_id = p_project_id
1587: AND ( ( p_task_id IS NOT NULL
1588: AND object_type='PA_TASKS'
1589: AND object_id=p_task_id)

Line 1628: FROM pa_control_items ci,

1624: tmp NUMBER;
1625: BEGIN
1626: SELECT 1
1627: INTO tmp
1628: FROM pa_control_items ci,
1629: pa_class_codes cc
1630: WHERE cc.class_category = p_class_category
1631: AND cc.class_code = p_class_code
1632: AND ( ci.classification_code_id = cc.class_code_id

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 1813: from pa_control_items pci, pa_ci_types_b pctb

1809: merged the similar select for change order/request/issue using the bind variable p_item_type*/
1810: if (p_item_type = 'ISSUE' or p_item_type = 'CHANGE_ORDER' or p_item_type = 'CHANGE_REQUEST') then
1811: select count(*)
1812: into tot_num
1813: from pa_control_items pci, pa_ci_types_b pctb
1814: where pci.project_id = p_project_id
1815: and pci.object_type = p_object_type
1816: and pci.object_id = p_object_id
1817: and pci.ci_type_id = pctb.ci_type_id

Line 1828: from pa_control_items pci, pa_ci_types_b pctb

1824:
1825: elsif (p_item_type = 'CHANGE') then
1826: select count(*)
1827: into tot_num
1828: from pa_control_items pci, pa_ci_types_b pctb
1829: where pci.project_id = p_project_id
1830: and pci.object_type = p_object_type
1831: and pci.object_id = p_object_id
1832: and pci.ci_type_id = pctb.ci_type_id

Line 1843: -- from pa_control_items pci, pa_ci_types_b pctb

1839:
1840: -- elsif (p_item_type = 'CHANGE_ORDER') then
1841: -- select count(*)
1842: -- into tot_num
1843: -- from pa_control_items pci, pa_ci_types_b pctb
1844: -- where pci.project_id = p_project_id
1845: -- and pci.object_type = p_object_type
1846: -- and pci.object_id = p_object_id
1847: -- and pci.ci_type_id = pctb.ci_type_id

Line 1858: -- from pa_control_items pci, pa_ci_types_b pctb

1854:
1855: -- elsif (p_item_type = 'CHANGE_REQUEST') then
1856: -- select count(*)
1857: -- into tot_num
1858: -- from pa_control_items pci, pa_ci_types_b pctb
1859: -- where pci.project_id = p_project_id
1860: -- and pci.object_type = p_object_type
1861: -- and pci.object_id = p_object_id
1862: -- and pci.ci_type_id = pctb.ci_type_id

Line 1891: pa_control_items ci

1887: cursor c_wf_type is
1888: SELECT ps.workflow_item_type,
1889: ps.workflow_process
1890: FROM pa_project_statuses ps,
1891: pa_control_items ci
1892: WHERE ci.ci_id = p_ci_id
1893: and ci.status_code = ps.project_status_code
1894: and ps.enable_wf_flag = 'Y'
1895: and ps.wf_success_status_code is NOT NULL

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 1952: pa_control_items ci

1948: cursor c_wf_type is
1949: SELECT ps.workflow_item_type,
1950: ps.workflow_process
1951: FROM pa_project_statuses ps,
1952: pa_control_items ci
1953: WHERE ci.ci_id = p_ci_id
1954: and ci.status_code = ps.project_status_code
1955: and ps.enable_wf_flag = 'Y'
1956: and ps.wf_success_status_code is NOT NULL

Line 2000: pa_control_items_workflow.cancel_workflow

1996: OPEN get_prev_status(p_ci_id);
1997: FETCH get_prev_status INTO l_prev_status, l_curr_status;
1998: CLOSE get_prev_status;
1999:
2000: pa_control_items_workflow.cancel_workflow
2001: (l_wf_item_type,
2002: l_item_key,
2003: x_msg_count,
2004: x_msg_data,

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 2020: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

2016: ,x_msg_count => x_msg_count
2017: ,x_msg_data => x_msg_data);
2018: */
2019:
2020: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
2021: p_api_version => 1.0
2022: ,p_init_msg_list => FND_API.G_TRUE
2023: ,p_validate_only => FND_API.G_FALSE
2024: ,p_ci_id => p_ci_id

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 2206: FROM pa_control_items pci

2202: IS
2203: CURSOR get_ci_info
2204: IS
2205: SELECT pci.status_code, pci.project_id
2206: FROM pa_control_items pci
2207: WHERE ci_id = p_ci_id;
2208:
2209:
2210: CURSOR get_status_name(l_code varchar2)

Line 2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

2215:
2216: CURSOR get_control_item_type
2217: IS
2218: SELECT pl.meaning,pl.lookup_code
2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
2220: WHERE
2221: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
2222: and pci.ci_type_id = pcit.ci_type_id
2223: and pl.lookup_code = pcit.ci_type_class_code

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 2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');

2748: IF l_next_sys_status = 'CI_CANCELED' THEN
2749: -- set included CR status to APPROVED
2750:
2751: IF P_PA_DEBUG_MODE = 'Y' THEN
2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2753: END IF;
2754:
2755: pa_control_items_pvt.change_included_cr_status
2756: (p_ci_id,

Line 2755: pa_control_items_pvt.change_included_cr_status

2751: IF P_PA_DEBUG_MODE = 'Y' THEN
2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2753: END IF;
2754:
2755: pa_control_items_pvt.change_included_cr_status
2756: (p_ci_id,
2757: x_return_status,
2758: x_msg_count,
2759: x_msg_data

Line 2763: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');

2759: x_msg_data
2760: );
2761:
2762: IF P_PA_DEBUG_MODE = 'Y' THEN
2763: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');
2764: END IF;
2765:
2766: ----- call delete included items api here
2767:

Line 2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');

2765:
2766: ----- call delete included items api here
2767:
2768: IF P_PA_DEBUG_MODE = 'Y' THEN
2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2770: END IF;
2771:
2772: pa_control_items_pvt.delete_all_included_crs
2773: (p_validate_only => 'F',

Line 2772: pa_control_items_pvt.delete_all_included_crs

2768: IF P_PA_DEBUG_MODE = 'Y' THEN
2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2770: END IF;
2771:
2772: pa_control_items_pvt.delete_all_included_crs
2773: (p_validate_only => 'F',
2774: p_init_msg_list => 'F',
2775: p_ci_id => p_ci_id,
2776: x_return_status => x_return_status,

Line 2781: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');

2777: x_msg_count => x_msg_count,
2778: x_msg_data => x_msg_data);
2779:
2780: IF P_PA_DEBUG_MODE = 'Y' THEN
2781: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');
2782: END IF;
2783:
2784: -- cancel open actions
2785: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') then

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 2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

2896: l_new_status := p_status;
2897:
2898: -- debug_msg_s1 ('6 ' || x_return_status);
2899: IF P_PA_DEBUG_MODE = 'Y' THEN
2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2901: END IF;
2902: -- We have verified all the validations while updation. This block is getting executed means
2903: -- some error have been occured, hence we will update the CI status to working.
2904: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

Line 2904: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2901: END IF;
2902: -- We have verified all the validations while updation. This block is getting executed means
2903: -- some error have been occured, hence we will update the CI status to working.
2904: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
2905: 1.0,
2906: p_init_msg_list,
2907: p_commit,
2908: p_validate_only,

Line 2918: pa_debug.write_file('ChangeCIStatusWorking: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

2914: x_msg_count,
2915: x_msg_data
2916: );
2917: IF P_PA_DEBUG_MODE = 'Y' THEN
2918: pa_debug.write_file('ChangeCIStatusWorking: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2919: END IF;
2920: -- Commit if the flag is set and there is no error
2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2922:

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;