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.OZF_AE_HEADER_PVT dependencies on OZF_UTILITY_PVT

Line 75: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

71: END IF;
72:
73: -- Debug Message
74: IF g_debug THEN
75: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
76: END IF;
77:
78:
79: -- Initialize API return status to SUCCESS

Line 107: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');

103: -- =========================================================================
104:
105: IF FND_GLOBAL.User_Id IS NULL
106: THEN
107: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:
111: /*

Line 116: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Header');

112: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
113: THEN
114: -- Debug message
115: IF g_debug THEN
116: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Header');
117: END IF;
118:
119: -- Invoke validation procedures
120: Validate_ae_header(

Line 137: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

133: */
134:
135: -- Debug Message
136: IF g_debug THEN
137: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(OZF_AE_HEADERS_PKG.Insert_Row)
141: OZF_AE_HEADERS_PKG.Insert_Row(

Line 201: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

197:
198:
199: -- Debug Message
200: IF g_debug THEN
201: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
202: END IF;
203:
204: -- Standard call to get message count and if count is 1, get message info.
205: FND_MSG_PUB.Count_And_Get

Line 211: WHEN OZF_Utility_PVT.resource_locked THEN

207: p_data => x_msg_data
208: );
209: EXCEPTION
210:
211: WHEN OZF_Utility_PVT.resource_locked THEN
212: x_return_status := FND_API.g_ret_sts_error;
213: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO CREATE_Ae_Header_PVT;

Line 213: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

209: EXCEPTION
210:
211: WHEN OZF_Utility_PVT.resource_locked THEN
212: x_return_status := FND_API.g_ret_sts_error;
213: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO CREATE_Ae_Header_PVT;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- Standard call to get message count and if count=1, get the message

Line 298: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

294: END IF;
295:
296: -- Debug Message
297: IF g_debug THEN
298: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
299: END IF;
300:
301:
302: -- Initialize API return status to SUCCESS

Line 307: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: -- Debug Message
306: IF g_debug THEN
307: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
308: END IF;
309:
310: /*
311: OPEN c_get_Ae_Header( l_tar_ae_header_rec.ae_header_id);

Line 316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RECORD_NOT_FOUND');

312:
313: FETCH c_get_Ae_Header INTO l_ref_ae_header_rec ;
314:
315: If ( c_get_Ae_Header%NOTFOUND) THEN
316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RECORD_NOT_FOUND');
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: -- Debug Message
320: IF g_debug THEN

Line 321: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: -- Debug Message
320: IF g_debug THEN
321: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
322: END IF;
323: CLOSE c_get_Ae_Header;
324: */
325:

Line 329: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_NO_OBJ_VER_NUM');

325:
326:
327: If (l_tar_ae_header_rec.object_version_number is NULL or
328: l_tar_ae_header_rec.object_version_number = FND_API.G_MISS_NUM ) Then
329: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_NO_OBJ_VER_NUM');
330: raise FND_API.G_EXC_ERROR;
331: End if;
332: -- Check Whether record has been changed by someone else
333: If (l_tar_ae_header_rec.object_version_number <> l_ref_ae_header_rec.object_version_number) Then

Line 334: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

330: raise FND_API.G_EXC_ERROR;
331: End if;
332: -- Check Whether record has been changed by someone else
333: If (l_tar_ae_header_rec.object_version_number <> l_ref_ae_header_rec.object_version_number) Then
334: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
335: raise FND_API.G_EXC_ERROR;
336: End if;
337: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
338: THEN

Line 341: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Header');

337: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
338: THEN
339: -- Debug message
340: IF g_debug THEN
341: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Header');
342: END IF;
343:
344: -- Invoke validation procedures
345: Validate_ae_header(

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

358:
359:
360: -- Debug Message
361: IF g_debug THEN
362: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
363: END IF;
364:
365: -- Invoke table handler(OZF_AE_HEADERS_PKG.Update_Row)
366: OZF_AE_HEADERS_PKG.Update_Row(

Line 420: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

416:
417:
418: -- Debug Message
419: IF g_debug THEN
420: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
421: END IF;
422:
423: -- Standard call to get message count and if count is 1, get message info.
424: FND_MSG_PUB.Count_And_Get

Line 430: WHEN OZF_Utility_PVT.resource_locked THEN

426: p_data => x_msg_data
427: );
428: EXCEPTION
429:
430: WHEN OZF_Utility_PVT.resource_locked THEN
431: x_return_status := FND_API.g_ret_sts_error;
432: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
433:
434: WHEN FND_API.G_EXC_ERROR THEN

Line 432: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

428: EXCEPTION
429:
430: WHEN OZF_Utility_PVT.resource_locked THEN
431: x_return_status := FND_API.g_ret_sts_error;
432: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO UPDATE_Ae_Header_PVT;
436: x_return_status := FND_API.G_RET_STS_ERROR;

Line 508: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

504: END IF;
505:
506: -- Debug Message
507: IF g_debug THEN
508: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
509: END IF;
510:
511:
512: -- Initialize API return status to SUCCESS

Line 520: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

516: -- Api body
517: --
518: -- Debug Message
519: IF g_debug THEN
520: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
521: END IF;
522:
523: -- Invoke table handler(OZF_AE_HEADERS_PKG.Delete_Row)
524: OZF_AE_HEADERS_PKG.Delete_Row(

Line 539: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

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

Line 549: WHEN OZF_Utility_PVT.resource_locked THEN

545: p_data => x_msg_data
546: );
547: EXCEPTION
548:
549: WHEN OZF_Utility_PVT.resource_locked THEN
550: x_return_status := FND_API.g_ret_sts_error;
551: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
552:
553: WHEN FND_API.G_EXC_ERROR THEN

Line 551: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

547: EXCEPTION
548:
549: WHEN OZF_Utility_PVT.resource_locked THEN
550: x_return_status := FND_API.g_ret_sts_error;
551: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO DELETE_Ae_Header_PVT;
555: x_return_status := FND_API.G_RET_STS_ERROR;

Line 620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

616: BEGIN
617:
618: -- Debug Message
619: IF g_debug THEN
620: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
621: END IF;
622:
623: -- Initialize message list if p_init_msg_list is set to TRUE.
624: IF FND_API.to_Boolean( p_init_msg_list )

Line 646: OZF_Utility_PVT.debug_message(l_full_name||': start');

642:
643: ------------------------ lock -------------------------
644:
645: IF g_debug THEN
646: OZF_Utility_PVT.debug_message(l_full_name||': start');
647: END IF;
648: OPEN c_Ae_Header;
649:
650: FETCH c_Ae_Header INTO l_AE_HEADER_ID;

Line 669: OZF_Utility_PVT.debug_message(l_full_name ||': end');

665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data);
668: IF g_debug THEN
669: OZF_Utility_PVT.debug_message(l_full_name ||': end');
670: END IF;
671: EXCEPTION
672:
673: WHEN OZF_Utility_PVT.resource_locked THEN

Line 673: WHEN OZF_Utility_PVT.resource_locked THEN

669: OZF_Utility_PVT.debug_message(l_full_name ||': end');
670: END IF;
671: EXCEPTION
672:
673: WHEN OZF_Utility_PVT.resource_locked THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
676:
677: WHEN FND_API.G_EXC_ERROR THEN

Line 675: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

671: EXCEPTION
672:
673: WHEN OZF_Utility_PVT.resource_locked THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
676:
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO LOCK_Ae_Header_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR;

Line 723: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

719:
720: BEGIN
721: x_return_status := FND_API.g_ret_sts_success;
722: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
723: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
724: 'OZF_AE_HEADERS_ALL',
725: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||''''
726: );
727: ELSE

Line 728: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

724: 'OZF_AE_HEADERS_ALL',
725: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||''''
726: );
727: ELSE
728: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
729: 'OZF_AE_HEADERS_ALL',
730: 'AE_HEADER_ID = ''' || p_ae_header_rec.AE_HEADER_ID ||
731: ''' AND AE_HEADER_ID <> ' || p_ae_header_rec.AE_HEADER_ID
732: );

Line 736: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_AE_HEADER_ID_DUPLICATE');

732: );
733: END IF;
734:
735: IF l_valid_flag = FND_API.g_false THEN
736: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_AE_HEADER_ID_DUPLICATE');
737: x_return_status := FND_API.g_ret_sts_error;
738: RETURN;
739: END IF;
740:

Line 756: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );

752: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
753:
754:
755: IF p_ae_header_rec.ae_header_id = FND_API.g_miss_num OR p_ae_header_rec.ae_header_id IS NULL THEN
756: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );
757: x_return_status := FND_API.g_ret_sts_error;
758: RETURN;
759: END IF;
760:

Line 763: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

759: END IF;
760:
761:
762: IF p_ae_header_rec.object_version_number = FND_API.g_miss_num OR p_ae_header_rec.object_version_number IS NULL THEN
763: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
764: x_return_status := FND_API.g_ret_sts_error;
765: RETURN;
766: END IF;
767:

Line 770: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

766: END IF;
767:
768:
769: IF p_ae_header_rec.last_update_date = FND_API.g_miss_date OR p_ae_header_rec.last_update_date IS NULL THEN
770: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
771: x_return_status := FND_API.g_ret_sts_error;
772: RETURN;
773: END IF;
774:

Line 777: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

773: END IF;
774:
775:
776: IF p_ae_header_rec.last_updated_by = FND_API.g_miss_num OR p_ae_header_rec.last_updated_by IS NULL THEN
777: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );
778: x_return_status := FND_API.g_ret_sts_error;
779: RETURN;
780: END IF;
781:

Line 784: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );

780: END IF;
781:
782:
783: IF p_ae_header_rec.creation_date = FND_API.g_miss_date OR p_ae_header_rec.creation_date IS NULL THEN
784: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:

Line 791: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );

787: END IF;
788:
789:
790: IF p_ae_header_rec.created_by = FND_API.g_miss_num OR p_ae_header_rec.created_by IS NULL THEN
791: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );
792: x_return_status := FND_API.g_ret_sts_error;
793: RETURN;
794: END IF;
795:

Line 798: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );

794: END IF;
795:
796:
797: IF p_ae_header_rec.accounting_event_id = FND_API.g_miss_num OR p_ae_header_rec.accounting_event_id IS NULL THEN
798: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;
802:

Line 805: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );

801: END IF;
802:
803:
804: IF p_ae_header_rec.accounting_date = FND_API.g_miss_date OR p_ae_header_rec.accounting_date IS NULL THEN
805: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );
806: x_return_status := FND_API.g_ret_sts_error;
807: RETURN;
808: END IF;
809:

Line 812: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_CATEGORY' );

808: END IF;
809:
810:
811: IF p_ae_header_rec.ae_category = FND_API.g_miss_char OR p_ae_header_rec.ae_category IS NULL THEN
812: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_CATEGORY' );
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CROSS_CURRENCY_FLAG' );

815: END IF;
816:
817:
818: IF p_ae_header_rec.cross_currency_flag = FND_API.g_miss_char OR p_ae_header_rec.cross_currency_flag IS NULL THEN
819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CROSS_CURRENCY_FLAG' );
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;
822: END IF;
823:

Line 826: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_FLAG' );

822: END IF;
823:
824:
825: IF p_ae_header_rec.gl_transfer_flag = FND_API.g_miss_char OR p_ae_header_rec.gl_transfer_flag IS NULL THEN
826: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_FLAG' );
827: x_return_status := FND_API.g_ret_sts_error;
828: RETURN;
829: END IF;
830:

Line 833: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_RUN_ID' );

829: END IF;
830:
831:
832: IF p_ae_header_rec.gl_transfer_run_id = FND_API.g_miss_num OR p_ae_header_rec.gl_transfer_run_id IS NULL THEN
833: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_RUN_ID' );
834: x_return_status := FND_API.g_ret_sts_error;
835: RETURN;
836: END IF;
837:

Line 840: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PERIOD_NAME' );

836: END IF;
837:
838:
839: IF p_ae_header_rec.period_name = FND_API.g_miss_char OR p_ae_header_rec.period_name IS NULL THEN
840: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PERIOD_NAME' );
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
843: END IF;
844:

Line 847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SET_OF_BOOKS_ID' );

843: END IF;
844:
845:
846: IF p_ae_header_rec.set_of_books_id = FND_API.g_miss_num OR p_ae_header_rec.set_of_books_id IS NULL THEN
847: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SET_OF_BOOKS_ID' );
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;
851: ELSE

Line 855: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );

851: ELSE
852:
853:
854: IF p_ae_header_rec.ae_header_id IS NULL THEN
855: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
859:

Line 862: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

858: END IF;
859:
860:
861: IF p_ae_header_rec.object_version_number IS NULL THEN
862: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:

Line 869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

865: END IF;
866:
867:
868: IF p_ae_header_rec.last_update_date IS NULL THEN
869: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873:

Line 876: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

872: END IF;
873:
874:
875: IF p_ae_header_rec.last_updated_by IS NULL THEN
876: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );
877: x_return_status := FND_API.g_ret_sts_error;
878: RETURN;
879: END IF;
880:

Line 883: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );

879: END IF;
880:
881:
882: IF p_ae_header_rec.creation_date IS NULL THEN
883: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
886: END IF;
887:

Line 890: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );

886: END IF;
887:
888:
889: IF p_ae_header_rec.created_by IS NULL THEN
890: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );
891: x_return_status := FND_API.g_ret_sts_error;
892: RETURN;
893: END IF;
894:

Line 897: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );

893: END IF;
894:
895:
896: IF p_ae_header_rec.accounting_event_id IS NULL THEN
897: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;
900: END IF;
901:

Line 904: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );

900: END IF;
901:
902:
903: IF p_ae_header_rec.accounting_date IS NULL THEN
904: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );
905: x_return_status := FND_API.g_ret_sts_error;
906: RETURN;
907: END IF;
908:

Line 911: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_CATEGORY' );

907: END IF;
908:
909:
910: IF p_ae_header_rec.ae_category IS NULL THEN
911: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_CATEGORY' );
912: x_return_status := FND_API.g_ret_sts_error;
913: RETURN;
914: END IF;
915:

Line 918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CROSS_CURRENCY_FLAG' );

914: END IF;
915:
916:
917: IF p_ae_header_rec.cross_currency_flag IS NULL THEN
918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CROSS_CURRENCY_FLAG' );
919: x_return_status := FND_API.g_ret_sts_error;
920: RETURN;
921: END IF;
922:

Line 925: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_FLAG' );

921: END IF;
922:
923:
924: IF p_ae_header_rec.gl_transfer_flag IS NULL THEN
925: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_FLAG' );
926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;
928: END IF;
929:

Line 932: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_RUN_ID' );

928: END IF;
929:
930:
931: IF p_ae_header_rec.gl_transfer_run_id IS NULL THEN
932: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'GL_TRANSFER_RUN_ID' );
933: x_return_status := FND_API.g_ret_sts_error;
934: RETURN;
935: END IF;
936:

Line 939: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PERIOD_NAME' );

935: END IF;
936:
937:
938: IF p_ae_header_rec.period_name IS NULL THEN
939: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'PERIOD_NAME' );
940: x_return_status := FND_API.g_ret_sts_error;
941: RETURN;
942: END IF;
943:

Line 946: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SET_OF_BOOKS_ID' );

942: END IF;
943:
944:
945: IF p_ae_header_rec.set_of_books_id IS NULL THEN
946: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SET_OF_BOOKS_ID' );
947: x_return_status := FND_API.g_ret_sts_error;
948: RETURN;
949: END IF;
950: END IF;

Line 1453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1449:
1450:
1451: -- Debug Message
1452: IF g_debug THEN
1453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1454: END IF;
1455:
1456:
1457: -- Initialize API return status to SUCCESS

Line 1463: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1459:
1460:
1461: -- Debug Message
1462: IF g_debug THEN
1463: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1464: END IF;
1465:
1466: -- Standard call to get message count and if count is 1, get message info.
1467: FND_MSG_PUB.Count_And_Get

Line 1473: WHEN OZF_Utility_PVT.resource_locked THEN

1469: p_data => x_msg_data
1470: );
1471: EXCEPTION
1472:
1473: WHEN OZF_Utility_PVT.resource_locked THEN
1474: x_return_status := FND_API.g_ret_sts_error;
1475: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN

Line 1475: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1471: EXCEPTION
1472:
1473: WHEN OZF_Utility_PVT.resource_locked THEN
1474: x_return_status := FND_API.g_ret_sts_error;
1475: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO VALIDATE_Ae_Header_;
1479: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1539: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1535: -- x_return_status := FND_API.G_RET_STS_ERROR;
1536:
1537: -- Debug Message
1538: IF g_debug THEN
1539: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1540: END IF;
1541: -- Standard call to get message count and if count is 1, get message info.
1542: FND_MSG_PUB.Count_And_Get
1543: (p_count => x_msg_count,