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_LINE_PVT dependencies on OZF_UTILITY_PVT

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

68: END IF;
69:
70: -- Debug Message
71: IF G_DEBUG THEN
72: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
73: END IF;
74:
75:
76: -- Initialize API return status to SUCCESS

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

81: -- Validate Environment
82: -- =========================================================================
83: IF FND_GLOBAL.User_Id IS NULL
84: THEN
85: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88:
89: /*

Line 94: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Line');

90: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
91: THEN
92: -- Debug message
93: IF G_DEBUG THEN
94: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Line');
95: END IF;
96:
97: -- Invoke validation procedures
98: Validate_ae_line(

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

112:
113:
114: -- Debug Message
115: IF G_DEBUG THEN
116: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
117: END IF;
118: X_AE_Line_ID := number_tbl_type();
119: FOR i in 1..p_AE_LINE_Tbl.count LOOP
120: -- Local variable initialization

Line 222: OZF_UTILITY_PVT.debug_message(sqlerrm);

218: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
219: FND_MSG_PUB.add;
220: END IF;
221: IF G_DEBUG THEN
222: OZF_UTILITY_PVT.debug_message(sqlerrm);
223: END IF;
224: RAISE FND_API.g_exc_error;
225: END;
226: X_AE_Line_ID.extend;

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

237: END IF;
238:
239: -- Debug Message
240: IF G_DEBUG THEN
241: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get

Line 250: WHEN OZF_Utility_PVT.resource_locked THEN

246: (p_count => x_msg_count,
247: p_data => x_msg_data
248: );
249: EXCEPTION
250: WHEN OZF_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO CREATE_Ae_Line_PVT;

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

248: );
249: EXCEPTION
250: WHEN OZF_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO CREATE_Ae_Line_PVT;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: -- Standard call to get message count and if count=1, get the message

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

333: END IF;
334:
335: -- Debug Message
336: IF G_DEBUG THEN
337: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
338: END IF;
339:
340:
341: -- Initialize API return status to SUCCESS

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

342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: -- Debug Message
345: IF G_DEBUG THEN
346: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
347: END IF;
348:
349: /*
350: OPEN c_get_Ae_Line( l_tar_ae_line_rec.ae_line_id);

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

351:
352: FETCH c_get_Ae_Line INTO l_ref_ae_line_rec ;
353:
354: If ( c_get_Ae_Line%NOTFOUND) THEN
355: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RECORD_NOT_FOUND');
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358: -- Debug Message
359: IF G_DEBUG THEN

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

356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358: -- Debug Message
359: IF G_DEBUG THEN
360: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
361: END IF;
362: CLOSE c_get_Ae_Line;
363: */
364:

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

364:
365:
366: If (l_tar_ae_line_rec.object_version_number is NULL or
367: l_tar_ae_line_rec.object_version_number = FND_API.G_MISS_NUM ) Then
368: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_NO_OBJ_VER_NUM');
369: raise FND_API.G_EXC_ERROR;
370: End if;
371: -- Check Whether record has been changed by someone else
372: If (l_tar_ae_line_rec.object_version_number <> l_ref_ae_line_rec.object_version_number) Then

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

369: raise FND_API.G_EXC_ERROR;
370: End if;
371: -- Check Whether record has been changed by someone else
372: If (l_tar_ae_line_rec.object_version_number <> l_ref_ae_line_rec.object_version_number) Then
373: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
374: raise FND_API.G_EXC_ERROR;
375: End if;
376: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
377: THEN

Line 380: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Line');

376: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
377: THEN
378: -- Debug message
379: IF G_DEBUG THEN
380: OZF_UTILITY_PVT.debug_message('Private API: Validate_Ae_Line');
381: END IF;
382:
383: -- Invoke validation procedures
384: Validate_ae_line(

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

397:
398:
399: -- Debug Message
400: IF G_DEBUG THEN
401: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
402: END IF;
403:
404: -- Invoke table handler(OZF_AE_LINES_PKG.Update_Row)
405: OZF_AE_LINES_PKG.Update_Row(

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

486:
487:
488: -- Debug Message
489: IF G_DEBUG THEN
490: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
491: END IF;
492:
493: -- Standard call to get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get

Line 500: WHEN OZF_Utility_PVT.resource_locked THEN

496: p_data => x_msg_data
497: );
498: EXCEPTION
499:
500: WHEN OZF_Utility_PVT.resource_locked THEN
501: x_return_status := FND_API.g_ret_sts_error;
502: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
503:
504: WHEN FND_API.G_EXC_ERROR THEN

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

498: EXCEPTION
499:
500: WHEN OZF_Utility_PVT.resource_locked THEN
501: x_return_status := FND_API.g_ret_sts_error;
502: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO UPDATE_Ae_Line_PVT;
506: x_return_status := FND_API.G_RET_STS_ERROR;

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

574: END IF;
575:
576: -- Debug Message
577: IF G_DEBUG THEN
578: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
579: END IF;
580:
581:
582: -- Initialize API return status to SUCCESS

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

586: -- Api body
587: --
588: -- Debug Message
589: IF G_DEBUG THEN
590: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
591: END IF;
592:
593: -- Invoke table handler(OZF_AE_LINES_PKG.Delete_Row)
594: OZF_AE_LINES_PKG.Delete_Row(

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

605:
606:
607: -- Debug Message
608: IF G_DEBUG THEN
609: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get

Line 619: WHEN OZF_Utility_PVT.resource_locked THEN

615: p_data => x_msg_data
616: );
617: EXCEPTION
618:
619: WHEN OZF_Utility_PVT.resource_locked THEN
620: x_return_status := FND_API.g_ret_sts_error;
621: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
622:
623: WHEN FND_API.G_EXC_ERROR THEN

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

617: EXCEPTION
618:
619: WHEN OZF_Utility_PVT.resource_locked THEN
620: x_return_status := FND_API.g_ret_sts_error;
621: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
622:
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO DELETE_Ae_Line_PVT;
625: x_return_status := FND_API.G_RET_STS_ERROR;

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

686: BEGIN
687:
688: -- Debug Message
689: IF G_DEBUG THEN
690: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
691: END IF;
692:
693: -- Initialize message list if p_init_msg_list is set to TRUE.
694: IF FND_API.to_Boolean( p_init_msg_list )

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

712:
713: ------------------------ lock -------------------------
714:
715: IF G_DEBUG THEN
716: OZF_Utility_PVT.debug_message(l_full_name||': start');
717: END IF;
718: OPEN c_Ae_Line;
719:
720: FETCH c_Ae_Line INTO l_AE_LINE_ID;

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

735: p_encoded => FND_API.g_false,
736: p_count => x_msg_count,
737: p_data => x_msg_data);
738: IF G_DEBUG THEN
739: OZF_Utility_PVT.debug_message(l_full_name ||': end');
740: END IF;
741: EXCEPTION
742:
743: WHEN OZF_Utility_PVT.resource_locked THEN

Line 743: WHEN OZF_Utility_PVT.resource_locked THEN

739: OZF_Utility_PVT.debug_message(l_full_name ||': end');
740: END IF;
741: EXCEPTION
742:
743: WHEN OZF_Utility_PVT.resource_locked THEN
744: x_return_status := FND_API.g_ret_sts_error;
745: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
746:
747: WHEN FND_API.G_EXC_ERROR THEN

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

741: EXCEPTION
742:
743: WHEN OZF_Utility_PVT.resource_locked THEN
744: x_return_status := FND_API.g_ret_sts_error;
745: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
746:
747: WHEN FND_API.G_EXC_ERROR THEN
748: ROLLBACK TO LOCK_Ae_Line_PVT;
749: x_return_status := FND_API.G_RET_STS_ERROR;

Line 793: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

789:
790: BEGIN
791: x_return_status := FND_API.g_ret_sts_success;
792: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
793: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
794: 'OZF_AE_LINES_ALL',
795: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||''''
796: );
797: ELSE

Line 798: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

794: 'OZF_AE_LINES_ALL',
795: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||''''
796: );
797: ELSE
798: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
799: 'OZF_AE_LINES_ALL',
800: 'AE_LINE_ID = ''' || p_ae_line_rec.AE_LINE_ID ||
801: ''' AND AE_LINE_ID <> ' || p_ae_line_rec.AE_LINE_ID
802: );

Line 806: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_AE_LINE_ID_DUPLICATE');

802: );
803: END IF;
804:
805: IF l_valid_flag = FND_API.g_false THEN
806: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_AE_LINE_ID_DUPLICATE');
807: x_return_status := FND_API.g_ret_sts_error;
808: RETURN;
809: END IF;
810:

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

822: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
823:
824:
825: IF p_ae_line_rec.ae_line_id = FND_API.g_miss_num OR p_ae_line_rec.ae_line_id IS NULL THEN
826: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_ID' );
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', 'OBJECT_VERSION_NUMBER' );

829: END IF;
830:
831:
832: IF p_ae_line_rec.object_version_number = FND_API.g_miss_num OR p_ae_line_rec.object_version_number IS NULL THEN
833: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
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', 'LAST_UPDATE_DATE' );

836: END IF;
837:
838:
839: IF p_ae_line_rec.last_update_date = FND_API.g_miss_date OR p_ae_line_rec.last_update_date IS NULL THEN
840: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
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', 'LAST_UPDATED_BY' );

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

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

850: END IF;
851:
852:
853: IF p_ae_line_rec.creation_date = FND_API.g_miss_date OR p_ae_line_rec.creation_date IS NULL THEN
854: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;
857: END IF;
858:

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

857: END IF;
858:
859:
860: IF p_ae_line_rec.created_by = FND_API.g_miss_num OR p_ae_line_rec.created_by IS NULL THEN
861: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATED_BY' );
862: x_return_status := FND_API.g_ret_sts_error;
863: RETURN;
864: END IF;
865:

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

864: END IF;
865:
866:
867: IF p_ae_line_rec.ae_header_id = FND_API.g_miss_num OR p_ae_line_rec.ae_header_id IS NULL THEN
868: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );
869: x_return_status := FND_API.g_ret_sts_error;
870: RETURN;
871: END IF;
872:

Line 875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_NUMBER' );

871: END IF;
872:
873:
874: IF p_ae_line_rec.ae_line_number = FND_API.g_miss_num OR p_ae_line_rec.ae_line_number IS NULL THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_NUMBER' );
876: x_return_status := FND_API.g_ret_sts_error;
877: RETURN;
878: END IF;
879:

Line 882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_TYPE_CODE' );

878: END IF;
879:
880:
881: IF p_ae_line_rec.ae_line_type_code = FND_API.g_miss_char OR p_ae_line_rec.ae_line_type_code IS NULL THEN
882: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_TYPE_CODE' );
883: x_return_status := FND_API.g_ret_sts_error;
884: RETURN;
885: END IF;
886:

Line 889: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CODE_COMBINATION_ID' );

885: END IF;
886:
887:
888: IF p_ae_line_rec.code_combination_id = FND_API.g_miss_num OR p_ae_line_rec.code_combination_id IS NULL THEN
889: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CODE_COMBINATION_ID' );
890: x_return_status := FND_API.g_ret_sts_error;
891: RETURN;
892: END IF;
893:

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

892: END IF;
893:
894:
895: IF p_ae_line_rec.source_id = FND_API.g_miss_num OR p_ae_line_rec.source_id IS NULL THEN
896: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );
897: x_return_status := FND_API.g_ret_sts_error;
898: RETURN;
899: END IF;
900:

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

899: END IF;
900:
901:
902: IF p_ae_line_rec.source_table = FND_API.g_miss_char OR p_ae_line_rec.source_table IS NULL THEN
903: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );
904: x_return_status := FND_API.g_ret_sts_error;
905: RETURN;
906: END IF;
907: ELSE

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

907: ELSE
908:
909:
910: IF p_ae_line_rec.ae_line_id IS NULL THEN
911: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_ID' );
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', 'OBJECT_VERSION_NUMBER' );

914: END IF;
915:
916:
917: IF p_ae_line_rec.object_version_number IS NULL THEN
918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
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', 'LAST_UPDATE_DATE' );

921: END IF;
922:
923:
924: IF p_ae_line_rec.last_update_date IS NULL THEN
925: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );
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', 'LAST_UPDATED_BY' );

928: END IF;
929:
930:
931: IF p_ae_line_rec.last_updated_by IS NULL THEN
932: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );
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', 'CREATION_DATE' );

935: END IF;
936:
937:
938: IF p_ae_line_rec.creation_date IS NULL THEN
939: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CREATION_DATE' );
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', 'CREATED_BY' );

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

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

949: END IF;
950:
951:
952: IF p_ae_line_rec.ae_header_id IS NULL THEN
953: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_HEADER_ID' );
954: x_return_status := FND_API.g_ret_sts_error;
955: RETURN;
956: END IF;
957:

Line 960: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_NUMBER' );

956: END IF;
957:
958:
959: IF p_ae_line_rec.ae_line_number IS NULL THEN
960: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_NUMBER' );
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;
963: END IF;
964:

Line 967: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_TYPE_CODE' );

963: END IF;
964:
965:
966: IF p_ae_line_rec.ae_line_type_code IS NULL THEN
967: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'AE_LINE_TYPE_CODE' );
968: x_return_status := FND_API.g_ret_sts_error;
969: RETURN;
970: END IF;
971:

Line 974: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CODE_COMBINATION_ID' );

970: END IF;
971:
972:
973: IF p_ae_line_rec.code_combination_id IS NULL THEN
974: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'CODE_COMBINATION_ID' );
975: x_return_status := FND_API.g_ret_sts_error;
976: RETURN;
977: END IF;
978:

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

977: END IF;
978:
979:
980: IF p_ae_line_rec.source_id IS NULL THEN
981: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_ID' );
982: x_return_status := FND_API.g_ret_sts_error;
983: RETURN;
984: END IF;
985:

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

984: END IF;
985:
986:
987: IF p_ae_line_rec.source_table IS NULL THEN
988: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_TABLE' );
989: x_return_status := FND_API.g_ret_sts_error;
990: RETURN;
991: END IF;
992: END IF;

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

1739:
1740:
1741: -- Debug Message
1742: IF G_DEBUG THEN
1743: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1744: END IF;
1745:
1746:
1747: -- Initialize API return status to SUCCESS

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

1749:
1750:
1751: -- Debug Message
1752: IF G_DEBUG THEN
1753: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1754: END IF;
1755:
1756: -- Standard call to get message count and if count is 1, get message info.
1757: FND_MSG_PUB.Count_And_Get

Line 1763: WHEN OZF_Utility_PVT.resource_locked THEN

1759: p_data => x_msg_data
1760: );
1761: EXCEPTION
1762:
1763: WHEN OZF_Utility_PVT.resource_locked THEN
1764: x_return_status := FND_API.g_ret_sts_error;
1765: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1766:
1767: WHEN FND_API.G_EXC_ERROR THEN

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

1761: EXCEPTION
1762:
1763: WHEN OZF_Utility_PVT.resource_locked THEN
1764: x_return_status := FND_API.g_ret_sts_error;
1765: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1766:
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: ROLLBACK TO VALIDATE_Ae_Line_;
1769: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1829: OZF_UTILITY_PVT.debug_message('Private API: Validate_ae_line_rec');

1825: -- x_return_status := FND_API.G_RET_STS_ERROR;
1826:
1827: -- Debug Message
1828: IF G_DEBUG THEN
1829: OZF_UTILITY_PVT.debug_message('Private API: Validate_ae_line_rec');
1830: END IF;
1831: -- Standard call to get message count and if count is 1, get message info.
1832: FND_MSG_PUB.Count_And_Get
1833: (p_count => x_msg_count,