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 114: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');

110: l_outputs ff_exec.outputs_t;
111: --
112: BEGIN
113: --
114: fnd_file.put_line(fnd_file.LOG,'Entering chk_is_asg_in_asg_set');
115: l_include_flag := 'N';
116: l_tab_asg_set_amnds := p_tab_asg_set_amnds;
117: -- Check whether the assignment exists in the collection
118: -- first as the static assignment set overrides the

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

118: -- first as the static assignment set overrides the
119: -- criteria one
120: IF l_tab_asg_set_amnds.EXISTS(p_assignment_id)
121: THEN
122: fnd_file.put_line(fnd_file.LOG,'Entered assignment ammendents if block');
123: -- Check whether to include or exclude
124: IF l_tab_asg_set_amnds(p_assignment_id) = 'I'
125: THEN
126: l_include_flag := 'Y';

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

133: -- assignment does not exist in assignment set amendments
134: -- check whether a formula criteria exists for this
135: -- assignment set
136: -- Initialize the formula
137: fnd_file.put_line(fnd_file.LOG,'Entered assignment criteria block');
138: ff_exec.init_formula(p_formula_id => p_formula_id
139: ,p_effective_date => p_effective_date
140: ,p_inputs => l_inputs
141: ,p_outputs => l_outputs

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

139: ,p_effective_date => p_effective_date
140: ,p_inputs => l_inputs
141: ,p_outputs => l_outputs
142: );
143: fnd_file.put_line(fnd_file.LOG,'formula initialized');
144: -- Set the inputs first
145: -- Loop through them to set the contexts
146: FOR i IN l_inputs.FIRST .. l_inputs.LAST
147: LOOP

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

153: l_inputs(i).VALUE := fnd_date.date_to_canonical(p_effective_date);
154: END IF;
155: END LOOP;
156: -- Run the formula
157: fnd_file.put_line(fnd_file.LOG,' before formaula run');
158:
159:
160: ff_exec.run_formula(l_inputs, l_outputs);
161:

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

159:
160: ff_exec.run_formula(l_inputs, l_outputs);
161:
162:
163: fnd_file.put_line(fnd_file.LOG,' aftre formaula run');
164: -- Check whether the assignment has to be included
165: -- by checking the output flag
166:
167:

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

164: -- Check whether the assignment has to be included
165: -- by checking the output flag
166:
167:
168: fnd_file.put_line(fnd_file.LOG,' before outputs for run');
169: FOR i IN l_outputs.FIRST .. l_outputs.LAST
170: LOOP
171: IF l_outputs(i).NAME = 'INCLUDE_FLAG'
172: THEN

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

176: ELSIF l_outputs(i).VALUE = 'N'
177: THEN
178: l_include_flag := 'N';
179: END IF;
180: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
181: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
182: EXIT;
183: END IF;
184:

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

177: THEN
178: l_include_flag := 'N';
179: END IF;
180: fnd_file.put_line(fnd_file.LOG,'p_assignment_id'||p_assignment_id);
181: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
182: EXIT;
183: END IF;
184:
185: END LOOP;

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

188: RETURN l_include_flag;
189: EXCEPTION
190: WHEN OTHERS
191: THEN
192: fnd_file.put_line(fnd_file.LOG,'..'||'SQL-ERRM :'||SQLERRM);
193: END chk_is_asg_in_asg_set;
194:
195:
196:

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

393: ,p_formula_id => l_formula_id
394: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
395:
396: );
397: fnd_file.put_line(fnd_file.LOG,'after get_asg_set_details' );
398:
399:
400: for p60 in c_p60_records(p_53_indicator,
401: cp_start_date,

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

408: p_sort_order) LOOP
409:
410:
411: /*6876894*/
412: fnd_file.put_line(fnd_file.LOG,'assignment_id'||p60.assignment_id);
413: l_flag:='Y';
414: If p_assignment_set_id is not null then
415: l_include_flag := chk_is_asg_in_asg_set(p_assignment_id => p60.assignment_id
416: ,p_formula_id => l_formula_id

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

416: ,p_formula_id => l_formula_id
417: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
418: ,p_effective_date => cp_effective_date
419: );
420: fnd_file.put_line(fnd_file.LOG,'l_include_flag'||l_include_flag);
421: if l_include_flag = 'N' then
422: l_flag:='N';
423: end if;
424: end if;