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 782: ozf_utility_pvt.write_conc_log(l_full_name || ': start refresh_products_netaccrual');

778: l_offer_id NUMBER;
779:
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;

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

1026: l_line_index NUMBER;
1027: l_offer_id NUMBER;
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;

Line 1229: ozf_utility_pvt.write_conc_log(l_full_name ||

1225: l_qualifier_exists VARCHAR2(1) := NULL;
1226:
1227: BEGIN
1228:
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;

Line 1425: ozf_utility_pvt.write_conc_log(l_full_name ||

1421: l_qual_line_ct NUMBER;
1422: l_direct_indirect_flag VARCHAR2(1) := 'N';
1423: BEGIN
1424:
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;

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

1431: OPEN c_no_groups;
1432: FETCH c_no_groups INTO l_no_groups;
1433: CLOSE c_no_groups;
1434:
1435: ozf_utility_pvt.write_conc_log('l_elig_exists:'||l_no_groups);
1436:
1437: IF l_no_groups > 0 THEN
1438: l_group_index := 1;
1439:

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

1677:
1678:
1679: BEGIN
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;

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

1698:
1699: OPEN c_offer_type;
1700: FETCH c_offer_type INTO l_offer_type;
1701: CLOSE c_offer_type;
1702: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
1703: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
1704:
1705: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
1706: refresh_lumpsum_parties(

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

1699: OPEN c_offer_type;
1700: FETCH c_offer_type INTO l_offer_type;
1701: CLOSE c_offer_type;
1702: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
1703: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
1704:
1705: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
1706: refresh_lumpsum_parties(
1707: p_api_version => p_api_version,

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

2138: l_excl_index NUMBER;
2139:
2140: BEGIN
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;

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

2159: OPEN c_offer_type;
2160: FETCH c_offer_type INTO l_offer_type;
2161: CLOSE c_offer_type;
2162:
2163: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
2164: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
2165:
2166: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
2167: refresh_lumpsum_products(

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

2160: FETCH c_offer_type INTO l_offer_type;
2161: CLOSE c_offer_type;
2162:
2163: ozf_utility_pvt.write_conc_log(' -- Offer Type : '|| l_offer_type );
2164: ozf_utility_pvt.write_conc_log(' -- Offer Id : '|| p_list_header_id );
2165:
2166: IF l_offer_type = 'LUMPSUM' OR l_offer_type = 'SCAN_DATA' THEN
2167: refresh_lumpsum_products(
2168: p_api_version => p_api_version,

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

2208: CLOSE c_no_products;
2209:
2210: l_prod_index := 1;
2211:
2212: ozf_utility_pvt.write_conc_log(' -- Number of Products in this offer : '|| l_no_products );
2213:
2214: IF l_no_products > 0 THEN
2215: FOR i IN c_list_lines LOOP
2216: l_stmt_temp := null;

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

2240: p_comparison => NULL,
2241: p_type => 'PROD'
2242: );
2243:
2244: ozf_utility_pvt.write_conc_log(' -- Geting Statement for : '|| l_product_attribute || ':' || l_product_attr_value );
2245: --write_log(' -- Geting Statement for : '|| l_product_attribute || ':' || l_product_attr_value );
2246:
2247:
2248: IF l_stmt_temp IS NULL THEN

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

2295: x_product_stmt := NULL;
2296: END IF;
2297: END IF;
2298:
2299: ozf_utility_pvt.write_conc_log(' -- End refresh products --' );
2300: --write_log(' -- End refresh products --' );
2301:
2302:
2303: EXCEPTION

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

2302:
2303: EXCEPTION
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');

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

2741:
2742: BEGIN
2743: SAVEPOINT refresh_denorm;
2744: --a := utl_file.fopen( out_dir ,l_out_file,'w' );
2745: ozf_utility_pvt.write_conc_log(l_full_name || ': Start Offer refresh denorm');
2746: --write_log(l_full_name || ': Start Offer refresh denorm');
2747:
2748: ERRBUF := NULL;
2749: RETCODE := '0';

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

2757: l_org_id := FND_PROFILE.VALUE('QP_ORGANIZATION_ID');
2758: l_common_uom := FND_PROFILE.VALUE('OZF_TP_COMMON_UOM');
2759: l_dis_as_exp := FND_PROFILE.VALUE('OZF_TREAT_DISCOUNT_AS_EXPENSE');
2760:
2761: ozf_utility_pvt.write_conc_log('-- l_increment_flag is : '|| l_increment_flag );
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:

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

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

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

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

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

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 --');
2776: --write_log('-- Full Refersh Start --');
2777:
2778: IF l_increment_flag = 'N' OR l_latest_comp_date IS NULL
2779: THEN

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

2815: end if;
2816:
2817: FOR i IN c_all_offers
2818: LOOP
2819: ozf_utility_pvt.write_conc_log('-- Processing Offer_id : '||i.object_id);
2820: --write_log('-- Processing Offer_id : '||i.object_id);
2821:
2822: IF l_increment_flag = 'N' OR l_latest_comp_date IS NULL
2823: THEN

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

2823: THEN
2824: -- first time execution or fresh denorm
2825: -- denorm parties
2826:
2827: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');
2828: /*
2829: DELETE FROM ozf_activity_customers_temp
2830: WHERE object_class = 'OFFR'
2831: AND object_id = i.object_id ;

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

2850: --=========================================================================--
2851: l_group_count :=0;
2852: FOR z IN c_groups(i.object_id)
2853: LOOP
2854: ozf_utility_pvt.write_conc_log('Checking Group:' || z.qnum);
2855:
2856: if z.qnum = -99 AND l_group_count > 0 then
2857: goto GROUP_END1;
2858: end if;

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

2907: 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,');
2908: 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');
2909: FND_DSQL.add_text(' FROM (');
2910:
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,

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

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

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

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:
3044: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
3045: IF l_stmt_product IS NOT NULL THEN
3046: -- 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 3072: --ozf_utility_pvt.write_conc_log(' Start forecast');

3068:
3069: IF product_denormed = 'Y' then
3070:
3071: /*---------- Start forecast update ----------------*/
3072: --ozf_utility_pvt.write_conc_log(' Start forecast');
3073: s_actual_units := 0;
3074: s_actual_revenue := 0;
3075: s_actual_costs := 0;
3076: sy_actual_revenue := 0;

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

3116: end if;
3117: end if;
3118:
3119:
3120: --ozf_utility_pvt.write_conc_log(' Before forecast values loop');
3121: -- Get Forecast Value
3122:
3123: --ReplaceForecast#2
3124:

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

3181: /*---------- End forecast update ----------------*/
3182:
3183: END IF;
3184: << END_INSERT >>
3185: ozf_utility_pvt.write_conc_log('-- Done for Offer Id : '|| i.object_id );
3186: ELSE --=================== incremental denorm======================
3187:
3188: ozf_utility_pvt.write_conc_log('-- Incremental Denorm -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3189: --write_log('-- Incremental Denorm -- ');

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

3184: << END_INSERT >>
3185: ozf_utility_pvt.write_conc_log('-- Done for Offer Id : '|| i.object_id );
3186: ELSE --=================== incremental denorm======================
3187:
3188: ozf_utility_pvt.write_conc_log('-- Incremental Denorm -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3189: --write_log('-- Incremental Denorm -- ');
3190:
3191: -- initialize offer_changed flag
3192: l_offer_changed := NULL;

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

3202: OPEN c_product_changed(i.object_id, l_latest_comp_date);
3203: FETCH c_product_changed INTO l_product_changed;
3204: CLOSE c_product_changed;
3205:
3206: ozf_utility_pvt.write_conc_log('-- After Change Check -- ' || '-'||to_char(sysdate,'dd-mon-yyyy-hh:mi:ss'));
3207:
3208: IF l_offer_changed IS NOT NULL THEN -- offer changed
3209: --write_log('OCHAN-Offer Id: '|| i.object_id || ' has changed.');
3210: -- parties have to be denormed as associated offers are changed

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

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

3906:
3907:
3908: IF l_increment_flag = 'N' THEN
3909: --full denorm, need to truncate table and populate from _temp tables and re-create index
3910: --ozf_utility_pvt.write_conc_log('Before the actual Insert into denorm tables for Full Refresh');
3911: /*
3912: SELECT i.index_tablespace INTO l_index_tablespace
3913: FROM fnd_product_installations i, fnd_application a
3914: WHERE a.application_short_name = 'AMS'

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

3914: WHERE a.application_short_name = 'AMS'
3915: AND a.application_id = i.application_id;
3916: */
3917:
3918: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_customers -- ');
3919:
3920: INSERT INTO ozf_activity_customers
3921: (activity_customer_id,OBJECT_ID,
3922: OBJECT_TYPE,

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

3995: QP_QUALIFIER_ID,
3996: QP_QUALIFIER_GROUP
3997: FROM ozf_activity_customers_temp;
3998:
3999: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');
4000:
4001: INSERT INTO ozf_activity_products
4002: (activity_product_id,
4003: OBJECT_ID,

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

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

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

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

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

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

Line 4289: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4285:
4286:
4287:
4288: if p_curr_code <> j.order_currency then
4289: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4290: ,p_from_currency => j.order_currency
4291: ,p_to_currency => p_curr_code
4292: ,p_conv_date => j.trans_date
4293: ,p_from_amount => l_actual_revenue

Line 4296: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4292: ,p_conv_date => j.trans_date
4293: ,p_from_amount => l_actual_revenue
4294: ,x_to_amount => l_conv_actual_revenue);
4295:
4296: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4297: ,p_from_currency => j.order_currency
4298: ,p_to_currency => p_curr_code
4299: ,p_conv_date => j.trans_date
4300: ,p_from_amount => y_actual_revenue

Line 4303: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4299: ,p_conv_date => j.trans_date
4300: ,p_from_amount => y_actual_revenue
4301: ,x_to_amount => y_conv_actual_revenue);
4302:
4303: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4304: ,p_from_currency => j.order_currency
4305: ,p_to_currency => p_curr_code
4306: ,p_conv_date => j.trans_date
4307: ,p_from_amount => l_actual_costs

Line 4310: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

4306: ,p_conv_date => j.trans_date
4307: ,p_from_amount => l_actual_costs
4308: ,x_to_amount => l_conv_actual_costs);
4309:
4310: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
4311: ,p_from_currency => j.order_currency
4312: ,p_to_currency => p_curr_code
4313: ,p_conv_date => j.trans_date
4314: ,p_from_amount => y_actual_costs