DBA Data[Home] [Help]

APPS.PAY_JP_ITW_REPORT_ARCHIVE dependencies on HR_UTILITY

Line 103: hr_utility.set_location('Entering: ' || c_proc, 10);

99: ,param('PUBLICATION_END_DATE', p_publication_end_date, true)
100: ,chr(0));
101: end submit_payjpitw_archive;
102: begin
103: hr_utility.set_location('Entering: ' || c_proc, 10);
104: --
105: retcode := 0;
106: --
107: -- Read the value from REQUEST_DATA. If this is the

Line 120: hr_utility.set_location(c_proc, 20);

116: if l_request_id = -1 then
117: return;
118: end if;
119: --
120: hr_utility.set_location(c_proc, 20);
121: --
122: if p_run_pre_tax_archive = 'Y' then
123: if l_request_id is NULL THEN
124: hr_utility.set_location(c_proc, 30);

Line 124: hr_utility.set_location(c_proc, 30);

120: hr_utility.set_location(c_proc, 20);
121: --
122: if p_run_pre_tax_archive = 'Y' then
123: if l_request_id is NULL THEN
124: hr_utility.set_location(c_proc, 30);
125: --
126: -- Submit PAYJPPRT_ARCHIVE
127: --
128: l_request_id := fnd_request.submit_request

Line 154: hr_utility.trace('Child request PAYJPPRT_ARCHIVE submitted, request_id: ' || l_request_id);

150: errbuf := fnd_message.get;
151: retcode := 2;
152: return;
153: else
154: hr_utility.trace('Child request PAYJPPRT_ARCHIVE submitted, request_id: ' || l_request_id);
155: --
156: -- Set PAYJPPRT_ARCHIVE request_id as request data.
157: --
158: fnd_conc_global.set_req_globals

Line 163: hr_utility.set_location(c_proc, 40);

159: (conc_status => 'PAUSED'
160: ,request_data => fnd_number.number_to_canonical(l_request_id));
161: end if;
162: else
163: hr_utility.set_location(c_proc, 40);
164: hr_utility.trace('PAYJPPRT_ARCHIVE request_id: ' || l_request_id);
165: --
166: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS
167: (request_id => l_request_id

Line 164: hr_utility.trace('PAYJPPRT_ARCHIVE request_id: ' || l_request_id);

160: ,request_data => fnd_number.number_to_canonical(l_request_id));
161: end if;
162: else
163: hr_utility.set_location(c_proc, 40);
164: hr_utility.trace('PAYJPPRT_ARCHIVE request_id: ' || l_request_id);
165: --
166: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS
167: (request_id => l_request_id
168: ,phase => l_rphase

Line 181: hr_utility.trace('Developer Phase = ' || l_dphase);

177: retcode := 2;
178: return;
179: end if;
180: --
181: hr_utility.trace('Developer Phase = ' || l_dphase);
182: hr_utility.trace('Developer Status = ' || l_dstatus);
183: --
184: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
185: hr_utility.set_location(c_proc, 50);

Line 182: hr_utility.trace('Developer Status = ' || l_dstatus);

178: return;
179: end if;
180: --
181: hr_utility.trace('Developer Phase = ' || l_dphase);
182: hr_utility.trace('Developer Status = ' || l_dstatus);
183: --
184: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
185: hr_utility.set_location(c_proc, 50);
186: --

Line 185: hr_utility.set_location(c_proc, 50);

181: hr_utility.trace('Developer Phase = ' || l_dphase);
182: hr_utility.trace('Developer Status = ' || l_dstatus);
183: --
184: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
185: hr_utility.set_location(c_proc, 50);
186: --
187: select COUNT(1)
188: into l_count
189: from pay_payroll_actions ppa,

Line 197: hr_utility.set_location(c_proc, 60);

193: and paa.payroll_action_id = ppa.payroll_action_id
194: and paa.action_status <> 'C';
195: --
196: if (l_count = 0) then
197: hr_utility.set_location(c_proc, 60);
198: --
199: l_request_id := submit_payjpitw_archive;
200: --
201: if (l_request_id = 0) then

Line 206: hr_utility.trace('Child request PAYJPITW_ARCHIVE submitted: ' || l_request_id);

202: errbuf := fnd_message.get;
203: retcode := 2;
204: return;
205: else
206: hr_utility.trace('Child request PAYJPITW_ARCHIVE submitted: ' || l_request_id);
207: --
208: fnd_conc_global.set_req_globals
209: (conc_status => 'PAUSED'
210: ,request_data => fnd_number.number_to_canonical(-1)

Line 227: hr_utility.set_location(c_proc, 70);

223: return;
224: end if;
225: end if;
226: else
227: hr_utility.set_location(c_proc, 70);
228: --
229: l_request_id := submit_payjpitw_archive;
230: --
231: if (l_request_id = 0) then

Line 236: hr_utility.trace('Child request PAYJPITW_ARCHIVE submitted: ' || l_request_id);

232: errbuf := fnd_message.get;
233: retcode := 2;
234: return;
235: else
236: hr_utility.trace('Child request PAYJPITW_ARCHIVE submitted: ' || l_request_id);
237: --
238: fnd_conc_global.set_req_globals
239: (conc_status => 'PAUSED'
240: ,request_data => fnd_number.number_to_canonical(-1)

Line 245: hr_utility.set_location('Leaving: ' || c_proc, 80);

241: );
242: end if;
243: end if;
244: --
245: hr_utility.set_location('Leaving: ' || c_proc, 80);
246: end submit_request;
247: --
248: END PAY_JP_ITW_REPORT_ARCHIVE;