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 FND_MSG_PUB

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 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 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 913: FND_MSG_PUB.initialize;

909: END IF;
910:
911: --Clear the global PL/SQL message table
912: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
913: FND_MSG_PUB.initialize;
914: END IF;
915:
916: FOR ci_rec IN( SELECT ci_id, record_version_number
917: FROM pa_control_items

Line 937: x_msg_count := FND_MSG_PUB.Count_Msg;

933: END LOOP;
934:
935: -- IF the number of messaages is 1 then fetch the message code from the stack
936: -- and return its text
937: x_msg_count := FND_MSG_PUB.Count_Msg;
938: IF x_msg_count = 1 THEN
939: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
940: ,p_msg_index => 1
941: ,p_data => x_msg_data

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 1075: FND_MSG_PUB.initialize;

1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: --Clear the global PL/SQL message table
1074: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1075: FND_MSG_PUB.initialize;
1076: END IF;
1077:
1078: OPEN c_from_item;
1079: FETCH c_from_item INTO copy_from_row;

Line 1306: x_msg_count := FND_MSG_PUB.Count_Msg;

1302: end if;
1303:
1304: -- IF the number of messages is 1 then fetch the message code from the stack
1305: -- and return its text
1306: x_msg_count := FND_MSG_PUB.Count_Msg;
1307: IF x_msg_count = 1 THEN
1308: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1309: ,p_msg_index => 1
1310: ,p_data => x_msg_data

Line 1326: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM'

1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: rollback;
1325: -- Set the excetption Message and the stack
1326: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM'
1327: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1328:
1329:
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 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 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 2170: fnd_msg_pub.initialize;

2166: SAVEPOINT add_related_item;
2167: END IF;
2168:
2169: IF p_init_msg_list = FND_API.G_TRUE THEN
2170: fnd_msg_pub.initialize;
2171: END IF;
2172:
2173: x_return_status := 'S';
2174: x_msg_count := 0;

Line 2212: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2208: ROLLBACK TO add_related_item;
2209: END IF;
2210: END IF;
2211:
2212: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2213: p_data => x_msg_data);
2214:
2215: pa_debug.reset_err_stack;
2216:

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 2228: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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,
2229: p_data => x_msg_data);
2230: END add_related_item;
2231:
2232:

Line 2256: fnd_msg_pub.initialize;

2252: SAVEPOINT delete_related_item;
2253: END IF;
2254:
2255: IF p_init_msg_list = FND_API.G_TRUE THEN
2256: fnd_msg_pub.initialize;
2257: END IF;
2258:
2259: x_return_status := 'S';
2260: x_msg_count := 0;

Line 2304: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2300: ROLLBACK TO delete_related_item;
2301: END IF;
2302: END IF;
2303:
2304: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2305: p_data => x_msg_data);
2306:
2307: pa_debug.reset_err_stack;
2308:

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 2320: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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,
2321: p_data => x_msg_data);
2322: END delete_related_item;
2323:
2324: PROCEDURE delete_all_related_items (

Line 2361: fnd_msg_pub.initialize;

2357: SAVEPOINT delete_all_related_items;
2358: END IF;
2359:
2360: IF p_init_msg_list = FND_API.G_TRUE THEN
2361: fnd_msg_pub.initialize;
2362: END IF;
2363:
2364: x_return_status := 'S';
2365: x_msg_count := 0;

Line 2393: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2389: ROLLBACK TO delete_all_related_items;
2390: END IF;
2391: END IF;
2392:
2393: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:
2396: pa_debug.reset_err_stack;
2397:

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 2409: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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,
2410: p_data => x_msg_data);
2411: END delete_all_related_items;
2412:
2413:

Line 2442: fnd_msg_pub.initialize;

2438: SAVEPOINT delete_all_included_crs;
2439: END IF;
2440:
2441: IF p_init_msg_list = FND_API.G_TRUE THEN
2442: fnd_msg_pub.initialize;
2443: END IF;
2444:
2445: x_return_status := 'S';
2446: x_msg_count := 0;

Line 2483: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2479: ROLLBACK TO delete_all_included_crs;
2480: END IF;
2481: END IF;
2482:
2483: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2484: p_data => x_msg_data);
2485:
2486: pa_debug.reset_err_stack;
2487:

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 2499: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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,
2500: p_data => x_msg_data);
2501: END delete_all_included_crs;
2502:
2503: PROCEDURE copy_related_items (

Line 2540: fnd_msg_pub.initialize;

2536: SAVEPOINT copy_related_items;
2537: END IF;
2538:
2539: IF p_init_msg_list = FND_API.G_TRUE THEN
2540: fnd_msg_pub.initialize;
2541: END IF;
2542:
2543: x_return_status := 'S';
2544: x_msg_count := 0;

Line 2572: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2568: ROLLBACK TO copy_related_items;
2569: END IF;
2570: END IF;
2571:
2572: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2573: p_data => x_msg_data);
2574:
2575: pa_debug.reset_err_stack;
2576:

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 2588: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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,
2589: p_data => x_msg_data);
2590: END copy_related_items;
2591:
2592: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676

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 ;