DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_REPORT_ARCH_PKG dependencies on HR_UTILITY

Line 93: hr_utility.set_location('Entering '||c_proc,1);

89: ,chr(0));
90: end submit_payjpitw_archive;
91: begin
92: --
93: hr_utility.set_location('Entering '||c_proc,1);
94: --
95: retcode := 0;
96: --
97: -- Read the value from REQUEST_DATA. If this is the

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

106: if l_request_id = -1 then
107: return;
108: end if;
109: --
110: hr_utility.set_location(c_proc, 20);
111: --
112: if p_run_pre_tax_archive = 'Y' then
113: if l_request_id is NULL THEN
114: hr_utility.set_location(c_proc, 30);

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

110: hr_utility.set_location(c_proc, 20);
111: --
112: if p_run_pre_tax_archive = 'Y' then
113: if l_request_id is NULL THEN
114: hr_utility.set_location(c_proc, 30);
115: --
116: -- Submit PAYJPPRT_ARCHIVE
117: --
118: l_request_id := fnd_request.submit_request

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

141: errbuf := fnd_message.get;
142: retcode := 2;
143: return;
144: else
145: hr_utility.trace('Child request PAYJPPRT_ARCHIVE submitted, request_id: ' || l_request_id);
146: --
147: -- Set PAYJPPRT_ARCHIVE request_id as request data.
148: --
149: fnd_conc_global.set_req_globals

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

150: (conc_status => 'PAUSED'
151: ,request_data => fnd_number.number_to_canonical(l_request_id));
152: end if;
153: else
154: hr_utility.set_location(c_proc, 40);
155: hr_utility.trace('PAYJPPRT_ARCHIVE request_id: ' || l_request_id);
156: --
157: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS
158: (request_id => l_request_id

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

151: ,request_data => fnd_number.number_to_canonical(l_request_id));
152: end if;
153: else
154: hr_utility.set_location(c_proc, 40);
155: hr_utility.trace('PAYJPPRT_ARCHIVE request_id: ' || l_request_id);
156: --
157: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS
158: (request_id => l_request_id
159: ,phase => l_rphase

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

168: retcode := 2;
169: return;
170: end if;
171: --
172: hr_utility.trace('Developer Phase = ' || l_dphase);
173: hr_utility.trace('Developer Status = ' || l_dstatus);
174: --
175: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
176: hr_utility.set_location(c_proc, 50);

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

169: return;
170: end if;
171: --
172: hr_utility.trace('Developer Phase = ' || l_dphase);
173: hr_utility.trace('Developer Status = ' || l_dstatus);
174: --
175: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
176: hr_utility.set_location(c_proc, 50);
177: --

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

172: hr_utility.trace('Developer Phase = ' || l_dphase);
173: hr_utility.trace('Developer Status = ' || l_dstatus);
174: --
175: if (l_dphase = 'COMPLETE' and l_dstatus = 'NORMAL') then
176: hr_utility.set_location(c_proc, 50);
177: --
178: select COUNT(1)
179: into l_count
180: from pay_payroll_actions ppa,

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

184: and paa.payroll_action_id = ppa.payroll_action_id
185: and paa.action_status <> 'C';
186: --
187: if (l_count = 0) then
188: hr_utility.set_location(c_proc, 60);
189: --
190: l_request_id := submit_payjpitw_archive;
191: --
192: if (l_request_id = 0) then

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

193: errbuf := fnd_message.get;
194: retcode := 2;
195: return;
196: else
197: hr_utility.trace('Child request PAYJPITW_ARCHIVE submitted: ' || l_request_id);
198: --
199: fnd_conc_global.set_req_globals
200: (conc_status => 'PAUSED'
201: ,request_data => fnd_number.number_to_canonical(-1)

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

214: return;
215: end if;
216: end if;
217: else
218: hr_utility.set_location(c_proc, 70);
219: --
220: l_request_id := submit_payjpitw_archive;
221: --
222: if (l_request_id = 0) then

Line 227: hr_utility.trace('Child request PAYJPIWHT_ARCHIVE submitted: ' || l_request_id);

223: errbuf := fnd_message.get;
224: retcode := 2;
225: return;
226: else
227: hr_utility.trace('Child request PAYJPIWHT_ARCHIVE submitted: ' || l_request_id);
228: --
229: fnd_conc_global.set_req_globals
230: (conc_status => 'PAUSED'
231: ,request_data => fnd_number.number_to_canonical(-1)

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

232: );
233: end if;
234: end if;
235: --
236: hr_utility.set_location('Leaving: ' || c_proc, 80);
237: end submit_request;
238: --
239: END PAY_JP_IWHT_REPORT_ARCH_PKG;