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_PAYMENT_GL_ACCOUNTS_PKG dependencies on HR_UTILITY

Line 35: hr_utility.set_location('Entering: '|| l_proc, 10);

31: --
32: begin
33: --
34:
35: hr_utility.set_location('Entering: '|| l_proc, 10);
36: hr_utility.set_location('Org Payment Method Id: ' || p_org_payment_method_id, 20);
37:
38: hr_api.mandatory_arg_error
39: (p_api_name => l_proc

Line 36: hr_utility.set_location('Org Payment Method Id: ' || p_org_payment_method_id, 20);

32: begin
33: --
34:
35: hr_utility.set_location('Entering: '|| l_proc, 10);
36: hr_utility.set_location('Org Payment Method Id: ' || p_org_payment_method_id, 20);
37:
38: hr_api.mandatory_arg_error
39: (p_api_name => l_proc
40: ,p_argument => 'ORG_PAYMENT_METHOD_ID'

Line 51: hr_utility.set_location(l_proc, 30);

47: fnd_message.raise_error;
48:
49: end if;
50:
51: hr_utility.set_location(l_proc, 30);
52:
53: l_external_account_id := p_external_account_id;
54: l_org_payment_method_id := p_org_payment_method_id;
55: l_effective_start_date := p_effective_start_date;

Line 64: hr_utility.set_location(l_proc, 40);

60: -- Check if default GL accounts for this bank already exist.
61:
62: -- If default flag is 'Y' then external_account_id must be passed.
63:
64: hr_utility.set_location(l_proc, 40);
65:
66: l_def_gl_acct_id := default_gl_accounts
67: ( p_external_account_id => p_external_account_id );
68:

Line 74: hr_utility.set_location(l_proc, 50);

70:
71: -- Default GL Accounts for the bank exist, validate the data passed in
72: -- and update the default GL Accounts.
73:
74: hr_utility.set_location(l_proc, 50);
75:
76: pay_pga_bus.chk_set_of_books_id
77: (p_set_of_books_id => p_set_of_books_id
78: );

Line 117: hr_utility.set_location(l_proc, 60);

113:
114: -- Default GL Accounts for the bank do not exist
115: -- Create the Default GL Accounts Now.
116:
117: hr_utility.set_location(l_proc, 60);
118:
119: l_org_payment_method_id := null;
120: l_effective_start_date := hr_general.start_of_time;
121: l_effective_end_date := hr_general.end_of_time;

Line 130: hr_utility.set_location(l_proc, 70);

126:
127: -- Default flag is 'N'.
128: -- GL Accounts for the Org Payment method has to be created.
129:
130: hr_utility.set_location(l_proc, 70);
131:
132: l_external_account_id := null;
133:
134: end if;

Line 136: hr_utility.set_location(l_proc, 80);

132: l_external_account_id := null;
133:
134: end if;
135:
136: hr_utility.set_location(l_proc, 80);
137:
138: pay_pga_ins.ins
139: (p_effective_date => trunc(l_effective_start_date)
140: ,p_set_of_books_id => p_set_of_books_id

Line 153: hr_utility.set_location(l_proc, 90);

149: ,p_effective_start_date => l_esd_out
150: ,p_effective_end_date => l_eed_out
151: );
152:
153: hr_utility.set_location(l_proc, 90);
154:
155: if l_esd_out <> l_effective_start_date or
156: l_eed_out <> l_effective_end_date then
157:

Line 158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

154:
155: if l_esd_out <> l_effective_start_date or
156: l_eed_out <> l_effective_end_date then
157:
158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
159: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW');
160: hr_utility.set_message_token('STEP','10');
161: hr_utility.raise_error;
162:

Line 159: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW');

155: if l_esd_out <> l_effective_start_date or
156: l_eed_out <> l_effective_end_date then
157:
158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
159: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW');
160: hr_utility.set_message_token('STEP','10');
161: hr_utility.raise_error;
162:
163: end if;

Line 160: hr_utility.set_message_token('STEP','10');

156: l_eed_out <> l_effective_end_date then
157:
158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
159: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW');
160: hr_utility.set_message_token('STEP','10');
161: hr_utility.raise_error;
162:
163: end if;
164:

Line 161: hr_utility.raise_error;

157:
158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
159: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW');
160: hr_utility.set_message_token('STEP','10');
161: hr_utility.raise_error;
162:
163: end if;
164:
165: hr_utility.set_location('Leaving: '|| l_proc, 100);

Line 165: hr_utility.set_location('Leaving: '|| l_proc, 100);

161: hr_utility.raise_error;
162:
163: end if;
164:
165: hr_utility.set_location('Leaving: '|| l_proc, 100);
166: --
167: end INSERT_ROW;
168:
169: procedure UPDATE_ROW (

Line 224: hr_utility.set_location('Entering: '|| l_proc, 10);

220: --
221: begin
222: --
223:
224: hr_utility.set_location('Entering: '|| l_proc, 10);
225: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
226:
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc

Line 225: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);

221: begin
222: --
223:
224: hr_utility.set_location('Entering: '|| l_proc, 10);
225: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
226:
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc
229: ,p_argument => 'ORG_PAYMENT_METHOD_ID'

Line 240: hr_utility.set_location(l_proc, 30);

236: fnd_message.raise_error;
237:
238: end if;
239:
240: hr_utility.set_location(l_proc, 30);
241:
242: l_opm_gl_acct_id := opm_gl_accounts
243: ( p_org_payment_method_id => p_org_payment_method_id );
244:

Line 248: hr_utility.set_location(l_proc || ' OPM GL ACCOUNT ID: ' || l_opm_gl_acct_id, 40);

244:
245: l_def_gl_acct_id := default_gl_accounts
246: ( p_external_account_id => p_external_account_id );
247:
248: hr_utility.set_location(l_proc || ' OPM GL ACCOUNT ID: ' || l_opm_gl_acct_id, 40);
249: hr_utility.set_location(l_proc || ' DEFAULT GL ACCOUNT ID: ' || l_def_gl_acct_id, 50);
250:
251: if p_default_gl_account = 'Y' then
252:

Line 249: hr_utility.set_location(l_proc || ' DEFAULT GL ACCOUNT ID: ' || l_def_gl_acct_id, 50);

245: l_def_gl_acct_id := default_gl_accounts
246: ( p_external_account_id => p_external_account_id );
247:
248: hr_utility.set_location(l_proc || ' OPM GL ACCOUNT ID: ' || l_opm_gl_acct_id, 40);
249: hr_utility.set_location(l_proc || ' DEFAULT GL ACCOUNT ID: ' || l_def_gl_acct_id, 50);
250:
251: if p_default_gl_account = 'Y' then
252:
253: -- When Default flag is 'Y', GL accounts for the OPM should not exist.

Line 255: hr_utility.set_location(l_proc, 60);

251: if p_default_gl_account = 'Y' then
252:
253: -- When Default flag is 'Y', GL accounts for the OPM should not exist.
254:
255: hr_utility.set_location(l_proc, 60);
256:
257: if l_opm_gl_acct_id is not null then
258:
259: fnd_message.set_name('PAY', 'PAY_33460_OPM_GL_ACT_EXISTS');

Line 264: hr_utility.set_location(l_proc, 70);

260: fnd_message.raise_error;
261:
262: end if;
263:
264: hr_utility.set_location(l_proc, 70);
265:
266: if l_def_gl_acct_id is not null then
267:
268: -- When the default GL Accounts for the bank already exists

Line 271: hr_utility.set_location(l_proc, 80);

267:
268: -- When the default GL Accounts for the bank already exists
269: -- we need to only validate the data and update the record.
270:
271: hr_utility.set_location(l_proc, 80);
272:
273: pay_pga_bus.chk_set_of_books_id
274: (p_set_of_books_id => p_set_of_books_id
275: );

Line 313: hr_utility.set_location(l_proc, 90);

309:
310: -- Default GL Accounts for the bank do not exist
311: -- Create the Default GL Accounts Now.
312:
313: hr_utility.set_location(l_proc, 90);
314:
315: pay_pga_ins.ins
316: (p_effective_date => trunc(hr_general.start_of_time)
317: ,p_set_of_books_id => p_set_of_books_id

Line 332: hr_utility.set_location(l_proc, 100);

328: );
329:
330: p_pay_gl_account_id_out := l_pay_gl_account_id;
331:
332: hr_utility.set_location(l_proc, 100);
333:
334: if l_esd_out <> hr_general.start_of_time and
335: l_eed_out <> hr_general.end_of_time then
336:

Line 337: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

333:
334: if l_esd_out <> hr_general.start_of_time and
335: l_eed_out <> hr_general.end_of_time then
336:
337: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
338: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
339: hr_utility.set_message_token('STEP','10');
340: hr_utility.raise_error;
341:

Line 338: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');

334: if l_esd_out <> hr_general.start_of_time and
335: l_eed_out <> hr_general.end_of_time then
336:
337: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
338: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
339: hr_utility.set_message_token('STEP','10');
340: hr_utility.raise_error;
341:
342: end if;

Line 339: hr_utility.set_message_token('STEP','10');

335: l_eed_out <> hr_general.end_of_time then
336:
337: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
338: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
339: hr_utility.set_message_token('STEP','10');
340: hr_utility.raise_error;
341:
342: end if;
343:

Line 340: hr_utility.raise_error;

336:
337: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
338: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
339: hr_utility.set_message_token('STEP','10');
340: hr_utility.raise_error;
341:
342: end if;
343:
344: end if;

Line 350: hr_utility.set_location(l_proc, 110);

346: else
347:
348: -- Default flag is 'N'. Check if the GL accounts for the OPM exist.
349:
350: hr_utility.set_location(l_proc, 110);
351:
352: if l_opm_gl_acct_id is not null then
353:
354: -- GL Accounts for the OPM exist. Update the record on the effective date.

Line 356: hr_utility.set_location(l_proc, 120);

352: if l_opm_gl_acct_id is not null then
353:
354: -- GL Accounts for the OPM exist. Update the record on the effective date.
355:
356: hr_utility.set_location(l_proc, 120);
357:
358: open csr_ovn (p_gl_acct_id => l_opm_gl_acct_id,
359: p_effective_date => p_effective_start_date);
360: fetch csr_ovn into l_ovn;

Line 379: hr_utility.set_location(l_proc, 130);

375: );
376:
377: p_pay_gl_account_id_out := l_opm_gl_acct_id;
378:
379: hr_utility.set_location(l_proc, 130);
380:
381: if l_esd_out <> p_effective_start_date or
382: l_eed_out <> p_effective_end_date then
383:

Line 384: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

380:
381: if l_esd_out <> p_effective_start_date or
382: l_eed_out <> p_effective_end_date then
383:
384: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
385: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
386: hr_utility.set_message_token('STEP','20');
387: hr_utility.raise_error;
388:

Line 385: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');

381: if l_esd_out <> p_effective_start_date or
382: l_eed_out <> p_effective_end_date then
383:
384: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
385: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
386: hr_utility.set_message_token('STEP','20');
387: hr_utility.raise_error;
388:
389: end if;

Line 386: hr_utility.set_message_token('STEP','20');

382: l_eed_out <> p_effective_end_date then
383:
384: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
385: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
386: hr_utility.set_message_token('STEP','20');
387: hr_utility.raise_error;
388:
389: end if;
390:

Line 387: hr_utility.raise_error;

383:
384: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
385: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
386: hr_utility.set_message_token('STEP','20');
387: hr_utility.raise_error;
388:
389: end if;
390:
391: else

Line 404: hr_utility.set_location(l_proc, 140);

400: close csr_next_seq;
401:
402: l_ovn_seq := 1;
403:
404: hr_utility.set_location(l_proc, 140);
405:
406: for l_rec in csr_opm_rows (p_org_payment_method_id => p_org_payment_method_id ) loop
407:
408: hr_utility.trace('Inserting Row for OPM: ' || p_org_payment_method_id || ' ' || l_rec.effective_start_date || ' ' || l_rec.effective_end_date );

Line 408: hr_utility.trace('Inserting Row for OPM: ' || p_org_payment_method_id || ' ' || l_rec.effective_start_date || ' ' || l_rec.effective_end_date );

404: hr_utility.set_location(l_proc, 140);
405:
406: for l_rec in csr_opm_rows (p_org_payment_method_id => p_org_payment_method_id ) loop
407:
408: hr_utility.trace('Inserting Row for OPM: ' || p_org_payment_method_id || ' ' || l_rec.effective_start_date || ' ' || l_rec.effective_end_date );
409:
410: l_def_gl_cash_ac_id := null;
411: l_def_gl_cash_clearing_ac_id := null;
412: l_def_gl_control_ac_id := null;

Line 425: hr_utility.set_location(l_proc, 141);

421: -- OPM will be the values passed to the UPDATE_ROW procedure
422: -- For other periods, the GL Accounts of the bank the OPM used in that period
423: -- will be populated.
424:
425: hr_utility.set_location(l_proc, 141);
426:
427: open csr_def_gl_accounts(p_ext_gl_id => l_rec.external_account_id,
428: p_effective_date => l_rec.effective_start_date);
429: fetch csr_def_gl_accounts into l_def_gl_cash_ac_id, l_def_gl_cash_clearing_ac_id,

Line 435: hr_utility.set_location(l_proc, 142);

431: close csr_def_gl_accounts;
432:
433: end if;
434:
435: hr_utility.set_location(l_proc, 142);
436:
437: insert into PAY_PAYMENT_GL_ACCOUNTS_F
438: (
439: PAY_GL_ACCOUNT_ID,

Line 470: hr_utility.set_location(l_proc, 143);

466: l_ovn_seq := l_ovn_seq + 1;
467:
468: p_pay_gl_account_id_out := l_seq_id;
469:
470: hr_utility.set_location(l_proc, 143);
471:
472: end loop;
473:
474: hr_utility.set_location(l_proc, 150);

Line 474: hr_utility.set_location(l_proc, 150);

470: hr_utility.set_location(l_proc, 143);
471:
472: end loop;
473:
474: hr_utility.set_location(l_proc, 150);
475:
476: open csr_ovn (p_gl_acct_id => l_seq_id,
477: p_effective_date => p_effective_start_date);
478: fetch csr_ovn into l_ovn;

Line 495: hr_utility.set_location(l_proc, 160);

491: ,p_effective_start_date => l_esd_out
492: ,p_effective_end_date => l_eed_out
493: );
494:
495: hr_utility.set_location(l_proc, 160);
496:
497: if l_esd_out <> p_effective_start_date or
498: l_eed_out <> p_effective_end_date then
499:

Line 500: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

496:
497: if l_esd_out <> p_effective_start_date or
498: l_eed_out <> p_effective_end_date then
499:
500: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
501: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
502: hr_utility.set_message_token('STEP','30');
503: hr_utility.raise_error;
504:

Line 501: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');

497: if l_esd_out <> p_effective_start_date or
498: l_eed_out <> p_effective_end_date then
499:
500: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
501: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
502: hr_utility.set_message_token('STEP','30');
503: hr_utility.raise_error;
504:
505: end if;

Line 502: hr_utility.set_message_token('STEP','30');

498: l_eed_out <> p_effective_end_date then
499:
500: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
501: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
502: hr_utility.set_message_token('STEP','30');
503: hr_utility.raise_error;
504:
505: end if;
506:

Line 503: hr_utility.raise_error;

499:
500: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
501: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW');
502: hr_utility.set_message_token('STEP','30');
503: hr_utility.raise_error;
504:
505: end if;
506:
507: end if;

Line 511: hr_utility.set_location('Leaving: '|| l_proc, 170);

507: end if;
508:
509: end if;
510:
511: hr_utility.set_location('Leaving: '|| l_proc, 170);
512: --
513: end UPDATE_ROW;
514:
515: procedure DELETE_ROW (

Line 537: hr_utility.set_location('Entering: '|| l_proc, 10);

533: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW';
534: --
535: begin
536: --
537: hr_utility.set_location('Entering: '|| l_proc, 10);
538: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
539:
540: open csr_opm_gl_rows;
541: fetch csr_opm_gl_rows into l_pay_gl_account_id, l_ovn;

Line 538: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);

534: --
535: begin
536: --
537: hr_utility.set_location('Entering: '|| l_proc, 10);
538: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
539:
540: open csr_opm_gl_rows;
541: fetch csr_opm_gl_rows into l_pay_gl_account_id, l_ovn;
542:

Line 545: hr_utility.set_location(l_proc, 30);

541: fetch csr_opm_gl_rows into l_pay_gl_account_id, l_ovn;
542:
543: if csr_opm_gl_rows%found then
544:
545: hr_utility.set_location(l_proc, 30);
546:
547: pay_pga_del.del
548: (p_effective_date => trunc(p_effective_date)
549: ,p_datetrack_mode => p_datetrack_mode

Line 556: hr_utility.set_location(l_proc, 40);

552: ,p_effective_start_date => l_esd_out
553: ,p_effective_end_date => l_eed_out
554: );
555:
556: hr_utility.set_location(l_proc, 40);
557:
558: end if;
559:
560: close csr_opm_gl_rows;

Line 562: hr_utility.set_location('Leaving: '|| l_proc, 50);

558: end if;
559:
560: close csr_opm_gl_rows;
561:
562: hr_utility.set_location('Leaving: '|| l_proc, 50);
563: --
564: end DELETE_ROW;
565:
566: function DEFAULT_GL_ACCOUNTS (

Line 580: hr_utility.set_location('Entering: '|| l_proc, 10);

576: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS';
577: --
578: BEGIN
579: --
580: hr_utility.set_location('Entering: '|| l_proc, 10);
581: hr_utility.set_location('External Account Id: '|| l_proc, 20);
582:
583: if p_external_account_id is not null then
584:

Line 581: hr_utility.set_location('External Account Id: '|| l_proc, 20);

577: --
578: BEGIN
579: --
580: hr_utility.set_location('Entering: '|| l_proc, 10);
581: hr_utility.set_location('External Account Id: '|| l_proc, 20);
582:
583: if p_external_account_id is not null then
584:
585: hr_utility.set_location(l_proc, 30);

Line 585: hr_utility.set_location(l_proc, 30);

581: hr_utility.set_location('External Account Id: '|| l_proc, 20);
582:
583: if p_external_account_id is not null then
584:
585: hr_utility.set_location(l_proc, 30);
586: open csr_default_gl_accounts;
587: fetch csr_default_gl_accounts into l_def_gl_acct_id;
588:
589: if csr_default_gl_accounts%ROWCOUNT > 1 then

Line 593: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

589: if csr_default_gl_accounts%ROWCOUNT > 1 then
590:
591: close csr_default_gl_accounts;
592:
593: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS');
595: hr_utility.set_message_token('STEP','10');
596: hr_utility.raise_error;
597:

Line 594: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS');

590:
591: close csr_default_gl_accounts;
592:
593: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS');
595: hr_utility.set_message_token('STEP','10');
596: hr_utility.raise_error;
597:
598: end if;

Line 595: hr_utility.set_message_token('STEP','10');

591: close csr_default_gl_accounts;
592:
593: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS');
595: hr_utility.set_message_token('STEP','10');
596: hr_utility.raise_error;
597:
598: end if;
599:

Line 596: hr_utility.raise_error;

592:
593: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS');
595: hr_utility.set_message_token('STEP','10');
596: hr_utility.raise_error;
597:
598: end if;
599:
600: close csr_default_gl_accounts;

Line 603: hr_utility.set_location(l_proc, 40);

599:
600: close csr_default_gl_accounts;
601:
602: else
603: hr_utility.set_location(l_proc, 40);
604: l_def_gl_acct_id := null;
605: end if;
606:
607: hr_utility.set_location('Leaving: '|| l_proc, 50);

Line 607: hr_utility.set_location('Leaving: '|| l_proc, 50);

603: hr_utility.set_location(l_proc, 40);
604: l_def_gl_acct_id := null;
605: end if;
606:
607: hr_utility.set_location('Leaving: '|| l_proc, 50);
608:
609: return l_def_gl_acct_id;
610: --
611: END DEFAULT_GL_ACCOUNTS;

Line 627: hr_utility.set_location('Entering: '|| l_proc, 10);

623: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS';
624: --
625: BEGIN
626: --
627: hr_utility.set_location('Entering: '|| l_proc, 10);
628: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
629:
630: if p_org_payment_method_id is not null then
631:

Line 628: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);

624: --
625: BEGIN
626: --
627: hr_utility.set_location('Entering: '|| l_proc, 10);
628: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
629:
630: if p_org_payment_method_id is not null then
631:
632: hr_utility.set_location(l_proc, 30);

Line 632: hr_utility.set_location(l_proc, 30);

628: hr_utility.set_location('Org Payment Method Id: '|| p_org_payment_method_id, 20);
629:
630: if p_org_payment_method_id is not null then
631:
632: hr_utility.set_location(l_proc, 30);
633: open csr_opm_gl_accounts;
634: fetch csr_opm_gl_accounts into l_opm_gl_acct_id;
635:
636: if csr_opm_gl_accounts%ROWCOUNT > 1 then

Line 640: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

636: if csr_opm_gl_accounts%ROWCOUNT > 1 then
637:
638: close csr_opm_gl_accounts;
639:
640: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
641: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS');
642: hr_utility.set_message_token('STEP','10');
643: hr_utility.raise_error;
644:

Line 641: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS');

637:
638: close csr_opm_gl_accounts;
639:
640: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
641: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS');
642: hr_utility.set_message_token('STEP','10');
643: hr_utility.raise_error;
644:
645: end if;

Line 642: hr_utility.set_message_token('STEP','10');

638: close csr_opm_gl_accounts;
639:
640: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
641: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS');
642: hr_utility.set_message_token('STEP','10');
643: hr_utility.raise_error;
644:
645: end if;
646:

Line 643: hr_utility.raise_error;

639:
640: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
641: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS');
642: hr_utility.set_message_token('STEP','10');
643: hr_utility.raise_error;
644:
645: end if;
646:
647: close csr_opm_gl_accounts;

Line 650: hr_utility.set_location(l_proc, 40);

646:
647: close csr_opm_gl_accounts;
648:
649: else
650: hr_utility.set_location(l_proc, 40);
651: l_opm_gl_acct_id := null;
652: end if;
653:
654: hr_utility.set_location('Leaving: '|| l_proc, 50);

Line 654: hr_utility.set_location('Leaving: '|| l_proc, 50);

650: hr_utility.set_location(l_proc, 40);
651: l_opm_gl_acct_id := null;
652: end if;
653:
654: hr_utility.set_location('Leaving: '|| l_proc, 50);
655: return l_opm_gl_acct_id;
656: --
657: END OPM_GL_ACCOUNTS;
658:

Line 686: hr_utility.set_location('Entering: '|| l_proc, 10);

682: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.GET_GL_ACCOUNTS';
683: --
684: BEGIN
685: --
686: hr_utility.set_location('Entering: '|| l_proc, 10);
687:
688: if p_pay_gl_account_id is not null then
689:
690: hr_utility.set_location(l_proc, 20);

Line 690: hr_utility.set_location(l_proc, 20);

686: hr_utility.set_location('Entering: '|| l_proc, 10);
687:
688: if p_pay_gl_account_id is not null then
689:
690: hr_utility.set_location(l_proc, 20);
691:
692: open csr_gl_accounts;
693: fetch csr_gl_accounts into p_gl_cash_ac_id, p_gl_cash_clearing_ac_id, p_gl_control_ac_id,
694: p_gl_error_ac_id , p_set_of_books_id ;

Line 699: hr_utility.set_location(l_proc, 30);

695: close csr_gl_accounts;
696:
697: if p_set_of_books_id is not null then
698:
699: hr_utility.set_location(l_proc, 30);
700:
701: open csr_set_of_books_name;
702: fetch csr_set_of_books_name into p_set_of_books_name, p_gl_account_flex_num ;
703: close csr_set_of_books_name;

Line 707: hr_utility.set_location(l_proc, 40);

703: close csr_set_of_books_name;
704:
705: end if;
706:
707: hr_utility.set_location(l_proc, 40);
708:
709: end if;
710: hr_utility.set_location('Leaving: '|| l_proc, 50);
711: --

Line 710: hr_utility.set_location('Leaving: '|| l_proc, 50);

706:
707: hr_utility.set_location(l_proc, 40);
708:
709: end if;
710: hr_utility.set_location('Leaving: '|| l_proc, 50);
711: --
712: END GET_GL_ACCOUNTS;
713:
714: