DBA Data[Home] [Help]

APPS.OKI_LOAD_RAG_PVT dependencies on FND_MESSAGE

Line 155: fnd_message.set_name( application => 'OKI'

151:
152: -- Set return code TO error
153: x_retcode := '2';
154:
155: fnd_message.set_name( application => 'OKI'
156: , name => 'OKI_TABLE_LOAD_FAILURE');
157:
158: fnd_message.set_token( token => 'TABLE_NAME'
159: , value => 'OKI_RENEWAL_AGING');

Line 158: fnd_message.set_token( token => 'TABLE_NAME'

154:
155: fnd_message.set_name( application => 'OKI'
156: , name => 'OKI_TABLE_LOAD_FAILURE');
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);

Line 162: , buff => fnd_message.get);

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 );
166: END ins_rnwl_aging ;

Line 211: fnd_message.set_name( application => 'OKI'

207:
208: -- Set return code to error
209: x_retcode := '2';
210:
211: fnd_message.set_name( application => 'OKI'
212: , name => 'OKI_UNEXPECTED_FAILURE' );
213:
214: fnd_message.set_token( token => 'OBJECT_NAME'
215: , value => 'OKI_LOAD_RAG_PVT.OKI_UPD_RNWL_AGING' );

Line 214: fnd_message.set_token( token => 'OBJECT_NAME'

210:
211: fnd_message.set_name( application => 'OKI'
212: , name => 'OKI_UNEXPECTED_FAILURE' );
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);

Line 218: , buff => fnd_message.get);

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 );
222: END upd_rnwl_aging ;

Line 287: fnd_message.set_name( application => 'OKI'

283: -- Set return code to error
284: x_retcode := '2' ;
285:
286:
287: fnd_message.set_name( application => 'OKI'
288: , name => 'OKI_UNEXPECTED_FAILURE');
289:
290: fnd_message.set_token( token => 'OBJECT_NAME'
291: , value => 'OKI_LOAD_RAG_PVT.CALC_AGE_GROUP');

Line 290: fnd_message.set_token( token => 'OBJECT_NAME'

286:
287: fnd_message.set_name( application => 'OKI'
288: , name => 'OKI_UNEXPECTED_FAILURE');
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);

Line 294: , buff => fnd_message.get);

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 );
298: END calc_age_group ;

Line 543: fnd_message.set_name( application => 'OKI'

539:
540: -- Set return code TO error
541: x_retcode := '2' ;
542:
543: fnd_message.set_name( application => 'OKI'
544: , name => 'OKI_UNEXPECTED_FAILURE');
545:
546: fnd_message.set_token( token => 'OBJECT_NAME'
547: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_DTL1');

Line 546: fnd_message.set_token( token => 'OBJECT_NAME'

542:
543: fnd_message.set_name( application => 'OKI'
544: , name => 'OKI_UNEXPECTED_FAILURE');
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);

Line 550: , buff => fnd_message.get);

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'
554: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 553: fnd_message.set_name( application => 'OKI'

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'
554: , name => 'OKI_LOC_IN_PROG_FAILURE');
555:
556: fnd_message.set_token( token => 'LOCATION'
557: , value => l_loc);

Line 556: fnd_message.set_token( token => 'LOCATION'

552: -- Log the location within the procedure where the error occurred
553: fnd_message.set_name( application => 'OKI'
554: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

Line 560: , buff => fnd_message.get);

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 );
564:

Line 792: fnd_message.set_name( application => 'OKI'

788:
789: -- Set return code TO error
790: x_retcode := '2' ;
791:
792: fnd_message.set_name( application => 'OKI'
793: , name => 'OKI_UNEXPECTED_FAILURE');
794:
795: fnd_message.set_token( token => 'OBJECT_NAME'
796: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_DTL2');

Line 795: fnd_message.set_token( token => 'OBJECT_NAME'

791:
792: fnd_message.set_name( application => 'OKI'
793: , name => 'OKI_UNEXPECTED_FAILURE');
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);

Line 799: , buff => fnd_message.get);

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'
803: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 802: fnd_message.set_name( application => 'OKI'

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'
803: , name => 'OKI_LOC_IN_PROG_FAILURE');
804:
805: fnd_message.set_token( token => 'LOCATION'
806: , value => l_loc);

Line 805: fnd_message.set_token( token => 'LOCATION'

801: -- Log the location within the procedure where the error occurred
802: fnd_message.set_name( application => 'OKI'
803: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

Line 809: , buff => fnd_message.get);

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 );
813:

Line 1036: fnd_message.set_name( application => 'OKI'

1032:
1033: -- Set return code TO error
1034: x_retcode := '2' ;
1035:
1036: fnd_message.set_name( application => 'OKI'
1037: , name => 'OKI_UNEXPECTED_FAILURE');
1038:
1039: fnd_message.set_token( token => 'OBJECT_NAME'
1040: , value => 'OKI_LOAD_rag_PVT.CALC_RAG_SUM');

Line 1039: fnd_message.set_token( token => 'OBJECT_NAME'

1035:
1036: fnd_message.set_name( application => 'OKI'
1037: , name => 'OKI_UNEXPECTED_FAILURE');
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);

Line 1043: , buff => fnd_message.get);

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'
1047: , name => 'OKI_LOC_IN_PROG_FAILURE');

Line 1046: fnd_message.set_name( application => 'OKI'

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'
1047: , name => 'OKI_LOC_IN_PROG_FAILURE');
1048:
1049: fnd_message.set_token( token => 'LOCATION'
1050: , value => l_loc);

Line 1049: fnd_message.set_token( token => 'LOCATION'

1045: -- Log the location within the procedure where the error occurred
1046: fnd_message.set_name( application => 'OKI'
1047: , name => 'OKI_LOC_IN_PROG_FAILURE');
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);

Line 1053: , buff => fnd_message.get);

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 );
1057: END calc_rag_sum ;

Line 1149: fnd_message.set_name( application => 'OKI'

1145: SAVEPOINT oki_load_rag_pvt_upd_refresh ;
1146:
1147: -- Table loaded successfully. Log message IN concurrent manager
1148: -- log indicating successful load.
1149: fnd_message.set_name( application => 'OKI'
1150: , name => 'OKI_TABLE_LOAD_SUCCESS');
1151:
1152: fnd_message.set_token( token => 'TABLE_NAME'
1153: , value => l_table_name );

Line 1152: fnd_message.set_token( token => 'TABLE_NAME'

1148: -- log indicating successful load.
1149: fnd_message.set_name( application => 'OKI'
1150: , name => 'OKI_TABLE_LOAD_SUCCESS');
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);

Line 1156: , buff => fnd_message.get);

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:
1160: IF l_retcode in ('1', '2') THEN

Line 1194: fnd_message.set_name( application => 'OKI'

1190: -- Rollback all transactions
1191: ROLLBACK TO oki_load_rag_pvt_crt_rnwl_age ;
1192:
1193:
1194: fnd_message.set_name( application => 'OKI'
1195: , name => 'OKI_UNEXPECTED_FAILURE');
1196:
1197: fnd_message.set_token( token => 'OBJECT_NAME'
1198: , value => 'OKI_LOAD_RAG_PVT.CRT_RNWL_AGE_BY_ORGS');

Line 1197: fnd_message.set_token( token => 'OBJECT_NAME'

1193:
1194: fnd_message.set_name( application => 'OKI'
1195: , name => 'OKI_UNEXPECTED_FAILURE');
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);

Line 1201: , buff => fnd_message.get);

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 );
1205: END crt_rnwl_aging ;