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_ROUTINGS_PUB dependencies on FND_MESSAGE

Line 157: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

153: IF p_routings.routing_no IS NULL THEN
154: IF (l_debug = 'Y') THEN
155: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');
156: END IF;
157: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
158: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');
159: FND_MSG_PUB.ADD;
160: RAISE routing_creation_failure;
161: END IF;

Line 158: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');

154: IF (l_debug = 'Y') THEN
155: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');
156: END IF;
157: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
158: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');
159: FND_MSG_PUB.ADD;
160: RAISE routing_creation_failure;
161: END IF;
162:

Line 167: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

163: IF p_routings.routing_vers IS NULL THEN
164: IF (l_debug = 'Y') THEN
165: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Version required');
166: END IF;
167: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
168: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_VERS');
169: FND_MSG_PUB.ADD;
170: RAISE routing_creation_failure;
171: ELSIF p_routings.routing_vers IS NOT NULL THEN

Line 168: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_VERS');

164: IF (l_debug = 'Y') THEN
165: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Version required');
166: END IF;
167: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
168: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_VERS');
169: FND_MSG_PUB.ADD;
170: RAISE routing_creation_failure;
171: ELSIF p_routings.routing_vers IS NOT NULL THEN
172: IF (p_routings.routing_vers < 0 ) THEN

Line 173: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

169: FND_MSG_PUB.ADD;
170: RAISE routing_creation_failure;
171: ELSIF p_routings.routing_vers IS NOT NULL THEN
172: IF (p_routings.routing_vers < 0 ) THEN
173: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
174: FND_MSG_PUB.ADD;
175: RAISE routing_creation_failure;
176: END IF;
177: END IF;

Line 183: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

179: IF p_routings.routing_desc IS NULL THEN
180: IF (l_debug = 'Y') THEN
181: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');
182: END IF;
183: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
184: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');
185: FND_MSG_PUB.ADD;
186: RAISE routing_creation_failure;
187: END IF;

Line 184: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');

180: IF (l_debug = 'Y') THEN
181: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');
182: END IF;
183: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
184: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');
185: FND_MSG_PUB.ADD;
186: RAISE routing_creation_failure;
187: END IF;
188:

Line 194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

190: IF p_routings.routing_uom IS NULL THEN
191: IF (l_debug = 'Y') THEN
192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');
193: END IF;
194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
196: FND_MSG_PUB.ADD;
197: RAISE routing_creation_failure;
198: /* call common function to check if um passed is valid */

Line 195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');

191: IF (l_debug = 'Y') THEN
192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');
193: END IF;
194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
196: FND_MSG_PUB.ADD;
197: RAISE routing_creation_failure;
198: /* call common function to check if um passed is valid */
199: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN

Line 203: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

199: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
200: IF (l_debug = 'Y') THEN
201: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
202: END IF;
203: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
204: FND_MSG_PUB.ADD;
205: RAISE routing_creation_failure;
206: END IF;
207:

Line 215: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');

211: */
212:
213: --Check that organization id is not null if raise an error message
214: IF (p_routings.owner_organization_id IS NULL) THEN
215: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
216: FND_MSG_PUB.Add;
217: RAISE routing_creation_failure;
218: END IF;
219:

Line 227: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

223: END IF;
224:
225: --Check the organization id passed is process enabled if not raise an error message
226: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN
227: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
228: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);
229: FND_MSG_PUB.Add;
230: RAISE routing_creation_failure;
231: END IF;

Line 228: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);

224:
225: --Check the organization id passed is process enabled if not raise an error message
226: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN
227: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
228: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);
229: FND_MSG_PUB.Add;
230: RAISE routing_creation_failure;
231: END IF;
232:

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

239: IF (l_debug = 'Y') THEN
240: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
241: ||'effective start date must be less then end date');
242: END IF;
243: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
244: FND_MSG_PUB.ADD;
245: RAISE routing_creation_failure;
246: END IF;
247: END IF;

Line 258: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_DUPLICATION');

254: ,xRouting_id => l_routing_id
255: ,xReturn_status => l_return_status);
256:
257: IF l_return_status <> 'E' THEN /* it indicates that this routing exists */
258: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_DUPLICATION');
259: FND_MSG_PUB.ADD;
260: RAISE routing_creation_failure;
261: ELSE
262: OPEN Get_routing_id_seq;

Line 265: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_SEQ');

261: ELSE
262: OPEN Get_routing_id_seq;
263: FETCH Get_routing_id_seq INTO l_routing_id;
264: IF Get_routing_id_seq%NOTFOUND then
265: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_SEQ');
266: FND_MSG_PUB.ADD;
267: RAISE routing_creation_failure;
268: END IF;
269: CLOSE Get_routing_id_seq;

Line 278: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_OPRN');

274: FOR b IN 1 .. p_routings_step_tbl.count LOOP
275: OPEN Get_oprn_details(p_routings_step_tbl(b).oprn_id);
276: FETCH Get_oprn_details INTO l_oprn_no, l_oprn_vers;
277: IF (Get_oprn_details%NOTFOUND) THEN
278: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_OPRN');
279: FND_MSG_PUB.ADD;
280: CLOSE Get_oprn_details;
281: RAISE routing_creation_failure;
282: END IF;

Line 289: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');

285: IF GMDRTVAL_PUB.check_oprn(poprn_no =>l_oprn_no
286: ,poprn_vers => l_oprn_vers
287: ,prouting_start_date => l_routings_rec.effective_start_date
288: ) <> 0 THEN
289: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');
290: FND_MSG_PUB.ADD;
291: RAISE routing_creation_failure;
292: END IF;
293: END LOOP; /* loop to validate routing dates */

Line 302: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');

298:
299: /* Validation : Check if Routing class is valid */
300: IF p_routings.routing_class IS NOT NULL THEN
301: IF GMDRTVAL_PUB.check_routing_class(p_routings.routing_class) <> 0 THEN
302: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
303: FND_MSG_PUB.ADD;
304: RAISE routing_creation_failure;
305: END IF;
306: END IF;

Line 317: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');

313: IF (p_routings.Routing_class IS NOT NULL) THEN
314: OPEN Rout_cls_cur(p_routings.Routing_class);
315: FETCH Rout_cls_cur INTO l_routing_class_um;
316: IF Rout_cls_cur%NOTFOUND THEN
317: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');
318: FND_MSG_PUB.Add;
319: CLOSE Rout_cls_cur;
320: Raise routing_creation_failure;
321: END IF;

Line 350: FND_MESSAGE.SET_NAME('GMD', 'GMD_RTG_CLS_VS_RTG_UM_TYPE');

346: (prouting_class => p_routings.Routing_class,
347: pquantity => l_routing_qty_cnv);
348:
349: ELSE
350: FND_MESSAGE.SET_NAME('GMD', 'GMD_RTG_CLS_VS_RTG_UM_TYPE');
351: FND_MSG_PUB.Add;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: Raise routing_creation_failure;
354:

Line 674: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

670: ,xReturn_status => l_return_status);
671:
672: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
673: /* it indicates that this routing does'ntexists */
674: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
675: FND_MSG_PUB.ADD;
676: RAISE routing_update_failure;
677: END IF;
678: END IF;

Line 685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

681: IF l_routing_id IS NULL THEN
682: IF (l_debug = 'Y') THEN
683: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');
684: END IF;
685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
686: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
687: FND_MSG_PUB.ADD;
688: RAISE routing_update_failure;
689: END IF;

Line 686: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

682: IF (l_debug = 'Y') THEN
683: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');
684: END IF;
685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
686: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
687: FND_MSG_PUB.ADD;
688: RAISE routing_update_failure;
689: END IF;
690:

Line 720: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');

716: ( P_Entity_Type => 4,
717: P_Entity_id => l_routing_id,
718: P_Current_Status => l_cur_status,
719: P_To_Status => p_update_table(a).p_value) THEN
720: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
721: FND_MSG_PUB.ADD;
722: RAISE routing_update_failure;
723: END IF;
724: /* Validation : Check if owner_orgn_id is valid */

Line 735: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');

731: /* Validation : Check if Routing class is valid */
732: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_CLASS' THEN
733: IF p_update_table(a).p_value IS NOT NULL THEN
734: IF GMDRTVAL_PUB.check_routing_class(p_update_table(a).p_value) <> 0 THEN
735: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
736: FND_MSG_PUB.ADD;
737: RAISE routing_update_failure;
738: END IF;
739: END IF;

Line 744: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

740: /* Validation : Check if Routing uom is valid */
741: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_UOM' THEN
742: IF p_update_table(a).p_value IS NOT NULL THEN
743: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
744: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
745: FND_MSG_PUB.ADD;
746: RAISE routing_update_failure;
747: END IF;
748: END IF;

Line 754: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');

750: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'DELETE_MARK' THEN
751: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(a).p_value,
752: x_return_status => l_return_status);
753: IF l_return_status <> 'S' THEN /* it indicates that invalid value has been passed */
754: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
755: FND_MSG_PUB.ADD;
756: RAISE routing_update_failure;
757: END IF;
758: /*RLNAGARA B6997624 Check if the fixed process loss uom is valid*/

Line 762: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

758: /*RLNAGARA B6997624 Check if the fixed process loss uom is valid*/
759: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN
760: IF p_update_table(a).p_value IS NOT NULL THEN
761: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
762: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
763: FND_MSG_PUB.ADD;
764: RAISE routing_update_failure;
765: END IF;
766: END IF;

Line 778: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

774: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED
775: (Entity => 'ROUTING',
776: Entity_id => l_routing_id,
777: Update_Column_Name => p_update_table(a).p_col_to_update ) THEN
778: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
779: FND_MSG_PUB.ADD;
780: RAISE routing_update_failure;
781: END IF;
782: END LOOP;

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

936: ,xReturn_status => l_return_status);
937:
938: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
939: /* it indicates that this routing does'ntexists */
940: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
941: FND_MSG_PUB.ADD;
942: RAISE routing_delete_failure;
943: END IF;
944: END IF;

Line 952: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_USED');

948: OPEN Cur_check_rout(p_routing_id);
949: FETCH Cur_check_rout INTO l_count;
950: IF (l_count <> 0) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_USED');
953: FND_MSG_PUB.ADD;
954: RAISE routing_used;
955: END IF;
956:

Line 1105: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1101: ,xReturn_status => l_return_status);
1102:
1103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1104: /* it indicates that this routing does'ntexists */
1105: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1106: FND_MSG_PUB.ADD;
1107: RAISE routing_undelete_failure;
1108: END IF;
1109: END IF;