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_H2PI_BG_UPLOAD dependencies on HR_UTILITY

Line 71: hr_utility.set_location('Entering:' || l_proc,10);

67: i NUMBER;
68: l_proc varchar2(72) := g_package || '.get_id_from_value' ;
69:
70: BEGIN
71: hr_utility.set_location('Entering:' || l_proc,10);
72: FOR v_rec IN csr_org_info LOOP
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );

Line 73: hr_utility.trace('Context : ' || v_rec.context);

69:
70: BEGIN
71: hr_utility.set_location('Entering:' || l_proc,10);
72: FOR v_rec IN csr_org_info LOOP
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );

Line 96: hr_utility.set_location(l_proc,10);

92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
96: hr_utility.set_location(l_proc,10);
97: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
98: (
99: appl_short_name => 'PER',
100: desc_flex_name => 'Org Developer DF',

Line 103: hr_utility.set_location(l_proc,30);

99: appl_short_name => 'PER',
100: desc_flex_name => 'Org Developer DF',
101: values_or_ids => 'V'
102: );
103: hr_utility.set_location(l_proc,30);
104:
105: i:=1;
106:
107: FOR v_org_info IN csr_flex_cols(v_rec.context) LOOP

Line 110: hr_utility.trace('Column Name : ' || v_org_info.col_name);

106:
107: FOR v_org_info IN csr_flex_cols(v_rec.context) LOOP
108: IF v_org_info.col_name = 'ORG_INFORMATION'||TO_CHAR(p_org_info_number) THEN
109: idx := i;
110: hr_utility.trace('Column Name : ' || v_org_info.col_name);
111: END IF;
112: i:=i+1;
113: END LOOP;
114:

Line 123: hr_utility.trace(l_seg_id || ':' || l_seg_value);

119: l_seg_value,
120: l_seg_desc
121: from dual;
122:
123: hr_utility.trace(l_seg_id || ':' || l_seg_value);
124: hr_utility.trace(fnd_flex_descval.error_message());
125: return(l_seg_id);
126: END LOOP;
127: hr_utility.set_location('Leaving:' || l_proc,90);

Line 124: hr_utility.trace(fnd_flex_descval.error_message());

120: l_seg_desc
121: from dual;
122:
123: hr_utility.trace(l_seg_id || ':' || l_seg_value);
124: hr_utility.trace(fnd_flex_descval.error_message());
125: return(l_seg_id);
126: END LOOP;
127: hr_utility.set_location('Leaving:' || l_proc,90);
128: END;

Line 127: hr_utility.set_location('Leaving:' || l_proc,90);

123: hr_utility.trace(l_seg_id || ':' || l_seg_value);
124: hr_utility.trace(fnd_flex_descval.error_message());
125: return(l_seg_id);
126: END LOOP;
127: hr_utility.set_location('Leaving:' || l_proc,90);
128: END;
129:
130: PROCEDURE upload_location (p_from_client_id NUMBER) IS
131:

Line 148: hr_utility.set_location('Entering:'|| l_proc, 10);

144:
145:
146:
147: BEGIN
148: hr_utility.set_location('Entering:'|| l_proc, 10);
149:
150: FOR v_ud_loc in csr_locations(p_from_client_id) LOOP
151:
152: SAVEPOINT location_start;

Line 155: hr_utility.set_location(l_proc, 20);

151:
152: SAVEPOINT location_start;
153:
154: BEGIN
155: hr_utility.set_location(l_proc, 20);
156: l_location_id := hr_h2pi_map.get_to_id
157: (p_table_name => 'HR_LOCATIONS_ALL',
158: p_from_id => v_ud_loc.location_id);
159:

Line 161: hr_utility.set_location(l_proc, 30);

157: (p_table_name => 'HR_LOCATIONS_ALL',
158: p_from_id => v_ud_loc.location_id);
159:
160: IF l_location_id = -1 THEN
161: hr_utility.set_location(l_proc, 30);
162: hr_location_api.create_location
163: (p_validate => FALSE
164: ,p_effective_date => SYSDATE
165: ,p_location_code => v_ud_loc.location_code

Line 220: hr_utility.set_location(l_proc, 40);

216: p_from_id => v_ud_loc.location_id,
217: p_to_id => l_location_id);
218: ELSE
219: BEGIN
220: hr_utility.set_location(l_proc, 40);
221: SELECT loc.object_version_number
222: INTO l_ovn
223: FROM hr_locations_all loc
224: WHERE loc.location_id = l_location_id;

Line 227: hr_utility.set_location(l_proc, 50);

223: FROM hr_locations_all loc
224: WHERE loc.location_id = l_location_id;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: hr_utility.set_location(l_proc, 50);
228: RAISE MAPPING_ID_INVALID;
229: END;
230:
231: hr_utility.set_location(l_proc, 60);

Line 231: hr_utility.set_location(l_proc, 60);

227: hr_utility.set_location(l_proc, 50);
228: RAISE MAPPING_ID_INVALID;
229: END;
230:
231: hr_utility.set_location(l_proc, 60);
232: hr_location_api.update_location
233: (p_validate => FALSE
234: ,p_effective_date => SYSDATE
235: ,p_location_id => l_location_id

Line 286: hr_utility.set_location(l_proc, 70);

282: );
283:
284: END IF;
285:
286: hr_utility.set_location(l_proc, 70);
287: UPDATE hr_h2pi_locations
288: SET status = 'C'
289: WHERE location_id = v_ud_loc.location_id
290: AND client_id = p_from_client_id;

Line 297: hr_utility.set_location(l_proc, 80);

293:
294: EXCEPTION
295: WHEN MAPPING_ID_INVALID THEN
296: ROLLBACK;
297: hr_utility.set_location(l_proc, 80);
298: hr_h2pi_error.data_error
299: (p_from_id => l_location_id,
300: p_table_name => 'HR_H2PI_LOCATIONS',
301: p_message_level => 'FATAL',

Line 305: hr_utility.set_location(l_proc, 90);

301: p_message_level => 'FATAL',
302: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
303: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
304: ROLLBACK;
305: hr_utility.set_location(l_proc, 90);
306: l_encoded_message := fnd_message.get_encoded;
307: hr_h2pi_error.data_error
308: (p_from_id => v_ud_loc.location_id,
309: p_table_name => 'HR_H2PI_LOCATIONS',

Line 316: hr_utility.set_location('Leaving:'|| l_proc, 100);

312: END;
313:
314: END LOOP;
315:
316: hr_utility.set_location('Leaving:'|| l_proc, 100);
317: COMMIT;
318:
319: END;
320:

Line 398: hr_utility.set_location('Entering:'|| l_proc, 10);

394:
395: l_proc VARCHAR2(72) := g_package||'upload_hr_organization';
396:
397: BEGIN
398: hr_utility.set_location('Entering:'|| l_proc, 10);
399:
400: -- Insert fnd_sessions row
401: OPEN csr_session_date;
402: hr_utility.set_location(l_proc, 11);

Line 402: hr_utility.set_location(l_proc, 11);

398: hr_utility.set_location('Entering:'|| l_proc, 10);
399:
400: -- Insert fnd_sessions row
401: OPEN csr_session_date;
402: hr_utility.set_location(l_proc, 11);
403: FETCH csr_session_date into l_session_date;
404: hr_utility.set_location(l_proc, 12);
405: IF csr_session_date%notfound then
406: hr_utility.set_location(l_proc, 13);

Line 404: hr_utility.set_location(l_proc, 12);

400: -- Insert fnd_sessions row
401: OPEN csr_session_date;
402: hr_utility.set_location(l_proc, 11);
403: FETCH csr_session_date into l_session_date;
404: hr_utility.set_location(l_proc, 12);
405: IF csr_session_date%notfound then
406: hr_utility.set_location(l_proc, 13);
407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
408: values(userenv('sessionid'), trunc(SYSDATE));

Line 406: hr_utility.set_location(l_proc, 13);

402: hr_utility.set_location(l_proc, 11);
403: FETCH csr_session_date into l_session_date;
404: hr_utility.set_location(l_proc, 12);
405: IF csr_session_date%notfound then
406: hr_utility.set_location(l_proc, 13);
407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
408: values(userenv('sessionid'), trunc(SYSDATE));
409: hr_utility.set_location(l_proc, 14);
410: hr_utility.set_location(l_proc || ': ' || userenv('sessionid'), 15);

Line 409: hr_utility.set_location(l_proc, 14);

405: IF csr_session_date%notfound then
406: hr_utility.set_location(l_proc, 13);
407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
408: values(userenv('sessionid'), trunc(SYSDATE));
409: hr_utility.set_location(l_proc, 14);
410: hr_utility.set_location(l_proc || ': ' || userenv('sessionid'), 15);
411: END IF;
412: CLOSE csr_session_date;
413: --

Line 410: hr_utility.set_location(l_proc || ': ' || userenv('sessionid'), 15);

406: hr_utility.set_location(l_proc, 13);
407: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
408: values(userenv('sessionid'), trunc(SYSDATE));
409: hr_utility.set_location(l_proc, 14);
410: hr_utility.set_location(l_proc || ': ' || userenv('sessionid'), 15);
411: END IF;
412: CLOSE csr_session_date;
413: --
414:

Line 417: hr_utility.set_location(l_proc, 20);

413: --
414:
415: FOR v_ud_org IN csr_orgs(p_from_client_id) LOOP
416:
417: hr_utility.set_location(l_proc, 20);
418: SAVEPOINT hr_org_start;
419:
420: BEGIN
421: IF v_ud_org.hr_org = 1 THEN

Line 424: hr_utility.set_location(l_proc, 30);

420: BEGIN
421: IF v_ud_org.hr_org = 1 THEN
422:
423: l_hr_org_id := NULL;
424: hr_utility.set_location(l_proc, 30);
425: OPEN csr_hr_org(v_ud_org.organization_id);
426: FETCH csr_hr_org INTO v_ud_hr_org;
427: CLOSE csr_hr_org;
428:

Line 429: hr_utility.set_location(l_proc, 40);

425: OPEN csr_hr_org(v_ud_org.organization_id);
426: FETCH csr_hr_org INTO v_ud_hr_org;
427: CLOSE csr_hr_org;
428:
429: hr_utility.set_location(l_proc, 40);
430: l_location_id := hr_h2pi_map.get_to_id
431: (p_table_name => 'HR_LOCATIONS_ALL',
432: p_from_id => v_ud_hr_org.location_id,
433: p_report_error => TRUE);

Line 439: hr_utility.set_location(l_proc, 50);

435: l_hr_org_id := hr_h2pi_map.get_to_id
436: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
437: p_from_id => v_ud_hr_org.organization_id);
438:
439: hr_utility.set_location(l_proc, 50);
440: IF l_hr_org_id = -1 THEN
441: hr_utility.set_location(l_proc, 60);
442: hr_organization_api.create_organization
443: (p_effective_date => SYSDATE

Line 441: hr_utility.set_location(l_proc, 60);

437: p_from_id => v_ud_hr_org.organization_id);
438:
439: hr_utility.set_location(l_proc, 50);
440: IF l_hr_org_id = -1 THEN
441: hr_utility.set_location(l_proc, 60);
442: hr_organization_api.create_organization
443: (p_effective_date => SYSDATE
444: ,p_business_group_id => hr_h2pi_upload.g_to_business_group_id
445: ,p_date_from => v_ud_hr_org.date_from

Line 480: hr_utility.set_location(l_proc, 70);

476: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
477: p_from_id => v_ud_hr_org.organization_id,
478: p_to_id => l_hr_org_id);
479: ELSE
480: hr_utility.set_location(l_proc, 70);
481: BEGIN
482: SELECT org.object_version_number
483: INTO l_ovn
484: FROM hr_all_organization_units org

Line 488: hr_utility.set_location(l_proc, 75);

484: FROM hr_all_organization_units org
485: WHERE org.organization_id = l_hr_org_id;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: hr_utility.set_location(l_proc, 75);
489: ROLLBACK;
490: hr_h2pi_error.data_error
491: (p_from_id => l_hr_org_class_id,
492: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

Line 498: hr_utility.set_location(l_proc, 80);

494: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
495: RAISE MAPPING_ID_INVALID;
496: END;
497:
498: hr_utility.set_location(l_proc, 80);
499: hr_organization_api.update_organization
500: (p_effective_date => SYSDATE
501: ,p_organization_id => l_hr_org_id
502: ,p_date_from => v_ud_hr_org.date_from

Line 531: hr_utility.set_location(l_proc, 90);

527: );
528:
529: END IF;
530:
531: hr_utility.set_location(l_proc, 90);
532: UPDATE hr_h2pi_hr_organizations
533: SET status = 'C'
534: WHERE organization_id = v_ud_hr_org.organization_id
535: AND client_id = p_from_client_id;

Line 539: hr_utility.set_location(l_proc, 94);

535: AND client_id = p_from_client_id;
536:
537: ELSE
538:
539: hr_utility.set_location(l_proc, 94);
540: l_hr_org_id := hr_h2pi_map.get_to_id
541: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
542: p_from_id => v_ud_org.organization_id,
543: p_report_error => TRUE);

Line 552: hr_utility.set_location(l_proc, 100);

548: FOR v_ud_hr_org_class IN csr_hr_org_class(v_ud_org.organization_id)
549: LOOP
550:
551: BEGIN
552: hr_utility.set_location(l_proc, 100);
553: l_hr_org_class_id := hr_h2pi_map.get_to_id
554: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
555: p_from_id => v_ud_hr_org_class.org_information_id);
556:

Line 557: hr_utility.set_location(l_proc, 110);

553: l_hr_org_class_id := hr_h2pi_map.get_to_id
554: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
555: p_from_id => v_ud_hr_org_class.org_information_id);
556:
557: hr_utility.set_location(l_proc, 110);
558: IF l_hr_org_class_id = -1 THEN
559: hr_utility.set_location(l_proc, 120);
560: hr_organization_api.create_org_classification
561: (p_effective_date => SYSDATE

Line 559: hr_utility.set_location(l_proc, 120);

555: p_from_id => v_ud_hr_org_class.org_information_id);
556:
557: hr_utility.set_location(l_proc, 110);
558: IF l_hr_org_class_id = -1 THEN
559: hr_utility.set_location(l_proc, 120);
560: hr_organization_api.create_org_classification
561: (p_effective_date => SYSDATE
562: ,p_organization_id => l_hr_org_id
563: ,p_org_classif_code => v_ud_hr_org_class.org_information1

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

570: p_from_id => v_ud_hr_org_class.org_information_id,
571: p_to_id => l_hr_org_class_id);
572: END IF;
573:
574: hr_utility.set_location(l_proc, 130);
575: hr_utility.set_location(l_proc, l_hr_org_class_id);
576: BEGIN
577: SELECT org_information2,
578: object_version_number

Line 575: hr_utility.set_location(l_proc, l_hr_org_class_id);

571: p_to_id => l_hr_org_class_id);
572: END IF;
573:
574: hr_utility.set_location(l_proc, 130);
575: hr_utility.set_location(l_proc, l_hr_org_class_id);
576: BEGIN
577: SELECT org_information2,
578: object_version_number
579: INTO l_org_info2,

Line 585: hr_utility.set_location(l_proc, 135);

581: FROM hr_organization_information
582: WHERE org_information_id = l_hr_org_class_id;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: hr_utility.set_location(l_proc, 135);
586: ROLLBACK;
587: hr_h2pi_error.data_error
588: (p_from_id => l_hr_org_class_id,
589: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

Line 595: hr_utility.set_location(l_proc, 140);

591: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
592: RAISE MAPPING_ID_INVALID;
593: END;
594:
595: hr_utility.set_location(l_proc, 140);
596: IF v_ud_hr_org_class.org_information2 = 'N' AND
597: l_org_info2 = 'Y' THEN
598: hr_utility.set_location(l_proc, 150);
599: hr_organization_api.disable_org_classification

Line 598: hr_utility.set_location(l_proc, 150);

594:
595: hr_utility.set_location(l_proc, 140);
596: IF v_ud_hr_org_class.org_information2 = 'N' AND
597: l_org_info2 = 'Y' THEN
598: hr_utility.set_location(l_proc, 150);
599: hr_organization_api.disable_org_classification
600: (p_effective_date => SYSDATE
601: ,p_org_information_id => l_hr_org_class_id
602: ,p_org_info_type_code => 'CLASS'

Line 607: hr_utility.set_location(l_proc, 160);

603: ,p_object_version_number => l_ovn
604: );
605: ELSIF v_ud_hr_org_class.org_information2 = 'Y' AND
606: l_org_info2 = 'N' THEN
607: hr_utility.set_location(l_proc, 160);
608: hr_organization_api.enable_org_classification
609: (p_effective_date => SYSDATE
610: ,p_org_information_id => l_hr_org_class_id
611: ,p_org_info_type_code => 'CLASS'

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

616: UPDATE hr_h2pi_organization_class
617: SET status = 'C'
618: WHERE org_information_id = v_ud_hr_org_class.org_information_id
619: AND client_id = p_from_client_id;
620: hr_utility.set_location(l_proc, 170);
621:
622: EXCEPTION
623: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
624: hr_utility.set_location(l_proc, 180);

Line 624: hr_utility.set_location(l_proc, 180);

620: hr_utility.set_location(l_proc, 170);
621:
622: EXCEPTION
623: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
624: hr_utility.set_location(l_proc, 180);
625: l_encoded_message := fnd_message.get_encoded;
626: hr_h2pi_error.data_error
627: (p_from_id => v_ud_hr_org_class.org_information_id,
628: p_table_name => 'HR_H2PI_ORGANIZATION_CLASS',

Line 642: hr_utility.set_location(l_proc, 190);

638:
639: FOR v_ud_hr_org_info in csr_hr_org_info(v_ud_org.organization_id)LOOP
640:
641: BEGIN
642: hr_utility.set_location(l_proc, 190);
643: l_hr_org_info_id := hr_h2pi_map.get_to_id
644: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
645: p_from_id => v_ud_hr_org_info.org_information_id);
646:

Line 647: hr_utility.set_location(l_proc, 200);

643: l_hr_org_info_id := hr_h2pi_map.get_to_id
644: (p_table_name => 'HR_ORGANIZATION_INFORMATION',
645: p_from_id => v_ud_hr_org_info.org_information_id);
646:
647: hr_utility.set_location(l_proc, 200);
648:
649: -- set values from uploaded org info table
650: l_org_info1 := v_ud_hr_org_info.org_information1;
651: l_org_info8 := v_ud_hr_org_info.org_information8;

Line 657: hr_utility.set_location(l_proc, 210);

653: l_org_info10 := v_ud_hr_org_info.org_information10;
654: l_org_info12 := v_ud_hr_org_info.org_information12;
655: l_org_info13 := v_ud_hr_org_info.org_information13;
656:
657: hr_utility.set_location(l_proc, 210);
658:
659: /* Added to take care for value set IDs in org additional info */
660: IF v_ud_hr_org_info.org_information_context = 'SQWL GN Transmitter Rules' THEN
661: -- for MMREF Contact Name

Line 662: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);

658:
659: /* Added to take care for value set IDs in org additional info */
660: IF v_ud_hr_org_info.org_information_context = 'SQWL GN Transmitter Rules' THEN
661: -- for MMREF Contact Name
662: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
663: IF v_ud_hr_org_info.org_information12 IS NOT NULL THEN
664: hr_utility.set_location(l_proc, 220);
665: l_org_info12 := hr_h2pi_map.get_to_id
666: (p_table_name => 'PER_ALL_PEOPLE_F',

Line 664: hr_utility.set_location(l_proc, 220);

660: IF v_ud_hr_org_info.org_information_context = 'SQWL GN Transmitter Rules' THEN
661: -- for MMREF Contact Name
662: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
663: IF v_ud_hr_org_info.org_information12 IS NOT NULL THEN
664: hr_utility.set_location(l_proc, 220);
665: l_org_info12 := hr_h2pi_map.get_to_id
666: (p_table_name => 'PER_ALL_PEOPLE_F',
667: p_from_id => v_ud_hr_org_info.org_information12);
668: hr_utility.set_location(l_proc, 220);

Line 668: hr_utility.set_location(l_proc, 220);

664: hr_utility.set_location(l_proc, 220);
665: l_org_info12 := hr_h2pi_map.get_to_id
666: (p_table_name => 'PER_ALL_PEOPLE_F',
667: p_from_id => v_ud_hr_org_info.org_information12);
668: hr_utility.set_location(l_proc, 220);
669: IF l_org_info12 = -1 THEN
670: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||
671: 'ORG_INFORMATION12'|| ':' ||
672: v_ud_hr_org_info.org_information12 || ':' ||

Line 670: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||

666: (p_table_name => 'PER_ALL_PEOPLE_F',
667: p_from_id => v_ud_hr_org_info.org_information12);
668: hr_utility.set_location(l_proc, 220);
669: IF l_org_info12 = -1 THEN
670: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||
671: 'ORG_INFORMATION12'|| ':' ||
672: v_ud_hr_org_info.org_information12 || ':' ||
673: 'is unsupported');
674:

Line 682: hr_utility.set_location(l_proc, 260);

678: l_org_info12 := v_ud_hr_org_info.org_information12;
679: END IF;
680: -- for Company Name
681: IF v_ud_hr_org_info.org_information13 IS NOT NULL THEN
682: hr_utility.set_location(l_proc, 260);
683: l_org_info13 := hr_h2pi_map.get_to_id
684: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
685: p_from_id =>v_ud_hr_org_info.org_information13);
686: ELSE

Line 691: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);

687: l_org_info13 := v_ud_hr_org_info.org_information13;
688: END IF;
689: ElSIF v_ud_hr_org_info.org_information_context = 'State Tax Rules' THEN
690: -- for WC Carrier Name
691: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
692: IF v_ud_hr_org_info.org_information8 IS NOT NULL THEN
693: l_org_info8 := hr_h2pi_map.get_to_id
694: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
695: p_from_id => v_ud_hr_org_info.org_information8);

Line 701: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);

697: l_org_info8 := v_ud_hr_org_info.org_information8;
698: END IF;
699: ELSIF v_ud_hr_org_info.org_information_context = 'W2 Reporting Rules' THEN
700: -- for Company Name
701: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
702: IF v_ud_hr_org_info.org_information9 IS NOT NULL THEN
703: hr_utility.set_location(l_proc, 270);
704: l_org_info9 := hr_h2pi_map.get_to_id
705: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',

Line 703: hr_utility.set_location(l_proc, 270);

699: ELSIF v_ud_hr_org_info.org_information_context = 'W2 Reporting Rules' THEN
700: -- for Company Name
701: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
702: IF v_ud_hr_org_info.org_information9 IS NOT NULL THEN
703: hr_utility.set_location(l_proc, 270);
704: l_org_info9 := hr_h2pi_map.get_to_id
705: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
706: p_from_id =>v_ud_hr_org_info.org_information9);
707: ELSE

Line 716: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||

712: l_org_info10 := hr_h2pi_map.get_to_id
713: (p_table_name => 'PER_ALL_PEOPLE_F',
714: p_from_id => v_ud_hr_org_info.org_information10);
715: IF l_org_info10 = -1 THEN
716: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||
717: 'ORG_INFORMATION10' || ':' ||
718: v_ud_hr_org_info.org_information10 || ':' ||
719: 'is unsupported');
720: l_org_info10 := NULL;

Line 727: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);

723: l_org_info10 := v_ud_hr_org_info.org_information10;
724: END IF;
725: ELSIF v_ud_hr_org_info.org_information_context = 'Work Schedule' THEN
726: -- for Schedule Table
727: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
728: IF v_ud_hr_org_info.org_information1 IS NOT NULL THEN
729: hr_utility.set_location(l_proc, 210);
730: l_org_info1 := hr_h2pi_map.get_to_id
731: (p_table_name => 'COMPANY_WORK_SCHEDULE',

Line 729: hr_utility.set_location(l_proc, 210);

725: ELSIF v_ud_hr_org_info.org_information_context = 'Work Schedule' THEN
726: -- for Schedule Table
727: hr_utility.trace('Found : ' || v_ud_hr_org_info.org_information_context);
728: IF v_ud_hr_org_info.org_information1 IS NOT NULL THEN
729: hr_utility.set_location(l_proc, 210);
730: l_org_info1 := hr_h2pi_map.get_to_id
731: (p_table_name => 'COMPANY_WORK_SCHEDULE',
732: p_from_id => v_ud_hr_org_info.org_information1);
733: IF l_org_info10 = -1 THEN

Line 734: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||

730: l_org_info1 := hr_h2pi_map.get_to_id
731: (p_table_name => 'COMPANY_WORK_SCHEDULE',
732: p_from_id => v_ud_hr_org_info.org_information1);
733: IF l_org_info10 = -1 THEN
734: hr_utility.trace(v_ud_hr_org_info.org_information_context || ':' ||
735: 'ORG_INFORMATION1' || ':' ||
736: v_ud_hr_org_info.org_information1 || ':' ||
737: 'is unsupported');
738: l_org_info1 := NULL;

Line 748: hr_utility.set_location(l_proc, 210);

744: Null;
745: END IF;
746:
747: IF l_hr_org_info_id = -1 THEN
748: hr_utility.set_location(l_proc, 210);
749:
750: hr_organization_api.create_org_information
751: (p_effective_date => SYSDATE
752: ,p_organization_id => l_hr_org_id

Line 785: hr_utility.set_location(l_proc, 220);

781: p_from_id => v_ud_hr_org_info.org_information_id,
782: p_to_id => l_hr_org_info_id);
783: ELSE
784:
785: hr_utility.set_location(l_proc, 220);
786: hr_utility.set_location(l_proc, l_hr_org_info_id);
787: BEGIN
788: SELECT org_information2,
789: object_version_number

Line 786: hr_utility.set_location(l_proc, l_hr_org_info_id);

782: p_to_id => l_hr_org_info_id);
783: ELSE
784:
785: hr_utility.set_location(l_proc, 220);
786: hr_utility.set_location(l_proc, l_hr_org_info_id);
787: BEGIN
788: SELECT org_information2,
789: object_version_number
790: INTO l_org_info2,

Line 796: hr_utility.set_location(l_proc, 50);

792: FROM hr_organization_information
793: WHERE org_information_id = l_hr_org_info_id;
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: hr_utility.set_location(l_proc, 50);
797: ROLLBACK;
798: hr_h2pi_error.data_error
799: (p_from_id => l_hr_org_info_id,
800: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',

Line 806: hr_utility.set_location(l_proc, 230);

802: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
803: RAISE MAPPING_ID_INVALID;
804: END;
805:
806: hr_utility.set_location(l_proc, 230);
807: hr_organization_api.update_org_information
808: (p_effective_date => SYSDATE
809: ,p_org_info_type_code
810: => v_ud_hr_org_info.org_information_context

Line 841: hr_utility.set_location(l_proc, 240);

837: UPDATE hr_h2pi_organization_info
838: SET status = 'C'
839: WHERE org_information_id = v_ud_hr_org_info.org_information_id
840: AND client_id = p_from_client_id;
841: hr_utility.set_location(l_proc, 240);
842:
843: EXCEPTION
844: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
845: hr_utility.set_location(l_proc, 250);

Line 845: hr_utility.set_location(l_proc, 250);

841: hr_utility.set_location(l_proc, 240);
842:
843: EXCEPTION
844: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
845: hr_utility.set_location(l_proc, 250);
846: l_encoded_message := fnd_message.get_encoded;
847: hr_h2pi_error.data_error
848: (p_from_id => v_ud_hr_org_info.org_information_id,
849: p_table_name => 'HR_H2PI_ORGANIZATION_INFO',

Line 858: hr_utility.set_location(l_proc, 260);

854: END LOOP;
855:
856: END IF;
857:
858: hr_utility.set_location(l_proc, 260);
859: COMMIT;
860:
861: EXCEPTION
862: WHEN MAPPING_ID_INVALID THEN

Line 863: hr_utility.set_location(l_proc, 270);

859: COMMIT;
860:
861: EXCEPTION
862: WHEN MAPPING_ID_INVALID THEN
863: hr_utility.set_location(l_proc, 270);
864: WHEN MAPPING_ID_MISSING THEN
865: hr_utility.set_location(l_proc, 280);
866: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
867: ROLLBACK;

Line 865: hr_utility.set_location(l_proc, 280);

861: EXCEPTION
862: WHEN MAPPING_ID_INVALID THEN
863: hr_utility.set_location(l_proc, 270);
864: WHEN MAPPING_ID_MISSING THEN
865: hr_utility.set_location(l_proc, 280);
866: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
867: ROLLBACK;
868: hr_utility.set_location(l_proc, 290);
869: l_encoded_message := fnd_message.get_encoded;

Line 868: hr_utility.set_location(l_proc, 290);

864: WHEN MAPPING_ID_MISSING THEN
865: hr_utility.set_location(l_proc, 280);
866: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
867: ROLLBACK;
868: hr_utility.set_location(l_proc, 290);
869: l_encoded_message := fnd_message.get_encoded;
870: hr_h2pi_error.data_error
871: (p_from_id => v_ud_hr_org.organization_id,
872: p_table_name => 'HR_H2PI_HR_ORGANIZATIONS',

Line 879: hr_utility.set_location('Leaving:'|| l_proc, 10);

875: END;
876:
877: END LOOP;
878:
879: hr_utility.set_location('Leaving:'|| l_proc, 10);
880: COMMIT;
881:
882:
883: END;

Line 903: hr_utility.set_location('Entering:'|| l_proc, 10);

899:
900: l_proc VARCHAR2(72) := g_package||'upload_element_name';
901:
902: BEGIN
903: hr_utility.set_location('Entering:'|| l_proc, 10);
904: FOR v_ud_ele_name in csr_ele_names(p_from_client_id) LOOP
905:
906: hr_utility.set_location(l_proc, 20);
907: SAVEPOINT hr_ele_name_start;

Line 906: hr_utility.set_location(l_proc, 20);

902: BEGIN
903: hr_utility.set_location('Entering:'|| l_proc, 10);
904: FOR v_ud_ele_name in csr_ele_names(p_from_client_id) LOOP
905:
906: hr_utility.set_location(l_proc, 20);
907: SAVEPOINT hr_ele_name_start;
908:
909: BEGIN
910: hr_utility.set_location(l_proc, 30);

Line 910: hr_utility.set_location(l_proc, 30);

906: hr_utility.set_location(l_proc, 20);
907: SAVEPOINT hr_ele_name_start;
908:
909: BEGIN
910: hr_utility.set_location(l_proc, 30);
911: l_ele_type_id := hr_h2pi_map.get_to_id
912: (p_table_name => 'PAY_ELEMENT_TYPES_F',
913: p_from_id => v_ud_ele_name.element_type_id,
914: p_report_error => TRUE);

Line 916: hr_utility.set_location(l_proc, 50);

912: (p_table_name => 'PAY_ELEMENT_TYPES_F',
913: p_from_id => v_ud_ele_name.element_type_id,
914: p_report_error => TRUE);
915:
916: hr_utility.set_location(l_proc, 50);
917: SELECT elt.element_name
918: INTO l_element_name
919: FROM pay_element_types_f elt
920: WHERE elt.element_type_id = l_ele_type_id

Line 924: hr_utility.set_location(l_proc, 60);

920: WHERE elt.element_type_id = l_ele_type_id
921: AND SYSDATE BETWEEN elt.effective_start_date
922: AND elt.effective_end_date;
923:
924: hr_utility.set_location(l_proc, 60);
925: /*
926: pay_element_types_pkg.translate_row
927: (x_e_element_name => l_element_name
928: ,x_e_legislation_code => 'US'--hr_h2pi_upload.g_legislation_code

Line 943: hr_utility.set_location(l_proc, 70);

939: SET status = 'C'
940: WHERE element_type_id = v_ud_ele_name.element_type_id
941: AND client_id = p_from_client_id;
942:
943: hr_utility.set_location(l_proc, 70);
944: COMMIT;
945:
946: EXCEPTION
947: WHEN MAPPING_ID_MISSING THEN

Line 948: hr_utility.set_location(l_proc, 80);

944: COMMIT;
945:
946: EXCEPTION
947: WHEN MAPPING_ID_MISSING THEN
948: hr_utility.set_location(l_proc, 80);
949: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
950: ROLLBACK;
951: hr_utility.set_location(l_proc, 90);
952: l_encoded_message := fnd_message.get_encoded;

Line 951: hr_utility.set_location(l_proc, 90);

947: WHEN MAPPING_ID_MISSING THEN
948: hr_utility.set_location(l_proc, 80);
949: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
950: ROLLBACK;
951: hr_utility.set_location(l_proc, 90);
952: l_encoded_message := fnd_message.get_encoded;
953: hr_h2pi_error.data_error
954: (p_from_id => v_ud_ele_name.element_type_id,
955: p_table_name => 'HR_H2PI_ELEMENT_NAME',

Line 962: hr_utility.set_location('Leaving:'|| l_proc, 100);

958: END;
959:
960: END LOOP;
961:
962: hr_utility.set_location('Leaving:'|| l_proc, 100);
963: COMMIT;
964:
965: END;
966: