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

Line 39: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

35: l_api_name CONSTANT VARCHAR2(30) := 'validateUniqueCodes';
36: l_location VARCHAR2(32767);
37: --
38: --
39: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
40: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
41: --
42: --
43: CURSOR layer_cur IS

Line 40: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

36: l_location VARCHAR2(32767);
37: --
38: --
39: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
40: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
41: --
42: --
43: CURSOR layer_cur IS
44: --

Line 60: vea_tpa_util_pvt.add_message_and_raise

56: --{
57: l_location := '0020';
58: --
59: --
60: vea_tpa_util_pvt.add_message_and_raise
61: (
62: p_error_name => 'VEA_LAYER_PROVIDER_CODE_EXIST',
63: p_token1 => 'LAYER_PROVIDER_NAME',
64: p_value1 => p_layer_provider_name

Line 84: vea_tpa_util_pvt.add_exc_message_and_raise

80: --}
81: WHEN OTHERS
82: THEN
83: --{
84: vea_tpa_util_pvt.add_exc_message_and_raise
85: (
86: p_package_name => G_PACKAGE_NAME,
87: p_api_name => l_api_name,
88: p_location => l_location

Line 114: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

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

Line 115: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

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

Line 122: IF vea_tpa_util_pvt.validate

118: --{
119: l_location := '0010';
120: --
121: -- what does this do ??
122: IF vea_tpa_util_pvt.validate
123: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
124: THEN
125:
126: --{

Line 123: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)

119: l_location := '0010';
120: --
121: -- what does this do ??
122: IF vea_tpa_util_pvt.validate
123: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
124: THEN
125:
126: --{
127: l_location := '0020';

Line 151: vea_tpa_util_pvt.add_exc_message_and_raise

147: --}
148: WHEN OTHERS
149: THEN
150: --{
151: vea_tpa_util_pvt.add_exc_message_and_raise
152: (
153: p_package_name => G_PACKAGE_NAME,
154: p_api_name => l_api_name,
155: p_location => l_location

Line 183: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

179: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
180: l_location VARCHAR2(32767);
181: --
182: --
183: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
184: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
185: --}
186: BEGIN
187: --{

Line 184: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

180: l_location VARCHAR2(32767);
181: --
182: --
183: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
184: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
185: --}
186: BEGIN
187: --{
188: l_location := '0010';

Line 227: vea_tpa_util_pvt.add_exc_message_and_raise

223: --{
224: WHEN OTHERS
225: THEN
226: --{
227: vea_tpa_util_pvt.add_exc_message_and_raise
228: (
229: p_package_name => G_PACKAGE_NAME,
230: p_api_name => l_api_name,
231: p_location => l_location

Line 259: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

255: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
256: l_location VARCHAR2(32767);
257: --
258: --
259: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
260: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
261: --}
262: BEGIN
263: --{

Line 260: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

256: l_location VARCHAR2(32767);
257: --
258: --
259: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
260: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
261: --}
262: BEGIN
263: --{
264: l_location := '0010';

Line 280: vea_tpa_util_pvt.add_exc_message_and_raise

276: --{
277: WHEN OTHERS
278: THEN
279: --{
280: vea_tpa_util_pvt.add_exc_message_and_raise
281: (
282: p_package_name => G_PACKAGE_NAME,
283: p_api_name => l_api_name,
284: p_location => l_location

Line 311: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

307: l_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
308: l_location VARCHAR2(32767);
309: --
310: --
311: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
312: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
313: --
314: --
315: l_layer_count NUMBER;

Line 312: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

308: l_location VARCHAR2(32767);
309: --
310: --
311: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
312: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
313: --
314: --
315: l_layer_count NUMBER;
316: --

Line 355: ELSIF NOT(vea_tpa_util_pvt.isLayerMergeOn) THEN

351: --
352: l_location := '0050';
353: --}
354: --
355: ELSIF NOT(vea_tpa_util_pvt.isLayerMergeOn) THEN
356: --
357: --{
358: l_location := '0060';
359: --

Line 360: vea_tpa_util_pvt.add_message_and_raise

356: --
357: --{
358: l_location := '0060';
359: --
360: vea_tpa_util_pvt.add_message_and_raise
361: (
362: p_error_name => 'VEA_LAYER_EXISTS_FOR_PROVIDER',
363: p_token1 => 'LAYER_PROVIDER_NAME',
364: p_value1 => p_layer_provider_name

Line 379: vea_tpa_util_pvt.add_exc_message_and_raise

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

Line 441: vea_tpa_util_pvt.add_message_and_raise

437: l_location := '0040';
438: --
439: --
440: /* No such layer provider name found */
441: vea_tpa_util_pvt.add_message_and_raise
442: (
443: p_error_name => 'VEA_LAYER_NAME_NOTFOUND',
444: p_token1 => 'LAYER_PROVIDER_NAME',
445: p_value1 => p_layer_provider_name

Line 455: vea_tpa_util_pvt.add_exc_message_and_raise

451: --{
452: WHEN OTHERS
453: THEN
454: --{
455: vea_tpa_util_pvt.add_exc_message_and_raise
456: (
457: p_package_name => G_PACKAGE_NAME,
458: p_api_name => l_api_name,
459: p_location => l_location

Line 517: vea_tpa_util_pvt.add_message_and_raise

513: l_location := '0040';
514: --
515: --
516: /* No such layer provider code found */
517: vea_tpa_util_pvt.add_message_and_raise
518: (
519: p_error_name => 'VEA_LAYER_CODE_NOTFOUND',
520: p_token1 => 'LAYER_PROVIDER_CODE',
521: p_value1 => p_layer_provider_code

Line 531: vea_tpa_util_pvt.add_exc_message_and_raise

527: --{
528: WHEN OTHERS
529: THEN
530: --{
531: vea_tpa_util_pvt.add_exc_message_and_raise
532: (
533: p_package_name => G_PACKAGE_NAME,
534: p_api_name => l_api_name,
535: p_location => l_location

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

565: IS
566: --{
567: l_api_name CONSTANT VARCHAR2(30) := 'process';
568: l_api_version CONSTANT NUMBER := 1.0;
569: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
570: --
571: --
572: l_location VARCHAR2(32767);
573: l_savepoint_name VARCHAR2(30);

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

597: BEGIN
598: --{
599: l_location := '0010';
600: --
601: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
602: THEN
603: RETURN;
604: END IF;
605: --

Line 611: vea_tpa_util_pvt.api_header

607: -- Standard API Header
608: --
609: l_location := '0020';
610: --
611: vea_tpa_util_pvt.api_header
612: (
613: p_package_name => G_PACKAGE_NAME,
614: p_api_name => l_api_name,
615: p_api_type => l_api_type,

Line 638: IF (vea_tpa_util_pvt.isLayerMergeOn)

634: --
635: l_location := '0040';
636: --
637: --
638: IF (vea_tpa_util_pvt.isLayerMergeOn)
639: THEN
640: open layer_cur for
641: 'select layer_provider_id,
642: layer_provider_code, layer_provider_name

Line 687: --IF ( vea_tpa_util_pvt.isLayerMergeOn ) AND (l_layer_count = 0)

683: --
684: l_location := '0100';
685: --
686: -- Bug No: 1389096.
687: --IF ( vea_tpa_util_pvt.isLayerMergeOn ) AND (l_layer_count = 0)
688: IF ( vea_tpa_util_pvt.isLayerMergeOn )
689: THEN
690: --{
691: update_row

Line 688: IF ( vea_tpa_util_pvt.isLayerMergeOn )

684: l_location := '0100';
685: --
686: -- Bug No: 1389096.
687: --IF ( vea_tpa_util_pvt.isLayerMergeOn ) AND (l_layer_count = 0)
688: IF ( vea_tpa_util_pvt.isLayerMergeOn )
689: THEN
690: --{
691: update_row
692: (

Line 707: vea_tpa_util_pvt.update_lookup_values

703: p_layer_provider_code => p_layer_provider_code,
704: p_layer_provider_name => p_layer_provider_name,
705: p_description => p_description
706: );
707: vea_tpa_util_pvt.update_lookup_values
708: (
709: p_lookup_type => 'VEA_LAYER_PROVIDERS',
710: p_new_lookup_code => p_layer_provider_code,
711: p_current_lookup_code => layer_rec.layer_provider_code,

Line 716: vea_tpa_util_pvt.add_message_and_raise

712: p_meaning => p_layer_provider_name,
713: p_description => p_layer_provider_name
714: );
715: ELSE
716: vea_tpa_util_pvt.add_message_and_raise
717: (
718: p_error_name => 'VEA_LAYER_EXISTS_FOR_PROVIDER',
719: p_token1 => 'LAYER_PROVIDER_NAME',
720: p_value1 => layer_rec.layer_provider_name

Line 747: IF NOT( vea_tpa_util_pvt.isLayerMergeOn )

743: p_layer_provider_code => p_layer_provider_code,
744: p_layer_provider_name => p_layer_provider_name,
745: p_description => p_description
746: );
747: IF NOT( vea_tpa_util_pvt.isLayerMergeOn )
748: THEN
749: --{
750: vea_tpa_util_pvt.insert_lookup_values
751: (

Line 750: vea_tpa_util_pvt.insert_lookup_values

746: );
747: IF NOT( vea_tpa_util_pvt.isLayerMergeOn )
748: THEN
749: --{
750: vea_tpa_util_pvt.insert_lookup_values
751: (
752: p_lookup_type => 'VEA_LAYER_PROVIDERS',
753: p_lookup_code => p_layer_provider_code,
754: p_meaning => p_layer_provider_name,

Line 776: vea_tpa_util_pvt.api_footer

772: -- Standard API Footer
773: --
774: l_location := '0130';
775: --
776: vea_tpa_util_pvt.api_footer
777: (
778: p_commit => p_commit,
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data

Line 789: vea_tpa_util_pvt.handle_error

785: WHEN FND_API.G_EXC_ERROR
786: THEN
787: --{
788: --RAISE;
789: vea_tpa_util_pvt.handle_error
790: (
791: p_error_type => vea_tpa_util_pvt.G_ERROR,
792: p_savepoint_name => l_savepoint_name,
793: p_package_name => G_PACKAGE_NAME,

Line 791: p_error_type => vea_tpa_util_pvt.G_ERROR,

787: --{
788: --RAISE;
789: vea_tpa_util_pvt.handle_error
790: (
791: p_error_type => vea_tpa_util_pvt.G_ERROR,
792: p_savepoint_name => l_savepoint_name,
793: p_package_name => G_PACKAGE_NAME,
794: p_api_name => l_api_name,
795: p_location => l_location,

Line 805: vea_tpa_util_pvt.handle_error

801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
802: THEN
803: --{
804: --RAISE;
805: vea_tpa_util_pvt.handle_error
806: (
807: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
808: p_savepoint_name => l_savepoint_name,
809: p_package_name => G_PACKAGE_NAME,

Line 807: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

803: --{
804: --RAISE;
805: vea_tpa_util_pvt.handle_error
806: (
807: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
808: p_savepoint_name => l_savepoint_name,
809: p_package_name => G_PACKAGE_NAME,
810: p_api_name => l_api_name,
811: p_location => l_location,

Line 821: vea_tpa_util_pvt.handle_error

817: WHEN OTHERS
818: THEN
819: --{
820: --RAISE;
821: vea_tpa_util_pvt.handle_error
822: (
823: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
824: p_savepoint_name => l_savepoint_name,
825: p_package_name => G_PACKAGE_NAME,

Line 823: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

819: --{
820: --RAISE;
821: vea_tpa_util_pvt.handle_error
822: (
823: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
824: p_savepoint_name => l_savepoint_name,
825: p_package_name => G_PACKAGE_NAME,
826: p_api_name => l_api_name,
827: p_location => l_location,