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

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

118:
119:
120:
121:
122: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
123:
124:
125: END IF;
126:

Line 158: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

154: IF FND_GLOBAL.User_Id IS NULL
155:
156: THEN
157:
158: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 167: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Rule');

163: THEN
164: -- Debug message
165: IF (AMS_DEBUG_HIGH_ON) THEN
166:
167: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Rule');
168: END IF;
169:
170: -- Invoke validation procedures
171:

Line 194: AMS_UTILITY_PVT.debug_message('posting_id, rulegroup_id :' || p_ps_rules_rec.posting_id||' '||p_ps_rules_rec.rulegroup_id);

190: IF (AMS_DEBUG_HIGH_ON) THEN
191:
192:
193:
194: AMS_UTILITY_PVT.debug_message('posting_id, rulegroup_id :' || p_ps_rules_rec.posting_id||' '||p_ps_rules_rec.rulegroup_id);
195:
196: END IF;
197: IF (AMS_DEBUG_HIGH_ON) THEN
198:

Line 199: AMS_UTILITY_PVT.debug_message('CLAUSEVALUE2,CLAUSEVALUE3 :' || p_ps_rules_rec.CLAUSEVALUE2||' '||p_ps_rules_rec.CLAUSEVALUE3 );

195:
196: END IF;
197: IF (AMS_DEBUG_HIGH_ON) THEN
198:
199: AMS_UTILITY_PVT.debug_message('CLAUSEVALUE2,CLAUSEVALUE3 :' || p_ps_rules_rec.CLAUSEVALUE2||' '||p_ps_rules_rec.CLAUSEVALUE3 );
200: END IF;
201:
202: SELECT COUNT(1) into l_no_of_records FROM AMS_IBA_PS_RULES ps_rule
203: WHERE (ps_rule.posting_id = p_ps_rules_rec.posting_id AND ps_rule.rulegroup_id = p_ps_rules_rec.rulegroup_id

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

212:
213: -- Debug Message
214: IF (AMS_DEBUG_HIGH_ON) THEN
215:
216: AMS_UTILITY_PVT.debug_message('Private API: Calling create table handler');
217: END IF;
218:
219: -- update strategy_id and exec_priority for new Segment and List rows
220:

Line 227: AMS_UTILITY_PVT.debug_message('posting_id, rulegroup_id :'|| p_ps_rules_rec.posting_id||' '||p_ps_rules_rec.rulegroup_id);

223: IF (AMS_DEBUG_HIGH_ON) THEN
224:
225:
226:
227: AMS_UTILITY_PVT.debug_message('posting_id, rulegroup_id :'|| p_ps_rules_rec.posting_id||' '||p_ps_rules_rec.rulegroup_id);
228:
229: END IF;
230:
231:

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

454:
455: -- Debug Message
456: IF (AMS_DEBUG_HIGH_ON) THEN
457:
458: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
459: END IF;
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get

Line 470: WHEN AMS_Utility_PVT.resource_locked THEN

466:
467:
468: EXCEPTION
469:
470: WHEN AMS_Utility_PVT.resource_locked THEN
471: x_return_status := FND_API.g_ret_sts_error;
472: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
473:
474: WHEN FND_API.G_EXC_ERROR THEN

Line 472: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

468: EXCEPTION
469:
470: WHEN AMS_Utility_PVT.resource_locked THEN
471: x_return_status := FND_API.g_ret_sts_error;
472: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
473:
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO CREATE_Ps_Rule_PVT;
476: x_return_status := FND_API.G_RET_STS_ERROR;

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

561:
562: -- Debug Message
563: IF (AMS_DEBUG_HIGH_ON) THEN
564:
565: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
566: END IF;
567:
568: -- Initialize API return status to SUCCESS
569: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

570:
571: -- Debug Message
572: IF (AMS_DEBUG_HIGH_ON) THEN
573:
574: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
575: END IF;
576:
577: OPEN c_object_version(p_ps_rules_rec.rulegroup_id);
578:

Line 582: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

578:
579: FETCH c_object_version INTO l_object_version;
580:
581: If ( c_object_version%NOTFOUND) THEN
582: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
583: p_token_name => 'INFO',
584: p_token_value => 'Rule');
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;

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

589: IF (AMS_DEBUG_HIGH_ON) THEN
590:
591:
592:
593: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
594:
595: END IF;
596: CLOSE c_object_version;
597:

Line 600: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

596: CLOSE c_object_version;
597:
598: IF (p_ps_rules_rec.object_version_number is NULL or
599: p_ps_rules_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
600: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
601: p_token_name => 'COLUMN',
602: p_token_value => 'object_version_number') ;
603: raise FND_API.G_EXC_ERROR;
604: END IF;

Line 608: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

604: END IF;
605:
606: -- Check Whether record has been changed by someone else
607: IF (p_ps_rules_rec.object_version_number <> l_object_version) THEN
608: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
609: p_token_name => 'INFO',
610: p_token_value => 'Rule') ;
611: raise FND_API.G_EXC_ERROR;
612: END IF;

Line 619: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Rule');

615: THEN
616: -- Debug message
617: IF (AMS_DEBUG_HIGH_ON) THEN
618:
619: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Rule');
620: END IF;
621:
622: -- Invoke validation procedures
623: Validate_ps_rule(

Line 653: AMS_UTILITY_PVT.debug_message('Private API: Calling update ');

649:
650: -- Debug Message
651: IF (AMS_DEBUG_HIGH_ON) THEN
652:
653: AMS_UTILITY_PVT.debug_message('Private API: Calling update ');
654: END IF;
655:
656: Update AMS_IBA_PS_RULES
657: SET

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

697:
698: -- Debug Message
699: IF (AMS_DEBUG_HIGH_ON) THEN
700:
701: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
702: END IF;
703:
704: -- Standard call to get message count and if count is 1, get message info.
705: FND_MSG_PUB.Count_And_Get

Line 711: WHEN AMS_Utility_PVT.resource_locked THEN

707: p_data => x_msg_data
708: );
709: EXCEPTION
710:
711: WHEN AMS_Utility_PVT.resource_locked THEN
712: x_return_status := FND_API.g_ret_sts_error;
713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
714:
715: WHEN FND_API.G_EXC_ERROR THEN

Line 713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

709: EXCEPTION
710:
711: WHEN AMS_Utility_PVT.resource_locked THEN
712: x_return_status := FND_API.g_ret_sts_error;
713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
714:
715: WHEN FND_API.G_EXC_ERROR THEN
716: ROLLBACK TO UPDATE_Ps_Rule_PVT;
717: x_return_status := FND_API.G_RET_STS_ERROR;

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

846:
847: -- Debug Message
848: IF (AMS_DEBUG_HIGH_ON) THEN
849:
850: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
851: END IF;
852:
853: -- Initialize API return status to SUCCESS
854: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1073:
1074: -- Debug Message
1075: IF (AMS_DEBUG_HIGH_ON) THEN
1076:
1077: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1078: END IF;
1079:
1080: -- Initialize API return status to SUCCESS
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1085: --
1086: -- Debug Message
1087: IF (AMS_DEBUG_HIGH_ON) THEN
1088:
1089: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
1090: END IF;
1091:
1092: -- Invoke table handler(AMS_IBA_PS_RULES_PKG.Delete_Row)
1093: AMS_IBA_PS_RULES_PKG.Delete_Row(

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

1104:
1105: -- Debug Message
1106: IF (AMS_DEBUG_HIGH_ON) THEN
1107:
1108: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1109: END IF;
1110:
1111: -- Standard call to get message count and if count is 1, get message info.
1112: FND_MSG_PUB.Count_And_Get

Line 1118: WHEN AMS_Utility_PVT.resource_locked THEN

1114: p_data => x_msg_data
1115: );
1116: EXCEPTION
1117:
1118: WHEN AMS_Utility_PVT.resource_locked THEN
1119: x_return_status := FND_API.g_ret_sts_error;
1120: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1121:
1122: WHEN FND_API.G_EXC_ERROR THEN

Line 1120: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1116: EXCEPTION
1117:
1118: WHEN AMS_Utility_PVT.resource_locked THEN
1119: x_return_status := FND_API.g_ret_sts_error;
1120: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1121:
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK TO DELETE_Ps_Rule_PVT;
1124: x_return_status := FND_API.G_RET_STS_ERROR;

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

1192:
1193: -- Debug Message
1194: IF (AMS_DEBUG_HIGH_ON) THEN
1195:
1196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1197: END IF;
1198:
1199: -- Initialize API return status to SUCCESS
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1204: --
1205: -- Debug Message
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207:
1208: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1209: END IF;
1210:
1211: -- Special delete case
1212: DELETE FROM ams_iba_ps_rules

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

