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.FII_PARTY_MKT_CLASS_C dependencies on BIS_COLLECTION_UTILITIES

Line 57: bis_collection_utilities.log('Error in Party Market Classification Type global setup ');

53: -- Then exit with error.
54:
55: IF NOT non_hierarchical_class( )
56: THEN
57: bis_collection_utilities.log('Error in Party Market Classification Type global setup ');
58: bis_collection_utilities.log('Make sure that Party Market Classification Type profile is non hierarchical and does not allow multiple parent code or multiple class code assignment. ');
59: raise g_bis_setup_exception;
60: END IF;
61:

Line 58: bis_collection_utilities.log('Make sure that Party Market Classification Type profile is non hierarchical and does not allow multiple parent code or multiple class code assignment. ');

54:
55: IF NOT non_hierarchical_class( )
56: THEN
57: bis_collection_utilities.log('Error in Party Market Classification Type global setup ');
58: bis_collection_utilities.log('Make sure that Party Market Classification Type profile is non hierarchical and does not allow multiple parent code or multiple class code assignment. ');
59: raise g_bis_setup_exception;
60: END IF;
61:
62: IF (g_retcode <> 0)

Line 67: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('FII_PARTY_MKT_CLASS');

63: THEN
64: RAISE l_exception;
65: END IF;
66:
67: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('FII_PARTY_MKT_CLASS');
68: IF (NOT l_setup_ok) THEN
69: errbuf := fnd_message.get;
70: bis_collection_utilities.log( 'BIS Setup Failure ',0);
71: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);

Line 70: bis_collection_utilities.log( 'BIS Setup Failure ',0);

66:
67: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('FII_PARTY_MKT_CLASS');
68: IF (NOT l_setup_ok) THEN
69: errbuf := fnd_message.get;
70: bis_collection_utilities.log( 'BIS Setup Failure ',0);
71: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
72: END IF;
73:
74: -- check to see whether initial load or incremental load.

Line 83: bis_collection_utilities.log('Setting dates for initial load. ');

79: -- Current request is for initial
80: -- OR
81: -- Last Initial is unseccessfull
82: g_phase := 'Setting dates for initial load.';
83: bis_collection_utilities.log('Setting dates for initial load. ');
84: g_collection_from_date := bis_common_parameters.get_GLOBAL_START_DATE; --global start date
85: if (g_collection_from_date is null) then
86: raise g_bis_setup_exception;
87: end if;

Line 96: bis_collection_utilities.log('Setting dates for incremental load. ');

92: THEN
93: IF( g_last_success_flag = 'Y')
94: THEN
95: -- Last Load is successfull
96: bis_collection_utilities.log('Setting dates for incremental load. ');
97: g_collection_from_date := g_last_collection_to_date;
98: g_collection_to_date := g_run_date;
99: ELSE
100: -- Last Load is unsuccessfull

Line 101: bis_collection_utilities.log('Unsuccessfull initial load. Contact Administrator to complete initial load of party market classification');

97: g_collection_from_date := g_last_collection_to_date;
98: g_collection_to_date := g_run_date;
99: ELSE
100: -- Last Load is unsuccessfull
101: bis_collection_utilities.log('Unsuccessfull initial load. Contact Administrator to complete initial load of party market classification');
102: RAISE l_exception;
103: END IF;
104: g_process_type := 'INCRE';
105: incremental_load();

Line 107: bis_collection_utilities.log('Please enter a valid parameter for load mode. Use INIT for initial load and INCRE for incremental load.');

103: END IF;
104: g_process_type := 'INCRE';
105: incremental_load();
106: ELSE
107: bis_collection_utilities.log('Please enter a valid parameter for load mode. Use INIT for initial load and INCRE for incremental load.');
108: RAISE l_exception;
109: END IF;
110:
111: IF (g_retcode <> 0)

Line 116: bis_collection_utilities.log('Current Collection Details: ');

112: THEN
113: RAISE l_exception;
114: END IF;
115:
116: bis_collection_utilities.log('Current Collection Details: ');
117: bis_collection_utilities.log(' Process Type : ' || g_process_type );
118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
120: bis_collection_utilities.log(' Success Flag : ' || 'Y');

Line 117: bis_collection_utilities.log(' Process Type : ' || g_process_type );

113: RAISE l_exception;
114: END IF;
115:
116: bis_collection_utilities.log('Current Collection Details: ');
117: bis_collection_utilities.log(' Process Type : ' || g_process_type );
118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
120: bis_collection_utilities.log(' Success Flag : ' || 'Y');
121:

Line 118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));

114: END IF;
115:
116: bis_collection_utilities.log('Current Collection Details: ');
117: bis_collection_utilities.log(' Process Type : ' || g_process_type );
118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
120: bis_collection_utilities.log(' Success Flag : ' || 'Y');
121:
122: COMMIT;

Line 119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));

115:
116: bis_collection_utilities.log('Current Collection Details: ');
117: bis_collection_utilities.log(' Process Type : ' || g_process_type );
118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
120: bis_collection_utilities.log(' Success Flag : ' || 'Y');
121:
122: COMMIT;
123:

Line 120: bis_collection_utilities.log(' Success Flag : ' || 'Y');

116: bis_collection_utilities.log('Current Collection Details: ');
117: bis_collection_utilities.log(' Process Type : ' || g_process_type );
118: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
119: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
120: bis_collection_utilities.log(' Success Flag : ' || 'Y');
121:
122: COMMIT;
123:
124: bis_collection_utilities.log('SUCCESS: Load Program Successfully completed ' ||

Line 124: bis_collection_utilities.log('SUCCESS: Load Program Successfully completed ' ||

120: bis_collection_utilities.log(' Success Flag : ' || 'Y');
121:
122: COMMIT;
123:
124: bis_collection_utilities.log('SUCCESS: Load Program Successfully completed ' ||
125: fnd_date.date_to_displayDT(sysdate),0);
126:
127: BIS_COLLECTION_UTILITIES.wrapup(TRUE,
128: -1,

Line 127: BIS_COLLECTION_UTILITIES.wrapup(TRUE,

123:
124: bis_collection_utilities.log('SUCCESS: Load Program Successfully completed ' ||
125: fnd_date.date_to_displayDT(sysdate),0);
126:
127: BIS_COLLECTION_UTILITIES.wrapup(TRUE,
128: -1,
129: 'FII_PARTY_MKT_CLASS COLLECTION SUCCEEFULL',
130: g_collection_from_date,
131: g_collection_to_date

Line 138: bis_collection_utilities.log('Error partner classification load program ');

134: WHEN l_exception THEN
135: errbuf := sqlerrm;
136: retcode := 2;
137: WHEN g_bis_setup_exception THEN
138: bis_collection_utilities.log('Error partner classification load program ');
139: bis_collection_utilities.log('Phase : ' || g_phase);
140: retcode := -1;
141: rollback;
142: WHEN OTHERS THEN

Line 139: bis_collection_utilities.log('Phase : ' || g_phase);

135: errbuf := sqlerrm;
136: retcode := 2;
137: WHEN g_bis_setup_exception THEN
138: bis_collection_utilities.log('Error partner classification load program ');
139: bis_collection_utilities.log('Phase : ' || g_phase);
140: retcode := -1;
141: rollback;
142: WHEN OTHERS THEN
143: l_error_message := sqlerrm;

Line 144: bis_collection_utilities.log('Error partner classification load program ');

140: retcode := -1;
141: rollback;
142: WHEN OTHERS THEN
143: l_error_message := sqlerrm;
144: bis_collection_utilities.log('Error partner classification load program ');
145: bis_collection_utilities.log('Error Message : ' || l_error_message);
146: bis_collection_utilities.log('Phase : ' || g_phase);
147: errbuf := l_error_message;
148: retcode := 2;

Line 145: bis_collection_utilities.log('Error Message : ' || l_error_message);

141: rollback;
142: WHEN OTHERS THEN
143: l_error_message := sqlerrm;
144: bis_collection_utilities.log('Error partner classification load program ');
145: bis_collection_utilities.log('Error Message : ' || l_error_message);
146: bis_collection_utilities.log('Phase : ' || g_phase);
147: errbuf := l_error_message;
148: retcode := 2;
149: END load;

Line 146: bis_collection_utilities.log('Phase : ' || g_phase);

142: WHEN OTHERS THEN
143: l_error_message := sqlerrm;
144: bis_collection_utilities.log('Error partner classification load program ');
145: bis_collection_utilities.log('Error Message : ' || l_error_message);
146: bis_collection_utilities.log('Phase : ' || g_phase);
147: errbuf := l_error_message;
148: retcode := 2;
149: END load;
150:

Line 159: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

155:
156: BEGIN
157: g_phase := 'Getting last refresh dates';
158:
159: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
160: p_object_name => 'FII_PARTY_MKT_CLASS',
161: p_start_date => l_period_from,
162: p_end_date => l_period_to,
163: p_period_from => g_last_collection_from_date,

Line 173: bis_collection_utilities.log('Last Collection Details: ');

169: ELSE
170: g_last_success_flag := 'Y';
171: END IF;
172:
173: bis_collection_utilities.log('Last Collection Details: ');
174: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_last_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
175: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_last_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
176:
177: EXCEPTION

Line 174: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_last_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));

170: g_last_success_flag := 'Y';
171: END IF;
172:
173: bis_collection_utilities.log('Last Collection Details: ');
174: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_last_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
175: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_last_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
176:
177: EXCEPTION
178: WHEN OTHERS THEN

Line 175: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_last_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));

171: END IF;
172:
173: bis_collection_utilities.log('Last Collection Details: ');
174: bis_collection_utilities.log(' Collection From Date : ' || to_char(g_last_collection_from_date,'DD-MON-YYYY HH24:MI:SS'));
175: bis_collection_utilities.log(' Collection To Date : ' || to_char(g_last_collection_to_date,'DD-MON-YYYY HH24:MI:SS'));
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: l_error_message := sqlerrm;

Line 180: bis_collection_utilities.log('Error While collecting last log information ');

176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: l_error_message := sqlerrm;
180: bis_collection_utilities.log('Error While collecting last log information ');
181: bis_collection_utilities.log('Error Message : ' || l_error_message);
182: bis_collection_utilities.log('Phase : ' || g_phase);
183: g_errbuf := l_error_message;
184: g_retcode := 2;

Line 181: bis_collection_utilities.log('Error Message : ' || l_error_message);

177: EXCEPTION
178: WHEN OTHERS THEN
179: l_error_message := sqlerrm;
180: bis_collection_utilities.log('Error While collecting last log information ');
181: bis_collection_utilities.log('Error Message : ' || l_error_message);
182: bis_collection_utilities.log('Phase : ' || g_phase);
183: g_errbuf := l_error_message;
184: g_retcode := 2;
185: END last_collection_detail;

Line 182: bis_collection_utilities.log('Phase : ' || g_phase);

178: WHEN OTHERS THEN
179: l_error_message := sqlerrm;
180: bis_collection_utilities.log('Error While collecting last log information ');
181: bis_collection_utilities.log('Error Message : ' || l_error_message);
182: bis_collection_utilities.log('Phase : ' || g_phase);
183: g_errbuf := l_error_message;
184: g_retcode := 2;
185: END last_collection_detail;
186:

Line 216: bis_collection_utilities.log('Classification Category is hierarchical. ');

212: */
213: IF (l_ret_val <> 0)
214: THEN
215: RETURN FALSE;
216: bis_collection_utilities.log('Classification Category is hierarchical. ');
217: ELSE
218: bis_collection_utilities.log('Classification Category is non-hierarchical. ');
219:
220: END IF;

Line 218: bis_collection_utilities.log('Classification Category is non-hierarchical. ');

214: THEN
215: RETURN FALSE;
216: bis_collection_utilities.log('Classification Category is hierarchical. ');
217: ELSE
218: bis_collection_utilities.log('Classification Category is non-hierarchical. ');
219:
220: END IF;
221: -- Checks if multiple parent flag is set to Y or multiple class code assignment flag is set to 'Y'.
222: g_phase := 'Checks if multiple parent flag is set to Y or multiple class code assignment flag is set to Yes';

Line 233: bis_collection_utilities.log('Classification Category allows multiple parent code or multiple class code assignment. ');

229:
230: IF (l_ret_val <> 0)
231: THEN
232: RETURN FALSE;
233: bis_collection_utilities.log('Classification Category allows multiple parent code or multiple class code assignment. ');
234: ELSE
235: RETURN TRUE;
236: bis_collection_utilities.log('Classification Category is non-hierarchial and does not allow multiple parent code or multiple class code assignment . ');
237:

Line 236: bis_collection_utilities.log('Classification Category is non-hierarchial and does not allow multiple parent code or multiple class code assignment . ');

232: RETURN FALSE;
233: bis_collection_utilities.log('Classification Category allows multiple parent code or multiple class code assignment. ');
234: ELSE
235: RETURN TRUE;
236: bis_collection_utilities.log('Classification Category is non-hierarchial and does not allow multiple parent code or multiple class code assignment . ');
237:
238: END IF;
239:
240: EXCEPTION

Line 243: bis_collection_utilities.log('Error while verifying partner classification global setup ');

239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: l_error_message := sqlerrm;
243: bis_collection_utilities.log('Error while verifying partner classification global setup ');
244: bis_collection_utilities.log('Error Message : ' || l_error_message);
245: bis_collection_utilities.log('Phase : ' || g_phase);
246: g_errbuf := l_error_message;
247: g_retcode := 2;

Line 244: bis_collection_utilities.log('Error Message : ' || l_error_message);

240: EXCEPTION
241: WHEN OTHERS THEN
242: l_error_message := sqlerrm;
243: bis_collection_utilities.log('Error while verifying partner classification global setup ');
244: bis_collection_utilities.log('Error Message : ' || l_error_message);
245: bis_collection_utilities.log('Phase : ' || g_phase);
246: g_errbuf := l_error_message;
247: g_retcode := 2;
248: END non_hierarchical_class;

Line 245: bis_collection_utilities.log('Phase : ' || g_phase);

241: WHEN OTHERS THEN
242: l_error_message := sqlerrm;
243: bis_collection_utilities.log('Error while verifying partner classification global setup ');
244: bis_collection_utilities.log('Error Message : ' || l_error_message);
245: bis_collection_utilities.log('Phase : ' || g_phase);
246: g_errbuf := l_error_message;
247: g_retcode := 2;
248: END non_hierarchical_class;
249:

Line 300: bis_collection_utilities.log('Truncating FII_PARTY_MKT_CLASS Table ');

296:
297: -- Identify Last valid class code for each party and create a record in FII_PARTY_MKT_CLASS table
298: g_phase := 'Identify Last valid class code for each party and create a record in FII_PARTY_MKT_CLASS table';
299:
300: bis_collection_utilities.log('Truncating FII_PARTY_MKT_CLASS Table ');
301:
302: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS';
303: EXECUTE IMMEDIATE l_sql_string;
304:

Line 305: bis_collection_utilities.log('Bis log file was reset for FII_PARTY_MKT_CLASS. ');

301:
302: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS';
303: EXECUTE IMMEDIATE l_sql_string;
304:
305: bis_collection_utilities.log('Bis log file was reset for FII_PARTY_MKT_CLASS. ');
306: BIS_COLLECTION_UTILITIES.DeleteLogForObject('FII_PARTY_MKT_CLASS');
307:
308: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table');
309: g_phase := 'Populating FII_PARTY_MKT_CLASS table';

Line 306: BIS_COLLECTION_UTILITIES.DeleteLogForObject('FII_PARTY_MKT_CLASS');

302: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS';
303: EXECUTE IMMEDIATE l_sql_string;
304:
305: bis_collection_utilities.log('Bis log file was reset for FII_PARTY_MKT_CLASS. ');
306: BIS_COLLECTION_UTILITIES.DeleteLogForObject('FII_PARTY_MKT_CLASS');
307:
308: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table');
309: g_phase := 'Populating FII_PARTY_MKT_CLASS table';
310:

Line 308: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table');

304:
305: bis_collection_utilities.log('Bis log file was reset for FII_PARTY_MKT_CLASS. ');
306: BIS_COLLECTION_UTILITIES.DeleteLogForObject('FII_PARTY_MKT_CLASS');
307:
308: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table');
309: g_phase := 'Populating FII_PARTY_MKT_CLASS table';
310:
311: INSERT /*+ APPEND */ INTO fii_party_mkt_class
312: (

Line 353: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table for unassigned customers');

349: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_party_mkt_class');
350:
351: commit; --Added for ORA-12838: cannot read/modify an object after modifying it in parallel
352:
353: bis_collection_utilities.log('Populating FII_PARTY_MKT_CLASS table for unassigned customers');
354:
355: g_phase := 'Populating FII_PARTY_MKT_CLASS table for unassigned customers';
356:
357: INSERT /*+ APPEND */ INTO fii_party_mkt_class

Line 394: bis_collection_utilities.log('Error while doing initial population of partner classification table ');

390:
391: EXCEPTION
392: WHEN OTHERS THEN
393: l_error_message := sqlerrm;
394: bis_collection_utilities.log('Error while doing initial population of partner classification table ');
395: bis_collection_utilities.log('Error Message : ' || l_error_message);
396: bis_collection_utilities.log('Phase : ' || g_phase);
397: g_errbuf := l_error_message;
398: g_retcode := 2;

Line 395: bis_collection_utilities.log('Error Message : ' || l_error_message);

391: EXCEPTION
392: WHEN OTHERS THEN
393: l_error_message := sqlerrm;
394: bis_collection_utilities.log('Error while doing initial population of partner classification table ');
395: bis_collection_utilities.log('Error Message : ' || l_error_message);
396: bis_collection_utilities.log('Phase : ' || g_phase);
397: g_errbuf := l_error_message;
398: g_retcode := 2;
399: END initial_load;

Line 396: bis_collection_utilities.log('Phase : ' || g_phase);

392: WHEN OTHERS THEN
393: l_error_message := sqlerrm;
394: bis_collection_utilities.log('Error while doing initial population of partner classification table ');
395: bis_collection_utilities.log('Error Message : ' || l_error_message);
396: bis_collection_utilities.log('Phase : ' || g_phase);
397: g_errbuf := l_error_message;
398: g_retcode := 2;
399: END initial_load;
400:

Line 471: bis_collection_utilities.log('Truncating Staging table');

467:
468: -- Identify Last valid class code for each party and create a record in FII_PARTY_MKT_CLASS table
469:
470:
471: bis_collection_utilities.log('Truncating Staging table');
472:
473: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS_STG';
474: EXECUTE IMMEDIATE l_sql_string;
475:

Line 476: bis_collection_utilities.log('Populating Staging table with incremental records from hz_code_assignments table');

472:
473: l_sql_string := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PARTY_MKT_CLASS_STG';
474: EXECUTE IMMEDIATE l_sql_string;
475:
476: bis_collection_utilities.log('Populating Staging table with incremental records from hz_code_assignments table');
477: g_phase := 'Populating Staging table with incremental records from hz_code_assignments table';
478:
479: -- Bug 5093260. Performance enhancement
480: INSERT INTO fii_party_mkt_class_stg

Line 521: bis_collection_utilities.log('Populating staging table with customer_ids that are created after last collection');

517: ) v
518: WHERE a.OWNER_TABLE_ID = v.OWNER_TABLE_ID
519: AND a.CLASS_CATEGORY = g_class_type;
520:
521: bis_collection_utilities.log('Populating staging table with customer_ids that are created after last collection');
522: bis_collection_utilities.log(' and that are not assigned to any class code' );
523: g_phase := 'Populating staging table with customer_ids that are created after last collection
524: and that are not assigned to any class code';
525:

Line 522: bis_collection_utilities.log(' and that are not assigned to any class code' );

518: WHERE a.OWNER_TABLE_ID = v.OWNER_TABLE_ID
519: AND a.CLASS_CATEGORY = g_class_type;
520:
521: bis_collection_utilities.log('Populating staging table with customer_ids that are created after last collection');
522: bis_collection_utilities.log(' and that are not assigned to any class code' );
523: g_phase := 'Populating staging table with customer_ids that are created after last collection
524: and that are not assigned to any class code';
525:
526: -- Bug 5093260. Performance enhancement

Line 575: bis_collection_utilities.log('Merging records into FII_PARTY_MKT_CLASS table ');

571: FND_STATS.gather_table_stats
572: (ownname => l_fii_schema,
573: tabname => 'FII_PARTY_MKT_CLASS_STG');
574:
575: bis_collection_utilities.log('Merging records into FII_PARTY_MKT_CLASS table ');
576: g_phase := 'Merging records into FII_PARTY_MKT_CLASS table';
577:
578: MERGE INTO fii_party_mkt_class cl
579: USING

Line 638: bis_collection_utilities.log('Error while doing incremental population of partner classification table ');

634:
635: EXCEPTION
636: WHEN OTHERS THEN
637: l_error_message := sqlerrm;
638: bis_collection_utilities.log('Error while doing incremental population of partner classification table ');
639: bis_collection_utilities.log('Error Message : ' || l_error_message);
640: bis_collection_utilities.log('Phase : ' || g_phase);
641: g_errbuf := l_error_message;
642: g_retcode := 2;

Line 639: bis_collection_utilities.log('Error Message : ' || l_error_message);

635: EXCEPTION
636: WHEN OTHERS THEN
637: l_error_message := sqlerrm;
638: bis_collection_utilities.log('Error while doing incremental population of partner classification table ');
639: bis_collection_utilities.log('Error Message : ' || l_error_message);
640: bis_collection_utilities.log('Phase : ' || g_phase);
641: g_errbuf := l_error_message;
642: g_retcode := 2;
643: END incremental_load;

Line 640: bis_collection_utilities.log('Phase : ' || g_phase);

636: WHEN OTHERS THEN
637: l_error_message := sqlerrm;
638: bis_collection_utilities.log('Error while doing incremental population of partner classification table ');
639: bis_collection_utilities.log('Error Message : ' || l_error_message);
640: bis_collection_utilities.log('Phase : ' || g_phase);
641: g_errbuf := l_error_message;
642: g_retcode := 2;
643: END incremental_load;
644:

Line 684: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

680: IF l_class_category <> nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1) THEN
681: return 'INIT';
682: ELSE
683: -- If the last run was unsuccessfull run initial else incremental
684: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
685: p_object_name => 'FII_PARTY_MKT_CLASS',
686: p_start_date => l_period_from,
687: p_end_date => l_period_to,
688: p_period_from => g_last_collection_from_date,