eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_CONC_REPLACE_PKG dependencies on FND_MESSAGE

Line 44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');

40: WHERE formula_id = (SELECT formula_id FROM gmd_recipes_b
41: WHERE recipe_id = precipe_id)
42: AND line_type = 1);
43:
44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');
45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
46: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
47:
48: ELSIF(update_item = 'ROUTING') THEN

Line 45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

41: WHERE recipe_id = precipe_id)
42: AND line_type = 1);
43:
44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');
45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
46: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
47:
48: ELSIF(update_item = 'ROUTING') THEN
49: DELETE FROM gmd_recipe_routing_steps

Line 58: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_RT_DEP');

54:
55: DELETE FROM gmd_recipe_orgn_resources
56: WHERE recipe_id = precipe_id;
57:
58: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_RT_DEP');
59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
60: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
61: END IF;
62:

Line 59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

55: DELETE FROM gmd_recipe_orgn_resources
56: WHERE recipe_id = precipe_id;
57:
58: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_RT_DEP');
59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
60: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
61: END IF;
62:
63: DELETE FROM gmd_recipe_step_materials

Line 66: fnd_message.set_name('GMD', 'GMD_DELETE_STEP_MAT_ASSOC');

62:
63: DELETE FROM gmd_recipe_step_materials
64: WHERE recipe_id = precipe_id;
65:
66: fnd_message.set_name('GMD', 'GMD_DELETE_STEP_MAT_ASSOC');
67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
69:
70: EXCEPTION

Line 67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

63: DELETE FROM gmd_recipe_step_materials
64: WHERE recipe_id = precipe_id;
65:
66: fnd_message.set_name('GMD', 'GMD_DELETE_STEP_MAT_ASSOC');
67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
69:
70: EXCEPTION
71: WHEN OTHERS THEN

Line 679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');

675: -- Making new line entry and prompting users about MSNR request
676: -- Bug# 5008299 Kapil M
677: -- Moved the code for log file so that it is shown for every replace
678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

676: -- Bug# 5008299 Kapil M
677: -- Moved the code for log file so that it is shown for every replace
678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);

677: -- Moved the code for log file so that it is shown for every replace
678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);

678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:

Line 683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:
687: -- NPD Conv.

Line 684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:
687: -- NPD Conv.
688: -- Check if the Entity Owning organization is available for the responsibility

Line 754: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

750: (get_object_rec.object_type,
751: get_object_rec.object_id,
752: l_dependent_val);
753: IF l_dependent_val THEN
754: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
755: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
756: END IF;
757: END IF;
758:

Line 800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');

796: ||l_action_flag);
797: END IF;
798:
799: IF (l_action_flag = 'N') THEN
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
804: FND_MSG_PUB.ADD;

Line 801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

797: END IF;
798:
799: IF (l_action_flag = 'N') THEN
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
804: FND_MSG_PUB.ADD;
805: RAISE NO_UPDATE_EXCEPTION;

Line 802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

798:
799: IF (l_action_flag = 'N') THEN
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
804: FND_MSG_PUB.ADD;
805: RAISE NO_UPDATE_EXCEPTION;
806: END IF;

Line 803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );

799: IF (l_action_flag = 'N') THEN
800: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
802: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
803: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
804: FND_MSG_PUB.ADD;
805: RAISE NO_UPDATE_EXCEPTION;
806: END IF;
807:

Line 824: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');

820: OPEN Cur_check_item(get_object_rec.object_id, get_object_rec.new_name);
821: FETCH Cur_check_item INTO l_itm_exists;
822: CLOSE Cur_check_item;
823: IF l_itm_exists <> 1 THEN
824: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');
825: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
826: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
827: FND_MSG_PUB.ADD;
828: RAISE NO_UPDATE_EXCEPTION;

Line 825: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));

821: FETCH Cur_check_item INTO l_itm_exists;
822: CLOSE Cur_check_item;
823: IF l_itm_exists <> 1 THEN
824: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');
825: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
826: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
827: FND_MSG_PUB.ADD;
828: RAISE NO_UPDATE_EXCEPTION;
829: END IF;

Line 826: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));

822: CLOSE Cur_check_item;
823: IF l_itm_exists <> 1 THEN
824: FND_MESSAGE.SET_NAME('gmd', 'GMD_FORMULA_ITMORG_NOT_FOUND');
825: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
826: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
827: FND_MSG_PUB.ADD;
828: RAISE NO_UPDATE_EXCEPTION;
829: END IF;
830:

Line 844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');

840: FETCH cur_item_ver_access INTO l_rev_access;
841: CLOSE cur_item_ver_access;
842: IF l_rev_access <> 1 THEN
843: -- Bug# 5198213 New message shown for items with revision
844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
848: FND_MSG_PUB.ADD;

Line 845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));

841: CLOSE cur_item_ver_access;
842: IF l_rev_access <> 1 THEN
843: -- Bug# 5198213 New message shown for items with revision
844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
848: FND_MSG_PUB.ADD;
849: RAISE NO_UPDATE_EXCEPTION;

Line 846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );

842: IF l_rev_access <> 1 THEN
843: -- Bug# 5198213 New message shown for items with revision
844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
848: FND_MSG_PUB.ADD;
849: RAISE NO_UPDATE_EXCEPTION;
850: END IF;

Line 847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));

843: -- Bug# 5198213 New message shown for items with revision
844: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA_ITMREV_NOT_FOUND');
845: FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
846: FND_MESSAGE.set_token('REV',get_object_rec.new_version );
847: FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
848: FND_MSG_PUB.ADD;
849: RAISE NO_UPDATE_EXCEPTION;
850: END IF;
851: END IF;

Line 861: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');

857: OPEN Cur_experimental_items(get_object_rec.object_id, get_object_rec.new_name);
858: FETCH Cur_experimental_items INTO l_expr_items_found;
859: CLOSE Cur_experimental_items;
860: IF l_expr_items_found > 0 THEN
861: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');
862: FND_MSG_PUB.ADD;
863: RAISE NO_UPDATE_EXCEPTION;
864: END IF;
865: END IF;

Line 916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

912: FROM fm_form_mst_b
913: WHERE formula_id = l_formula_id;
914: -- Setup message to indicate that a new version
915: -- has been created
916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
917: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:

Line 917: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);

913: WHERE formula_id = l_formula_id;
914: -- Setup message to indicate that a new version
915: -- has been created
916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
917: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:
921: IF (get_object_rec.replace_type = 'INGREDIENT') THEN

Line 918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

914: -- Setup message to indicate that a new version
915: -- has been created
916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
917: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:
921: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

Line 919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

915: -- has been created
916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
917: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:
921: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

Line 922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

918: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:
921: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
924: get_item_no(get_object_rec.new_name) );
925: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

Line 923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

919: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
920:
921: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
924: get_item_no(get_object_rec.new_name) );
925: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

Line 926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

922: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
924: get_item_no(get_object_rec.new_name) );
925: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
928: get_owner_name(get_object_rec.new_name) );
929: ELSE
930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

923: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
924: get_item_no(get_object_rec.new_name) );
925: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
928: get_owner_name(get_object_rec.new_name) );
929: ELSE
930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

Line 930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

926: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
928: get_owner_name(get_object_rec.new_name) );
929: ELSE
930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
932: END IF;
933:
934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

927: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
928: get_owner_name(get_object_rec.new_name) );
929: ELSE
930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
932: END IF;
933:
934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
935: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
932: END IF;
933:
934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
935: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
936: END IF;
937:
938: ELSIF (l_action_flag IN ('U')) THEN

Line 987: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');

983: AND inventory_item_id = get_object_rec.old_name
984: AND NVL(revision, -1) = NVL(get_object_rec.old_version, -1);
985: -- Raise and exception is replace was not performed
986: IF (SQL%NOTFOUND) THEN
987: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');
988: FND_MSG_PUB.ADD;
989: RAISE NO_UPDATE_EXCEPTION;
990: END IF;
991: -- Item substitution realted fix, Bug 4479101

Line 1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');

1072: ||l_action_flag);
1073: END IF;
1074:
1075: IF (l_action_flag = 'N') THEN
1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1080: FND_MSG_PUB.ADD;

Line 1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1073: END IF;
1074:
1075: IF (l_action_flag = 'N') THEN
1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1080: FND_MSG_PUB.ADD;
1081: RAISE NO_UPDATE_EXCEPTION;

Line 1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1074:
1075: IF (l_action_flag = 'N') THEN
1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1080: FND_MSG_PUB.ADD;
1081: RAISE NO_UPDATE_EXCEPTION;
1082: END IF;

Line 1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );

1075: IF (l_action_flag = 'N') THEN
1076: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1077: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1078: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1079: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1080: FND_MSG_PUB.ADD;
1081: RAISE NO_UPDATE_EXCEPTION;
1082: END IF;
1083:

Line 1180: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

1176: WHERE recipe_id = l_recipe_id;
1177:
1178: -- Setup message to indicate that a new version
1179: -- has been created
1180: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1181: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:

Line 1181: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);

1177:
1178: -- Setup message to indicate that a new version
1179: -- has been created
1180: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1181: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN

Line 1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

1178: -- Setup message to indicate that a new version
1179: -- has been created
1180: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1181: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

Line 1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1179: -- has been created
1180: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1181: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1187: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

Line 1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

1182: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1187: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1188: GMD_API_GRP.get_object_name_version
1189: ('FORMULA'
1190: ,get_object_rec.new_name)

Line 1187: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1183: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1187: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1188: GMD_API_GRP.get_object_name_version
1189: ('FORMULA'
1190: ,get_object_rec.new_name)
1191: );

Line 1193: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

1189: ('FORMULA'
1190: ,get_object_rec.new_name)
1191: );
1192: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN
1193: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1194: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1195: GMD_API_GRP.get_object_name_version
1196: ('ROUTING'
1197: ,get_object_rec.new_name)

Line 1194: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1190: ,get_object_rec.new_name)
1191: );
1192: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN
1193: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1194: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1195: GMD_API_GRP.get_object_name_version
1196: ('ROUTING'
1197: ,get_object_rec.new_name)
1198: );

Line 1200: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

1196: ('ROUTING'
1197: ,get_object_rec.new_name)
1198: );
1199: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1200: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1201: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1202: get_owner_name(get_object_rec.new_name) );
1203: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1204: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_RECIPE_TYPE',true);

Line 1201: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1197: ,get_object_rec.new_name)
1198: );
1199: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1200: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1201: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1202: get_owner_name(get_object_rec.new_name) );
1203: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1204: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_RECIPE_TYPE',true);
1205: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

Line 1204: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_RECIPE_TYPE',true);

1200: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1201: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1202: get_owner_name(get_object_rec.new_name) );
1203: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1204: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_RECIPE_TYPE',true);
1205: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1206: get_recipe_type(get_object_rec.new_name) );
1207: -- Bug# 5234792 To get the recipe type value.
1208: ELSE

Line 1205: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1201: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1202: get_owner_name(get_object_rec.new_name) );
1203: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1204: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_RECIPE_TYPE',true);
1205: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1206: get_recipe_type(get_object_rec.new_name) );
1207: -- Bug# 5234792 To get the recipe type value.
1208: ELSE
1209: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 1209: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1205: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1206: get_recipe_type(get_object_rec.new_name) );
1207: -- Bug# 5234792 To get the recipe type value.
1208: ELSE
1209: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1210: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1211: END IF;
1212:
1213:

Line 1210: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

1206: get_recipe_type(get_object_rec.new_name) );
1207: -- Bug# 5234792 To get the recipe type value.
1208: ELSE
1209: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1210: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1211: END IF;
1212:
1213:
1214: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1214: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1210: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1211: END IF;
1212:
1213:
1214: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1216: END IF;
1217:
1218: ELSIF (l_action_flag IN ('U')) THEN

Line 1242: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_UPD_NO_ACCESS');

1238: last_update_login = p_last_update_login
1239: WHERE recipe_id = get_object_rec.object_id;
1240:
1241: IF (sql%notfound) THEN
1242: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_UPD_NO_ACCESS');
1243: FND_MSG_PUB.ADD;
1244: RAISE NO_UPDATE_EXCEPTION;
1245: END IF;
1246: -- Delete all recipe dependencies if either formula or

Line 1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');

1306: ||' : For Routing Action flag = '||l_action_flag);
1307: END IF;
1308:
1309: IF (l_action_flag = 'N') THEN
1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1314: FND_MSG_PUB.ADD;

Line 1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1307: END IF;
1308:
1309: IF (l_action_flag = 'N') THEN
1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1314: FND_MSG_PUB.ADD;
1315: RAISE NO_UPDATE_EXCEPTION;

Line 1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1308:
1309: IF (l_action_flag = 'N') THEN
1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1314: FND_MSG_PUB.ADD;
1315: RAISE NO_UPDATE_EXCEPTION;
1316: END IF;

Line 1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );

1309: IF (l_action_flag = 'N') THEN
1310: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1311: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1312: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1313: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1314: FND_MSG_PUB.ADD;
1315: RAISE NO_UPDATE_EXCEPTION;
1316: END IF;
1317:

Line 1368: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

1364: WHERE routing_id = l_routing_id;
1365:
1366: -- Setup message to indicate that a new version
1367: -- has been created
1368: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1369: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:

Line 1369: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);

1365:
1366: -- Setup message to indicate that a new version
1367: -- has been created
1368: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1369: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

1366: -- Setup message to indicate that a new version
1367: -- has been created
1368: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1369: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

