eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on FND_MSG_PUB

Line 6: OZF_DEBUG_LOW CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2: /* $Header: ozfvodeb.pls 120.23.12010000.2 2008/07/31 11:28:10 kpatro ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='OZF_OFFR_ELIG_PROD_DENORM_PVT';
6: OZF_DEBUG_LOW CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: --a utl_file.file_type;
8: --l_out_dir varchar2(100);
9: --out_dir varchar2(100) := '/sqlcom/crmeco/ozfd1r10/temp';
10: --l_out_file varchar2(100) := 'debug_denorm.txt';

Line 275: FND_MSG_PUB.initialize;

271: l_prod_stmt VARCHAR2(32000) := NULL;
272: l_cond_id VARCHAR2(40);
273: BEGIN
274: IF FND_API.to_boolean(p_init_msg_list) THEN
275: FND_MSG_PUB.initialize;
276: END IF;
277:
278: IF NOT FND_API.compatible_api_call(l_api_version,
279: p_api_version,

Line 320: FND_MSG_PUB.add;

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

Line 322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
324: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
325: END IF;
326:

Line 324: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

320: FND_MSG_PUB.add;
321:
322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
323: THEN
324: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
325: END IF;
326:
327: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
328: p_count => x_msg_count,

Line 327: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

323: THEN
324: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
325: END IF;
326:
327: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330:
331: END insert_excl_prod;

Line 683: FND_MSG_PUB.add;

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

Line 685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
688: END IF;
689:

Line 687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

683: FND_MSG_PUB.add;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
686: THEN
687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
688: END IF;
689:
690: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
691: p_count => x_msg_count,

Line 690: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

686: THEN
687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
688: END IF;
689:
690: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
691: p_count => x_msg_count,
692: p_data => x_msg_data);
693:
694: END refresh_netaccrual_parties;

Line 788: FND_MSG_PUB.initialize;

784:
785: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_netaccrual');
786:
787: IF FND_API.to_boolean(p_init_msg_list) THEN
788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: IF NOT FND_API.compatible_api_call(l_api_version,
792: p_api_version,

Line 896: FND_MSG_PUB.add;

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

Line 898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
900: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:

Line 900: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

896: FND_MSG_PUB.add;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
899: THEN
900: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:
903: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
904: p_count => x_msg_count,

Line 903: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

899: THEN
900: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
901: END IF;
902:
903: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
904: p_count => x_msg_count,
905: p_data => x_msg_data);
906:
907: END refresh_netaccrual_products;

Line 1024: FND_MSG_PUB.initialize;

1020: BEGIN
1021: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_volume');
1022:
1023: IF FND_API.to_boolean(p_init_msg_list) THEN
1024: FND_MSG_PUB.initialize;
1025: END IF;
1026:
1027: IF NOT FND_API.compatible_api_call(l_api_version,
1028: p_api_version,

Line 1148: FND_MSG_PUB.add;

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

Line 1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_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
1152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:

Line 1152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1148: FND_MSG_PUB.add;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1151: THEN
1152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:
1155: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1156: p_count => x_msg_count,

Line 1155: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1151: THEN
1152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1153: END IF;
1154:
1155: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: END refresh_volume_products;

Line 1271: FND_MSG_PUB.add;

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

Line 1273: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
1275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1276: END IF;
1277:

Line 1275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1271: FND_MSG_PUB.add;
1272:
1273: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1274: THEN
1275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1276: END IF;
1277:
1278: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1279: p_count => x_msg_count,

Line 1278: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1274: THEN
1275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1276: END IF;
1277:
1278: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data);
1281:
1282: END refresh_lumpsum_parties;

Line 1531: FND_MSG_PUB.add;

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

Line 1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
1535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1536: END IF;
1537:

Line 1535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1531: FND_MSG_PUB.add;
1532:
1533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1534: THEN
1535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1536: END IF;
1537:
1538: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1539: p_count => x_msg_count,

Line 1538: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1534: THEN
1535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1536: END IF;
1537:
1538: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data);
1541:
1542: END refresh_volume_parties;

Line 1666: FND_MSG_PUB.initialize;

1662: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh parties' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1663: --write_log(l_full_name || ': Start refresh parties');
1664:
1665: IF FND_API.to_boolean(p_init_msg_list) THEN
1666: FND_MSG_PUB.initialize;
1667: END IF;
1668:
1669: IF NOT FND_API.compatible_api_call(l_api_version,
1670: p_api_version,

Line 1795: FND_MSG_PUB.add;

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

Line 1797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
1799: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1800: END IF;
1801:

Line 1799: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1795: FND_MSG_PUB.add;
1796:
1797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1798: THEN
1799: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1800: END IF;
1801:
1802: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1803: p_count => x_msg_count,

Line 1802: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1798: THEN
1799: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1800: END IF;
1801:
1802: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1803: p_count => x_msg_count,
1804: p_data => x_msg_data);
1805:
1806: END refresh_parties;

Line 1903: FND_MSG_PUB.initialize;

1899:
1900: write_conc_log(l_full_name || ': start refresh_products_lumpsum');
1901:
1902: IF FND_API.to_boolean(p_init_msg_list) THEN
1903: FND_MSG_PUB.initialize;
1904: END IF;
1905:
1906: IF NOT FND_API.compatible_api_call(l_api_version,
1907: p_api_version,

Line 2002: FND_MSG_PUB.add;

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

Line 2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:

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

2002: FND_MSG_PUB.add;
2003:
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2005: THEN
2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:
2009: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2010: p_count => x_msg_count,

Line 2009: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

2005: THEN
2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:
2009: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2010: p_count => x_msg_count,
2011: p_data => x_msg_data);
2012:
2013: END refresh_lumpsum_products;

Line 2112: FND_MSG_PUB.initialize;

2108: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh products' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
2109: --write_log(l_full_name || ': Start refresh products');
2110:
2111: IF FND_API.to_boolean(p_init_msg_list) THEN
2112: FND_MSG_PUB.initialize;
2113: END IF;
2114:
2115: IF NOT FND_API.compatible_api_call(l_api_version,
2116: p_api_version,

Line 2255: FND_MSG_PUB.add;

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

Line 2257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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
2259: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2260: END IF;
2261:

Line 2259: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2255: FND_MSG_PUB.add;
2256:
2257: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2258: THEN
2259: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2260: END IF;
2261:
2262: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2263: p_count => x_msg_count,

Line 2262: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

2258: THEN
2259: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2260: END IF;
2261:
2262: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data);
2265:
2266: END refresh_products;