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 760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

756: x_return_status => l_return_status,
757: x_msg_data => l_msg_data
758: );
759:
760: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
761: RAISE PROC_CALL_ERROR;
762: END IF;
763:
764: /* Retrieve items UN Class */

Line 772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

768: x_return_status => l_return_status,
769: x_msg_data => l_msg_data
770: );
771:
772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
773: RAISE PROC_CALL_ERROR;
774: END IF;
775:
776: UPDATE mtl_system_items_b

Line 1044: IF p_commit = FND_API.G_TRUE THEN

1040: WHERE item_code = l_mig_rec.item_code and
1041: organization_id = l_mig_rec. organization_id;
1042:
1043: /* Issue commit if required */
1044: IF p_commit = FND_API.G_TRUE THEN
1045: COMMIT;
1046: END IF;
1047:
1048: /* Increment appropriate counter */

Line 1419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1415: x_return_status => l_return_status,
1416: x_msg_data => l_msg_data
1417: );
1418:
1419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1420: RAISE PROC_CALL_ERROR;
1421: END IF;
1422:
1423: /* Retrieve product's primary uom */

Line 1604: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1600: x_return_status => l_return_status,
1601: x_msg_data => l_msg_data
1602: );
1603:
1604: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1605: RAISE PROC_CALL_ERROR;
1606: END IF;
1607:
1608: /* Retrieve ingredient's primary uom */

Line 1825: IF p_commit = FND_API.G_TRUE THEN

1821: SET migration_ind = 1
1822: WHERE item_code = l_item_code;
1823:
1824: /* Issue commit if required */
1825: IF p_commit = FND_API.G_TRUE THEN
1826: COMMIT;
1827: END IF;
1828:
1829: END IF; -- If concentration record found

Line 2088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2084: x_return_status => l_return_status,
2085: x_msg_data => l_msg_data
2086: );
2087:
2088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: RAISE INVALID_ORG_ITEM;
2090: END IF;
2091:
2092: UPDATE gr_dispatch_history

Line 2098: IF p_commit = FND_API.G_TRUE THEN

2094: inventory_item_id = l_inv_item_id
2095: WHERE dispatch_history_id = l_dispatch_rec.dispatch_history_id;
2096:
2097: /* Issue commit if required */
2098: IF p_commit = FND_API.G_TRUE THEN
2099: COMMIT;
2100: END IF;
2101:
2102: l_migration_count := l_migration_count + 1;