DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on FND_MESSAGE

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

230: RETURN ln_template_id ;
231:
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 ----------------------------------------*/

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

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

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

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

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

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

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

436: );
437:
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 ------------------------------*/

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

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

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

473: );
474: END LOOP;
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:

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

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

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

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

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

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

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

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

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

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

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

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;
646: END IF;
647:
648: jai_inv_items_pkg.copy_items

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

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

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

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

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

687: END IF;
688: END IF;
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: /*----------------------------------------------------------------------------------*/

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

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

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

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

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

889: AND inventory_item_id = ln_source_inventory_item_id
890: );
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 ------------------------*/

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

890: );
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:

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

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

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

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