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

Line 182: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

178:
179: -- Debug Message
180: IF (AMS_DEBUG_HIGH_ON) THEN
181:
182: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
183: END IF;
184:
185: -- Initialize message list if p_init_msg_list is set to TRUE.
186: IF FND_API.to_Boolean( p_init_msg_list )

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

207: IF (AMS_DEBUG_HIGH_ON) THEN
208:
209:
210:
211: AMS_Utility_PVT.debug_message(l_full_name||': start');
212:
213: END IF;
214: OPEN c_Source;
215:

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

232: p_count => x_msg_count,
233: p_data => x_msg_data);
234: IF (AMS_DEBUG_HIGH_ON) THEN
235:
236: AMS_Utility_PVT.debug_message(l_full_name ||': end');
237: END IF;
238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN

Line 240: WHEN AMS_Utility_PVT.resource_locked THEN

236: AMS_Utility_PVT.debug_message(l_full_name ||': end');
237: END IF;
238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
243: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
244: FND_MSG_PUB.add;

Line 339: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

335:
336: -- Debug Message
337: IF (AMS_DEBUG_HIGH_ON) THEN
338:
339: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
340: END IF;
341:
342:
343: -- Initialize API return status to SUCCESS

Line 369: AMS_UTILITY_PVT.debug_message('Private API: Validate_Source');

365: THEN
366: -- Debug message
367: IF (AMS_DEBUG_HIGH_ON) THEN
368:
369: AMS_UTILITY_PVT.debug_message('Private API: Validate_Source');
370: END IF;
371:
372: -- Invoke validation procedures
373: Validate_Source(

Line 392: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

388:
389: -- Debug Message
390: IF (AMS_DEBUG_HIGH_ON) THEN
391:
392: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
393: END IF;
394:
395: -- Invoke table handler(ams_dm_source_PKG.Insert_Row)
396: BEGIN

Line 417: AMS_Utility_PVT.error_message ('AMS_API_NO_INSERT');

413: p_decile => p_source_rec.decile,
414: p_percentile => p_source_rec.percentile);
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: AMS_Utility_PVT.error_message ('AMS_API_NO_INSERT');
418: RAISE FND_API.g_exc_error;
419: END;
420: --
421: -- End of API body

Line 434: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

430:
431: -- Debug Message
432: IF (AMS_DEBUG_HIGH_ON) THEN
433:
434: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
435: END IF;
436:
437: -- Standard call to get message count and if count is 1, get message info.
438: FND_MSG_PUB.Count_And_Get

Line 444: WHEN AMS_Utility_PVT.resource_locked THEN

440: p_data => x_msg_data
441: );
442: EXCEPTION
443:
444: WHEN AMS_Utility_PVT.resource_locked THEN
445: x_return_status := FND_API.g_ret_sts_error;
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
447: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
448: FND_MSG_PUB.add;

Line 538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

534:
535: -- Debug Message
536: IF (AMS_DEBUG_HIGH_ON) THEN
537:
538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
539: END IF;
540:
541:
542: -- Initialize API return status to SUCCESS

Line 548: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

544:
545: -- Debug Message
546: IF (AMS_DEBUG_HIGH_ON) THEN
547:
548: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
549: END IF;
550:
551: OPEN c_reference (l_tar_source_rec.source_id);
552: FETCH c_reference INTO l_reference_rec;

Line 565: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

561: END IF;
562: -- Debug Message
563: IF (AMS_DEBUG_HIGH_ON) THEN
564:
565: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
566: END IF;
567: CLOSE c_reference;
568:
569: -- Check Whether record has been changed by someone else

Line 583: AMS_UTILITY_PVT.debug_message('Private API: Validate_Source');

579: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
580: -- Debug message
581: IF (AMS_DEBUG_HIGH_ON) THEN
582:
583: AMS_UTILITY_PVT.debug_message('Private API: Validate_Source');
584: END IF;
585:
586: -- Invoke validation procedures
587: Validate_Source(

Line 605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

601:
602: -- Debug Message
603: IF (AMS_DEBUG_LOW_ON) THEN
604:
605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
606: END IF;
607:
608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)
609: ams_dm_source_PKG.Update_Row(

Line 639: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

635:
636: -- Debug Message
637: IF (AMS_DEBUG_HIGH_ON) THEN
638:
639: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.
643: FND_MSG_PUB.Count_And_Get

Line 649: WHEN AMS_Utility_PVT.resource_locked THEN

645: p_data => x_msg_data
646: );
647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
652: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
653: FND_MSG_PUB.add;

