42: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
43: l_location VARCHAR2(32767);
44: --
45: --
46: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
47: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
48: --}
49: BEGIN
50: --{
43: l_location VARCHAR2(32767);
44: --
45: --
46: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
47: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
48: --}
49: BEGIN
50: --{
51: l_location := '0010';
77: --{
78: WHEN OTHERS
79: THEN
80: --{
81: vea_tpa_util_pvt.add_exc_message_and_raise
82: (
83: p_package_name => G_PACKAGE_NAME,
84: p_api_name => l_api_name,
85: p_location => l_location
114: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
115: l_location VARCHAR2(32767);
116: --
117: --
118: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
119: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
120: --}
121: BEGIN
122: --{
115: l_location VARCHAR2(32767);
116: --
117: --
118: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
119: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
120: --}
121: BEGIN
122: --{
123: l_location := '0010';
140: --{
141: WHEN OTHERS
142: THEN
143: --{
144: vea_tpa_util_pvt.add_exc_message_and_raise
145: (
146: p_package_name => G_PACKAGE_NAME,
147: p_api_name => l_api_name,
148: p_location => l_location
184: --{
185: WHEN OTHERS
186: THEN
187: --{
188: vea_tpa_util_pvt.add_exc_message_and_raise
189: (
190: p_package_name => G_PACKAGE_NAME,
191: p_api_name => l_api_name,
192: p_location => l_location
297: IS
298: --{
299: l_api_name CONSTANT VARCHAR2(30) := 'process';
300: l_api_version CONSTANT NUMBER := 1.0;
301: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
302: --
303: --
304: l_location VARCHAR2(32767);
305: l_savepoint_name VARCHAR2(30);
345: BEGIN
346: --{
347: l_location := '0010';
348: --
349: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
350: THEN
351: RETURN;
352: END IF;
353: --
355: -- Standard API Header
356: --
357: l_location := '0020';
358: --
359: vea_tpa_util_pvt.api_header
360: (
361: p_package_name => G_PACKAGE_NAME,
362: p_api_name => l_api_name,
363: p_api_type => l_api_type,
373: --
374: --
375: l_location := '0030';
376: --
377: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
378: --{
379: l_program_unit_id := VEA_PROGRAM_UNITS_SV.g_program_unit_id;
380: l_tp_layer_id := nvl(vea_packages_sv.g_tp_layer_id,p_tp_layer_id);
381: --}
427: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_name is ' || p_name);
428: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_datatype is ' || p_datatype);
429: --
430: --
431: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
432: THEN
433: SELECT NVL( p_id, vea_parameters_s.NEXTVAL )
434: INTO l_parameter_id
435: FROM DUAL;
498: -- Standard API Footer
499: --
500: l_location := '0110';
501: --
502: vea_tpa_util_pvt.api_footer
503: (
504: p_commit => p_commit,
505: x_msg_count => x_msg_count,
506: x_msg_data => x_msg_data
511: WHEN FND_API.G_EXC_ERROR
512: THEN
513: --{
514: --RAISE;
515: vea_tpa_util_pvt.handle_error
516: (
517: p_error_type => vea_tpa_util_pvt.G_ERROR,
518: p_savepoint_name => l_savepoint_name,
519: p_package_name => G_PACKAGE_NAME,
513: --{
514: --RAISE;
515: vea_tpa_util_pvt.handle_error
516: (
517: p_error_type => vea_tpa_util_pvt.G_ERROR,
518: p_savepoint_name => l_savepoint_name,
519: p_package_name => G_PACKAGE_NAME,
520: p_api_name => l_api_name,
521: p_location => l_location,
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
528: THEN
529: --{
530: --RAISE;
531: vea_tpa_util_pvt.handle_error
532: (
533: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
534: p_savepoint_name => l_savepoint_name,
535: p_package_name => G_PACKAGE_NAME,
529: --{
530: --RAISE;
531: vea_tpa_util_pvt.handle_error
532: (
533: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
534: p_savepoint_name => l_savepoint_name,
535: p_package_name => G_PACKAGE_NAME,
536: p_api_name => l_api_name,
537: p_location => l_location,
543: WHEN OTHERS
544: THEN
545: --{
546: --RAISE;
547: vea_tpa_util_pvt.handle_error
548: (
549: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
550: p_savepoint_name => l_savepoint_name,
551: p_package_name => G_PACKAGE_NAME,
545: --{
546: --RAISE;
547: vea_tpa_util_pvt.handle_error
548: (
549: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
550: p_savepoint_name => l_savepoint_name,
551: p_package_name => G_PACKAGE_NAME,
552: p_api_name => l_api_name,
553: p_location => l_location,