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_SITES_PVT dependencies on AMS_UTILITY_PVT

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

166:
167: -- Debug Message
168: IF (AMS_DEBUG_HIGH_ON) THEN
169:
170: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
171: END IF;
172:
173:
174: -- Initialize API return status to SUCCESS

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

196: -- =========================================================================
197:
198: IF FND_GLOBAL.User_Id IS NULL
199: THEN
200: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 209: AMS_UTILITY_PVT.debug_message('Private API: validate_iba_pl_sites');

205: THEN
206: -- Debug message
207: IF (AMS_DEBUG_HIGH_ON) THEN
208:
209: AMS_UTILITY_PVT.debug_message('Private API: validate_iba_pl_sites');
210: END IF;
211:
212: -- Invoke validation procedures
213: validate_iba_pl_sites(

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

229:
230: -- Debug Message
231: IF (AMS_DEBUG_HIGH_ON) THEN
232:
233: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
234: END IF;
235:
236: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Insert_Row)
237: AMS_IBA_PL_SITES_B_PKG.Insert_Row(

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

265:
266: -- Debug Message
267: IF (AMS_DEBUG_HIGH_ON) THEN
268:
269: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
270: END IF;
271:
272: -- Standard call to get message count and if count is 1, get message info.
273: FND_MSG_PUB.Count_And_Get

Line 279: WHEN AMS_Utility_PVT.resource_locked THEN

275: p_data => x_msg_data
276: );
277: EXCEPTION
278:
279: WHEN AMS_Utility_PVT.resource_locked THEN
280: x_return_status := FND_API.g_ret_sts_error;
281: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
282:
283: WHEN FND_API.G_EXC_ERROR THEN

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

277: EXCEPTION
278:
279: WHEN AMS_Utility_PVT.resource_locked THEN
280: x_return_status := FND_API.g_ret_sts_error;
281: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
282:
283: WHEN FND_API.G_EXC_ERROR THEN
284: ROLLBACK TO CREATE_Iba_Pl_Sites_PVT;
285: x_return_status := FND_API.G_RET_STS_ERROR;

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

371:
372: -- Debug Message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:
375: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
376: END IF;
377:
378:
379: -- Initialize API return status to SUCCESS

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

381:
382: -- Debug Message
383: IF (AMS_DEBUG_HIGH_ON) THEN
384:
385: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
386: END IF;
387:
388: --/*
389: OPEN c_get_Iba_Pl_Sites( l_tar_iba_pl_sites_rec.site_id);

Line 394: AMS_Utility_PVT.Error_Message(

390:
391: FETCH c_get_Iba_Pl_Sites INTO l_ref_iba_pl_sites_rec ;
392:
393: IF ( c_get_Iba_Pl_Sites%NOTFOUND) THEN
394: AMS_Utility_PVT.Error_Message(
395: p_message_name => 'API_MISSING_UPDATE_TARGET',
396: p_token_name => 'INFO',
397: p_token_value => 'Iba_Pl_Sites') ;
398: RAISE FND_API.G_EXC_ERROR;

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

400:
401: -- Debug Message
402: IF (AMS_DEBUG_HIGH_ON) THEN
403:
404: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
405: END IF;
406: CLOSE c_get_Iba_Pl_Sites;
407: --*/
408:

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

409:
410: IF (l_tar_iba_pl_sites_rec.object_version_number is NULL or
411: l_tar_iba_pl_sites_rec.object_version_number = FND_API.G_MISS_NUM )
412: THEN
413: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
414: p_token_name => 'COLUMN',
415: p_token_value => 'Last_Update_Date') ;
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;

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

418:
419: -- Check Whether record has been changed by someone else
420: IF (l_tar_iba_pl_sites_rec.object_version_number <> l_ref_iba_pl_sites_rec.object_version_number)
421: THEN
422: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
423: p_token_name => 'INFO',
424: p_token_value => 'Iba_Pl_Sites') ;
425: RAISE FND_API.G_EXC_ERROR;
426: End if;

Line 485: AMS_UTILITY_PVT.debug_message('Private API: validate_iba_pl_sites');

481: THEN
482: -- Debug message
483: IF (AMS_DEBUG_HIGH_ON) THEN
484:
485: AMS_UTILITY_PVT.debug_message('Private API: validate_iba_pl_sites');
486: END IF;
487:
488: -- Invoke validation procedures
489: validate_iba_pl_sites(

Line 505: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' After Validate call - return_status='||x_return_status);

501: IF (AMS_DEBUG_HIGH_ON) THEN
502:
503:
504:
505: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' After Validate call - return_status='||x_return_status);
506:
507: END IF;
508: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
509: RAISE FND_API.G_EXC_ERROR;

Line 514: -- 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;

510: END IF;
511:
512:
513: -- Debug Message
514: -- 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;
515: IF (AMS_DEBUG_HIGH_ON) THEN
516:
517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);
518: END IF;

Line 517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);

513: -- Debug Message
514: -- 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;
515: IF (AMS_DEBUG_HIGH_ON) THEN
516:
517: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler - mymessage - site_id='||p_iba_pl_sites_rec.site_id);
518: END IF;
519:
520: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Update_Row)
521: AMS_IBA_PL_SITES_B_PKG.Update_Row(

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

546:
547: -- Debug Message
548: IF (AMS_DEBUG_HIGH_ON) THEN
549:
550: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
551: END IF;
552:
553: -- Standard call to get message count and if count is 1, get message info.
554: FND_MSG_PUB.Count_And_Get

Line 560: WHEN AMS_Utility_PVT.resource_locked THEN

556: p_data => x_msg_data
557: );
558: EXCEPTION
559:
560: WHEN AMS_Utility_PVT.resource_locked THEN
561: x_return_status := FND_API.g_ret_sts_error;
562: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
563:
564: WHEN FND_API.G_EXC_ERROR THEN

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

558: EXCEPTION
559:
560: WHEN AMS_Utility_PVT.resource_locked THEN
561: x_return_status := FND_API.g_ret_sts_error;
562: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
563:
564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO UPDATE_Iba_Pl_Sites_PVT;
566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 578: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Updte method - unexpected exception area');

574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: ROLLBACK TO UPDATE_Iba_Pl_Sites_PVT;
576: IF (AMS_DEBUG_HIGH_ON) THEN
577:
578: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Updte method - unexpected exception area');
579: END IF;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (

Line 593: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Update method - others exception area');

589: ROLLBACK TO UPDATE_Iba_Pl_Sites_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF (AMS_DEBUG_HIGH_ON) THEN
592:
593: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' in Update method - others exception area');
594: END IF;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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

649:
650: -- Debug Message
651: IF (AMS_DEBUG_HIGH_ON) THEN
652:
653: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
654: END IF;
655:
656:
657: -- Initialize API return status to SUCCESS

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

662: --
663: -- Debug Message
664: IF (AMS_DEBUG_HIGH_ON) THEN
665:
666: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
667: END IF;
668:
669: OPEN c_site_pages(p_site_id);
670: FETCH c_site_pages INTO l_site_page_count;

Line 677: AMS_UTILITY_PVT.debug_message('Private API: Page Count = ' || l_site_page_count );

673: IF (AMS_DEBUG_HIGH_ON) THEN
674:
675:
676:
677: AMS_UTILITY_PVT.debug_message('Private API: Page Count = ' || l_site_page_count );
678:
679: END IF;
680: -- Invoke table handler(AMS_IBA_PL_SITES_B_PKG.Delete_Row)
681: IF l_site_page_count = 0 --MEANING NO PAGES ARE AVAILABLE FOR THIS SITE

Line 687: AMS_UTILITY_PVT.debug_message('Private API: Just before calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);

683: -- IF l_object_version_number = p_object_version_number -- VERSIONS MATCH
684: -- THEN
685: IF (AMS_DEBUG_HIGH_ON) THEN
686:
687: AMS_UTILITY_PVT.debug_message('Private API: Just before calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);
688: END IF;
689:
690: AMS_IBA_PL_SITES_B_PKG.Delete_Row
691: (p_site_id => p_site_id,

Line 696: AMS_UTILITY_PVT.debug_message('Private API: Just after calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);

692: p_object_version_number => p_object_version_number
693: );
694: IF (AMS_DEBUG_HIGH_ON) THEN
695:
696: AMS_UTILITY_PVT.debug_message('Private API: Just after calling Delete site_id = ' || p_site_id || 'obj_ver_no = ' || p_object_version_number);
697: END IF;
698: -- ELSE -- VERSIONS DOESN'T MATCH
699: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
700: -- THEN

Line 722: AMS_UTILITY_PVT.debug_message( 'Private API: before Commit : p_commit = '|| p_commit);

718: IF (AMS_DEBUG_HIGH_ON) THEN
719:
720:
721:
722: AMS_UTILITY_PVT.debug_message( 'Private API: before Commit : p_commit = '|| p_commit);
723:
724: END IF;
725: -- Standard check for p_commit
726: IF FND_API.to_Boolean( p_commit )

Line 731: AMS_UTILITY_PVT.debug_message( 'Private API: After Commit : p_commit = '|| p_commit);

727: THEN
728: COMMIT WORK;
729: IF (AMS_DEBUG_HIGH_ON) THEN
730:
731: AMS_UTILITY_PVT.debug_message( 'Private API: After Commit : p_commit = '|| p_commit);
732: END IF;
733: END IF;
734:
735:

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

735:
736: -- Debug Message
737: IF (AMS_DEBUG_HIGH_ON) THEN
738:
739: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
740: END IF;
741:
742: -- Standard call to get message count and if count is 1, get message info.
743: FND_MSG_PUB.Count_And_Get

Line 749: WHEN AMS_Utility_PVT.resource_locked THEN

745: p_data => x_msg_data
746: );
747: EXCEPTION
748:
749: WHEN AMS_Utility_PVT.resource_locked THEN
750: x_return_status := FND_API.g_ret_sts_error;
751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
752:
753: WHEN FND_API.G_EXC_ERROR THEN

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

747: EXCEPTION
748:
749: WHEN AMS_Utility_PVT.resource_locked THEN
750: x_return_status := FND_API.g_ret_sts_error;
751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
752:
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO DELETE_Iba_Pl_Sites_PVT;
755: x_return_status := FND_API.G_RET_STS_ERROR;

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

817:
818: -- Debug Message
819: IF (AMS_DEBUG_HIGH_ON) THEN
820:
821: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
822: END IF;
823:
824: -- Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean( p_init_msg_list )

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

845: IF (AMS_DEBUG_HIGH_ON) THEN
846:
847:
848:
849: AMS_Utility_PVT.debug_message(l_full_name||': start');
850:
851: END IF;
852: OPEN c_Iba_Pl_Sites;
853:

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

871: p_data => x_msg_data
872: );
873: IF (AMS_DEBUG_HIGH_ON) THEN
874:
875: AMS_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877: EXCEPTION
878:
879: WHEN AMS_Utility_PVT.resource_locked THEN

Line 879: WHEN AMS_Utility_PVT.resource_locked THEN

875: AMS_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877: EXCEPTION
878:
879: WHEN AMS_Utility_PVT.resource_locked THEN
880: x_return_status := FND_API.g_ret_sts_error;
881: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
882:
883: WHEN FND_API.G_EXC_ERROR THEN

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

877: EXCEPTION
878:
879: WHEN AMS_Utility_PVT.resource_locked THEN
880: x_return_status := FND_API.g_ret_sts_error;
881: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
882:
883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO LOCK_Iba_Pl_Sites_PVT;
885: x_return_status := FND_API.G_RET_STS_ERROR;

Line 935: l_site_id_flag := ams_uTILITY_pvt.check_uniqueness(

931: x_return_status := FND_API.g_ret_sts_success;
932: --If Validation_mode is create, check uniqueness of site_id, name, site_ref_code
933: if p_validation_mode = JTF_PLSQL_API.g_create then
934: -- Checking if the site id passed is unique
935: l_site_id_flag := ams_uTILITY_pvt.check_uniqueness(
936: 'ams_iba_pl_sites_b'
937: , 'site_id = ''' || p_iba_pl_sites_rec.site_id ||''''
938: );
939:

Line 941: ams_utility_pvt.Error_Message(p_message_name => 'AMS_PLCE_SITE_ID_DUP');

937: , 'site_id = ''' || p_iba_pl_sites_rec.site_id ||''''
938: );
939:
940: if l_site_id_flag = fnd_api.g_false then
941: ams_utility_pvt.Error_Message(p_message_name => 'AMS_PLCE_SITE_ID_DUP');
942: x_return_status := fnd_api.g_ret_sts_error;
943: return;
944: end if;
945:

Line 947: l_site_name_flag := ams_utility_pvt.check_uniqueness(

943: return;
944: end if;
945:
946: -- Checking if the site name passed is unique
947: l_site_name_flag := ams_utility_pvt.check_uniqueness(
948: 'ams_iba_pl_sites_vl'
949: , 'name = ''' || p_iba_pl_sites_rec.name ||''''
950: );
951: if l_site_name_flag = fnd_api.g_false then

Line 952: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');

948: 'ams_iba_pl_sites_vl'
949: , 'name = ''' || p_iba_pl_sites_rec.name ||''''
950: );
951: if l_site_name_flag = fnd_api.g_false then
952: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');
953: x_return_status := fnd_api.g_ret_sts_error;
954: return;
955: end if;
956:

Line 958: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(

954: return;
955: end if;
956:
957: -- Checking if the site ref code passed is unique
958: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(
959: 'ams_iba_pl_sites_vl'
960: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''''
961: );
962: if l_site_ref_code_flag = fnd_api.g_false then

Line 963: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');

959: 'ams_iba_pl_sites_vl'
960: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''''
961: );
962: if l_site_ref_code_flag = fnd_api.g_false then
963: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');
964: x_return_status := fnd_api.g_ret_sts_error;
965: return;
966: end if;
967: end if;

Line 972: l_site_name_flag := ams_utility_pvt.check_uniqueness(

968:
969: --If Validation_mode is update, check uniqueness of site name, site_ref_code
970: if p_validation_mode = JTF_PLSQL_API.g_update then
971: -- Checking if the site name passed is unique
972: l_site_name_flag := ams_utility_pvt.check_uniqueness(
973: 'ams_iba_pl_sites_vl'
974: , 'name = ''' || p_iba_pl_sites_rec.name ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
975: );
976: IF (AMS_DEBUG_HIGH_ON) THEN

Line 978: AMS_UTILITY_PVT.debug_message('In update unique check - site_name: ' || p_iba_pl_sites_rec.name);

974: , 'name = ''' || p_iba_pl_sites_rec.name ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
975: );
976: IF (AMS_DEBUG_HIGH_ON) THEN
977:
978: AMS_UTILITY_PVT.debug_message('In update unique check - site_name: ' || p_iba_pl_sites_rec.name);
979: END IF;
980: if l_site_name_flag = fnd_api.g_false then
981: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');
982: x_return_status := fnd_api.g_ret_sts_error;

Line 981: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');

977:
978: AMS_UTILITY_PVT.debug_message('In update unique check - site_name: ' || p_iba_pl_sites_rec.name);
979: END IF;
980: if l_site_name_flag = fnd_api.g_false then
981: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');
982: x_return_status := fnd_api.g_ret_sts_error;
983: return;
984: end if;
985:

Line 987: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(

983: return;
984: end if;
985:
986: -- Checking if the site ref code passed is unique
987: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(
988: 'ams_iba_pl_sites_vl'
989: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
990: );
991: if l_site_ref_code_flag = fnd_api.g_false then

Line 992: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');

988: 'ams_iba_pl_sites_vl'
989: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
990: );
991: if l_site_ref_code_flag = fnd_api.g_false then
992: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');
993: x_return_status := fnd_api.g_ret_sts_error;
994: return;
995: end if;
996: end if;

Line 1013: AMS_Utility_PVT.Error_Message(p_message_name => 'private API :in check required columns procedure');

1009:
1010: ---------------
1011: -- sodixit : commenting the following lines as validation of the required fields for mode = create will be done in middle tier
1012: ---------------
1013: AMS_Utility_PVT.Error_Message(p_message_name => 'private API :in check required columns procedure');
1014: -- IF (p_iba_pl_sites_rec.site_id = FND_API.g_miss_num) OR (p_iba_pl_sites_rec.site_id IS NULL)
1015: -- THEN
1016: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_id');
1017: -- x_return_status := FND_API.g_ret_sts_error;

Line 1016: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_id');

1012: ---------------
1013: AMS_Utility_PVT.Error_Message(p_message_name => 'private API :in check required columns procedure');
1014: -- IF (p_iba_pl_sites_rec.site_id = FND_API.g_miss_num) OR (p_iba_pl_sites_rec.site_id IS NULL)
1015: -- THEN
1016: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_id');
1017: -- x_return_status := FND_API.g_ret_sts_error;
1018: -- RETURN;
1019: -- END IF;
1020:

Line 1023: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_ref_code');

1019: -- END IF;
1020:
1021: -- IF (p_iba_pl_sites_rec.site_ref_code = FND_API.g_miss_char) OR (p_iba_pl_sites_rec.site_ref_code IS NULL)
1022: ---- THEN
1023: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_ref_code');
1024: -- x_return_status := FND_API.g_ret_sts_error;
1025: -- RETURN;
1026: -- END IF;
1027:

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

1027:
1028:
1029: -- IF (p_iba_pl_sites_rec.site_category_type = FND_API.g_miss_char) OR (p_iba_pl_sites_rec.site_category_type IS NULL)
1030: -- THEN
1031: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_category_type');
1032: -- x_return_status := FND_API.g_ret_sts_error;
1033: -- RETURN;
1034: -- END IF;
1035:

Line 1039: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_status_code');

1035:
1036:
1037: -- IF (p_iba_pl_sites_rec.status_code = FND_API.g_miss_char) OR (p_iba_pl_sites_rec.status_code IS NULL)
1038: -- THEN
1039: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_status_code');
1040: -- x_return_status := FND_API.g_ret_sts_error;
1041: -- RETURN;
1042: -- END IF;
1043:

Line 1047: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_created_by');

1043:
1044:
1045: -- IF (p_iba_pl_sites_rec.created_by = FND_API.g_miss_num) OR (p_iba_pl_sites_rec.created_by IS NULL)
1046: -- THEN
1047: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_created_by');
1048: -- x_return_status := FND_API.g_ret_sts_error;
1049: -- RETURN;
1050: -- END IF;
1051:

Line 1055: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_creation_date');

1051:
1052:
1053: -- IF (p_iba_pl_sites_rec.creation_date = FND_API.g_miss_date) OR (p_iba_pl_sites_rec.creation_date IS NULL)
1054: -- THEN
1055: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_creation_date');
1056: -- x_return_status := FND_API.g_ret_sts_error;
1057: -- RETURN;
1058: -- END IF;
1059: --

Line 1063: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_updated_by');

1059: --
1060:
1061: -- IF p_iba_pl_sites_rec.last_updated_by = FND_API.g_miss_num OR p_iba_pl_sites_rec.last_updated_by IS NULL
1062: -- THEN
1063: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_updated_by');
1064: -- x_return_status := FND_API.g_ret_sts_error;
1065: -- RETURN;
1066: -- END IF;
1067: --

Line 1071: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_update_date');

1067: --
1068:
1069: ---- IF p_iba_pl_sites_rec.last_update_date = FND_API.g_miss_date OR p_iba_pl_sites_rec.last_update_date IS NULL
1070: -- THEN
1071: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_update_date');
1072: -- x_return_status := FND_API.g_ret_sts_error;
1073: -- RETURN;
1074: -- END IF;
1075:

Line 1079: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_id');

1075:
1076: ELSE
1077:
1078: IF p_iba_pl_sites_rec.site_id IS NULL THEN
1079: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_id');
1080: x_return_status := FND_API.g_ret_sts_error;
1081: RETURN;
1082: END IF;
1083:

Line 1086: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_ref_code');

1082: END IF;
1083:
1084:
1085: IF p_iba_pl_sites_rec.site_ref_code IS NULL THEN
1086: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_ref_code');
1087: x_return_status := FND_API.g_ret_sts_error;
1088: RETURN;
1089: END IF;
1090:

Line 1093: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_category_type');

1089: END IF;
1090:
1091:
1092: IF p_iba_pl_sites_rec.site_category_type IS NULL THEN
1093: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_site_category_type');
1094: x_return_status := FND_API.g_ret_sts_error;
1095: RETURN;
1096: END IF;
1097:

Line 1100: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_status_code');

1096: END IF;
1097:
1098:
1099: IF p_iba_pl_sites_rec.status_code IS NULL THEN
1100: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_status_code');
1101: x_return_status := FND_API.g_ret_sts_error;
1102: RETURN;
1103: END IF;
1104:

Line 1107: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_created_by');

1103: END IF;
1104:
1105:
1106: IF p_iba_pl_sites_rec.created_by IS NULL THEN
1107: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_created_by');
1108: x_return_status := FND_API.g_ret_sts_error;
1109: RETURN;
1110: END IF;
1111:

Line 1114: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_creation_date');

1110: END IF;
1111:
1112:
1113: IF p_iba_pl_sites_rec.creation_date IS NULL THEN
1114: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_creation_date');
1115: x_return_status := FND_API.g_ret_sts_error;
1116: RETURN;
1117: END IF;
1118:

Line 1121: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_updated_by');

1117: END IF;
1118:
1119:
1120: IF p_iba_pl_sites_rec.last_updated_by IS NULL THEN
1121: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_updated_by');
1122: x_return_status := FND_API.g_ret_sts_error;
1123: RETURN;
1124: END IF;
1125:

Line 1128: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_update_date');

1124: END IF;
1125:
1126:
1127: IF p_iba_pl_sites_rec.last_update_date IS NULL THEN
1128: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_iba_pl_sites_NO_last_update_date');
1129: x_return_status := FND_API.g_ret_sts_error;
1130: RETURN;
1131: END IF;
1132: END IF;

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

1382:
1383: -- Debug Message
1384: IF (AMS_DEBUG_HIGH_ON) THEN
1385:
1386: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1387: END IF;
1388:
1389:
1390: -- Initialize API return status to SUCCESS

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

1393:
1394: -- Debug Message
1395: IF (AMS_DEBUG_HIGH_ON) THEN
1396:
1397: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1398: END IF;
1399:
1400: -- Standard call to get message count and if count is 1, get message info.
1401: FND_MSG_PUB.Count_And_Get

Line 1407: WHEN AMS_Utility_PVT.resource_locked THEN

1403: p_data => x_msg_data
1404: );
1405: EXCEPTION
1406:
1407: WHEN AMS_Utility_PVT.resource_locked THEN
1408: x_return_status := FND_API.g_ret_sts_error;
1409: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1410:
1411: WHEN FND_API.G_EXC_ERROR THEN

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

1405: EXCEPTION
1406:
1407: WHEN AMS_Utility_PVT.resource_locked THEN
1408: x_return_status := FND_API.g_ret_sts_error;
1409: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1410:
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: ROLLBACK TO validate_iba_pl_sites_;
1413: x_return_status := FND_API.G_RET_STS_ERROR;

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

1470:
1471: -- Debug Message
1472: IF (AMS_DEBUG_HIGH_ON) THEN
1473:
1474: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1475: END IF;
1476: -- Standard call to get message count and if count is 1, get message info.
1477: FND_MSG_PUB.Count_And_Get
1478: (p_count => x_msg_count,