DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on INV_ITEM_MSG

Line 514: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_LOCK_ITEM_FAILED'

510: EXCEPTION
511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
512: p_return_status := FALSE;
513: --Write to LOG unable to lock the Item.
514: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_LOCK_ITEM_FAILED'
515: ,p_token1 => 'ORG_ID'
516: ,p_value1 => TO_CHAR(p_Org_Id)
517: ,p_token2 => 'ITEM_ID'
518: ,p_value2 => TO_CHAR(p_Item_Id)

Line 524: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));

520: ,p_value3 => p_pending_status);
521: WHEN OTHERS THEN
522: p_return_status := FALSE;
523: --Write to LOG regarding the Exception.
524: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));
525:
526: END update_item_attributes;
527:
528: PROCEDURE Process_Pending_Status(ERRBUF OUT NOCOPY VARCHAR2

Line 587: INV_ITEM_MSG.Initialize;

583: G_PROG_APPID := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
584: G_PROG_ID := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
585: G_REQUEST_ID := NVL(p_request_id, FND_GLOBAL.conc_request_id );
586:
587: INV_ITEM_MSG.Initialize;
588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
590:
591: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);

584: G_PROG_ID := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
585: G_REQUEST_ID := NVL(p_request_id, FND_GLOBAL.conc_request_id );
586:
587: INV_ITEM_MSG.Initialize;
588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
590:
591: IF FND_API.To_Boolean (p_init_msg_list) THEN
592: INV_ITEM_MSG.Initialize_Error_Handler;

Line 589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);

585: G_REQUEST_ID := NVL(p_request_id, FND_GLOBAL.conc_request_id );
586:
587: INV_ITEM_MSG.Initialize;
588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
590:
591: IF FND_API.To_Boolean (p_init_msg_list) THEN
592: INV_ITEM_MSG.Initialize_Error_Handler;
593: END IF;

Line 592: INV_ITEM_MSG.Initialize_Error_Handler;

588: INV_ITEM_MSG.set_Message_Mode (p_msg_logname);
589: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
590:
591: IF FND_API.To_Boolean (p_init_msg_list) THEN
592: INV_ITEM_MSG.Initialize_Error_Handler;
593: END IF;
594:
595: WHILE (l_counter < 3) LOOP
596: OPEN c_status_pending_items (cp_org_id => P_Org_Id

Line 617: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_UPDT_ITEM_STATUS'

613: ,p_return_status => l_done);
614:
615: IF (l_done AND p_msg_logname = 'FILE') THEN
616: --Write to the log Updated : Org, Item id, Status Code
617: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_UPDT_ITEM_STATUS'
618: ,p_token1 => 'ORG_ID'
619: ,p_value1 => TO_CHAR(l_org_id)
620: ,p_token2 => 'ITEM_ID'
621: ,p_value2 => TO_CHAR(l_Item_Id)

Line 648: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_BOM_ITEM_TYPE_UP'

644: -- Added for Bug 5230429
645: /*commented for bug 5479302
646: If (G_BOM_status =1) then
647: -- Write to log mentioning Couldnt not update since there are items in a Bill of Material
648: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_BOM_ITEM_TYPE_UP'
649: ,p_token1 => 'ORG_ID'
650: ,p_value1 => TO_CHAR(l_Org_Id)
651: ,p_token2 => 'ITEM_ID'
652: ,p_value2 => TO_CHAR(l_Item_Id)

Line 660: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_TRANSACTABLE_YES_NO'

656: end if; */
657:
658: if (G_Transactable_status) then
659: -- Write to log mentioning Couldnt not update since there are Open Sales Order lines.
660: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_TRANSACTABLE_YES_NO'
661: ,p_token1 => 'ORG_ID'
662: ,p_value1 => TO_CHAR(l_Org_Id)
663: ,p_token2 => 'ITEM_ID'
664: ,p_value2 => TO_CHAR(l_Item_Id)

Line 672: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_TRANSACTABLE_UNCHECK'

668: end if;
669:
670: if (G_TRANSACTABLE = 1) then
671: -- Write to log mentioning Couldnt not update since there are Open Sales Order lines.
672: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_TRANSACTABLE_UNCHECK'
673: ,p_token1 => 'ORG_ID'
674: ,p_value1 => TO_CHAR(l_Org_Id)
675: ,p_token2 => 'ITEM_ID'
676: ,p_value2 => TO_CHAR(l_Item_Id)

Line 684: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_CUST_ORDERABLE_UNCHECK'

680: end if;
681:
682: if (G_ORDERABLE = 1) then
683: -- Write to log mentioning Couldnt not update since there are Open Sales Order lines.
684: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_CUST_ORDERABLE_UNCHECK'
685: ,p_token1 => 'ORG_ID'
686: ,p_value1 => TO_CHAR(l_Org_Id)
687: ,p_token2 => 'ITEM_ID'
688: ,p_value2 => TO_CHAR(l_Item_Id)

Line 696: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_PURCHASABLE_UNCHECK'

692: end if;
693:
694: if (G_PURCHASABLE = 1) then
695: -- Write to log mentioning Couldnt not update since there are Open Sales Order lines.
696: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_PURCHASABLE_UNCHECK'
697: ,p_token1 => 'ORG_ID'
698: ,p_value1 => TO_CHAR(l_Org_Id)
699: ,p_token2 => 'ITEM_ID'
700: ,p_value2 => TO_CHAR(l_Item_Id)

Line 708: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_UPDT_ITEM_STATUS_FAIL'

704: end if;
705:
706:
707: -- Write to log mentioning Couldnt not update Org, Item id, Status Code
708: INV_ITEM_MSG.Add_Message(p_Msg_Name => 'INV_UPDT_ITEM_STATUS_FAIL'
709: ,p_token1 => 'ORG_ID'
710: ,p_value1 => TO_CHAR(l_org_id)
711: ,p_token2 => 'ITEM_ID'
712: ,p_value2 => TO_CHAR(l_Item_Id)

Line 721: INV_ITEM_MSG.Write_List (p_delete => TRUE);

717: END LOOP;
718: CLOSE c_status_pending_items;
719:
720: IF p_msg_logname = 'FILE' THEN
721: INV_ITEM_MSG.Write_List (p_delete => TRUE);
722: END IF;
723:
724: EXCEPTION
725: WHEN OTHERS THEN

Line 734: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));

730: CLOSE c_get_control_level;
731: END IF;
732: RETCODE := G_ERROR;
733: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_FAILURE');
734: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));
735:
736: IF p_msg_logname = 'FILE' THEN
737: INV_ITEM_MSG.Write_List (p_delete => TRUE);
738: END IF;

Line 737: INV_ITEM_MSG.Write_List (p_delete => TRUE);

733: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_FAILURE');
734: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));
735:
736: IF p_msg_logname = 'FILE' THEN
737: INV_ITEM_MSG.Write_List (p_delete => TRUE);
738: END IF;
739:
740: END Process_Pending_Status;
741: