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

Line 164: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

160: --
161: l_proc varchar2(72) := g_package||'Effective_Date_Valid';
162: --
163: Begin
164: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
165: --
166: -- Ensure that all the mandatory arguments are not null
167: --
168: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

169: p_argument => 'p_effective_date',
170: p_argument_value => p_effective_date);
171:
172: If (p_effective_date < Hr_Api.g_sot) then
173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE', l_proc);
175: hr_utility.set_message_token('STEP','10');
176: hr_utility.raise_error;
177: End If;

Line 174: hr_utility.set_message_token('PROCEDURE', l_proc);

170: p_argument_value => p_effective_date);
171:
172: If (p_effective_date < Hr_Api.g_sot) then
173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE', l_proc);
175: hr_utility.set_message_token('STEP','10');
176: hr_utility.raise_error;
177: End If;
178: --

Line 175: hr_utility.set_message_token('STEP','10');

171:
172: If (p_effective_date < Hr_Api.g_sot) then
173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE', l_proc);
175: hr_utility.set_message_token('STEP','10');
176: hr_utility.raise_error;
177: End If;
178: --
179: -- Check that effective_date does not include a time component. If set

Line 176: hr_utility.raise_error;

172: If (p_effective_date < Hr_Api.g_sot) then
173: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE', l_proc);
175: hr_utility.set_message_token('STEP','10');
176: hr_utility.raise_error;
177: End If;
178: --
179: -- Check that effective_date does not include a time component. If set
180: -- then raise an error because it should have been truncated to just a day,

Line 184: hr_utility.set_message(801, 'HR_51322_DT_TIME_SET');

180: -- then raise an error because it should have been truncated to just a day,
181: -- month year value before the DT logic is called.
182: --
183: if p_effective_date <> trunc(p_effective_date) then
184: hr_utility.set_message(801, 'HR_51322_DT_TIME_SET');
185: hr_utility.raise_error;
186: end if;
187: --
188: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);

Line 185: hr_utility.raise_error;

181: -- month year value before the DT logic is called.
182: --
183: if p_effective_date <> trunc(p_effective_date) then
184: hr_utility.set_message(801, 'HR_51322_DT_TIME_SET');
185: hr_utility.raise_error;
186: end if;
187: --
188: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
189: End Effective_Date_Valid;

Line 188: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);

184: hr_utility.set_message(801, 'HR_51322_DT_TIME_SET');
185: hr_utility.raise_error;
186: end if;
187: --
188: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
189: End Effective_Date_Valid;
190: -- ----------------------------------------------------------------------------
191: -- |----------------------< Return_Effective_Dates >--------------------------|
192: -- ----------------------------------------------------------------------------

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

207: --
208: l_proc VARCHAR2(72) := g_package||'return_effective_dates';
209: --
210: BEGIN
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: effective_date_valid(p_effective_date => p_effective_date);
213: -- Define dynamic sql text with substitution tokens
214: pay_prt_shd.g_dynamic_sql :=
215: 'select t.effective_start_date, ' ||

Line 228: hr_utility.set_location('Leaving :'||l_proc, 45);

224: ,p_effective_end_date
225: USING p_base_key_value
226: ,p_effective_date;
227: --
228: hr_utility.set_location('Leaving :'||l_proc, 45);
229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: -- As no rows were returned we must error
232: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

Line 232: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

228: hr_utility.set_location('Leaving :'||l_proc, 45);
229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: -- As no rows were returned we must error
232: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
233: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
234:
235: /* FOR BUG 11830805 */
236:

Line 233: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);

229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: -- As no rows were returned we must error
232: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
233: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
234:
235: /* FOR BUG 11830805 */
236:
237: /* hr_utility.set_message_token

Line 237: /* hr_utility.set_message_token

233: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
234:
235: /* FOR BUG 11830805 */
236:
237: /* hr_utility.set_message_token
238: ('SESSION_DATE'
239: ,fnd_date.date_to_chardate(p_effective_date)
240: ); */
241:

Line 242: hr_utility.set_message_token

238: ('SESSION_DATE'
239: ,fnd_date.date_to_chardate(p_effective_date)
240: ); */
241:
242: hr_utility.set_message_token
243: ('SESSION_DATE'
244: ,fnd_date.date_to_chardate(p_effective_date, calendar_aware=>FND_DATE.calendar_aware_alt)
245: );
246:

Line 249: hr_utility.raise_error;

245: );
246:
247: /* FOR BUG 11830805 */
248:
249: hr_utility.raise_error;
250: WHEN TOO_MANY_ROWS THEN
251: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
252: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
253:

Line 251: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');

247: /* FOR BUG 11830805 */
248:
249: hr_utility.raise_error;
250: WHEN TOO_MANY_ROWS THEN
251: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
252: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
253:
254: /* FOR BUG 11830805 */
255:

Line 252: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);

248:
249: hr_utility.raise_error;
250: WHEN TOO_MANY_ROWS THEN
251: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
252: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
253:
254: /* FOR BUG 11830805 */
255:
256: /* hr_utility.set_message_token

Line 256: /* hr_utility.set_message_token

252: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
253:
254: /* FOR BUG 11830805 */
255:
256: /* hr_utility.set_message_token
257: ('SESSION_DATE'
258: ,fnd_date.date_to_chardate(p_effective_date)
259: ); */
260:

Line 261: hr_utility.set_message_token

257: ('SESSION_DATE'
258: ,fnd_date.date_to_chardate(p_effective_date)
259: ); */
260:
261: hr_utility.set_message_token
262: ('SESSION_DATE'
263: ,fnd_date.date_to_chardate(p_effective_date, calendar_aware=>FND_DATE.calendar_aware_alt)
264: );
265:

Line 269: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));

265:
266:
267: /* FOR BUG 11830805 */
268:
269: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));
270: hr_utility.raise_error;
271: WHEN OTHERS THEN
272: RAISE;
273: --

Line 270: hr_utility.raise_error;

266:
267: /* FOR BUG 11830805 */
268:
269: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));
270: hr_utility.raise_error;
271: WHEN OTHERS THEN
272: RAISE;
273: --
274: END return_effective_dates;

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

293: l_proc VARCHAR2(72) := g_package||'return_max_end_date';
294: l_max_date DATE;
295: --
296: BEGIN
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: -- Ensure that all the mandatory arguments are not null
299: hr_api.mandatory_arg_error(p_api_name => l_proc,
300: p_argument => 'p_base_table_name',
301: p_argument_value => p_base_table_name);

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

315: EXECUTE IMMEDIATE pay_prt_shd.g_dynamic_sql
316: INTO l_max_date
317: USING p_base_key_value;
318: --
319: hr_utility.set_location('Leaving :'||l_proc, 10);
320: RETURN(l_max_date);
321: --
322: END return_max_end_date;
323: -- ----------------------------------------------------------------------------

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

339: l_proc VARCHAR2(72) := g_package||'return_min_start_date';
340: l_min_date DATE;
341: --
342: BEGIN
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: -- Define dynamic sql text with substitution tokens
345: pay_prt_shd.g_dynamic_sql :=
346: 'select min(t.effective_start_date) '||
347: 'from '||p_base_table_name||' t '||

Line 356: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');

352: USING p_base_key_value;
353: -- Need to ensure that the minimum date is NOT null. If it is then we
354: -- must error
355: IF (l_min_date IS NULL) THEN
356: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
357: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
358: hr_utility.raise_error;
359: END IF;
360: --

Line 357: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);

353: -- Need to ensure that the minimum date is NOT null. If it is then we
354: -- must error
355: IF (l_min_date IS NULL) THEN
356: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
357: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
358: hr_utility.raise_error;
359: END IF;
360: --
361: hr_utility.set_location('Leaving :'||l_proc, 45);

Line 358: hr_utility.raise_error;

354: -- must error
355: IF (l_min_date IS NULL) THEN
356: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
357: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
358: hr_utility.raise_error;
359: END IF;
360: --
361: hr_utility.set_location('Leaving :'||l_proc, 45);
362: RETURN(l_min_date);

Line 361: hr_utility.set_location('Leaving :'||l_proc, 45);

357: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
358: hr_utility.raise_error;
359: END IF;
360: --
361: hr_utility.set_location('Leaving :'||l_proc, 45);
362: RETURN(l_min_date);
363: END return_min_start_date;
364: -- ----------------------------------------------------------------------------
365: -- |-------------------------< Future_Rows_Exists >---------------------------|

Line 390: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

386: l_effective_end_date date; -- Current effective end date
387: l_max_effective_end_date date; -- Maximum effective end date
388: --
389: Begin
390: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
391: --
392: -- Must ensure that a row exists as of the effective date supplied
393: -- and we need the current effective end date
394: --

Line 419: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);

415: If (l_max_effective_end_date > l_effective_end_date) then
416: l_boolean := TRUE;
417: End If;
418: --
419: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);
420: Return(l_boolean);
421: --
422: End Future_Rows_Exist;
423: -- ----------------------------------------------------------------------------

Line 481: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

477: l_parent_key_column varchar2(30);
478: l_parent_key_value number;
479: --
480: Begin
481: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
482: --
483: -- <>
484: -- For l_counter In 1..1 Loop
485: --

Line 559: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');

555: --
556: -- The parental rows specified do not exist as of the effective date
557: -- therefore a serious integrity problem has ocurred
558: --
559: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
560: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
561: hr_utility.raise_error;
562: Else
563: --

Line 560: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));

556: -- The parental rows specified do not exist as of the effective date
557: -- therefore a serious integrity problem has ocurred
558: --
559: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
560: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
561: hr_utility.raise_error;
562: Else
563: --
564: -- The LEAST function will then compare the working l_min_date with the

Line 561: hr_utility.raise_error;

557: -- therefore a serious integrity problem has ocurred
558: --
559: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
560: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
561: hr_utility.raise_error;
562: Else
563: --
564: -- The LEAST function will then compare the working l_min_date with the
565: -- returned maximum effective end date (l_temp_date) and set the

Line 573: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);

569: End If;
570: End If;
571: -- End Loop;
572: --
573: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);
574: Return(l_min_date);
575: --
576: End Return_Min_Parent_End_Date;
577: -- ----------------------------------------------------------------------------

Line 635: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

631: l_parent_key_column varchar2(30);
632: l_parent_key_value number;
633: --
634: Begin
635: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
636: --
637: /*
638: <>
639: For l_counter In 1..10 Loop

Line 715: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');

711: --
712: -- The parental rows specified do not exist as of the effective date
713: -- therefore a serious integrity problem has ocurred
714: --
715: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
716: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
717: hr_utility.raise_error;
718: Else
719: --

Line 716: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));

712: -- The parental rows specified do not exist as of the effective date
713: -- therefore a serious integrity problem has ocurred
714: --
715: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
716: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
717: hr_utility.raise_error;
718: Else
719: --
720: -- The LEAST function will then compare the working l_min_date with the

Line 717: hr_utility.raise_error;

713: -- therefore a serious integrity problem has ocurred
714: --
715: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
716: hr_utility.set_message_token('ARGUMENT', upper(l_parent_key_column));
717: hr_utility.raise_error;
718: Else
719: --
720: -- The LEAST function will then compare the working l_min_date with the
721: -- returned miniumum effective start date (l_temp_date) and set the

Line 729: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);

725: End If;
726: End If;
727: -- End Loop;
728: --
729: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);
730: Return(l_min_date);
731: --
732: End Return_Min_Parent_Start_Date;
733: -- ----------------------------------------------------------------------------

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

754: TYPE l_csr_type IS REF CURSOR; -- define weak REF CURSOR type
755: l_csr l_csr_type;
756: --
757: BEGIN
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Ensure that all the required parameters exist
761: -- Note: we don't check the p_key_value argument
762: --

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

790: EXIT WHEN l_csr%NOTFOUND; -- exit loop when last row is fetched
791: END LOOP;
792: CLOSE l_csr;
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);
795: END IF;
796: EXCEPTION
797: WHEN NO_DATA_FOUND THEN
798: -- The parental rows specified do not exist as of the effective date

Line 800: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');

796: EXCEPTION
797: WHEN NO_DATA_FOUND THEN
798: -- The parental rows specified do not exist as of the effective date
799: -- therefore a serious integrity problem has ocurred
800: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
801: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));
802: hr_utility.raise_error;
803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful

Line 801: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));

797: WHEN NO_DATA_FOUND THEN
798: -- The parental rows specified do not exist as of the effective date
799: -- therefore a serious integrity problem has ocurred
800: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
801: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));
802: hr_utility.raise_error;
803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.

Line 802: hr_utility.raise_error;

798: -- The parental rows specified do not exist as of the effective date
799: -- therefore a serious integrity problem has ocurred
800: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
801: hr_utility.set_message_token('ARGUMENT', upper(p_key_column));
802: hr_utility.raise_error;
803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.
806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

Line 806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

802: hr_utility.raise_error;
803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.
806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
807: hr_utility.set_message_token('TABLE_NAME', p_table_name);
808: hr_utility.raise_error;
809: WHEN OTHERS THEN
810: RAISE;

Line 807: hr_utility.set_message_token('TABLE_NAME', p_table_name);

803: WHEN hr_api.object_locked THEN
804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.
806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
807: hr_utility.set_message_token('TABLE_NAME', p_table_name);
808: hr_utility.raise_error;
809: WHEN OTHERS THEN
810: RAISE;
811: --

Line 808: hr_utility.raise_error;

804: -- The object is locked therefore we need to supply a meaningful
805: -- error message.
806: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
807: hr_utility.set_message_token('TABLE_NAME', p_table_name);
808: hr_utility.raise_error;
809: WHEN OTHERS THEN
810: RAISE;
811: --
812: END lck_future_rows;

Line 832: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

828: --
829: l_proc varchar2(72) := g_package||'Lck_Parent';
830: --
831: Begin
832: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
833: --
834: Lck_Future_Rows
835: (p_effective_date => p_effective_date,
836: p_table_name => p_parent_table_name,

Line 840: Hr_Utility.Set_Location(' Leaving:'||l_proc, 35);

836: p_table_name => p_parent_table_name,
837: p_key_column => p_parent_key_column,
838: p_key_value => p_parent_key_value);
839: --
840: Hr_Utility.Set_Location(' Leaving:'||l_proc, 35);
841: End Lck_Parent;
842: -- ----------------------------------------------------------------------------
843: -- |----------------------------< Lck_Child >---------------------------------|
844: -- ----------------------------------------------------------------------------

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

877: TYPE l_cursor_type IS REF CURSOR; -- define weak REF CURSOR type
878: l_cursor l_cursor_type;
879: --
880: BEGIN
881: hr_utility.set_location('Entering:'||l_proc, 5);
882: --
883: -- Ensure that all the required parameters exist
884: -- Note: we don't check the p_parent_key_value argument
885: --

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

899: -- If the p_parent_key_value is null then we must not
900: -- process the sql as it could be a nullable column.
901: --
902: IF (p_parent_key_value IS NOT NULL) THEN
903: hr_utility.set_location(l_proc, 10);
904: -- Define dynamic sql text with substitution tokens
905: pay_prt_shd.g_dynamic_sql :=
906: 'select t1.effective_end_date effective_end_date ' ||
907: 'from '||p_child_table_name||' t1 ' ||

Line 923: hr_utility.set_location(l_proc, 15);

919: -- open a cursor
920: OPEN l_cursor
921: FOR pay_prt_shd.g_dynamic_sql
922: USING p_parent_key_value;
923: hr_utility.set_location(l_proc, 15);
924: --
925: LOOP
926: FETCH l_cursor INTO l_lck_date;
927: hr_utility.set_location(l_proc, 20);

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

923: hr_utility.set_location(l_proc, 15);
924: --
925: LOOP
926: FETCH l_cursor INTO l_lck_date;
927: hr_utility.set_location(l_proc, 20);
928: EXIT WHEN l_cursor%NOTFOUND;
929: -- For each locked row we must ensure that the maximum end date is NOT
930: -- greater than the validation start date
931: IF (l_lck_date >= p_validation_start_date) THEN

Line 934: hr_utility.set_location(l_proc, 22);

930: -- greater than the validation start date
931: IF (l_lck_date >= p_validation_start_date) THEN
932: -- The maximum end date is greater than or equal to the
933: -- validation start date therefore we must error
934: hr_utility.set_location(l_proc, 22);
935: hr_utility.set_message(801, 'HR_7201_DT_NO_DELETE_CHILD');
936: hr_utility.raise_error;
937: END IF;
938: hr_utility.set_location('Entering:'||l_proc, 25);

Line 935: hr_utility.set_message(801, 'HR_7201_DT_NO_DELETE_CHILD');

931: IF (l_lck_date >= p_validation_start_date) THEN
932: -- The maximum end date is greater than or equal to the
933: -- validation start date therefore we must error
934: hr_utility.set_location(l_proc, 22);
935: hr_utility.set_message(801, 'HR_7201_DT_NO_DELETE_CHILD');
936: hr_utility.raise_error;
937: END IF;
938: hr_utility.set_location('Entering:'||l_proc, 25);
939: END LOOP;

Line 936: hr_utility.raise_error;

932: -- The maximum end date is greater than or equal to the
933: -- validation start date therefore we must error
934: hr_utility.set_location(l_proc, 22);
935: hr_utility.set_message(801, 'HR_7201_DT_NO_DELETE_CHILD');
936: hr_utility.raise_error;
937: END IF;
938: hr_utility.set_location('Entering:'||l_proc, 25);
939: END LOOP;
940: --

Line 938: hr_utility.set_location('Entering:'||l_proc, 25);

934: hr_utility.set_location(l_proc, 22);
935: hr_utility.set_message(801, 'HR_7201_DT_NO_DELETE_CHILD');
936: hr_utility.raise_error;
937: END IF;
938: hr_utility.set_location('Entering:'||l_proc, 25);
939: END LOOP;
940: --
941: CLOSE l_cursor;
942: hr_utility.set_location(' Leaving:'||l_proc, 35);

Line 942: hr_utility.set_location(' Leaving:'||l_proc, 35);

938: hr_utility.set_location('Entering:'||l_proc, 25);
939: END LOOP;
940: --
941: CLOSE l_cursor;
942: hr_utility.set_location(' Leaving:'||l_proc, 35);
943: END IF;
944: EXCEPTION
945: WHEN hr_api.object_locked THEN
946: IF l_cursor%ISOPEN THEN

Line 951: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

947: CLOSE l_cursor;
948: END IF;
949: -- The object is locked therefore we need to supply a meaningful
950: -- error message.
951: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
952: hr_utility.set_message_token('TABLE_NAME', p_child_table_name);
953: hr_utility.raise_error;
954: --
955: WHEN OTHERS THEN

Line 952: hr_utility.set_message_token('TABLE_NAME', p_child_table_name);

948: END IF;
949: -- The object is locked therefore we need to supply a meaningful
950: -- error message.
951: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
952: hr_utility.set_message_token('TABLE_NAME', p_child_table_name);
953: hr_utility.raise_error;
954: --
955: WHEN OTHERS THEN
956: IF l_cursor%ISOPEN THEN

Line 953: hr_utility.raise_error;

949: -- The object is locked therefore we need to supply a meaningful
950: -- error message.
951: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
952: hr_utility.set_message_token('TABLE_NAME', p_child_table_name);
953: hr_utility.raise_error;
954: --
955: WHEN OTHERS THEN
956: IF l_cursor%ISOPEN THEN
957: CLOSE l_cursor;

Line 1021: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1017: l_counter integer; -- Loop counter
1018: l_dummy_date date;
1019: --
1020: Begin
1021: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1022: --
1023: -- Step 1: Lock all parent rows specified from the effective date onwards
1024: -- providing that the p_enforce_foreign_locking is TRUE.
1025: --

Line 1176: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);

1172: p_parent_key_column10 => p_parent_key_column10,
1173: p_parent_key_value10 => p_parent_key_value10);
1174: */
1175: --
1176: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1177: --
1178: End Get_Insert_Dates;
1179: -- ----------------------------------------------------------------------------
1180: -- |-----------------------< Get_Correction_Dates >---------------------------|

Line 1202: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1198: l_effective_start_date date; -- Holds current effective start date
1199: l_effective_end_date date; -- Holds current effective end date
1200: --
1201: Begin
1202: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1203: Return_Effective_Dates
1204: (p_effective_date => p_effective_date,
1205: p_base_table_name => p_base_table_name,
1206: p_base_key_column => p_base_key_column,

Line 1217: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);

1213: --
1214: p_validation_start_date := l_effective_start_date;
1215: p_validation_end_date := l_effective_end_date;
1216: --
1217: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1218: End Get_Correction_Dates;
1219: -- ----------------------------------------------------------------------------
1220: -- |--------------------------< Get_Update_Dates >----------------------------|
1221: -- ----------------------------------------------------------------------------

Line 1242: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1238: l_effective_start_date date; -- Holds current effective start date
1239: l_effective_end_date date; -- Holds current effective end date
1240: --
1241: Begin
1242: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1243: --
1244: -- Determine if any future rows exist
1245: --
1246: If NOT (Future_Rows_Exist

Line 1271: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

1267: --
1268: -- We cannot perform a DateTrack update operation where the effective
1269: -- date is the same as the current effective end date
1270: --
1271: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1272: hr_utility.raise_error;
1273: End If;
1274: Else
1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

Line 1272: hr_utility.raise_error;

1268: -- We cannot perform a DateTrack update operation where the effective
1269: -- date is the same as the current effective end date
1270: --
1271: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1272: hr_utility.raise_error;
1273: End If;
1274: Else
1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1276: hr_utility.raise_error;

Line 1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

1271: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1272: hr_utility.raise_error;
1273: End If;
1274: Else
1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1276: hr_utility.raise_error;
1277: End If;
1278: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1279: --

Line 1276: hr_utility.raise_error;

1272: hr_utility.raise_error;
1273: End If;
1274: Else
1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1276: hr_utility.raise_error;
1277: End If;
1278: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1279: --
1280: End Get_Update_Dates;

Line 1278: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);

1274: Else
1275: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1276: hr_utility.raise_error;
1277: End If;
1278: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1279: --
1280: End Get_Update_Dates;
1281: -- ----------------------------------------------------------------------------
1282: -- |-------------------< Get_Update_Override_Dates >--------------------------|

Line 1305: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1301: l_effective_start_date date; -- Holds current effective start date
1302: l_effective_end_date date; -- Holds current effective end date
1303: --
1304: Begin
1305: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1306: Return_Effective_Dates
1307: (p_effective_date => p_effective_date,
1308: p_base_table_name => p_base_table_name,
1309: p_base_key_column => p_base_key_column,

Line 1334: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');

1330: (p_base_table_name => p_base_table_name,
1331: p_base_key_column => p_base_key_column,
1332: p_base_key_value => p_base_key_value);
1333: Else
1334: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1335: hr_utility.set_message_token('DT_MODE', 'update override');
1336: hr_utility.raise_error;
1337: End If;
1338: Else

Line 1335: hr_utility.set_message_token('DT_MODE', 'update override');

1331: p_base_key_column => p_base_key_column,
1332: p_base_key_value => p_base_key_value);
1333: Else
1334: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1335: hr_utility.set_message_token('DT_MODE', 'update override');
1336: hr_utility.raise_error;
1337: End If;
1338: Else
1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

Line 1336: hr_utility.raise_error;

1332: p_base_key_value => p_base_key_value);
1333: Else
1334: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1335: hr_utility.set_message_token('DT_MODE', 'update override');
1336: hr_utility.raise_error;
1337: End If;
1338: Else
1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1340: hr_utility.raise_error;

Line 1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

1335: hr_utility.set_message_token('DT_MODE', 'update override');
1336: hr_utility.raise_error;
1337: End If;
1338: Else
1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1340: hr_utility.raise_error;
1341: End If;
1342: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1343: --

Line 1340: hr_utility.raise_error;

1336: hr_utility.raise_error;
1337: End If;
1338: Else
1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1340: hr_utility.raise_error;
1341: End If;
1342: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1343: --
1344: End Get_Update_Override_Dates;

Line 1342: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);

1338: Else
1339: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1340: hr_utility.raise_error;
1341: End If;
1342: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1343: --
1344: End Get_Update_Override_Dates;
1345: -- ----------------------------------------------------------------------------
1346: -- |-----------------< Get_Update_Change_Insert_Dates >-----------------------|

Line 1369: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1365: l_effective_start_date date; -- Holds current effective start date
1366: l_effective_end_date date; -- Holds current effective end date
1367: --
1368: Begin
1369: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1370: Return_Effective_Dates
1371: (p_effective_date => p_effective_date,
1372: p_base_table_name => p_base_table_name,
1373: p_base_key_column => p_base_key_column,

Line 1395: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');

1391: p_base_key_value => p_base_key_value)) then
1392: p_validation_start_date := p_effective_date;
1393: p_validation_end_date := l_effective_end_date;
1394: Else
1395: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1396: hr_utility.set_message_token('DT_MODE', 'update change insert');
1397: hr_utility.raise_error;
1398: End If;
1399: Else

Line 1396: hr_utility.set_message_token('DT_MODE', 'update change insert');

1392: p_validation_start_date := p_effective_date;
1393: p_validation_end_date := l_effective_end_date;
1394: Else
1395: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1396: hr_utility.set_message_token('DT_MODE', 'update change insert');
1397: hr_utility.raise_error;
1398: End If;
1399: Else
1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

Line 1397: hr_utility.raise_error;

1393: p_validation_end_date := l_effective_end_date;
1394: Else
1395: hr_utility.set_message(801, 'HR_7183_DT_NO_FUTURE_ROWS');
1396: hr_utility.set_message_token('DT_MODE', 'update change insert');
1397: hr_utility.raise_error;
1398: End If;
1399: Else
1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1401: hr_utility.raise_error;

Line 1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

1396: hr_utility.set_message_token('DT_MODE', 'update change insert');
1397: hr_utility.raise_error;
1398: End If;
1399: Else
1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1401: hr_utility.raise_error;
1402: End If;
1403: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1404: --

Line 1401: hr_utility.raise_error;

1397: hr_utility.raise_error;
1398: End If;
1399: Else
1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1401: hr_utility.raise_error;
1402: End If;
1403: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1404: --
1405: End Get_Update_Change_Insert_Dates;

Line 1403: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);

1399: Else
1400: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1401: hr_utility.raise_error;
1402: End If;
1403: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1404: --
1405: End Get_Update_Change_Insert_Dates;
1406: -- ----------------------------------------------------------------------------
1407: -- |----------------------------< Get_Zap_Dates >-----------------------------|

Line 1427: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1423: --
1424: l_proc varchar2(72) := g_package||'Get_Zap_Dates';
1425: --
1426: Begin
1427: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1428: p_validation_start_date := Return_Min_Start_Date
1429: (p_base_table_name => p_base_table_name,
1430: p_base_key_column => p_base_key_column,
1431: p_base_key_value => p_base_key_value);

Line 1438: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);

1434: (p_base_table_name => p_base_table_name,
1435: p_base_key_column => p_base_key_column,
1436: p_base_key_value => p_base_key_value);
1437: --
1438: Hr_Utility.Set_Location('Leaving :'||l_proc, 20);
1439: --
1440: End Get_Zap_Dates;
1441: -- ----------------------------------------------------------------------------
1442: -- |--------------------------< Get_Delete_Dates >----------------------------|

Line 1475: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1471: l_child_key_column varchar2(30);
1472: l_child_fk_column varchar2(30);
1473: --
1474: Begin
1475: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1476: --
1477: If p_enforce_foreign_locking Then
1478: <>
1479: For l_counter In 1..2 Loop

Line 1537: hr_utility.set_message(801, 'HR_7185_DT_DEL_NOT_ALLOWED');

1533: --
1534: -- We cannot perform a DateTrack delete operation where the effective date
1535: -- is the same as the maximum effective end date.
1536: --
1537: hr_utility.set_message(801, 'HR_7185_DT_DEL_NOT_ALLOWED');
1538: hr_utility.raise_error;
1539: End If;
1540: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1541: --

Line 1538: hr_utility.raise_error;

1534: -- We cannot perform a DateTrack delete operation where the effective date
1535: -- is the same as the maximum effective end date.
1536: --
1537: hr_utility.set_message(801, 'HR_7185_DT_DEL_NOT_ALLOWED');
1538: hr_utility.raise_error;
1539: End If;
1540: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1541: --
1542: End Get_Delete_Dates;

Line 1540: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);

1536: --
1537: hr_utility.set_message(801, 'HR_7185_DT_DEL_NOT_ALLOWED');
1538: hr_utility.raise_error;
1539: End If;
1540: Hr_Utility.Set_Location('Leaving :'||l_proc, 10);
1541: --
1542: End Get_Delete_Dates;
1543: -- ----------------------------------------------------------------------------
1544: -- |-----------------------< Get_Future_Change_Dates >------------------------|

Line 1599: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1595: l_effective_end_date date; -- Holds current effective end date
1596: l_validation_end_date date;
1597: --
1598: Begin
1599: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1600: Return_Effective_Dates
1601: (p_effective_date => p_effective_date,
1602: p_base_table_name => p_base_table_name,
1603: p_base_key_column => p_base_key_column,

Line 1655: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');

1651: -- then we must error as we cannot extend the end date of the current
1652: -- row
1653: --
1654: If (l_validation_end_date <= l_effective_end_date) then
1655: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1656: hr_utility.set_message_token('DT_MODE', ' future changes');
1657: hr_utility.raise_error;
1658: Else
1659: p_validation_end_date := l_validation_end_date;

Line 1656: hr_utility.set_message_token('DT_MODE', ' future changes');

1652: -- row
1653: --
1654: If (l_validation_end_date <= l_effective_end_date) then
1655: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1656: hr_utility.set_message_token('DT_MODE', ' future changes');
1657: hr_utility.raise_error;
1658: Else
1659: p_validation_end_date := l_validation_end_date;
1660: End If;

Line 1657: hr_utility.raise_error;

1653: --
1654: If (l_validation_end_date <= l_effective_end_date) then
1655: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1656: hr_utility.set_message_token('DT_MODE', ' future changes');
1657: hr_utility.raise_error;
1658: Else
1659: p_validation_end_date := l_validation_end_date;
1660: End If;
1661: Else

Line 1666: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');

1662: --
1663: -- The current effective end date is alreay the end of time therefore
1664: -- we cannot extend the end date
1665: --
1666: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1667: hr_utility.raise_error;
1668: End If;
1669: --
1670: Hr_Utility.Set_Location(' Leaving:'||l_proc, 15);

Line 1667: hr_utility.raise_error;

1663: -- The current effective end date is alreay the end of time therefore
1664: -- we cannot extend the end date
1665: --
1666: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1667: hr_utility.raise_error;
1668: End If;
1669: --
1670: Hr_Utility.Set_Location(' Leaving:'||l_proc, 15);
1671: --

Line 1670: Hr_Utility.Set_Location(' Leaving:'||l_proc, 15);

1666: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1667: hr_utility.raise_error;
1668: End If;
1669: --
1670: Hr_Utility.Set_Location(' Leaving:'||l_proc, 15);
1671: --
1672: End Get_Future_Change_Dates;
1673: -- ----------------------------------------------------------------------------
1674: -- |--------------------< Get_Delete_Next_Change_Dates >----------------------|

Line 1733: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1729: l_future_effective_end_date date; -- Holds the end date of next row
1730: l_min_parent_end_date date; -- Holds the min parental end date
1731: --
1732: Begin
1733: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1734: Return_Effective_Dates
1735: (p_effective_date => p_effective_date,
1736: p_base_table_name => p_base_table_name,
1737: p_base_key_column => p_base_key_column,

Line 1822: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');

1818: -- then we must error as we cannot extend the end date of the current
1819: -- row
1820: --
1821: If (l_validation_end_date <= l_effective_end_date) then
1822: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1823: hr_utility.set_message_token('DT_MODE', ' delete next change');
1824: hr_utility.raise_error;
1825: Else
1826: p_validation_end_date := l_validation_end_date;

Line 1823: hr_utility.set_message_token('DT_MODE', ' delete next change');

1819: -- row
1820: --
1821: If (l_validation_end_date <= l_effective_end_date) then
1822: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1823: hr_utility.set_message_token('DT_MODE', ' delete next change');
1824: hr_utility.raise_error;
1825: Else
1826: p_validation_end_date := l_validation_end_date;
1827: End If;

Line 1824: hr_utility.raise_error;

1820: --
1821: If (l_validation_end_date <= l_effective_end_date) then
1822: hr_utility.set_message(801, 'HR_7187_DT_CANNOT_EXTEND_END');
1823: hr_utility.set_message_token('DT_MODE', ' delete next change');
1824: hr_utility.raise_error;
1825: Else
1826: p_validation_end_date := l_validation_end_date;
1827: End If;
1828: Else

Line 1833: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');

1829: --
1830: -- The current effective end date is alreay the end of time therefore
1831: -- we cannot extend the end date
1832: --
1833: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1834: hr_utility.raise_error;
1835: End If;
1836: --
1837: Hr_Utility.Set_Location(' Leaving:'||l_proc, 25);

Line 1834: hr_utility.raise_error;

1830: -- The current effective end date is alreay the end of time therefore
1831: -- we cannot extend the end date
1832: --
1833: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1834: hr_utility.raise_error;
1835: End If;
1836: --
1837: Hr_Utility.Set_Location(' Leaving:'||l_proc, 25);
1838: --

Line 1837: Hr_Utility.Set_Location(' Leaving:'||l_proc, 25);

1833: hr_utility.set_message(801, 'HR_7188_DT_DATE_IS_EOT');
1834: hr_utility.raise_error;
1835: End If;
1836: --
1837: Hr_Utility.Set_Location(' Leaving:'||l_proc, 25);
1838: --
1839: End Get_Delete_Next_Change_Dates;
1840: -- ---------------------------------------------------------------------------
1841: -- |-------------------------< validate_dt_mode >----------------------------|

Line 1915: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1911: l_proc varchar2(72) := g_package||'Validate_DT_Mode';
1912: l_datetrack_mode varchar2(30);
1913: --
1914: Begin
1915: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1916: l_datetrack_mode := upper(p_datetrack_mode);
1917: --
1918: Effective_Date_Valid(p_effective_date => p_effective_date);
1919: --

Line 2154: hr_utility.set_message(801, 'HR_7184_DT_MODE_UNKNOWN');

2150: p_validation_start_date => p_validation_start_date,
2151: p_validation_end_date => p_validation_end_date);
2152: --
2153: Else
2154: hr_utility.set_message(801, 'HR_7184_DT_MODE_UNKNOWN');
2155: hr_utility.set_message_token('DT_MODE', l_datetrack_mode);
2156: hr_utility.raise_error;
2157: End If;
2158: --

Line 2155: hr_utility.set_message_token('DT_MODE', l_datetrack_mode);

2151: p_validation_end_date => p_validation_end_date);
2152: --
2153: Else
2154: hr_utility.set_message(801, 'HR_7184_DT_MODE_UNKNOWN');
2155: hr_utility.set_message_token('DT_MODE', l_datetrack_mode);
2156: hr_utility.raise_error;
2157: End If;
2158: --
2159: Hr_Utility.Set_Location(' Leaving:'||l_proc, 55);

Line 2156: hr_utility.raise_error;

2152: --
2153: Else
2154: hr_utility.set_message(801, 'HR_7184_DT_MODE_UNKNOWN');
2155: hr_utility.set_message_token('DT_MODE', l_datetrack_mode);
2156: hr_utility.raise_error;
2157: End If;
2158: --
2159: Hr_Utility.Set_Location(' Leaving:'||l_proc, 55);
2160: --

Line 2159: Hr_Utility.Set_Location(' Leaving:'||l_proc, 55);

2155: hr_utility.set_message_token('DT_MODE', l_datetrack_mode);
2156: hr_utility.raise_error;
2157: End If;
2158: --
2159: Hr_Utility.Set_Location(' Leaving:'||l_proc, 55);
2160: --
2161: End Validate_DT_Mode;
2162: -- ----------------------------------------------------------------------------
2163: -- |---------------------------< find_dt_upd_modes >--------------------------|

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

2173: --
2174: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
2175: --
2176: Begin
2177: hr_utility.set_location('Entering:'||l_proc, 5);
2178: --
2179: -- Call the corresponding datetrack api
2180: --
2181: dt_api.find_dt_upd_modes

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

2207: if p_update_change_insert then
2208: p_update_change_insert := false;
2209: end if;
2210: --
2211: hr_utility.set_location(' Leaving:'||l_proc, 10);
2212: End find_dt_upd_modes;
2213: --
2214: -- ----------------------------------------------------------------------------
2215: -- |---------------------------< find_dt_del_modes >--------------------------|

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

2226: l_proc varchar2(72) := g_package||'find_dt_del_modes';
2227: --
2228: --
2229: Begin
2230: hr_utility.set_location('Entering:'||l_proc, 5);
2231: --
2232: -- Call the corresponding datetrack api
2233: --
2234: dt_api.find_dt_del_modes

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

2241: ,p_future_change => p_future_change
2242: ,p_delete_next_change => p_delete_next_change
2243: );
2244: --
2245: hr_utility.set_location(' Leaving:'||l_proc, 10);
2246: End find_dt_del_modes;
2247: --
2248: -- ----------------------------------------------------------------------------
2249: -- |-----------------------< upd_effective_end_date >-------------------------|

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

2260: l_proc varchar2(72) := g_package||'upd_effective_end_date';
2261: l_object_version_number number;
2262: --
2263: Begin
2264: hr_utility.set_location('Entering:'||l_proc, 5);
2265: --
2266: -- Because we are updating a row we must get the next object
2267: -- version number.
2268: --

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

2272: ,p_base_key_column => 'run_type_id'
2273: ,p_base_key_value => p_base_key_value
2274: );
2275: --
2276: hr_utility.set_location(l_proc, 10);
2277: --
2278: -- Update the specified datetrack row setting the effective
2279: -- end date to the specified new effective end date.
2280: --

Line 2289: hr_utility.set_location(' Leaving:'||l_proc, 15);

2285: and p_effective_date
2286: between t.effective_start_date and t.effective_end_date;
2287: --
2288: p_object_version_number := l_object_version_number;
2289: hr_utility.set_location(' Leaving:'||l_proc, 15);
2290: --
2291: End upd_effective_end_date;
2292: --
2293: -- ----------------------------------------------------------------------------

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

2361: --
2362: --
2363: --
2364: Begin
2365: hr_utility.set_location('Entering:'||l_proc, 5);
2366: --
2367: -- Ensure that all the mandatory arguments are not null
2368: --
2369: hr_api.mandatory_arg_error(p_api_name => l_proc

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

2464: --
2465: p_validation_start_date := l_validation_start_date;
2466: p_validation_end_date := l_validation_end_date;
2467: --
2468: hr_utility.set_location(' Leaving:'||l_proc, 30);
2469: --
2470: -- We need to trap the ORA LOCK exception
2471: --
2472: Exception