eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_LOAD_SGR_PVT dependencies on FND_MESSAGE

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

305:
306: -- Set return code TO error
307: x_retcode := '2';
308:
309: fnd_message.set_name( application => 'OKI'
310: , name => 'OKI_TABLE_LOAD_FAILURE' );
311:
312: fnd_message.set_token( token => 'TABLE_NAME'
313: , value => 'OKI_SEQ_GROWTH_RATE' );

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

308:
309: fnd_message.set_name( application => 'OKI'
310: , name => 'OKI_TABLE_LOAD_FAILURE' );
311:
312: fnd_message.set_token( token => 'TABLE_NAME'
313: , value => 'OKI_SEQ_GROWTH_RATE' );
314:
315: fnd_file.put_line( which => fnd_file.log
316: , buff => fnd_message.get );

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

312: fnd_message.set_token( token => 'TABLE_NAME'
313: , value => 'OKI_SEQ_GROWTH_RATE' );
314:
315: fnd_file.put_line( which => fnd_file.log
316: , buff => fnd_message.get );
317:
318: fnd_file.put_line( which => fnd_file.log
319: , buff => l_sqlcode||' '|| l_sqlerrm );
320:

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

363:
364: -- Set return code to error
365: x_retcode := '2';
366:
367: fnd_message.set_name( application => 'OKI'
368: , name => 'OKI_UNEXPECTED_FAILURE' );
369:
370: fnd_message.set_token( token => 'OBJECT_NAME'
371: , value => 'OKI_LOAD_SGR_PVT.UPD_SEQ_GRW_RATE' );

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

366:
367: fnd_message.set_name( application => 'OKI'
368: , name => 'OKI_UNEXPECTED_FAILURE' );
369:
370: fnd_message.set_token( token => 'OBJECT_NAME'
371: , value => 'OKI_LOAD_SGR_PVT.UPD_SEQ_GRW_RATE' );
372:
373: fnd_file.put_line( which => fnd_file.log
374: , buff => fnd_message.get );

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

370: fnd_message.set_token( token => 'OBJECT_NAME'
371: , value => 'OKI_LOAD_SGR_PVT.UPD_SEQ_GRW_RATE' );
372:
373: fnd_file.put_line( which => fnd_file.log
374: , buff => fnd_message.get );
375:
376: fnd_file.put_line( which => fnd_file.log
377: , buff => l_sqlcode||' '|| l_sqlerrm );
378: END upd_seq_grw_rate ;

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

