DBA Data[Home] [Help]

APPS.VEA_PARAMETERS_SV dependencies on VEA_TPA_UTIL_PVT

Line 46: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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: --{

Line 47: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

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';

Line 81: vea_tpa_util_pvt.add_exc_message_and_raise

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

Line 118: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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: --{

Line 119: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

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';

Line 144: vea_tpa_util_pvt.add_exc_message_and_raise

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

Line 188: vea_tpa_util_pvt.add_exc_message_and_raise

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

Line 301: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

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);

Line 349: IF NOT( vea_tpa_util_pvt.is_vea_installed() )

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: --

Line 359: vea_tpa_util_pvt.api_header

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,

Line 377: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN

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: --}

Line 431: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

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;

Line 502: vea_tpa_util_pvt.api_footer

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

Line 515: vea_tpa_util_pvt.handle_error

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,

Line 517: p_error_type => vea_tpa_util_pvt.G_ERROR,

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,

Line 531: vea_tpa_util_pvt.handle_error

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,

Line 533: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

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,

Line 547: vea_tpa_util_pvt.handle_error

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,

Line 549: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

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,