DBA Data[Home] [Help]

APPS.OZF_ACCTNG_EVENTS_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 105: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');

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

Line 114: OZF_UTILITY_PVT.debug_message('Private API: Validate_Acctng_Events');

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

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

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

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

186: END IF;
187:
188: -- Debug Message
189: IF g_debug THEN
190: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
191: END IF;
192:
193: -- Standard call to get message count and if count is 1, get message info.
194: FND_MSG_PUB.Count_And_Get

Line 199: WHEN OZF_Utility_PVT.resource_locked THEN

195: (p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198: EXCEPTION
199: WHEN OZF_Utility_PVT.resource_locked THEN
200: x_return_status := FND_API.g_ret_sts_error;
201: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO CREATE_Acctng_Events_PVT;

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

197: );
198: EXCEPTION
199: WHEN OZF_Utility_PVT.resource_locked THEN
200: x_return_status := FND_API.g_ret_sts_error;
201: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO CREATE_Acctng_Events_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: -- Standard call to get message count and if count=1, get the message

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

282: END IF;
283:
284: -- Debug Message
285: IF g_debug THEN
286: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
287: END IF;
288:
289:
290: -- Initialize API return status to SUCCESS

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

291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: -- Debug Message
294: IF g_debug THEN
295: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
296: END IF;
297:
298: /*
299: OPEN c_get_Acctng_Events( l_tar_acctng_event_rec.accounting_event_id);

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

300:
301: FETCH c_get_Acctng_Events INTO l_ref_acctng_event_rec ;
302:
303: If ( c_get_Acctng_Events%NOTFOUND) THEN
304: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RECORD_NOT_FOUND');
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307: -- Debug Message
308: IF g_debug THEN

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

305: RAISE FND_API.G_EXC_ERROR;
306: END IF;
307: -- Debug Message
308: IF g_debug THEN
309: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
310: END IF;
311: CLOSE c_get_Acctng_Events;
312: */
313:

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

313:
314:
315: If (l_tar_acctng_event_rec.object_version_number is NULL or
316: l_tar_acctng_event_rec.object_version_number = FND_API.G_MISS_NUM ) Then
317: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_NO_OBJ_VER_NUM');
318: raise FND_API.G_EXC_ERROR;
319: End if;
320: -- Check Whether record has been changed by someone else
321: If (l_tar_acctng_event_rec.object_version_number <> l_ref_acctng_event_rec.object_version_number) Then

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

318: raise FND_API.G_EXC_ERROR;
319: End if;
320: -- Check Whether record has been changed by someone else
321: If (l_tar_acctng_event_rec.object_version_number <> l_ref_acctng_event_rec.object_version_number) Then
322: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
323: raise FND_API.G_EXC_ERROR;
324: End if;
325: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
326: THEN

Line 329: OZF_UTILITY_PVT.debug_message('Private API: Validate_Acctng_Events');

325: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
326: THEN
327: -- Debug message
328: IF g_debug THEN
329: OZF_UTILITY_PVT.debug_message('Private API: Validate_Acctng_Events');
330: END IF;
331:
332: -- Invoke validation procedures
333: Validate_acctng_events(

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

346:
347:
348: -- Debug Message
349: IF g_debug THEN
350: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351: END IF;
352:
353: -- Invoke table handler(OZF_ACCTNG_EVENTS_PKG.Update_Row)
354: OZF_ACCTNG_EVENTS_PKG.Update_Row(

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

396:
397:
398: -- Debug Message
399: IF g_debug THEN
400: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
401: END IF;
402:
403: -- Standard call to get message count and if count is 1, get message info.
404: FND_MSG_PUB.Count_And_Get

Line 410: WHEN OZF_Utility_PVT.resource_locked THEN

406: p_data => x_msg_data
407: );
408: EXCEPTION
409:
410: WHEN OZF_Utility_PVT.resource_locked THEN
411: x_return_status := FND_API.g_ret_sts_error;
412: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
413:
414: WHEN FND_API.G_EXC_ERROR THEN

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

408: EXCEPTION
409:
410: WHEN OZF_Utility_PVT.resource_locked THEN
411: x_return_status := FND_API.g_ret_sts_error;
412: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
413:
414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO UPDATE_Acctng_Events_PVT;
416: x_return_status := FND_API.G_RET_STS_ERROR;

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

484: END IF;
485:
486: -- Debug Message
487: IF g_debug THEN
488: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
489: END IF;
490:
491:
492: -- Initialize API return status to SUCCESS

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

496: -- Api body
497: --
498: -- Debug Message
499: IF g_debug THEN
500: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
501: END IF;
502:
503: -- Invoke table handler(OZF_ACCTNG_EVENTS_PKG.Delete_Row)
504: OZF_ACCTNG_EVENTS_PKG.Delete_Row(

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

515:
516:
517: -- Debug Message
518: IF g_debug THEN
519: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get

Line 529: WHEN OZF_Utility_PVT.resource_locked THEN

525: p_data => x_msg_data
526: );
527: EXCEPTION
528:
529: WHEN OZF_Utility_PVT.resource_locked THEN
530: x_return_status := FND_API.g_ret_sts_error;
531: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
532:
533: WHEN FND_API.G_EXC_ERROR THEN

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

527: EXCEPTION
528:
529: WHEN OZF_Utility_PVT.resource_locked THEN
530: x_return_status := FND_API.g_ret_sts_error;
531: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK TO DELETE_Acctng_Events_PVT;
535: x_return_status := FND_API.G_RET_STS_ERROR;

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

596: BEGIN
597:
598: -- Debug Message
599: IF g_debug THEN
600: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
601: END IF;
602:
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list )

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

