DBA Data[Home] [Help]

APPS.FND_CONC_PRIVATE_UTILS dependencies on FND_LOG

Line 529: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

525: and node = record_temp_file_use_pvt.node
526: and type = record_temp_file_use_pvt.type;
527:
528: if not SQL%FOUND then
529: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
531: 'insert into fnd_temp_files');
532: end if;
533: insert into fnd_temp_files

Line 530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',

526: and type = record_temp_file_use_pvt.type;
527:
528: if not SQL%FOUND then
529: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
531: 'insert into fnd_temp_files');
532: end if;
533: insert into fnd_temp_files
534: (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)

Line 537: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

533: insert into fnd_temp_files
534: (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)
535: values (record_temp_file_use_pvt.filename, record_temp_file_use_pvt.type, req_id, sess_id, record_temp_file_use_pvt.node);
536: else
537: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
539: 'fnd_temp_files updated');
540: end if;
541: end if;

Line 538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',

534: (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)
535: values (record_temp_file_use_pvt.filename, record_temp_file_use_pvt.type, req_id, sess_id, record_temp_file_use_pvt.node);
536: else
537: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
538: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt',
539: 'fnd_temp_files updated');
540: end if;
541: end if;
542:

Line 547: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

543: commit;
544:
545: exception
546: when others then
547: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
548: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
549: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
550: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
551: FND_MESSAGE.SET_TOKEN('ROUTINE', 'RECORD_TEMP_FILE_USE_PVT');

Line 552: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt');

548: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
549: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
550: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
551: FND_MESSAGE.SET_TOKEN('ROUTINE', 'RECORD_TEMP_FILE_USE_PVT');
552: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.record_temp_file_use_pvt');
553: end if;
554:
555: end record_temp_file_use_pvt;
556:

Line 610: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

606: and upper(node) = upper(erase_temp_file_use_pvt.node)
607: and upper(type) = upper(erase_temp_file_use_pvt.type);
608:
609: if not SQL%FOUND then
610: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',
612: 'filename: '|| filename ||' on node: '|| node ||
613: ' with type: '||type||' not found');
614: end if;

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',

607: and upper(type) = upper(erase_temp_file_use_pvt.type);
608:
609: if not SQL%FOUND then
610: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',
612: 'filename: '|| filename ||' on node: '|| node ||
613: ' with type: '||type||' not found');
614: end if;
615: else

Line 616: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

612: 'filename: '|| filename ||' on node: '|| node ||
613: ' with type: '||type||' not found');
614: end if;
615: else
616: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',
618: 'filename: '|| filename ||' on node: '|| node ||
619: ' with type: '||type||' erased');
620: end if;

Line 617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',

613: ' with type: '||type||' not found');
614: end if;
615: else
616: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'fnd.plsql.fnd_conc_private_utils.erase_temp_file_use_pvt',
618: 'filename: '|| filename ||' on node: '|| node ||
619: ' with type: '||type||' erased');
620: end if;
621: end if;

Line 627: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

623: commit;
624:
625: exception
626: when others then
627: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
628: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
629: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
630: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
631: FND_MESSAGE.SET_TOKEN('ROUTINE', 'ERASE_TEMP_FILE_USAGE_PVT');

Line 632: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.erase_temp_file_usage_pvt');

628: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
629: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
630: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
631: FND_MESSAGE.SET_TOKEN('ROUTINE', 'ERASE_TEMP_FILE_USAGE_PVT');
632: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.erase_temp_file_usage_pvt');
633: end if;
634:
635: end erase_temp_file_use_pvt;
636:

Line 680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

676: exception
677: when no_data_found then
678: null;
679: when others then
680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
681: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
682: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
683: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
684: FND_MESSAGE.SET_TOKEN('ROUTINE', 'ERASE_TEMP_FILE_USAGE_PVT');

Line 685: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.check_temp_file_use');

681: FND_MESSAGE.SET_NAME('FND', 'SQL-GENERIC ERROR');
682: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE, FALSE);
683: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM, FALSE);
684: FND_MESSAGE.SET_TOKEN('ROUTINE', 'ERASE_TEMP_FILE_USAGE_PVT');
685: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.fnd_conc_private_utils.check_temp_file_use');
686: end if;
687: end;
688:
689: return file_recorded;

Line 774: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

770: when resource_mgr_off then
771: commit;
772:
773: when others then
774: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
775: FND_MESSAGE.SET_NAME('FND', 'CONC-CANT SWITCH RCG');
776: FND_MESSAGE.SET_TOKEN('ROUTINE', 'SET_MGR_RCG');
777: FND_MESSAGE.SET_TOKEN('QID', qid);
778: FND_MESSAGE.SET_TOKEN('RCG', que_rcg);

Line 780: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.FND_CONC_PRIVATE_UTILS.SET_MGR_RCG');

776: FND_MESSAGE.SET_TOKEN('ROUTINE', 'SET_MGR_RCG');
777: FND_MESSAGE.SET_TOKEN('QID', qid);
778: FND_MESSAGE.SET_TOKEN('RCG', que_rcg);
779: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
780: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION, 'fnd.plsql.FND_CONC_PRIVATE_UTILS.SET_MGR_RCG');
781: end if;
782: commit;
783:
784: end set_mgr_rcg;