DBA Data[Home] [Help]

APPS.AMS_DMLIFT_PVT dependencies on AMS_UTILITY_PVT

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

64:
65: -- Debug Message
66: IF (AMS_DEBUG_HIGH_ON) THEN
67:
68: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
69: END IF;
70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )

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

93: IF (AMS_DEBUG_HIGH_ON) THEN
94:
95:
96:
97: AMS_Utility_PVT.debug_message(l_full_name||': start');
98:
99: END IF;
100: OPEN c_Dmlift;
101:

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

118: p_count => x_msg_count,
119: p_data => x_msg_data);
120: IF (AMS_DEBUG_HIGH_ON) THEN
121:
122: AMS_Utility_PVT.debug_message(l_full_name ||': end');
123: END IF;
124: EXCEPTION
125:
126: WHEN AMS_Utility_PVT.resource_locked THEN

Line 126: WHEN AMS_Utility_PVT.resource_locked THEN

122: AMS_Utility_PVT.debug_message(l_full_name ||': end');
123: END IF;
124: EXCEPTION
125:
126: WHEN AMS_Utility_PVT.resource_locked THEN
127: x_return_status := FND_API.g_ret_sts_error;
128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
129: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
130: FND_MSG_PUB.add;

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

221:
222: -- Debug Message
223: IF (AMS_DEBUG_HIGH_ON) THEN
224:
225: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
226: END IF;
227:
228:
229: -- Initialize API return status to SUCCESS

Line 256: AMS_UTILITY_PVT.debug_message('Private API: Validate_Lift');

252: THEN
253: -- Debug message
254: IF (AMS_DEBUG_HIGH_ON) THEN
255:
256: AMS_UTILITY_PVT.debug_message('Private API: Validate_Lift');
257: END IF;
258:
259: -- Invoke validation procedures
260: Validate_Lift (

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

275:
276: -- Debug Message
277: IF (AMS_DEBUG_HIGH_ON) THEN
278:
279: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
280: END IF;
281:
282: -- Invoke table handler(AMS_DM_LIFT_PKG.Insert_Row)
283: AMS_DM_LIFT_PKG.Insert_Row(

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

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

Line 330: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

420:
421: -- Debug Message
422: IF (AMS_DEBUG_HIGH_ON) THEN
423:
424: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
425: END IF;
426:
427:
428: -- Initialize API return status to SUCCESS

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

430:
431: -- Debug Message
432: IF (AMS_DEBUG_HIGH_ON) THEN
433:
434: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
435: END IF;
436:
437: OPEN c_get_Dmlift( l_tar_Lift_rec.LIFT_ID);
438:

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

449: END IF;
450: -- Debug Message
451: IF (AMS_DEBUG_HIGH_ON) THEN
452:
453: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
454: END IF;
455: CLOSE c_get_Dmlift;
456:
457: -- Check Whether record has been changed by someone else

Line 472: AMS_UTILITY_PVT.debug_message('Private API: Validate_Lift');

468: THEN
469: -- Debug message
470: IF (AMS_DEBUG_HIGH_ON) THEN
471:
472: AMS_UTILITY_PVT.debug_message('Private API: Validate_Lift');
473: END IF;
474:
475: -- Invoke validation procedures
476: Validate_Lift(

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

491:
492: -- Debug Message
493: IF (AMS_DEBUG_HIGH_ON) THEN
494:
495: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
496: END IF;
497:
498: -- Invoke table handler(AMS_DM_LIFT_PKG.Update_Row)
499: BEGIN

Line 521: AMS_Utility_PVT.error_message ('AMS_API_NO_UPDATE');

517: p_non_target_confidence => p_Lift_rec.non_target_confidence
518: );
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: AMS_Utility_PVT.error_message ('AMS_API_NO_UPDATE');
522: RAISE FND_API.g_exc_error;
523: END;
524: --
525: -- End of API body.

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

534:
535: -- Debug Message
536: IF (AMS_DEBUG_HIGH_ON) THEN
537:
538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
539: END IF;
540:
541: -- Standard call to get message count and if count is 1, get message info.
542: FND_MSG_PUB.Count_And_Get

Line 548: WHEN AMS_Utility_PVT.resource_locked THEN

544: p_data => x_msg_data
545: );
546: EXCEPTION
547:
548: WHEN AMS_Utility_PVT.resource_locked THEN
549: x_return_status := FND_API.g_ret_sts_error;
550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
551: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
552: FND_MSG_PUB.add;

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

626:
627: -- Debug Message
628: IF (AMS_DEBUG_HIGH_ON) THEN
629:
630: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
631: END IF;
632:
633:
634: -- Initialize API return status to SUCCESS

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

639: --
640: -- Debug Message
641: IF (AMS_DEBUG_HIGH_ON) THEN
642:
643: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
644: END IF;
645:
646: -- Invoke table handler(AMS_DM_LIFT_PKG.Delete_Row)
647: BEGIN

Line 652: AMS_Utility_PVT.error_message ('AMS_API_NO_DELETE');

648: AMS_DM_LIFT_PKG.Delete_Row(
649: p_LIFT_ID => p_LIFT_ID);
650: EXCEPTION
651: WHEN NO_DATA_FOUND THEN
652: AMS_Utility_PVT.error_message ('AMS_API_NO_DELETE');
653: RAISE FND_API.g_exc_error;
654: END;
655: --
656: -- End of API body

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

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

Line 679: WHEN AMS_Utility_PVT.resource_locked THEN

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

Line 732: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

728:
729: BEGIN
730: x_return_status := FND_API.g_ret_sts_success;
731: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
732: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
733: 'AMS_DM_LIFT',
734: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||''''
735: );
736: ELSE

Line 737: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

733: 'AMS_DM_LIFT',
734: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||''''
735: );
736: ELSE
737: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
738: 'AMS_DM_LIFT',
739: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||
740: ''' AND LIFT_ID <> ' || p_Lift_rec.LIFT_ID
741: );

Line 859: IF AMS_Utility_PVT.check_fk_exists (

855: x_return_status := FND_API.g_ret_sts_success;
856:
857: -- Enter custom code here
858: IF p_lift_rec.model_id <> FND_API.g_miss_num THEN
859: IF AMS_Utility_PVT.check_fk_exists (
860: 'AMS_DM_MODELS_ALL_B',
861: 'MODEL_ID',
862: p_lift_rec.model_id
863: ) = FND_API.g_false THEN

Line 864: AMS_Utility_PVT.error_message ('AMS_DM_LIFT_BAD_MODEL_ID');

860: 'AMS_DM_MODELS_ALL_B',
861: 'MODEL_ID',
862: p_lift_rec.model_id
863: ) = FND_API.g_false THEN
864: AMS_Utility_PVT.error_message ('AMS_DM_LIFT_BAD_MODEL_ID');
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867: END IF;
868:

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

1013:
1014: -- Debug Message
1015: IF (AMS_DEBUG_HIGH_ON) THEN
1016:
1017: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1018: END IF;
1019:
1020:
1021: -- Initialize API return status to SUCCESS

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

1024:
1025: -- Debug Message
1026: IF (AMS_DEBUG_HIGH_ON) THEN
1027:
1028: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1029: END IF;
1030:
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get

Line 1038: WHEN AMS_Utility_PVT.resource_locked THEN

1034: p_data => x_msg_data
1035: );
1036: EXCEPTION
1037:
1038: WHEN AMS_Utility_PVT.resource_locked THEN
1039: x_return_status := FND_API.g_ret_sts_error;
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1041: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1042: FND_MSG_PUB.add;

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

1101:
1102: -- Debug Message
1103: IF (AMS_DEBUG_HIGH_ON) THEN
1104:
1105: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1106: END IF;
1107: -- Standard call to get message count and if count is 1, get message info.
1108: FND_MSG_PUB.Count_And_Get
1109: (p_count => x_msg_count,