1436:
1437: -- Set return code TO error
1438: x_retcode := '2' ;
1439:
1440: fnd_message.set_name( application => 'OKI'
1441: , name => 'OKI_UNEXPECTED_FAILURE');
1442:
1443: fnd_message.set_token( token => 'OBJECT_NAME'
1444: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL1');

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

1439:
1440: fnd_message.set_name( application => 'OKI'
1441: , name => 'OKI_UNEXPECTED_FAILURE');
1442:
1443: fnd_message.set_token( token => 'OBJECT_NAME'
1444: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL1');
1445:
1446: fnd_file.put_line( which => fnd_file.log
1447: , buff => fnd_message.get);

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

1443: fnd_message.set_token( token => 'OBJECT_NAME'
1444: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL1');
1445:
1446: fnd_file.put_line( which => fnd_file.log
1447: , buff => fnd_message.get);
1448:
1449: -- Log the location within the procedure where the error occurred
1450: fnd_message.set_name( application => 'OKI'
1451: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

1446: fnd_file.put_line( which => fnd_file.log
1447: , buff => fnd_message.get);
1448:
1449: -- Log the location within the procedure where the error occurred
1450: fnd_message.set_name( application => 'OKI'
1451: , name => 'OKI_LOC_IN_PROG_FAILURE');
1452:
1453: fnd_message.set_token( token => 'LOCATION'
1454: , value => l_loc);

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

1449: -- Log the location within the procedure where the error occurred
1450: fnd_message.set_name( application => 'OKI'
1451: , name => 'OKI_LOC_IN_PROG_FAILURE');
1452:
1453: fnd_message.set_token( token => 'LOCATION'
1454: , value => l_loc);
1455:
1456: fnd_file.put_line( which => fnd_file.log
1457: , buff => fnd_message.get);

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

1453: fnd_message.set_token( token => 'LOCATION'
1454: , value => l_loc);
1455:
1456: fnd_file.put_line( which => fnd_file.log
1457: , buff => fnd_message.get);
1458:
1459: fnd_file.put_line( which => fnd_file.log
1460: , buff => l_sqlcode||' '||l_sqlerrm );
1461: END calc_sgr_dtl1 ;

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

2512:
2513: -- Set return code TO error
2514: x_retcode := '2' ;
2515:
2516: fnd_message.set_name( application => 'OKI'
2517: , name => 'OKI_UNEXPECTED_FAILURE');
2518:
2519: fnd_message.set_token( token => 'OBJECT_NAME'
2520: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL2');

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

2515:
2516: fnd_message.set_name( application => 'OKI'
2517: , name => 'OKI_UNEXPECTED_FAILURE');
2518:
2519: fnd_message.set_token( token => 'OBJECT_NAME'
2520: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL2');
2521:
2522: fnd_file.put_line( which => fnd_file.log
2523: , buff => fnd_message.get);

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

2519: fnd_message.set_token( token => 'OBJECT_NAME'
2520: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL2');
2521:
2522: fnd_file.put_line( which => fnd_file.log
2523: , buff => fnd_message.get);
2524:
2525: -- Log the location within the procedure where the error occurred
2526: fnd_message.set_name( application => 'OKI'
2527: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

2522: fnd_file.put_line( which => fnd_file.log
2523: , buff => fnd_message.get);
2524:
2525: -- Log the location within the procedure where the error occurred
2526: fnd_message.set_name( application => 'OKI'
2527: , name => 'OKI_LOC_IN_PROG_FAILURE');
2528:
2529: fnd_message.set_token( token => 'LOCATION'
2530: , value => l_loc);

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

2525: -- Log the location within the procedure where the error occurred
2526: fnd_message.set_name( application => 'OKI'
2527: , name => 'OKI_LOC_IN_PROG_FAILURE');
2528:
2529: fnd_message.set_token( token => 'LOCATION'
2530: , value => l_loc);
2531:
2532: fnd_file.put_line( which => fnd_file.log
2533: , buff => fnd_message.get);

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

2529: fnd_message.set_token( token => 'LOCATION'
2530: , value => l_loc);
2531:
2532: fnd_file.put_line( which => fnd_file.log
2533: , buff => fnd_message.get);
2534:
2535: fnd_file.put_line( which => fnd_file.log
2536: , buff => l_sqlcode||' '|| l_sqlerrm );
2537:

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

3462:
3463: -- Set return code TO error
3464: x_retcode := '2' ;
3465:
3466: fnd_message.set_name( application => 'OKI'
3467: , name => 'OKI_UNEXPECTED_FAILURE');
3468:
3469: fnd_message.set_token( token => 'OBJECT_NAME'
3470: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL3');

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

3465:
3466: fnd_message.set_name( application => 'OKI'
3467: , name => 'OKI_UNEXPECTED_FAILURE');
3468:
3469: fnd_message.set_token( token => 'OBJECT_NAME'
3470: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL3');
3471:
3472: fnd_file.put_line( which => fnd_file.log
3473: , buff => fnd_message.get);

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

3469: fnd_message.set_token( token => 'OBJECT_NAME'
3470: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_DTL3');
3471:
3472: fnd_file.put_line( which => fnd_file.log
3473: , buff => fnd_message.get);
3474:
3475: -- Log the location within the procedure where the error occurred
3476: fnd_message.set_name( application => 'OKI'
3477: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

3472: fnd_file.put_line( which => fnd_file.log
3473: , buff => fnd_message.get);
3474:
3475: -- Log the location within the procedure where the error occurred
3476: fnd_message.set_name( application => 'OKI'
3477: , name => 'OKI_LOC_IN_PROG_FAILURE');
3478:
3479: fnd_message.set_token( token => 'LOCATION'
3480: , value => l_loc);

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

3475: -- Log the location within the procedure where the error occurred
3476: fnd_message.set_name( application => 'OKI'
3477: , name => 'OKI_LOC_IN_PROG_FAILURE');
3478:
3479: fnd_message.set_token( token => 'LOCATION'
3480: , value => l_loc);
3481:
3482: fnd_file.put_line( which => fnd_file.log
3483: , buff => fnd_message.get);

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

3479: fnd_message.set_token( token => 'LOCATION'
3480: , value => l_loc);
3481:
3482: fnd_file.put_line( which => fnd_file.log
3483: , buff => fnd_message.get);
3484:
3485: fnd_file.put_line( which => fnd_file.log
3486: , buff => l_sqlcode||' '|| l_sqlerrm );
3487: END calc_sgr_dtl3 ;

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

4503:
4504: -- Set return code TO error
4505: x_retcode := '2' ;
4506:
4507: fnd_message.set_name( application => 'OKI'
4508: , name => 'OKI_UNEXPECTED_FAILURE');
4509:
4510: fnd_message.set_token( token => 'OBJECT_NAME'
4511: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_SUM');

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

4506:
4507: fnd_message.set_name( application => 'OKI'
4508: , name => 'OKI_UNEXPECTED_FAILURE');
4509:
4510: fnd_message.set_token( token => 'OBJECT_NAME'
4511: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_SUM');
4512:
4513: fnd_file.put_line( which => fnd_file.log
4514: , buff => fnd_message.get);

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

4510: fnd_message.set_token( token => 'OBJECT_NAME'
4511: , value => 'OKI_LOAD_SGR_PVT.CALC_SGR_SUM');
4512:
4513: fnd_file.put_line( which => fnd_file.log
4514: , buff => fnd_message.get);
4515:
4516: -- Log the location within the procedure where the error occurred
4517: fnd_message.set_name( application => 'OKI'
4518: , name => 'OKI_LOC_IN_PROG_FAILURE');

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

4513: fnd_file.put_line( which => fnd_file.log
4514: , buff => fnd_message.get);
4515:
4516: -- Log the location within the procedure where the error occurred
4517: fnd_message.set_name( application => 'OKI'
4518: , name => 'OKI_LOC_IN_PROG_FAILURE');
4519:
4520: fnd_message.set_token( token => 'LOCATION'
4521: , value => l_loc);

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

4516: -- Log the location within the procedure where the error occurred
4517: fnd_message.set_name( application => 'OKI'
4518: , name => 'OKI_LOC_IN_PROG_FAILURE');
4519:
4520: fnd_message.set_token( token => 'LOCATION'
4521: , value => l_loc);
4522:
4523: fnd_file.put_line( which => fnd_file.log
4524: , buff => fnd_message.get);

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

4520: fnd_message.set_token( token => 'LOCATION'
4521: , value => l_loc);
4522:
4523: fnd_file.put_line( which => fnd_file.log
4524: , buff => fnd_message.get);
4525:
4526: fnd_file.put_line( which => fnd_file.log
4527: , buff => l_sqlcode||' '|| l_sqlerrm );
4528: END calc_sgr_sum ;

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

4662:
4663:
4664: -- Table loaded successfully. Log message IN concurrent manager
4665: -- log indicating successful load.
4666: fnd_message.set_name( application => 'OKI'
4667: , name => 'OKI_TABLE_LOAD_SUCCESS');
4668:
4669: fnd_message.set_token( token => 'TABLE_NAME'
4670: , value => l_table_name );

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

4665: -- log indicating successful load.
4666: fnd_message.set_name( application => 'OKI'
4667: , name => 'OKI_TABLE_LOAD_SUCCESS');
4668:
4669: fnd_message.set_token( token => 'TABLE_NAME'
4670: , value => l_table_name );
4671:
4672: fnd_file.put_line( which => fnd_file.log
4673: , buff => fnd_message.get);

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

4669: fnd_message.set_token( token => 'TABLE_NAME'
4670: , value => l_table_name );
4671:
4672: fnd_file.put_line( which => fnd_file.log
4673: , buff => fnd_message.get);
4674:
4675: oki_refresh_pvt.update_oki_refresh( l_table_name, l_retcode ) ;
4676:
4677: IF l_retcode in ('1', '2') THEN

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

4707: -- ROLLBACK all transactions
4708: ROLLBACK TO oki_load_sgr_pvt_crt_seq_grw ;
4709:
4710:
4711: fnd_message.set_name( application => 'OKI'
4712: , name => 'OKI_UNEXPECTED_FAILURE');
4713:
4714: fnd_message.set_token( token => 'OBJECT_NAME'
4715: , value => 'OKI_LOAD_SGR_PVT.CRT_SEQ_GRW');

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

4710:
4711: fnd_message.set_name( application => 'OKI'
4712: , name => 'OKI_UNEXPECTED_FAILURE');
4713:
4714: fnd_message.set_token( token => 'OBJECT_NAME'
4715: , value => 'OKI_LOAD_SGR_PVT.CRT_SEQ_GRW');
4716:
4717: fnd_file.put_line( which => fnd_file.log
4718: , buff => fnd_message.get);

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

4714: fnd_message.set_token( token => 'OBJECT_NAME'
4715: , value => 'OKI_LOAD_SGR_PVT.CRT_SEQ_GRW');
4716:
4717: fnd_file.put_line( which => fnd_file.log
4718: , buff => fnd_message.get);
4719:
4720: fnd_file.put_line( which => fnd_file.log
4721: , buff => l_sqlcode||' '||l_sqlerrm );
4722: