DBA Data[Home] [Help]

APPS.VEA_PARAMETER_MAPPINGS_SV dependencies on VEA_TPA_UTIL_PVT

Line 45: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

41: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
42: l_location VARCHAR2(32767);
43: --
44: --
45: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
46: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
47: --}
48: BEGIN
49: --{

Line 46: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

42: l_location VARCHAR2(32767);
43: --
44: --
45: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
46: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
47: --}
48: BEGIN
49: --{
50: l_location := '0010';

Line 80: vea_tpa_util_pvt.add_exc_message_and_raise

76: --{
77: WHEN OTHERS
78: THEN
79: --{
80: vea_tpa_util_pvt.add_exc_message_and_raise
81: (
82: p_package_name => G_PACKAGE_NAME,
83: p_api_name => l_api_name,
84: p_location => l_location

Line 116: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

112: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
113: l_location VARCHAR2(32767);
114: --
115: --
116: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
117: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
118: --}
119: BEGIN
120: --{

Line 117: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

113: l_location VARCHAR2(32767);
114: --
115: --
116: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
117: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
118: --}
119: BEGIN
120: --{
121: 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 235: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;

231: IS
232: --{
233: l_api_name CONSTANT VARCHAR2(30) := 'process';
234: l_api_version CONSTANT NUMBER := 1.0;
235: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
236: --
237: --
238: l_location VARCHAR2(32767);
239: l_savepoint_name VARCHAR2(30);

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

266: BEGIN
267: --{
268: l_location := '0010';
269: --
270: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
271: THEN
272: RETURN;
273: END IF;
274: --

Line 280: vea_tpa_util_pvt.api_header

276: -- Standard API Header
277: --
278: l_location := '0020';
279: --
280: vea_tpa_util_pvt.api_header
281: (
282: p_package_name => G_PACKAGE_NAME,
283: p_api_name => l_api_name,
284: p_api_type => l_api_type,

Line 300: vea_tpa_util_pvt.add_message_and_raise

296: --
297: IF p_program_unit_parameter_name IS NULL
298: OR p_tps_parameter_name IS NULL
299: THEN
300: vea_tpa_util_pvt.add_message_and_raise
301: (
302: p_error_name => 'VEA_INCOMPATIBLE_LAYER_FILE'
303: );
304: END IF;

Line 367: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

363: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' vea_layer_headers_sv.g_program_unit_id is ' || vea_layer_headers_sv.g_program_unit_id);
364: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_program_unit_parameter_name is ' || p_program_unit_parameter_name);
365: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' l_tps_parameter_id is ' || l_tps_parameter_id);
366: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_layer_provider_code is ' || p_layer_provider_code);
367: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
368: THEN
369: SELECT NVL( p_id, vea_parameter_mappings_s.NEXTVAL )
370: INTO l_parameter_mapping_id
371: FROM DUAL;

Line 425: vea_tpa_util_pvt.api_footer

421: -- Standard API Footer
422: --
423: l_location := '0130';
424: --
425: vea_tpa_util_pvt.api_footer
426: (
427: p_commit => p_commit,
428: x_msg_count => x_msg_count,
429: x_msg_data => x_msg_data

Line 438: vea_tpa_util_pvt.handle_error

434: WHEN FND_API.G_EXC_ERROR
435: THEN
436: --{
437: --RAISE;
438: vea_tpa_util_pvt.handle_error
439: (
440: p_error_type => vea_tpa_util_pvt.G_ERROR,
441: p_savepoint_name => l_savepoint_name,
442: p_package_name => G_PACKAGE_NAME,

Line 440: p_error_type => vea_tpa_util_pvt.G_ERROR,

436: --{
437: --RAISE;
438: vea_tpa_util_pvt.handle_error
439: (
440: p_error_type => vea_tpa_util_pvt.G_ERROR,
441: p_savepoint_name => l_savepoint_name,
442: p_package_name => G_PACKAGE_NAME,
443: p_api_name => l_api_name,
444: p_location => l_location,

Line 454: vea_tpa_util_pvt.handle_error

450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
451: THEN
452: --{
453: --RAISE;
454: vea_tpa_util_pvt.handle_error
455: (
456: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
457: p_savepoint_name => l_savepoint_name,
458: p_package_name => G_PACKAGE_NAME,

Line 456: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

452: --{
453: --RAISE;
454: vea_tpa_util_pvt.handle_error
455: (
456: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
457: p_savepoint_name => l_savepoint_name,
458: p_package_name => G_PACKAGE_NAME,
459: p_api_name => l_api_name,
460: p_location => l_location,

Line 470: vea_tpa_util_pvt.handle_error

466: WHEN OTHERS
467: THEN
468: --{
469: --RAISE;
470: vea_tpa_util_pvt.handle_error
471: (
472: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
473: p_savepoint_name => l_savepoint_name,
474: p_package_name => G_PACKAGE_NAME,

Line 472: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

468: --{
469: --RAISE;
470: vea_tpa_util_pvt.handle_error
471: (
472: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
473: p_savepoint_name => l_savepoint_name,
474: p_package_name => G_PACKAGE_NAME,
475: p_api_name => l_api_name,
476: p_location => l_location,