149:
150: -- Set return code to error
151: x_retcode := '2';
152:
153: fnd_message.set_name( application => 'OKI'
154: , name => 'OKI_TABLE_LOAD_FAILURE');
155:
156: fnd_message.set_token( token => 'TABLE_NAME'
157: , value => 'OKI_WIP_BY_CUSTOMERS' );
152:
153: fnd_message.set_name( application => 'OKI'
154: , name => 'OKI_TABLE_LOAD_FAILURE');
155:
156: fnd_message.set_token( token => 'TABLE_NAME'
157: , value => 'OKI_WIP_BY_CUSTOMERS' );
158:
159: fnd_file.put_line( which => fnd_file.log
160: , buff => fnd_message.get);
156: fnd_message.set_token( token => 'TABLE_NAME'
157: , value => 'OKI_WIP_BY_CUSTOMERS' );
158:
159: fnd_file.put_line( which => fnd_file.log
160: , buff => fnd_message.get);
161:
162: fnd_file.put_line( which => fnd_file.log
163: , buff => l_sqlcode||' '||l_sqlerrm );
164:
168:
169: -- Set return code to error
170: x_retcode := '2';
171:
172: fnd_message.set_name( application => 'OKI'
173: , name => 'OKI_TABLE_LOAD_FAILURE');
174:
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_WIP_BY_CUSTOMERS' );
171:
172: fnd_message.set_name( application => 'OKI'
173: , name => 'OKI_TABLE_LOAD_FAILURE');
174:
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_WIP_BY_CUSTOMERS' );
177:
178: fnd_file.put_line( which => fnd_file.log
179: , buff => fnd_message.get);
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_WIP_BY_CUSTOMERS' );
177:
178: fnd_file.put_line( which => fnd_file.log
179: , buff => fnd_message.get);
180:
181: fnd_file.put_line( which => fnd_file.log
182: , buff => l_sqlcode||' '||l_sqlerrm );
183: END ins_wip_by_cust ;
223:
224: -- Set return code to error
225: x_retcode := '2';
226:
227: fnd_message.set_name( application => 'OKI'
228: , name => 'OKI_UNEXPECTED_FAILURE');
229:
230: fnd_message.set_token( token => 'OBJECT_NAME'
231: , value => 'OKI_LOAD_WBC_PVT.UPD_WIP_BY_CUST');
226:
227: fnd_message.set_name( application => 'OKI'
228: , name => 'OKI_UNEXPECTED_FAILURE');
229:
230: fnd_message.set_token( token => 'OBJECT_NAME'
231: , value => 'OKI_LOAD_WBC_PVT.UPD_WIP_BY_CUST');
232:
233: fnd_file.put_line( which => fnd_file.log
234: , buff => fnd_message.get);
230: fnd_message.set_token( token => 'OBJECT_NAME'
231: , value => 'OKI_LOAD_WBC_PVT.UPD_WIP_BY_CUST');
232:
233: fnd_file.put_line( which => fnd_file.log
234: , buff => fnd_message.get);
235:
236: fnd_file.put_line( which => fnd_file.log
237: , buff => l_sqlcode||' '||l_sqlerrm );
238: END upd_wip_by_cust ;
484:
485: -- Set return code TO error
486: x_retcode := '2' ;
487:
488: fnd_message.set_name( application => 'OKI'
489: , name => 'OKI_UNEXPECTED_FAILURE');
490:
491: fnd_message.set_token( token => 'OBJECT_NAME'
492: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL1');
487:
488: fnd_message.set_name( application => 'OKI'
489: , name => 'OKI_UNEXPECTED_FAILURE');
490:
491: fnd_message.set_token( token => 'OBJECT_NAME'
492: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL1');
493:
494: fnd_file.put_line( which => fnd_file.log
495: , buff => fnd_message.get);
491: fnd_message.set_token( token => 'OBJECT_NAME'
492: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL1');
493:
494: fnd_file.put_line( which => fnd_file.log
495: , buff => fnd_message.get);
496:
497: -- Log the location within the procedure where the error occurred
498: fnd_message.set_name( application => 'OKI'
499: , name => 'OKI_LOC_IN_PROG_FAILURE');
494: fnd_file.put_line( which => fnd_file.log
495: , buff => fnd_message.get);
496:
497: -- Log the location within the procedure where the error occurred
498: fnd_message.set_name( application => 'OKI'
499: , name => 'OKI_LOC_IN_PROG_FAILURE');
500:
501: fnd_message.set_token( token => 'LOCATION'
502: , value => l_loc);
497: -- Log the location within the procedure where the error occurred
498: fnd_message.set_name( application => 'OKI'
499: , name => 'OKI_LOC_IN_PROG_FAILURE');
500:
501: fnd_message.set_token( token => 'LOCATION'
502: , value => l_loc);
503:
504: fnd_file.put_line( which => fnd_file.log
505: , buff => fnd_message.get);
501: fnd_message.set_token( token => 'LOCATION'
502: , value => l_loc);
503:
504: fnd_file.put_line( which => fnd_file.log
505: , buff => fnd_message.get);
506:
507: fnd_file.put_line( which => fnd_file.log
508: , buff => l_sqlcode||' '||l_sqlerrm );
509:
745:
746: -- Set return code TO error
747: x_retcode := '2' ;
748:
749: fnd_message.set_name( application => 'OKI'
750: , name => 'OKI_UNEXPECTED_FAILURE');
751:
752: fnd_message.set_token( token => 'OBJECT_NAME'
753: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL2');
748:
749: fnd_message.set_name( application => 'OKI'
750: , name => 'OKI_UNEXPECTED_FAILURE');
751:
752: fnd_message.set_token( token => 'OBJECT_NAME'
753: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL2');
754:
755: fnd_file.put_line( which => fnd_file.log
756: , buff => fnd_message.get);
752: fnd_message.set_token( token => 'OBJECT_NAME'
753: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_DTL2');
754:
755: fnd_file.put_line( which => fnd_file.log
756: , buff => fnd_message.get);
757:
758: -- Log the location within the procedure where the error occurred
759: fnd_message.set_name( application => 'OKI'
760: , name => 'OKI_LOC_IN_PROG_FAILURE');
755: fnd_file.put_line( which => fnd_file.log
756: , buff => fnd_message.get);
757:
758: -- Log the location within the procedure where the error occurred
759: fnd_message.set_name( application => 'OKI'
760: , name => 'OKI_LOC_IN_PROG_FAILURE');
761:
762: fnd_message.set_token( token => 'LOCATION'
763: , value => l_loc);
758: -- Log the location within the procedure where the error occurred
759: fnd_message.set_name( application => 'OKI'
760: , name => 'OKI_LOC_IN_PROG_FAILURE');
761:
762: fnd_message.set_token( token => 'LOCATION'
763: , value => l_loc);
764:
765: fnd_file.put_line( which => fnd_file.log
766: , buff => fnd_message.get);
762: fnd_message.set_token( token => 'LOCATION'
763: , value => l_loc);
764:
765: fnd_file.put_line( which => fnd_file.log
766: , buff => fnd_message.get);
767:
768: fnd_file.put_line( which => fnd_file.log
769: , buff => l_sqlcode||' '||l_sqlerrm );
770:
995:
996: -- Set return code TO error
997: x_retcode := '2' ;
998:
999: fnd_message.set_name( application => 'OKI'
1000: , name => 'OKI_UNEXPECTED_FAILURE');
1001:
1002: fnd_message.set_token( token => 'OBJECT_NAME'
1003: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_SUM');
998:
999: fnd_message.set_name( application => 'OKI'
1000: , name => 'OKI_UNEXPECTED_FAILURE');
1001:
1002: fnd_message.set_token( token => 'OBJECT_NAME'
1003: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_SUM');
1004:
1005: fnd_file.put_line( which => fnd_file.log
1006: , buff => fnd_message.get);
1002: fnd_message.set_token( token => 'OBJECT_NAME'
1003: , value => 'OKI_LOAD_WBC_PVT.CALC_WBC_SUM');
1004:
1005: fnd_file.put_line( which => fnd_file.log
1006: , buff => fnd_message.get);
1007:
1008: -- Log the location within the procedure where the error occurred
1009: fnd_message.set_name( application => 'OKI'
1010: , name => 'OKI_LOC_IN_PROG_FAILURE');
1005: fnd_file.put_line( which => fnd_file.log
1006: , buff => fnd_message.get);
1007:
1008: -- Log the location within the procedure where the error occurred
1009: fnd_message.set_name( application => 'OKI'
1010: , name => 'OKI_LOC_IN_PROG_FAILURE');
1011:
1012: fnd_message.set_token( token => 'LOCATION'
1013: , value => l_loc);
1008: -- Log the location within the procedure where the error occurred
1009: fnd_message.set_name( application => 'OKI'
1010: , name => 'OKI_LOC_IN_PROG_FAILURE');
1011:
1012: fnd_message.set_token( token => 'LOCATION'
1013: , value => l_loc);
1014:
1015: fnd_file.put_line( which => fnd_file.log
1016: , buff => fnd_message.get);
1012: fnd_message.set_token( token => 'LOCATION'
1013: , value => l_loc);
1014:
1015: fnd_file.put_line( which => fnd_file.log
1016: , buff => fnd_message.get);
1017:
1018: fnd_file.put_line( which => fnd_file.log
1019: , buff => l_sqlcode||' '||l_sqlerrm );
1020:
1107: SAVEPOINT oki_load_wbc_pvt_upd_refresh ;
1108:
1109: -- Table loaded successfully. Log message in concurrent manager
1110: -- log indicating successful load.
1111: fnd_message.set_name( application => 'OKI'
1112: , name => 'OKI_TABLE_LOAD_SUCCESS');
1113:
1114: fnd_message.set_token( token => 'TABLE_NAME'
1115: , value => l_table_name );
1110: -- log indicating successful load.
1111: fnd_message.set_name( application => 'OKI'
1112: , name => 'OKI_TABLE_LOAD_SUCCESS');
1113:
1114: fnd_message.set_token( token => 'TABLE_NAME'
1115: , value => l_table_name );
1116:
1117: fnd_file.put_line( which => fnd_file.log
1118: , buff => fnd_message.get);
1114: fnd_message.set_token( token => 'TABLE_NAME'
1115: , value => l_table_name );
1116:
1117: fnd_file.put_line( which => fnd_file.log
1118: , buff => fnd_message.get);
1119:
1120: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
1121:
1122: IF l_retcode in ('1', '2') THEN
1152: -- rollback all transactions
1153: ROLLBACK to oki_load_wbc_pvt_crt_wip_cust ;
1154:
1155:
1156: fnd_message.set_name( application => 'OKI'
1157: , name => 'OKI_UNEXPECTED_FAILURE');
1158:
1159: fnd_message.set_token( token => 'OBJECT_NAME'
1160: , value => 'OKI_LOAD_WBC_PVT.CRT_WIP_BY_CUST');
1155:
1156: fnd_message.set_name( application => 'OKI'
1157: , name => 'OKI_UNEXPECTED_FAILURE');
1158:
1159: fnd_message.set_token( token => 'OBJECT_NAME'
1160: , value => 'OKI_LOAD_WBC_PVT.CRT_WIP_BY_CUST');
1161:
1162: fnd_file.put_line( which => fnd_file.log
1163: , buff => fnd_message.get);
1159: fnd_message.set_token( token => 'OBJECT_NAME'
1160: , value => 'OKI_LOAD_WBC_PVT.CRT_WIP_BY_CUST');
1161:
1162: fnd_file.put_line( which => fnd_file.log
1163: , buff => fnd_message.get);
1164:
1165: fnd_file.put_line( which => fnd_file.log
1166: , buff => l_sqlcode||' '||l_sqlerrm );
1167: