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

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

278:
279: -- Debug Message
280: IF (AMS_DEBUG_HIGH_ON) THEN
281:
282: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
283: END IF;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list )

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

307: IF (AMS_DEBUG_HIGH_ON) THEN
308:
309:
310:
311: AMS_Utility_PVT.debug_message(l_full_name||': start');
312:
313: END IF;
314: OPEN c_Score_b;
315: FETCH c_Score_b INTO l_score_id;

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

330: p_count => x_msg_count,
331: p_data => x_msg_data);
332: IF (AMS_DEBUG_HIGH_ON) THEN
333:
334: AMS_Utility_PVT.debug_message(l_full_name ||': end');
335: END IF;
336: EXCEPTION
337:
338: WHEN AMS_Utility_PVT.resource_locked THEN

Line 338: WHEN AMS_Utility_PVT.resource_locked THEN

334: AMS_Utility_PVT.debug_message(l_full_name ||': end');
335: END IF;
336: EXCEPTION
337:
338: WHEN AMS_Utility_PVT.resource_locked THEN
339: x_return_status := FND_API.g_ret_sts_error;
340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
341: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
342: FND_MSG_PUB.add;

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

466:
467: -- Debug Message
468: IF (AMS_DEBUG_HIGH_ON) THEN
469:
470: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
471: END IF;
472:
473:
474: -- Initialize API return status to SUCCESS

Line 554: AMS_UTILITY_PVT.debug_message('Private API: Validate_Score');

550: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
551: -- Debug message
552: IF (AMS_DEBUG_HIGH_ON) THEN
553:
554: AMS_UTILITY_PVT.debug_message('Private API: Validate_Score');
555: END IF;
556:
557: -- Invoke validation procedures
558: Validate_Score (

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

574:
575: -- Debug Message
576: IF (AMS_DEBUG_HIGH_ON) THEN
577:
578: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
579: END IF;
580:
581: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Insert_Row)
582: AMS_DM_scoreS_B_PKG.Insert_Row(

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

663:
664: -- Debug Message
665: IF (AMS_DEBUG_HIGH_ON) THEN
666:
667: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
668: END IF;
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get

Line 677: WHEN AMS_Utility_PVT.resource_locked THEN

673: p_data => x_msg_data
674: );
675: EXCEPTION
676:
677: WHEN AMS_Utility_PVT.resource_locked THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
680: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
681: FND_MSG_PUB.add;

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

785: END IF;
786:
787: -- Debug Message
788: IF (AMS_DEBUG_HIGH_ON) THEN
789: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
790: END IF;
791:
792:
793: -- Initialize API return status to SUCCESS

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

819: END IF;
820:
821: -- Debug Message
822: IF (AMS_DEBUG_HIGH_ON) THEN
823: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
824: END IF;
825: CLOSE c_reference;
826:
827: OPEN c_target_id (l_tar_score_rec.score_id);

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

831: -- 24-Mar-2003 nyostos Fixed bug 2863861.
832: -- Check if the user is resubmitting the update request (via browser refresh button
833: -- or by pressing the "update" button again) before re-loading the record.
834: IF (p_score_rec.object_version_number <> l_reference_rec.object_version_number) THEN
835: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839: l_tar_score_rec.country_id := FND_PROFILE.value ('AMS_SRCGEN_USER_CITY');

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

855: x_is_enabled => l_is_enabled
856: );
857: IF l_is_enabled = FALSE THEN
858: IF (AMS_DEBUG_HIGH_ON) THEN
859: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot score');
860: END IF;
861: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
862: -- displayed to the user
863: x_return_status := 'T';

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

867: -- We should not schedule the Run if there are no data selections
868: dataToPreview (l_tar_score_rec.score_id, l_data_exists_flag);
869: IF l_data_exists_flag = 'N' THEN
870: IF (AMS_DEBUG_HIGH_ON) THEN
871: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Score');
872: END IF;
873: -- Set x_return_status to 'D' (for data error). This will results in a different message
874: -- displayed to the user
875: x_return_status := 'D';

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

895: -- to be displayed on a custom confirmation message.
896: l_run_started := 'Y';
897: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_score_rec.wf_itemkey, 'NO');
898: IF (AMS_DEBUG_HIGH_ON) THEN
899: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
900: END IF;
901: ELSE
902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
903: p_token_name => 'STATUS',

Line 902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',

898: IF (AMS_DEBUG_HIGH_ON) THEN
899: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
900: END IF;
901: ELSE
902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
903: p_token_name => 'STATUS',
904: p_token_value => l_model_status) ;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;

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

920: x_is_enabled => l_is_enabled
921: );
922: IF l_is_enabled = FALSE THEN
923: IF (AMS_DEBUG_HIGH_ON) THEN
924: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot score');
925: END IF;
926: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
927: -- displayed to the user
928: x_return_status := 'T';

Line 942: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Change schedule failed' );

938: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
939: -- if we cannot change the schedule, may be the process has been purged,
940: -- then we go ahead and submit a new process and get a new wf_itemkey
941: IF (AMS_DEBUG_HIGH_ON) THEN
942: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Change schedule failed' );
943: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to start new build process' );
944: END IF;
945:
946: -- Check that there is data selections for the Scoring Run

Line 943: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to start new build process' );

939: -- if we cannot change the schedule, may be the process has been purged,
940: -- then we go ahead and submit a new process and get a new wf_itemkey
941: IF (AMS_DEBUG_HIGH_ON) THEN
942: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Change schedule failed' );
943: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to start new build process' );
944: END IF;
945:
946: -- Check that there is data selections for the Scoring Run
947: -- We should not schedule the Run if there are no data selections

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

947: -- We should not schedule the Run if there are no data selections
948: dataToPreview (l_tar_score_rec.score_id, l_data_exists_flag);
949: IF l_data_exists_flag = 'N' THEN
950: IF (AMS_DEBUG_HIGH_ON) THEN
951: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Score');
952: END IF;
953: -- Set x_return_status to 'D' (for data error). This will results in a different message
954: -- displayed to the user
955: x_return_status := 'D';

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

980: x_return_status := 'W';
981: RETURN;
982: END IF;
983: IF (AMS_DEBUG_HIGH_ON) THEN
984: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_score_rec.wf_itemkey);
985: END IF;
986:
987: END IF;
988:

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

990: -- to be displayed on a custom confirmation message.
991: l_run_started := 'Y';
992: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_score_rec.wf_itemkey, 'NO');
993: IF (AMS_DEBUG_HIGH_ON) THEN
994: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
995: END IF;
996: ELSE
997: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
998: p_token_name => 'STATUS',

Line 997: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',

993: IF (AMS_DEBUG_HIGH_ON) THEN
994: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
995: END IF;
996: ELSE
997: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
998: p_token_name => 'STATUS',
999: p_token_value => l_model_status) ;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;

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

1013: x_is_enabled => l_is_enabled
1014: );
1015: IF l_is_enabled = FALSE THEN
1016: IF (AMS_DEBUG_HIGH_ON) THEN
1017: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot score');
1018: END IF;
1019: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
1020: -- displayed to the user
1021: x_return_status := 'T';

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

1026: dataToPreview (l_tar_score_rec.score_id, l_data_exists_flag);
1027: IF l_data_exists_flag = 'N' THEN
1028: IF (AMS_DEBUG_HIGH_ON) THEN
1029:
1030: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Score');
1031: END IF;
1032: -- Set x_return_status to 'D' (for data error). This will results in a different message
1033: -- displayed to the user
1034: x_return_status := 'D';

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

1055: -- to be displayed on a custom confirmation message.
1056: l_run_started := 'Y';
1057: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_score_rec.wf_itemkey, 'NO');
1058: IF (AMS_DEBUG_HIGH_ON) THEN
1059: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1060: END IF;
1061: ELSE
1062: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
1063: p_token_name => 'STATUS',

Line 1062: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',

1058: IF (AMS_DEBUG_HIGH_ON) THEN
1059: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1060: END IF;
1061: ELSE
1062: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
1063: p_token_name => 'STATUS',
1064: p_token_value => l_model_status) ;
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;

Line 1072: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Scoring Run is currently previewing');

1068: ELSIF l_reference_rec.status_code = G_STATUS_PREVIEWING AND l_reference_rec.scheduled_date <> FND_API.G_MISS_DATE THEN
1069:
1070: -- if the Scoring Run is PREVIEWING, then cancel the preview process first and set the Scoring Run status to DRAFT
1071: IF (AMS_DEBUG_HIGH_ON) THEN
1072: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Scoring Run is currently previewing');
1073: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to cancel Preview Process. Item Key ' || l_tar_score_rec.wf_itemkey);
1074: END IF;
1075:
1076: -- First check that Model is still AVAILABLE

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

