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

Line 531: AMS_Utility_PVT.create_log (

527: BEGIN
528: -- Initialize API return status to SUCCESS
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
531: AMS_Utility_PVT.create_log (
532: x_return_status => l_return_status_log,
533: p_arc_log_used_by => p_arc_object,
534: p_log_used_by_id => p_object_id,
535: p_msg_data => L_API_NAME || ': Begin'

Line 541: AMS_Utility_PVT.debug_message ('OBJECT TYPE: ' || p_arc_object || ' OBJECT ID: ' || p_object_id);

537:
538: FND_MSG_PUB.initialize;
539:
540: IF (AMS_DEBUG_HIGH_ON) THEN
541: AMS_Utility_PVT.debug_message ('OBJECT TYPE: ' || p_arc_object || ' OBJECT ID: ' || p_object_id);
542: END IF;
543:
544: -- determine if the data source used is
545: -- a seeded data source

Line 560: AMS_Utility_PVT.create_log (

556: IF l_target_id < L_SEEDED_ID_THRESHOLD THEN
557: l_seeded_data_source := TRUE;
558: END IF;
559:
560: AMS_Utility_PVT.create_log (
561: x_return_status => l_return_status_log,
562: p_arc_log_used_by => p_arc_object,
563: p_log_used_by_id => p_object_id,
564: p_msg_data => L_API_NAME || ': Before call to purge_target_staging '

Line 580: AMS_Utility_PVT.create_log (

576: p_count => 'INITIAL',
577: x_return_status => l_return_status
578: );
579:
580: AMS_Utility_PVT.create_log (
581: x_return_status => l_return_status_log,
582: p_arc_log_used_by => p_arc_object,
583: p_log_used_by_id => p_object_id,
584: p_msg_data => L_API_NAME || ': After purge_target_staging Status= ' || l_return_status

Line 600: AMS_Utility_PVT.create_log (

596: p_seeded_data_source => l_seeded_data_source,
597: x_return_status => l_return_status
598: );
599:
600: AMS_Utility_PVT.create_log (
601: x_return_status => l_return_status_log,
602: p_arc_log_used_by => p_arc_object,
603: p_log_used_by_id => p_object_id,
604: p_msg_data => L_API_NAME || ': After populate_target_staging Status= ' || l_return_status

Line 616: AMS_Utility_PVT.create_log (

612: -- process is model building -- target value is
613: -- not needed when scoring.
614: IF p_arc_object = G_OBJECT_TYPE_MODEL THEN
615:
616: AMS_Utility_PVT.create_log (
617: x_return_status => l_return_status_log,
618: p_arc_log_used_by => p_arc_object,
619: p_log_used_by_id => p_object_id,
620: p_msg_data => L_API_NAME || ': MODL Going to call populate_targets '

Line 649: AMS_Utility_PVT.create_log (

645: p_seeded_data_source => l_seeded_data_source,
646: x_return_status => l_return_status
647: );
648:
649: AMS_Utility_PVT.create_log (
650: x_return_status => l_return_status_log,
651: p_arc_log_used_by => p_arc_object,
652: p_log_used_by_id => p_object_id,
653: p_msg_data => L_API_NAME || ': After populate_targets Status= ' || l_return_status

Line 672: AMS_Utility_PVT.create_log (

668: x_return_status => l_return_status
669: );
670:
671:
672: AMS_Utility_PVT.create_log (
673: x_return_status => l_return_status_log,
674: p_arc_log_used_by => p_arc_object,
675: p_log_used_by_id => p_object_id,
676: p_msg_data => L_API_NAME || ': After update_action_summary Status= ' || l_return_status

Line 692: AMS_Utility_PVT.create_log (

688: p_object_for_id => p_object_id,
689: p_seeded_data_source => l_seeded_data_source,
690: x_return_status => l_return_status
691: );
692: AMS_Utility_PVT.create_log (
693: x_return_status => l_return_status_log,
694: p_arc_log_used_by => p_arc_object,
695: p_log_used_by_id => p_object_id,
696: p_msg_data => L_API_NAME || ': After populate_source Status= ' || l_return_status

Line 1008: AMS_Utility_PVT.debug_message (substr(L_API_NAME || ' - SQL [' || l_object_rec.arc_incl_object_from || ', ' || l_object_rec.incl_object_id || ']: ' || l_sql_statement,1,4000));

1004: l_sql_statement := l_sql_statement || ' WHERE ' || l_where_clause;
1005: END IF;
1006:
1007: IF (AMS_DEBUG_HIGH_ON) THEN
1008: AMS_Utility_PVT.debug_message (substr(L_API_NAME || ' - SQL [' || l_object_rec.arc_incl_object_from || ', ' || l_object_rec.incl_object_id || ']: ' || l_sql_statement,1,4000));
1009: END IF;
1010:
1011: IF l_object_rec.arc_incl_object_from <> 'DIWB' THEN
1012: EXECUTE IMMEDIATE l_sql_statement

Line 1109: AMS_Utility_PVT.debug_message (L_API_NAME || ' - SQL: ' || l_sql_statement);

1105: l_sql_statement := l_sql_statement || ' WHERE ' || l_where_clause;
1106: END IF;
1107:
1108: IF (AMS_DEBUG_HIGH_ON) THEN
1109: AMS_Utility_PVT.debug_message (L_API_NAME || ' - SQL: ' || l_sql_statement);
1110: END IF;
1111:
1112: EXECUTE IMMEDIATE l_sql_statement
1113: USING p_arc_object_for, p_object_for_id, G_ALTERNATIVE_DATA_SOURCE, l_data_source_id;

Line 1192: AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || l_from_and_where);

1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189: END IF;
1190:
1191: IF (AMS_DEBUG_HIGH_ON) THEN
1192: AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || l_from_and_where);
1193: END IF;
1194:
1195: -- construct the entire sql statement
1196: -- which selects the source_pk_field

Line 1272: AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || p_arc_object_for || ': '||p_object_for_id || ': '|| p_count);

1268: l_ams_schema
1269: );
1270:
1271: IF (AMS_DEBUG_HIGH_ON) THEN
1272: AMS_Utility_PVT.debug_message (L_API_NAME || ': ' || p_arc_object_for || ': '||p_object_for_id || ': '|| p_count);
1273: END IF;
1274:
1275: if p_arc_object_for = G_OBJECT_TYPE_SCORE then
1276: open c_model_id(p_object_for_id);

Line 1382: AMS_Utility_PVT.error_message ('AMS_DM_DIWB_NO_SOURCE_TYPE', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);

1378: END LOOP;
1379: CLOSE c_master_types;
1380:
1381: IF l_found = FND_API.G_FALSE THEN
1382: AMS_Utility_PVT.error_message ('AMS_DM_DIWB_NO_SOURCE_TYPE', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: x_customer_field := l_customer_pk_field;

Line 1651: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_ACTION');

1647: AND t.object_id = l_sources_rec.incl_object_id
1648: AND t.party_id = i.party_id)
1649: ;
1650: ELSE
1651: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_ACTION');
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654: END LOOP;
1655: CLOSE c_sources;

Line 1727: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PRIMARY_KEY');

1723: ;
1724: --added rosharma 20-aug-2003 bug # 3102421
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PRIMARY_KEY');
1728: RAISE FND_API.G_EXC_ERROR;
1729: END;
1730: --end add rosharma 20-aug-2003 bug # 3102421
1731:

Line 1747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_SELECTIONS_EMPTY');

1743:
1744: -- If model is building, then check that the data can be used for building
1745: IF l_status_code = G_STATUS_BUILDING THEN
1746: IF l_total_records <= 0 THEN
1747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_SELECTIONS_EMPTY');
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:

Line 1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NO_POSITIVE_TGTS');

1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:
1752: IF l_total_positives <= 0 THEN
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NO_POSITIVE_TGTS');
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:

Line 1759: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_ALL_POSITIVE_TGTS');

1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: IF l_total_positives = l_total_records THEN
1759: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_ALL_POSITIVE_TGTS');
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;
1763: END IF;

Line 1775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORE_SELECTIONS_EMPTY');

1771:
1772: -- If Scoring Run is scoring, then check that the data can be used for scoring
1773: IF l_status_code = G_STATUS_SCORING THEN
1774: IF l_row_count <= 0 THEN
1775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORE_SELECTIONS_EMPTY');
1776: x_return_status := FND_API.G_RET_STS_ERROR;
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779: END IF;

Line 1792: AMS_Utility_PVT.debug_message ('In populate_source synchronize org_cotacts with org');

1788: WHERE org_party_id NOT IN (SELECT distinct party_id from ams_dm_int_src_stg_gt WHERE arc_object_used_by = p_arc_object_for AND
1789: object_used_by_id = p_object_for_id);
1790:
1791: IF (AMS_DEBUG_HIGH_ON) THEN
1792: AMS_Utility_PVT.debug_message ('In populate_source synchronize org_cotacts with org');
1793: END IF;
1794:
1795: END IF;
1796:

Line 1848: AMS_Utility_PVT.error_message ('AMS_SQL_NO_FROM', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);

1844: x_position => l_position,
1845: x_overflow => l_overflow
1846: );
1847: IF l_found <> FND_API.G_TRUE THEN
1848: AMS_Utility_PVT.error_message ('AMS_SQL_NO_FROM', 'WORKBOOKSHEET', p_workbook_name || '.' || p_worksheet_name);
1849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1850: END IF;
1851:
1852: -- fetch the sql string from ams_discoverer_sql

Line 1965: AMS_Utility_PVT.debug_message (L_API_NAME || ': L_DATE = ' || l_date);

1961:
1962: l_model_id := p_model_id;
1963:
1964: IF (AMS_DEBUG_HIGH_ON) THEN
1965: AMS_Utility_PVT.debug_message (L_API_NAME || ': L_DATE = ' || l_date);
1966: AMS_Utility_PVT.debug_message ('MODEL ID: ' || p_model_id);
1967: END IF;
1968:
1969: OPEN c_model_details (p_model_id);

Line 1966: AMS_Utility_PVT.debug_message ('MODEL ID: ' || p_model_id);

1962: l_model_id := p_model_id;
1963:
1964: IF (AMS_DEBUG_HIGH_ON) THEN
1965: AMS_Utility_PVT.debug_message (L_API_NAME || ': L_DATE = ' || l_date);
1966: AMS_Utility_PVT.debug_message ('MODEL ID: ' || p_model_id);
1967: END IF;
1968:
1969: OPEN c_model_details (p_model_id);
1970: FETCH c_model_details INTO l_model_rec;

Line 2061: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');

2057: CLOSE c_target;
2058:
2059: IF l_target_enabled <> 'Y' THEN
2060: IF (AMS_DEBUG_HIGH_ON) THEN
2061: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2062: END IF;
2063: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;

Line 2063: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');

2059: IF l_target_enabled <> 'Y' THEN
2060: IF (AMS_DEBUG_HIGH_ON) THEN
2061: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2062: END IF;
2063: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:
2067: get_target_positive_values ( p_target_id => l_model_rec.target_id,

Line 2113: AMS_Utility_PVT.debug_message ('Customer Profitability-target sql: ' || l_sql);

2109: l_sql := l_sql || ' WHERE t.arc_object_used_by = :object_type';
2110: l_sql := l_sql || ' AND t.object_used_by_id = :model_id';
2111:
2112: IF (AMS_DEBUG_HIGH_ON) THEN
2113: AMS_Utility_PVT.debug_message ('Customer Profitability-target sql: ' || l_sql);
2114: END IF;
2115:
2116: EXECUTE IMMEDIATE l_sql
2117: USING l_model_rec.target_id, G_OBJECT_TYPE_MODEL, p_model_id;

Line 2128: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');

2124: CLOSE c_target;
2125:
2126: IF l_target_enabled <> 'Y' THEN
2127: IF (AMS_DEBUG_HIGH_ON) THEN
2128: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2129: END IF;
2130: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2131: RAISE FND_API.G_EXC_ERROR;
2132: END IF;

Line 2130: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');

2126: IF l_target_enabled <> 'Y' THEN
2127: IF (AMS_DEBUG_HIGH_ON) THEN
2128: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2129: END IF;
2130: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2131: RAISE FND_API.G_EXC_ERROR;
2132: END IF;
2133:
2134: is_b2b_data_source(

Line 2222: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_model_rec.model_type);

2218: AND object_used_by_id = p_model_id;
2219: END IF;
2220:
2221: ELSE
2222: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_model_rec.model_type);
2223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2224: END IF;
2225:
2226: ELSE

Line 2233: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');

2229: CLOSE c_target;
2230:
2231: IF l_target_enabled <> 'Y' THEN
2232: IF (AMS_DEBUG_HIGH_ON) THEN
2233: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2234: END IF;
2235: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;

Line 2235: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');

2231: IF l_target_enabled <> 'Y' THEN
2232: IF (AMS_DEBUG_HIGH_ON) THEN
2233: AMS_Utility_PVT.debug_message ('Target Field has been disabled. Raising Error.');
2234: END IF;
2235: AMS_Utility_PVT.error_message ('AMS_DM_TARGET_FIELD_DISABLED');
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239: -- get the sql statement that ANDs all the positive values defined for the target

Line 2278: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_DATA_CONVERT');

2274: l_sql := l_sql || ' AND t.object_used_by_id = :model_id';
2275:
2276: EXCEPTION
2277: WHEN VALUE_ERROR THEN
2278: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_DATA_CONVERT');
2279: RAISE FND_API.G_EXC_ERROR;
2280: END;
2281:
2282: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2283: AMS_Utility_PVT.debug_message ('target sql: ' || l_sql);

2279: RAISE FND_API.G_EXC_ERROR;
2280: END;
2281:
2282: IF (AMS_DEBUG_HIGH_ON) THEN
2283: AMS_Utility_PVT.debug_message ('target sql: ' || l_sql);
2284: END IF;
2285:
2286: EXECUTE IMMEDIATE l_sql
2287: USING G_OBJECT_TYPE_MODEL, p_model_id;

Line 2507: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_object_rec.model_type);

2503: ))
2504: WHERE arc_used_for_object = p_object_type
2505: AND used_for_object_id = p_object_id;
2506: ELSE
2507: AMS_Utility_PVT.error_message ('AMS_DM_UNSUPPORTED_MODEL', 'MODEL_TYPE', l_object_rec.model_type);
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510:
2511: UPDATE /*+ index(AMS_DM_SOURCE AMS_DM_SOURCE_U2) */ ams_dm_source

Line 2550: AMS_Utility_PVT.create_log (

2546: );
2547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: l_msg_count := FND_MSG_PUB.count_msg;
2549: FOR i IN 1 .. l_msg_count LOOP
2550: AMS_Utility_PVT.create_log (
2551: x_return_status => l_return_status,
2552: p_arc_log_used_by => p_arc_object,
2553: p_log_used_by_id => p_object_id,
2554: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),

Line 2562: AMS_Utility_PVT.create_log (

2558: retcode := 2;
2559: END IF;
2560:
2561: -- write a complete message to log
2562: AMS_Utility_PVT.create_log (
2563: x_return_status => l_return_status,
2564: p_arc_log_used_by => p_arc_object,
2565: p_log_used_by_id => p_object_id,
2566: p_msg_data => 'Schedule Preview: COMPLETE',

Line 2593: AMS_Utility_PVT.create_log (

2589: );
2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2591: l_msg_count := FND_MSG_PUB.count_msg;
2592: FOR i IN 1 .. l_msg_count LOOP
2593: AMS_Utility_PVT.create_log (
2594: x_return_status => l_return_status,
2595: p_arc_log_used_by => p_arc_object,
2596: p_log_used_by_id => p_object_id,
2597: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false)

Line 2674: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_records);

2670: CLOSE c_score_details;
2671: END IF;
2672:
2673: IF l_total_records < NVL (l_min_records, 0) THEN
2674: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_records);
2675: RAISE FND_API.G_EXC_ERROR;
2676: END IF;
2677:
2678: IF l_row_selection_type = L_SELECTION_TYPE_STANDARD THEN

Line 2686: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;

2682: WHERE arc_object_used_by = p_arc_object_for
2683: AND object_used_by_id = p_object_for_id
2684: AND rownum <= NVL (l_max_records, l_total_records)
2685: ;
2686: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;
2687: ELSIF l_row_selection_type = L_SELECTION_TYPE_NTH_ROW THEN
2688: randomize_nth_rows (
2689: p_arc_object_for => p_arc_object_for,
2690: p_object_for_id => p_object_for_id,

Line 2700: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;

2696: );
2697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2699: END IF;
2700: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_row_selection_type || ': ' || SQL%ROWCOUNT); END IF;
2701: ELSIF l_row_selection_type = L_SELECTION_TYPE_PCT THEN
2702: randomize_by_pct (
2703: p_arc_object_for => p_arc_object_for,
2704: p_object_for_id => p_object_for_id,

Line 2715: AMS_Utility_PVT.error_message ('AMS_DM_BAD_SELECTION_TYPE', 'SELECTION_TYPE', l_row_selection_type);

2711: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714: ELSE
2715: AMS_Utility_PVT.error_message ('AMS_DM_BAD_SELECTION_TYPE', 'SELECTION_TYPE', l_row_selection_type);
2716: x_return_status := FND_API.G_RET_STS_ERROR;
2717: END IF;
2718: END apply_sizing_options;
2719:

Line 2753: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);

2749: -- Initialize API return status to SUCCESS
2750: x_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2753: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756:
2757: -- Randomize the records

Line 2810: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);

2806: -- Initialize API return status to SUCCESS
2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: IF l_total_random_rows < NVL (p_min_rows, 0) THEN
2810: AMS_Utility_PVT.error_message ('AMS_DM_NOT_ENOUGH_RECORDS', 'NUM_RECORDS', l_total_random_rows);
2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813:
2814: -- two phase updates

Line 3161: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition : ' || l_composite_relation_cond);

3157: CLOSE c_score_child_ds;
3158: END IF;
3159:
3160: IF (AMS_DEBUG_HIGH_ON) THEN
3161: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition : ' || l_composite_relation_cond);
3162: END IF;
3163:
3164: get_wb_filter (
3165: p_workbook_owner => p_workbook_owner,

Line 3185: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition being appended to where clause :: ' || l_composite_relation_cond);

3181: END IF;
3182:
3183: IF LENGTH(l_composite_relation_cond) > 0 THEN
3184: IF (AMS_DEBUG_HIGH_ON) THEN
3185: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition being appended to where clause :: ' || l_composite_relation_cond);
3186: END IF;
3187: IF x_where_clause IS NOT NULL THEN
3188: x_where_clause := x_where_clause || ' AND ' || l_composite_relation_cond ;
3189: ELSE

Line 3241: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: where clause :: ' || x_where_clause);

3237:
3238: x_where_clause := l_from_and_where;
3239: END IF;
3240: IF (AMS_DEBUG_HIGH_ON) THEN
3241: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: where clause :: ' || x_where_clause);
3242: END IF;
3243: END get_where_clause;
3244:
3245:

Line 3310: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: perz filter : ' || x_filter);

3306: x_filter := x_filter || ' AND ' || l_filters_tab(i).parameter_name || ' ' || l_filters_tab(i).parameter_condition || ' ''' || l_filters_tab(i).parameter_value || '''';
3307: END LOOP;
3308:
3309: IF (AMS_DEBUG_HIGH_ON) THEN
3310: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: perz filter : ' || x_filter);
3311: END IF;
3312: END get_perz_filter;
3313:
3314:

Line 3476: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: target positive values: ' || x_sql_stmt);

3472: x_sql_stmt := l_str_not_equals;
3473: END IF;
3474:
3475: IF (AMS_DEBUG_HIGH_ON) THEN
3476: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: target positive values: ' || x_sql_stmt);
3477: END IF;
3478: END get_target_positive_values;
3479:
3480: ---------------------------------------------------------------

Line 3520: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: '|| p_model_id || ' :: ' || l_ds_cat );

3516: x_is_b2b := FALSE;
3517: END IF;
3518:
3519: IF (AMS_DEBUG_HIGH_ON) THEN
3520: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: '|| p_model_id || ' :: ' || l_ds_cat );
3521: END IF;
3522:
3523:
3524: END is_b2b_data_source;

Line 3607: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition : ' || x_sql_stmt);

3603: END LOOP;
3604: CLOSE c_cond;
3605:
3606: IF (AMS_DEBUG_HIGH_ON) THEN
3607: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: relation condition : ' || x_sql_stmt);
3608: END IF;
3609: END get_related_ds_condition;
3610:
3611: ---------------------------------------------------------------

Line 3654: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: IS SEEDED :: TRUE FOR TARGET ID : '|| to_char(p_target_id));

3650:
3651: IF l_dummy IS NOT NULL THEN
3652: x_is_seeded := TRUE;
3653: IF (AMS_DEBUG_HIGH_ON) THEN
3654: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: IS SEEDED :: TRUE FOR TARGET ID : '|| to_char(p_target_id));
3655: END IF;
3656: END IF;
3657:
3658:

Line 3699: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: '|| p_model_id || ' :: ' || l_ds_type_code );

3695: x_is_org_prod := TRUE;
3696: END IF;
3697:
3698: IF (AMS_DEBUG_HIGH_ON) THEN
3699: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: '|| p_model_id || ' :: ' || l_ds_type_code );
3700: END IF;
3701:
3702: END is_org_prod_affn;
3703:

Line 3769: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected List Name : '|| l_list_name || ', Status : ' || l_status_code );

3765: FETCH c_valid_list INTO l_list_name, l_status_code;
3766: CLOSE c_valid_list;
3767:
3768: IF (AMS_DEBUG_HIGH_ON) THEN
3769: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected List Name : '|| l_list_name || ', Status : ' || l_status_code );
3770: END IF;
3771:
3772: IF l_status_code NOT IN ('AVAILABLE','LOCKED') THEN
3773: AMS_Utility_PVT.error_message ('AMS_DM_LIST_NOT_AVAILABLE', 'LISTNAME', l_list_name);

Line 3773: AMS_Utility_PVT.error_message ('AMS_DM_LIST_NOT_AVAILABLE', 'LISTNAME', l_list_name);

3769: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected List Name : '|| l_list_name || ', Status : ' || l_status_code );
3770: END IF;
3771:
3772: IF l_status_code NOT IN ('AVAILABLE','LOCKED') THEN
3773: AMS_Utility_PVT.error_message ('AMS_DM_LIST_NOT_AVAILABLE', 'LISTNAME', l_list_name);
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: RETURN;
3776: END IF;
3777: ELSIF p_select_object_type = 'CELL' THEN

Line 3783: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected Segment Name : '|| l_cell_name || ', Status : ' || l_status_code );

3779: FETCH c_valid_cell INTO l_cell_name, l_status_code;
3780: CLOSE c_valid_cell;
3781:
3782: IF (AMS_DEBUG_HIGH_ON) THEN
3783: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected Segment Name : '|| l_cell_name || ', Status : ' || l_status_code );
3784: END IF;
3785:
3786: IF l_status_code <> 'AVAILABLE' THEN
3787: AMS_Utility_PVT.error_message ('AMS_DM_CELL_NOT_AVAILABLE', 'CELLNAME', l_cell_name);

Line 3787: AMS_Utility_PVT.error_message ('AMS_DM_CELL_NOT_AVAILABLE', 'CELLNAME', l_cell_name);

3783: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Selected Segment Name : '|| l_cell_name || ', Status : ' || l_status_code );
3784: END IF;
3785:
3786: IF l_status_code <> 'AVAILABLE' THEN
3787: AMS_Utility_PVT.error_message ('AMS_DM_CELL_NOT_AVAILABLE', 'CELLNAME', l_cell_name);
3788: x_return_status := FND_API.G_RET_STS_ERROR;
3789: RETURN;
3790: END IF;
3791: ELSIF p_select_object_type = 'DIWB' THEN

Line 3793: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Checking Workbook : '|| p_workbook_name || '::' || p_worksheet_name );

3789: RETURN;
3790: END IF;
3791: ELSIF p_select_object_type = 'DIWB' THEN
3792: IF (AMS_DEBUG_HIGH_ON) THEN
3793: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Checking Workbook : '|| p_workbook_name || '::' || p_worksheet_name );
3794: END IF;
3795:
3796: OPEN c_discoverer_sql (p_workbook_name,
3797: p_worksheet_name,

Line 3813: AMS_Utility_PVT.error_message ('AMS_DM_COMPLEX_WORKBOOK_SQL', 'WORKBOOKNAME', p_workbook_name || '::' || p_worksheet_name);

3809: -- Check if query has these clauses
3810: IF instr(l_sql_string, 'ORDER BY') > 0
3811: OR instr(l_sql_string, 'GROUP BY') > 0
3812: THEN
3813: AMS_Utility_PVT.error_message ('AMS_DM_COMPLEX_WORKBOOK_SQL', 'WORKBOOKNAME', p_workbook_name || '::' || p_worksheet_name);
3814: x_return_status := FND_API.G_RET_STS_ERROR;
3815: RETURN;
3816: END IF;
3817: END IF;

Line 3892: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Checking category ID: '|| l_cat_id || ' and Product name: ' || l_prod_name);

3888: FETCH c_valid_cat INTO l_dummy;
3889: CLOSE c_valid_cat;
3890:
3891: IF (AMS_DEBUG_HIGH_ON) THEN
3892: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Checking category ID: '|| l_cat_id || ' and Product name: ' || l_prod_name);
3893: END IF;
3894:
3895: IF l_dummy IS NULL THEN
3896: AMS_Utility_PVT.error_message ('AMS_DM_CAT_NOT_IN_SET');

Line 3896: AMS_Utility_PVT.error_message ('AMS_DM_CAT_NOT_IN_SET');

3892: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Checking category ID: '|| l_cat_id || ' and Product name: ' || l_prod_name);
3893: END IF;
3894:
3895: IF l_dummy IS NULL THEN
3896: AMS_Utility_PVT.error_message ('AMS_DM_CAT_NOT_IN_SET');
3897: x_return_status := FND_API.G_RET_STS_ERROR;
3898: RETURN;
3899: END IF;
3900:

Line 3909: AMS_Utility_PVT.error_message ('AMS_DM_PROD_NOT_IN_CAT', 'PRODNAME', l_prod_name);

3905: FETCH c_valid_prod INTO l_dummy;
3906: CLOSE c_valid_prod;
3907:
3908: IF l_dummy IS NULL THEN
3909: AMS_Utility_PVT.error_message ('AMS_DM_PROD_NOT_IN_CAT', 'PRODNAME', l_prod_name);
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911: RETURN;
3912: END IF;
3913: END IF;

Line 3917: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Raising error...No categories/products selected.');

3913: END IF;
3914: END LOOP;
3915: IF c_cats_for_model%ROWCOUNT = 0 THEN
3916: IF (AMS_DEBUG_HIGH_ON) THEN
3917: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Raising error...No categories/products selected.');
3918: END IF;
3919: AMS_Utility_PVT.error_message ('AMS_DM_PROD_SEL_EMPTY');
3920: x_return_status := FND_API.G_RET_STS_ERROR;
3921: CLOSE c_cats_for_model;

Line 3919: AMS_Utility_PVT.error_message ('AMS_DM_PROD_SEL_EMPTY');

3915: IF c_cats_for_model%ROWCOUNT = 0 THEN
3916: IF (AMS_DEBUG_HIGH_ON) THEN
3917: AMS_Utility_PVT.debug_message (L_API_NAME || ' :: Raising error...No categories/products selected.');
3918: END IF;
3919: AMS_Utility_PVT.error_message ('AMS_DM_PROD_SEL_EMPTY');
3920: x_return_status := FND_API.G_RET_STS_ERROR;
3921: CLOSE c_cats_for_model;
3922: RETURN;
3923: END IF;