622:
623: ------------------------ lock -------------------------
624:
625: IF g_debug THEN
626: OZF_Utility_PVT.debug_message(l_full_name||': start');
627: END IF;
628: OPEN c_Acctng_Events;
629:
630: FETCH c_Acctng_Events INTO l_ACCOUNTING_EVENT_ID;

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

645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data);
648: IF g_debug THEN
649: OZF_Utility_PVT.debug_message(l_full_name ||': end');
650: END IF;
651: EXCEPTION
652:
653: WHEN OZF_Utility_PVT.resource_locked THEN

Line 653: WHEN OZF_Utility_PVT.resource_locked THEN

649: OZF_Utility_PVT.debug_message(l_full_name ||': end');
650: END IF;
651: EXCEPTION
652:
653: WHEN OZF_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN

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

651: EXCEPTION
652:
653: WHEN OZF_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Acctng_Events_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 703: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

699:
700: BEGIN
701: x_return_status := FND_API.g_ret_sts_success;
702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
703: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
704: 'OZF_ACCTNG_EVENTS_ALL',
705: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||''''
706: );
707: ELSE

Line 708: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

704: 'OZF_ACCTNG_EVENTS_ALL',
705: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||''''
706: );
707: ELSE
708: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
709: 'OZF_ACCTNG_EVENTS_ALL',
710: 'ACCOUNTING_EVENT_ID = ''' || p_acctng_event_rec.ACCOUNTING_EVENT_ID ||
711: ''' AND ACCOUNTING_EVENT_ID <> ' || p_acctng_event_rec.ACCOUNTING_EVENT_ID
712: );

Line 716: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ACCT_EVENT_ID_DUPLICATE');

712: );
713: END IF;
714:
715: IF l_valid_flag = FND_API.g_false THEN
716: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ACCT_EVENT_ID_DUPLICATE');
717: x_return_status := FND_API.g_ret_sts_error;
718: RETURN;
719: END IF;
720:

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

732: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
733:
734:
735: IF p_acctng_event_rec.accounting_event_id = FND_API.g_miss_num OR p_acctng_event_rec.accounting_event_id IS NULL THEN
736: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );
737: x_return_status := FND_API.g_ret_sts_error;
738: RETURN;
739: END IF;
740:

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

739: END IF;
740:
741:
742: IF p_acctng_event_rec.object_version_number = FND_API.g_miss_num OR p_acctng_event_rec.object_version_number IS NULL THEN
743: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
744: x_return_status := FND_API.g_ret_sts_error;
745: RETURN;
746: END IF;
747:

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

746: END IF;
747:
748:
749: IF p_acctng_event_rec.last_update_date = FND_API.g_miss_date OR p_acctng_event_rec.last_update_date IS NULL THEN
750: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
751: x_return_status := FND_API.g_ret_sts_error;
752: RETURN;
753: END IF;
754:

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

753: END IF;
754:
755:
756: IF p_acctng_event_rec.last_updated_by = FND_API.g_miss_num OR p_acctng_event_rec.last_updated_by IS NULL THEN
757: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );
758: x_return_status := FND_API.g_ret_sts_error;
759: RETURN;
760: END IF;
761:

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

760: END IF;
761:
762:
763: IF p_acctng_event_rec.creation_date = FND_API.g_miss_date OR p_acctng_event_rec.creation_date IS NULL THEN
764: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
765: x_return_status := FND_API.g_ret_sts_error;
766: RETURN;
767: END IF;
768:

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

767: END IF;
768:
769:
770: IF p_acctng_event_rec.created_by = FND_API.g_miss_num OR p_acctng_event_rec.created_by IS NULL THEN
771: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );
772: x_return_status := FND_API.g_ret_sts_error;
773: RETURN;
774: END IF;
775:

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

774: END IF;
775:
776:
777: IF p_acctng_event_rec.accounting_date = FND_API.g_miss_date OR p_acctng_event_rec.accounting_date IS NULL THEN
778: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );
779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;
781: END IF;
782:

Line 785: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_STATUS_CODE' );

781: END IF;
782:
783:
784: IF p_acctng_event_rec.event_status_code = FND_API.g_miss_char OR p_acctng_event_rec.event_status_code IS NULL THEN
785: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_STATUS_CODE' );
786: x_return_status := FND_API.g_ret_sts_error;
787: RETURN;
788: END IF;
789:

Line 792: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_TYPE_CODE' );

788: END IF;
789:
790:
791: IF p_acctng_event_rec.event_type_code = FND_API.g_miss_char OR p_acctng_event_rec.event_type_code IS NULL THEN
792: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_TYPE_CODE' );
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;
795: END IF;
796:

Line 799: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );

795: END IF;
796:
797:
798: IF p_acctng_event_rec.source_id = FND_API.g_miss_num OR p_acctng_event_rec.source_id IS NULL THEN
799: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );
800: x_return_status := FND_API.g_ret_sts_error;
801: RETURN;
802: END IF;
803:

Line 806: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );

802: END IF;
803:
804:
805: IF p_acctng_event_rec.source_table = FND_API.g_miss_char OR p_acctng_event_rec.source_table IS NULL THEN
806: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );
807: x_return_status := FND_API.g_ret_sts_error;
808: RETURN;
809: END IF;
810: ELSE

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

810: ELSE
811:
812:
813: IF p_acctng_event_rec.accounting_event_id IS NULL THEN
814: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_EVENT_ID' );
815: x_return_status := FND_API.g_ret_sts_error;
816: RETURN;
817: END IF;
818:

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

817: END IF;
818:
819:
820: IF p_acctng_event_rec.object_version_number IS NULL THEN
821: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
822: x_return_status := FND_API.g_ret_sts_error;
823: RETURN;
824: END IF;
825:

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

824: END IF;
825:
826:
827: IF p_acctng_event_rec.last_update_date IS NULL THEN
828: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;
831: END IF;
832:

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

831: END IF;
832:
833:
834: IF p_acctng_event_rec.last_updated_by IS NULL THEN
835: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );
836: x_return_status := FND_API.g_ret_sts_error;
837: RETURN;
838: END IF;
839:

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

838: END IF;
839:
840:
841: IF p_acctng_event_rec.creation_date IS NULL THEN
842: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;
845: END IF;
846:

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

845: END IF;
846:
847:
848: IF p_acctng_event_rec.created_by IS NULL THEN
849: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );
850: x_return_status := FND_API.g_ret_sts_error;
851: RETURN;
852: END IF;
853:

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

852: END IF;
853:
854:
855: IF p_acctng_event_rec.accounting_date IS NULL THEN
856: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'ACCOUNTING_DATE' );
857: x_return_status := FND_API.g_ret_sts_error;
858: RETURN;
859: END IF;
860:

Line 863: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_STATUS_CODE' );

859: END IF;
860:
861:
862: IF p_acctng_event_rec.event_status_code IS NULL THEN
863: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_STATUS_CODE' );
864: x_return_status := FND_API.g_ret_sts_error;
865: RETURN;
866: END IF;
867:

Line 870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_TYPE_CODE' );

866: END IF;
867:
868:
869: IF p_acctng_event_rec.event_type_code IS NULL THEN
870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EVENT_TYPE_CODE' );
871: x_return_status := FND_API.g_ret_sts_error;
872: RETURN;
873: END IF;
874:

Line 877: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );

873: END IF;
874:
875:
876: IF p_acctng_event_rec.source_id IS NULL THEN
877: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );
878: x_return_status := FND_API.g_ret_sts_error;
879: RETURN;
880: END IF;
881:

Line 884: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );

880: END IF;
881:
882:
883: IF p_acctng_event_rec.source_table IS NULL THEN
884: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );
885: x_return_status := FND_API.g_ret_sts_error;
886: RETURN;
887: END IF;
888: END IF;

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

1323:
1324:
1325: -- Debug Message
1326: IF g_debug THEN
1327: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1328: END IF;
1329:
1330:
1331: -- Initialize API return status to SUCCESS

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

1333:
1334:
1335: -- Debug Message
1336: IF g_debug THEN
1337: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: FND_MSG_PUB.Count_And_Get

Line 1347: WHEN OZF_Utility_PVT.resource_locked THEN

1343: p_data => x_msg_data
1344: );
1345: EXCEPTION
1346:
1347: WHEN OZF_Utility_PVT.resource_locked THEN
1348: x_return_status := FND_API.g_ret_sts_error;
1349: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1350:
1351: WHEN FND_API.G_EXC_ERROR THEN

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

1345: EXCEPTION
1346:
1347: WHEN OZF_Utility_PVT.resource_locked THEN
1348: x_return_status := FND_API.g_ret_sts_error;
1349: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1350:
1351: WHEN FND_API.G_EXC_ERROR THEN
1352: ROLLBACK TO VALIDATE_Acctng_Events_;
1353: x_return_status := FND_API.G_RET_STS_ERROR;

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

1409: -- x_return_status := FND_API.G_RET_STS_ERROR;
1410:
1411: -- Debug Message
1412: IF g_debug THEN
1413: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1414: END IF;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: (p_count => x_msg_count,