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 130: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 656: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1477: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

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

Line 1504: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

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

Line 1568: IF AMS_Utility_PVT.check_fk_exists(

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

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

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

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

1601: x_return_status := FND_API.g_ret_sts_success;
1602:
1603: -- master_source_type_flag
1604: 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
1605: IF AMS_Utility_PVT.is_Y_or_N (p_listsrctype_rec.master_source_type_flag) = FND_API.g_false THEN
1606: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_MASTERSRC_FLAG');
1608: FND_MSG_PUB.add;
1609: END IF;

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

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