APPS.FND_CONC_PRIVATE_UTILS dependencies on FND_CONC_PRIVATE_UTILS

Line 1: package body FND_CONC_PRIVATE_UTILS as

1: package body FND_CONC_PRIVATE_UTILS as
2: /* $Header: AFCPSCRB.pls 120.11 2011/10/25 20:16:09 jtoruno ship $ */
3:
4:
5: -- FUNCTION get_fs_svc_name:

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

Line 807: end FND_CONC_PRIVATE_UTILS;

803: end set_multiorg_context;
804:
805:
806:
807: end FND_CONC_PRIVATE_UTILS;