DBA Data[Home] [Help]

APPS.OKI_LOAD_WBC_PVT dependencies on FND_MESSAGE

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

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' );

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

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

Line 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:

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

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' );

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

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

Line 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 ;

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

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');

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

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

Line 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 ;

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

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');

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

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

Line 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');

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

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

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

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

Line 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:

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

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');

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

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

Line 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');

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

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

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

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

Line 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:

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

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');

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

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

Line 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');

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

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

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

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

Line 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:

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

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

Line 1114: fnd_message.set_token( token => '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);

Line 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

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

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');

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

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

Line 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: