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

Line 181: fnd_file.put(fnd_file.log,' ');

177: END IF;
178: /* indent the line */
179: FOR i IN 1 .. p_indent
180: LOOP
181: fnd_file.put(fnd_file.log,' ');
182: END LOOP;
183: /* RPAD so that the values besides the prompts are printed aligned */
184: fnd_file.put(fnd_file.log, RPAD (all_segment_details_tab(i).row_prompt || ': ', g_DFF_prompt_max_length + 5, ' ') || l_DFF_value);
185: fnd_file.put_line(fnd_file.log,'');

Line 184: fnd_file.put(fnd_file.log, RPAD (all_segment_details_tab(i).row_prompt || ': ', g_DFF_prompt_max_length + 5, ' ') || l_DFF_value);

180: LOOP
181: fnd_file.put(fnd_file.log,' ');
182: END LOOP;
183: /* RPAD so that the values besides the prompts are printed aligned */
184: fnd_file.put(fnd_file.log, RPAD (all_segment_details_tab(i).row_prompt || ': ', g_DFF_prompt_max_length + 5, ' ') || l_DFF_value);
185: fnd_file.put_line(fnd_file.log,'');
186: END IF;
187: END LOOP;
188:

Line 185: fnd_file.put_line(fnd_file.log,'');

181: fnd_file.put(fnd_file.log,' ');
182: END LOOP;
183: /* RPAD so that the values besides the prompts are printed aligned */
184: fnd_file.put(fnd_file.log, RPAD (all_segment_details_tab(i).row_prompt || ': ', g_DFF_prompt_max_length + 5, ' ') || l_DFF_value);
185: fnd_file.put_line(fnd_file.log,'');
186: END IF;
187: END LOOP;
188:
189: END get_DFF_output;

Line 415: fnd_file.new_line(fnd_file.log, 1);

