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.PER_APPLICANT_PKG dependencies on HR_UTILITY

Line 66: g_debug := hr_utility.debug_enabled; -- get debug status

62: l_proc varchar2(22) := 'get_working_conditions';
63: --
64: begin
65: --
66: g_debug := hr_utility.debug_enabled; -- get debug status
67: IF g_debug THEN
68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));

Line 68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);

64: begin
65: --
66: g_debug := hr_utility.debug_enabled; -- get debug status
67: IF g_debug THEN
68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));

Line 69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));

65: --
66: g_debug := hr_utility.debug_enabled; -- get debug status
67: IF g_debug THEN
68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));

Line 70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));

66: g_debug := hr_utility.debug_enabled; -- get debug status
67: IF g_debug THEN
68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));

Line 71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));

67: IF g_debug THEN
68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));

Line 72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));

68: hr_utility.set_location('Entering: '|| g_package || l_proc, 5);
69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));

Line 73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));

69: hr_utility.trace('p_business_group_id = ' || to_char(nvl(p_business_group_id,-999)));
70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));
77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));

Line 74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));

70: hr_utility.trace('p_organization_id = ' || to_char(nvl(p_organization_id,-999)));
71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));
77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));
78: END IF;

Line 75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));

71: hr_utility.trace('p_position_id = ' || to_char(nvl(p_position_id,-999)));
72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));
77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));
78: END IF;
79:

Line 76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));

72: hr_utility.trace('p_hours = ' || to_char(nvl(p_hours,-999)));
73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));
77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));
78: END IF;
79:
80: if ( p_position_id is not null ) then

Line 77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));

73: hr_utility.trace('p_freq = ' || nvl(p_freq,'NULL'));
74: hr_utility.trace('p_start = ' || nvl(p_start,'NULL'));
75: hr_utility.trace('p_finish = ' || nvl(p_finish,'NULL'));
76: hr_utility.trace('p_probation_period = ' || to_char(nvl(p_probation_period,-999)));
77: hr_utility.trace('p_probation_unit = ' || nvl(p_probation_unit,'NULL'));
78: END IF;
79:
80: if ( p_position_id is not null ) then
81: open get_pos_conditions ;

Line 102: hr_utility.set_location(g_package || l_proc, 10);

98: end if ;
99: --
100: --
101: IF g_debug THEN
102: hr_utility.set_location(g_package || l_proc, 10);
103: END IF;
104:
105: if ( ( p_organization_id is not null )
106: and ( p_organization_id <> p_business_group_id ) ) then

Line 121: hr_utility.set_location(g_package || l_proc, 20);

117: else
118: --
119: --
120: IF g_debug THEN
121: hr_utility.set_location(g_package || l_proc, 20);
122: END IF;
123:
124:
125: open get_bg_conditions ;

Line 421: g_debug := hr_utility.debug_enabled; -- get debug status

417: begin
418: --
419: --Create the PERSON record
420: --
421: g_debug := hr_utility.debug_enabled; -- get debug status
422: IF g_debug THEN
423: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
424: END IF;
425:

Line 423: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

419: --Create the PERSON record
420: --
421: g_debug := hr_utility.debug_enabled; -- get debug status
422: IF g_debug THEN
423: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
424: END IF;
425:
426: if ( p_method_of_apl_num_gen = 'A' and p_applicant_number is null) then
427: hr_person.generate_number( p_current_employee => 'N',

Line 442: hr_utility.set_location(g_package || l_proc, 10);

438: p_date_of_birth => p_date_of_birth
439: ,p_start_date => p_effective_start_date);
440: else
441: IF g_debug THEN
442: hr_utility.set_location(g_package || l_proc, 10);
443: END IF;
444:
445: -- Check that the number is unique
446: hr_person.validate_unique_number ( p_person_id => NULL,

Line 461: hr_utility.set_location(g_package || l_proc, 20);

457: -- then populate location code. This happens when the standard location
458: -- is accepted.
459:
460: IF g_debug THEN
461: hr_utility.set_location(g_package || l_proc, 20);
462: END IF;
463:
464: if ( ( p_location_id is not null )
465: and ( p_location_code is null ) ) then

Line 476: hr_utility.set_location(g_package || l_proc, 30);

472: -- This is untidy but the clean way would have involved the
473: -- rewrite of this package
474:
475: IF g_debug THEN
476: hr_utility.set_location(g_package || l_proc, 30);
477: END IF;
478:
479: if ( p_person_id is null ) then
480: open c1;

Line 486: hr_utility.set_location(g_package || l_proc, 40);

482: close c1;
483: end if;
484:
485: IF g_debug THEN
486: hr_utility.set_location(g_package || l_proc, 40);
487: END IF;
488:
489: --
490: hr_security_internal.populate_new_person

Line 495: hr_utility.set_location(g_package || l_proc, 50);

491: (p_business_group_id => p_business_group_id
492: ,p_person_id => p_person_id);
493: --
494: IF g_debug THEN
495: hr_utility.set_location(g_package || l_proc, 50);
496: END IF;
497:
498: per_people_pkg.insert_row(
499: p_rowid => p_rowid,

Line 625: hr_utility.set_location(g_package || l_proc, 60);

621: ,p_fast_path_employee=>p_fast_path_employee
622: ,p_fte_capacity =>p_fte_capacity ) ;
623:
624: IF g_debug THEN
625: hr_utility.set_location(g_package || l_proc, 60);
626: END IF;
627:
628: -- If the Application has been terminated then create a person starting
629: -- from the following day

Line 763: hr_utility.set_location(g_package || l_proc, 70);

759: end if ;
760: --
761:
762: IF g_debug THEN
763: hr_utility.set_location(g_package || l_proc, 70);
764: END IF;
765:
766: -- PTU Added call to create APL PTU record
767: -- Condition added to pass the person_type_id instead of the default value

Line 796: hr_utility.set_location(g_package || l_proc, 80);

792: -- End PTU Changes
793: --
794:
795: IF g_debug THEN
796: hr_utility.set_location(g_package || l_proc, 80);
797: END IF;
798:
799:
800: if p_address_set then

Line 805: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 2 ) ;

801: -- **************************
802: -- Create the ADDRESS record
803: -- **************************
804: l_dummy_number := NULL ;
805: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 2 ) ;
806: per_addresses_pkg.insert_row(
807: p_row_id => l_dummy_varchar2
808: ,p_address_id => l_dummy_number
809: ,p_business_group_id => p_business_group_id

Line 876: hr_utility.set_location(g_package || l_proc, 90);

872: end if ;
873: --
874:
875: IF g_debug THEN
876: hr_utility.set_location(g_package || l_proc, 90);
877: END IF;
878:
879: --
880: -- Create the APPLICATION record

Line 890: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 3 ) ;

886: end if ;
887: --
888: l_application_id := NULL ;
889: l_dummy_varchar2 := NULL ;
890: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 3 ) ;
891: per_applications_pkg.Insert_Row(p_Rowid => l_dummy_varchar2,
892: p_Application_Id => l_application_id,
893: p_Business_Group_Id => p_business_group_id,
894: p_Person_Id => p_person_id,

Line 935: hr_utility.set_location(g_package || l_proc, 100);

931: --
932: --
933:
934: IF g_debug THEN
935: hr_utility.set_location(g_package || l_proc, 100);
936: END IF;
937:
938: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;
939: l_dummy_number := NULL ;

Line 938: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;

934: IF g_debug THEN
935: hr_utility.set_location(g_package || l_proc, 100);
936: END IF;
937:
938: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;
939: l_dummy_number := NULL ;
940: l_dummy_varchar2 := NULL ;
941: --
942: -- Set the end date of the assignment if the status is TERM_APL

Line 967: hr_utility.set_location(g_package || l_proc, 110);

963: -- Start of fix for bug# 2314084
964: --
965:
966: IF g_debug THEN
967: hr_utility.set_location(g_package || l_proc, 110);
968: END IF;
969:
970: if ((l_probation_period is not null) and (l_probation_unit is not null) ) then
971: hr_assignment.gen_probation_end

Line 984: hr_utility.set_location(g_package || l_proc, 120);

980: -- End of fix for bug# 2314084
981: --
982:
983: IF g_debug THEN
984: hr_utility.set_location(g_package || l_proc, 120);
985: END IF;
986:
987: per_assignments_f_pkg.insert_row(
988: p_row_id => l_dummy_varchar2,

Line 1092: hr_utility.set_location(g_package || l_proc, 130);

1088: );
1089: */
1090:
1091: IF g_debug THEN
1092: hr_utility.set_location(g_package || l_proc, 130);
1093: END IF;
1094:
1095:
1096: -- Create default budget values for the assignment

Line 1104: hr_utility.set_location(g_package || l_proc, 140);

1100: p_effective_end_date => l_asg_end_date) ;
1101: --
1102:
1103: IF g_debug THEN
1104: hr_utility.set_location(g_package || l_proc, 140);
1105: END IF;
1106:
1107: update_group ( p_people_group_id,
1108: p_people_group_name ) ;

Line 1113: hr_utility.set_location(g_package || l_proc, 150);

1109: --
1110: -- Create letter request
1111:
1112: IF g_debug THEN
1113: hr_utility.set_location(g_package || l_proc, 150);
1114: END IF;
1115:
1116:
1117: check_for_letter_requests ( p_business_group_id => p_business_group_id,

Line 1128: hr_utility.set_location('Leaving: '|| g_package || l_proc, 160);

1124: p_vacancy_id => p_vacancy_id
1125: ) ;
1126: --
1127: IF g_debug THEN
1128: hr_utility.set_location('Leaving: '|| g_package || l_proc, 160);
1129: END IF;
1130:
1131: end insert_row ;
1132: --

Line 1231: g_debug := hr_utility.debug_enabled; -- get debug status

1227: l_proc varchar2(8) := 'lock_row';
1228:
1229: begin
1230: --
1231: g_debug := hr_utility.debug_enabled; -- get debug status
1232: IF g_debug THEN
1233: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1234: END IF;
1235:

Line 1233: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

1229: begin
1230: --
1231: g_debug := hr_utility.debug_enabled; -- get debug status
1232: IF g_debug THEN
1233: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1234: END IF;
1235:
1236: -- Call people lock row
1237: per_people_pkg.lock_row(

Line 1335: hr_utility.set_location('leaving: '|| g_package || l_proc, 10);

1331: p_i30 => p_per_information30
1332: ) ;
1333: --
1334: IF g_debug THEN
1335: hr_utility.set_location('leaving: '|| g_package || l_proc, 10);
1336: END IF;
1337:
1338: end lock_row ;
1339: --

Line 1530: g_debug := hr_utility.debug_enabled; -- get debug status

1526: pbg.method_of_generation_apl_num
1527: from per_business_groups pbg
1528: where business_group_id = p_business_group_id ;
1529: begin
1530: g_debug := hr_utility.debug_enabled; -- get debug status
1531: IF g_debug THEN
1532: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1533: END IF;
1534:

Line 1532: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

1528: where business_group_id = p_business_group_id ;
1529: begin
1530: g_debug := hr_utility.debug_enabled; -- get debug status
1531: IF g_debug THEN
1532: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1533: END IF;
1534:
1535: --
1536: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;

Line 1536: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;

1532: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1533: END IF;
1534:
1535: --
1536: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;
1537: -- Retrieve the person type for a system person type of APL
1538: open c1 ;
1539: fetch c1 into p_person_type_id,
1540: p_system_person_type ;

Line 1545: hr_utility.set_location( g_package || l_proc, 10);

1541: close c1 ;
1542: -- Retrieve the Assignment Status Type defaults
1543:
1544: IF g_debug THEN
1545: hr_utility.set_location( g_package || l_proc, 10);
1546: END IF;
1547:
1548: open c2 ;
1549: fetch c2 into p_ass_status_type_id,

Line 1557: hr_utility.set_location( g_package || l_proc, 20);

1553: --
1554: -- Retrieve the default country to use for addresses
1555:
1556: IF g_debug THEN
1557: hr_utility.set_location( g_package || l_proc, 20);
1558: END IF;
1559:
1560: open c3;
1561: fetch c3 into l_default,l_default_code;

Line 1576: hr_utility.set_location(g_package || l_proc, 30);

1572: --
1573: -- Retrieve the default yes and no descriptions
1574:
1575: IF g_debug THEN
1576: hr_utility.set_location(g_package || l_proc, 30);
1577: END IF;
1578:
1579: open c4 ;
1580: fetch c4 into p_default_yes_desc,p_default_no_desc ;

Line 1586: hr_utility.set_location(g_package || l_proc, 40);

1582: --
1583: -- Retrieve business group defaults
1584:
1585: IF g_debug THEN
1586: hr_utility.set_location(g_package || l_proc, 40);
1587: END IF;
1588:
1589: open c5 ;
1590: fetch c5 into p_bg_name,

Line 1602: hr_utility.set_location('Leaving: '|| g_package || l_proc, 50);

1598: close c5 ;
1599: --
1600:
1601: IF g_debug THEN
1602: hr_utility.set_location('Leaving: '|| g_package || l_proc, 50);
1603: END IF;
1604:
1605: end get_db_default_values ;
1606: --

Line 1624: g_debug := hr_utility.debug_enabled; -- get debug status

1620: and vacancy_id = p_vacancy_id ;
1621: begin
1622: --
1623:
1624: g_debug := hr_utility.debug_enabled; -- get debug status
1625: IF g_debug THEN
1626: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1627: END IF;
1628:

Line 1626: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

1622: --
1623:
1624: g_debug := hr_utility.debug_enabled; -- get debug status
1625: IF g_debug THEN
1626: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1627: END IF;
1628:
1629: open c1 ;
1630: fetch c1 into l_dummy ;

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

1631: l_return_value := c1%found ;
1632: close c1 ;
1633:
1634: IF g_debug THEN
1635: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
1636: END IF;
1637:
1638: return ( l_return_value ) ;
1639: --

Line 1663: g_debug := hr_utility.debug_enabled; -- get debug status

1659: l_proc varchar2(20) := 'uniq_vac_for_rec_act';
1660: --
1661: begin
1662:
1663: g_debug := hr_utility.debug_enabled; -- get debug status
1664: IF g_debug THEN
1665: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1666: END IF;
1667:

Line 1665: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

1661: begin
1662:
1663: g_debug := hr_utility.debug_enabled; -- get debug status
1664: IF g_debug THEN
1665: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1666: END IF;
1667:
1668: open c1 ;
1669: fetch c1 into l_vacancy_id ;

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

1673: close c1 ;
1674: --
1675:
1676: IF g_debug THEN
1677: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
1678: END IF;
1679:
1680: return ( l_vacancy_id ) ;
1681: --

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

1706: l_manager_number per_all_people_f.employee_number%TYPE;
1707:
1708: begin
1709: --
1710: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
1711:
1712: get_vacancy_details ( p_vacancy_id => p_vacancy_id
1713: ,p_vacancy_name => p_vacancy_name
1714: ,p_recruiter_id => p_recruiter_id

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

1728: ,p_manager_id => l_manager_id
1729: ,p_manager_name => l_manager_name
1730: ,p_manager_number => l_manager_number);
1731:
1732: hr_utility.set_location('Leaving: '|| g_package || l_proc, 100);
1733: --
1734: end;
1735:
1736: --

Line 1818: g_debug := hr_utility.debug_enabled; -- get debug status

1814: --
1815: l_proc varchar2(20) := 'get_vacancy_details';
1816: --
1817: begin
1818: g_debug := hr_utility.debug_enabled; -- get debug status
1819: IF g_debug THEN
1820: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1821: END IF;
1822:

Line 1820: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

1816: --
1817: begin
1818: g_debug := hr_utility.debug_enabled; -- get debug status
1819: IF g_debug THEN
1820: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
1821: END IF;
1822:
1823:
1824: if p_vacancy_name is null then

Line 1842: hr_utility.set_location( g_package || l_proc, 10);

1838: -- Retrieve descriptions
1839: --
1840: -- Recruiter
1841: IF g_debug THEN
1842: hr_utility.set_location( g_package || l_proc, 10);
1843: END IF;
1844: if p_recruiter_id is not null then
1845: open get_recruiter ;
1846: fetch get_recruiter into p_recruiter_name

Line 1856: hr_utility.set_location(g_package || l_proc, 20);

1852: end if ;
1853: --
1854: -- Organization
1855: IF g_debug THEN
1856: hr_utility.set_location(g_package || l_proc, 20);
1857: END IF;
1858:
1859: if p_org_id is not null then
1860: open get_organization ;

Line 1869: hr_utility.set_location( g_package || l_proc, 30);

1865: end if ;
1866: --
1867: -- Job
1868: IF g_debug THEN
1869: hr_utility.set_location( g_package || l_proc, 30);
1870: END IF;
1871:
1872: if p_job_id is not null then
1873: open get_job ;

Line 1882: hr_utility.set_location( g_package || l_proc, 40);

1878: end if ;
1879: --
1880: -- Position
1881: IF g_debug THEN
1882: hr_utility.set_location( g_package || l_proc, 40);
1883: END IF;
1884:
1885: if p_pos_id is not null then
1886: open get_position ;

Line 1895: hr_utility.set_location( g_package || l_proc, 50);

1891: end if ;
1892: --
1893: -- Grade
1894: IF g_debug THEN
1895: hr_utility.set_location( g_package || l_proc, 50);
1896: END IF;
1897:
1898: if p_grade_id is not null then
1899: open get_grade ;

Line 1908: hr_utility.set_location( g_package || l_proc, 60);

1904: end if ;
1905: --
1906: -- Location
1907: IF g_debug THEN
1908: hr_utility.set_location( g_package || l_proc, 60);
1909: END IF;
1910:
1911: if p_location_id is not null then
1912: open get_location ;

Line 1923: hr_utility.set_location( g_package || l_proc, 65);

1919:
1920: -- Start changes for bug 8678206
1921: -- Manager
1922: IF g_debug THEN
1923: hr_utility.set_location( g_package || l_proc, 65);
1924: END IF;
1925:
1926: if p_manager_id is not null then
1927: open get_manager ;

Line 1938: hr_utility.set_location('Leaving: '|| g_package || l_proc, 70);

1934: --
1935: -- End changes for bug 8678206
1936:
1937: IF g_debug THEN
1938: hr_utility.set_location('Leaving: '|| g_package || l_proc, 70);
1939: END IF;
1940: end get_vacancy_details ;
1941: --
1942: -- Provide overload for get_vacancy_details

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

2006: --
2007:
2008: begin
2009: --
2010: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
2011: --
2012: set_vac_from_rec_act (p_recruitment_activity_id => p_recruitment_activity_id
2013: ,p_date_received => p_date_received
2014: ,p_vacancy_id => p_vacancy_id

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

2029: ,p_manager_id => l_manager_id
2030: ,p_manager_name => l_manager_name
2031: ,p_manager_number => l_manager_number);
2032: --
2033: hr_utility.set_location('Leaving: '|| g_package || l_proc, 100);
2034: --
2035: end;
2036:
2037: --

Line 2067: g_debug := hr_utility.debug_enabled; -- get debug status

2063: l_proc varchar2(20) := 'set_vac_from_rec_act';
2064:
2065: begin
2066: --
2067: g_debug := hr_utility.debug_enabled; -- get debug status
2068: IF g_debug THEN
2069: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2070: END IF;
2071:

Line 2069: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

2065: begin
2066: --
2067: g_debug := hr_utility.debug_enabled; -- get debug status
2068: IF g_debug THEN
2069: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2070: END IF;
2071:
2072: -- Check that the vacancy is unique
2073: p_vacancy_id := uniq_vac_for_rec_act ( p_recruitment_activity_id,

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

2099: -- End changes for bug 8678206
2100: end if ;
2101: --
2102: IF g_debug THEN
2103: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
2104: END IF;
2105:
2106: end set_vac_from_rec_act ;
2107: --

Line 2130: g_debug := hr_utility.debug_enabled; -- get debug status

2126: AND ((P.DATE_END IS NULL)
2127: OR (P.DATE_END >= p_date_received )) ;
2128: begin
2129: --
2130: g_debug := hr_utility.debug_enabled; -- get debug status
2131: IF g_debug THEN
2132: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2133: END IF;
2134:

Line 2132: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

2128: begin
2129: --
2130: g_debug := hr_utility.debug_enabled; -- get debug status
2131: IF g_debug THEN
2132: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2133: END IF;
2134:
2135: open c1 ;
2136: fetch c1 into l_dummy ;

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

2138: close c1 ;
2139: --
2140:
2141: IF g_debug THEN
2142: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
2143: END IF;
2144:
2145: return ( l_return_value ) ;
2146: --

Line 2224: hr_utility.set_location('Leaving: '|| g_package || l_proc, 1);

2220: close c2 ;
2221: end if ;
2222: --
2223: IF g_debug THEN
2224: hr_utility.set_location('Leaving: '|| g_package || l_proc, 1);
2225: END IF;
2226:
2227: end exists_val_grd_for_pos_and_job ;
2228: --

Line 2244: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');

2240: open c1 ;
2241: fetch c1 into l_dummy_number ;
2242: if c1%found then
2243: close c1 ;
2244: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');
2245: hr_utility.raise_error ;
2246: end if ;
2247: close c1 ;
2248: --

Line 2245: hr_utility.raise_error ;

2241: fetch c1 into l_dummy_number ;
2242: if c1%found then
2243: close c1 ;
2244: hr_utility.set_message('PAY','HR_6413_APPL_NO_EXISTS');
2245: hr_utility.raise_error ;
2246: end if ;
2247: close c1 ;
2248: --
2249: end check_apl_num_unique ;

Line 2272: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );

2268: open c1 ;
2269: fetch c1 into l_dummy_number ;
2270: if c1%found then
2271: close c1 ;
2272: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );
2273: hr_utility.raise_error ;
2274: end if;
2275: close c1 ;
2276: --

Line 2273: hr_utility.raise_error ;

2269: fetch c1 into l_dummy_number ;
2270: if c1%found then
2271: close c1 ;
2272: hr_utility.set_message(801,'HR_6414_APPL_DATE_EFFECTIVE' );
2273: hr_utility.raise_error ;
2274: end if;
2275: close c1 ;
2276: --
2277: open c2 ;

Line 2281: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );

2277: open c2 ;
2278: fetch c2 into l_dummy_number ;
2279: if c2%found then
2280: close c2 ;
2281: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );
2282: hr_utility.raise_error ;
2283: end if;
2284: close c2 ;
2285: --

Line 2282: hr_utility.raise_error ;

2278: fetch c2 into l_dummy_number ;
2279: if c2%found then
2280: close c2 ;
2281: hr_utility.set_message(801,'HR_6415_APPL_ADDRESS' );
2282: hr_utility.raise_error ;
2283: end if;
2284: close c2 ;
2285: --
2286: -- Fix for 3908271 starts here.

Line 2310: g_debug := hr_utility.debug_enabled; -- get debug status

2306:
2307: l_proc varchar2(28) := 'create_default_budget_values';
2308: begin
2309: --
2310: g_debug := hr_utility.debug_enabled; -- get debug status
2311: IF g_debug THEN
2312: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2313: END IF;
2314:

Line 2312: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

2308: begin
2309: --
2310: g_debug := hr_utility.debug_enabled; -- get debug status
2311: IF g_debug THEN
2312: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2313: END IF;
2314:
2315: insert into per_assignment_budget_values_f
2316: (assignment_budget_value_id,

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

2331: where d.business_group_id + 0 = p_business_group_id ;
2332: --
2333:
2334: IF g_debug THEN
2335: hr_utility.set_location('Leaving: '|| g_package || l_proc, 10);
2336: END IF;
2337: end create_default_budget_values ;
2338: --
2339: procedure check_for_letter_requests ( p_business_group_id in number,

Line 2373: g_debug := hr_utility.debug_enabled; -- get debug status

2369: -- Fix for bug 3680947 ends here.
2370: --
2371: begin
2372: --
2373: g_debug := hr_utility.debug_enabled; -- get debug status
2374: IF g_debug THEN
2375: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2376: END IF;
2377:

Line 2375: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);

2371: begin
2372: --
2373: g_debug := hr_utility.debug_enabled; -- get debug status
2374: IF g_debug THEN
2375: hr_utility.set_location('Entering: '|| g_package || l_proc, 1);
2376: END IF;
2377:
2378: open check_statuses ;
2379: fetch check_statuses into l_dummy_number ;

Line 2389: hr_utility.set_location(g_package || l_proc, 10);

2385: --
2386: -- Fix for bug 3680947 starts here.
2387: --
2388: IF g_debug THEN
2389: hr_utility.set_location(g_package || l_proc, 10);
2390: END IF;
2391:
2392: open csr_check_manual_or_auto;
2393: fetch csr_check_manual_or_auto into l_dummy_number;

Line 2403: hr_utility.set_location(g_package || l_proc, 20);

2399: --
2400: -- Fix for bug 3680947 ends here.
2401: --
2402: IF g_debug THEN
2403: hr_utility.set_location(g_package || l_proc, 20);
2404: END IF;
2405:
2406:
2407: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then

Line 2410: hr_utility.set_location(g_package || l_proc, 30);

2406:
2407: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
2408:
2409: IF g_debug THEN
2410: hr_utility.set_location(g_package || l_proc, 30);
2411: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
2412: END IF;
2413:
2414:

Line 2411: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);

2407: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
2408:
2409: IF g_debug THEN
2410: hr_utility.set_location(g_package || l_proc, 30);
2411: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
2412: END IF;
2413:
2414:
2415: insert into per_letter_requests

Line 2449: hr_utility.set_location(g_package || l_proc, 40);

2445: -- Bug fix 3648715
2446: -- Insert statment modified - 'r.business_group_id +0' changed to
2447: -- r.business_group_id to improve performance.
2448: IF g_debug THEN
2449: hr_utility.set_location(g_package || l_proc, 40);
2450: END IF;
2451:
2452: insert into per_letter_request_lines
2453: (letter_request_line_id,

Line 2490: hr_utility.set_location(g_package || l_proc, 50);

2486: else
2487:
2488: -- Profile HR: Letter by Vacancy has not been set to Yes
2489: IF g_debug THEN
2490: hr_utility.set_location(g_package || l_proc, 50);
2491: END IF;
2492:
2493: insert into per_letter_requests
2494: (letter_request_id,

Line 2526: hr_utility.set_location(g_package || l_proc, 60);

2522: -- bug fix 3648715
2523: -- Insert statment modified - 'r.business_group_id +0' changed to
2524: -- r.business_group_id to improve performance.
2525: IF g_debug THEN
2526: hr_utility.set_location(g_package || l_proc, 60);
2527: END IF;
2528:
2529: insert into per_letter_request_lines
2530: (letter_request_line_id,

Line 2567: hr_utility.set_location('Leaving: ' ||g_package || l_proc, 30);

2563: end if;
2564: --
2565: --
2566: IF g_debug THEN
2567: hr_utility.set_location('Leaving: ' ||g_package || l_proc, 30);
2568: END IF;
2569:
2570: end check_for_letter_requests ;
2571: --