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_API

Line 243: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

239:
240:
241: PROCEDURE insert_excl_prod(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
244: p_commit IN VARCHAR2 := FND_API.g_false,
245: p_context IN VARCHAR2,
246: p_attribute IN VARCHAR2,
247: p_attr_value IN VARCHAR2,

Line 244: p_commit IN VARCHAR2 := FND_API.g_false,

240:
241: PROCEDURE insert_excl_prod(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
244: p_commit IN VARCHAR2 := FND_API.g_false,
245: p_context IN VARCHAR2,
246: p_attribute IN VARCHAR2,
247: p_attr_value IN VARCHAR2,
248: x_return_status OUT NOCOPY VARCHAR2,

Line 274: IF FND_API.to_boolean(p_init_msg_list) THEN

270: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
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,

Line 278: IF NOT FND_API.compatible_api_call(l_api_version,

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,
280: l_api_name,
281: g_pkg_name)
282: THEN

Line 283: RAISE FND_API.g_exc_unexpected_error;

279: p_api_version,
280: l_api_name,
281: g_pkg_name)
282: THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;
285:
286: x_return_status := FND_API.g_ret_sts_success;
287:

Line 286: x_return_status := FND_API.g_ret_sts_success;

282: THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;
285:
286: x_return_status := FND_API.g_ret_sts_success;
287:
288: IF p_attribute = 'PRICING_ATTRIBUTE1' THEN
289: INSERT INTO ozf_search_selections_t(attribute_value, attribute_id) VALUES(p_attr_value, p_attribute);
290: ELSE

Line 311: x_return_status := FND_API.g_ret_sts_unexp_error;

307:
308: EXCEPTION
309: WHEN OTHERS THEN
310: write_conc_log('-- insert_excl_prod failed - '|| SQLERRM || ' ' );
311: x_return_status := FND_API.g_ret_sts_unexp_error;
312:
313: write_conc_log('1:' || SUBSTR(l_prod_stmt, 1, 250));
314: write_conc_log('2:' || SUBSTR(l_prod_stmt, 251, 250));
315: write_conc_log('3:' || SUBSTR(l_prod_stmt, 501, 250));

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 539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

535: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
536: ---------------------------------------------------------------------
537: PROCEDURE refresh_netaccrual_parties(
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
540: p_commit IN VARCHAR2 := FND_API.g_false,
541:
542: p_list_header_id IN NUMBER,
543: p_calling_from_den IN VARCHAR2,

Line 540: p_commit IN VARCHAR2 := FND_API.g_false,

536: ---------------------------------------------------------------------
537: PROCEDURE refresh_netaccrual_parties(
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
540: p_commit IN VARCHAR2 := FND_API.g_false,
541:
542: p_list_header_id IN NUMBER,
543: p_calling_from_den IN VARCHAR2,
544:

Line 615: x_return_status := FND_API.g_ret_sts_success;

611: ozf_utility_pvt.write_conc_log(l_full_name ||
612: ': Start refresh netaccrual parties' ||
613: '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
614:
615: x_return_status := FND_API.g_ret_sts_success;
616:
617: OPEN c_offer_id;
618: FETCH c_offer_id INTO l_offer_id;
619: CLOSE c_offer_id;

Line 676: x_return_status := FND_API.g_ret_sts_unexp_error;

672: END IF;
673:
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;

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 708: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

704: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
705: ----------------------------------------------------------------------
706: PROCEDURE refresh_netaccrual_products(
707: p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710:
711: p_list_header_id IN NUMBER,
712: p_calling_from_den IN VARCHAR2,

Line 709: p_commit IN VARCHAR2 := FND_API.g_false,

705: ----------------------------------------------------------------------
706: PROCEDURE refresh_netaccrual_products(
707: p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710:
711: p_list_header_id IN NUMBER,
712: p_calling_from_den IN VARCHAR2,
713:

Line 784: IF FND_API.to_boolean(p_init_msg_list) THEN

780: BEGIN
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,

Line 788: IF NOT FND_API.compatible_api_call(l_api_version,

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,
790: l_api_name,
791: g_pkg_name)
792: THEN

Line 793: RAISE FND_API.g_exc_unexpected_error;

789: p_api_version,
790: l_api_name,
791: g_pkg_name)
792: THEN
793: RAISE FND_API.g_exc_unexpected_error;
794: END IF;
795:
796: x_return_status := FND_API.g_ret_sts_success;
797: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

Line 796: x_return_status := FND_API.g_ret_sts_success;

792: THEN
793: RAISE FND_API.g_exc_unexpected_error;
794: END IF;
795:
796: x_return_status := FND_API.g_ret_sts_success;
797: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
798: l_context := 'ITEM';
799:
800: OPEN c_offer_id;

Line 901: x_return_status := FND_API.g_ret_sts_unexp_error;

897:
898: EXCEPTION
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;

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 933: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

929: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
930: ----------------------------------------------------------------------
931: PROCEDURE refresh_volume_products(
932: p_api_version IN NUMBER,
933: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
934: p_commit IN VARCHAR2 := FND_API.g_false,
935:
936: p_list_header_id IN NUMBER,
937: p_calling_from_den IN VARCHAR2,

Line 934: p_commit IN VARCHAR2 := FND_API.g_false,

930: ----------------------------------------------------------------------
931: PROCEDURE refresh_volume_products(
932: p_api_version IN NUMBER,
933: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
934: p_commit IN VARCHAR2 := FND_API.g_false,
935:
936: p_list_header_id IN NUMBER,
937: p_calling_from_den IN VARCHAR2,
938:

Line 1032: IF FND_API.to_boolean(p_init_msg_list) THEN

1028:
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,

Line 1036: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1038: l_api_name,
1039: g_pkg_name)
1040: THEN

Line 1041: RAISE FND_API.g_exc_unexpected_error;

1037: p_api_version,
1038: l_api_name,
1039: g_pkg_name)
1040: THEN
1041: RAISE FND_API.g_exc_unexpected_error;
1042: END IF;
1043:
1044: x_return_status := FND_API.g_ret_sts_success;
1045: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

Line 1044: x_return_status := FND_API.g_ret_sts_success;

1040: THEN
1041: RAISE FND_API.g_exc_unexpected_error;
1042: END IF;
1043:
1044: x_return_status := FND_API.g_ret_sts_success;
1045: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
1046: l_context := 'ITEM';
1047:
1048: OPEN c_offer_id(p_list_header_id);

Line 1166: x_return_status := FND_API.g_ret_sts_unexp_error;

1162:
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:

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 1184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1180: END refresh_volume_products;
1181:
1182: PROCEDURE refresh_lumpsum_parties(
1183: p_api_version IN NUMBER,
1184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1185: p_commit IN VARCHAR2 := FND_API.g_false,
1186:
1187: p_list_header_id IN NUMBER,
1188: p_calling_from_den IN VARCHAR2,

Line 1185: p_commit IN VARCHAR2 := FND_API.g_false,

1181:
1182: PROCEDURE refresh_lumpsum_parties(
1183: p_api_version IN NUMBER,
1184: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1185: p_commit IN VARCHAR2 := FND_API.g_false,
1186:
1187: p_list_header_id IN NUMBER,
1188: p_calling_from_den IN VARCHAR2,
1189:

Line 1233: x_return_status := FND_API.g_ret_sts_success;

1229: ozf_utility_pvt.write_conc_log(l_full_name ||
1230: ': Start refresh lumpsum parties' ||
1231: '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1232:
1233: x_return_status := FND_API.g_ret_sts_success;
1234:
1235: OPEN c_qualifier_exists;
1236: FETCH c_qualifier_exists INTO l_qualifier_exists;
1237: CLOSE c_qualifier_exists;

Line 1287: x_return_status := FND_API.g_ret_sts_unexp_error;

1283:
1284:
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;

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 1319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1315: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1316: ---------------------------------------------------------------------
1317: PROCEDURE refresh_volume_parties(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1320: p_commit IN VARCHAR2 := FND_API.g_false,
1321:
1322: p_list_header_id IN NUMBER,
1323: p_calling_from_den IN VARCHAR2,

Line 1320: p_commit IN VARCHAR2 := FND_API.g_false,

1316: ---------------------------------------------------------------------
1317: PROCEDURE refresh_volume_parties(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1320: p_commit IN VARCHAR2 := FND_API.g_false,
1321:
1322: p_list_header_id IN NUMBER,
1323: p_calling_from_den IN VARCHAR2,
1324:

Line 1429: x_return_status := FND_API.g_ret_sts_success;

1425: ozf_utility_pvt.write_conc_log(l_full_name ||
1426: ': Start refresh volume parties' ||
1427: '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1428:
1429: x_return_status := FND_API.g_ret_sts_success;
1430:
1431: OPEN c_no_groups;
1432: FETCH c_no_groups INTO l_no_groups;
1433: CLOSE c_no_groups;

Line 1546: x_return_status := FND_API.g_ret_sts_unexp_error;

1542:
1543:
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;

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 1578: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1574: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1575: ---------------------------------------------------------------------
1576: PROCEDURE refresh_parties(
1577: p_api_version IN NUMBER,
1578: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1579: p_commit IN VARCHAR2 := FND_API.g_false,
1580:
1581: p_list_header_id IN NUMBER,
1582: p_calling_from_den IN VARCHAR2,

Line 1579: p_commit IN VARCHAR2 := FND_API.g_false,

1575: ---------------------------------------------------------------------
1576: PROCEDURE refresh_parties(
1577: p_api_version IN NUMBER,
1578: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1579: p_commit IN VARCHAR2 := FND_API.g_false,
1580:
1581: p_list_header_id IN NUMBER,
1582: p_calling_from_den IN VARCHAR2,
1583:

Line 1684: IF FND_API.to_boolean(p_init_msg_list) THEN

1680:
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,

Line 1688: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1690: l_api_name,
1691: g_pkg_name)
1692: THEN

Line 1693: RAISE FND_API.g_exc_unexpected_error;

1689: p_api_version,
1690: l_api_name,
1691: g_pkg_name)
1692: THEN
1693: RAISE FND_API.g_exc_unexpected_error;
1694: END IF;
1695:
1696: x_return_status := FND_API.g_ret_sts_success;
1697:

Line 1696: x_return_status := FND_API.g_ret_sts_success;

1692: THEN
1693: RAISE FND_API.g_exc_unexpected_error;
1694: END IF;
1695:
1696: x_return_status := FND_API.g_ret_sts_success;
1697:
1698:
1699: OPEN c_offer_type;
1700: FETCH c_offer_type INTO l_offer_type;

Line 1814: x_return_status := FND_API.g_ret_sts_unexp_error;

1810:
1811: EXCEPTION
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;

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 1848: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1844: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
1845: ----------------------------------------------------------------------
1846: PROCEDURE refresh_lumpsum_products(
1847: p_api_version IN NUMBER,
1848: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1849: p_commit IN VARCHAR2 := FND_API.g_false,
1850:
1851: p_list_header_id IN NUMBER,
1852: p_calling_from_den IN VARCHAR2,

Line 1849: p_commit IN VARCHAR2 := FND_API.g_false,

1845: ----------------------------------------------------------------------
1846: PROCEDURE refresh_lumpsum_products(
1847: p_api_version IN NUMBER,
1848: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1849: p_commit IN VARCHAR2 := FND_API.g_false,
1850:
1851: p_list_header_id IN NUMBER,
1852: p_calling_from_den IN VARCHAR2,
1853:

Line 1925: IF FND_API.to_boolean(p_init_msg_list) THEN

1921: BEGIN
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,

Line 1929: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1931: l_api_name,
1932: g_pkg_name)
1933: THEN

Line 1934: RAISE FND_API.g_exc_unexpected_error;

1930: p_api_version,
1931: l_api_name,
1932: g_pkg_name)
1933: THEN
1934: RAISE FND_API.g_exc_unexpected_error;
1935: END IF;
1936:
1937: x_return_status := FND_API.g_ret_sts_success;
1938: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

Line 1937: x_return_status := FND_API.g_ret_sts_success;

1933: THEN
1934: RAISE FND_API.g_exc_unexpected_error;
1935: END IF;
1936:
1937: x_return_status := FND_API.g_ret_sts_success;
1938: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
1939: l_context := 'ITEM';
1940:
1941: OPEN c_no_products(p_list_header_id, l_org_id);

Line 2032: x_return_status := FND_API.g_ret_sts_unexp_error;

2028:
2029: EXCEPTION
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;

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 2063: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2059: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
2060: ----------------------------------------------------------------------
2061: PROCEDURE refresh_products(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2064: p_commit IN VARCHAR2 := FND_API.g_false,
2065:
2066: p_list_header_id IN NUMBER,
2067: p_calling_from_den IN VARCHAR2,

Line 2064: p_commit IN VARCHAR2 := FND_API.g_false,

2060: ----------------------------------------------------------------------
2061: PROCEDURE refresh_products(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2064: p_commit IN VARCHAR2 := FND_API.g_false,
2065:
2066: p_list_header_id IN NUMBER,
2067: p_calling_from_den IN VARCHAR2,
2068:

Line 2145: IF FND_API.to_boolean(p_init_msg_list) THEN

2141:
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,

Line 2149: IF NOT FND_API.compatible_api_call(l_api_version,

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,
2151: l_api_name,
2152: g_pkg_name)
2153: THEN

Line 2154: RAISE FND_API.g_exc_unexpected_error;

2150: p_api_version,
2151: l_api_name,
2152: g_pkg_name)
2153: THEN
2154: RAISE FND_API.g_exc_unexpected_error;
2155: END IF;
2156:
2157: x_return_status := FND_API.g_ret_sts_success;
2158:

Line 2157: x_return_status := FND_API.g_ret_sts_success;

2153: THEN
2154: RAISE FND_API.g_exc_unexpected_error;
2155: END IF;
2156:
2157: x_return_status := FND_API.g_ret_sts_success;
2158:
2159: OPEN c_offer_type;
2160: FETCH c_offer_type INTO l_offer_type;
2161: CLOSE c_offer_type;

Line 2308: x_return_status := FND_API.g_ret_sts_unexp_error;

2304:
2305: WHEN OTHERS 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;

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;

Line 2766: IF NOT FND_API.compatible_api_call(l_api_version,

2762: --write_log('-- l_increment_flag is : '|| l_increment_flag );
2763: ozf_utility_pvt.write_conc_log('-- l_org_id is : '|| l_org_id );
2764: ozf_utility_pvt.write_conc_log('-- l_latest_comp_date is : '|| p_latest_comp_date );
2765:
2766: IF NOT FND_API.compatible_api_call(l_api_version,
2767: l_api_version,
2768: l_api_name,
2769: g_pkg_name)
2770: THEN

Line 2771: RAISE FND_API.g_exc_unexpected_error;

2767: l_api_version,
2768: l_api_name,
2769: g_pkg_name)
2770: THEN
2771: RAISE FND_API.g_exc_unexpected_error;
2772: END IF;
2773:
2774: l_latest_comp_date := NVL(p_latest_comp_date, TO_DATE('01/01/1952','MM/DD/YYYY'));
2775: ozf_utility_pvt.write_conc_log('-- Full Refersh Start --');

Line 2915: p_init_msg_list => FND_API.g_false,

2911: --ozf_utility_pvt.write_conc_log('Before refresh parties');
2912:
2913: /* refresh parties would get all the parties for the list_header_id and add to FND_DSQL*/
2914: refresh_parties(p_api_version => l_api_version,
2915: p_init_msg_list => FND_API.g_false,
2916: p_commit => FND_API.g_false,
2917: p_list_header_id => i.object_id,
2918: p_calling_from_den => 'Y',
2919: x_return_status => l_return_status,

Line 2916: p_commit => FND_API.g_false,

2912:
2913: /* refresh parties would get all the parties for the list_header_id and add to FND_DSQL*/
2914: refresh_parties(p_api_version => l_api_version,
2915: p_init_msg_list => FND_API.g_false,
2916: p_commit => FND_API.g_false,
2917: p_list_header_id => i.object_id,
2918: p_calling_from_den => 'Y',
2919: x_return_status => l_return_status,
2920: x_msg_count => l_msg_count,

Line 2934: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2930: write_conc_log('6:' || SUBSTR(l_stmt_offer, 1251, 250));
2931: write_conc_log('7:' || SUBSTR(l_stmt_offer, 1501, 250));*/
2932:
2933: --ozf_utility_pvt.write_conc_log('After refresh parties');
2934: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2935: RAISE FND_API.g_exc_unexpected_error;
2936: END IF;
2937:
2938: IF l_stmt_offer IS NOT NULL THEN

Line 2935: RAISE FND_API.g_exc_unexpected_error;

2931: write_conc_log('7:' || SUBSTR(l_stmt_offer, 1501, 250));*/
2932:
2933: --ozf_utility_pvt.write_conc_log('After refresh parties');
2934: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2935: RAISE FND_API.g_exc_unexpected_error;
2936: END IF;
2937:
2938: IF l_stmt_offer IS NOT NULL THEN
2939: FND_DSQL.add_text(' UNION select -1 qp_qualifier_id, -1 qp_qualifier_group,-1 party_id, -1 cust_account_id, -1 cust_acct_site_id, ');

Line 3028: p_init_msg_list => FND_API.g_false,

3024: -- FND_DSQL.add_text(',discount_line_id,apply_discount,include_volume, product_id, product_type FROM (');
3025: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3026:
3027: refresh_products(p_api_version => l_api_version,
3028: p_init_msg_list => FND_API.g_false,
3029: p_commit => FND_API.g_false,
3030: p_list_header_id => i.object_id,
3031: p_calling_from_den => 'Y',
3032: x_return_status => l_return_status,

Line 3029: p_commit => FND_API.g_false,

3025: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3026:
3027: refresh_products(p_api_version => l_api_version,
3028: p_init_msg_list => FND_API.g_false,
3029: p_commit => FND_API.g_false,
3030: p_list_header_id => i.object_id,
3031: p_calling_from_den => 'Y',
3032: x_return_status => l_return_status,
3033: x_msg_count => l_msg_count,

Line 3038: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3034: x_msg_data => l_msg_data,
3035: x_product_stmt => l_stmt_product,
3036: p_lline_id => x.lline_id);
3037:
3038: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3039: RAISE FND_API.g_exc_unexpected_error;
3040: END IF;
3041:
3042: ozf_utility_pvt.write_conc_log ('-- 1 --');

Line 3039: RAISE FND_API.g_exc_unexpected_error;

3035: x_product_stmt => l_stmt_product,
3036: p_lline_id => x.lline_id);
3037:
3038: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3039: RAISE FND_API.g_exc_unexpected_error;
3040: END IF;
3041:
3042: ozf_utility_pvt.write_conc_log ('-- 1 --');
3043:

Line 3273: p_init_msg_list => FND_API.g_false,

3269: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
3270: FND_DSQL.add_text(' FROM (');
3271:
3272: refresh_parties(p_api_version => l_api_version,
3273: p_init_msg_list => FND_API.g_false,
3274: p_commit => FND_API.g_false,
3275: p_list_header_id => i.object_id,
3276: p_calling_from_den => 'Y',
3277: x_return_status => l_return_status,

Line 3274: p_commit => FND_API.g_false,

3270: FND_DSQL.add_text(' FROM (');
3271:
3272: refresh_parties(p_api_version => l_api_version,
3273: p_init_msg_list => FND_API.g_false,
3274: p_commit => FND_API.g_false,
3275: p_list_header_id => i.object_id,
3276: p_calling_from_den => 'Y',
3277: x_return_status => l_return_status,
3278: x_msg_count => l_msg_count,

Line 3283: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3279: x_msg_data => l_msg_data,
3280: x_party_stmt => l_stmt_offer,
3281: p_qnum => z.qnum);
3282:
3283: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3284: RAISE FND_API.g_exc_unexpected_error;
3285: END IF;
3286:
3287: ozf_utility_pvt.write_conc_log('l_stmt_offer '||l_stmt_offer);

Line 3284: RAISE FND_API.g_exc_unexpected_error;

3280: x_party_stmt => l_stmt_offer,
3281: p_qnum => z.qnum);
3282:
3283: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3284: RAISE FND_API.g_exc_unexpected_error;
3285: END IF;
3286:
3287: ozf_utility_pvt.write_conc_log('l_stmt_offer '||l_stmt_offer);
3288:

Line 3378: p_init_msg_list => FND_API.g_false,

3374: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3375:
3376:
3377: refresh_products(p_api_version => l_api_version,
3378: p_init_msg_list => FND_API.g_false,
3379: p_commit => FND_API.g_false,
3380: p_list_header_id => i.object_id,
3381: p_calling_from_den => 'Y',
3382: x_return_status => l_return_status,

Line 3379: p_commit => FND_API.g_false,

3375:
3376:
3377: refresh_products(p_api_version => l_api_version,
3378: p_init_msg_list => FND_API.g_false,
3379: p_commit => FND_API.g_false,
3380: p_list_header_id => i.object_id,
3381: p_calling_from_den => 'Y',
3382: x_return_status => l_return_status,
3383: x_msg_count => l_msg_count,

Line 3390: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3386: p_lline_id => x.lline_id);
3387:
3388: --write_log('After Refresh products- offer has changed');
3389:
3390: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3391: RAISE FND_API.g_exc_unexpected_error;
3392: END IF;
3393:
3394: --write_log('one');

Line 3391: RAISE FND_API.g_exc_unexpected_error;

3387:
3388: --write_log('After Refresh products- offer has changed');
3389:
3390: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3391: RAISE FND_API.g_exc_unexpected_error;
3392: END IF;
3393:
3394: --write_log('one');
3395: IF l_stmt_product IS NOT NULL THEN

Line 3487: p_init_msg_list => FND_API.g_false,

3483: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''QUALIFIER_ATTRIBUTE14'',''SHIP_TO'',''QUALIFIER_ATTRIBUTE11'',substr(site_use_code,INSTR(site_use_code,'':'')+1)) qualifier_attribute,');
3484: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
3485: FND_DSQL.add_text(' FROM (');
3486: refresh_parties(p_api_version => l_api_version,
3487: p_init_msg_list => FND_API.g_false,
3488: p_commit => FND_API.g_false,
3489: p_list_header_id => i.object_id,
3490: p_calling_from_den => 'Y',
3491: x_return_status => l_return_status,

Line 3488: p_commit => FND_API.g_false,

3484: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
3485: FND_DSQL.add_text(' FROM (');
3486: refresh_parties(p_api_version => l_api_version,
3487: p_init_msg_list => FND_API.g_false,
3488: p_commit => FND_API.g_false,
3489: p_list_header_id => i.object_id,
3490: p_calling_from_den => 'Y',
3491: x_return_status => l_return_status,
3492: x_msg_count => l_msg_count,

Line 3497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3493: x_msg_data => l_msg_data,
3494: x_party_stmt => l_stmt_offer,
3495: p_qnum => z.qnum);
3496:
3497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3498: RAISE FND_API.g_exc_unexpected_error;
3499: END IF;
3500:
3501: IF l_stmt_offer IS NOT NULL THEN

Line 3498: RAISE FND_API.g_exc_unexpected_error;

3494: x_party_stmt => l_stmt_offer,
3495: p_qnum => z.qnum);
3496:
3497: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3498: RAISE FND_API.g_exc_unexpected_error;
3499: END IF;
3500:
3501: IF l_stmt_offer IS NOT NULL THEN
3502: --FND_DSQL.add_text(')');

Line 3593: p_init_msg_list => FND_API.g_false,

3589: -- FND_DSQL.add_text(',discount_line_id,apply_discount,include_volume, product_id, product_type FROM (');
3590: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3591:
3592: refresh_products(p_api_version => l_api_version,
3593: p_init_msg_list => FND_API.g_false,
3594: p_commit => FND_API.g_false,
3595: p_list_header_id => i.object_id,
3596: p_calling_from_den => 'Y',
3597: x_return_status => l_return_status,

Line 3594: p_commit => FND_API.g_false,

3590: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3591:
3592: refresh_products(p_api_version => l_api_version,
3593: p_init_msg_list => FND_API.g_false,
3594: p_commit => FND_API.g_false,
3595: p_list_header_id => i.object_id,
3596: p_calling_from_den => 'Y',
3597: x_return_status => l_return_status,
3598: x_msg_count => l_msg_count,

Line 3605: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3601: p_lline_id => x.lline_id);
3602:
3603: --write_log('After Refresh products- offer has not changed');
3604:
3605: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:
3609: IF l_stmt_product IS NOT NULL THEN

Line 3606: RAISE FND_API.g_exc_unexpected_error;

3602:
3603: --write_log('After Refresh products- offer has not changed');
3604:
3605: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:
3609: IF l_stmt_product IS NOT NULL THEN
3610: --FND_DSQL.add_text(')');

Line 4099: WHEN FND_API.G_EXC_ERROR THEN

4095: --utl_file.fflush( a );
4096: --utl_file.fclose( a );
4097:
4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: ozf_utility_pvt.write_conc_log('-- Expected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4101: x_return_status := FND_API.g_ret_sts_error ;
4102: ERRBUF := l_msg_data;
4103: RETCODE := 2;

Line 4101: x_return_status := FND_API.g_ret_sts_error ;

4097:
4098: EXCEPTION
4099: WHEN FND_API.G_EXC_ERROR THEN
4100: ozf_utility_pvt.write_conc_log('-- Expected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4101: x_return_status := FND_API.g_ret_sts_error ;
4102: ERRBUF := l_msg_data;
4103: RETCODE := 2;
4104:
4105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4101: x_return_status := FND_API.g_ret_sts_error ;
4102: ERRBUF := l_msg_data;
4103: RETCODE := 2;
4104:
4105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4106: ozf_utility_pvt.write_conc_log('-- Unexpected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4107: x_return_status := FND_API.g_ret_sts_unexp_error ;
4108: ERRBUF := l_msg_data;
4109: RETCODE := 2;

Line 4107: x_return_status := FND_API.g_ret_sts_unexp_error ;

4103: RETCODE := 2;
4104:
4105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4106: ozf_utility_pvt.write_conc_log('-- Unexpected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4107: x_return_status := FND_API.g_ret_sts_unexp_error ;
4108: ERRBUF := l_msg_data;
4109: RETCODE := 2;
4110:
4111: WHEN OTHERS THEN

Line 4115: x_return_status := FND_API.g_ret_sts_unexp_error ;

4111: WHEN OTHERS THEN
4112: -- ROLLBACK TO refresh_denorm;
4113: ozf_utility_pvt.write_conc_log('-- Others - '|| SQLERRM || ' ' || l_stmt_denorm);
4114: ROLLBACK TO refresh_denorm;
4115: x_return_status := FND_API.g_ret_sts_unexp_error ;
4116: ERRBUF := SQLERRM || ' ' || l_stmt_denorm;
4117: RETCODE := sqlcode;
4118:
4119:

Line 4480: p_init_msg_list => FND_API.g_false,

4476: end if;
4477:
4478: ozf_forecast_util_pvt.get_list_price(
4479: p_api_version => l_api_version,
4480: p_init_msg_list => FND_API.g_false,
4481: p_commit => FND_API.g_false,
4482: p_obj_type => 'OFFR',
4483: p_obj_id => p_offer_id,
4484: p_forecast_id => j.forecast_id,

Line 4481: p_commit => FND_API.g_false,

4477:
4478: ozf_forecast_util_pvt.get_list_price(
4479: p_api_version => l_api_version,
4480: p_init_msg_list => FND_API.g_false,
4481: p_commit => FND_API.g_false,
4482: p_obj_type => 'OFFR',
4483: p_obj_id => p_offer_id,
4484: p_forecast_id => j.forecast_id,
4485: p_product_attribute => j.product_attribute,

Line 4572: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

4568: p_cust_acct_id IN NUMBER := NULL,
4569: p_cust_site_id IN NUMBER := NULL,
4570:
4571: p_api_version IN NUMBER,
4572: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4573: p_commit IN VARCHAR2 := FND_API.g_false,
4574:
4575: x_return_status OUT NOCOPY VARCHAR2,
4576: x_msg_count OUT NOCOPY NUMBER,

Line 4573: p_commit IN VARCHAR2 := FND_API.g_false,

4569: p_cust_site_id IN NUMBER := NULL,
4570:
4571: p_api_version IN NUMBER,
4572: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4573: p_commit IN VARCHAR2 := FND_API.g_false,
4574:
4575: x_return_status OUT NOCOPY VARCHAR2,
4576: x_msg_count OUT NOCOPY NUMBER,
4577: x_msg_data OUT NOCOPY VARCHAR2,

Line 4638: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

4634: p_cust_acct_id IN NUMBER := NULL,
4635: p_cust_site_id IN NUMBER := NULL,
4636:
4637: p_api_version IN NUMBER,
4638: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4639: p_commit IN VARCHAR2 := FND_API.g_false,
4640:
4641: x_return_status OUT NOCOPY VARCHAR2,
4642: x_msg_count OUT NOCOPY NUMBER,

Line 4639: p_commit IN VARCHAR2 := FND_API.g_false,

4635: p_cust_site_id IN NUMBER := NULL,
4636:
4637: p_api_version IN NUMBER,
4638: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4639: p_commit IN VARCHAR2 := FND_API.g_false,
4640:
4641: x_return_status OUT NOCOPY VARCHAR2,
4642: x_msg_count OUT NOCOPY NUMBER,
4643: x_msg_data OUT NOCOPY VARCHAR2,

Line 4696: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

4692: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
4693: ----------------------------------------------------------------------
4694: PROCEDURE get_party_product_stmt(
4695: p_api_version IN NUMBER,
4696: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4697: p_commit IN VARCHAR2 := FND_API.g_false,
4698:
4699: p_list_header_id IN NUMBER,
4700:

Line 4697: p_commit IN VARCHAR2 := FND_API.g_false,

4693: ----------------------------------------------------------------------
4694: PROCEDURE get_party_product_stmt(
4695: p_api_version IN NUMBER,
4696: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4697: p_commit IN VARCHAR2 := FND_API.g_false,
4698:
4699: p_list_header_id IN NUMBER,
4700:
4701: x_return_status OUT NOCOPY VARCHAR2,