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.VEA_LAYER_HEADERS_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 117: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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

Line 118: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

114: l_location VARCHAR2(32767);
115: --
116: --
117: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
118: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
119: --}
120: BEGIN
121: --{
122: l_location := '0010';

Line 198: vea_tpa_util_pvt.add_exc_message_and_raise

194: --{
195: WHEN OTHERS
196: THEN
197: --{
198: vea_tpa_util_pvt.add_exc_message_and_raise
199: (
200: p_package_name => G_PACKAGE_NAME,
201: p_api_name => l_api_name,
202: p_location => l_location

Line 238: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

234: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
235: l_location VARCHAR2(32767);
236: --
237: --
238: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
239: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
240: --
241: --
242: CURSOR layer_header_cur

Line 239: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

235: l_location VARCHAR2(32767);
236: --
237: --
238: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
239: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
240: --
241: --
242: CURSOR layer_header_cur
243: (

Line 378: vea_tpa_util_pvt.add_exc_message_and_raise

374: --{
375: WHEN OTHERS
376: THEN
377: --{
378: vea_tpa_util_pvt.add_exc_message_and_raise
379: (
380: p_package_name => G_PACKAGE_NAME,
381: p_api_name => l_api_name,
382: p_location => l_location

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

426: IS
427: --{
428: l_api_name CONSTANT VARCHAR2(30) := 'process';
429: l_api_version CONSTANT NUMBER := 1.0;
430: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
431: --
432: --
433: l_location VARCHAR2(32767);
434: l_savepoint_name VARCHAR2(30);

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

467: BEGIN
468: --{
469: l_location := '0010';
470: --
471: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
472: THEN
473: RETURN;
474: END IF;
475: --

Line 481: vea_tpa_util_pvt.api_header

477: -- Standard API Header
478: --
479: l_location := '0020';
480: --
481: vea_tpa_util_pvt.api_header
482: (
483: p_package_name => G_PACKAGE_NAME,
484: p_api_name => l_api_name,
485: p_api_type => l_api_type,

Line 507: vea_tpa_util_pvt.add_message_and_raise

503: OR p_tps_program_unit_name IS NULL
504: OR p_tpsPkg_app_name IS NULL
505: OR p_tpsPkg_cs_flag IS NULL
506: THEN
507: vea_tpa_util_pvt.add_message_and_raise
508: (
509: p_error_name => 'VEA_INCOMPATIBLE_LAYER_FILE'
510: );
511: END IF;

Line 604: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' g_current_layer_provider_code is ' || vea_tpa_util_pvt.g_current_layer_provider_code);

600: l_location := '0120';
601: --
602: --
603: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_layer_provider_code is ' || p_layer_provider_code);
604: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' g_current_layer_provider_code is ' || vea_tpa_util_pvt.g_current_layer_provider_code);
605: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' l_program_unit_id is ' || l_program_unit_id);
606: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_program_unit_lp_code is ' || p_program_unit_lp_code);
607: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' l_tps_program_unit_id is ' || l_tps_program_unit_id);
608: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tps_program_unit_lp_code is ' || p_tps_program_unit_lp_code);

Line 615: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

611: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' l_tps_package_id is ' || l_tps_package_id);
612: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tps_package_name is ' || p_tps_package_name);
613: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tpsPkg_cs_flag is ' || p_tpsPkg_cs_flag);
614: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_tpsPkg_app_name is ' || p_tpsPkg_app_name);
615: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
616: THEN
617: SELECT NVL( p_id, vea_layer_headers_s.NEXTVAL )
618: INTO l_layer_header_id
619: FROM DUAL;

Line 681: vea_tpa_util_pvt.api_footer

677: -- Standard API Footer
678: --
679: l_location := '0180';
680: --
681: vea_tpa_util_pvt.api_footer
682: (
683: p_commit => p_commit,
684: x_msg_count => x_msg_count,
685: x_msg_data => x_msg_data

Line 694: vea_tpa_util_pvt.handle_error

690: WHEN FND_API.G_EXC_ERROR
691: THEN
692: --{
693: --RAISE;
694: vea_tpa_util_pvt.handle_error
695: (
696: p_error_type => vea_tpa_util_pvt.G_ERROR,
697: p_savepoint_name => l_savepoint_name,
698: p_package_name => G_PACKAGE_NAME,

Line 696: p_error_type => vea_tpa_util_pvt.G_ERROR,

692: --{
693: --RAISE;
694: vea_tpa_util_pvt.handle_error
695: (
696: p_error_type => vea_tpa_util_pvt.G_ERROR,
697: p_savepoint_name => l_savepoint_name,
698: p_package_name => G_PACKAGE_NAME,
699: p_api_name => l_api_name,
700: p_location => l_location,

Line 710: vea_tpa_util_pvt.handle_error

706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
707: THEN
708: --{
709: --RAISE;
710: vea_tpa_util_pvt.handle_error
711: (
712: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
713: p_savepoint_name => l_savepoint_name,
714: p_package_name => G_PACKAGE_NAME,

Line 712: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

708: --{
709: --RAISE;
710: vea_tpa_util_pvt.handle_error
711: (
712: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
713: p_savepoint_name => l_savepoint_name,
714: p_package_name => G_PACKAGE_NAME,
715: p_api_name => l_api_name,
716: p_location => l_location,

Line 726: vea_tpa_util_pvt.handle_error

722: WHEN OTHERS
723: THEN
724: --{
725: --RAISE;
726: vea_tpa_util_pvt.handle_error
727: (
728: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
729: p_savepoint_name => l_savepoint_name,
730: p_package_name => G_PACKAGE_NAME,

Line 728: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

724: --{
725: --RAISE;
726: vea_tpa_util_pvt.handle_error
727: (
728: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
729: p_savepoint_name => l_savepoint_name,
730: p_package_name => G_PACKAGE_NAME,
731: p_api_name => l_api_name,
732: p_location => l_location,