DBA Data[Home] [Help]

APPS.PAY_PAYMENT_GL_ACCOUNTS_PKG dependencies on PAY_PAYMENT_GL_ACCOUNTS_PKG

Line 1: package body PAY_PAYMENT_GL_ACCOUNTS_PKG as

1: package body PAY_PAYMENT_GL_ACCOUNTS_PKG as
2: /* $Header: pypga01t.pkb 120.0 2005/09/29 10:51 tvankayl noship $ */
3:
4: procedure INSERT_ROW (
5: P_PAY_GL_ACCOUNT_ID OUT NOCOPY NUMBER,

Line 30: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW';

26: l_effective_end_date date;
27: l_ovn number;
28: l_esd_out date;
29: l_eed_out date;
30: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.INSERT_ROW';
31: --
32: begin
33: --
34:

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 197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';

193: l_def_gl_cash_clearing_ac_id pay_payment_gl_accounts_f.gl_cash_clearing_ac_id%type;
194: l_def_gl_control_ac_id pay_payment_gl_accounts_f.gl_control_ac_id%type;
195: l_def_gl_error_ac_id pay_payment_gl_accounts_f.gl_error_ac_id%type;
196: l_seq_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
197: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.UPDATE_ROW';
198: --
199: cursor csr_ovn (p_gl_acct_id number, p_effective_date date) is
200: select object_version_number
201: from pay_payment_gl_accounts_f

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 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 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 533: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DELETE_ROW';

529: l_pay_gl_account_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
530: l_ovn pay_payment_gl_accounts_f.object_version_number%type;
531: l_esd_out date;
532: l_eed_out date;
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);

Line 576: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.DEFAULT_GL_ACCOUNTS';

572: from pay_payment_gl_accounts_f pga
573: where pga.external_account_id = p_external_account_id;
574: --
575: l_def_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
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);

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 623: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.OPM_GL_ACCOUNTS';

619: from pay_payment_gl_accounts_f pga
620: where pga.org_payment_method_id = p_org_payment_method_id;
621: --
622: l_opm_gl_acct_id pay_payment_gl_accounts_f.pay_gl_account_id%type;
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);

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 682: l_proc varchar2(100) := 'PAY_PAYMENT_GL_ACCOUNTS_PKG.GET_GL_ACCOUNTS';

678: select name, chart_of_accounts_id
679: from gl_sets_of_books
680: where set_of_books_id = p_set_of_books_id;
681: --
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);

Line 715: end PAY_PAYMENT_GL_ACCOUNTS_PKG;

711: --
712: END GET_GL_ACCOUNTS;
713:
714:
715: end PAY_PAYMENT_GL_ACCOUNTS_PKG;
716: