DBA Data[Home] [Help]

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 51: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

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

Line 52: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

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

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

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

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

79: hr_utility.trace('====================================================================');
80: END IF;
81:
82: IF (p_entry_information2 IS NOT NULL AND p_entry_information3 IS NULL) THEN
83: hr_cn_api.set_location(g_debug,l_procedure,20);
84: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
85: p_token_name(1) := 'FIELD1';
86: 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');
87: p_token_name(2) := 'FIELD2';

Line 86: 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');

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

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

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

Line 96: hr_cn_api.raise_message(800

92: hr_utility.trace('p_message_name '||p_message_name);
93: hr_utility.trace('====================================================================');
94: END IF;
95: /* Raised error message for bug 8838185 */
96: hr_cn_api.raise_message(800
97: ,p_message_name
98: ,p_token_name
99: ,p_token_value);
100: END IF;

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

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

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

102: IF (p_entry_information3 IS NOT NULL AND p_entry_information2 IS NULL) THEN
103: hr_cn_api.set_location(g_debug,l_procedure,30);
104: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
105: p_token_name(1) := 'FIELD1';
106: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
107: p_token_name(2) := 'FIELD2';
108: 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');
109:
110: IF g_debug THEN

Line 108: 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');

104: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
105: p_token_name(1) := 'FIELD1';
106: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
107: p_token_name(2) := 'FIELD2';
108: 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');
109:
110: IF g_debug THEN
111: hr_utility.trace('====================================================================');
112: hr_utility.trace('p_message_name '||p_message_name);

Line 116: hr_cn_api.raise_message(800

112: hr_utility.trace('p_message_name '||p_message_name);
113: hr_utility.trace('====================================================================');
114: END IF;
115: /* Raised error message for bug 8838185 */
116: hr_cn_api.raise_message(800
117: ,p_message_name
118: ,p_token_name
119: ,p_token_value);
120: END IF;

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

119: ,p_token_value);
120: END IF;
121:
122: IF (p_entry_information4 IS NOT NULL AND p_entry_information5 IS NULL) THEN
123: hr_cn_api.set_location(g_debug,l_procedure,40);
124: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
125: p_token_name(1) := 'FIELD1';
126: 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');
127: p_token_name(2) := 'FIELD2';

Line 126: 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');

122: IF (p_entry_information4 IS NOT NULL AND p_entry_information5 IS NULL) THEN
123: hr_cn_api.set_location(g_debug,l_procedure,40);
124: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
125: p_token_name(1) := 'FIELD1';
126: 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');
127: p_token_name(2) := 'FIELD2';
128: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
129:
130: IF g_debug THEN

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

124: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
125: p_token_name(1) := 'FIELD1';
126: 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');
127: p_token_name(2) := 'FIELD2';
128: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
129:
130: IF g_debug THEN
131: hr_utility.trace('====================================================================');
132: hr_utility.trace('p_message_name '||p_message_name);

Line 136: hr_cn_api.raise_message(800

132: hr_utility.trace('p_message_name '||p_message_name);
133: hr_utility.trace('====================================================================');
134: END IF;
135: /* Raised error message for bug 8838185 */
136: hr_cn_api.raise_message(800
137: ,p_message_name
138: ,p_token_name
139: ,p_token_value);
140: END IF;

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

139: ,p_token_value);
140: END IF;
141:
142: IF (p_entry_information5 IS NOT NULL AND p_entry_information4 IS NULL) THEN
143: hr_cn_api.set_location(g_debug,l_procedure,50);
144: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
145: p_token_name(1) := 'FIELD1';
146: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
147: p_token_name(2) := 'FIELD2';

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

142: IF (p_entry_information5 IS NOT NULL AND p_entry_information4 IS NULL) THEN
143: hr_cn_api.set_location(g_debug,l_procedure,50);
144: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
145: p_token_name(1) := 'FIELD1';
146: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
147: p_token_name(2) := 'FIELD2';
148: 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');
149:
150: IF g_debug THEN

Line 148: 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');

144: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
145: p_token_name(1) := 'FIELD1';
146: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Percent or Fixed', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
147: p_token_name(2) := 'FIELD2';
148: 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');
149:
150: IF g_debug THEN
151: hr_utility.trace('====================================================================');
152: hr_utility.trace('p_message_name '||p_message_name);

Line 156: hr_cn_api.raise_message(800

152: hr_utility.trace('p_message_name '||p_message_name);
153: hr_utility.trace('====================================================================');
154: END IF;
155: /* Raised error message for bug 8838185 */
156: hr_cn_api.raise_message(800
157: ,p_message_name
158: ,p_token_name
159: ,p_token_value);
160: END IF;

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

159: ,p_token_value);
160: END IF;
161:
162: IF (p_entry_information6 = 'FIXED' AND p_entry_information7 IS NULL) THEN
163: hr_cn_api.set_location(g_debug,l_procedure,60);
164: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
165: p_token_name(1) := 'FIELD1';
166: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
167: p_token_name(2) := 'FIELD2';

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

162: IF (p_entry_information6 = 'FIXED' AND p_entry_information7 IS NULL) THEN
163: hr_cn_api.set_location(g_debug,l_procedure,60);
164: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
165: p_token_name(1) := 'FIELD1';
166: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
167: p_token_name(2) := 'FIELD2';
168: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
169:
170: IF g_debug THEN

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

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

Line 176: hr_cn_api.raise_message(800

172: hr_utility.trace('p_message_name '||p_message_name);
173: hr_utility.trace('====================================================================');
174: END IF;
175: /* Raised error message for bug 8838185 */
176: hr_cn_api.raise_message(800
177: ,p_message_name
178: ,p_token_name
179: ,p_token_value);
180: END IF;

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

179: ,p_token_value);
180: END IF;
181:
182: IF (p_entry_information8 = 'FIXED' AND p_entry_information9 IS NULL) THEN
183: hr_cn_api.set_location(g_debug,l_procedure,70);
184: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
185: p_token_name(1) := 'FIELD1';
186: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
187: p_token_name(2) := 'FIELD2';

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

182: IF (p_entry_information8 = 'FIXED' AND p_entry_information9 IS NULL) THEN
183: hr_cn_api.set_location(g_debug,l_procedure,70);
184: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
185: p_token_name(1) := 'FIELD1';
186: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
187: p_token_name(2) := 'FIELD2';
188: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
189:
190: IF g_debug THEN

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

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

Line 196: hr_cn_api.raise_message(800

192: hr_utility.trace('p_message_name '||p_message_name);
193: hr_utility.trace('====================================================================');
194: END IF;
195: /* Raised error message for bug 8838185 */
196: hr_cn_api.raise_message(800
197: ,p_message_name
198: ,p_token_name
199: ,p_token_value);
200: END IF;

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

199: ,p_token_value);
200: END IF;
201:
202: IF (p_entry_information7 IS NOT NULL AND p_entry_information6 IS NULL) THEN
203: hr_cn_api.set_location(g_debug,l_procedure,110);
204: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
205: p_token_name(1) := 'FIELD1';
206: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207: p_token_name(2) := 'FIELD2';

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

202: IF (p_entry_information7 IS NOT NULL AND p_entry_information6 IS NULL) THEN
203: hr_cn_api.set_location(g_debug,l_procedure,110);
204: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
205: p_token_name(1) := 'FIELD1';
206: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
207: p_token_name(2) := 'FIELD2';
208: p_token_value(2) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
209:
210: IF g_debug THEN

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

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

Line 216: hr_cn_api.raise_message(800

212: hr_utility.trace('p_message_name '||p_message_name);
213: hr_utility.trace('====================================================================');
214: END IF;
215: /* Raised error message for bug 8838185 */
216: hr_cn_api.raise_message(800
217: ,p_message_name
218: ,p_token_name
219: ,p_token_value);
220: END IF;

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

219: ,p_token_value);
220: END IF;
221:
222: IF (p_entry_information9 IS NOT NULL AND p_entry_information8 IS NULL) THEN
223: hr_cn_api.set_location(g_debug,l_procedure,120);
224: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
225: p_token_name(1) := 'FIELD1';
226: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
227: p_token_name(2) := 'FIELD2';

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

222: IF (p_entry_information9 IS NOT NULL AND p_entry_information8 IS NULL) THEN
223: hr_cn_api.set_location(g_debug,l_procedure,120);
224: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
225: p_token_name(1) := 'FIELD1';
226: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
227: p_token_name(2) := 'FIELD2';
228: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
229:
230: IF g_debug THEN

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

224: p_message_name := 'HR_374622_DPND_FIELD_ABSENT';
225: p_token_name(1) := 'FIELD1';
226: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
227: p_token_name(2) := 'FIELD2';
228: p_token_value(2) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
229:
230: IF g_debug THEN
231: hr_utility.trace('====================================================================');
232: hr_utility.trace('p_message_name '||p_message_name);

Line 236: hr_cn_api.raise_message(800

232: hr_utility.trace('p_message_name '||p_message_name);
233: hr_utility.trace('====================================================================');
234: END IF;
235: /* Raised error message for bug 8838185 */
236: hr_cn_api.raise_message(800
237: ,p_message_name
238: ,p_token_name
239: ,p_token_value);
240: END IF;

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

239: ,p_token_value);
240: END IF;
241:
242: IF (p_entry_information6 <> 'FIXED' AND p_entry_information7 IS NOT NULL) THEN
243: hr_cn_api.set_location(g_debug,l_procedure,80);
244: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
245: p_token_name(1) := 'FIELD1';
246: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
247: p_token_name(2) := 'VALUE1';

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

242: IF (p_entry_information6 <> 'FIXED' AND p_entry_information7 IS NOT NULL) THEN
243: hr_cn_api.set_location(g_debug,l_procedure,80);
244: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
245: p_token_name(1) := 'FIELD1';
246: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
247: p_token_name(2) := 'VALUE1';
248: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
249: p_token_name(3) := 'FIELD2';
250: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

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

246: p_token_value(1) := hr_cn_api.get_dff_tl_value('EE Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
247: p_token_name(2) := 'VALUE1';
248: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
249: p_token_name(3) := 'FIELD2';
250: p_token_value(3) := hr_cn_api.get_dff_tl_value('EE Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
251:
252: IF g_debug THEN
253: hr_utility.trace('====================================================================');
254: hr_utility.trace('p_message_name '||p_message_name);

Line 258: hr_cn_api.raise_message(800

254: hr_utility.trace('p_message_name '||p_message_name);
255: hr_utility.trace('====================================================================');
256: END IF;
257: /* Raised error message for bug 8838185 */
258: hr_cn_api.raise_message(800
259: ,p_message_name
260: ,p_token_name
261: ,p_token_value);
262: END IF;

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

261: ,p_token_value);
262: END IF;
263:
264: IF (p_entry_information8 <> 'FIXED' AND p_entry_information9 IS NOT NULL) THEN
265: hr_cn_api.set_location(g_debug,l_procedure,90);
266: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
267: p_token_name(1) := 'FIELD1';
268: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
269: p_token_name(2) := 'VALUE1';

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

264: IF (p_entry_information8 <> 'FIXED' AND p_entry_information9 IS NOT NULL) THEN
265: hr_cn_api.set_location(g_debug,l_procedure,90);
266: p_message_name := 'HR_374623_DPND_FIELD_MISMATCH';
267: p_token_name(1) := 'FIELD1';
268: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
269: p_token_name(2) := 'VALUE1';
270: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
271: p_token_name(3) := 'FIELD2';
272: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');

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

268: p_token_value(1) := hr_cn_api.get_dff_tl_value('ER Cont Base Method', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
269: p_token_name(2) := 'VALUE1';
270: p_token_value(2) := hr_general.decode_lookup('CN_CONT_BASE_CALC_METHOD', 'FIXED');
271: p_token_name(3) := 'FIELD2';
272: p_token_value(3) := hr_cn_api.get_dff_tl_value('ER Fixed Amount', 'Element Entry Developer DF' , 'CN_PHF AND SI INFORMATION');
273:
274: IF g_debug THEN
275: hr_utility.trace('====================================================================');
276: hr_utility.trace('p_message_name '||p_message_name);

Line 280: hr_cn_api.raise_message(800

276: hr_utility.trace('p_message_name '||p_message_name);
277: hr_utility.trace('====================================================================');
278: END IF;
279: /* Raised error message for bug 8838185 */
280: hr_cn_api.raise_message(800
281: ,p_message_name
282: ,p_token_name
283: ,p_token_value);
284: END IF;

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

282: ,p_token_name
283: ,p_token_value);
284: END IF;
285:
286: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,130);
287: RETURN;
288: END check_ee_phf_si_setup;
289:
290: --------------------------------------------------------------------------

Line 330: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

326: ,p_entry_information8 IN VARCHAR2
327: ,p_entry_information9 IN VARCHAR2
328: ,p_calling_procedure IN VARCHAR2
329: ,p_message_name OUT NOCOPY VARCHAR2
330: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
331: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
332: )
333: IS
334:

Line 331: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

327: ,p_entry_information9 IN VARCHAR2
328: ,p_calling_procedure IN VARCHAR2
329: ,p_message_name OUT NOCOPY VARCHAR2
330: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
331: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
332: )
333: IS
334:
335: l_procedure VARCHAR2(100);

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

337:
338: BEGIN
339: l_procedure := g_package||'check_eff_date';
340: g_debug := hr_utility.debug_enabled;
341: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
342:
343: IF g_debug THEN
344: hr_utility.trace('====================================================================');
345: hr_utility.trace('p_effective_start_date'||p_effective_start_date);

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

364: p_entry_information8 IS NOT NULL OR
365: p_entry_information9 IS NOT NULL ) AND
366: p_effective_start_date < l_stat_upd_eff_date) THEN
367:
368: hr_cn_api.set_location(g_debug,l_procedure,30);
369: p_message_name := 'HR_374626_EFF_DATE_WRONG';
370: p_token_name(1) := 'DATE';
371: p_token_value(1) := fnd_date.date_to_displaydate(l_stat_upd_eff_date);
372:

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

375: hr_utility.trace('p_message_name '||p_message_name);
376: hr_utility.trace('====================================================================');
377: END IF;
378:
379: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
380: RETURN;
381: END IF;
382:
383: END check_eff_date;

Line 430: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type

426: ,p_entry_information8 IN VARCHAR2
427: ,p_entry_information9 IN VARCHAR2
428: ,p_calling_procedure IN VARCHAR2
429: ,p_message_name OUT NOCOPY VARCHAR2
430: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
431: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
432: )
433: IS
434:

Line 431: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type

427: ,p_entry_information9 IN VARCHAR2
428: ,p_calling_procedure IN VARCHAR2
429: ,p_message_name OUT NOCOPY VARCHAR2
430: ,p_token_name OUT NOCOPY hr_cn_api.char_tab_type
431: ,p_token_value OUT NOCOPY hr_cn_api.char_tab_type
432: )
433: IS
434:
435: CURSOR csr_check_element(p_element_entry_id NUMBER

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

465:
466: BEGIN
467: l_procedure := g_package||'check_entry_value_int';
468: g_debug := hr_utility.debug_enabled;
469: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
470:
471: IF g_debug THEN
472: hr_utility.trace('====================================================================');
473: hr_utility.trace('p_effective_date '||p_effective_date );

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

494: FETCH csr_check_element INTO l_check_element, l_element_name;
495: CLOSE csr_check_element;
496:
497: IF (l_check_element = 0) THEN
498: hr_cn_api.set_location(g_debug,l_procedure,20);
499: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,25);
500: RETURN;
501:
502: ELSIF (l_check_element = 2) THEN

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

495: CLOSE csr_check_element;
496:
497: IF (l_check_element = 0) THEN
498: hr_cn_api.set_location(g_debug,l_procedure,20);
499: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,25);
500: RETURN;
501:
502: ELSIF (l_check_element = 2) THEN
503:

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

500: RETURN;
501:
502: ELSIF (l_check_element = 2) THEN
503:
504: hr_cn_api.set_location(g_debug,l_procedure,30);
505: IF (p_entry_information2 IS NOT NULL OR
506: p_entry_information3 IS NOT NULL OR
507: p_entry_information4 IS NOT NULL OR
508: p_entry_information5 IS NOT NULL OR

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

522: END IF;
523: END IF;
524:
525: ELSIF (l_check_element = 1) THEN
526: hr_cn_api.set_location(g_debug,l_procedure,30);
527: check_ee_phf_si_setup(
528: p_entry_information2 => p_entry_information2
529: ,p_entry_information3 => p_entry_information3
530: ,p_entry_information4 => p_entry_information4

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

566: hr_utility.trace('====================================================================');
567: END IF;
568:
569: END IF;
570: hr_cn_api.set_location(g_debug,'Leaving: '||l_procedure,40);
571: RETURN;
572:
573: END check_entry_value_int;
574: --------------------------------------------------------------------------

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

620: BEGIN
621: --
622: l_procedure := g_package||'check_entry_value';
623: g_debug := hr_utility.debug_enabled;
624: hr_cn_api.set_location(g_debug, 'Entering: ' || l_procedure, 10);
625:
626: IF g_debug THEN
627: hr_utility.trace('====================================================================');
628: hr_utility.trace('p_effective_date '||p_effective_date );

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

645: -- Check whether PAY is installed for China Localization
646: --
647: IF hr_utility.chk_product_install('Oracle Payroll','CN') THEN
648:
649: hr_cn_api.set_location(g_debug,l_procedure,20);
650:
651: check_entry_value_int(p_effective_date => p_effective_date
652: ,p_element_entry_id => p_element_entry_id
653: ,p_effective_start_date => p_effective_start_date

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

672: hr_utility.trace('====================================================================');
673: END IF;
674:
675: IF g_message_name <> 'SUCCESS' THEN
676: hr_cn_api.set_location(g_debug,l_procedure,30);
677: hr_cn_api.raise_message(800
678: ,g_message_name
679: ,g_token_name
680: ,g_token_value);

Line 677: hr_cn_api.raise_message(800

673: END IF;
674:
675: IF g_message_name <> 'SUCCESS' THEN
676: hr_cn_api.set_location(g_debug,l_procedure,30);
677: hr_cn_api.raise_message(800
678: ,g_message_name
679: ,g_token_name
680: ,g_token_value);
681: END IF;

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

682:
683: END IF ;
684:
685:
686: hr_cn_api.set_location(g_debug,'Leaving : '||l_procedure, 40);
687:
688: END check_entry_value;
689:
690: END pay_cn_entry_value_leg_hook;