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 GMD_ROUTINGS

Line 39: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

35: (
36: p_api_version IN NUMBER := 1
37: , p_init_msg_list IN BOOLEAN := TRUE
38: , p_commit IN BOOLEAN := FALSE
39: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
40: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
41: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
42: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
43: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

Line 40: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

36: p_api_version IN NUMBER := 1
37: , p_init_msg_list IN BOOLEAN := TRUE
38: , p_commit IN BOOLEAN := FALSE
39: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
40: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
41: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
42: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
43: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
44: , x_message_count OUT NOCOPY NUMBER

Line 41: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

37: , p_init_msg_list IN BOOLEAN := TRUE
38: , p_commit IN BOOLEAN := FALSE
39: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
40: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
41: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
42: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
43: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
44: , x_message_count OUT NOCOPY NUMBER
45: , x_message_list OUT NOCOPY VARCHAR2

Line 43: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

39: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
40: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
41: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
42: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
43: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
44: , x_message_count OUT NOCOPY NUMBER
45: , x_message_list OUT NOCOPY VARCHAR2
46: , x_return_status OUT NOCOPY VARCHAR2
47: ) IS

Line 56: l_routing_id gmd_routings.routing_id%TYPE;

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;
60: l_oprn_no gmd_operations.oprn_no%TYPE;

Line 58: l_enforce_flag GMD_ROUTINGS.enforce_step_dependency%TYPE;

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;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_rout_eff_start_date DATE;

Line 69: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

65: /* define record type */
66: l_routing_step_rec fm_rout_dtl%ROWTYPE;
67:
68: /* define table type */
69: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
70:
71: /* Cursor section */
72: CURSOR get_enforce_flag(vRouting_id NUMBER) IS
73: Select enforce_step_dependency

Line 74: From gmd_routings_b

70:
71: /* Cursor section */
72: CURSOR get_enforce_flag(vRouting_id NUMBER) IS
73: Select enforce_step_dependency
74: From gmd_routings_b
75: Where routing_id = vRouting_id;
76:
77: /* gets the operation no and version associated to the routing detail/Step */
78: Cursor Get_oprn_details(vOprn_id fm_rout_dtl.oprn_id%TYPE) IS

Line 86: From gmd_routings_b

82:
83: /* get routing start date */
84: Cursor get_rout_start_date(vRouting_id NUMBER) IS
85: Select effective_start_date, effective_end_date
86: From gmd_routings_b
87: Where routing_id = vRouting_id;
88:
89: /* Exception section */
90: routing_creation_failure EXCEPTION;

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 467: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

463: (
464: p_api_version IN NUMBER := 1
465: , p_init_msg_list IN BOOLEAN := TRUE
466: , p_commit IN BOOLEAN := FALSE
467: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
468: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
469: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
470: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
471: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL

Line 468: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

464: p_api_version IN NUMBER := 1
465: , p_init_msg_list IN BOOLEAN := TRUE
466: , p_commit IN BOOLEAN := FALSE
467: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
468: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
469: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
470: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
471: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
472: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

Line 469: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

465: , p_init_msg_list IN BOOLEAN := TRUE
466: , p_commit IN BOOLEAN := FALSE
467: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
468: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
469: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
470: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
471: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
472: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
473: , x_message_count OUT NOCOPY NUMBER

Line 472: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

468: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
469: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
470: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
471: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
472: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
473: , x_message_count OUT NOCOPY NUMBER
474: , x_message_list OUT NOCOPY VARCHAR2
475: , x_return_status OUT NOCOPY VARCHAR2
476: ) IS

Line 480: l_routing_id gmd_routings.routing_id%TYPE;

476: ) IS
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;

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 744: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

740: , p_init_msg_list IN BOOLEAN := TRUE
741: , p_commit IN BOOLEAN := FALSE
742: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
743: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
744: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
745: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
746: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
747: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
748: , x_message_count OUT NOCOPY NUMBER

Line 745: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

741: , p_commit IN BOOLEAN := FALSE
742: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
743: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
744: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
745: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
746: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
747: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
748: , x_message_count OUT NOCOPY NUMBER
749: , x_message_list OUT NOCOPY VARCHAR2

Line 746: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

742: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
743: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
744: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
745: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
746: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
747: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
748: , x_message_count OUT NOCOPY NUMBER
749: , x_message_list OUT NOCOPY VARCHAR2
750: , x_return_status OUT NOCOPY VARCHAR2

Line 747: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type

743: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
744: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
745: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
746: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
747: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
748: , x_message_count OUT NOCOPY NUMBER
749: , x_message_list OUT NOCOPY VARCHAR2
750: , x_return_status OUT NOCOPY VARCHAR2
751: ) IS

Line 755: l_routing_id gmd_routings.routing_id%TYPE;

751: ) IS
752:
753: /* Local variable section */
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;

Line 772: From gmd_routings_b

768: Where routingStep_id = vRoutingStep_id;
769:
770: Cursor get_routing_owner_orgn_code(vRouting_id Number) IS
771: Select owner_orgn_code
772: From gmd_routings_b
773: Where routing_id = vRouting_id;
774:
775: /* Define Exceptions */
776: routing_update_step_failure EXCEPTION;

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 890: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
893: END IF;
894: ELSE

Line 903: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
906: END IF;
907: END IF;

Line 1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

1060: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1061: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
1067: , x_message_count OUT NOCOPY NUMBER
1068: , x_message_list OUT NOCOPY VARCHAR2

Line 1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

1061: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
1067: , x_message_count OUT NOCOPY NUMBER
1068: , x_message_list OUT NOCOPY VARCHAR2
1069: , x_return_status OUT NOCOPY VARCHAR2

Line 1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type

1062: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1063: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1064: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1065: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1066: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
1067: , x_message_count OUT NOCOPY NUMBER
1068: , x_message_list OUT NOCOPY VARCHAR2
1069: , x_return_status OUT NOCOPY VARCHAR2
1070: ) IS

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 1229: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
1232: END IF;
1233: ELSE

Line 1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
1244: END IF;
1245: END IF;

Line 1353: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

1349: , p_commit IN BOOLEAN := FALSE
1350: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1351: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
1352: , p_routing_id IN fm_rout_dtl.routing_id%TYPE := NULL
1353: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1354: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1355: , x_message_count OUT NOCOPY NUMBER
1356: , x_message_list OUT NOCOPY VARCHAR2
1357: , x_return_status OUT NOCOPY VARCHAR2

Line 1354: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

1350: , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
1351: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
1352: , p_routing_id IN fm_rout_dtl.routing_id%TYPE := NULL
1353: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1354: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1355: , x_message_count OUT NOCOPY NUMBER
1356: , x_message_list OUT NOCOPY VARCHAR2
1357: , x_return_status OUT NOCOPY VARCHAR2
1358: ) IS

Line 1366: l_routing_id gmd_routings.routing_id%TYPE;

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;
1368:
1369: /* Define Cursors */
1370: /* Cursor that check if there any row in the step dependency table that

Line 1373: ,vRouting_id gmd_routings.Routing_id%TYPE) IS

1369: /* Define Cursors */
1370: /* Cursor that check if there any row in the step dependency table that
1371: needs to be deleted */
1372: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE
1373: ,vRouting_id gmd_routings.Routing_id%TYPE) IS
1374: Select dep_routingstep_no
1375: From fm_rout_dep
1376: Where routingStep_no = vRoutingStep_no
1377: And routing_id = vrouting_id;

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 1485: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
1488: END IF;
1489: ELSE

Line 1500: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
1503: END IF;
1504: END IF;

Line 1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL

1620: , p_commit IN BOOLEAN := FALSE
1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1626: , x_message_count OUT NOCOPY NUMBER
1627: , x_message_list OUT NOCOPY VARCHAR2
1628: , x_return_status OUT NOCOPY VARCHAR2

Line 1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL

1621: , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
1622: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
1623: , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
1624: , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
1625: , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
1626: , x_message_count OUT NOCOPY NUMBER
1627: , x_message_list OUT NOCOPY VARCHAR2
1628: , x_return_status OUT NOCOPY VARCHAR2
1629: ) IS

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 1739: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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;
1742: END IF;
1743: END IF;