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 679: x_return_status := FND_API.g_ret_sts_unexp_error;

675: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
676:
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;

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

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

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

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

Line 787: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 791: IF NOT FND_API.compatible_api_call(l_api_version,

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,
793: l_api_name,
794: g_pkg_name)
795: THEN

Line 796: RAISE FND_API.g_exc_unexpected_error;

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

Line 799: x_return_status := FND_API.g_ret_sts_success;

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

Line 892: x_return_status := FND_API.g_ret_sts_unexp_error;

888:
889: EXCEPTION
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;

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

920: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
921: ----------------------------------------------------------------------
922: PROCEDURE refresh_volume_products(
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
925: p_commit IN VARCHAR2 := FND_API.g_false,
926:
927: p_list_header_id IN NUMBER,
928: p_calling_from_den IN VARCHAR2,

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

921: ----------------------------------------------------------------------
922: PROCEDURE refresh_volume_products(
923: p_api_version IN NUMBER,
924: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
925: p_commit IN VARCHAR2 := FND_API.g_false,
926:
927: p_list_header_id IN NUMBER,
928: p_calling_from_den IN VARCHAR2,
929:

Line 1023: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 1027: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1029: l_api_name,
1030: g_pkg_name)
1031: THEN

Line 1032: RAISE FND_API.g_exc_unexpected_error;

1028: p_api_version,
1029: l_api_name,
1030: g_pkg_name)
1031: THEN
1032: RAISE FND_API.g_exc_unexpected_error;
1033: END IF;
1034:
1035: x_return_status := FND_API.g_ret_sts_success;
1036: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

Line 1035: x_return_status := FND_API.g_ret_sts_success;

1031: THEN
1032: RAISE FND_API.g_exc_unexpected_error;
1033: END IF;
1034:
1035: x_return_status := FND_API.g_ret_sts_success;
1036: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
1037: l_context := 'ITEM';
1038:
1039: OPEN c_offer_id(p_list_header_id);

Line 1145: x_return_status := FND_API.g_ret_sts_unexp_error;

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

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

1159: END refresh_volume_products;
1160:
1161: PROCEDURE refresh_lumpsum_parties(
1162: p_api_version IN NUMBER,
1163: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1164: p_commit IN VARCHAR2 := FND_API.g_false,
1165:
1166: p_list_header_id IN NUMBER,
1167: p_calling_from_den IN VARCHAR2,

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

1160:
1161: PROCEDURE refresh_lumpsum_parties(
1162: p_api_version IN NUMBER,
1163: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1164: p_commit IN VARCHAR2 := FND_API.g_false,
1165:
1166: p_list_header_id IN NUMBER,
1167: p_calling_from_den IN VARCHAR2,
1168:

Line 1212: x_return_status := FND_API.g_ret_sts_success;

1208: ozf_utility_pvt.write_conc_log(l_full_name ||
1209: ': Start refresh lumpsum parties' ||
1210: '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1211:
1212: x_return_status := FND_API.g_ret_sts_success;
1213:
1214: OPEN c_qualifier_exists;
1215: FETCH c_qualifier_exists INTO l_qualifier_exists;
1216: CLOSE c_qualifier_exists;

Line 1267: x_return_status := FND_API.g_ret_sts_unexp_error;

1263: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1264:
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;

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

1295: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1296: ---------------------------------------------------------------------
1297: PROCEDURE refresh_volume_parties(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1300: p_commit IN VARCHAR2 := FND_API.g_false,
1301:
1302: p_list_header_id IN NUMBER,
1303: p_calling_from_den IN VARCHAR2,

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

1296: ---------------------------------------------------------------------
1297: PROCEDURE refresh_volume_parties(
1298: p_api_version IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1300: p_commit IN VARCHAR2 := FND_API.g_false,
1301:
1302: p_list_header_id IN NUMBER,
1303: p_calling_from_den IN VARCHAR2,
1304:

Line 1409: x_return_status := FND_API.g_ret_sts_success;

1405: ozf_utility_pvt.write_conc_log(l_full_name ||
1406: ': Start refresh volume parties' ||
1407: '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
1408:
1409: x_return_status := FND_API.g_ret_sts_success;
1410:
1411: OPEN c_no_groups;
1412: FETCH c_no_groups INTO l_no_groups;
1413: CLOSE c_no_groups;

Line 1527: x_return_status := FND_API.g_ret_sts_unexp_error;

1523: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1524:
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;

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

1555: -- This procedure calls get_sql, builds SQL statment for parties and refresh ozf_activity_customers
1556: ---------------------------------------------------------------------
1557: PROCEDURE refresh_parties(
1558: p_api_version IN NUMBER,
1559: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1560: p_commit IN VARCHAR2 := FND_API.g_false,
1561:
1562: p_list_header_id IN NUMBER,
1563: p_calling_from_den IN VARCHAR2,

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

1556: ---------------------------------------------------------------------
1557: PROCEDURE refresh_parties(
1558: p_api_version IN NUMBER,
1559: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1560: p_commit IN VARCHAR2 := FND_API.g_false,
1561:
1562: p_list_header_id IN NUMBER,
1563: p_calling_from_den IN VARCHAR2,
1564:

Line 1665: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 1669: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1671: l_api_name,
1672: g_pkg_name)
1673: THEN

Line 1674: RAISE FND_API.g_exc_unexpected_error;

1670: p_api_version,
1671: l_api_name,
1672: g_pkg_name)
1673: THEN
1674: RAISE FND_API.g_exc_unexpected_error;
1675: END IF;
1676:
1677: x_return_status := FND_API.g_ret_sts_success;
1678:

Line 1677: x_return_status := FND_API.g_ret_sts_success;

1673: THEN
1674: RAISE FND_API.g_exc_unexpected_error;
1675: END IF;
1676:
1677: x_return_status := FND_API.g_ret_sts_success;
1678:
1679:
1680: OPEN c_offer_type;
1681: FETCH c_offer_type INTO l_offer_type;

Line 1791: x_return_status := FND_API.g_ret_sts_unexp_error;

1787:
1788: EXCEPTION
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;

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

1821: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
1822: ----------------------------------------------------------------------
1823: PROCEDURE refresh_lumpsum_products(
1824: p_api_version IN NUMBER,
1825: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1826: p_commit IN VARCHAR2 := FND_API.g_false,
1827:
1828: p_list_header_id IN NUMBER,
1829: p_calling_from_den IN VARCHAR2,

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

1822: ----------------------------------------------------------------------
1823: PROCEDURE refresh_lumpsum_products(
1824: p_api_version IN NUMBER,
1825: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1826: p_commit IN VARCHAR2 := FND_API.g_false,
1827:
1828: p_list_header_id IN NUMBER,
1829: p_calling_from_den IN VARCHAR2,
1830:

Line 1902: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 1906: IF NOT FND_API.compatible_api_call(l_api_version,

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,
1908: l_api_name,
1909: g_pkg_name)
1910: THEN

Line 1911: RAISE FND_API.g_exc_unexpected_error;

1907: p_api_version,
1908: l_api_name,
1909: g_pkg_name)
1910: THEN
1911: RAISE FND_API.g_exc_unexpected_error;
1912: END IF;
1913:
1914: x_return_status := FND_API.g_ret_sts_success;
1915: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');

Line 1914: x_return_status := FND_API.g_ret_sts_success;

1910: THEN
1911: RAISE FND_API.g_exc_unexpected_error;
1912: END IF;
1913:
1914: x_return_status := FND_API.g_ret_sts_success;
1915: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
1916: l_context := 'ITEM';
1917:
1918: OPEN c_no_products(p_list_header_id, l_org_id);

Line 1998: x_return_status := FND_API.g_ret_sts_unexp_error;

1994:
1995: EXCEPTION
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;

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

2025: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
2026: ----------------------------------------------------------------------
2027: PROCEDURE refresh_products(
2028: p_api_version IN NUMBER,
2029: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2030: p_commit IN VARCHAR2 := FND_API.g_false,
2031:
2032: p_list_header_id IN NUMBER,
2033: p_calling_from_den IN VARCHAR2,

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

2026: ----------------------------------------------------------------------
2027: PROCEDURE refresh_products(
2028: p_api_version IN NUMBER,
2029: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2030: p_commit IN VARCHAR2 := FND_API.g_false,
2031:
2032: p_list_header_id IN NUMBER,
2033: p_calling_from_den IN VARCHAR2,
2034:

Line 2111: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 2115: IF NOT FND_API.compatible_api_call(l_api_version,

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,
2117: l_api_name,
2118: g_pkg_name)
2119: THEN

Line 2120: RAISE FND_API.g_exc_unexpected_error;

2116: p_api_version,
2117: l_api_name,
2118: g_pkg_name)
2119: THEN
2120: RAISE FND_API.g_exc_unexpected_error;
2121: END IF;
2122:
2123: x_return_status := FND_API.g_ret_sts_success;
2124:

Line 2123: x_return_status := FND_API.g_ret_sts_success;

2119: THEN
2120: RAISE FND_API.g_exc_unexpected_error;
2121: END IF;
2122:
2123: x_return_status := FND_API.g_ret_sts_success;
2124:
2125: OPEN c_offer_type;
2126: FETCH c_offer_type INTO l_offer_type;
2127: CLOSE c_offer_type;

Line 2251: x_return_status := FND_API.g_ret_sts_unexp_error;

2247:
2248: WHEN OTHERS THEN
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;

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;

Line 2709: IF NOT FND_API.compatible_api_call(l_api_version,

2705: --write_log('-- l_increment_flag is : '|| l_increment_flag );
2706: ozf_utility_pvt.write_conc_log('-- l_org_id is : '|| l_org_id );
2707: ozf_utility_pvt.write_conc_log('-- l_latest_comp_date is : '|| p_latest_comp_date );
2708:
2709: IF NOT FND_API.compatible_api_call(l_api_version,
2710: l_api_version,
2711: l_api_name,
2712: g_pkg_name)
2713: THEN

Line 2714: RAISE FND_API.g_exc_unexpected_error;

2710: l_api_version,
2711: l_api_name,
2712: g_pkg_name)
2713: THEN
2714: RAISE FND_API.g_exc_unexpected_error;
2715: END IF;
2716:
2717: l_latest_comp_date := NVL(p_latest_comp_date, TO_DATE('01/01/1952','MM/DD/YYYY'));
2718: ozf_utility_pvt.write_conc_log('-- Full Refersh Start --');

Line 2858: p_init_msg_list => FND_API.g_false,

2854: --ozf_utility_pvt.write_conc_log('Before refresh parties');
2855:
2856: /* refresh parties would get all the parties for the list_header_id and add to FND_DSQL*/
2857: refresh_parties(p_api_version => l_api_version,
2858: p_init_msg_list => FND_API.g_false,
2859: p_commit => FND_API.g_false,
2860: p_list_header_id => i.object_id,
2861: p_calling_from_den => 'Y',
2862: x_return_status => l_return_status,

Line 2859: p_commit => FND_API.g_false,

2855:
2856: /* refresh parties would get all the parties for the list_header_id and add to FND_DSQL*/
2857: refresh_parties(p_api_version => l_api_version,
2858: p_init_msg_list => FND_API.g_false,
2859: p_commit => FND_API.g_false,
2860: p_list_header_id => i.object_id,
2861: p_calling_from_den => 'Y',
2862: x_return_status => l_return_status,
2863: x_msg_count => l_msg_count,

Line 2877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2873: --write_conc_log('6:' || SUBSTR(l_stmt_offer, 1251, 250));
2874: --write_conc_log('7:' || SUBSTR(l_stmt_offer, 1501, 250));
2875:
2876: --ozf_utility_pvt.write_conc_log('After refresh parties');
2877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2878: RAISE FND_API.g_exc_unexpected_error;
2879: END IF;
2880:
2881: IF l_stmt_offer IS NOT NULL THEN

Line 2878: RAISE FND_API.g_exc_unexpected_error;

2874: --write_conc_log('7:' || SUBSTR(l_stmt_offer, 1501, 250));
2875:
2876: --ozf_utility_pvt.write_conc_log('After refresh parties');
2877: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2878: RAISE FND_API.g_exc_unexpected_error;
2879: END IF;
2880:
2881: IF l_stmt_offer IS NOT NULL THEN
2882: 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 2969: p_init_msg_list => FND_API.g_false,

2965: -- FND_DSQL.add_text(',discount_line_id,apply_discount,include_volume, product_id, product_type FROM (');
2966: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
2967:
2968: refresh_products(p_api_version => l_api_version,
2969: p_init_msg_list => FND_API.g_false,
2970: p_commit => FND_API.g_false,
2971: p_list_header_id => i.object_id,
2972: p_calling_from_den => 'Y',
2973: x_return_status => l_return_status,

Line 2970: p_commit => FND_API.g_false,

2966: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
2967:
2968: refresh_products(p_api_version => l_api_version,
2969: p_init_msg_list => FND_API.g_false,
2970: p_commit => FND_API.g_false,
2971: p_list_header_id => i.object_id,
2972: p_calling_from_den => 'Y',
2973: x_return_status => l_return_status,
2974: x_msg_count => l_msg_count,

Line 2979: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2975: x_msg_data => l_msg_data,
2976: x_product_stmt => l_stmt_product,
2977: p_lline_id => x.lline_id);
2978:
2979: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2980: RAISE FND_API.g_exc_unexpected_error;
2981: END IF;
2982:
2983: ozf_utility_pvt.write_conc_log ('-- 1 --');

Line 2980: RAISE FND_API.g_exc_unexpected_error;

2976: x_product_stmt => l_stmt_product,
2977: p_lline_id => x.lline_id);
2978:
2979: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2980: RAISE FND_API.g_exc_unexpected_error;
2981: END IF;
2982:
2983: ozf_utility_pvt.write_conc_log ('-- 1 --');
2984:

Line 3213: p_init_msg_list => FND_API.g_false,

3209: 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');
3210: FND_DSQL.add_text(' FROM (');
3211:
3212: refresh_parties(p_api_version => l_api_version,
3213: p_init_msg_list => FND_API.g_false,
3214: p_commit => FND_API.g_false,
3215: p_list_header_id => i.object_id,
3216: p_calling_from_den => 'Y',
3217: x_return_status => l_return_status,

Line 3214: p_commit => FND_API.g_false,

3210: FND_DSQL.add_text(' FROM (');
3211:
3212: refresh_parties(p_api_version => l_api_version,
3213: p_init_msg_list => FND_API.g_false,
3214: p_commit => FND_API.g_false,
3215: p_list_header_id => i.object_id,
3216: p_calling_from_den => 'Y',
3217: x_return_status => l_return_status,
3218: x_msg_count => l_msg_count,

Line 3223: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3219: x_msg_data => l_msg_data,
3220: x_party_stmt => l_stmt_offer,
3221: p_qnum => z.qnum);
3222:
3223: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3224: RAISE FND_API.g_exc_unexpected_error;
3225: END IF;
3226:
3227: ozf_utility_pvt.write_conc_log('l_stmt_offer '||l_stmt_offer);

Line 3224: RAISE FND_API.g_exc_unexpected_error;

3220: x_party_stmt => l_stmt_offer,
3221: p_qnum => z.qnum);
3222:
3223: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3224: RAISE FND_API.g_exc_unexpected_error;
3225: END IF;
3226:
3227: ozf_utility_pvt.write_conc_log('l_stmt_offer '||l_stmt_offer);
3228:

Line 3318: p_init_msg_list => FND_API.g_false,

3314: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3315:
3316:
3317: refresh_products(p_api_version => l_api_version,
3318: p_init_msg_list => FND_API.g_false,
3319: p_commit => FND_API.g_false,
3320: p_list_header_id => i.object_id,
3321: p_calling_from_den => 'Y',
3322: x_return_status => l_return_status,

Line 3319: p_commit => FND_API.g_false,

3315:
3316:
3317: refresh_products(p_api_version => l_api_version,
3318: p_init_msg_list => FND_API.g_false,
3319: p_commit => FND_API.g_false,
3320: p_list_header_id => i.object_id,
3321: p_calling_from_den => 'Y',
3322: x_return_status => l_return_status,
3323: x_msg_count => l_msg_count,

Line 3330: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3326: p_lline_id => x.lline_id);
3327:
3328: --write_log('After Refresh products- offer has changed');
3329:
3330: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3331: RAISE FND_API.g_exc_unexpected_error;
3332: END IF;
3333:
3334: --write_log('one');

Line 3331: RAISE FND_API.g_exc_unexpected_error;

3327:
3328: --write_log('After Refresh products- offer has changed');
3329:
3330: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3331: RAISE FND_API.g_exc_unexpected_error;
3332: END IF;
3333:
3334: --write_log('one');
3335: IF l_stmt_product IS NOT NULL THEN

Line 3427: p_init_msg_list => FND_API.g_false,

3423: 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,');
3424: 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');
3425: FND_DSQL.add_text(' FROM (');
3426: refresh_parties(p_api_version => l_api_version,
3427: p_init_msg_list => FND_API.g_false,
3428: p_commit => FND_API.g_false,
3429: p_list_header_id => i.object_id,
3430: p_calling_from_den => 'Y',
3431: x_return_status => l_return_status,

Line 3428: p_commit => FND_API.g_false,

3424: 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');
3425: FND_DSQL.add_text(' FROM (');
3426: refresh_parties(p_api_version => l_api_version,
3427: p_init_msg_list => FND_API.g_false,
3428: p_commit => FND_API.g_false,
3429: p_list_header_id => i.object_id,
3430: p_calling_from_den => 'Y',
3431: x_return_status => l_return_status,
3432: x_msg_count => l_msg_count,

Line 3437: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3433: x_msg_data => l_msg_data,
3434: x_party_stmt => l_stmt_offer,
3435: p_qnum => z.qnum);
3436:
3437: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3438: RAISE FND_API.g_exc_unexpected_error;
3439: END IF;
3440:
3441: IF l_stmt_offer IS NOT NULL THEN

Line 3438: RAISE FND_API.g_exc_unexpected_error;

3434: x_party_stmt => l_stmt_offer,
3435: p_qnum => z.qnum);
3436:
3437: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3438: RAISE FND_API.g_exc_unexpected_error;
3439: END IF;
3440:
3441: IF l_stmt_offer IS NOT NULL THEN
3442: --FND_DSQL.add_text(')');

Line 3533: p_init_msg_list => FND_API.g_false,

3529: -- FND_DSQL.add_text(',discount_line_id,apply_discount,include_volume, product_id, product_type FROM (');
3530: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3531:
3532: refresh_products(p_api_version => l_api_version,
3533: p_init_msg_list => FND_API.g_false,
3534: p_commit => FND_API.g_false,
3535: p_list_header_id => i.object_id,
3536: p_calling_from_den => 'Y',
3537: x_return_status => l_return_status,

Line 3534: p_commit => FND_API.g_false,

3530: FND_DSQL.add_text(',items_category, product_id, product_type FROM (');
3531:
3532: refresh_products(p_api_version => l_api_version,
3533: p_init_msg_list => FND_API.g_false,
3534: p_commit => FND_API.g_false,
3535: p_list_header_id => i.object_id,
3536: p_calling_from_den => 'Y',
3537: x_return_status => l_return_status,
3538: x_msg_count => l_msg_count,

Line 3545: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

3541: p_lline_id => x.lline_id);
3542:
3543: --write_log('After Refresh products- offer has not changed');
3544:
3545: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3546: RAISE FND_API.g_exc_unexpected_error;
3547: END IF;
3548:
3549: IF l_stmt_product IS NOT NULL THEN

Line 3546: RAISE FND_API.g_exc_unexpected_error;

3542:
3543: --write_log('After Refresh products- offer has not changed');
3544:
3545: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3546: RAISE FND_API.g_exc_unexpected_error;
3547: END IF;
3548:
3549: IF l_stmt_product IS NOT NULL THEN
3550: --FND_DSQL.add_text(')');

Line 4039: WHEN FND_API.G_EXC_ERROR THEN

4035: --utl_file.fflush( a );
4036: --utl_file.fclose( a );
4037:
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: ozf_utility_pvt.write_conc_log('-- Expected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4041: x_return_status := FND_API.g_ret_sts_error ;
4042: ERRBUF := l_msg_data;
4043: RETCODE := 2;

Line 4041: x_return_status := FND_API.g_ret_sts_error ;

4037:
4038: EXCEPTION
4039: WHEN FND_API.G_EXC_ERROR THEN
4040: ozf_utility_pvt.write_conc_log('-- Expected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4041: x_return_status := FND_API.g_ret_sts_error ;
4042: ERRBUF := l_msg_data;
4043: RETCODE := 2;
4044:
4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4041: x_return_status := FND_API.g_ret_sts_error ;
4042: ERRBUF := l_msg_data;
4043: RETCODE := 2;
4044:
4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4046: ozf_utility_pvt.write_conc_log('-- Unexpected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4047: x_return_status := FND_API.g_ret_sts_unexp_error ;
4048: ERRBUF := l_msg_data;
4049: RETCODE := 2;

Line 4047: x_return_status := FND_API.g_ret_sts_unexp_error ;

4043: RETCODE := 2;
4044:
4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4046: ozf_utility_pvt.write_conc_log('-- Unexpected Error - '|| SQLERRM || ' ' || l_stmt_denorm);
4047: x_return_status := FND_API.g_ret_sts_unexp_error ;
4048: ERRBUF := l_msg_data;
4049: RETCODE := 2;
4050:
4051: WHEN OTHERS THEN

Line 4054: x_return_status := FND_API.g_ret_sts_unexp_error ;

4050:
4051: WHEN OTHERS THEN
4052: ROLLBACK TO refresh_denorm;
4053: ozf_utility_pvt.write_conc_log('-- Others - '|| SQLERRM || ' ' || l_stmt_denorm);
4054: x_return_status := FND_API.g_ret_sts_unexp_error ;
4055: ERRBUF := SQLERRM || ' ' || l_stmt_denorm;
4056: RETCODE := sqlcode;
4057:
4058:

Line 4417: p_init_msg_list => FND_API.g_false,

4413: end if;
4414:
4415: ozf_forecast_util_pvt.get_list_price(
4416: p_api_version => l_api_version,
4417: p_init_msg_list => FND_API.g_false,
4418: p_commit => FND_API.g_false,
4419: p_obj_type => 'OFFR',
4420: p_obj_id => p_offer_id,
4421: p_forecast_id => j.forecast_id,

Line 4418: p_commit => FND_API.g_false,

4414:
4415: ozf_forecast_util_pvt.get_list_price(
4416: p_api_version => l_api_version,
4417: p_init_msg_list => FND_API.g_false,
4418: p_commit => FND_API.g_false,
4419: p_obj_type => 'OFFR',
4420: p_obj_id => p_offer_id,
4421: p_forecast_id => j.forecast_id,
4422: p_product_attribute => j.product_attribute,

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

4505: p_cust_acct_id IN NUMBER := NULL,
4506: p_cust_site_id IN NUMBER := NULL,
4507:
4508: p_api_version IN NUMBER,
4509: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4510: p_commit IN VARCHAR2 := FND_API.g_false,
4511:
4512: x_return_status OUT NOCOPY VARCHAR2,
4513: x_msg_count OUT NOCOPY NUMBER,

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

4506: p_cust_site_id IN NUMBER := NULL,
4507:
4508: p_api_version IN NUMBER,
4509: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4510: p_commit IN VARCHAR2 := FND_API.g_false,
4511:
4512: x_return_status OUT NOCOPY VARCHAR2,
4513: x_msg_count OUT NOCOPY NUMBER,
4514: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

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

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

4629: -- This procedure calls get_sql, builds SQL statment for product and refresh ozf_activity_products
4630: ----------------------------------------------------------------------
4631: PROCEDURE get_party_product_stmt(
4632: p_api_version IN NUMBER,
4633: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4634: p_commit IN VARCHAR2 := FND_API.g_false,
4635:
4636: p_list_header_id IN NUMBER,
4637:

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

4630: ----------------------------------------------------------------------
4631: PROCEDURE get_party_product_stmt(
4632: p_api_version IN NUMBER,
4633: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4634: p_commit IN VARCHAR2 := FND_API.g_false,
4635:
4636: p_list_header_id IN NUMBER,
4637:
4638: x_return_status OUT NOCOPY VARCHAR2,