DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on APP_EXCEPTION

Line 241: app_exception.raise_exception;

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

Line 377: app_exception.raise_exception;

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

Line 447: app_exception.raise_exception;

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

Line 484: app_exception.raise_exception;

480: EXCEPTION
481: WHEN OTHERS THEN
482: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
483: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
484: app_exception.raise_exception;
485: END jai_create_attribs;
486:
487: /* ------------------------------------------- SYNCHRONIZATION ---------------------------------------*/
488:

Line 597: app_exception.raise_exception;

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

Line 642: app_exception.raise_exception;

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

Line 646: app_exception.raise_exception;

642: app_exception.raise_exception;
643: END IF;
644: IF rec_itms.inventory_item_id IS NULL THEN
645: fnd_message.set_name ('JA','JAI_ITEM_CANT_BE_NULL');
646: app_exception.raise_exception;
647: END IF;
648: IF rec_itms.source_organization_id IS NULL THEN
649: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
650: app_exception.raise_exception;

Line 650: app_exception.raise_exception;

646: app_exception.raise_exception;
647: END IF;
648: IF rec_itms.source_organization_id IS NULL THEN
649: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');
650: app_exception.raise_exception;
651: END IF;
652:
653: jai_inv_items_pkg.copy_items
654: ( pn_organization_id => rec_itms.organization_id

Line 669: app_exception.raise_exception;

665: OR pn_inventory_item_id IS NULL
666: OR pn_source_organization_id IS NULL
667: OR pn_source_inventory_item_id IS NULL THEN
668: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
669: app_exception.raise_exception;
670: END IF;
671:
672: jai_inv_items_pkg.copy_items
673: ( pn_organization_id => pn_organization_id

Line 684: app_exception.raise_exception;

680:
681: IF pn_organization_id IS NULL
682: OR pn_inventory_item_id IS NULL THEN
683: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');
684: app_exception.raise_exception;
685: END IF;
686:
687: jai_inv_items_pkg.delete_items
688: (

Line 698: app_exception.raise_exception;

694: EXCEPTION
695: WHEN OTHERS THEN
696: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
697: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );
698: app_exception.raise_exception;
699: END propagate_item_action;
700: /*----------------------------------------------------------------------------------*/
701: PROCEDURE copy_items
702: ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 789: app_exception.raise_exception;

785: CLOSE cur_get_item_regns;
786:
787: IF ln_dest_item_regns_id IS NOT NULL THEN
788: fnd_message.set_name('JA', 'JAI_DUP_ITEM');
789: app_exception.raise_exception;
790: END IF;
791:
792: /* Check if item specific registration exists for the source item */
793:

Line 906: app_exception.raise_exception;

902: EXCEPTION
903: WHEN OTHERS THEN
904: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
905: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );
906: app_exception.raise_exception;
907: END copy_items;
908: /* ------------------------------- END OF PROCEDURE COPY_ITEMS ------------------------*/
909:
910: PROCEDURE delete_items ( pn_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

Line 976: app_exception.raise_exception;

972: EXCEPTION
973: WHEN OTHERS THEN
974: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
975: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
976: app_exception.raise_exception;
977: END delete_items;
978: /* -----------------------END OF PROCEDURE DELETE_ITEMS ----------------------------*/
979: /* End of Bug# 4389149 */
980: