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.AMS_GEO_AREAS_PVT dependencies on AMS_UTILITY_PVT

Line 60: AMS_Utility_PVT.debug_message(l_full_name || ': start');

56: IF (AMS_DEBUG_HIGH_ON) THEN
57:
58:
59:
60: AMS_Utility_PVT.debug_message(l_full_name || ': start');
61:
62: END IF;
63:
64: IF NOT FND_API.compatible_api_call

Line 81: AMS_Utility_PVT.debug_message(l_full_name || ': validate');

77: -- validate
78: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
79: IF (AMS_DEBUG_HIGH_ON) THEN
80:
81: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
82: END IF;
83:
84: validate_geo_area
85: (

Line 105: AMS_Utility_PVT.debug_message(l_full_name || ': insert');

101:
102: -- insert
103: IF (AMS_DEBUG_HIGH_ON) THEN
104:
105: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
106: END IF;
107:
108: IF l_geo_area_rec.activity_geo_area_id IS NULL THEN
109: LOOP

Line 227: AMS_Utility_PVT.debug_message(l_full_name||': end');

223: IF (AMS_DEBUG_HIGH_ON) THEN
224:
225:
226:
227: AMS_Utility_PVT.debug_message(l_full_name||': end');
228:
229: END IF;
230:
231: EXCEPTION

Line 308: AMS_Utility_PVT.debug_message(l_full_name || ': start');

304: IF (AMS_DEBUG_HIGH_ON) THEN
305:
306:
307:
308: AMS_Utility_PVT.debug_message(l_full_name || ': start');
309:
310: END IF;
311:
312: IF NOT FND_API.compatible_api_call

Line 335: AMS_Utility_PVT.debug_message(l_full_name || ': validate'||l_geo_area_rec.object_version_number);

331: -- validate
332: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: AMS_Utility_PVT.debug_message(l_full_name || ': validate'||l_geo_area_rec.object_version_number);
336: END IF;
337:
338: check_items
339: (

Line 355: AMS_Utility_PVT.debug_message(l_full_name||': update');

351:
352: -- update
353: IF (AMS_DEBUG_HIGH_ON) THEN
354:
355: AMS_Utility_PVT.debug_message(l_full_name||': update');
356: END IF;
357:
358: UPDATE AMS_ACT_GEO_AREAS SET
359: last_update_date = SYSDATE,

Line 410: AMS_Utility_PVT.debug_message(l_full_name || ': end');

406: IF (AMS_DEBUG_HIGH_ON) THEN
407:
408:
409:
410: AMS_Utility_PVT.debug_message(l_full_name || ': end');
411:
412: END IF;
413:
414: EXCEPTION

Line 499: AMS_Utility_PVT.debug_message(l_full_name || ': start');

495: IF (AMS_DEBUG_HIGH_ON) THEN
496:
497:
498:
499: AMS_Utility_PVT.debug_message(l_full_name || ': start');
500:
501: END IF;
502:
503: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 527: AMS_Utility_PVT.debug_message(l_full_name || ': delete');

523:
524: -- delete
525: IF (AMS_DEBUG_HIGH_ON) THEN
526:
527: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
528: END IF;
529:
530: DELETE FROM AMS_ACT_GEO_AREAS
531: WHERE activity_geo_area_id = p_geo_area_id

Line 592: AMS_Utility_PVT.debug_message(l_full_name || ': end');

588: IF (AMS_DEBUG_HIGH_ON) THEN
589:
590:
591:
592: AMS_Utility_PVT.debug_message(l_full_name || ': end');
593:
594: END IF;
595:
596: EXCEPTION

Line 670: AMS_Utility_PVT.debug_message(l_full_name || ': start');

666: BEGIN
667: -- initialize
668: IF (AMS_DEBUG_HIGH_ON) THEN
669:
670: AMS_Utility_PVT.debug_message(l_full_name || ': start');
671: END IF;
672:
673: IF FND_API.to_boolean(p_init_msg_list) THEN
674: FND_MSG_PUB.initialize;

Line 693: AMS_Utility_PVT.debug_message(l_full_name || ': lock');

689:
690: -- lock
691: IF (AMS_DEBUG_HIGH_ON) THEN
692:
693: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
694: END IF;
695:
696: OPEN c_geo_area;
697: FETCH c_geo_area INTO l_geo_area_id;

Line 720: AMS_Utility_PVT.debug_message(l_full_name || ': end');

716: IF (AMS_DEBUG_HIGH_ON) THEN
717:
718:
719:
720: AMS_Utility_PVT.debug_message(l_full_name || ': end');
721:
722: END IF;
723:
724: EXCEPTION

Line 726: WHEN AMS_Utility_PVT.resource_locked THEN

722: END IF;
723:
724: EXCEPTION
725:
726: WHEN AMS_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;

Line 804: AMS_Utility_PVT.debug_message(l_full_name||': start');

800:
801: ----------------------- initialize --------------------
802: IF (AMS_DEBUG_HIGH_ON) THEN
803:
804: AMS_Utility_PVT.debug_message(l_full_name||': start');
805: END IF;
806:
807: -- IF FND_API.to_boolean(p_init_msg_list) THEN
808: -- FND_MSG_PUB.initialize;

Line 826: AMS_Utility_PVT.debug_message(l_full_name||': check items');

822: ---------------------- validate ------------------------
823: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
824: IF (AMS_DEBUG_HIGH_ON) THEN
825:
826: AMS_Utility_PVT.debug_message(l_full_name||': check items');
827: END IF;
828: check_items
829: (
830: p_validation_mode => JTF_PLSQL_API.g_create,

Line 853: AMS_Utility_PVT.debug_message(l_full_name ||': end');

849: IF (AMS_DEBUG_HIGH_ON) THEN
850:
851:
852:
853: AMS_Utility_PVT.debug_message(l_full_name ||': end');
854:
855: END IF;
856:
857: EXCEPTION

Line 913: AMS_Utility_PVT.debug_message(l_full_name || ': start');

909: BEGIN
910: -- initialize
911: IF (AMS_DEBUG_HIGH_ON) THEN
912:
913: AMS_Utility_PVT.debug_message(l_full_name || ': start');
914: END IF;
915:
916: x_return_status := FND_API.g_ret_sts_success;
917:

Line 921: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');

917:
918: -- check required items
919: IF (AMS_DEBUG_HIGH_ON) THEN
920:
921: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
922: END IF;
923: check_geo_area_req_items
924: (
925: p_validation_mode => p_validation_mode,

Line 937: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');

933:
934: -- check unique key items
935: IF (AMS_DEBUG_HIGH_ON) THEN
936:
937: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
938: END IF;
939: check_geo_area_uk_items
940: (
941: p_validation_mode => p_validation_mode,

Line 953: AMS_Utility_PVT.debug_message(l_full_name || ': check fk items');

949:
950: -- check foreign key items
951: IF (AMS_DEBUG_HIGH_ON) THEN
952:
953: AMS_Utility_PVT.debug_message(l_full_name || ': check fk items');
954: END IF;
955: check_geo_area_fk_items
956: (
957: p_geo_area_rec => p_geo_area_rec,

Line 1093: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1089: -- check PK, if activity_geo_area_id is passed in, must check if it is duplicate
1090: IF p_validation_mode = JTF_PLSQL_API.g_create
1091: AND p_geo_area_rec.activity_geo_area_id IS NOT NULL
1092: THEN
1093: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1094: (
1095: 'AMS_ACT_GEO_AREAS',
1096: 'activity_geo_area_id = ' || p_geo_area_rec.activity_geo_area_id
1097: );

Line 1113: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1109:
1110: -- check used_by, used_by_id
1111: IF p_geo_area_rec.activity_geo_area_id IS NOT NULL THEN -- UPDATE RECORD
1112:
1113: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1114: (
1115: 'AMS_ACT_GEO_AREAS',
1116: 'activity_geo_area_id <> ' || p_geo_area_rec.activity_geo_area_id
1117: || ' AND geo_hierarchy_id = ' || p_geo_area_rec.geo_hierarchy_id

Line 1122: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1118: || ' AND act_geo_area_used_by_id = ' || p_geo_area_rec.act_geo_area_used_by_id
1119: || ' AND arc_act_geo_area_used_by = ''' || p_geo_area_rec.arc_act_geo_area_used_by || ''''
1120: );
1121: ELSE -- NEW RECORD
1122: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1123: (
1124: 'AMS_ACT_GEO_AREAS',
1125: 'act_geo_area_used_by_id = ' || p_geo_area_rec.act_geo_area_used_by_id
1126: || ' AND geo_hierarchy_id = ' || p_geo_area_rec.geo_hierarchy_id

Line 1173: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1169: -- check act_geo_area_used_by_id
1170:
1171: --modified by soagrawa on 29-Jun-2001
1172: /*****
1173: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1174: (
1175: 'AMS_CAMPAIGNS_VL',
1176: 'campaign_id',
1177: p_geo_area_rec.act_geo_area_used_by_id

Line 1185: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (

1181: /*********************** CODE COMMENTED BY ABHOLA **********************************
1182: -- 22 - APR - 02
1183: --
1184:
1185: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
1186: p_sys_qual => p_geo_area_rec.arc_act_geo_area_used_by,
1187: x_return_status => x_return_status,
1188: x_table_name => l_table_name,
1189: x_pk_name => l_pk_name

Line 1193: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1189: x_pk_name => l_pk_name
1190: );
1191:
1192: l_pk_value := p_geo_area_rec.act_geo_area_used_by_id;
1193: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1194: l_additional_where_clause := NULL;
1195:
1196: l_fk_flag := AMS_Utility_PVT.Check_FK_Exists (
1197: p_table_name => l_table_name

Line 1196: l_fk_flag := AMS_Utility_PVT.Check_FK_Exists (

1192: l_pk_value := p_geo_area_rec.act_geo_area_used_by_id;
1193: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1194: l_additional_where_clause := NULL;
1195:
1196: l_fk_flag := AMS_Utility_PVT.Check_FK_Exists (
1197: p_table_name => l_table_name
1198: ,p_pk_name => l_pk_name
1199: ,p_pk_value => l_pk_value
1200: ,p_pk_data_type => l_pk_data_type

Line 1220: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1216:
1217: ************************************************************************************/
1218:
1219: -- check geo_area_type_code
1220: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1221: (
1222: 'JTF_LOC_TYPES_VL',
1223: 'location_type_code',
1224: p_geo_area_rec.geo_area_type_code,

Line 1239: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1235: RETURN;
1236: END IF;
1237:
1238: -- check geo_hierarchy_id
1239: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1240: (
1241: 'JTF_LOC_HIERARCHIES_B',
1242: 'location_hierarchy_id',
1243: p_geo_area_rec.geo_hierarchy_id