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.HR_DU_DO_ENTITIES dependencies on HR_DU_UTILITY

Line 63: hr_du_utility.message('ROUT','entry:hr_du_do_entities.create_default_employee',

59:
60:
61: BEGIN
62: --
63: hr_du_utility.message('ROUT','entry:hr_du_do_entities.create_default_employee',
64: 5);
65: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
66: ')(p_upload_id - ' || p_upload_id ||
67: ')(p_batch_id - ' || p_batch_id ||

Line 65: hr_du_utility.message('PARA', '(p_values_table - Record Structure ' ||

61: BEGIN
62: --
63: hr_du_utility.message('ROUT','entry:hr_du_do_entities.create_default_employee',
64: 5);
65: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
66: ')(p_upload_id - ' || p_upload_id ||
67: ')(p_batch_id - ' || p_batch_id ||
68: ')(p_api_module_id - ' || p_api_module_id ||
69: ')(p_process_order - ' || p_process_order ||

Line 76: hr_du_utility.message('INFO','p_upload_line_id : ' || p_upload_line_id, 15);

72: --
73: --Statement extracts the ID number for the particular upload_line_id
74: --that was passed in.
75:
76: hr_du_utility.message('INFO','p_upload_line_id : ' || p_upload_line_id, 15);
77:
78: OPEN csr_line_id;
79: --
80: FETCH csr_line_id INTO l_row_id;

Line 92: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 25);

88: l_parent_user_key := hr_du_do_datapump.RETURN_CREATED_USER_KEY_2(l_row_id,
89: p_values_table.r_api_id, p_upload_line_id,
90: l_foreign_user_key);
91:
92: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 25);
93: hr_du_utility.message('INFO','l_parent_user_key : ' || l_parent_user_key , 30);
94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);
95:
96: hr_du_di_insert.g_current_delimiter := ',';

Line 93: hr_du_utility.message('INFO','l_parent_user_key : ' || l_parent_user_key , 30);

89: p_values_table.r_api_id, p_upload_line_id,
90: l_foreign_user_key);
91:
92: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 25);
93: hr_du_utility.message('INFO','l_parent_user_key : ' || l_parent_user_key , 30);
94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);
95:
96: hr_du_di_insert.g_current_delimiter := ',';
97:

Line 94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);

90: l_foreign_user_key);
91:
92: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 25);
93: hr_du_utility.message('INFO','l_parent_user_key : ' || l_parent_user_key , 30);
94: hr_du_utility.message('INFO','l_foreign_user_key : '||l_foreign_user_key , 35);
95:
96: hr_du_di_insert.g_current_delimiter := ',';
97:
98: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

Line 106: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||

102: /*
103: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
104: p_values_table.r_pval_parent_line_id);
105:
106: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
107: p_values_table.r_pval_parent_line_id , 40);
108: hr_du_utility.message('INFO','l_number_refs : ' || l_number_refs , 45);
109:
110: --check to see if this api_module has any columns that may contain data to

Line 108: hr_du_utility.message('INFO','l_number_refs : ' || l_number_refs , 45);

104: p_values_table.r_pval_parent_line_id);
105:
106: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
107: p_values_table.r_pval_parent_line_id , 40);
108: hr_du_utility.message('INFO','l_number_refs : ' || l_number_refs , 45);
109:
110: --check to see if this api_module has any columns that may contain data to
111: --indicate that it has been called by another api_module
112:

Line 133: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||

129:
130: l_parent_api_module_number := hr_du_di_insert.Return_Word(
131: p_values_table.r_parent_api_module_number , j);
132:
133: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
134: l_pval_parent_line_id , 50);
135: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
136: l_parent_api_module_number , 55);
137:

Line 135: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

131: p_values_table.r_parent_api_module_number , j);
132:
133: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
134: l_pval_parent_line_id , 50);
135: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
136: l_parent_api_module_number , 55);
137:
138:
139: --check to see if referencing column is a generic reference. If null

Line 147: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 65);

143: l_temp_id := hr_du_dp_pc_conversion.return_field_value
144: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
145: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
146:
147: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 65);
148:
149: --Check to see if there's a value with in the reference column of
150: --the api_module
151: IF l_temp_id IS NOT NULL THEN

Line 156: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 70);

152: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
153: l_parent_api_module_number, l_temp_id,
154: p_upload_id, l_foreign_user_key_2);
155:
156: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 70);
157: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
158: l_parent_api_module_number , 75);
159: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
160: l_parent_user_key_2 , 80);

Line 157: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||

153: l_parent_api_module_number, l_temp_id,
154: p_upload_id, l_foreign_user_key_2);
155:
156: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 70);
157: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
158: l_parent_api_module_number , 75);
159: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
160: l_parent_user_key_2 , 80);
161: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

Line 159: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||

155:
156: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 70);
157: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
158: l_parent_api_module_number , 75);
159: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
160: l_parent_user_key_2 , 80);
161: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
162: l_foreign_user_key_2 , 85);
163: EXIT;

Line 161: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

157: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
158: l_parent_api_module_number , 75);
159: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
160: l_parent_user_key_2 , 80);
161: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
162: l_foreign_user_key_2 , 85);
163: EXIT;
164: END IF;
165: --generic column

Line 172: hr_du_utility.message('INFO','l_temp_id 2 : ' || l_temp_id , 90);

168: l_temp_id := hr_du_dp_pc_conversion.return_field_value
169: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
170: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
171:
172: hr_du_utility.message('INFO','l_temp_id 2 : ' || l_temp_id , 90);
173:
174: -- Check to see if there's a value with in the reference column
175: --of that api_module
176: IF l_temp_id IS NOT NULL THEN

Line 181: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 95);

177: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
178: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
179: 'UPLOAD_LINE_ID', l_pval_api_module_number);
180:
181: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 95);
182:
183: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
184: l_temp_api_module, l_temp_id,
185: p_upload_id, l_foreign_user_key_2);

Line 187: hr_du_utility.message('INFO','l_temp_api_module : ' ||l_temp_api_module , 100);

183: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
184: l_temp_api_module, l_temp_id,
185: p_upload_id, l_foreign_user_key_2);
186:
187: hr_du_utility.message('INFO','l_temp_api_module : ' ||l_temp_api_module , 100);
188: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
189: l_parent_user_key_2 , 105);
190: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
191: l_foreign_user_key_2 , 110);

Line 188: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||

184: l_temp_api_module, l_temp_id,
185: p_upload_id, l_foreign_user_key_2);
186:
187: hr_du_utility.message('INFO','l_temp_api_module : ' ||l_temp_api_module , 100);
188: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
189: l_parent_user_key_2 , 105);
190: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
191: l_foreign_user_key_2 , 110);
192:

Line 190: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

186:
187: hr_du_utility.message('INFO','l_temp_api_module : ' ||l_temp_api_module , 100);
188: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
189: l_parent_user_key_2 , 105);
190: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
191: l_foreign_user_key_2 , 110);
192:
193: END IF;
194: END IF;

Line 229: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);

225: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
226: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
227: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
228:
229: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
230:
231: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
232:
233: hr_du_utility.dynamic_sql(l_insert_statement);

Line 231: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

227: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
228:
229: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
230:
231: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
232:
233: hr_du_utility.dynamic_sql(l_insert_statement);
234:
235: --

Line 233: hr_du_utility.dynamic_sql(l_insert_statement);

229: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
230:
231: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
232:
233: hr_du_utility.dynamic_sql(l_insert_statement);
234:
235: --
236: hr_du_utility.message('ROUT','exit:hr_du_do_entities.create_default_employee', 115);
237: --

Line 236: hr_du_utility.message('ROUT','exit:hr_du_do_entities.create_default_employee', 115);

232:
233: hr_du_utility.dynamic_sql(l_insert_statement);
234:
235: --
236: hr_du_utility.message('ROUT','exit:hr_du_do_entities.create_default_employee', 115);
237: --
238:
239: EXCEPTION
240: WHEN e_fatal_error THEN

Line 241: hr_du_utility.error(SQLCODE,'hr_du_do_entities.create_default_employee'

237: --
238:
239: EXCEPTION
240: WHEN e_fatal_error THEN
241: hr_du_utility.error(SQLCODE,'hr_du_do_entities.create_default_employee'
242: ,l_fatal_error_message, 'R');
243: RAISE;
244: WHEN OTHERS THEN
245: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.create_default_employee'

Line 245: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.create_default_employee'

241: hr_du_utility.error(SQLCODE,'hr_du_do_entities.create_default_employee'
242: ,l_fatal_error_message, 'R');
243: RAISE;
244: WHEN OTHERS THEN
245: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.create_default_employee'
246: ,'(none)', 'R');
247: RAISE;
248:
249: --

Line 309: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api', 5);

305:
306: BEGIN
307:
308: --
309: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api', 5);
310: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
311: ')(p_upload_id - ' || p_upload_id ||
312: ')(p_batch_id - ' || p_batch_id ||
313: ')(p_api_module_id - ' || p_api_module_id ||

Line 310: hr_du_utility.message('PARA', '(p_values_table - Record Structure ' ||

306: BEGIN
307:
308: --
309: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api', 5);
310: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
311: ')(p_upload_id - ' || p_upload_id ||
312: ')(p_batch_id - ' || p_batch_id ||
313: ')(p_api_module_id - ' || p_api_module_id ||
314: ')(p_process_order - ' || p_process_order ||

Line 337: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);

333: p_values_table.r_api_id, p_upload_line_id,
334: l_foreign_user_key);
335:
336:
337: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);
338: hr_du_utility.message('INFO', 'l_parent_user_key : ' ||
339: l_parent_user_key , 20);
340: hr_du_utility.message('INFO', 'l_foreign_user_key : ' ||
341: l_foreign_user_key , 25);

Line 338: hr_du_utility.message('INFO', 'l_parent_user_key : ' ||

334: l_foreign_user_key);
335:
336:
337: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);
338: hr_du_utility.message('INFO', 'l_parent_user_key : ' ||
339: l_parent_user_key , 20);
340: hr_du_utility.message('INFO', 'l_foreign_user_key : ' ||
341: l_foreign_user_key , 25);
342:

Line 340: hr_du_utility.message('INFO', 'l_foreign_user_key : ' ||

336:
337: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);
338: hr_du_utility.message('INFO', 'l_parent_user_key : ' ||
339: l_parent_user_key , 20);
340: hr_du_utility.message('INFO', 'l_foreign_user_key : ' ||
341: l_foreign_user_key , 25);
342:
343: hr_du_di_insert.g_current_delimiter := ',';
344:

Line 351: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||

347:
348: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
349: p_values_table.r_pval_parent_line_id);
350:
351: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
352: p_values_table.r_pval_parent_line_id , 30);
353: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
354:
355:

Line 353: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);

349: p_values_table.r_pval_parent_line_id);
350:
351: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
352: p_values_table.r_pval_parent_line_id , 30);
353: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
354:
355:
356: --check to see if this api_module has any columns that may contain data to
357: --indicate that it has been called by another api_module

Line 385: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||

381:
382: l_pval_api_module_number := hr_du_di_insert.Return_Word(
383: p_values_table.r_pval_api_module_number , j);
384:
385: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
386: l_pval_parent_line_id , 40);
387: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
388: l_parent_api_module_number , 45);
389:

Line 387: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

383: p_values_table.r_pval_api_module_number , j);
384:
385: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
386: l_pval_parent_line_id , 40);
387: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
388: l_parent_api_module_number , 45);
389:
390: --check to see if referencing column is a generic reference. If null
391: --then it is

Line 406: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);

402: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
403: l_parent_api_module_number, l_temp_id,
404: p_upload_id, l_foreign_user_key_2);
405:
406: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
407: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
408: l_parent_api_module_number , 65);
409: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
410: l_parent_user_key_2 , 70);

Line 407: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

403: l_parent_api_module_number, l_temp_id,
404: p_upload_id, l_foreign_user_key_2);
405:
406: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
407: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
408: l_parent_api_module_number , 65);
409: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
410: l_parent_user_key_2 , 70);
411: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

Line 409: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||

405:
406: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
407: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
408: l_parent_api_module_number , 65);
409: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
410: l_parent_user_key_2 , 70);
411: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
412: l_foreign_user_key_2 , 75);
413:

Line 411: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

407: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
408: l_parent_api_module_number , 65);
409: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
410: l_parent_user_key_2 , 70);
411: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
412: l_foreign_user_key_2 , 75);
413:
414: EXIT;
415: END IF;

Line 436: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id, 85);

432: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
433: l_temp_api_module, l_temp_id,
434: p_upload_id, l_foreign_user_key_2);
435:
436: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id, 85);
437: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module, 90);
438: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
439: l_parent_user_key_2, 95);
440: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

Line 437: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module, 90);

433: l_temp_api_module, l_temp_id,
434: p_upload_id, l_foreign_user_key_2);
435:
436: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id, 85);
437: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module, 90);
438: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
439: l_parent_user_key_2, 95);
440: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
441: l_foreign_user_key_2, 100);

Line 438: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||

434: p_upload_id, l_foreign_user_key_2);
435:
436: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id, 85);
437: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module, 90);
438: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
439: l_parent_user_key_2, 95);
440: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
441: l_foreign_user_key_2, 100);
442: END IF;

Line 440: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

436: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id, 85);
437: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module, 90);
438: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
439: l_parent_user_key_2, 95);
440: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
441: l_foreign_user_key_2, 100);
442: END IF;
443: END IF;
444: END LOOP;

Line 483: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);

479:
480: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
481: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
482:
483: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
484:
485: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
486:
487: hr_du_utility.dynamic_sql(l_insert_statement);

Line 485: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

481: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
482:
483: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
484:
485: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
486:
487: hr_du_utility.dynamic_sql(l_insert_statement);
488:
489: --

Line 487: hr_du_utility.dynamic_sql(l_insert_statement);

483: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
484:
485: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
486:
487: hr_du_utility.dynamic_sql(l_insert_statement);
488:
489: --
490: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api', 105);
491: --

Line 490: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api', 105);

486:
487: hr_du_utility.dynamic_sql(l_insert_statement);
488:
489: --
490: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api', 105);
491: --
492:
493: EXCEPTION
494: WHEN e_fatal_error THEN

Line 495: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api'

491: --
492:
493: EXCEPTION
494: WHEN e_fatal_error THEN
495: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api'
496: ,l_fatal_error_message, 'R');
497: RAISE;
498: WHEN OTHERS THEN
499: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api','(none)', 'R');

Line 499: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api','(none)', 'R');

495: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api'
496: ,l_fatal_error_message, 'R');
497: RAISE;
498: WHEN OTHERS THEN
499: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api','(none)', 'R');
500: RAISE;
501: --
502: END DEFAULT_API;
503:

Line 566: hr_du_utility.message('ROUT',

562:
563: BEGIN
564:
565: --
566: hr_du_utility.message('ROUT',
567: 'entry:hr_du_do_entities.update_emp_asg_criteria', 5);
568: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
569: ')(p_upload_id - ' || p_upload_id ||
570: ')(p_batch_id - ' || p_batch_id ||

Line 568: hr_du_utility.message('PARA', '(p_values_table - Record Structure ' ||

564:
565: --
566: hr_du_utility.message('ROUT',
567: 'entry:hr_du_do_entities.update_emp_asg_criteria', 5);
568: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
569: ')(p_upload_id - ' || p_upload_id ||
570: ')(p_batch_id - ' || p_batch_id ||
571: ')(p_api_module_id - ' || p_api_module_id ||
572: ')(p_process_order - ' || p_process_order ||

Line 593: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 15);

589: l_parent_user_key := hr_du_do_datapump.RETURN_CREATED_USER_KEY_2(l_row_id,
590: p_values_table.r_api_id, p_upload_line_id,
591: l_foreign_user_key);
592:
593: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 15);
594: hr_du_utility.message('INFO', 'l_parent_user_key : ' || l_parent_user_key , 20);
595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);
596:
597: hr_du_di_insert.g_current_delimiter := ',';

Line 594: hr_du_utility.message('INFO', 'l_parent_user_key : ' || l_parent_user_key , 20);

590: p_values_table.r_api_id, p_upload_line_id,
591: l_foreign_user_key);
592:
593: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 15);
594: hr_du_utility.message('INFO', 'l_parent_user_key : ' || l_parent_user_key , 20);
595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);
596:
597: hr_du_di_insert.g_current_delimiter := ',';
598:

Line 595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);

591: l_foreign_user_key);
592:
593: hr_du_utility.message('INFO','l_row_id : ' || l_row_id , 15);
594: hr_du_utility.message('INFO', 'l_parent_user_key : ' || l_parent_user_key , 20);
595: hr_du_utility.message('INFO', 'l_foreign_user_key : ' || l_foreign_user_key, 25);
596:
597: hr_du_di_insert.g_current_delimiter := ',';
598:
599: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

Line 605: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||

601:
602: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
603: p_values_table.r_pval_parent_line_id);
604:
605: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
606: p_values_table.r_pval_parent_line_id , 30);
607: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
608:
609: --check to see if this api_module has any columns that may contain

Line 607: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);

603: p_values_table.r_pval_parent_line_id);
604:
605: hr_du_utility.message('INFO','r_pval_parent_line_id : ' ||
606: p_values_table.r_pval_parent_line_id , 30);
607: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
608:
609: --check to see if this api_module has any columns that may contain
610: --data to indicate that it has been called by another api_module
611:

Line 639: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||

635:
636: l_pval_api_module_number := hr_du_di_insert.Return_Word(
637: p_values_table.r_pval_api_module_number , j);
638:
639: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
640: l_pval_parent_line_id , 40);
641: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
642: l_parent_api_module_number , 45);
643: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||

Line 641: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

637: p_values_table.r_pval_api_module_number , j);
638:
639: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
640: l_pval_parent_line_id , 40);
641: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
642: l_parent_api_module_number , 45);
643: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||
644: l_pval_api_module_number , 50);
645:

Line 643: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||

639: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
640: l_pval_parent_line_id , 40);
641: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
642: l_parent_api_module_number , 45);
643: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||
644: l_pval_api_module_number , 50);
645:
646: --check to see if referencing column is a generic reference. If null
647: --then it is

Line 661: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 55);

657: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
658: l_parent_api_module_number, l_temp_id,
659: p_upload_id, l_foreign_user_key_2);
660:
661: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 55);
662: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
663: l_parent_api_module_number , 60);
664: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
665: l_parent_user_key_2 , 65);

Line 662: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||

658: l_parent_api_module_number, l_temp_id,
659: p_upload_id, l_foreign_user_key_2);
660:
661: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 55);
662: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
663: l_parent_api_module_number , 60);
664: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
665: l_parent_user_key_2 , 65);
666: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

Line 664: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||

660:
661: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 55);
662: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
663: l_parent_api_module_number , 60);
664: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
665: l_parent_user_key_2 , 65);
666: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
667: l_foreign_user_key_2 , 70);
668: EXIT;

Line 666: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

662: hr_du_utility.message('INFO', 'l_parent_api_module_number : ' ||
663: l_parent_api_module_number , 60);
664: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
665: l_parent_user_key_2 , 65);
666: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
667: l_foreign_user_key_2 , 70);
668: EXIT;
669: END IF;
670: --generic column

Line 684: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 75);

680: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
681: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
682: 'UPLOAD_LINE_ID', l_pval_api_module_number);
683:
684: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 75);
685:
686: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
687: l_temp_api_module, l_temp_id,
688: p_upload_id, l_foreign_user_key_2);

Line 690: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 80);

686: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
687: l_temp_api_module, l_temp_id,
688: p_upload_id, l_foreign_user_key_2);
689:
690: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 80);
691: hr_du_utility.message('INFO','l_temp_api_module : ' || l_temp_api_module , 85);
692: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
693: l_parent_user_key_2 , 90);
694: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

Line 691: hr_du_utility.message('INFO','l_temp_api_module : ' || l_temp_api_module , 85);

687: l_temp_api_module, l_temp_id,
688: p_upload_id, l_foreign_user_key_2);
689:
690: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 80);
691: hr_du_utility.message('INFO','l_temp_api_module : ' || l_temp_api_module , 85);
692: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
693: l_parent_user_key_2 , 90);
694: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
695: l_foreign_user_key_2 , 95);

Line 692: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||

688: p_upload_id, l_foreign_user_key_2);
689:
690: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 80);
691: hr_du_utility.message('INFO','l_temp_api_module : ' || l_temp_api_module , 85);
692: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
693: l_parent_user_key_2 , 90);
694: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
695: l_foreign_user_key_2 , 95);
696: END IF;

Line 694: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

690: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 80);
691: hr_du_utility.message('INFO','l_temp_api_module : ' || l_temp_api_module , 85);
692: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
693: l_parent_user_key_2 , 90);
694: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
695: l_foreign_user_key_2 , 95);
696: END IF;
697: END IF;
698: END LOOP;

Line 730: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);

726: l_insert_statement := l_insert_statement || p_values_table.r_PVAL_string;
727: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
728: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
729:
730: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
731: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
732:
733: hr_du_utility.dynamic_sql(l_insert_statement);
734:

Line 731: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

727: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
728: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
729:
730: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
731: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
732:
733: hr_du_utility.dynamic_sql(l_insert_statement);
734:
735: --

Line 733: hr_du_utility.dynamic_sql(l_insert_statement);

729:
730: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
731: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
732:
733: hr_du_utility.dynamic_sql(l_insert_statement);
734:
735: --
736: hr_du_utility.message('ROUT','exit:hr_du_do_entities.update_emp_asg_criteria', 100);
737: --

Line 736: hr_du_utility.message('ROUT','exit:hr_du_do_entities.update_emp_asg_criteria', 100);

732:
733: hr_du_utility.dynamic_sql(l_insert_statement);
734:
735: --
736: hr_du_utility.message('ROUT','exit:hr_du_do_entities.update_emp_asg_criteria', 100);
737: --
738:
739: EXCEPTION
740: WHEN e_fatal_error THEN

Line 741: hr_du_utility.error(SQLCODE,'hr_du_do_entities.update_emp_asg_criteria'

737: --
738:
739: EXCEPTION
740: WHEN e_fatal_error THEN
741: hr_du_utility.error(SQLCODE,'hr_du_do_entities.update_emp_asg_criteria'
742: ,l_fatal_error_message, 'R');
743: RAISE;
744: WHEN OTHERS THEN
745: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.update_emp_asg_criteria',

Line 745: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.update_emp_asg_criteria',

741: hr_du_utility.error(SQLCODE,'hr_du_do_entities.update_emp_asg_criteria'
742: ,l_fatal_error_message, 'R');
743: RAISE;
744: WHEN OTHERS THEN
745: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.update_emp_asg_criteria',
746: '(none)', 'R');
747: RAISE;
748:
749: --

Line 810: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api_null', 5);

806:
807: BEGIN
808:
809: --
810: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api_null', 5);
811: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
812: ')(p_upload_id - ' || p_upload_id ||
813: ')(p_batch_id - ' || p_batch_id ||
814: ')(p_api_module_id - ' || p_api_module_id ||

Line 811: hr_du_utility.message('PARA', '(p_values_table - Record Structure ' ||

807: BEGIN
808:
809: --
810: hr_du_utility.message('ROUT','entry:hr_du_do_entities.default_api_null', 5);
811: hr_du_utility.message('PARA', '(p_values_table - ** Record Structure** ' ||
812: ')(p_upload_id - ' || p_upload_id ||
813: ')(p_batch_id - ' || p_batch_id ||
814: ')(p_api_module_id - ' || p_api_module_id ||
815: ')(p_process_order - ' || p_process_order ||

Line 833: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);

829: END IF;
830: --
831: CLOSE csr_line_id;
832:
833: hr_du_utility.message('INFO', 'l_row_id : ' || l_row_id , 15);
834:
835: hr_du_di_insert.g_current_delimiter := ',';
836:
837: -- no delimeters as we have 'none' as the user key

Line 844: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||

840: --
841: l_number_refs := hr_du_di_insert.WORDS_ON_LINE(
842: p_values_table.r_pval_parent_line_id);
843:
844: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
845: p_values_table.r_pval_parent_line_id , 30);
846: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
847:
848: --check to see if this api_module has any columns that may contain data to

Line 846: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);

842: p_values_table.r_pval_parent_line_id);
843:
844: hr_du_utility.message('INFO', 'r_pval_parent_line_id : ' ||
845: p_values_table.r_pval_parent_line_id , 30);
846: hr_du_utility.message('INFO', 'l_number_refs : ' || l_number_refs , 35);
847:
848: --check to see if this api_module has any columns that may contain data to
849: --indicate that it has been called by another api_module
850:

Line 875: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||

871:
872: l_pval_api_module_number := hr_du_di_insert.Return_Word(
873: p_values_table.r_pval_api_module_number , j);
874:
875: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
876: l_pval_parent_line_id , 40);
877: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
878: l_parent_api_module_number , 45);
879: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||

Line 877: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

873: p_values_table.r_pval_api_module_number , j);
874:
875: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
876: l_pval_parent_line_id , 40);
877: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
878: l_parent_api_module_number , 45);
879: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||
880: l_pval_api_module_number , 50);
881:

Line 879: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||

875: hr_du_utility.message('INFO','l_pval_parent_line_id : ' ||
876: l_pval_parent_line_id , 40);
877: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
878: l_parent_api_module_number , 45);
879: hr_du_utility.message('INFO','l_pval_api_module_number : ' ||
880: l_pval_api_module_number , 50);
881:
882: --check to see if referencing column is a generic reference. If null
883: --then it is

Line 890: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 55);

886: l_temp_id := hr_du_dp_pc_conversion.return_field_value
887: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
888: 'UPLOAD_LINE_ID', l_pval_parent_line_id);
889:
890: hr_du_utility.message('INFO','l_temp_id 1 : ' || l_temp_id , 55);
891:
892: --Check to see if there's a value with in the reference column of
893: --the api_module
894: IF l_temp_id IS NOT NULL THEN

Line 899: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);

895: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
896: l_parent_api_module_number, l_temp_id,
897: p_upload_id, l_foreign_user_key_2);
898:
899: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
900: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
901: l_parent_api_module_number , 65);
902: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
903: l_parent_user_key_2 , 70);

Line 900: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||

896: l_parent_api_module_number, l_temp_id,
897: p_upload_id, l_foreign_user_key_2);
898:
899: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
900: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
901: l_parent_api_module_number , 65);
902: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
903: l_parent_user_key_2 , 70);
904: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

Line 902: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||

898:
899: hr_du_utility.message('INFO','l_temp_id : ' || l_temp_id , 60);
900: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
901: l_parent_api_module_number , 65);
902: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
903: l_parent_user_key_2 , 70);
904: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
905: l_foreign_user_key_2 , 75);
906:

Line 904: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||

900: hr_du_utility.message('INFO','l_parent_api_module_number : ' ||
901: l_parent_api_module_number , 65);
902: hr_du_utility.message('INFO','l_parent_user_key_2 : ' ||
903: l_parent_user_key_2 , 70);
904: hr_du_utility.message('INFO','l_foreign_user_key_2 : ' ||
905: l_foreign_user_key_2 , 75);
906:
907: EXIT;
908: END IF;

Line 924: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module,

920: l_temp_api_module := hr_du_dp_pc_conversion.return_field_value
921: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
922: 'UPLOAD_LINE_ID', l_pval_api_module_number);
923:
924: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module,
925: 80);
926:
927: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
928: l_temp_api_module, l_temp_id,

Line 931: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 85);

927: l_parent_user_key_2 := hr_du_do_datapump.RETURN_CREATED_USER_KEY(
928: l_temp_api_module, l_temp_id,
929: p_upload_id, l_foreign_user_key_2);
930:
931: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 85);
932: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 90);
933: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
934: l_parent_user_key_2 , 95);
935: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

Line 932: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 90);

928: l_temp_api_module, l_temp_id,
929: p_upload_id, l_foreign_user_key_2);
930:
931: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 85);
932: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 90);
933: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
934: l_parent_user_key_2 , 95);
935: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
936: l_foreign_user_key_2 , 100);

Line 933: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||

929: p_upload_id, l_foreign_user_key_2);
930:
931: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 85);
932: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 90);
933: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
934: l_parent_user_key_2 , 95);
935: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
936: l_foreign_user_key_2 , 100);
937:

Line 935: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||

931: hr_du_utility.message('INFO', 'l_temp_id : ' || l_temp_id , 85);
932: hr_du_utility.message('INFO', 'l_temp_api_module : ' || l_temp_api_module , 90);
933: hr_du_utility.message('INFO', 'l_parent_user_key_2 : ' ||
934: l_parent_user_key_2 , 95);
935: hr_du_utility.message('INFO', 'l_foreign_user_key_2 : ' ||
936: l_foreign_user_key_2 , 100);
937:
938: END IF;
939: END IF;

Line 977: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);

973:
974: l_insert_statement := l_insert_statement || ' FROM HR_DU_UPLOAD_LINES ' ||
975: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
976:
977: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
978:
979: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
980:
981: hr_du_utility.dynamic_sql(l_insert_statement);

Line 979: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);

975: 'WHERE UPLOAD_LINE_ID = ' || p_upload_line_id;
976:
977: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
978:
979: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
980:
981: hr_du_utility.dynamic_sql(l_insert_statement);
982:
983: --

Line 981: hr_du_utility.dynamic_sql(l_insert_statement);

977: hr_du_utility.message('INFO', 'l_insert_statement - ' || l_insert_statement,35);
978:
979: hr_du_utility.message('INFO','l_foreign_user_key : ' || l_foreign_user_key , 115);
980:
981: hr_du_utility.dynamic_sql(l_insert_statement);
982:
983: --
984: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api_null', 105);
985: --

Line 984: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api_null', 105);

980:
981: hr_du_utility.dynamic_sql(l_insert_statement);
982:
983: --
984: hr_du_utility.message('ROUT','exit:hr_du_do_entities.default_api_null', 105);
985: --
986:
987: EXCEPTION
988: WHEN e_fatal_error THEN

Line 989: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api_null'

985: --
986:
987: EXCEPTION
988: WHEN e_fatal_error THEN
989: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api_null'
990: ,l_fatal_error_message, 'R');
991: RAISE;
992: WHEN OTHERS THEN
993: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api_null','(none)', 'R');

Line 993: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api_null','(none)', 'R');

989: hr_du_utility.error(SQLCODE,'hr_du_do_entities.default_api_null'
990: ,l_fatal_error_message, 'R');
991: RAISE;
992: WHEN OTHERS THEN
993: hr_du_utility.error(SQLCODE, 'hr_du_do_entities.default_api_null','(none)', 'R');
994: RAISE;
995: --
996: END DEFAULT_API_NULL;
997: