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 129: fnd_msg_pub.initialize;

125:
126:
127: /* Initialize message list and count if needed */
128: IF p_init_msg_list THEN
129: fnd_msg_pub.initialize;
130: END IF;
131:
132: IF (l_debug = 'Y') THEN
133: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');

Line 159: FND_MSG_PUB.ADD;

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:
163: IF p_routings.routing_vers IS NULL THEN

Line 169: FND_MSG_PUB.ADD;

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
173: FND_MESSAGE.SET_NAME ('GMD', 'GMD_NEGATIVE_FIELDS');

Line 174: 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;
178:

Line 185: FND_MSG_PUB.ADD;

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:
189: /* routing_uom must be passed, otherwise give error */

Line 196: FND_MSG_PUB.ADD;

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

Line 204: FND_MSG_PUB.ADD;

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:
208: /*

Line 216: FND_MSG_PUB.Add;

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:
220: -- Check if the responsibility has access to the organization

Line 229: FND_MSG_PUB.Add;

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:
233: /* Validation : Validate if the Routing start and end dates */

Line 244: FND_MSG_PUB.ADD;

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;
248:

Line 259: FND_MSG_PUB.ADD;

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;
263: FETCH Get_routing_id_seq INTO l_routing_id;

Line 266: FND_MSG_PUB.ADD;

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;
270: END IF; /* l_return_status <> 'E' */

Line 279: FND_MSG_PUB.ADD;

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;
283: CLOSE Get_oprn_details;

Line 290: FND_MSG_PUB.ADD;

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 */
294:

Line 303: FND_MSG_PUB.ADD;

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;
307:

Line 318: FND_MSG_PUB.Add;

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;
322: CLOSE Rout_cls_cur;

Line 351: FND_MSG_PUB.Add;

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:
355: END IF; /* IF l_routing_um_class = l_routing_class_um_class */

Line 521: fnd_msg_pub.count_and_get (

517: END IF; --l_entity_status <> 100
518: COMMIT;
519: END IF; --P_commit
520:
521: fnd_msg_pub.count_and_get (
522: p_count => x_message_count
523: ,p_encoded => FND_API.g_false
524: ,p_data => x_message_list);
525:

Line 543: fnd_msg_pub.count_and_get (

539: WHEN routing_creation_failure OR invalid_version THEN
540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
542: END IF;
543: fnd_msg_pub.count_and_get (
544: p_count => x_message_count
545: ,p_encoded => FND_API.g_false
546: ,p_data => x_message_list);
547: x_return_status := FND_API.G_RET_STS_ERROR;

Line 552: fnd_msg_pub.count_and_get (

548: ROLLBACK TO SAVEPOINT create_routing;
549: WHEN setup_failure THEN
550: ROLLBACK TO SAVEPOINT create_routing;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: fnd_msg_pub.count_and_get (
553: p_count => x_message_count
554: ,p_encoded => FND_API.g_false
555: ,p_data => x_message_list);
556: WHEN default_status_err THEN

Line 559: fnd_msg_pub.count_and_get (

555: ,p_data => x_message_list);
556: WHEN default_status_err THEN
557: ROLLBACK TO default_status_sp;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: fnd_msg_pub.count_and_get (
560: p_count => x_message_count
561: ,p_encoded => FND_API.g_false
562: ,p_data => x_message_list);
563: WHEN OTHERS THEN

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

562: ,p_data => x_message_list);
563: WHEN OTHERS THEN
564: ROLLBACK TO SAVEPOINT create_routing;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
567: IF (l_debug = 'Y') THEN
568: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
569: END IF;
570: fnd_msg_pub.count_and_get (

Line 570: fnd_msg_pub.count_and_get (

566: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
567: IF (l_debug = 'Y') THEN
568: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
569: END IF;
570: fnd_msg_pub.count_and_get (
571: p_count => x_message_count
572: ,p_encoded => FND_API.g_false
573: ,p_data => x_message_list);
574: END insert_routing;

Line 637: fnd_msg_pub.initialize;

633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: /* Initialize message list and count if needed */
636: IF p_init_msg_list THEN
637: fnd_msg_pub.initialize;
638: END IF;
639:
640: IF (l_debug = 'Y') THEN
641: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

Line 675: FND_MSG_PUB.ADD;

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;
679:

Line 687: FND_MSG_PUB.ADD;

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:
691: /* Routing Security fix */

Line 721: FND_MSG_PUB.ADD;

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 */
725: /* Routing Security fix */

Line 736: FND_MSG_PUB.ADD;

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;
740: /* Validation : Check if Routing uom is valid */

Line 745: FND_MSG_PUB.ADD;

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;
749: /* Validation: delete_mark validation */

Line 755: FND_MSG_PUB.ADD;

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*/
759: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN

Line 763: FND_MSG_PUB.ADD;

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;
767: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'OWNER_ID' THEN

Line 779: FND_MSG_PUB.ADD;

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;
783:

Line 798: fnd_msg_pub.count_and_get (

794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
795: RAISE routing_update_failure;
796: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
797:
798: fnd_msg_pub.count_and_get (
799: p_count => x_message_count
800: ,p_encoded => FND_API.g_false
801: ,p_data => x_message_list);
802:

Line 825: fnd_msg_pub.count_and_get (

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF (l_debug = 'Y') THEN
823: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
824: END IF;
825: fnd_msg_pub.count_and_get (
826: p_count => x_message_count
827: ,p_encoded => FND_API.g_false
828: ,p_data => x_message_list);
829: WHEN setup_failure THEN

Line 832: fnd_msg_pub.count_and_get (

828: ,p_data => x_message_list);
829: WHEN setup_failure THEN
830: ROLLBACK TO SAVEPOINT update_routing;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: fnd_msg_pub.count_and_get (
833: p_count => x_message_count
834: ,p_encoded => FND_API.g_false
835: ,p_data => x_message_list);
836: WHEN OTHERS THEN

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

835: ,p_data => x_message_list);
836: WHEN OTHERS THEN
837: ROLLBACK TO SAVEPOINT update_routing;
838: x_return_status := FND_API.g_ret_sts_unexp_error;
839: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
840: IF (l_debug = 'Y') THEN
841: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
842: END IF;
843: fnd_msg_pub.count_and_get (

Line 843: fnd_msg_pub.count_and_get (

839: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
840: IF (l_debug = 'Y') THEN
841: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
842: END IF;
843: fnd_msg_pub.count_and_get (
844: p_count => x_message_count
845: ,p_encoded => FND_API.g_false
846: ,p_data => x_message_list);
847: END update_routing;

Line 907: fnd_msg_pub.initialize;

903: x_return_status := FND_API.G_RET_STS_SUCCESS;
904:
905: /* Initialize message list and count if needed */
906: IF p_init_msg_list THEN
907: fnd_msg_pub.initialize;
908: END IF;
909:
910: /* Intialize the setup fields */
911: IF NOT gmd_api_grp.setup_done THEN

Line 941: FND_MSG_PUB.ADD;

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;
945:

Line 953: FND_MSG_PUB.ADD;

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:
957: l_update_table(1).P_COL_TO_UPDATE := 'DELETE_MARK';

Line 974: fnd_msg_pub.count_and_get (

970: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
971: RAISE routing_delete_failure;
972: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
973:
974: fnd_msg_pub.count_and_get (
975: p_count => x_message_count
976: ,p_encoded => FND_API.g_false
977: ,p_data => x_message_list);
978:

Line 1001: fnd_msg_pub.count_and_get (

997: x_return_status := FND_API.G_RET_STS_ERROR;
998: IF (l_debug = 'Y') THEN
999: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1000: END IF;
1001: fnd_msg_pub.count_and_get (
1002: p_count => x_message_count
1003: ,p_encoded => FND_API.g_false
1004: ,p_data => x_message_list);
1005: WHEN setup_failure THEN

Line 1008: fnd_msg_pub.count_and_get (

1004: ,p_data => x_message_list);
1005: WHEN setup_failure THEN
1006: ROLLBACK TO SAVEPOINT delete_routing;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: fnd_msg_pub.count_and_get (
1009: p_count => x_message_count
1010: ,p_encoded => FND_API.g_false
1011: ,p_data => x_message_list);
1012: WHEN OTHERS THEN

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

1011: ,p_data => x_message_list);
1012: WHEN OTHERS THEN
1013: ROLLBACK TO SAVEPOINT delete_routing;
1014: x_return_status := FND_API.g_ret_sts_unexp_error;
1015: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1016: IF (l_debug = 'Y') THEN
1017: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1018: END IF;
1019: fnd_msg_pub.count_and_get (

Line 1019: fnd_msg_pub.count_and_get (

1015: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1016: IF (l_debug = 'Y') THEN
1017: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1018: END IF;
1019: fnd_msg_pub.count_and_get (
1020: p_count => x_message_count
1021: ,p_encoded => FND_API.g_false
1022: ,p_data => x_message_list);
1023: END delete_routing;

Line 1072: fnd_msg_pub.initialize;

1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069:
1070: /* Initialize message list and count if needed */
1071: IF p_init_msg_list THEN
1072: fnd_msg_pub.initialize;
1073: END IF;
1074:
1075: /* Intialize the setup fields */
1076: IF NOT gmd_api_grp.setup_done THEN

Line 1106: FND_MSG_PUB.ADD;

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;
1110:

Line 1115: fnd_msg_pub.count_and_get (

1111: UPDATE gmd_routings_b
1112: SET delete_mark = 0
1113: WHERE routing_id = l_routing_id;
1114:
1115: fnd_msg_pub.count_and_get (
1116: p_count => x_message_count
1117: ,p_encoded => FND_API.g_false
1118: ,p_data => x_message_list);
1119:

Line 1142: fnd_msg_pub.count_and_get (

1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: IF (l_debug = 'Y') THEN
1140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1141: END IF;
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 1149: fnd_msg_pub.count_and_get (

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

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

1152: ,p_data => x_message_list);
1153: WHEN OTHERS THEN
1154: ROLLBACK TO SAVEPOINT undelete_routing;
1155: x_return_status := FND_API.g_ret_sts_unexp_error;
1156: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1157: IF (l_debug = 'Y') THEN
1158: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1159: END IF;
1160: fnd_msg_pub.count_and_get (

Line 1160: fnd_msg_pub.count_and_get (

1156: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1157: IF (l_debug = 'Y') THEN
1158: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1159: END IF;
1160: fnd_msg_pub.count_and_get (
1161: p_count => x_message_count
1162: ,p_encoded => FND_API.g_false
1163: ,p_data => x_message_list);
1164: END undelete_routing;