DBA Data[Home] [Help]

APPS.PO_SHARED_PROC_PVT dependencies on FND_MSG_PUB

Line 23: -- FND_MSG_PUB on error.

19: --Pre-reqs:
20: -- None.
21: --Modifies:
22: -- FND_LOG
23: -- FND_MSG_PUB on error.
24: --Locks:
25: -- None.
26: --Function:
27: -- Check if an inventory transaction flow exists for input parameters given.

Line 84: FND_MSG_PUB.initialize;

80: l_progress := '000';
81:
82: -- Start standard API initialization
83: IF FND_API.to_boolean(p_init_msg_list) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: x_return_status := FND_API.g_ret_sts_success;
87: -- End standard API initialization
88:

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

206: END IF;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.g_ret_sts_unexp_error;
209: x_transaction_flow_header_id := NULL;
210: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
211: p_procedure_name => 'check_transaction_flow',
212: p_error_text => 'Progress: '||l_progress||
213: ' Error: '||SUBSTRB(SQLERRM,1,215));
214: IF g_debug_unexp THEN

Line 957: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);

953:
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: x_return_status := fnd_api.g_ret_sts_error;
957: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
958: WHEN fnd_api.g_exc_unexpected_error THEN
959: x_return_status := fnd_api.g_ret_sts_unexp_error;
960: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
961: WHEN OTHERS THEN

Line 960: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);

956: x_return_status := fnd_api.g_ret_sts_error;
957: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
958: WHEN fnd_api.g_exc_unexpected_error THEN
959: x_return_status := fnd_api.g_ret_sts_unexp_error;
960: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
961: WHEN OTHERS THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
964: SUBSTRB(SQLERRM , 1 , 200) || ' at location ' || l_progress);

Line 963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,

959: x_return_status := fnd_api.g_ret_sts_unexp_error;
960: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
961: WHEN OTHERS THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
964: SUBSTRB(SQLERRM , 1 , 200) || ' at location ' || l_progress);
965: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
966: END validate_cross_ou_purchasing;
967:

Line 965: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);

961: WHEN OTHERS THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
964: SUBSTRB(SQLERRM , 1 , 200) || ' at location ' || l_progress);
965: fnd_message.parse_encoded(FND_MSG_PUB.get,x_app_name,x_error_msg_name);
966: END validate_cross_ou_purchasing;
967:
968:
969: -----------------------------------------------------------------------

Line 1083: -- FND_MSG_PUB

1079: --Pre-reqs:
1080: -- None.
1081: --Modifies:
1082: -- FND_LOG
1083: -- FND_MSG_PUB
1084: --Locks:
1085: -- None.
1086: --Function:
1087: -- Checks if p_item_id and p_item_revision are available in p_inv_org_id.

Line 1133: FND_MSG_PUB.initialize;

1129: l_progress := '000';
1130:
1131: -- Start standard API initialization
1132: IF FND_API.to_boolean(p_init_msg_list) THEN
1133: FND_MSG_PUB.initialize;
1134: END IF;
1135: x_return_status := FND_API.g_ret_sts_success;
1136: -- End standard API initialization
1137:

Line 1207: FND_MSG_PUB.add_exc_msg

1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: x_return_status := FND_API.g_ret_sts_unexp_error;
1206: x_in_inv_org := FALSE;
1207: FND_MSG_PUB.add_exc_msg
1208: (p_pkg_name => g_pkg_name,
1209: p_procedure_name => 'check_item_in_inventory_org',
1210: p_error_text => 'Progress: '||l_progress||' Error: '||
1211: SUBSTRB(SQLERRM,1,215));

Line 1226: -- FND_MSG_PUB

1222: --Pre-reqs:
1223: -- None.
1224: --Modifies:
1225: -- FND_LOG
1226: -- FND_MSG_PUB
1227: --Locks:
1228: -- None.
1229: --Function:
1230: -- Validates the ship-to org with the current OU. The ship-to org is valid

Line 1301: FND_MSG_PUB.initialize;

1297: l_progress := '000';
1298:
1299: -- Start standard API initialization
1300: IF FND_API.to_boolean(p_init_msg_list) THEN
1301: FND_MSG_PUB.initialize;
1302: END IF;
1303: x_return_status := FND_API.g_ret_sts_success;
1304: -- End standard API initialization
1305:

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

1482: END IF;
1483: WHEN OTHERS THEN
1484: x_return_status := FND_API.g_ret_sts_unexp_error;
1485: x_is_valid := FALSE;
1486: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1487: p_procedure_name => 'validate_ship_to_org',
1488: p_error_text => 'Progress: '||l_progress||
1489: ' Error: '||SUBSTRB(SQLERRM,1,215));
1490: IF g_debug_unexp THEN

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

1608: WHEN FND_API.g_exc_unexpected_error THEN
1609: x_return_status := FND_API.g_ret_sts_unexp_error;
1610: WHEN OTHERS THEN
1611: x_return_status := FND_API.g_ret_sts_unexp_error;
1612: FND_MSG_PUB.add_exc_msg(p_pkg_name => g_pkg_name,
1613: p_procedure_name => 'do_item_validity_checks',
1614: p_error_text => NULL);
1615: IF g_debug_unexp THEN
1616: PO_DEBUG.debug_exc