APPS.GHR_PER_ADDRESSES_AFIUD dependencies on HR_UTILITY

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

68: END get_old_address_data;
69:
70: BEGIN
71: if hr_general.g_data_migrator_mode <> 'Y' then
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var( l_session_var);
74: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
75: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
76:

Line 74: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);

70: BEGIN
71: if hr_general.g_data_migrator_mode <> 'Y' then
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var( l_session_var);
74: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
75: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
76:
77: if l_session_var.fire_trigger = 'Y' THEN
78: if l_session_var.person_id is null then

Line 75: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);

71: if hr_general.g_data_migrator_mode <> 'Y' then
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var( l_session_var);
74: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
75: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
76:
77: if l_session_var.fire_trigger = 'Y' THEN
78: if l_session_var.person_id is null then
79: l_session_var.person_id := :new.person_id;

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

85: end if;
86:
87: if (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
88: if inserting THEN
89: hr_utility.set_location( l_proc , 170);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info
92: (
93: p_table_name => ghr_history_api.g_addres_table,

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

86:
87: if (lower(l_session_var.program_name) = 'sf50' or lower(l_session_var.program_name) = 'core') then
88: if inserting THEN
89: hr_utility.set_location( l_proc , 170);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info
92: (
93: p_table_name => ghr_history_api.g_addres_table,
94: p_program_name => l_session_var.program_name,

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

98: p_old_record_data => l_old_address_hist_data,
99: p_row_id => :new.rowid
100: );
101: elsif updating THEN
102: hr_utility.set_location( l_proc , 140);
103: get_old_address_data( l_old_address_data);
104: ghr_history_conv_rg.conv_addresses_rg_to_hist_rg
105: (
106: p_addresses_data => l_old_address_data,

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

117: p_old_record_data => l_old_address_hist_data,
118: p_row_id => :new.rowid
119: );
120: else -- ie deleting
121: hr_utility.set_location( l_proc , 120);
122: ghr_history_api.get_g_session_var( l_session_var);
123: NULL;
124: end if;
125: else -- Not a known type

Line 126: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);

122: ghr_history_api.get_g_session_var( l_session_var);
123: NULL;
124: end if;
125: else -- Not a known type
126: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
127: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
128: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
129: hr_utility.raise_error; -- History not maintained
130: end if;

Line 127: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');

123: NULL;
124: end if;
125: else -- Not a known type
126: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
127: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
128: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
129: hr_utility.raise_error; -- History not maintained
130: end if;
131: end if;

Line 129: hr_utility.raise_error; -- History not maintained

125: else -- Not a known type
126: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
127: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
128: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
129: hr_utility.raise_error; -- History not maintained
130: end if;
131: end if;
132: hr_utility.set_location('Leaving:'|| l_proc , 1);
133: end if;

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

128: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
129: hr_utility.raise_error; -- History not maintained
130: end if;
131: end if;
132: hr_utility.set_location('Leaving:'|| l_proc , 1);
133: end if;
134: end GHR_PER_ADDRESSES_AFIUD;