APPS.PQP_GB_PENSION_SCHEME_UPDATE dependencies on FND_FILE

Line 41: fnd_file.put_line(fnd_file.output,

37: and pee.eei_information12 is null;
38:
39: Begin --print_details
40:
41: fnd_file.put_line(fnd_file.output,
42: 'List of Existing Additional Voluntary Contribution'
43: ||' Elements and Their Pension Scheme Types: ');
44: fnd_file.new_line(fnd_file.output,1);
45:

Line 44: fnd_file.new_line(fnd_file.output,1);

40:
41: fnd_file.put_line(fnd_file.output,
42: 'List of Existing Additional Voluntary Contribution'
43: ||' Elements and Their Pension Scheme Types: ');
44: fnd_file.new_line(fnd_file.output,1);
45:
46: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
47: ||' '
48: ||rpad('-',19,'-'));

Line 46: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

42: 'List of Existing Additional Voluntary Contribution'
43: ||' Elements and Their Pension Scheme Types: ');
44: fnd_file.new_line(fnd_file.output,1);
45:
46: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
47: ||' '
48: ||rpad('-',19,'-'));
49:
50: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)

Line 50: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)

46: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
47: ||' '
48: ||rpad('-',19,'-'));
49:
50: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)
51: ||' '
52: ||'Pension Scheme Type');
53:
54: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

Line 54: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

50: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)
51: ||' '
52: ||'Pension Scheme Type');
53:
54: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
55: ||' '
56: ||rpad('-',19,'-'));
57:
58: --loop through the cursor

Line 61: fnd_file.put_line(fnd_file.output,rpad(i.element_name,85,' ')

57:
58: --loop through the cursor
59: --and print element name and its pension scheme type
60: For i in csr_element_and_type loop
61: fnd_file.put_line(fnd_file.output,rpad(i.element_name,85,' ')
62: ||i.scheme_type);
63:
64: End loop;
65: End print_details ;

Line 94: fnd_file.put_line(fnd_file.output,

90: element_details_tab element_details_typ;
91:
92: Begin --update_scheme_type
93:
94: fnd_file.put_line(fnd_file.output,
95: 'List of Elements Updated with Pension Scheme Types: ');
96: fnd_file.new_line(fnd_file.output,1);
97:
98: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

Line 96: fnd_file.new_line(fnd_file.output,1);

92: Begin --update_scheme_type
93:
94: fnd_file.put_line(fnd_file.output,
95: 'List of Elements Updated with Pension Scheme Types: ');
96: fnd_file.new_line(fnd_file.output,1);
97:
98: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
99: ||' '
100: ||rpad('-',19,'-'));

Line 98: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

94: fnd_file.put_line(fnd_file.output,
95: 'List of Elements Updated with Pension Scheme Types: ');
96: fnd_file.new_line(fnd_file.output,1);
97:
98: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
99: ||' '
100: ||rpad('-',19,'-'));
101:
102: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)

Line 102: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)

98: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
99: ||' '
100: ||rpad('-',19,'-'));
101:
102: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)
103: ||' '
104: ||'Pension Scheme Type');
105:
106: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

Line 106: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')

102: fnd_file.put_line(fnd_file.output,rpad('Element Name',80)
103: ||' '
104: ||'Pension Scheme Type');
105:
106: fnd_file.put_line(fnd_file.output,rpad('-',80,'-')
107: ||' '
108: ||rpad('-',19,'-'));
109:
110:

Line 128: fnd_file.put_line(fnd_file.output,

124: and pee.eei_information4 = 'AVC'
125: and pee.eei_information12 is null;
126:
127: If(sql%rowcount>0) then
128: fnd_file.put_line(fnd_file.output,
129: rpad(element_details_tab(i).element_name,85,' ')
130: ||element_details_tab(i).description);
131: End If;
132: End Loop;

Line 134: fnd_file.put_line(fnd_file.log,

130: ||element_details_tab(i).description);
131: End If;
132: End Loop;
133: Else
134: fnd_file.put_line(fnd_file.log,
135: 'Element_details_tab.count : '||Element_details_tab.count
136: );
137: End If;
138: End Update_scheme_type;

Line 144: fnd_file.put_line(fnd_file.log,

140:
141: BEGIN --process_scheme_type
142:
143: --write parameters to log file
144: fnd_file.put_line(fnd_file.log,
145: 'Business Group id : '||p_business_group_id);
146: fnd_file.put_line(fnd_file.log,'Execution Mode : '||p_execution_mode);
147:
148:

Line 146: fnd_file.put_line(fnd_file.log,'Execution Mode : '||p_execution_mode);

142:
143: --write parameters to log file
144: fnd_file.put_line(fnd_file.log,
145: 'Business Group id : '||p_business_group_id);
146: fnd_file.put_line(fnd_file.log,'Execution Mode : '||p_execution_mode);
147:
148:
149: select name
150: into l_bg_name

Line 155: fnd_file.put_line(fnd_file.output,'Business Group Name : '||l_bg_name);

151: from per_business_groups_perf
152: where business_group_id = p_business_group_id;
153:
154:
155: fnd_file.put_line(fnd_file.output,'Business Group Name : '||l_bg_name);
156: fnd_file.new_line(fnd_file.output,2);
157:
158: if p_execution_mode ='PRINT'
159: then

Line 156: fnd_file.new_line(fnd_file.output,2);

152: where business_group_id = p_business_group_id;
153:
154:
155: fnd_file.put_line(fnd_file.output,'Business Group Name : '||l_bg_name);
156: fnd_file.new_line(fnd_file.output,2);
157:
158: if p_execution_mode ='PRINT'
159: then
160: print_details;