1226:
1227: -- Debug Message
1228: IF (AMS_DEBUG_HIGH_ON) THEN
1229:
1230: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1231: END IF;
1232:
1233: -- Standard call to get message count and if count is 1, get message info.
1234: FND_MSG_PUB.Count_And_Get

Line 1240: WHEN AMS_Utility_PVT.resource_locked THEN

1236: p_data => x_msg_data
1237: );
1238: EXCEPTION
1239:
1240: WHEN AMS_Utility_PVT.resource_locked THEN
1241: x_return_status := FND_API.g_ret_sts_error;
1242: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1243:
1244: WHEN FND_API.G_EXC_ERROR THEN

Line 1242: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1238: EXCEPTION
1239:
1240: WHEN AMS_Utility_PVT.resource_locked THEN
1241: x_return_status := FND_API.g_ret_sts_error;
1242: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1243:
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: ROLLBACK TO DELETE_Ps_Rule_PVT;
1246: x_return_status := FND_API.G_RET_STS_ERROR;

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

1306:
1307: -- Debug Message
1308: IF (AMS_DEBUG_HIGH_ON) THEN
1309:
1310: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1311: END IF;
1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )

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

1335: IF (AMS_DEBUG_HIGH_ON) THEN
1336:
1337:
1338:
1339: AMS_Utility_PVT.debug_message(l_full_name||': start');
1340:
1341: END IF;
1342: OPEN c_Ps_Rule;
1343:

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

1360: p_count => x_msg_count,
1361: p_data => x_msg_data);
1362: IF (AMS_DEBUG_HIGH_ON) THEN
1363:
1364: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1365: END IF;
1366: EXCEPTION
1367:
1368: WHEN AMS_Utility_PVT.resource_locked THEN

Line 1368: WHEN AMS_Utility_PVT.resource_locked THEN

1364: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1365: END IF;
1366: EXCEPTION
1367:
1368: WHEN AMS_Utility_PVT.resource_locked THEN
1369: x_return_status := FND_API.g_ret_sts_error;
1370: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1371:
1372: WHEN FND_API.G_EXC_ERROR THEN

Line 1370: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1366: EXCEPTION
1367:
1368: WHEN AMS_Utility_PVT.resource_locked THEN
1369: x_return_status := FND_API.g_ret_sts_error;
1370: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1371:
1372: WHEN FND_API.G_EXC_ERROR THEN
1373: ROLLBACK TO LOCK_Ps_Rule_PVT;
1374: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1418: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1414:
1415: BEGIN
1416: x_return_status := FND_API.g_ret_sts_success;
1417: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1418: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1419: 'AMS_IBA_PS_RULES',
1420: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||''''
1421: );
1422: ELSE

Line 1423: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1419: 'AMS_IBA_PS_RULES',
1420: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||''''
1421: );
1422: ELSE
1423: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1424: 'AMS_IBA_PS_RULES',
1425: 'RULE_ID = ''' || p_ps_rules_rec.RULE_ID ||
1426: ''' AND RULE_ID <> ' || p_ps_rules_rec.RULE_ID
1427: );

Line 1431: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_RULE_ID_DUPLICATE');

1427: );
1428: END IF;
1429:
1430: IF l_valid_flag = FND_API.g_false THEN
1431: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_RULE_ID_DUPLICATE');
1432: x_return_status := FND_API.g_ret_sts_error;
1433: RETURN;
1434: END IF;
1435:

Line 1451: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_created_by');

1447: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1448:
1449:
1450: IF p_ps_rules_rec.created_by = FND_API.g_miss_num OR p_ps_rules_rec.created_by IS NULL THEN
1451: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_created_by');
1452: x_return_status := FND_API.g_ret_sts_error;
1453: RETURN;
1454: END IF;
1455:

Line 1458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_creation_date');

1454: END IF;
1455:
1456:
1457: IF p_ps_rules_rec.creation_date = FND_API.g_miss_date OR p_ps_rules_rec.creation_date IS NULL THEN
1458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_creation_date');
1459: x_return_status := FND_API.g_ret_sts_error;
1460: RETURN;
1461: END IF;
1462:

Line 1465: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');

1461: END IF;
1462:
1463:
1464: IF p_ps_rules_rec.last_updated_by = FND_API.g_miss_num OR p_ps_rules_rec.last_updated_by IS NULL THEN
1465: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');
1466: x_return_status := FND_API.g_ret_sts_error;
1467: RETURN;
1468: END IF;
1469:

Line 1472: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');

1468: END IF;
1469:
1470:
1471: IF p_ps_rules_rec.last_update_date = FND_API.g_miss_date OR p_ps_rules_rec.last_update_date IS NULL THEN
1472: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');
1473: x_return_status := FND_API.g_ret_sts_error;
1474: RETURN;
1475: END IF;
1476:

Line 1479: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rule_id');

1475: END IF;
1476:
1477:
1478: IF p_ps_rules_rec.rule_id = FND_API.g_miss_num OR p_ps_rules_rec.rule_id IS NULL THEN
1479: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rule_id');
1480: x_return_status := FND_API.g_ret_sts_error;
1481: RETURN;
1482: END IF;
1483:

Line 1486: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rulegroup_id');

1482: END IF;
1483:
1484:
1485: IF p_ps_rules_rec.rulegroup_id = FND_API.g_miss_num OR p_ps_rules_rec.rulegroup_id IS NULL THEN
1486: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rulegroup_id');
1487: x_return_status := FND_API.g_ret_sts_error;
1488: RETURN;
1489: END IF;
1490:

Line 1493: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_posting_id');

1489: END IF;
1490:
1491:
1492: IF p_ps_rules_rec.posting_id = FND_API.g_miss_num OR p_ps_rules_rec.posting_id IS NULL THEN
1493: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_posting_id');
1494: x_return_status := FND_API.g_ret_sts_error;
1495: RETURN;
1496: END IF;
1497:

Line 1500: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_strategy_id');

1496: END IF;
1497:
1498:
1499: IF p_ps_rules_rec.strategy_id = FND_API.g_miss_num OR p_ps_rules_rec.strategy_id IS NULL THEN
1500: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_strategy_id');
1501: x_return_status := FND_API.g_ret_sts_error;
1502: RETURN;
1503: END IF;
1504: ELSE

Line 1508: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_created_by');

1504: ELSE
1505:
1506:
1507: IF p_ps_rules_rec.created_by IS NULL THEN
1508: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_created_by');
1509: x_return_status := FND_API.g_ret_sts_error;
1510: RETURN;
1511: END IF;
1512:

Line 1515: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_creation_date');

1511: END IF;
1512:
1513:
1514: IF p_ps_rules_rec.creation_date IS NULL THEN
1515: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_creation_date');
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;
1519:

Line 1522: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');

1518: END IF;
1519:
1520:
1521: IF p_ps_rules_rec.last_updated_by IS NULL THEN
1522: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_updated_by');
1523: x_return_status := FND_API.g_ret_sts_error;
1524: RETURN;
1525: END IF;
1526:

Line 1529: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');

1525: END IF;
1526:
1527:
1528: IF p_ps_rules_rec.last_update_date IS NULL THEN
1529: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_last_update_date');
1530: x_return_status := FND_API.g_ret_sts_error;
1531: RETURN;
1532: END IF;
1533:

Line 1536: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rule_id');

1532: END IF;
1533:
1534:
1535: IF p_ps_rules_rec.rule_id IS NULL THEN
1536: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rule_id');
1537: x_return_status := FND_API.g_ret_sts_error;
1538: RETURN;
1539: END IF;
1540:

Line 1543: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rulegroup_id');

1539: END IF;
1540:
1541:
1542: IF p_ps_rules_rec.rulegroup_id IS NULL THEN
1543: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_rulegroup_id');
1544: x_return_status := FND_API.g_ret_sts_error;
1545: RETURN;
1546: END IF;
1547:

Line 1550: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_posting_id');

1546: END IF;
1547:
1548:
1549: IF p_ps_rules_rec.posting_id IS NULL THEN
1550: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_posting_id');
1551: x_return_status := FND_API.g_ret_sts_error;
1552: RETURN;
1553: END IF;
1554:

Line 1557: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_strategy_id');

1553: END IF;
1554:
1555:
1556: IF p_ps_rules_rec.strategy_id IS NULL THEN
1557: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_rules_NO_strategy_id');
1558: x_return_status := FND_API.g_ret_sts_error;
1559: RETURN;
1560: END IF;
1561: END IF;

Line 1632: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing filters');

1628: IF (AMS_DEBUG_HIGH_ON) THEN
1629:
1630:
1631:
1632: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing filters');
1633:
1634: END IF;
1635:
1636: DELETE FROM AMS_IBA_PS_RL_ST_FLTRS

Line 1643: AMS_UTILITY_PVT.debug_message('Private API: - deleted existing filters');

1639: IF (AMS_DEBUG_HIGH_ON) THEN
1640:
1641:
1642:
1643: AMS_UTILITY_PVT.debug_message('Private API: - deleted existing filters');
1644:
1645: END IF;
1646:
1647:

Line 1654: AMS_UTILITY_PVT.debug_message('Private API: - adding new filters');

1650: IF (AMS_DEBUG_HIGH_ON) THEN
1651:
1652:
1653:
1654: AMS_UTILITY_PVT.debug_message('Private API: - adding new filters');
1655:
1656: END IF;
1657:
1658: l_index := p_ps_filter_tbl.FIRST;

Line 1708: AMS_UTILITY_PVT.debug_message('Private API: - added new filters');

1704: IF (AMS_DEBUG_HIGH_ON) THEN
1705:
1706:
1707:
1708: AMS_UTILITY_PVT.debug_message('Private API: - added new filters');
1709:
1710: END IF;
1711:
1712: END update_filters;

Line 1746: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing strategy parameters');

1742: IF (AMS_DEBUG_HIGH_ON) THEN
1743:
1744:
1745:
1746: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing strategy parameters');
1747:
1748: END IF;
1749:
1750: DELETE FROM AMS_IBA_PS_RL_ST_PARAMS

Line 1757: AMS_UTILITY_PVT.debug_message('Private API: - deleted existing strategy parameters');

1753: IF (AMS_DEBUG_HIGH_ON) THEN
1754:
1755:
1756:
1757: AMS_UTILITY_PVT.debug_message('Private API: - deleted existing strategy parameters');
1758:
1759: END IF;
1760:
1761:

Line 1768: AMS_UTILITY_PVT.debug_message('Private API: - adding new strategy parameters');

1764: IF (AMS_DEBUG_HIGH_ON) THEN
1765:
1766:
1767:
1768: AMS_UTILITY_PVT.debug_message('Private API: - adding new strategy parameters');
1769:
1770: END IF;
1771:
1772: l_index := p_ps_strategy_tbl.FIRST;

Line 1825: AMS_UTILITY_PVT.debug_message('Private API: - added new strategy parameters');

1821: IF (AMS_DEBUG_HIGH_ON) THEN
1822:
1823:
1824:
1825: AMS_UTILITY_PVT.debug_message('Private API: - added new strategy parameters');
1826:
1827: END IF;
1828:
1829: END update_strategy_params;

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

2010:
2011: -- Debug Message
2012: IF (AMS_DEBUG_HIGH_ON) THEN
2013:
2014: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2015: END IF;
2016:
2017: -- Initialize API return status to SUCCESS
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2019:
2020: -- Debug Message
2021: IF (AMS_DEBUG_HIGH_ON) THEN
2022:
2023: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2024: END IF;
2025:
2026: -- Standard call to get message count and if count is 1, get message info.
2027: FND_MSG_PUB.Count_And_Get

Line 2033: WHEN AMS_Utility_PVT.resource_locked THEN

2029: p_data => x_msg_data
2030: );
2031: EXCEPTION
2032:
2033: WHEN AMS_Utility_PVT.resource_locked THEN
2034: x_return_status := FND_API.g_ret_sts_error;
2035: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2036:
2037: WHEN FND_API.G_EXC_ERROR THEN

Line 2035: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2031: EXCEPTION
2032:
2033: WHEN AMS_Utility_PVT.resource_locked THEN
2034: x_return_status := FND_API.g_ret_sts_error;
2035: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2036:
2037: WHEN FND_API.G_EXC_ERROR THEN
2038: ROLLBACK TO VALIDATE_Ps_Rule_;
2039: x_return_status := FND_API.G_RET_STS_ERROR;

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

2096:
2097: -- Debug Message
2098: IF (AMS_DEBUG_HIGH_ON) THEN
2099:
2100: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2101: END IF;
2102: -- Standard call to get message count and if count is 1, get message info.
2103: FND_MSG_PUB.Count_And_Get
2104: (p_count => x_msg_count,