APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_API

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: INVALID_ITEM EXCEPTION;
122:
123: BEGIN
124:
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: /* Retrieve Regulatory Item information */
128: OPEN c_get_reg_item;
129: FETCH c_get_reg_item INTO l_reg_rec;

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179:
180: WHEN INVALID_ITEM THEN
181: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
182: x_msg_data := FND_MESSAGE.GET;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184:
185: WHEN OTHERS THEN
186: x_msg_data := SQLERRM;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: x_return_status := FND_API.G_RET_STS_ERROR;
184:
185: WHEN OTHERS THEN
186: x_msg_data := SQLERRM;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188:
189: END get_reg_item_info;
190:
191: /*====================================================================

Line 282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

278: p_item_code => p_item_code,
279: x_reg_item_rec => l_opm_item,
280: x_return_status => l_return_status,
281: x_msg_data => l_msg_data);
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
283: -- Log error
284: -- dbms_output.put_line ('Invalid Regulatory Item :' || p_item_code);
285: GMA_COMMON_LOGGING.gma_migration_central_log (
286: p_run_id => p_migration_run_id,

Line 347: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

343: x_return_status => l_return_status,
344: x_msg_count => l_msg_count,
345: x_msg_data => l_msg_data);
346:
347: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
348: l_action := 'U';
349: END IF;
350:
351: EXCEPTION

Line 913: WHEN FND_API.G_EXC_ERROR THEN

909: -- Jatinder - 11/30/06 - Move commit to the main procedure to avoid deadlocks. 5690686.
910: EXCEPTION
911: WHEN e_error THEN
912: ROLLBACK;
913: WHEN FND_API.G_EXC_ERROR THEN
914: x_failure_count := x_failure_count + 1;
915: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
916: FOR i in 1..l_msg_count LOOP
917: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: p_app_short_name => 'FND');
932: END LOOP;
933: ROLLBACK;
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936:
937: x_failure_count := x_failure_count + 1;
938: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
939: FOR i in 1..l_msg_count LOOP

Line 1514: IF (p_commit <> FND_API.G_FALSE) THEN

1510: END IF;
1511:
1512: -- Jatinder - 11/30/06 - Moved commit here to avoid deadlocks. 5690686.
1513: -- Autonomous transaction commit
1514: IF (p_commit <> FND_API.G_FALSE) THEN
1515: COMMIT;
1516: ELSE
1517: ROLLBACK; -- Since this is an autonomous transaction
1518: END IF;

Line 1924: IF (p_commit <> FND_API.G_FALSE) THEN

1920: NULL
1921: );
1922: END IF;
1923:
1924: IF (p_commit <> FND_API.G_FALSE) THEN
1925: COMMIT;
1926: END IF;
1927: END LOOP;
1928: