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 568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

564: --first log the sqlerrm
565: l_error_text := substr (SQLERRM, 1, 512);
566: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
567: --then add it to the message api list
568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
569: END IF;
570:
571: IF cur_address%isopen THEN
572: CLOSE cur_address;

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

847: --first log the sqlerrm
848: l_error_text := substr (SQLERRM, 1, 512);
849: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
850: --then add it to the message api list
851: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
852: END IF;
853:
854: IF cur_address%isopen THEN
855: CLOSE cur_address;

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

985: --first log the sqlerrm
986: l_error_text := substr (SQLERRM, 1, 512);
987: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
988: --then add it to the message api list
989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
990: END IF;
991:
992: IF cur_cust_info%isopen THEN
993: CLOSE cur_cust_info;

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

1115: --first log the sqlerrm
1116: l_error_text := substr (SQLERRM, 1, 512);
1117: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1118: --then add it to the message api list
1119: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1120: END IF;
1121: RAISE;
1122:
1123: END INIT_ZX_TRXLINE_DIST_TBL;

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

1209: --first log the sqlerrm
1210: l_error_text := substr (SQLERRM, 1, 512);
1211: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1212: --then add it to the message api list
1213: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1214: END IF;
1215:
1216: IF cur_custtrx_type_id%isopen THEN
1217: CLOSE cur_custtrx_type_id;

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

1377: --first log the sqlerrm
1378: l_error_text := substr (SQLERRM, 1, 512);
1379: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1380: --then add it to the message api list
1381: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1382: END IF;
1383:
1384: IF (cur_k_header%isopen) THEN
1385: CLOSE cur_k_header;

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

1500: --first log the sqlerrm
1501: l_error_text := substr (SQLERRM, 1, 512);
1502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1503: --then add it to the message api list
1504: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1505: END IF;
1506:
1507: IF (cur_batch_source_id%isopen) THEN
1508: CLOSE cur_batch_source_id;

Line 1649: FND_MSG_PUB.initialize;

1645: END IF;
1646:
1647: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1648: IF(FND_API.G_TRUE = p_init_msg_list) THEN
1649: FND_MSG_PUB.initialize;
1650: END IF;
1651:
1652: --1. get hdr details from okc table and do basic id validation
1653: OPEN okc_hdr_csr(p_chr_id);

Line 1661: FND_MSG_PUB.ADD;

1657: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1658: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1659: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1660: END IF;
1661: FND_MSG_PUB.ADD;
1662: CLOSE okc_hdr_csr;
1663: RAISE FND_API.g_exc_error;
1664: END IF;
1665: CLOSE okc_hdr_csr;

Line 1861: FND_MSG_PUB.ADD;

1857: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1858: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1859: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1860: END IF;
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.g_exc_error;
1863: END IF;
1864: -- End of added for tax bug # 4026206
1865:

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

1954: --first log the sqlerrm
1955: l_error_text := substr (SQLERRM, 1, 512);
1956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
1957: --then add it to the message api list
1958: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1959: END IF;
1960: IF Cur_Batch_Source_Id%ISOPEN THEN
1961: CLOSE Cur_Batch_Source_Id;
1962: END IF;

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

2007: --first log the sqlerrm
2008: l_error_text := substr (SQLERRM, 1, 512);
2009: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2010: --then add it to the message api list
2011: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2012: END IF;
2013: RAISE FND_API.g_exc_unexpected_error;
2014:
2015: END; --of inner block

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

2108: p_rail_rec => px_rail_rec,
2109: p_msg => 'End get_tax, PX_RAIL_REC details',
2110: p_level => FND_LOG.level_procedure);
2111: END IF;
2112: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2113:
2114:
2115: EXCEPTION
2116: WHEN FND_API.g_exc_error THEN

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

2118:
2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2121: END IF;
2122: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2123:
2124: IF okc_hdr_csr%ISOPEN THEN
2125: CLOSE okc_hdr_csr;
2126: END IF;

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

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

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

2220: --first log the sqlerrm
2221: l_error_text := substr (SQLERRM, 1, 240);
2222: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2223: --then add it to the message api list
2224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2225: END IF;
2226: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2227:
2228: IF okc_hdr_csr%ISOPEN THEN

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

2222: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2223: --then add it to the message api list
2224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2225: END IF;
2226: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2227:
2228: IF okc_hdr_csr%ISOPEN THEN
2229: CLOSE okc_hdr_csr;
2230: END IF;