118: END IF;
119:
120: EXCEPTION
121: WHEN DELETE_STEP_DEP_EXCEPTION THEN
122: FND_MSG_PUB.GET( p_msg_index => 1,
123: p_data => l_message,
124: p_encoded => 'F',
125: p_msg_index_out => l_dummy);
126:
293: END IF;
294:
295: EXCEPTION
296: WHEN INSERT_STEP_DEP_EXCEPTION THEN
297: FND_MSG_PUB.GET( p_msg_index => 1,
298: p_data => l_message,
299: p_encoded => 'F',
300: p_msg_index_out => l_dummy);
301:
434: END IF;
435:
436: EXCEPTION
437: WHEN UPDATE_STEP_DEP_EXCEPTION THEN
438: FND_MSG_PUB.GET( p_msg_index => 1,
439: p_data => l_message,
440: p_encoded => 'F',
441: p_msg_index_out => l_dummy);
442:
761:
762:
763: EXCEPTION
764: WHEN UPDATE_ROUTING_EXCEPTION THEN
765: FND_MSG_PUB.GET( p_msg_index => 1,
766: p_data => l_message,
767: p_encoded => 'F',
768: p_msg_index_out => l_dummy);
769:
952: END IF;
953:
954: EXCEPTION
955: WHEN INSERT_STEP_EXCEPTION THEN
956: FND_MSG_PUB.GET( p_msg_index => 1,
957: p_data => l_message,
958: p_encoded => 'F',
959: p_msg_index_out => l_dummy);
960:
1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN UPDATE_STEP_EXCEPTION THEN
1087: FND_MSG_PUB.GET( p_msg_index => 1,
1088: p_data => l_message,
1089: p_encoded => 'F',
1090: p_msg_index_out => l_dummy);
1091:
1276: END IF;
1277:
1278: EXCEPTION
1279: WHEN INSERT_ROUTING_EXCEPTION THEN
1280: FND_MSG_PUB.GET( p_msg_index => 1,
1281: p_data => l_message,
1282: p_encoded => 'F',
1283: p_msg_index_out => l_dummy);
1284:
1335: x_return_code := 'S';
1336:
1337: IF l_status <> 'S' THEN
1338:
1339: FND_MSG_PUB.GET( p_msg_index => 1,
1340: p_data => l_message,
1341: p_encoded => 'F',
1342: p_msg_index_out => l_dummy);
1343:
1424: END IF;
1425:
1426: EXCEPTION
1427: WHEN DELETE_STEP_EXCEPTION THEN
1428: FND_MSG_PUB.GET( p_msg_index => 1,
1429: p_data => l_message,
1430: p_encoded => 'F',
1431: p_msg_index_out => l_dummy);
1432:
1980: x_msg_stack => l_msg_data,
1981: x_return_status => l_return_status);
1982:
1983: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1984: FND_MSG_PUB.GET(p_msg_index => 1,
1985: p_data => x_error_msg,
1986: p_encoded => 'F',
1987: p_msg_index_out => l_msg_index);
1988: x_return_code := 'F';
1990:
1991:
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: FND_MSG_PUB.GET(p_msg_index => 1,
1995: p_data => x_error_msg,
1996: p_encoded => 'F',
1997: p_msg_index_out => l_msg_index);
1998: x_return_code := 'F';
2047: x_return_status => l_return_status);
2048:
2049: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2050:
2051: FND_MSG_PUB.GET(p_msg_index => 1,
2052: p_data => x_error_msg,
2053: p_encoded => 'F',
2054: p_msg_index_out => l_msg_index);
2055:
2059: END IF;
2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: FND_MSG_PUB.GET(p_msg_index => 1,
2064: p_data => x_error_msg,
2065: p_encoded => 'F',
2066: p_msg_index_out => l_msg_index);
2067: x_return_code := 'F';
2116: END IF;
2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: FND_MSG_PUB.GET(p_msg_index => 1,
2121: p_data => x_error_msg,
2122: p_encoded => 'F',
2123: p_msg_index_out => l_msg_index);
2124: x_return_code := 'F';
2316: COMMIT;
2317:
2318: EXCEPTION
2319: WHEN DELETE_ROUTING_EXCEPTION THEN
2320: FND_MSG_PUB.GET( p_msg_index => 1,
2321: p_data => l_message,
2322: p_encoded => 'F',
2323: p_msg_index_out => l_dummy);
2324:
2413: COMMIT;
2414:
2415: EXCEPTION
2416: WHEN UNDELETE_ROUTING_EXCEPTION THEN
2417: FND_MSG_PUB.GET( p_msg_index => 1,
2418: p_data => l_message,
2419: p_encoded => 'F',
2420: p_msg_index_out => l_dummy);
2421: