DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on FND_MESSAGE

Line 318: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PRODUCT_STMT_FAILED');

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)

Line 319: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

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

Line 681: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

677: EXCEPTION
678: WHEN OTHERS THEN
679: x_return_status := FND_API.g_ret_sts_unexp_error;
680:
681: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
682: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
683: FND_MSG_PUB.add;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 682: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

678: WHEN OTHERS THEN
679: x_return_status := FND_API.g_ret_sts_unexp_error;
680:
681: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
682: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
683: FND_MSG_PUB.add;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
686: THEN

Line 894: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');

890:
891: WHEN OTHERS THEN
892: x_return_status := FND_API.g_ret_sts_unexp_error;
893:
894: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
895: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
896: FND_MSG_PUB.add;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 895: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

891: WHEN OTHERS THEN
892: x_return_status := FND_API.g_ret_sts_unexp_error;
893:
894: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
895: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
896: FND_MSG_PUB.add;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
899: THEN

Line 1146: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');

1142:
1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.g_ret_sts_unexp_error;
1146: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
1147: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1148: FND_MSG_PUB.add;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 1147: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1143: EXCEPTION
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.g_ret_sts_unexp_error;
1146: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
1147: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1148: FND_MSG_PUB.add;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1151: THEN

Line 1269: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: x_return_status := FND_API.g_ret_sts_unexp_error;
1268:
1269: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1270: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1271: FND_MSG_PUB.add;
1272:
1273: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 1270: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1266: WHEN OTHERS THEN
1267: x_return_status := FND_API.g_ret_sts_unexp_error;
1268:
1269: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1270: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1271: FND_MSG_PUB.add;
1272:
1273: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1274: THEN

Line 1529: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');

1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.g_ret_sts_unexp_error;
1528:
1529: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1530: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1531: FND_MSG_PUB.add;
1532:
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 1530: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.g_ret_sts_unexp_error;
1528:
1529: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
1530: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1531: FND_MSG_PUB.add;
1532:
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1534: THEN

Line 1793: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PARTY_STMT_FAILED');

1789: WHEN OTHERS THEN
1790: write_conc_log ('-- Others - ' || SQLERRM || ' ' || x_party_stmt);
1791: x_return_status := FND_API.g_ret_sts_unexp_error;
1792:
1793: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PARTY_STMT_FAILED');
1794: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1795: FND_MSG_PUB.add;
1796:
1797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 1794: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1790: write_conc_log ('-- Others - ' || SQLERRM || ' ' || x_party_stmt);
1791: x_return_status := FND_API.g_ret_sts_unexp_error;
1792:
1793: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PARTY_STMT_FAILED');
1794: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1795: FND_MSG_PUB.add;
1796:
1797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1798: THEN

Line 2000: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');

1996:
1997: WHEN OTHERS THEN
1998: x_return_status := FND_API.g_ret_sts_unexp_error;
1999:
2000: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2001: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2002: FND_MSG_PUB.add;
2003:
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 2001: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1997: WHEN OTHERS THEN
1998: x_return_status := FND_API.g_ret_sts_unexp_error;
1999:
2000: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2001: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2002: FND_MSG_PUB.add;
2003:
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2005: THEN

Line 2253: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');

2249: ozf_utility_pvt.write_conc_log('-- Others - ' || SQLERRM || ' ' || x_product_stmt);
2250:
2251: x_return_status := FND_API.g_ret_sts_unexp_error;
2252:
2253: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2254: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2255: FND_MSG_PUB.add;
2256:
2257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 2254: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

2250:
2251: x_return_status := FND_API.g_ret_sts_unexp_error;
2252:
2253: FND_MESSAGE.set_name('AMS', 'AMS_OFFER_PRODUCT_STMT_FAILED');
2254: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
2255: FND_MSG_PUB.add;
2256:
2257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2258: THEN