38: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --}
45: BEGIN
46: --{
39: l_location VARCHAR2(32767);
40: --
41: --
42: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
43: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
44: --}
45: BEGIN
46: --{
47: l_location := '0010';
69: --{
70: WHEN OTHERS
71: THEN
72: --{
73: vea_tpa_util_pvt.add_exc_message_and_raise
74: (
75: p_package_name => G_PACKAGE_NAME,
76: p_api_name => l_api_name,
77: p_location => l_location
102: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
103: l_location VARCHAR2(32767);
104: --
105: --
106: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
107: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
108: --}
109: BEGIN
110: --{
103: l_location VARCHAR2(32767);
104: --
105: --
106: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
107: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
108: --}
109: BEGIN
110: --{
111: l_location := '0010';
124: --{
125: WHEN OTHERS
126: THEN
127: --{
128: vea_tpa_util_pvt.add_exc_message_and_raise
129: (
130: p_package_name => G_PACKAGE_NAME,
131: p_api_name => l_api_name,
132: p_location => l_location
162: IS
163: --{
164: l_api_name CONSTANT VARCHAR2(30) := 'process';
165: l_api_version CONSTANT NUMBER := 1.0;
166: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
167: --
168: --
169: l_location VARCHAR2(32767);
170: l_savepoint_name VARCHAR2(30);
194: BEGIN
195: --{
196: l_location := '0010';
197: --
198: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
199: THEN
200: RETURN;
201: END IF;
202: --
204: -- Standard API Header
205: --
206: l_location := '0020';
207: --
208: vea_tpa_util_pvt.api_header
209: (
210: p_package_name => G_PACKAGE_NAME,
211: p_api_name => l_api_name,
212: p_api_type => l_api_type,
226: l_layer_id := NULL;
227: l_version_id := p_version_id;
228: --
229: --
230: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
231: --{
232: l_release_id := nvl(vea_release_details_sv.g_release_id,p_release_id);
233: --}
234: ELSE
295: -- Standard API Footer
296: --
297: l_location := '0090';
298: --
299: vea_tpa_util_pvt.api_footer
300: (
301: p_commit => p_commit,
302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data
308: WHEN FND_API.G_EXC_ERROR
309: THEN
310: --{
311: --RAISE;
312: vea_tpa_util_pvt.handle_error
313: (
314: p_error_type => vea_tpa_util_pvt.G_ERROR,
315: p_savepoint_name => l_savepoint_name,
316: p_package_name => G_PACKAGE_NAME,
310: --{
311: --RAISE;
312: vea_tpa_util_pvt.handle_error
313: (
314: p_error_type => vea_tpa_util_pvt.G_ERROR,
315: p_savepoint_name => l_savepoint_name,
316: p_package_name => G_PACKAGE_NAME,
317: p_api_name => l_api_name,
318: p_location => l_location,
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
325: THEN
326: --{
327: --RAISE;
328: vea_tpa_util_pvt.handle_error
329: (
330: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
331: p_savepoint_name => l_savepoint_name,
332: p_package_name => G_PACKAGE_NAME,
326: --{
327: --RAISE;
328: vea_tpa_util_pvt.handle_error
329: (
330: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
331: p_savepoint_name => l_savepoint_name,
332: p_package_name => G_PACKAGE_NAME,
333: p_api_name => l_api_name,
334: p_location => l_location,
340: WHEN OTHERS
341: THEN
342: --{
343: --RAISE;
344: vea_tpa_util_pvt.handle_error
345: (
346: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
347: p_savepoint_name => l_savepoint_name,
348: p_package_name => G_PACKAGE_NAME,
342: --{
343: --RAISE;
344: vea_tpa_util_pvt.handle_error
345: (
346: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
347: p_savepoint_name => l_savepoint_name,
348: p_package_name => G_PACKAGE_NAME,
349: p_api_name => l_api_name,
350: p_location => l_location,