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.17.12020000.2 2012/07/19 09:30:02 admarath ship $
3:
4:
5: procedure ADD_CONTROL_ITEM(

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

113:
114: BEGIN
115:
116: -- Initialize the Error Stack
117: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Add_Control_Item');
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: -- Issue API savepoint if the transaction is to be committed
121: IF p_commit = FND_API.G_TRUE THEN

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

370: ROLLBACK TO add_control_item;
371: END IF;
372:
373: -- Set the excetption Message and the stack
374: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.add_control_item'
375: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
376:
377:
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

497:
498: begin
499:
500: -- Initialize the Error Stack
501: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Update_Control_Item');
502:
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: -- Issue API savepoint if the transaction is to be committed

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

737: ROLLBACK TO update_control_item;
738: END IF;
739:
740: -- Set the excetption Message and the stack
741: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.update_control_item'
742: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
743:
744:
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

771: and ci.status_code = pps.project_status_code;
772: begin
773:
774: -- Initialize the Error Stack
775: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_Control_Item');
776:
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778: -- Issue API savepoint if the transaction is to be committed
779: IF p_commit = FND_API.G_TRUE THEN

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

873: ROLLBACK TO delete_control_item;
874: END IF;
875:
876: -- Set the excetption Message and the stack
877: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_control_item'
878: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
879:
880:
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

899:
900: BEGIN
901:
902: -- Initialize the Error Stack
903: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Delete_ALL_Control_Items');
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: -- Issue API savepoint if the transaction is to be committed
907: IF p_commit = FND_API.G_TRUE THEN

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

959: ROLLBACK TO delete_all_control_items;
960: END IF;
961:
962: -- Set the excetption Message and the stack
963: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.delete_all_control_items'
964: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
965:
966:
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1161: PA_CONTROL_ITEMS_PVT.ADD_CONTROL_ITEM(

1157: l_ci_system_status := 'CI_DRAFT';
1158: END IF;
1159:
1160: -- Bug#13475251 Changes end.
1161: PA_CONTROL_ITEMS_PVT.ADD_CONTROL_ITEM(
1162: p_api_version => p_api_version
1163: ,p_init_msg_list => p_init_msg_list
1164: ,p_commit => FND_API.g_false
1165: ,p_validate_only => p_validate_only

Line 1262: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(

1258: x_msg_data => x_msg_data);
1259: end if;
1260:
1261: if x_return_status = FND_API.g_ret_sts_success and p_include = 'Y' THEN
1262: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(
1263: p_api_version => p_api_version
1264: ,p_init_msg_list => p_init_msg_list
1265: ,p_commit => 'F'
1266: ,p_validate_only => p_validate_only

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

1369: cp check_params%rowtype;
1370: begin
1371:
1372: -- Initialize the Error Stack
1373: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Include_Control_Item');
1374:
1375: x_return_status := FND_API.G_RET_STS_SUCCESS;
1376: -- Issue API savepoint if the transaction is to be committed
1377: IF p_commit = FND_API.G_TRUE THEN

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

1518: ROLLBACK TO include_control_item;
1519: END IF;
1520:
1521: -- Set the excetption Message and the stack
1522: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.include_control_item'
1523: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1524:
1525:
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1557:
1558: BEGIN
1559:
1560: -- Initialize the Error Stack
1561: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS');
1562:
1563: x_return_status := FND_API.G_RET_STS_SUCCESS;
1564: -- Issue API savepoint if the transaction is to be committed
1565: IF p_commit = FND_API.G_TRUE THEN

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

1683: ROLLBACK TO UPDATE_NUMBER_OF_ACTIONS;
1684: END IF;
1685:
1686: -- Set the excetption Message and the stack
1687: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_NUMBER_OF_ACTIONS'
1688: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1689:
1690:
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1740:
1741: BEGIN
1742:
1743: -- Initialize the Error Stack
1744: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS');
1745:
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747: -- Issue API savepoint if the transaction is to be committed
1748: IF p_commit = FND_API.G_TRUE THEN

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

1957: ROLLBACK TO UPDATE_CONTROL_ITEM_STATUS;
1958: END IF;
1959:
1960: -- Set the excetption Message and the stack
1961: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM_STATUS'
1962: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1963:
1964:
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2031:
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034: -- Set the exception Message and the stack
2035: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.has_null_data'
2036: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2037:
2038: RAISE;
2039:

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

2095: WHEN NO_DATA_FOUND THEN
2096: return FALSE;
2097: WHEN OTHERS THEN
2098: -- Set the exception Message and the stack
2099: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.is_lookup_valid'
2100: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2101:
2102: RAISE;
2103:

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

2159: )
2160: IS
2161: l_object_relationship_id NUMBER;
2162: BEGIN
2163: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.ADD_RELATED_ITEM');
2164:
2165: IF p_commit = FND_API.G_TRUE THEN
2166: SAVEPOINT add_related_item;
2167: END IF;

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

2220: ROLLBACK TO add_related_item;
2221: END IF;
2222:
2223: x_return_status := 'U';
2224: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2225: p_procedure_name => 'ADD_RELATED_ITEM',
2226: p_error_text => SUBSTRB(SQLERRM,1,240));
2227:
2228: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2245: IS
2246: l_object_relationship_id NUMBER;
2247: l_record_version_number NUMBER;
2248: BEGIN
2249: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_RELATED_ITEM');
2250:
2251: IF p_commit = FND_API.G_TRUE THEN
2252: SAVEPOINT delete_related_item;
2253: END IF;

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

2312: ROLLBACK TO delete_related_item;
2313: END IF;
2314:
2315: x_return_status := 'U';
2316: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2317: p_procedure_name => 'DELETE_RELATED_ITEM',
2318: p_error_text => SUBSTRB(SQLERRM,1,240));
2319:
2320: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2350:
2351:
2352:
2353: BEGIN
2354: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_RELATED_ITEMS');
2355:
2356: IF p_commit = FND_API.G_TRUE THEN
2357: SAVEPOINT delete_all_related_items;
2358: END IF;

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

2401: ROLLBACK TO delete_all_related_items;
2402: END IF;
2403:
2404: x_return_status := 'U';
2405: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2406: p_procedure_name => 'DELETE_ALL_RELATED_ITEMS',
2407: p_error_text => SUBSTRB(SQLERRM,1,240));
2408:
2409: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2431: AND relationship_type = 'CI_INCLUDED_ITEM'
2432: AND object_id_from1 = p_ci_id;
2433:
2434: BEGIN
2435: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.DELETE_ALL_INCLUDED_CRS');
2436:
2437: IF p_commit = FND_API.G_TRUE THEN
2438: SAVEPOINT delete_all_included_crs;
2439: END IF;

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

2491: ROLLBACK TO delete_all_included_crs;
2492: END IF;
2493:
2494: x_return_status := 'U';
2495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2496: p_procedure_name => 'DELETE_ALL_INCLUDED_CRS',
2497: p_error_text => SUBSTRB(SQLERRM,1,240));
2498:
2499: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

2529: AND object_id_to1 = p_from_ci_id;
2530:
2531:
2532: BEGIN
2533: pa_debug.set_err_stack ('PA_CONTROL_ITEMS_PVT.COPY_RELATED_ITEMS');
2534:
2535: IF p_commit = FND_API.G_TRUE THEN
2536: SAVEPOINT copy_related_items;
2537: END IF;

Line 2552: pa_control_items_pvt.add_related_item(

2548: RETURN;
2549: END IF;
2550:
2551: FOR cur in items_c LOOP
2552: pa_control_items_pvt.add_related_item(
2553: p_init_msg_list => FND_API.G_FALSE,
2554: p_commit => FND_API.G_FALSE,
2555: p_validate_only => FND_API.G_FALSE,
2556: p_max_msg_count => p_max_msg_count,

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

2580: ROLLBACK TO copy_related_items;
2581: END IF;
2582:
2583: x_return_status := 'U';
2584: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_PVT',
2585: p_procedure_name => 'COPY_RELATED_ITEMS',
2586: p_error_text => SUBSTRB(SQLERRM,1,240));
2587:
2588: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2693: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Lock_Control_Item');

2689:
2690: begin
2691:
2692: -- Initialize the Error Stack
2693: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PVT.Lock_Control_Item');
2694:
2695: x_return_status := FND_API.G_RET_STS_SUCCESS;
2696: -- Issue API savepoint if the transaction is to be committed
2697: IF p_commit = FND_API.G_TRUE THEN

Line 2816: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.lock_control_item'

2812: ROLLBACK TO locked_control_item;
2813: END IF;
2814:
2815: -- Set the excetption Message and the stack
2816: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PVT.lock_control_item'
2817: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2818:
2819:
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2826: END PA_CONTROL_ITEMS_PVT;

2822: end LOCK_CONTROL_ITEM;
2823: -- end 26-Jun-2009 cklee Modified for the Bug# 8633676
2824:
2825:
2826: END PA_CONTROL_ITEMS_PVT;