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_LISTSOURCETYPE_PVT dependencies on AMS_UTILITY_PVT

Line 128: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

124: BEGIN
125: --------------------- initialize -----------------------
126: SAVEPOINT Create_ListSourceType;
127:
128: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
129:
130: IF FND_API.to_boolean (p_init_msg_list) THEN
131: FND_MSG_PUB.initialize;
132: END IF;

Line 146: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

142:
143: x_return_status := FND_API.g_ret_sts_success;
144:
145: ----------------------- validate -----------------------
146: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
147:
148: Validate_ListSourceType (
149: p_api_version => l_api_version,
150: p_init_msg_list => p_init_msg_list,

Line 193: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');

189: END LOOP;
190: END IF;
191:
192: -------------------------- insert --------------------------
193: AMS_Utility_PVT.debug_message (l_full_name || ': Insert');
194:
195: INSERT INTO ams_list_src_types (
196: list_source_type_id,
197: last_update_date,

Line 296: AMS_Utility_PVT.debug_message (l_full_name || ': End');

292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295:
296: AMS_Utility_PVT.debug_message (l_full_name || ': End');
297:
298: EXCEPTION
299: WHEN FND_API.g_exc_error THEN
300: ROLLBACK TO Create_ListSourceType;

Line 404: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

400: BEGIN
401: --------------------- initialize -----------------------
402: SAVEPOINT Delete_ListSourceType;
403:
404: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
405:
406: IF FND_API.to_boolean (p_init_msg_list) THEN
407: FND_MSG_PUB.initialize;
408: END IF;

Line 458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DATASOURCE_USED');

454: OPEN c_analytics_ds_used(p_list_source_type_id);
455: FETCH c_analytics_ds_used INTO l_no_of_models;
456: CLOSE c_analytics_ds_used;
457: IF l_no_of_models > 0 THEN
458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_DATASOURCE_USED');
459: RAISE FND_API.G_EXC_ERROR;
460: END IF;
461: END IF;
462: -------------------- finish --------------------------

Line 528: AMS_Utility_PVT.debug_message(l_full_name || ': End');

524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527:
528: AMS_Utility_PVT.debug_message(l_full_name || ': End');
529:
530: EXCEPTION
531: WHEN FND_API.g_exc_error THEN
532: ROLLBACK TO Delete_ListSourceType;

Line 614: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

610: AND object_version_number = p_object_version
611: FOR UPDATE NOWAIT;
612: BEGIN
613: --------------------- initialize -----------------------
614: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
615:
616: IF FND_API.to_boolean (p_init_msg_list) THEN
617: FND_MSG_PUB.initialize;
618: END IF;

Line 651: AMS_Utility_PVT.debug_message (l_full_name || ': End');

647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );
650:
651: AMS_Utility_PVT.debug_message (l_full_name || ': End');
652:
653: EXCEPTION
654: WHEN AMS_Utility_PVT.resource_locked THEN
655: x_return_status := FND_API.g_ret_sts_error;

Line 654: WHEN AMS_Utility_PVT.resource_locked THEN

650:
651: AMS_Utility_PVT.debug_message (l_full_name || ': End');
652:
653: EXCEPTION
654: WHEN AMS_Utility_PVT.resource_locked THEN
655: x_return_status := FND_API.g_ret_sts_error;
656: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
657: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
658: FND_MSG_PUB.add;

Line 733: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

729: BEGIN
730: --------------------- initialize -----------------------
731: SAVEPOINT Update_ListSourceType;
732:
733: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
734:
735: IF FND_API.to_boolean (p_init_msg_list) THEN
736: FND_MSG_PUB.initialize;
737: END IF;

Line 765: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

761: END IF;
762: */
763:
764: ----------------------- validate ----------------------
765: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
766:
767: -- replace g_miss_char/num/date with current column values
768: Complete_ListSourceType_Rec (p_listsrctype_rec, l_listsrctype_rec);
769:

Line 862: AMS_Utility_PVT.debug_message (l_full_name || ': End');

858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861:
862: AMS_Utility_PVT.debug_message (l_full_name || ': End');
863:
864: EXCEPTION
865: WHEN FND_API.g_exc_error THEN
866: ROLLBACK TO Update_ListSourceType;

Line 934: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

930:
931: l_return_status VARCHAR2(1);
932: BEGIN
933: --------------------- initialize -----------------------
934: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
935:
936: IF FND_API.to_boolean (p_init_msg_list) THEN
937: FND_MSG_PUB.initialize;
938: END IF;

Line 952: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');

948:
949: x_return_status := FND_API.g_ret_sts_success;
950:
951: ---------------------- validate ------------------------
952: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
953:
954: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
955: Check_ListSourceType_Items (
956: p_listsrctype_rec => p_listsrctype_rec,

Line 968: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

964: RAISE FND_API.g_exc_error;
965: END IF;
966: END IF;
967:
968: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
969:
970: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
971: Check_ListSourceType_Record (
972: p_listsrctype_rec => p_listsrctype_rec,

Line 991: AMS_Utility_PVT.debug_message (l_full_name || ': End');

987: p_count => x_msg_count,
988: p_data => x_msg_data
989: );
990:
991: AMS_Utility_PVT.debug_message (l_full_name || ': End');
992:
993: EXCEPTION
994: WHEN FND_API.g_exc_error THEN
995: x_return_status := FND_API.g_ret_sts_error;

Line 1143: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_lstsrctype_business');

1139: IF x_return_status <> FND_API.g_ret_sts_success THEN
1140: RETURN;
1141: END IF;
1142:
1143: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_lstsrctype_business');
1144: check_lstsrctype_business(
1145: p_listsrctype_rec => p_listsrctype_rec,
1146: x_return_status => x_return_status);
1147: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 1150: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_lstsrctype_business');

1146: x_return_status => x_return_status);
1147: IF x_return_status <> FND_API.g_ret_sts_success THEN
1148: RETURN;
1149: END IF;
1150: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_lstsrctype_business');
1151:
1152: END Check_ListSourceType_Items;
1153:
1154:

Line 1221: AMS_Utility_PVT.error_message ('AMS_DM_NO_TARGETS');

1217: FETCH c_target_exists INTO l_target_indicator;
1218: CLOSE c_target_exists;
1219:
1220: IF l_target_indicator IS NULL OR l_target_indicator <> 1 THEN
1221: AMS_Utility_PVT.error_message ('AMS_DM_NO_TARGETS');
1222: x_return_status := FND_API.g_ret_sts_error;
1223: END IF;
1224: END IF;
1225: END IF; -- if analytics data source

Line 1475: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1471: l_valid_flag := NULL;
1472: END IF;
1473:
1474: -- list_source_type and source_type_code
1475: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1476: p_table_name => l_list_src_types_table,
1477: p_where_clause => l_where_clause
1478: );
1479: IF l_valid_flag = FND_API.g_false THEN

Line 1502: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

1498: l_valid_flag := NULL;
1499: END IF;
1500:
1501: -- list_source_type and source_type_code
1502: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1503: p_table_name => l_list_src_types_table,
1504: p_where_clause => l_where_clause || ' AND list_source_type_id <> ' || p_listsrctype_rec.list_source_type_id
1505: );
1506: IF l_valid_flag = FND_API.g_false THEN

Line 1566: IF AMS_Utility_PVT.check_fk_exists(

1562: BEGIN
1563: x_return_status := FND_API.g_ret_sts_success;
1564: --------------------- view application_id ------------------------
1565: IF p_listsrctype_rec.view_application_id <> FND_API.g_miss_num THEN
1566: IF AMS_Utility_PVT.check_fk_exists(
1567: 'fnd_application',
1568: 'application_id',
1569: p_listsrctype_rec.view_application_id
1570: ) = FND_API.g_false

Line 1572: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');

1568: 'application_id',
1569: p_listsrctype_rec.view_application_id
1570: ) = FND_API.g_false
1571: THEN
1572: AMS_Utility_PVT.Error_Message('AMS_LIST_BAD_APPLICATION_ID');
1573: x_return_status := FND_API.g_ret_sts_error;
1574: RETURN;
1575: END IF;
1576: END IF;

Line 1603: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN

1599: x_return_status := FND_API.g_ret_sts_success;
1600:
1601: -- master_source_type_flag
1602: IF p_listsrctype_rec.master_source_type_flag <> FND_API.g_miss_char AND p_listsrctype_rec.master_source_type_flag IS NOT NULL THEN
1603: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1604: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1605: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1606: FND_MSG_PUB.add;
1607: END IF;

Line 1616: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.enabled_flag) = FND_API.g_false THEN

1612: END IF;
1613:
1614: -- enabled_flag
1615: IF p_listsrctype_rec.enabled_flag <> FND_API.g_miss_char AND p_listsrctype_rec.enabled_flag IS NOT NULL THEN
1616: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.enabled_flag) = FND_API.g_false THEN
1617: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1618: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_ENABLED_FLAG');
1619: FND_MSG_PUB.add;
1620: END IF;