DBA Data[Home] [Help]

APPS.GMD_RECIPE_VAL dependencies on FND_MESSAGE

Line 103: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');

99: IF (p_recipe_id IS NOT NULL) THEN
100: OPEN get_record_with_recipe_id(p_recipe_id);
101: FETCH get_record_with_recipe_id into x_recipe_id;
102: IF get_record_with_recipe_id%NOTFOUND THEN
103: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: CLOSE get_record_with_recipe_id;

Line 112: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');

108: ELSE
109: OPEN get_record_without_recipe_id(p_recipe_no, p_recipe_version);
110: FETCH get_record_without_recipe_id into x_recipe_id;
111: IF get_record_without_recipe_id%NOTFOUND THEN
112: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
113: FND_MSG_PUB.Add;
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: CLOSE get_record_without_recipe_id;

Line 797: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');

793: BEGIN
794: x_return_status := 'S';
795:
796: IF P_disp_start_date < P_routing_start_date THEN
797: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
798: FND_MSG_PUB.ADD;
799: x_return_status := 'E';
800: END IF;
801:

Line 828: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');

824: x_return_status := 'S';
825: IF (P_end_date IS NOT NULL) AND
826: (P_routing_end_date IS NOT NULL) AND
827: (P_end_date > P_routing_end_date) THEN
828: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
829: FND_MSG_PUB.ADD;
830: x_return_status := 'E';
831: END IF;
832:

Line 836: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');

832:
833: -- Routing end date is finite but Vr end date is infinite
834: IF (P_routing_end_date IS NOT NULL) AND
835: (P_end_date IS NULL) THEN
836: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
837: FND_MSG_PUB.ADD;
838: x_return_status := 'E';
839: END IF;
840:

Line 866: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

862: x_return_status := 'S';
863:
864: IF (P_end_date IS NOT NULL AND P_start_date IS NOT NULL) THEN
865: IF (P_end_date < P_start_date) THEN
866: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
867: FND_MSG_PUB.ADD;
868: x_return_status := 'E';
869: END IF;
870: END IF;

Line 900: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');

896: IF (P_std_qty < P_min_qty
897: OR P_std_qty > P_max_qty)
898: OR P_std_qty <= 0 THEN
899: IF P_std_qty <= 0 THEN
900: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');
901: FND_MSG_PUB.ADD;
902: x_return_status := 'E';
903: ELSE
904: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');

Line 904: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');

900: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');
901: FND_MSG_PUB.ADD;
902: x_return_status := 'E';
903: ELSE
904: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');
905: FND_MSG_PUB.ADD;
906: x_return_status := 'E';
907: END IF; -- end if std qty is the problem, or the range
908: END IF; -- end if std qty not within range

Line 936: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');

932: IF P_max_qty IS NOT NULL THEN
933: IF (P_max_qty < P_min_qty
934: OR P_min_qty < 0) THEN
935: IF P_min_qty < 0 THEN
936: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');
937: FND_MSG_PUB.ADD;
938: x_return_status := 'E';
939: ELSE
940: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');

Line 940: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');

936: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');
937: FND_MSG_PUB.ADD;
938: x_return_status := 'E';
939: ELSE
940: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');
941: FND_MSG_PUB.ADD;
942: x_return_status := 'E';
943: END IF; -- end if qty is the problem, or the range
944: END IF; -- IF (P_max_qty < P_min_qty

Line 1128: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_VR_EXIST');

1124: l_api_name VARCHAR2(100) := 'check_for_duplicate' ;
1125: BEGIN
1126: x_return_status := 'S';
1127: FOR VR_dup_rec IN Cur_check_dup_upd LOOP
1128: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_VR_EXIST');
1129: FND_MSG_PUB.ADD;
1130: x_return_status := 'E';
1131: END LOOP;
1132: EXCEPTION