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_PVT dependencies on PA_CONTROL_ITEMS_PVT

Line 1: PACKAGE BODY PA_CONTROL_ITEMS_PVT AS

1: PACKAGE BODY PA_CONTROL_ITEMS_PVT AS
2: --$Header: PACICIVB.pls 120.4 2007/02/08 11:46:15 sukhanna ship $
3:
4:
5: procedure ADD_CONTROL_ITEM(

Line 104: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Add_Control_Item');

100:
101: BEGIN
102:
103: -- Initialize the Error Stack
104: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Add_Control_Item');
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Issue API savepoint if the transaction is to be committed
108: IF p_commit = FND_API.G_TRUE THEN

Line 349: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.add_control_item'

345: ROLLBACK TO add_control_item;
346: END IF;
347:
348: -- Set the excetption Message and the stack
349: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.add_control_item'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
351:
352:
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 457: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Update_Control_Item');

453:
454: begin
455:
456: -- Initialize the Error Stack
457: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Update_Control_Item');
458:
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: -- Issue API savepoint if the transaction is to be committed

Line 665: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.update_control_item'

661: ROLLBACK TO update_control_item;
662: END IF;
663:
664: -- Set the excetption Message and the stack
665: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.update_control_item'
666: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
667:
668:
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 699: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_Control_Item');

695: and ci.status_code = pps.project_status_code;
696: begin
697:
698: -- Initialize the Error Stack
699: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_Control_Item');
700:
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702: -- Issue API savepoint if the transaction is to be committed
703: IF p_commit = FND_API.G_TRUE THEN

Line 801: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_control_item'

797: ROLLBACK TO delete_control_item;
798: END IF;
799:
800: -- Set the excetption Message and the stack
801: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_control_item'
802: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
803:
804:
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 827: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_ALL_Control_Items');

823:
824: BEGIN
825:
826: -- Initialize the Error Stack
827: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_ALL_Control_Items');
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: -- Issue API savepoint if the transaction is to be committed
831: IF p_commit = FND_API.G_TRUE THEN

Line 887: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_all_control_items'

883: ROLLBACK TO delete_all_control_items;
884: END IF;
885:
886: -- Set the excetption Message and the stack
887: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_all_control_items'
888: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
889:
890:
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1042: PA_CONTROL_ITEMS_PVT.ADD_CONTROL_ITEM(

1038: close c_from_reason;
1039:
1040: end if;
1041:
1042: PA_CONTROL_ITEMS_PVT.ADD_CONTROL_ITEM(
1043: p_api_version => p_api_version
1044: ,p_init_msg_list => p_init_msg_list
1045: ,p_commit => FND_API.g_false
1046: ,p_validate_only => p_validate_only

Line 1128: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(

1124: x_msg_data => x_msg_data);
1125: end if;
1126:
1127: if x_return_status = FND_API.g_ret_sts_success and p_include = 'Y' THEN
1128: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(
1129: p_api_version => p_api_version
1130: ,p_init_msg_list => p_init_msg_list
1131: ,p_commit => 'F'
1132: ,p_validate_only => p_validate_only

Line 1240: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Include_Control_Item');

1236: cp check_params%rowtype;
1237: begin
1238:
1239: -- Initialize the Error Stack
1240: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Include_Control_Item');
1241:
1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243: -- Issue API savepoint if the transaction is to be committed
1244: IF p_commit = FND_API.G_TRUE THEN

Line 1389: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.include_control_item'

1385: ROLLBACK TO include_control_item;
1386: END IF;
1387:
1388: -- Set the excetption Message and the stack
1389: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.include_control_item'
1390: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1391:
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1428: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS');

1424:
1425: BEGIN
1426:
1427: -- Initialize the Error Stack
1428: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS');
1429:
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431: -- Issue API savepoint if the transaction is to be committed
1432: IF p_commit = FND_API.G_TRUE THEN

Line 1538: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS'

1534: ROLLBACK TO UPDATE_NUMBER_OF_ACTIONS;
1535: END IF;
1536:
1537: -- Set the excetption Message and the stack
1538: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS'
1539: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1540:
1541:
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1595: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS');

1591:
1592: BEGIN
1593:
1594: -- Initialize the Error Stack
1595: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS');
1596:
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598: -- Issue API savepoint if the transaction is to be committed
1599: IF p_commit = FND_API.G_TRUE THEN

Line 1796: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS'

1792: ROLLBACK TO UPDATE_CONTROL_ITEM_STATUS;
1793: END IF;
1794:
1795: -- Set the excetption Message and the stack
1796: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS'
1797: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1798:
1799:
1800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.has_null_data'

1866:
1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: -- Set the exception Message and the stack
1870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.has_null_data'
1871: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1872:
1873: RAISE;
1874:

Line 1934: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.is_lookup_valid'

1930: WHEN NO_DATA_FOUND THEN
1931: return FALSE;
1932: WHEN OTHERS THEN
1933: -- Set the exception Message and the stack
1934: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.is_lookup_valid'
1935: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1936:
1937: RAISE;
1938:

Line 1998: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.ADD_RELATED_ITEM');

1994: )
1995: IS
1996: l_object_relationship_id NUMBER;
1997: BEGIN
1998: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.ADD_RELATED_ITEM');
1999:
2000: IF p_commit = FND_API.G_TRUE THEN
2001: SAVEPOINT add_related_item;
2002: END IF;

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

2055: ROLLBACK TO add_related_item;
2056: END IF;
2057:
2058: x_return_status := 'U';
2059: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2060: p_procedure_name => 'ADD_RELATED_ITEM',
2061: p_error_text => SUBSTRB(SQLERRM,1,240));
2062:
2063: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2084: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_RELATED_ITEM');

2080: IS
2081: l_object_relationship_id NUMBER;
2082: l_record_version_number NUMBER;
2083: BEGIN
2084: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_RELATED_ITEM');
2085:
2086: IF p_commit = FND_API.G_TRUE THEN
2087: SAVEPOINT delete_related_item;
2088: END IF;

Line 2151: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',

2147: ROLLBACK TO delete_related_item;
2148: END IF;
2149:
2150: x_return_status := 'U';
2151: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2152: p_procedure_name => 'DELETE_RELATED_ITEM',
2153: p_error_text => SUBSTRB(SQLERRM,1,240));
2154:
2155: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2189: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_RELATED_ITEMS');

2185:
2186:
2187:
2188: BEGIN
2189: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_RELATED_ITEMS');
2190:
2191: IF p_commit = FND_API.G_TRUE THEN
2192: SAVEPOINT delete_all_related_items;
2193: END IF;

Line 2240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',

2236: ROLLBACK TO delete_all_related_items;
2237: END IF;
2238:
2239: x_return_status := 'U';
2240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2241: p_procedure_name => 'DELETE_ALL_RELATED_ITEMS',
2242: p_error_text => SUBSTRB(SQLERRM,1,240));
2243:
2244: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2270: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_INCLUDED_CRS');

2266: AND relationship_type = 'CI_INCLUDED_ITEM'
2267: AND object_id_from1 = p_ci_id;
2268:
2269: BEGIN
2270: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_INCLUDED_CRS');
2271:
2272: IF p_commit = FND_API.G_TRUE THEN
2273: SAVEPOINT delete_all_included_crs;
2274: END IF;

Line 2330: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',

2326: ROLLBACK TO delete_all_included_crs;
2327: END IF;
2328:
2329: x_return_status := 'U';
2330: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2331: p_procedure_name => 'DELETE_ALL_INCLUDED_CRS',
2332: p_error_text => SUBSTRB(SQLERRM,1,240));
2333:
2334: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2368: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.COPY_RELATED_ITEMS');

2364: AND object_id_to1 = p_from_ci_id;
2365:
2366:
2367: BEGIN
2368: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.COPY_RELATED_ITEMS');
2369:
2370: IF p_commit = FND_API.G_TRUE THEN
2371: SAVEPOINT copy_related_items;
2372: END IF;

Line 2419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',

2415: ROLLBACK TO copy_related_items;
2416: END IF;
2417:
2418: x_return_status := 'U';
2419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2420: p_procedure_name => 'COPY_RELATED_ITEMS',
2421: p_error_text => SUBSTRB(SQLERRM,1,240));
2422:
2423: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2428: END PA_CONTROL_ITEMS_PVT;

2424: p_data => x_msg_data);
2425: END copy_related_items;
2426:
2427:
2428: END PA_CONTROL_ITEMS_PVT;