APPS.PAY_NL_IZA_UPLOAD dependencies on HR_UTILITY

Line 268: hr_utility.trace_on(NULL,'IZA');

264: -- g_debug := TRUE;
265:
266:
267: if g_debug then
268: hr_utility.trace_on(NULL,'IZA');
269: -- input parameters
270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );

Line 270: hr_utility.set_location('p_file_name '||p_file_name,250);

266:
267: if g_debug then
268: hr_utility.trace_on(NULL,'IZA');
269: -- input parameters
270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);

Line 271: hr_utility.set_location('p_effective_date '||p_effective_date,250);

267: if g_debug then
268: hr_utility.trace_on(NULL,'IZA');
269: -- input parameters
270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);

Line 272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );

268: hr_utility.trace_on(NULL,'IZA');
269: -- input parameters
270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);
276: hr_utility.set_location ( 'Entering:' || l_proc, 250);

Line 273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);

269: -- input parameters
270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);
276: hr_utility.set_location ( 'Entering:' || l_proc, 250);
277:

Line 274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);

270: hr_utility.set_location('p_file_name '||p_file_name,250);
271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);
276: hr_utility.set_location ( 'Entering:' || l_proc, 250);
277:
278: end if;

Line 275: hr_utility.set_location('p_batch_name '||p_batch_name,250);

271: hr_utility.set_location('p_effective_date '||p_effective_date,250);
272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);
276: hr_utility.set_location ( 'Entering:' || l_proc, 250);
277:
278: end if;
279:

Line 276: hr_utility.set_location ( 'Entering:' || l_proc, 250);

272: hr_utility.set_location('p_business_group_id '||p_business_group_id,250 );
273: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,250);
274: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,250);
275: hr_utility.set_location('p_batch_name '||p_batch_name,250);
276: hr_utility.set_location ( 'Entering:' || l_proc, 250);
277:
278: end if;
279:
280: c_read_file := 'r';

Line 304: hr_utility.set_location ( 'directory = ' || l_location, 270);

300: l_filename := p_file_name;
301: fnd_profile.get (c_data_exchange_dir, l_location);
302:
303: if g_debug then
304: hr_utility.set_location ( 'directory = ' || l_location, 270);
305: end if;
306:
307: IF l_location IS NULL
308: THEN

Line 376: hr_utility.set_location (l_proc, 350);

372: UTL_FILE.fclose (l_file_handle);
373: END IF;
374:
375: if g_debug then
376: hr_utility.set_location (l_proc, 350);
377: end if;
378:
379: retcode := c_error;
380: l_input_line_num := l_batch_seq + 1;

Line 397: hr_utility.set_location ( 'line read: ' || SUBSTR (l_line_read, 1, 40), 350);

393: END;
394:
395: if g_debug then
396:
397: hr_utility.set_location ( 'line read: ' || SUBSTR (l_line_read, 1, 40), 350);
398:
399: end if;
400:
401: -- Performing the necessary actions for a Data Record

Line 411: hr_utility.set_location ( 'l_rec_client_num: ' || SUBSTR (l_rec_client_num, 1, 40), 350);

407: l_rec_client_num:= SUBSTR (l_line_read,4,3);
408: l_rec_sub_emplr_num := SUBSTR (l_line_read,22,3);
409:
410: if g_debug then
411: hr_utility.set_location ( 'l_rec_client_num: ' || SUBSTR (l_rec_client_num, 1, 40), 350);
412: hr_utility.set_location ( 'l_rec_sub_emplr_num: ' || SUBSTR (l_rec_sub_emplr_num, 1, 40), 350);
413: end if;
414:
415: OPEN csr_organization_id(l_rec_client_num,l_rec_sub_emplr_num,p_business_group_id);

Line 412: hr_utility.set_location ( 'l_rec_sub_emplr_num: ' || SUBSTR (l_rec_sub_emplr_num, 1, 40), 350);

408: l_rec_sub_emplr_num := SUBSTR (l_line_read,22,3);
409:
410: if g_debug then
411: hr_utility.set_location ( 'l_rec_client_num: ' || SUBSTR (l_rec_client_num, 1, 40), 350);
412: hr_utility.set_location ( 'l_rec_sub_emplr_num: ' || SUBSTR (l_rec_sub_emplr_num, 1, 40), 350);
413: end if;
414:
415: OPEN csr_organization_id(l_rec_client_num,l_rec_sub_emplr_num,p_business_group_id);
416: FETCH csr_organization_id INTO l_rec_org_id;

Line 423: hr_utility.set_location ( 'l_rec_org_id: ' || SUBSTR (l_rec_org_id, 1, 40), 350);

419: END IF;
420: CLOSE csr_organization_id;
421:
422: if g_debug then
423: hr_utility.set_location ( 'l_rec_org_id: ' || SUBSTR (l_rec_org_id, 1, 40), 350);
424: end if;
425:
426:
427: OPEN csr_org_struct_version_id(p_business_group_id,l_period_eff_end_date);

Line 432: hr_utility.set_location ( 'l_org_struct_version_id: ' || SUBSTR (l_org_struct_version_id, 1, 40), 350);

428: FETCH csr_org_struct_version_id INTO l_org_struct_version_id;
429: CLOSE csr_org_struct_version_id;
430:
431: if g_debug then
432: hr_utility.set_location ( 'l_org_struct_version_id: ' || SUBSTR (l_org_struct_version_id, 1, 40), 350);
433: end if;
434:
435: val_create_batch_line(l_line_read,l_batch_id,l_batch_seq,l_process_yr_mm,l_payroll_center,l_rec_org_id,l_org_struct_version_id,p_business_group_id,fnd_date.canonical_to_date(p_effective_date),l_batch_line_id,l_bl_ovn);
436:

Line 462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);

458:
459: if g_debug then
460:
461: -- input parameters
462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);
463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);

Line 463: hr_utility.set_location('l_org_id '||l_org_id,400);

459: if g_debug then
460:
461: -- input parameters
462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);
463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);

Line 464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );

460:
461: -- input parameters
462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);
463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);

Line 465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);

461: -- input parameters
462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);
463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);

Line 466: hr_utility.set_location('l_employee_number '||l_employee_number,400);

462: hr_utility.set_location('p_business_group_id '||p_business_group_id,400);
463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);

Line 467: hr_utility.set_location('l_process_status '||l_process_status,400);

463: hr_utility.set_location('l_org_id '||l_org_id,400);
464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);

Line 468: hr_utility.set_location('l_province_code '||l_province_code,400);

464: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,400 );
465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);
472: hr_utility.set_location('l_prefix '||l_prefix,400);

Line 469: hr_utility.set_location('l_participant_number '||l_participant_number,400);

465: hr_utility.set_location('csr_missing_employees_rec.person_id '||csr_missing_employees_rec.person_id,400);
466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);
472: hr_utility.set_location('l_prefix '||l_prefix,400);
473:

Line 470: hr_utility.set_location('l_last_name '||l_last_name,400);

466: hr_utility.set_location('l_employee_number '||l_employee_number,400);
467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);
472: hr_utility.set_location('l_prefix '||l_prefix,400);
473:
474: end if;

Line 471: hr_utility.set_location('l_initials '||l_initials,400);

467: hr_utility.set_location('l_process_status '||l_process_status,400);
468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);
472: hr_utility.set_location('l_prefix '||l_prefix,400);
473:
474: end if;
475:

Line 472: hr_utility.set_location('l_prefix '||l_prefix,400);

468: hr_utility.set_location('l_province_code '||l_province_code,400);
469: hr_utility.set_location('l_participant_number '||l_participant_number,400);
470: hr_utility.set_location('l_last_name '||l_last_name,400);
471: hr_utility.set_location('l_initials '||l_initials,400);
472: hr_utility.set_location('l_prefix '||l_prefix,400);
473:
474: end if;
475:
476: l_process_status:='MISSING';

Line 531: hr_utility.set_location ( 'Leaving:'|| l_proc, 500);

527: COMMIT;
528: UTL_FILE.fclose (l_file_handle);
529:
530: if g_debug then
531: hr_utility.set_location ( 'Leaving:'|| l_proc, 500);
532: end if;
533:
534: -- Most off these exceptions are not translated as they should not happen normally
535: -- If they do happen, something is seriously wrong and SysAdmin interference will be necessary.

Line 550: hr_utility.set_location (l_proc, 500);

546: UTL_FILE.fclose (l_file_handle);
547: END IF;
548:
549: if g_debug then
550: hr_utility.set_location (l_proc, 500);
551: end if;
552: -- Set retcode to 2, indicating an ERROR to the ConcMgr
553: retcode := 2;
554:

Line 574: hr_utility.set_location (l_proc, 500);

570: UTL_FILE.fclose (l_file_handle);
571: END IF;
572:
573: if g_debug then
574: hr_utility.set_location (l_proc, 500);
575: end if;
576:
577: -- Set retcode to 2, indicating an ERROR to the ConcMgr
578: retcode := c_error;

Line 582: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');

578: retcode := c_error;
579:
580: -- Set the application error
581:
582: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
583:
584: -- Return the message to the ConcMgr (This msg will appear in the log file)
585: errbuf := hr_utility.get_message;
586:

Line 585: errbuf := hr_utility.get_message;

581:
582: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
583:
584: -- Return the message to the ConcMgr (This msg will appear in the log file)
585: errbuf := hr_utility.get_message;
586:
587: WHEN UTL_FILE.invalid_operation
588: -- File could not be opened as requested, perhaps because of operating system permissions
589: -- Also raised when attempting a write operation on a file opened for read, or a read operation

Line 599: hr_utility.set_location (l_proc, 550);

595: UTL_FILE.fclose (l_file_handle);
596: END IF;
597:
598: if g_debug then
599: hr_utility.set_location (l_proc, 550);
600: end if;
601:
602: retcode := c_error;
603:

Line 620: hr_utility.set_location (l_proc, 550);

616: UTL_FILE.fclose (l_file_handle);
617: END IF;
618:
619: if g_debug then
620: hr_utility.set_location (l_proc, 550);
621: end if;
622:
623: retcode := c_error;
624:

Line 641: hr_utility.set_location (l_proc, 550);

637: UTL_FILE.fclose (l_file_handle);
638: END IF;
639:
640: if g_debug then
641: hr_utility.set_location (l_proc, 550);
642: end if;
643:
644: retcode := c_error;
645:

Line 669: hr_utility.set_location (l_proc, 550);

665: errbuf := fnd_message.get();
666:
667:
668: if g_debug then
669: hr_utility.set_location (l_proc, 550);
670: end if;
671:
672: WHEN UTL_FILE.invalid_filehandle
673: -- File handle does not specify an open file

Line 681: hr_utility.set_location (l_proc, 550);

677: UTL_FILE.fclose (l_file_handle);
678: END IF;
679:
680: if g_debug then
681: hr_utility.set_location (l_proc, 550);
682: end if;
683:
684: retcode := c_error;
685:

Line 704: hr_utility.set_location (l_proc, 650);

700: UTL_FILE.fclose (l_file_handle);
701: END IF;
702:
703: if g_debug then
704: hr_utility.set_location (l_proc, 650);
705: end if;
706:
707:
708: fnd_message.set_name('PAY','PAY_NL_FILE_READ_ERROR');

Line 772: hr_utility.set_location ( 'Entering:'

768:
769:
770:
771: if g_debug then
772: hr_utility.set_location ( 'Entering:'
773: || l_proc, 700);
774: end if;
775:
776: -- CREATE_BATCH_HEADER definition

Line 823: hr_utility.set_location ( 'Leaving:'

819: );
820:
821: if g_debug then
822:
823: hr_utility.set_location ( 'Leaving:'
824: || l_proc, 750);
825: end if;
826:
827:

Line 861: hr_utility.set_location ( 'Entering:'|| l_proc, 800);

857:
858: BEGIN
859:
860: if g_debug then
861: hr_utility.set_location ( 'Entering:'|| l_proc, 800);
862: end if;
863:
864: l_proc := g_package|| 'create_batch_line';
865:

Line 883: hr_utility.set_location ( 'Leaving:'

879: p_object_version_number => p_obj_vn
880: );
881:
882: if g_debug then
883: hr_utility.set_location ( 'Leaving:'
884: || l_proc, 800);
885: end if;
886:
887: END create_batch_line;

Line 982: hr_utility.set_location ( 'Inside val_create_batch_line ', 900);

978:
979: BEGIN
980:
981: if g_debug then
982: hr_utility.set_location ( 'Inside val_create_batch_line ', 900);
983: end if;
984:
985: l_reject_reason_code1 := '00';
986: l_reject_reason_code2 := '00';

Line 1004: hr_utility.set_location('l_province_code '||l_province_code,900);

1000:
1001: if g_debug then
1002:
1003: -- input parameters
1004: hr_utility.set_location('l_province_code '||l_province_code,900);
1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);

Line 1005: hr_utility.set_location('l_client_num '||l_client_num,900);

1001: if g_debug then
1002:
1003: -- input parameters
1004: hr_utility.set_location('l_province_code '||l_province_code,900);
1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);
1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);

Line 1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );

1002:
1003: -- input parameters
1004: hr_utility.set_location('l_province_code '||l_province_code,900);
1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);
1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);
1010:

Line 1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);

1003: -- input parameters
1004: hr_utility.set_location('l_province_code '||l_province_code,900);
1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);
1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);
1010:
1011: end if;

Line 1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);

1004: hr_utility.set_location('l_province_code '||l_province_code,900);
1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);
1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);
1010:
1011: end if;
1012:

Line 1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);

1005: hr_utility.set_location('l_client_num '||l_client_num,900);
1006: hr_utility.set_location('l_sub_emplr_num '||l_sub_emplr_num,900 );
1007: hr_utility.set_location('l_exchange_number '||l_exchange_number,900);
1008: hr_utility.set_location('l_participant_number '||l_participant_number,900);
1009: hr_utility.set_location('l_employee_name '||l_employee_name,900);
1010:
1011: end if;
1012:
1013:

Line 1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);

1052:
1053: if g_debug then
1054:
1055: -- input parameters
1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);
1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);

Line 1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);

1053: if g_debug then
1054:
1055: -- input parameters
1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);
1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);
1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);

Line 1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );

1054:
1055: -- input parameters
1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);
1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);
1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);
1062:

Line 1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);

1055: -- input parameters
1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);
1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);
1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);
1062:
1063: end if;

Line 1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);

1056: hr_utility.set_location('l_contribution1 '||l_contribution1,950);
1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);
1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);
1062:
1063: end if;
1064:

Line 1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);

1057: hr_utility.set_location('l_corr_cont1 '||l_corr_cont1,950);
1058: hr_utility.set_location('l_contribution2 '||l_contribution2,950 );
1059: hr_utility.set_location('l_corr_cont2 '||l_corr_cont2,950);
1060: hr_utility.set_location('l_participant_number '||l_participant_number,950);
1061: hr_utility.set_location('l_employee_number '||l_employee_number,950);
1062:
1063: end if;
1064:
1065:

Line 1097: hr_utility.set_location('l_person_id '||l_person_id,970);

1093:
1094: if g_debug then
1095:
1096: -- input parameters
1097: hr_utility.set_location('l_person_id '||l_person_id,970);
1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1099: hr_utility.set_location('p_org_id '||p_org_id,970);
1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);

Line 1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);

1094: if g_debug then
1095:
1096: -- input parameters
1097: hr_utility.set_location('l_person_id '||l_person_id,970);
1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1099: hr_utility.set_location('p_org_id '||p_org_id,970);
1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);
1102: end if;

Line 1099: hr_utility.set_location('p_org_id '||p_org_id,970);

1095:
1096: -- input parameters
1097: hr_utility.set_location('l_person_id '||l_person_id,970);
1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1099: hr_utility.set_location('p_org_id '||p_org_id,970);
1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);
1102: end if;
1103:

Line 1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);

1096: -- input parameters
1097: hr_utility.set_location('l_person_id '||l_person_id,970);
1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1099: hr_utility.set_location('p_org_id '||p_org_id,970);
1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);
1102: end if;
1103:
1104:

Line 1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);

1097: hr_utility.set_location('l_person_id '||l_person_id,970);
1098: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1099: hr_utility.set_location('p_org_id '||p_org_id,970);
1100: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1101: hr_utility.set_location('l_reject_reason_code1 '||l_reject_reason_code1,970);
1102: end if;
1103:
1104:
1105: IF l_corr_cont1 <> 0 THEN

Line 1124: hr_utility.set_location('l_person_id '||l_person_id,970);

1120:
1121: if g_debug then
1122:
1123: -- input parameters
1124: hr_utility.set_location('l_person_id '||l_person_id,970);
1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1126: hr_utility.set_location('p_org_id '||p_org_id,970);
1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);

Line 1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);

1121: if g_debug then
1122:
1123: -- input parameters
1124: hr_utility.set_location('l_person_id '||l_person_id,970);
1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1126: hr_utility.set_location('p_org_id '||p_org_id,970);
1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);
1129: end if;

Line 1126: hr_utility.set_location('p_org_id '||p_org_id,970);

1122:
1123: -- input parameters
1124: hr_utility.set_location('l_person_id '||l_person_id,970);
1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1126: hr_utility.set_location('p_org_id '||p_org_id,970);
1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);
1129: end if;
1130:

Line 1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);

1123: -- input parameters
1124: hr_utility.set_location('l_person_id '||l_person_id,970);
1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1126: hr_utility.set_location('p_org_id '||p_org_id,970);
1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);
1129: end if;
1130:
1131:

Line 1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);

1124: hr_utility.set_location('l_person_id '||l_person_id,970);
1125: hr_utility.set_location('l_assignment_id '||l_assignment_id,970);
1126: hr_utility.set_location('p_org_id '||p_org_id,970);
1127: hr_utility.set_location('l_assignment_num '||l_assignment_num,970);
1128: hr_utility.set_location('l_reject_reason_code2 '||l_reject_reason_code2,970);
1129: end if;
1130:
1131:
1132: IF l_corr_cont2 <> 0 THEN

Line 1150: hr_utility.set_location('l_person_id '||l_person_id,1000);

1146:
1147: if g_debug then
1148:
1149: -- input parameters
1150: hr_utility.set_location('l_person_id '||l_person_id,1000);
1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);
1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );
1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);
1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);

Line 1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);

1147: if g_debug then
1148:
1149: -- input parameters
1150: hr_utility.set_location('l_person_id '||l_person_id,1000);
1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);
1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );
1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);
1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);
1155: end if;

Line 1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );

1148:
1149: -- input parameters
1150: hr_utility.set_location('l_person_id '||l_person_id,1000);
1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);
1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );
1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);
1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);
1155: end if;
1156:

Line 1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);

1149: -- input parameters
1150: hr_utility.set_location('l_person_id '||l_person_id,1000);
1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);
1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );
1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);
1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);
1155: end if;
1156:
1157:

Line 1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);

1150: hr_utility.set_location('l_person_id '||l_person_id,1000);
1151: hr_utility.set_location('l_assignment_id '||l_assignment_id,1000);
1152: hr_utility.set_location('p_org_id '||p_org_id,1000 );
1153: hr_utility.set_location('l_assignment_num '||l_assignment_num,1000);
1154: hr_utility.set_location('l_reject_reason_code3 '||l_reject_reason_code3,1000);
1155: end if;
1156:
1157:
1158:

Line 1349: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1345: END IF;
1346:
1347: EXCEPTION
1348: WHEN OTHERS then
1349: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1350: HR_UTILITY.RAISE_ERROR;
1351:
1352:
1353: end val_create_batch_line;

Line 1350: HR_UTILITY.RAISE_ERROR;

1346:
1347: EXCEPTION
1348: WHEN OTHERS then
1349: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1350: HR_UTILITY.RAISE_ERROR;
1351:
1352:
1353: end val_create_batch_line;
1354:

Line 1491: hr_utility.set_location('l_length_process_period '||l_length_process_period,1350);

1487:
1488: if g_debug then
1489:
1490: -- input parameters
1491: hr_utility.set_location('l_length_process_period '||l_length_process_period,1350);
1492: hr_utility.set_location('l_employee_number '||l_employee_number,1350);
1493: end if;
1494:
1495:

Line 1492: hr_utility.set_location('l_employee_number '||l_employee_number,1350);

1488: if g_debug then
1489:
1490: -- input parameters
1491: hr_utility.set_location('l_length_process_period '||l_length_process_period,1350);
1492: hr_utility.set_location('l_employee_number '||l_employee_number,1350);
1493: end if;
1494:
1495:
1496: OPEN csr_emp_num_exists(l_employee_number,p_business_group_id,p_period_start_date,p_period_end_date) ;

Line 1503: hr_utility.set_location('p_person_id '||p_person_id,1350);

1499:
1500: if g_debug then
1501:
1502: -- input parameters
1503: hr_utility.set_location('p_person_id '||p_person_id,1350);
1504: hr_utility.set_location('p_assignment_id '||p_assignment_id,1350);
1505: hr_utility.set_location('p_assignment_num '||p_assignment_num,1350 );
1506: end if;
1507:

Line 1504: hr_utility.set_location('p_assignment_id '||p_assignment_id,1350);

1500: if g_debug then
1501:
1502: -- input parameters
1503: hr_utility.set_location('p_person_id '||p_person_id,1350);
1504: hr_utility.set_location('p_assignment_id '||p_assignment_id,1350);
1505: hr_utility.set_location('p_assignment_num '||p_assignment_num,1350 );
1506: end if;
1507:
1508:

Line 1505: hr_utility.set_location('p_assignment_num '||p_assignment_num,1350 );

1501:
1502: -- input parameters
1503: hr_utility.set_location('p_person_id '||p_person_id,1350);
1504: hr_utility.set_location('p_assignment_id '||p_assignment_id,1350);
1505: hr_utility.set_location('p_assignment_num '||p_assignment_num,1350 );
1506: end if;
1507:
1508:
1509: IF p_person_id IS NULL THEN

Line 1523: hr_utility.set_location('l_current_employee_flag '||l_current_employee_flag,1350);

1519:
1520: if g_debug then
1521:
1522: -- input parameters
1523: hr_utility.set_location('l_current_employee_flag '||l_current_employee_flag,1350);
1524: end if;
1525:
1526:
1527: IF l_current_employee_flag IS NULL THEN

Line 1542: hr_utility.set_location('l_iza_insured_flag '||l_iza_insured_flag,1400);

1538:
1539: if g_debug then
1540:
1541: -- input parameters
1542: hr_utility.set_location('l_iza_insured_flag '||l_iza_insured_flag,1400);
1543: end if;
1544:
1545: IF l_iza_insured_flag IS NULL THEN
1546: p_reject_reason_code := '02';

Line 1560: hr_utility.set_location('l_contract_other_cmpny '||l_contract_other_cmpny,1400);

1556:
1557: if g_debug then
1558:
1559: -- input parameters
1560: hr_utility.set_location('l_contract_other_cmpny '||l_contract_other_cmpny,1400);
1561: end if;
1562:
1563: IF l_contract_other_cmpny IS NOT NULL THEN
1564: p_reject_reason_code := '03';

Line 1581: hr_utility.set_location('l_leave_days '||l_leave_days,1400);

1577:
1578: if g_debug then
1579:
1580: -- input parameters
1581: hr_utility.set_location('l_leave_days '||l_leave_days,1400);
1582: end if;
1583:
1584: IF l_leave_days = l_length_process_period THEN
1585: p_reject_reason_code := '04';

Line 1595: hr_utility.set_location('p_org_id '||p_org_id,1450);

1591:
1592: if g_debug then
1593:
1594: -- input parameters
1595: hr_utility.set_location('p_org_id '||p_org_id,1450);
1596: end if;
1597:
1598:
1599: IF l_already_rejected_flag = 'N' THEN

Line 1611: hr_utility.set_location('p_assignment_id '||p_assignment_id,1450);

1607:
1608: if g_debug then
1609:
1610: -- input parameters
1611: hr_utility.set_location('p_assignment_id '||p_assignment_id,1450);
1612: hr_utility.set_location('p_assignment_num '||p_assignment_num,1450);
1613: end if;
1614:
1615: IF p_assignment_id IS NULL then

Line 1612: hr_utility.set_location('p_assignment_num '||p_assignment_num,1450);

1608: if g_debug then
1609:
1610: -- input parameters
1611: hr_utility.set_location('p_assignment_id '||p_assignment_id,1450);
1612: hr_utility.set_location('p_assignment_num '||p_assignment_num,1450);
1613: end if;
1614:
1615: IF p_assignment_id IS NULL then
1616: p_reject_reason_code := '05';

Line 1629: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1625:
1626:
1627: EXCEPTION
1628: WHEN OTHERS then
1629: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1630: HR_UTILITY.RAISE_ERROR;
1631:
1632:
1633: end iza_validation;

Line 1630: HR_UTILITY.RAISE_ERROR;

1626:
1627: EXCEPTION
1628: WHEN OTHERS then
1629: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1630: HR_UTILITY.RAISE_ERROR;
1631:
1632:
1633: end iza_validation;
1634:

Line 1668: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1664: AND pizas.business_group_id = p_business_group_id;
1665:
1666: EXCEPTION
1667: WHEN OTHERS then
1668: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1669: HR_UTILITY.RAISE_ERROR;
1670:
1671: end purge_iza_process_status;
1672:

Line 1669: HR_UTILITY.RAISE_ERROR;

1665:
1666: EXCEPTION
1667: WHEN OTHERS then
1668: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1669: HR_UTILITY.RAISE_ERROR;
1670:
1671: end purge_iza_process_status;
1672:
1673: END PAY_NL_IZA_UPLOAD;