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_VALIDITY_RULES_PVT dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.ADD;

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:
76: EXCEPTION

Line 78: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

74: END IF;
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
79: x_return_status := FND_API.g_ret_sts_unexp_error;
80: END validate_start_date;
81:
82: /*#####################################################

Line 103: FND_MSG_PUB.ADD;

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:
107: -- Routing end date is finite but Vr end date is infinite

Line 111: FND_MSG_PUB.ADD;

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:
115: EXCEPTION

Line 117: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

113: END IF;
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
118: x_return_status := FND_API.g_ret_sts_unexp_error;
119: END validate_end_date;
120:
121:

Line 141: FND_MSG_PUB.ADD;

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;
145: EXCEPTION

Line 147: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

143: END IF;
144: END IF;
145: EXCEPTION
146: WHEN OTHERS THEN
147: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
148: x_return_status := FND_API.g_ret_sts_unexp_error;
149: END effective_dates;
150:
151: /*###################################################################

Line 175: FND_MSG_PUB.ADD;

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');
179: FND_MSG_PUB.ADD;

Line 179: FND_MSG_PUB.ADD;

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
183: END IF; -- end if std qty is not null

Line 186: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

182: END IF; -- end if std qty not within range
183: END IF; -- end if std qty is not null
184: EXCEPTION
185: WHEN OTHERS THEN
186: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
187: x_return_status := FND_API.g_ret_sts_unexp_error;
188: END std_qty;
189:
190: /*#####################################################

Line 211: FND_MSG_PUB.ADD;

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');
215: FND_MSG_PUB.ADD;

Line 215: FND_MSG_PUB.ADD;

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
219: END IF; -- IF P_max_qty IS NOT NULL

Line 222: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

218: END IF; -- IF (P_max_qty < P_min_qty
219: END IF; -- IF P_max_qty IS NOT NULL
220: EXCEPTION
221: WHEN OTHERS THEN
222: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
223: x_return_status := FND_API.g_ret_sts_unexp_error;
224: END max_qty;
225:
226:

Line 288: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

284: X_inv_min_qty := ROUND(X_inv_min_qty,5); --NPD Conv. Round upto 5 digits
285: X_inv_max_qty := ROUND(X_inv_max_qty,5);
286: EXCEPTION
287: WHEN OTHERS THEN
288: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
289: x_return_status := FND_API.g_ret_sts_unexp_error;
290: END calc_inv_qtys;
291:
292: /*#####################################################

Line 355: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

351: END IF;
352: END IF;
353: EXCEPTION
354: WHEN OTHERS THEN
355: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
356: x_return_status := FND_API.g_ret_sts_unexp_error;
357: END calculate_process_loss;
358:
359: /*#####################################################

Line 430: FND_MSG_PUB.ADD;

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
434: WHEN OTHERS THEN

Line 435: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

431: x_return_status := 'E';
432: END LOOP;
433: EXCEPTION
434: WHEN OTHERS THEN
435: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
436: x_return_status := FND_API.g_ret_sts_unexp_error;
437: END check_for_duplicate;
438:
439:

Line 561: FND_MSG_PUB.ADD;

557: OPEN get_old_vr_rec(p_validity_rule_id);
558: FETCH get_old_vr_rec INTO l_old_vr_rec;
559: IF get_old_vr_rec%NOTFOUND THEN
560: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_INVALID');
561: FND_MSG_PUB.ADD;
562: CLOSE get_old_vr_rec;
563: RAISE vr_update_failure;
564: END IF;
565: CLOSE get_old_vr_rec;

Line 714: FND_MSG_PUB.ADD;

710: -- Users should be prompted to use change status API
711: -- Since Change Status API commits work it cannot be
712: -- called from here directly
713: FND_MESSAGE.set_name('GMD','GMD_NOT_USE_API_UPD_STATUS');
714: FND_MSG_PUB.ADD;
715: RAISE vr_update_failure;
716: END IF;
717:
718: IF (l_debug = 'Y') THEN

Line 728: FND_MSG_PUB.ADD;

724: IF NOT GMD_COMMON_VAL.update_allowed('VALIDITY'
725: ,p_Validity_rule_id
726: ,UPPER(p_update_table(i).p_col_to_update) ) THEN
727: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_CANNOT_UPD');
728: FND_MSG_PUB.ADD;
729: RAISE vr_update_failure;
730: END IF;
731:
732: /* Compare Dates - if the last update date passed in via the API is less than

Line 764: FND_MSG_PUB.ADD;

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

Line 857: FND_MSG_PUB.ADD;

853: CLOSE check_fmhdr_fixed_scale;
854:
855: IF (l_fixed_scale = 1) THEN
856: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');
857: FND_MSG_PUB.ADD;
858: RAISE vr_update_failure;
859: END IF;
860:
861: -- Check if scale type at formula dtl for the VR product is fixed, if yes then

Line 874: FND_MSG_PUB.ADD;

870: CLOSE check_fmdtl_fixed_scale;
871:
872: IF (l_fixed_scale = 1) THEN
873: FND_MESSAGE.SET_NAME('GMD', 'GMD_FXD_HDR_FOR_VR');
874: FND_MSG_PUB.ADD;
875: RAISE vr_update_failure;
876: END IF;
877: END IF;
878: -- Bug 5024092 KapilM

Line 1117: FND_MSG_PUB.ADD;

1113: where recipe_validity_rule_id = p_validity_rule_id;
1114:
1115: IF (sql%notfound) THEN
1116: FND_MESSAGE.SET_NAME('GMD', 'GMD_VR_UPD_NO_ACCESS');
1117: FND_MSG_PUB.ADD;
1118: RAISE vr_update_failure;
1119: END IF;
1120:
1121: IF (l_debug = 'Y') THEN

Line 1131: fnd_msg_pub.count_and_get (

1127: RAISE vr_update_failure;
1128: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1129:
1130: /* Get the messgae list and count generated by this API */
1131: fnd_msg_pub.count_and_get (
1132: p_count => x_message_count
1133: ,p_encoded => FND_API.g_false
1134: ,p_data => x_message_list);
1135:

Line 1147: fnd_msg_pub.count_and_get (

1143: IF (l_debug = 'Y') THEN
1144: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1145: END IF;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: fnd_msg_pub.count_and_get (
1148: p_count => x_message_count
1149: ,p_encoded => FND_API.g_false
1150: ,p_data => x_message_list);
1151: WHEN last_update_date_failure THEN

Line 1154: FND_MSG_PUB.ADD;

1150: ,p_data => x_message_list);
1151: WHEN last_update_date_failure THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1154: FND_MSG_PUB.ADD;
1155: fnd_msg_pub.count_and_get (
1156: p_count => x_message_count
1157: ,p_encoded => FND_API.g_false
1158: ,p_data => x_message_list);

Line 1155: fnd_msg_pub.count_and_get (

1151: WHEN last_update_date_failure THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1154: FND_MSG_PUB.ADD;
1155: fnd_msg_pub.count_and_get (
1156: p_count => x_message_count
1157: ,p_encoded => FND_API.g_false
1158: ,p_data => x_message_list);
1159: WHEN setup_failure THEN

Line 1161: fnd_msg_pub.count_and_get (

1157: ,p_encoded => FND_API.g_false
1158: ,p_data => x_message_list);
1159: WHEN setup_failure THEN
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: fnd_msg_pub.count_and_get (
1162: p_count => x_message_count
1163: ,p_encoded => FND_API.g_false
1164: ,p_data => x_message_list);
1165: WHEN OTHERS THEN

Line 1169: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

1165: WHEN OTHERS THEN
1166: IF (l_debug = 'Y') THEN
1167: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1168: END IF;
1169: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1170: x_return_status := FND_API.g_ret_sts_unexp_error;
1171: fnd_msg_pub.count_and_get (
1172: p_count => x_message_count
1173: ,p_encoded => FND_API.g_false

Line 1171: fnd_msg_pub.count_and_get (

1167: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1168: END IF;
1169: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1170: x_return_status := FND_API.g_ret_sts_unexp_error;
1171: fnd_msg_pub.count_and_get (
1172: p_count => x_message_count
1173: ,p_encoded => FND_API.g_false
1174: ,p_data => x_message_list);
1175: END update_validity_rules;