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

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

291:
292: -- Debug Message
293: IF (AMS_DEBUG_HIGH_ON) THEN
294:
295: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
296: END IF;
297: -- Initialize API return status to SUCCESS
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:

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

314:
315: -- Debug Message
316: IF (AMS_DEBUG_HIGH_ON) THEN
317:
318: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.
322: FND_MSG_PUB.Count_And_Get

Line 328: WHEN AMS_Utility_PVT.resource_locked THEN

324: p_data => x_msg_data
325: );
326: EXCEPTION
327:
328: WHEN AMS_Utility_PVT.resource_locked THEN
329: x_return_status := FND_API.g_ret_sts_error;
330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
331: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
332: FND_MSG_PUB.add;

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

400: BEGIN
401:
402: -- Debug Message
403: IF (AMS_DEBUG_HIGH_ON) THEN
404: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
405: END IF;
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )

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

426:
427: ------------------------ lock -------------------------
428:
429: IF (AMS_DEBUG_HIGH_ON) THEN
430: AMS_Utility_PVT.debug_message(l_full_name||': start');
431: END IF;
432: OPEN c_dm_model_b;
433:
434: FETCH c_dm_model_b INTO l_MODEL_ID;

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

450: p_count => x_msg_count,
451: p_data => x_msg_data);
452: IF (AMS_DEBUG_HIGH_ON) THEN
453:
454: AMS_Utility_PVT.debug_message(l_full_name ||': end');
455: END IF;
456: EXCEPTION
457:
458: WHEN AMS_Utility_PVT.resource_locked THEN

Line 458: WHEN AMS_Utility_PVT.resource_locked THEN

454: AMS_Utility_PVT.debug_message(l_full_name ||': end');
455: END IF;
456: EXCEPTION
457:
458: WHEN AMS_Utility_PVT.resource_locked THEN
459: x_return_status := FND_API.g_ret_sts_error;
460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
461: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
462: FND_MSG_PUB.add;

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

572:
573: -- Debug Message
574: IF (AMS_DEBUG_HIGH_ON) THEN
575:
576: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
577: END IF;
578:
579: -- ******************************************************************
580: -- Validate Environment

Line 644: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model');

640: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
641: -- Debug message
642: IF (AMS_DEBUG_HIGH_ON) THEN
643:
644: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model');
645: END IF;
646:
647: -- Invoke validation procedures
648: Validate_dm_model(

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

664:
665: -- Debug Message
666: IF (AMS_DEBUG_HIGH_ON) THEN
667:
668: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
669: END IF;
670:
671: -- Invoke table handler(ams_dm_models_b_PKG.Insert_Row)
672: AMS_DM_MODELS_B_PKG.Insert_Row(

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

765:
766: -- Debug Message
767: IF (AMS_DEBUG_HIGH_ON) THEN
768:
769: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
770: END IF;
771:
772: -- Standard call to get message count and if count is 1, get message info.
773: FND_MSG_PUB.Count_And_Get

Line 779: WHEN AMS_Utility_PVT.resource_locked THEN

775: p_data => x_msg_data
776: );
777: EXCEPTION
778:
779: WHEN AMS_Utility_PVT.resource_locked THEN
780: x_return_status := FND_API.g_ret_sts_error;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
782: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
783: FND_MSG_PUB.add;

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

883: END IF;
884:
885: -- Debug Message
886: IF (AMS_DEBUG_HIGH_ON) THEN
887: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
888: END IF;
889:
890: -- Initialize API return status to SUCCESS
891: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 916: ams_utility_pvt.debug_message ('input object version number : ' || p_dm_model_rec.object_version_number);

912: FETCH c_ref_model INTO l_ref_model_rec;
913: CLOSE c_ref_model;
914:
915: IF (AMS_DEBUG_HIGH_ON) THEN
916: ams_utility_pvt.debug_message ('input object version number : ' || p_dm_model_rec.object_version_number);
917: ams_utility_pvt.debug_message ('completed object version number : ' || l_ref_model_rec.object_version_number);
918: ams_utility_pvt.debug_message ('model id before: ' || l_tar_model_rec.model_id);
919: END IF;
920:

Line 917: ams_utility_pvt.debug_message ('completed object version number : ' || l_ref_model_rec.object_version_number);

913: CLOSE c_ref_model;
914:
915: IF (AMS_DEBUG_HIGH_ON) THEN
916: ams_utility_pvt.debug_message ('input object version number : ' || p_dm_model_rec.object_version_number);
917: ams_utility_pvt.debug_message ('completed object version number : ' || l_ref_model_rec.object_version_number);
918: ams_utility_pvt.debug_message ('model id before: ' || l_tar_model_rec.model_id);
919: END IF;
920:
921: -- 24-Mar-2003 nyostos Fixed bug 2863861.

Line 918: ams_utility_pvt.debug_message ('model id before: ' || l_tar_model_rec.model_id);

914:
915: IF (AMS_DEBUG_HIGH_ON) THEN
916: ams_utility_pvt.debug_message ('input object version number : ' || p_dm_model_rec.object_version_number);
917: ams_utility_pvt.debug_message ('completed object version number : ' || l_ref_model_rec.object_version_number);
918: ams_utility_pvt.debug_message ('model id before: ' || l_tar_model_rec.model_id);
919: END IF;
920:
921: -- 24-Mar-2003 nyostos Fixed bug 2863861.
922: -- Check if the user is resubmitting the update request (via browser refresh button

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

921: -- 24-Mar-2003 nyostos Fixed bug 2863861.
922: -- Check if the user is resubmitting the update request (via browser refresh button
923: -- or by pressing the "update" button again) before re-loading the record.
924: IF (p_dm_model_rec.object_version_number <> l_ref_model_rec.object_version_number) THEN
925: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:
929: --

Line 952: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');

948: x_is_enabled => l_is_enabled
949: );
950: IF l_is_enabled = FALSE THEN
951: IF (AMS_DEBUG_HIGH_ON) THEN
952: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');
953: END IF;
954: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
955: -- displayed to the user
956: x_return_status := 'T';

Line 964: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');

960: -- We should not schedule the build if there are no data selections
961: dataToPreview (p_dm_model_rec.model_id, l_data_exists_flag);
962: IF l_data_exists_flag = 'N' THEN
963: IF (AMS_DEBUG_HIGH_ON) THEN
964: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');
965: END IF;
966: -- Set x_return_status to 'D' (for data error). This will results in a different message
967: -- displayed to the user
968: x_return_status := 'D';

Line 995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );

991: -- to be displayed on a custom confirmation message.
992: l_build_started := 'Y';
993: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_model_rec.wf_itemkey, 'NO');
994: IF (AMS_DEBUG_HIGH_ON) THEN
995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
996: END IF;
997:
998: ELSIF l_ref_model_rec.status_code = G_MODEL_STATUS_SCHEDULED AND l_ref_model_rec.scheduled_date <> l_tar_model_rec.scheduled_date THEN
999:

Line 1007: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');

1003: x_is_enabled => l_is_enabled
1004: );
1005: IF l_is_enabled = FALSE THEN
1006: IF (AMS_DEBUG_HIGH_ON) THEN
1007: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');
1008: END IF;
1009: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
1010: -- displayed to the user
1011: x_return_status := 'T';

Line 1019: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');

1015: -- We should not schedule the build if there are no data selections
1016: dataToPreview (p_dm_model_rec.model_id, l_data_exists_flag);
1017: IF l_data_exists_flag = 'N' THEN
1018: IF (AMS_DEBUG_HIGH_ON) THEN
1019: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');
1020: END IF;
1021: -- Set x_return_status to 'D' (for data error). This will results in a different message
1022: -- displayed to the user
1023: x_return_status := 'D';

Line 1040: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Change schedule failed. Going to start new build process' );

1036:
1037: -- if we cannot change the schedule, may be the process has been purged,
1038: -- then we go ahead and submit a new process and get a new wf_itemkey
1039: IF (AMS_DEBUG_HIGH_ON) THEN
1040: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Change schedule failed. Going to start new build process' );
1041: END IF;
1042:
1043: -- Set reference model status to DRAFT
1044: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, G_DEFAULT_STATUS);

Line 1069: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_model_rec.wf_itemkey);

1065: x_return_status := 'W';
1066: RETURN;
1067: END IF;
1068: IF (AMS_DEBUG_HIGH_ON) THEN
1069: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_model_rec.wf_itemkey);
1070: END IF;
1071:
1072: END IF;
1073:

Line 1079: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );

1075: -- to be displayed on a custom confirmation message.
1076: l_build_started := 'Y';
1077: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_model_rec.wf_itemkey, 'NO');
1078: IF (AMS_DEBUG_HIGH_ON) THEN
1079: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1080: END IF;
1081:
1082: ELSIF l_ref_model_rec.status_code = G_MODEL_STATUS_AVAILABLE AND l_ref_model_rec.scheduled_date <> l_tar_model_rec.scheduled_date THEN
1083:

Line 1091: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');

1087: x_is_enabled => l_is_enabled
1088: );
1089: IF l_is_enabled = FALSE THEN
1090: IF (AMS_DEBUG_HIGH_ON) THEN
1091: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');
1092: END IF;
1093: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
1094: -- displayed to the user
1095: x_return_status := 'T';

Line 1103: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');

1099: -- We should not schedule the build if there are no data selections
1100: dataToPreview (p_dm_model_rec.model_id, l_data_exists_flag);
1101: IF l_data_exists_flag = 'N' THEN
1102: IF (AMS_DEBUG_HIGH_ON) THEN
1103: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');
1104: END IF;
1105: -- Set x_return_status to 'D' (for data error). This will results in a different message
1106: -- displayed to the user
1107: x_return_status := 'D';

Line 1133: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );

1129: -- to be displayed on a custom confirmation message.
1130: l_build_started := 'Y';
1131: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_model_rec.wf_itemkey, 'NO');
1132: IF (AMS_DEBUG_HIGH_ON) THEN
1133: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1134: END IF;
1135:
1136: ELSIF l_ref_model_rec.status_code = G_MODEL_STATUS_PREVIEWING AND l_ref_model_rec.scheduled_date <> FND_API.G_MISS_DATE THEN
1137:

Line 1145: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');

1141: x_is_enabled => l_is_enabled
1142: );
1143: IF l_is_enabled = FALSE THEN
1144: IF (AMS_DEBUG_HIGH_ON) THEN
1145: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot build');
1146: END IF;
1147: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
1148: -- displayed to the user
1149: x_return_status := 'T';

Line 1157: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');

1153: -- We should not schedule the build if there are no data selections
1154: dataToPreview (p_dm_model_rec.model_id, l_data_exists_flag);
1155: IF l_data_exists_flag = 'N' THEN
1156: IF (AMS_DEBUG_HIGH_ON) THEN
1157: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');
1158: END IF;
1159: -- Set x_return_status to 'D' (for data error). This will results in a different message
1160: -- displayed to the user
1161: x_return_status := 'D';

Line 1167: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Model is currently previewing');

1163: END IF;
1164:
1165: -- if the model is PREVIEWING, then cancel the preview process first and set the Model status to DRAFT
1166: IF (AMS_DEBUG_HIGH_ON) THEN
1167: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Model is currently previewing');
1168: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to cancel Preview Process. Item Key ' || l_tar_model_rec.wf_itemkey);
1169: END IF;
1170:
1171:

Line 1168: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to cancel Preview Process. Item Key ' || l_tar_model_rec.wf_itemkey);

1164:
1165: -- if the model is PREVIEWING, then cancel the preview process first and set the Model status to DRAFT
1166: IF (AMS_DEBUG_HIGH_ON) THEN
1167: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Model is currently previewing');
1168: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to cancel Preview Process. Item Key ' || l_tar_model_rec.wf_itemkey);
1169: END IF;
1170:
1171:
1172: AMS_WFMod_PVT.cancel_process (

Line 1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_model_rec.wf_itemkey);

1200: x_return_status := 'W';
1201: RETURN;
1202: END IF;
1203: IF (AMS_DEBUG_HIGH_ON) THEN
1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_model_rec.wf_itemkey);
1205: END IF;
1206:
1207: -- Construct the URL that could be used to monitor the WF process. This will be returned to the caller
1208: -- to be displayed on a custom confirmation message.

Line 1212: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );

1208: -- to be displayed on a custom confirmation message.
1209: l_build_started := 'Y';
1210: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_model_rec.wf_itemkey, 'NO');
1211: IF (AMS_DEBUG_HIGH_ON) THEN
1212: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1213: END IF;
1214: END IF;
1215:
1216: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1217: ams_utility_pvt.debug_message ('model id after: ' || l_tar_model_rec.model_id);

1213: END IF;
1214: END IF;
1215:
1216: IF (AMS_DEBUG_HIGH_ON) THEN
1217: ams_utility_pvt.debug_message ('model id after: ' || l_tar_model_rec.model_id);
1218: ams_utility_pvt.debug_message ('l_ref_model_rec.status_code ' || l_ref_model_rec.status_code );
1219: ams_utility_pvt.debug_message ('l_tar_model_rec.status_code ' || l_tar_model_rec.status_code );
1220: END IF;
1221:

Line 1218: ams_utility_pvt.debug_message ('l_ref_model_rec.status_code ' || l_ref_model_rec.status_code );

1214: END IF;
1215:
1216: IF (AMS_DEBUG_HIGH_ON) THEN
1217: ams_utility_pvt.debug_message ('model id after: ' || l_tar_model_rec.model_id);
1218: ams_utility_pvt.debug_message ('l_ref_model_rec.status_code ' || l_ref_model_rec.status_code );
1219: ams_utility_pvt.debug_message ('l_tar_model_rec.status_code ' || l_tar_model_rec.status_code );
1220: END IF;
1221:
1222: -- Validate if data selections changed for an AVAILABLE Model, and set the

Line 1219: ams_utility_pvt.debug_message ('l_tar_model_rec.status_code ' || l_tar_model_rec.status_code );

1215:
1216: IF (AMS_DEBUG_HIGH_ON) THEN
1217: ams_utility_pvt.debug_message ('model id after: ' || l_tar_model_rec.model_id);
1218: ams_utility_pvt.debug_message ('l_ref_model_rec.status_code ' || l_ref_model_rec.status_code );
1219: ams_utility_pvt.debug_message ('l_tar_model_rec.status_code ' || l_tar_model_rec.status_code );
1220: END IF;
1221:
1222: -- Validate if data selections changed for an AVAILABLE Model, and set the
1223: -- Model status to INVALID. Make sure that a build has not been started as

Line 1269: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model');

1265:
1266: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1267: -- Debug message
1268: IF (AMS_DEBUG_HIGH_ON) THEN
1269: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model');
1270: END IF;
1271:
1272: -- Invoke validation procedures
1273: Validate_dm_model(

Line 1290: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

1286:
1287:
1288: -- Debug Message
1289: IF (AMS_DEBUG_HIGH_ON) THEN
1290: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
1291: END IF;
1292:
1293: BEGIN
1294: -- Invoke table handler(AMS_DM_MODELS_B_PKG.Update_Row)

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

1347: p_attribute15 => l_tar_model_rec.attribute15
1348: );
1349: EXCEPTION
1350: WHEN NO_DATA_FOUND THEN
1351: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
1352: RAISE FND_API.G_EXC_ERROR;
1353: END;
1354:
1355: x_object_version_number := l_tar_model_rec.object_version_number + 1;

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

1385:
1386:
1387: -- Debug Message
1388: IF (AMS_DEBUG_HIGH_ON) THEN
1389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1390: END IF;
1391:
1392: -- Standard call to get message count and if count is 1, get message info.
1393: FND_MSG_PUB.Count_And_Get

Line 1405: WHEN AMS_Utility_PVT.resource_locked THEN

1401: END IF;
1402:
1403: EXCEPTION
1404:
1405: WHEN AMS_Utility_PVT.resource_locked THEN
1406: x_return_status := FND_API.g_ret_sts_error;
1407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1408: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1409: FND_MSG_PUB.add;

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

1483:
1484: -- Debug Message
1485: IF (AMS_DEBUG_HIGH_ON) THEN
1486:
1487: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1488: END IF;
1489:
1490:
1491: -- Initialize API return status to SUCCESS

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

1496: --
1497: -- Debug Message
1498: IF (AMS_DEBUG_HIGH_ON) THEN
1499:
1500: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1501: END IF;
1502:
1503: -- Invoke table handler(AMS_DM_MODELS_B_PKG.Delete_Row)
1504:

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

1522:
1523: -- Debug Message
1524: IF (AMS_DEBUG_HIGH_ON) THEN
1525:
1526: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1527: END IF;
1528:
1529: -- Standard call to get message count and if count is 1, get message info.
1530: FND_MSG_PUB.Count_And_Get

Line 1536: WHEN AMS_Utility_PVT.resource_locked THEN

1532: p_data => x_msg_data
1533: );
1534: EXCEPTION
1535:
1536: WHEN AMS_Utility_PVT.resource_locked THEN
1537: x_return_status := FND_API.g_ret_sts_error;
1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1539: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1540: FND_MSG_PUB.add;

Line 1589: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_fk_items');

1585: IS
1586: BEGIN
1587: IF (AMS_DEBUG_HIGH_ON) THEN
1588:
1589: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_fk_items');
1590: END IF;
1591: x_return_status := FND_API.g_ret_sts_success;
1592: --------------------owner_user_id---------------------------
1593: IF p_dm_model_rec.owner_user_id <> FND_API.g_miss_num THEN

Line 1594: IF AMS_Utility_PVT.check_fk_exists(

1590: END IF;
1591: x_return_status := FND_API.g_ret_sts_success;
1592: --------------------owner_user_id---------------------------
1593: IF p_dm_model_rec.owner_user_id <> FND_API.g_miss_num THEN
1594: IF AMS_Utility_PVT.check_fk_exists(
1595: 'jtf_rs_resource_extns',
1596: 'resource_id',
1597: p_dm_model_rec.owner_user_id
1598: ) = FND_API.g_false

Line 1600: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'OWNER_USER_ID');

1596: 'resource_id',
1597: p_dm_model_rec.owner_user_id
1598: ) = FND_API.g_false
1599: THEN
1600: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'OWNER_USER_ID');
1601: x_return_status := FND_API.g_ret_sts_error;
1602: END IF;
1603: END IF;
1604:

Line 1607: IF AMS_Utility_PVT.check_fk_exists(

1603: END IF;
1604:
1605: --------------------- user_status_id ------------------------
1606: IF p_dm_model_rec.user_status_id <> FND_API.g_miss_num THEN
1607: IF AMS_Utility_PVT.check_fk_exists(
1608: 'ams_user_statuses_b',
1609: 'user_status_id',
1610: p_dm_model_rec.user_status_id
1611: ) = FND_API.g_false

Line 1613: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'USER_STATUS_ID');

1609: 'user_status_id',
1610: p_dm_model_rec.user_status_id
1611: ) = FND_API.g_false
1612: THEN
1613: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'USER_STATUS_ID');
1614: x_return_status := FND_API.g_ret_sts_error;
1615: END IF;
1616: END IF;
1617:

Line 1620: IF AMS_Utility_PVT.check_fk_exists(

1616: END IF;
1617:
1618: --------------------- target_id ------------------------
1619: IF p_dm_model_rec.target_id <> FND_API.g_miss_num THEN
1620: IF AMS_Utility_PVT.check_fk_exists(
1621: 'ams_dm_targets_b',
1622: 'target_id',
1623: p_dm_model_rec.target_id
1624: ) = FND_API.g_false

Line 1626: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_ID');

1622: 'target_id',
1623: p_dm_model_rec.target_id
1624: ) = FND_API.g_false
1625: THEN
1626: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_ID');
1627: x_return_status := FND_API.g_ret_sts_error;
1628: END IF;
1629: END IF;
1630:

