DBA Data[Home] [Help]

APPS.AMS_APPR_HIST_PVT dependencies on AMS_UTILITY_PVT

Line 192: WHEN AMS_Utility_PVT.resource_locked THEN

188: p_data => x_msg_data
189: );
190: EXCEPTION
191:
192: WHEN AMS_Utility_PVT.resource_locked THEN
193: x_return_status := FND_API.g_ret_sts_error;
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO CREATE_Appr_Hist_PVT;

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

324:
325: FETCH c_get_Appr_Hist INTO l_ref_appr_hist_rec ;
326:
327: IF ( c_get_Appr_Hist%NOTFOUND) THEN
328: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
329: p_token_name => 'INFO',
330: p_token_value => 'Appr_Hist') ;
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;

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

338: -- API gen thought it is the object_version_number used for pseudo locking
339: /*
340: If (l_tar_appr_hist_rec.object_version_num is NULL or
341: l_tar_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM ) Then
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
343: p_token_name => 'COLUMN',
344: p_token_value => 'Last_Update_Date') ;
345: raise FND_API.G_EXC_ERROR;
346: End if;

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

345: raise FND_API.G_EXC_ERROR;
346: End if;
347: -- Check Whether record has been changed by someone else
348: If (l_tar_appr_hist_rec.object_version_num <> l_ref_appr_hist_rec.object_version_num) Then
349: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
350: p_token_name => 'INFO',
351: p_token_value => 'Appr_Hist') ;
352: raise FND_API.G_EXC_ERROR;
353: End if;

Line 415: WHEN AMS_Utility_PVT.resource_locked THEN

411: p_data => x_msg_data
412: );
413: EXCEPTION
414:
415: WHEN AMS_Utility_PVT.resource_locked THEN
416: x_return_status := FND_API.g_ret_sts_error;
417: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
418:
419: WHEN FND_API.G_EXC_ERROR THEN

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

413: EXCEPTION
414:
415: WHEN AMS_Utility_PVT.resource_locked THEN
416: x_return_status := FND_API.g_ret_sts_error;
417: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
418:
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO UPDATE_Appr_Hist_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 558: WHEN AMS_Utility_PVT.resource_locked THEN

554: p_data => x_msg_data
555: );
556: EXCEPTION
557:
558: WHEN AMS_Utility_PVT.resource_locked THEN
559: x_return_status := FND_API.g_ret_sts_error;
560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO DELETE_Appr_Hist_PVT;

Line 609: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

605: /*
606: IF p_validation_mode = JTF_PLSQL_API.g_create
607: AND p_appr_hist_rec.object_id IS NOT NULL
608: THEN
609: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
610: 'ams_approval_history',
611: 'object_id = ''' || p_appr_hist_rec.object_id ||''''
612: );
613: END IF;

Line 636: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );

632: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
633:
634:
635: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_id IS NULL THEN
636: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
637: x_return_status := FND_API.g_ret_sts_error;
638: END IF;
639:
640:

Line 642: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );

638: END IF;
639:
640:
641: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char OR p_appr_hist_rec.object_type_code IS NULL THEN
642: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
643: x_return_status := FND_API.g_ret_sts_error;
644: END IF;
645:
646:

Line 648: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );

644: END IF;
645:
646:
647: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.sequence_num IS NULL THEN
648: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
649: x_return_status := FND_API.g_ret_sts_error;
650: END IF;
651:
652:

Line 654: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );

650: END IF;
651:
652:
653: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM OR p_appr_hist_rec.object_version_num IS NULL THEN
654: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
655: x_return_status := FND_API.g_ret_sts_error;
656: END IF;
657:
658:

Line 663: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );

659: ELSE
660:
661:
662: IF p_appr_hist_rec.object_id = FND_API.G_MISS_NUM THEN
663: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_ID' );
664: x_return_status := FND_API.g_ret_sts_error;
665: END IF;
666:
667:

Line 669: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );

665: END IF;
666:
667:
668: IF p_appr_hist_rec.object_type_code = FND_API.g_miss_char THEN
669: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
670: x_return_status := FND_API.g_ret_sts_error;
671: END IF;
672:
673:

Line 675: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );

671: END IF;
672:
673:
674: IF p_appr_hist_rec.sequence_num = FND_API.G_MISS_NUM THEN
675: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
676: x_return_status := FND_API.g_ret_sts_error;
677: END IF;
678:
679:

Line 681: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );

677: END IF;
678:
679:
680: IF p_appr_hist_rec.object_version_num = FND_API.G_MISS_NUM THEN
681: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUM' );
682: x_return_status := FND_API.g_ret_sts_error;
683: END IF;
684: END IF;
685:

Line 993: WHEN AMS_Utility_PVT.resource_locked THEN

989: p_data => x_msg_data
990: );
991: EXCEPTION
992:
993: WHEN AMS_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
996:
997: WHEN FND_API.G_EXC_ERROR THEN

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

991: EXCEPTION
992:
993: WHEN AMS_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
996:
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO VALIDATE_Appr_Hist_;
999: x_return_status := FND_API.G_RET_STS_ERROR;