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_CN_ENTRY_VALUE_LEG_HOOK dependencies on HR_CN_API

Line 9: g_token_name hr_cn_api.char_tab_type;

5: --
6: g_package CONSTANT VARCHAR2(100) := 'pay_cn_entry_value_leg_hook.' ;
7: g_debug BOOLEAN ;
8: g_message_name VARCHAR2(30);
9: g_token_name hr_cn_api.char_tab_type;
10: g_token_value hr_cn_api.char_tab_type;
11:
12: --------------------------------------------------------------------------
13: -- --

Line 10: g_token_value hr_cn_api.char_tab_type;

6: g_package CONSTANT VARCHAR2(100) := 'pay_cn_entry_value_leg_hook.' ;
7: g_debug BOOLEAN ;
8: g_message_name VARCHAR2(30);
9: g_token_name hr_cn_api.char_tab_type;
10: g_token_value hr_cn_api.char_tab_type;
11:
12: --------------------------------------------------------------------------
13: -- --
14: -- Name : CHECK_EE_PHF_SI_SETUP --

Line 50: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

46: ,p_entry_information8 IN VARCHAR2
47: ,p_entry_information9 IN VARCHAR2
48: ,p_calling_procedure IN VARCHAR2
49: ,p_message_name OUT NOCOPY VARCHAR2
50: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
51: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
52: )
53: IS
54: l_procedure VARCHAR2(100);

Line 51: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

47: ,p_entry_information9 IN VARCHAR2
48: ,p_calling_procedure IN VARCHAR2
49: ,p_message_name OUT NOCOPY VARCHAR2
50: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
51: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
52: )
53: IS
54: l_procedure VARCHAR2(100);
55: BEGIN

Line 59: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);

55: BEGIN
56:
57: l_procedure := g_package||'check_ee_phf_si_setup';
58: g_debug := hr_utility.debug_enabled;
59: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
60:
61: IF g_debug THEN
62: hr_utility.trace('====================================================================');
63: hr_utility.trace('p_message_name '||p_message_name);

Line 82: hr_cn_api.set_location(g_debug,l_procedure,20);

78: hr_utility.trace('====================================================================');
79: END IF;
80:
81: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
82: hr_cn_api.set_location(g_debug,l_procedure,20);
83: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
84: p_token_name(1) := 'FIELD1';
85: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
86: p_token_name(2) := 'FIELD2';

Line 85: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

81: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
82: hr_cn_api.set_location(g_debug,l_procedure,20);
83: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
84: p_token_name(1) := 'FIELD1';
85: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
86: p_token_name(2) := 'FIELD2';
87: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
88:
89: IF g_debug THEN

Line 87: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

83: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
84: p_token_name(1) := 'FIELD1';
85: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
86: p_token_name(2) := 'FIELD2';
87: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
88:
89: IF g_debug THEN
90: hr_utility.trace('====================================================================');
91: hr_utility.trace('p_message_name '||p_message_name);

Line 99: hr_cn_api.set_location(g_debug,l_procedure,30);

95: RETURN;
96: END IF;
97:
98: IF (p_entry_information3 IS NOT NULL AND p_entry_information2 IS NULL) THEN
99: hr_cn_api.set_location(g_debug,l_procedure,30);
100: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
101: p_token_name(1) := 'FIELD1';
102: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
103: p_token_name(2) := 'FIELD2';

Line 102: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

98: IF (p_entry_information3 IS NOT NULL AND p_entry_information2 IS NULL) THEN
99: hr_cn_api.set_location(g_debug,l_procedure,30);
100: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
101: p_token_name(1) := 'FIELD1';
102: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
103: p_token_name(2) := 'FIELD2';
104: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
105:
106: IF g_debug THEN

Line 104: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

100: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
101: p_token_name(1) := 'FIELD1';
102: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
103: p_token_name(2) := 'FIELD2';
104: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
105:
106: IF g_debug THEN
107: hr_utility.trace('====================================================================');
108: hr_utility.trace('p_message_name '||p_message_name);

Line 116: hr_cn_api.set_location(g_debug,l_procedure,40);

112: RETURN;
113: END IF;
114:
115: IF (p_entry_information4 IS NOT NULL AND p_entry_information5 IS NULL) THEN
116: hr_cn_api.set_location(g_debug,l_procedure,40);
117: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
118: p_token_name(1) := 'FIELD1';
119: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
120: p_token_name(2) := 'FIELD2';

Line 119: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

115: IF (p_entry_information4 IS NOT NULL AND p_entry_information5 IS NULL) THEN
116: hr_cn_api.set_location(g_debug,l_procedure,40);
117: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
118: p_token_name(1) := 'FIELD1';
119: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
120: p_token_name(2) := 'FIELD2';
121: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
122:
123: IF g_debug THEN

Line 121: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

117: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
118: p_token_name(1) := 'FIELD1';
119: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
120: p_token_name(2) := 'FIELD2';
121: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
122:
123: IF g_debug THEN
124: hr_utility.trace('====================================================================');
125: hr_utility.trace('p_message_name '||p_message_name);

Line 133: hr_cn_api.set_location(g_debug,l_procedure,50);

129: RETURN;
130: END IF;
131:
132: IF (p_entry_information5 IS NOT NULL AND p_entry_information4 IS NULL) THEN
133: hr_cn_api.set_location(g_debug,l_procedure,50);
134: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
135: p_token_name(1) := 'FIELD1';
136: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
137: p_token_name(2) := 'FIELD2';

Line 136: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

132: IF (p_entry_information5 IS NOT NULL AND p_entry_information4 IS NULL) THEN
133: hr_cn_api.set_location(g_debug,l_procedure,50);
134: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
135: p_token_name(1) := 'FIELD1';
136: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
137: p_token_name(2) := 'FIELD2';
138: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
139:
140: IF g_debug THEN

Line 138: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

134: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
135: p_token_name(1) := 'FIELD1';
136: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
137: p_token_name(2) := 'FIELD2';
138: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Rate or Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
139:
140: IF g_debug THEN
141: hr_utility.trace('====================================================================');
142: hr_utility.trace('p_message_name '||p_message_name);

Line 150: hr_cn_api.set_location(g_debug,l_procedure,60);

146: RETURN;
147: END IF;
148:
149: IF (p_entry_information6 = 'FIXED' AND p_entry_information7 IS NULL) THEN
150: hr_cn_api.set_location(g_debug,l_procedure,60);
151: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
152: p_token_name(1) := 'FIELD1';
153: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
154: p_token_name(2) := 'FIELD2';

Line 153: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

149: IF (p_entry_information6 = 'FIXED' AND p_entry_information7 IS NULL) THEN
150: hr_cn_api.set_location(g_debug,l_procedure,60);
151: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
152: p_token_name(1) := 'FIELD1';
153: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
154: p_token_name(2) := 'FIELD2';
155: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
156:
157: IF g_debug THEN

Line 155: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

151: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
152: p_token_name(1) := 'FIELD1';
153: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
154: p_token_name(2) := 'FIELD2';
155: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
156:
157: IF g_debug THEN
158: hr_utility.trace('====================================================================');
159: hr_utility.trace('p_message_name '||p_message_name);

Line 167: hr_cn_api.set_location(g_debug,l_procedure,70);

163: RETURN;
164: END IF;
165:
166: IF (p_entry_information8 = 'FIXED' AND p_entry_information9 IS NULL) THEN
167: hr_cn_api.set_location(g_debug,l_procedure,70);
168: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
169: p_token_name(1) := 'FIELD1';
170: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
171: p_token_name(2) := 'FIELD2';

Line 170: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

166: IF (p_entry_information8 = 'FIXED' AND p_entry_information9 IS NULL) THEN
167: hr_cn_api.set_location(g_debug,l_procedure,70);
168: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
169: p_token_name(1) := 'FIELD1';
170: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
171: p_token_name(2) := 'FIELD2';
172: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
173:
174: IF g_debug THEN

Line 172: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

168: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
169: p_token_name(1) := 'FIELD1';
170: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
171: p_token_name(2) := 'FIELD2';
172: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
173:
174: IF g_debug THEN
175: hr_utility.trace('====================================================================');
176: hr_utility.trace('p_message_name '||p_message_name);

Line 184: hr_cn_api.set_location(g_debug,l_procedure,110);

180: RETURN;
181: END IF;
182:
183: IF (p_entry_information7 IS NOT NULL AND p_entry_information6 IS NULL) THEN
184: hr_cn_api.set_location(g_debug,l_procedure,110);
185: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
186: p_token_name(1) := 'FIELD1';
187: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
188: p_token_name(2) := 'FIELD2';

Line 187: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

183: IF (p_entry_information7 IS NOT NULL AND p_entry_information6 IS NULL) THEN
184: hr_cn_api.set_location(g_debug,l_procedure,110);
185: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
186: p_token_name(1) := 'FIELD1';
187: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
188: p_token_name(2) := 'FIELD2';
189: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
190:
191: IF g_debug THEN

Line 189: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

185: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
186: p_token_name(1) := 'FIELD1';
187: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
188: p_token_name(2) := 'FIELD2';
189: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
190:
191: IF g_debug THEN
192: hr_utility.trace('====================================================================');
193: hr_utility.trace('p_message_name '||p_message_name);

Line 201: hr_cn_api.set_location(g_debug,l_procedure,120);

