APPS.AMS_CATEGORY_PVT dependencies on FND_MSG_PUB

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

35: --
36: -- Procedure and function declarations.
37:
38:
39: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Validate_Category_Cross_Record

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

36: -- Procedure and function declarations.
37:
38:
39: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Validate_Category_Cross_Record
44: ( p_category_rec IN category_rec_type,

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

37:
38:
39: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Validate_Category_Cross_Record
44: ( p_category_rec IN category_rec_type,
45: x_return_status OUT NOCOPY VARCHAR2

Line 127: FND_MSG_PUB.initialize;

123:
124: -- Initialize message list IF p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean( p_init_msg_list )
126: THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130:
131: -- Initialize API return status to success

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

189: FETCH c_findParentofParent INTO l_parent_id;
190: CLOSE c_findParentofParent;
191:
192: if ( l_parent_id IS NOT NULL ) then
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;

Line 195: FND_MSG_PUB.add;

191:
192: if ( l_parent_id IS NOT NULL ) then
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: end if;
199:

Line 310: FND_MSG_PUB.Count_AND_Get

306: COMMIT WORK;
307: END IF;
308:
309: -- Standard call to get message count AND IF count is 1, get message info.
310: FND_MSG_PUB.Count_AND_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data,
313: p_encoded => FND_API.G_FALSE
314: );

Line 331: FND_MSG_PUB.Count_AND_Get

327: THEN
328: ROLLBACK TO Create_Category_PVT;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330:
331: FND_MSG_PUB.Count_AND_Get
332: ( p_count => x_msg_count,
333: p_data => x_msg_data,
334: p_encoded => FND_API.G_FALSE
335: );

Line 342: FND_MSG_PUB.Count_AND_Get

338: THEN
339: ROLLBACK TO Create_Category_PVT;
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
341:
342: FND_MSG_PUB.Count_AND_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data,
345: p_encoded => FND_API.G_FALSE
346: );

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

349:
350: ROLLBACK TO Create_Category_PVT;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352:
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357:

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

351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352:
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357:
358: FND_MSG_PUB.Count_AND_Get
359: ( p_count => x_msg_count,

Line 358: FND_MSG_PUB.Count_AND_Get

354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
356: END IF;
357:
358: FND_MSG_PUB.Count_AND_Get
359: ( p_count => x_msg_count,
360: p_data => x_msg_data,
361: p_encoded => FND_API.G_FALSE
362: );

Line 427: FND_MSG_PUB.initialize;

423:
424: -- Initialize message list IF p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )
426: THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Initialize API return status to success
431: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

467: FETCH c_findParentofParent INTO l_parent_id;
468: CLOSE c_findParentofParent;
469:
470: if ( l_parent_id IS NOT NULL ) then
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;

Line 473: FND_MSG_PUB.add;

469:
470: if ( l_parent_id IS NOT NULL ) then
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('AMS', 'AMS_INVALID_CAT_LEVEL');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: end if;
477:

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

498: WHERE
499: CATEGORY_ID = l_category_rec.category_id;
500:
501: IF (SQL%NOTFOUND) THEN
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
503: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
504: FND_MSG_PUB.add;
505: END IF;
506: RAISE FND_API.g_exc_error;

Line 504: FND_MSG_PUB.add;

500:
501: IF (SQL%NOTFOUND) THEN
502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
503: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
504: FND_MSG_PUB.add;
505: END IF;
506: RAISE FND_API.g_exc_error;
507: END IF;
508:

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

516: CATEGORY_ID = p_category_rec.category_id
517: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
518:
519: IF (SQL%NOTFOUND) THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;

Line 522: FND_MSG_PUB.add;

518:
519: IF (SQL%NOTFOUND) THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;
525: END IF;
526:

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

558: WHERE
559: CATEGORY_ID = l_category_rec.category_id;
560:
561: IF (SQL%NOTFOUND) THEN
562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
563: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
564: FND_MSG_PUB.add;
565: END IF;
566: RAISE FND_API.g_exc_error;

Line 564: FND_MSG_PUB.add;

560:
561: IF (SQL%NOTFOUND) THEN
562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
563: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
564: FND_MSG_PUB.add;
565: END IF;
566: RAISE FND_API.g_exc_error;
567: END IF;
568:

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

578: CATEGORY_ID = p_category_rec.category_id
579: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
580:
581: IF (SQL%NOTFOUND) THEN
582: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
583: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
584: FND_MSG_PUB.add;
585: END IF;
586: RAISE FND_API.g_exc_error;

Line 584: FND_MSG_PUB.add;

580:
581: IF (SQL%NOTFOUND) THEN
582: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
583: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
584: FND_MSG_PUB.add;
585: END IF;
586: RAISE FND_API.g_exc_error;
587: END IF;
588:

Line 601: FND_MSG_PUB.Count_AND_Get

597: COMMIT WORK;
598: END IF;
599:
600: -- Standard call to get message count AND IF count is 1, get message info.
601: FND_MSG_PUB.Count_AND_Get
602: ( p_count => x_msg_count,
603: p_data => x_msg_data,
604: p_encoded => FND_API.G_FALSE
605: );

Line 618: FND_MSG_PUB.Count_AND_Get

614: THEN
615: ROLLBACK TO Update_Category_PVT;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
617:
618: FND_MSG_PUB.Count_AND_Get
619: ( p_count => x_msg_count,
620: p_data => x_msg_data,
621: p_encoded => FND_API.G_FALSE
622: );

Line 629: FND_MSG_PUB.Count_AND_Get

625: THEN
626: ROLLBACK TO Update_Category_PVT;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628:
629: FND_MSG_PUB.Count_AND_Get
630: ( p_count => x_msg_count,
631: p_data => x_msg_data,
632: p_encoded => FND_API.G_FALSE
633: );

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

637:
638: ROLLBACK TO Update_Category_PVT;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640:
641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
642: THEN
643: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
644: END IF;
645:

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

639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640:
641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
642: THEN
643: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
644: END IF;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,

Line 646: FND_MSG_PUB.Count_AND_Get

642: THEN
643: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
644: END IF;
645:
646: FND_MSG_PUB.Count_AND_Get
647: ( p_count => x_msg_count,
648: p_data => x_msg_data,
649: p_encoded => FND_API.G_FALSE
650: );

Line 713: FND_MSG_PUB.initialize;

709:
710: -- Initialize message list IF p_init_msg_list is set to TRUE.
711: IF FND_API.to_Boolean( p_init_msg_list )
712: THEN
713: FND_MSG_PUB.initialize;
714: END IF;
715:
716: -- Initialize API return status to success
717: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

742:
743: -- seeded category if category_id < 10000
744: -- user cannot modify or delete seeded category
745: IF (l_category_id < 10000 ) THEN
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
747: THEN
748: FND_MESSAGE.set_name('AMS', 'AMS_CAT_CANNOT_MOD_SEED');
749: FND_MSG_PUB.add;
750: END IF;

Line 749: FND_MSG_PUB.add;

745: IF (l_category_id < 10000 ) THEN
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
747: THEN
748: FND_MESSAGE.set_name('AMS', 'AMS_CAT_CANNOT_MOD_SEED');
749: FND_MSG_PUB.add;
750: END IF;
751: RAISE FND_API.g_exc_error;
752: END IF;
753:

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

755: where category_id = l_category_id
756: and object_version_number = p_object_version;
757:
758: IF (SQL%NOTFOUND) THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
760: THEN
761: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
762: FND_MSG_PUB.add;
763: END IF;

Line 762: FND_MSG_PUB.add;

758: IF (SQL%NOTFOUND) THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
760: THEN
761: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
762: FND_MSG_PUB.add;
763: END IF;
764: RAISE FND_API.g_exc_error;
765: END IF;
766:

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

769: where category_id = l_category_id
770: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
771:
772: IF (SQL%NOTFOUND) THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.add;
777: END IF;

Line 776: FND_MSG_PUB.add;

772: IF (SQL%NOTFOUND) THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.add;
777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;
780:

Line 791: FND_MSG_PUB.Count_AND_Get

787: COMMIT WORK;
788: END IF;
789:
790: -- Standard call to get message count AND IF count is 1, get message info.
791: FND_MSG_PUB.Count_AND_Get
792: ( p_count => x_msg_count,
793: p_data => x_msg_data,
794: p_encoded => FND_API.G_FALSE
795: );

Line 808: FND_MSG_PUB.Count_AND_Get

804: THEN
805: ROLLBACK TO Delete_Category_PVT;
806: x_return_status := FND_API.G_RET_STS_ERROR ;
807:
808: FND_MSG_PUB.Count_AND_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data,
811: p_encoded => FND_API.G_FALSE
812: );

Line 820: FND_MSG_PUB.Count_AND_Get

