DBA Data[Home] [Help]

APPS.PAY_JP_DEF_REPORT_PKG dependencies on FND_MESSAGE

Line 12: c_circle varchar2(60) := substr(fnd_message.get_string('PER','HR_JP_CIRCLE'),0,1);

8: c_eol varchar2(30) := fnd_global.local_chr(10);
9: --
10: c_st_upd_date_2011 constant date := to_date('2011/01/01','YYYY/MM/DD');
11: --
12: c_circle varchar2(60) := substr(fnd_message.get_string('PER','HR_JP_CIRCLE'),0,1);
13: c_self varchar2(100) := fnd_message.get_string('PER','HR_JP_SELF');
14: c_husband varchar2(100) := fnd_message.get_string('PER','HR_JP_HUSBAND');
15: c_wife varchar2(100) := fnd_message.get_string('PER','HR_JP_WIFE');
16: --

Line 13: c_self varchar2(100) := fnd_message.get_string('PER','HR_JP_SELF');

9: --
10: c_st_upd_date_2011 constant date := to_date('2011/01/01','YYYY/MM/DD');
11: --
12: c_circle varchar2(60) := substr(fnd_message.get_string('PER','HR_JP_CIRCLE'),0,1);
13: c_self varchar2(100) := fnd_message.get_string('PER','HR_JP_SELF');
14: c_husband varchar2(100) := fnd_message.get_string('PER','HR_JP_HUSBAND');
15: c_wife varchar2(100) := fnd_message.get_string('PER','HR_JP_WIFE');
16: --
17: c_dep_row_cnt number := 5;

Line 14: c_husband varchar2(100) := fnd_message.get_string('PER','HR_JP_HUSBAND');

10: c_st_upd_date_2011 constant date := to_date('2011/01/01','YYYY/MM/DD');
11: --
12: c_circle varchar2(60) := substr(fnd_message.get_string('PER','HR_JP_CIRCLE'),0,1);
13: c_self varchar2(100) := fnd_message.get_string('PER','HR_JP_SELF');
14: c_husband varchar2(100) := fnd_message.get_string('PER','HR_JP_HUSBAND');
15: c_wife varchar2(100) := fnd_message.get_string('PER','HR_JP_WIFE');
16: --
17: c_dep_row_cnt number := 5;
18: c_dep_oe_row_cnt number := 2;

Line 15: c_wife varchar2(100) := fnd_message.get_string('PER','HR_JP_WIFE');

11: --
12: c_circle varchar2(60) := substr(fnd_message.get_string('PER','HR_JP_CIRCLE'),0,1);
13: c_self varchar2(100) := fnd_message.get_string('PER','HR_JP_SELF');
14: c_husband varchar2(100) := fnd_message.get_string('PER','HR_JP_HUSBAND');
15: c_wife varchar2(100) := fnd_message.get_string('PER','HR_JP_WIFE');
16: --
17: c_dep_row_cnt number := 5;
18: c_dep_oe_row_cnt number := 2;
19: c_dep_os_row_cnt number := 2;

Line 92: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');

88: open csr_action;
89: fetch csr_action into l_csr_action;
90: if csr_action%notfound then
91: close csr_action;
92: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
93: fnd_message.raise_error;
94: end if;
95: close csr_action;
96: --

Line 93: fnd_message.raise_error;

89: fetch csr_action into l_csr_action;
90: if csr_action%notfound then
91: close csr_action;
92: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
93: fnd_message.raise_error;
94: end if;
95: close csr_action;
96: --
97: if nvl(g_call_type,'X') = 'SS' then

Line 111: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');

107: open csr_action_arch;
108: fetch csr_action_arch into l_csr_action_arch;
109: if csr_action_arch%notfound then
110: close csr_action_arch;
111: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
112: fnd_message.raise_error;
113: end if;
114: close csr_action_arch;
115: --

Line 112: fnd_message.raise_error;

108: fetch csr_action_arch into l_csr_action_arch;
109: if csr_action_arch%notfound then
110: close csr_action_arch;
111: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
112: fnd_message.raise_error;
113: end if;
114: close csr_action_arch;
115: --
116: g_effective_date := l_csr_action_arch.effective_date;