Line 1645: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_lookup_items');

1641: IS
1642: BEGIN
1643: IF (AMS_DEBUG_HIGH_ON) THEN
1644:
1645: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_lookup_items');
1646: END IF;
1647: x_return_status := FND_API.g_ret_sts_success;
1648:
1649: /*lookup type can be get from the detail design doc */

Line 1652: IF AMS_Utility_PVT.check_lookup_exists(

1648:
1649: /*lookup type can be get from the detail design doc */
1650: ----------------------- model_type ------------------------
1651: IF p_dm_model_rec.model_type <> FND_API.g_miss_char THEN
1652: IF AMS_Utility_PVT.check_lookup_exists(
1653: p_lookup_type => 'AMS_DM_MODEL_TYPE',
1654: p_lookup_code => p_dm_model_rec.model_type
1655: ) = FND_API.g_false
1656: THEN

Line 1669: IF AMS_Utility_PVT.check_lookup_exists(

1665: END IF;
1666:
1667: ------------------ status_code ---------------------------------------
1668: IF p_dm_model_rec.status_code <> FND_API.g_miss_char THEN
1669: IF AMS_Utility_PVT.check_lookup_exists(
1670: p_lookup_type => 'AMS_DM_MODEL_STATUS',
1671: p_lookup_code => p_dm_model_rec.status_code
1672: ) = FND_API.g_false
1673: THEN

Line 1689: IF AMS_Utility_PVT.check_lookup_exists(

1685: /* the following should be uncommentted when data is ready */
1686:
1687: /*** choang - 05-jun-2002 - OBSELETED
1688: IF p_dm_model_rec.target_group_type <> FND_API.g_miss_char THEN
1689: IF AMS_Utility_PVT.check_lookup_exists(
1690: p_lookup_type => 'AMS_DM_TARGET_GROUP_TYPE',
1691: p_lookup_code => p_dm_model_rec.target_group_type
1692: ) = FND_API.g_false
1693: THEN

Line 1732: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_uk_items');

1728:
1729: BEGIN
1730: IF (AMS_DEBUG_HIGH_ON) THEN
1731:
1732: AMS_UTILITY_PVT.debug_message('Private API:check_dm_model_uk_items');
1733: END IF;
1734: x_return_status := FND_API.g_ret_sts_success;
1735:
1736: --Validate unique model_id

Line 1738: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1734: x_return_status := FND_API.g_ret_sts_success;
1735:
1736: --Validate unique model_id
1737: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1738: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1739: 'ams_dm_models_all_b',
1740: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||'''');
1741: ELSE
1742: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1742: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1738: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1739: 'ams_dm_models_all_b',
1740: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||'''');
1741: ELSE
1742: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1743: 'ams_dm_models_all_b',
1744: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||
1745: ''' AND MODEL_ID <> ' || p_dm_model_rec.model_id);
1746: END IF;

Line 1801: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for update');

1797:
1798: IF (p_validation_mode = jtf_plsql_api.g_update) THEN
1799:
1800: IF (AMS_DEBUG_HIGH_ON) THEN
1801: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for update');
1802: END IF;
1803:
1804: IF (p_dm_model_rec.model_id IS NULL OR p_dm_model_rec.model_id = FND_API.G_MISS_NUM) THEN
1805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1813: AMS_Utility_PVT.error_message ('AMS_MODEL_NO_OBJ_VERSION');

1809: x_return_status := FND_API.g_ret_sts_error;
1810: END IF;
1811:
1812: IF (p_dm_model_rec.object_version_number IS NULL OR p_dm_model_rec.object_version_number = FND_API.G_MISS_NUM) THEN
1813: AMS_Utility_PVT.error_message ('AMS_MODEL_NO_OBJ_VERSION');
1814: x_return_status := FND_API.g_ret_sts_error;
1815: END IF;
1816:
1817: IF p_dm_model_rec.model_type IS NULL THEN

Line 1896: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_NAME');

1892:
1893: -- nyostos Feb 13, 2003. Added check for model name in case the mandatory rule
1894: -- for model name is missing
1895: IF p_dm_model_rec.model_name IS NULL THEN
1896: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_NAME');
1897: x_return_status := FND_API.g_ret_sts_error;
1898: END IF;
1899:
1900: IF p_dm_model_rec.target_id IS NULL THEN

Line 1901: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID');

1897: x_return_status := FND_API.g_ret_sts_error;
1898: END IF;
1899:
1900: IF p_dm_model_rec.target_id IS NULL THEN
1901: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID');
1902: x_return_status := FND_API.g_ret_sts_error;
1903: END IF;
1904:
1905: ELSE

Line 1910: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for create');

1906: -- nyostos Feb 13, 2003. Added check for NULL values on Create
1907:
1908: -- for insert API, check if the parameter is missing or NULL
1909: IF (AMS_DEBUG_HIGH_ON) THEN
1910: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for create');
1911: END IF;
1912:
1913: IF p_dm_model_rec.model_type = FND_API.G_MISS_CHAR OR p_dm_model_rec.model_type IS NULL THEN
1914: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_TYPE');

Line 1914: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_TYPE');

1910: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for create');
1911: END IF;
1912:
1913: IF p_dm_model_rec.model_type = FND_API.G_MISS_CHAR OR p_dm_model_rec.model_type IS NULL THEN
1914: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_TYPE');
1915: x_return_status := FND_API.g_ret_sts_error;
1916: END IF;
1917:
1918: IF p_dm_model_rec.user_status_id = FND_API.G_MISS_NUM OR p_dm_model_rec.user_status_id IS NULL THEN

Line 1919: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID');

1915: x_return_status := FND_API.g_ret_sts_error;
1916: END IF;
1917:
1918: IF p_dm_model_rec.user_status_id = FND_API.G_MISS_NUM OR p_dm_model_rec.user_status_id IS NULL THEN
1919: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID');
1920: x_return_status := FND_API.g_ret_sts_error;
1921: END IF;
1922:
1923: IF p_dm_model_rec.status_code = FND_API.G_MISS_CHAR OR p_dm_model_rec.status_code IS NULL THEN

Line 1924: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE');

1920: x_return_status := FND_API.g_ret_sts_error;
1921: END IF;
1922:
1923: IF p_dm_model_rec.status_code = FND_API.G_MISS_CHAR OR p_dm_model_rec.status_code IS NULL THEN
1924: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE');
1925: x_return_status := FND_API.g_ret_sts_error;
1926: END IF;
1927:
1928: IF p_dm_model_rec.status_date = FND_API.G_MISS_DATE OR p_dm_model_rec.status_date IS NULL THEN

Line 1929: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_DATE');

1925: x_return_status := FND_API.g_ret_sts_error;
1926: END IF;
1927:
1928: IF p_dm_model_rec.status_date = FND_API.G_MISS_DATE OR p_dm_model_rec.status_date IS NULL THEN
1929: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_DATE');
1930: x_return_status := FND_API.g_ret_sts_error;
1931: END IF;
1932:
1933: IF (p_dm_model_rec.owner_user_id = FND_API.G_MISS_NUM) OR p_dm_model_rec.owner_user_id IS NULL THEN

Line 1934: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OWNER_USER_ID');

1930: x_return_status := FND_API.g_ret_sts_error;
1931: END IF;
1932:
1933: IF (p_dm_model_rec.owner_user_id = FND_API.G_MISS_NUM) OR p_dm_model_rec.owner_user_id IS NULL THEN
1934: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OWNER_USER_ID');
1935: x_return_status := FND_API.g_ret_sts_error;
1936: END IF;
1937:
1938: /**** - choang - 05-jun-2002 - OBSELETED

Line 1940: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_GROUP_TYPE');

1936: END IF;
1937:
1938: /**** - choang - 05-jun-2002 - OBSELETED
1939: IF p_dm_model_rec.target_group_type = FND_API.G_MISS_CHAR THEN
1940: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_GROUP_TYPE');
1941: x_return_status := FND_API.g_ret_sts_error;
1942: END IF;
1943: ***/
1944: -- nyostos Feb 13, 2003. Added check for model name in case the mandatory rule

Line 1947: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_NAME');

1943: ***/
1944: -- nyostos Feb 13, 2003. Added check for model name in case the mandatory rule
1945: -- for model name is missing
1946: IF p_dm_model_rec.model_name = FND_API.G_MISS_CHAR OR p_dm_model_rec.model_name IS NULL THEN
1947: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_NAME');
1948: x_return_status := FND_API.g_ret_sts_error;
1949: END IF;
1950:
1951: IF p_dm_model_rec.target_id = FND_API.G_MISS_NUM OR p_dm_model_rec.target_id IS NULL THEN

Line 1952: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID');

1948: x_return_status := FND_API.g_ret_sts_error;
1949: END IF;
1950:
1951: IF p_dm_model_rec.target_id = FND_API.G_MISS_NUM OR p_dm_model_rec.target_id IS NULL THEN
1952: AMS_Utility_PVT.error_message ('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TARGET_ID');
1953: x_return_status := FND_API.g_ret_sts_error;
1954: END IF;
1955:
1956: END IF;

Line 1976: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_uk_items');

1972:
1973: -- Check Items Uniqueness API calls
1974: IF (AMS_DEBUG_HIGH_ON) THEN
1975:
1976: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_uk_items');
1977: END IF;
1978: Check_dm_model_uk_items(
1979: p_dm_model_rec =>p_dm_model_rec,
1980: p_validation_mode => p_validation_mode,

Line 1988: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_req_items');

1984: END IF;
1985:
1986: -- Check Items Required/NOT NULL API calls
1987: IF (AMS_DEBUG_HIGH_ON) THEN
1988: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_req_items');
1989: END IF;
1990: Check_dm_model_req_items(
1991: p_dm_model_rec =>p_dm_model_rec,
1992: p_validation_mode => p_validation_mode,

Line 2000: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_fk_items');

1996: END IF;
1997:
1998: -- Check Items Foreign Key API calls
1999: IF (AMS_DEBUG_HIGH_ON) THEN
2000: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_fk_items');
2001: END IF;
2002: Check_dm_model_fk_items(
2003: p_dm_model_rec =>p_dm_model_rec,
2004: x_return_status => x_return_status);

Line 2011: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_lookup_items');

2007: END IF;
2008:
2009: -- Check Items Lookup API calls
2010: IF (AMS_DEBUG_HIGH_ON) THEN
2011: AMS_UTILITY_PVT.debug_message('Private API:call check_dm_model_lookup_items');
2012: END IF;
2013: Check_dm_model_lookup_items(
2014: p_dm_model_rec =>p_dm_model_rec,
2015: x_return_status => x_return_status);

Line 2029: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MIN_RECORDS');

2025: l_min_rec NUMBER;
2026: BEGIN
2027: l_min_rec := TO_NUMBER (p_dm_model_rec.min_records);
2028: IF l_min_rec < 0 THEN
2029: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MIN_RECORDS');
2030: x_return_status := FND_API.G_RET_STS_ERROR;
2031: RETURN;
2032: END IF;
2033: EXCEPTION

Line 2035: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MIN_RECORDS');

2031: RETURN;
2032: END IF;
2033: EXCEPTION
2034: WHEN VALUE_ERROR THEN
2035: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MIN_RECORDS');
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: RETURN;
2038: END;
2039: END IF;

Line 2049: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MAX_RECORDS');

2045: l_max_rec NUMBER;
2046: BEGIN
2047: l_max_rec := TO_NUMBER (p_dm_model_rec.max_records);
2048: IF l_max_rec < 0 THEN
2049: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MAX_RECORDS');
2050: x_return_status := FND_API.G_RET_STS_ERROR;
2051: RETURN;
2052: END IF;
2053: EXCEPTION

Line 2055: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MAX_RECORDS');

2051: RETURN;
2052: END IF;
2053: EXCEPTION
2054: WHEN VALUE_ERROR THEN
2055: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MAX_RECORDS');
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: RETURN;
2058: END;
2059: END IF;

Line 2105: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

2101: -- THEN
2102: -- x_return_status := FND_API.G_RET_STS_ERROR;
2103:
2104: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
2105: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2106:
2107: OPEN c_reference(p_dm_model_rec.model_id);
2108: FETCH c_reference INTO l_reference_rec;
2109: CLOSE c_reference;

Line 2135: AMS_Utility_PVT.error_message ('AMS_PRIC_UPDT_OWNER_PERM');

2131: p_user_or_role_id => l_context_resource_id
2132: );
2133:
2134: IF l_is_owner = 'N' AND NOT AMS_Access_PVT.Check_Admin_Access(l_context_resource_id) THEN
2135: AMS_Utility_PVT.error_message ('AMS_PRIC_UPDT_OWNER_PERM');
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: END IF;
2138: END IF;
2139: END IF;

Line 2154: AMS_Utility_PVT.error_message ('AMS_DM_MIN_MORE_THAN_MAX');

2150: BEGIN
2151: l_min_rec := TO_NUMBER (p_dm_model_rec.min_records);
2152: l_max_rec := TO_NUMBER (p_dm_model_rec.max_records);
2153: IF l_max_rec < l_min_rec THEN
2154: AMS_Utility_PVT.error_message ('AMS_DM_MIN_MORE_THAN_MAX');
2155: x_return_status := FND_API.G_RET_STS_ERROR;
2156: RETURN;
2157: END IF;
2158: END;

Line 2166: AMS_Utility_PVT.error_message ('AMS_DM_NO_NTH_RECORD');

2162: -- and it must be greater than 0
2163: IF p_dm_model_rec.row_selection_type = 'NTH_RECORD' THEN
2164: IF p_dm_model_rec.every_nth_row IS NULL OR
2165: p_dm_model_rec.every_nth_row = FND_API.g_miss_num THEN
2166: AMS_Utility_PVT.error_message ('AMS_DM_NO_NTH_RECORD');
2167: x_return_status := FND_API.G_RET_STS_ERROR;
2168: RETURN;
2169: END IF;
2170: --check for valid number

Line 2176: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_NTH_ROW');

2172: l_nth_row NUMBER;
2173: BEGIN
2174: l_nth_row := ROUND(TO_NUMBER (p_dm_model_rec.every_nth_row));
2175: IF l_nth_row <= 0 THEN
2176: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_NTH_ROW');
2177: x_return_status := FND_API.G_RET_STS_ERROR;
2178: RETURN;
2179: END IF;
2180: EXCEPTION

Line 2182: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'EVERY_NTH_ROW');

2178: RETURN;
2179: END IF;
2180: EXCEPTION
2181: WHEN VALUE_ERROR THEN
2182: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'EVERY_NTH_ROW');
2183: x_return_status := FND_API.G_RET_STS_ERROR;
2184: RETURN;
2185: END;
2186: END IF;

Line 2193: AMS_Utility_PVT.error_message ('AMS_DM_NO_PCT_RANDOM');

2189: -- and it must be between 0 and 100
2190: IF p_dm_model_rec.row_selection_type = 'RANDOM' THEN
2191: IF p_dm_model_rec.pct_random IS NULL OR
2192: p_dm_model_rec.pct_random = FND_API.g_miss_num THEN
2193: AMS_Utility_PVT.error_message ('AMS_DM_NO_PCT_RANDOM');
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: RETURN;
2196: END IF;
2197: --check for valid number

Line 2203: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PCT_RANDOM');

2199: l_pct_random NUMBER;
2200: BEGIN
2201: l_pct_random := TO_NUMBER (p_dm_model_rec.pct_random);
2202: IF l_pct_random <= 0 OR l_pct_random > 100 THEN
2203: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PCT_RANDOM');
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: RETURN;
2206: END IF;
2207: EXCEPTION

Line 2209: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'PCT_RANDOM');

2205: RETURN;
2206: END IF;
2207: EXCEPTION
2208: WHEN VALUE_ERROR THEN
2209: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'PCT_RANDOM');
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: RETURN;
2212: END;
2213: END IF;

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

2214: -- End add rosharma 28-Nov-2002
2215:
2216: -- Debug Message
2217: IF (AMS_DEBUG_HIGH_ON) THEN
2218: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2219: END IF;
2220: -- Standard call to get message count and if count is 1, get message info.
2221: FND_MSG_PUB.Count_And_Get
2222: (p_count => x_msg_count,

Line 2250: AMS_Utility_PVT.error_message ('AMS_MODEL_BAD_ID');

2246: OPEN c_complete;
2247: FETCH c_complete INTO l_model_rec;
2248: IF c_complete%NOTFOUND THEN
2249: CLOSE c_complete;
2250: AMS_Utility_PVT.error_message ('AMS_MODEL_BAD_ID');
2251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2252: END IF;
2253: CLOSE c_complete;
2254:

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

2547:
2548: -- Debug Message
2549: IF (AMS_DEBUG_HIGH_ON) THEN
2550:
2551: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
2552: END IF;
2553: -- Initialize API return status to SUCCESS
2554: x_return_status := FND_API.G_RET_STS_SUCCESS;
2555:

Line 2573: AMS_UTILITY_PVT.debug_message('Private API:call Check_DM_MODEL_Items');

2569: END IF;
2570: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2571: IF (AMS_DEBUG_HIGH_ON) THEN
2572:
2573: AMS_UTILITY_PVT.debug_message('Private API:call Check_DM_MODEL_Items');
2574: END IF;
2575: Check_dm_model_items(
2576: p_dm_model_rec => p_dm_model_rec,
2577: p_validation_mode => p_validation_mode,

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

2602:
2603: -- Debug Message
2604: IF (AMS_DEBUG_HIGH_ON) THEN
2605:
2606: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2607: END IF;
2608:
2609: -- Standard call to get message count and if count is 1, get message info.
2610: FND_MSG_PUB.Count_And_Get

Line 2615: WHEN AMS_Utility_PVT.resource_locked THEN

2611: (p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );
2614: EXCEPTION
2615: WHEN AMS_Utility_PVT.resource_locked THEN
2616: x_return_status := FND_API.g_ret_sts_error;
2617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2618: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2619: FND_MSG_PUB.add;

Line 2668: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

2664: L_MODEL_QUALIFIER CONSTANT VARCHAR2(30) := 'MODL';
2665: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
2666:
2667: -- user id of the currently logged in user.
2668: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
2669: BEGIN
2670: -- Initialize API return status to SUCCESS
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672:

Line 2673: --IF (AMS_DEBUG_HIGH_ON) THENams_utility_pvt.debug_message ('qualifier: ' || l_model_qualifier || ' id: ' || p_model_rec.model_id || ' resource: ' || l_owner_user_id);END IF;

2669: BEGIN
2670: -- Initialize API return status to SUCCESS
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672:
2673: --IF (AMS_DEBUG_HIGH_ON) THENams_utility_pvt.debug_message ('qualifier: ' || l_model_qualifier || ' id: ' || p_model_rec.model_id || ' resource: ' || l_owner_user_id);END IF;
2674: -- validate access privileges
2675: IF AMS_Access_PVT.check_update_access (
2676: p_object_id => p_model_rec.model_id,
2677: p_object_type => L_MODEL_QUALIFIER,

Line 2680: AMS_Utility_PVT.error_message ('AMS_MODEL_NO_UPDATE_ACCESS');

2676: p_object_id => p_model_rec.model_id,
2677: p_object_type => L_MODEL_QUALIFIER,
2678: p_user_or_role_id => l_owner_user_id,
2679: p_user_or_role_type => L_ACCESS_TYPE_USER) = 'N' THEN
2680: AMS_Utility_PVT.error_message ('AMS_MODEL_NO_UPDATE_ACCESS');
2681: x_return_status := FND_API.G_RET_STS_ERROR;
2682: END IF;
2683: END check_access;
2684:

Line 2861: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

2857: BEGIN
2858: -- Debug Message
2859: IF (AMS_DEBUG_HIGH_ON) THEN
2860:
2861: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2862: END IF;
2863:
2864: AMS_Utility_PVT.create_log (
2865: x_return_status => l_return_status,

Line 2864: AMS_Utility_PVT.create_log (

2860:
2861: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2862: END IF;
2863:
2864: AMS_Utility_PVT.create_log (
2865: x_return_status => l_return_status,
2866: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2867: p_log_used_by_id => p_model_id,
2868: p_msg_data => L_API_NAME || ': begin '

Line 2903: AMS_Utility_PVT.create_log (

2899: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2900: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: -- Report that an error occurred, but ifgnore it and proceed with re-setting
2902: -- the Model status.
2903: AMS_Utility_PVT.create_log (
2904: x_return_status => l_return_status,
2905: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2906: p_log_used_by_id => p_model_id,
2907: p_msg_data => L_API_NAME || ': Error while canceling Model Build '

Line 2912: AMS_Utility_PVT.create_log (

2908: );
2909:
2910: --RAISE FND_API.G_EXC_ERROR;
2911: ELSE
2912: AMS_Utility_PVT.create_log (
2913: x_return_status => l_return_status,
2914: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2915: p_log_used_by_id => p_model_id,
2916: p_msg_data => L_API_NAME || ': Model Build Process Canceled '

Line 2966: AMS_Utility_PVT.create_log (

2962: -- No Build Request/Process to cancel
2963: -- Set x_return_status to expected error. This will results in a different message
2964: -- displayed to the user
2965: x_return_status := FND_API.G_RET_STS_ERROR;
2966: AMS_Utility_PVT.create_log (
2967: x_return_status => l_return_status,
2968: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2969: p_log_used_by_id => p_model_id,
2970: p_msg_data => L_API_NAME || ': No Model Build To Cancel '

Line 2978: AMS_Utility_PVT.create_log (

2974: -- No Build Request/Process to cancel
2975: -- Set x_return_status to expected error. This will results in a different message
2976: -- displayed to the user
2977: x_return_status := FND_API.G_RET_STS_ERROR;
2978: AMS_Utility_PVT.create_log (
2979: x_return_status => l_return_status,
2980: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2981: p_log_used_by_id => p_model_id,
2982: p_msg_data => L_API_NAME || ': No Model Build To Cancel '

Line 2986: AMS_Utility_PVT.create_log (

2982: p_msg_data => L_API_NAME || ': No Model Build To Cancel '
2983: );
2984: END IF;
2985:
2986: AMS_Utility_PVT.create_log (
2987: x_return_status => l_return_status,
2988: p_arc_log_used_by => G_OBJECT_TYPE_MODEL,
2989: p_log_used_by_id => p_model_id,
2990: p_msg_data => L_API_NAME || ': End '

Line 2995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

2991: );
2992:
2993: -- Debug Message
2994: IF (AMS_DEBUG_HIGH_ON) THEN
2995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
2996: END IF;
2997:
2998: END cancel_build_request;
2999:

Line 3014: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

3010: )
3011: IS
3012: L_MODEL_QUALIFIER CONSTANT VARCHAR2(30) := 'MODL';
3013: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
3014: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
3015:
3016: l_proceedWithPreviewFlag VARCHAR2(1);
3017: l_data_exists_flag VARCHAR2(1);
3018: l_target_id NUMBER;

Line 3042: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3038: BEGIN
3039: -- Debug Message
3040: IF (AMS_DEBUG_HIGH_ON) THEN
3041:
3042: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3043: END IF;
3044:
3045: -- Initialize API return status to SUCCESS
3046: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3074: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot preview');

3070: x_is_enabled => l_is_enabled
3071: );
3072: IF l_is_enabled = FALSE THEN
3073: IF (AMS_DEBUG_HIGH_ON) THEN
3074: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot preview');
3075: END IF;
3076: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
3077: -- displayed to the user
3078: x_return_status := 'T';

Line 3087: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Cannot Proceed with Preview');

3083: proceedWithPreview (p_model_id, l_proceedWithPreviewFlag);
3084: IF l_proceedWithPreviewFlag = 'N' THEN
3085: IF (AMS_DEBUG_HIGH_ON) THEN
3086:
3087: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Cannot Proceed with Preview');
3088: END IF;
3089: -- Set x_return_status to expected error. This will results in a different message
3090: -- displayed to the user
3091: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3099: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Preview');

3095: dataToPreview (p_model_id, l_data_exists_flag);
3096: IF l_data_exists_flag = 'N' THEN
3097: IF (AMS_DEBUG_HIGH_ON) THEN
3098:
3099: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Preview');
3100: END IF;
3101: -- Set x_return_status to 'D' (for data error). This will results in a different message
3102: -- displayed to the user
3103: x_return_status := 'D';

Line 3117: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Error from wf_startPreviewProcess');

3113:
3114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3115: IF (AMS_DEBUG_HIGH_ON) THEN
3116:
3117: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Error from wf_startPreviewProcess');
3118: END IF;
3119: -- Set x_return_status to unexpected error. This will results in a different message
3120: -- displayed to the user
3121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3145: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

3141:
3142: -- Debug Message
3143: IF (AMS_DEBUG_HIGH_ON) THEN
3144:
3145: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
3146: END IF;
3147:
3148: END handle_preview_request;
3149:

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

3258: IF (AMS_DEBUG_HIGH_ON) THEN
3259:
3260:
3261:
3262: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
3263:
3264: END IF;
3265:
3266: -- Initialize API return status to SUCCESS

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

3449:
3450: -- Debug Message
3451: IF (AMS_DEBUG_HIGH_ON) THEN
3452:
3453: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3454: END IF;
3455:
3456: -- Standard call to get message count and if count is 1, get message info.
3457: FND_MSG_PUB.Count_And_Get (

Line 3542: AMS_Utility_PVT.get_user_timezone (

3538: -- used with get_user_timezone api
3539: l_user_timezone_name VARCHAR2(80);
3540: BEGIN
3541: IF p_scheduled_timezone_id IS NULL THEN
3542: AMS_Utility_PVT.get_user_timezone (
3543: x_return_status => x_return_status,
3544: x_user_time_id => x_tar_model_rec.scheduled_timezone_id,
3545: x_user_time_name => l_user_timezone_name
3546: );

Line 3601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3597: BEGIN
3598:
3599: -- Debug Message
3600: IF (AMS_DEBUG_HIGH_ON) THEN
3601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3602: END IF;
3603:
3604: -- fix for bug 4961279. changed get_user_timezone to get_system_timezone
3605: AMS_Utility_PVT.get_system_timezone (

Line 3605: AMS_Utility_PVT.get_system_timezone (

3601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3602: END IF;
3603:
3604: -- fix for bug 4961279. changed get_user_timezone to get_system_timezone
3605: AMS_Utility_PVT.get_system_timezone (
3606: x_return_status => x_return_status,
3607: x_sys_time_id => x_tar_model_rec.scheduled_timezone_id,
3608: x_sys_time_name => l_user_timezone_name
3609: );

Line 3611: AMS_UTILITY_PVT.debug_message(' Error in get_user_timezone.');

3607: x_sys_time_id => x_tar_model_rec.scheduled_timezone_id,
3608: x_sys_time_name => l_user_timezone_name
3609: );
3610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: AMS_UTILITY_PVT.debug_message(' Error in get_user_timezone.');
3612: RAISE FND_API.G_EXC_ERROR;
3613: END IF;
3614:
3615: -- When we submit a Preview request, we clean up all the previous

Line 3641: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

3637: );
3638:
3639: -- Debug Message
3640: IF (AMS_DEBUG_HIGH_ON) THEN
3641: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
3642: END IF;
3643:
3644: IF x_tar_model_rec.wf_itemkey IS NULL THEN
3645: x_return_status := FND_API.g_ret_sts_error;

Line 3667: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3663:
3664: -- Debug Message
3665: IF (AMS_DEBUG_HIGH_ON) THEN
3666:
3667: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3668: END IF;
3669:
3670: -- Remove DM Source records
3671: delete /*+ index(AMS_DM_SOURCE AMS_DM_SOURCE_U2) */ from ams_dm_source

Line 3695: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');

3691:
3692: -- Debug Message
3693: IF (AMS_DEBUG_HIGH_ON) THEN
3694:
3695: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');
3696: END IF;
3697:
3698: END cleanupPreviousBuildData;
3699:

Line 3727: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3723:
3724: -- Debug Message
3725: IF (AMS_DEBUG_HIGH_ON) THEN
3726:
3727: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3728: END IF;
3729:
3730: -- Get the model status
3731: OPEN c_model_status (p_model_id);

Line 3738: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Model Status Code = ' || x_status_code);

3734:
3735: -- Debug Message
3736: IF (AMS_DEBUG_HIGH_ON) THEN
3737:
3738: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Model Status Code = ' || x_status_code);
3739: END IF;
3740:
3741: END getModelStatus;
3742:

Line 3787: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3783:
3784: -- Debug Message
3785: IF (AMS_DEBUG_HIGH_ON) THEN
3786:
3787: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3788: END IF;
3789:
3790: -- Initialize x_data_exists_flag to 'Y'
3791: x_data_exists_flag := 'Y';

Line 3802: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_seeded_ds_flag = ' || l_seeded_ds_flag);

3798:
3799: -- Debug Message
3800: IF (AMS_DEBUG_HIGH_ON) THEN
3801:
3802: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_seeded_ds_flag = ' || l_seeded_ds_flag);
3803: END IF;
3804:
3805: IF l_seeded_ds_flag = 'Y' THEN
3806:

Line 3840: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. x_data_exists_flag = ' || x_data_exists_flag);

3836:
3837: -- Debug Message
3838: IF (AMS_DEBUG_HIGH_ON) THEN
3839:
3840: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. x_data_exists_flag = ' || x_data_exists_flag);
3841: END IF;
3842:
3843: END dataToPreview;
3844:

Line 3868: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3864:
3865: -- Debug Message
3866: IF (AMS_DEBUG_HIGH_ON) THEN
3867:
3868: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3869: END IF;
3870:
3871: -- Initialize proceed flag to 'Y'
3872: x_proceed_flag := 'Y';

Line 3880: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Status Code = ' || l_status_code);

3876:
3877: -- Debug Message
3878: IF (AMS_DEBUG_HIGH_ON) THEN
3879:
3880: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Status Code = ' || l_status_code);
3881: END IF;
3882:
3883: IF l_status_code = G_MODEL_STATUS_SCHEDULED OR
3884: l_status_code = G_MODEL_STATUS_BUILDING OR

Line 3898: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Proceed Flag = ' || x_proceed_flag);

3894:
3895: -- Debug Message
3896: IF (AMS_DEBUG_HIGH_ON) THEN
3897:
3898: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Proceed Flag = ' || x_proceed_flag);
3899: END IF;
3900:
3901: END proceedWithPreview;
3902:

Line 3927: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

3923:
3924: -- Debug Message
3925: IF (AMS_DEBUG_HIGH_ON) THEN
3926:
3927: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3928: END IF;
3929:
3930: -- Initialize proceed flag to 'Y'
3931: x_seeded_flag := 'Y';

Line 3946: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Seeded Flag = ' || x_seeded_flag);

3942:
3943: -- Debug Message
3944: IF (AMS_DEBUG_HIGH_ON) THEN
3945:
3946: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Seeded Flag = ' || x_seeded_flag);
3947: END IF;
3948:
3949: END seededDataSource;
3950:

Line 3976: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');

3972: BEGIN
3973: -- Debug Message
3974: IF (AMS_DEBUG_HIGH_ON) THEN
3975:
3976: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');
3977: END IF;
3978:
3979: x_selections_changed_flag := 'N';
3980:

Line 4025: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Selections Changed Flag = ' || x_selections_changed_flag);

4021:
4022: -- Debug Message
4023: IF (AMS_DEBUG_HIGH_ON) THEN
4024:
4025: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Selections Changed Flag = ' || x_selections_changed_flag);
4026: END IF;
4027:
4028: END check_data_size_changes;
4029:

Line 4056: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');

4052: BEGIN
4053: -- Debug Message
4054: IF (AMS_DEBUG_HIGH_ON) THEN
4055:
4056: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');
4057: END IF;
4058:
4059: -- Load the model record to get the original status
4060: OPEN c_ref_model (p_model_id);

Line 4094: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Invalidated Model.');

4090: IF (AMS_DEBUG_HIGH_ON) THEN
4091:
4092:
4093:
4094: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Invalidated Model.');
4095:
4096: END IF;
4097:
4098: END IF;

Line 4104: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');

4100:
4101: -- Debug Message
4102: IF (AMS_DEBUG_HIGH_ON) THEN
4103:
4104: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');
4105: END IF;
4106:
4107: END handle_data_selection_changes;
4108:

Line 4141: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');

4137:
4138: -- Debug Message
4139: IF (AMS_DEBUG_HIGH_ON) THEN
4140:
4141: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');
4142: END IF;
4143:
4144: -- Get the user status id for INVALID status
4145: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, G_MODEL_STATUS_INVALID);

Line 4169: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');

4165:
4166: -- Debug Message
4167: IF (AMS_DEBUG_HIGH_ON) THEN
4168:
4169: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');
4170: END IF;
4171:
4172: END handle_data_source_changes;
4173: