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

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

101:
102: -- Debug Message
103: IF (AMS_DEBUG_HIGH_ON) THEN
104:
105: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
106: END IF;
107:
108:
109: -- Initialize API return status to SUCCESS

Line 132: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Target Value ID to Insert = ' || l_dm_target_value_rec.TARGET_VALUE_ID);

128: IF (AMS_DEBUG_HIGH_ON) THEN
129:
130:
131:
132: AMS_UTILITY_PVT.debug_message( l_api_name || ' New Target Value ID to Insert = ' || l_dm_target_value_rec.TARGET_VALUE_ID);
133:
134: END IF;
135:
136: -- =========================================================================

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

138: -- =========================================================================
139:
140: IF FND_GLOBAL.User_Id IS NULL
141: THEN
142: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

164:
165: -- Debug Message
166: IF (AMS_DEBUG_HIGH_ON) THEN
167:
168: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
169: END IF;
170:
171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)
172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(

Line 198: AMS_UTILITY_PVT.debug_message( l_api_name || ' Going to activate target: ' || l_dm_target_value_rec.target_id);

194: IF (AMS_DEBUG_HIGH_ON) THEN
195:
196:
197:
198: AMS_UTILITY_PVT.debug_message( l_api_name || ' Going to activate target: ' || l_dm_target_value_rec.target_id);
199:
200: END IF;
201:
202: -- After successfully inserting the target value record, Set the target to Active

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

226:
227: -- Debug Message
228: IF (AMS_DEBUG_HIGH_ON) THEN
229:
230: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
231: END IF;
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get

Line 240: WHEN AMS_Utility_PVT.resource_locked THEN

236: p_data => x_msg_data
237: );
238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
243:
244: WHEN FND_API.G_EXC_ERROR THEN

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

238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Dm_Target_Value_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;

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

316:
317: -- Debug Message
318: IF (AMS_DEBUG_HIGH_ON) THEN
319:
320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
321: END IF;
322:
323: -- Standard call to check for call compatibility.
324: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 345: AMS_UTILITY_PVT.debug_message('Private API: - Going to Complete Record');

341:
342: -- Debug Message
343: IF (AMS_DEBUG_HIGH_ON) THEN
344:
345: AMS_UTILITY_PVT.debug_message('Private API: - Going to Complete Record');
346: END IF;
347:
348:
349: -- Complete missing entries in the record before updating

Line 358: AMS_UTILITY_PVT.debug_message('Private API: - Open Reference Cursor');

354:
355: -- Debug Message
356: IF (AMS_DEBUG_HIGH_ON) THEN
357:
358: AMS_UTILITY_PVT.debug_message('Private API: - Open Reference Cursor');
359: END IF;
360:
361: IF (AMS_DEBUG_HIGH_ON) THEN
362:

Line 365: AMS_UTILITY_PVT.debug_message('target value id: ' || l_tar_dm_target_value_rec.target_value_id);

361: IF (AMS_DEBUG_HIGH_ON) THEN
362:
363:
364:
365: AMS_UTILITY_PVT.debug_message('target value id: ' || l_tar_dm_target_value_rec.target_value_id);
366:
367: END IF;
368:
369: -- get the reference target, which contains

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

371: OPEN c_get_Dm_Target_Value( l_tar_dm_target_value_rec.target_value_id);
372: FETCH c_get_Dm_Target_Value INTO l_ref_dm_target_value_rec ;
373:
374: If ( c_get_Dm_Target_Value%NOTFOUND) THEN
375: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
376: p_token_name => 'INFO',
377: p_token_value => 'Dm_Target_Value') ;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;

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

380:
381: -- Debug Message
382: IF (AMS_DEBUG_HIGH_ON) THEN
383:
384: AMS_UTILITY_PVT.debug_message('Private API: - Close Reference Cursor');
385: END IF;
386: CLOSE c_get_Dm_Target_Value;
387:
388:

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

