DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES_PVT dependencies on FND_MESSAGE

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

67: BEGIN
68: x_return_status := 'S';
69:
70: IF P_disp_start_date < P_routing_start_date THEN
71: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
72: FND_MSG_PUB.ADD;
73: x_return_status := 'E';
74: END IF;
75:

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

98: x_return_status := 'S';
99: IF (P_end_date IS NOT NULL) AND
100: (P_routing_end_date IS NOT NULL) AND
101: (P_end_date > P_routing_end_date) THEN
102: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
103: FND_MSG_PUB.ADD;
104: x_return_status := 'E';
105: END IF;
106:

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

106:
107: -- Routing end date is finite but Vr end date is infinite
108: IF (P_routing_end_date IS NOT NULL) AND
109: (P_end_date IS NULL) THEN
110: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
111: FND_MSG_PUB.ADD;
112: x_return_status := 'E';
113: END IF;
114:

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

136: x_return_status := 'S';
137:
138: IF (P_end_date IS NOT NULL AND P_start_date IS NOT NULL) THEN
139: IF (P_end_date < P_start_date) THEN
140: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
141: FND_MSG_PUB.ADD;
142: x_return_status := 'E';
143: END IF;
144: END IF;

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

170: IF (P_std_qty < P_min_qty
171: OR P_std_qty > P_max_qty)
172: OR P_std_qty <= 0 THEN
173: IF P_std_qty <= 0 THEN
174: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');
175: FND_MSG_PUB.ADD;
176: x_return_status := 'E';
177: ELSE
178: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');

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

174: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');
175: FND_MSG_PUB.ADD;
176: x_return_status := 'E';
177: ELSE
178: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');
179: FND_MSG_PUB.ADD;
180: x_return_status := 'E';
181: END IF; -- end if std qty is the problem, or the range
182: END IF; -- end if std qty not within range

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

206: IF P_max_qty IS NOT NULL THEN
207: IF (P_max_qty < P_min_qty
208: OR P_min_qty < 0) THEN
209: IF P_min_qty < 0 THEN
210: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');
211: FND_MSG_PUB.ADD;
212: x_return_status := 'E';
213: ELSE
214: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');

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

210: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');
211: FND_MSG_PUB.ADD;
212: x_return_status := 'E';
213: ELSE
214: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');
215: FND_MSG_PUB.ADD;
216: x_return_status := 'E';
217: END IF; -- end if qty is the problem, or the range
218: END IF; -- IF (P_max_qty < P_min_qty

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

425: gmd_debug.put_line(m_pkg_name||'.'||l_api_name
426: ||': Duplicate VR id = '||VR_dup_rec.recipe_validity_rule_id);
427:
428: END IF;
429: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_VR_EXIST');
430: FND_MSG_PUB.ADD;
431: x_return_status := 'E';
432: END LOOP;
433: EXCEPTION

Line 557: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_INVALID');

553: /* Get the old routing rec value */
554: OPEN get_old_vr_rec(p_validity_rule_id);
555: FETCH get_old_vr_rec INTO l_old_vr_rec;
556: IF get_old_vr_rec%NOTFOUND THEN
557: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_INVALID');
558: FND_MSG_PUB.ADD;
559: CLOSE get_old_vr_rec;
560: RAISE vr_update_failure;
561: END IF;

Line 710: FND_MESSAGE.set_name('GMD','GMD_NOT_USE_API_UPD_STATUS');

706: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'VALIDITY_RULE_STATUS') THEN
707: -- Users should be prompted to use change status API
708: -- Since Change Status API commits work it cannot be
709: -- called from here directly
710: FND_MESSAGE.set_name('GMD','GMD_NOT_USE_API_UPD_STATUS');
711: FND_MSG_PUB.ADD;
712: RAISE vr_update_failure;
713: END IF;
714:

Line 724: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_CANNOT_UPD');

720: /* Chcek if update is allowed */
721: IF NOT GMD_COMMON_VAL.update_allowed('VALIDITY'
722: ,p_Validity_rule_id
723: ,UPPER(p_update_table(i).p_col_to_update) ) THEN
724: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_CANNOT_UPD');
725: FND_MSG_PUB.ADD;
726: RAISE vr_update_failure;
727: END IF;
728:

Line 760: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_IS_PRODUCT');

756:
757: -- Check if the item being modified is either a product or a by-product
758: IF (UPPER(p_update_table(i).p_col_to_update) = 'ITEM_ID') THEN
759: IF NOT Determine_Product(l_old_vr_rec.RECIPE_ID, l_old_vr_rec.INVENTORY_ITEM_ID) THEN -- NPD Conv.
760: FND_MESSAGE.SET_NAME('GMD', 'GMD_ITEM_IS_PRODUCT');
761: FND_MSG_PUB.ADD;
762: x_return_status := 'E';
763: RAISE vr_update_failure;
764: END IF;

Line 853: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');

849: FETCH check_fmhdr_fixed_scale INTO l_fixed_scale;
850: CLOSE check_fmhdr_fixed_scale;
851:
852: IF (l_fixed_scale = 1) THEN
853: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');
854: FND_MSG_PUB.ADD;
855: RAISE vr_update_failure;
856: END IF;
857:

Line 870: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');

866: FETCH check_fmdtl_fixed_scale INTO l_fixed_scale;
867: CLOSE check_fmdtl_fixed_scale;
868:
869: IF (l_fixed_scale = 1) THEN
870: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');
871: FND_MSG_PUB.ADD;
872: RAISE vr_update_failure;
873: END IF;
874: END IF;

Line 1103: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_UPD_NO_ACCESS');

1099: , fixed_process_loss_uom = l_old_vr_rec.fixed_process_loss_uom /* RLNAGARA Bug6997624 */
1100: where recipe_validity_rule_id = p_validity_rule_id;
1101:
1102: IF (sql%notfound) THEN
1103: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_UPD_NO_ACCESS');
1104: FND_MSG_PUB.ADD;
1105: RAISE vr_update_failure;
1106: END IF;
1107:

Line 1140: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

1136: ,p_encoded => FND_API.g_false
1137: ,p_data => x_message_list);
1138: WHEN last_update_date_failure THEN
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1141: FND_MSG_PUB.ADD;
1142: fnd_msg_pub.count_and_get (
1143: p_count => x_message_count
1144: ,p_encoded => FND_API.g_false