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

Line 647: -- FND_API.g_ret_sts_success - if the procedure completed successfully

643: --p_valid_org_id
644: -- The org ID of the OU where this item is already valid (e.g. GA owning org)
645: --OUT:
646: --x_return_status
647: -- FND_API.g_ret_sts_success - if the procedure completed successfully
648: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
649: --x_is_purchasable
650: -- TRUE if the item master item in the Financial Options Inventory Organization
651: -- of p_org_id is defined as 'purchasable', or if this is a one-time item, or

Line 648: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

644: -- The org ID of the OU where this item is already valid (e.g. GA owning org)
645: --OUT:
646: --x_return_status
647: -- FND_API.g_ret_sts_success - if the procedure completed successfully
648: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
649: --x_is_purchasable
650: -- TRUE if the item master item in the Financial Options Inventory Organization
651: -- of p_org_id is defined as 'purchasable', or if this is a one-time item, or
652: -- p_org_id equals p_valid_org_id.

Line 682: x_return_status := FND_API.g_ret_sts_success;

678: l_progress VARCHAR2(3);
679:
680: BEGIN
681: l_progress := '000';
682: x_return_status := FND_API.g_ret_sts_success;
683:
684: IF g_debug_stmt THEN
685: PO_DEBUG.debug_stmt
686: (p_log_head => g_module_prefix||'validate_item',

Line 761: x_return_status := FND_API.g_ret_sts_unexp_error;

757: x_is_purchasable := FALSE;
758: x_is_same_uom_class := FALSE;
759: x_is_not_osp_item := FALSE;
760: WHEN OTHERS THEN
761: x_return_status := FND_API.g_ret_sts_unexp_error;
762: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
763: p_procedure_name => 'validate_item',
764: p_error_text => 'Progress: '||l_progress||
765: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 1047: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN

1043: p_automatically_added_flag => 'Y',
1044: x_return_status => l_api_return_status,
1045: x_msg_data => l_api_msg_data);
1046:
1047: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
1048: x_msg_data := l_api_msg_data;
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1051: x_msg_data := l_api_msg_data;

Line 1049: RAISE FND_API.G_EXC_ERROR;

1045: x_msg_data => l_api_msg_data);
1046:
1047: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
1048: x_msg_data := l_api_msg_data;
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1051: x_msg_data := l_api_msg_data;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;

Line 1050: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1046:
1047: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
1048: x_msg_data := l_api_msg_data;
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1051: x_msg_data := l_api_msg_data;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;
1054:

Line 1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1048: x_msg_data := l_api_msg_data;
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1051: x_msg_data := l_api_msg_data;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: END IF;
1054:
1055: END IF; --references a GA
1056:

Line 1057: x_return_status := FND_API.G_RET_STS_SUCCESS;

1053: END IF;
1054:
1055: END IF; --references a GA
1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: WHEN OTHERS THEN

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: WHEN OTHERS THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1062: WHEN FND_API.G_EXC_ERROR THEN

1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: WHEN OTHERS THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1066: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059: EXCEPTION
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: WHEN FND_API.G_EXC_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: WHEN OTHERS THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1066: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1067: END IF;

Line 1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1067: END IF;
1068:
1069: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1070: p_encoded => 'F');
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072:
1073: END sync_ga_line_attachments;
1074:
1075: --=============================================================================

Line 1089: -- RETURNS : x_return_status - values FND_API.G_RET_STS_SUCCESS

1085: -- copy of attachments.
1086: --
1087: -- PARAMETERS : -
1088: --
1089: -- RETURNS : x_return_status - values FND_API.G_RET_STS_SUCCESS
1090: -- FND_API.G_RET_STS_ERROR
1091: -- FND_API.G_RET_STS_UNEXP_ERROR
1092: -- x_msg_data in case of failure
1093: ---

Line 1090: -- FND_API.G_RET_STS_ERROR

1086: --
1087: -- PARAMETERS : -
1088: --
1089: -- RETURNS : x_return_status - values FND_API.G_RET_STS_SUCCESS
1090: -- FND_API.G_RET_STS_ERROR
1091: -- FND_API.G_RET_STS_UNEXP_ERROR
1092: -- x_msg_data in case of failure
1093: ---
1094: -- EXCEPTIONS : -

Line 1091: -- FND_API.G_RET_STS_UNEXP_ERROR

1087: -- PARAMETERS : -
1088: --
1089: -- RETURNS : x_return_status - values FND_API.G_RET_STS_SUCCESS
1090: -- FND_API.G_RET_STS_ERROR
1091: -- FND_API.G_RET_STS_UNEXP_ERROR
1092: -- x_msg_data in case of failure
1093: ---
1094: -- EXCEPTIONS : -
1095: --==========================================================================

Line 1120: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1116: l_api_version CONSTANT NUMBER := 1.0;
1117:
1118: BEGIN
1119: -- Standard call to check for call compatibility
1120: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1121: THEN
1122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1123: END IF;
1124:

Line 1122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1118: BEGIN
1119: -- Standard call to check for call compatibility
1120: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1121: THEN
1122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1123: END IF;
1124:
1125: --Insert new records in fnd_attached_documents table to create
1126: --reference from p_from_entity_name to p_to_entity_name

Line 1229: x_return_status := FND_API.G_RET_STS_SUCCESS;

1225: OR (fd.security_type = 4)
1226: );
1227: --
1228:
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1228:
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1234: p_encoded => 'F');
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: WHEN FND_API.G_EXC_ERROR THEN

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1234: p_encoded => 'F');
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1238: p_encoded => 'F');
1239: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1236: WHEN FND_API.G_EXC_ERROR THEN

1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1234: p_encoded => 'F');
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1238: p_encoded => 'F');
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: WHEN OTHERS THEN

Line 1239: x_return_status := FND_API.G_RET_STS_ERROR;

1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1238: p_encoded => 'F');
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: WHEN OTHERS THEN
1241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1242: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
1243: END IF;

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1243: END IF;
1244:
1245: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1246: p_encoded => 'F');
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248:
1249: END reference_attachments;
1250: --
1251:

Line 1266: -- RETURNS : x_result : FND_API.G_TRUE if enabled,

1262: -- enabled given a vendor site
1263: --
1264: -- PARAMETERS : p_po_header_id - GC header_id
1265: -- p_vendor_site_id - target site
1266: -- RETURNS : x_result : FND_API.G_TRUE if enabled,
1267: -- FND_API.G_FALSE otherwise
1268: ---
1269: -- EXCEPTIONS : -
1270: --==========================================================================

Line 1267: -- FND_API.G_FALSE otherwise

1263: --
1264: -- PARAMETERS : p_po_header_id - GC header_id
1265: -- p_vendor_site_id - target site
1266: -- RETURNS : x_result : FND_API.G_TRUE if enabled,
1267: -- FND_API.G_FALSE otherwise
1268: ---
1269: -- EXCEPTIONS : -
1270: --==========================================================================
1271:

Line 1293: x_result := FND_API.G_TRUE;

1289: AND PGOA.vendor_site_id = p_vendor_site_id
1290: AND PGOA.enabled_flag = 'Y');
1291:
1292: IF (l_is_enabled = 'Y') THEN
1293: x_result := FND_API.G_TRUE;
1294: ELSE
1295: x_result := FND_API.G_FALSE;
1296: END IF;
1297:

Line 1295: x_result := FND_API.G_FALSE;

1291:
1292: IF (l_is_enabled = 'Y') THEN
1293: x_result := FND_API.G_TRUE;
1294: ELSE
1295: x_result := FND_API.G_FALSE;
1296: END IF;
1297:
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN

Line 1300: x_result := FND_API.G_FALSE;

1296: END IF;
1297:
1298: EXCEPTION
1299: WHEN NO_DATA_FOUND THEN
1300: x_result := FND_API.G_FALSE;
1301: END is_purchasing_site_on_ga;
1302:
1303:
1304: --=============================================================================

Line 1430: -- FND_API.g_ret_sts_success - if the procedure completed successfully

1426: -- If TRUE, then the revision control property of the item in p_org_id will be
1427: -- used during validation. If FALSE, then it will not be used.
1428: --OUT:
1429: --x_return_status
1430: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1431: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1432: --x_is_valid
1433: -- TRUE if:
1434: -- - p_item_id is a one-time item

Line 1431: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

1427: -- used during validation. If FALSE, then it will not be used.
1428: --OUT:
1429: --x_return_status
1430: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1431: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1432: --x_is_valid
1433: -- TRUE if:
1434: -- - p_item_id is a one-time item
1435: -- OR

Line 1469: x_return_status := FND_API.g_ret_sts_success;

1465: l_progress VARCHAR2(3);
1466:
1467: BEGIN
1468: l_progress := '000';
1469: x_return_status := FND_API.g_ret_sts_success;
1470:
1471: IF g_debug_stmt THEN
1472: PO_DEBUG.debug_stmt
1473: (p_log_head => g_module_prefix||'validate_item_revision',

Line 1561: x_return_status := FND_API.g_ret_sts_unexp_error;

1557: EXCEPTION
1558: WHEN NO_DATA_FOUND THEN
1559: x_is_valid := FALSE;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.g_ret_sts_unexp_error;
1562: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1563: p_procedure_name => 'validate_item_revision',
1564: p_error_text => 'Progress: '||l_progress||
1565: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 1602: -- FND_API.g_ret_sts_success - if the procedure completed successfully

1598: --p_owning_org_id
1599: -- The GA Owning Org ID
1600: --OUT:
1601: --x_return_status
1602: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1603: -- FND_API.g_ret_sts_error - if an error occurred
1604: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1605: --x_is_valid
1606: -- TRUE if:

Line 1603: -- FND_API.g_ret_sts_error - if an error occurred

1599: -- The GA Owning Org ID
1600: --OUT:
1601: --x_return_status
1602: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1603: -- FND_API.g_ret_sts_error - if an error occurred
1604: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1605: --x_is_valid
1606: -- TRUE if:
1607: -- - item is a one-time item

Line 1604: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

1600: --OUT:
1601: --x_return_status
1602: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1603: -- FND_API.g_ret_sts_error - if an error occurred
1604: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1605: --x_is_valid
1606: -- TRUE if:
1607: -- - item is a one-time item
1608: -- OR

Line 1646: x_return_status := FND_API.g_ret_sts_success;

1642: l_progress VARCHAR2(3);
1643:
1644: BEGIN
1645: l_progress := '000';
1646: x_return_status := FND_API.g_ret_sts_success;
1647:
1648: IF g_debug_stmt THEN
1649: PO_DEBUG.debug_stmt
1650: (p_log_head => g_module_prefix||'validate_item_in_org',

Line 1687: IF (x_return_status = FND_API.g_ret_sts_error) THEN

1683: p_check_rev_control => l_check_rev_control,
1684: x_is_valid => x_is_valid,
1685: x_item_revision => x_item_revision);
1686:
1687: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1688: RAISE FND_API.g_exc_error;
1689: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1690: RAISE FND_API.g_exc_unexpected_error;
1691: END IF;

Line 1688: RAISE FND_API.g_exc_error;

1684: x_is_valid => x_is_valid,
1685: x_item_revision => x_item_revision);
1686:
1687: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1688: RAISE FND_API.g_exc_error;
1689: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1690: RAISE FND_API.g_exc_unexpected_error;
1691: END IF;
1692:

Line 1689: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

1685: x_item_revision => x_item_revision);
1686:
1687: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1688: RAISE FND_API.g_exc_error;
1689: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1690: RAISE FND_API.g_exc_unexpected_error;
1691: END IF;
1692:
1693: IF (NOT x_is_valid) THEN

Line 1690: RAISE FND_API.g_exc_unexpected_error;

1686:
1687: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1688: RAISE FND_API.g_exc_error;
1689: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1690: RAISE FND_API.g_exc_unexpected_error;
1691: END IF;
1692:
1693: IF (NOT x_is_valid) THEN
1694: -- revision check failed, so validation fails. No need to continue

Line 1711: IF (x_return_status = FND_API.g_ret_sts_error) THEN

1707: x_is_purchasable => l_is_purchasable,
1708: x_is_same_uom_class => l_is_same_uom_class,
1709: x_is_not_osp_item => l_is_not_osp_item);
1710:
1711: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1712: RAISE FND_API.g_exc_error;
1713: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1714: RAISE FND_API.g_exc_unexpected_error;
1715: END IF;

Line 1712: RAISE FND_API.g_exc_error;

1708: x_is_same_uom_class => l_is_same_uom_class,
1709: x_is_not_osp_item => l_is_not_osp_item);
1710:
1711: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1712: RAISE FND_API.g_exc_error;
1713: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1714: RAISE FND_API.g_exc_unexpected_error;
1715: END IF;
1716:

Line 1713: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

1709: x_is_not_osp_item => l_is_not_osp_item);
1710:
1711: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1712: RAISE FND_API.g_exc_error;
1713: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1714: RAISE FND_API.g_exc_unexpected_error;
1715: END IF;
1716:
1717: x_is_valid := (l_is_purchasable AND l_is_same_uom_class AND

Line 1714: RAISE FND_API.g_exc_unexpected_error;

1710:
1711: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1712: RAISE FND_API.g_exc_error;
1713: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1714: RAISE FND_API.g_exc_unexpected_error;
1715: END IF;
1716:
1717: x_is_valid := (l_is_purchasable AND l_is_same_uom_class AND
1718: l_is_not_osp_item);

Line 1722: x_return_status := FND_API.g_ret_sts_error;

1718: l_is_not_osp_item);
1719:
1720: EXCEPTION
1721: WHEN APP_EXCEPTION.application_exception THEN
1722: x_return_status := FND_API.g_ret_sts_error;
1723: FND_MSG_PUB.add;
1724: IF g_debug_stmt THEN
1725: PO_DEBUG.debug_stmt
1726: (p_log_head => g_module_prefix||'validate_item_in_org',

Line 1730: WHEN FND_API.g_exc_error THEN

1726: (p_log_head => g_module_prefix||'validate_item_in_org',
1727: p_token => l_progress,
1728: p_message => 'APPLICATION_EXCEPTION caught.');
1729: END IF;
1730: WHEN FND_API.g_exc_error THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: WHEN FND_API.g_exc_unexpected_error THEN
1733: x_return_status := FND_API.g_ret_sts_unexp_error;
1734: WHEN OTHERS THEN

Line 1731: x_return_status := FND_API.g_ret_sts_error;

1727: p_token => l_progress,
1728: p_message => 'APPLICATION_EXCEPTION caught.');
1729: END IF;
1730: WHEN FND_API.g_exc_error THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: WHEN FND_API.g_exc_unexpected_error THEN
1733: x_return_status := FND_API.g_ret_sts_unexp_error;
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1732: WHEN FND_API.g_exc_unexpected_error THEN

1728: p_message => 'APPLICATION_EXCEPTION caught.');
1729: END IF;
1730: WHEN FND_API.g_exc_error THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: WHEN FND_API.g_exc_unexpected_error THEN
1733: x_return_status := FND_API.g_ret_sts_unexp_error;
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.g_ret_sts_unexp_error;
1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

Line 1733: x_return_status := FND_API.g_ret_sts_unexp_error;

1729: END IF;
1730: WHEN FND_API.g_exc_error THEN
1731: x_return_status := FND_API.g_ret_sts_error;
1732: WHEN FND_API.g_exc_unexpected_error THEN
1733: x_return_status := FND_API.g_ret_sts_unexp_error;
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.g_ret_sts_unexp_error;
1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1737: p_procedure_name => 'validate_item_in_org',

Line 1735: x_return_status := FND_API.g_ret_sts_unexp_error;

1731: x_return_status := FND_API.g_ret_sts_error;
1732: WHEN FND_API.g_exc_unexpected_error THEN
1733: x_return_status := FND_API.g_ret_sts_unexp_error;
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.g_ret_sts_unexp_error;
1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1737: p_procedure_name => 'validate_item_in_org',
1738: p_error_text => 'Progress: '||l_progress||
1739: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 1771: -- FND_API.g_ret_sts_success - if the procedure completed successfully

1767: -- The Purchasing Org ID, or NULL to use the current OU. If NULL, this will be
1768: -- set to be the current OU if x_is_valid is TRUE.
1769: --OUT:
1770: --x_return_status
1771: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1772: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1773: --x_is_valid
1774: -- TRUE if x_purchasing_org_id is valid and enabled for use for the GA.
1775: -- FALSE otherwise.

Line 1772: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

1768: -- set to be the current OU if x_is_valid is TRUE.
1769: --OUT:
1770: --x_return_status
1771: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1772: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1773: --x_is_valid
1774: -- TRUE if x_purchasing_org_id is valid and enabled for use for the GA.
1775: -- FALSE otherwise.
1776: --End of Comments

Line 1792: x_return_status := FND_API.g_ret_sts_success;

1788: l_progress VARCHAR2(3);
1789:
1790: BEGIN
1791: l_progress := '000';
1792: x_return_status := FND_API.g_ret_sts_success;
1793:
1794: IF g_debug_stmt THEN
1795: PO_DEBUG.debug_stmt
1796: (p_log_head => g_module_prefix||'val_enabled_purchasing_org',

Line 1851: x_return_status := FND_API.g_ret_sts_unexp_error;

1847: p_name => 'x_is_valid',
1848: p_value => x_is_valid);
1849: END IF;
1850: WHEN OTHERS THEN
1851: x_return_status := FND_API.g_ret_sts_unexp_error;
1852: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1853: p_procedure_name => 'val_enabled_purchasing_org',
1854: p_error_text => 'Progress: '||l_progress||
1855: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 1887: -- FND_API.g_ret_sts_success - if the procedure completed successfully

1883: -- The Requesting Org ID, or NULL to use the current OU. If NULL, this will be
1884: -- set to be the current OU if x_is_valid is TRUE.
1885: --OUT:
1886: --x_return_status
1887: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1888: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1889: --x_is_valid
1890: -- TRUE if p_requesting_org_id is valid and enabled for use for the GA.
1891: -- FALSE otherwise.

Line 1888: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

1884: -- set to be the current OU if x_is_valid is TRUE.
1885: --OUT:
1886: --x_return_status
1887: -- FND_API.g_ret_sts_success - if the procedure completed successfully
1888: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
1889: --x_is_valid
1890: -- TRUE if p_requesting_org_id is valid and enabled for use for the GA.
1891: -- FALSE otherwise.
1892: --x_purchasing_org_id

Line 1912: x_return_status := FND_API.g_ret_sts_success;

1908: l_progress VARCHAR2(3);
1909:
1910: BEGIN
1911: l_progress := '000';
1912: x_return_status := FND_API.g_ret_sts_success;
1913:
1914: IF g_debug_stmt THEN
1915: PO_DEBUG.debug_stmt
1916: (p_log_head => g_module_prefix||'val_enabled_requesting_org',

Line 1972: x_return_status := FND_API.g_ret_sts_unexp_error;

1968: p_name => 'x_is_valid',
1969: p_value => x_is_valid);
1970: END IF;
1971: WHEN OTHERS THEN
1972: x_return_status := FND_API.g_ret_sts_unexp_error;
1973: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1974: p_procedure_name => 'val_enabled_requesting_org',
1975: p_error_text => 'Progress: '||l_progress||
1976: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 2012: -- FND_API.g_ret_sts_success - if the procedure completed successfully

2008: --p_owning_org_id
2009: -- The GA Owning Org ID
2010: --OUT:
2011: --x_return_status
2012: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2013: -- FND_API.g_ret_sts_error - if an error occurred
2014: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2015: --x_is_pou_valid
2016: -- TRUE if p_purchasing_org_id is a valid Purchasing Org for the GA.

Line 2013: -- FND_API.g_ret_sts_error - if an error occurred

2009: -- The GA Owning Org ID
2010: --OUT:
2011: --x_return_status
2012: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2013: -- FND_API.g_ret_sts_error - if an error occurred
2014: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2015: --x_is_pou_valid
2016: -- TRUE if p_purchasing_org_id is a valid Purchasing Org for the GA.
2017: -- FALSE otherwise.

Line 2014: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

2010: --OUT:
2011: --x_return_status
2012: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2013: -- FND_API.g_ret_sts_error - if an error occurred
2014: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2015: --x_is_pou_valid
2016: -- TRUE if p_purchasing_org_id is a valid Purchasing Org for the GA.
2017: -- FALSE otherwise.
2018: --x_is_item_valid:

Line 2048: x_return_status := FND_API.g_ret_sts_success;

2044: l_progress VARCHAR2(3);
2045:
2046: BEGIN
2047: l_progress := '000';
2048: x_return_status := FND_API.g_ret_sts_success;
2049:
2050: IF g_debug_stmt THEN
2051: PO_DEBUG.debug_stmt
2052: (p_log_head => g_module_prefix||'validate_in_purchasing_org',

Line 2067: IF (x_return_status = FND_API.g_ret_sts_error) THEN

2063: p_po_header_id => p_po_header_id,
2064: x_purchasing_org_id => l_purchasing_org_id,
2065: x_is_valid => x_is_pou_valid);
2066:
2067: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2068: RAISE FND_API.g_exc_error;
2069: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: END IF;

Line 2068: RAISE FND_API.g_exc_error;

2064: x_purchasing_org_id => l_purchasing_org_id,
2065: x_is_valid => x_is_pou_valid);
2066:
2067: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2068: RAISE FND_API.g_exc_error;
2069: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: END IF;
2072:

Line 2069: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

2065: x_is_valid => x_is_pou_valid);
2066:
2067: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2068: RAISE FND_API.g_exc_error;
2069: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: END IF;
2072:
2073: IF (NOT x_is_pou_valid) THEN

Line 2070: RAISE FND_API.g_exc_unexpected_error;

2066:
2067: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2068: RAISE FND_API.g_exc_error;
2069: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: END IF;
2072:
2073: IF (NOT x_is_pou_valid) THEN
2074: -- p_purchasing_org_id is not a valid Purchasing Org, so return

Line 2092: IF (x_return_status = FND_API.g_ret_sts_error) THEN

2088: p_owning_org_id => p_owning_org_id,
2089: x_is_valid => x_is_item_valid,
2090: x_item_revision => x_item_revision);
2091:
2092: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2093: RAISE FND_API.g_exc_error;
2094: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2095: RAISE FND_API.g_exc_unexpected_error;
2096: END IF;

Line 2093: RAISE FND_API.g_exc_error;

2089: x_is_valid => x_is_item_valid,
2090: x_item_revision => x_item_revision);
2091:
2092: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2093: RAISE FND_API.g_exc_error;
2094: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2095: RAISE FND_API.g_exc_unexpected_error;
2096: END IF;
2097:

Line 2094: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

2090: x_item_revision => x_item_revision);
2091:
2092: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2093: RAISE FND_API.g_exc_error;
2094: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2095: RAISE FND_API.g_exc_unexpected_error;
2096: END IF;
2097:
2098: IF g_debug_stmt THEN

Line 2095: RAISE FND_API.g_exc_unexpected_error;

2091:
2092: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2093: RAISE FND_API.g_exc_error;
2094: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2095: RAISE FND_API.g_exc_unexpected_error;
2096: END IF;
2097:
2098: IF g_debug_stmt THEN
2099: PO_DEBUG.debug_var

Line 2107: WHEN FND_API.g_exc_error THEN

2103: p_value => x_is_item_valid);
2104: END IF;
2105:
2106: EXCEPTION
2107: WHEN FND_API.g_exc_error THEN
2108: x_return_status := FND_API.g_ret_sts_error;
2109: WHEN FND_API.g_exc_unexpected_error THEN
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111: WHEN OTHERS THEN

Line 2108: x_return_status := FND_API.g_ret_sts_error;

2104: END IF;
2105:
2106: EXCEPTION
2107: WHEN FND_API.g_exc_error THEN
2108: x_return_status := FND_API.g_ret_sts_error;
2109: WHEN FND_API.g_exc_unexpected_error THEN
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2109: WHEN FND_API.g_exc_unexpected_error THEN

2105:
2106: EXCEPTION
2107: WHEN FND_API.g_exc_error THEN
2108: x_return_status := FND_API.g_ret_sts_error;
2109: WHEN FND_API.g_exc_unexpected_error THEN
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.g_ret_sts_unexp_error;
2113: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

Line 2110: x_return_status := FND_API.g_ret_sts_unexp_error;

2106: EXCEPTION
2107: WHEN FND_API.g_exc_error THEN
2108: x_return_status := FND_API.g_ret_sts_error;
2109: WHEN FND_API.g_exc_unexpected_error THEN
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.g_ret_sts_unexp_error;
2113: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2114: p_procedure_name => 'validate_in_purchasing_org',

Line 2112: x_return_status := FND_API.g_ret_sts_unexp_error;

2108: x_return_status := FND_API.g_ret_sts_error;
2109: WHEN FND_API.g_exc_unexpected_error THEN
2110: x_return_status := FND_API.g_ret_sts_unexp_error;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.g_ret_sts_unexp_error;
2113: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2114: p_procedure_name => 'validate_in_purchasing_org',
2115: p_error_text => 'Progress: '||l_progress||
2116: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 2154: -- FND_API.g_ret_sts_success - if the procedure completed successfully

2150: --p_owning_org_id
2151: -- The GA Owning Org ID
2152: --OUT:
2153: --x_return_status
2154: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2155: -- FND_API.g_ret_sts_error - if an error occurred
2156: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2157: --x_is_rou_valid
2158: -- TRUE if p_requesting_org_id is a valid Requesting Org for the GA.

Line 2155: -- FND_API.g_ret_sts_error - if an error occurred

2151: -- The GA Owning Org ID
2152: --OUT:
2153: --x_return_status
2154: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2155: -- FND_API.g_ret_sts_error - if an error occurred
2156: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2157: --x_is_rou_valid
2158: -- TRUE if p_requesting_org_id is a valid Requesting Org for the GA.
2159: -- FALSE otherwise.

Line 2156: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred

2152: --OUT:
2153: --x_return_status
2154: -- FND_API.g_ret_sts_success - if the procedure completed successfully
2155: -- FND_API.g_ret_sts_error - if an error occurred
2156: -- FND_API.g_ret_sts_unexp_error - unexpected error occurred
2157: --x_is_rou_valid
2158: -- TRUE if p_requesting_org_id is a valid Requesting Org for the GA.
2159: -- FALSE otherwise.
2160: --x_is_item_valid:

Line 2191: x_return_status := FND_API.g_ret_sts_success;

2187: l_progress VARCHAR2(3);
2188:
2189: BEGIN
2190: l_progress := '000';
2191: x_return_status := FND_API.g_ret_sts_success;
2192:
2193: IF g_debug_stmt THEN
2194: PO_DEBUG.debug_stmt
2195: (p_log_head => g_module_prefix||'validate_in_requesting_org',

Line 2211: IF (x_return_status = FND_API.g_ret_sts_error) THEN

2207: x_requesting_org_id => l_requesting_org_id,
2208: x_is_valid => x_is_rou_valid,
2209: x_purchasing_org_id => l_purchasing_org_id);
2210:
2211: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2212: RAISE FND_API.g_exc_error;
2213: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2214: RAISE FND_API.g_exc_unexpected_error;
2215: END IF;

Line 2212: RAISE FND_API.g_exc_error;

2208: x_is_valid => x_is_rou_valid,
2209: x_purchasing_org_id => l_purchasing_org_id);
2210:
2211: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2212: RAISE FND_API.g_exc_error;
2213: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2214: RAISE FND_API.g_exc_unexpected_error;
2215: END IF;
2216:

Line 2213: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

2209: x_purchasing_org_id => l_purchasing_org_id);
2210:
2211: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2212: RAISE FND_API.g_exc_error;
2213: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2214: RAISE FND_API.g_exc_unexpected_error;
2215: END IF;
2216:
2217: IF (NOT x_is_rou_valid) THEN

Line 2214: RAISE FND_API.g_exc_unexpected_error;

2210:
2211: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2212: RAISE FND_API.g_exc_error;
2213: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2214: RAISE FND_API.g_exc_unexpected_error;
2215: END IF;
2216:
2217: IF (NOT x_is_rou_valid) THEN
2218: -- p_requesting_org_id is not a valid Requesting Org, so return

Line 2236: IF (x_return_status = FND_API.g_ret_sts_error) THEN

2232: p_owning_org_id => p_owning_org_id,
2233: x_is_valid => x_is_item_valid,
2234: x_item_revision => x_item_revision);
2235:
2236: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2237: RAISE FND_API.g_exc_error;
2238: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2239: RAISE FND_API.g_exc_unexpected_error;
2240: END IF;

Line 2237: RAISE FND_API.g_exc_error;

2233: x_is_valid => x_is_item_valid,
2234: x_item_revision => x_item_revision);
2235:
2236: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2237: RAISE FND_API.g_exc_error;
2238: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2239: RAISE FND_API.g_exc_unexpected_error;
2240: END IF;
2241:

Line 2238: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

2234: x_item_revision => x_item_revision);
2235:
2236: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2237: RAISE FND_API.g_exc_error;
2238: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2239: RAISE FND_API.g_exc_unexpected_error;
2240: END IF;
2241:
2242: IF (NOT x_is_item_valid) THEN

Line 2239: RAISE FND_API.g_exc_unexpected_error;

2235:
2236: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2237: RAISE FND_API.g_exc_error;
2238: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2239: RAISE FND_API.g_exc_unexpected_error;
2240: END IF;
2241:
2242: IF (NOT x_is_item_valid) THEN
2243: -- This Requesting Org failed item validity, so return here

Line 2259: IF (x_return_status = FND_API.g_ret_sts_error) THEN

2255: p_owning_org_id => p_owning_org_id,
2256: x_is_valid => x_is_item_valid,
2257: x_item_revision => l_dummy_revision);
2258:
2259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;

Line 2260: RAISE FND_API.g_exc_error;

2256: x_is_valid => x_is_item_valid,
2257: x_item_revision => l_dummy_revision);
2258:
2259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264:

Line 2261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

2257: x_item_revision => l_dummy_revision);
2258:
2259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264:
2265: IF g_debug_stmt THEN

Line 2262: RAISE FND_API.g_exc_unexpected_error;

2258:
2259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264:
2265: IF g_debug_stmt THEN
2266: PO_DEBUG.debug_var

Line 2274: WHEN FND_API.g_exc_error THEN

2270: p_value => x_is_item_valid);
2271: END IF;
2272:
2273: EXCEPTION
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: WHEN FND_API.g_exc_unexpected_error THEN
2277: x_return_status := FND_API.g_ret_sts_unexp_error;
2278: WHEN OTHERS THEN

Line 2275: x_return_status := FND_API.g_ret_sts_error;

2271: END IF;
2272:
2273: EXCEPTION
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: WHEN FND_API.g_exc_unexpected_error THEN
2277: x_return_status := FND_API.g_ret_sts_unexp_error;
2278: WHEN OTHERS THEN
2279: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2276: WHEN FND_API.g_exc_unexpected_error THEN

2272:
2273: EXCEPTION
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: WHEN FND_API.g_exc_unexpected_error THEN
2277: x_return_status := FND_API.g_ret_sts_unexp_error;
2278: WHEN OTHERS THEN
2279: x_return_status := FND_API.g_ret_sts_unexp_error;
2280: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

Line 2277: x_return_status := FND_API.g_ret_sts_unexp_error;

2273: EXCEPTION
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: WHEN FND_API.g_exc_unexpected_error THEN
2277: x_return_status := FND_API.g_ret_sts_unexp_error;
2278: WHEN OTHERS THEN
2279: x_return_status := FND_API.g_ret_sts_unexp_error;
2280: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2281: p_procedure_name => 'validate_in_requesting_org',

Line 2279: x_return_status := FND_API.g_ret_sts_unexp_error;

2275: x_return_status := FND_API.g_ret_sts_error;
2276: WHEN FND_API.g_exc_unexpected_error THEN
2277: x_return_status := FND_API.g_ret_sts_unexp_error;
2278: WHEN OTHERS THEN
2279: x_return_status := FND_API.g_ret_sts_unexp_error;
2280: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
2281: p_procedure_name => 'validate_in_requesting_org',
2282: p_error_text => 'Progress: '||l_progress||
2283: ' Error: '||SUBSTRB(SQLERRM,1,215));

Line 2420: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN

2416: p_automatically_added_flag => 'Y',
2417: x_return_status => l_api_return_status,
2418: x_msg_data => l_api_msg_data);
2419:
2420: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
2421: x_msg_data := l_api_msg_data;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2424: x_msg_data := l_api_msg_data;

Line 2422: RAISE FND_API.G_EXC_ERROR;

2418: x_msg_data => l_api_msg_data);
2419:
2420: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
2421: x_msg_data := l_api_msg_data;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2424: x_msg_data := l_api_msg_data;
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;

Line 2423: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2419:
2420: IF l_api_return_status = FND_API.G_RET_STS_ERROR THEN
2421: x_msg_data := l_api_msg_data;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2424: x_msg_data := l_api_msg_data;
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427:

Line 2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2421: x_msg_data := l_api_msg_data;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSIF l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2424: x_msg_data := l_api_msg_data;
2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427:
2428: END IF; --references a GA
2429:

Line 2435: x_return_status := FND_API.G_RET_STS_SUCCESS;

2431: close lines_csr;
2432:
2433:
2434:
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;
2436:
2437: EXCEPTION
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2434:
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;
2436:
2437: EXCEPTION
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: WHEN OTHERS THEN

Line 2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2435: x_return_status := FND_API.G_RET_STS_SUCCESS;
2436:
2437: EXCEPTION
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: WHEN OTHERS THEN
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 2440: WHEN FND_API.G_EXC_ERROR THEN

2436:
2437: EXCEPTION
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: WHEN OTHERS THEN
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2444: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 2441: x_return_status := FND_API.G_RET_STS_ERROR;

2437: EXCEPTION
2438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: x_return_status := FND_API.G_RET_STS_ERROR;
2442: WHEN OTHERS THEN
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2444: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
2445: END IF;

Line 2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2445: END IF;
2446:
2447: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
2448: p_encoded => 'F');
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2450:
2451: END sync_all_ga_line_attachments;
2452:
2453: END PO_GA_PVT;