51: IF request_type = 'PRE-EXPORT' THEN
52: IF l_num_rec <> 0 THEN
53: -- dbms_output.put_line(rt_c_get_enab_sectab.table_name||' Inside Condition');
54: -- Call procedure to create additional column in to core tables
55: igi_sls_objects_pkg.create_sls_col
56: (sec_tab => rt_c_get_enab_sectab.table_name,
57: schema_name => rt_c_get_enab_sectab.owner,
58: errbuf => errbuf,
59: retcode => retcode);
88:
89: END IF;
90: -- Drop column in core tables
91:
92: igi_sls_objects_pkg.drop_sls_col (sec_tab => rt_c_get_enab_sectab.table_name,
93: schema_name => rt_c_get_enab_sectab.owner,
94: errbuf => errbuf,
95: retcode => retcode);
96:
115: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
116: l_excep_level :=1;
117: retcode := 2;
118: errbuf := Fnd_message.get;
119: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_col','END igi_sls_objects_pkg.create_sls_col - failed with error ' || SQLERRM );
120: -- dbms_output.put_line(SQLERRM);
121: RETURN;
122:
123: END create_sls_datafix;