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.26.12020000.2 2013/02/11 07:03:19 annsrini 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 680: FND_MSG_PUB.add;

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

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

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
684: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
685: END IF;
686:

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

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

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

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

Line 785: FND_MSG_PUB.initialize;

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

Line 905: FND_MSG_PUB.add;

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

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

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
909: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
910: END IF;
911:

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

905: FND_MSG_PUB.add;
906:
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
908: THEN
909: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
910: END IF;
911:
912: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
913: p_count => x_msg_count,

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

908: THEN
909: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
910: END IF;
911:
912: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
913: p_count => x_msg_count,
914: p_data => x_msg_data);
915:
916: END refresh_netaccrual_products;

Line 1033: FND_MSG_PUB.initialize;

1029: BEGIN
1030: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_volume');
1031:
1032: IF FND_API.to_boolean(p_init_msg_list) THEN
1033: FND_MSG_PUB.initialize;
1034: END IF;
1035:
1036: IF NOT FND_API.compatible_api_call(l_api_version,
1037: p_api_version,

Line 1169: FND_MSG_PUB.add;

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

Line 1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_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
1173: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1174: END IF;
1175:

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

1169: FND_MSG_PUB.add;
1170:
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1172: THEN
1173: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1174: END IF;
1175:
1176: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1177: p_count => x_msg_count,

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

1172: THEN
1173: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1174: END IF;
1175:
1176: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data);
1179:
1180: END refresh_volume_products;

Line 1291: FND_MSG_PUB.add;

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

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

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
1295: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1296: END IF;
1297:

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

1291: FND_MSG_PUB.add;
1292:
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1294: THEN
1295: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1296: END IF;
1297:
1298: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1299: p_count => x_msg_count,

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

1294: THEN
1295: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1296: END IF;
1297:
1298: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: END refresh_lumpsum_parties;

Line 1550: FND_MSG_PUB.add;

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

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

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
1554: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1555: END IF;
1556:

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

1550: FND_MSG_PUB.add;
1551:
1552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1553: THEN
1554: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1555: END IF;
1556:
1557: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,

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

1553: THEN
1554: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1555: END IF;
1556:
1557: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data);
1560:
1561: END refresh_volume_parties;

Line 1685: FND_MSG_PUB.initialize;

1681: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh parties' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1682: --write_log(l_full_name || ': Start refresh parties');
1683:
1684: IF FND_API.to_boolean(p_init_msg_list) THEN
1685: FND_MSG_PUB.initialize;
1686: END IF;
1687:
1688: IF NOT FND_API.compatible_api_call(l_api_version,
1689: p_api_version,

Line 1818: FND_MSG_PUB.add;

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

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

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
1822: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1823: END IF;
1824:

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

1818: FND_MSG_PUB.add;
1819:
1820: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1821: THEN
1822: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1823: END IF;
1824:
1825: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1826: p_count => x_msg_count,

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

1821: THEN
1822: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1823: END IF;
1824:
1825: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828:
1829: END refresh_parties;

Line 1926: FND_MSG_PUB.initialize;

1922:
1923: write_conc_log(l_full_name || ': start refresh_products_lumpsum');
1924:
1925: IF FND_API.to_boolean(p_init_msg_list) THEN
1926: FND_MSG_PUB.initialize;
1927: END IF;
1928:
1929: IF NOT FND_API.compatible_api_call(l_api_version,
1930: p_api_version,

Line 2036: FND_MSG_PUB.add;

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

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

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
2040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2041: END IF;
2042:

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

2036: FND_MSG_PUB.add;
2037:
2038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2039: THEN
2040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2041: END IF;
2042:
2043: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2044: p_count => x_msg_count,

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

2039: THEN
2040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2041: END IF;
2042:
2043: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2044: p_count => x_msg_count,
2045: p_data => x_msg_data);
2046:
2047: END refresh_lumpsum_products;

Line 2146: FND_MSG_PUB.initialize;

2142: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh products' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
2143: --write_log(l_full_name || ': Start refresh products');
2144:
2145: IF FND_API.to_boolean(p_init_msg_list) THEN
2146: FND_MSG_PUB.initialize;
2147: END IF;
2148:
2149: IF NOT FND_API.compatible_api_call(l_api_version,
2150: p_api_version,

Line 2312: FND_MSG_PUB.add;

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

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

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
2316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2317: END IF;
2318:

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

2312: FND_MSG_PUB.add;
2313:
2314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2315: THEN
2316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2317: END IF;
2318:
2319: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2320: p_count => x_msg_count,

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

2315: THEN
2316: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2317: END IF;
2318:
2319: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2320: p_count => x_msg_count,
2321: p_data => x_msg_data);
2322:
2323: END refresh_products;