DBA Data[Home] [Help]

APPS.GMD_ROUTING_DESIGNER_PKG dependencies on FND_API

Line 116: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

112: , x_message_count => l_message_count
113: , x_message_list => l_message_list
114: , x_return_status => l_return_status);
115:
116: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: RAISE DELETE_STEP_DEP_EXCEPTION;
118: END IF;
119:
120: EXCEPTION

Line 291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

287: , x_message_count => l_message_count
288: , x_message_list => l_message_list
289: , x_return_status => l_return_status);
290:
291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
292: RAISE INSERT_STEP_DEP_EXCEPTION;
293: END IF;
294:
295: EXCEPTION

Line 432: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

428: , x_message_list => l_message_list
429: , x_return_status => l_return_status);
430:
431:
432: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
433: RAISE UPDATE_STEP_DEP_EXCEPTION;
434: END IF;
435:
436: EXCEPTION

Line 631: x_return_code := FND_API.G_RET_STS_SUCCESS;

627:
628: BEGIN
629:
630: x_error_msg := '';
631: x_return_code := FND_API.G_RET_STS_SUCCESS;
632:
633:
634: OPEN Cur_get_routing;
635: FETCH Cur_get_routing INTO l_rec;

Line 709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

705: , x_message_count => l_message_count
706: , x_message_list => l_message_list
707: , x_return_status => l_return_status);
708:
709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
710: RAISE UPDATE_ROUTING_EXCEPTION;
711: END IF;
712:
713: --- If routing number and/or version have changed, we need to update them. This

Line 914: x_return_code := FND_API.G_RET_STS_SUCCESS;

910:
911: BEGIN
912:
913: x_error_msg := '';
914: x_return_code := FND_API.G_RET_STS_SUCCESS;
915:
916: IF p_text_code <= 0 THEN
917: l_text_code := NULL;
918: ELSE

Line 950: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

946: , x_message_count => l_message_count
947: , x_message_list => l_message_list
948: , x_return_status => l_return_status);
949:
950: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
951: RAISE INSERT_STEP_EXCEPTION;
952: END IF;
953:
954: EXCEPTION

Line 1031: x_return_code := FND_API.G_RET_STS_SUCCESS;

1027:
1028: BEGIN
1029:
1030: x_error_msg := '';
1031: x_return_code := FND_API.G_RET_STS_SUCCESS;
1032:
1033:
1034: IF p_text_code <= 0 THEN
1035: l_text_code := NULL;

Line 1081: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1077: , x_message_count => l_message_count
1078: , x_message_list => l_message_list
1079: , x_return_status => l_return_status);
1080:
1081: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1082: RAISE UPDATE_STEP_EXCEPTION;
1083: END IF;
1084:
1085: EXCEPTION

Line 1182: x_return_code := FND_API.G_RET_STS_SUCCESS;

1178: l_dummy NUMBER;
1179:
1180: BEGIN
1181:
1182: x_return_code := FND_API.G_RET_STS_SUCCESS;
1183: x_error_msg := FND_MESSAGE.GET;
1184: OPEN Cur_routing_id;
1185: FETCH Cur_routing_id INTO x_routing_id;
1186: CLOSE Cur_routing_id;

Line 1274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1270: , x_message_count => l_message_count
1271: , x_message_list => l_message_list
1272: , x_return_status => l_return_status);
1273:
1274: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1275: RAISE INSERT_ROUTING_EXCEPTION;
1276: END IF;
1277:
1278: EXCEPTION

Line 1422: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1418: , x_message_count => l_message_count
1419: , x_message_list => l_message_list
1420: , x_return_status => l_return_status);
1421:
1422: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1423: RAISE DELETE_STEP_EXCEPTION;
1424: END IF;
1425:
1426: EXCEPTION

Line 1536: x_return_code := FND_API.G_RET_STS_SUCCESS;

1532:
1533: BEGIN
1534:
1535: x_error_msg := '';
1536: x_return_code := FND_API.G_RET_STS_SUCCESS;
1537:
1538: -- Load routing header
1539: OPEN Cur_get_hdr;
1540: FETCH Cur_get_hdr INTO X_hdr_rec;

Line 1983: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1979: x_msg_count => l_msg_count,
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);

Line 2049: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2045: x_msg_count => l_msg_count,
2046: x_msg_stack => l_msg_data,
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',

Line 2114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2110: x_msg_count => l_msg_count,
2111: x_msg_stack => l_msg_data,
2112: x_return_status => l_return_status);
2113:
2114: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2115: RAISE UNEXPECTED_ERROR;
2116: END IF;
2117:
2118: EXCEPTION

Line 2287: x_return_code := FND_API.G_RET_STS_SUCCESS;

2283:
2284: BEGIN
2285:
2286: x_error_msg := '';
2287: x_return_code := FND_API.G_RET_STS_SUCCESS;
2288:
2289:
2290: OPEN Cur_get_routing;
2291: FETCH Cur_get_routing INTO l_rec;

Line 2311: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2307: , x_message_count => l_message_count
2308: , x_message_list => l_message_list
2309: , x_return_status => l_return_status);
2310:
2311: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2312: RAISE DELETE_ROUTING_EXCEPTION;
2313: END IF;
2314:
2315: --- This should be removed when the API does the commit

Line 2386: x_return_code := FND_API.G_RET_STS_SUCCESS;

2382:
2383: BEGIN
2384:
2385: x_error_msg := '';
2386: x_return_code := FND_API.G_RET_STS_SUCCESS;
2387:
2388: OPEN Cur_get_routing;
2389: FETCH Cur_get_routing INTO l_rec;
2390:

Line 2408: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2404: , x_message_count => l_message_count
2405: , x_message_list => l_message_list
2406: , x_return_status => l_return_status);
2407:
2408: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2409: RAISE UNDELETE_ROUTING_EXCEPTION;
2410: END IF;
2411:
2412: --- This should be removed when the API does the commit

Line 2488: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;

2484: END IF;
2485:
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: x_return_code := FND_API.G_RET_STS_UNEXP_ERROR;
2489:
2490: END CHECK_ROUT_ORGN_ACCESS;
2491:
2492: