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.AMS_IBA_PL_PAGES_PVT dependencies on AMS_UTILITY_PVT

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

144:
145: -- Debug Message
146: IF (AMS_DEBUG_HIGH_ON) THEN
147:
148: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
149: END IF;
150:
151: -- Initialize API return status to SUCCESS
152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 183: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

179: -- =========================================================================
180:
181: IF FND_GLOBAL.User_Id IS NULL
182: THEN
183: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 192: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Pl_Pages');

188: THEN
189: -- Debug message
190: IF (AMS_DEBUG_HIGH_ON) THEN
191:
192: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Pl_Pages');
193: END IF;
194:
195: -- Invoke validation procedures
196: Validate_iba_pl_pages(

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

212:
213: -- Debug Message
214: IF (AMS_DEBUG_HIGH_ON) THEN
215:
216: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
217: END IF;
218:
219: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Insert_Row)
220: AMS_IBA_PL_PAGES_B_PKG.Insert_Row(

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

248:
249: -- Debug Message
250: IF (AMS_DEBUG_HIGH_ON) THEN
251:
252: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
253: END IF;
254:
255: -- Standard call to get message count and if count is 1, get message info.
256: FND_MSG_PUB.Count_And_Get

Line 262: WHEN AMS_Utility_PVT.resource_locked THEN

258: p_data => x_msg_data
259: );
260: EXCEPTION
261:
262: WHEN AMS_Utility_PVT.resource_locked THEN
263: x_return_status := FND_API.g_ret_sts_error;
264: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
265:
266: WHEN FND_API.G_EXC_ERROR THEN

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

260: EXCEPTION
261:
262: WHEN AMS_Utility_PVT.resource_locked THEN
263: x_return_status := FND_API.g_ret_sts_error;
264: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
265:
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO CREATE_Iba_Pl_Pages_PVT;
268: x_return_status := FND_API.G_RET_STS_ERROR;

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

351:
352: -- Debug Message
353: IF (AMS_DEBUG_HIGH_ON) THEN
354:
355: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
356: END IF;
357:
358:
359: -- Initialize API return status to SUCCESS

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

361:
362: -- Debug Message
363: IF (AMS_DEBUG_HIGH_ON) THEN
364:
365: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
366: END IF;
367:
368: --/*
369: OPEN c_get_Iba_Pl_Pages( l_tar_iba_pl_pages_rec.page_id);

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

370:
371: FETCH c_get_Iba_Pl_Pages INTO l_ref_iba_pl_pages_rec ;
372:
373: If ( c_get_Iba_Pl_Pages%NOTFOUND) THEN
374: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
375: p_token_name => 'INFO',
376: p_token_value => 'Iba_Pl_Pages') ;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;

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

378: END IF;
379: -- Debug Message
380: IF (AMS_DEBUG_HIGH_ON) THEN
381:
382: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
383: END IF;
384: CLOSE c_get_Iba_Pl_Pages;
385: --*/
386:

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

387:
388: If (l_tar_iba_pl_pages_rec.object_version_number is NULL or
389: l_tar_iba_pl_pages_rec.object_version_number = FND_API.G_MISS_NUM )
390: Then
391: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
392: p_token_name => 'COLUMN',
393: p_token_value => 'Last_Update_Date') ;
394: raise FND_API.G_EXC_ERROR;
395: End if;

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

395: End if;
396: -- Check Whether record has been changed by someone else
397: If (l_tar_iba_pl_pages_rec.object_version_number <> l_ref_iba_pl_pages_rec.object_version_number)
398: Then
399: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
400: p_token_name => 'INFO',
401: p_token_value => 'Iba_Pl_Pages') ;
402: raise FND_API.G_EXC_ERROR;
403: End if;

Line 437: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Pl_Pages');

433: THEN
434: -- Debug message
435: IF (AMS_DEBUG_HIGH_ON) THEN
436:
437: AMS_UTILITY_PVT.debug_message('Private API: Validate_Iba_Pl_Pages');
438: END IF;
439:
440: -- Invoke validation procedures
441: Validate_iba_pl_pages(

Line 459: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;

455: END IF;
456:
457:
458: -- Debug Message
459: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
460:
461: -- Invoke table handler(AMS_IBA_PL_PAGES_B_PKG.Update_Row)
462: AMS_IBA_PL_PAGES_B_PKG.Update_Row(
463: p_page_id => p_iba_pl_pages_rec.page_id,

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

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

Line 502: WHEN AMS_Utility_PVT.resource_locked THEN

498: p_data => x_msg_data
499: );
500: EXCEPTION
501:
502: WHEN AMS_Utility_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN

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

500: EXCEPTION
501:
502: WHEN AMS_Utility_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Iba_Pl_Pages_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;

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

576:
577: -- Debug Message
578: IF (AMS_DEBUG_HIGH_ON) THEN
579:
580: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
581: END IF;
582:
583:
584: -- Initialize API return status to SUCCESS

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

589: --
590: -- Debug Message
591: IF (AMS_DEBUG_HIGH_ON) THEN
592:
593: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
594: END IF;
595:
596: --Check if the page to be deleted is being used in any of placements, if so, it should not be deleted.
597: l_page_placements := check_page_placements(

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

627:
628: -- Debug Message
629: IF (AMS_DEBUG_HIGH_ON) THEN
630:
631: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
632: END IF;
633:
634: -- Standard call to get message count and if count is 1, get message info.
635: FND_MSG_PUB.Count_And_Get

Line 641: WHEN AMS_Utility_PVT.resource_locked THEN

637: p_data => x_msg_data
638: );
639: EXCEPTION
640:
641: WHEN AMS_Utility_PVT.resource_locked THEN
642: x_return_status := FND_API.g_ret_sts_error;
643: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
644:
645: WHEN FND_API.G_EXC_ERROR THEN

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

639: EXCEPTION
640:
641: WHEN AMS_Utility_PVT.resource_locked THEN
642: x_return_status := FND_API.g_ret_sts_error;
643: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
644:
645: WHEN FND_API.G_EXC_ERROR THEN
646: ROLLBACK TO DELETE_Iba_Pl_Pages_PVT;
647: x_return_status := FND_API.G_RET_STS_ERROR;

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

707: BEGIN
708: -- Debug Message
709: IF (AMS_DEBUG_HIGH_ON) THEN
710:
711: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
712: END IF;
713:
714: -- Initialize message list if p_init_msg_list is set to TRUE.
715: IF FND_API.to_Boolean( p_init_msg_list )

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

736: IF (AMS_DEBUG_HIGH_ON) THEN
737:
738:
739:
740: AMS_Utility_PVT.debug_message(l_full_name||': start');
741:
742: END IF;
743: OPEN c_Iba_Pl_Pages;
744:

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

761: p_count => x_msg_count,
762: p_data => x_msg_data);
763: IF (AMS_DEBUG_HIGH_ON) THEN
764:
765: AMS_Utility_PVT.debug_message(l_full_name ||': end');
766: END IF;
767: EXCEPTION
768:
769: WHEN AMS_Utility_PVT.resource_locked THEN

Line 769: WHEN AMS_Utility_PVT.resource_locked THEN

765: AMS_Utility_PVT.debug_message(l_full_name ||': end');
766: END IF;
767: EXCEPTION
768:
769: WHEN AMS_Utility_PVT.resource_locked THEN
770: x_return_status := FND_API.g_ret_sts_error;
771: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
772:
773: WHEN FND_API.G_EXC_ERROR THEN

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

767: EXCEPTION
768:
769: WHEN AMS_Utility_PVT.resource_locked THEN
770: x_return_status := FND_API.g_ret_sts_error;
771: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
772:
773: WHEN FND_API.G_EXC_ERROR THEN
774: ROLLBACK TO LOCK_Iba_Pl_Pages_PVT;
775: x_return_status := FND_API.G_RET_STS_ERROR;

Line 822: l_page_name_flag := ams_utility_pvt.check_uniqueness(

818: x_return_status := FND_API.g_ret_sts_success;
819: --If Validation_mode is create, check uniqueness of page_id, name, page_ref_code
820: if p_validation_mode = JTF_PLSQL_API.g_create then
821: -- Checking if the page name passed is unique
822: l_page_name_flag := ams_utility_pvt.check_uniqueness(
823: 'ams_iba_pl_pages_vl'
824: , 'name = ''' || p_iba_pl_pages_rec.name ||''' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
825: );
826: if l_page_name_flag = fnd_api.g_false then

Line 827: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_PAGE_NAME_DUP');

823: 'ams_iba_pl_pages_vl'
824: , 'name = ''' || p_iba_pl_pages_rec.name ||''' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
825: );
826: if l_page_name_flag = fnd_api.g_false then
827: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_PAGE_NAME_DUP');
828: x_return_status := fnd_api.g_ret_sts_error;
829: return;
830: end if;
831:

Line 833: l_page_ref_code_flag := ams_utility_pvt.check_uniqueness(

829: return;
830: end if;
831:
832: -- Checking if the page ref code passed is unique
833: l_page_ref_code_flag := ams_utility_pvt.check_uniqueness(
834: 'ams_iba_pl_pages_vl'
835: , 'page_ref_code = ''' || p_iba_pl_pages_rec.page_ref_code ||''' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
836:
837: );

Line 839: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_PAGE_REF');

835: , 'page_ref_code = ''' || p_iba_pl_pages_rec.page_ref_code ||''' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
836:
837: );
838: if l_page_ref_code_flag = fnd_api.g_false then
839: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_PAGE_REF');
840: x_return_status := fnd_api.g_ret_sts_error;
841: return;
842: end if;
843: end if;

Line 848: l_page_name_flag := ams_utility_pvt.check_uniqueness(

844:
845: --If Validation_mode is update, check uniqueness of page name, page_ref_code
846: if p_validation_mode = JTF_PLSQL_API.g_update then
847: -- Checking if the page name passed is unique
848: l_page_name_flag := ams_utility_pvt.check_uniqueness(
849: 'ams_iba_pl_pages_vl'
850: , 'name = ''' || p_iba_pl_pages_rec.name ||''' and page_id <> ' || p_iba_pl_pages_rec.page_id || ' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
851:
852: );

Line 855: AMS_UTILITY_PVT.debug_message('In update unique check - page_name: ' || p_iba_pl_pages_rec.name);

851:
852: );
853: IF (AMS_DEBUG_HIGH_ON) THEN
854:
855: AMS_UTILITY_PVT.debug_message('In update unique check - page_name: ' || p_iba_pl_pages_rec.name);
856: END IF;
857: if l_page_name_flag = fnd_api.g_false then
858: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_PAGE_NAME_DUP');
859: x_return_status := fnd_api.g_ret_sts_error;

Line 858: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_PAGE_NAME_DUP');

854:
855: AMS_UTILITY_PVT.debug_message('In update unique check - page_name: ' || p_iba_pl_pages_rec.name);
856: END IF;
857: if l_page_name_flag = fnd_api.g_false then
858: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_PAGE_NAME_DUP');
859: x_return_status := fnd_api.g_ret_sts_error;
860: return;
861: end if;
862:

Line 864: l_page_ref_code_flag := ams_utility_pvt.check_uniqueness(

860: return;
861: end if;
862:
863: -- Checking if the page ref code passed is unique
864: l_page_ref_code_flag := ams_utility_pvt.check_uniqueness(
865: 'ams_iba_pl_pages_vl'
866: , 'page_ref_code = ''' || p_iba_pl_pages_rec.page_ref_code ||''' and page_id <> ' || p_iba_pl_pages_rec.page_id || ' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
867: );
868: if l_page_ref_code_flag = fnd_api.g_false then

Line 869: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_PAGE_REF');

865: 'ams_iba_pl_pages_vl'
866: , 'page_ref_code = ''' || p_iba_pl_pages_rec.page_ref_code ||''' and page_id <> ' || p_iba_pl_pages_rec.page_id || ' and site_ref_code = ''' || p_iba_pl_pages_rec.site_ref_code || ''''
867: );
868: if l_page_ref_code_flag = fnd_api.g_false then
869: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_PAGE_REF');
870: x_return_status := fnd_api.g_ret_sts_error;
871: return;
872: end if;
873: end if;

Line 876: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(

872: end if;
873: end if;
874:
875: -- IF p_validation_mode = JTF_PLSQL_API.g_create THEN
876: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
877: -- 'AMS_IBA_PL_PAGES_B',
878: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||''''
879: -- );
880: -- ELSE

Line 881: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(

877: -- 'AMS_IBA_PL_PAGES_B',
878: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||''''
879: -- );
880: -- ELSE
881: -- l_valid_flag := AMS_Utility_PVT.check_uniqueness(
882: -- 'AMS_IBA_PL_PAGES_B',
883: -- 'PAGE_ID = ''' || p_iba_pl_pages_rec.PAGE_ID ||
884: -- ''' AND PAGE_ID <> ' || p_iba_pl_pages_rec.PAGE_ID
885: -- );

Line 889: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PAGE_ID_DUPLICATE');

885: -- );
886: -- END IF;
887:
888: -- IF l_valid_flag = FND_API.g_false THEN
889: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PAGE_ID_DUPLICATE');
890: -- x_return_status := FND_API.g_ret_sts_error;
891: -- RETURN;
892: -- END IF;
893:

Line 909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_id');

905: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
906:
907:
908: IF p_iba_pl_pages_rec.page_id = FND_API.g_miss_num OR p_iba_pl_pages_rec.page_id IS NULL THEN
909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_id');
910: x_return_status := FND_API.g_ret_sts_error;
911: RETURN;
912: END IF;
913:

Line 916: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_id');

912: END IF;
913:
914:
915: IF p_iba_pl_pages_rec.site_id = FND_API.g_miss_num OR p_iba_pl_pages_rec.site_id IS NULL THEN
916: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_id');
917: x_return_status := FND_API.g_ret_sts_error;
918: RETURN;
919: END IF;
920:

Line 923: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_ref_code');

919: END IF;
920:
921:
922: IF p_iba_pl_pages_rec.site_ref_code = FND_API.g_miss_char OR p_iba_pl_pages_rec.site_ref_code IS NULL THEN
923: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_ref_code');
924: x_return_status := FND_API.g_ret_sts_error;
925: RETURN;
926: END IF;
927:

Line 930: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_ref_code');

926: END IF;
927:
928:
929: IF p_iba_pl_pages_rec.page_ref_code = FND_API.g_miss_char OR p_iba_pl_pages_rec.page_ref_code IS NULL THEN
930: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_ref_code');
931: x_return_status := FND_API.g_ret_sts_error;
932: RETURN;
933: END IF;
934:

Line 937: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_status_code');

933: END IF;
934:
935:
936: IF p_iba_pl_pages_rec.status_code = FND_API.g_miss_char OR p_iba_pl_pages_rec.status_code IS NULL THEN
937: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_status_code');
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;
940: END IF;
941:

Line 944: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_created_by');

940: END IF;
941:
942:
943: IF p_iba_pl_pages_rec.created_by = FND_API.g_miss_num OR p_iba_pl_pages_rec.created_by IS NULL THEN
944: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_created_by');
945: x_return_status := FND_API.g_ret_sts_error;
946: RETURN;
947: END IF;
948:

Line 951: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_creation_date');

947: END IF;
948:
949:
950: IF p_iba_pl_pages_rec.creation_date = FND_API.g_miss_date OR p_iba_pl_pages_rec.creation_date IS NULL THEN
951: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_creation_date');
952: x_return_status := FND_API.g_ret_sts_error;
953: RETURN;
954: END IF;
955:

Line 958: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_updated_by');

954: END IF;
955:
956:
957: IF p_iba_pl_pages_rec.last_updated_by = FND_API.g_miss_num OR p_iba_pl_pages_rec.last_updated_by IS NULL THEN
958: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_updated_by');
959: x_return_status := FND_API.g_ret_sts_error;
960: RETURN;
961: END IF;
962:

Line 965: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_update_date');

961: END IF;
962:
963:
964: IF p_iba_pl_pages_rec.last_update_date = FND_API.g_miss_date OR p_iba_pl_pages_rec.last_update_date IS NULL THEN
965: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_update_date');
966: x_return_status := FND_API.g_ret_sts_error;
967: RETURN;
968: END IF;
969:

Line 975: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_id');

971: ELSE
972:
973:
974: IF p_iba_pl_pages_rec.page_id IS NULL THEN
975: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_id');
976: x_return_status := FND_API.g_ret_sts_error;
977: RETURN;
978: END IF;
979:

Line 982: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_id');

978: END IF;
979:
980:
981: IF p_iba_pl_pages_rec.site_id IS NULL THEN
982: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_id');
983: x_return_status := FND_API.g_ret_sts_error;
984: RETURN;
985: END IF;
986:

Line 989: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_ref_code');

985: END IF;
986:
987:
988: IF p_iba_pl_pages_rec.site_ref_code IS NULL THEN
989: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_site_ref_code');
990: x_return_status := FND_API.g_ret_sts_error;
991: RETURN;
992: END IF;
993:

Line 996: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_ref_code');

992: END IF;
993:
994:
995: IF p_iba_pl_pages_rec.page_ref_code IS NULL THEN
996: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_page_ref_code');
997: x_return_status := FND_API.g_ret_sts_error;
998: RETURN;
999: END IF;
1000:

Line 1003: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_status_code');

999: END IF;
1000:
1001:
1002: IF p_iba_pl_pages_rec.status_code IS NULL THEN
1003: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_status_code');
1004: x_return_status := FND_API.g_ret_sts_error;
1005: RETURN;
1006: END IF;
1007:

Line 1010: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_created_by');

1006: END IF;
1007:
1008:
1009: IF p_iba_pl_pages_rec.created_by IS NULL THEN
1010: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_created_by');
1011: x_return_status := FND_API.g_ret_sts_error;
1012: RETURN;
1013: END IF;
1014:

Line 1017: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_creation_date');

1013: END IF;
1014:
1015:
1016: IF p_iba_pl_pages_rec.creation_date IS NULL THEN
1017: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_creation_date');
1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;
1020: END IF;
1021:

Line 1024: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_updated_by');

1020: END IF;
1021:
1022:
1023: IF p_iba_pl_pages_rec.last_updated_by IS NULL THEN
1024: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_updated_by');
1025: x_return_status := FND_API.g_ret_sts_error;
1026: RETURN;
1027: END IF;
1028:

Line 1031: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_update_date');

1027: END IF;
1028:
1029:
1030: IF p_iba_pl_pages_rec.last_update_date IS NULL THEN
1031: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_pages_NO_last_update_date');
1032: x_return_status := FND_API.g_ret_sts_error;
1033: RETURN;
1034: END IF;
1035:

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

1258:
1259: -- Debug Message
1260: IF (AMS_DEBUG_HIGH_ON) THEN
1261:
1262: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1263: END IF;
1264:
1265:
1266: -- Initialize API return status to SUCCESS

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

1269:
1270: -- Debug Message
1271: IF (AMS_DEBUG_HIGH_ON) THEN
1272:
1273: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1274: END IF;
1275:
1276: -- Standard call to get message count and if count is 1, get message info.
1277: FND_MSG_PUB.Count_And_Get

Line 1283: WHEN AMS_Utility_PVT.resource_locked THEN

1279: p_data => x_msg_data
1280: );
1281: EXCEPTION
1282:
1283: WHEN AMS_Utility_PVT.resource_locked THEN
1284: x_return_status := FND_API.g_ret_sts_error;
1285: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1286:
1287: WHEN FND_API.G_EXC_ERROR THEN

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

1281: EXCEPTION
1282:
1283: WHEN AMS_Utility_PVT.resource_locked THEN
1284: x_return_status := FND_API.g_ret_sts_error;
1285: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1286:
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: ROLLBACK TO VALIDATE_Iba_Pl_Pages_;
1289: x_return_status := FND_API.G_RET_STS_ERROR;

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

1346:
1347: -- Debug Message
1348: IF (AMS_DEBUG_HIGH_ON) THEN
1349:
1350: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1351: END IF;
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get
1354: (p_count => x_msg_count,