Line 735: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

731:
732: -- Debug Message
733: IF (AMS_DEBUG_HIGH_ON) THEN
734:
735: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
736: END IF;
737:
738: -- Initialize API return status to SUCCESS
739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 745: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

741: IF (AMS_DEBUG_HIGH_ON) THEN
742:
743:
744:
745: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
746:
747: END IF;
748:
749: OPEN c_obj_version(p_source_id);

Line 752: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');

748:
749: OPEN c_obj_version(p_source_id);
750: FETCH c_obj_version INTO l_object_version_number;
751: IF ( c_obj_version%NOTFOUND) THEN
752: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
753: RAISE FND_API.g_exc_error;
754: END IF;
755: -- Debug Message
756: IF (AMS_DEBUG_HIGH_ON) THEN

Line 758: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

754: END IF;
755: -- Debug Message
756: IF (AMS_DEBUG_HIGH_ON) THEN
757:
758: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
759: END IF;
760: CLOSE c_obj_version;
761:
762: --

Line 769: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

765: -- Debug Message
766: IF P_Object_Version_Number = l_object_version_number THEN
767: IF (AMS_DEBUG_HIGH_ON) THEN
768:
769: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
770: END IF;
771:
772: -- Invoke table handler(AMS_DM_MODEL_SCORES_B_PKG.Delete_Row)
773: BEGIN

Line 778: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');

774: ams_dm_source_pkg.Delete_Row(
775: p_source_id => p_source_id);
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
778: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
779: RAISE FND_API.g_exc_error;
780: END;
781: --
782: -- End of API body

Line 795: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

791:
792: -- Debug Message
793: IF (AMS_DEBUG_HIGH_ON) THEN
794:
795: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
796: END IF;
797:
798: -- Standard call to get message count and if count is 1, get message info.
799: FND_MSG_PUB.Count_And_Get

Line 814: WHEN AMS_Utility_PVT.resource_locked THEN

810: END IF;
811:
812: EXCEPTION
813:
814: WHEN AMS_Utility_PVT.resource_locked THEN
815: x_return_status := FND_API.g_ret_sts_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
818: FND_MSG_PUB.add;

Line 867: AMS_UTILITY_PVT.debug_message('Private API:check_source_uk_items');

863:
864: BEGIN
865: IF (AMS_DEBUG_HIGH_ON) THEN
866:
867: AMS_UTILITY_PVT.debug_message('Private API:check_source_uk_items');
868: END IF;
869: x_return_status := FND_API.g_ret_sts_success;
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 871: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

