DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on FND_MSG_PUB

Line 142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

138: --first log the sqlerrm
139: l_error_text := substr (SQLERRM, 1, 512);
140: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
141: --then add it to the message api list
142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
143: END IF;
144: RAISE;
145:
146: END PRINT_G_RAIL_REC;

Line 188: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

184: --first log the sqlerrm
185: l_error_text := substr (SQLERRM, 1, 512);
186: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
187: --then add it to the message api list
188: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
189: END IF;
190:
191: IF l_org_csr%isopen THEN
192: CLOSE l_org_csr;

Line 410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

406: --first log the sqlerrm
407: l_error_text := substr (SQLERRM, 1, 512);
408: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
409: --then add it to the message api list
410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
411: END IF;
412:
413: IF cust_acct_csr%isopen THEN
414: CLOSE cust_acct_csr;

Line 584: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

580: --first log the sqlerrm
581: l_error_text := substr (SQLERRM, 1, 512);
582: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
583: --then add it to the message api list
584: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
585: END IF;
586:
587: IF cur_address%isopen THEN
588: CLOSE cur_address;

Line 885: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

881: --first log the sqlerrm
882: l_error_text := substr (SQLERRM, 1, 512);
883: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
884: --then add it to the message api list
885: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
886: END IF;
887:
888: IF cur_address%isopen THEN
889: CLOSE cur_address;

Line 1023: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1019: --first log the sqlerrm
1020: l_error_text := substr (SQLERRM, 1, 512);
1021: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1022: --then add it to the message api list
1023: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1024: END IF;
1025:
1026: IF cur_cust_info%isopen THEN
1027: CLOSE cur_cust_info;

Line 1167: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1163: --first log the sqlerrm
1164: l_error_text := substr (SQLERRM, 1, 512);
1165: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1166: --then add it to the message api list
1167: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1168: END IF;
1169: RAISE;
1170:
1171: END INIT_ZX_TRXLINE_DIST_TBL;

Line 1261: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1257: --first log the sqlerrm
1258: l_error_text := substr (SQLERRM, 1, 512);
1259: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1260: --then add it to the message api list
1261: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1262: END IF;
1263:
1264: IF cur_custtrx_type_id%isopen THEN
1265: CLOSE cur_custtrx_type_id;

Line 1429: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1425: --first log the sqlerrm
1426: l_error_text := substr (SQLERRM, 1, 512);
1427: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1428: --then add it to the message api list
1429: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1430: END IF;
1431:
1432: IF (cur_k_header%isopen) THEN
1433: CLOSE cur_k_header;

Line 1552: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1548: --first log the sqlerrm
1549: l_error_text := substr (SQLERRM, 1, 512);
1550: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1551: --then add it to the message api list
1552: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1553: END IF;
1554:
1555: IF (cur_batch_source_id%isopen) THEN
1556: CLOSE cur_batch_source_id;

Line 1697: FND_MSG_PUB.initialize;

1693: END IF;
1694:
1695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1696: IF(FND_API.G_TRUE = p_init_msg_list) THEN
1697: FND_MSG_PUB.initialize;
1698: END IF;
1699:
1700: --1. get hdr details from okc table and do basic id validation
1701: OPEN okc_hdr_csr(p_chr_id);

Line 1709: FND_MSG_PUB.ADD;

1705: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1706: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1707: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1708: END IF;
1709: FND_MSG_PUB.ADD;
1710: CLOSE okc_hdr_csr;
1711: RAISE FND_API.g_exc_error;
1712: END IF;
1713: CLOSE okc_hdr_csr;

Line 1909: FND_MSG_PUB.ADD;

1905: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1906: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1907: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1908: END IF;
1909: FND_MSG_PUB.ADD;
1910: RAISE FND_API.g_exc_error;
1911: END IF;
1912: -- End of added for tax bug # 4026206
1913:

Line 2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2002: --first log the sqlerrm
2003: l_error_text := substr (SQLERRM, 1, 512);
2004: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
2005: --then add it to the message api list
2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2007: END IF;
2008: IF Cur_Batch_Source_Id%ISOPEN THEN
2009: CLOSE Cur_Batch_Source_Id;
2010: END IF;

Line 2059: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2055: --first log the sqlerrm
2056: l_error_text := substr (SQLERRM, 1, 512);
2057: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2058: --then add it to the message api list
2059: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2060: END IF;
2061: RAISE FND_API.g_exc_unexpected_error;
2062:
2063: END; --of inner block

Line 2160: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

2156: p_rail_rec => px_rail_rec,
2157: p_msg => 'End get_tax, PX_RAIL_REC details',
2158: p_level => FND_LOG.level_procedure);
2159: END IF;
2160: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2161:
2162:
2163: EXCEPTION
2164: WHEN FND_API.g_exc_error THEN

Line 2170: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

2166:
2167: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2168: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2169: END IF;
2170: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2171:
2172: IF okc_hdr_csr%ISOPEN THEN
2173: CLOSE okc_hdr_csr;
2174: END IF;

Line 2220: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

2216:
2217: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2218: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2219: END IF;
2220: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2221:
2222: IF okc_hdr_csr%ISOPEN THEN
2223: CLOSE okc_hdr_csr;
2224: END IF;

Line 2272: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

2268: --first log the sqlerrm
2269: l_error_text := substr (SQLERRM, 1, 240);
2270: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2271: --then add it to the message api list
2272: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2273: END IF;
2274: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2275:
2276: IF okc_hdr_csr%ISOPEN THEN

Line 2274: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

2270: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2271: --then add it to the message api list
2272: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2273: END IF;
2274: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2275:
2276: IF okc_hdr_csr%ISOPEN THEN
2277: CLOSE okc_hdr_csr;
2278: END IF;