290: AMS_UTILITY_PVT.debug_message(AMS_LOG_PROCEDURE,g_module_name||'.'||l_api_name,l_full_name||':Start');
291: END IF;
292:
293: IF (AMS_DEBUG_HIGH_ON) THEN
294: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
295: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
296: FND_MSG_PUB.Add;
297: END IF;
298:
291: END IF;
292:
293: IF (AMS_DEBUG_HIGH_ON) THEN
294: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
295: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
296: FND_MSG_PUB.Add;
297: END IF;
298:
299: -- Initialize API return status to success
446: raise;
447: */
448: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
449: THEN
450: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
451: FND_MESSAGE.Set_Token('ROW', l_api_name, TRUE);
452: FND_MSG_PUB.Add;
453: END IF;
454:
447: */
448: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
449: THEN
450: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
451: FND_MESSAGE.Set_Token('ROW', l_api_name, TRUE);
452: FND_MSG_PUB.Add;
453: END IF;
454:
455:
453: END IF;
454:
455:
456: IF (AMS_DEBUG_HIGH_ON) THEN
457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
458: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
459: FND_MSG_PUB.Add;
460: END IF;
461:
454:
455:
456: IF (AMS_DEBUG_HIGH_ON) THEN
457: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
458: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
459: FND_MSG_PUB.Add;
460: END IF;
461:
462: IF (AMS_LOG_PROCEDURE_ON) THEN
571: END IF;
572:
573: -- Debug Message
574: IF (AMS_DEBUG_HIGH_ON) THEN
575: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
576: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
577: FND_MSG_PUB.Add;
578: END IF;
579:
572:
573: -- Debug Message
574: IF (AMS_DEBUG_HIGH_ON) THEN
575: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
576: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
577: FND_MSG_PUB.Add;
578: END IF;
579:
580: IF (AMS_LOG_PROCEDURE_ON) THEN
609: raise;
610: */
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
612: THEN
613: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
614: FND_MESSAGE.Set_Token('ROW', l_Api_name, TRUE);
615: FND_MSG_PUB.Add;
616: END IF;
617:
610: */
611: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
612: THEN
613: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
614: FND_MESSAGE.Set_Token('ROW', l_Api_name, TRUE);
615: FND_MSG_PUB.Add;
616: END IF;
617:
618:
616: END IF;
617:
618:
619: IF (AMS_DEBUG_HIGH_ON) THEN
620: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
621: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
622: FND_MSG_PUB.Add;
623: END IF;
624:
617:
618:
619: IF (AMS_DEBUG_HIGH_ON) THEN
620: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
621: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
622: FND_MSG_PUB.Add;
623: END IF;
624:
625: IF (AMS_LOG_PROCEDURE_ON) THEN
741: END IF;
742:
743: -- Debug Message
744: IF (AMS_DEBUG_HIGH_ON) THEN
745: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
746: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
747: FND_MSG_PUB.Add;
748: END IF;
749:
742:
743: -- Debug Message
744: IF (AMS_DEBUG_HIGH_ON) THEN
745: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
746: FND_MESSAGE.Set_Token('ROW', l_api_name||': Start', TRUE);
747: FND_MSG_PUB.Add;
748: END IF;
749:
750:
799:
800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
801: THEN
802: AMS_UTILITY_PVT.debug_message('Error Generating the tar views');
803: FND_MESSAGE.set_name('AMS', 'AMS_ERR_LIST_GEN_TAR_VIEW');
804: FND_MSG_PUB.Add;
805: RAISE FND_API.g_exc_error;
806: END IF;
807:
824: -- Success Message
825: -- MMSG
826: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
827: THEN
828: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
829: FND_MESSAGE.Set_Token('ROW', l_api_name, TRUE);
830: FND_MSG_PUB.Add;
831: END IF;
832:
825: -- MMSG
826: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
827: THEN
828: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
829: FND_MESSAGE.Set_Token('ROW', l_api_name, TRUE);
830: FND_MSG_PUB.Add;
831: END IF;
832:
833:
831: END IF;
832:
833:
834: IF (AMS_DEBUG_HIGH_ON) THEN
835: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
836: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
837: FND_MSG_PUB.Add;
838: END IF;
839:
832:
833:
834: IF (AMS_DEBUG_HIGH_ON) THEN
835: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
836: FND_MESSAGE.Set_Token('ROW', l_api_name||': END', TRUE);
837: FND_MSG_PUB.Add;
838: END IF;
839:
840: IF (AMS_LOG_PROCEDURE_ON) THEN