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.PAY_GB_RETRO_UPGRADE dependencies on FND_FILE

Line 64: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);

60: lv_procedure_name VARCHAR2(100);
61:
62: BEGIN
63: lv_procedure_name := '.insert_retro_comp_usages';
64: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
65:
66: select pay_retro_component_usages_s.nextval
67: into ln_retro_component_usage_id
68: from dual;

Line 85: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id= ' || p_retro_comp_usage_id);

81: AND creator_id = p_creator_id
82: AND creator_type = 'ET');
83:
84: p_retro_comp_usage_id := ln_retro_component_usage_id;
85: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
86: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
87:
88: exception
89: when others then

Line 86: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);

82: AND creator_type = 'ET');
83:
84: p_retro_comp_usage_id := ln_retro_component_usage_id;
85: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
86: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
87:
88: exception
89: when others then
90: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

Line 90: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

86: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
87:
88: exception
89: when others then
90: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
91: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
92: raise;
93: END insert_retro_comp_usages;
94:

Line 91: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

87:
88: exception
89: when others then
90: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
91: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
92: raise;
93: END insert_retro_comp_usages;
94:
95:

Line 108: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);

104: lv_procedure_name VARCHAR2(100);
105:
106: BEGIN
107: lv_procedure_name := '.insert_element_span_usages';
108: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
109:
110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);
111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

Line 110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);

106: BEGIN
107: lv_procedure_name := '.insert_element_span_usages';
108: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
109:
110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);
111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);
114:

Line 111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);

107: lv_procedure_name := '.insert_element_span_usages';
108: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
109:
110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);
111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);
114:
115: insert into pay_element_span_usages

Line 112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

108: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
109:
110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);
111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);
114:
115: insert into pay_element_span_usages
116: (element_span_usage_id, business_group_id, time_span_id,

Line 113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);

109:
110: fnd_file.put_line(fnd_file.log,'p_business_group_id ='|| p_business_group_id);
111: fnd_file.put_line(fnd_file.log,'p_time_span_id ='|| p_time_span_id);
112: fnd_file.put_line(fnd_file.log,'p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
113: fnd_file.put_line(fnd_file.log,'p_retro_element_type_id ='|| p_retro_element_type_id);
114:
115: insert into pay_element_span_usages
116: (element_span_usage_id, business_group_id, time_span_id,
117: retro_component_usage_id, retro_element_type_id,

Line 132: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);

128: AND pesu.legislation_code IS NULL
129: AND pesu.time_span_id = p_time_span_id
130: AND retro_component_usage_id = p_retro_comp_usage_id);
131:
132: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
133:
134: exception
135: when others then
136: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

Line 136: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

132: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
133:
134: exception
135: when others then
136: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
137: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
138: raise;
139: END insert_element_span_usages;
140:

Line 137: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

133:
134: exception
135: when others then
136: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
137: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
138: raise;
139: END insert_element_span_usages;
140:
141:

Line 226: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);

222:
223:
224: BEGIN
225:
226: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
227: fnd_file.put_line(fnd_file.log,'Checking element type id '||p_object_id);
228: open c_element_class(p_object_id);
229: fetch c_element_class into ln_classification_id,
230: lv_element_name,

Line 227: fnd_file.put_line(fnd_file.log,'Checking element type id '||p_object_id);

223:
224: BEGIN
225:
226: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
227: fnd_file.put_line(fnd_file.log,'Checking element type id '||p_object_id);
228: open c_element_class(p_object_id);
229: fetch c_element_class into ln_classification_id,
230: lv_element_name,
231: lv_legislation_code,

Line 293: fnd_file.put_line(fnd_file.log,'Element Set ID ' || ln_element_set_id);

289: if c_element_set%notfound then
290: exit;
291: end if;
292:
293: fnd_file.put_line(fnd_file.log,'Element Set ID ' || ln_element_set_id);
294: open c_element_check(ln_element_set_id);
295: fetch c_element_check into ln_element_used;
296: if c_element_check%found then
297: fnd_file.put_line(fnd_file.log, 'Checking legislation code '||lv_ele_leg_code);

Line 297: fnd_file.put_line(fnd_file.log, 'Checking legislation code '||lv_ele_leg_code);

293: fnd_file.put_line(fnd_file.log,'Element Set ID ' || ln_element_set_id);
294: open c_element_check(ln_element_set_id);
295: fetch c_element_check into ln_element_used;
296: if c_element_check%found then
297: fnd_file.put_line(fnd_file.log, 'Checking legislation code '||lv_ele_leg_code);
298: if lv_ele_leg_code IS NOT NULL then
299: fnd_file.put_line(fnd_file.log,' Seeded element '||lv_element_name||' ('||p_object_id||') can not be upgraded.');
300: lv_qualified := 'N';
301: else

Line 299: fnd_file.put_line(fnd_file.log,' Seeded element '||lv_element_name||' ('||p_object_id||') can not be upgraded.');

295: fetch c_element_check into ln_element_used;
296: if c_element_check%found then
297: fnd_file.put_line(fnd_file.log, 'Checking legislation code '||lv_ele_leg_code);
298: if lv_ele_leg_code IS NOT NULL then
299: fnd_file.put_line(fnd_file.log,' Seeded element '||lv_element_name||' ('||p_object_id||') can not be upgraded.');
300: lv_qualified := 'N';
301: else
302: fnd_file.put_line(fnd_file.log,'Element retro-ed before, check classification.');
303: if lv_classification_name in ('Court Orders',

Line 302: fnd_file.put_line(fnd_file.log,'Element retro-ed before, check classification.');

298: if lv_ele_leg_code IS NOT NULL then
299: fnd_file.put_line(fnd_file.log,' Seeded element '||lv_element_name||' ('||p_object_id||') can not be upgraded.');
300: lv_qualified := 'N';
301: else
302: fnd_file.put_line(fnd_file.log,'Element retro-ed before, check classification.');
303: if lv_classification_name in ('Court Orders',
304: 'PAYE', 'NI', 'SSP Non Payment',
305: 'SMP Non Payment',
306: 'SPP Birth Non Payment',

Line 310: fnd_file.put_line(fnd_file.log,'Classification '||lv_classification_name||' is not supported for this upgrade.');

306: 'SPP Birth Non Payment',
307: 'SPP Adoption Non Payment',
308: 'SAP Non Payment')
309: then
310: fnd_file.put_line(fnd_file.log,'Classification '||lv_classification_name||' is not supported for this upgrade.');
311: lv_qualified := 'N';
312: else
313: lv_qualified := 'Y';
314: fnd_file.put_line(fnd_file.log,'UPGRADE Element ' || lv_element_name ||

Line 314: fnd_file.put_line(fnd_file.log,'UPGRADE Element ' || lv_element_name ||

310: fnd_file.put_line(fnd_file.log,'Classification '||lv_classification_name||' is not supported for this upgrade.');
311: lv_qualified := 'N';
312: else
313: lv_qualified := 'Y';
314: fnd_file.put_line(fnd_file.log,'UPGRADE Element ' || lv_element_name ||
315: '(' || p_object_id || ')');
316: end if;
317: end if;
318: --

Line 322: fnd_file.put_line(fnd_file.log,'Element ' || lv_element_name ||

318: --
319: exit;
320: else
321: lv_qualified := 'N';
322: fnd_file.put_line(fnd_file.log,'Element ' || lv_element_name ||
323: '(' || p_object_id || ') does not need to be upgraded');
324: end if;
325: close c_element_check;
326: end loop;

Line 330: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);

326: end loop;
327: close c_element_set;
328:
329: p_qualified := lv_qualified;
330: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
331:
332: exception
333: when others then
334: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

Line 334: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

330: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
331:
332: exception
333: when others then
334: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
335: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
336: raise;
337: END qualify_element;
338:

Line 335: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

331:
332: exception
333: when others then
334: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
335: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
336: raise;
337: END qualify_element;
338:
339:

Line 421: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);

417:
418: ltt_business_group numeric_data_table;
419: BEGIN
420: lv_procedure_name := '.upgrade_element';
421: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
422:
423: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
424: open c_element_dtl(p_element_type_id);
425: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,

Line 423: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

419: BEGIN
420: lv_procedure_name := '.upgrade_element';
421: fnd_file.put_line(fnd_file.log,'Entering ' || gv_package_name || lv_procedure_name);
422:
423: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
424: open c_element_dtl(p_element_type_id);
425: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
426: ln_classification_id, ln_retro_element_type_id,
427: lv_element_name;

Line 429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);

425: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
426: ln_classification_id, ln_retro_element_type_id,
427: lv_element_name;
428: close c_element_dtl;
429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);
430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);
431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);
432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);
433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);

Line 430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);

426: ln_classification_id, ln_retro_element_type_id,
427: lv_element_name;
428: close c_element_dtl;
429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);
430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);
431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);
432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);
433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);
434:

Line 431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);

427: lv_element_name;
428: close c_element_dtl;
429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);
430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);
431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);
432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);
433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);
434:
435: if ln_legislation_code is null and

Line 432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);

428: close c_element_dtl;
429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);
430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);
431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);
432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);
433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);
434:
435: if ln_legislation_code is null and
436: ln_ele_business_group_id is not null then

Line 433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);

429: fnd_file.put_line(fnd_file.log,'p_element_type_id ='|| p_element_type_id);
430: fnd_file.put_line(fnd_file.log,'lv_element_name ='|| lv_element_name);
431: fnd_file.put_line(fnd_file.log,'ln_legislation_code ='|| ln_legislation_code);
432: fnd_file.put_line(fnd_file.log,'ln_ele_business_group_id ='|| ln_ele_business_group_id);
433: fnd_file.put_line(fnd_file.log,'ln_retro_element_type_id ='|| ln_retro_element_type_id);
434:
435: if ln_legislation_code is null and
436: ln_ele_business_group_id is not null then
437: open c_legislation_code(ln_ele_business_group_id);

Line 443: fnd_file.put_line(fnd_file.log,'lv_legislation_code ='|| lv_legislation_code);

439: close c_legislation_code;
440: else
441: lv_legislation_code := ln_legislation_code;
442: end if;
443: fnd_file.put_line(fnd_file.log,'lv_legislation_code ='|| lv_legislation_code);
444:
445: if gn_retro_component_id is null then
446: fnd_file.put_line(fnd_file.log,'getting gn_retro_component_id ='|| gn_retro_component_id);
447: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

Line 446: fnd_file.put_line(fnd_file.log,'getting gn_retro_component_id ='|| gn_retro_component_id);

442: end if;
443: fnd_file.put_line(fnd_file.log,'lv_legislation_code ='|| lv_legislation_code);
444:
445: if gn_retro_component_id is null then
446: fnd_file.put_line(fnd_file.log,'getting gn_retro_component_id ='|| gn_retro_component_id);
447: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
448: open c_retro_info(lv_legislation_code);
449: fetch c_retro_info into gn_retro_component_id
450: ,gn_time_span_id;

Line 447: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

443: fnd_file.put_line(fnd_file.log,'lv_legislation_code ='|| lv_legislation_code);
444:
445: if gn_retro_component_id is null then
446: fnd_file.put_line(fnd_file.log,'getting gn_retro_component_id ='|| gn_retro_component_id);
447: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
448: open c_retro_info(lv_legislation_code);
449: fetch c_retro_info into gn_retro_component_id
450: ,gn_time_span_id;
451: close c_retro_info;

Line 453: fnd_file.put_line(fnd_file.log,'gn_retro_component_id ='|| gn_retro_component_id);

449: fetch c_retro_info into gn_retro_component_id
450: ,gn_time_span_id;
451: close c_retro_info;
452: end if;
453: fnd_file.put_line(fnd_file.log,'gn_retro_component_id ='|| gn_retro_component_id);
454: fnd_file.put_line(fnd_file.log,'gn_time_span_id ='|| gn_time_span_id);
455:
456: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
457:

Line 454: fnd_file.put_line(fnd_file.log,'gn_time_span_id ='|| gn_time_span_id);

450: ,gn_time_span_id;
451: close c_retro_info;
452: end if;
453: fnd_file.put_line(fnd_file.log,'gn_retro_component_id ='|| gn_retro_component_id);
454: fnd_file.put_line(fnd_file.log,'gn_time_span_id ='|| gn_time_span_id);
455:
456: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
457:
458: if ln_legislation_code is not null and

Line 456: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

452: end if;
453: fnd_file.put_line(fnd_file.log,'gn_retro_component_id ='|| gn_retro_component_id);
454: fnd_file.put_line(fnd_file.log,'gn_time_span_id ='|| gn_time_span_id);
455:
456: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
457:
458: if ln_legislation_code is not null and
459: ln_ele_business_group_id is null then
460:

Line 461: fnd_file.put_line(fnd_file.log,'Seeded Element');

457:
458: if ln_legislation_code is not null and
459: ln_ele_business_group_id is null then
460:
461: fnd_file.put_line(fnd_file.log,'Seeded Element');
462: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
463: insert_retro_comp_usages
464: (p_business_group_id => null
465: ,p_legislation_code => ln_legislation_code

Line 462: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

458: if ln_legislation_code is not null and
459: ln_ele_business_group_id is null then
460:
461: fnd_file.put_line(fnd_file.log,'Seeded Element');
462: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
463: insert_retro_comp_usages
464: (p_business_group_id => null
465: ,p_legislation_code => ln_legislation_code
466: ,p_retro_component_id => gn_retro_component_id

Line 470: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

466: ,p_retro_component_id => gn_retro_component_id
467: ,p_creator_id => p_element_type_id
468: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
469:
470: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
471: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
472: loop
473: fetch c_element_set into ln_element_set_id;
474: if c_element_set%notfound then

Line 475: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

471: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
472: loop
473: fetch c_element_set into ln_element_set_id;
474: if c_element_set%notfound then
475: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
476: exit;
477: end if;
478:
479: open c_get_business_group(ln_element_set_id,ln_legislation_code);

Line 483: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

479: open c_get_business_group(ln_element_set_id,ln_legislation_code);
480: loop
481: fetch c_get_business_group into ln_business_group_id;
482: if c_get_business_group%notfound then
483: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
484: exit;
485: end if;
486:
487: -- ln_count := ltt_business_group.count;

Line 490: fnd_file.put_line(fnd_file.log,'ln_business_group_id ='|| ln_business_group_id);

486:
487: -- ln_count := ltt_business_group.count;
488: -- ltt_business_group(ln_count) := ln_business_group_id;
489:
490: fnd_file.put_line(fnd_file.log,'ln_business_group_id ='|| ln_business_group_id);
491: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
492:
493: insert_element_span_usages
494: (p_business_group_id => ln_business_group_id

Line 491: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

487: -- ln_count := ltt_business_group.count;
488: -- ltt_business_group(ln_count) := ln_business_group_id;
489:
490: fnd_file.put_line(fnd_file.log,'ln_business_group_id ='|| ln_business_group_id);
491: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
492:
493: insert_element_span_usages
494: (p_business_group_id => ln_business_group_id
495: ,p_retro_element_type_id => ln_retro_element_type_id

Line 500: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

496: ,p_legislation_code => ln_legislation_code
497: ,p_time_span_id => gn_time_span_id
498: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
499:
500: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
501: end loop;
502: close c_get_business_group;
503: end loop;
504: close c_element_set;

Line 506: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

502: close c_get_business_group;
503: end loop;
504: close c_element_set;
505: end if;
506: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
507:
508: if ln_legislation_code is null and
509: ln_ele_business_group_id is not null then
510:

Line 511: fnd_file.put_line(fnd_file.log,'Custom Element');

507:
508: if ln_legislation_code is null and
509: ln_ele_business_group_id is not null then
510:
511: fnd_file.put_line(fnd_file.log,'Custom Element');
512: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
513: insert_retro_comp_usages
514: (p_business_group_id => ln_ele_business_group_id
515: ,p_legislation_code => null

Line 512: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

508: if ln_legislation_code is null and
509: ln_ele_business_group_id is not null then
510:
511: fnd_file.put_line(fnd_file.log,'Custom Element');
512: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
513: insert_retro_comp_usages
514: (p_business_group_id => ln_ele_business_group_id
515: ,p_legislation_code => null
516: ,p_retro_component_id => gn_retro_component_id

Line 519: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

515: ,p_legislation_code => null
516: ,p_retro_component_id => gn_retro_component_id
517: ,p_creator_id => p_element_type_id
518: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
519: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
520: insert_element_span_usages
521: (p_business_group_id => ln_ele_business_group_id
522: ,p_retro_element_type_id => ln_retro_element_type_id
523: ,p_legislation_code => null

Line 528: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);

524: ,p_time_span_id => gn_time_span_id
525: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
526: end if;
527:
528: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
529: exception
530: when others then
531: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
532: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

Line 531: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);

527:
528: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
529: exception
530: when others then
531: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
532: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
533: raise;
534: END upgrade_element;
535:

Line 532: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

528: fnd_file.put_line(fnd_file.log,'Leaving ' || gv_package_name || lv_procedure_name);
529: exception
530: when others then
531: fnd_file.put_line(fnd_file.log,gv_package_name || lv_procedure_name);
532: fnd_file.put_line(fnd_file.log,'ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
533: raise;
534: END upgrade_element;
535:
536: BEGIN