DBA Data[Home] [Help]

APPS.GHR_PER_POSITION_EI_AFIUD dependencies on HR_UTILITY

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

68: p_position_extra_info_data => p_old_position_ei_record );
69: END get_old_position_ei_data;
70:
71: BEGIN
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var (l_session_var);
74:
75: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
76: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);

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

71: BEGIN
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var (l_session_var);
74:
75: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
76: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
77:
78:
79: IF l_session_var.fire_trigger = 'Y' THEN

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

72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var (l_session_var);
74:
75: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
76: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
77:
78:
79: IF l_session_var.fire_trigger = 'Y' THEN
80: IF lower(l_session_var.program_name) = 'core' then

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

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

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

86: lower(l_session_var.program_name) = 'core') then
87: IF inserting THEN
88: hr_utility.set_location( l_proc , 170);
89: ghr_history_api.get_g_session_var( l_session_var);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info(
92: p_table_name => ghr_history_api.g_posnei_table,
93: p_program_name => l_session_var.program_name,
94: p_date_effective => l_session_var.date_effective,

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

98: p_row_id => :new.rowid
99: );
100: ELSIF updating THEN
101: ghr_history_api.get_g_session_var( l_session_var);
102: hr_utility.set_location( l_proc , 140);
103: get_old_position_ei_data( l_old_position_ei_data);
104: ghr_history_conv_rg.conv_positionei_rg_to_hist_rg( p_position_ei_data => l_old_position_ei_data,
105: p_history_data => l_old_position_ei_hist_data);
106:

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

113: p_old_record_data => l_old_position_ei_hist_data,
114: p_row_id => :new.rowid
115: );
116: ELSE /* ie deleting */
117: hr_utility.set_location( l_proc , 120);
118: ghr_history_api.get_g_session_var( l_session_var);
119: /* Need to discuss with functionals to decide if we should allow deletes */
120: NULL;
121: END IF;

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

119: /* Need to discuss with functionals to decide if we should allow deletes */
120: NULL;
121: END IF;
122: ELSE /* Not a known type */
123: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
124: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
125: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
126: hr_utility.raise_error; -- raise error
127: /* History not maintained */

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

120: NULL;
121: END IF;
122: ELSE /* Not a known type */
123: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
124: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
125: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
126: hr_utility.raise_error; -- raise error
127: /* History not maintained */
128: END IF;

Line 126: hr_utility.raise_error; -- raise error

122: ELSE /* Not a known type */
123: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
124: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
125: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
126: hr_utility.raise_error; -- raise error
127: /* History not maintained */
128: END IF;
129: END IF;
130: hr_utility.set_location('Leaving:'|| l_proc , 1);

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

126: hr_utility.raise_error; -- raise error
127: /* History not maintained */
128: END IF;
129: END IF;
130: hr_utility.set_location('Leaving:'|| l_proc , 1);
131: END GHR_PER_POSITION_EI_AFIUD;
132: