DBA Data[Home] [Help]

APPS.HR_REGISTER_EITS dependencies on FND_FILE

Line 86: fnd_file.put_line(fnd_file.log,l_insert);

82: ,v_desc
83: ,v_leg_code
84: ,1);
85:
86: fnd_file.put_line(fnd_file.log,l_insert);
87:
88:
89: --
90:

Line 108: fnd_file.put_line(fnd_file.log,l_insert);

104: ,v_desc
105: ,v_leg_code
106: ,1);
107: --
108: fnd_file.put_line(fnd_file.log,l_insert);
109:
110: insert into PER_ASSIGNMENT_INFO_TYPES_TL
111: (INFORMATION_TYPE
112: ,LANGUAGE

Line 141: fnd_file.put_line(fnd_file.log,l_insert);

137: from per_assignment_info_types_tl pait
138: where pait.information_type = m.information_type
139: and pait.language = l.language_code);
140: --
141: fnd_file.put_line(fnd_file.log,l_insert);
142:
143:
144: elsif v_table_name = 'PER_POSITION_INFO_TYPES' then
145: --

Line 161: fnd_file.put_line(fnd_file.log,l_insert);

157: ,v_desc
158: ,v_leg_code
159: ,1);
160:
161: fnd_file.put_line(fnd_file.log,l_insert);
162:
163:
164: elsif v_table_name = 'PQP_VEH_ALLOC_INFO_TYPES' then
165: --

Line 181: fnd_file.put_line(fnd_file.log,l_insert);

177: ,v_desc
178: ,v_leg_code
179: ,1);
180:
181: fnd_file.put_line(fnd_file.log,l_insert);
182:
183:
184: elsif v_table_name = 'PQP_VEH_REPOS_INFO_TYPES' then
185: --

Line 201: fnd_file.put_line(fnd_file.log,l_insert);

197: ,v_desc
198: ,v_leg_code
199: ,1);
200:
201: fnd_file.put_line(fnd_file.log,l_insert);
202:
203: elsif v_table_name = 'HR_LOCATION_INFO_TYPES' then
204: --
205: INSERT INTO HR_LOCATION_INFO_TYPES

Line 220: fnd_file.put_line(fnd_file.log,l_insert);

216: ,v_desc
217: ,v_leg_code
218: ,1);
219:
220: fnd_file.put_line(fnd_file.log,l_insert);
221: --
222: elsif v_table_name = 'PER_JOB_INFO_TYPES' then
223: --
224:

Line 240: fnd_file.put_line(fnd_file.log,l_insert);

236: ,v_desc
237: ,v_leg_code
238: ,1);
239:
240: fnd_file.put_line(fnd_file.log,l_insert);
241:
242: elsif v_table_name = 'PER_CONTACT_INFO_TYPES' then
243: --
244:

Line 258: fnd_file.put_line(fnd_file.log,l_insert);

254: ,v_multi_row
255: ,v_leg_code
256: ,1);
257:
258: fnd_file.put_line(fnd_file.log,l_insert);
259: --
260: insert into PER_CONTACT_INFO_TYPES_TL
261: (INFORMATION_TYPE
262: , LANGUAGE

Line 291: fnd_file.put_line(fnd_file.log,l_insert);

287: from per_contact_info_types_tl pcit
288: where pcit.information_type = m.information_type
289: and pcit.language = l.language_code);
290:
291: fnd_file.put_line(fnd_file.log,l_insert);
292: --
293:
294: elsif v_table_name = 'PER_PREV_JOB_INFO_TYPES' then
295: --

Line 312: fnd_file.put_line(fnd_file.log,l_insert);

308: ,v_desc
309: ,v_leg_code
310: ,1);
311:
312: fnd_file.put_line(fnd_file.log,l_insert);
313:
314: elsif v_table_name = 'PAY_ELEMENT_TYPE_INFO_TYPES' then
315: --
316: INSERT INTO PAY_ELEMENT_TYPE_INFO_TYPES

Line 331: fnd_file.put_line(fnd_file.log,l_insert);

327: ,v_desc
328: ,v_leg_code
329: ,1);
330:
331: fnd_file.put_line(fnd_file.log,l_insert);
332:
333: /* Changes Added to support BEN EITs start here */
334:
335: elsif v_table_name = 'BEN_OPT_INFO_TYPES' then

Line 351: fnd_file.put_line(fnd_file.log,l_insert);

347: ,v_multi_row
348: ,v_desc
349: ,v_leg_code
350: ,1);
351: fnd_file.put_line(fnd_file.log,l_insert);
352:
353: --
354: elsif v_table_name = 'BEN_ABR_INFO_TYPES' then
355: --

Line 370: fnd_file.put_line(fnd_file.log,l_insert);

366: ,v_multi_row
367: ,v_desc
368: ,v_leg_code
369: ,1);
370: fnd_file.put_line(fnd_file.log,l_insert);
371: --
372: elsif v_table_name = 'BEN_PL_INFO_TYPES' then
373: --
374: INSERT INTO BEN_PL_INFO_TYPES

Line 388: fnd_file.put_line(fnd_file.log,l_insert);

384: ,v_multi_row
385: ,v_desc
386: ,v_leg_code
387: ,1);
388: fnd_file.put_line(fnd_file.log,l_insert);
389: --
390: elsif v_table_name = 'BEN_ELP_INFO_TYPES' then
391: --
392: INSERT INTO BEN_ELP_INFO_TYPES

Line 406: fnd_file.put_line(fnd_file.log,l_insert);

402: ,v_multi_row
403: ,v_desc
404: ,v_leg_code
405: ,1);
406: fnd_file.put_line(fnd_file.log,l_insert);
407: --
408: elsif v_table_name = 'BEN_LER_INFO_TYPES' then
409: --
410: INSERT INTO BEN_LER_INFO_TYPES

Line 424: fnd_file.put_line(fnd_file.log,l_insert);

420: ,v_multi_row
421: ,v_desc
422: ,v_leg_code
423: ,1);
424: fnd_file.put_line(fnd_file.log,l_insert);
425: --
426: elsif v_table_name = 'BEN_PGM_INFO_TYPES' then
427: --
428: INSERT INTO BEN_PGM_INFO_TYPES

Line 442: fnd_file.put_line(fnd_file.log,l_insert);

438: ,v_multi_row
439: ,v_desc
440: ,v_leg_code
441: ,1);
442: fnd_file.put_line(fnd_file.log,l_insert);
443: --
444:
445: /* Changes Added to support BEN EITs end here */
446: /* 4197450 Start of Fix */

Line 476: fnd_file.put_line(fnd_file.log,l_insert);

472: ,l_update_date
473: ,l_updated_by
474: ,l_update_login);
475:
476: fnd_file.put_line(fnd_file.log,l_insert);
477: EXCEPTION
478: WHEN OTHERS THEN
479: fnd_file.put_line(fnd_file.log,l_fail);
480: end;

Line 479: fnd_file.put_line(fnd_file.log,l_fail);

475:
476: fnd_file.put_line(fnd_file.log,l_insert);
477: EXCEPTION
478: WHEN OTHERS THEN
479: fnd_file.put_line(fnd_file.log,l_fail);
480: end;
481:
482: INSERT INTO HR_ORG_INFO_TYPES_BY_CLASS
483: (ORG_CLASSIFICATION

Line 500: fnd_file.put_line(fnd_file.log,l_insert);

496: and ORG_CLASSIFICATION = v_org_class);
497:
498: l_insert := 'The Information has been inserted into the table HR_ORG_INFO_TYPES_BY_CLASS for Organization Classification ' || v_org_class;
499:
500: fnd_file.put_line(fnd_file.log,l_insert);
501: EXCEPTION
502: WHEN OTHERS THEN
503: fnd_file.put_line(fnd_file.log,l_fail);
504: end;

Line 503: fnd_file.put_line(fnd_file.log,l_fail);

499:
500: fnd_file.put_line(fnd_file.log,l_insert);
501: EXCEPTION
502: WHEN OTHERS THEN
503: fnd_file.put_line(fnd_file.log,l_fail);
504: end;
505:
506: else
507: --The following has been added to return error if application id is not entered.

Line 510: fnd_file.put_line(fnd_file.log,l_show_error);

506: else
507: --The following has been added to return error if application id is not entered.
508: retcode := '2';
509: l_show_error:= 'Please enter the mandatory application for HR_ORG_INFORMATION_TYPES';
510: fnd_file.put_line(fnd_file.log,l_show_error);
511: --
512: end if;
513:
514:

Line 548: fnd_file.put_line(fnd_file.log,l_insert);

544: ,p_document_type_id => l_doc_type_id
545: ,p_object_version_number => l_ovn
546: );
547:
548: fnd_file.put_line(fnd_file.log,l_insert);
549: exception
550: when others then
551: retcode:='1';
552: fnd_file.put_line(fnd_file.log,l_fail);

Line 552: fnd_file.put_line(fnd_file.log,l_fail);

548: fnd_file.put_line(fnd_file.log,l_insert);
549: exception
550: when others then
551: retcode:='1';
552: fnd_file.put_line(fnd_file.log,l_fail);
553: fnd_file.put_line(fnd_file.log,sqlerrm);
554:
555: end;
556:

Line 553: fnd_file.put_line(fnd_file.log,sqlerrm);

549: exception
550: when others then
551: retcode:='1';
552: fnd_file.put_line(fnd_file.log,l_fail);
553: fnd_file.put_line(fnd_file.log,sqlerrm);
554:
555: end;
556:
557:

Line 561: fnd_file.put_line(fnd_file.log,'Error - user entered invalid or unsupported table name');

557:
558: /* END Added elsif block for Documents Of Record */
559: else
560:
561: fnd_file.put_line(fnd_file.log,'Error - user entered invalid or unsupported table name');
562:
563: raise VALUE_ERROR;
564:
565: end if;

Line 571: fnd_file.put_line(fnd_file.log,l_fail);

567: EXCEPTION
568:
569: WHEN OTHERS THEN
570:
571: fnd_file.put_line(fnd_file.log,l_fail);
572: --
573: END;
574:
575: end;