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_ACTRESOURCE_PVT dependencies on FND_MSG_PUB

Line 32: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

28: g_debug boolean := FALSE;
29: g_debug boolean := TRUE;
30: --
31:
32: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: PROCEDURE Check_Resource_Booked (

Line 33: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

29: g_debug boolean := TRUE;
30: --
31:
32: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: PROCEDURE Check_Resource_Booked (
37: p_act_Resource_rec IN act_Resource_rec_type,

Line 34: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

30: --
31:
32: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: PROCEDURE Check_Resource_Booked (
37: p_act_Resource_rec IN act_Resource_rec_type,
38: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

Line 109: FND_MSG_PUB.initialize;

105:
106: -- Initialize message list IF p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )
108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:
112: -- Initialize API return status to success
113: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 274: FND_MSG_PUB.Count_AND_Get

270: THEN
271: COMMIT WORK;
272: END IF;
273: -- Standard call to get message count AND IF count is 1, get message info.
274: FND_MSG_PUB.Count_AND_Get
275: ( p_count => x_msg_count,
276: p_data => x_msg_data,
277: p_encoded => FND_API.G_FALSE
278: );

Line 283: FND_MSG_PUB.Count_AND_Get

279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO Create_Act_Resource_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_AND_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data,
286: p_encoded => FND_API.G_FALSE
287: );

Line 291: FND_MSG_PUB.Count_AND_Get

287: );
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: -- ROLLBACK TO Create_Act_Resource_PVT;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291: FND_MSG_PUB.Count_AND_Get
292: ( p_count => x_msg_count,
293: p_data => x_msg_data,
294: p_encoded => FND_API.G_FALSE
295: );

Line 299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

295: );
296: WHEN OTHERS THEN
297: ROLLBACK TO Create_Act_Resource_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
302: END IF;
303:

Line 301: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

297: ROLLBACK TO Create_Act_Resource_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
302: END IF;
303:
304: FND_MSG_PUB.Count_AND_Get
305: ( p_count => x_msg_count,

Line 304: FND_MSG_PUB.Count_AND_Get

300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
302: END IF;
303:
304: FND_MSG_PUB.Count_AND_Get
305: ( p_count => x_msg_count,
306: p_data => x_msg_data,
307: p_encoded => FND_API.G_FALSE
308: );

Line 370: FND_MSG_PUB.initialize;

366: END IF;
367:
368: -- Initialize message list IF p_init_msg_list is set to TRUE.
369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

500: AND object_version_number = l_act_Resource_rec.object_version_number;
501:
502: IF (SQL%NOTFOUND)
503: THEN
504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN -- MMSG
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.Add;
508: END IF;

Line 507: FND_MSG_PUB.Add;

503: THEN
504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
505: THEN -- MMSG
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.Add;
508: END IF;
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:

Line 518: FND_MSG_PUB.Count_AND_Get

514: THEN
515: COMMIT WORK;
516: END IF;
517: -- Standard call to get message count AND IF count is 1, get message info.
518: FND_MSG_PUB.Count_AND_Get
519: ( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE
522: );

Line 527: FND_MSG_PUB.Count_AND_Get

523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO Update_Act_Resource_PVT;
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_AND_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data,
530: p_encoded => FND_API.G_FALSE
531: );

Line 536: FND_MSG_PUB.Count_AND_Get

532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO Update_Act_Resource_PVT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
536: FND_MSG_PUB.Count_AND_Get
537: ( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE
540: );

Line 545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

541:
542: WHEN OTHERS THEN
543: ROLLBACK TO Update_Act_Resource_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
548: END IF;
549:

Line 547: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

543: ROLLBACK TO Update_Act_Resource_PVT;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
548: END IF;
549:
550: FND_MSG_PUB.Count_AND_Get
551: ( p_count => x_msg_count,

Line 550: FND_MSG_PUB.Count_AND_Get

546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
548: END IF;
549:
550: FND_MSG_PUB.Count_AND_Get
551: ( p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE
554: );

Line 607: FND_MSG_PUB.initialize;

603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Initialize API return status to success
611: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

616: WHERE ACTIVITY_RESOURCE_ID = p_act_Resource_id
617: AND p_object_version = p_object_version;
618:
619: IF (SQL%NOTFOUND) THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;

Line 622: FND_MSG_PUB.add;

618:
619: IF (SQL%NOTFOUND) THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;
625: END IF;
626:

Line 635: FND_MSG_PUB.Count_AND_Get

631: COMMIT WORK;
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
636: ( p_count => x_msg_count,
637: p_data => x_msg_data,
638: p_encoded => FND_API.G_FALSE
639: );

Line 644: FND_MSG_PUB.Count_AND_Get

640: EXCEPTION
641: WHEN FND_API.G_EXC_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PVT;
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
648: );

Line 652: FND_MSG_PUB.Count_AND_Get

648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Delete_Act_Resource_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.Count_AND_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data,
655: p_encoded => FND_API.G_FALSE
656: );

Line 662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

658: WHEN OTHERS THEN
659: ROLLBACK TO Delete_Act_Resource_PVT;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
665: END IF;
666:

Line 664: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
665: END IF;
666:
667: FND_MSG_PUB.Count_AND_Get
668: ( p_count => x_msg_count,

Line 667: FND_MSG_PUB.Count_AND_Get

663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
665: END IF;
666:
667: FND_MSG_PUB.Count_AND_Get
668: ( p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => FND_API.G_FALSE
671: );

Line 724: FND_MSG_PUB.initialize;

720:
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
723: THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize API return status to success
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

733: IF (c_act_resource%NOTFOUND)
734: THEN
735: CLOSE c_act_resource;
736:
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
738: THEN
739: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.Add;
741: END IF;

Line 740: FND_MSG_PUB.Add;

736:
737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
738: THEN
739: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.Add;
741: END IF;
742:
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;

Line 750: FND_MSG_PUB.Count_AND_Get

746: --
747: -- END of API body.
748: --
749: -- Standard call to get message count AND IF count is 1, get message info.
750: FND_MSG_PUB.Count_AND_Get
751: ( p_count => x_msg_count,
752: p_data => x_msg_data,
753: p_encoded => FND_API.G_FALSE
754: );

Line 758: FND_MSG_PUB.Count_AND_Get

754: );
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR ;
758: FND_MSG_PUB.Count_AND_Get
759: ( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => FND_API.G_FALSE
762: );

Line 765: FND_MSG_PUB.Count_AND_Get

761: p_encoded => FND_API.G_FALSE
762: );
763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_AND_Get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
769: );

Line 772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

768: p_encoded => FND_API.G_FALSE
769: );
770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;
775: END IF;
776:

Line 774: FND_MSG_PUB.add;

770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;
775: END IF;
776:
777: FND_MSG_PUB.Count_AND_Get
778: ( p_count => x_msg_count,

Line 777: FND_MSG_PUB.Count_AND_Get

773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;
775: END IF;
776:
777: FND_MSG_PUB.Count_AND_Get
778: ( p_count => x_msg_count,
779: p_data => x_msg_data,
780: p_encoded => FND_API.G_FALSE
781: );

Line 784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

780: p_encoded => FND_API.G_FALSE
781: );
782: WHEN OTHERS THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
787: END IF;
788:

Line 786: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

782: WHEN OTHERS THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
787: END IF;
788:
789: FND_MSG_PUB.Count_AND_Get
790: ( p_count => x_msg_count,

Line 789: FND_MSG_PUB.Count_AND_Get

785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
787: END IF;
788:
789: FND_MSG_PUB.Count_AND_Get
790: ( p_count => x_msg_count,
791: p_data => x_msg_data,
792: p_encoded => FND_API.G_FALSE
793: );

Line 841: FND_MSG_PUB.initialize;

837: END IF;
838:
839: -- Initialize message list if p_init_msg_list is set to TRUE.
840: IF FND_API.to_Boolean( p_init_msg_list ) THEN
841: FND_MSG_PUB.initialize;
842: END IF;
843:
844: -- Initialize API return status to success
845: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 893: FND_MSG_PUB.count_and_get(

889:
890: END IF;
891:
892: -------------------- finish --------------------------
893: FND_MSG_PUB.count_and_get(
894: p_encoded => FND_API.g_false,
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );

Line 901: FND_MSG_PUB.Count_AND_Get

897: );
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: FND_MSG_PUB.Count_AND_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE
905: );

Line 908: FND_MSG_PUB.Count_AND_Get

904: p_encoded => FND_API.G_FALSE
905: );
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
911: p_encoded => FND_API.G_FALSE
912: );

Line 915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

911: p_encoded => FND_API.G_FALSE
912: );
913: WHEN OTHERS THEN
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
918: END IF;
919:

Line 917: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);

913: WHEN OTHERS THEN
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
918: END IF;
919:
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,

Line 920: FND_MSG_PUB.Count_AND_Get

916: THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
918: END IF;
919:
920: FND_MSG_PUB.Count_AND_Get
921: ( p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => FND_API.G_FALSE
924: );

Line 957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

953: 'ams_act_resources_v',
954: 'activity_resource_id = ' || p_act_Resource_rec.activity_resource_id
955: ) = FND_API.g_false
956: THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_RES_DUPLICATE_ID');
959: FND_MSG_PUB.add;
960: END IF;
961: x_return_status := FND_API.g_ret_sts_error;

Line 959: FND_MSG_PUB.add;

955: ) = FND_API.g_false
956: THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_RES_DUPLICATE_ID');
959: FND_MSG_PUB.add;
960: END IF;
961: x_return_status := FND_API.g_ret_sts_error;
962: RETURN;
963: END IF;

Line 1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

996: ------------------------ user_status_id --------------------------
997: IF (p_act_Resource_rec.user_status_id IS NULL OR
998: p_act_Resource_rec.user_status_id = FND_API.g_miss_num)
999: THEN
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
1002: FND_MSG_PUB.add;
1003: END IF;
1004: x_return_status := FND_API.g_ret_sts_error;

Line 1002: FND_MSG_PUB.add;

998: p_act_Resource_rec.user_status_id = FND_API.g_miss_num)
999: THEN
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
1002: FND_MSG_PUB.add;
1003: END IF;
1004: x_return_status := FND_API.g_ret_sts_error;
1005: END IF;
1006:

Line 1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1007: ------------------------ application_id --------------------------
1008: /* IF (p_act_Resource_rec.application_id IS NULL OR
1009: p_act_Resource_rec.application_id = FND_API.g_miss_num)
1010: THEN
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1013: FND_MSG_PUB.add;
1014: END IF;
1015: x_return_status := FND_API.g_ret_sts_error;

Line 1013: FND_MSG_PUB.add;

1009: p_act_Resource_rec.application_id = FND_API.g_miss_num)
1010: THEN
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
1013: FND_MSG_PUB.add;
1014: END IF;
1015: x_return_status := FND_API.g_ret_sts_error;
1016: RETURN;
1017: END IF; */

Line 1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1019: ------------------------ resource_id--------------------------
1020: IF (p_act_Resource_rec.resource_id IS NULL OR
1021: p_act_Resource_rec.resource_id = FND_API.g_miss_num)
1022: THEN
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;

Line 1025: FND_MSG_PUB.add;

1021: p_act_Resource_rec.resource_id = FND_API.g_miss_num)
1022: THEN
1023: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1024: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_RESOURCE_ID');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;
1028: RETURN;
1029: ELSE

Line 1039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1035: CLOSE c_primary_coordinator;
1036:
1037: IF( l_coordinator_id = p_act_Resource_rec.resource_id AND p_act_Resource_rec.role_cd = 'COORDINATOR')
1038: THEN
1039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1040: FND_MESSAGE.set_name('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1041: FND_MSG_PUB.add;
1042: END IF;
1043: x_return_status := FND_API.g_ret_sts_error;

Line 1041: FND_MSG_PUB.add;

1037: IF( l_coordinator_id = p_act_Resource_rec.resource_id AND p_act_Resource_rec.role_cd = 'COORDINATOR')
1038: THEN
1039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1040: FND_MESSAGE.set_name('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1041: FND_MSG_PUB.add;
1042: END IF;
1043: x_return_status := FND_API.g_ret_sts_error;
1044: RETURN;
1045: END IF;

Line 1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1048: ------------------------ role_cd--------------------------
1049: IF (p_act_Resource_rec.role_cd IS NULL OR
1050: p_act_Resource_rec.role_cd = FND_API.g_miss_char)
1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;

Line 1054: FND_MSG_PUB.add;

1050: p_act_Resource_rec.role_cd = FND_API.g_miss_char)
1051: THEN
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1053: FND_MESSAGE.set_name('AMS', 'AMS_NO_ROLE_CD');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;
1058: END IF;

Line 1064: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1060: ------------ ACT_RESOURCE_USED_BY_ID -------------------------------------
1061: IF (p_act_Resource_rec.act_resource_used_by_id = FND_API.G_MISS_NUM OR
1062: p_act_Resource_rec.act_resource_used_by_id IS NULL)
1063: THEN
1064: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1065: THEN
1066: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBYID');
1067: FND_MSG_PUB.add;
1068: END IF;

Line 1067: FND_MSG_PUB.add;

1063: THEN
1064: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1065: THEN
1066: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBYID');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;
1071: END IF;

Line 1078: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1074: IF (p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY = FND_API.G_MISS_CHAR OR
1075: p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY IS NULL)
1076: THEN
1077: -- missing required fields
1078: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1079: THEN -- MMSG
1080: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBY');
1081: FND_MSG_PUB.add;
1082: END IF;

Line 1081: FND_MSG_PUB.add;

1077: -- missing required fields
1078: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1079: THEN -- MMSG
1080: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_NO_USEDBY');
1081: FND_MSG_PUB.add;
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: -- If any error happens abort API.
1085: RETURN;

Line 1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1121: 'application_id',
1122: p_act_Resource_rec.application_id
1123: ) = FND_API.g_false
1124: THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1126: THEN
1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1128: FND_MSG_PUB.add;
1129: END IF;

Line 1128: FND_MSG_PUB.add;

1124: THEN
1125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1126: THEN
1127: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
1128: FND_MSG_PUB.add;
1129: END IF;
1130: x_return_status := FND_API.g_ret_sts_error;
1131: RETURN;
1132: END IF;

Line 1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1140: 'user_status_id',
1141: p_act_Resource_rec.user_status_id
1142: ) = FND_API.g_false
1143: THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1145: THEN
1146: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');
1147: FND_MSG_PUB.add;
1148: END IF;

Line 1147: FND_MSG_PUB.add;

1143: THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1145: THEN
1146: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');
1147: FND_MSG_PUB.add;
1148: END IF;
1149:
1150: x_return_status := FND_API.g_ret_sts_error;
1151: RETURN;

Line 1167: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1163: ,p_pk_name => l_pk_name
1164: ,p_pk_value => l_pk_value
1165: ) = FND_API.G_FALSE
1166: THEN
1167: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1168: THEN
1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1170: FND_MSG_PUB.add;
1171: END IF;

Line 1170: FND_MSG_PUB.add;

1166: THEN
1167: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1168: THEN
1169: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_RESOURCE');
1170: FND_MSG_PUB.add;
1171: END IF;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: -- If any errors happen abort API/Procedure.
1174: RETURN;

Line 1198: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1194: ,p_pk_name => l_pk_name
1195: ,p_pk_value => l_pk_value
1196: ) = FND_API.G_FALSE
1197: THEN
1198: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1199: THEN
1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');
1201: FND_MSG_PUB.add;
1202: END IF;

Line 1201: FND_MSG_PUB.add;

1197: THEN
1198: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1199: THEN
1200: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_INVALID_REFERENCE');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: -- If any errors happen abort API/Procedure.
1205: RETURN;

Line 1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1232: p_lookup_type => 'AMS_EVENT_ROLE',
1233: p_lookup_code => p_act_Resource_rec.role_cd
1234: ) = FND_API.g_false
1235: THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1237: THEN
1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');
1239: FND_MSG_PUB.add;
1240: END IF;

Line 1239: FND_MSG_PUB.add;

1235: THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1237: THEN
1238: FND_MESSAGE.set_name('AMS', 'AMS_BAD_ROLE_TYPE');
1239: FND_MSG_PUB.add;
1240: END IF;
1241: x_return_status := FND_API.g_ret_sts_error;
1242: RETURN;
1243: END IF;

Line 1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1251: p_lookup_type => 'AMS_EVENT_AGENDA_STATUS',
1252: p_lookup_code => p_act_Resource_rec.system_status_code
1253: ) = FND_API.g_false
1254: THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1256: THEN
1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');
1258: FND_MSG_PUB.add;
1259: END IF;

Line 1258: FND_MSG_PUB.add;

1254: THEN
1255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1256: THEN
1257: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BAD_USER_STATUS');
1258: FND_MSG_PUB.add;
1259: END IF;
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;
1262: END IF;

Line 1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1268: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1269: p_lookup_code => p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY
1270: ) = FND_API.g_false
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');
1275: FND_MSG_PUB.add;
1276: END IF;

Line 1275: FND_MSG_PUB.add;

1271: THEN
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('AMS', 'AMS_ACT_RSC_BAD_SYS_ARC');
1275: FND_MSG_PUB.add;
1276: END IF;
1277: x_return_status := FND_API.g_ret_sts_error;
1278: RETURN;
1279: END IF;

Line 1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1306: AND p_act_Resource_rec.primary_flag IS NOT NULL
1307: THEN
1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false
1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1313: FND_MSG_PUB.add;
1314: END IF;

Line 1313: FND_MSG_PUB.add;

1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1313: FND_MSG_PUB.add;
1314: END IF;
1315: x_return_status := FND_API.g_ret_sts_error;
1316: RETURN;
1317: END IF;

Line 1406: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1402: CLOSE c_parent_status;
1403:
1404: IF(l_count > 0)
1405: THEN
1406: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1407: THEN
1408: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1409: Fnd_Msg_Pub.ADD;
1410: END IF;

Line 1409: Fnd_Msg_Pub.ADD;

1405: THEN
1406: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1407: THEN
1408: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1409: Fnd_Msg_Pub.ADD;
1410: END IF;
1411: RAISE FND_API.g_exc_error;
1412: END IF;
1413:

Line 1417: FND_MSG_PUB.add;

1413:
1414: IF p_act_Resource_rec.start_date_time < l_parent_start_date
1415: THEN
1416: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_SES_STTIME');
1417: FND_MSG_PUB.add;
1418: RAISE FND_API.g_exc_error;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN
1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');

Line 1422: FND_MSG_PUB.add;

1418: RAISE FND_API.g_exc_error;
1419: ELSIF p_act_Resource_rec.end_date_time > l_parent_end_date
1420: THEN
1421: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_SES_EDTIME');
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.g_exc_error;
1424: END IF;
1425:
1426: ELSIF(p_act_Resource_rec.arc_act_resource_used_by = 'EVEO'

Line 1439: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1435: CLOSE c_event_status;
1436:
1437: IF(l_count > 0)
1438: THEN
1439: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1440: THEN
1441: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1442: Fnd_Msg_Pub.ADD;
1443: END IF;

Line 1442: Fnd_Msg_Pub.ADD;

1438: THEN
1439: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1440: THEN
1441: Fnd_Message.set_name('AMS', 'AMS_NO_RESOURCE');
1442: Fnd_Msg_Pub.ADD;
1443: END IF;
1444: RAISE FND_API.g_exc_error;
1445: END IF;
1446:

Line 1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1450: l_end_date := TO_DATE(TO_CHAR(l_parent_end_date,'DD:MM:YYYY'),'DD:MM:YYYY');
1451:
1452: IF l_res_start_date < l_start_date
1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1455: THEN
1456: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_GT_PRNT_SD');
1457: FND_MSG_PUB.add;
1458: END IF;

Line 1457: FND_MSG_PUB.add;

1453: THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1455: THEN
1456: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_GT_PRNT_SD');
1457: FND_MSG_PUB.add;
1458: END IF;
1459: x_return_status := FND_API.g_ret_sts_error;
1460: RETURN;
1461: ELSIF l_res_start_date > l_end_date

Line 1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1459: x_return_status := FND_API.g_ret_sts_error;
1460: RETURN;
1461: ELSIF l_res_start_date > l_end_date
1462: THEN
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1464: THEN
1465: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_ST_PRNT_ED');
1466: FND_MSG_PUB.add;
1467: END IF;

Line 1466: FND_MSG_PUB.add;

1462: THEN
1463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1464: THEN
1465: FND_MESSAGE.set_name('AMS', 'AMS_RES_SD_ST_PRNT_ED');
1466: FND_MSG_PUB.add;
1467: END IF;
1468: x_return_status := FND_API.g_ret_sts_error;
1469: RETURN;
1470: ELSIF l_res_start_date = l_start_date

Line 1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1473: AND
1474: TO_CHAR(l_parent_start_date,'HH24:MI') <> '00:00'
1475: AND p_act_Resource_rec.start_date_time < l_parent_start_date )
1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_EVN_STTIME');
1480: FND_MSG_PUB.add;
1481: END IF;

Line 1480: FND_MSG_PUB.add;

1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_RES_STTIME_LS_EVN_STTIME');
1480: FND_MSG_PUB.add;
1481: END IF;
1482: x_return_status := FND_API.g_ret_sts_error;
1483: RETURN;
1484: END IF;

Line 1489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1485: END IF;
1486:
1487: IF l_res_end_date < l_start_date
1488: THEN
1489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1490: THEN
1491: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_GT_PRNT_SD');
1492: FND_MSG_PUB.add;
1493: END IF;

Line 1492: FND_MSG_PUB.add;

1488: THEN
1489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1490: THEN
1491: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_GT_PRNT_SD');
1492: FND_MSG_PUB.add;
1493: END IF;
1494: x_return_status := FND_API.g_ret_sts_error;
1495: RETURN;
1496: ELSIF l_res_end_date > l_end_date

Line 1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1494: x_return_status := FND_API.g_ret_sts_error;
1495: RETURN;
1496: ELSIF l_res_end_date > l_end_date
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_LT_PRNT_ED');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;

Line 1500: FND_MSG_PUB.add;

1496: ELSIF l_res_end_date > l_end_date
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1499: FND_MESSAGE.set_name('AMS', 'AMS_RES_ED_LT_PRNT_ED');
1500: FND_MSG_PUB.add;
1501: END IF;
1502: x_return_status := FND_API.g_ret_sts_error;
1503: RETURN;
1504: ELSIF l_res_end_date = l_end_date

Line 1511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1507: AND
1508: TO_CHAR(l_parent_end_date,'HH24:MI') <> '00:00'
1509: AND p_act_Resource_rec.end_date_time > l_parent_end_date)
1510: THEN
1511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1512: THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_EVN_EDTIME');
1514: FND_MSG_PUB.add;
1515: END IF;

Line 1514: FND_MSG_PUB.add;

1510: THEN
1511: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1512: THEN
1513: FND_MESSAGE.set_name('AMS', 'AMS_RES_EDTIME_GT_EVN_EDTIME');
1514: FND_MSG_PUB.add;
1515: END IF;
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;

Line 1622: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1618:
1619: /* The End Time has to be greater than Start Time */
1620: IF ( p_act_Resource_rec.start_date_time > p_act_Resource_rec.end_date_time)
1621: THEN
1622: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1623: THEN
1624: FND_MESSAGE.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
1625: FND_MSG_PUB.add;
1626: END IF;

Line 1625: FND_MSG_PUB.add;

1621: THEN
1622: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1623: THEN
1624: FND_MESSAGE.set_name('AMS', 'AMS_EDTIME_LS_STTIME');
1625: FND_MSG_PUB.add;
1626: END IF;
1627: x_return_status := FND_API.g_ret_sts_error;
1628: RETURN;
1629: END IF;

Line 1712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)

1708: END;
1709:
1710: IF l_count > 0
1711: THEN
1712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)
1713: THEN
1714: FND_MESSAGE.set_name ('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1715: FND_MSG_PUB.add;
1716: END IF;

Line 1715: FND_MSG_PUB.add;

1711: THEN
1712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error)
1713: THEN
1714: FND_MESSAGE.set_name ('AMS', 'AMS_SAME_COORDINATOR_PRESENT');
1715: FND_MSG_PUB.add;
1716: END IF;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: ELSE

Line 1799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1795: OPEN c_resource;
1796: FETCH c_resource INTO l_act_Resource_rec;
1797: IF c_resource%NOTFOUND THEN
1798: CLOSE c_resource;
1799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1800: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1801: FND_MSG_PUB.add;
1802: END IF;
1803: RAISE FND_API.g_exc_error;

Line 1801: FND_MSG_PUB.add;

1797: IF c_resource%NOTFOUND THEN
1798: CLOSE c_resource;
1799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1800: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1801: FND_MSG_PUB.add;
1802: END IF;
1803: RAISE FND_API.g_exc_error;
1804: END IF;
1805: CLOSE c_resource;

Line 2186: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

2182:
2183: END IF; --IF(p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2184:
2185: <>
2186: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2187: THEN
2188: IF( x_return_status = Fnd_Api.g_ret_sts_error) -- to avoid flow though
2189: THEN
2190: IF (p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')

Line 2196: Fnd_Msg_Pub.ADD;

2192: Fnd_Message.set_name('AMS', 'AMS_SESSION_RESOURCE_BOOKED');
2193: ELSE
2194: Fnd_Message.set_name('AMS', 'AMS_RESOURCE_BOOKED');
2195: END IF;
2196: Fnd_Msg_Pub.ADD;
2197: RETURN;
2198: END IF;
2199: END IF;
2200: