DBA Data[Home] [Help]

APPS.GMDRTVAL_PUB dependencies on FND_API

Line 280: xReturn_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
279: FND_MSG_PUB.ADD;
280: xReturn_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: END check_routing;
282:
283:
284:

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: END IF;
551: /* Bug 2454861 - Thomas Daniel */
552: /* Added the closing of the open cursor */
553: CLOSE Cur_get_routing_steps;
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: EXCEPTION
556: WHEN missing_details THEN
557: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DETAILS_MISSING');
558: FND_MSG_PUB.ADD;

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: EXCEPTION
556: WHEN missing_details THEN
557: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DETAILS_MISSING');
558: FND_MSG_PUB.ADD;
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN INSERT_FAILURE THEN
561: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
562: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
563: FND_MSG_PUB.ADD;

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: WHEN INSERT_FAILURE THEN
561: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
562: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
563: FND_MSG_PUB.ADD;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
567: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
568: FND_MSG_PUB.ADD;

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: WHEN OTHERS THEN
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
567: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
568: FND_MSG_PUB.ADD;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: END generate_step_dependencies;
571:
572:
573: /*====================================================================== */

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: END IF;
670: /* Bug 2454861 - Thomas Daniel */
671: /* Added the closing of the open cursor */
672: CLOSE Cur_get_routing_steps;
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674: EXCEPTION
675: WHEN missing_details THEN
676: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DETAILS_MISSING');
677: FND_MSG_PUB.ADD;

Line 678: x_return_status := FND_API.G_RET_STS_ERROR;

674: EXCEPTION
675: WHEN missing_details THEN
676: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DETAILS_MISSING');
677: FND_MSG_PUB.ADD;
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: WHEN INSERT_FAILURE THEN
680: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
681: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
682: FND_MSG_PUB.ADD;

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: WHEN INSERT_FAILURE THEN
680: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
681: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
682: FND_MSG_PUB.ADD;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
686: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
687: FND_MSG_PUB.ADD;

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
686: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
687: FND_MSG_PUB.ADD;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: END generate_step_dependencies;
690:
691:
692: /* ================================================= */

Line 728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: WHEN OTHERS THEN
725: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
726: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
727: FND_MSG_PUB.ADD;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:
730: END Get_process_loss_max_qtys;
731:
732: /* =================================================== */

Line 769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

765: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
766: P_data => x_msg_stack);
767: EXCEPTION
768: WHEN OTHERS THEN
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
771: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
772: FND_MSG_PUB.ADD;
773: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

812: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
813: P_data => x_msg_stack);
814: EXCEPTION
815: WHEN OTHERS THEN
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
818: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
819: FND_MSG_PUB.ADD;
820: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

855: END LOOP;
856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
861: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
862: FND_MSG_PUB.ADD;
863: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

914: END IF;
915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919:
920: END get_routingstep_info;
921:
922:

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

1007: PROCEDURE check_delete_mark(pdelete_mark IN NUMBER,
1008: x_return_status OUT NOCOPY VARCHAR2) IS
1009: inv_delete_mark EXCEPTION;
1010: BEGIN
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012: IF (pdelete_mark NOT IN (0,1)) THEN
1013: RAISE inv_delete_mark;
1014: END IF;
1015: EXCEPTION

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: /* ================ */
1052: l_ret NUMBER;
1053: inv_owner_orgn_code EXCEPTION;
1054: BEGIN
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: OPEN Cur_ownerorgn_code;
1057: FETCH Cur_ownerorgn_code INTO l_ret;
1058: IF (Cur_ownerorgn_code%NOTFOUND) THEN
1059: CLOSE Cur_ownerorgn_code;

Line 1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

1102: /* ================ */
1103: l_ret NUMBER;
1104: inv_dep_step EXCEPTION;
1105: BEGIN
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107: OPEN Cur_step_no;
1108: FETCH Cur_step_no INTO l_ret;
1109: IF (Cur_step_no%FOUND) THEN
1110: CLOSE Cur_step_no;