197: RETURN;
198: END IF;
199:
200: IF (p_entry_information9 IS NOT NULL AND p_entry_information8 IS NULL) THEN
201: hr_cn_api.set_location(g_debug,l_procedure,120);
202: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
203: p_token_name(1) := 'FIELD1';
204: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
205: p_token_name(2) := 'FIELD2';

Line 204: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

200: IF (p_entry_information9 IS NOT NULL AND p_entry_information8 IS NULL) THEN
201: hr_cn_api.set_location(g_debug,l_procedure,120);
202: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
203: p_token_name(1) := 'FIELD1';
204: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
205: p_token_name(2) := 'FIELD2';
206: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207:
208: IF g_debug THEN

Line 206: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

202: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
203: p_token_name(1) := 'FIELD1';
204: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
205: p_token_name(2) := 'FIELD2';
206: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207:
208: IF g_debug THEN
209: hr_utility.trace('====================================================================');
210: hr_utility.trace('p_message_name '||p_message_name);

Line 218: hr_cn_api.set_location(g_debug,l_procedure,80);

214: RETURN;
215: END IF;
216:
217: IF (p_entry_information6 <> 'FIXED' AND p_entry_information7 IS NOT NULL) THEN
218: hr_cn_api.set_location(g_debug,l_procedure,80);
219: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
220: p_token_name(1) := 'FIELD1';
221: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
222: p_token_name(2) := 'VALUE1';

Line 221: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

217: IF (p_entry_information6 <> 'FIXED' AND p_entry_information7 IS NOT NULL) THEN
218: hr_cn_api.set_location(g_debug,l_procedure,80);
219: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
220: p_token_name(1) := 'FIELD1';
221: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
222: p_token_name(2) := 'VALUE1';
223: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
224: p_token_name(3) := 'FIELD2';
225: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

Line 225: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

221: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
222: p_token_name(2) := 'VALUE1';
223: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
224: p_token_name(3) := 'FIELD2';
225: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
226:
227: IF g_debug THEN
228: hr_utility.trace('====================================================================');
229: hr_utility.trace('p_message_name '||p_message_name);

Line 237: hr_cn_api.set_location(g_debug,l_procedure,90);

233: RETURN;
234: END IF;
235:
236: IF (p_entry_information8 <> 'FIXED' AND p_entry_information9 IS NOT NULL) THEN
237: hr_cn_api.set_location(g_debug,l_procedure,90);
238: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
239: p_token_name(1) := 'FIELD1';
240: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
241: p_token_name(2) := 'VALUE1';

Line 240: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

236: IF (p_entry_information8 <> 'FIXED' AND p_entry_information9 IS NOT NULL) THEN
237: hr_cn_api.set_location(g_debug,l_procedure,90);
238: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
239: p_token_name(1) := 'FIELD1';
240: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
241: p_token_name(2) := 'VALUE1';
242: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
243: p_token_name(3) := 'FIELD2';
244: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

Line 244: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

240: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
241: p_token_name(2) := 'VALUE1';
242: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
243: p_token_name(3) := 'FIELD2';
244: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
245:
246: IF g_debug THEN
247: hr_utility.trace('====================================================================');
248: hr_utility.trace('p_message_name '||p_message_name);

Line 255: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,130);

251:
252: RETURN;
253: END IF;
254:
255: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,130);
256: RETURN;
257: END check_ee_phf_si_setup;
258:
259: --------------------------------------------------------------------------

Line 299: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

295: ,p_entry_information8 IN VARCHAR2
296: ,p_entry_information9 IN VARCHAR2
297: ,p_calling_procedure IN VARCHAR2
298: ,p_message_name OUT NOCOPY VARCHAR2
299: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
300: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
301: )
302: IS
303:

Line 300: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

296: ,p_entry_information9 IN VARCHAR2
297: ,p_calling_procedure IN VARCHAR2
298: ,p_message_name OUT NOCOPY VARCHAR2
299: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
300: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
301: )
302: IS
303:
304: l_procedure VARCHAR2(100);

Line 310: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);

306:
307: BEGIN
308: l_procedure := g_package||'check_eff_date';
309: g_debug := hr_utility.debug_enabled;
310: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
311:
312: IF g_debug THEN
313: hr_utility.trace('====================================================================');
314: hr_utility.trace('p_effective_start_date'||p_effective_start_date);

Line 337: hr_cn_api.set_location(g_debug,l_procedure,30);

333: p_entry_information8 IS NOT NULL OR
334: p_entry_information9 IS NOT NULL ) AND
335: p_effective_start_date < l_stat_upd_eff_date) THEN
336:
337: hr_cn_api.set_location(g_debug,l_procedure,30);
338: p_message_name := 'HR_374626_EFF_DATE_WRONG';
339: p_token_name(1) := 'DATE';
340: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
341:

Line 348: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);

344: hr_utility.trace('p_message_name '||p_message_name);
345: hr_utility.trace('====================================================================');
346: END IF;
347:
348: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
349: RETURN;
350: END IF;
351:
352: END check_eff_date;

Line 399: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

395: ,p_entry_information8 IN VARCHAR2
396: ,p_entry_information9 IN VARCHAR2
397: ,p_calling_procedure IN VARCHAR2
398: ,p_message_name OUT NOCOPY VARCHAR2
399: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
400: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
401: )
402: IS
403:

Line 400: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

396: ,p_entry_information9 IN VARCHAR2
397: ,p_calling_procedure IN VARCHAR2
398: ,p_message_name OUT NOCOPY VARCHAR2
399: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
400: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
401: )
402: IS
403:
404: CURSOR csr_check_element(p_element_entry_id NUMBER

Line 438: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);

434:
435: BEGIN
436: l_procedure := g_package||'check_entry_value_int';
437: g_debug := hr_utility.debug_enabled;
438: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
439:
440: IF g_debug THEN
441: hr_utility.trace('====================================================================');
442: hr_utility.trace('p_effective_date '||p_effective_date );

Line 467: hr_cn_api.set_location(g_debug,l_procedure,20);

463: FETCH csr_check_element INTO l_check_element, l_element_name;
464: CLOSE csr_check_element;
465:
466: IF (l_check_element = 0) THEN
467: hr_cn_api.set_location(g_debug,l_procedure,20);
468: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,25);
469: RETURN;
470:
471: ELSIF (l_check_element = 2) THEN

Line 468: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,25);

464: CLOSE csr_check_element;
465:
466: IF (l_check_element = 0) THEN
467: hr_cn_api.set_location(g_debug,l_procedure,20);
468: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,25);
469: RETURN;
470:
471: ELSIF (l_check_element = 2) THEN
472:

Line 473: hr_cn_api.set_location(g_debug,l_procedure,30);

469: RETURN;
470:
471: ELSIF (l_check_element = 2) THEN
472:
473: hr_cn_api.set_location(g_debug,l_procedure,30);
474: IF (p_entry_information2 IS NOT NULL OR
475: p_entry_information3 IS NOT NULL OR
476: p_entry_information4 IS NOT NULL OR
477: p_entry_information5 IS NOT NULL OR

Line 495: hr_cn_api.set_location(g_debug,l_procedure,30);

491: END IF;
492: END IF;
493:
494: ELSIF (l_check_element = 1) THEN
495: hr_cn_api.set_location(g_debug,l_procedure,30);
496: check_ee_phf_si_setup(
497: p_entry_information2 => p_entry_information2
498: ,p_entry_information3 => p_entry_information3
499: ,p_entry_information4 => p_entry_information4

Line 539: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);

535: hr_utility.trace('====================================================================');
536: END IF;
537:
538: END IF;
539: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
540: RETURN;
541:
542: END check_entry_value_int;
543: --------------------------------------------------------------------------

Line 593: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);

589: BEGIN
590: --
591: l_procedure := g_package||'check_entry_value';
592: g_debug := hr_utility.debug_enabled;
593: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
594:
595: IF g_debug THEN
596: hr_utility.trace('====================================================================');
597: hr_utility.trace('p_effective_date '||p_effective_date );

Line 618: hr_cn_api.set_location(g_debug,l_procedure,20);

614: -- Check whether PAY is installed for China Localization
615: --
616: IF hr_utility.chk_product_install('Oracle Payroll','CN') THEN
617:
618: hr_cn_api.set_location(g_debug,l_procedure,20);
619:
620: check_entry_value_int(p_effective_date => p_effective_date
621: ,p_element_entry_id => p_element_entry_id
622: ,p_effective_start_date => p_effective_start_date

Line 645: hr_cn_api.set_location(g_debug,l_procedure,30);

641: hr_utility.trace('====================================================================');
642: END IF;
643:
644: IF g_message_name <> 'SUCCESS' THEN
645: hr_cn_api.set_location(g_debug,l_procedure,30);
646: hr_cn_api.raise_message(800
647: ,g_message_name
648: ,g_token_name
649: ,g_token_value);

Line 646: hr_cn_api.raise_message(800

642: END IF;
643:
644: IF g_message_name <> 'SUCCESS' THEN
645: hr_cn_api.set_location(g_debug,l_procedure,30);
646: hr_cn_api.raise_message(800
647: ,g_message_name
648: ,g_token_name
649: ,g_token_value);
650: END IF;

Line 655: hr_cn_api.set_location(g_debug,'Leaving : '||l_procedure, 40);

651:
652: END IF ;
653:
654:
655: hr_cn_api.set_location(g_debug,'Leaving : '||l_procedure, 40);
656:
657: END check_entry_value;
658:
659: END pay_cn_entry_value_leg_hook;