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 OZF_UTILITY_PVT

Line 18: ozf_utility_pvt.write_conc_log(p_text);

14: p_text IN VARCHAR2
15: ) IS
16: BEGIN
17: --if OZF_DEBUG_LOW then
18: ozf_utility_pvt.write_conc_log(p_text);
19: --end if;
20: --dbms_output.put_line(p_text);
21: --null;
22: END write_conc_log;

Line 129: --ozf_utility_pvt.write_conc_log ('In getSQL : p_attribute is ' || p_attribute);

125: l_category := p_attr_value_from;
126: else
127: l_category := null;
128: end if;
129: --ozf_utility_pvt.write_conc_log ('In getSQL : p_attribute is ' || p_attribute);
130: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is ' || l_category);
131: -- special case, for item only.
132: IF l_stmt_1 is not null then
133: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN

Line 130: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is ' || l_category);

126: else
127: l_category := null;
128: end if;
129: --ozf_utility_pvt.write_conc_log ('In getSQL : p_attribute is ' || p_attribute);
130: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is ' || l_category);
131: -- special case, for item only.
132: IF l_stmt_1 is not null then
133: IF INSTR(l_stmt_1, '*') > 0 OR INSTR(l_stmt_1, '?') > 0 THEN
134: FND_DSQL.add_text('SELECT null items_category, TO_NUMBER(');

Line 141: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is null condition ');

137: FND_DSQL.add_text(') product_id,''PRICING_ATTRIBUTE1'' product_type FROM DUAL');
138: ELSE
139: IF p_context = 'ITEM' then
140: IF l_category is null then
141: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is null condition ');
142: l_stmt_1 := 'select null items_category, ' || substr(l_stmt_1,7);
143: else
144: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is not null and is equal to:' || l_category ||':');
145: l_stmt_1 := 'select '|| l_category || ' items_category, ' || substr(l_stmt_1,7);

Line 144: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is not null and is equal to:' || l_category ||':');

140: IF l_category is null then
141: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is null condition ');
142: l_stmt_1 := 'select null items_category, ' || substr(l_stmt_1,7);
143: else
144: --ozf_utility_pvt.write_conc_log ('In getSQL : l_category is not null and is equal to:' || l_category ||':');
145: l_stmt_1 := 'select '|| l_category || ' items_category, ' || substr(l_stmt_1,7);
146: end if;
147: ELSIF l_qualifier_id is not null then
148: l_distinct_position := INSTR(l_stmt_1,' distinct ');

Line 611: ozf_utility_pvt.write_conc_log(l_full_name ||

607: l_offer_id NUMBER;
608:
609: BEGIN
610:
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;

Line 625: ozf_utility_pvt.write_conc_log('l_elig_exists:'||l_no_groups);

621: OPEN c_no_groups(l_offer_id);
622: FETCH c_no_groups INTO l_no_groups;
623: CLOSE c_no_groups;
624:
625: ozf_utility_pvt.write_conc_log('l_elig_exists:'||l_no_groups);
626: IF l_no_groups > 0 THEN
627: l_group_index := 1;
628:
629: FOR i IN c_groups(l_offer_id) LOOP

Line 673: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));

669: x_party_stmt := FND_DSQL.get_text(FALSE);
670: ELSE
671: x_party_stmt := NULL;
672: END IF;
673: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
674: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
675: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
676:
677: EXCEPTION

Line 674: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));

670: ELSE
671: x_party_stmt := NULL;
672: END IF;
673: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
674: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
675: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
676:
677: EXCEPTION
678: WHEN OTHERS THEN

Line 675: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));

671: x_party_stmt := NULL;
672: END IF;
673: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
674: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
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;

Line 785: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_netaccrual');

781: l_offer_id NUMBER;
782:
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;

Line 1021: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_volume');

1017: l_line_index NUMBER;
1018: l_offer_id NUMBER;
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;

Line 1208: ozf_utility_pvt.write_conc_log(l_full_name ||

1204: l_qualifier_exists VARCHAR2(1) := NULL;
1205:
1206: BEGIN
1207:
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;

Line 1261: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));

1257: x_party_stmt := FND_DSQL.get_text(FALSE);
1258: ELSE
1259: x_party_stmt := NULL;
1260: END IF;
1261: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1262: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
1263: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1264:
1265: EXCEPTION

Line 1262: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));

1258: ELSE
1259: x_party_stmt := NULL;
1260: END IF;
1261: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1262: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
1263: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1264:
1265: EXCEPTION
1266: WHEN OTHERS THEN

Line 1263: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));

1259: x_party_stmt := NULL;
1260: END IF;
1261: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1262: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
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;

Line 1405: ozf_utility_pvt.write_conc_log(l_full_name ||

1401: l_qual_line_ct NUMBER;
1402: l_direct_indirect_flag VARCHAR2(1) := 'N';
1403: BEGIN
1404:
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;

Line 1415: ozf_utility_pvt.write_conc_log('l_elig_exists:'||l_no_groups);

1411: OPEN c_no_groups;
1412: FETCH c_no_groups INTO l_no_groups;
1413: CLOSE c_no_groups;
1414:
1415: ozf_utility_pvt.write_conc_log('l_elig_exists:'||l_no_groups);
1416:
1417: IF l_no_groups > 0 THEN
1418: l_group_index := 1;
1419:

Line 1521: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));

1517: x_party_stmt := FND_DSQL.get_text(FALSE);
1518: ELSE
1519: x_party_stmt := NULL;
1520: END IF;
1521: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1522: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
1523: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1524:
1525: EXCEPTION

Line 1522: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));

1518: ELSE
1519: x_party_stmt := NULL;
1520: END IF;
1521: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1522: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
1523: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN

Line 1523: --ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));

1519: x_party_stmt := NULL;
1520: END IF;
1521: --ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
1522: --ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
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;

Line 1662: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh parties' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

1658:
1659:
1660: BEGIN
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;

Line 1683: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );

1679:
1680: OPEN c_offer_type;
1681: FETCH c_offer_type INTO l_offer_type;
1682: CLOSE c_offer_type;
1683: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
1684: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
1685:
1686: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
1687: refresh_lumpsum_parties(

Line 1684: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );

1680: OPEN c_offer_type;
1681: FETCH c_offer_type INTO l_offer_type;
1682: CLOSE c_offer_type;
1683: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
1684: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
1685:
1686: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
1687: refresh_lumpsum_parties(
1688: p_api_version => p_api_version,

Line 2108: ozf_utility_pvt.write_conc_log(l_full_name || ': Start refresh products' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

2104: l_excl_index NUMBER;
2105:
2106: BEGIN
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;

Line 2129: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );

2125: OPEN c_offer_type;
2126: FETCH c_offer_type INTO l_offer_type;
2127: CLOSE c_offer_type;
2128:
2129: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
2130: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
2131:
2132: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
2133: refresh_lumpsum_products(

Line 2130: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );

2126: FETCH c_offer_type INTO l_offer_type;
2127: CLOSE c_offer_type;
2128:
2129: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
2130: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
2131:
2132: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
2133: refresh_lumpsum_products(
2134: p_api_version => p_api_version,

Line 2178: ozf_utility_pvt.write_conc_log(' -- Number of Products in this offer : '|| l_no_products );

2174: CLOSE c_no_products;
2175:
2176: l_prod_index := 1;
2177:
2178: ozf_utility_pvt.write_conc_log(' -- Number of Products in this offer : '|| l_no_products );
2179:
2180: IF l_no_products > 0 THEN
2181: FOR i IN c_list_lines LOOP
2182: l_stmt_temp := null;

Line 2202: ozf_utility_pvt.write_conc_log(' -- Geting Statement for : '|| l_product_attribute || ':' || l_product_attr_value );

2198: p_comparison => NULL,
2199: p_type => 'PROD'
2200: );
2201:
2202: ozf_utility_pvt.write_conc_log(' -- Geting Statement for : '|| l_product_attribute || ':' || l_product_attr_value );
2203: --write_log(' -- Geting Statement for : '|| l_product_attribute || ':' || l_product_attr_value );
2204:
2205: IF l_stmt_temp IS NULL THEN
2206: l_no_query_flag := 'Y';

Line 2242: ozf_utility_pvt.write_conc_log(' -- End refresh products --' );

2238: ELSE
2239: x_product_stmt := NULL;
2240: END IF;
2241: END IF;
2242: ozf_utility_pvt.write_conc_log(' -- End refresh products --' );
2243: --write_log(' -- End refresh products --' );
2244:
2245:
2246: EXCEPTION

Line 2249: ozf_utility_pvt.write_conc_log('-- Others - ' || SQLERRM || ' ' || x_product_stmt);

2245:
2246: EXCEPTION
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');

Line 2688: ozf_utility_pvt.write_conc_log(l_full_name || ': Start Offer refresh denorm');

2684:
2685: BEGIN
2686: SAVEPOINT refresh_denorm;
2687: --a := utl_file.fopen( out_dir ,l_out_file,'w' );
2688: ozf_utility_pvt.write_conc_log(l_full_name || ': Start Offer refresh denorm');
2689: --write_log(l_full_name || ': Start Offer refresh denorm');
2690:
2691: ERRBUF := NULL;
2692: RETCODE := '0';

Line 2704: ozf_utility_pvt.write_conc_log('-- l_increment_flag is : '|| l_increment_flag );

2700: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
2701: l_common_uom := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
2702: l_dis_as_exp := FND_PROFILE.VALUE('OZF_TREAT_DISCOUNT_AS_EXPENSE');
2703:
2704: ozf_utility_pvt.write_conc_log('-- l_increment_flag is : '|| l_increment_flag );
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:

Line 2706: ozf_utility_pvt.write_conc_log('-- l_org_id is : '|| l_org_id );

2702: l_dis_as_exp := FND_PROFILE.VALUE('OZF_TREAT_DISCOUNT_AS_EXPENSE');
2703:
2704: ozf_utility_pvt.write_conc_log('-- l_increment_flag is : '|| l_increment_flag );
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,

Line 2707: ozf_utility_pvt.write_conc_log('-- l_latest_comp_date is : '|| p_latest_comp_date );

2703:
2704: ozf_utility_pvt.write_conc_log('-- l_increment_flag is : '|| l_increment_flag );
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,

Line 2718: ozf_utility_pvt.write_conc_log('-- Full Refersh Start --');

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 --');
2719: --write_log('-- Full Refersh Start --');
2720:
2721: IF l_increment_flag = 'N' OR l_latest_comp_date IS NULL
2722: THEN

Line 2762: ozf_utility_pvt.write_conc_log('-- Processing Offer_id : '||i.object_id);

2758: end if;
2759:
2760: FOR i IN c_all_offers
2761: LOOP
2762: ozf_utility_pvt.write_conc_log('-- Processing Offer_id : '||i.object_id);
2763: --write_log('-- Processing Offer_id : '||i.object_id);
2764:
2765: IF l_increment_flag = 'N' OR l_latest_comp_date IS NULL
2766: THEN

Line 2770: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');

2766: THEN
2767: -- first time execution or fresh denorm
2768: -- denorm parties
2769:
2770: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');
2771: /*
2772: DELETE FROM ozf_activity_customers_temp
2773: WHERE object_class = 'OFFR'
2774: AND object_id = i.object_id ;

Line 2797: ozf_utility_pvt.write_conc_log('Checking Group:' || z.qnum);

2793: --=========================================================================--
2794: l_group_count :=0;
2795: FOR z IN c_groups(i.object_id)
2796: LOOP
2797: ozf_utility_pvt.write_conc_log('Checking Group:' || z.qnum);
2798:
2799: if z.qnum = -99 AND l_group_count > 0 then
2800: goto GROUP_END1;
2801: end if;

Line 2854: --ozf_utility_pvt.write_conc_log('Before refresh parties');

2850: 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,');
2851: 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');
2852: FND_DSQL.add_text(' FROM (');
2853:
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,

Line 2876: --ozf_utility_pvt.write_conc_log('After refresh parties');

2872: --write_conc_log('5:' || SUBSTR(l_stmt_offer, 1001, 250));
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:

Line 2983: ozf_utility_pvt.write_conc_log ('-- 1 --');

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:
2985: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
2986: IF l_stmt_product IS NOT NULL THEN
2987: -- FND_DSQL.add_text(' UNION SELECT distinct discount_line_id,apply_discount,include_volume, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');

Line 3012: --ozf_utility_pvt.write_conc_log(' Start forecast');

3008:
3009: IF product_denormed = 'Y' then
3010:
3011: /*---------- Start forecast update ----------------*/
3012: --ozf_utility_pvt.write_conc_log(' Start forecast');
3013: s_actual_units := 0;
3014: s_actual_revenue := 0;
3015: s_actual_costs := 0;
3016: sy_actual_revenue := 0;

Line 3060: --ozf_utility_pvt.write_conc_log(' Before forecast values loop');

3056: end if;
3057: end if;
3058:
3059:
3060: --ozf_utility_pvt.write_conc_log(' Before forecast values loop');
3061: -- Get Forecast Value
3062:
3063: --ReplaceForecast#2
3064:

Line 3125: ozf_utility_pvt.write_conc_log('-- Done for Offer Id : '|| i.object_id );

3121: /*---------- End forecast update ----------------*/
3122:
3123: END IF;
3124: << END_INSERT >>
3125: ozf_utility_pvt.write_conc_log('-- Done for Offer Id : '|| i.object_id );
3126: ELSE --=================== incremental denorm======================
3127:
3128: ozf_utility_pvt.write_conc_log('-- Incremental Denorm -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3129: --write_log('-- Incremental Denorm -- ');

Line 3128: ozf_utility_pvt.write_conc_log('-- Incremental Denorm -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

3124: << END_INSERT >>
3125: ozf_utility_pvt.write_conc_log('-- Done for Offer Id : '|| i.object_id );
3126: ELSE --=================== incremental denorm======================
3127:
3128: ozf_utility_pvt.write_conc_log('-- Incremental Denorm -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3129: --write_log('-- Incremental Denorm -- ');
3130:
3131: -- initialize offer_changed flag
3132: l_offer_changed := NULL;

Line 3146: ozf_utility_pvt.write_conc_log('-- After Change Check -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));

3142: OPEN c_product_changed(i.object_id, l_latest_comp_date);
3143: FETCH c_product_changed INTO l_product_changed;
3144: CLOSE c_product_changed;
3145:
3146: ozf_utility_pvt.write_conc_log('-- After Change Check -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3147:
3148: IF l_offer_changed IS NOT NULL THEN -- offer changed
3149: --write_log('OCHAN-Offer Id: '|| i.object_id || ' has changed.');
3150: -- parties have to be denormed as associated offers are changed

Line 3227: ozf_utility_pvt.write_conc_log('l_stmt_offer '||l_stmt_offer);

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:
3229: IF l_stmt_offer IS NOT NULL THEN
3230: --FND_DSQL.add_text(')');
3231: 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 3850: --ozf_utility_pvt.write_conc_log('Before the actual Insert into denorm tables for Full Refresh');

3846:
3847:
3848: IF l_increment_flag = 'N' THEN
3849: --full denorm, need to truncate table and populate from _temp tables and re-create index
3850: --ozf_utility_pvt.write_conc_log('Before the actual Insert into denorm tables for Full Refresh');
3851: /*
3852: SELECT i.index_tablespace INTO l_index_tablespace
3853: FROM fnd_product_installations i, fnd_application a
3854: WHERE a.application_short_name = 'AMS'

Line 3858: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');

3854: WHERE a.application_short_name = 'AMS'
3855: AND a.application_id = i.application_id;
3856: */
3857:
3858: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');
3859:
3860: INSERT INTO ozf_activity_customers
3861: (activity_customer_id,OBJECT_ID,
3862: OBJECT_TYPE,

Line 3939: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');

3935: QP_QUALIFIER_ID,
3936: QP_QUALIFIER_GROUP
3937: FROM ozf_activity_customers_temp;
3938:
3939: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');
3940:
3941: INSERT INTO ozf_activity_products
3942: (activity_product_id,
3943: OBJECT_ID,

Line 4040: ozf_utility_pvt.write_conc_log('-- Expected Error - '|| SQLERRM || ' ' || l_stmt_denorm);

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;
4044:

Line 4046: ozf_utility_pvt.write_conc_log('-- Unexpected Error - '|| SQLERRM || ' ' || l_stmt_denorm);

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;
4050:

Line 4053: ozf_utility_pvt.write_conc_log('-- Others - '|| SQLERRM || ' ' || l_stmt_denorm);

4049: RETCODE := 2;
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:

Line 4226: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4222:
4223:
4224:
4225: if p_curr_code <> j.order_currency then
4226: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4227: ,p_from_currency => j.order_currency
4228: ,p_to_currency => p_curr_code
4229: ,p_conv_date => j.trans_date
4230: ,p_from_amount => l_actual_revenue

Line 4233: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4229: ,p_conv_date => j.trans_date
4230: ,p_from_amount => l_actual_revenue
4231: ,x_to_amount => l_conv_actual_revenue);
4232:
4233: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4234: ,p_from_currency => j.order_currency
4235: ,p_to_currency => p_curr_code
4236: ,p_conv_date => j.trans_date
4237: ,p_from_amount => y_actual_revenue

Line 4240: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4236: ,p_conv_date => j.trans_date
4237: ,p_from_amount => y_actual_revenue
4238: ,x_to_amount => y_conv_actual_revenue);
4239:
4240: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4241: ,p_from_currency => j.order_currency
4242: ,p_to_currency => p_curr_code
4243: ,p_conv_date => j.trans_date
4244: ,p_from_amount => l_actual_costs

Line 4247: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4243: ,p_conv_date => j.trans_date
4244: ,p_from_amount => l_actual_costs
4245: ,x_to_amount => l_conv_actual_costs);
4246:
4247: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4248: ,p_from_currency => j.order_currency
4249: ,p_to_currency => p_curr_code
4250: ,p_conv_date => j.trans_date
4251: ,p_from_amount => y_actual_costs