DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on FND_MESSAGE

Line 239: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

235: RETURN ln_template_id ;
236:
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 ----------------------------------------*/

Line 240: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

236:
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:

Line 375: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

371: END IF;
372:
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:

Line 376: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

372:
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 ---------------------------------*/

Line 445: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

441: );
442:
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 ------------------------------*/

Line 446: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

442:
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

Line 482: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

478: );
479: END LOOP;
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:

Line 483: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

479: END LOOP;
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 ---------------------------------------*/

Line 595: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

591:
592: end loop; /* rec_jmsi */
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: /*-----------------------------------------------------------------------------------*/

Line 596: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

592: end loop; /* rec_jmsi */
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 */

Line 641: fnd_message.set_name('JA','JAI_DEST_ORG_CANT_BE_NULL');

637: FOR rec_itms IN cur_get_items_from_interface
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');

Line 645: fnd_message.set_name ('JA','JAI_ITEM_CANT_BE_NULL');

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;
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');

Line 649: fnd_message.set_name('JA','JAI_SOURCE_ORG_CANT_BE_NULL');

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;
651: END IF;
652:
653: jai_inv_items_pkg.copy_items

Line 668: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');

664: IF pn_organization_id IS NULL
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

Line 683: fnd_message.set_name('JA','JAI_IL_API_ARGS_NOT_PROPER');

679: ELSIF pv_action_type IN ('DELETE') THEN
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

Line 696: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

692: END IF;
693: END IF;
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: /*----------------------------------------------------------------------------------*/

Line 697: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );

693: END IF;
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

Line 788: fnd_message.set_name('JA', 'JAI_DUP_ITEM');

784:
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 */

Line 904: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

900: );
901: END IF;
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 ------------------------*/

Line 905: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||SQLERRM );

901: END IF;
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:

Line 974: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');

970: AND inventory_item_id = ln_inventory_item_id;
971:
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 ----------------------------*/

Line 975: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);

971:
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 */