157:
158: fnd_message.set_token( token => 'TABLE_NAME'
159: , value => 'OKI_RENEWAL_AGING');
160:
161: fnd_file.put_line( which => fnd_file.log
162: , buff => fnd_message.get);
163:
164: fnd_file.put_line( which => fnd_file.log
165: , buff => l_sqlcode||' '||l_sqlerrm );
160:
161: fnd_file.put_line( which => fnd_file.log
162: , buff => fnd_message.get);
163:
164: fnd_file.put_line( which => fnd_file.log
165: , buff => l_sqlcode||' '||l_sqlerrm );
166: END ins_rnwl_aging ;
167:
168: --------------------------------------------------------------------------------
213:
214: fnd_message.set_token( token => 'OBJECT_NAME'
215: , value => 'OKI_LOAD_RAG_PVT.OKI_UPD_RNWL_AGING' );
216:
217: fnd_file.put_line( which => fnd_file.log
218: , buff => fnd_message.get);
219:
220: fnd_file.put_line( which => fnd_file.log
221: , buff => l_sqlcode||' '||l_sqlerrm );
216:
217: fnd_file.put_line( which => fnd_file.log
218: , buff => fnd_message.get);
219:
220: fnd_file.put_line( which => fnd_file.log
221: , buff => l_sqlcode||' '||l_sqlerrm );
222: END upd_rnwl_aging ;
223:
224: --------------------------------------------------------------------------------
289:
290: fnd_message.set_token( token => 'OBJECT_NAME'
291: , value => 'OKI_LOAD_RAG_PVT.CALC_AGE_GROUP');
292:
293: fnd_file.put_line( which => fnd_file.log
294: , buff => fnd_message.get);
295:
296: fnd_file.put_line( which => fnd_file.log
297: , buff => l_sqlcode||' '||l_sqlerrm );
292:
293: fnd_file.put_line( which => fnd_file.log
294: , buff => fnd_message.get);
295:
296: fnd_file.put_line( which => fnd_file.log
297: , buff => l_sqlcode||' '||l_sqlerrm );
298: END calc_age_group ;
299:
300: --------------------------------------------------------------------------------
545:
546: fnd_message.set_token( token => 'OBJECT_NAME'
547: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_DTL1');
548:
549: fnd_file.put_line( which => fnd_file.log
550: , buff => fnd_message.get);
551:
552: -- Log the location within the procedure where the error occurred
553: fnd_message.set_name( application => 'OKI'
555:
556: fnd_message.set_token( token => 'LOCATION'
557: , value => l_loc);
558:
559: fnd_file.put_line( which => fnd_file.log
560: , buff => fnd_message.get);
561:
562: fnd_file.put_line( which => fnd_file.log
563: , buff => l_sqlcode||' '||l_sqlerrm );
558:
559: fnd_file.put_line( which => fnd_file.log
560: , buff => fnd_message.get);
561:
562: fnd_file.put_line( which => fnd_file.log
563: , buff => l_sqlcode||' '||l_sqlerrm );
564:
565: END calc_rag_dtl1 ;
566:
794:
795: fnd_message.set_token( token => 'OBJECT_NAME'
796: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_DTL2');
797:
798: fnd_file.put_line( which => fnd_file.log
799: , buff => fnd_message.get);
800:
801: -- Log the location within the procedure where the error occurred
802: fnd_message.set_name( application => 'OKI'
804:
805: fnd_message.set_token( token => 'LOCATION'
806: , value => l_loc);
807:
808: fnd_file.put_line( which => fnd_file.log
809: , buff => fnd_message.get);
810:
811: fnd_file.put_line( which => fnd_file.log
812: , buff => l_sqlcode||' '||l_sqlerrm );
807:
808: fnd_file.put_line( which => fnd_file.log
809: , buff => fnd_message.get);
810:
811: fnd_file.put_line( which => fnd_file.log
812: , buff => l_sqlcode||' '||l_sqlerrm );
813:
814: END calc_rag_dtl2 ;
815:
1038:
1039: fnd_message.set_token( token => 'OBJECT_NAME'
1040: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_SUM');
1041:
1042: fnd_file.put_line( which => fnd_file.log
1043: , buff => fnd_message.get);
1044:
1045: -- Log the location within the procedure where the error occurred
1046: fnd_message.set_name( application => 'OKI'
1048:
1049: fnd_message.set_token( token => 'LOCATION'
1050: , value => l_loc);
1051:
1052: fnd_file.put_line( which => fnd_file.log
1053: , buff => fnd_message.get);
1054:
1055: fnd_file.put_line( which => fnd_file.log
1056: , buff => l_sqlcode||' '||l_sqlerrm );
1051:
1052: fnd_file.put_line( which => fnd_file.log
1053: , buff => fnd_message.get);
1054:
1055: fnd_file.put_line( which => fnd_file.log
1056: , buff => l_sqlcode||' '||l_sqlerrm );
1057: END calc_rag_sum ;
1058:
1059: --------------------------------------------------------------------------------
1151:
1152: fnd_message.set_token( token => 'TABLE_NAME'
1153: , value => l_table_name );
1154:
1155: fnd_file.put_line( which => fnd_file.log
1156: , buff => fnd_message.get);
1157:
1158: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
1159:
1196:
1197: fnd_message.set_token( token => 'OBJECT_NAME'
1198: , value => 'OKI_LOAD_RAG_PVT.CRT_RNWL_AGE_BY_ORGS');
1199:
1200: fnd_file.put_line( which => fnd_file.log
1201: , buff => fnd_message.get);
1202:
1203: fnd_file.put_line( which => fnd_file.log
1204: , buff => l_sqlcode||' '||l_sqlerrm );
1199:
1200: fnd_file.put_line( which => fnd_file.log
1201: , buff => fnd_message.get);
1202:
1203: fnd_file.put_line( which => fnd_file.log
1204: , buff => l_sqlcode||' '||l_sqlerrm );
1205: END crt_rnwl_aging ;
1206:
1207: BEGIN