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_ROUTING_STEPS_PVT dependencies on FND_API

Line 42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

38: ) IS
39:
40: /* Local variable section */
41: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROUTING_STEPS';
42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
44: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;
45:
46: /*define cursor */

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: IF NOT gmd_api_grp.setup_done THEN
66: RAISE setup_failure;
67: END IF;
68: /* Set the return status to success initially */
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: /* Get the routingStep_id from sequence generator */
72: IF (l_debug = 'Y') THEN
73: gmd_debug.put_line('Get the routingstep id value : ');

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: WHEN routing_step_creation_failure OR invalid_version THEN
131: IF (l_debug = 'Y') THEN
132: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete '||SQLERRM);
133: END IF;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: WHEN setup_failure THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN OTHERS THEN
138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete '||SQLERRM);
133: END IF;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: WHEN setup_failure THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN OTHERS THEN
138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 142: x_return_status := FND_API.g_ret_sts_unexp_error;

138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
141: END IF;
142: x_return_status := FND_API.g_ret_sts_unexp_error;
143: END insert_routing_steps;
144:
145: /* =============================================================== */
146: /* Procedure: */

Line 175: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

171: AND routingstep_no = vroutingstep_no;
172:
173: /* Local variable section */
174: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_STEP_DEPENDENCIES';
175: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
176: l_step_qty NUMBER;
177: l_transfer_qty NUMBER;
178:
179: /* Exception section */

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: RAISE setup_failure;
197: END IF;
198:
199: /* Set the return status to success initially */
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202:
203: /* Insert made into the step dependency table */
204: FOR i IN 1 .. p_routings_step_dep_tbl.count LOOP

Line 217: x_return_status := FND_API.g_ret_sts_error;

213: IF (p_routings_step_dep_tbl(i).max_delay < p_routings_step_dep_tbl(i).standard_delay AND
214: p_routings_step_dep_tbl(i).max_delay IS NOT NULL) THEN
215: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
216: FND_MSG_PUB.ADD;
217: x_return_status := FND_API.g_ret_sts_error;
218: END IF;
219:
220:
221: INSERT INTO fm_rout_dep

Line 261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

257: RAISE routing_cir_ref_failure;
258: END IF;
259:
260: /* Check if work was done */
261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RAISE routing_step_dep_failure;
263: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
264: IF (l_debug = 'Y') THEN
265: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

259:
260: /* Check if work was done */
261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RAISE routing_step_dep_failure;
263: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
264: IF (l_debug = 'Y') THEN
265: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
266: END IF;
267:

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: WHEN routing_step_dep_failure OR invalid_version THEN
270: IF (l_debug = 'Y') THEN
271: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
272: END IF;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274:
275: WHEN routing_cir_ref_failure THEN
276: IF (l_debug = 'Y') THEN
277: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete due circular reference');

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: WHEN routing_cir_ref_failure THEN
276: IF (l_debug = 'Y') THEN
277: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete due circular reference');
278: END IF;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: WHEN setup_failure THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete due circular reference');
278: END IF;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: WHEN setup_failure THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
284: IF (l_debug = 'Y') THEN
285: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 287: x_return_status := FND_API.g_ret_sts_unexp_error;

283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
284: IF (l_debug = 'Y') THEN
285: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
286: END IF;
287: x_return_status := FND_API.g_ret_sts_unexp_error;
288: END insert_step_dependencies;
289:
290: /* =============================================================== */
291: /* Procedure: */

Line 311: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

307:
308: /* Local variable section */
309: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING_STEPS';
310: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
311: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
312: l_db_date DATE;
313:
314: /* Define record type that hold the routing data */
315: l_old_routingStep_rec fm_rout_dtl%ROWTYPE;

Line 330: x_return_status := FND_API.G_RET_STS_SUCCESS;

326: Where RoutingStep_id = vRoutingStep_id;
327:
328: BEGIN
329: /* Set the return status to success initially */
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: /* Get the old routing rec value */
333: IF (l_debug = 'Y') THEN
334: gmd_debug.put_line('Fetch : Populate the old routing step record ');

Line 514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

510: END IF;
511: END LOOP;
512:
513: /* Check if work was done */
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: RAISE routing_update_step_failure;
516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
517: IF (l_debug = 'Y') THEN
518: gmd_debug.put_line('Completed '||m_pkg_name||'.'||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

512:
513: /* Check if work was done */
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: RAISE routing_update_step_failure;
516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
517: IF (l_debug = 'Y') THEN
518: gmd_debug.put_line('Completed '||m_pkg_name||'.'||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
519: END IF;
520:

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: WHEN routing_update_step_failure OR invalid_version THEN
523: IF (l_debug = 'Y') THEN
524: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
525: END IF;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: WHEN last_update_date_failure THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
530: FND_MSG_PUB.ADD;

Line 528: x_return_status := FND_API.G_RET_STS_ERROR;

524: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
525: END IF;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: WHEN last_update_date_failure THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
530: FND_MSG_PUB.ADD;
531: WHEN setup_failure THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
530: FND_MSG_PUB.ADD;
531: WHEN setup_failure THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
535: IF (l_debug = 'Y') THEN
536: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 538: x_return_status := FND_API.g_ret_sts_unexp_error;

534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
535: IF (l_debug = 'Y') THEN
536: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;
539: END update_routing_steps;
540:
541: /* =============================================================== */
542: /* Procedure: */

Line 563: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

559: ) IS
560:
561: /* Local variable section */
562: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STEP_DEPENDENCIES';
563: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
564: l_db_date DATE;
565:
566: /* Define record type that hold the routing data */
567: l_old_stepDep_rec fm_rout_dep%ROWTYPE;

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

594: RAISE setup_failure;
595: END IF;
596:
597: /* Set the return status to success initially */
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599:
600: /* The old routing step dependency record */
601: OPEN get_old_stepDep_rec(p_routingstep_no,p_dep_routingstep_no,p_routing_id);
602: FETCH get_old_stepDep_rec INTO l_old_stepDep_rec;

Line 651: x_return_status := FND_API.g_ret_sts_error;

647: IF (l_old_stepDep_rec.max_delay < l_old_stepDep_rec.standard_delay AND
648: l_old_stepDep_rec.max_delay IS NOT NULL) THEN
649: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
650: FND_MSG_PUB.ADD;
651: x_return_status := FND_API.g_ret_sts_error;
652: END IF;
653:
654: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */
655: UPDATE fm_rout_dep

Line 675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

671: END IF;
672: END LOOP;
673:
674: /* Check if work was done */
675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
676: RAISE routing_update_dep_failure;
677: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
678: IF (l_debug = 'Y') THEN
679: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

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

673:
674: /* Check if work was done */
675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
676: RAISE routing_update_dep_failure;
677: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
678: IF (l_debug = 'Y') THEN
679: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
680: END IF;
681:

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: WHEN routing_update_dep_failure OR invalid_version THEN
684: IF (l_debug = 'Y') THEN
685: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
686: END IF;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: WHEN last_update_date_failure THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
691: FND_MSG_PUB.ADD;

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
686: END IF;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: WHEN last_update_date_failure THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
691: FND_MSG_PUB.ADD;
692: WHEN setup_failure THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
691: FND_MSG_PUB.ADD;
692: WHEN setup_failure THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: WHEN OTHERS THEN
695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
696: IF (l_debug = 'Y') THEN
697: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 699: x_return_status := FND_API.g_ret_sts_unexp_error;

695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
696: IF (l_debug = 'Y') THEN
697: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
698: END IF;
699: x_return_status := FND_API.g_ret_sts_unexp_error;
700: END update_step_dependencies;
701:
702: /* =============================================================== */
703: /* Procedure: */

Line 722: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

718: ) IS
719:
720: /* Local variable section */
721: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
722: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
723: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
724: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
725: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
726: l_stepdep_count NUMBER := 0;

Line 723: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

719:
720: /* Local variable section */
721: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
722: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
723: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
724: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
725: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
726: l_stepdep_count NUMBER := 0;
727: l_exists PLS_INTEGER;

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: RAISE setup_failure;
787: END IF;
788:
789: /* Set the return status to success initially */
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: /* Get the routingstep_no (routingstep_no is used for the routing step dep delete ) */
793: IF (l_debug = 'Y') THEN
794: gmd_debug.put_line(' get the RoutingStep_id - if it is not passed as a parameter ');

Line 801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

797: l_routingstep_id := p_routingstep_id;
798: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
799: ,pxRoutingStep_id => l_routingstep_id
800: ,x_return_status => l_return_status );
801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
802: /* it indicates that this routing does'ntexists */
803: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
804: FND_MSG_PUB.ADD;
805: RAISE routing_delete_step_failure;

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

812:
813: /* Check if work was done */
814: IF SQL%ROWCOUNT = 0 THEN
815: RAISE routing_delete_step_failure;
816: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
817:
818: /* Bug#5211932 - Check if the routing step is used in the recipe */
819:
820: /* Check for any overrides at recipe routing steps */

Line 874: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN

870: , x_return_status => l_return_from_routing_step_dep
871: );
872:
873: /* Check if insert of step dependency was done */
874: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
875: RAISE routing_delete_stepdep_failure;
876: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
877: END IF; /* l_stepdep_count > 0 */
878:

Line 876: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */

872:
873: /* Check if insert of step dependency was done */
874: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
875: RAISE routing_delete_stepdep_failure;
876: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
877: END IF; /* l_stepdep_count > 0 */
878:
879: /* Actual delete is performed */
880: DELETE FROM fm_rout_dtl

Line 892: x_return_status := FND_API.G_RET_STS_ERROR;

888: WHEN routing_delete_step_failure OR invalid_version THEN
889: IF (l_debug = 'Y') THEN
890: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: WHEN step_used_in_recipe THEN
894: IF (l_debug = 'Y') THEN
895: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'routing step '||l_routingstep_no||' has override data ');
896: END IF;

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'routing step '||l_routingstep_no||' has override data ');
896: END IF;
897: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');
898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: WHEN routing_delete_stepdep_failure THEN
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
903: END IF;

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900: WHEN routing_delete_stepdep_failure THEN
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
903: END IF;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: WHEN setup_failure THEN
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: WHEN OTHERS THEN
908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 906: x_return_status := FND_API.G_RET_STS_ERROR;

902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
903: END IF;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: WHEN setup_failure THEN
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: WHEN OTHERS THEN
908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 912: x_return_status := FND_API.g_ret_sts_unexp_error;

908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
911: END IF;
912: x_return_status := FND_API.g_ret_sts_unexp_error;
913: END delete_routing_step;
914:
915:
916: /* =============================================================== */

Line 937: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

933: ) IS
934:
935: /* Local variable section */
936: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STEP_DEPENDENCIES';
937: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
938:
939: /* Define Exceptions */
940: routing_delete_dep_failure EXCEPTION;
941: invalid_version EXCEPTION;

Line 950: x_return_status := FND_API.G_RET_STS_SUCCESS;

946: gmd_debug.log_initialize('Desdpvt');
947: END IF;
948:
949: /* Set the return status to success initially */
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: /* Actual delete in fm_rout_dep table */
953: /* This delete can be specific to a dep_routingstep_no or a
954: Routingstep_no */

Line 991: x_return_status := FND_API.G_RET_STS_ERROR;

987: WHEN routing_delete_dep_failure OR invalid_version THEN
988: IF (l_debug = 'Y') THEN
989: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
990: END IF;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: WHEN setup_failure THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN OTHERS THEN
995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
990: END IF;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: WHEN setup_failure THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN OTHERS THEN
995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
996: IF (l_debug = 'Y') THEN
997: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 999: x_return_status := FND_API.g_ret_sts_unexp_error;

995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
996: IF (l_debug = 'Y') THEN
997: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
998: END IF;
999: x_return_status := FND_API.g_ret_sts_unexp_error;
1000:
1001: END delete_step_dependencies;
1002:
1003: END GMD_ROUTING_STEPS_PVT;