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 558: FND_MSG_PUB.ADD;

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;
562: CLOSE get_old_vr_rec;

Line 711: FND_MSG_PUB.ADD;

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:
715: IF (l_debug = 'Y') THEN

Line 725: FND_MSG_PUB.ADD;

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:
729: /* Compare Dates - if the last update date passed in via the API is less than

Line 761: FND_MSG_PUB.ADD;

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

Line 854: FND_MSG_PUB.ADD;

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:
858: -- Check if scale type at formula dtl for the VR product is fixed, if yes then

Line 871: FND_MSG_PUB.ADD;

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;
875: -- Bug 5024092 KapilM

Line 1104: FND_MSG_PUB.ADD;

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:
1108: IF (l_debug = 'Y') THEN

Line 1118: fnd_msg_pub.count_and_get (

1114: RAISE vr_update_failure;
1115: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1116:
1117: /* Get the messgae list and count generated by this API */
1118: fnd_msg_pub.count_and_get (
1119: p_count => x_message_count
1120: ,p_encoded => FND_API.g_false
1121: ,p_data => x_message_list);
1122:

Line 1134: fnd_msg_pub.count_and_get (

1130: IF (l_debug = 'Y') THEN
1131: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1132: END IF;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: fnd_msg_pub.count_and_get (
1135: p_count => x_message_count
1136: ,p_encoded => FND_API.g_false
1137: ,p_data => x_message_list);
1138: WHEN last_update_date_failure THEN

Line 1141: FND_MSG_PUB.ADD;

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
1145: ,p_data => x_message_list);

Line 1142: fnd_msg_pub.count_and_get (

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
1145: ,p_data => x_message_list);
1146: WHEN setup_failure THEN

Line 1148: fnd_msg_pub.count_and_get (

1144: ,p_encoded => FND_API.g_false
1145: ,p_data => x_message_list);
1146: WHEN setup_failure THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: fnd_msg_pub.count_and_get (
1149: p_count => x_message_count
1150: ,p_encoded => FND_API.g_false
1151: ,p_data => x_message_list);
1152: WHEN OTHERS THEN

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

1152: WHEN OTHERS THEN
1153: IF (l_debug = 'Y') THEN
1154: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1155: END IF;
1156: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1157: x_return_status := FND_API.g_ret_sts_unexp_error;
1158: fnd_msg_pub.count_and_get (
1159: p_count => x_message_count
1160: ,p_encoded => FND_API.g_false

Line 1158: fnd_msg_pub.count_and_get (

1154: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1155: END IF;
1156: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1157: x_return_status := FND_API.g_ret_sts_unexp_error;
1158: fnd_msg_pub.count_and_get (
1159: p_count => x_message_count
1160: ,p_encoded => FND_API.g_false
1161: ,p_data => x_message_list);
1162: END update_validity_rules;