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

Line 49: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

45: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
46: l_location VARCHAR2(32767);
47: --
48: --
49: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
50: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
51: --}
52: BEGIN
53: --{

Line 50: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

46: l_location VARCHAR2(32767);
47: --
48: --
49: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
50: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
51: --}
52: BEGIN
53: --{
54: l_location := '0010';

Line 88: vea_tpa_util_pvt.add_exc_message_and_raise

84: --{
85: WHEN OTHERS
86: THEN
87: --{
88: vea_tpa_util_pvt.add_exc_message_and_raise
89: (
90: p_package_name => G_PACKAGE_NAME,
91: p_api_name => l_api_name,
92: p_location => l_location

Line 128: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

124: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
125: l_location VARCHAR2(32767);
126: --
127: --
128: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
129: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
130: --}
131: BEGIN
132: --{

Line 129: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

125: l_location VARCHAR2(32767);
126: --
127: --
128: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
129: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
130: --}
131: BEGIN
132: --{
133: l_location := '0010';

Line 157: vea_tpa_util_pvt.add_exc_message_and_raise

153: --{
154: WHEN OTHERS
155: THEN
156: --{
157: vea_tpa_util_pvt.add_exc_message_and_raise
158: (
159: p_package_name => G_PACKAGE_NAME,
160: p_api_name => l_api_name,
161: p_location => l_location

Line 211: vea_tpa_util_pvt.add_exc_message_and_raise

207: --{
208: WHEN OTHERS
209: THEN
210: --{
211: vea_tpa_util_pvt.add_exc_message_and_raise
212: (
213: p_package_name => G_PACKAGE_NAME,
214: p_api_name => l_api_name,
215: p_location => l_location

Line 459: vea_tpa_util_pvt.add_exc_message_and_raise

455: --{
456: WHEN OTHERS
457: THEN
458: --{
459: vea_tpa_util_pvt.add_exc_message_and_raise
460: (
461: p_package_name => G_PACKAGE_NAME,
462: p_api_name => l_api_name,
463: p_location => l_location

Line 491: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

487: l_api_name CONSTANT VARCHAR2(30) := 'getName';
488: l_location VARCHAR2(32767);
489: --
490: --
491: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
492: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
493: --
494: --
495: CURSOR program_unit_cur

Line 492: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

488: l_location VARCHAR2(32767);
489: --
490: --
491: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
492: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
493: --
494: --
495: CURSOR program_unit_cur
496: IS

Line 525: vea_tpa_util_pvt.add_exc_message_and_raise

521: --{
522: WHEN OTHERS
523: THEN
524: --{
525: vea_tpa_util_pvt.add_exc_message_and_raise
526: (
527: p_package_name => G_PACKAGE_NAME,
528: p_api_name => l_api_name,
529: p_location => l_location

Line 557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

553: l_api_name CONSTANT VARCHAR2(30) := 'validateMapping';
554: l_location VARCHAR2(32767);
555: --
556: --
557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
559: --
560: --
561: l_program_unit_name vea_program_units.name%TYPE;

Line 558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

554: l_location VARCHAR2(32767);
555: --
556: --
557: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
558: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
559: --
560: --
561: l_program_unit_name vea_program_units.name%TYPE;
562: l_package_name vea_packages.name%TYPE;

Line 572: IF vea_tpa_util_pvt.validate

568: BEGIN
569: --{
570: l_location := '0010';
571: --
572: IF vea_tpa_util_pvt.validate
573: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
574: AND p_old_tpa_program_unit_id <> p_tpa_program_unit_id
575: THEN
576: --{

Line 573: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)

569: --{
570: l_location := '0010';
571: --
572: IF vea_tpa_util_pvt.validate
573: AND NOT(vea_tpa_util_pvt.isLayerMergeOn)
574: AND p_old_tpa_program_unit_id <> p_tpa_program_unit_id
575: THEN
576: --{
577: l_location := '0020';

Line 612: vea_tpa_util_pvt.add_message_and_raise

608: --
609: --
610: l_location := '0020';
611: --
612: vea_tpa_util_pvt.add_message_and_raise
613: (
614: p_error_name => 'VEA_IMPORT_DUP_TPA_MAPPING',
615: p_token1 => 'TPA_PROGRAM_UNIT_NAME',
616: p_value1 => l_tpa_program_unit_name,

Line 641: vea_tpa_util_pvt.add_exc_message_and_raise

637: --}
638: WHEN OTHERS
639: THEN
640: --{
641: vea_tpa_util_pvt.add_exc_message_and_raise
642: (
643: p_package_name => G_PACKAGE_NAME,
644: p_api_name => l_api_name,
645: p_location => l_location

Line 672: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;

668: l_api_name CONSTANT VARCHAR2(30) := 'deleteUnreferencedProgramUnits';
669: l_location VARCHAR2(32767);
670: --
671: --
672: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
673: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
674: --
675: --
676: CURSOR program_unit_cur

Line 673: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;

669: l_location VARCHAR2(32767);
670: --
671: --
672: l_user_id NUMBER := vea_tpa_util_pvt.get_user_id;
673: l_login_id NUMBER := vea_tpa_util_pvt.get_login_id;
674: --
675: --
676: CURSOR program_unit_cur
677: IS

Line 712: vea_tpa_util_pvt.add_exc_message_and_raise

708: --{
709: WHEN OTHERS
710: THEN
711: --{
712: vea_tpa_util_pvt.add_exc_message_and_raise
713: (
714: p_package_name => G_PACKAGE_NAME,
715: p_api_name => l_api_name,
716: p_location => l_location

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

824: IS
825: --{
826: l_api_name CONSTANT VARCHAR2(30) := 'process';
827: l_api_version CONSTANT NUMBER := 1.0;
828: l_api_type CONSTANT VARCHAR2(3) := vea_tpa_util_pvt.G_PUBLIC_API;
829: --
830: --
831: l_location VARCHAR2(32767);
832: l_savepoint_name VARCHAR2(30);

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

874: BEGIN
875: --{
876: l_location := '0010';
877: --
878: IF NOT( vea_tpa_util_pvt.is_vea_installed() )
879: THEN
880: RETURN;
881: END IF;
882: --

Line 888: vea_tpa_util_pvt.api_header

884: -- Standard API Header
885: --
886: l_location := '0020';
887: --
888: vea_tpa_util_pvt.api_header
889: (
890: p_package_name => G_PACKAGE_NAME,
891: p_api_name => l_api_name,
892: p_api_type => l_api_type,

Line 910: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN

906: g_program_unit_id := p_id;
907: l_tpa_program_unit_id := p_tpa_program_unit_id;
908: --
909: --
910: IF (VEA_TPA_UTIL_PVT.isLayerMergeOn) THEN
911: --{
912: --FND_FILE.PUT_LINE ( FND_FILE.LOG, ' p_package_id ' || p_package_id);
913: --l_package_id := nvl(vea_packages_sv.g_package_id,p_package_id);
914: l_location := '0040';

Line 926: vea_tpa_util_pvt.get

922: --{
923: BEGIN
924: l_location := '0050';
925: --
926: vea_tpa_util_pvt.get
927: (
928: p_key => p_tpa_program_unit_id,
929: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
930: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,

Line 929: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,

925: --
926: vea_tpa_util_pvt.get
927: (
928: p_key => p_tpa_program_unit_id,
929: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
930: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,
931: x_value => l_tpa_program_unit_id
932: );
933: EXCEPTION

Line 930: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,

926: vea_tpa_util_pvt.get
927: (
928: p_key => p_tpa_program_unit_id,
929: p_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
930: p_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl,
931: x_value => l_tpa_program_unit_id
932: );
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN

Line 993: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code

989: THEN
990: --{
991: l_location := '0120';
992: --
993: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
994: THEN
995: SELECT NVL( p_id, vea_program_units_s.NEXTVAL )
996: INTO l_program_unit_id
997: FROM DUAL;

Line 1010: vea_tpa_util_pvt.put

1006: --
1007: IF p_tpa_program_unit_id IS NOT NULL
1008: AND l_tpa_program_unit_id IS NULL
1009: THEN
1010: vea_tpa_util_pvt.put
1011: (
1012: p_key => l_program_unit_id,
1013: p_value => p_tpa_program_unit_id,
1014: x_cache_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_tbl,

Line 1014: x_cache_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_tbl,

1010: vea_tpa_util_pvt.put
1011: (
1012: p_key => l_program_unit_id,
1013: p_value => p_tpa_program_unit_id,
1014: x_cache_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_tbl,
1015: x_cache_ext_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_ext_tbl
1016: );
1017: END IF;
1018: --

Line 1015: x_cache_ext_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_ext_tbl

1011: (
1012: p_key => l_program_unit_id,
1013: p_value => p_tpa_program_unit_id,
1014: x_cache_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_tbl,
1015: x_cache_ext_tbl => vea_tpa_util_pvt.g_pend_puId_tpaPUId_ext_tbl
1016: );
1017: END IF;
1018: --
1019: --

Line 1113: vea_tpa_util_pvt.put

1109: --
1110: --
1111: IF p_id IS NOT NULL
1112: THEN
1113: vea_tpa_util_pvt.put
1114: (
1115: p_key => p_id,
1116: p_value => l_program_unit_id,
1117: x_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,

Line 1117: x_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,

1113: vea_tpa_util_pvt.put
1114: (
1115: p_key => p_id,
1116: p_value => l_program_unit_id,
1117: x_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
1118: x_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl
1119: );
1120: END IF;
1121: --

Line 1118: x_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl

1114: (
1115: p_key => p_id,
1116: p_value => l_program_unit_id,
1117: x_cache_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_tbl,
1118: x_cache_ext_tbl => vea_tpa_util_pvt.g_PU_fileId_dbId_ext_tbl
1119: );
1120: END IF;
1121: --
1122: --}

Line 1133: vea_tpa_util_pvt.api_footer

1129: -- Standard API Footer
1130: --
1131: l_location := '0200';
1132: --
1133: vea_tpa_util_pvt.api_footer
1134: (
1135: p_commit => p_commit,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data

Line 1146: vea_tpa_util_pvt.handle_error

1142: WHEN FND_API.G_EXC_ERROR
1143: THEN
1144: --{
1145: --RAISE;
1146: vea_tpa_util_pvt.handle_error
1147: (
1148: p_error_type => vea_tpa_util_pvt.G_ERROR,
1149: p_savepoint_name => l_savepoint_name,
1150: p_package_name => G_PACKAGE_NAME,

Line 1148: p_error_type => vea_tpa_util_pvt.G_ERROR,

1144: --{
1145: --RAISE;
1146: vea_tpa_util_pvt.handle_error
1147: (
1148: p_error_type => vea_tpa_util_pvt.G_ERROR,
1149: p_savepoint_name => l_savepoint_name,
1150: p_package_name => G_PACKAGE_NAME,
1151: p_api_name => l_api_name,
1152: p_location => l_location,

Line 1162: vea_tpa_util_pvt.handle_error

1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1159: THEN
1160: --{
1161: --RAISE;
1162: vea_tpa_util_pvt.handle_error
1163: (
1164: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1165: p_savepoint_name => l_savepoint_name,
1166: p_package_name => G_PACKAGE_NAME,

Line 1164: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,

1160: --{
1161: --RAISE;
1162: vea_tpa_util_pvt.handle_error
1163: (
1164: p_error_type => vea_tpa_util_pvt.G_UNEXPECTED_ERROR,
1165: p_savepoint_name => l_savepoint_name,
1166: p_package_name => G_PACKAGE_NAME,
1167: p_api_name => l_api_name,
1168: p_location => l_location,

Line 1178: vea_tpa_util_pvt.handle_error

1174: WHEN OTHERS
1175: THEN
1176: --{
1177: --RAISE;
1178: vea_tpa_util_pvt.handle_error
1179: (
1180: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1181: p_savepoint_name => l_savepoint_name,
1182: p_package_name => G_PACKAGE_NAME,

Line 1180: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,

1176: --{
1177: --RAISE;
1178: vea_tpa_util_pvt.handle_error
1179: (
1180: p_error_type => vea_tpa_util_pvt.G_OTHER_ERROR,
1181: p_savepoint_name => l_savepoint_name,
1182: p_package_name => G_PACKAGE_NAME,
1183: p_api_name => l_api_name,
1184: p_location => l_location,