Line 1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1367: -- has been created
1368: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1369: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1375: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

Line 1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

1370: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1375: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1376: GMD_API_GRP.get_object_name_version
1377: ('OPERATION'
1378: ,get_object_rec.new_name)

Line 1375: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1371: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1375: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1376: GMD_API_GRP.get_object_name_version
1377: ('OPERATION'
1378: ,get_object_rec.new_name)
1379: );

Line 1381: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

1377: ('OPERATION'
1378: ,get_object_rec.new_name)
1379: );
1380: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1381: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1382: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1383: get_owner_name(get_object_rec.new_name) );
1384: ELSE
1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 1382: FND_MESSAGE.SET_TOKEN('NEW_ITEM',

1378: ,get_object_rec.new_name)
1379: );
1380: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1381: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1382: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1383: get_owner_name(get_object_rec.new_name) );
1384: ELSE
1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

Line 1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1381: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1382: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1383: get_owner_name(get_object_rec.new_name) );
1384: ELSE
1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1387: END IF;
1388:
1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

1382: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1383: get_owner_name(get_object_rec.new_name) );
1384: ELSE
1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1387: END IF;
1388:
1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1387: END IF;
1388:
1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1391: END IF;
1392:
1393: ELSIF (l_action_flag IN ('U')) THEN

Line 1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');

1522: ||l_action_flag);
1523: END IF;
1524:
1525: IF (l_action_flag = 'N') THEN
1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1530: FND_MSG_PUB.ADD;

Line 1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1523: END IF;
1524:
1525: IF (l_action_flag = 'N') THEN
1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1530: FND_MSG_PUB.ADD;
1531: RAISE NO_UPDATE_EXCEPTION;

Line 1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1524:
1525: IF (l_action_flag = 'N') THEN
1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1530: FND_MSG_PUB.ADD;
1531: RAISE NO_UPDATE_EXCEPTION;
1532: END IF;

Line 1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );

1525: IF (l_action_flag = 'N') THEN
1526: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1527: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1528: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1529: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1530: FND_MSG_PUB.ADD;
1531: RAISE NO_UPDATE_EXCEPTION;
1532: END IF;
1533:

Line 1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

1589: WHERE oprn_id = l_oprn_id;
1590:
1591: -- Setup message to indicate that a new version
1592: -- has been created
1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

Line 1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1590:
1591: -- Setup message to indicate that a new version
1592: -- has been created
1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

Line 1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);

1591: -- Setup message to indicate that a new version
1592: -- has been created
1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

1592: -- has been created
1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1593: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');
1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1601: END IF;

Line 1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);

1594: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1601: END IF;
1602:

Line 1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1601: END IF;
1602:
1603: ELSIF (l_action_flag IN ('U')) THEN

Line 1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');

1771: IF (l_return_status <> 'S') THEN
1772: RAISE No_Update_Exception;
1773: END IF;
1774: ELSIF (l_action_flag = 'N') THEN
1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1779: FND_MSG_PUB.ADD;

Line 1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1772: RAISE No_Update_Exception;
1773: END IF;
1774: ELSIF (l_action_flag = 'N') THEN
1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1779: FND_MSG_PUB.ADD;
1780: RAISE NO_UPDATE_EXCEPTION;

Line 1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1773: END IF;
1774: ELSIF (l_action_flag = 'N') THEN
1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1779: FND_MSG_PUB.ADD;
1780: RAISE NO_UPDATE_EXCEPTION;
1781: END IF; -- for action flags for VRs

Line 1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );

1774: ELSIF (l_action_flag = 'N') THEN
1775: FND_MESSAGE.SET_NAME('GMD', 'GMD_REPLACE_NOT_ALLOWED');
1776: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1777: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1778: FND_MESSAGE.SET_TOKEN('STATUS',get_status_meaning(l_status_type) );
1779: FND_MSG_PUB.ADD;
1780: RAISE NO_UPDATE_EXCEPTION;
1781: END IF; -- for action flags for VRs
1782: END IF; -- After working thro' every object type condition

Line 1789: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT');

1785: -- Provide a log entry after any entity instance is successfully replaced
1786: -- Bug# 5234792 Kapil M
1787: -- Log for Update of existing version only
1788: IF ((l_return_status = 'S')AND (l_action_flag = 'U')) THEN
1789: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT');
1790: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1791:
1792: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1793: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

Line 1790: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

1786: -- Bug# 5234792 Kapil M
1787: -- Log for Update of existing version only
1788: IF ((l_return_status = 'S')AND (l_action_flag = 'U')) THEN
1789: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT');
1790: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1791:
1792: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1793: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1794: IF get_object_rec.new_version IS NULL THEN

Line 1793: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

1789: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT');
1790: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1791:
1792: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1793: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1794: IF get_object_rec.new_version IS NULL THEN
1795: l_item_txt := get_item_no(get_object_rec.new_name);
1796: ELSE
1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

Line 1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

1793: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1794: IF get_object_rec.new_version IS NULL THEN
1795: l_item_txt := get_item_no(get_object_rec.new_name);
1796: ELSE
1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1798: END IF;
1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

Line 1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );

1795: l_item_txt := get_item_no(get_object_rec.new_name);
1796: ELSE
1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1798: END IF;
1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1803: get_status_meaning(

Line 1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1797: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1798: END IF;
1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1803: get_status_meaning(
1804: GMD_API_GRP.get_object_status_type
1805: (get_object_rec.object_type

Line 1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1798: END IF;
1799: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1803: get_status_meaning(
1804: GMD_API_GRP.get_object_status_type
1805: (get_object_rec.object_type
1806: , get_object_rec.object_id)

Line 1809: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

1805: (get_object_rec.object_type
1806: , get_object_rec.object_id)
1807: ) );
1808: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1809: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1810: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1811: GMD_API_GRP.get_object_name_version
1812: ('ROUTING',get_object_rec.new_name)
1813: );

Line 1810: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1806: , get_object_rec.object_id)
1807: ) );
1808: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1809: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1810: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1811: GMD_API_GRP.get_object_name_version
1812: ('ROUTING',get_object_rec.new_name)
1813: );
1814: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1815: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

1811: GMD_API_GRP.get_object_name_version
1812: ('ROUTING',get_object_rec.new_name)
1813: );
1814: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1815: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1816: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1817: GMD_API_GRP.get_object_name_version
1818: ('OPERATION',get_object_rec.new_name)
1819: );

Line 1816: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1812: ('ROUTING',get_object_rec.new_name)
1813: );
1814: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1815: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1816: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1817: GMD_API_GRP.get_object_name_version
1818: ('OPERATION',get_object_rec.new_name)
1819: );
1820: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN

Line 1821: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

1817: GMD_API_GRP.get_object_name_version
1818: ('OPERATION',get_object_rec.new_name)
1819: );
1820: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1821: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1822: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1823: GMD_API_GRP.get_object_name_version
1824: ('FORMULA',get_object_rec.new_name)
1825: );

Line 1822: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1818: ('OPERATION',get_object_rec.new_name)
1819: );
1820: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1821: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1822: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1823: GMD_API_GRP.get_object_name_version
1824: ('FORMULA',get_object_rec.new_name)
1825: );
1826: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

Line 1827: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

1823: GMD_API_GRP.get_object_name_version
1824: ('FORMULA',get_object_rec.new_name)
1825: );
1826: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1827: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1828: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1829: get_owner_name(get_object_rec.new_name) );
1830: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1831: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1828: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1824: ('FORMULA',get_object_rec.new_name)
1825: );
1826: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1827: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1828: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1829: get_owner_name(get_object_rec.new_name) );
1830: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1831: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1832: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1831: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1827: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1828: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1829: get_owner_name(get_object_rec.new_name) );
1830: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1831: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1832: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1833: get_recipe_use(get_object_rec.new_name) );
1834: -- Bug# 5234792 Kapil M
1835: -- To get the recipe type value

Line 1832: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1828: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1829: get_owner_name(get_object_rec.new_name) );
1830: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1831: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1832: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1833: get_recipe_use(get_object_rec.new_name) );
1834: -- Bug# 5234792 Kapil M
1835: -- To get the recipe type value
1836: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN

Line 1837: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1833: get_recipe_use(get_object_rec.new_name) );
1834: -- Bug# 5234792 Kapil M
1835: -- To get the recipe type value
1836: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1837: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1838: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1839: get_recipe_type(get_object_rec.new_name) );
1840: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1841: (get_object_rec.replace_type like '%END_DATE%') ) THEN

Line 1838: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1834: -- Bug# 5234792 Kapil M
1835: -- To get the recipe type value
1836: ELSIF (get_object_rec.replace_type = 'RECIPE_TYPE') THEN
1837: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1838: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1839: get_recipe_type(get_object_rec.new_name) );
1840: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1841: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1842: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1842: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1838: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1839: get_recipe_type(get_object_rec.new_name) );
1840: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1841: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1842: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1843: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1844: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1845: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1846: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN

Line 1843: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1839: get_recipe_type(get_object_rec.new_name) );
1840: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1841: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1842: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1843: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1844: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1845: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1846: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1847: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1847: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1843: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1844: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1845: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1846: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1847: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1848: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1849: get_orgn_code(get_object_rec.new_name) );
1850:
1851: ELSE

Line 1848: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1844: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1845: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1846: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1847: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1848: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1849: get_orgn_code(get_object_rec.new_name) );
1850:
1851: ELSE
1852: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1852: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1848: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1849: get_orgn_code(get_object_rec.new_name) );
1850:
1851: ELSE
1852: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1853: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1854: END IF;
1855:
1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);

Line 1853: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);

1849: get_orgn_code(get_object_rec.new_name) );
1850:
1851: ELSE
1852: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1853: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1854: END IF;
1855:
1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1857: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);

Line 1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);

1852: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1853: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1854: END IF;
1855:
1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1857: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1858: -- to be removed
1859: -- fnd_msg_pub.add;
1860: END IF;

Line 1857: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);

1853: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1854: END IF;
1855:
1856: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1857: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1858: -- to be removed
1859: -- fnd_msg_pub.add;
1860: END IF;
1861:

Line 1862: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1858: -- to be removed
1859: -- fnd_msg_pub.add;
1860: END IF;
1861:
1862: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1863: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1864:
1865: -- Set the row counter
1866: l_rowcount := l_rowcount + 1;

Line 1889: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1885: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
1886: ||' : In the No_update_exception section '
1887: ||' Error text is '||l_error_text);
1888: END IF;
1889: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1890:
1891: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1892: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1893: IF get_object_rec.new_version IS NULL THEN

Line 1892: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

1888: END IF;
1889: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1890:
1891: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1892: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1893: IF get_object_rec.new_version IS NULL THEN
1894: l_item_txt := get_item_no(get_object_rec.new_name);
1895: ELSE
1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

Line 1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

1892: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1893: IF get_object_rec.new_version IS NULL THEN
1894: l_item_txt := get_item_no(get_object_rec.new_name);
1895: ELSE
1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1897: END IF;
1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1899: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

Line 1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );

1894: l_item_txt := get_item_no(get_object_rec.new_name);
1895: ELSE
1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1897: END IF;
1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1899: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );

Line 1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1896: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1897: END IF;
1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1899: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

Line 1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1897: END IF;
1898: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1899: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1905: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

1900: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1905: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1906: GMD_API_GRP.get_object_name_version
1907: ('ROUTING'
1908: ,get_object_rec.new_name)

Line 1905: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1901: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1905: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1906: GMD_API_GRP.get_object_name_version
1907: ('ROUTING'
1908: ,get_object_rec.new_name)
1909: );

Line 1911: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

1907: ('ROUTING'
1908: ,get_object_rec.new_name)
1909: );
1910: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1911: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1912: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1913: GMD_API_GRP.get_object_name_version
1914: ('OPERATION'
1915: ,get_object_rec.new_name)

Line 1912: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1908: ,get_object_rec.new_name)
1909: );
1910: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1911: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1912: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1913: GMD_API_GRP.get_object_name_version
1914: ('OPERATION'
1915: ,get_object_rec.new_name)
1916: );

Line 1918: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

1914: ('OPERATION'
1915: ,get_object_rec.new_name)
1916: );
1917: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1918: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1919: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1920: GMD_API_GRP.get_object_name_version
1921: ('FORMULA'
1922: ,get_object_rec.new_name)

Line 1919: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1915: ,get_object_rec.new_name)
1916: );
1917: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1918: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1919: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1920: GMD_API_GRP.get_object_name_version
1921: ('FORMULA'
1922: ,get_object_rec.new_name)
1923: );

Line 1925: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

1921: ('FORMULA'
1922: ,get_object_rec.new_name)
1923: );
1924: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1925: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1926: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1927: get_owner_name(get_object_rec.new_name) );
1928: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1929: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1926: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1922: ,get_object_rec.new_name)
1923: );
1924: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1925: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1926: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1927: get_owner_name(get_object_rec.new_name) );
1928: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1929: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1930: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1929: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1925: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1926: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1927: get_owner_name(get_object_rec.new_name) );
1928: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1929: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1930: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1931: get_recipe_use(get_object_rec.new_name) );
1932: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1933: (get_object_rec.replace_type like '%END_DATE%') ) THEN

Line 1930: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1926: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1927: get_owner_name(get_object_rec.new_name) );
1928: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
1929: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1930: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1931: get_recipe_use(get_object_rec.new_name) );
1932: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1933: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1930: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1931: get_recipe_use(get_object_rec.new_name) );
1932: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1933: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1936: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1937: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1931: get_recipe_use(get_object_rec.new_name) );
1932: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1933: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1936: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1937: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1936: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1937: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1940: get_orgn_code(get_object_rec.new_name) );
1941:
1942: ELSE

Line 1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1936: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1937: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1940: get_orgn_code(get_object_rec.new_name) );
1941:
1942: ELSE
1943: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 1943: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1940: get_orgn_code(get_object_rec.new_name) );
1941:
1942: ELSE
1943: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1944: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1945: END IF;
1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

Line 1944: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);

1940: get_orgn_code(get_object_rec.new_name) );
1941:
1942: ELSE
1943: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1944: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1945: END IF;
1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

Line 1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

1943: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1944: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1945: END IF;
1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

1944: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
1945: END IF;
1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);

1945: END IF;
1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1953: WHEN OTHERS THEN

Line 1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);

1946:
1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1953: WHEN OTHERS THEN
1954:

Line 1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1953: WHEN OTHERS THEN
1954:
1955: ret_code := 2;

Line 1960: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1956: err_buf := NULL;
1957: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
1958:
1959: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1960: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1961:
1962: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1963: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1964: IF get_object_rec.new_version IS NULL THEN

Line 1963: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);

1959: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
1960: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1961:
1962: IF (get_object_rec.replace_type = 'INGREDIENT') THEN
1963: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1964: IF get_object_rec.new_version IS NULL THEN
1965: l_item_txt := get_item_no(get_object_rec.new_name);
1966: ELSE
1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

Line 1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;

1963: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','LM_INGREDIENT',true);
1964: IF get_object_rec.new_version IS NULL THEN
1965: l_item_txt := get_item_no(get_object_rec.new_name);
1966: ELSE
1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1968: END IF;
1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1970: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

Line 1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );

1965: l_item_txt := get_item_no(get_object_rec.new_name);
1966: ELSE
1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1968: END IF;
1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1970: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );

Line 1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);

1967: l_item_txt := get_item_no(get_object_rec.new_name) ||' , '|| fnd_message.GET_STRING('INV', 'REVISION') || ' : '||get_object_rec.new_version;
1968: END IF;
1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1970: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

Line 1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1968: END IF;
1969: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', l_item_txt );
1970: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1976: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);

1971: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1976: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1977: GMD_API_GRP.get_object_name_version
1978: ('ROUTING'
1979: ,get_object_rec.new_name)

Line 1976: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1972: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1976: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1977: GMD_API_GRP.get_object_name_version
1978: ('ROUTING'
1979: ,get_object_rec.new_name)
1980: );

Line 1982: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

1978: ('ROUTING'
1979: ,get_object_rec.new_name)
1980: );
1981: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1982: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1983: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1984: GMD_API_GRP.get_object_name_version
1985: ('OPERATION'
1986: ,get_object_rec.new_name)

Line 1983: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1979: ,get_object_rec.new_name)
1980: );
1981: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1982: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1983: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1984: GMD_API_GRP.get_object_name_version
1985: ('OPERATION'
1986: ,get_object_rec.new_name)
1987: );

Line 1989: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

1985: ('OPERATION'
1986: ,get_object_rec.new_name)
1987: );
1988: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1989: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1990: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1991: GMD_API_GRP.get_object_name_version
1992: ('FORMULA'
1993: ,get_object_rec.new_name)

Line 1990: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1986: ,get_object_rec.new_name)
1987: );
1988: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1989: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1990: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1991: GMD_API_GRP.get_object_name_version
1992: ('FORMULA'
1993: ,get_object_rec.new_name)
1994: );

Line 1996: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

1992: ('FORMULA'
1993: ,get_object_rec.new_name)
1994: );
1995: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1996: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1997: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1998: get_owner_name(get_object_rec.new_name) );
1999: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
2000: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 1997: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1993: ,get_object_rec.new_name)
1994: );
1995: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1996: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1997: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1998: get_owner_name(get_object_rec.new_name) );
1999: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
2000: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2001: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 2000: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

1996: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);
1997: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1998: get_owner_name(get_object_rec.new_name) );
1999: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
2000: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2001: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2002: get_recipe_use(get_object_rec.new_name) );
2003: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
2004: (get_object_rec.replace_type like '%END_DATE%') ) THEN

Line 2001: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

1997: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1998: get_owner_name(get_object_rec.new_name) );
1999: ELSIF (get_object_rec.replace_type = 'RECIPE_USE') THEN
2000: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2001: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2002: get_recipe_use(get_object_rec.new_name) );
2003: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
2004: (get_object_rec.replace_type like '%END_DATE%') ) THEN
2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

2001: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2002: get_recipe_use(get_object_rec.new_name) );
2003: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
2004: (get_object_rec.replace_type like '%END_DATE%') ) THEN
2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2007: FND_DATE.canonical_to_date(get_object_rec.new_name) );
2008: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

Line 2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

2002: get_recipe_use(get_object_rec.new_name) );
2003: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
2004: (get_object_rec.replace_type like '%END_DATE%') ) THEN
2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2007: FND_DATE.canonical_to_date(get_object_rec.new_name) );
2008: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2007: FND_DATE.canonical_to_date(get_object_rec.new_name) );
2008: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2011: get_orgn_code(get_object_rec.new_name) );
2012: ELSE
2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

Line 2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2007: FND_DATE.canonical_to_date(get_object_rec.new_name) );
2008: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2011: get_orgn_code(get_object_rec.new_name) );
2012: ELSE
2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);

Line 2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);

2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2011: get_orgn_code(get_object_rec.new_name) );
2012: ELSE
2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
2015: END IF;
2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

Line 2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);

2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2011: get_orgn_code(get_object_rec.new_name) );
2012: ELSE
2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
2015: END IF;
2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

Line 2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);

2013: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
2015: END IF;
2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);

2014: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_object_rec.new_name);
2015: END IF;
2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);

2015: END IF;
2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2023: END; -- End created to handle exception for each record

Line 2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

2016:
2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2023: END; -- End created to handle exception for each record
2024:

Line 2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2023: END; -- End created to handle exception for each record
2024:
2025:

Line 2039: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NO_ROW_FOUND');

2035: END IF;
2036:
2037: -- There were no row selected for replace raise an error
2038: IF (l_rowcount = 0) THEN
2039: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NO_ROW_FOUND');
2040: Raise No_Replace_Exception;
2041: END IF;
2042:
2043: IF (l_debug = 'Y') THEN

Line 2067: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

2063: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
2064: ||' : In the No_replace_exception section '
2065: ||' Error text is '||l_error_text);
2066: END IF;
2067: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2068: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2069: -- outer excepption handles all error that occur prior to or after
2070: -- Mass updates (or within LOOP above)
2071:

Line 2079: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

2075: err_buf := NULL;
2076: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
2077:
2078: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2079: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2081: IF (pReplace_type = 'INGREDIENT') THEN
2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );
2083: ELSIF (preplace_type = 'STATUS') THEN

Line 2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);

2076: l_retval := fnd_concurrent.set_completion_status('WARNING',sqlerrm);
2077:
2078: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2079: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2081: IF (pReplace_type = 'INGREDIENT') THEN
2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );
2083: ELSIF (preplace_type = 'STATUS') THEN
2084: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_status_meaning(pnew_name) );

Line 2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );

2078: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
2079: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2081: IF (pReplace_type = 'INGREDIENT') THEN
2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );
2083: ELSIF (preplace_type = 'STATUS') THEN
2084: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_status_meaning(pnew_name) );
2085: ELSIF (pReplace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2086: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 2084: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_status_meaning(pnew_name) );

2080: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2081: IF (pReplace_type = 'INGREDIENT') THEN
2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );
2083: ELSIF (preplace_type = 'STATUS') THEN
2084: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_status_meaning(pnew_name) );
2085: ELSIF (pReplace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2086: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2087: get_orgn_code(pnew_name) );
2088: ELSE

Line 2086: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

2082: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE', get_item_no(pNew_name) );
2083: ELSIF (preplace_type = 'STATUS') THEN
2084: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',get_status_meaning(pnew_name) );
2085: ELSIF (pReplace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2086: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2087: get_orgn_code(pnew_name) );
2088: ELSE
2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;

Line 2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);

2085: ELSIF (pReplace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2086: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2087: get_orgn_code(pnew_name) );
2088: ELSE
2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);

2087: get_orgn_code(pnew_name) );
2088: ELSE
2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2094: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2095:

Line 2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

2088: ELSE
2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2094: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2095:
2096: END Mass_Replace_Operation;

Line 2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2094: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2095:
2096: END Mass_Replace_Operation;
2097:

Line 2235: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');

2231: ,'FORMULA_CLASS') THEN
2232: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');
2233: ELSE
2234: -- pOld_Name cannot be null
2235: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');
2236: FND_MSG_PUB.ADD;
2237: RAISE VALIDATION_FAILED_EXCEPTION;
2238: END IF;
2239: ELSE