314: write_conc_log('2:' || SUBSTR(l_prod_stmt, 251, 250));
315: write_conc_log('3:' || SUBSTR(l_prod_stmt, 501, 250));
316: write_conc_log('4:' || SUBSTR(l_prod_stmt, 751, 250));
317:
318: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PRODUCT_STMT_FAILED');
319: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
320: FND_MSG_PUB.add;
321:
322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
315: write_conc_log('3:' || SUBSTR(l_prod_stmt, 501, 250));
316: write_conc_log('4:' || SUBSTR(l_prod_stmt, 751, 250));
317:
318: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PRODUCT_STMT_FAILED');
319: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
320: FND_MSG_PUB.add;
321:
322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
323: THEN
674: EXCEPTION
675: WHEN OTHERS THEN
676: x_return_status := FND_API.g_ret_sts_unexp_error;
677:
678: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
679: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
680: FND_MSG_PUB.add;
681:
682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
675: WHEN OTHERS THEN
676: x_return_status := FND_API.g_ret_sts_unexp_error;
677:
678: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
679: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
680: FND_MSG_PUB.add;
681:
682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
683: THEN
899:
900: WHEN OTHERS THEN
901: x_return_status := FND_API.g_ret_sts_unexp_error;
902:
903: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
904: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
905: FND_MSG_PUB.add;
906:
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
900: WHEN OTHERS THEN
901: x_return_status := FND_API.g_ret_sts_unexp_error;
902:
903: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
904: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
905: FND_MSG_PUB.add;
906:
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
908: THEN
1163:
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: x_return_status := FND_API.g_ret_sts_unexp_error;
1167: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
1168: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1169: FND_MSG_PUB.add;
1170:
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: x_return_status := FND_API.g_ret_sts_unexp_error;
1167: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
1168: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1169: FND_MSG_PUB.add;
1170:
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1172: THEN
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288:
1289: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1290: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1291: FND_MSG_PUB.add;
1292:
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1286: WHEN OTHERS THEN
1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288:
1289: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1290: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1291: FND_MSG_PUB.add;
1292:
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1294: THEN
1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: x_return_status := FND_API.g_ret_sts_unexp_error;
1547:
1548: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1549: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1550: FND_MSG_PUB.add;
1551:
1552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1545: WHEN OTHERS THEN
1546: x_return_status := FND_API.g_ret_sts_unexp_error;
1547:
1548: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1549: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1550: FND_MSG_PUB.add;
1551:
1552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1553: THEN
1812: WHEN OTHERS THEN
1813: write_conc_log ('-- Others - ' || SQLERRM || ' ' || x_party_stmt);
1814: x_return_status := FND_API.g_ret_sts_unexp_error;
1815:
1816: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PARTY_STMT_FAILED');
1817: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1818: FND_MSG_PUB.add;
1819:
1820: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1813: write_conc_log ('-- Others - ' || SQLERRM || ' ' || x_party_stmt);
1814: x_return_status := FND_API.g_ret_sts_unexp_error;
1815:
1816: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PARTY_STMT_FAILED');
1817: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1818: FND_MSG_PUB.add;
1819:
1820: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1821: THEN
2030:
2031: WHEN OTHERS THEN
2032: x_return_status := FND_API.g_ret_sts_unexp_error;
2033:
2034: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2035: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2036: FND_MSG_PUB.add;
2037:
2038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2031: WHEN OTHERS THEN
2032: x_return_status := FND_API.g_ret_sts_unexp_error;
2033:
2034: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2035: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2036: FND_MSG_PUB.add;
2037:
2038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2039: THEN
2306: ozf_utility_pvt.write_conc_log('-- Others - ' || SQLERRM || ' ' || x_product_stmt);
2307:
2308: x_return_status := FND_API.g_ret_sts_unexp_error;
2309:
2310: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2311: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2312: FND_MSG_PUB.add;
2313:
2314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2307:
2308: x_return_status := FND_API.g_ret_sts_unexp_error;
2309:
2310: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2311: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2312: FND_MSG_PUB.add;
2313:
2314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2315: THEN