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_IE_P60XML dependencies on FND_FILE

Line 49: fnd_file.put_line(fnd_file.LOG,'Entering get_asg_set_details');

45:
46: --
47: BEGIN
48: --
49: fnd_file.put_line(fnd_file.LOG,'Entering get_asg_set_details');
50: -- Check whether the assignment set id has a criteria
51: -- if a formula id is attached or check whether this
52: -- is an amendments only
53: l_formula_id := NULL;

Line 56: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');

52: -- is an amendments only
53: l_formula_id := NULL;
54: OPEN csr_get_asg_set_info(p_assignment_set_id);
55: FETCH csr_get_asg_set_info INTO l_formula_id;
56: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');
57: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);
58: IF csr_get_asg_set_info%FOUND
59: THEN
60: -- Criteria exists check for formula id

Line 57: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);

53: l_formula_id := NULL;
54: OPEN csr_get_asg_set_info(p_assignment_set_id);
55: FETCH csr_get_asg_set_info INTO l_formula_id;
56: fnd_file.put_line(fnd_file.LOG,' after csr_get_asg_set_info ');
57: fnd_file.put_line(fnd_file.LOG,' l_formula_id '|| l_formula_id);
58: IF csr_get_asg_set_info%FOUND
59: THEN
60: -- Criteria exists check for formula id
61: IF l_formula_id IS NULL

Line 69: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');

65: hr_utility.raise_error;
66: END IF; -- End if of formula id is null check ...
67: END IF; -- End if of asg criteria row found check ...
68: CLOSE csr_get_asg_set_info;
69: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');
70: OPEN csr_get_asg_amnd(p_assignment_set_id);
71: LOOP
72: FETCH csr_get_asg_amnd INTO l_asg_set_amnds;
73: EXIT WHEN csr_get_asg_amnd%NOTFOUND;

Line 76: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);

72: FETCH csr_get_asg_amnd INTO l_asg_set_amnds;
73: EXIT WHEN csr_get_asg_amnd%NOTFOUND;
74: l_tab_asg_set_amnds(l_asg_set_amnds.assignment_id) :=
75: l_asg_set_amnds.include_or_exclude;
76: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);
77: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);
78: END LOOP;
79: CLOSE csr_get_asg_amnd;
80: p_formula_id := l_formula_id;

Line 77: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);

73: EXIT WHEN csr_get_asg_amnd%NOTFOUND;
74: l_tab_asg_set_amnds(l_asg_set_amnds.assignment_id) :=
75: l_asg_set_amnds.include_or_exclude;
76: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.assignment_id '|| l_asg_set_amnds.assignment_id);
77: fnd_file.put_line(fnd_file.LOG,' l_asg_set_amnds.include_or_exclude '|| l_asg_set_amnds.include_or_exclude);
78: END LOOP;
79: CLOSE csr_get_asg_amnd;
80: p_formula_id := l_formula_id;
81: p_tab_asg_set_amnds := l_tab_asg_set_amnds;

Line 85: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);

81: p_tab_asg_set_amnds := l_tab_asg_set_amnds;
82: EXCEPTION
83: WHEN OTHERS
84: THEN
85: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);
86: END get_asg_set_details;
87:
88:
89:

Line 148: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');

144: l_outputs ff_exec.outputs_t;
145: --
146: BEGIN
147: --
148: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');
149: l_include_flag := 'N';
150: l_tab_asg_set_amnds := p_tab_asg_set_amnds;
151: -- Check whether the assignment exists in the collection
152: -- first as the static assignment set overrides the

Line 156: fnd_file.put_line(fnd_file.LOG,'Entered assignment ammendents if block');

152: -- first as the static assignment set overrides the
153: -- criteria one
154: IF l_tab_asg_set_amnds.EXISTS(p_assignment_id)
155: THEN
156: fnd_file.put_line(fnd_file.LOG,'Entered assignment ammendents if block');
157: -- Check whether to include or exclude
158: IF l_tab_asg_set_amnds(p_assignment_id) = 'I'
159: THEN
160: l_include_flag := 'Y';

Line 171: fnd_file.put_line(fnd_file.LOG,'Entered assignment criteria block');

167: -- assignment does not exist in assignment set amendments
168: -- check whether a formula criteria exists for this
169: -- assignment set
170: -- Initialize the formula
171: fnd_file.put_line(fnd_file.LOG,'Entered assignment criteria block');
172: ff_exec.init_formula(p_formula_id => p_formula_id
173: ,p_effective_date => p_effective_date
174: ,p_inputs => l_inputs
175: ,p_outputs => l_outputs

Line 177: fnd_file.put_line(fnd_file.LOG,'formula initialized');

173: ,p_effective_date => p_effective_date
174: ,p_inputs => l_inputs
175: ,p_outputs => l_outputs
176: );
177: fnd_file.put_line(fnd_file.LOG,'formula initialized');
178: -- Set the inputs first
179: -- Loop through them to set the contexts
180: FOR i IN l_inputs.FIRST .. l_inputs.LAST
181: LOOP

Line 191: fnd_file.put_line(fnd_file.LOG,' before formaula run');

187: l_inputs(i).VALUE := fnd_date.date_to_canonical(p_effective_date);
188: END IF;
189: END LOOP;
190: -- Run the formula
191: fnd_file.put_line(fnd_file.LOG,' before formaula run');
192:
193:
194: ff_exec.run_formula(l_inputs, l_outputs);
195:

Line 197: fnd_file.put_line(fnd_file.LOG,' aftre formaula run');

193:
194: ff_exec.run_formula(l_inputs, l_outputs);
195:
196:
197: fnd_file.put_line(fnd_file.LOG,' aftre formaula run');
198: -- Check whether the assignment has to be included
199: -- by checking the output flag
200:
201:

Line 202: fnd_file.put_line(fnd_file.LOG,' before outputs for run');

198: -- Check whether the assignment has to be included
199: -- by checking the output flag
200:
201:
202: fnd_file.put_line(fnd_file.LOG,' before outputs for run');
203: FOR i IN l_outputs.FIRST .. l_outputs.LAST
204: LOOP
205: IF l_outputs(i).NAME = 'INCLUDE_FLAG'
206: THEN

Line 214: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);

210: ELSIF l_outputs(i).VALUE = 'N'
211: THEN
212: l_include_flag := 'N';
213: END IF;
214: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
215: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
216: EXIT;
217: END IF;
218:

Line 215: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);

211: THEN
212: l_include_flag := 'N';
213: END IF;
214: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
215: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
216: EXIT;
217: END IF;
218:
219: END LOOP;

Line 226: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);

222: RETURN l_include_flag;
223: EXCEPTION
224: WHEN OTHERS
225: THEN
226: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);
227: END chk_is_asg_in_asg_set;
228:
229:
230:

Line 527: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );

523: ,p_formula_id => l_formula_id
524: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
525:
526: );
527: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );
528:
529:
530: for p60 in c_p60_records(p_53_indicator,
531: cp_start_date,

Line 542: fnd_file.put_line(fnd_file.LOG,'assignment_id'||p60.assignment_id);

538: p_sort_order) LOOP
539:
540:
541: /*6876894*/
542: fnd_file.put_line(fnd_file.LOG,'assignment_id'||p60.assignment_id);
543: /* 10277535 start */
544: l_er_address_line1:='';
545: l_er_address_line2:='';
546: l_er_address_line3:='';

Line 556: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);

552: ,p_formula_id => l_formula_id
553: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
554: ,p_effective_date => cp_effective_date
555: );
556: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
557: if l_include_flag = 'N' then
558: l_flag:='N';
559: end if;
560: end if;

Line 564: fnd_file.put_line(fnd_file.LOG,'P60 Location id not null' || p60.asg_location_id);

560: end if;
561: IF(l_flag='Y') THEN
562: /* 10277535 start */
563: IF p60.asg_location_id IS NOT NULL THEN
564: fnd_file.put_line(fnd_file.LOG,'P60 Location id not null' || p60.asg_location_id);
565: OPEN csr_asg_empr_location(p60.asg_location_id);
566: FETCH csr_asg_empr_location INTO r_asg_empr_location;
567: CLOSE csr_asg_empr_location;
568:

Line 573: fnd_file.put_line(fnd_file.LOG,'P60 Address lines set');

569: l_er_address_line1 := test_XML(r_asg_empr_location.address_line1);
570: l_er_address_line2 := test_XML(r_asg_empr_location.address_line2);
571: l_er_address_line3 := test_XML(r_asg_empr_location.address_line3);
572: l_er_loc_name := test_XML(r_asg_empr_location.Location_name);
573: fnd_file.put_line(fnd_file.LOG,'P60 Address lines set');
574: ELSE
575: l_er_address_line1 := test_XML(p60.address_line1);
576: l_er_address_line2 := test_XML(p60.address_line2);
577: l_er_address_line3 := test_XML(p60.address_line3);

Line 579: fnd_file.put_line(fnd_file.LOG,'P60 Location id is null');

575: l_er_address_line1 := test_XML(p60.address_line1);
576: l_er_address_line2 := test_XML(p60.address_line2);
577: l_er_address_line3 := test_XML(p60.address_line3);
578: l_er_loc_name := test_XML(p60.Location_name);
579: fnd_file.put_line(fnd_file.LOG,'P60 Location id is null');
580: END IF;
581: --11674153
582: OPEN csr_org_name(p_business_group_id, p60.asg_org_id, cp_effective_date);
583: FETCH csr_org_name INTO l_asg_org_name;