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

Line 308: -- FND_API.G_RET_STS_ERROR - for expected error

304: -- None
305: --OUT:
306: --x_return_status
307: -- The standard OUT parameter giving return status of the API call.
308: -- FND_API.G_RET_STS_ERROR - for expected error
309: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
310: -- FND_API.G_RET_STS_SUCCESS - for success
311: --Notes:
312: -- None

Line 309: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

305: --OUT:
306: --x_return_status
307: -- The standard OUT parameter giving return status of the API call.
308: -- FND_API.G_RET_STS_ERROR - for expected error
309: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
310: -- FND_API.G_RET_STS_SUCCESS - for success
311: --Notes:
312: -- None
313: --Testing:

Line 310: -- FND_API.G_RET_STS_SUCCESS - for success

306: --x_return_status
307: -- The standard OUT parameter giving return status of the API call.
308: -- FND_API.G_RET_STS_ERROR - for expected error
309: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
310: -- FND_API.G_RET_STS_SUCCESS - for success
311: --Notes:
312: -- None
313: --Testing:
314: -- None

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: l_vs_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
329:
330: BEGIN
331: -- Initialize API return status to success
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: --Default all the required default po parameters from the financial system
335: --parameters,Po_system_parameters, receiving options and gl set of books.
336: --Using the procedure po_core_s.get_po_parameters

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: g_cpa_csr.confirming_order_flag := 'N';
540: g_cpa_csr.frozen_flag := 'N';
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: g_progress := '210';
546: IF g_debug_stmt THEN
547: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: g_cpa_csr.frozen_flag := 'N';
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: g_progress := '210';
546: IF g_debug_stmt THEN
547: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
548: p_token => g_progress,

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

547: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
548: p_token => g_progress,
549: p_message => 'Expected Error');
550: END IF;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: g_progress := '211';
554: IF g_debug_unexp THEN
555: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: p_token => g_progress,
549: p_message => 'Expected Error');
550: END IF;
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: g_progress := '211';
554: IF g_debug_unexp THEN
555: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
556: p_token => g_progress,

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: p_token => g_progress,
557: p_message => 'Unexpected Error');
558: END IF;
559: WHEN OTHERS THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: g_progress := '212';
562: IF g_debug_unexp THEN
563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
564: p_token => g_progress,

Line 590: -- FND_API.G_RET_STS_ERROR - for expected error

586: -- None
587: --OUT:
588: --x_return_status
589: -- The standard OUT parameter giving return status of the API call.
590: -- FND_API.G_RET_STS_ERROR - for expected error
591: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
592: -- FND_API.G_RET_STS_SUCCESS - for success
593: --Notes:
594: -- None

Line 591: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

587: --OUT:
588: --x_return_status
589: -- The standard OUT parameter giving return status of the API call.
590: -- FND_API.G_RET_STS_ERROR - for expected error
591: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
592: -- FND_API.G_RET_STS_SUCCESS - for success
593: --Notes:
594: -- None
595: --Testing:

Line 592: -- FND_API.G_RET_STS_SUCCESS - for success

588: --x_return_status
589: -- The standard OUT parameter giving return status of the API call.
590: -- FND_API.G_RET_STS_ERROR - for expected error
591: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
592: -- FND_API.G_RET_STS_SUCCESS - for success
593: --Notes:
594: -- None
595: --Testing:
596: -- None

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

607: l_freight_carrier ORG_FREIGHT.freight_code%TYPE;
608: l_terms_id AP_TERMS.term_id%TYPE;
609: BEGIN
610: -- Initialize API return status to success
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: -- validate document number
614: IF g_cpa_csr.document_num IS NOT NULL THEN
615: IF g_cpa_csr.document_num <> 'CPA 11.5.10+' THEN

Line 648: RAISE FND_API.G_EXC_ERROR;

644: Fnd_message.set_token( token => 'VALUE'
645: , VALUE => g_cpa_csr.document_num);
646: FND_MSG_PUB.Add;
647:
648: RAISE FND_API.G_EXC_ERROR;
649:
650: ELSIF (l_error_code = 'PO_PDOI_VALUE_NUMERIC') THEN
651: g_progress := '303';
652: IF g_debug_stmt THEN

Line 663: RAISE FND_API.G_EXC_ERROR;

659: , VALUE => 'Document Number');
660: Fnd_message.set_token( token => 'VALUE'
661: , VALUE => g_cpa_csr.document_num);
662: FND_MSG_PUB.Add;
663: RAISE FND_API.G_EXC_ERROR;
664: ELSIF (l_error_code = 'PO_PDOI_LT_ZERO') THEN
665: g_progress := '304';
666: IF g_debug_stmt THEN
667: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 677: RAISE FND_API.G_EXC_ERROR;

673: , VALUE => 'Document Number');
674: Fnd_message.set_token( token => 'VALUE'
675: , VALUE => g_cpa_csr.document_num);
676: FND_MSG_PUB.Add;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679: END IF; -- If is_valid = FALSE
680: END IF; -- End of IF g_cpa_csr.document_num <> 'CPA 11.5.10+'
681: ELSE

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: Fnd_message.set_name('PO','PO_PDOI_COLUMN_NOT_NULL');
691: Fnd_message.set_token( token => 'COLUMN_NAME'
692: , VALUE => 'Document Number');
693: FND_MSG_PUB.Add;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF; -- End of IF g_cpa_csr.document_num IS NOT NULL
696:
697: -- Validate ship_to_location
698: IF g_cpa_csr.ship_to_location_id IS NOT NULL THEN

Line 756: WHEN FND_API.G_EXC_ERROR THEN

752: g_cpa_csr.bill_to_location_id := NULL;
753: END IF;
754: END IF; -- End of validate bill_to_location
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: g_progress := '320';
759: IF g_debug_stmt THEN
760: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 757: x_return_status := FND_API.G_RET_STS_ERROR;

753: END IF;
754: END IF; -- End of validate bill_to_location
755: EXCEPTION
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: g_progress := '320';
759: IF g_debug_stmt THEN
760: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
761: p_token => g_progress,

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
761: p_token => g_progress,
762: p_message => 'Expected Error');
763: END IF;
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: g_progress := '321';
767: IF g_debug_unexp THEN
768: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

761: p_token => g_progress,
762: p_message => 'Expected Error');
763: END IF;
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: g_progress := '321';
767: IF g_debug_unexp THEN
768: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
769: p_token => g_progress,

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769: p_token => g_progress,
770: p_message => 'Unexpected Error');
771: END IF;
772: WHEN OTHERS THEN
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: g_progress := '322';
775: IF g_debug_unexp THEN
776: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
777: p_token => g_progress,

Line 817: -- FND_API.G_RET_STS_ERROR - for expected error

813: --x_document_number
814: -- The document number that would uniquely identify a document in a given organization.
815: --x_return_status
816: -- The standard OUT parameter giving return status of the API call.
817: -- FND_API.G_RET_STS_ERROR - for expected error
818: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
819: -- FND_API.G_RET_STS_SUCCESS - for success
820: --Notes:
821: -- None

Line 818: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

814: -- The document number that would uniquely identify a document in a given organization.
815: --x_return_status
816: -- The standard OUT parameter giving return status of the API call.
817: -- FND_API.G_RET_STS_ERROR - for expected error
818: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
819: -- FND_API.G_RET_STS_SUCCESS - for success
820: --Notes:
821: -- None
822: --Testing:

Line 819: -- FND_API.G_RET_STS_SUCCESS - for success

815: --x_return_status
816: -- The standard OUT parameter giving return status of the API call.
817: -- FND_API.G_RET_STS_ERROR - for expected error
818: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
819: -- FND_API.G_RET_STS_SUCCESS - for success
820: --Notes:
821: -- None
822: --Testing:
823: -- None

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

849: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_CPA';
850: BEGIN
851:
852: -- Initialize API return status to success
853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854:
855: x_document_num := g_cpa_csr.document_num;
856: x_document_number := g_cpa_csr.document_num;
857:

Line 1026: p_init_msg_list => FND_API.g_true,

1022: p_message => 'Before calling PO_GA_ORG_ASSIGN_PVT.Insert_Row');
1023: END IF;
1024:
1025: PO_GA_ORG_ASSIGN_PVT.insert_row(
1026: p_init_msg_list => FND_API.g_true,
1027: x_return_status => l_return_status,
1028: p_org_assign_rec => l_org_assign_rec,
1029: x_row_id => l_org_row_id);
1030: g_progress := '403';

Line 1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1033: p_token => g_progress,
1034: p_message => 'After calling PO_GA_ORG_ASSIGN_PVT.Insert_Row');
1035: END IF;
1036:
1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1034: p_message => 'After calling PO_GA_ORG_ASSIGN_PVT.Insert_Row');
1035: END IF;
1036:
1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;

Line 1039: RAISE FND_API.G_EXC_ERROR;

1035: END IF;
1036:
1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043: END IF;

Line 1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1036:
1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043: END IF;
1044:

Line 1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE FND_API.G_EXC_ERROR;
1040: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042: END IF;
1043: END IF;
1044:
1045: END IF;

Line 1283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1279: p_token => g_progress,
1280: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'||l_return_status);
1281: END IF;
1282:
1283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1284: RAISE l_Contracts_call_exception;
1285: END IF; -- Return status from contracts
1286:
1287: END IF; -- if p_conterms_exist_flag = Y

Line 1291: x_return_status := FND_API.G_RET_STS_ERROR;

1287: END IF; -- if p_conterms_exist_flag = Y
1288: EXCEPTION
1289: WHEN l_Contracts_call_exception then
1290: g_progress := '416';
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292:
1293: -- put error messages in log
1294: IF g_debug_stmt THEN
1295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1311: p_message => FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F'));
1312: END LOOP;
1313: END IF;
1314: WHEN OTHERS THEN
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: g_progress := '417';
1317: IF g_debug_unexp THEN
1318: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1319: p_token => g_progress,

Line 1361: -- FND_API.G_RET_STS_ERROR - for expected error

1357: --x_document_number
1358: -- The document number that would uniquely identify a document in a given organization.
1359: --x_return_status
1360: -- The standard OUT parameter giving return status of the API call.
1361: -- FND_API.G_RET_STS_ERROR - for expected error
1362: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1363: -- FND_API.G_RET_STS_SUCCESS - for success
1364: --Notes:
1365: -- None

Line 1362: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

1358: -- The document number that would uniquely identify a document in a given organization.
1359: --x_return_status
1360: -- The standard OUT parameter giving return status of the API call.
1361: -- FND_API.G_RET_STS_ERROR - for expected error
1362: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1363: -- FND_API.G_RET_STS_SUCCESS - for success
1364: --Notes:
1365: -- None
1366: --Testing:

Line 1363: -- FND_API.G_RET_STS_SUCCESS - for success

1359: --x_return_status
1360: -- The standard OUT parameter giving return status of the API call.
1361: -- FND_API.G_RET_STS_ERROR - for expected error
1362: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1363: -- FND_API.G_RET_STS_SUCCESS - for success
1364: --Notes:
1365: -- None
1366: --Testing:
1367: -- None

Line 1391: x_return_status := FND_API.G_RET_STS_SUCCESS;

1387: l_document_subtype PO_HEADERS_INTERFACE.document_subtype%TYPE;
1388: l_action PO_HEADERS_INTERFACE.action%TYPE;
1389: BEGIN
1390: -- Initialize API return status to success
1391: x_return_status := FND_API.G_RET_STS_SUCCESS;
1392:
1393: g_progress:='500';
1394: IF g_interface_cursor%ISOPEN THEN
1395: CLOSE g_interface_cursor;

Line 1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1406: p_message => 'PO_ALL_NO_DRILLDOWN: '||SQLERRM);
1407: END IF;
1408: Fnd_message.set_name('PO','PO_ALL_NO_DRILLDOWN');
1409: FND_MSG_PUB.Add;
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: l_document_type := g_cpa_csr.document_type_code;
1414: l_document_subtype := g_cpa_csr.document_subtype;

Line 1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1433: p_token => g_progress,
1434: p_message => 'After calling po_sourcing_pvt.default_cpa');
1435: END IF;
1436:
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1434: p_message => 'After calling po_sourcing_pvt.default_cpa');
1435: END IF;
1436:
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;

Line 1439: RAISE FND_API.G_EXC_ERROR;

1435: END IF;
1436:
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443: END IF;

Line 1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1436:
1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443: END IF;
1444:

Line 1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443: END IF;
1444:
1445: -- Validate the required fields in the record

Line 1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1460: p_token => g_progress,
1461: p_message => 'After calling po_sourcing_pvt.validate_cpa');
1462: END IF;
1463:
1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1461: p_message => 'After calling po_sourcing_pvt.validate_cpa');
1462: END IF;
1463:
1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;

Line 1466: RAISE FND_API.G_EXC_ERROR;

1462: END IF;
1463:
1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: END IF;

Line 1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1463:
1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: END IF;
1471:

Line 1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: END IF;
1471:
1472: -- Insert record in the po_headers table and add attachments and contract terms

Line 1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1494: p_token => g_progress,
1495: p_message => 'After calling po_sourcing_pvt.insert_cpa');
1496: END IF;
1497:
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1495: p_message => 'After calling po_sourcing_pvt.insert_cpa');
1496: END IF;
1497:
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;

Line 1500: RAISE FND_API.G_EXC_ERROR;

1496: END IF;
1497:
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504: END IF;

Line 1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1497:
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504: END IF;
1505:

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500: RAISE FND_API.G_EXC_ERROR;
1501: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504: END IF;
1505:
1506: ELSE

Line 1517: RAISE FND_API.G_EXC_ERROR;

1513: Fnd_message.set_name('PO','PO_PDOI_INVALID_ACTION');
1514: Fnd_message.set_token( token => 'VALUE'
1515: , VALUE => g_cpa_csr.action);
1516: FND_MSG_PUB.Add;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF; -- End of l_action = 'NEW'
1519: ELSE
1520: g_progress := '508';
1521: IF g_debug_stmt THEN

Line 1533: RAISE FND_API.G_EXC_ERROR;

1529: Fnd_message.set_token( token => 'VALUE'
1530: , VALUE => 'CONTRACT');
1531: FND_MSG_PUB.Add;
1532:
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF; -- End of l_document_type = 'CONTRACT'
1535: EXCEPTION
1536: WHEN FND_API.G_EXC_ERROR THEN
1537: x_document_number := NULL;

Line 1536: WHEN FND_API.G_EXC_ERROR THEN

1532:
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF; -- End of l_document_type = 'CONTRACT'
1535: EXCEPTION
1536: WHEN FND_API.G_EXC_ERROR THEN
1537: x_document_number := NULL;
1538: x_document_id := NULL;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: g_progress := '510';

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: EXCEPTION
1536: WHEN FND_API.G_EXC_ERROR THEN
1537: x_document_number := NULL;
1538: x_document_id := NULL;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: g_progress := '510';
1541: IF g_debug_stmt THEN
1542: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1543: p_token => g_progress,

Line 1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1543: p_token => g_progress,
1544: p_message => 'Expected Error');
1545: END IF;
1546:
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: x_document_number := NULL;
1549: x_document_id := NULL;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: g_progress := '511';

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1546:
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: x_document_number := NULL;
1549: x_document_id := NULL;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: g_progress := '511';
1552: IF g_debug_unexp THEN
1553: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1554: p_token => g_progress,

Line 1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1556: END IF;
1557: WHEN OTHERS THEN
1558: x_document_number := NULL;
1559: x_document_id := NULL;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: g_progress := '512';
1562: IF g_debug_unexp THEN
1563: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1564: p_token => g_progress,

Line 1593: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error

1589: -- The id that will be used to uniquely identify a row in the PO_HEADERS_INTERFACE table
1590: --OUT:
1591: --x_return_status
1592: -- The standard OUT parameter giving return status of the API call.
1593: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1594: -- FND_API.G_RET_STS_SUCCESS - for success
1595: --Notes:
1596: -- None
1597: --Testing:

Line 1594: -- FND_API.G_RET_STS_SUCCESS - for success

1590: --OUT:
1591: --x_return_status
1592: -- The standard OUT parameter giving return status of the API call.
1593: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected error
1594: -- FND_API.G_RET_STS_SUCCESS - for success
1595: --Notes:
1596: -- None
1597: --Testing:
1598: -- None

Line 1609: x_return_status := FND_API.G_RET_STS_SUCCESS;

1605: ) IS
1606: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_INTERFACE_HEADER';
1607: BEGIN
1608: -- Initialize API return status to success
1609: x_return_status := FND_API.G_RET_STS_SUCCESS;
1610:
1611: DELETE po_headers_interface
1612: WHERE interface_header_id = p_interface_header_id;
1613:

Line 1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1618: p_message => 'No of Records deleted from PO_HEADERS_INTERFACE'||SQL%rowcount);
1619: END IF;
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: g_progress := '601';
1624: IF g_debug_unexp THEN
1625: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
1626: p_token => g_progress,