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 HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_PLAN_DESIGN_TXN_APIS.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- Private procedure to update the cer with target details
11: --

Line 130: hr_utility.set_location('Entering:'|| l_proc, 10);

126: l_context_bg_name per_business_groups.name%type;
127: --
128: begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Issue a savepoint if operating in validation only mode
133: --
134: savepoint create_PLAN_DESIGN_TXN;

Line 136: hr_utility.set_location(l_proc, 20);

132: -- Issue a savepoint if operating in validation only mode
133: --
134: savepoint create_PLAN_DESIGN_TXN;
135: --
136: hr_utility.set_location(l_proc, 20);
137: --
138: fnd_msg_pub.initialize;
139: --
140:

Line 162: hr_utility.set_location('Before PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);

158: null ;
159: end ;
160: -- Need to create a row into pqh_transaction_category(tct) table
161: --
162: hr_utility.set_location('Before PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);
163:
164: --
165: open txn_cat_c;
166: fetch txn_cat_c into l_transaction_category_id;

Line 169: hr_utility.set_location('l_transaction_category_id '||l_transaction_category_id, 60);

165: open txn_cat_c;
166: fetch txn_cat_c into l_transaction_category_id;
167: close txn_cat_c;
168: --
169: hr_utility.set_location('l_transaction_category_id '||l_transaction_category_id, 60);
170: --
171: PQH_COPY_ENTITY_TXNS_API.create_COPY_ENTITY_TXN
172: (
173: p_validate => false

Line 192: hr_utility.set_location('After PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);

188: ,p_object_version_number => l_cetobject_version_number
189: ,p_effective_date => trunc(p_effective_date)
190: );
191: --
192: hr_utility.set_location('After PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);
193:
194:
195: --
196: -- Set all output arguments

Line 254: hr_utility.set_location(' Leaving:'||l_proc, 70);

250: if p_validate = 1 then
251: raise hr_API.validate_enabled;
252: end if;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 70);
255: --
256: exception
257: --
258: when hr_API.validate_enabled then

Line 271: hr_utility.set_location(' Leaving:'||l_proc, 80);

267: -- when validation only mode is being used.)
268: --
269: p_copy_entity_txn_id := null;
270: p_cea_object_version_number := null;
271: hr_utility.set_location(' Leaving:'||l_proc, 80);
272: hr_utility.set_location(' hr_API.validate_enabled:'||l_proc, 80);
273: --
274: when app_exception.application_exception then
275: p_copy_entity_txn_id := null;

Line 272: hr_utility.set_location(' hr_API.validate_enabled:'||l_proc, 80);

268: --
269: p_copy_entity_txn_id := null;
270: p_cea_object_version_number := null;
271: hr_utility.set_location(' Leaving:'||l_proc, 80);
272: hr_utility.set_location(' hr_API.validate_enabled:'||l_proc, 80);
273: --
274: when app_exception.application_exception then
275: p_copy_entity_txn_id := null;
276: p_cea_object_version_number := null;

Line 279: hr_utility.set_location(' app_exception.application_exception:'||l_proc, 80);

275: p_copy_entity_txn_id := null;
276: p_cea_object_version_number := null;
277:
278: fnd_msg_pub.add;
279: hr_utility.set_location(' app_exception.application_exception:'||l_proc, 80);
280:
281: --
282: when others then
283: --

Line 290: hr_utility.set_location(' when others:'||l_proc, 80);

286: ROLLBACK TO create_PLAN_DESIGN_TXN;
287: p_copy_entity_txn_id := null;
288: p_cea_object_version_number := null;
289:
290: hr_utility.set_location(' when others:'||l_proc, 80);
291: raise;
292: --
293: end create_PLAN_DESIGN_TXN;
294:

Line 398: hr_utility.set_location('Entering:'|| l_proc, 10);

394: l_icx_date_format_mask VARCHAR2(30);
395: --
396: begin
397: --
398: hr_utility.set_location('Entering:'|| l_proc, 10);
399: --
400: -- Issue a savepoint if operating in validation only mode
401: --
402: savepoint update_PLAN_DESIGN_TXN;

Line 406: hr_utility.set_location(l_proc, 20);

402: savepoint update_PLAN_DESIGN_TXN;
403: --
404: fnd_msg_pub.initialize;
405: --
406: hr_utility.set_location(l_proc, 20);
407: --
408: -- Bug 3001617
409: -- This is the benchmark date for Benefits object to start, particularly
410: -- because all of BEN delivered lookups start from 01-Jan-1951

Line 458: hr_utility.set_location(l_proc, 60);

454: );
455: --
456: end if;
457: --
458: hr_utility.set_location(l_proc, 60);
459: --
460: l_cea_object_version_number := p_cea_object_version_number;
461: --
462: if p_upd_record_type in ('CEA', 'CET_CEA')

Line 582: hr_utility.set_location(' Leaving:'||l_proc, 70);

578: --
579: p_cet_object_version_number := l_cet_object_version_number;
580: p_cea_object_version_number := l_cea_object_version_number;
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: --
584: exception
585: --
586: when hr_API.validate_enabled then

Line 597: hr_utility.set_location(' Leaving:'||l_proc, 80);

593: -- Only set output warning arguments
594: -- (Any key or derived arguments must be set to null
595: -- when validation only mode is being used.)
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 80);
598: --
599: when app_exception.application_exception then
600:
601: fnd_msg_pub.add;

Line 602: hr_utility.set_location(' app_exception.application_exception:'||l_proc, 80);

598: --
599: when app_exception.application_exception then
600:
601: fnd_msg_pub.add;
602: hr_utility.set_location(' app_exception.application_exception:'||l_proc, 80);
603:
604: --
605: when others then
606: --

Line 647: hr_utility.set_location('Entering:'|| l_proc, 10);

643: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
644:
645: begin
646: --
647: hr_utility.set_location('Entering:'|| l_proc, 10);
648: --
649: -- Issue a savepoint if operating in validation only mode
650: --
651: pqh_cet_bus.chk_completed_target_err ( p_copy_entity_txn_id );

Line 655: hr_utility.set_location(l_proc, 20);

651: pqh_cet_bus.chk_completed_target_err ( p_copy_entity_txn_id );
652: --
653: savepoint delete_PLAN_DESIGN_TXN;
654: --
655: hr_utility.set_location(l_proc, 20);
656: --
657: -- Process Logic
658: --
659: l_object_version_number := p_cet_object_version_number;

Line 694: hr_utility.set_location(l_proc, 40);

690: ,p_copy_entity_txn_id => p_copy_entity_txn_id
691: ,p_object_version_number => l_object_version_number
692: ,p_effective_date => p_effective_date
693: );
694: hr_utility.set_location(l_proc, 40);
695: --
696: else
697: --
698: -- Update the records in PQH_COPY_ENTITY_TXNS table with status as 'Purged'

Line 709: hr_utility.set_location(l_proc, 50);

705: ,p_status => 'PURGED'
706: ,p_object_version_number => l_object_version_number
707: ,p_effective_date => sysdate
708: );
709: hr_utility.set_location(l_proc, 50);
710: end if;
711: --
712: hr_utility.set_location(l_proc, 60);
713: --

Line 712: hr_utility.set_location(l_proc, 60);

708: );
709: hr_utility.set_location(l_proc, 50);
710: end if;
711: --
712: hr_utility.set_location(l_proc, 60);
713: --
714: -- When in validation only mode raise the Validate_Enabled exception
715: --
716: if p_validate = 1 then

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 70);

716: if p_validate = 1 then
717: raise hr_API.validate_enabled;
718: end if;
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 70);
721: --
722: exception
723: --
724: when hr_API.validate_enabled then

Line 761: hr_utility.set_location(' Entering :'||l_proc, 10);

757: )
758: is
759: l_proc varchar2(72) := g_package||'create_plan_design_result';
760: begin
761: hr_utility.set_location(' Entering :'||l_proc, 10);
762:
763: if p_pgm_id is not null then
764: -- Call the Program routine
765: ben_plan_design_program_module.create_program_result

Line 813: hr_utility.set_location(' Leaving :'||l_proc, 10);

809: end if;
810:
811: --
812: --
813: hr_utility.set_location(' Leaving :'||l_proc, 10);
814: end create_plan_design_result;
815: --
816: -- Overloaded create_plan_design_result for Plan Design Wizard
817: -- This has been overloaded to allow copying Plans to staging area

Line 839: hr_utility.set_location(' Entering :'||l_proc, 10);

835: l_proc varchar2(72) := g_package||'create_plan_design_result';
836: l_copy_entity_result_id number;
837: l_object_version_number number;
838: begin
839: hr_utility.set_location(' Entering :'||l_proc, 10);
840: --
841: create_plan_design_result
842: (
843: p_validate => p_validate

Line 867: hr_utility.set_location(' Leaving :'||l_proc, 10);

863: -- Set out variables
864: p_copy_entity_result_id := l_copy_entity_result_id;
865: p_object_version_number := l_object_version_number;
866:
867: hr_utility.set_location(' Leaving :'||l_proc, 10);
868: end create_plan_design_result;
869: --
870:
871: procedure update_child_object_selection(

Line 1032: hr_utility.set_location(' Entering :'||l_proc, 10);

1028: l_table_name pqh_table_route.where_clause%type;
1029:
1030: begin
1031: --
1032: hr_utility.set_location(' Entering :'||l_proc, 10);
1033: l_number_of_copies := p_number_of_copies ;
1034: --
1035:
1036: if p_called_from = 'HGRID' then

Line 1053: hr_utility.set_location(' Leaving :'||l_proc, 10);

1049: ,p_object_version_number => l_cer_object_version_number
1050: ,p_effective_date => p_effective_date
1051: ,p_information323 => null
1052: );
1053: hr_utility.set_location(' Leaving :'||l_proc, 10);
1054: --
1055:
1056: -- Update number_of_copies for Non Displayed
1057: -- Top level (Program or Plan )records

Line 1169: hr_utility.set_location(' Entering :'||l_proc, 10);

1165: where cer.copy_entity_txn_id = c_copy_entity_txn_id;
1166: --
1167: --
1168: begin
1169: hr_utility.set_location(' Entering :'||l_proc, 10);
1170: --
1171:
1172: --
1173: -- delete from pqh_copy_entity_results

Line 1201: hr_utility.set_location(' Leaving :'||l_proc, 10);

1197: ) ;
1198: --
1199: end loop ;
1200:
1201: hr_utility.set_location(' Leaving :'||l_proc, 10);
1202: --
1203: end delete_plan_design_result;
1204: --
1205: procedure get_effective_dates(

Line 1567: hr_utility.set_location(' Entering :'||l_proc, 10);

1563: l_effective_date1 date;
1564: l_effective_date2 date;
1565: begin
1566: --
1567: hr_utility.set_location(' Entering :'||l_proc, 10);
1568: --
1569: open c_table_name(p_table_route_id);
1570: fetch c_table_name into l_table_route_name;
1571: close c_table_name;

Line 2167: hr_utility.set_location(' Leaving :'||l_proc, 10);

2163: --
2164: end loop;
2165: end if;
2166: --
2167: hr_utility.set_location(' Leaving :'||l_proc, 10);
2168: --
2169: end auto_mapping;
2170: --
2171:

Line 4727: g_debug := hr_utility.debug_enabled;

4723: l_request_id number;
4724: --
4725: BEGIN
4726: --
4727: g_debug := hr_utility.debug_enabled;
4728: if (g_debug) then
4729: hr_utility.set_location(' Entering ' ||l_proc,10);
4730: hr_utility.set_location(' submit req.set BENPDSBMTCMPFF',10);
4731: end if;

Line 4729: hr_utility.set_location(' Entering ' ||l_proc,10);

4725: BEGIN
4726: --
4727: g_debug := hr_utility.debug_enabled;
4728: if (g_debug) then
4729: hr_utility.set_location(' Entering ' ||l_proc,10);
4730: hr_utility.set_location(' submit req.set BENPDSBMTCMPFF',10);
4731: end if;
4732: l_request_id := p_request_id;
4733: --

Line 4730: hr_utility.set_location(' submit req.set BENPDSBMTCMPFF',10);

4726: --
4727: g_debug := hr_utility.debug_enabled;
4728: if (g_debug) then
4729: hr_utility.set_location(' Entering ' ||l_proc,10);
4730: hr_utility.set_location(' submit req.set BENPDSBMTCMPFF',10);
4731: end if;
4732: l_request_id := p_request_id;
4733: --
4734: l_success := fnd_submit.set_request_set

Line 4741: hr_utility.set_location(' submit pgm BEPDCPRC',10);

4737: --
4738: if l_success then
4739: --
4740: if (g_debug) then
4741: hr_utility.set_location(' submit pgm BEPDCPRC',10);
4742: end if;
4743: --
4744: l_success := fnd_submit.submit_program
4745: (application => 'BEN'

Line 4763: hr_utility.set_location(' submit pgm BEPDCCF',10);

4759: raise l_submit_failed;
4760: end if;
4761: --
4762: if (g_debug) then
4763: hr_utility.set_location(' submit pgm BEPDCCF',10);
4764: end if;
4765: --
4766: l_success := fnd_submit.submit_program
4767: (application => 'BEN'

Line 4779: hr_utility.set_location(' submit set',10);

4775: raise l_submit_failed;
4776: end if;
4777: --
4778: if (g_debug) then
4779: hr_utility.set_location(' submit set',10);
4780: end if;
4781: --
4782: l_request_id := fnd_submit.submit_set(null,FALSE);
4783: --

Line 4892: hr_utility.set_location('Entering:'|| l_proc, 10);

4888: begin
4889: --
4890: fnd_msg_pub.initialize;
4891: --
4892: hr_utility.set_location('Entering:'|| l_proc, 10);
4893: --
4894: -- Issue a savepoint if operating in validation only mode
4895: --
4896: savepoint SUBMIT_COPY_REQUEST;

Line 4898: hr_utility.set_location(l_proc, 20);

4894: -- Issue a savepoint if operating in validation only mode
4895: --
4896: savepoint SUBMIT_COPY_REQUEST;
4897: --
4898: hr_utility.set_location(l_proc, 20);
4899: --
4900:
4901: --Perform the following check only for PDW or PDC
4902: --TCS PDW Integration ENH

Line 4920: hr_utility.set_location('Entering:'|| l_proc, 10);

4916: fetch c_copy_entity_txn into l_copy_entity_txn ;
4917: close c_copy_entity_txn;
4918:
4919: if l_copy_entity_txn.target_typ_cd = 'BEN_PDFILE' then -- Export to File
4920: hr_utility.set_location('Entering:'|| l_proc, 10);
4921: --
4922: l_request_id := fnd_request.submit_request
4923: (application => 'BEN'
4924: ,program => 'BENPDCDL'

Line 5086: hr_utility.set_location('l_cea.copy_entity_attrib_id ' || l_cea.copy_entity_attrib_id, 10);

5082: open c_cea;
5083: fetch c_cea into l_cea ;
5084: if c_cea%found then
5085: --
5086: hr_utility.set_location('l_cea.copy_entity_attrib_id ' || l_cea.copy_entity_attrib_id, 10);
5087: hr_utility.set_location('l_cea.ovn' || l_cea.object_version_number, 10);
5088: --
5089: -- Update Request Set Id into Information14 column of PQH_COPY_ENTITY_ATTRIBS table.
5090: pqh_copy_entity_attribs_api.update_copy_entity_attrib

Line 5087: hr_utility.set_location('l_cea.ovn' || l_cea.object_version_number, 10);

5083: fetch c_cea into l_cea ;
5084: if c_cea%found then
5085: --
5086: hr_utility.set_location('l_cea.copy_entity_attrib_id ' || l_cea.copy_entity_attrib_id, 10);
5087: hr_utility.set_location('l_cea.ovn' || l_cea.object_version_number, 10);
5088: --
5089: -- Update Request Set Id into Information14 column of PQH_COPY_ENTITY_ATTRIBS table.
5090: pqh_copy_entity_attribs_api.update_copy_entity_attrib
5091: (p_copy_entity_attrib_id => l_cea.copy_entity_attrib_id

Line 5103: hr_utility.set_location('After call to CET Update',200);

5099: --
5100: end if;
5101: -- Bug 4278495
5102: --
5103: hr_utility.set_location('After call to CET Update',200);
5104: --
5105: g_pgm_pl_prefix_suffix_text := null;
5106: --
5107: end if;

Line 5117: hr_utility.set_location(' Leaving:'||l_proc, 70);

5113: if p_validate = 1 then -- p_validate is true
5114: raise hr_API.validate_enabled;
5115: end if;
5116: --
5117: hr_utility.set_location(' Leaving:'||l_proc, 70);
5118: --
5119: exception
5120: --
5121: when hr_API.validate_enabled then

Line 5134: hr_utility.set_location(' Leaving:'||l_proc, 80);

5130: -- when validation only mode is being used.)
5131: --
5132: p_request_id := null;
5133:
5134: hr_utility.set_location(' Leaving:'||l_proc, 80);
5135: --
5136: when app_exception.application_exception then
5137:
5138: fnd_msg_pub.add;

Line 5272: hr_utility.set_location(' p_request_id '||p_request_id,99);

5268: ,dev_status => l_dev_status
5269: ,message => l_message
5270: );
5271: --
5272: hr_utility.set_location(' p_request_id '||p_request_id,99);
5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);

Line 5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);

5269: ,message => l_message
5270: );
5271: --
5272: hr_utility.set_location(' p_request_id '||p_request_id,99);
5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);

Line 5274: hr_utility.set_location(' l_phase '||l_phase,99);

5270: );
5271: --
5272: hr_utility.set_location(' p_request_id '||p_request_id,99);
5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);
5278: hr_utility.set_location(' l_message '||l_message,99);

Line 5275: hr_utility.set_location(' l_status '||l_status,99);

5271: --
5272: hr_utility.set_location(' p_request_id '||p_request_id,99);
5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);
5278: hr_utility.set_location(' l_message '||l_message,99);
5279: --

Line 5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);

5272: hr_utility.set_location(' p_request_id '||p_request_id,99);
5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);
5278: hr_utility.set_location(' l_message '||l_message,99);
5279: --
5280:

Line 5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);

5273: hr_utility.set_location(' p_copy_entity_txn_id '||p_copy_entity_txn_id,99);
5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);
5278: hr_utility.set_location(' l_message '||l_message,99);
5279: --
5280:
5281: open c_copy_entity_txn ;

Line 5278: hr_utility.set_location(' l_message '||l_message,99);

5274: hr_utility.set_location(' l_phase '||l_phase,99);
5275: hr_utility.set_location(' l_status '||l_status,99);
5276: hr_utility.set_location(' l_dev_status '||l_dev_status,99);
5277: hr_utility.set_location(' l_dev_phase '||l_dev_phase ,99);
5278: hr_utility.set_location(' l_message '||l_message,99);
5279: --
5280:
5281: open c_copy_entity_txn ;
5282: fetch c_copy_entity_txn into l_effective_date,l_ovn,l_start_with;

Line 5304: hr_utility.set_location(' l_txn_status '||l_txn_status,99);

5300: l_txn_status := 'ERROR' ;
5301: --
5302: end if;
5303: --
5304: hr_utility.set_location(' l_txn_status '||l_txn_status,99);
5305: --
5306: --
5307: hr_utility.set_location('Before call to CET Update',100);
5308: --

Line 5307: hr_utility.set_location('Before call to CET Update',100);

5303: --
5304: hr_utility.set_location(' l_txn_status '||l_txn_status,99);
5305: --
5306: --
5307: hr_utility.set_location('Before call to CET Update',100);
5308: --
5309: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
5310: (
5311: p_copy_entity_txn_id => p_copy_entity_txn_id

Line 5319: hr_utility.set_location('After call to CET Update',200);

5315: ,p_object_version_number => l_ovn
5316: ,p_effective_date => l_effective_date
5317: );
5318: --
5319: hr_utility.set_location('After call to CET Update',200);
5320: --
5321: end update_download_status ;
5322: --
5323: