DBA Data[Home] [Help]

APPS.PO_GA_PVT dependencies on FND_MSG_PUB

Line 631: -- FND_MSG_PUB

627: --Name: validate_item
628: --Pre-reqs:
629: -- None.
630: --Modifies:
631: -- FND_MSG_PUB
632: --Locks:
633: -- None.
634: --Function:
635: -- Performs item validity checks between p_org_id and p_valid_org_id. Appends

Line 762: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
766: IF g_debug_unexp THEN

Line 1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_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;
1068:
1069: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1066: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

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;
1068:
1069: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1070: p_encoded => 'F');

Line 1069: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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;
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;

Line 1233: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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
1237: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1237: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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
1241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_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;
1244:
1245: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1242: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

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;
1244:
1245: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1246: p_encoded => 'F');

Line 1245: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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;
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;

Line 1409: -- FND_MSG_PUB

1405: --Pre-reqs:
1406: -- None.
1407: --Modifies:
1408: -- FND_LOG
1409: -- FND_MSG_PUB
1410: --Locks:
1411: -- None.
1412: --Function:
1413: -- Validates that p_ga_item_revision for p_item_id is available in both

Line 1562: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
1566: IF g_debug_unexp THEN

Line 1580: -- FND_MSG_PUB

1576: --Pre-reqs:
1577: -- None.
1578: --Modifies:
1579: -- FND_LOG
1580: -- FND_MSG_PUB
1581: --Locks:
1582: -- None.
1583: --Function:
1584: -- Performs item and item revision validity checks between p_org_id and

Line 1723: FND_MSG_PUB.add;

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',
1727: p_token => l_progress,

Line 1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
1740: IF g_debug_unexp THEN

Line 1754: -- FND_MSG_PUB

1750: --Pre-reqs:
1751: -- None.
1752: --Modifies:
1753: -- FND_LOG
1754: -- FND_MSG_PUB
1755: --Locks:
1756: -- None.
1757: --Function:
1758: -- Validate that x_purchasing_org_id is a Purchasing Org for the GA, with an

Line 1852: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
1856: IF g_debug_unexp THEN

Line 1870: -- FND_MSG_PUB

1866: --Pre-reqs:
1867: -- None.
1868: --Modifies:
1869: -- FND_LOG
1870: -- FND_MSG_PUB
1871: --Locks:
1872: -- None.
1873: --Function:
1874: -- Validate that x_requesting_org_id is a Requesting Org for the GA, with an

Line 1973: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
1977: IF g_debug_unexp THEN

Line 1991: -- FND_MSG_PUB

1987: --Pre-reqs:
1988: -- None.
1989: --Modifies:
1990: -- FND_LOG
1991: -- FND_MSG_PUB
1992: --Locks:
1993: -- None.
1994: --Function:
1995: -- Validates the item in the Purchasing Org p_purchasing_org_id against the

Line 2113: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
2117: IF g_debug_unexp THEN

Line 2131: -- FND_MSG_PUB

2127: --Pre-reqs:
2128: -- None.
2129: --Modifies:
2130: -- FND_LOG
2131: -- FND_MSG_PUB
2132: --Locks:
2133: -- None.
2134: --Function:
2135: -- Validates the item in the Requesting Org p_requesting_org_id against the

Line 2280: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,

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));
2284: IF g_debug_unexp THEN

Line 2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_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;
2446:
2447: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 2444: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

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;
2446:
2447: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
2448: p_encoded => 'F');

Line 2447: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

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;
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;