387:
388:
389: If (l_tar_dm_target_value_rec.object_version_number is NULL or
390: l_tar_dm_target_value_rec.object_version_number = FND_API.G_MISS_NUM ) Then
391: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
392: p_token_name => 'COLUMN',
393: p_token_value => 'Last_Update_Date') ;
394: raise FND_API.G_EXC_ERROR;
395: End if;

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

394: raise FND_API.G_EXC_ERROR;
395: End if;
396: -- Check Whether record has been changed by someone else
397: If (l_tar_dm_target_value_rec.object_version_number <> l_ref_dm_target_value_rec.object_version_number) Then
398: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
399: p_token_name => 'INFO',
400: p_token_value => 'Dm_Target_Value') ;
401: raise FND_API.G_EXC_ERROR;
402: End if;

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

421:
422: -- Debug Message
423: IF (AMS_DEBUG_HIGH_ON) THEN
424:
425: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
426: END IF;
427:
428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)
429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(

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

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

Line 467: WHEN AMS_Utility_PVT.resource_locked THEN

463: p_data => x_msg_data
464: );
465: EXCEPTION
466:
467: WHEN AMS_Utility_PVT.resource_locked THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
470:
471: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

513:
514: -- Debug Message
515: IF (AMS_DEBUG_HIGH_ON) THEN
516:
517: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
518: END IF;
519:
520: --
521: -- Api body

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

532:
533: -- Debug Message
534: IF (AMS_DEBUG_HIGH_ON) THEN
535:
536: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
537: END IF;
538:
539: EXCEPTION
540:

Line 541: WHEN AMS_Utility_PVT.resource_locked THEN

537: END IF;
538:
539: EXCEPTION
540:
541: WHEN AMS_Utility_PVT.resource_locked THEN
542: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
543:
544: WHEN FND_API.G_EXC_ERROR THEN
545: ROLLBACK TO Delete_TgtValues_For_Target;

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

538:
539: EXCEPTION
540:
541: WHEN AMS_Utility_PVT.resource_locked THEN
542: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
543:
544: WHEN FND_API.G_EXC_ERROR THEN
545: ROLLBACK TO Delete_TgtValues_For_Target;
546:

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

622:
623: -- Debug Message
624: IF (AMS_DEBUG_HIGH_ON) THEN
625:
626: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
627: END IF;
628:
629:
630: -- Initialize API return status to SUCCESS

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

635: --
636: -- Debug Message
637: IF (AMS_DEBUG_HIGH_ON) THEN
638:
639: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
640: END IF;
641:
642: -- Get the target id for this target value record before deleting it
643: OPEN c_target_id(p_target_value_id);

Line 651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Before Delete: TARGET_ID = ' || l_target_id );

647: IF (AMS_DEBUG_HIGH_ON) THEN
648:
649:
650:
651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Before Delete: TARGET_ID = ' || l_target_id );
652:
653: END IF;
654:
655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)

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

705:
706: -- Debug Message
707: IF (AMS_DEBUG_HIGH_ON) THEN
708:
709: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
710: END IF;
711:
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get

Line 719: WHEN AMS_Utility_PVT.resource_locked THEN

715: p_data => x_msg_data
716: );
717: EXCEPTION
718:
719: WHEN AMS_Utility_PVT.resource_locked THEN
720: x_return_status := FND_API.g_ret_sts_error;
721: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
722:
723: WHEN FND_API.G_EXC_ERROR THEN

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

717: EXCEPTION
718:
719: WHEN AMS_Utility_PVT.resource_locked THEN
720: x_return_status := FND_API.g_ret_sts_error;
721: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
722:
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO DELETE_Dm_Target_Value_PVT;
725: x_return_status := FND_API.G_RET_STS_ERROR;

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

787:
788: -- Debug Message
789: IF (AMS_DEBUG_HIGH_ON) THEN
790:
791: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
792: END IF;
793:
794: -- Initialize message list if p_init_msg_list is set to TRUE.
795: IF FND_API.to_Boolean( p_init_msg_list )

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

816: IF (AMS_DEBUG_HIGH_ON) THEN
817:
818:
819:
820: AMS_Utility_PVT.debug_message(l_full_name||': start');
821:
822: END IF;
823: OPEN c_Dm_Target_Value;
824:

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

841: p_count => x_msg_count,
842: p_data => x_msg_data);
843: IF (AMS_DEBUG_HIGH_ON) THEN
844:
845: AMS_Utility_PVT.debug_message(l_full_name ||': end');
846: END IF;
847: EXCEPTION
848:
849: WHEN AMS_Utility_PVT.resource_locked THEN

Line 849: WHEN AMS_Utility_PVT.resource_locked THEN

845: AMS_Utility_PVT.debug_message(l_full_name ||': end');
846: END IF;
847: EXCEPTION
848:
849: WHEN AMS_Utility_PVT.resource_locked THEN
850: x_return_status := FND_API.g_ret_sts_error;
851: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
852:
853: WHEN FND_API.G_EXC_ERROR THEN

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

847: EXCEPTION
848:
849: WHEN AMS_Utility_PVT.resource_locked THEN
850: x_return_status := FND_API.g_ret_sts_error;
851: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
852:
853: WHEN FND_API.G_EXC_ERROR THEN
854: ROLLBACK TO LOCK_Dm_Target_Value_PVT;
855: x_return_status := FND_API.G_RET_STS_ERROR;

Line 920: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

916: x_return_status := FND_API.g_ret_sts_success;
917:
918: -- validate uniqueness of primary key
919: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
920: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
921: 'AMS_DM_TARGET_VALUES_B',
922: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||''''
923: );
924: ELSE

Line 925: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

921: 'AMS_DM_TARGET_VALUES_B',
922: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||''''
923: );
924: ELSE
925: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
926: 'AMS_DM_TARGET_VALUES_B',
927: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||
928: ''' AND TARGET_VALUE_ID <> ' || p_dm_target_value_rec.TARGET_VALUE_ID
929: );

Line 933: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_VALUE_ID');

929: );
930: END IF;
931:
932: IF l_valid_flag = FND_API.g_false THEN
933: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_VALUE_ID');
934: x_return_status := FND_API.g_ret_sts_error;
935: RETURN;
936: END IF;
937:

Line 953: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_OPERATOR');

949: CLOSE c_op_value_updt;
950: END IF;
951:
952: IF l_valid_flag = FND_API.g_false THEN
953: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','TARGET_OPERATOR');
954: x_return_status := FND_API.g_ret_sts_error;
955: END IF;
956: END check_uk_items;
957:

Line 973: ams_utility_pvt.debug_message('Private API:check_req_items for CREATE');

969: IF (AMS_DEBUG_HIGH_ON) THEN
970:
971:
972:
973: ams_utility_pvt.debug_message('Private API:check_req_items for CREATE');
974:
975: END IF;
976:
977: IF p_dm_target_value_rec.target_value_id = FND_API.g_miss_num OR p_dm_target_value_rec.target_value_id IS NULL THEN

Line 978: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');

974:
975: END IF;
976:
977: IF p_dm_target_value_rec.target_value_id = FND_API.g_miss_num OR p_dm_target_value_rec.target_value_id IS NULL THEN
978: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');
979: x_return_status := FND_API.g_ret_sts_error;
980: END IF;
981: IF p_dm_target_value_rec.target_id = FND_API.g_miss_num OR p_dm_target_value_rec.target_id IS NULL THEN
982: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

Line 982: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

978: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');
979: x_return_status := FND_API.g_ret_sts_error;
980: END IF;
981: IF p_dm_target_value_rec.target_id = FND_API.g_miss_num OR p_dm_target_value_rec.target_id IS NULL THEN
982: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
983: x_return_status := FND_API.g_ret_sts_error;
984: END IF;
985: IF p_dm_target_value_rec.target_value = FND_API.g_miss_char OR p_dm_target_value_rec.target_value IS NULL THEN
986: --changed rosharma 19-feb-2003 Bug # 2853640

Line 987: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');

983: x_return_status := FND_API.g_ret_sts_error;
984: END IF;
985: IF p_dm_target_value_rec.target_value = FND_API.g_miss_char OR p_dm_target_value_rec.target_value IS NULL THEN
986: --changed rosharma 19-feb-2003 Bug # 2853640
987: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');
988: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');
989: --end change rosharma 19-feb-2003 Bug # 2853640
990: x_return_status := FND_API.g_ret_sts_error;
991: END IF;

Line 988: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');

984: END IF;
985: IF p_dm_target_value_rec.target_value = FND_API.g_miss_char OR p_dm_target_value_rec.target_value IS NULL THEN
986: --changed rosharma 19-feb-2003 Bug # 2853640
987: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');
988: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');
989: --end change rosharma 19-feb-2003 Bug # 2853640
990: x_return_status := FND_API.g_ret_sts_error;
991: END IF;
992: IF p_dm_target_value_rec.target_operator = FND_API.g_miss_char OR p_dm_target_value_rec.target_operator IS NULL THEN

Line 994: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');

990: x_return_status := FND_API.g_ret_sts_error;
991: END IF;
992: IF p_dm_target_value_rec.target_operator = FND_API.g_miss_char OR p_dm_target_value_rec.target_operator IS NULL THEN
993: --changed rosharma 19-feb-2003 Bug # 2853640
994: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');
995: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');
996: --end change rosharma 19-feb-2003 Bug # 2853640
997: x_return_status := FND_API.g_ret_sts_error;
998: END IF;

Line 995: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');

991: END IF;
992: IF p_dm_target_value_rec.target_operator = FND_API.g_miss_char OR p_dm_target_value_rec.target_operator IS NULL THEN
993: --changed rosharma 19-feb-2003 Bug # 2853640
994: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');
995: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');
996: --end change rosharma 19-feb-2003 Bug # 2853640
997: x_return_status := FND_API.g_ret_sts_error;
998: END IF;
999: ELSE

Line 1002: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');

998: END IF;
999: ELSE
1000: IF (AMS_DEBUG_HIGH_ON) THEN
1001:
1002: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');
1003: END IF;
1004: IF p_dm_target_value_rec.target_value_id IS NULL THEN
1005: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');
1006: x_return_status := FND_API.g_ret_sts_error;

Line 1005: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');

1001:
1002: ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');
1003: END IF;
1004: IF p_dm_target_value_rec.target_value_id IS NULL THEN
1005: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');
1006: x_return_status := FND_API.g_ret_sts_error;
1007: END IF;
1008: IF p_dm_target_value_rec.last_update_date IS NULL THEN
1009: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

Line 1009: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

1005: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE_ID');
1006: x_return_status := FND_API.g_ret_sts_error;
1007: END IF;
1008: IF p_dm_target_value_rec.last_update_date IS NULL THEN
1009: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
1010: x_return_status := FND_API.g_ret_sts_error;
1011: END IF;
1012: IF p_dm_target_value_rec.last_updated_by IS NULL THEN
1013: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

Line 1013: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

1009: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');
1010: x_return_status := FND_API.g_ret_sts_error;
1011: END IF;
1012: IF p_dm_target_value_rec.last_updated_by IS NULL THEN
1013: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
1014: x_return_status := FND_API.g_ret_sts_error;
1015: END IF;
1016: IF p_dm_target_value_rec.creation_date IS NULL THEN
1017: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

Line 1017: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');

1013: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');
1014: x_return_status := FND_API.g_ret_sts_error;
1015: END IF;
1016: IF p_dm_target_value_rec.creation_date IS NULL THEN
1017: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
1018: x_return_status := FND_API.g_ret_sts_error;
1019: END IF;
1020: IF p_dm_target_value_rec.created_by IS NULL THEN
1021: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

Line 1021: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');

1017: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATION_DATE');
1018: x_return_status := FND_API.g_ret_sts_error;
1019: END IF;
1020: IF p_dm_target_value_rec.created_by IS NULL THEN
1021: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
1022: x_return_status := FND_API.g_ret_sts_error;
1023: END IF;
1024: IF p_dm_target_value_rec.last_update_login IS NULL THEN
1025: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_LOGIN');

Line 1025: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_LOGIN');

1021: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','CREATED_BY');
1022: x_return_status := FND_API.g_ret_sts_error;
1023: END IF;
1024: IF p_dm_target_value_rec.last_update_login IS NULL THEN
1025: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_LOGIN');
1026: x_return_status := FND_API.g_ret_sts_error;
1027: END IF;
1028: IF p_dm_target_value_rec.object_version_number IS NULL THEN
1029: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');

Line 1029: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');

1025: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_LOGIN');
1026: x_return_status := FND_API.g_ret_sts_error;
1027: END IF;
1028: IF p_dm_target_value_rec.object_version_number IS NULL THEN
1029: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');
1030: x_return_status := FND_API.g_ret_sts_error;
1031: END IF;
1032: IF p_dm_target_value_rec.target_id IS NULL THEN
1033: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

Line 1033: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');

1029: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','OBJECT_VERSION_NUMBER');
1030: x_return_status := FND_API.g_ret_sts_error;
1031: END IF;
1032: IF p_dm_target_value_rec.target_id IS NULL THEN
1033: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_ID');
1034: x_return_status := FND_API.g_ret_sts_error;
1035: END IF;
1036: IF p_dm_target_value_rec.target_value IS NULL THEN
1037: --changed rosharma 19-feb-2003 Bug # 2853640

Line 1038: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');

1034: x_return_status := FND_API.g_ret_sts_error;
1035: END IF;
1036: IF p_dm_target_value_rec.target_value IS NULL THEN
1037: --changed rosharma 19-feb-2003 Bug # 2853640
1038: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');
1039: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');
1040: --end change rosharma 19-feb-2003 Bug # 2853640
1041: x_return_status := FND_API.g_ret_sts_error;
1042: END IF;

Line 1039: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');

1035: END IF;
1036: IF p_dm_target_value_rec.target_value IS NULL THEN
1037: --changed rosharma 19-feb-2003 Bug # 2853640
1038: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_VALUE');
1039: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL');
1040: --end change rosharma 19-feb-2003 Bug # 2853640
1041: x_return_status := FND_API.g_ret_sts_error;
1042: END IF;
1043: IF p_dm_target_value_rec.target_operator IS NULL THEN

Line 1045: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');

1041: x_return_status := FND_API.g_ret_sts_error;
1042: END IF;
1043: IF p_dm_target_value_rec.target_operator IS NULL THEN
1044: --changed rosharma 19-feb-2003 Bug # 2853640
1045: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');
1046: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');
1047: --end change rosharma 19-feb-2003 Bug # 2853640
1048: x_return_status := FND_API.g_ret_sts_error;
1049: END IF;

Line 1046: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');

1042: END IF;
1043: IF p_dm_target_value_rec.target_operator IS NULL THEN
1044: --changed rosharma 19-feb-2003 Bug # 2853640
1045: --AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','TARGET_OPERATOR');
1046: AMS_Utility_PVT.Error_Message('AMS_DM_NO_TARVAL_OP');
1047: --end change rosharma 19-feb-2003 Bug # 2853640
1048: x_return_status := FND_API.g_ret_sts_error;
1049: END IF;
1050: END IF;

Line 1064: IF AMS_Utility_PVT.check_fk_exists(

1060: x_return_status := FND_API.g_ret_sts_success;
1061:
1062: --------------------target_id---------------------------
1063: IF p_dm_target_value_rec.target_id <> FND_API.g_miss_num THEN
1064: IF AMS_Utility_PVT.check_fk_exists(
1065: 'ams_dm_targets_b',
1066: 'target_id',
1067: p_dm_target_value_rec.target_id
1068: ) = FND_API.g_false

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

1066: 'target_id',
1067: p_dm_target_value_rec.target_id
1068: ) = FND_API.g_false
1069: THEN
1070: AMS_Utility_PVT.error_message ('AMS_API_INVALID_FK', 'COLUMN_NAME', 'TARGET_ID');
1071: x_return_status := FND_API.g_ret_sts_error;
1072: END IF;
1073: END IF;
1074:

Line 1087: IF AMS_Utility_PVT.check_lookup_exists(

1083: x_return_status := FND_API.g_ret_sts_success;
1084:
1085: -- target operator --
1086: IF p_dm_target_value_rec.target_operator <> FND_API.g_miss_char THEN
1087: IF AMS_Utility_PVT.check_lookup_exists(
1088: p_lookup_type => 'AMS_DM_TARGET_OPERATORS',
1089: p_lookup_code => p_dm_target_value_rec.target_operator
1090: ) = FND_API.g_false
1091: THEN

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

1296:
1297: -- Debug Message
1298: IF (AMS_DEBUG_HIGH_ON) THEN
1299:
1300: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1301: END IF;
1302:
1303:
1304: -- Initialize API return status to SUCCESS

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

1307:
1308: -- Debug Message
1309: IF (AMS_DEBUG_HIGH_ON) THEN
1310:
1311: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312: END IF;
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get

Line 1321: WHEN AMS_Utility_PVT.resource_locked THEN

1317: p_data => x_msg_data
1318: );
1319: EXCEPTION
1320:
1321: WHEN AMS_Utility_PVT.resource_locked THEN
1322: x_return_status := FND_API.g_ret_sts_error;
1323: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN

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

1319: EXCEPTION
1320:
1321: WHEN AMS_Utility_PVT.resource_locked THEN
1322: x_return_status := FND_API.g_ret_sts_error;
1323: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO VALIDATE_Dm_Target_Value_;
1327: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1384: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_target_value_rec');

1380: BEGIN
1381: -- Debug Message
1382: IF (AMS_DEBUG_HIGH_ON) THEN
1383:
1384: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_target_value_rec');
1385: END IF;
1386:
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF FND_API.to_Boolean( p_init_msg_list )

Line 1403: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_NO_BETWEEN');

1399: p_dm_target_value_rec.target_operator <> FND_API.g_miss_char THEN
1400: IF p_dm_target_value_rec.target_operator = 'BETWEEN' THEN
1401: IF p_dm_target_value_rec.range_value IS NULL OR
1402: p_dm_target_value_rec.range_value = FND_API.g_miss_char THEN
1403: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_NO_BETWEEN');
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: ELSE
1406: DECLARE
1407: l_low NUMBER;

Line 1416: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_INVALID_RANGE');

1412: -- if invalid number exception thrown
1413: l_low := TO_NUMBER (p_dm_target_value_rec.target_value);
1414: l_high := TO_NUMBER (p_dm_target_value_rec.range_value);
1415: IF l_low > l_high THEN
1416: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_INVALID_RANGE');
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: END IF;
1419: EXCEPTION
1420: WHEN VALUE_ERROR THEN

Line 1451: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_NOT_NUMBER');

1447: END IF;
1448: END IF;
1449: EXCEPTION
1450: WHEN VALUE_ERROR THEN
1451: AMS_Utility_PVT.error_message ('AMS_DM_TARVAL_NOT_NUMBER');
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END;
1454: END IF;
1455: -- end add rosharma 28-Nov-2002