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.BEN_PLAN_DESIGN_TXNS_API dependencies on BEN_BATCH_UTILS

Line 5449: ben_batch_utils.write('Start of conc prog - PURGE PLAN DESIGN COPY PROCESS -');

5445: l_count number;
5446: l_retain_log varchar2(10);
5447: --
5448: begin
5449: ben_batch_utils.write('Start of conc prog - PURGE PLAN DESIGN COPY PROCESS -');
5450: --
5451: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5452: l_retain_log := p_retain_log;
5453: --

Line 5454: ben_batch_utils.write(' ');

5450: --
5451: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5452: l_retain_log := p_retain_log;
5453: --
5454: ben_batch_utils.write(' ');
5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);

Line 5455: ben_batch_utils.write('Input Parameters are :-');

5451: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
5452: l_retain_log := p_retain_log;
5453: --
5454: ben_batch_utils.write(' ');
5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));

Line 5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));

5452: l_retain_log := p_retain_log;
5453: --
5454: ben_batch_utils.write(' ');
5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);

Line 5457: ben_batch_utils.write('Process Id :'||p_process_id);

5453: --
5454: ben_batch_utils.write(' ');
5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);

Line 5458: ben_batch_utils.write('Effective Date :'||l_effective_date);

5454: ben_batch_utils.write(' ');
5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);

Line 5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));

5455: ben_batch_utils.write('Input Parameters are :-');
5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);
5463: ben_batch_utils.write(' ');

Line 5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);

5456: ben_batch_utils.write('Validate :'||hr_general.decode_lookup ('BEN_DB_UPD_MD',p_validate));
5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);
5463: ben_batch_utils.write(' ');
5464: --

Line 5461: ben_batch_utils.write('Retain Log :'||p_retain_log);

5457: ben_batch_utils.write('Process Id :'||p_process_id);
5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);
5463: ben_batch_utils.write(' ');
5464: --
5465: l_count := 1;

Line 5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);

5458: ben_batch_utils.write('Effective Date :'||l_effective_date);
5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);
5463: ben_batch_utils.write(' ');
5464: --
5465: l_count := 1;
5466: --

Line 5463: ben_batch_utils.write(' ');

5459: ben_batch_utils.write('Status :'||hr_general.decode_lookup ('BEN_PD_STATUS',p_status));
5460: ben_batch_utils.write('Transaction short Name :'||p_transaction_short_name);
5461: ben_batch_utils.write('Retain Log :'||p_retain_log);
5462: ben_batch_utils.write('Business Group Id :'||p_business_group_id);
5463: ben_batch_utils.write(' ');
5464: --
5465: l_count := 1;
5466: --
5467: open get_purge_processes(p_process_id

Line 5481: ben_batch_utils.write('============== List of Purged Processes =====================');

5477: -- Bug No 4349302 Log only processes with target_typ_cd <> 'BEN_PDVIEW'
5478: --
5479: if(nvl(l_purge_processes.target_typ_cd,'XXX') <> 'BEN_PDVIEW') then
5480: if (l_count = 1) then
5481: ben_batch_utils.write('============== List of Purged Processes =====================');
5482: ben_batch_utils.write(' ');
5483: end if;
5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name
5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');

Line 5482: ben_batch_utils.write(' ');

5478: --
5479: if(nvl(l_purge_processes.target_typ_cd,'XXX') <> 'BEN_PDVIEW') then
5480: if (l_count = 1) then
5481: ben_batch_utils.write('============== List of Purged Processes =====================');
5482: ben_batch_utils.write(' ');
5483: end if;
5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name
5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');
5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);

Line 5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name

5480: if (l_count = 1) then
5481: ben_batch_utils.write('============== List of Purged Processes =====================');
5482: ben_batch_utils.write(' ');
5483: end if;
5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name
5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');
5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);
5487: ben_batch_utils.write(' Effective Date : '|| l_purge_processes.src_effective_date);
5488: l_count := l_count + 1;

Line 5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);

5482: ben_batch_utils.write(' ');
5483: end if;
5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name
5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');
5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);
5487: ben_batch_utils.write(' Effective Date : '|| l_purge_processes.src_effective_date);
5488: l_count := l_count + 1;
5489: ben_batch_utils.write(' ');
5490: end if;

Line 5487: ben_batch_utils.write(' Effective Date : '|| l_purge_processes.src_effective_date);

5483: end if;
5484: ben_batch_utils.write(l_count||') Process Name : '|| l_purge_processes.process_name
5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');
5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);
5487: ben_batch_utils.write(' Effective Date : '|| l_purge_processes.src_effective_date);
5488: l_count := l_count + 1;
5489: ben_batch_utils.write(' ');
5490: end if;
5491: --

Line 5489: ben_batch_utils.write(' ');

5485: || '(' || l_purge_processes.copy_entity_txn_id || ')');
5486: ben_batch_utils.write(' Status (Before Purge) : '||l_purge_processes.status);
5487: ben_batch_utils.write(' Effective Date : '|| l_purge_processes.src_effective_date);
5488: l_count := l_count + 1;
5489: ben_batch_utils.write(' ');
5490: end if;
5491: --
5492: /* Only if validate mode is Commit ('N'), delete the txns,
5493: for mode = rollback ('Y'), no need of actually calling delete,

Line 5518: ben_batch_utils.write('No processes found which match the given criteria.');

5514: --
5515: close get_purge_processes;
5516: --
5517: if (l_count = 1) then
5518: ben_batch_utils.write('No processes found which match the given criteria.');
5519: ben_batch_utils.write(' ');
5520: end if;
5521: ben_batch_utils.write('Completed - PURGE PLAN DESIGN COPY PROCESS -');
5522: --

Line 5519: ben_batch_utils.write(' ');

5515: close get_purge_processes;
5516: --
5517: if (l_count = 1) then
5518: ben_batch_utils.write('No processes found which match the given criteria.');
5519: ben_batch_utils.write(' ');
5520: end if;
5521: ben_batch_utils.write('Completed - PURGE PLAN DESIGN COPY PROCESS -');
5522: --
5523: end purge_plan_design_process;

Line 5521: ben_batch_utils.write('Completed - PURGE PLAN DESIGN COPY PROCESS -');

5517: if (l_count = 1) then
5518: ben_batch_utils.write('No processes found which match the given criteria.');
5519: ben_batch_utils.write(' ');
5520: end if;
5521: ben_batch_utils.write('Completed - PURGE PLAN DESIGN COPY PROCESS -');
5522: --
5523: end purge_plan_design_process;
5524:
5525: end BEN_PLAN_DESIGN_TXNS_API;