DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on FND_API

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: IF NOT gmd_api_grp.setup_done THEN
61: RAISE setup_failure;
62: END IF;
63: /* Set the return status to success initially */
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66:
67: IF p_routings.routing_id IS NOT NULL THEN
68:

Line 150: ,p_encoded => FND_API.g_false

146: END IF;
147: /* Get the messgae list and count generated by this API */
148: fnd_msg_pub.count_and_get (
149: p_count => x_message_count
150: ,p_encoded => FND_API.g_false
151: ,p_data => x_message_list);
152:
153: IF (l_debug = 'Y') THEN
154: gmd_debug.put_line('Completed '||l_api_name ||' at '

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: END IF;
162: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
163: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
164: FND_MSG_PUB.ADD;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: fnd_msg_pub.count_and_get (
167: p_count => x_message_count
168: ,p_encoded => FND_API.g_false
169: ,p_data => x_message_list);

Line 168: ,p_encoded => FND_API.g_false

164: FND_MSG_PUB.ADD;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: fnd_msg_pub.count_and_get (
167: p_count => x_message_count
168: ,p_encoded => FND_API.g_false
169: ,p_data => x_message_list);
170: WHEN setup_failure THEN
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: fnd_msg_pub.count_and_get (

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: p_count => x_message_count
168: ,p_encoded => FND_API.g_false
169: ,p_data => x_message_list);
170: WHEN setup_failure THEN
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: fnd_msg_pub.count_and_get (
173: p_count => x_message_count
174: ,p_encoded => FND_API.g_false
175: ,p_data => x_message_list);

Line 174: ,p_encoded => FND_API.g_false

170: WHEN setup_failure THEN
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: fnd_msg_pub.count_and_get (
173: p_count => x_message_count
174: ,p_encoded => FND_API.g_false
175: ,p_data => x_message_list);
176: WHEN OTHERS THEN
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 181: x_return_status := FND_API.g_ret_sts_unexp_error;

177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
179: END IF;
180: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
181: x_return_status := FND_API.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get (
183: p_count => x_message_count
184: ,p_encoded => FND_API.g_false
185: ,p_data => x_message_list);

Line 184: ,p_encoded => FND_API.g_false

180: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
181: x_return_status := FND_API.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get (
183: p_count => x_message_count
184: ,p_encoded => FND_API.g_false
185: ,p_data => x_message_list);
186: END insert_routing;
187:
188: /* =============================================================== */

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: RAISE setup_failure;
279: END IF;
280:
281: /* Set the return status to success initially */
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283: /* Get the old routing rec value */
284: OPEN get_old_routing_rec(p_routing_id);
285: FETCH get_old_routing_rec INTO l_old_routing_rec;
286: IF get_old_routing_rec%NOTFOUND THEN

Line 559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

555: );
556: END LOOP;
557:
558: /* Check if work was done */
559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
560: RAISE routing_update_failure;
561: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
562:
563: /* Get the messgae list and count generated by this API */

Line 561: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

557:
558: /* Check if work was done */
559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
560: RAISE routing_update_failure;
561: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
562:
563: /* Get the messgae list and count generated by this API */
564: fnd_msg_pub.count_and_get (
565: p_count => x_message_count

Line 566: ,p_encoded => FND_API.g_false

562:
563: /* Get the messgae list and count generated by this API */
564: fnd_msg_pub.count_and_get (
565: p_count => x_message_count
566: ,p_encoded => FND_API.g_false
567: ,p_data => x_message_list);
568:
569: IF (l_debug = 'Y') THEN
570: gmd_debug.put_line('Completed '||l_api_name ||' at '

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574: WHEN routing_update_failure OR invalid_version THEN
575: IF (l_debug = 'Y') THEN
576: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
577: END IF;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: fnd_msg_pub.count_and_get (
580: p_count => x_message_count
581: ,p_encoded => FND_API.g_false
582: ,p_data => x_message_list);

Line 581: ,p_encoded => FND_API.g_false

577: END IF;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: fnd_msg_pub.count_and_get (
580: p_count => x_message_count
581: ,p_encoded => FND_API.g_false
582: ,p_data => x_message_list);
583: WHEN last_update_date_failure THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

Line 584: x_return_status := FND_API.G_RET_STS_ERROR;

580: p_count => x_message_count
581: ,p_encoded => FND_API.g_false
582: ,p_data => x_message_list);
583: WHEN last_update_date_failure THEN
584: x_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
586: FND_MSG_PUB.ADD;
587: fnd_msg_pub.count_and_get (
588: p_count => x_message_count

Line 589: ,p_encoded => FND_API.g_false

585: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
586: FND_MSG_PUB.ADD;
587: fnd_msg_pub.count_and_get (
588: p_count => x_message_count
589: ,p_encoded => FND_API.g_false
590: ,p_data => x_message_list);
591: WHEN setup_failure THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: fnd_msg_pub.count_and_get (

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: p_count => x_message_count
589: ,p_encoded => FND_API.g_false
590: ,p_data => x_message_list);
591: WHEN setup_failure THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: fnd_msg_pub.count_and_get (
594: p_count => x_message_count
595: ,p_encoded => FND_API.g_false
596: ,p_data => x_message_list);

Line 595: ,p_encoded => FND_API.g_false

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

Line 602: x_return_status := FND_API.g_ret_sts_unexp_error;

598: IF (l_debug = 'Y') THEN
599: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
600: END IF;
601: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
602: x_return_status := FND_API.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get (
604: p_count => x_message_count
605: ,p_encoded => FND_API.g_false
606: ,p_data => x_message_list);

Line 605: ,p_encoded => FND_API.g_false

601: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
602: x_return_status := FND_API.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get (
604: p_count => x_message_count
605: ,p_encoded => FND_API.g_false
606: ,p_data => x_message_list);
607: END update_routing;
608: /* =============================================================== */
609: /* Procedure: */