411: l_start_date := sysdate - nvl(p_no_of_days ,0);
412: l_end_date := sysdate;
413: END IF;
414:
415: fnd_file.new_line(fnd_file.log, 1);
416:
417: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
418: /*
419: * If the user chooses to display the DFFs AND the DFF definition is frozen

Line 442: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

438: open c_grp_sec(p_group_id);
439: fetch c_grp_sec into r_grp;
440: if(c_grp_sec%found)
441: then
442: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
443: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
444: IF (g_DFF_to_be_displayed)
445: THEN
446: get_DFF_output

Line 468: fnd_file.put_line(fnd_file.log,'No values found based on your criterion');

464: );
465: END IF;
466: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
467: else
468: fnd_file.put_line(fnd_file.log,'No values found based on your criterion');
469: end if;
470: l_prev_group := r_grp.group_name;
471: while (c_grp_sec%FOUND)
472: loop

Line 475: fnd_file.new_line(fnd_file.log, 3);

471: while (c_grp_sec%FOUND)
472: loop
473: if (l_prev_group <> r_grp.group_name)
474: then
475: fnd_file.new_line(fnd_file.log, 3);
476: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
477: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
478: IF (g_DFF_to_be_displayed)
479: THEN

Line 476: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

472: loop
473: if (l_prev_group <> r_grp.group_name)
474: then
475: fnd_file.new_line(fnd_file.log, 3);
476: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
477: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
478: IF (g_DFF_to_be_displayed)
479: THEN
480: get_DFF_output

Line 516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);

512: l_to_grp_number := null;
513: l_to_grp_name := null;
514: end if;
515:
516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

Line 517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);

513: l_to_grp_name := null;
514: end if;
515:
516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

Line 518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);

514: end if;
515:
516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

Line 519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);

515:
516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

Line 520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

516: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

Line 521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

517: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

Line 522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

518: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

Line 523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

519: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

Line 524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

520: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
528: l_prev_group := r_grp.group_name;

Line 525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

521: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
528: l_prev_group := r_grp.group_name;
529: fnd_file.new_line(fnd_file.log, 1);

Line 526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

522: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
528: l_prev_group := r_grp.group_name;
529: fnd_file.new_line(fnd_file.log, 1);
530: fetch c_grp_sec into r_grp;

Line 527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

523: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
524: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
528: l_prev_group := r_grp.group_name;
529: fnd_file.new_line(fnd_file.log, 1);
530: fetch c_grp_sec into r_grp;
531:

Line 529: fnd_file.new_line(fnd_file.log, 1);

525: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
526: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
527: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
528: l_prev_group := r_grp.group_name;
529: fnd_file.new_line(fnd_file.log, 1);
530: fetch c_grp_sec into r_grp;
531:
532: end loop; -- end of if
533: close c_grp_sec;

Line 548: fnd_file.put_line(fnd_file.log,'Usage: ' || r_grp_usagename.meaning);

544: --Bug# 2909006. Print Usage at the top of report.
545: open c_grp_usagename;
546: fetch c_grp_usagename into r_grp_usagename;
547: if (c_grp_usagename%found) then
548: fnd_file.put_line(fnd_file.log,'Usage: ' || r_grp_usagename.meaning);
549: end if;
550: close c_grp_usagename;
551:
552: if(p_group_id is null)

Line 563: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

559: open c_grp_sec(r_grp_usage.group_id);
560: fetch c_grp_sec into r_grp;
561: if(c_grp_sec%found)
562: then
563: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
564: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
565: IF (g_DFF_to_be_displayed)
566: THEN
567: get_DFF_output

Line 596: fnd_file.new_line(fnd_file.log, 3);

592: while (c_grp_sec%FOUND)
593: loop
594: if (l_prev_group <> r_grp.group_name)
595: then
596: fnd_file.new_line(fnd_file.log, 3);
597: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
598: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
599: IF (g_DFF_to_be_displayed)
600: THEN

Line 597: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

593: loop
594: if (l_prev_group <> r_grp.group_name)
595: then
596: fnd_file.new_line(fnd_file.log, 3);
597: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
598: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
599: IF (g_DFF_to_be_displayed)
600: THEN
601: get_DFF_output

Line 637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);

633: l_to_grp_number := null;
634: l_to_grp_name := null;
635: end if;
636:
637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

Line 638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);

634: l_to_grp_name := null;
635: end if;
636:
637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

Line 639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);

635: end if;
636:
637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

Line 640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);

636:
637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

Line 641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

637: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

Line 642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

638: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

Line 643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

639: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

Line 644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

640: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

Line 645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

641: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
649: l_prev_group := r_grp.group_name;

Line 646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

642: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
649: l_prev_group := r_grp.group_name;
650: fnd_file.new_line(fnd_file.log, 1);

Line 647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

643: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
649: l_prev_group := r_grp.group_name;
650: fnd_file.new_line(fnd_file.log, 1);
651: fetch c_grp_sec into r_grp;

Line 648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

644: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
645: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
649: l_prev_group := r_grp.group_name;
650: fnd_file.new_line(fnd_file.log, 1);
651: fetch c_grp_sec into r_grp;
652:

Line 650: fnd_file.new_line(fnd_file.log, 1);

646: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
647: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
648: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
649: l_prev_group := r_grp.group_name;
650: fnd_file.new_line(fnd_file.log, 1);
651: fetch c_grp_sec into r_grp;
652:
653: end loop; -- end of if
654: close c_grp_sec;

Line 676: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

672: open c_grp_sec(r_grp_usage.group_id);
673: fetch c_grp_sec into r_grp;
674: if(c_grp_sec%found)
675: then
676: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
677: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
678: IF (g_DFF_to_be_displayed)
679: THEN
680: get_DFF_output

Line 709: fnd_file.new_line(fnd_file.log, 3);

705: while (c_grp_sec%FOUND)
706: loop
707: if (l_prev_group <> r_grp.group_name)
708: then
709: fnd_file.new_line(fnd_file.log, 3);
710: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
711: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
712: IF (g_DFF_to_be_displayed)
713: THEN

Line 710: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);

706: loop
707: if (l_prev_group <> r_grp.group_name)
708: then
709: fnd_file.new_line(fnd_file.log, 3);
710: fnd_file.put_line(fnd_file.log,'Group name: '||r_grp.group_name);
711: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
712: IF (g_DFF_to_be_displayed)
713: THEN
714: get_DFF_output

Line 750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);

746: l_to_grp_number := null;
747: l_to_grp_name := null;
748: end if;
749:
750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

Line 751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);

747: l_to_grp_name := null;
748: end if;
749:
750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

Line 752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);

748: end if;
749:
750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

Line 753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);

749:
750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

Line 754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);

750: fnd_file.put_line(fnd_file.log,rpad(' Resource Name: ',27, ' ')||r_grp.resource_name);
751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

Line 755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);

751: fnd_file.put_line(fnd_file.log,rpad(' Resource Number: ',27, ' ')||r_grp.resource_number);
752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

Line 756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);

752: fnd_file.put_line(fnd_file.log,rpad(' Category: ',27, ' ')||r_grp.category_name);
753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

Line 757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);

753: fnd_file.put_line(fnd_file.log,rpad(' Date: ',27, ' ')||r_grp.creation_date);
754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

Line 758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);

754: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',27, ' ')||r_grp.created_by);
755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
762: l_prev_group := r_grp.group_name;

Line 759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);

755: fnd_file.put_line(fnd_file.log,rpad(' Action: ',27, ' ')||r_grp.moved);
756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
762: l_prev_group := r_grp.group_name;
763: fnd_file.new_line(fnd_file.log, 1);

Line 760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);

756: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',27, ' ')||r_grp.from_group_number);
757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
762: l_prev_group := r_grp.group_name;
763: fnd_file.new_line(fnd_file.log, 1);
764: fetch c_grp_sec into r_grp;

Line 761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);

757: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',27, ' ')||r_grp.from_group_name);
758: --fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||r_grp.to_group_number);
759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
762: l_prev_group := r_grp.group_name;
763: fnd_file.new_line(fnd_file.log, 1);
764: fetch c_grp_sec into r_grp;
765:

Line 763: fnd_file.new_line(fnd_file.log, 1);

759: --fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||r_grp.to_group_name);
760: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',27, ' ')||l_to_grp_number);
761: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',27, ' ')||l_to_grp_name);
762: l_prev_group := r_grp.group_name;
763: fnd_file.new_line(fnd_file.log, 1);
764: fetch c_grp_sec into r_grp;
765:
766: end loop; -- end of if
767: close c_grp_sec;

Line 787: fnd_file.put_line(fnd_file.log,'Resource: '||r_res.resource_name);

783: open c_res;
784: fetch c_res into r_res;
785: if(c_res%found)
786: then
787: fnd_file.put_line(fnd_file.log,'Resource: '||r_res.resource_name);
788: fnd_file.put_line(fnd_file.log,'Resource Number: '||r_res.resource_number);
789: fnd_file.put_line(fnd_file.log,'Category: '||r_res.category_name);
790: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
791: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463

Line 788: fnd_file.put_line(fnd_file.log,'Resource Number: '||r_res.resource_number);

784: fetch c_res into r_res;
785: if(c_res%found)
786: then
787: fnd_file.put_line(fnd_file.log,'Resource: '||r_res.resource_name);
788: fnd_file.put_line(fnd_file.log,'Resource Number: '||r_res.resource_number);
789: fnd_file.put_line(fnd_file.log,'Category: '||r_res.category_name);
790: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
791: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
792: IF (g_DFF_to_be_displayed)

Line 789: fnd_file.put_line(fnd_file.log,'Category: '||r_res.category_name);

785: if(c_res%found)
786: then
787: fnd_file.put_line(fnd_file.log,'Resource: '||r_res.resource_name);
788: fnd_file.put_line(fnd_file.log,'Resource Number: '||r_res.resource_number);
789: fnd_file.put_line(fnd_file.log,'Category: '||r_res.category_name);
790: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
791: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
792: IF (g_DFF_to_be_displayed)
793: THEN

Line 790: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);

786: then
787: fnd_file.put_line(fnd_file.log,'Resource: '||r_res.resource_name);
788: fnd_file.put_line(fnd_file.log,'Resource Number: '||r_res.resource_number);
789: fnd_file.put_line(fnd_file.log,'Category: '||r_res.category_name);
790: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
791: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
792: IF (g_DFF_to_be_displayed)
793: THEN
794: get_DFF_output

Line 816: fnd_file.put_line(fnd_file.log,'No values found based on your criterion');

812: );
813: END IF;
814: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
815: else
816: fnd_file.put_line(fnd_file.log,'No values found based on your criterion');
817: end if;
818: l_prev_group := r_res.group_name;
819: while (c_res%FOUND)
820: loop

Line 823: fnd_file.new_line(fnd_file.log, 3);

819: while (c_res%FOUND)
820: loop
821: if (l_prev_group <> r_res.group_name)
822: then
823: fnd_file.new_line(fnd_file.log, 3);
824: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
825: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
826: IF (g_DFF_to_be_displayed)
827: THEN

Line 824: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);

820: loop
821: if (l_prev_group <> r_res.group_name)
822: then
823: fnd_file.new_line(fnd_file.log, 3);
824: fnd_file.put_line(fnd_file.log,rpad(' Group name: ',27,' ')||r_res.group_name);
825: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
826: IF (g_DFF_to_be_displayed)
827: THEN
828: get_DFF_output

Line 850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);

846: );
847: END IF;
848: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
849: end if;
850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);
851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);

Line 851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);

847: END IF;
848: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
849: end if;
850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);
851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);

Line 852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);

848: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
849: end if;
850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);
851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);

Line 853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);

849: end if;
850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);
851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);
857: l_prev_group := r_res.group_name;

Line 854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);

850: fnd_file.put_line(fnd_file.log,rpad(' Date: ',29, ' ')||r_res.creation_date);
851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);
857: l_prev_group := r_res.group_name;
858: fnd_file.new_line(fnd_file.log, 1);

Line 855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);

851: fnd_file.put_line(fnd_file.log,rpad(' Updated By: ',29, ' ')||r_res.created_by);
852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);
857: l_prev_group := r_res.group_name;
858: fnd_file.new_line(fnd_file.log, 1);
859: fetch c_res into r_res;

Line 856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);

852: fnd_file.put_line(fnd_file.log,rpad(' Action: ',29, ' ')||r_res.moved);
853: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group #:',29, ' ')||r_res.from_group_number);
854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);
857: l_prev_group := r_res.group_name;
858: fnd_file.new_line(fnd_file.log, 1);
859: fetch c_res into r_res;
860:

Line 858: fnd_file.new_line(fnd_file.log, 1);

854: fnd_file.put_line(fnd_file.log,rpad(' Moved From Group Name:',29, ' ')||r_res.from_group_name);
855: fnd_file.put_line(fnd_file.log,rpad(' Moved To Group #:',29, ' ')||r_res.to_group_number);
856: fnd_file.put_line(fnd_file.log,rpad(' Moved to Group Name: ',29, ' ')||r_res.to_group_name);
857: l_prev_group := r_res.group_name;
858: fnd_file.new_line(fnd_file.log, 1);
859: fetch c_res into r_res;
860:
861: end loop; -- end of if
862: close c_res;

Line 875: fnd_file.put_line(fnd_file.log,sqlerrm);

871: END IF;
872: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
873: exception
874: when others then
875: fnd_file.put_line(fnd_file.log,sqlerrm);
876: end query_group;
877:
878: /* This procedure traverse recursively thru the child
879: hierarchy of a group and populates g_child_tab table with

Line 1071: fnd_file.put_line(fnd_file.log,'Group name: '||p_group_name);

1067: open group_id_cur;
1068: fetch group_id_cur into group_id_rec;
1069: while(group_id_cur%found)
1070: loop
1071: fnd_file.put_line(fnd_file.log,'Group name: '||p_group_name);
1072: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1073: IF (g_DFF_to_be_displayed)
1074: THEN
1075: get_DFF_output

Line 1103: fnd_file.put_line(fnd_file.log,rpad(' Member :',15,' ') ||members_rec.resource_name);

1099: fetch members_cur into members_rec;
1100: while(members_cur%found)
1101: loop
1102: --print members
1103: fnd_file.put_line(fnd_file.log,rpad(' Member :',15,' ') ||members_rec.resource_name);
1104: /* Begin of Add - Bug# 1745032 */
1105: if (p_disp_role ='Y') then
1106: l_role_name := members_rec.role_name;
1107: if members_rec.res_rl_start_date IS NOT NULL THEN

Line 1113: fnd_file.put_line(fnd_file.log,rpad(' Role :',15,' ') ||l_role_name);

1109: AND NVL (members_rec.res_rl_end_date, l_sysdate)) THEN
1110: l_role_name := NULL;
1111: end if;
1112: end if;
1113: fnd_file.put_line(fnd_file.log,rpad(' Role :',15,' ') ||l_role_name);
1114: end if;
1115: /* End of Add - Bug# 1745032 */
1116: fnd_file.put_line(fnd_file.log,rpad(' Category :',15,' ') ||members_rec.category_name);
1117:

Line 1116: fnd_file.put_line(fnd_file.log,rpad(' Category :',15,' ') ||members_rec.category_name);

1112: end if;
1113: fnd_file.put_line(fnd_file.log,rpad(' Role :',15,' ') ||l_role_name);
1114: end if;
1115: /* End of Add - Bug# 1745032 */
1116: fnd_file.put_line(fnd_file.log,rpad(' Category :',15,' ') ||members_rec.category_name);
1117:
1118: fetch members_cur into members_rec;
1119: end loop;
1120: close members_cur;

Line 1133: fnd_file.put_line(fnd_file.log,rpad(' Child Group name: ',27, ' ')||child_dtls_rec.group_name);

1129: fetch child_dtls_cur into child_dtls_rec;
1130: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1131:
1132: --get group name etc
1133: fnd_file.put_line(fnd_file.log,rpad(' Child Group name: ',27, ' ')||child_dtls_rec.group_name);
1134: fnd_file.put_line(fnd_file.log,rpad(' Level : ',27, ' ')||l_child_tab(i).level);
1135: fnd_file.put_line(fnd_file.log,rpad(' Effective : ',27, ' ')||l_child_tab(i).p_relation_start_date ||' -- '||l_child_tab(i).p_relation_end_date);
1136: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1137: IF (g_DFF_to_be_displayed)

Line 1134: fnd_file.put_line(fnd_file.log,rpad(' Level : ',27, ' ')||l_child_tab(i).level);

1130: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1131:
1132: --get group name etc
1133: fnd_file.put_line(fnd_file.log,rpad(' Child Group name: ',27, ' ')||child_dtls_rec.group_name);
1134: fnd_file.put_line(fnd_file.log,rpad(' Level : ',27, ' ')||l_child_tab(i).level);
1135: fnd_file.put_line(fnd_file.log,rpad(' Effective : ',27, ' ')||l_child_tab(i).p_relation_start_date ||' -- '||l_child_tab(i).p_relation_end_date);
1136: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1137: IF (g_DFF_to_be_displayed)
1138: THEN

Line 1135: fnd_file.put_line(fnd_file.log,rpad(' Effective : ',27, ' ')||l_child_tab(i).p_relation_start_date ||' -- '||l_child_tab(i).p_relation_end_date);

1131:
1132: --get group name etc
1133: fnd_file.put_line(fnd_file.log,rpad(' Child Group name: ',27, ' ')||child_dtls_rec.group_name);
1134: fnd_file.put_line(fnd_file.log,rpad(' Level : ',27, ' ')||l_child_tab(i).level);
1135: fnd_file.put_line(fnd_file.log,rpad(' Effective : ',27, ' ')||l_child_tab(i).p_relation_start_date ||' -- '||l_child_tab(i).p_relation_end_date);
1136: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1137: IF (g_DFF_to_be_displayed)
1138: THEN
1139: get_DFF_output

Line 1168: fnd_file.put_line(fnd_file.log,rpad(' Member :',20,' ') ||members_rec.resource_name);

1164: fetch members_cur into members_rec;
1165: while(members_cur%found)
1166: loop
1167: --print members
1168: fnd_file.put_line(fnd_file.log,rpad(' Member :',20,' ') ||members_rec.resource_name);
1169: /* Begin of Add - Bug# 1745032 */
1170: if (p_disp_role ='Y') then
1171: fnd_file.put_line(fnd_file.log,rpad(' Role :',20,' ') ||members_rec.role_name);
1172: end if;

Line 1171: fnd_file.put_line(fnd_file.log,rpad(' Role :',20,' ') ||members_rec.role_name);

1167: --print members
1168: fnd_file.put_line(fnd_file.log,rpad(' Member :',20,' ') ||members_rec.resource_name);
1169: /* Begin of Add - Bug# 1745032 */
1170: if (p_disp_role ='Y') then
1171: fnd_file.put_line(fnd_file.log,rpad(' Role :',20,' ') ||members_rec.role_name);
1172: end if;
1173: /* End of Add - Bug# 1745032 */
1174: fnd_file.put_line(fnd_file.log,rpad(' Category :',20,' ') ||members_rec.category_name);
1175:

Line 1174: fnd_file.put_line(fnd_file.log,rpad(' Category :',20,' ') ||members_rec.category_name);

1170: if (p_disp_role ='Y') then
1171: fnd_file.put_line(fnd_file.log,rpad(' Role :',20,' ') ||members_rec.role_name);
1172: end if;
1173: /* End of Add - Bug# 1745032 */
1174: fnd_file.put_line(fnd_file.log,rpad(' Category :',20,' ') ||members_rec.category_name);
1175:
1176: fetch members_cur into members_rec;
1177: end loop;
1178: close members_cur;

Line 1369: fnd_file.put_line(fnd_file.log,lpad('Group name: ',l_indent,' ')||r_grp_child.group_name);

1365: fetch c_grp_child into r_grp_child;
1366: if(c_grp_child%found)
1367: then
1368: l_indent := l_child_tab(i).level * 3 + 15;
1369: fnd_file.put_line(fnd_file.log,lpad('Group name: ',l_indent,' ')||r_grp_child.group_name);
1370: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1371: IF (g_DFF_to_be_displayed)
1372: THEN
1373: get_DFF_output

Line 1394: --fnd_file.put_line(fnd_file.log,'Level: '||l_child_tab(i).level);

1390: l_indent - 12
1391: );
1392: END IF;
1393: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1394: --fnd_file.put_line(fnd_file.log,'Level: '||l_child_tab(i).level);
1395:
1396: end if;
1397: while (c_grp_child%FOUND)
1398: loop

Line 1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);

1408: l_to_grp_number := null;
1409: l_to_grp_name := null;
1410: end if;
1411:
1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);
1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);

Line 1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);

1409: l_to_grp_name := null;
1410: end if;
1411:
1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);
1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);

Line 1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);

1410: end if;
1411:
1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);
1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);

Line 1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);

1411:
1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);
1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);

Line 1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);

1412: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_name);
1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);

Line 1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);

1413: fnd_file.put_line(fnd_file.log,lpad(rpad(' Resource Number: ',27, ' '),15+l_indent, ' ')||r_grp_child.resource_number);
1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);

Line 1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);

1414: fnd_file.put_line(fnd_file.log,lpad(rpad(' Category: ',27, ' '),15+l_indent, ' ')||r_grp_child.category_name);
1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);

Line 1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);

1415: fnd_file.put_line(fnd_file.log,lpad(rpad(' Date: ',27, ' '),15+l_indent, ' ')||r_grp_child.creation_date);
1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);

Line 1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);

1416: fnd_file.put_line(fnd_file.log,lpad(rpad(' Updated By: ',27, ' '),15+l_indent, ' ')||r_grp_child.created_by);
1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);
1424: fnd_file.new_line(fnd_file.log, 1);

Line 1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);

1417: fnd_file.put_line(fnd_file.log,lpad(rpad(' Action: ',27, ' '),15+l_indent, ' ')||r_grp_child.moved);
1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);
1424: fnd_file.new_line(fnd_file.log, 1);
1425: fetch c_grp_child into r_grp_child;

Line 1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);

1418: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_number);
1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);
1424: fnd_file.new_line(fnd_file.log, 1);
1425: fetch c_grp_child into r_grp_child;
1426:

Line 1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);

1419: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved From Group Name:',27, ' '),15+l_indent, ' ')||r_grp_child.from_group_name);
1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);
1424: fnd_file.new_line(fnd_file.log, 1);
1425: fetch c_grp_child into r_grp_child;
1426:
1427: end loop; -- end of if

Line 1424: fnd_file.new_line(fnd_file.log, 1);

1420: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_number);
1421: -- fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent, ' ')||r_grp_child.to_group_name);
1422: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved To Group #:',27, ' '),15+l_indent,' ')||l_to_grp_number);
1423: fnd_file.put_line(fnd_file.log,lpad(rpad(' Moved to Group Name: ',27, ' '),15+l_indent,' ')||l_to_grp_name);
1424: fnd_file.new_line(fnd_file.log, 1);
1425: fetch c_grp_child into r_grp_child;
1426:
1427: end loop; -- end of if
1428: close c_grp_child;