DBA Data[Home] [Help]

APPS.OKI_LOAD_ENR_PVT dependencies on FND_MESSAGE

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

159:
160: -- Set return code to error
161: x_retcode := '2';
162:
163: fnd_message.set_name( application => 'OKI'
164: , name => 'OKI_TABLE_LOAD_FAILURE');
165:
166: fnd_message.set_token( token => 'TABLE_NAME'
167: , value => 'OKI_EXP_NOT_RENEWED');

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

162:
163: fnd_message.set_name( application => 'OKI'
164: , name => 'OKI_TABLE_LOAD_FAILURE');
165:
166: fnd_message.set_token( token => 'TABLE_NAME'
167: , value => 'OKI_EXP_NOT_RENEWED');
168:
169: fnd_file.put_line( which => fnd_file.log
170: , buff => fnd_message.get);

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

166: fnd_message.set_token( token => 'TABLE_NAME'
167: , value => 'OKI_EXP_NOT_RENEWED');
168:
169: fnd_file.put_line( which => fnd_file.log
170: , buff => fnd_message.get);
171:
172: fnd_file.put_line( which => fnd_file.log
173: , buff => l_sqlcode||' '||l_sqlerrm );
174: END ins_exp_not_rnw ;

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

212:
213: -- Set return code to error
214: x_retcode := '2';
215:
216: fnd_message.set_name( application => 'OKI'
217: , name => 'OKI_UNEXPECTED_FAILURE');
218:
219: fnd_message.set_token( token => 'OBJECT_NAME'
220: , value => 'OKI_LOAD_ENR_PVT.UPD_EXP_NOT_RNW');

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

215:
216: fnd_message.set_name( application => 'OKI'
217: , name => 'OKI_UNEXPECTED_FAILURE');
218:
219: fnd_message.set_token( token => 'OBJECT_NAME'
220: , value => 'OKI_LOAD_ENR_PVT.UPD_EXP_NOT_RNW');
221:
222: fnd_file.put_line( which => fnd_file.log
223: , buff => fnd_message.get);

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

219: fnd_message.set_token( token => 'OBJECT_NAME'
220: , value => 'OKI_LOAD_ENR_PVT.UPD_EXP_NOT_RNW');
221:
222: fnd_file.put_line( which => fnd_file.log
223: , buff => fnd_message.get);
224:
225: fnd_file.put_line( which => fnd_file.log
226: , buff => l_sqlcode||' '||l_sqlerrm );
227: END upd_exp_not_rnw ;

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

418:
419: -- Set return code TO error
420: x_retcode := '2' ;
421:
422: fnd_message.set_name( application => 'OKI'
423: , name => 'OKI_UNEXPECTED_FAILURE');
424:
425: fnd_message.set_token( token => 'OBJECT_NAME'
426: , value => 'OKI_LOAD_ENR_PVT.calc_enr_dtl1');

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

421:
422: fnd_message.set_name( application => 'OKI'
423: , name => 'OKI_UNEXPECTED_FAILURE');
424:
425: fnd_message.set_token( token => 'OBJECT_NAME'
426: , value => 'OKI_LOAD_ENR_PVT.calc_enr_dtl1');
427:
428: fnd_file.put_line( which => fnd_file.log
429: , buff => fnd_message.get);

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

425: fnd_message.set_token( token => 'OBJECT_NAME'
426: , value => 'OKI_LOAD_ENR_PVT.calc_enr_dtl1');
427:
428: fnd_file.put_line( which => fnd_file.log
429: , buff => fnd_message.get);
430:
431: -- Log the location within the procedure where the error occurred
432: fnd_message.set_name( application => 'OKI'
433: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

428: fnd_file.put_line( which => fnd_file.log
429: , buff => fnd_message.get);
430:
431: -- Log the location within the procedure where the error occurred
432: fnd_message.set_name( application => 'OKI'
433: , name => 'OKI_LOC_IN_PROG_FAILURE');
434:
435: fnd_message.set_token( token => 'LOCATION'
436: , value => l_loc);

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

431: -- Log the location within the procedure where the error occurred
432: fnd_message.set_name( application => 'OKI'
433: , name => 'OKI_LOC_IN_PROG_FAILURE');
434:
435: fnd_message.set_token( token => 'LOCATION'
436: , value => l_loc);
437:
438: fnd_file.put_line( which => fnd_file.log
439: , buff => fnd_message.get);

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

435: fnd_message.set_token( token => 'LOCATION'
436: , value => l_loc);
437:
438: fnd_file.put_line( which => fnd_file.log
439: , buff => fnd_message.get);
440:
441: fnd_file.put_line( which => fnd_file.log
442: , buff => l_sqlcode||' '||l_sqlerrm );
443:

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

630:
631: -- Set return code TO error
632: x_retcode := '2' ;
633:
634: fnd_message.set_name( application => 'OKI'
635: , name => 'OKI_UNEXPECTED_FAILURE');
636:
637: fnd_message.set_token( token => 'OBJECT_NAME'
638: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_DTL2');

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

633:
634: fnd_message.set_name( application => 'OKI'
635: , name => 'OKI_UNEXPECTED_FAILURE');
636:
637: fnd_message.set_token( token => 'OBJECT_NAME'
638: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_DTL2');
639:
640: fnd_file.put_line( which => fnd_file.log
641: , buff => fnd_message.get);

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

637: fnd_message.set_token( token => 'OBJECT_NAME'
638: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_DTL2');
639:
640: fnd_file.put_line( which => fnd_file.log
641: , buff => fnd_message.get);
642:
643: -- Log the location within the procedure where the error occurred
644: fnd_message.set_name( application => 'OKI'
645: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

640: fnd_file.put_line( which => fnd_file.log
641: , buff => fnd_message.get);
642:
643: -- Log the location within the procedure where the error occurred
644: fnd_message.set_name( application => 'OKI'
645: , name => 'OKI_LOC_IN_PROG_FAILURE');
646:
647: fnd_message.set_token( token => 'LOCATION'
648: , value => l_loc);

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

643: -- Log the location within the procedure where the error occurred
644: fnd_message.set_name( application => 'OKI'
645: , name => 'OKI_LOC_IN_PROG_FAILURE');
646:
647: fnd_message.set_token( token => 'LOCATION'
648: , value => l_loc);
649:
650: fnd_file.put_line( which => fnd_file.log
651: , buff => fnd_message.get);

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

647: fnd_message.set_token( token => 'LOCATION'
648: , value => l_loc);
649:
650: fnd_file.put_line( which => fnd_file.log
651: , buff => fnd_message.get);
652:
653: fnd_file.put_line( which => fnd_file.log
654: , buff => l_sqlcode||' '||l_sqlerrm );
655:

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

833:
834: -- Set return code TO error
835: x_retcode := '2' ;
836:
837: fnd_message.set_name( application => 'OKI'
838: , name => 'OKI_UNEXPECTED_FAILURE');
839:
840: fnd_message.set_token( token => 'OBJECT_NAME'
841: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_SUM');

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

836:
837: fnd_message.set_name( application => 'OKI'
838: , name => 'OKI_UNEXPECTED_FAILURE');
839:
840: fnd_message.set_token( token => 'OBJECT_NAME'
841: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_SUM');
842:
843: fnd_file.put_line( which => fnd_file.log
844: , buff => fnd_message.get);

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

840: fnd_message.set_token( token => 'OBJECT_NAME'
841: , value => 'OKI_LOAD_ENR_PVT.CALC_ENR_SUM');
842:
843: fnd_file.put_line( which => fnd_file.log
844: , buff => fnd_message.get);
845:
846: -- Log the location within the procedure where the error occurred
847: fnd_message.set_name( application => 'OKI'
848: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

843: fnd_file.put_line( which => fnd_file.log
844: , buff => fnd_message.get);
845:
846: -- Log the location within the procedure where the error occurred
847: fnd_message.set_name( application => 'OKI'
848: , name => 'OKI_LOC_IN_PROG_FAILURE');
849:
850: fnd_message.set_token( token => 'LOCATION'
851: , value => l_loc);

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

846: -- Log the location within the procedure where the error occurred
847: fnd_message.set_name( application => 'OKI'
848: , name => 'OKI_LOC_IN_PROG_FAILURE');
849:
850: fnd_message.set_token( token => 'LOCATION'
851: , value => l_loc);
852:
853: fnd_file.put_line( which => fnd_file.log
854: , buff => fnd_message.get);

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

850: fnd_message.set_token( token => 'LOCATION'
851: , value => l_loc);
852:
853: fnd_file.put_line( which => fnd_file.log
854: , buff => fnd_message.get);
855:
856: fnd_file.put_line( which => fnd_file.log
857: , buff => l_sqlcode||' '||l_sqlerrm );
858: END calc_enr_sum;

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

944: SAVEPOINT oki_load_enr_pvt_upd_refresh ;
945:
946: -- Table loaded successfully. Log message in concurrent manager
947: -- log indicating successful load.
948: fnd_message.set_name( application => 'OKI'
949: , name => 'OKI_TABLE_LOAD_SUCCESS');
950:
951: fnd_message.set_token( token => 'TABLE_NAME'
952: , value => l_table_name );

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

947: -- log indicating successful load.
948: fnd_message.set_name( application => 'OKI'
949: , name => 'OKI_TABLE_LOAD_SUCCESS');
950:
951: fnd_message.set_token( token => 'TABLE_NAME'
952: , value => l_table_name );
953:
954: fnd_file.put_line( which => fnd_file.log
955: , buff => fnd_message.get);

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

951: fnd_message.set_token( token => 'TABLE_NAME'
952: , value => l_table_name );
953:
954: fnd_file.put_line( which => fnd_file.log
955: , buff => fnd_message.get);
956:
957: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
958:
959: IF l_retcode in ('1', '2') THEN

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

990: -- rollback all transactions
991: ROLLBACK to oki_load_enr_pvt_crt_exp_unrnw ;
992:
993:
994: fnd_message.set_name( application => 'OKI'
995: , name => 'OKI_UNEXPECTED_FAILURE');
996:
997: fnd_message.set_token( token => 'OBJECT_NAME'
998: , value => 'OKI_LOAD_ENR_PVT.CRT_EXP_NOT_RNW');

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

993:
994: fnd_message.set_name( application => 'OKI'
995: , name => 'OKI_UNEXPECTED_FAILURE');
996:
997: fnd_message.set_token( token => 'OBJECT_NAME'
998: , value => 'OKI_LOAD_ENR_PVT.CRT_EXP_NOT_RNW');
999:
1000: fnd_file.put_line( which => fnd_file.log
1001: , buff => fnd_message.get);

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

997: fnd_message.set_token( token => 'OBJECT_NAME'
998: , value => 'OKI_LOAD_ENR_PVT.CRT_EXP_NOT_RNW');
999:
1000: fnd_file.put_line( which => fnd_file.log
1001: , buff => fnd_message.get);
1002:
1003: fnd_file.put_line( which => fnd_file.log
1004: , buff => l_sqlcode||' '||l_sqlerrm );
1005: