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.BIC_LIFECYCLE_EXTRACT_PKG dependencies on BIC_LIFECYCLE_EXTRACT_PKG

Line 1: PACKAGE BODY bic_lifecycle_extract_pkg AS

1: PACKAGE BODY bic_lifecycle_extract_pkg AS
2: /* $Header: biclcexb.pls 120.4 2005/12/27 10:32:17 vsegu ship $ */
3:
4: -- Global variables for who columns
5: g_last_updated_by NUMBER;

Line 113: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

109: SELECT count(*) INTO rec_count
110: FROM bic_temp_periods;
111: IF rec_count = 0 THEN
112: write_log('LIFE_CYCLE data already extracted',
113: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
114: RETURN;
115: END IF;
116: -- write_log('Value of g_lc_comparision type ' || g_lc_comparison_type,
117: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

Line 117: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

113: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
114: RETURN;
115: END IF;
116: -- write_log('Value of g_lc_comparision type ' || g_lc_comparison_type,
117: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
118: -- write_log('Value of g_lc_granularity_level ' || g_lc_granularity_level,
119: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
120:
121: IF g_lc_granularity_level = 'Year' THEN

Line 119: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

115: END IF;
116: -- write_log('Value of g_lc_comparision type ' || g_lc_comparison_type,
117: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
118: -- write_log('Value of g_lc_granularity_level ' || g_lc_granularity_level,
119: -- 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
120:
121: IF g_lc_granularity_level = 'Year' THEN
122: bic_summary_extract_pkg.g_period_start_date := ADD_MONTHS(p_start_date,-23);
123: END IF;

Line 150: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

146: ELSIF g_measure_for_lc_stage = 'SALES' THEN
147: bic_summary_extract_pkg.extract_sales(bic_summary_extract_pkg.g_period_start_date,p_end_date,NULL,'Y');
148: END IF;
149: write_log('Before Inserting New Customers for Life Cycle ....',
150: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
151: IF p_delete_flag = 'N' THEN
152: bic_summary_extract_pkg.extract_periods (
153: add_months(p_start_date ,g_lc_new_cust_period*- 1),
154: p_end_date,

Line 168: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

164: x_c_select := Common_Select ;
165: -- write_log(' the lc **select ***query is ' || x_c_select , 'lifecycle' );
166: Insert_New_Cust ;
167: write_log('Before Inserting Insignificant Customers for Life Cycle ....',
168: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
169: insert_Insig_Cust(x_c_select) ;
170: write_log('Before Inserting Stable, Defected, Growing and Declining
171: Customers for Life Cycle ....',
172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

Line 172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

168: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
169: insert_Insig_Cust(x_c_select) ;
170: write_log('Before Inserting Stable, Defected, Growing and Declining
171: Customers for Life Cycle ....',
172: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
173: Insert_Others(x_c_select) ;
174: bic_consolidate_cust_data_pkg.populate_status_data(p_start_date, p_end_date, 'LIFE_CYCLE' );
175: bic_consolidate_cust_data_pkg.purge_party_summary_data;
176: bic_consolidate_cust_data_pkg.purge_customer_summary_data;

Line 183: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

179: COMMIT;
180: EXCEPTION
181: WHEN NO_LC_SETUP_DATA THEN
182: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
183: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
184: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
185: 'No records in BIC_LC_SETUP_ALL');
186: ROLLBACK;
187: WHEN NO_LC_PROFILE_DATA THEN

Line 189: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

185: 'No records in BIC_LC_SETUP_ALL');
186: ROLLBACK;
187: WHEN NO_LC_PROFILE_DATA THEN
188: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
189: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
190: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
191: 'No records in BIC_PROFILE_VALUES_ALL');
192: ROLLBACK;
193: WHEN NO_LC_MEASURE_ID THEN

Line 195: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

191: 'No records in BIC_PROFILE_VALUES_ALL');
192: ROLLBACK;
193: WHEN NO_LC_MEASURE_ID THEN
194: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
195: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
196: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,
197: 'Measure_id not found for LIFE_CYCLE in the table BIC_MEASURES_ALL');
198: ROLLBACK;
199: WHEN OTHERS THEN

Line 201: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');

197: 'Measure_id not found for LIFE_CYCLE in the table BIC_MEASURES_ALL');
198: ROLLBACK;
199: WHEN OTHERS THEN
200: write_log(' LIFECYCLE data is not extracted due to exception : '||SQLERRM,
201: 'bic_lifecycle_extract_pkg.extract_lifecycle_data');
202: bic_summary_extract_pkg.generate_error(bic_summary_extract_pkg.g_measure_code,'LIFECYCLE data is not extracted : '||SQLERRM);
203: bic_summary_extract_pkg.g_period_start_date := p_start_date;
204: ROLLBACK;
205: END extract_lifecycle_data ;

Line 280: write_log('Error:' || sqlerrm, 'bic_lifecycle_extract_pkg.Insert_New_Cust') ; */

276: write_log('dup value for ' || x_party_id , ' knk lc' );
277: null;
278:
279: WHEN OTHERS THEN
280: write_log('Error:' || sqlerrm, 'bic_lifecycle_extract_pkg.Insert_New_Cust') ; */
281:
282: END Insert_New_Cust ;
283:
284: ---------------------------------------------------------------------------------------

Line 426: write_log('Error:' || sqlerrm || 'for party ' || x_cust_id(i), 'bic_lifecycle_extract_pkg.Insert_Insig_Cust');

422:
423: /*
424: EXCEPTION
425: WHEN OTHERS THEN
426: write_log('Error:' || sqlerrm || 'for party ' || x_cust_id(i), 'bic_lifecycle_extract_pkg.Insert_Insig_Cust');
427: */
428:
429:
430: END Insert_Insig_Cust ;

Line 503: write_log('Error:' || sqlerrm || ' for party ' || x_cust_id(i), 'bic_lifecycle_extract_pkg.Insert_Others'); */

499:
500: /*
501: EXCEPTION
502: WHEN OTHERS THEN
503: write_log('Error:' || sqlerrm || ' for party ' || x_cust_id(i), 'bic_lifecycle_extract_pkg.Insert_Others'); */
504:
505:
506: END Insert_Others ;
507:

Line 533: ' period ' || p_start_date, 'bic_lifecycle_extract_pkg.Insert_Record');

529:
530: EXCEPTION
531: WHEN DUP_VAL_ON_INDEX THEN
532: write_log('LifeCycle Step-up resulted: Error inside insert_record :' || SQLERRM || ' for customer ' || p_cust_id ||
533: ' period ' || p_start_date, 'bic_lifecycle_extract_pkg.Insert_Record');
534: -- NULL;
535: -- if setup data is not right and some new customer may fall in
536: -- these categories too.
537:

Line 539: -- write_log('Error:' || sqlerrm, 'bic_lifecycle_extract_pkg.Insert_Record');

535: -- if setup data is not right and some new customer may fall in
536: -- these categories too.
537:
538: -- WHEN OTHERS THEN
539: -- write_log('Error:' || sqlerrm, 'bic_lifecycle_extract_pkg.Insert_Record');
540:
541:
542: END Insert_Record ;
543:

Line 647: write_log('Error:' || SQLERRM, 'bic_lifecycle_extract_pkg.Initialize');

643:
644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: write_log('Error:' || SQLERRM, 'bic_lifecycle_extract_pkg.Initialize');
648: IF g_growing_vlu1 IS NULL OR g_growing_vlu2 IS NULL OR
649: g_op_growing1 IS NULL OR g_op_growing2 IS NULL THEN
650: RAISE NO_LC_SETUP_DATA ;
651: END IF;

Line 688: END bic_lifecycle_extract_pkg ;

684:
685: END write_log;
686:
687:
688: END bic_lifecycle_extract_pkg ;