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_LICENSES_SV dependencies on VEA_TPA_UTIL_PVT

Line 41: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

37: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
38: l_location VARCHAR2(32767);
39: --
40: --
41: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
42: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
43: --}
44: BEGIN
45: --{

Line 42: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

38: l_location VARCHAR2(32767);
39: --
40: --
41: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
42: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
43: --}
44: BEGIN
45: --{
46: l_location := '0010';

Line 74: vea_tpa_util_pvt.add_exc_message_and_raise

70: --{
71: WHEN OTHERS
72: THEN
73: --{
74: vea_tpa_util_pvt.add_exc_message_and_raise
75: (
76: p_package_name => G_PACKAGE_NAME,
77: p_api_name => l_api_name,
78: p_location => l_location

Line 106: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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

Line 107: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

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

Line 127: vea_tpa_util_pvt.add_exc_message_and_raise

123: --{
124: WHEN OTHERS
125: THEN
126: --{
127: vea_tpa_util_pvt.add_exc_message_and_raise
128: (
129: p_package_name => G_PACKAGE_NAME,
130: p_api_name => l_api_name,
131: p_location => l_location

Line 158: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

154: l_api_name CONSTANT VARCHAR2(30) := 'isLicensed';
155: l_location VARCHAR2(32767);
156: --
157: --
158: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
159: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
160: --
161: --
162: CURSOR layer_license_cur

Line 159: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

155: l_location VARCHAR2(32767);
156: --
157: --
158: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
159: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
160: --
161: --
162: CURSOR layer_license_cur
163: (

Line 188: IF NOT( vea_tpa_util_pvt.isLayerMergeOn )

184: --
185: --
186: l_location := '0015';
187: --
188: IF NOT( vea_tpa_util_pvt.isLayerMergeOn )
189: THEN
190: RETURN(TRUE);
191: END IF;
192: --

Line 196: IF vea_tpa_util_pvt.get_curr_layer_provider_code = p_layer_provider_code

192: --
193: --
194: l_location := '0016';
195: --
196: IF vea_tpa_util_pvt.get_curr_layer_provider_code = p_layer_provider_code
197: THEN
198: RETURN(TRUE);
199: END IF;
200: --

Line 204: --IF vea_tpa_util_pvt.get_curr_layer_provider_code like 'CUST%'

200: --
201: --
202: l_location := '0017';
203: --
204: --IF vea_tpa_util_pvt.get_curr_layer_provider_code like 'CUST%'
205: --THEN
206: --{
207: l_location := '0020';
208: --

Line 251: vea_tpa_util_pvt.add_exc_message_and_raise

247: --{
248: WHEN OTHERS
249: THEN
250: --{
251: vea_tpa_util_pvt.add_exc_message_and_raise
252: (
253: p_package_name => G_PACKAGE_NAME,
254: p_api_name => l_api_name,
255: p_location => l_location

Line 281: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

277: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
278: l_location VARCHAR2(32767);
279: --
280: --
281: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
282: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
283: --}
284: BEGIN
285: --{

Line 282: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

278: l_location VARCHAR2(32767);
279: --
280: --
281: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
282: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
283: --}
284: BEGIN
285: --{
286: l_location := '0010';

Line 297: vea_tpa_util_pvt.add_exc_message_and_raise

293: --{
294: WHEN OTHERS
295: THEN
296: --{
297: vea_tpa_util_pvt.add_exc_message_and_raise
298: (
299: p_package_name => G_PACKAGE_NAME,
300: p_api_name => l_api_name,
301: p_location => l_location

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

332: IS
333: --{
334: l_api_name CONSTANT VARCHAR2(30) := 'process';
335: l_api_version CONSTANT NUMBER := 1.0;
336: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
337: --
338: --
339: l_location VARCHAR2(32767);
340: l_savepoint_name VARCHAR2(30);

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

360: BEGIN
361: --{
362: l_location := '0010';
363: --
364: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
365: THEN
366: RETURN;
367: END IF;
368: --

Line 374: vea_tpa_util_pvt.api_header

370: -- Standard API Header
371: --
372: l_location := '0020';
373: --
374: vea_tpa_util_pvt.api_header
375: (
376: p_package_name => G_PACKAGE_NAME,
377: p_api_name => l_api_name,
378: p_api_type => l_api_type,

Line 392: IF vea_tpa_util_pvt.get_curr_customer_name() = p_customer_name

388: --
389: --
390: l_location := '0025';
391: --
392: IF vea_tpa_util_pvt.get_curr_customer_name() = p_customer_name
393: THEN
394: --{
395: l_location := '0030';
396: --

Line 399: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN

395: l_location := '0030';
396: --
397: l_id := NULL;
398: --
399: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
400: --{
401: l_tp_layer_id := nvl(vea_tp_layers_sv.g_tp_layer_id,p_tp_layer_id);
402: --}
403: ELSE

Line 468: vea_tpa_util_pvt.api_footer

464: -- Standard API Footer
465: --
466: l_location := '0090';
467: --
468: vea_tpa_util_pvt.api_footer
469: (
470: p_commit => p_commit,
471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data

Line 481: vea_tpa_util_pvt.handle_error

477: WHEN FND_API.G_EXC_ERROR
478: THEN
479: --{
480: --RAISE;
481: vea_tpa_util_pvt.handle_error
482: (
483: p_error_type => vea_tpa_util_pvt.G_ERROR,
484: p_savepoint_name => l_savepoint_name,
485: p_package_name => G_PACKAGE_NAME,

Line 483: p_error_type => vea_tpa_util_pvt.G_ERROR,

479: --{
480: --RAISE;
481: vea_tpa_util_pvt.handle_error
482: (
483: p_error_type => vea_tpa_util_pvt.G_ERROR,
484: p_savepoint_name => l_savepoint_name,
485: p_package_name => G_PACKAGE_NAME,
486: p_api_name => l_api_name,
487: p_location => l_location,

Line 497: vea_tpa_util_pvt.handle_error

493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
494: THEN
495: --{
496: --RAISE;
497: vea_tpa_util_pvt.handle_error
498: (
499: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
500: p_savepoint_name => l_savepoint_name,
501: p_package_name => G_PACKAGE_NAME,

Line 499: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

495: --{
496: --RAISE;
497: vea_tpa_util_pvt.handle_error
498: (
499: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
500: p_savepoint_name => l_savepoint_name,
501: p_package_name => G_PACKAGE_NAME,
502: p_api_name => l_api_name,
503: p_location => l_location,

Line 513: vea_tpa_util_pvt.handle_error

509: WHEN OTHERS
510: THEN
511: --{
512: --RAISE;
513: vea_tpa_util_pvt.handle_error
514: (
515: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
516: p_savepoint_name => l_savepoint_name,
517: p_package_name => G_PACKAGE_NAME,

Line 515: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

511: --{
512: --RAISE;
513: vea_tpa_util_pvt.handle_error
514: (
515: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
516: p_savepoint_name => l_savepoint_name,
517: p_package_name => G_PACKAGE_NAME,
518: p_api_name => l_api_name,
519: p_location => l_location,