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

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

12:
13: -- Debug mode
14: g_debug boolean := FALSE;
15: --g_debug boolean := TRUE;
16: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;

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

13: -- Debug mode
14: g_debug boolean := FALSE;
15: --g_debug boolean := TRUE;
16: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
21: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;

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

14: g_debug boolean := FALSE;
15: --g_debug boolean := TRUE;
16: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: AMS_LOG_PROCEDURE constant number := FND_LOG.LEVEL_PROCEDURE;
21: AMS_LOG_EXCEPTION constant Number := FND_LOG.LEVEL_EXCEPTION;
22: AMS_LOG_STATEMENT constant Number := FND_LOG.LEVEL_STATEMENT;

Line 139: FND_MSG_PUB.initialize;

135: END IF;
136: -- Initialize message list IF p_init_msg_list is set to TRUE.
137: IF FND_API.to_Boolean( p_init_msg_list )
138: THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141: -- Initialize API return status to success
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: --

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

189: --
190: -- Changed access to check for value N
191: --
192: if AMS_ACCESS_PVT.check_update_access(l_act_Product_rec.act_product_used_by_id,l_act_Product_rec.arc_act_product_used_by, l_res_id, 'USER') = 'N' then
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;

Line 195: FND_MSG_PUB.add;

191: --
192: if AMS_ACCESS_PVT.check_update_access(l_act_Product_rec.act_product_used_by_id,l_act_Product_rec.arc_act_product_used_by, l_res_id, 'USER') = 'N' then
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: end if;
199: END IF;

Line 334: FND_MSG_PUB.Count_AND_Get

330: THEN
331: COMMIT WORK;
332: END IF;
333: -- Standard call to get message count AND IF count is 1, get message info.
334: FND_MSG_PUB.Count_AND_Get
335: ( p_count => x_msg_count,
336: p_data => x_msg_data,
337: p_encoded => FND_API.G_FALSE
338: );

Line 343: FND_MSG_PUB.Count_AND_Get

339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO Create_Act_Product_PVT;
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: FND_MSG_PUB.Count_AND_Get
344: ( p_count => x_msg_count,
345: p_data => x_msg_data,
346: p_encoded => FND_API.G_FALSE
347: );

Line 351: FND_MSG_PUB.Count_AND_Get

347: );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Create_Act_Product_PVT;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_AND_Get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data,
354: p_encoded => FND_API.G_FALSE
355: );

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

358: CLOSE c_act_product_id;
359: END IF;
360: ROLLBACK TO Create_Act_Product_PVT;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
363: THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
365: END IF;
366: FND_MSG_PUB.Count_AND_Get

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

360: ROLLBACK TO Create_Act_Product_PVT;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
363: THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
365: END IF;
366: FND_MSG_PUB.Count_AND_Get
367: ( p_count => x_msg_count,
368: p_data => x_msg_data,

Line 366: FND_MSG_PUB.Count_AND_Get

362: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
363: THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
365: END IF;
366: FND_MSG_PUB.Count_AND_Get
367: ( p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE
370: );

Line 421: FND_MSG_PUB.initialize;

417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419: -- Initialize message list IF p_init_msg_list is set to TRUE.
420: IF FND_API.to_Boolean( p_init_msg_list ) THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425: --

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

467: -- Changed Access call to check N instead of F
468: --
469: if l_act_Product_rec.arc_act_product_used_by NOT IN ('OFFR') THEN
470: if AMS_ACCESS_PVT.check_update_access(l_act_Product_rec.act_product_used_by_id,l_act_Product_rec.arc_act_product_used_by, l_res_id, 'USER') = 'N' then
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;

Line 473: FND_MSG_PUB.add;

469: if l_act_Product_rec.arc_act_product_used_by NOT IN ('OFFR') THEN
470: if AMS_ACCESS_PVT.check_update_access(l_act_Product_rec.act_product_used_by_id,l_act_Product_rec.arc_act_product_used_by, l_res_id, 'USER') = 'N' then
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: end if;
477: end if;

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

525: IF (SQL%NOTFOUND)
526: THEN
527: -- Error, check the msg level and added an error message to the
528: -- API message list
529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
530: THEN -- MMSG
531: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
532: FND_MSG_PUB.Add;
533: END IF;

Line 532: FND_MSG_PUB.Add;

528: -- API message list
529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
530: THEN -- MMSG
531: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
532: FND_MSG_PUB.Add;
533: END IF;
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536: --

Line 545: FND_MSG_PUB.Count_AND_Get

541: THEN
542: COMMIT WORK;
543: END IF;
544: -- Standard call to get message count AND IF count is 1, get message info.
545: FND_MSG_PUB.Count_AND_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data,
548: p_encoded => FND_API.G_FALSE
549: );

Line 554: FND_MSG_PUB.Count_AND_Get

550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO Update_Act_Product_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_AND_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data,
557: p_encoded => FND_API.G_FALSE
558: );

Line 562: FND_MSG_PUB.Count_AND_Get

558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO Update_Act_Product_PVT;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: FND_MSG_PUB.Count_AND_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE
566: );

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

566: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Update_Act_Product_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
573: END IF;
574: FND_MSG_PUB.Count_AND_Get

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

568: ROLLBACK TO Update_Act_Product_PVT;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
573: END IF;
574: FND_MSG_PUB.Count_AND_Get
575: ( p_count => x_msg_count,
576: p_data => x_msg_data,

Line 574: FND_MSG_PUB.Count_AND_Get

570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
573: END IF;
574: FND_MSG_PUB.Count_AND_Get
575: ( p_count => x_msg_count,
576: p_data => x_msg_data,
577: p_encoded => FND_API.G_FALSE
578: );

Line 654: FND_MSG_PUB.initialize;

650: END IF;
651: -- Initialize message list IF p_init_msg_list is set to TRUE.
652: IF FND_API.to_Boolean( p_init_msg_list )
653: THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656: -- Initialize API return status to success
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: --

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

678: -- Commented out the following call to check_update_access
679: -- as it does not work for Messages tab. GDEODHAR : Oct 06, 2000
680: /*
681: if AMS_ACCESS_PVT.check_update_access(l_acc_obj_id, l_acc_obj, l_res_id, 'USER') <> 'F' then
682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
683: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
684: FND_MSG_PUB.add;
685: END IF;
686: RAISE FND_API.g_exc_error;

Line 684: FND_MSG_PUB.add;

680: /*
681: if AMS_ACCESS_PVT.check_update_access(l_acc_obj_id, l_acc_obj, l_res_id, 'USER') <> 'F' then
682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
683: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
684: FND_MSG_PUB.add;
685: END IF;
686: RAISE FND_API.g_exc_error;
687: end if;
688: */

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

700: IF SQL%NOTFOUND THEN
701: --
702: -- Add error message to API message list.
703: --
704: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
705: THEN
706: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
707: FND_MSG_PUB.add;
708: END IF;

Line 707: FND_MSG_PUB.add;

703: --
704: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
705: THEN
706: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
707: FND_MSG_PUB.add;
708: END IF;
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711:

Line 759: FND_MSG_PUB.Count_AND_Get

755: THEN
756: COMMIT WORK;
757: END IF;
758: -- Standard call to get message count AND IF count is 1, get message info.
759: FND_MSG_PUB.Count_AND_Get
760: ( p_count => x_msg_count,
761: p_data => x_msg_data,
762: p_encoded => FND_API.G_FALSE
763: );

Line 768: FND_MSG_PUB.Count_AND_Get

764: EXCEPTION
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO Delete_Act_Product_PVT;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_AND_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data,
771: p_encoded => FND_API.G_FALSE
772: );

Line 776: FND_MSG_PUB.Count_AND_Get

772: );
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO Delete_Act_Product_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: FND_MSG_PUB.Count_AND_Get
777: ( p_count => x_msg_count,
778: p_data => x_msg_data,
779: p_encoded => FND_API.G_FALSE
780: );

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

786: CLOSE get_count;
787: END IF;
788: ROLLBACK TO Delete_Act_Product_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_AND_Get

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

788: ROLLBACK TO Delete_Act_Product_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_AND_Get
795: ( p_count => x_msg_count,
796: p_data => x_msg_data,

Line 794: FND_MSG_PUB.Count_AND_Get

790: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_AND_Get
795: ( p_count => x_msg_count,
796: p_data => x_msg_data,
797: p_encoded => FND_API.G_FALSE
798: );

Line 845: FND_MSG_PUB.initialize;

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

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

855: IF (c_act_product%NOTFOUND) THEN
856: CLOSE c_act_product;
857: -- Error, check the msg level and added an error message to the
858: -- API message list
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN -- MMSG
861: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
862: FND_MSG_PUB.Add;
863: END IF;

Line 862: FND_MSG_PUB.Add;

858: -- API message list
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN -- MMSG
861: FND_MESSAGE.Set_Name('AMS', 'AMS_API_RECORD_NOT_FOUND');
862: FND_MSG_PUB.Add;
863: END IF;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: CLOSE c_act_product;

Line 871: FND_MSG_PUB.Count_AND_Get

867: --
868: -- END of API body.
869: --
870: -- Standard call to get message count AND IF count is 1, get message info.
871: FND_MSG_PUB.Count_AND_Get
872: ( p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => FND_API.G_FALSE
875: );

Line 879: FND_MSG_PUB.Count_AND_Get

875: );
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: FND_MSG_PUB.Count_AND_Get
880: ( p_count => x_msg_count,
881: p_data => x_msg_data,
882: p_encoded => FND_API.G_FALSE
883: );

Line 886: FND_MSG_PUB.Count_AND_Get

882: p_encoded => FND_API.G_FALSE
883: );
884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: FND_MSG_PUB.Count_AND_Get
887: ( p_count => x_msg_count,
888: p_data => x_msg_data,
889: p_encoded => FND_API.G_FALSE
890: );

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

889: p_encoded => FND_API.G_FALSE
890: );
891: WHEN AMS_Utility_PVT.resource_locked THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
894: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
895: FND_MSG_PUB.add;
896: END IF;
897: FND_MSG_PUB.Count_AND_Get

Line 895: FND_MSG_PUB.add;

891: WHEN AMS_Utility_PVT.resource_locked THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
894: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
895: FND_MSG_PUB.add;
896: END IF;
897: FND_MSG_PUB.Count_AND_Get
898: ( p_count => x_msg_count,
899: p_data => x_msg_data,

Line 897: FND_MSG_PUB.Count_AND_Get

893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
894: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
895: FND_MSG_PUB.add;
896: END IF;
897: FND_MSG_PUB.Count_AND_Get
898: ( p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
901: );

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

903: IF (c_act_product%ISOPEN) THEN
904: CLOSE c_act_product;
905: END IF;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get

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

905: END IF;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,

Line 911: FND_MSG_PUB.Count_AND_Get

907: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
908: THEN
909: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
910: END IF;
911: FND_MSG_PUB.Count_AND_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data,
914: p_encoded => FND_API.G_FALSE
915: );

Line 957: FND_MSG_PUB.initialize;

953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954: END IF;
955: -- Initialize message list if p_init_msg_list is set to TRUE.
956: IF FND_API.to_Boolean( p_init_msg_list ) THEN
957: FND_MSG_PUB.initialize;
958: END IF;
959: -- Initialize API return status to success
960: x_return_status := FND_API.G_RET_STS_SUCCESS;
961: --

Line 1007: FND_MSG_PUB.count_and_get(

1003: --
1004: -- END of API body.
1005: --
1006: -------------------- finish --------------------------
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );

Line 1015: FND_MSG_PUB.Count_AND_Get

1011: );
1012: EXCEPTION
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: x_return_status := FND_API.G_RET_STS_ERROR ;
1015: FND_MSG_PUB.Count_AND_Get
1016: ( p_count => x_msg_count,
1017: p_data => x_msg_data,
1018: p_encoded => FND_API.G_FALSE
1019: );

Line 1022: FND_MSG_PUB.Count_AND_Get

1018: p_encoded => FND_API.G_FALSE
1019: );
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1022: FND_MSG_PUB.Count_AND_Get
1023: ( p_count => x_msg_count,
1024: p_data => x_msg_data,
1025: p_encoded => FND_API.G_FALSE
1026: );

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

1025: p_encoded => FND_API.G_FALSE
1026: );
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1032: END IF;
1033: FND_MSG_PUB.Count_AND_Get

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

1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1032: END IF;
1033: FND_MSG_PUB.Count_AND_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data,

Line 1033: FND_MSG_PUB.Count_AND_Get

1029: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
1032: END IF;
1033: FND_MSG_PUB.Count_AND_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data,
1036: p_encoded => FND_API.G_FALSE
1037: );

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

1091: END IF;
1092:
1093: IF l_primary_flag = 'Y'
1094: THEN
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1096: THEN
1097: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_PRIMARY_FLAG');
1098: FND_MSG_PUB.add;
1099: END IF;

Line 1098: FND_MSG_PUB.add;

1094: THEN
1095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1096: THEN
1097: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_PRIMARY_FLAG');
1098: FND_MSG_PUB.add;
1099: END IF;
1100: x_return_status := FND_API.g_ret_sts_error;
1101: RETURN;
1102: END IF;

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

1162: IF (p_act_Product_rec.act_product_used_by_id = FND_API.G_MISS_NUM OR
1163: p_act_Product_rec.act_product_used_by_id IS NULL)
1164: THEN
1165: -- missing required fields
1166: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1167: THEN -- MMSG
1168: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_USEDBYID');
1169: FND_MSG_PUB.add;
1170: END IF;

Line 1169: FND_MSG_PUB.add;

1165: -- missing required fields
1166: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1167: THEN -- MMSG
1168: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_USEDBYID');
1169: FND_MSG_PUB.add;
1170: END IF;
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: -- If any error happens abort API.
1173: RETURN;

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

1177: IF (p_act_Product_rec.arc_act_product_used_by = FND_API.G_MISS_CHAR OR
1178: p_act_Product_rec.arc_act_product_used_by IS NULL)
1179: THEN
1180: -- missing required fields
1181: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1182: THEN -- MMSG
1183: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_USEDBY');
1184: FND_MSG_PUB.add;
1185: END IF;

Line 1184: FND_MSG_PUB.add;

1180: -- missing required fields
1181: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1182: THEN -- MMSG
1183: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_USEDBY');
1184: FND_MSG_PUB.add;
1185: END IF;
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: -- If any error happens abort API.
1188: RETURN;

Line 1202: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1198: IF (p_act_Product_rec.level_type_code = 'FAMILY'
1199: AND (p_act_Product_rec.category_id IS NULL
1200: OR p_act_Product_rec.category_id = FND_API.G_MISS_NUM))
1201: THEN
1202: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1203: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NAME_MISSING');
1204: FND_MSG_PUB.add;
1205: END IF;
1206: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1204: FND_MSG_PUB.add;

1200: OR p_act_Product_rec.category_id = FND_API.G_MISS_NUM))
1201: THEN
1202: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1203: FND_MESSAGE.set_name('AMS', 'AMS_CAT_NAME_MISSING');
1204: FND_MSG_PUB.add;
1205: END IF;
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: RETURN;
1208: END IF;

Line 1217: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1213: AND p_act_Product_rec.arc_act_product_used_by <> 'FUND')
1214: AND (p_act_Product_rec.category_set_id IS NULL
1215: OR p_act_Product_rec.category_set_id = FND_API.G_MISS_NUM))
1216: THEN
1217: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1218: FND_MESSAGE.set_name('AMS', 'AMS_CAT_SET_ID_MISSING');
1219: FND_MSG_PUB.add;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1219: FND_MSG_PUB.add;

1215: OR p_act_Product_rec.category_set_id = FND_API.G_MISS_NUM))
1216: THEN
1217: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1218: FND_MESSAGE.set_name('AMS', 'AMS_CAT_SET_ID_MISSING');
1219: FND_MSG_PUB.add;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: RETURN;
1223: END IF;

Line 1230: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1226: IF (p_act_Product_rec.level_type_code = 'PRODUCT'
1227: AND (p_act_Product_rec.inventory_item_id IS NULL
1228: OR p_act_Product_rec.inventory_item_id = FND_API.G_MISS_NUM))
1229: THEN
1230: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1231: FND_MESSAGE.set_name('AMS', 'AMS_INVENTORY_ITEM_ID_MISSING');
1232: FND_MSG_PUB.add;
1233: END IF;
1234: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1232: FND_MSG_PUB.add;

1228: OR p_act_Product_rec.inventory_item_id = FND_API.G_MISS_NUM))
1229: THEN
1230: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1231: FND_MESSAGE.set_name('AMS', 'AMS_INVENTORY_ITEM_ID_MISSING');
1232: FND_MSG_PUB.add;
1233: END IF;
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: RETURN;
1236: END IF;

Line 1248: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1244: IF p_act_Product_rec.level_type_code = 'PRODUCT' THEN -- category does not have uom
1245: IF p_act_Product_rec.uom_code = FND_API.G_MISS_CHAR
1246: OR p_act_Product_rec.uom_code IS NULL
1247: THEN
1248: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1249: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_UOM');
1250: FND_MSG_PUB.add;
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1250: FND_MSG_PUB.add;

1246: OR p_act_Product_rec.uom_code IS NULL
1247: THEN
1248: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1249: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_UOM');
1250: FND_MSG_PUB.add;
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: RETURN;
1254: END IF;

Line 1260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1256:
1257: IF p_act_Product_rec.quantity = FND_API.G_MISS_NUM
1258: OR p_act_Product_rec.quantity IS NULL
1259: THEN
1260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1261: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_QUANTITY');
1262: FND_MSG_PUB.add;
1263: END IF;
1264: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1262: FND_MSG_PUB.add;

1258: OR p_act_Product_rec.quantity IS NULL
1259: THEN
1260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1261: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_QUANTITY');
1262: FND_MSG_PUB.add;
1263: END IF;
1264: x_return_status := FND_API.G_RET_STS_ERROR;
1265: RETURN;
1266: END IF;

Line 1272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1268: IF l_custom_setup_id <> 117 THEN -- channel_id not mandatory for special pricing
1269: IF p_act_Product_rec.channel_id = FND_API.G_MISS_NUM
1270: OR p_act_Product_rec.channel_id IS NULL
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1273: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_SCAN_TYPE');
1274: FND_MSG_PUB.add;
1275: END IF;
1276: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1274: FND_MSG_PUB.add;

1270: OR p_act_Product_rec.channel_id IS NULL
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1273: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_SCAN_TYPE');
1274: FND_MSG_PUB.add;
1275: END IF;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: RETURN;
1278: END IF;

Line 1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1280:
1281: IF p_act_Product_rec.scan_value = FND_API.G_MISS_NUM
1282: OR p_act_Product_rec.scan_value IS NULL
1283: THEN
1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1285: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_SCAN_VALUE');
1286: FND_MSG_PUB.add;
1287: END IF;
1288: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1286: FND_MSG_PUB.add;

1282: OR p_act_Product_rec.scan_value IS NULL
1283: THEN
1284: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1285: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_SCAN_VALUE');
1286: FND_MSG_PUB.add;
1287: END IF;
1288: x_return_status := FND_API.G_RET_STS_ERROR;
1289: RETURN;
1290: END IF;

Line 1295: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG

1291:
1292: IF p_act_Product_rec.scan_unit_forecast = FND_API.G_MISS_NUM
1293: OR p_act_Product_rec.scan_unit_forecast IS NULL
1294: THEN
1295: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1296: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_UNIT_FCST');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1297: FND_MSG_PUB.add;

1293: OR p_act_Product_rec.scan_unit_forecast IS NULL
1294: THEN
1295: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- MMSG
1296: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_UNIT_FCST');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300: RETURN;
1301: END IF;

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

1310: 'ams_act_products',
1311: 'activity_product_id = ' || p_act_Product_rec.activity_product_id
1312: ) = FND_API.g_false
1313: THEN
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1315: THEN
1316: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPLICATE_ID');
1317: FND_MSG_PUB.add;
1318: END IF;

Line 1317: FND_MSG_PUB.add;

1313: THEN
1314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1315: THEN
1316: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPLICATE_ID');
1317: FND_MSG_PUB.add;
1318: END IF;
1319: x_return_status := FND_API.g_ret_sts_error;
1320: RETURN;
1321: END IF;

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

1328: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1329: p_lookup_code => p_act_Product_rec.arc_act_product_used_by
1330: ) = FND_API.g_false
1331: THEN
1332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1333: THEN
1334: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_USEDBY');
1335: FND_MSG_PUB.add;
1336: END IF;

Line 1335: FND_MSG_PUB.add;

1331: THEN
1332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1333: THEN
1334: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_USEDBY');
1335: FND_MSG_PUB.add;
1336: END IF;
1337: x_return_status := FND_API.g_ret_sts_error;
1338: RETURN;
1339: END IF;

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

1346: p_lookup_type => 'AMS_PRODUCT_LEVEL',
1347: p_lookup_code => p_act_Product_rec.LEVEL_TYPE_CODE
1348: ) = FND_API.g_false
1349: THEN
1350: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1351: THEN
1352: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_LEVELTYPE');
1353: FND_MSG_PUB.add;
1354: END IF;

Line 1353: FND_MSG_PUB.add;

1349: THEN
1350: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1351: THEN
1352: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_LEVELTYPE');
1353: FND_MSG_PUB.add;
1354: END IF;
1355: x_return_status := FND_API.g_ret_sts_error;
1356: RETURN;
1357: END IF;

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

1373: CLOSE c_get_budget_type;
1374:
1375: if (l_budget_flag = 'Y') then
1376:
1377: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_ASSOCIATE_PROD');
1380: FND_MSG_PUB.add;
1381: END IF;

Line 1380: FND_MSG_PUB.add;

1376:
1377: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_ASSOCIATE_PROD');
1380: FND_MSG_PUB.add;
1381: END IF;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: -- If any errors happen abort API/Procedure.
1384: RETURN;

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

1449: ,p_pk_name => l_pk_name
1450: ,p_pk_value => l_pk_value
1451: ) = FND_API.G_FALSE
1452: THEN
1453: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1454: THEN
1455: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_REFERENCE');
1456: FND_MSG_PUB.add;
1457: END IF;

Line 1456: FND_MSG_PUB.add;

1452: THEN
1453: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1454: THEN
1455: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_REFERENCE');
1456: FND_MSG_PUB.add;
1457: END IF;
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: -- If any errors happen abort API/Procedure.
1460: RETURN;

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

1471: ,p_pk_name => l_pk_name
1472: ,p_pk_value => l_pk_value
1473: ) = FND_API.G_FALSE
1474: THEN
1475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN
1477: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ITEM');
1478: FND_MSG_PUB.add;
1479: END IF;

Line 1478: FND_MSG_PUB.add;

1474: THEN
1475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN
1477: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ITEM');
1478: FND_MSG_PUB.add;
1479: END IF;
1480: x_return_status := FND_API.G_RET_STS_ERROR;
1481: -- If any errors happen abort API/Procedure.
1482: RETURN;

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

1494: ,p_pk_name => l_pk_name
1495: ,p_pk_value => l_pk_value
1496: ) = FND_API.G_FALSE
1497: THEN
1498: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ORG');
1501: FND_MSG_PUB.add;
1502: END IF;

Line 1501: FND_MSG_PUB.add;

1497: THEN
1498: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1499: THEN
1500: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ORG');
1501: FND_MSG_PUB.add;
1502: END IF;
1503: x_return_status := FND_API.G_RET_STS_ERROR;
1504: -- If any errors happen abort API/Procedure.
1505: RETURN;

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

1516: ,p_pk_name => l_pk_name
1517: ,p_pk_value => l_pk_value
1518: ) = FND_API.G_FALSE
1519: THEN
1520: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1521: THEN
1522: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_CAT');
1523: FND_MSG_PUB.add;
1524: END IF;

Line 1523: FND_MSG_PUB.add;

1519: THEN
1520: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1521: THEN
1522: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_CAT');
1523: FND_MSG_PUB.add;
1524: END IF;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: -- If any errors happen abort API/Procedure.
1527: RETURN;

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

1538: ,p_pk_name => l_pk_name
1539: ,p_pk_value => l_pk_value
1540: ) = FND_API.G_FALSE
1541: THEN
1542: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ITEMCAT');
1545: FND_MSG_PUB.add;
1546: END IF;

Line 1545: FND_MSG_PUB.add;

1541: THEN
1542: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_INVALID_ITEMCAT');
1545: FND_MSG_PUB.add;
1546: END IF;
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: -- If any errors happen abort API/Procedure.
1549: RETURN;

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

1558: AND p_act_Product_rec.enabled_flag IS NOT NULL
1559: THEN
1560: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.enabled_flag) = FND_API.g_false
1561: THEN
1562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1563: THEN
1564: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_ENABLED_FLAG');
1565: FND_MSG_PUB.add;
1566: END IF;

Line 1565: FND_MSG_PUB.add;

1561: THEN
1562: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1563: THEN
1564: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_ENABLED_FLAG');
1565: FND_MSG_PUB.add;
1566: END IF;
1567: x_return_status := FND_API.g_ret_sts_error;
1568: RETURN;
1569: END IF;

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

1573: AND p_act_Product_rec.excluded_flag IS NOT NULL
1574: THEN
1575: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.excluded_flag) = FND_API.g_false
1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_EXCLUDED_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;

Line 1580: FND_MSG_PUB.add;

1576: THEN
1577: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1578: THEN
1579: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_EXCLUDED_FLAG');
1580: FND_MSG_PUB.add;
1581: END IF;
1582: x_return_status := FND_API.g_ret_sts_error;
1583: RETURN;
1584: END IF;

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

1589: AND p_act_Product_rec.primary_product_flag IS NOT NULL
1590: THEN
1591: IF AMS_Utility_PVT.is_Y_or_N(p_act_Product_rec.primary_product_flag) = FND_API.g_false
1592: THEN
1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1594: THEN
1595: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_PRIMARY_FLAG');
1596: FND_MSG_PUB.add;
1597: END IF;

Line 1596: FND_MSG_PUB.add;

1592: THEN
1593: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1594: THEN
1595: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_BAD_PRIMARY_FLAG');
1596: FND_MSG_PUB.add;
1597: END IF;
1598: x_return_status := FND_API.g_ret_sts_error;
1599: RETURN;
1600: END IF;

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

1602:
1603: -------------------- Product Name --------------------
1604: -- bug 4102448
1605: IF p_act_product_rec.category_id IS NULL AND p_act_product_rec.inventory_item_id IS NULL THEN
1606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_PROD');
1608: FND_MSG_PUB.add;
1609: END IF;
1610: x_return_status := FND_API.g_ret_sts_error;

Line 1608: FND_MSG_PUB.add;

1604: -- bug 4102448
1605: IF p_act_product_rec.category_id IS NULL AND p_act_product_rec.inventory_item_id IS NULL THEN
1606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1607: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_PROD');
1608: FND_MSG_PUB.add;
1609: END IF;
1610: x_return_status := FND_API.g_ret_sts_error;
1611: END IF;
1612:

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

1626: END IF;
1627:
1628: -- if level =PROD, error out.. no more include/exclude rows allowed
1629: IF l_level = 'PRODUCT' THEN
1630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1631: THEN
1632: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_MORE_ROWS');
1633: FND_MSG_PUB.add;
1634: END IF;

Line 1633: FND_MSG_PUB.add;

1629: IF l_level = 'PRODUCT' THEN
1630: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1631: THEN
1632: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_MORE_ROWS');
1633: FND_MSG_PUB.add;
1634: END IF;
1635: x_return_status := FND_API.g_ret_sts_error;
1636: RETURN;
1637: ELSE

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

1638: -- either no rows exist or it exists for CAT
1639: -- if row exists for CAT and to be added one is include row, error out
1640: -- in this release though.. this stage not necessary as CAT/subCAT wont be allowed to be excluded
1641: IF l_level = 'FAMILY' and p_act_Product_rec.excluded_flag <> 'Y' THEN
1642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1643: THEN
1644: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_MORE_ROWS');
1645: FND_MSG_PUB.add;
1646: END IF;

Line 1645: FND_MSG_PUB.add;

1641: IF l_level = 'FAMILY' and p_act_Product_rec.excluded_flag <> 'Y' THEN
1642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1643: THEN
1644: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_MORE_ROWS');
1645: FND_MSG_PUB.add;
1646: END IF;
1647: x_return_status := FND_API.g_ret_sts_error;
1648: RETURN;
1649: END IF;

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

1649: END IF;
1650: -- if no row exists, and exclusion row being added, error out
1651:
1652: IF l_level = 'NEW' and p_act_Product_rec.excluded_flag = 'Y' THEN
1653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1654: THEN
1655: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_INCLUDE_ROWS');
1656: FND_MSG_PUB.add;
1657: END IF;

Line 1656: FND_MSG_PUB.add;

1652: IF l_level = 'NEW' and p_act_Product_rec.excluded_flag = 'Y' THEN
1653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1654: THEN
1655: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NO_INCLUDE_ROWS');
1656: FND_MSG_PUB.add;
1657: END IF;
1658: x_return_status := FND_API.g_ret_sts_error;
1659: RETURN;
1660: END IF;

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

1842: CLOSE c_scan_item_dup2;
1843: END IF;
1844:
1845: IF l_count1 > 0 THEN
1846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1847: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUP_ITEM');
1848: FND_MSG_PUB.add;
1849: END IF;
1850:

Line 1848: FND_MSG_PUB.add;

1844:
1845: IF l_count1 > 0 THEN
1846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1847: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUP_ITEM');
1848: FND_MSG_PUB.add;
1849: END IF;
1850:
1851: x_return_status := FND_API.g_ret_sts_error;
1852: RETURN;

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

1861: FETCH c_check_item_in_cat INTO l_count2;
1862: CLOSE c_check_item_in_cat;
1863:
1864: IF l_count2 = 1 THEN
1865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1866: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_ITEM_IN_CAT');
1867: FND_MSG_PUB.add;
1868: END IF;
1869:

Line 1867: FND_MSG_PUB.add;

1863:
1864: IF l_count2 = 1 THEN
1865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1866: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_ITEM_IN_CAT');
1867: FND_MSG_PUB.add;
1868: END IF;
1869:
1870: x_return_status := FND_API.g_ret_sts_error;
1871: RETURN;

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

1877: FETCH c_check_item_in_cat INTO l_count2;
1878: CLOSE c_check_item_in_cat;
1879:
1880: IF l_count2 = 1 THEN
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1882: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_ITEM_IN_CAT');
1883: FND_MSG_PUB.add;
1884: END IF;
1885:

Line 1883: FND_MSG_PUB.add;

1879:
1880: IF l_count2 = 1 THEN
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1882: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_ITEM_IN_CAT');
1883: FND_MSG_PUB.add;
1884: END IF;
1885:
1886: x_return_status := FND_API.g_ret_sts_error;
1887: RETURN;

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

1902: CLOSE c_scan_cat_dup2;
1903: END IF;
1904:
1905: IF l_count1 > 0 THEN
1906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1907: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUP_CAT');
1908: FND_MSG_PUB.add;
1909: END IF;
1910:

Line 1908: FND_MSG_PUB.add;

1904:
1905: IF l_count1 > 0 THEN
1906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1907: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUP_CAT');
1908: FND_MSG_PUB.add;
1909: END IF;
1910:
1911: x_return_status := FND_API.g_ret_sts_error;
1912: RETURN;

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

1921: FETCH c_check_item_in_cat INTO l_count2;
1922: CLOSE c_check_item_in_cat;
1923:
1924: IF l_count2 = 1 THEN
1925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1926: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CAT_HAS_ITEM');
1927: FND_MSG_PUB.add;
1928: END IF;
1929:

Line 1927: FND_MSG_PUB.add;

1923:
1924: IF l_count2 = 1 THEN
1925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1926: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CAT_HAS_ITEM');
1927: FND_MSG_PUB.add;
1928: END IF;
1929:
1930: x_return_status := FND_API.g_ret_sts_error;
1931: RETURN;

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

1937: FETCH c_check_item_in_cat INTO l_count2;
1938: CLOSE c_check_item_in_cat;
1939:
1940: IF l_count2 = 1 THEN
1941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1942: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CAT_HAS_ITEM');
1943: FND_MSG_PUB.add;
1944: END IF;
1945:

Line 1943: FND_MSG_PUB.add;

1939:
1940: IF l_count2 = 1 THEN
1941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1942: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CAT_HAS_ITEM');
1943: FND_MSG_PUB.add;
1944: END IF;
1945:
1946: x_return_status := FND_API.g_ret_sts_error;
1947: RETURN;

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

1960:
1961: EXIT WHEN c_get_all_categories%NOTFOUND;
1962:
1963: IF p_act_Product_rec.category_id = cat_id THEN
1964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1965: THEN
1966: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPE_CAT');
1967: FND_MSG_PUB.add;
1968: END IF;

Line 1967: FND_MSG_PUB.add;

1963: IF p_act_Product_rec.category_id = cat_id THEN
1964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1965: THEN
1966: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPE_CAT');
1967: FND_MSG_PUB.add;
1968: END IF;
1969: x_return_status := FND_API.g_ret_sts_error;
1970: CLOSE c_get_all_categories;
1971: RETURN;

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

1984:
1985: EXIT WHEN c_get_all_items%NOTFOUND;
1986:
1987: IF p_act_Product_rec.inventory_item_id = item_id THEN
1988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1989: THEN
1990: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPE_ITEM');
1991: FND_MSG_PUB.add;
1992: END IF;

Line 1991: FND_MSG_PUB.add;

1987: IF p_act_Product_rec.inventory_item_id = item_id THEN
1988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1989: THEN
1990: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_DUPE_ITEM');
1991: FND_MSG_PUB.add;
1992: END IF;
1993: x_return_status := FND_API.g_ret_sts_error;
1994: CLOSE c_get_all_items;
1995: RETURN;

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

2000: -- for any row, CAT cannot be excluded
2001: /** commented by abhola
2002: IF p_act_Product_rec.level_type_code = 'FAMILY'
2003: AND p_act_Product_rec.excluded_flag = 'Y' THEN
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2005: THEN
2006: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CANT_EXCLUDE_CAT');
2007: FND_MSG_PUB.add;
2008: END IF;

Line 2007: FND_MSG_PUB.add;

2003: AND p_act_Product_rec.excluded_flag = 'Y' THEN
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2005: THEN
2006: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_CANT_EXCLUDE_CAT');
2007: FND_MSG_PUB.add;
2008: END IF;
2009: x_return_status := FND_API.g_ret_sts_error;
2010: RETURN;
2011: END IF;

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

2031: EXIT WHEN item_in_cat = 1;
2032: END LOOP;
2033: CLOSE c_get_categories;
2034: IF item_in_cat <> 1 THEN
2035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2036: THEN
2037: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NOT_IN_CAT');
2038: FND_MSG_PUB.add;
2039: END IF;

Line 2038: FND_MSG_PUB.add;

2034: IF item_in_cat <> 1 THEN
2035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2036: THEN
2037: FND_MESSAGE.set_name('AMS', 'AMS_ACT_PRD_NOT_IN_CAT');
2038: FND_MSG_PUB.add;
2039: END IF;
2040: x_return_status := FND_API.g_ret_sts_error;
2041: RETURN;
2042: END IF;

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

2079: OPEN c_product;
2080: FETCH c_product INTO l_act_Product_rec;
2081: IF c_product%NOTFOUND THEN
2082: CLOSE c_product;
2083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2084: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2085: FND_MSG_PUB.add;
2086: END IF;
2087: RAISE FND_API.g_exc_error;

Line 2085: FND_MSG_PUB.add;

2081: IF c_product%NOTFOUND THEN
2082: CLOSE c_product;
2083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2084: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2085: FND_MSG_PUB.add;
2086: END IF;
2087: RAISE FND_API.g_exc_error;
2088: END IF;
2089: CLOSE c_product;

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

2629: OPEN c_item_cat_check;
2630: FETCH c_item_cat_check into l_count;
2631: CLOSE c_item_cat_check;
2632: IF l_count = 0 THEN
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2634: FND_MESSAGE.set_name('AMS', 'AMS_API_PRD_ITEM_IN_CAT');
2635: FND_MSG_PUB.add;
2636: END IF;
2637: END IF;

Line 2635: FND_MSG_PUB.add;

2631: CLOSE c_item_cat_check;
2632: IF l_count = 0 THEN
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2634: FND_MESSAGE.set_name('AMS', 'AMS_API_PRD_ITEM_IN_CAT');
2635: FND_MSG_PUB.add;
2636: END IF;
2637: END IF;
2638: l_count := 0;
2639: END IF;

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

2700: IF (AMS_LOG_STATEMENT_ON) THEN
2701: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'check_cat_exist does not exist');
2702: END IF;
2703: --- both hierarch doesn't exist raising an error
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_PROD_ASSOC_NOT_IN_CAMP');
2707: FND_MSG_PUB.add;
2708: END IF;

Line 2707: FND_MSG_PUB.add;

2703: --- both hierarch doesn't exist raising an error
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_PROD_ASSOC_NOT_IN_CAMP');
2707: FND_MSG_PUB.add;
2708: END IF;
2709: x_return_status := FND_API.g_ret_sts_error;
2710: RETURN;
2711: END IF;

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

2710: RETURN;
2711: END IF;
2712: END IF;
2713: ELSE --- if there is no category passed, which means the product assoc doesnot there in campaign
2714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2715: THEN
2716: FND_MESSAGE.set_name('AMS', 'AMS_PROD_ASSOC_NOT_IN_CAMP');
2717: FND_MSG_PUB.add;
2718: END IF;

Line 2717: FND_MSG_PUB.add;

2713: ELSE --- if there is no category passed, which means the product assoc doesnot there in campaign
2714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2715: THEN
2716: FND_MESSAGE.set_name('AMS', 'AMS_PROD_ASSOC_NOT_IN_CAMP');
2717: FND_MSG_PUB.add;
2718: END IF;
2719: x_return_status := FND_API.g_ret_sts_error;
2720: RETURN;
2721: END IF;

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

2741: THEN
2742: IF (AMS_LOG_STATEMENT_ON) THEN
2743: AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,G_module_name,'HIERARCHY ALSO DOESNT EXIST');
2744: END IF;
2745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2746: THEN
2747: FND_MESSAGE.set_name('AMS', 'AMS_CAT_ASSOC_NOT_IN_CAMP');
2748: FND_MSG_PUB.add;
2749: END IF;

Line 2748: FND_MSG_PUB.add;

2744: END IF;
2745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2746: THEN
2747: FND_MESSAGE.set_name('AMS', 'AMS_CAT_ASSOC_NOT_IN_CAMP');
2748: FND_MSG_PUB.add;
2749: END IF;
2750: x_return_status := FND_API.g_ret_sts_error;
2751: RETURN;
2752: END IF;