816: THEN
817: ROLLBACK TO Delete_Category_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
819:
820: FND_MSG_PUB.Count_AND_Get
821: ( p_count => x_msg_count,
822: p_data => x_msg_data,
823: p_encoded => FND_API.G_FALSE
824: );

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

827:
828: ROLLBACK TO Delete_Category_PVT;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830:
831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
832: THEN
833: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
834: END IF;
835:

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

829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830:
831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
832: THEN
833: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
834: END IF;
835:
836: FND_MSG_PUB.Count_AND_Get
837: ( p_count => x_msg_count,

Line 836: FND_MSG_PUB.Count_AND_Get

832: THEN
833: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
834: END IF;
835:
836: FND_MSG_PUB.Count_AND_Get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data,
839: p_encoded => FND_API.G_FALSE
840: );

Line 913: FND_MSG_PUB.initialize;

909: END IF;
910:
911: -- Initialize message list if p_init_msg_list is set to TRUE.
912: IF FND_API.to_Boolean( p_init_msg_list ) THEN
913: FND_MSG_PUB.initialize;
914: END IF;
915: -- Initialize API return status to success
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:

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

927: IF (C_ams_categories_b%NOTFOUND) THEN
928: CLOSE C_ams_categories_b;
929: -- Error, check the msg level and added an error message to the
930: -- API message list
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
933: FND_MSG_PUB.add;
934: END IF;
935:

Line 933: FND_MSG_PUB.add;

929: -- Error, check the msg level and added an error message to the
930: -- API message list
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
933: FND_MSG_PUB.add;
934: END IF;
935:
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;

Line 945: FND_MSG_PUB.Count_AND_Get

941: open C_ams_categories_tl ;
942: close C_ams_categories_tl;
943:
944: -- Standard call to get message count AND IF count is 1, get message info.
945: FND_MSG_PUB.Count_AND_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data,
948: p_encoded => FND_API.G_FALSE
949: );

Line 961: FND_MSG_PUB.Count_AND_Get

957: WHEN FND_API.G_EXC_ERROR
958: THEN
959: x_return_status := FND_API.G_RET_STS_ERROR ;
960:
961: FND_MSG_PUB.Count_AND_Get
962: ( p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => FND_API.G_FALSE
965: );

Line 971: FND_MSG_PUB.Count_AND_Get

967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
968: THEN
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970:
971: FND_MSG_PUB.Count_AND_Get
972: ( p_count => x_msg_count,
973: p_data => x_msg_data,
974: p_encoded => FND_API.G_FALSE
975: );

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

977: WHEN AMS_Utility_PVT.RESOURCE_LOCKED
978: THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980:
981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
982: THEN -- MMSG
983: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
984: FND_MSG_PUB.Add;
985: END IF;

Line 984: FND_MSG_PUB.Add;