867: AMS_UTILITY_PVT.debug_message('Private API:check_source_uk_items');
868: END IF;
869: x_return_status := FND_API.g_ret_sts_success;
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
872: 'ams_dm_source',
873: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||''''
874: );
875: ELSE

Line 876: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

872: 'ams_dm_source',
873: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||''''
874: );
875: ELSE
876: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
877: 'ams_dm_source',
878: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||
879: ''' AND SOURCE_ID <> ' || p_source_rec.SOURCE_ID
880: );

Line 902: AMS_UTILITY_PVT.debug_message('Private API:check_source_req_items');

898: IS
899: BEGIN
900: IF (AMS_DEBUG_HIGH_ON) THEN
901:
902: AMS_UTILITY_PVT.debug_message('Private API:check_source_req_items');
903: END IF;
904: x_return_status := FND_API.g_ret_sts_success;
905:
906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 978: AMS_UTILITY_PVT.debug_message('Private API:check_source_fk_items');

974: IS
975: BEGIN
976: IF (AMS_DEBUG_HIGH_ON) THEN
977:
978: AMS_UTILITY_PVT.debug_message('Private API:check_source_fk_items');
979: END IF;
980: x_return_status := FND_API.g_ret_sts_success;
981:
982: --------------------used_for_object_id---------------------------

Line 985: IF AMS_Utility_PVT.check_fk_exists(

981:
982: --------------------used_for_object_id---------------------------
983: IF p_source_rec.arc_used_for_object = 'MODL' THEN
984: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
985: IF AMS_Utility_PVT.check_fk_exists(
986: 'ams_dm_models_all_b',
987: 'model_id',
988: p_source_rec.used_for_object_id
989: ) = FND_API.g_false

Line 1000: IF AMS_Utility_PVT.check_fk_exists(

996: END IF;
997: END IF;
998: ELSIF p_source_rec.arc_used_for_object = 'SCOR' THEN
999: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
1000: IF AMS_Utility_PVT.check_fk_exists(
1001: 'ams_dm_scores_all_b',
1002: 'score_id',
1003: p_source_rec.used_for_object_id
1004: ) = FND_API.g_false

Line 1144: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

1140:
1141: -- Debug Message
1142: IF (AMS_DEBUG_HIGH_ON) THEN
1143:
1144: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1145: END IF;
1146:
1147:
1148: -- Initialize API return status to SUCCESS

Line 1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

1151:
1152: -- Debug Message
1153: IF (AMS_DEBUG_HIGH_ON) THEN
1154:
1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1156: END IF;
1157:
1158: -- Standard call to get message count and if count is 1, get message info.
1159: FND_MSG_PUB.Count_And_Get

Line 1165: WHEN AMS_Utility_PVT.resource_locked THEN

1161: p_data => x_msg_data
1162: );
1163: EXCEPTION
1164:
1165: WHEN AMS_Utility_PVT.resource_locked THEN
1166: x_return_status := FND_API.g_ret_sts_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1168: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1169: FND_MSG_PUB.add;

Line 1232: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1228:
1229: -- Debug Message
1230: IF (AMS_DEBUG_HIGH_ON) THEN
1231:
1232: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1233: END IF;
1234: -- Standard call to get message count and if count is 1, get message info.
1235: FND_MSG_PUB.Count_And_Get
1236: (p_count => x_msg_count,

Line 1359: AMS_Utility_PVT.debug_message (L_API_NAME || ' - l_source_object: ' || l_source_object);

1355:
1356: l_source_object := 'OMO_' || l_db_instance || '_' || p_score_id || '_SRT';
1357:
1358: IF (AMS_DEBUG_HIGH_ON) THEN
1359: AMS_Utility_PVT.debug_message (L_API_NAME || ' - l_source_object: ' || l_source_object);
1360: END IF;
1361:
1362: -- Standard Start of API savepoint
1363: SAVEPOINT process_scores;

Line 1399: AMS_Utility_PVT.debug_message (L_API_NAME || ' - ODM output schema: ' || l_odm_schema);

1395: -- changed rosharma 18-nov-2003
1396: --l_odm_schema := FND_PROFILE.value ('AMS_ODM_OUTPUT_SCHEMA');
1397: l_odm_schema := FND_ORACLE_SCHEMA.GetOuValue('ODMSCHEMA');
1398: IF (AMS_DEBUG_HIGH_ON) THEN
1399: AMS_Utility_PVT.debug_message (L_API_NAME || ' - ODM output schema: ' || l_odm_schema);
1400: END IF;
1401: -- end change rosharma 18-nov-2003
1402: IF l_odm_schema IS NOT NULL THEN
1403: l_source_object := l_odm_schema || '.' || l_source_object;

Line 1412: AMS_Utility_PVT.debug_message (L_API_NAME || ' - SQL: ' || l_sql);

1408: -- l_sql := 'INSERT INTO ams_dm_apply_stg (SELECT idkey, score, probability FROM ' || l_source_object || ')';
1409: l_sql := 'INSERT INTO ams_dm_apply_stg_gt (SELECT idkey, score, probability FROM ' || l_source_object || ')';
1410:
1411: IF (AMS_DEBUG_HIGH_ON) THEN
1412: AMS_Utility_PVT.debug_message (L_API_NAME || ' - SQL: ' || l_sql);
1413: END IF;
1414:
1415: -- execute dynamic sql
1416: EXECUTE IMMEDIATE l_sql;

Line 1481: AMS_Utility_PVT.debug_message (L_API_NAME || ': BEGIN');

1477: BEGIN
1478:
1479:
1480: IF (AMS_DEBUG_HIGH_ON) THEN
1481: AMS_Utility_PVT.debug_message (L_API_NAME || ': BEGIN');
1482: END IF;
1483:
1484: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1485: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

Line 1497: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );

1493: l_training_view := 'AMS_DM_' || p_object_id || '_TRAIN_V';
1494: l_test_view := 'AMS_DM_' || p_object_id || '_TEST_V';
1495:
1496: IF (AMS_DEBUG_HIGH_ON) THEN
1497: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1498: AMS_Utility_PVT.debug_message ('Dropping Training View ' || l_training_view );
1499: AMS_Utility_PVT.debug_message ('Dropping Test View ' || l_test_view );
1500: END IF;
1501:

Line 1498: AMS_Utility_PVT.debug_message ('Dropping Training View ' || l_training_view );

1494: l_test_view := 'AMS_DM_' || p_object_id || '_TEST_V';
1495:
1496: IF (AMS_DEBUG_HIGH_ON) THEN
1497: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1498: AMS_Utility_PVT.debug_message ('Dropping Training View ' || l_training_view );
1499: AMS_Utility_PVT.debug_message ('Dropping Test View ' || l_test_view );
1500: END IF;
1501:
1502: EXECUTE IMMEDIATE 'DROP VIEW ' || l_training_view ;

Line 1499: AMS_Utility_PVT.debug_message ('Dropping Test View ' || l_test_view );

1495:
1496: IF (AMS_DEBUG_HIGH_ON) THEN
1497: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1498: AMS_Utility_PVT.debug_message ('Dropping Training View ' || l_training_view );
1499: AMS_Utility_PVT.debug_message ('Dropping Test View ' || l_test_view );
1500: END IF;
1501:
1502: EXECUTE IMMEDIATE 'DROP VIEW ' || l_training_view ;
1503: EXECUTE IMMEDIATE 'DROP VIEW ' || l_test_view;

Line 1511: AMS_Utility_PVT.debug_message ('deleting synonyms for views in ' || l_odm_schema || ' schema.' );

1507: EXECUTE IMMEDIATE 'DROP synonym ' || l_odm_schema || '.' || l_training_view;
1508: EXECUTE IMMEDIATE 'DROP synonym ' || l_odm_schema || '.' || l_test_view;
1509:
1510: IF (AMS_DEBUG_HIGH_ON) THEN
1511: AMS_Utility_PVT.debug_message ('deleting synonyms for views in ' || l_odm_schema || ' schema.' );
1512: END IF;
1513: END IF;
1514:
1515: ELSE

Line 1519: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );

1515: ELSE
1516: l_apply_view := 'AMS_DM_' || p_object_id || '_APPLY_V';
1517:
1518: IF (AMS_DEBUG_HIGH_ON) THEN
1519: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1520: AMS_Utility_PVT.debug_message ('Dropping APPLY View ' || l_apply_view);
1521: END IF;
1522:
1523: -- drop the apply view

Line 1520: AMS_Utility_PVT.debug_message ('Dropping APPLY View ' || l_apply_view);

1516: l_apply_view := 'AMS_DM_' || p_object_id || '_APPLY_V';
1517:
1518: IF (AMS_DEBUG_HIGH_ON) THEN
1519: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1520: AMS_Utility_PVT.debug_message ('Dropping APPLY View ' || l_apply_view);
1521: END IF;
1522:
1523: -- drop the apply view
1524: EXECUTE IMMEDIATE 'DROP VIEW ' || l_apply_view;

Line 1531: AMS_Utility_PVT.debug_message ('drop synonyms for apply views in ' || l_odm_schema || ' schema.' );

1527: IF FND_PROFILE.Value('AMS_DM_USE_DBLINK') = 'N' OR FND_PROFILE.Value('AMS_DM_USE_DBLINK') IS NULL THEN
1528: -- Also drop synonyms for the view in the ODM schema
1529: EXECUTE IMMEDIATE 'DROP synonym ' || l_odm_schema || '.' || l_apply_view ;
1530: IF (AMS_DEBUG_HIGH_ON) THEN
1531: AMS_Utility_PVT.debug_message ('drop synonyms for apply views in ' || l_odm_schema || ' schema.' );
1532: END IF;
1533: END IF;
1534:
1535: END IF;

Line 1538: AMS_Utility_PVT.debug_message (L_API_NAME || ': END');

1534:
1535: END IF;
1536:
1537: IF (AMS_DEBUG_HIGH_ON) THEN
1538: AMS_Utility_PVT.debug_message (L_API_NAME || ': END');
1539: END IF;
1540:
1541: END cleanup_odm_input_views;
1542:

Line 1663: AMS_UTILITY_PVT.debug_message('Note: None of the attributes from the data source "Organization Contacts" will be used for mining as they are not relevant for this model.');

1659: END IF;
1660: END IF;
1661:
1662: IF l_is_b2b_cust THEN
1663: AMS_UTILITY_PVT.debug_message('Note: None of the attributes from the data source "Organization Contacts" will be used for mining as they are not relevant for this model.');
1664: END IF;
1665:
1666: get_select_fields (
1667: p_data_source_id => p_data_source_id,

Line 1695: AMS_Utility_PVT.create_log (

1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695: AMS_Utility_PVT.create_log (
1696: x_return_status => l_log_return_status,
1697: p_arc_log_used_by => p_object_type,
1698: p_log_used_by_id => p_object_id,
1699: p_msg_data => SUBSTR ('SQL: ' || l_select_list || l_from_clause || l_where_clause, 1, 4000),

Line 1714: AMS_Utility_PVT.create_log (

1710: l_check_sql := l_check_sql || 'SELECT ' || l_ds_pk_field || ', COUNT(*) ' || l_from_clause || l_where_clause_sel;
1711: l_check_sql := l_check_sql || ' GROUP BY ' || l_ds_pk_field || ' HAVING COUNT(*) > 1)';
1712:
1713:
1714: AMS_Utility_PVT.create_log (
1715: x_return_status => l_log_return_status,
1716: p_arc_log_used_by => p_object_type,
1717: p_log_used_by_id => p_object_id,
1718: p_msg_data => SUBSTR ('SQL: ' || l_check_sql, 1, 4000)

Line 1728: AMS_Utility_PVT.create_log (

1724: WHEN NO_DATA_FOUND THEN
1725: l_dummy := 0;
1726: END;
1727:
1728: AMS_Utility_PVT.create_log (
1729: x_return_status => l_log_return_status,
1730: p_arc_log_used_by => p_object_type,
1731: p_log_used_by_id => p_object_id,
1732: p_msg_data => 'l_dummy :: ' || l_dummy

Line 1736: AMS_UTILITY_PVT.debug_message(L_API_NAME || ' :: ' || 'Data Source mapping not 1-to-1, raising error...');

1732: p_msg_data => 'l_dummy :: ' || l_dummy
1733: );
1734:
1735: IF l_dummy = 1 THEN
1736: AMS_UTILITY_PVT.debug_message(L_API_NAME || ' :: ' || 'Data Source mapping not 1-to-1, raising error...');
1737: AMS_Utility_PVT.Error_Message('AMS_DM_DS_MAPPING_ERROR');
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:

Line 1737: AMS_Utility_PVT.Error_Message('AMS_DM_DS_MAPPING_ERROR');

1733: );
1734:
1735: IF l_dummy = 1 THEN
1736: AMS_UTILITY_PVT.debug_message(L_API_NAME || ' :: ' || 'Data Source mapping not 1-to-1, raising error...');
1737: AMS_Utility_PVT.Error_Message('AMS_DM_DS_MAPPING_ERROR');
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:
1741: IF p_object_type = 'MODL' THEN

Line 1759: AMS_Utility_PVT.create_log (

1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: AMS_Utility_PVT.create_log (
1760: x_return_status => l_log_return_status,
1761: p_arc_log_used_by => p_object_type,
1762: p_log_used_by_id => p_object_id,
1763: p_msg_data => ' Exception in generate_odm_input_views status ' || x_return_status

Line 1821: AMS_Utility_PVT.debug_message ('Training dataset target count..' || l_target_count);

1817: OPEN c_check_targets('Y');
1818: FETCH c_check_targets INTO l_target_count;
1819:
1820: IF (AMS_DEBUG_HIGH_ON) THEN
1821: AMS_Utility_PVT.debug_message ('Training dataset target count..' || l_target_count);
1822: END IF;
1823:
1824: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1825: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');

Line 1825: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');

1821: AMS_Utility_PVT.debug_message ('Training dataset target count..' || l_target_count);
1822: END IF;
1823:
1824: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1825: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF;
1828:
1829: CLOSE c_check_targets;

Line 1835: AMS_Utility_PVT.debug_message ('Test dataset target count..' || l_target_count);

1831: OPEN c_check_targets('N');
1832: FETCH c_check_targets INTO l_target_count;
1833:
1834: IF (AMS_DEBUG_HIGH_ON) THEN
1835: AMS_Utility_PVT.debug_message ('Test dataset target count..' || l_target_count);
1836: END IF;
1837:
1838: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1839: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');

Line 1839: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');

1835: AMS_Utility_PVT.debug_message ('Test dataset target count..' || l_target_count);
1836: END IF;
1837:
1838: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1839: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:
1843: CLOSE c_check_targets;

Line 1887: AMS_Utility_PVT.debug_message ('create_build_views BEGIN' );

1883: l_odm_schema VARCHAR2(30);
1884:
1885: BEGIN
1886: IF (AMS_DEBUG_HIGH_ON) THEN
1887: AMS_Utility_PVT.debug_message ('create_build_views BEGIN' );
1888: END IF;
1889:
1890: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1891: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

Line 1904: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );

1900: l_training_view := 'AMS_DM_' || p_object_id || '_TRAIN_V';
1901: l_test_view := 'AMS_DM_' || p_object_id || '_TEST_V';
1902:
1903: IF (AMS_DEBUG_HIGH_ON) THEN
1904: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1905: AMS_Utility_PVT.debug_message ('Creating Training View ' || l_training_view );
1906: AMS_Utility_PVT.debug_message ('Creating Test View ' || l_test_view );
1907:
1908: END IF;

Line 1905: AMS_Utility_PVT.debug_message ('Creating Training View ' || l_training_view );

1901: l_test_view := 'AMS_DM_' || p_object_id || '_TEST_V';
1902:
1903: IF (AMS_DEBUG_HIGH_ON) THEN
1904: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1905: AMS_Utility_PVT.debug_message ('Creating Training View ' || l_training_view );
1906: AMS_Utility_PVT.debug_message ('Creating Test View ' || l_test_view );
1907:
1908: END IF;
1909:

Line 1906: AMS_Utility_PVT.debug_message ('Creating Test View ' || l_test_view );

1902:
1903: IF (AMS_DEBUG_HIGH_ON) THEN
1904: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1905: AMS_Utility_PVT.debug_message ('Creating Training View ' || l_training_view );
1906: AMS_Utility_PVT.debug_message ('Creating Test View ' || l_test_view );
1907:
1908: END IF;
1909:
1910: EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ' || l_training_view || ' AS ' || l_sql_str || ' AND s.training_data_flag = ''Y''';

Line 1926: AMS_Utility_PVT.debug_message ('Created synonyms for views in ' || l_odm_schema || ' schema.' );

1922: EXECUTE IMMEDIATE 'CREATE OR REPLACE synonym ' || l_odm_schema || '.' || l_training_view || ' for ' || l_training_view;
1923: EXECUTE IMMEDIATE 'CREATE OR REPLACE synonym ' || l_odm_schema || '.' || l_test_view || ' for ' || l_test_view;
1924:
1925: IF (AMS_DEBUG_HIGH_ON) THEN
1926: AMS_Utility_PVT.debug_message ('Created synonyms for views in ' || l_odm_schema || ' schema.' );
1927: END IF;
1928: END IF;
1929:
1930: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1931: AMS_Utility_PVT.debug_message ('create_build_views END' );

1927: END IF;
1928: END IF;
1929:
1930: IF (AMS_DEBUG_HIGH_ON) THEN
1931: AMS_Utility_PVT.debug_message ('create_build_views END' );
1932: END IF;
1933:
1934: END create_build_views;
1935:

Line 1960: AMS_Utility_PVT.debug_message ('create_apply_views BEGIN' );

1956: l_odm_schema VARCHAR2(30);
1957: BEGIN
1958:
1959: IF (AMS_DEBUG_HIGH_ON) THEN
1960: AMS_Utility_PVT.debug_message ('create_apply_views BEGIN' );
1961: END IF;
1962:
1963: -- Get the ODM schema name that willbe used later for GRANTS and SYNONYMS
1964: l_odm_schema := fnd_oracle_schema.GetOuValue(G_ODM_SCHEMA_LOOKUP);

Line 1977: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );

1973:
1974: l_apply_view := 'AMS_DM_' || p_object_id || '_APPLY_V';
1975:
1976: IF (AMS_DEBUG_HIGH_ON) THEN
1977: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1978: AMS_Utility_PVT.debug_message ('Creating APPLY View ' || l_apply_view);
1979: END IF;
1980:
1981: EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ' || l_apply_view || ' AS ' || l_sql_str;

Line 1978: AMS_Utility_PVT.debug_message ('Creating APPLY View ' || l_apply_view);

1974: l_apply_view := 'AMS_DM_' || p_object_id || '_APPLY_V';
1975:
1976: IF (AMS_DEBUG_HIGH_ON) THEN
1977: AMS_Utility_PVT.debug_message ('ODM Schema' || l_odm_schema );
1978: AMS_Utility_PVT.debug_message ('Creating APPLY View ' || l_apply_view);
1979: END IF;
1980:
1981: EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ' || l_apply_view || ' AS ' || l_sql_str;
1982:

Line 1990: AMS_Utility_PVT.debug_message ('Created synonyms for views in ' || l_odm_schema || ' schema.' );

1986:
1987: -- Also create synonyms for the view in the ODM schema
1988: EXECUTE IMMEDIATE 'CREATE OR REPLACE synonym ' || l_odm_schema || '.' || l_apply_view || ' for ' || l_apply_view;
1989: IF (AMS_DEBUG_HIGH_ON) THEN
1990: AMS_Utility_PVT.debug_message ('Created synonyms for views in ' || l_odm_schema || ' schema.' );
1991: END IF;
1992: END IF;
1993:
1994: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1995: AMS_Utility_PVT.debug_message ('create_apply_views END' );

1991: END IF;
1992: END IF;
1993:
1994: IF (AMS_DEBUG_HIGH_ON) THEN
1995: AMS_Utility_PVT.debug_message ('create_apply_views END' );
1996: END IF;
1997:
1998: END create_apply_views;
1999:

Line 2139: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);

2135: END LOOP;
2136: l_count:=c_dup_fields_custprof%ROWCOUNT;
2137: IF l_count <> 0 THEN
2138: IF l_count <= 15 THEN
2139: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: ELSE
2142: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2142: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);

2138: IF l_count <= 15 THEN
2139: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: ELSE
2142: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144: END IF;
2145: CLOSE c_dup_fields_custprof;
2146: return;

Line 2174: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');

2170: --end change rosharma 15-may-2003 bug # 2961532
2171: END LOOP;
2172:
2173: IF c_fields_custprof%ROWCOUNT = 0 THEN
2174: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: END IF;
2177: CLOSE c_fields_custprof;
2178:

Line 2194: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);

2190: END LOOP;
2191: l_count:=c_dup_fields%ROWCOUNT;
2192: IF l_count <> 0 THEN
2193: IF l_count <= 15 THEN
2194: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: ELSE
2197: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2198: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2197: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);

2193: IF l_count <= 15 THEN
2194: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: ELSE
2197: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2198: x_return_status := FND_API.G_RET_STS_ERROR;
2199: END IF;
2200: CLOSE c_dup_fields;
2201: return;

Line 2230: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');

2226: --end change rosharma 15-may-2003 bug # 2961532
2227: END LOOP;
2228:
2229: IF c_fields%ROWCOUNT = 0 THEN
2230: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: END IF;
2233: CLOSE c_fields;
2234:

Line 2389: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: relation condition : ' || l_composite_relation_cond);

2385: END LOOP;
2386: CLOSE c_child_sources;
2387:
2388: IF (AMS_DEBUG_HIGH_ON) THEN
2389: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: relation condition : ' || l_composite_relation_cond);
2390: END IF;
2391: IF LENGTH(l_composite_relation_cond) > 0 THEN
2392: IF l_model_type = 'CUSTOMER_PROFITABILITY' AND l_is_seeded THEN
2393: l_composite_relation_cond := REPLACE(l_composite_relation_cond , 'AMS_DM_PARTY_PROFIT_V.PARTY_ID' , 'AMS_DM_PARTY_PROFIT_V.PARTY_ID(+)');

Line 2407: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: from condition for data source : ' || x_from_clause);

2403: x_where_clause := x_where_clause || ' AND s.arc_used_for_object = ''' || p_object_type || '''';
2404: x_where_clause := x_where_clause || ' AND s.used_for_object_id = ' || p_object_id;
2405:
2406: IF (AMS_DEBUG_HIGH_ON) THEN
2407: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: from condition for data source : ' || x_from_clause);
2408: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: where condition for data source : ' || x_where_clause);
2409: END IF;
2410: END get_from_where_clause;
2411:

Line 2408: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: where condition for data source : ' || x_where_clause);

2404: x_where_clause := x_where_clause || ' AND s.used_for_object_id = ' || p_object_id;
2405:
2406: IF (AMS_DEBUG_HIGH_ON) THEN
2407: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: from condition for data source : ' || x_from_clause);
2408: AMS_Utility_PVT.debug_message ('get_from_where_clause' || ' :: where condition for data source : ' || x_where_clause);
2409: END IF;
2410: END get_from_where_clause;
2411:
2412: