APPS.GR_MIGRATE_TO_12 dependencies on FND_API

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: INVALID_ORG_ITEM EXCEPTION;
52:
53: BEGIN
54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: /* Validate the inventory item id */
58: OPEN c_get_inventory_item_id;
59: FETCH c_get_inventory_item_id INTO l_inventory_item_id;

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: EXCEPTION
72:
73: WHEN INVALID_ORG_ITEM THEN
74: x_msg_data := 'INVALID_ORG_ITEM';
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: RETURN NULL;
77:
78: WHEN OTHERS THEN
79: x_msg_data := SQLERRM;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: RETURN NULL;
77:
78: WHEN OTHERS THEN
79: x_msg_data := SQLERRM;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: RETURN NULL;
82:
83: END get_inventory_item_id;
84:

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: INVALID_HAZARD_CLASS EXCEPTION;
142:
143: BEGIN
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: /* Retrieve the hazard class */
148: OPEN c_get_hazard_class;
149: FETCH c_get_hazard_class INTO l_hazard_class;

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

170:
171: EXCEPTION
172: WHEN INVALID_HAZARD_CLASS THEN
173: x_msg_data := 'INVALID_HAZARD_CLASS';
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: RETURN NULL;
176:
177: WHEN OTHERS THEN
178: x_msg_data := SQLERRM;

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: RETURN NULL;
176:
177: WHEN OTHERS THEN
178: x_msg_data := SQLERRM;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: RETURN NULL;
181:
182: END get_hazard_class_id;
183:

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

239:
240:
241: BEGIN
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: /* Retrieve the un number */
246: OPEN c_get_un_number;
247: FETCH c_get_un_number INTO l_un_number;

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: EXCEPTION
270:
271: WHEN INVALID_UN_NUMBER THEN
272: x_msg_data := 'INVALID_UN_NUMBER';
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: RETURN NULL;
275:
276: WHEN OTHERS THEN
277: x_msg_data := SQLERRM;

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

274: RETURN NULL;
275:
276: WHEN OTHERS THEN
277: x_msg_data := SQLERRM;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: RETURN NULL;
280:
281: END get_un_number_id;
282:

Line 394: IF p_commit = FND_API.G_TRUE THEN

390: WHERE b.item_code = a.item_code and
391: b.organization_id = l_organization_id);
392:
393: /* Issue commit if required */
394: IF p_commit = FND_API.G_TRUE THEN
395: COMMIT;
396: END IF;
397:
398: l_migration_count:= l_migration_count + l_recs_inserted;

Line 432: IF p_commit = FND_API.G_TRUE THEN

428: WHERE b.item_code = a.item_code and
429: b.organization_id = l_organization_id);
430:
431: /* Issue commit if required */
432: IF p_commit = FND_API.G_TRUE THEN
433: COMMIT;
434: END IF;
435:
436: FETCH c_get_child_orgs into l_organization_id;

Line 783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

779: x_return_status => l_return_status,
780: x_msg_data => l_msg_data
781: );
782:
783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
784: RAISE PROC_CALL_ERROR;
785: END IF;
786:
787: /* Retrieve items UN Class */

Line 795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

791: x_return_status => l_return_status,
792: x_msg_data => l_msg_data
793: );
794:
795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
796: RAISE PROC_CALL_ERROR;
797: END IF;
798:
799: UPDATE mtl_system_items_b

Line 1067: IF p_commit = FND_API.G_TRUE THEN

1063: WHERE item_code = l_mig_rec.item_code and
1064: organization_id = l_mig_rec. organization_id;
1065:
1066: /* Issue commit if required */
1067: IF p_commit = FND_API.G_TRUE THEN
1068: COMMIT;
1069: END IF;
1070:
1071: /* Increment appropriate counter */

Line 1443: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1439: x_return_status => l_return_status,
1440: x_msg_data => l_msg_data
1441: );
1442:
1443: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1444: RAISE PROC_CALL_ERROR;
1445: END IF;
1446:
1447: /* Retrieve product's primary uom */

Line 1628: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1624: x_return_status => l_return_status,
1625: x_msg_data => l_msg_data
1626: );
1627:
1628: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1629: RAISE PROC_CALL_ERROR;
1630: END IF;
1631:
1632: /* Retrieve ingredient's primary uom */

Line 1849: IF p_commit = FND_API.G_TRUE THEN

1845: SET migration_ind = 1
1846: WHERE item_code = l_item_code;
1847:
1848: /* Issue commit if required */
1849: IF p_commit = FND_API.G_TRUE THEN
1850: COMMIT;
1851: END IF;
1852:
1853: END IF; -- If concentration record found

Line 2112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2108: x_return_status => l_return_status,
2109: x_msg_data => l_msg_data
2110: );
2111:
2112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2113: RAISE INVALID_ORG_ITEM;
2114: END IF;
2115:
2116: UPDATE gr_dispatch_history

Line 2122: IF p_commit = FND_API.G_TRUE THEN

2118: inventory_item_id = l_inv_item_id
2119: WHERE dispatch_history_id = l_dispatch_rec.dispatch_history_id;
2120:
2121: /* Issue commit if required */
2122: IF p_commit = FND_API.G_TRUE THEN
2123: COMMIT;
2124: END IF;
2125:
2126: l_migration_count := l_migration_count + 1;