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_CUST_FACTS_PVT dependencies on OZF_UTILITY_PVT

Line 48: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

44:
45:
46: BEGIN
47:
48: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
49:
50: IF FND_API.to_boolean(p_init_msg_list) THEN
51: FND_MSG_PUB.initialize;
52: END IF;

Line 145: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

141: AND bb.status_code <> 'CANCELLED')
142: )
143: AND prod.item_type <> 'OTHERS');
144:
145: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: x_return_status := FND_API.g_ret_sts_error ;

Line 303: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

299: l_mtd_bsales NUMBER;
300:
301: BEGIN
302:
303: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
304:
305: IF FND_API.to_boolean(p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;
307: END IF;

Line 506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);

502: IF l_ytd_sales < l_ytd_bsales THEN
503: l_ytd_bsales := l_ytd_sales ;
504: END IF ;
505:
506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);
507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);
508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);
509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);
510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);

Line 507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);

503: l_ytd_bsales := l_ytd_sales ;
504: END IF ;
505:
506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);
507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);
508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);
509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);
510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);
511:

Line 508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);

504: END IF ;
505:
506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);
507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);
508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);
509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);
510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);
511:
512: -- Modified for R12

Line 509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);

505:
506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);
507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);
508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);
509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);
510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);
511:
512: -- Modified for R12
513: UPDATE ozf_cust_daily_facts

Line 510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);

506: -- ozf_utility_pvt.write_conc_log( 'Fact Id : '||fact.cust_daily_fact_id);
507: -- ozf_utility_pvt.write_conc_log( 'Day : '|| l_day_total);
508: -- ozf_utility_pvt.write_conc_log( 'Week : '|| l_week_total);
509: -- ozf_utility_pvt.write_conc_log( 'Month : '|| l_mth_total);
510: -- ozf_utility_pvt.write_conc_log( 'Quarter : '|| l_qtr_total);
511:
512: -- Modified for R12
513: UPDATE ozf_cust_daily_facts
514: SET ptd_sales = l_mtd_sales

Line 530: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

526: WHERE cust_daily_fact_id = fact.cust_daily_fact_id;
527:
528: END LOOP;
529: --
530: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.g_ret_sts_error ;

Line 683: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

679: l_temp_bo_qty NUMBER;
680:
681: BEGIN
682:
683: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
684:
685: IF FND_API.to_boolean(p_init_msg_list) THEN
686: FND_MSG_PUB.initialize;
687: END IF;

Line 735: ozf_utility_pvt.write_conc_log('Cannot convert ' || ord.from_unit || ' to ' || ord.to_unit );

731: FND_MESSAGE.Set_Token('TO_VALUE', err.common_uom_code);
732: FND_MESSAGE.Set_Token('DATE', err.transaction_date);
733: l_mesg := FND_MESSAGE.Get;
734: */
735: ozf_utility_pvt.write_conc_log('Cannot convert ' || ord.from_unit || ' to ' || ord.to_unit );
736: ozf_utility_pvt.write_conc_log('This value will be ignored ' || ord.unit );
737:
738: GOTO NEXT_ORDER;
739: END IF;

Line 736: ozf_utility_pvt.write_conc_log('This value will be ignored ' || ord.unit );

732: FND_MESSAGE.Set_Token('DATE', err.transaction_date);
733: l_mesg := FND_MESSAGE.Get;
734: */
735: ozf_utility_pvt.write_conc_log('Cannot convert ' || ord.from_unit || ' to ' || ord.to_unit );
736: ozf_utility_pvt.write_conc_log('This value will be ignored ' || ord.unit );
737:
738: GOTO NEXT_ORDER;
739: END IF;
740:

Line 787: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

783: WHERE cust_daily_fact_id = fact.cust_daily_fact_id;
784:
785: END LOOP;
786: --
787: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
788:
789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status := FND_API.g_ret_sts_error ;

Line 1044: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

1040: WHERE ent_year_id = p_year_id;
1041:
1042: BEGIN
1043:
1044: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1045:
1046: IF FND_API.to_boolean(p_init_msg_list) THEN
1047: FND_MSG_PUB.initialize;
1048: END IF;

Line 1192: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

1188: l_current_year_target := NULL;
1189:
1190: END LOOP;
1191: --
1192: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
1193:
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: x_return_status := FND_API.g_ret_sts_error ;

Line 1257: ozf_utility_pvt.write_conc_log('Private API: ' || 'Insert_Kpi' || ' (-)') ;

1253: l_ytd_sales VARCHAR2(100):= FND_MESSAGE.GET_STRING('OZF','OZF_DASHB_KPI_YTD_SALES');
1254:
1255: BEGIN
1256:
1257: ozf_utility_pvt.write_conc_log('Private API: ' || 'Insert_Kpi' || ' (-)') ;
1258:
1259: -- inanaiah: bug 4912723 - commented as deletion happens in refresh_kpi_info
1260: /*
1261: DELETE FROM ozf_dashb_daily_kpi

Line 1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;

1271: l_ent_year_id,
1272: l_ent_year_name;
1273: CLOSE period_name_csr;
1274:
1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;
1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;

Line 1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;

1272: l_ent_year_name;
1273: CLOSE period_name_csr;
1274:
1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;
1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;

Line 1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;

1273: CLOSE period_name_csr;
1274:
1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;
1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;
1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;

Line 1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;

1274:
1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;
1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;
1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;
1282:

Line 1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;

1275: ozf_utility_pvt.write_conc_log('-- p_resource_id : '|| p_resource_id ) ;
1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;
1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;
1282:
1283: l_kpi_rec_count := 0;

Line 1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;

1276: ozf_utility_pvt.write_conc_log('-- p_current_period_target : '|| p_current_period_target ) ;
1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;
1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;
1282:
1283: l_kpi_rec_count := 0;
1284: LOOP

Line 1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;

1277: ozf_utility_pvt.write_conc_log('-- p_current_qtr_target : '|| p_current_qtr_target ) ;
1278: ozf_utility_pvt.write_conc_log('-- p_current_year_target : '|| p_current_year_target ) ;
1279: ozf_utility_pvt.write_conc_log('-- p_current_period_sales : '|| p_current_period_sales ) ;
1280: ozf_utility_pvt.write_conc_log('-- p_current_qtr_sales : '|| p_current_qtr_sales ) ;
1281: ozf_utility_pvt.write_conc_log('-- p_current_year_sales : '|| p_current_year_sales ) ;
1282:
1283: l_kpi_rec_count := 0;
1284: LOOP
1285: l_kpi_rec_count := l_kpi_rec_count + 1;

Line 1401: ozf_utility_pvt.write_conc_log('Private API: ' || 'Insert_Kpi' || ' (+)');

1397:
1398: END LOOP;
1399:
1400: --
1401: ozf_utility_pvt.write_conc_log('Private API: ' || 'Insert_Kpi' || ' (+)');
1402:
1403: END insert_kpi;
1404:
1405:

Line 1581: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

1577: l_current_year_sales NUMBER;
1578:
1579: BEGIN
1580:
1581: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1582:
1583: IF FND_API.to_boolean(p_init_msg_list) THEN
1584: FND_MSG_PUB.initialize;
1585: END IF;

Line 1710: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

1706: l_current_year_sales);
1707:
1708: END LOOP; -- Process next resource
1709:
1710: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
1711:
1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN

Line 1857: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

1853: l_quota_sales NUMBER;
1854: l_acct_time_sales NUMBER;
1855:
1856: BEGIN
1857: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1858:
1859: IF FND_API.to_boolean(p_init_msg_list) THEN
1860: FND_MSG_PUB.initialize;
1861: END IF;

Line 2013: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

2009:
2010:
2011:
2012: -- End Package Body
2013: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2014:
2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_ERROR THEN

Line 2121: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');

2117: -- Initialize message list if p_init_msg_list is set to TRUE.
2118: FND_MSG_PUB.initialize;
2119:
2120: -- Debug Message
2121: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');
2122:
2123: -- Initialize API return status to SUCCESS
2124: x_return_status := FND_API.G_RET_STS_SUCCESS;
2125:

Line 2166: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

2162:
2163: END LOOP; -- End of parent_quotas_csr
2164:
2165: -- Procedure body end
2166: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2167:
2168: EXCEPTION
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN

Line 2205: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

2201: l_return_status VARCHAR2(1);
2202:
2203: BEGIN
2204:
2205: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
2206:
2207: IF FND_API.to_boolean(p_init_msg_list) THEN
2208: FND_MSG_PUB.initialize;
2209: END IF;

Line 2745: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

2741: )
2742: WHERE outer.fact_row_for = 'SHIP_TO'
2743: AND outer.report_date = p_report_date;
2744:
2745: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2746:
2747: EXCEPTION
2748: WHEN FND_API.G_EXC_ERROR THEN
2749: x_return_status := FND_API.g_ret_sts_error ;

Line 2782: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

2778: l_return_status VARCHAR2(1);
2779:
2780: BEGIN
2781:
2782: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
2783:
2784: IF FND_API.to_boolean(p_init_msg_list) THEN
2785: FND_MSG_PUB.initialize;
2786: END IF;

Line 3488: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

3484: )
3485: WHERE outer.fact_row_for = 'SHIP_TO'
3486: AND outer.report_date = p_report_date ;
3487:
3488: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
3489:
3490: EXCEPTION
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: x_return_status := FND_API.g_ret_sts_error ;

Line 3542: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');

3538: -- Initialize message list if p_init_msg_list is set to TRUE.
3539: FND_MSG_PUB.initialize;
3540:
3541: -- Debug Message
3542: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');
3543:
3544: -- Initialize API return status to SUCCESS
3545: x_return_status := FND_API.G_RET_STS_SUCCESS;
3546:

Line 3554: ozf_utility_pvt.write_conc_log(' -- report_date is : ' || l_report_date );

3550: THEN
3551: l_report_date := TRUNC(SYSDATE);
3552: END IF;
3553:
3554: ozf_utility_pvt.write_conc_log(' -- report_date is : ' || l_report_date );
3555: --
3556: -- Refresh Account and Products
3557: --
3558:

Line 3578: -- ozf_utility_pvt.write_conc_log('-22');

3574: --
3575: -- Refresh Sales Info
3576: --
3577:
3578: -- ozf_utility_pvt.write_conc_log('-22');
3579: refresh_sales_info(
3580: l_api_version ,
3581: l_init_msg_list ,
3582: l_report_date ,

Line 3609: -- ozf_utility_pvt.write_conc_log('-33');

3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:
3609: -- ozf_utility_pvt.write_conc_log('-33');
3610: --
3611: -- Refresh Order Info
3612: --
3613:

Line 3633: -- ozf_utility_pvt.write_conc_log('-44');

3629: --
3630: -- Refresh KPI Info
3631: --
3632:
3633: -- ozf_utility_pvt.write_conc_log('-44');
3634:
3635: refresh_kpi_info(
3636: l_api_version ,
3637: l_init_msg_list ,

Line 3679: -- ozf_utility_pvt.write_conc_log('- End');

3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3676: RAISE FND_API.g_exc_unexpected_error;
3677: END IF;
3678:
3679: -- ozf_utility_pvt.write_conc_log('- End');
3680:
3681: /*
3682: update_sales_info(
3683: l_api_version ,

Line 3699: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');

3695: x_return_status ,
3696: x_msg_count ,
3697: x_msg_data ) ;
3698:
3699: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');
3700:
3701: EXCEPTION
3702: WHEN FND_API.G_EXC_ERROR THEN
3703: x_return_status := FND_API.g_ret_sts_error ;

Line 3709: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');

3705: p_count => x_msg_count,
3706: p_data => x_msg_data);
3707: ERRBUF := x_msg_data;
3708: RETCODE := 2;
3709: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
3710:
3711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3712: x_return_status := FND_API.g_ret_sts_unexp_error ;
3713: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 3718: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');

3714: p_count => x_msg_count,
3715: p_data => x_msg_data);
3716: ERRBUF := x_msg_data;
3717: RETCODE := 2;
3718: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');
3719:
3720: WHEN OTHERS THEN
3721: x_return_status := FND_API.g_ret_sts_unexp_error ;
3722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 3728: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');

3724: p_data => x_msg_data);
3725:
3726: ERRBUF := sqlerrm(sqlcode);
3727: RETCODE := sqlcode;
3728: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');
3729:
3730: END load_daily_facts;
3731:
3732: