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

833: END IF;
834:
835: --Clear the global PL/SQL message table
836: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
837: FND_MSG_PUB.initialize;
838: END IF;
839:
840: FOR ci_rec IN( SELECT ci_id, record_version_number
841: FROM pa_control_items

Line 861: x_msg_count := FND_MSG_PUB.Count_Msg;

857: END LOOP;
858:
859: -- IF the number of messaages is 1 then fetch the message code from the stack
860: -- and return its text
861: x_msg_count := FND_MSG_PUB.Count_Msg;
862: IF x_msg_count = 1 THEN
863: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
864: ,p_msg_index => 1
865: ,p_data => x_msg_data

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

983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: --Clear the global PL/SQL message table
986: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: OPEN c_from_item;
991: FETCH c_from_item INTO copy_from_row;

Line 1172: x_msg_count := FND_MSG_PUB.Count_Msg;

1168: end if;
1169:
1170: -- IF the number of messages is 1 then fetch the message code from the stack
1171: -- and return its text
1172: x_msg_count := FND_MSG_PUB.Count_Msg;
1173: IF x_msg_count = 1 THEN
1174: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1175: ,p_msg_index => 1
1176: ,p_data => x_msg_data

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

1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: rollback;
1192: -- Set the excetption Message and the stack
1193: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM'
1194: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1195:
1196:
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2001: SAVEPOINT add_related_item;
2002: END IF;
2003:
2004: IF p_init_msg_list = FND_API.G_TRUE THEN
2005: fnd_msg_pub.initialize;
2006: END IF;
2007:
2008: x_return_status := 'S';
2009: x_msg_count := 0;

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

2043: ROLLBACK TO add_related_item;
2044: END IF;
2045: END IF;
2046:
2047: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2048: p_data => x_msg_data);
2049:
2050: pa_debug.reset_err_stack;
2051:

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

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,
2064: p_data => x_msg_data);
2065: END add_related_item;
2066:
2067:

Line 2091: fnd_msg_pub.initialize;

2087: SAVEPOINT delete_related_item;
2088: END IF;
2089:
2090: IF p_init_msg_list = FND_API.G_TRUE THEN
2091: fnd_msg_pub.initialize;
2092: END IF;
2093:
2094: x_return_status := 'S';
2095: x_msg_count := 0;

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

2135: ROLLBACK TO delete_related_item;
2136: END IF;
2137: END IF;
2138:
2139: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2140: p_data => x_msg_data);
2141:
2142: pa_debug.reset_err_stack;
2143:

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

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,
2156: p_data => x_msg_data);
2157: END delete_related_item;
2158:
2159: PROCEDURE delete_all_related_items (

Line 2196: fnd_msg_pub.initialize;

2192: SAVEPOINT delete_all_related_items;
2193: END IF;
2194:
2195: IF p_init_msg_list = FND_API.G_TRUE THEN
2196: fnd_msg_pub.initialize;
2197: END IF;
2198:
2199: x_return_status := 'S';
2200: x_msg_count := 0;

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

2224: ROLLBACK TO delete_all_related_items;
2225: END IF;
2226: END IF;
2227:
2228: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2229: p_data => x_msg_data);
2230:
2231: pa_debug.reset_err_stack;
2232:

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

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,
2245: p_data => x_msg_data);
2246: END delete_all_related_items;
2247:
2248:

Line 2277: fnd_msg_pub.initialize;

2273: SAVEPOINT delete_all_included_crs;
2274: END IF;
2275:
2276: IF p_init_msg_list = FND_API.G_TRUE THEN
2277: fnd_msg_pub.initialize;
2278: END IF;
2279:
2280: x_return_status := 'S';
2281: x_msg_count := 0;

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

2314: ROLLBACK TO delete_all_included_crs;
2315: END IF;
2316: END IF;
2317:
2318: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2319: p_data => x_msg_data);
2320:
2321: pa_debug.reset_err_stack;
2322:

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

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,
2335: p_data => x_msg_data);
2336: END delete_all_included_crs;
2337:
2338: PROCEDURE copy_related_items (

Line 2375: fnd_msg_pub.initialize;

2371: SAVEPOINT copy_related_items;
2372: END IF;
2373:
2374: IF p_init_msg_list = FND_API.G_TRUE THEN
2375: fnd_msg_pub.initialize;
2376: END IF;
2377:
2378: x_return_status := 'S';
2379: x_msg_count := 0;

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

2403: ROLLBACK TO copy_related_items;
2404: END IF;
2405: END IF;
2406:
2407: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2408: p_data => x_msg_data);
2409:
2410: pa_debug.reset_err_stack;
2411:

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

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,
2424: p_data => x_msg_data);
2425: END copy_related_items;
2426:
2427: