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_DOCUMENT_FUNDS_PVT dependencies on FND_API

Line 139: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

135: -- Indicates whether funds override capability can be used if needed, to make a
136: -- transaction succeed.
137: --OUT:
138: --x_return_status
139: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
140: -- FND_API.G_RET_STS_ERROR if validation fails
141: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
142: --x_po_return_code
143: -- Indicates whether PO is classifying this transaction as an

Line 140: -- FND_API.G_RET_STS_ERROR if validation fails

136: -- transaction succeed.
137: --OUT:
138: --x_return_status
139: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
140: -- FND_API.G_RET_STS_ERROR if validation fails
141: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
142: --x_po_return_code
143: -- Indicates whether PO is classifying this transaction as an
144: -- Error/Warning/Partial Success/Success

Line 141: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

137: --OUT:
138: --x_return_status
139: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
140: -- FND_API.G_RET_STS_ERROR if validation fails
141: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
142: --x_po_return_code
143: -- Indicates whether PO is classifying this transaction as an
144: -- Error/Warning/Partial Success/Success
145: --x_online_report_id

Line 214: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

210: x_online_report_id => x_online_report_id);
211:
212: l_progress := '100';
213:
214: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
215: OR x_return_status IS NULL
216: ) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213:
214: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
215: OR x_return_status IS NULL
216: ) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: l_progress := '900';
221:

Line 296: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

292: --p_override_date
293: -- Caller-specified date to use for distribution encumbrance date in GL entries
294: --OUT:
295: --x_return_status
296: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
297: -- FND_API.G_RET_STS_ERROR if validation fails
298: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
299: --x_po_return_code
300: -- Indicates whether PO is classifying this transaction as an

Line 297: -- FND_API.G_RET_STS_ERROR if validation fails

293: -- Caller-specified date to use for distribution encumbrance date in GL entries
294: --OUT:
295: --x_return_status
296: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
297: -- FND_API.G_RET_STS_ERROR if validation fails
298: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
299: --x_po_return_code
300: -- Indicates whether PO is classifying this transaction as an
301: -- Error/Warning/Partial Success/Success

Line 298: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

294: --OUT:
295: --x_return_status
296: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
297: -- FND_API.G_RET_STS_ERROR if validation fails
298: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
299: --x_po_return_code
300: -- Indicates whether PO is classifying this transaction as an
301: -- Error/Warning/Partial Success/Success
302: --x_online_report_id

Line 369: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

365: x_online_report_id => x_online_report_id);
366:
367: l_progress := '100';
368:
369: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
370: OR x_return_status IS NULL
371: ) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368:
369: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
370: OR x_return_status IS NULL
371: ) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: l_progress := '900';
376:

Line 468: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

464: --p_employee_id
465: -- Employee Id of the user taking the action
466: --OUT:
467: --x_return_status
468: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
469: -- FND_API.G_RET_STS_ERROR if validation fails
470: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
471: --x_po_return_code
472: -- Indicates whether PO is classifying this transaction as an

Line 469: -- FND_API.G_RET_STS_ERROR if validation fails

465: -- Employee Id of the user taking the action
466: --OUT:
467: --x_return_status
468: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
469: -- FND_API.G_RET_STS_ERROR if validation fails
470: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
471: --x_po_return_code
472: -- Indicates whether PO is classifying this transaction as an
473: -- Error/Warning/Partial Success/Success

Line 470: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

466: --OUT:
467: --x_return_status
468: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
469: -- FND_API.G_RET_STS_ERROR if validation fails
470: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
471: --x_po_return_code
472: -- Indicates whether PO is classifying this transaction as an
473: -- Error/Warning/Partial Success/Success
474: --x_online_report_id

Line 547: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

543: x_online_report_id => x_online_report_id);
544:
545: l_progress := '100';
546:
547: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
548: OR x_return_status IS NULL
549: ) THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546:
547: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
548: OR x_return_status IS NULL
549: ) THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: l_progress := '900';
554:

Line 645: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

641: --p_employee_id
642: -- Employee Id of the user taking the action
643: --OUT:
644: --x_return_status
645: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
646: -- FND_API.G_RET_STS_ERROR if validation fails
647: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
648: --x_po_return_code
649: -- Indicates whether PO is classifying this transaction as an

Line 646: -- FND_API.G_RET_STS_ERROR if validation fails

642: -- Employee Id of the user taking the action
643: --OUT:
644: --x_return_status
645: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
646: -- FND_API.G_RET_STS_ERROR if validation fails
647: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
648: --x_po_return_code
649: -- Indicates whether PO is classifying this transaction as an
650: -- Error/Warning/Partial Success/Success

Line 647: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

643: --OUT:
644: --x_return_status
645: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
646: -- FND_API.G_RET_STS_ERROR if validation fails
647: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
648: --x_po_return_code
649: -- Indicates whether PO is classifying this transaction as an
650: -- Error/Warning/Partial Success/Success
651: --x_online_report_id

Line 728: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

724: x_online_report_id => x_online_report_id);
725:
726: l_progress := '100';
727:
728: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
729: OR x_return_status IS NULL
730: ) THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727:
728: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
729: OR x_return_status IS NULL
730: ) THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: l_progress := '900';
735:

Line 816: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

812: --p_override_date
813: -- Caller-specified date to use for distribution encumbrance date in GL entries
814: --OUT:
815: --x_return_status
816: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
817: -- FND_API.G_RET_STS_ERROR if validation fails
818: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
819: --x_po_return_code
820: -- Indicates whether PO is classifying this transaction as an

Line 817: -- FND_API.G_RET_STS_ERROR if validation fails

813: -- Caller-specified date to use for distribution encumbrance date in GL entries
814: --OUT:
815: --x_return_status
816: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
817: -- FND_API.G_RET_STS_ERROR if validation fails
818: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
819: --x_po_return_code
820: -- Indicates whether PO is classifying this transaction as an
821: -- Error/Warning/Partial Success/Success

Line 818: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

814: --OUT:
815: --x_return_status
816: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
817: -- FND_API.G_RET_STS_ERROR if validation fails
818: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
819: --x_po_return_code
820: -- Indicates whether PO is classifying this transaction as an
821: -- Error/Warning/Partial Success/Success
822: --x_online_report_id

Line 893: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

889: x_online_report_id => x_online_report_id);
890:
891: l_progress := '100';
892:
893: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
894: OR x_return_status IS NULL
895: ) THEN
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;

Line 896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

892:
893: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
894: OR x_return_status IS NULL
895: ) THEN
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;
898:
899: l_progress := '900';
900:

Line 985: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

981: --p_override_date
982: -- Caller-specified date to use for distribution encumbrance date in GL entries
983: --OUT:
984: --x_return_status
985: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
986: -- FND_API.G_RET_STS_ERROR if validation fails
987: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
988: --x_po_return_code
989: -- Indicates whether PO is classifying this transaction as an

Line 986: -- FND_API.G_RET_STS_ERROR if validation fails

982: -- Caller-specified date to use for distribution encumbrance date in GL entries
983: --OUT:
984: --x_return_status
985: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
986: -- FND_API.G_RET_STS_ERROR if validation fails
987: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
988: --x_po_return_code
989: -- Indicates whether PO is classifying this transaction as an
990: -- Error/Warning/Partial Success/Success

Line 987: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

983: --OUT:
984: --x_return_status
985: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
986: -- FND_API.G_RET_STS_ERROR if validation fails
987: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
988: --x_po_return_code
989: -- Indicates whether PO is classifying this transaction as an
990: -- Error/Warning/Partial Success/Success
991: --x_online_report_id

Line 1064: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1060: x_online_report_id => x_online_report_id);
1061:
1062: l_progress := '100';
1063:
1064: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1065: OR x_return_status IS NULL
1066: ) THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: END IF;

Line 1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1063:
1064: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1065: OR x_return_status IS NULL
1066: ) THEN
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: END IF;
1069:
1070: l_progress := '900';
1071:

Line 1159: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1155: --p_override_date
1156: -- Caller-specified date to use for distribution encumbrance date in GL entries
1157: --OUT:
1158: --x_return_status
1159: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1160: -- FND_API.G_RET_STS_ERROR if validation fails
1161: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1162: --x_po_return_code
1163: -- Indicates whether PO is classifying this transaction as an

Line 1160: -- FND_API.G_RET_STS_ERROR if validation fails

1156: -- Caller-specified date to use for distribution encumbrance date in GL entries
1157: --OUT:
1158: --x_return_status
1159: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1160: -- FND_API.G_RET_STS_ERROR if validation fails
1161: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1162: --x_po_return_code
1163: -- Indicates whether PO is classifying this transaction as an
1164: -- Error/Warning/Partial Success/Success

Line 1161: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1157: --OUT:
1158: --x_return_status
1159: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1160: -- FND_API.G_RET_STS_ERROR if validation fails
1161: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1162: --x_po_return_code
1163: -- Indicates whether PO is classifying this transaction as an
1164: -- Error/Warning/Partial Success/Success
1165: --x_online_report_id

Line 1238: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1234: x_online_report_id => x_online_report_id);
1235:
1236: l_progress := '100';
1237:
1238: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1239: OR x_return_status IS NULL
1240: ) THEN
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1242: END IF;

Line 1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1237:
1238: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1239: OR x_return_status IS NULL
1240: ) THEN
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1242: END IF;
1243:
1244: l_progress := '900';
1245:

Line 1327: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1323: -- If 'Y', then encumbrance code will make calls to check doc correctness
1324: -- If 'N', then the caller has already done these validations.
1325: --OUT:
1326: --x_return_status
1327: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1328: -- FND_API.G_RET_STS_ERROR if validation fails
1329: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1330: --x_po_return_code
1331: -- Indicates whether PO is classifying this transaction as an

Line 1328: -- FND_API.G_RET_STS_ERROR if validation fails

1324: -- If 'N', then the caller has already done these validations.
1325: --OUT:
1326: --x_return_status
1327: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1328: -- FND_API.G_RET_STS_ERROR if validation fails
1329: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1330: --x_po_return_code
1331: -- Indicates whether PO is classifying this transaction as an
1332: -- Error/Warning/Partial Success/Success

Line 1329: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1325: --OUT:
1326: --x_return_status
1327: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1328: -- FND_API.G_RET_STS_ERROR if validation fails
1329: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1330: --x_po_return_code
1331: -- Indicates whether PO is classifying this transaction as an
1332: -- Error/Warning/Partial Success/Success
1333: --x_online_report_id

Line 1406: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1402: x_online_report_id => x_online_report_id);
1403:
1404: l_progress := '100';
1405:
1406: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1407: OR x_return_status IS NULL
1408: ) THEN
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;

Line 1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1405:
1406: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1407: OR x_return_status IS NULL
1408: ) THEN
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: l_progress := '900';
1413:

Line 1493: -- FND_API.G_RET_STS_SUCCESS for success

1489: -- in GL entries.
1490: --OUT:
1491: --x_return_status
1492: -- VARCHAR2(1)
1493: -- FND_API.G_RET_STS_SUCCESS for success
1494: -- FND_API.G_RET_STS_ERROR for a forseen error
1495: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
1496: --x_po_return_code
1497: -- VARCHAR2(10)

Line 1494: -- FND_API.G_RET_STS_ERROR for a forseen error

1490: --OUT:
1491: --x_return_status
1492: -- VARCHAR2(1)
1493: -- FND_API.G_RET_STS_SUCCESS for success
1494: -- FND_API.G_RET_STS_ERROR for a forseen error
1495: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
1496: --x_po_return_code
1497: -- VARCHAR2(10)
1498: -- Indicates the PO classification of the results of this transaction.

Line 1495: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs

1491: --x_return_status
1492: -- VARCHAR2(1)
1493: -- FND_API.G_RET_STS_SUCCESS for success
1494: -- FND_API.G_RET_STS_ERROR for a forseen error
1495: -- FND_API.G_RET_STS_UNEXP_ERROR if an unexpected error occurs
1496: --x_po_return_code
1497: -- VARCHAR2(10)
1498: -- Indicates the PO classification of the results of this transaction.
1499: -- g_return_<>

Line 1564: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1560: );
1561:
1562: l_progress := '200';
1563:
1564: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1565: OR x_return_status IS NULL
1566: ) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;

Line 1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1563:
1564: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1565: OR x_return_status IS NULL
1566: ) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;
1569:
1570: l_progress := '210';
1571: IF g_debug_stmt THEN

Line 1588: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1584: );
1585:
1586: l_progress := '300';
1587:
1588: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1589: OR x_return_status IS NULL
1590: ) THEN
1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END IF;

Line 1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1587:
1588: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1589: OR x_return_status IS NULL
1590: ) THEN
1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END IF;
1593:
1594: l_progress := '310';
1595: IF g_debug_stmt THEN

Line 1635: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1631: );
1632:
1633: l_progress := '400';
1634:
1635: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1636: OR x_return_status IS NULL
1637: ) THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;

Line 1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1634:
1635: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1636: OR x_return_status IS NULL
1637: ) THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: l_progress := '900';
1642:

Line 1727: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

1723: -- The id of the invoice that is causing the final match, when coming
1724: -- through an AP call.
1725: --OUT:
1726: --x_return_status
1727: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1728: -- FND_API.G_RET_STS_ERROR if validation fails
1729: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1730: --x_po_return_code
1731: -- Indicates whether PO is classifying this transaction as an

Line 1728: -- FND_API.G_RET_STS_ERROR if validation fails

1724: -- through an AP call.
1725: --OUT:
1726: --x_return_status
1727: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1728: -- FND_API.G_RET_STS_ERROR if validation fails
1729: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1730: --x_po_return_code
1731: -- Indicates whether PO is classifying this transaction as an
1732: -- Error/Warning/Partial Success/Success

Line 1729: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1725: --OUT:
1726: --x_return_status
1727: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
1728: -- FND_API.G_RET_STS_ERROR if validation fails
1729: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1730: --x_po_return_code
1731: -- Indicates whether PO is classifying this transaction as an
1732: -- Error/Warning/Partial Success/Success
1733: --x_online_report_id

Line 1812: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1808: );
1809:
1810: l_progress := '100';
1811:
1812: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1813: OR x_return_status IS NULL
1814: ) THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: END IF;

Line 1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1811:
1812: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1813: OR x_return_status IS NULL
1814: ) THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: END IF;
1817:
1818: l_progress := '900';
1819:

Line 1994: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1990: );
1991:
1992: l_progress := '100';
1993:
1994: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1995: OR x_return_status IS NULL
1996: ) THEN
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;

Line 1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1993:
1994: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1995: OR x_return_status IS NULL
1996: ) THEN
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999:
2000: l_progress := '900';
2001:

Line 2080: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2076: --p_employee_id
2077: -- Employee Id of the user taking the action
2078: --OUT:
2079: --x_return_status
2080: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2081: -- FND_API.G_RET_STS_ERROR if validation fails
2082: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2083: --x_po_return_code
2084: -- Indicates whether PO is classifying this transaction as an

Line 2081: -- FND_API.G_RET_STS_ERROR if validation fails

2077: -- Employee Id of the user taking the action
2078: --OUT:
2079: --x_return_status
2080: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2081: -- FND_API.G_RET_STS_ERROR if validation fails
2082: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2083: --x_po_return_code
2084: -- Indicates whether PO is classifying this transaction as an
2085: -- Error/Warning/Partial Success/Success

Line 2082: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2078: --OUT:
2079: --x_return_status
2080: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2081: -- FND_API.G_RET_STS_ERROR if validation fails
2082: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2083: --x_po_return_code
2084: -- Indicates whether PO is classifying this transaction as an
2085: -- Error/Warning/Partial Success/Success
2086: --x_online_report_id

Line 2155: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2151: x_online_report_id => x_online_report_id);
2152:
2153: l_progress := '100';
2154:
2155: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2156: OR x_return_status IS NULL
2157: ) THEN
2158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;

Line 2158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2154:
2155: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2156: OR x_return_status IS NULL
2157: ) THEN
2158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2160:
2161: l_progress := '900';
2162:

Line 2246: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2242: --p_employee_id
2243: -- Employee Id of the user taking the action
2244: --OUT:
2245: --x_return_status
2246: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2247: -- FND_API.G_RET_STS_ERROR if validation fails
2248: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2249: --x_po_return_code
2250: -- Indicates whether PO is classifying this transaction as an

Line 2247: -- FND_API.G_RET_STS_ERROR if validation fails

2243: -- Employee Id of the user taking the action
2244: --OUT:
2245: --x_return_status
2246: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2247: -- FND_API.G_RET_STS_ERROR if validation fails
2248: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2249: --x_po_return_code
2250: -- Indicates whether PO is classifying this transaction as an
2251: -- Error/Warning/Partial Success/Success

Line 2248: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2244: --OUT:
2245: --x_return_status
2246: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2247: -- FND_API.G_RET_STS_ERROR if validation fails
2248: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2249: --x_po_return_code
2250: -- Indicates whether PO is classifying this transaction as an
2251: -- Error/Warning/Partial Success/Success
2252: --x_online_report_id

Line 2325: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2321: x_online_report_id => x_online_report_id);
2322:
2323: l_progress := '100';
2324:
2325: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2326: OR x_return_status IS NULL
2327: ) THEN
2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2329: END IF;

Line 2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2324:
2325: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2326: OR x_return_status IS NULL
2327: ) THEN
2328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2329: END IF;
2330:
2331: l_progress := '900';
2332:

Line 2433: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2429: --OUT:
2430: --x_packet_id
2431: -- GL PACKET ID, if gl entries are made otherwise null
2432: --x_return_status
2433: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2434: -- FND_API.G_RET_STS_ERROR if validation fails
2435: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2436: --Testing:
2437: --

Line 2434: -- FND_API.G_RET_STS_ERROR if validation fails

2430: --x_packet_id
2431: -- GL PACKET ID, if gl entries are made otherwise null
2432: --x_return_status
2433: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2434: -- FND_API.G_RET_STS_ERROR if validation fails
2435: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2436: --Testing:
2437: --
2438: --End of Comments

Line 2435: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2431: -- GL PACKET ID, if gl entries are made otherwise null
2432: --x_return_status
2433: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2434: -- FND_API.G_RET_STS_ERROR if validation fails
2435: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2436: --Testing:
2437: --
2438: --End of Comments
2439: -------------------------------------------------------------------------------

Line 2508: x_return_status := FND_API.G_RET_STS_SUCCESS;

2504: -- return success without doing anything.
2505:
2506: IF (NVL(p_tax_line_flag, g_parameter_NO) = g_parameter_YES) THEN
2507: x_packet_id := NULL;
2508: x_return_status := FND_API.G_RET_STS_SUCCESS;
2509: RETURN;
2510: END IF;
2511:
2512: l_progress := '005';

Line 2544: x_return_status := FND_API.G_RET_STS_SUCCESS;

2540:
2541: IF ((l_amt_based_line_flag = 'N') and (NVL(p_qty_cancelled, 0) = 0))
2542: THEN
2543: x_packet_id := NULL;
2544: x_return_status := FND_API.G_RET_STS_SUCCESS;
2545: RETURN;
2546: END IF;
2547:
2548: l_progress := '008';

Line 2576: x_return_status := FND_API.G_RET_STS_SUCCESS;

2572: ELSE -- p_qty_cancelled = 0, No entries should be created
2573: l_progress := '050';
2574:
2575: x_packet_id := NULL;
2576: x_return_status := FND_API.G_RET_STS_SUCCESS;
2577:
2578: return;
2579: END IF;
2580:

Line 2637: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2633: );
2634:
2635: l_progress := '090';
2636:
2637: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2638: OR x_return_status IS NULL
2639: ) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: END IF;

Line 2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2636:
2637: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2638: OR x_return_status IS NULL
2639: ) THEN
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641: END IF;
2642:
2643: l_progress := '100';
2644:

Line 2709: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2705: -- A table of po_header_ids corresponding to the PAs that we are checking
2706: -- the encumbered state of.
2707: --OUT:
2708: --x_return_status
2709: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2710: -- FND_API.G_RET_STS_ERROR if validation fails
2711: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2712: --x_agreement_encumbered_tbl
2713: -- A table of Y/N results indicating whether each PA is encumbered or not.

Line 2710: -- FND_API.G_RET_STS_ERROR if validation fails

2706: -- the encumbered state of.
2707: --OUT:
2708: --x_return_status
2709: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2710: -- FND_API.G_RET_STS_ERROR if validation fails
2711: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2712: --x_agreement_encumbered_tbl
2713: -- A table of Y/N results indicating whether each PA is encumbered or not.
2714: -- Y = the given PA is/can be encumbered.

Line 2711: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2707: --OUT:
2708: --x_return_status
2709: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2710: -- FND_API.G_RET_STS_ERROR if validation fails
2711: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2712: --x_agreement_encumbered_tbl
2713: -- A table of Y/N results indicating whether each PA is encumbered or not.
2714: -- Y = the given PA is/can be encumbered.
2715: -- N = the PA is not eligible for encumbrance

Line 2838: x_return_status := fnd_api.g_ret_sts_success;

2834: ;
2835:
2836: l_progress := '040';
2837:
2838: x_return_status := fnd_api.g_ret_sts_success;
2839:
2840: l_progress := '900';
2841:
2842: IF g_debug_stmt THEN

Line 2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2848: EXCEPTION
2849: WHEN OTHERS THEN
2850: BEGIN
2851: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853: IF g_debug_stmt THEN
2854: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',x_return_status);
2855: PO_DEBUG.debug_var(l_log_head,l_progress,'x_agreement_encumbered_tbl',x_agreement_encumbered_tbl);
2856: END IF;

Line 2890: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

2886: -- A po_header_id corresponding to the PA that we are checking
2887: -- the encumbered state of.
2888: --OUT:
2889: --x_return_status
2890: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2891: -- FND_API.G_RET_STS_ERROR if validation fails
2892: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2893: --x_agreement_encumbered_flag
2894: -- Indicates whether the PA is encumbered or not.

Line 2891: -- FND_API.G_RET_STS_ERROR if validation fails

2887: -- the encumbered state of.
2888: --OUT:
2889: --x_return_status
2890: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2891: -- FND_API.G_RET_STS_ERROR if validation fails
2892: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2893: --x_agreement_encumbered_flag
2894: -- Indicates whether the PA is encumbered or not.
2895: -- Y = the given PA is/can be encumbered.

Line 2892: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2888: --OUT:
2889: --x_return_status
2890: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
2891: -- FND_API.G_RET_STS_ERROR if validation fails
2892: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2893: --x_agreement_encumbered_flag
2894: -- Indicates whether the PA is encumbered or not.
2895: -- Y = the given PA is/can be encumbered.
2896: -- N = the PA is not eligible for encumbrance

Line 2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: BEGIN
2962: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: ROLLBACK TO IS_AGREEMENT_ENCUMBERED_SP;
2965: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2966: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
2967: END IF;

Line 3041: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

3037: --p_employee_id
3038: -- Employee Id of the user taking the action
3039: --OUT:
3040: --x_return_status
3041: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3042: -- FND_API.G_RET_STS_ERROR if validation fails
3043: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3044: --x_po_return_code
3045: -- Indicates whether PO is classifying this transaction as an

Line 3042: -- FND_API.G_RET_STS_ERROR if validation fails

3038: -- Employee Id of the user taking the action
3039: --OUT:
3040: --x_return_status
3041: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3042: -- FND_API.G_RET_STS_ERROR if validation fails
3043: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3044: --x_po_return_code
3045: -- Indicates whether PO is classifying this transaction as an
3046: -- Error/Warning/Partial Success/Success

Line 3043: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

3039: --OUT:
3040: --x_return_status
3041: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3042: -- FND_API.G_RET_STS_ERROR if validation fails
3043: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3044: --x_po_return_code
3045: -- Indicates whether PO is classifying this transaction as an
3046: -- Error/Warning/Partial Success/Success
3047: --x_online_report_id

Line 3339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3335: p_calling_program =>g_action_RESERVE,
3336: x_return_status => l_return_status);
3337: END IF;
3338:
3339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3340: IF g_debug_stmt THEN
3341: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3342: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||
3343: l_api_name||'.' || l_progress,

Line 3355: x_return_status := FND_API.G_RET_STS_ERROR;

3351: p_message_text => l_exc_message_text,
3352: p_user_id => l_user_id,
3353: x_online_report_id => x_online_report_id
3354: );
3355: x_return_status := FND_API.G_RET_STS_ERROR;
3356: x_po_return_code := g_return_FAILURE;
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: END IF;
3359: END IF;

Line 3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3353: x_online_report_id => x_online_report_id
3354: );
3355: x_return_status := FND_API.G_RET_STS_ERROR;
3356: x_po_return_code := g_return_FAILURE;
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3358: END IF;
3359: END IF;
3360: --
3361: END IF; -- end of check for Reserve action

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422:
3423: IF (l_validation_successful_flag <> g_parameter_YES) THEN
3424: l_progress := '035';
3425: l_exc_code := g_SUBMISSION_CHECK_EXC_CODE;
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429: l_progress := '040';
3430:

Line 3447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3443: , p_cbc_flag => p_cbc_flag
3444: , x_count => l_dist_count
3445: );
3446: EXCEPTION
3447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3448: l_progress := '041';
3449: l_exc_code := G_GET_ALL_DISTS_EXC_CODE;
3450: RAISE;
3451: END;

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454:
3455: IF (NVL(l_dist_count,0) < 1) THEN
3456: l_progress := '045';
3457: l_exc_code := g_NO_ROWS_EXC_CODE;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460:
3461: l_progress := '046';
3462: IF g_debug_stmt THEN

Line 3636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3632: , p_user_resp_id => l_user_resp_id
3633: , x_return_code => l_gl_return_code
3634: );
3635: EXCEPTION
3636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3637: l_progress := '075';
3638: l_exc_code := g_EXECUTE_GL_CALL_EXC_CODE;
3639: RAISE;
3640: END;

Line 3798: x_return_status := FND_API.g_ret_sts_success;

3794: --
3795: PO_ENCUMBRANCE_POSTPROCESSING.populate_bc_report_id(x_online_report_id);
3796: --
3797: IF x_po_return_code IN (g_return_SUCCESS, g_return_WARNING) THEN
3798: x_return_status := FND_API.g_ret_sts_success;
3799: ELSIF x_po_return_code IN (g_return_PARTIAL, g_return_FAILURE) THEN
3800: x_return_status := FND_API.g_ret_sts_error;
3801: ELSE
3802: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3800: x_return_status := FND_API.g_ret_sts_error;

3796: --
3797: IF x_po_return_code IN (g_return_SUCCESS, g_return_WARNING) THEN
3798: x_return_status := FND_API.g_ret_sts_success;
3799: ELSIF x_po_return_code IN (g_return_PARTIAL, g_return_FAILURE) THEN
3800: x_return_status := FND_API.g_ret_sts_error;
3801: ELSE
3802: x_return_status := FND_API.g_ret_sts_unexp_error;
3803: END IF;
3804:

Line 3802: x_return_status := FND_API.g_ret_sts_unexp_error;

3798: x_return_status := FND_API.g_ret_sts_success;
3799: ELSIF x_po_return_code IN (g_return_PARTIAL, g_return_FAILURE) THEN
3800: x_return_status := FND_API.g_ret_sts_error;
3801: ELSE
3802: x_return_status := FND_API.g_ret_sts_unexp_error;
3803: END IF;
3804:
3805: -- Push the po_return_msg onto api msg list
3806: -- Bug 3516763: No longer put a message on the message dictionary stack.

Line 3834: x_return_status := FND_API.G_RET_STS_SUCCESS;

3830: -- Set the return statuses.
3831: --
3832:
3833: IF (l_exc_code = g_NO_ROWS_EXC_CODE) THEN
3834: x_return_status := FND_API.G_RET_STS_SUCCESS;
3835: x_po_return_code := g_return_SUCCESS;
3836: l_po_return_msg_name := 'PO_ENC_API_SUCCESS';
3837: ELSIF (l_exc_code = g_SUBMISSION_CHECK_EXC_CODE) THEN
3838: x_return_status := FND_API.g_ret_sts_error;

Line 3838: x_return_status := FND_API.g_ret_sts_error;

3834: x_return_status := FND_API.G_RET_STS_SUCCESS;
3835: x_po_return_code := g_return_SUCCESS;
3836: l_po_return_msg_name := 'PO_ENC_API_SUCCESS';
3837: ELSIF (l_exc_code = g_SUBMISSION_CHECK_EXC_CODE) THEN
3838: x_return_status := FND_API.g_ret_sts_error;
3839: x_po_return_code := g_return_FAILURE;
3840: l_po_return_msg_name := 'PO_ENC_API_FAILURE';
3841: ELSE
3842: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3842: x_return_status := FND_API.g_ret_sts_unexp_error;

3838: x_return_status := FND_API.g_ret_sts_error;
3839: x_po_return_code := g_return_FAILURE;
3840: l_po_return_msg_name := 'PO_ENC_API_FAILURE';
3841: ELSE
3842: x_return_status := FND_API.g_ret_sts_unexp_error;
3843: x_po_return_code := g_return_FATAL;
3844: l_po_return_msg_name := 'PO_ENC_API_FAILURE';
3845: END IF;
3846:

Line 3883: , p_encoded => FND_API.G_FALSE

3879: -- Retrieve that message.
3880: l_exc_message_text :=
3881: FND_MSG_PUB.get(
3882: p_msg_index => FND_MSG_PUB.G_LAST
3883: , p_encoded => FND_API.G_FALSE
3884: );
3885:
3886: ELSE
3887: -- Unrecognized exception.

Line 3952: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

3948: -- Warning and Error rows are always included.
3949: -- Values: g_parameter_YES, g_parameter_NO
3950: --OUT:
3951: --x_return_status
3952: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3953: -- FND_API.G_RET_STS_ERROR if validation fails
3954: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3955: --x_report_object
3956: -- Object of po_fcout_type

Line 3953: -- FND_API.G_RET_STS_ERROR if validation fails

3949: -- Values: g_parameter_YES, g_parameter_NO
3950: --OUT:
3951: --x_return_status
3952: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3953: -- FND_API.G_RET_STS_ERROR if validation fails
3954: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3955: --x_report_object
3956: -- Object of po_fcout_type
3957: --Testing:

Line 3954: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

3950: --OUT:
3951: --x_return_status
3952: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
3953: -- FND_API.G_RET_STS_ERROR if validation fails
3954: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
3955: --x_report_object
3956: -- Object of po_fcout_type
3957: --Testing:
3958: --

Line 4025: x_return_status := FND_API.g_ret_sts_success;

4021: )
4022: ;
4023:
4024: l_progress := '020';
4025: x_return_status := FND_API.g_ret_sts_success;
4026:
4027: IF g_debug_stmt THEN
4028: PO_DEBUG.debug_end(l_log_head);
4029: PO_DEBUG.debug_var(l_log_head,l_progress,'x_return_status',

Line 4038: x_return_status := FND_API.g_ret_sts_unexp_error;

4034: WHEN OTHERS THEN
4035: BEGIN
4036: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
4037: --unexpected error from this procedure
4038: x_return_status := FND_API.g_ret_sts_unexp_error;
4039: --add message to the stack and log a debug msg if necessary
4040: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
4041: fnd_msg_pub.add;
4042: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');

Line 4083: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

4079: -- The id corresponding to the doc level type:
4080: -- header_id/release_id, line_id, line_location_id, distribution_id
4081: --OUT:
4082: --x_return_status
4083: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4084: -- FND_API.G_RET_STS_ERROR if validation fails
4085: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4086: --x_reservable_flag
4087: -- Indicates whether funds reservation is possible on this doc level

Line 4084: -- FND_API.G_RET_STS_ERROR if validation fails

4080: -- header_id/release_id, line_id, line_location_id, distribution_id
4081: --OUT:
4082: --x_return_status
4083: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4084: -- FND_API.G_RET_STS_ERROR if validation fails
4085: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4086: --x_reservable_flag
4087: -- Indicates whether funds reservation is possible on this doc level
4088: -- 'Y' means it is possible, 'N' means it isn't.

Line 4085: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

4081: --OUT:
4082: --x_return_status
4083: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4084: -- FND_API.G_RET_STS_ERROR if validation fails
4085: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4086: --x_reservable_flag
4087: -- Indicates whether funds reservation is possible on this doc level
4088: -- 'Y' means it is possible, 'N' means it isn't.
4089: --Testing:

Line 4134: x_return_status := fnd_api.g_ret_sts_success;

4130: x_action_possible_flag => x_reservable_flag);
4131:
4132: l_progress := '100';
4133:
4134: x_return_status := fnd_api.g_ret_sts_success;
4135:
4136: l_progress := '900';
4137:
4138: IF g_debug_stmt THEN

Line 4148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4144: EXCEPTION
4145: WHEN OTHERS THEN
4146: BEGIN
4147: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
4148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4149: ROLLBACK TO IS_RESERVABLE_SP;
4150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4151: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4152: END IF;

Line 4194: -- FND_API.G_RET_STS_SUCCESS if validation succeeds

4190: -- The id corresponding to the doc level type:
4191: -- header_id/release_id, line_id, line_location_id, distribution_id
4192: --OUT:
4193: --x_return_status
4194: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4195: -- FND_API.G_RET_STS_ERROR if validation fails
4196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4197: --x_unreservable_flag
4198: -- Indicates whether funds unreservation is possible on this doc level

Line 4195: -- FND_API.G_RET_STS_ERROR if validation fails

4191: -- header_id/release_id, line_id, line_location_id, distribution_id
4192: --OUT:
4193: --x_return_status
4194: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4195: -- FND_API.G_RET_STS_ERROR if validation fails
4196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4197: --x_unreservable_flag
4198: -- Indicates whether funds unreservation is possible on this doc level
4199: -- 'Y' means it is possible, 'N' means it isn't.

Line 4196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

4192: --OUT:
4193: --x_return_status
4194: -- FND_API.G_RET_STS_SUCCESS if validation succeeds
4195: -- FND_API.G_RET_STS_ERROR if validation fails
4196: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
4197: --x_unreservable_flag
4198: -- Indicates whether funds unreservation is possible on this doc level
4199: -- 'Y' means it is possible, 'N' means it isn't.
4200: --Testing:

Line 4245: x_return_status := fnd_api.g_ret_sts_success;

4241: x_action_possible_flag => x_unreservable_flag);
4242:
4243: l_progress := '100';
4244:
4245: x_return_status := fnd_api.g_ret_sts_success;
4246:
4247: l_progress := '900';
4248:
4249: IF g_debug_stmt THEN

Line 4259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4255: EXCEPTION
4256: WHEN OTHERS THEN
4257: BEGIN
4258: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
4259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4260: ROLLBACK TO IS_UNRESERVABLE_SP;
4261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4262: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
4263: END IF;

Line 4358: x_return_status := FND_API.G_RET_STS_SUCCESS;

4354:
4355: BEGIN
4356:
4357: SAVEPOINT populate_encumbrance_gt_PVT;
4358: x_return_status := FND_API.G_RET_STS_SUCCESS;
4359:
4360: IF g_debug_stmt THEN
4361: PO_DEBUG.debug_begin(l_log_head);
4362: PO_DEBUG.debug_var(l_log_head,l_progress,'p_doc_type', p_doc_type);

Line 4690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4686: EXCEPTION
4687: WHEN OTHERS THEN
4688: BEGIN
4689: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
4690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4691: ROLLBACK TO populate_encumbrance_gt_PVT;
4692: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS End');
4693: EXCEPTION
4694: WHEN OTHERS THEN

Line 4785: x_return_status := FND_API.G_RET_STS_SUCCESS;

4781:
4782: l_progress := '020';
4783:
4784: -- Initialize API return status to success
4785: x_return_status := FND_API.G_RET_STS_SUCCESS;
4786:
4787: l_progress := '100';
4788:
4789: -- Clear the existing data from the encumbrance table.

Line 4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4833: EXCEPTION
4834: WHEN OTHERS THEN
4835: BEGIN
4836: PO_DEBUG.debug_unexp(l_log_head,l_progress,'OTHERS Start');
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4838: ROLLBACK TO POPULATE_ENC_GT_ACTION_IDS_PVT;
4839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4840: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name,SQLERRM);
4841: END IF;

Line 4874: -- Will be set to FND_API.g_ret_sts_unexp_error.

4870: -- The location in the procedure at which the exception occurred.
4871: --OUT:
4872: --x_return_status
4873: -- VARCHAR2(1)
4874: -- Will be set to FND_API.g_ret_sts_unexp_error.
4875: --x_po_return_code
4876: -- VARCHAR2(10)
4877: -- Will be set to g_return_FATAL.
4878: --Notes:

Line 4910: x_return_status := FND_API.g_ret_sts_unexp_error;

4906:
4907:
4908: -- 1. Set the API return statuses to indicate a failure.
4909:
4910: x_return_status := FND_API.g_ret_sts_unexp_error;
4911: x_po_return_code := g_return_FATAL;
4912:
4913: l_progress := '100';
4914:

Line 5014: x_return_status := FND_API.G_RET_STS_SUCCESS;

5010: )
5011: IS
5012: l_api_name CONSTANT varchar2(30) := 'POPULATE_BC_REPORT_EVENTS';
5013: BEGIN
5014: x_return_status := FND_API.G_RET_STS_SUCCESS;
5015:
5016: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
5017: --
5018: --Going forward we would populate the events and distribution ids

Line 5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5039: EXCEPTION
5040: WHEN OTHERS THEN
5041: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
5042: p_proc_name => l_api_name);
5043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5044: END POPULATE_BC_REPORT_EVENTS;
5045:
5046: -------------------------------------------------------------------------------
5047: --Start of Comments

Line 5069: -- FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_UNEXP_ERROR

5065: --IN OUT:
5066: -- None.
5067: --OUT:
5068: -- x_return_status : overall status of the procedure - i.e.
5069: -- FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_UNEXP_ERROR
5070: -- x_report_created : 'Y'/'N' to indicate whether the report was created
5071: -- successfully
5072: --Notes:
5073: --Testing:

Line 5095: x_return_status := FND_API.G_RET_STS_SUCCESS;

5091: l_application_id NUMBER := 201; -- PO
5092: l_return_status VARCHAR2(1);
5093: l_progress VARCHAR2(3) := '000';
5094: BEGIN
5095: x_return_status := FND_API.G_RET_STS_SUCCESS;
5096: x_report_created := 'N';
5097: --
5098: PO_DOCUMENT_FUNDS_PVT.g_ONLINE_REPORT_ID:=p_online_report_id;
5099: --

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

5103: p_online_report_id => p_online_report_id,
5104: x_events_populated => l_events_populated
5105: );
5106:
5107: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END IF;
5110: --
5111: --If events haven't been populated we needto look into po_online_report_text

Line 5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5104: x_events_populated => l_events_populated
5105: );
5106:
5107: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END IF;
5110: --
5111: --If events haven't been populated we needto look into po_online_report_text
5112: -- to figure out if any of the rows in it are marked as show in psa.

Line 5171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5167: WHEN OTHERS THEN
5168: PO_DEBUG.handle_unexp_error ( p_pkg_name => g_pkg_name,
5169: p_proc_name => l_api_name,
5170: p_progress => l_progress );
5171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5172: END POPULATE_AND_CREATE_BC_REPORT;
5173: --
5174:
5175: --