DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on APP_EXCEPTION

Line 236: app_exception.raise_exception;

232: EXCEPTION
233: WHEN OTHERS THEN
234: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
235: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
236: app_exception.raise_exception;
237: END jai_create_template;
238: /*---------------------------------------------- ASSIGN TEMPLATE ----------------------------------------*/
239:
240: PROCEDURE jai_assign_template( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE

Line 372: app_exception.raise_exception;

368: EXCEPTION
369: WHEN OTHERS THEN
370: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
371: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
372: app_exception.raise_exception;
373: END jai_assign_template;
374:
375: /* ------------------------------- CREATE ITEM SPECIFIC REGISTRATION ---------------------------------*/
376: PROCEDURE jai_create_item_regns ( p_regime_code JAI_RGM_ITM_REGNS.REGIME_CODE%TYPE

Line 442: app_exception.raise_exception;

438: EXCEPTION
439: WHEN OTHERS THEN
440: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
441: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
442: app_exception.raise_exception;
443: END jai_create_item_regns ;
444: /* -------------------------------------- CREATE TEMPLATE ATTRIBUTES ------------------------------*/
445: PROCEDURE jai_create_attribs ( p_template_id JAI_RGM_ITM_TEMPLATES.TEMPLATE_ID%TYPE
446: ,p_rgm_item_regns_id JAI_RGM_ITM_REGNS.RGM_ITEM_REGNS_ID%TYPE

Line 479: app_exception.raise_exception;

475: EXCEPTION
476: WHEN OTHERS THEN
477: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
478: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
479: app_exception.raise_exception;
480: END jai_create_attribs;
481:
482: /* ------------------------------------------- SYNCHRONIZATION ---------------------------------------*/
483:

Line 592: app_exception.raise_exception;

588: EXCEPTION
589: WHEN OTHERS THEN
590: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
591: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
592: app_exception.raise_exception;
593: end jai_synchronize_jmsi;
594: /*-----------------------------------------------------------------------------------*/
595: /* Added by Brathod for bug#4389149 */
596: /* India Localization code hook for Base item copy/delete/assignment/import action */

Line 637: app_exception.raise_exception;

633: LOOP
634:
635: IF rec_itms.organization_id IS NULL THEN
636: fnd_message.set_name('JA','JAI_DEST_ORG_CANT_BE_NULL');
637: app_exception.raise_exception;
638: END IF;
639: IF rec_itms.inventory_item_id IS NULL THEN
640: fnd_message.set_name ('JA','JAI_ITEM_CANT_BE_NULL');
641: app_exception.raise_exception;

Line 641: app_exception.raise_exception;

637: app_exception.raise_exception;
638: END IF;
639: IF rec_itms.inventory_item_id IS NULL THEN
640: fnd_message.set_name ('JA','JAI_ITEM_CANT_BE_NULL');
641: app_exception.raise_exception;
642: END IF;
643: IF rec_itms.source_organization_id IS NULL THEN
644: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
645: app_exception.raise_exception;

Line 645: app_exception.raise_exception;

641: app_exception.raise_exception;
642: END IF;
643: IF rec_itms.source_organization_id IS NULL THEN
644: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
645: app_exception.raise_exception;
646: END IF;
647:
648: jai_inv_items_pkg.copy_items
649: ( pn_organization_id => rec_itms.organization_id

Line 664: app_exception.raise_exception;

660: OR pn_inventory_item_id IS NULL
661: OR pn_source_organization_id IS NULL
662: OR pn_source_inventory_item_id IS NULL THEN
663: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
664: app_exception.raise_exception;
665: END IF;
666:
667: jai_inv_items_pkg.copy_items
668: ( pn_organization_id => pn_organization_id

Line 679: app_exception.raise_exception;

675:
676: IF pn_organization_id IS NULL
677: OR pn_inventory_item_id IS NULL THEN
678: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
679: app_exception.raise_exception;
680: END IF;
681:
682: jai_inv_items_pkg.delete_items
683: (

Line 693: app_exception.raise_exception;

689: EXCEPTION
690: WHEN OTHERS THEN
691: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
692: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );
693: app_exception.raise_exception;
694: END propagate_item_action;
695: /*----------------------------------------------------------------------------------*/
696: PROCEDURE copy_items
697: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 781: app_exception.raise_exception;

777: CLOSE cur_get_item_regns;
778:
779: IF ln_dest_item_regns_id IS NOT NULL THEN
780: fnd_message.set_name('JA', 'JAI_DUP_ITEM');
781: app_exception.raise_exception;
782: END IF;
783:
784: /* Check if item specific registration exists for the source item */
785:

Line 895: app_exception.raise_exception;

891: EXCEPTION
892: WHEN OTHERS THEN
893: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
894: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );
895: app_exception.raise_exception;
896: END copy_items;
897: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
898:
899: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 965: app_exception.raise_exception;

961: EXCEPTION
962: WHEN OTHERS THEN
963: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
964: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
965: app_exception.raise_exception;
966: END delete_items;
967: /* -----------------------END OF PROCEDURE DELETE_ITEMS ----------------------------*/
968: /* End of Bug# 4389149 */
969: