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.PO_PRICE_ADJUSTMENTS_PKG dependencies on FND_API

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: ORDER BY ATTRV.price_adjustment_id ASC;
659:
660: BEGIN
661: SAVEPOINT POPULATE_QP_TABLES;
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: l_progress := '000';
664:
665: --Check if order_header_id or line_ids are passed
666: IF (p_order_header_id IS NULL) THEN

Line 1200: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1196: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
1197: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1198: END IF;
1199:
1200: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1200: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1208: FND_MSG_PUB.Add;

Line 1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1201: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1208: FND_MSG_PUB.Add;
1209: RAISE FND_API.G_EXC_ERROR;

Line 1209: RAISE FND_API.G_EXC_ERROR;

1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1208: FND_MSG_PUB.Add;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: END IF;
1212:
1213:

Line 1239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1235: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
1236: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1237: END IF;
1238:
1239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1246: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1247: FND_MSG_PUB.Add;

Line 1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1240: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1246: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR;

Line 1248: RAISE FND_API.G_EXC_ERROR;

1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1246: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250: END IF;
1251:
1252:

Line 1300: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1296: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
1297: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1298: END IF;
1299:
1300: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1308: FND_MSG_PUB.Add;

Line 1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1301: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;

Line 1309: RAISE FND_API.G_EXC_ERROR;

1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311: END IF;
1312: END IF;
1313: CLOSE man_ovr_adj_attr_cur;

Line 1332: WHEN FND_API.G_EXC_ERROR THEN

1328: END IF;
1329: */
1330: --
1331: EXCEPTION
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: IF g_debug_unexp THEN
1335: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH EXC ERROR with rollback');
1336: END IF;

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: */
1330: --
1331: EXCEPTION
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: IF g_debug_unexp THEN
1335: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH EXC ERROR with rollback');
1336: END IF;
1337: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;

Line 1338: RAISE FND_API.G_EXC_ERROR;

1334: IF g_debug_unexp THEN
1335: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH EXC ERROR with rollback');
1336: END IF;
1337: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1338: RAISE FND_API.G_EXC_ERROR;
1339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF g_debug_unexp THEN
1342: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH UNEXPECTED ERROR with rollback');

Line 1339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1335: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH EXC ERROR with rollback');
1336: END IF;
1337: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1338: RAISE FND_API.G_EXC_ERROR;
1339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF g_debug_unexp THEN
1342: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH UNEXPECTED ERROR with rollback');
1343: END IF;

Line 1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1336: END IF;
1337: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1338: RAISE FND_API.G_EXC_ERROR;
1339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF g_debug_unexp THEN
1342: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH UNEXPECTED ERROR with rollback');
1343: END IF;
1344: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;

Line 1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1341: IF g_debug_unexp THEN
1342: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING POPL_MANUAL_OVERRIDDEN_ADJ WITH UNEXPECTED ERROR with rollback');
1343: END IF;
1344: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF g_debug_unexp THEN
1349: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN POPL_MANUAL_OVERRIDDEN_ADJ. SQLERRM at '||l_progress||': '||SQLERRM);

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1343: END IF;
1344: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF g_debug_unexp THEN
1349: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN POPL_MANUAL_OVERRIDDEN_ADJ. SQLERRM at '||l_progress||': '||SQLERRM);
1350: END IF;
1351:

Line 1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1352: IF g_debug_unexp THEN
1353: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.POPL_MANUAL_OVERRIDDEN_ADJ with rollback');
1354: END IF;
1355: ROLLBACK TO SAVEPOINT POPULATE_QP_TABLES;
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END popl_manual_overridden_adj;
1358:
1359: --------------------------------------------------------------------------------
1360: --Start of Comments

Line 1419: x_return_status := FND_API.G_RET_STS_SUCCESS;

1415:
1416: --
1417: BEGIN
1418: SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1419: x_return_status := FND_API.G_RET_STS_SUCCESS;
1420: l_progress := '000';
1421:
1422: --Check if order_header_id or line_ids are passed
1423: IF (p_order_header_id IS NULL OR p_order_line_id_tbl IS NULL OR p_order_line_id_tbl.count <= 0) THEN

Line 1538: WHEN FND_API.G_EXC_ERROR THEN

1534: ,p_price_adjustment_id => NULL);
1535: END IF;
1536: --
1537: EXCEPTION
1538: WHEN FND_API.G_EXC_ERROR THEN
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: IF g_debug_unexp THEN
1541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH EXC ERROR with rollback');
1542: END IF;

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: END IF;
1536: --
1537: EXCEPTION
1538: WHEN FND_API.G_EXC_ERROR THEN
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: IF g_debug_unexp THEN
1541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH EXC ERROR with rollback');
1542: END IF;
1543: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: IF g_debug_unexp THEN
1541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH EXC ERROR with rollback');
1542: END IF;
1543: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1544: RAISE FND_API.G_EXC_ERROR;
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1547: IF g_debug_unexp THEN
1548: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback');

Line 1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1541: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH EXC ERROR with rollback');
1542: END IF;
1543: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1544: RAISE FND_API.G_EXC_ERROR;
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1547: IF g_debug_unexp THEN
1548: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback');
1549: END IF;

Line 1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1542: END IF;
1543: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1544: RAISE FND_API.G_EXC_ERROR;
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1547: IF g_debug_unexp THEN
1548: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback');
1549: END IF;
1550: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;

Line 1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1547: IF g_debug_unexp THEN
1548: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING EXTRACT_PRICE_ADJUSTMENTS WITH UNEXPECTED ERROR with rollback');
1549: END IF;
1550: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: WHEN OTHERS THEN
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: IF g_debug_unexp THEN
1555: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN EXTRACT_PRICE_ADJUSTMENTS. SQLERRM at '||l_progress||': '||SQLERRM);

Line 1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1549: END IF;
1550: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: WHEN OTHERS THEN
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: IF g_debug_unexp THEN
1555: PO_DEBUG.debug_stmt(l_log_head,l_progress,'UnExpected ERROR IN EXTRACT_PRICE_ADJUSTMENTS. SQLERRM at '||l_progress||': '||SQLERRM);
1556: END IF;
1557:

Line 1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1558: IF g_debug_unexp THEN
1559: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING PO_PRICE_ADJUSTMENTS_PKG.EXTRACT_PRICE_ADJUSTMENTS with rollback');
1560: END IF;
1561: ROLLBACK TO SAVEPOINT EXTRACT_PRICE_ADJUSTMENTS;
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END extract_price_adjustments;
1564:
1565:
1566: PROCEDURE delete_line_adjs

Line 1741: RAISE FND_API.G_EXC_ERROR;

1737: PO_DEBUG.debug_stmt(p_log_head,l_progress,'in lock record exception, someone else working on the row');
1738: END IF;
1739: --FND_MESSAGE.SET_NAME('ONT', 'PO_LOCK_ROW_ALREADY_LOCKED');
1740: --PO_MSG_PUB.Add;
1741: RAISE FND_API.G_EXC_ERROR;
1742: WHEN NO_DATA_FOUND THEN
1743: l_progress := '200';
1744: IF g_debug_stmt THEN
1745: PO_DEBUG.debug_stmt(p_log_head,l_progress,'no_data_found, record lock exception');

Line 1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1748: l_progress := '210';
1749: IF g_debug_stmt THEN
1750: PO_DEBUG.debug_stmt(p_log_head,l_progress,'record lock exception, others');
1751: END IF;
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END;
1754:
1755: UPDATE PO_PRICE_ADJUSTMENTS_DRAFT ADJD
1756: SET ( LAST_UPDATE_DATE

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: l_progress := '300';
2111: IF g_debug_stmt THEN
2112: PO_DEBUG.debug_stmt(p_log_head,l_progress,'ERROR in inserting adjustments and associations');
2113: END IF;
2114: RAISE FND_API.G_EXC_ERROR;
2115: END insert_adj;
2116:
2117: PROCEDURE update_adj_attribs(p_draft_id IN NUMBER
2118: ,p_order_header_id IN NUMBER

Line 2353: x_return_status := FND_API.G_RET_STS_SUCCESS;

2349: PO_LOG.proc_begin(d_mod, 'p_draft_id', p_draft_id);
2350: PO_LOG.proc_begin(d_mod, 'p_doc_sub_type', p_doc_sub_type);
2351: END IF;
2352:
2353: x_return_status := FND_API.G_RET_STS_SUCCESS;
2354:
2355: d_position := 100;
2356: IF PO_LOG.d_stmt THEN
2357: PO_LOG.stmt(d_mod, d_position, 'Get newly added manual modifier lines');

Line 2496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2492: END IF;
2493:
2494: EXCEPTION
2495: WHEN OTHERS THEN
2496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2497: x_return_status_text := 'UnExpected ERROR IN COMPLETE_MANUAL_MOD_LOV_MAP. SQLERRM at '||d_position||': '||SQLERRM;
2498: IF PO_LOG.d_exc THEN
2499: PO_LOG.exc(d_mod, d_position, x_return_status_text);
2500: END IF;

Line 2556: x_return_status := FND_API.G_RET_STS_SUCCESS;

2552: AND (p_overridden_flag IS NULL OR ADJ.updated_flag = p_overridden_flag);
2553:
2554: BEGIN
2555: SAVEPOINT COPY_LINE_ADJUSTMENTS;
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557: l_progress := '010';
2558:
2559: IF g_debug_stmt THEN
2560: PO_DEBUG.debug_begin(l_log_head);

Line 2803: x_return_status := FND_API.G_RET_STS_ERROR;

2799: END IF;
2800:
2801: EXCEPTION
2802: WHEN COPYDOC_ADJUSTMENT_FAILURE THEN
2803: x_return_status := FND_API.G_RET_STS_ERROR;
2804: x_return_status_text := l_return_status_text;
2805:
2806: IF g_debug_unexp THEN
2807: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING COPY_LINE_ADJUSTMENTS with ERROR: '||l_return_status_text);

Line 2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2807: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING COPY_LINE_ADJUSTMENTS with ERROR: '||l_return_status_text);
2808: END IF;
2809: ROLLBACK TO SAVEPOINT COPY_LINE_ADJUSTMENTS;
2810: WHEN OTHERS THEN
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2812: x_return_status_text := 'UnExpected ERROR IN COPY_LINE_ADJUSTMENTS. SQLERRM at '||l_progress||': '||SQLERRM;
2813:
2814: IF g_debug_unexp THEN
2815: PO_DEBUG.debug_stmt(l_log_head,l_progress, x_return_status_text);

Line 2874: x_return_status := FND_API.G_RET_STS_SUCCESS;

2870: AND (p_overridden_flag IS NULL OR ADJV.updated_flag = p_overridden_flag);
2871:
2872: BEGIN
2873: SAVEPOINT COPY_DRAFT_LINE_ADJUSTMENTS;
2874: x_return_status := FND_API.G_RET_STS_SUCCESS;
2875: l_progress := '010';
2876:
2877: IF g_debug_stmt THEN
2878: PO_DEBUG.debug_begin(l_log_head);

Line 3210: x_return_status := FND_API.G_RET_STS_ERROR;

3206: END IF;
3207:
3208: EXCEPTION
3209: WHEN COPYDOC_ADJUSTMENT_FAILURE THEN
3210: x_return_status := FND_API.G_RET_STS_ERROR;
3211: x_return_status_text := l_return_status_text;
3212:
3213: IF g_debug_unexp THEN
3214: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING COPY_DRAFT_LINE_ADJUSTMENTS with ERROR: '||l_return_status_text);

Line 3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3214: PO_DEBUG.debug_stmt(l_log_head,l_progress,'EXITING COPY_DRAFT_LINE_ADJUSTMENTS with ERROR: '||l_return_status_text);
3215: END IF;
3216: ROLLBACK TO SAVEPOINT COPY_DRAFT_LINE_ADJUSTMENTS;
3217: WHEN OTHERS THEN
3218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3219: x_return_status_text := 'UnExpected ERROR IN COPY_DRAFT_LINE_ADJUSTMENTS. SQLERRM at '||l_progress||': '||SQLERRM;
3220:
3221: IF g_debug_unexp THEN
3222: PO_DEBUG.debug_stmt(l_log_head,l_progress, x_return_status_text);