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.JA_CN_HRMS_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 323: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'

319: CLOSE acc_date_cur;
320:
321: FOR v_row IN department_cur
322: LOOP
323: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
324: ,Ja_Cn_Utility.GV_TAG_TYPE_START
325: );
326: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
327: ,v_row.DEPARMENT_ID

Line 324: ,Ja_Cn_Utility.GV_TAG_TYPE_START

320:
321: FOR v_row IN department_cur
322: LOOP
323: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
324: ,Ja_Cn_Utility.GV_TAG_TYPE_START
325: );
326: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
327: ,v_row.DEPARMENT_ID
328: );

Line 326: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

322: LOOP
323: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
324: ,Ja_Cn_Utility.GV_TAG_TYPE_START
325: );
326: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
327: ,v_row.DEPARMENT_ID
328: );
329: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
330: ,v_row.DEPARTMENT_NAME

Line 329: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'

325: );
326: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
327: ,v_row.DEPARMENT_ID
328: );
329: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
330: ,v_row.DEPARTMENT_NAME
331: );
332: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
333: ,Get_Parent_Org_ID(v_row.DEPARMENT_ID)

Line 332: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'

328: );
329: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
330: ,v_row.DEPARTMENT_NAME
331: );
332: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
333: ,Get_Parent_Org_ID(v_row.DEPARMENT_ID)
334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
335: ,Ja_Cn_Utility.GV_REQUIRED_NO
336: );

Line 334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

330: ,v_row.DEPARTMENT_NAME
331: );
332: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
333: ,Get_Parent_Org_ID(v_row.DEPARMENT_ID)
334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
335: ,Ja_Cn_Utility.GV_REQUIRED_NO
336: );
337: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
338: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 335: ,Ja_Cn_Utility.GV_REQUIRED_NO

331: );
332: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
333: ,Get_Parent_Org_ID(v_row.DEPARMENT_ID)
334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
335: ,Ja_Cn_Utility.GV_REQUIRED_NO
336: );
337: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
338: ,Ja_Cn_Utility.GV_TAG_TYPE_END
339: );

Line 337: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'

333: ,Get_Parent_Org_ID(v_row.DEPARMENT_ID)
334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
335: ,Ja_Cn_Utility.GV_REQUIRED_NO
336: );
337: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
338: ,Ja_Cn_Utility.GV_TAG_TYPE_END
339: );
340: ln_rec_count := ln_rec_count + 1;
341: END LOOP;

Line 338: ,Ja_Cn_Utility.GV_TAG_TYPE_END

334: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
335: ,Ja_Cn_Utility.GV_REQUIRED_NO
336: );
337: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
338: ,Ja_Cn_Utility.GV_TAG_TYPE_END
339: );
340: ln_rec_count := ln_rec_count + 1;
341: END LOOP;
342:

Line 358: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');

354: -- There is no data found for department record
355: IF ln_rec_count = 0
356: THEN
357: --Begin: Added for bug# 9722570
358: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
359: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
360: ,Ja_Cn_Utility.GV_TAG_TYPE_START
361: );
362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

Line 359: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'

355: IF ln_rec_count = 0
356: THEN
357: --Begin: Added for bug# 9722570
358: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
359: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
360: ,Ja_Cn_Utility.GV_TAG_TYPE_START
361: );
362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
363: ,NULL

Line 360: ,Ja_Cn_Utility.GV_TAG_TYPE_START

356: THEN
357: --Begin: Added for bug# 9722570
358: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
359: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
360: ,Ja_Cn_Utility.GV_TAG_TYPE_START
361: );
362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
363: ,NULL
364: );

Line 362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

358: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
359: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
360: ,Ja_Cn_Utility.GV_TAG_TYPE_START
361: );
362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
363: ,NULL
364: );
365: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
366: ,NULL

Line 365: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'

361: );
362: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
363: ,NULL
364: );
365: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
366: ,NULL
367: );
368: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
369: ,NULL

Line 368: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'

364: );
365: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_NAME'
366: ,NULL
367: );
368: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
369: ,NULL
370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
371: ,Ja_Cn_Utility.GV_REQUIRED_NO
372: );

Line 370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

366: ,NULL
367: );
368: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
369: ,NULL
370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
371: ,Ja_Cn_Utility.GV_REQUIRED_NO
372: );
373: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
374: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 371: ,Ja_Cn_Utility.GV_REQUIRED_NO

367: );
368: Ja_Cn_Utility.Add_Child_Node('PARENT_DEPARTMENT_ID'
369: ,NULL
370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
371: ,Ja_Cn_Utility.GV_REQUIRED_NO
372: );
373: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
374: ,Ja_Cn_Utility.GV_TAG_TYPE_END
375: );

Line 373: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'

369: ,NULL
370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
371: ,Ja_Cn_Utility.GV_REQUIRED_NO
372: );
373: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
374: ,Ja_Cn_Utility.GV_TAG_TYPE_END
375: );
376: --RAISE NO_DATA;
377: --End: Added for bug# 9722570

Line 374: ,Ja_Cn_Utility.GV_TAG_TYPE_END

370: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
371: ,Ja_Cn_Utility.GV_REQUIRED_NO
372: );
373: Ja_Cn_Utility.Add_Sub_Root_Node('DEPARTMENT_RECORDS'
374: ,Ja_Cn_Utility.GV_TAG_TYPE_END
375: );
376: --RAISE NO_DATA;
377: --End: Added for bug# 9722570
378: END IF;

Line 400: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');

396: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
397: 'exception',
398: 'No data for Department Records');
399: END IF; --ln_proc_level>=ln_dbg_level
400: Ja_Cn_Utility.Print_No_Data_Found_For_Log('DEPARTMENT_RECORDS');
401: RAISE;*/
402: --End: Deleted for bug# 9722570
403: WHEN OTHERS THEN
404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 546: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'

542: CLOSE acc_date_cur;
543:
544: FOR v_row IN employee_cur
545: LOOP
546: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
547: ,Ja_Cn_Utility.GV_TAG_TYPE_START
548: );
549: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
550: ,v_row.EMPLOYEE_ID

Line 547: ,Ja_Cn_Utility.GV_TAG_TYPE_START

543:
544: FOR v_row IN employee_cur
545: LOOP
546: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
547: ,Ja_Cn_Utility.GV_TAG_TYPE_START
548: );
549: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
550: ,v_row.EMPLOYEE_ID
551: );

Line 549: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'

545: LOOP
546: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
547: ,Ja_Cn_Utility.GV_TAG_TYPE_START
548: );
549: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
550: ,v_row.EMPLOYEE_ID
551: );
552: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
553: ,v_row.EMPLOYEE_NAME

Line 552: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'

548: );
549: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
550: ,v_row.EMPLOYEE_ID
551: );
552: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
553: ,v_row.EMPLOYEE_NAME
554: );
555: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
556: ,CN_Get_Doc_Details(v_row.PERSON_ID

Line 555: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'

551: );
552: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
553: ,v_row.EMPLOYEE_NAME
554: );
555: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
556: ,CN_Get_Doc_Details(v_row.PERSON_ID
557: ,v_row.EFFECTIVE_START_DATE
558: ,'TYPE'
559: )

Line 561: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'

557: ,v_row.EFFECTIVE_START_DATE
558: ,'TYPE'
559: )
560: );
561: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
562: ,CN_Get_Doc_Details(v_row.PERSON_ID
563: ,v_row.EFFECTIVE_START_DATE
564: ,'NAME'
565: )

Line 567: Ja_Cn_Utility.Add_Child_Node('GENDER'

563: ,v_row.EFFECTIVE_START_DATE
564: ,'NAME'
565: )
566: );
567: Ja_Cn_Utility.Add_Child_Node('GENDER'
568: ,Get_Lookup_Meaning(v_row.GENDER, 'SEX')
569: );
570: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
571: ,v_row.DATE_OF_BIRTH

Line 570: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'

566: );
567: Ja_Cn_Utility.Add_Child_Node('GENDER'
568: ,Get_Lookup_Meaning(v_row.GENDER, 'SEX')
569: );
570: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
571: ,v_row.DATE_OF_BIRTH
572: ,8
573: );
574: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

Line 574: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

570: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
571: ,v_row.DATE_OF_BIRTH
572: ,8
573: );
574: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
575: ,v_row.DEPARTMENT_ID
576: );
577: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
578: ,v_row.HIRE_DATE

Line 577: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'

573: );
574: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
575: ,v_row.DEPARTMENT_ID
576: );
577: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
578: ,v_row.HIRE_DATE
579: ,8
580: );
581: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'

Line 581: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'

577: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
578: ,v_row.HIRE_DATE
579: ,8
580: );
581: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'
582: ,v_row.TERMINATION_DATE
583: ,8
584: ,Ja_Cn_Utility.GV_REQUIRED_NO
585: );

Line 584: ,Ja_Cn_Utility.GV_REQUIRED_NO

580: );
581: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'
582: ,v_row.TERMINATION_DATE
583: ,8
584: ,Ja_Cn_Utility.GV_REQUIRED_NO
585: );
586: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
587: ,Ja_Cn_Utility.GV_TAG_TYPE_END
588: );

Line 586: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'

582: ,v_row.TERMINATION_DATE
583: ,8
584: ,Ja_Cn_Utility.GV_REQUIRED_NO
585: );
586: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
587: ,Ja_Cn_Utility.GV_TAG_TYPE_END
588: );
589: ln_rec_count := ln_rec_count + 1;
590:

Line 587: ,Ja_Cn_Utility.GV_TAG_TYPE_END

583: ,8
584: ,Ja_Cn_Utility.GV_REQUIRED_NO
585: );
586: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
587: ,Ja_Cn_Utility.GV_TAG_TYPE_END
588: );
589: ln_rec_count := ln_rec_count + 1;
590:
591: END LOOP;

Line 608: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');

604: -- There is no data found for employee record
605: IF ln_rec_count = 0
606: THEN
607: --Begin: Added for bug# 9722570
608: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
609: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_START
611: );
612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'

Line 609: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'

605: IF ln_rec_count = 0
606: THEN
607: --Begin: Added for bug# 9722570
608: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
609: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_START
611: );
612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
613: ,NULL

Line 610: ,Ja_Cn_Utility.GV_TAG_TYPE_START

606: THEN
607: --Begin: Added for bug# 9722570
608: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
609: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_START
611: );
612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
613: ,NULL
614: );

Line 612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'

608: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
609: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_START
611: );
612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
613: ,NULL
614: );
615: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
616: ,NULL

Line 615: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'

611: );
612: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_ID'
613: ,NULL
614: );
615: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
616: ,NULL
617: );
618: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
619: ,NULL

Line 618: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'

614: );
615: Ja_Cn_Utility.Add_Child_Node('EMPLOYEE_NAME'
616: ,NULL
617: );
618: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
619: ,NULL
620: );
621: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
622: ,NULL

Line 621: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'

617: );
618: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_TYPE'
619: ,NULL
620: );
621: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
622: ,NULL
623: );
624: Ja_Cn_Utility.Add_Child_Node('GENDER'
625: ,NULL

Line 624: Ja_Cn_Utility.Add_Child_Node('GENDER'

620: );
621: Ja_Cn_Utility.Add_Child_Node('DOCUMENT_NUMBER'
622: ,NULL
623: );
624: Ja_Cn_Utility.Add_Child_Node('GENDER'
625: ,NULL
626: );
627: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
628: ,NULL

Line 627: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'

623: );
624: Ja_Cn_Utility.Add_Child_Node('GENDER'
625: ,NULL
626: );
627: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
628: ,NULL
629: ,8
630: );
631: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

Line 631: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'

627: Ja_Cn_Utility.Add_Fixed_Child_Node('DATE_OF_BIRTH'
628: ,NULL
629: ,8
630: );
631: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
632: ,NULL
633: );
634: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
635: ,NULL

Line 634: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'

630: );
631: Ja_Cn_Utility.Add_Child_Node('DEPARTMENT_ID'
632: ,NULL
633: );
634: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
635: ,NULL
636: ,8
637: );
638: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'

Line 638: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'

634: Ja_Cn_Utility.Add_Fixed_Child_Node('HIRE_DATE'
635: ,NULL
636: ,8
637: );
638: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'
639: ,NULL
640: ,8
641: ,Ja_Cn_Utility.GV_REQUIRED_NO
642: );

Line 641: ,Ja_Cn_Utility.GV_REQUIRED_NO

637: );
638: Ja_Cn_Utility.Add_Fixed_Child_Node('TERMINATION_DATE'
639: ,NULL
640: ,8
641: ,Ja_Cn_Utility.GV_REQUIRED_NO
642: );
643: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
644: ,Ja_Cn_Utility.GV_TAG_TYPE_END
645: );

Line 643: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'

639: ,NULL
640: ,8
641: ,Ja_Cn_Utility.GV_REQUIRED_NO
642: );
643: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
644: ,Ja_Cn_Utility.GV_TAG_TYPE_END
645: );
646: --RAISE NO_DATA;
647: --End: Added for bug# 9722570

Line 644: ,Ja_Cn_Utility.GV_TAG_TYPE_END

640: ,8
641: ,Ja_Cn_Utility.GV_REQUIRED_NO
642: );
643: Ja_Cn_Utility.Add_Sub_Root_Node('EMPLOYEE_RECORDS'
644: ,Ja_Cn_Utility.GV_TAG_TYPE_END
645: );
646: --RAISE NO_DATA;
647: --End: Added for bug# 9722570
648: END IF; --ln_rec_count = 0

Line 669: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');

665: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
666: 'exception',
667: 'No data for Employee Records');
668: END IF; --ln_proc_level>=ln_dbg_level
669: Ja_Cn_Utility.Print_No_Data_Found_For_Log('EMPLOYEE_RECORDS');
670: RAISE;*/
671: --End: Deleted for bug# 9722570
672: WHEN OTHERS THEN
673: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)