980:
981: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
982: THEN -- MMSG
983: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
984: FND_MSG_PUB.Add;
985: END IF;
986:
987: FND_MSG_PUB.Count_AND_Get
988: ( p_count => x_msg_count,

Line 987: FND_MSG_PUB.Count_AND_Get

983: FND_MESSAGE.SET_NAME('AMS','AMS_API_RESOURCE_LOCKED');
984: FND_MSG_PUB.Add;
985: END IF;
986:
987: FND_MSG_PUB.Count_AND_Get
988: ( p_count => x_msg_count,
989: p_data => x_msg_data,
990: p_encoded => FND_API.G_FALSE
991: );

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

993: WHEN OTHERS THEN
994:
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996:
997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1000: END IF;
1001:

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

995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996:
997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1000: END IF;
1001:
1002: FND_MSG_PUB.Count_AND_Get
1003: ( p_count => x_msg_count,

Line 1002: FND_MSG_PUB.Count_AND_Get

998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1000: END IF;
1001:
1002: FND_MSG_PUB.Count_AND_Get
1003: ( p_count => x_msg_count,
1004: p_data => x_msg_data,
1005: p_encoded => FND_API.G_FALSE
1006: );

Line 1064: FND_MSG_PUB.initialize;

1060:
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062: IF FND_API.to_Boolean( p_init_msg_list )
1063: THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066:
1067: -- Initialize API return status to success
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1193: FND_MSG_PUB.Count_AND_Get

1189:
1190: --
1191: END IF;
1192: -- Standard call to get message count AND IF count is 1, get message info.
1193: FND_MSG_PUB.Count_AND_Get
1194: ( p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1197: );

Line 1205: FND_MSG_PUB.Count_AND_Get

1201: WHEN FND_API.G_EXC_ERROR
1202: THEN
1203: x_return_status := FND_API.G_RET_STS_ERROR ;
1204:
1205: FND_MSG_PUB.Count_AND_Get
1206: ( p_count => x_msg_count,
1207: p_data => x_msg_data,
1208: p_encoded => FND_API.G_FALSE
1209: );

Line 1215: FND_MSG_PUB.Count_AND_Get

1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1212: THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1214:
1215: FND_MSG_PUB.Count_AND_Get
1216: ( p_count => x_msg_count,
1217: p_data => x_msg_data,
1218: p_encoded => FND_API.G_FALSE
1219: );

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

1221: WHEN OTHERS THEN
1222:
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1224:
1225: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1226: THEN
1227: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1228: END IF;
1229:

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

1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1224:
1225: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1226: THEN
1227: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1228: END IF;
1229:
1230: FND_MSG_PUB.Count_AND_Get
1231: ( p_count => x_msg_count,

Line 1230: FND_MSG_PUB.Count_AND_Get

1226: THEN
1227: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1228: END IF;
1229:
1230: FND_MSG_PUB.Count_AND_Get
1231: ( p_count => x_msg_count,
1232: p_data => x_msg_data,
1233: p_encoded => FND_API.G_FALSE
1234: );

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

1280: ,p_pk_value => l_pk_value
1281: ,p_additional_where_clause => l_additional_where_clause -- Bug 3847393 in 11.5.10.1R
1282: ) = FND_API.G_FALSE
1283: THEN
1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1285: THEN
1286: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_PARENT_CAT_ID');
1287: FND_MSG_PUB.add;
1288: END IF;

Line 1287: FND_MSG_PUB.add;

1283: THEN
1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1285: THEN
1286: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_PARENT_CAT_ID');
1287: FND_MSG_PUB.add;
1288: END IF;
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: -- If any errors happen abort API/Procedure.
1291: RETURN;

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

1301: AND p_category_rec.enabled_flag IS NOT NULL
1302: THEN
1303: IF AMS_Utility_PVT.is_Y_or_N(p_category_rec.enabled_flag) = FND_API.g_false
1304: THEN
1305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1306: THEN
1307: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_ENABLED_FLAG');
1308: FND_MSG_PUB.add;
1309: END IF;

Line 1308: FND_MSG_PUB.add;

1304: THEN
1305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1306: THEN
1307: FND_MESSAGE.set_name('AMS', 'AMS_CAT_BAD_ENABLED_FLAG');
1308: FND_MSG_PUB.add;
1309: END IF;
1310: x_return_status := FND_API.g_ret_sts_error;
1311: RETURN;
1312: END IF;

Line 1385: FND_MSG_PUB.initialize;

1381:
1382: -- Initialize message list if p_init_msg_list is set to TRUE.
1383: IF FND_API.to_Boolean( p_init_msg_list )
1384: THEN
1385: FND_MSG_PUB.initialize;
1386: END IF;
1387: -- Initialize API return status to success
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389:

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

1429:
1430:
1431: THEN
1432: -- FK checking
1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1434: THEN -- MMSG
1435: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE');
1436: FND_MSG_PUB.Add;
1437: END IF;

Line 1436: FND_MSG_PUB.Add;

1432: -- FK checking
1433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1434: THEN -- MMSG
1435: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE');
1436: FND_MSG_PUB.Add;
1437: END IF;
1438: x_return_status := FND_API.g_ret_sts_error;
1439: RETURN;
1440: END IF;

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

1454: CLOSE get_enabled_child;
1455:
1456: IF l_count > 0 THEN
1457:
1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1459: THEN -- MMSG
1460: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE_PARENT');
1461: FND_MSG_PUB.Add;
1462: END IF;

Line 1461: FND_MSG_PUB.Add;

1457:
1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1459: THEN -- MMSG
1460: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DISABLE_PARENT');
1461: FND_MSG_PUB.Add;
1462: END IF;
1463:
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;

Line 1477: FND_MSG_PUB.Add;

1473:
1474: IF (l_parent_cr_for <> p_category_rec.ARC_CATEGORY_CREATED_FOR)
1475: THEN
1476: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_PARENT_CR_FOR');
1477: FND_MSG_PUB.Add;
1478:
1479: x_return_status := FND_API.g_ret_sts_error;
1480: RETURN;
1481: END IF;

Line 1490: FND_MSG_PUB.Count_AND_Get

1486:
1487: END IF;
1488:
1489: -- Standard call to get message count AND IF count is 1, get message info.
1490: FND_MSG_PUB.Count_AND_Get
1491: ( p_count => x_msg_count,
1492: p_data => x_msg_data,
1493: p_encoded => FND_API.G_FALSE
1494: );

Line 1502: FND_MSG_PUB.Count_AND_Get

1498: WHEN FND_API.G_EXC_ERROR
1499: THEN
1500: x_return_status := FND_API.G_RET_STS_ERROR ;
1501:
1502: FND_MSG_PUB.Count_AND_Get
1503: ( p_count => x_msg_count,
1504: p_data => x_msg_data,
1505: p_encoded => FND_API.G_FALSE
1506: );

Line 1511: FND_MSG_PUB.Count_AND_Get

1507:
1508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1509: THEN
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1511: FND_MSG_PUB.Count_AND_Get
1512: ( p_count => x_msg_count,
1513: p_data => x_msg_data,
1514: p_encoded => FND_API.G_FALSE
1515: );

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

1517: WHEN OTHERS THEN
1518:
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520:
1521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1522: THEN
1523: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1524: END IF;
1525:

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

1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520:
1521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1522: THEN
1523: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1524: END IF;
1525:
1526: FND_MSG_PUB.Count_AND_Get
1527: ( p_count => x_msg_count,

Line 1526: FND_MSG_PUB.Count_AND_Get

1522: THEN
1523: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1524: END IF;
1525:
1526: FND_MSG_PUB.Count_AND_Get
1527: ( p_count => x_msg_count,
1528: p_data => x_msg_data,
1529: p_encoded => FND_API.G_FALSE
1530: );

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

1607: close c_ctg_name_crt;
1608: IF l_dummy = 1 THEN
1609:
1610: -- invalid item
1611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1612: THEN -- MMSG
1613: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1614: FND_MSG_PUB.Add;
1615: END IF;

Line 1614: FND_MSG_PUB.Add;

1610: -- invalid item
1611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1612: THEN -- MMSG
1613: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1614: FND_MSG_PUB.Add;
1615: END IF;
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: -- If any errors happen abort API/Procedure.
1618: return;

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

1641: close c_ctg_name_updt;
1642: IF l_dummy = 1 THEN
1643:
1644: -- invalid item
1645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1646: THEN -- MMSG
1647: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1648: FND_MSG_PUB.Add;
1649: END IF;

Line 1648: FND_MSG_PUB.Add;

1644: -- invalid item
1645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1646: THEN -- MMSG
1647: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_DUPLICATE_NAME');
1648: FND_MSG_PUB.Add;
1649: END IF;
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: -- If any errors happen abort API/Procedure.
1652: return;

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

1722: ,p_pk_value => l_pk_value
1723: ) = FND_API.G_TRUE
1724: THEN
1725: -- FK checking
1726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1727: THEN -- MMSG
1728: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_PARENT');
1729: FND_MSG_PUB.Add;
1730: END IF;

Line 1729: FND_MSG_PUB.Add;

1725: -- FK checking
1726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1727: THEN -- MMSG
1728: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_PARENT');
1729: FND_MSG_PUB.Add;
1730: END IF;
1731: x_return_status := FND_API.g_ret_sts_error;
1732: RETURN;
1733: END IF;

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

1738: ,p_pk_value => l_pk_value
1739: ) = FND_API.G_TRUE
1740: THEN
1741: -- FK checking
1742: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1743: THEN -- MMSG
1744: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1745: FND_MSG_PUB.Add;
1746: END IF;

Line 1745: FND_MSG_PUB.Add;

1741: -- FK checking
1742: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1743: THEN -- MMSG
1744: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1745: FND_MSG_PUB.Add;
1746: END IF;
1747: x_return_status := FND_API.g_ret_sts_error;
1748: RETURN;
1749: END IF;

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

1755: ,p_pk_value => l_pk_value
1756: ) = FND_API.G_TRUE
1757: THEN
1758: -- FK checking
1759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1760: THEN -- MMSG
1761: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1762: FND_MSG_PUB.Add;
1763: END IF;

Line 1762: FND_MSG_PUB.Add;

1758: -- FK checking
1759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1760: THEN -- MMSG
1761: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1762: FND_MSG_PUB.Add;
1763: END IF;
1764: x_return_status := FND_API.g_ret_sts_error;
1765: RETURN;
1766: END IF;

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

1771: ,p_pk_value => l_pk_value
1772: ) = FND_API.G_TRUE
1773: THEN
1774: -- FK checking
1775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1776: THEN -- MMSG
1777: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1778: FND_MSG_PUB.Add;
1779: END IF;

Line 1778: FND_MSG_PUB.Add;

1774: -- FK checking
1775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1776: THEN -- MMSG
1777: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_METRICS');
1778: FND_MSG_PUB.Add;
1779: END IF;
1780: x_return_status := FND_API.g_ret_sts_error;
1781: RETURN;
1782: END IF;

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

1790: ,p_pk_value => l_pk_value
1791: ) = FND_API.G_TRUE
1792: THEN
1793: -- FK checking
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1795: THEN -- MMSG
1796: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1797: FND_MSG_PUB.Add;
1798: END IF;

Line 1797: FND_MSG_PUB.Add;

1793: -- FK checking
1794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1795: THEN -- MMSG
1796: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1797: FND_MSG_PUB.Add;
1798: END IF;
1799: x_return_status := FND_API.g_ret_sts_error;
1800: RETURN;
1801: END IF;

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

1821: ,p_pk_value => l_pk_value
1822: ) = FND_API.G_TRUE
1823: THEN
1824: -- FK checking
1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1828: FND_MSG_PUB.Add;
1829: END IF;

Line 1828: FND_MSG_PUB.Add;

1824: -- FK checking
1825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1826: THEN -- MMSG
1827: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1828: FND_MSG_PUB.Add;
1829: END IF;
1830: x_return_status := FND_API.g_ret_sts_error;
1831: RETURN;
1832: END IF;

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

1842: ,p_pk_value => l_pk_value
1843: ) = FND_API.G_TRUE
1844: THEN
1845: -- FK checking
1846: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1847: THEN -- MMSG
1848: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1849: FND_MSG_PUB.Add;
1850: END IF;

Line 1849: FND_MSG_PUB.Add;

1845: -- FK checking
1846: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1847: THEN -- MMSG
1848: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1849: FND_MSG_PUB.Add;
1850: END IF;
1851: x_return_status := FND_API.g_ret_sts_error;
1852: RETURN;
1853: END IF;

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

1877: ,p_pk_value => l_pk_value
1878: ) = FND_API.G_TRUE
1879: THEN
1880: -- FK checking
1881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1882: THEN -- MMSG
1883: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1884: FND_MSG_PUB.Add;
1885: END IF;

Line 1884: FND_MSG_PUB.Add;

1880: -- FK checking
1881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1882: THEN -- MMSG
1883: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_ACT');
1884: FND_MSG_PUB.Add;
1885: END IF;
1886: x_return_status := FND_API.g_ret_sts_error;
1887: RETURN;
1888: END IF;

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

1896: ,p_pk_value => l_pk_value
1897: ) = FND_API.G_TRUE
1898: THEN
1899: -- FK checking
1900: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN -- MMSG
1902: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1903: FND_MSG_PUB.Add;
1904: END IF;

Line 1903: FND_MSG_PUB.Add;

1899: -- FK checking
1900: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN -- MMSG
1902: FND_MESSAGE.Set_Name('AMS', 'AMS_CAT_CANT_DEL_DELV');
1903: FND_MSG_PUB.Add;
1904: END IF;
1905: x_return_status := FND_API.g_ret_sts_error;
1906: RETURN;
1907: END IF;

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

1947: IF (p_category_rec.CATEGORY_NAME = FND_API.G_MISS_CHAR OR
1948: p_category_rec.CATEGORY_NAME IS NULL)
1949: THEN
1950:
1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1952: THEN
1953: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NO_CAT_NAME');
1954: FND_MSG_PUB.add;
1955: END IF;

Line 1954: FND_MSG_PUB.add;

1950:
1951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1952: THEN
1953: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NO_CAT_NAME');
1954: FND_MSG_PUB.add;
1955: END IF;
1956: x_return_status := FND_API.g_ret_sts_error;
1957: RETURN;
1958: END IF;

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

1981: OPEN c_cat;
1982: FETCH c_cat INTO l_category_rec;
1983: IF c_cat%NOTFOUND THEN
1984: CLOSE c_cat;
1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1986: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: RAISE FND_API.g_exc_error;

Line 1987: FND_MSG_PUB.add;

1983: IF c_cat%NOTFOUND THEN
1984: CLOSE c_cat;
1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1986: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: RAISE FND_API.g_exc_error;
1990: END IF;
1991: CLOSE c_cat;