DBA Data[Home] [Help]

APPS.PAY_JP_ITW_REPORT_ARCHIVE dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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