1069:
1070: -- if the Scoring Run is PREVIEWING, then cancel the preview process first and set the Scoring Run status to DRAFT
1071: IF (AMS_DEBUG_HIGH_ON) THEN
1072: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Scoring Run is currently previewing');
1073: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to cancel Preview Process. Item Key ' || l_tar_score_rec.wf_itemkey);
1074: END IF;
1075:
1076: -- First check that Model is still AVAILABLE
1077: wf_checkModelStatus ( p_score_id => l_tar_score_rec.score_id,

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

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 score');
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 1104: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');

1100: dataToPreview (l_tar_score_rec.score_id, l_data_exists_flag);
1101: IF l_data_exists_flag = 'N' THEN
1102: IF (AMS_DEBUG_HIGH_ON) THEN
1103:
1104: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Build');
1105: END IF;
1106: -- Set x_return_status to 'D' (for data error). This will results in a different message
1107: -- displayed to the user
1108: x_return_status := 'D';

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

1139: x_return_status := 'W';
1140: RETURN;
1141: END IF;
1142: IF (AMS_DEBUG_HIGH_ON) THEN
1143: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' New Item Key ' || l_tar_score_rec.wf_itemkey);
1144: END IF;
1145:
1146: -- Construct the URL that could be used to monitor the WF process. This will be returned to the caller
1147: -- to be displayed on a custom confirmation message.

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

1148: l_run_started := 'Y';
1149: l_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_score_rec.wf_itemkey, 'NO');
1150: IF (AMS_DEBUG_HIGH_ON) THEN
1151:
1152: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1153: END IF;
1154: ELSE
1155: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
1156: p_token_name => 'STATUS',

Line 1155: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',

1151:
1152: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_monitor_url = ' || l_monitor_url );
1153: END IF;
1154: ELSE
1155: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_MODEL_NOT_AVAILABLE',
1156: p_token_name => 'STATUS',
1157: p_token_value => l_model_status) ;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END IF;

Line 1208: AMS_UTILITY_PVT.debug_message('Private API: Validate_Score');

1204: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1205: -- Debug message
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207:
1208: AMS_UTILITY_PVT.debug_message('Private API: Validate_Score');
1209: END IF;
1210:
1211: -- Invoke validation procedures
1212: Validate_Score (

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

1227:
1228: -- Debug Message
1229: IF (AMS_DEBUG_LOW_ON) THEN
1230:
1231: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler',FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1232: END IF;
1233:
1234: BEGIN
1235: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Update_Row)

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

1280: p_ATTRIBUTE15 => l_tar_score_rec.ATTRIBUTE15
1281: );
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
1285: RAISE FND_API.G_EXC_ERROR;
1286: END;
1287:
1288: x_object_version_number := p_score_rec.object_version_number + 1;

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

1299:
1300: -- Debug Message
1301: IF (AMS_DEBUG_HIGH_ON) THEN
1302:
1303: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1304: END IF;
1305:
1306: -- Standard call to get message count and if count is 1, get message info.
1307: FND_MSG_PUB.Count_And_Get

Line 1319: WHEN AMS_Utility_PVT.resource_locked THEN

1315: END IF;
1316:
1317: EXCEPTION
1318:
1319: WHEN AMS_Utility_PVT.resource_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;

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

1403:
1404: -- Debug Message
1405: IF (AMS_DEBUG_HIGH_ON) THEN
1406:
1407: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1408: END IF;
1409:
1410:
1411: -- Initialize API return status to SUCCESS

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

1414: IF (AMS_DEBUG_HIGH_ON) THEN
1415:
1416:
1417:
1418: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
1419:
1420: END IF;
1421:
1422: Open c_obj_version(P_score_ID);

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

1434: END IF;
1435: -- Debug Message
1436: IF (AMS_DEBUG_HIGH_ON) THEN
1437:
1438: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
1439: END IF;
1440: Close c_obj_version;
1441:
1442: --

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

1454: IF (AMS_DEBUG_HIGH_ON) THEN
1455:
1456:
1457:
1458: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1459:
1460: END IF;
1461: -- Debug Message
1462: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Delete_Row)

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

1475:
1476: -- Debug Message
1477: IF (AMS_DEBUG_HIGH_ON) THEN
1478:
1479: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1480: END IF;
1481:
1482: -- Standard call to get message count and if count is 1, get message info.
1483: FND_MSG_PUB.Count_And_Get

Line 1490: WHEN AMS_Utility_PVT.resource_locked THEN

1486: );
1487:
1488: EXCEPTION
1489:
1490: WHEN AMS_Utility_PVT.resource_locked THEN
1491: x_return_status := FND_API.g_ret_sts_error;
1492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1493: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1494: FND_MSG_PUB.add;

Line 1558: AMS_UTILITY_PVT.debug_message('Private API:check_Score_uk_items');

1554:
1555: BEGIN
1556: IF (AMS_DEBUG_HIGH_ON) THEN
1557:
1558: AMS_UTILITY_PVT.debug_message('Private API:check_Score_uk_items');
1559: END IF;
1560:
1561: x_return_status := FND_API.g_ret_sts_success;
1562: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1563: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1559: END IF;
1560:
1561: x_return_status := FND_API.g_ret_sts_success;
1562: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1563: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1564: 'AMS_DM_SCORES_ALL_B',
1565: 'SCORE_ID = ''' || p_score_rec.score_id ||''''
1566: );
1567: ELSE

Line 1568: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1564: 'AMS_DM_SCORES_ALL_B',
1565: 'SCORE_ID = ''' || p_score_rec.score_id ||''''
1566: );
1567: ELSE
1568: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1569: 'AMS_DM_scoreS_ALL_B',
1570: 'score_ID = ''' || p_score_rec.score_id ||
1571: ''' AND score_ID <> ' || p_score_rec.score_id
1572: );

Line 1617: AMS_UTILITY_PVT.debug_message('Private API:check_Score_req_items');

1613: IS
1614: BEGIN
1615: IF (AMS_DEBUG_HIGH_ON) THEN
1616:
1617: AMS_UTILITY_PVT.debug_message('Private API:check_Score_req_items');
1618: END IF;
1619: x_return_status := FND_API.g_ret_sts_success;
1620: IF (AMS_DEBUG_HIGH_ON) THEN
1621:

Line 1622: AMS_UTILITY_PVT.debug_message('Private API:mode ' || p_validation_mode);

1618: END IF;
1619: x_return_status := FND_API.g_ret_sts_success;
1620: IF (AMS_DEBUG_HIGH_ON) THEN
1621:
1622: AMS_UTILITY_PVT.debug_message('Private API:mode ' || p_validation_mode);
1623: END IF;
1624:
1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1626: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1628: AMS_UTILITY_PVT.debug_message('Private API: id ' || p_score_rec.score_id);

1624:
1625: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1626: IF (AMS_DEBUG_HIGH_ON) THEN
1627:
1628: AMS_UTILITY_PVT.debug_message('Private API: id ' || p_score_rec.score_id);
1629: END IF;
1630: IF p_score_rec.model_id = FND_API.g_miss_num
1631: OR p_score_rec.model_id IS NULL THEN
1632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1682: AMS_Utility_PVT.error_message ('AMS_SCORE_NO_OBJECT_VERSION');

1678: x_return_status := FND_API.g_ret_sts_error;
1679: END IF;
1680:
1681: IF p_score_rec.object_version_number IS NULL OR p_score_rec.object_version_number = FND_API.G_MISS_NUM THEN
1682: AMS_Utility_PVT.error_message ('AMS_SCORE_NO_OBJECT_VERSION');
1683: x_return_status := FND_API.g_ret_sts_error;
1684: END IF;
1685:
1686: IF p_score_rec.model_id IS NULL THEN

Line 1724: AMS_UTILITY_PVT.debug_message('Private API:check_Score_fk_items');

1720: IS
1721: BEGIN
1722: IF (AMS_DEBUG_HIGH_ON) THEN
1723:
1724: AMS_UTILITY_PVT.debug_message('Private API:check_Score_fk_items');
1725: END IF;
1726: x_return_status := FND_API.g_ret_sts_success;
1727:
1728: --------------------model_id---------------------------

Line 1730: IF AMS_Utility_PVT.check_fk_exists(

1726: x_return_status := FND_API.g_ret_sts_success;
1727:
1728: --------------------model_id---------------------------
1729: IF p_score_rec.model_id <> FND_API.g_miss_num THEN
1730: IF AMS_Utility_PVT.check_fk_exists(
1731: 'AMS_DM_MODELS_ALL_B',
1732: 'MODEL_ID',
1733: p_score_rec.model_id
1734: ) = FND_API.g_false

Line 1747: IF AMS_Utility_PVT.check_fk_exists(

1743: END IF;
1744:
1745: --------------------- user_status_id ------------------------
1746: IF p_score_rec.user_status_id <> FND_API.g_miss_num THEN
1747: IF AMS_Utility_PVT.check_fk_exists(
1748: 'AMS_USER_STATUSES_B',
1749: 'USER_STATUS_ID',
1750: p_score_rec.user_status_id
1751: ) = FND_API.g_false

Line 1771: AMS_UTILITY_PVT.debug_message('Private API:check_Score_lookup_items');

1767: IS
1768: BEGIN
1769: IF (AMS_DEBUG_HIGH_ON) THEN
1770:
1771: AMS_UTILITY_PVT.debug_message('Private API:check_Score_lookup_items');
1772: END IF;
1773: x_return_status := FND_API.g_ret_sts_success;
1774:
1775: ------------------ status_code ----------------------------------

Line 1777: IF AMS_Utility_PVT.check_lookup_exists(

1773: x_return_status := FND_API.g_ret_sts_success;
1774:
1775: ------------------ status_code ----------------------------------
1776: IF p_score_rec.status_code <> FND_API.g_miss_char THEN
1777: IF AMS_Utility_PVT.check_lookup_exists(
1778: p_lookup_type => G_STATUS_TYPE_SCORE,
1779: p_lookup_code => p_score_rec.status_code
1780: ) = FND_API.g_false
1781: THEN

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

1844: l_min_rec NUMBER;
1845: BEGIN
1846: l_min_rec := TO_NUMBER (p_score_rec.min_records);
1847: IF l_min_rec < 0 THEN
1848: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MIN_RECORDS');
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: RETURN;
1851: END IF;
1852: EXCEPTION

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

1850: RETURN;
1851: END IF;
1852: EXCEPTION
1853: WHEN VALUE_ERROR THEN
1854: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MIN_RECORDS');
1855: x_return_status := FND_API.G_RET_STS_ERROR;
1856: RETURN;
1857: END;
1858: END IF;

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

1864: l_max_rec NUMBER;
1865: BEGIN
1866: l_max_rec := TO_NUMBER (p_score_rec.max_records);
1867: IF l_max_rec < 0 THEN
1868: AMS_Utility_PVT.error_message ('AMS_DM_NEGATIVE_NUMBER' , 'FIELD' , 'MAX_RECORDS');
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: RETURN;
1871: END IF;
1872: EXCEPTION

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

1870: RETURN;
1871: END IF;
1872: EXCEPTION
1873: WHEN VALUE_ERROR THEN
1874: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'MAX_RECORDS');
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: RETURN;
1877: END;
1878: END IF;

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

2126:
2127: -- Debug Message
2128: IF (AMS_DEBUG_HIGH_ON) THEN
2129:
2130: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
2131: END IF;
2132:
2133: -- Standard call to check for call compatibility.
2134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

2180:
2181: -- Debug Message
2182: IF (AMS_DEBUG_HIGH_ON) THEN
2183:
2184: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2185: END IF;
2186:
2187: -- Standard call to get message count and if count is 1, get message info.
2188: FND_MSG_PUB.Count_And_Get

Line 2194: WHEN AMS_Utility_PVT.resource_locked THEN

2190: p_data => x_msg_data
2191: );
2192: EXCEPTION
2193:
2194: WHEN AMS_Utility_PVT.resource_locked THEN
2195: x_return_status := FND_API.g_ret_sts_error;
2196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2197: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2198: FND_MSG_PUB.add;

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

2265:
2266: -- Debug Message
2267: IF (AMS_DEBUG_HIGH_ON) THEN
2268:
2269: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2270: END IF;
2271:
2272: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2273: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

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

2269: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2270: END IF;
2271:
2272: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2273: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2274:
2275: OPEN c_reference(p_score_rec.score_id);
2276: FETCH c_reference INTO l_reference_rec;
2277: CLOSE c_reference;

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

2292: p_user_or_role_id => l_context_resource_id
2293: );
2294:
2295: IF l_is_owner = 'N' AND NOT AMS_Access_PVT.Check_Admin_Access(l_context_resource_id) THEN
2296: AMS_Utility_PVT.error_message ('AMS_PRIC_UPDT_OWNER_PERM');
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: END IF;
2299: END IF;
2300: END IF;

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

2311: BEGIN
2312: l_min_rec := TO_NUMBER (p_score_rec.min_records);
2313: l_max_rec := TO_NUMBER (p_score_rec.max_records);
2314: IF l_max_rec < l_min_rec THEN
2315: AMS_Utility_PVT.error_message ('AMS_DM_MIN_MORE_THAN_MAX');
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: RETURN;
2318: END IF;
2319: END;

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

2323: -- and it must be greater than 0
2324: IF p_score_rec.row_selection_type = 'NTH_RECORD' THEN
2325: IF p_score_rec.every_nth_row IS NULL OR
2326: p_score_rec.every_nth_row = FND_API.g_miss_num THEN
2327: AMS_Utility_PVT.error_message ('AMS_DM_NO_NTH_RECORD');
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: RETURN;
2330: END IF;
2331: --check for valid number

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

2333: l_nth_row NUMBER;
2334: BEGIN
2335: l_nth_row := ROUND(TO_NUMBER (p_score_rec.every_nth_row));
2336: IF l_nth_row <= 0 THEN
2337: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_NTH_ROW');
2338: x_return_status := FND_API.G_RET_STS_ERROR;
2339: RETURN;
2340: END IF;
2341: EXCEPTION

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

2339: RETURN;
2340: END IF;
2341: EXCEPTION
2342: WHEN VALUE_ERROR THEN
2343: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'EVERY_NTH_ROW');
2344: x_return_status := FND_API.G_RET_STS_ERROR;
2345: RETURN;
2346: END;
2347: END IF;

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

2350: -- and it must be between 0 and 100
2351: IF p_score_rec.row_selection_type = 'RANDOM' THEN
2352: IF p_score_rec.pct_random IS NULL OR
2353: p_score_rec.pct_random = FND_API.g_miss_num THEN
2354: AMS_Utility_PVT.error_message ('AMS_DM_NO_PCT_RANDOM');
2355: x_return_status := FND_API.G_RET_STS_ERROR;
2356: RETURN;
2357: END IF;
2358: --check for valid number

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

2360: l_pct_random NUMBER;
2361: BEGIN
2362: l_pct_random := TO_NUMBER (p_score_rec.pct_random);
2363: IF l_pct_random <= 0 OR l_pct_random > 100 THEN
2364: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_PCT_RANDOM');
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: RETURN;
2367: END IF;
2368: EXCEPTION

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

2366: RETURN;
2367: END IF;
2368: EXCEPTION
2369: WHEN VALUE_ERROR THEN
2370: AMS_Utility_PVT.error_message ('AMS_DM_NOT_NUMBER' , 'FIELD' , 'PCT_RANDOM');
2371: x_return_status := FND_API.G_RET_STS_ERROR;
2372: RETURN;
2373: END;
2374: END IF;

Line 2398: ams_utility_pvt.debug_message ('score id: ' || p_score_rec.score_id || ' owner: ' || fnd_global.user_id);

2394: IF (AMS_DEBUG_HIGH_ON) THEN
2395:
2396:
2397:
2398: ams_utility_pvt.debug_message ('score id: ' || p_score_rec.score_id || ' owner: ' || fnd_global.user_id);
2399:
2400: END IF;
2401: -- validate access privileges
2402: IF AMS_Access_PVT.check_update_access (

Line 2405: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),

2401: -- validate access privileges
2402: IF AMS_Access_PVT.check_update_access (
2403: p_object_id => p_score_rec.score_id,
2404: p_object_type => G_OBJECT_TYPE_SCORE,
2405: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),
2406: p_user_or_role_type => L_ACCESS_TYPE_USER) = 'N' THEN
2407: AMS_Utility_PVT.error_message ('AMS_SCOR_NO_UPDATE_ACCESS');
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409: END IF;

Line 2407: AMS_Utility_PVT.error_message ('AMS_SCOR_NO_UPDATE_ACCESS');

2403: p_object_id => p_score_rec.score_id,
2404: p_object_type => G_OBJECT_TYPE_SCORE,
2405: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),
2406: p_user_or_role_type => L_ACCESS_TYPE_USER) = 'N' THEN
2407: AMS_Utility_PVT.error_message ('AMS_SCOR_NO_UPDATE_ACCESS');
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409: END IF;
2410: END check_access;
2411:

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

2548: )
2549: IS
2550: L_SCORE_QUALIFIER CONSTANT VARCHAR2(30) := 'SCOR';
2551: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
2552: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
2553:
2554: l_proceedWithPreviewFlag VARCHAR2(1);
2555: l_data_exists_flag VARCHAR2(1);
2556: l_target_id NUMBER;

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

2577: BEGIN
2578: -- Debug Message
2579: IF (AMS_DEBUG_HIGH_ON) THEN
2580:
2581: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
2582: END IF;
2583:
2584: -- Initialize API return status to SUCCESS
2585: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2609: x_is_enabled => l_is_enabled
2610: );
2611: IF l_is_enabled = FALSE THEN
2612: IF (AMS_DEBUG_HIGH_ON) THEN
2613: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Target is disabled, cannot preview');
2614: END IF;
2615: -- Set x_return_status to 'T' (for target disabled error). This will results in a different message
2616: -- displayed to the user
2617: x_return_status := 'T';

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

2622: proceedWithPreview (p_score_id, l_proceedWithPreviewFlag);
2623: IF l_proceedWithPreviewFlag = 'N' THEN
2624: IF (AMS_DEBUG_HIGH_ON) THEN
2625:
2626: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Cannot Proceed with Preview');
2627: END IF;
2628: -- Set x_return_status to expected error. This will results in a different message
2629: -- displayed to the user
2630: x_return_status := FND_API.G_RET_STS_ERROR;

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

2634: dataToPreview (p_score_id, l_data_exists_flag);
2635: IF l_data_exists_flag = 'N' THEN
2636: IF (AMS_DEBUG_HIGH_ON) THEN
2637:
2638: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' No Data Selections to Preview');
2639: END IF;
2640: -- Set x_return_status to 'D' (for data error). This will results in a different message
2641: -- displayed to the user
2642: x_return_status := 'D';

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

2652:
2653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2654: IF (AMS_DEBUG_HIGH_ON) THEN
2655:
2656: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Error from wf_startPreviewProcess');
2657: END IF;
2658: -- Set x_return_status to unexpected error. This will results in a different message
2659: -- displayed to the user
2660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2680:
2681: -- Debug Message
2682: IF (AMS_DEBUG_HIGH_ON) THEN
2683:
2684: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
2685: END IF;
2686:
2687: END handle_preview_request;
2688:

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

2796: IF (AMS_DEBUG_HIGH_ON) THEN
2797:
2798:
2799:
2800: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
2801:
2802: END IF;
2803:
2804: -- Initialize API return status to SUCCESS

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

2967:
2968: -- Debug Message
2969: IF (AMS_DEBUG_HIGH_ON) THEN
2970:
2971: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2972: END IF;
2973:
2974: -- Standard call to get message count and if count is 1, get message info.
2975: FND_MSG_PUB.Count_And_Get (

Line 3138: AMS_Utility_PVT.get_user_timezone (

3134: -- used with get_user_timezone api
3135: l_user_timezone_name VARCHAR2(80);
3136: BEGIN
3137: IF p_scheduled_timezone_id IS NULL THEN
3138: AMS_Utility_PVT.get_user_timezone (
3139: x_return_status => x_return_status,
3140: x_user_time_id => x_tar_score_rec.scheduled_timezone_id,
3141: x_user_time_name => l_user_timezone_name
3142: );

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

3203: BEGIN
3204: -- Debug Message
3205: IF (AMS_DEBUG_HIGH_ON) THEN
3206:
3207: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3208: END IF;
3209:
3210: AMS_Utility_PVT.create_log (
3211: x_return_status => l_return_status,

Line 3210: AMS_Utility_PVT.create_log (

3206:
3207: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3208: END IF;
3209:
3210: AMS_Utility_PVT.create_log (
3211: x_return_status => l_return_status,
3212: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3213: p_log_used_by_id => p_score_id,
3214: p_msg_data => L_API_NAME || ': Begin'

Line 3247: AMS_Utility_PVT.create_log (

3243: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3245: -- Report that an error occurred, but ifgnore it and proceed with re-setting
3246: -- the Scoring Run status.
3247: AMS_Utility_PVT.create_log (
3248: x_return_status => l_return_status,
3249: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3250: p_log_used_by_id => p_score_id,
3251: p_msg_data => L_API_NAME || ': Error while canceling Scoring Run process'

Line 3255: AMS_Utility_PVT.create_log (

3251: p_msg_data => L_API_NAME || ': Error while canceling Scoring Run process'
3252: );
3253: --RAISE FND_API.G_EXC_ERROR;
3254: ELSE
3255: AMS_Utility_PVT.create_log (
3256: x_return_status => l_return_status,
3257: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3258: p_log_used_by_id => p_score_id,
3259: p_msg_data => L_API_NAME || ': Successfully canceled Scoring Run Process'

Line 3327: AMS_Utility_PVT.create_log (

3323: -- Set x_return_status to expected error. This will results in a different message
3324: -- displayed to the user
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326:
3327: AMS_Utility_PVT.create_log (
3328: x_return_status => l_return_status,
3329: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3330: p_log_used_by_id => p_score_id,
3331: p_msg_data => L_API_NAME || ': No Scoring Run process to cancel'

Line 3340: AMS_Utility_PVT.create_log (

3336: -- Set x_return_status to expected error. This will results in a different message
3337: -- displayed to the user
3338: x_return_status := FND_API.G_RET_STS_ERROR;
3339:
3340: AMS_Utility_PVT.create_log (
3341: x_return_status => l_return_status,
3342: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3343: p_log_used_by_id => p_score_id,
3344: p_msg_data => L_API_NAME || ': No Scoring Run process to cancel'

Line 3348: AMS_Utility_PVT.create_log (

3344: p_msg_data => L_API_NAME || ': No Scoring Run process to cancel'
3345: );
3346: END IF;
3347:
3348: AMS_Utility_PVT.create_log (
3349: x_return_status => l_return_status,
3350: p_arc_log_used_by => G_OBJECT_TYPE_SCORE,
3351: p_log_used_by_id => p_score_id,
3352: p_msg_data => L_API_NAME || ': End'

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

3354:
3355: -- Debug Message
3356: IF (AMS_DEBUG_HIGH_ON) THEN
3357:
3358: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
3359: END IF;
3360:
3361: END cancel_run_request;
3362:

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

3376:
3377: -- Debug Message
3378: IF (AMS_DEBUG_HIGH_ON) THEN
3379:
3380: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3381: END IF;
3382:
3383: -- fix for bug 4961279. changed get_user_timezone to get_system_timezone
3384: AMS_Utility_PVT.get_system_timezone (

Line 3384: AMS_Utility_PVT.get_system_timezone (

3380: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3381: END IF;
3382:
3383: -- fix for bug 4961279. changed get_user_timezone to get_system_timezone
3384: AMS_Utility_PVT.get_system_timezone (
3385: x_return_status => x_return_status,
3386: x_sys_time_id => x_tar_score_rec.scheduled_timezone_id,
3387: x_sys_time_name => l_user_timezone_name
3388: );

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

3415: );
3416:
3417: -- Debug Message
3418: IF (AMS_DEBUG_HIGH_ON) THEN
3419: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
3420: END IF;
3421:
3422: END wf_startPreviewProcess;
3423:

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

3433: BEGIN
3434:
3435: -- Debug Message
3436: IF (AMS_DEBUG_HIGH_ON) THEN
3437: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3438: END IF;
3439:
3440: -- Remove DM Source records
3441: delete /*+ index(AMS_DM_SOURCE AMS_DM_SOURCE_U2) */ from ams_dm_source

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

3456: WHERE score_id = p_score_id;
3457:
3458: -- Debug Message
3459: IF (AMS_DEBUG_HIGH_ON) THEN
3460: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');
3461: END IF;
3462:
3463: END cleanupPreviousScoreData;
3464:

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

3496:
3497: -- Debug Message
3498: IF (AMS_DEBUG_HIGH_ON) THEN
3499:
3500: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3501: END IF;
3502:
3503: -- Initialize x_data_exists_flag to 'Y'
3504: x_data_exists_flag := 'Y';

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

3516:
3517: -- Debug Message
3518: IF (AMS_DEBUG_HIGH_ON) THEN
3519:
3520: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' l_seeded_ds_flag = ' || l_seeded_ds_flag);
3521: END IF;
3522:
3523: IF l_seeded_ds_flag = 'Y' THEN
3524:

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

3537:
3538: -- Debug Message
3539: IF (AMS_DEBUG_HIGH_ON) THEN
3540:
3541: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. x_data_exists_flag = ' || x_data_exists_flag);
3542: END IF;
3543:
3544: END dataToPreview;
3545:

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

3565:
3566: -- Debug Message
3567: IF (AMS_DEBUG_HIGH_ON) THEN
3568:
3569: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3570: END IF;
3571:
3572: -- Initialize proceed flag to 'Y'
3573: x_proceed_flag := 'Y';

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

3577:
3578: -- Debug Message
3579: IF (AMS_DEBUG_HIGH_ON) THEN
3580:
3581: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Status Code = ' || l_status_code);
3582: END IF;
3583:
3584: IF l_status_code = G_STATUS_SCHEDULED OR
3585: l_status_code = G_STATUS_SCORING OR

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

3592:
3593: -- Debug Message
3594: IF (AMS_DEBUG_HIGH_ON) THEN
3595:
3596: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Proceed Flag = ' || x_proceed_flag);
3597: END IF;
3598:
3599: END proceedWithPreview;
3600:

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

3624:
3625: -- Debug Message
3626: IF (AMS_DEBUG_HIGH_ON) THEN
3627:
3628: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
3629: END IF;
3630:
3631: -- Get the model status
3632: OPEN c_score_status (p_score_id);

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

3635:
3636: -- Debug Message
3637: IF (AMS_DEBUG_HIGH_ON) THEN
3638:
3639: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Model Status Code = ' || x_status_code);
3640: END IF;
3641:
3642: END getScoreStatus;
3643:

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

3666: BEGIN
3667: -- Debug Message
3668: IF (AMS_DEBUG_HIGH_ON) THEN
3669:
3670: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');
3671: END IF;
3672:
3673: x_selections_changed_flag := 'N';
3674:

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

3715:
3716: -- Debug Message
3717: IF (AMS_DEBUG_HIGH_ON) THEN
3718:
3719: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End. Selections Changed Flag = ' || x_selections_changed_flag);
3720: END IF;
3721:
3722: END check_data_size_changes;
3723:

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

3792: BEGIN
3793: -- Debug Message
3794: IF (AMS_DEBUG_HIGH_ON) THEN
3795:
3796: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Begin.');
3797: END IF;
3798:
3799: -- Load the score record to get the original status
3800: OPEN c_ref_score (p_score_id);

Line 3834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Invalidated Scoring Run.');

3830: IF (AMS_DEBUG_HIGH_ON) THEN
3831:
3832:
3833:
3834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Invalidated Scoring Run.');
3835:
3836: END IF;
3837:
3838: END IF;

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

3839:
3840: -- Debug Message
3841: IF (AMS_DEBUG_HIGH_ON) THEN
3842:
3843: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End.');
3844: END IF;
3845:
3846: END handle_data_selection_changes;
3847: