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_MSG_PUB

Line 140: fnd_msg_pub.initialize;

136:
137:
138: /* Initialize message list and count if needed */
139: IF p_init_msg_list THEN
140: fnd_msg_pub.initialize;
141: END IF;
142:
143: IF (l_debug = 'Y') THEN
144: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');

Line 170: FND_MSG_PUB.ADD;

166: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');
167: END IF;
168: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
169: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');
170: FND_MSG_PUB.ADD;
171: RAISE routing_creation_failure;
172: END IF;
173:
174: IF p_routings.routing_vers IS NULL THEN

Line 180: FND_MSG_PUB.ADD;

176: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Version required');
177: END IF;
178: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
179: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_VERS');
180: FND_MSG_PUB.ADD;
181: RAISE routing_creation_failure;
182: ELSIF p_routings.routing_vers IS NOT NULL THEN
183: IF (p_routings.routing_vers < 0 ) THEN
184: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 185: FND_MSG_PUB.ADD;

181: RAISE routing_creation_failure;
182: ELSIF p_routings.routing_vers IS NOT NULL THEN
183: IF (p_routings.routing_vers < 0 ) THEN
184: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');
185: FND_MSG_PUB.ADD;
186: RAISE routing_creation_failure;
187: END IF;
188: END IF;
189:

Line 196: FND_MSG_PUB.ADD;

192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');
193: END IF;
194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');
196: FND_MSG_PUB.ADD;
197: RAISE routing_creation_failure;
198: END IF;
199:
200: /* routing_uom must be passed, otherwise give error */

Line 207: FND_MSG_PUB.ADD;

203: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');
204: END IF;
205: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
206: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
207: FND_MSG_PUB.ADD;
208: RAISE routing_creation_failure;
209: /* call common function to check if um passed is valid */
210: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
211: IF (l_debug = 'Y') THEN

Line 215: FND_MSG_PUB.ADD;

211: IF (l_debug = 'Y') THEN
212: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
213: END IF;
214: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
215: FND_MSG_PUB.ADD;
216: RAISE routing_creation_failure;
217: END IF;
218:
219: /*

Line 227: FND_MSG_PUB.Add;

223:
224: --Check that organization id is not null if raise an error message
225: IF (p_routings.owner_organization_id IS NULL) THEN
226: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
227: FND_MSG_PUB.Add;
228: RAISE routing_creation_failure;
229: END IF;
230:
231: -- Check if the responsibility has access to the organization

Line 240: FND_MSG_PUB.Add;

236: --Check the organization id passed is process enabled if not raise an error message
237: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN
238: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
239: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);
240: FND_MSG_PUB.Add;
241: RAISE routing_creation_failure;
242: END IF;
243:
244: /* Validation : Validate if the Routing start and end dates */

Line 255: FND_MSG_PUB.ADD;

251: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
252: ||'effective start date must be less then end date');
253: END IF;
254: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
255: FND_MSG_PUB.ADD;
256: RAISE routing_creation_failure;
257: END IF;
258: END IF;
259:

Line 270: FND_MSG_PUB.ADD;

266: ,xReturn_status => l_return_status);
267:
268: IF l_return_status <> 'E' THEN /* it indicates that this routing exists */
269: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_DUPLICATION');
270: FND_MSG_PUB.ADD;
271: RAISE routing_creation_failure;
272: ELSE
273: OPEN Get_routing_id_seq;
274: FETCH Get_routing_id_seq INTO l_routing_id;

Line 277: FND_MSG_PUB.ADD;

273: OPEN Get_routing_id_seq;
274: FETCH Get_routing_id_seq INTO l_routing_id;
275: IF Get_routing_id_seq%NOTFOUND then
276: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_SEQ');
277: FND_MSG_PUB.ADD;
278: RAISE routing_creation_failure;
279: END IF;
280: CLOSE Get_routing_id_seq;
281: END IF; /* l_return_status <> 'E' */

Line 290: FND_MSG_PUB.ADD;

286: OPEN Get_oprn_details(p_routings_step_tbl(b).oprn_id);
287: FETCH Get_oprn_details INTO l_oprn_no, l_oprn_vers;
288: IF (Get_oprn_details%NOTFOUND) THEN
289: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_OPRN');
290: FND_MSG_PUB.ADD;
291: CLOSE Get_oprn_details;
292: RAISE routing_creation_failure;
293: END IF;
294: CLOSE Get_oprn_details;

Line 304: FND_MSG_PUB.ADD;

300: ,prouting_start_date => l_routings_rec.effective_start_date
301: ,prouting_end_date => l_routings_rec.effective_end_date
302: ) <> 0 THEN
303: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');
304: FND_MSG_PUB.ADD;
305: RAISE routing_creation_failure;
306: END IF;
307: END LOOP; /* loop to validate routing dates */
308: -- rnalla Bug 9314021 add the new cusror to check for valid user id

Line 314: FND_MSG_PUB.Add;

310: OPEN Cur_user_id(p_routings.owner_id);
311: FETCH Cur_user_id INTO l_temp;
312: IF Cur_user_id%NOTFOUND THEN
313: FND_MESSAGE.SET_NAME('GMD', 'QC_INVALID_USER');
314: FND_MSG_PUB.Add;
315: CLOSE Cur_user_id;
316: Raise routing_creation_failure;
317: END IF;
318: CLOSE Cur_user_id;

Line 328: FND_MSG_PUB.ADD;

324: /* Validation : Check if Routing class is valid */
325: IF p_routings.routing_class IS NOT NULL THEN
326: IF GMDRTVAL_PUB.check_routing_class(p_routings.routing_class) <> 0 THEN
327: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
328: FND_MSG_PUB.ADD;
329: RAISE routing_creation_failure;
330: END IF;
331: END IF;
332:

Line 343: FND_MSG_PUB.Add;

339: OPEN Rout_cls_cur(p_routings.Routing_class);
340: FETCH Rout_cls_cur INTO l_routing_class_um;
341: IF Rout_cls_cur%NOTFOUND THEN
342: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');
343: FND_MSG_PUB.Add;
344: CLOSE Rout_cls_cur;
345: Raise routing_creation_failure;
346: END IF;
347: CLOSE Rout_cls_cur;

Line 376: FND_MSG_PUB.Add;

372: pquantity => l_routing_qty_cnv);
373:
374: ELSE
375: FND_MESSAGE.SET_NAME('GMD', 'GMD_RTG_CLS_VS_RTG_UM_TYPE');
376: FND_MSG_PUB.Add;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: Raise routing_creation_failure;
379:
380: END IF; /* IF l_routing_um_class = l_routing_class_um_class */

Line 546: fnd_msg_pub.count_and_get (

542: END IF; --l_entity_status <> 100
543: COMMIT;
544: END IF; --P_commit
545:
546: fnd_msg_pub.count_and_get (
547: p_count => x_message_count
548: ,p_encoded => FND_API.g_false
549: ,p_data => x_message_list);
550:

Line 568: fnd_msg_pub.count_and_get (

564: WHEN routing_creation_failure OR invalid_version THEN
565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
567: END IF;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false
571: ,p_data => x_message_list);
572: x_return_status := FND_API.G_RET_STS_ERROR;

Line 577: fnd_msg_pub.count_and_get (

573: ROLLBACK TO SAVEPOINT create_routing;
574: WHEN setup_failure THEN
575: ROLLBACK TO SAVEPOINT create_routing;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_msg_pub.count_and_get (
578: p_count => x_message_count
579: ,p_encoded => FND_API.g_false
580: ,p_data => x_message_list);
581: WHEN default_status_err THEN

Line 584: fnd_msg_pub.count_and_get (

580: ,p_data => x_message_list);
581: WHEN default_status_err THEN
582: ROLLBACK TO default_status_sp;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: fnd_msg_pub.count_and_get (
585: p_count => x_message_count
586: ,p_encoded => FND_API.g_false
587: ,p_data => x_message_list);
588: WHEN OTHERS THEN

Line 591: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

587: ,p_data => x_message_list);
588: WHEN OTHERS THEN
589: ROLLBACK TO SAVEPOINT create_routing;
590: x_return_status := FND_API.g_ret_sts_unexp_error;
591: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
592: IF (l_debug = 'Y') THEN
593: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
594: END IF;
595: fnd_msg_pub.count_and_get (

Line 595: fnd_msg_pub.count_and_get (

591: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
592: IF (l_debug = 'Y') THEN
593: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
594: END IF;
595: fnd_msg_pub.count_and_get (
596: p_count => x_message_count
597: ,p_encoded => FND_API.g_false
598: ,p_data => x_message_list);
599: END insert_routing;

Line 673: fnd_msg_pub.initialize;

669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: /* Initialize message list and count if needed */
672: IF p_init_msg_list THEN
673: fnd_msg_pub.initialize;
674: END IF;
675:
676: IF (l_debug = 'Y') THEN
677: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

Line 711: FND_MSG_PUB.ADD;

707:
708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
709: /* it indicates that this routing does'ntexists */
710: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
711: FND_MSG_PUB.ADD;
712: RAISE routing_update_failure;
713: END IF;
714: END IF;
715:

Line 723: FND_MSG_PUB.ADD;

719: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');
720: END IF;
721: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
722: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
723: FND_MSG_PUB.ADD;
724: RAISE routing_update_failure;
725: END IF;
726:
727: /* Routing Security fix */

Line 757: FND_MSG_PUB.ADD;

753: P_Entity_id => l_routing_id,
754: P_Current_Status => l_cur_status,
755: P_To_Status => p_update_table(a).p_value) THEN
756: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
757: FND_MSG_PUB.ADD;
758: RAISE routing_update_failure;
759: END IF;
760: /* Validation : Check if owner_orgn_id is valid */
761: /* Routing Security fix */

Line 772: FND_MSG_PUB.ADD;

768: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_CLASS' THEN
769: IF p_update_table(a).p_value IS NOT NULL THEN
770: IF GMDRTVAL_PUB.check_routing_class(p_update_table(a).p_value) <> 0 THEN
771: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
772: FND_MSG_PUB.ADD;
773: RAISE routing_update_failure;
774: END IF;
775: END IF;
776: /* Validation : Check if Routing uom is valid */

Line 781: FND_MSG_PUB.ADD;

777: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_UOM' THEN
778: IF p_update_table(a).p_value IS NOT NULL THEN
779: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
780: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
781: FND_MSG_PUB.ADD;
782: RAISE routing_update_failure;
783: END IF;
784: END IF;
785: /* Validation: delete_mark validation */

Line 791: FND_MSG_PUB.ADD;

787: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(a).p_value,
788: x_return_status => l_return_status);
789: IF l_return_status <> 'S' THEN /* it indicates that invalid value has been passed */
790: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
791: FND_MSG_PUB.ADD;
792: RAISE routing_update_failure;
793: END IF;
794: /*RLNAGARA B6997624 Check if the fixed process loss uom is valid*/
795: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN

Line 799: FND_MSG_PUB.ADD;

795: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN
796: IF p_update_table(a).p_value IS NOT NULL THEN
797: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
798: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
799: FND_MSG_PUB.ADD;
800: RAISE routing_update_failure;
801: END IF;
802: END IF;
803: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'OWNER_ID' THEN

Line 810: FND_MSG_PUB.Add;

806: OPEN Cur_user_id(p_update_table(a).p_value);
807: FETCH Cur_user_id INTO l_temp;
808: IF Cur_user_id%NOTFOUND THEN
809: FND_MESSAGE.SET_NAME('GMD', 'QC_INVALID_USER');
810: FND_MSG_PUB.Add;
811: CLOSE Cur_user_id;
812: Raise routing_update_failure;
813: END IF;
814: CLOSE Cur_user_id;

Line 826: FND_MSG_PUB.ADD;

822: (Entity => 'ROUTING',
823: Entity_id => l_routing_id,
824: Update_Column_Name => p_update_table(a).p_col_to_update ) THEN
825: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
826: FND_MSG_PUB.ADD;
827: RAISE routing_update_failure;
828: END IF;
829: END LOOP;
830:

Line 845: fnd_msg_pub.count_and_get (

841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE routing_update_failure;
843: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
844:
845: fnd_msg_pub.count_and_get (
846: p_count => x_message_count
847: ,p_encoded => FND_API.g_false
848: ,p_data => x_message_list);
849:

Line 872: fnd_msg_pub.count_and_get (

868: x_return_status := FND_API.G_RET_STS_ERROR;
869: IF (l_debug = 'Y') THEN
870: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
871: END IF;
872: fnd_msg_pub.count_and_get (
873: p_count => x_message_count
874: ,p_encoded => FND_API.g_false
875: ,p_data => x_message_list);
876: WHEN setup_failure THEN

Line 879: fnd_msg_pub.count_and_get (

875: ,p_data => x_message_list);
876: WHEN setup_failure THEN
877: ROLLBACK TO SAVEPOINT update_routing;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: fnd_msg_pub.count_and_get (
880: p_count => x_message_count
881: ,p_encoded => FND_API.g_false
882: ,p_data => x_message_list);
883: WHEN OTHERS THEN

Line 886: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

882: ,p_data => x_message_list);
883: WHEN OTHERS THEN
884: ROLLBACK TO SAVEPOINT update_routing;
885: x_return_status := FND_API.g_ret_sts_unexp_error;
886: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
887: IF (l_debug = 'Y') THEN
888: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
889: END IF;
890: fnd_msg_pub.count_and_get (

Line 890: fnd_msg_pub.count_and_get (

886: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
887: IF (l_debug = 'Y') THEN
888: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
889: END IF;
890: fnd_msg_pub.count_and_get (
891: p_count => x_message_count
892: ,p_encoded => FND_API.g_false
893: ,p_data => x_message_list);
894: END update_routing;

Line 954: fnd_msg_pub.initialize;

950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: /* Initialize message list and count if needed */
953: IF p_init_msg_list THEN
954: fnd_msg_pub.initialize;
955: END IF;
956:
957: /* Intialize the setup fields */
958: IF NOT gmd_api_grp.setup_done THEN

Line 988: FND_MSG_PUB.ADD;

984:
985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
986: /* it indicates that this routing does'ntexists */
987: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
988: FND_MSG_PUB.ADD;
989: RAISE routing_delete_failure;
990: END IF;
991: END IF;
992:

Line 1000: FND_MSG_PUB.ADD;

996: FETCH Cur_check_rout INTO l_count;
997: IF (l_count <> 0) THEN
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_USED');
1000: FND_MSG_PUB.ADD;
1001: RAISE routing_used;
1002: END IF;
1003:
1004: l_update_table(1).P_COL_TO_UPDATE := 'DELETE_MARK';

Line 1021: fnd_msg_pub.count_and_get (

1017: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1018: RAISE routing_delete_failure;
1019: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1020:
1021: fnd_msg_pub.count_and_get (
1022: p_count => x_message_count
1023: ,p_encoded => FND_API.g_false
1024: ,p_data => x_message_list);
1025:

Line 1048: fnd_msg_pub.count_and_get (

1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: IF (l_debug = 'Y') THEN
1046: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1047: END IF;
1048: fnd_msg_pub.count_and_get (
1049: p_count => x_message_count
1050: ,p_encoded => FND_API.g_false
1051: ,p_data => x_message_list);
1052: WHEN setup_failure THEN

Line 1055: fnd_msg_pub.count_and_get (

1051: ,p_data => x_message_list);
1052: WHEN setup_failure THEN
1053: ROLLBACK TO SAVEPOINT delete_routing;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: fnd_msg_pub.count_and_get (
1056: p_count => x_message_count
1057: ,p_encoded => FND_API.g_false
1058: ,p_data => x_message_list);
1059: WHEN OTHERS THEN

Line 1062: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

1058: ,p_data => x_message_list);
1059: WHEN OTHERS THEN
1060: ROLLBACK TO SAVEPOINT delete_routing;
1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1063: IF (l_debug = 'Y') THEN
1064: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1065: END IF;
1066: fnd_msg_pub.count_and_get (

Line 1066: fnd_msg_pub.count_and_get (

1062: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1063: IF (l_debug = 'Y') THEN
1064: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1065: END IF;
1066: fnd_msg_pub.count_and_get (
1067: p_count => x_message_count
1068: ,p_encoded => FND_API.g_false
1069: ,p_data => x_message_list);
1070: END delete_routing;

Line 1119: fnd_msg_pub.initialize;

1115: x_return_status := FND_API.G_RET_STS_SUCCESS;
1116:
1117: /* Initialize message list and count if needed */
1118: IF p_init_msg_list THEN
1119: fnd_msg_pub.initialize;
1120: END IF;
1121:
1122: /* Intialize the setup fields */
1123: IF NOT gmd_api_grp.setup_done THEN

Line 1153: FND_MSG_PUB.ADD;

1149:
1150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1151: /* it indicates that this routing does'ntexists */
1152: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1153: FND_MSG_PUB.ADD;
1154: RAISE routing_undelete_failure;
1155: END IF;
1156: END IF;
1157:

Line 1162: fnd_msg_pub.count_and_get (

1158: UPDATE gmd_routings_b
1159: SET delete_mark = 0
1160: WHERE routing_id = l_routing_id;
1161:
1162: fnd_msg_pub.count_and_get (
1163: p_count => x_message_count
1164: ,p_encoded => FND_API.g_false
1165: ,p_data => x_message_list);
1166:

Line 1189: fnd_msg_pub.count_and_get (

1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: IF (l_debug = 'Y') THEN
1187: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1188: END IF;
1189: fnd_msg_pub.count_and_get (
1190: p_count => x_message_count
1191: ,p_encoded => FND_API.g_false
1192: ,p_data => x_message_list);
1193: WHEN setup_failure THEN

Line 1196: fnd_msg_pub.count_and_get (

1192: ,p_data => x_message_list);
1193: WHEN setup_failure THEN
1194: ROLLBACK TO SAVEPOINT undelete_routing;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: fnd_msg_pub.count_and_get (
1197: p_count => x_message_count
1198: ,p_encoded => FND_API.g_false
1199: ,p_data => x_message_list);
1200: WHEN OTHERS THEN

Line 1203: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

1199: ,p_data => x_message_list);
1200: WHEN OTHERS THEN
1201: ROLLBACK TO SAVEPOINT undelete_routing;
1202: x_return_status := FND_API.g_ret_sts_unexp_error;
1203: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1204: IF (l_debug = 'Y') THEN
1205: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1206: END IF;
1207: fnd_msg_pub.count_and_get (

Line 1207: fnd_msg_pub.count_and_get (

1203: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1204: IF (l_debug = 'Y') THEN
1205: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1206: END IF;
1207: fnd_msg_pub.count_and_get (
1208: p_count => x_message_count
1209: ,p_encoded => FND_API.g_false
1210: ,p_data => x_message_list);
1211: END undelete_routing;