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

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

50: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROUTING_STEPS';
51: l_row_id ROWID;
52: k NUMBER := 1;
53:
54: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
55: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
56: l_routing_id gmd_routings.routing_id%TYPE;
57: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
58: l_enforce_flag GMD_ROUTINGS.enforce_step_dependency%TYPE;

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

51: l_row_id ROWID;
52: k NUMBER := 1;
53:
54: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
55: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
56: l_routing_id gmd_routings.routing_id%TYPE;
57: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
58: l_enforce_flag GMD_ROUTINGS.enforce_step_dependency%TYPE;
59: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: BEGIN
97: SAVEPOINT create_routing_steps;
98:
99: /* Set the return status to success initially */
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: /* Initialize message list and count if needed */
103: IF p_init_msg_list THEN
104: fnd_msg_pub.initialize;

Line 116: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

112: RAISE setup_failure;
113: END IF;
114:
115: /* Make sure we are call compatible */
116: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
117: ,p_api_version
118: ,'INSERT_ROUTING_STEPS'
119: ,gmd_routing_steps_PUB.m_pkg_name) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
117: ,p_api_version
118: ,'INSERT_ROUTING_STEPS'
119: ,gmd_routing_steps_PUB.m_pkg_name) THEN
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: RAISE invalid_version;
122: END IF;
123:
124: /* Validations done prior to creation of routing steps */

Line 137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

133: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
134: ,pRouting_vers => p_routing_vers
135: ,xRouting_id => l_routing_id
136: ,xReturn_status => l_return_status);
137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: /* it indicates that this routing does'ntexists */
139: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
140: FND_MSG_PUB.ADD;
141: RAISE routing_step_creation_failure;

Line 149: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

145: ,pRouting_vers => p_routing_vers
146: ,xRouting_id => l_routing_id
147: ,xReturn_status => l_return_status);
148:
149: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
150: /* it indicates that this routing does'ntexists */
151: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
152: FND_MSG_PUB.ADD;
153: RAISE routing_step_creation_failure;

Line 204: IF x_return_status <> FND_API.g_ret_sts_success THEN

200: FND_MSG_PUB.ADD;
201: RAISE routing_step_creation_failure;
202: END IF;
203:
204: IF x_return_status <> FND_API.g_ret_sts_success THEN
205: RAISE routing_step_creation_failure;
206: END IF;
207:
208: IF (l_debug = 'Y') THEN

Line 311: IF x_return_status <> FND_API.g_ret_sts_success THEN

307: ,p_routing_step_rec => l_routing_step_rec
308: ,x_return_status => x_return_status
309: );
310:
311: IF x_return_status <> FND_API.g_ret_sts_success THEN
312: RAISE routing_step_creation_failure;
313: END IF;
314:
315: -- Check if routing detail was created

Line 378: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN

374: ,x_return_status => l_return_from_routing_step_dep
375: );
376:
377: /* Check if insert of step dependency was done */
378: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
379: RAISE routing_step_dep_failure;
380: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
381: END IF; /* when l_step_dep_tab.count > 0 */
382: END IF; /* if p_routings_step_dep_tbl.count > 0 */

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

376:
377: /* Check if insert of step dependency was done */
378: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
379: RAISE routing_step_dep_failure;
380: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
381: END IF; /* when l_step_dep_tab.count > 0 */
382: END IF; /* if p_routings_step_dep_tbl.count > 0 */
383:
384: /* Check if work was done */

Line 385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

381: END IF; /* when l_step_dep_tab.count > 0 */
382: END IF; /* if p_routings_step_dep_tbl.count > 0 */
383:
384: /* Check if work was done */
385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: RAISE routing_step_creation_failure;
387: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
388:
389: fnd_msg_pub.count_and_get (

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

383:
384: /* Check if work was done */
385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: RAISE routing_step_creation_failure;
387: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
388:
389: fnd_msg_pub.count_and_get (
390: p_count => x_message_count
391: ,p_encoded => FND_API.g_false

Line 391: ,p_encoded => FND_API.g_false

387: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
388:
389: fnd_msg_pub.count_and_get (
390: p_count => x_message_count
391: ,p_encoded => FND_API.g_false
392: ,p_data => x_message_list);
393:
394: IF x_message_count = 0 THEN
395: IF (l_debug = 'Y') THEN

Line 417: ,p_encoded => FND_API.g_false

413: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete '||SQLERRM);
414: END IF;
415: fnd_msg_pub.count_and_get (
416: p_count => x_message_count
417: ,p_encoded => FND_API.g_false
418: ,p_data => x_message_list);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN setup_failure THEN
421: ROLLBACK TO SAVEPOINT create_routing_steps;

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: fnd_msg_pub.count_and_get (
416: p_count => x_message_count
417: ,p_encoded => FND_API.g_false
418: ,p_data => x_message_list);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN setup_failure THEN
421: ROLLBACK TO SAVEPOINT create_routing_steps;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: fnd_msg_pub.count_and_get (

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418: ,p_data => x_message_list);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN setup_failure THEN
421: ROLLBACK TO SAVEPOINT create_routing_steps;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: fnd_msg_pub.count_and_get (
424: p_count => x_message_count
425: ,p_encoded => FND_API.g_false
426: ,p_data => x_message_list);

Line 425: ,p_encoded => FND_API.g_false

421: ROLLBACK TO SAVEPOINT create_routing_steps;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: fnd_msg_pub.count_and_get (
424: p_count => x_message_count
425: ,p_encoded => FND_API.g_false
426: ,p_data => x_message_list);
427: WHEN routing_step_dep_failure THEN
428: ROLLBACK TO SAVEPOINT create_routing_steps;
429: IF (l_debug = 'Y') THEN

Line 434: ,p_encoded => FND_API.g_false

430: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'failure due to insert step dep'||SQLERRM);
431: END IF;
432: fnd_msg_pub.count_and_get (
433: p_count => x_message_count
434: ,p_encoded => FND_API.g_false
435: ,p_data => x_message_list);
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: WHEN OTHERS THEN
438: ROLLBACK TO SAVEPOINT create_routing_steps;

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432: fnd_msg_pub.count_and_get (
433: p_count => x_message_count
434: ,p_encoded => FND_API.g_false
435: ,p_data => x_message_list);
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: WHEN OTHERS THEN
438: ROLLBACK TO SAVEPOINT create_routing_steps;
439: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
440: IF (l_debug = 'Y') THEN

Line 445: ,p_encoded => FND_API.g_false

441: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
442: END IF;
443: fnd_msg_pub.count_and_get (
444: p_count => x_message_count
445: ,p_encoded => FND_API.g_false
446: ,p_data => x_message_list);
447: x_return_status := FND_API.g_ret_sts_unexp_error;
448: END insert_routing_steps;
449:

Line 447: x_return_status := FND_API.g_ret_sts_unexp_error;

443: fnd_msg_pub.count_and_get (
444: p_count => x_message_count
445: ,p_encoded => FND_API.g_false
446: ,p_data => x_message_list);
447: x_return_status := FND_API.g_ret_sts_unexp_error;
448: END insert_routing_steps;
449:
450: /* =============================================================== */
451: /* Procedure: */

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

477:
478: /* Local variable section */
479: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_STEP_DEPENDENCIES';
480: l_routing_id gmd_routings.routing_id%TYPE;
481: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
482:
483: /* Exception section */
484: routing_step_dep_failure EXCEPTION;
485: invalid_version EXCEPTION;

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: BEGIN
489: SAVEPOINT create_step_dependencies;
490:
491: /* Set the return status to success initially */
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494: /* Initialize message list and count if needed */
495: IF p_init_msg_list THEN
496: fnd_msg_pub.initialize;

Line 508: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

504: RAISE setup_failure;
505: END IF;
506:
507: /* Make sure we are call compatible */
508: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
509: ,p_api_version
510: ,l_api_name
511: ,gmd_routing_steps_PUB.m_pkg_name) THEN
512: x_return_status := FND_API.G_RET_STS_ERROR;

Line 512: x_return_status := FND_API.G_RET_STS_ERROR;

508: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
509: ,p_api_version
510: ,l_api_name
511: ,gmd_routing_steps_PUB.m_pkg_name) THEN
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: RAISE invalid_version;
514: END IF;
515:
516: /* Routingstp number must be passed, otherwise give error */

Line 588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

584: ,pRouting_vers => p_routing_vers
585: ,xRouting_id => l_routing_id
586: ,xReturn_status => l_return_status);
587:
588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
589: /* it indicates that this routing does'ntexists */
590: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
591: FND_MSG_PUB.ADD;
592: RAISE routing_step_dep_failure;

Line 600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

596: ,pRouting_vers => p_routing_vers
597: ,xRouting_id => l_routing_id
598: ,xReturn_status => l_return_status);
599:
600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
601: /* it indicates that this routing does'ntexists */
602: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
603: FND_MSG_PUB.ADD;
604: RAISE routing_step_dep_failure;

Line 616: x_return_status := FND_API.g_ret_sts_error;

612: END IF;
613: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
614: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
615: FND_MSG_PUB.ADD;
616: x_return_status := FND_API.g_ret_sts_error;
617: END IF;
618:
619: /* Routing Security Validation */
620: /* Validation: Check if for given user this routing can be modified */

Line 650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

646: ,pRoutingstep_no => p_routingstep_no
647: ,pdeproutingstep_no => p_routings_step_dep_tbl(i).dep_routingstep_no
648: ,x_Return_status => l_return_status);
649:
650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: /* it indicates that this routing does'ntexists */
652: FND_MESSAGE.SET_NAME('GME', 'PC_RECORD_EXISTS');
653: FND_MSG_PUB.ADD;
654: RAISE routing_step_dep_failure;

Line 672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

668: gmd_debug.put_line('After inserting routing step dependencies');
669: END IF;
670:
671: /* Check if work was done */
672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
673: RAISE routing_step_dep_failure;
674: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
675:
676: fnd_msg_pub.count_and_get (

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

670:
671: /* Check if work was done */
672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
673: RAISE routing_step_dep_failure;
674: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
675:
676: fnd_msg_pub.count_and_get (
677: p_count => x_message_count
678: ,p_encoded => FND_API.g_false

Line 678: ,p_encoded => FND_API.g_false

674: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
675:
676: fnd_msg_pub.count_and_get (
677: p_count => x_message_count
678: ,p_encoded => FND_API.g_false
679: ,p_data => x_message_list);
680:
681: IF x_message_count = 0 THEN
682: IF (l_debug = 'Y') THEN

Line 703: ,p_encoded => FND_API.g_false

699: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
700: END IF;
701: fnd_msg_pub.count_and_get (
702: p_count => x_message_count
703: ,p_encoded => FND_API.g_false
704: ,p_data => x_message_list);
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: WHEN setup_failure THEN
707: ROLLBACK TO SAVEPOINT create_step_dependencies;

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: fnd_msg_pub.count_and_get (
702: p_count => x_message_count
703: ,p_encoded => FND_API.g_false
704: ,p_data => x_message_list);
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: WHEN setup_failure THEN
707: ROLLBACK TO SAVEPOINT create_step_dependencies;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: fnd_msg_pub.count_and_get (

Line 708: x_return_status := FND_API.G_RET_STS_ERROR;

704: ,p_data => x_message_list);
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: WHEN setup_failure THEN
707: ROLLBACK TO SAVEPOINT create_step_dependencies;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: fnd_msg_pub.count_and_get (
710: p_count => x_message_count
711: ,p_encoded => FND_API.g_false
712: ,p_data => x_message_list);

Line 711: ,p_encoded => FND_API.g_false

707: ROLLBACK TO SAVEPOINT create_step_dependencies;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: fnd_msg_pub.count_and_get (
710: p_count => x_message_count
711: ,p_encoded => FND_API.g_false
712: ,p_data => x_message_list);
713: WHEN OTHERS THEN
714: ROLLBACK TO SAVEPOINT create_step_dependencies;
715: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 721: ,p_encoded => FND_API.g_false

717: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
718: END IF;
719: fnd_msg_pub.count_and_get (
720: p_count => x_message_count
721: ,p_encoded => FND_API.g_false
722: ,p_data => x_message_list);
723: x_return_status := FND_API.g_ret_sts_unexp_error;
724: END insert_step_dependencies;
725:

Line 723: x_return_status := FND_API.g_ret_sts_unexp_error;

719: fnd_msg_pub.count_and_get (
720: p_count => x_message_count
721: ,p_encoded => FND_API.g_false
722: ,p_data => x_message_list);
723: x_return_status := FND_API.g_ret_sts_unexp_error;
724: END insert_step_dependencies;
725:
726: /* =============================================================== */
727: /* Procedure: */

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

754: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING_STEPS';
755: l_routing_id gmd_routings.routing_id%TYPE;
756: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
757: l_routingstep_no fm_rout_dtl.routingStep_no%TYPE;
758: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
759: l_oprn_id gmd_operations.oprn_id%TYPE;
760:
761: /* Define record type that hold the routing data */
762: l_old_routingStep_rec fm_rout_dtl%ROWTYPE;

Line 791: x_return_status := FND_API.G_RET_STS_SUCCESS;

787: BEGIN
788: SAVEPOINT update_routing_details;
789:
790: /* Set the return status to success initially */
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792:
793: /* Initialize message list and count if needed */
794: IF p_init_msg_list THEN
795: fnd_msg_pub.initialize;

Line 807: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

803: RAISE setup_failure;
804: END IF;
805:
806: /* Make sure we are call compatible */
807: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
808: ,p_api_version
809: ,l_api_name
810: ,gmd_routing_steps_PUB.m_pkg_name) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
808: ,p_api_version
809: ,l_api_name
810: ,gmd_routing_steps_PUB.m_pkg_name) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: RAISE invalid_version;
813: END IF;
814:
815: /* Validation prior to Routings Steps update */

Line 829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

825: ,pRouting_vers => p_routing_vers
826: ,xRouting_id => l_routing_id
827: ,xReturn_status => l_return_status);
828:
829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
830: /* it indicates that this routing does'ntexists */
831: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
832: FND_MSG_PUB.ADD;
833: RAISE routing_update_step_failure;

Line 841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

837: ,pRouting_vers => p_routing_vers
838: ,xRouting_id => l_routing_id
839: ,xReturn_status => l_return_status);
840:
841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: /* it indicates that this routing does'ntexists */
843: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
844: FND_MSG_PUB.ADD;
845: RAISE routing_update_step_failure;

Line 888: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

884: ,x_return_status => l_return_status );
885: IF (l_debug = 'Y') THEN
886: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
887: END IF;
888: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: /* it indicates that this routing does'ntexists */
890: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
891: FND_MSG_PUB.ADD;
892: RAISE routing_update_step_failure;

Line 901: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

897: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
898: ,pxRoutingStep_no => l_routingstep_no
899: ,pxRoutingStep_id => l_routingstep_id
900: ,x_return_status => l_return_status );
901: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
902: -- it indicates that this routing does not exists
903: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
904: FND_MSG_PUB.ADD;
905: RAISE routing_update_step_failure;

Line 984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

980: , x_return_status => x_return_status
981: );
982:
983: /* Check if work was done */
984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE routing_update_step_failure;
986: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
987:
988: fnd_msg_pub.count_and_get (

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

982:
983: /* Check if work was done */
984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE routing_update_step_failure;
986: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
987:
988: fnd_msg_pub.count_and_get (
989: p_count => x_message_count
990: ,p_encoded => FND_API.g_false

Line 990: ,p_encoded => FND_API.g_false

986: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
987:
988: fnd_msg_pub.count_and_get (
989: p_count => x_message_count
990: ,p_encoded => FND_API.g_false
991: ,p_data => x_message_list);
992:
993: IF x_message_count = 0 THEN
994: IF (l_debug = 'Y') THEN

Line 1014: ,p_encoded => FND_API.g_false

1010: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1011: END IF;
1012: fnd_msg_pub.count_and_get (
1013: p_count => x_message_count
1014: ,p_encoded => FND_API.g_false
1015: ,p_data => x_message_list);
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: WHEN setup_failure THEN
1018: ROLLBACK TO SAVEPOINT update_routing_details;

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: fnd_msg_pub.count_and_get (
1013: p_count => x_message_count
1014: ,p_encoded => FND_API.g_false
1015: ,p_data => x_message_list);
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: WHEN setup_failure THEN
1018: ROLLBACK TO SAVEPOINT update_routing_details;
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020: fnd_msg_pub.count_and_get (

Line 1019: x_return_status := FND_API.G_RET_STS_ERROR;

1015: ,p_data => x_message_list);
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: WHEN setup_failure THEN
1018: ROLLBACK TO SAVEPOINT update_routing_details;
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020: fnd_msg_pub.count_and_get (
1021: p_count => x_message_count
1022: ,p_encoded => FND_API.g_false
1023: ,p_data => x_message_list);

Line 1022: ,p_encoded => FND_API.g_false

1018: ROLLBACK TO SAVEPOINT update_routing_details;
1019: x_return_status := FND_API.G_RET_STS_ERROR;
1020: fnd_msg_pub.count_and_get (
1021: p_count => x_message_count
1022: ,p_encoded => FND_API.g_false
1023: ,p_data => x_message_list);
1024: WHEN VALID_DATE_EXCEPTION THEN
1025: ROLLBACK TO SAVEPOINT update_routing_details;
1026: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1026: x_return_status := FND_API.G_RET_STS_ERROR;

1022: ,p_encoded => FND_API.g_false
1023: ,p_data => x_message_list);
1024: WHEN VALID_DATE_EXCEPTION THEN
1025: ROLLBACK TO SAVEPOINT update_routing_details;
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: fnd_msg_pub.count_and_get (
1028: p_count => x_message_count
1029: ,p_encoded => FND_API.g_false
1030: ,p_data => x_message_list);

Line 1029: ,p_encoded => FND_API.g_false

1025: ROLLBACK TO SAVEPOINT update_routing_details;
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: fnd_msg_pub.count_and_get (
1028: p_count => x_message_count
1029: ,p_encoded => FND_API.g_false
1030: ,p_data => x_message_list);
1031: WHEN OTHERS THEN
1032: ROLLBACK TO SAVEPOINT update_routing_details;
1033: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 1039: ,p_encoded => FND_API.g_false

1035: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1036: END IF;
1037: fnd_msg_pub.count_and_get (
1038: p_count => x_message_count
1039: ,p_encoded => FND_API.g_false
1040: ,p_data => x_message_list);
1041: x_return_status := FND_API.g_ret_sts_unexp_error;
1042: END update_routing_steps;
1043:

Line 1041: x_return_status := FND_API.g_ret_sts_unexp_error;

1037: fnd_msg_pub.count_and_get (
1038: p_count => x_message_count
1039: ,p_encoded => FND_API.g_false
1040: ,p_data => x_message_list);
1041: x_return_status := FND_API.g_ret_sts_unexp_error;
1042: END update_routing_steps;
1043:
1044: /* =============================================================== */
1045: /* Procedure: */

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

1070: ) IS
1071:
1072: /* Local variable section */
1073: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STEP_DEPENDENCIES';
1074: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1075:
1076: l_routingstep_no fm_rout_dtl.routingStep_no%TYPE;
1077: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
1078: l_routing_id fm_rout_dep.routing_id%TYPE;

Line 1095: x_return_status := FND_API.G_RET_STS_SUCCESS;

1091: BEGIN
1092: SAVEPOINT update_step_dependency;
1093:
1094: /* Set the return status to success initially */
1095: x_return_status := FND_API.G_RET_STS_SUCCESS;
1096:
1097: /* Initialize message list and count if needed */
1098: IF p_init_msg_list THEN
1099: fnd_msg_pub.initialize;

Line 1111: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

1107: RAISE setup_failure;
1108: END IF;
1109:
1110: /* Make sure we are call compatible */
1111: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1112: ,p_api_version
1113: ,l_api_name
1114: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1115: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1115: x_return_status := FND_API.G_RET_STS_ERROR;

1111: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1112: ,p_api_version
1113: ,l_api_name
1114: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: RAISE invalid_version;
1117: END IF;
1118:
1119: /* Validation prior to Routings Step dependency update */

Line 1174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1170: ,pRouting_vers => p_routing_vers
1171: ,xRouting_id => l_routing_id
1172: ,xReturn_status => l_return_status);
1173:
1174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1175: /* it indicates that this routing does'ntexists */
1176: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1177: FND_MSG_PUB.ADD;
1178: RAISE routing_update_dep_failure;

Line 1186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1182: ,pRouting_vers => p_routing_vers
1183: ,xRouting_id => l_routing_id
1184: ,xReturn_status => l_return_status);
1185:
1186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1187: /* it indicates that this routing does'ntexists */
1188: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1189: FND_MSG_PUB.ADD;
1190: RAISE routing_update_dep_failure;

Line 1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1223: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1224: ,pxRoutingStep_no => l_routingstep_no
1225: ,pxRoutingStep_id => l_routingstep_id
1226: ,x_return_status => l_return_status );
1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1228: /* it indicates that this routing does'ntexists */
1229: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1230: FND_MSG_PUB.ADD;
1231: RAISE routing_update_dep_failure;

Line 1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1235: l_routingstep_id := p_routingstep_id;
1236: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
1237: ,pxRoutingStep_id => l_routingstep_id
1238: ,x_return_status => l_return_status );
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: /* it indicates that this routing does'ntexists */
1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1242: FND_MSG_PUB.ADD;
1243: RAISE routing_update_dep_failure;

Line 1258: IF x_return_status <> FND_API.g_ret_sts_success THEN

1254: FND_MSG_PUB.ADD;
1255: RAISE routing_update_dep_failure;
1256: END IF;
1257:
1258: IF x_return_status <> FND_API.g_ret_sts_success THEN
1259: RAISE routing_update_dep_failure;
1260: END IF;
1261:
1262: /* Validation : Routing status is not On Hold nor Obsolete/Archived

Line 1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1275: , p_update_table => p_update_table
1276: , x_return_status => x_return_status
1277: );
1278: /* Check if work was done */
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: RAISE routing_update_dep_failure;
1281: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1282:
1283: fnd_msg_pub.count_and_get (

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

1277: );
1278: /* Check if work was done */
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: RAISE routing_update_dep_failure;
1281: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1282:
1283: fnd_msg_pub.count_and_get (
1284: p_count => x_message_count
1285: ,p_encoded => FND_API.g_false

Line 1285: ,p_encoded => FND_API.g_false

1281: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1282:
1283: fnd_msg_pub.count_and_get (
1284: p_count => x_message_count
1285: ,p_encoded => FND_API.g_false
1286: ,p_data => x_message_list);
1287:
1288: IF x_message_count = 0 THEN
1289: IF (l_debug = 'Y') THEN

Line 1310: ,p_encoded => FND_API.g_false

1306: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1307: END IF;
1308: fnd_msg_pub.count_and_get (
1309: p_count => x_message_count
1310: ,p_encoded => FND_API.g_false
1311: ,p_data => x_message_list);
1312: x_return_status := FND_API.G_RET_STS_ERROR;
1313: WHEN setup_failure THEN
1314: ROLLBACK TO SAVEPOINT update_step_dependency;

Line 1312: x_return_status := FND_API.G_RET_STS_ERROR;

1308: fnd_msg_pub.count_and_get (
1309: p_count => x_message_count
1310: ,p_encoded => FND_API.g_false
1311: ,p_data => x_message_list);
1312: x_return_status := FND_API.G_RET_STS_ERROR;
1313: WHEN setup_failure THEN
1314: ROLLBACK TO SAVEPOINT update_step_dependency;
1315: x_return_status := FND_API.G_RET_STS_ERROR;
1316: fnd_msg_pub.count_and_get (

Line 1315: x_return_status := FND_API.G_RET_STS_ERROR;

1311: ,p_data => x_message_list);
1312: x_return_status := FND_API.G_RET_STS_ERROR;
1313: WHEN setup_failure THEN
1314: ROLLBACK TO SAVEPOINT update_step_dependency;
1315: x_return_status := FND_API.G_RET_STS_ERROR;
1316: fnd_msg_pub.count_and_get (
1317: p_count => x_message_count
1318: ,p_encoded => FND_API.g_false
1319: ,p_data => x_message_list);

Line 1318: ,p_encoded => FND_API.g_false

1314: ROLLBACK TO SAVEPOINT update_step_dependency;
1315: x_return_status := FND_API.G_RET_STS_ERROR;
1316: fnd_msg_pub.count_and_get (
1317: p_count => x_message_count
1318: ,p_encoded => FND_API.g_false
1319: ,p_data => x_message_list);
1320: WHEN OTHERS THEN
1321: ROLLBACK TO SAVEPOINT update_routing_details;
1322: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 1328: ,p_encoded => FND_API.g_false

1324: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1325: END IF;
1326: fnd_msg_pub.count_and_get (
1327: p_count => x_message_count
1328: ,p_encoded => FND_API.g_false
1329: ,p_data => x_message_list);
1330: x_return_status := FND_API.g_ret_sts_unexp_error;
1331:
1332: END update_step_dependencies;

Line 1330: x_return_status := FND_API.g_ret_sts_unexp_error;

1326: fnd_msg_pub.count_and_get (
1327: p_count => x_message_count
1328: ,p_encoded => FND_API.g_false
1329: ,p_data => x_message_list);
1330: x_return_status := FND_API.g_ret_sts_unexp_error;
1331:
1332: END update_step_dependencies;
1333:
1334: /* =============================================================== */

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

1358: ) IS
1359:
1360: /* Local variable section */
1361: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
1362: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1363: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1364: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1365: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1366: l_routing_id gmd_routings.routing_id%TYPE;

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

1359:
1360: /* Local variable section */
1361: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
1362: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1363: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1364: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1365: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1366: l_routing_id gmd_routings.routing_id%TYPE;
1367: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;

Line 1389: x_return_status := FND_API.G_RET_STS_SUCCESS;

1385: BEGIN
1386: SAVEPOINT delete_routing_step;
1387:
1388: /* Set the return status to success initially */
1389: x_return_status := FND_API.G_RET_STS_SUCCESS;
1390:
1391: /* Initialize message list and count if needed */
1392: IF p_init_msg_list THEN
1393: fnd_msg_pub.initialize;

Line 1405: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

1401: RAISE setup_failure;
1402: END IF;
1403:
1404: /* Make sure we are call compatible */
1405: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1406: ,p_api_version
1407: ,l_api_name
1408: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1406: ,p_api_version
1407: ,l_api_name
1408: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: RAISE invalid_version;
1411: END IF;
1412:
1413: /* Get routing id if it is not passed in as a parameter */

Line 1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1422: ,pRouting_vers => p_routing_vers
1423: ,xRouting_id => l_routing_id
1424: ,xReturn_status => l_return_status);
1425:
1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: /* it indicates that this routing does'ntexists */
1428: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1429: FND_MSG_PUB.ADD;
1430: RAISE routing_delete_step_failure;

Line 1438: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1434: ,pRouting_vers => p_routing_vers
1435: ,xRouting_id => l_routing_id
1436: ,xReturn_status => l_return_status);
1437:
1438: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1439: /* it indicates that this routing does'ntexists */
1440: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1441: FND_MSG_PUB.ADD;
1442: RAISE routing_delete_step_failure;

Line 1454: x_return_status := FND_API.g_ret_sts_error;

1450: END IF;
1451: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1452: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1453: FND_MSG_PUB.ADD;
1454: x_return_status := FND_API.g_ret_sts_error;
1455: END IF;
1456:
1457: /* Routing Security Validation */
1458: /* Validation: Check if for given user this routing can be modified */

Line 1483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1479: ,x_return_status => l_return_status );
1480: IF (l_debug = 'Y') THEN
1481: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
1482: END IF;
1483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1484: /* it indicates that this routing does'ntexists */
1485: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1486: FND_MSG_PUB.ADD;
1487: RAISE routing_delete_step_failure;

Line 1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1494: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1495: ,pxRoutingStep_no => l_routingstep_no
1496: ,pxRoutingStep_id => l_routingstep_id
1497: ,x_return_status => l_return_status );
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: /* it indicates that this routing does'ntexists */
1500: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1501: FND_MSG_PUB.ADD;
1502: RAISE routing_delete_step_failure;

Line 1546: ,p_encoded => FND_API.g_false

1542: );
1543:
1544: fnd_msg_pub.count_and_get (
1545: p_count => x_message_count
1546: ,p_encoded => FND_API.g_false
1547: ,p_data => x_message_list);
1548:
1549: IF x_message_count = 0 THEN
1550: IF (l_debug = 'Y') THEN

Line 1571: ,p_encoded => FND_API.g_false

1567: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1568: END IF;
1569: fnd_msg_pub.count_and_get (
1570: p_count => x_message_count
1571: ,p_encoded => FND_API.g_false
1572: ,p_data => x_message_list);
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN setup_failure THEN
1575: ROLLBACK TO SAVEPOINT delete_routing_step;

Line 1573: x_return_status := FND_API.G_RET_STS_ERROR;

1569: fnd_msg_pub.count_and_get (
1570: p_count => x_message_count
1571: ,p_encoded => FND_API.g_false
1572: ,p_data => x_message_list);
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN setup_failure THEN
1575: ROLLBACK TO SAVEPOINT delete_routing_step;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: fnd_msg_pub.count_and_get (

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR;

1572: ,p_data => x_message_list);
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN setup_failure THEN
1575: ROLLBACK TO SAVEPOINT delete_routing_step;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: fnd_msg_pub.count_and_get (
1578: p_count => x_message_count
1579: ,p_encoded => FND_API.g_false
1580: ,p_data => x_message_list);

Line 1579: ,p_encoded => FND_API.g_false

1575: ROLLBACK TO SAVEPOINT delete_routing_step;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: fnd_msg_pub.count_and_get (
1578: p_count => x_message_count
1579: ,p_encoded => FND_API.g_false
1580: ,p_data => x_message_list);
1581: WHEN routing_delete_stepdep_failure THEN
1582: ROLLBACK TO SAVEPOINT delete_routing_step;
1583: IF (l_debug = 'Y') THEN

Line 1588: ,p_encoded => FND_API.g_false

1584: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
1585: END IF;
1586: fnd_msg_pub.count_and_get (
1587: p_count => x_message_count
1588: ,p_encoded => FND_API.g_false
1589: ,p_data => x_message_list);
1590: x_return_status := FND_API.G_RET_STS_ERROR;
1591: WHEN OTHERS THEN
1592: ROLLBACK TO SAVEPOINT delete_routing_step;

Line 1590: x_return_status := FND_API.G_RET_STS_ERROR;

1586: fnd_msg_pub.count_and_get (
1587: p_count => x_message_count
1588: ,p_encoded => FND_API.g_false
1589: ,p_data => x_message_list);
1590: x_return_status := FND_API.G_RET_STS_ERROR;
1591: WHEN OTHERS THEN
1592: ROLLBACK TO SAVEPOINT delete_routing_step;
1593: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
1594: IF (l_debug = 'Y') THEN

Line 1599: ,p_encoded => FND_API.g_false

1595: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1596: END IF;
1597: fnd_msg_pub.count_and_get (
1598: p_count => x_message_count
1599: ,p_encoded => FND_API.g_false
1600: ,p_data => x_message_list);
1601: x_return_status := FND_API.g_ret_sts_unexp_error;
1602:
1603: END delete_routing_step;

Line 1601: x_return_status := FND_API.g_ret_sts_unexp_error;

1597: fnd_msg_pub.count_and_get (
1598: p_count => x_message_count
1599: ,p_encoded => FND_API.g_false
1600: ,p_data => x_message_list);
1601: x_return_status := FND_API.g_ret_sts_unexp_error;
1602:
1603: END delete_routing_step;
1604:
1605: /* =============================================================== */

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

1629: ) IS
1630:
1631: /* Local variable section */
1632: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STEP_DEPENDENCIES';
1633: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1634:
1635: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
1636: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
1637: l_dep_routingstep_no fm_rout_dep.dep_routingStep_no%TYPE;

Line 1649: x_return_status := FND_API.G_RET_STS_SUCCESS;

1645: BEGIN
1646: SAVEPOINT delete_step_dependency;
1647:
1648: /* Set the return status to success initially */
1649: x_return_status := FND_API.G_RET_STS_SUCCESS;
1650:
1651: /* Initialize message list and count if needed */
1652: IF p_init_msg_list THEN
1653: fnd_msg_pub.initialize;

Line 1665: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

1661: RAISE setup_failure;
1662: END IF;
1663:
1664: /* Make sure we are call compatible */
1665: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1666: ,p_api_version
1667: ,l_api_name
1668: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1669: x_return_status := FND_API.G_RET_STS_ERROR;

1665: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
1666: ,p_api_version
1667: ,l_api_name
1668: ,gmd_routing_steps_PUB.m_pkg_name) THEN
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: RAISE invalid_version;
1671: END IF;
1672:
1673: /* Validation prior to Routings Step dependency delete */

Line 1689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1685: ,pRouting_vers => p_routing_vers
1686: ,xRouting_id => l_routing_id
1687: ,xReturn_status => l_return_status);
1688:
1689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1690: /* it indicates that this routing does'ntexists */
1691: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1692: FND_MSG_PUB.ADD;
1693: RAISE routing_delete_dep_failure;

Line 1701: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1697: ,pRouting_vers => p_routing_vers
1698: ,xRouting_id => l_routing_id
1699: ,xReturn_status => l_return_status);
1700:
1701: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1702: /* it indicates that this routing does'ntexists */
1703: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1704: FND_MSG_PUB.ADD;
1705: RAISE routing_delete_dep_failure;

Line 1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1733: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1734: ,pxRoutingStep_no => l_routingstep_no
1735: ,pxRoutingStep_id => l_routingstep_id
1736: ,x_return_status => l_return_status );
1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: /* it indicates that this routing does'ntexists */
1739: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1740: FND_MSG_PUB.ADD;
1741: RAISE routing_delete_dep_failure;

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

1791:
1792: /* Check if work was done */
1793: IF SQL%ROWCOUNT = 0 THEN
1794: RAISE routing_delete_dep_failure;
1795: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1796:
1797: fnd_msg_pub.count_and_get (
1798: p_count => x_message_count
1799: ,p_encoded => FND_API.g_false

Line 1799: ,p_encoded => FND_API.g_false

1795: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1796:
1797: fnd_msg_pub.count_and_get (
1798: p_count => x_message_count
1799: ,p_encoded => FND_API.g_false
1800: ,p_data => x_message_list);
1801:
1802: IF x_message_count = 0 THEN
1803: IF (l_debug = 'Y') THEN

Line 1824: ,p_encoded => FND_API.g_false

1820: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1821: END IF;
1822: fnd_msg_pub.count_and_get (
1823: p_count => x_message_count
1824: ,p_encoded => FND_API.g_false
1825: ,p_data => x_message_list);
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: WHEN setup_failure THEN
1828: ROLLBACK TO SAVEPOINT delete_step_dependency;

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: fnd_msg_pub.count_and_get (
1823: p_count => x_message_count
1824: ,p_encoded => FND_API.g_false
1825: ,p_data => x_message_list);
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: WHEN setup_failure THEN
1828: ROLLBACK TO SAVEPOINT delete_step_dependency;
1829: x_return_status := FND_API.G_RET_STS_ERROR;
1830: fnd_msg_pub.count_and_get (

Line 1829: x_return_status := FND_API.G_RET_STS_ERROR;

1825: ,p_data => x_message_list);
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: WHEN setup_failure THEN
1828: ROLLBACK TO SAVEPOINT delete_step_dependency;
1829: x_return_status := FND_API.G_RET_STS_ERROR;
1830: fnd_msg_pub.count_and_get (
1831: p_count => x_message_count
1832: ,p_encoded => FND_API.g_false
1833: ,p_data => x_message_list);

Line 1832: ,p_encoded => FND_API.g_false

1828: ROLLBACK TO SAVEPOINT delete_step_dependency;
1829: x_return_status := FND_API.G_RET_STS_ERROR;
1830: fnd_msg_pub.count_and_get (
1831: p_count => x_message_count
1832: ,p_encoded => FND_API.g_false
1833: ,p_data => x_message_list);
1834: WHEN OTHERS THEN
1835: ROLLBACK TO SAVEPOINT delete_step_dependency;
1836: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);

Line 1842: ,p_encoded => FND_API.g_false

1838: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1839: END IF;
1840: fnd_msg_pub.count_and_get (
1841: p_count => x_message_count
1842: ,p_encoded => FND_API.g_false
1843: ,p_data => x_message_list);
1844: x_return_status := FND_API.g_ret_sts_unexp_error;
1845:
1846: END delete_step_dependencies;

Line 1844: x_return_status := FND_API.g_ret_sts_unexp_error;

1840: fnd_msg_pub.count_and_get (
1841: p_count => x_message_count
1842: ,p_encoded => FND_API.g_false
1843: ,p_data => x_message_list);
1844: x_return_status := FND_API.g_ret_sts_unexp_error;
1845:
1846: END delete_step_dependencies;
1847:
1848: END GMD_ROUTING_STEPS_PUB;