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

Line 31: hr_utility.set_location('Entering:'|| v_proc, 5);

27: v_proc varchar2(72) := g_package||'set_globals';
28: --
29: Begin
30: --
31: hr_utility.set_location('Entering:'|| v_proc, 5);
32: --
33: --
34: g_version_start_date := start_date;
35: g_version_end_date := end_date;

Line 37: hr_utility.set_location('Leaving:'|| v_proc, 10);

33: --
34: g_version_start_date := start_date;
35: g_version_end_date := end_date;
36: --
37: hr_utility.set_location('Leaving:'|| v_proc, 10);
38: --
39: End set_globals;
40: --
41: -- ----------------------------------------------------------------------------

Line 47: -- hr_utility.

43: -- ----------------------------------------------------------------------------
44: --
45: -- Description:
46: -- Passes the error information to the procedure set_message of package
47: -- hr_utility.
48: --
49: Procedure call_error_message
50: (
51: p_error_appl varchar2

Line 59: hr_utility.set_location('Entering:'|| v_proc, 5);

55: v_proc varchar2(72) := g_package||'call_error_message';
56: --
57: Begin
58: --
59: hr_utility.set_location('Entering:'|| v_proc, 5);
60: --
61: -- ** TEMP ** Add error message with the following text.
62: --
63: fnd_message.set_name ( p_error_appl ,p_error_txt);

Line 66: hr_utility.set_location(' Leaving:'|| v_proc, 10);

62: --
63: fnd_message.set_name ( p_error_appl ,p_error_txt);
64: fnd_message.raise_error;
65: --
66: hr_utility.set_location(' Leaving:'|| v_proc, 10);
67: --
68: End call_error_message;
69: --
70: -- ----------------------------------------------------------------------------

Line 76: -- hr_utility.

72: -- ----------------------------------------------------------------------------
73: --
74: -- Description:
75: -- Passes the error information to the procedure set_message of package
76: -- hr_utility.
77: --
78: Procedure call_warning_message
79: (
80: p_warning_txt varchar2

Line 87: hr_utility.set_location('Entering:'|| v_proc, 5);

83: v_proc varchar2(72) := g_package||'call_warning_message';
84: --
85: Begin
86: --
87: hr_utility.set_location('Entering:'|| v_proc, 5);
88: --
89: -- ** TEMP ** Add warning message with the following text.
90: --
91: -- fnd_message.set_name( 'OTA', OTA_TAV_');

Line 95: hr_utility.set_location(' Leaving:'|| v_proc, 10);

91: -- fnd_message.set_name( 'OTA', OTA_TAV_');
92: fnd_message.set_name( 'OTA', p_warning_txt);
93: fnd_message.raise_error;
94: --
95: hr_utility.set_location(' Leaving:'|| v_proc, 10);
96: --
97: End call_warning_message;
98: --
99: -- ----------------------------------------------------------------------------

Line 108: hr_utility.set_location('Entering:'|| v_proc, 5);

104: --
105: v_proc varchar2(72) := g_package||'check_currency';
106: begin
107: --
108: hr_utility.set_location('Entering:'|| v_proc, 5);
109: --
110: ota_general.check_currency_is_valid
111: (p_currency_code);
112: --

Line 113: hr_utility.set_location(' Leaving:'|| v_proc, 10);

109: --
110: ota_general.check_currency_is_valid
111: (p_currency_code);
112: --
113: hr_utility.set_location(' Leaving:'|| v_proc, 10);
114: --
115: exception
116: when app_exception.application_exception then
117: if hr_multi_message.exception_add

Line 120: hr_utility.set_location(' Leaving:'|| v_proc,70);

116: when app_exception.application_exception then
117: if hr_multi_message.exception_add
118: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
119: ) then
120: hr_utility.set_location(' Leaving:'|| v_proc,70);
121: raise;
122: end if;
123: hr_utility.set_location(' Leaving:'|| v_proc,80);
124: end check_currency;

Line 123: hr_utility.set_location(' Leaving:'|| v_proc,80);

119: ) then
120: hr_utility.set_location(' Leaving:'|| v_proc,70);
121: raise;
122: end if;
123: hr_utility.set_location(' Leaving:'|| v_proc,80);
124: end check_currency;
125: --
126: -- ----------------------------------------------------------------------------
127: -- |---------------------< check_vendor >----------------------------------|

Line 135: hr_utility.set_location('Entering:'|| v_proc, 5);

131: --
132: v_proc varchar2(72) := g_package||'check_vendor';
133: begin
134: --
135: hr_utility.set_location('Entering:'|| v_proc, 5);
136: --
137: ota_general.check_vendor_is_valid(p_vendor_id);
138: --
139: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 139: hr_utility.set_location(' Leaving:'|| v_proc, 10);

135: hr_utility.set_location('Entering:'|| v_proc, 5);
136: --
137: ota_general.check_vendor_is_valid(p_vendor_id);
138: --
139: hr_utility.set_location(' Leaving:'|| v_proc, 10);
140: --
141: exception
142: when app_exception.application_exception then
143: if hr_multi_message.exception_add

Line 146: hr_utility.set_location(' Leaving:'|| v_proc,70);

142: when app_exception.application_exception then
143: if hr_multi_message.exception_add
144: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.VENDOR_ID'
145: ) then
146: hr_utility.set_location(' Leaving:'|| v_proc,70);
147: raise;
148: end if;
149: hr_utility.set_location(' Leaving:'|| v_proc,80);
150: end check_vendor;

Line 149: hr_utility.set_location(' Leaving:'|| v_proc,80);

145: ) then
146: hr_utility.set_location(' Leaving:'|| v_proc,70);
147: raise;
148: end if;
149: hr_utility.set_location(' Leaving:'|| v_proc,80);
150: end check_vendor;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |---------------------< check_cost_vals >----------------------------------|

Line 164: hr_utility.set_location('Entering:'|| v_proc, 5);

160: --
161: v_proc varchar2(72) := g_package||'check_cost_vals';
162: begin
163: --
164: hr_utility.set_location('Entering:'|| v_proc, 5);
165: --
166: if (p_budget_cost is not null or p_actual_cost is not null) and
167: p_budget_currency_code is null then
168: --

Line 174: hr_utility.set_location(' Leaving:'|| v_proc, 10);

170: fnd_message.raise_error;
171: --
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'|| v_proc, 10);
175: --
176: exception
177: when app_exception.application_exception then
178: if hr_multi_message.exception_add

Line 183: hr_utility.set_location(' Leaving:'|| v_proc,70);

179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'
181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'
182: ) then
183: hr_utility.set_location(' Leaving:'|| v_proc,70);
184: raise;
185: end if;
186: hr_utility.set_location(' Leaving:'|| v_proc,80);
187: end check_cost_vals;

Line 186: hr_utility.set_location(' Leaving:'|| v_proc,80);

182: ) then
183: hr_utility.set_location(' Leaving:'|| v_proc,70);
184: raise;
185: end if;
186: hr_utility.set_location(' Leaving:'|| v_proc,80);
187: end check_cost_vals;
188: --
189: -- ----------------------------------------------------------------------------
190: -- |---------------------< check_professional_credit_vals >-------------------|

Line 200: hr_utility.set_location('Entering:'|| v_proc, 5);

196: --
197: v_proc varchar2(72) := g_package||'check_professional_credit_vals';
198: begin
199: --
200: hr_utility.set_location('Entering:'|| v_proc, 5);
201: --
202: if (p_professional_credit_type is null and
203: p_professional_credits is not null)
204: or (p_professional_credit_type is not null and

Line 212: hr_utility.set_location(' Leaving:'|| v_proc, 10);

208: fnd_message.raise_error;
209: --
210: end if;
211: --
212: hr_utility.set_location(' Leaving:'|| v_proc, 10);
213: --
214: exception
215: when app_exception.application_exception then
216: if hr_multi_message.exception_add

Line 220: hr_utility.set_location(' Leaving:'|| v_proc,70);

216: if hr_multi_message.exception_add
217: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDITS'
218: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
219: ) then
220: hr_utility.set_location(' Leaving:'|| v_proc,70);
221: raise;
222: end if;
223: hr_utility.set_location(' Leaving:'|| v_proc,80);
224: end check_professional_credit_vals;

Line 223: hr_utility.set_location(' Leaving:'|| v_proc,80);

219: ) then
220: hr_utility.set_location(' Leaving:'|| v_proc,70);
221: raise;
222: end if;
223: hr_utility.set_location(' Leaving:'|| v_proc,80);
224: end check_professional_credit_vals;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |---------------------< check_professional_credit_type >-------------------|

Line 236: hr_utility.set_location('Entering:'|| v_proc, 5);

232: --
233: v_proc varchar2(72) := g_package||'check_professional_credit_type';
234: begin
235: --
236: hr_utility.set_location('Entering:'|| v_proc, 5);
237: --
238: ota_general.check_domain_value
239: ( 'PROFESSIONAL_CREDIT_TYPE', p_professional_credit_type);
240: --

Line 241: hr_utility.set_location(' Leaving:'|| v_proc, 10);

237: --
238: ota_general.check_domain_value
239: ( 'PROFESSIONAL_CREDIT_TYPE', p_professional_credit_type);
240: --
241: hr_utility.set_location(' Leaving:'|| v_proc, 10);
242: --
243: exception
244: when app_exception.application_exception then
245: if hr_multi_message.exception_add

Line 248: hr_utility.set_location(' Leaving:'|| v_proc,70);

244: when app_exception.application_exception then
245: if hr_multi_message.exception_add
246: (p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
247: ) then
248: hr_utility.set_location(' Leaving:'|| v_proc,70);
249: raise;
250: end if;
251: hr_utility.set_location(' Leaving:'|| v_proc,80);
252: end check_professional_credit_type;

Line 251: hr_utility.set_location(' Leaving:'|| v_proc,80);

247: ) then
248: hr_utility.set_location(' Leaving:'|| v_proc,70);
249: raise;
250: end if;
251: hr_utility.set_location(' Leaving:'|| v_proc,80);
252: end check_professional_credit_type;
253: --
254: -- ----------------------------------------------------------------------------
255: -- |-------------------------< check_min_max_values >-------------------------|

Line 272: hr_utility.set_location('Entering:'||v_proc, 5);

268: v_proc varchar2(72) := g_package||'check_min_max_values';
269: --
270: Begin
271: --
272: hr_utility.set_location('Entering:'||v_proc, 5);
273: --
274: If p_min is not null AND p_max is not null then
275: --
276: If p_min > p_max Then

Line 288: hr_utility.set_location(' Leaving:'||v_proc, 10);

284: End If;
285: --
286: End If;
287: --
288: hr_utility.set_location(' Leaving:'||v_proc, 10);
289: --
290: End check_min_max_values;
291: --
292: -- ----------------------------------------------------------------------------

Line 332: hr_utility.set_location('Entering:'|| v_proc, 5);

328:
329: --
330: Begin
331: --
332: hr_utility.set_location('Entering:'|| v_proc, 5);
333: --
334: if p_business_group_id is null then
335: open get_activity;
336: fetch get_activity into v_business_group_id;

Line 359: hr_utility.set_location(' Leaving:'|| v_proc, 10);

355: end if;
356: --
357: close sel_unique_key;
358: --
359: hr_utility.set_location(' Leaving:'|| v_proc, 10);
360: --
361: End check_unique_name;
362: --
363: -- ----------------------------------------------------------------------------

Line 389: hr_utility.set_location('Entering:'|| v_proc, 5);

385: where tav.activity_version_id = p_sup_act_vers_id;
386: --
387: Begin
388: --
389: hr_utility.set_location('Entering:'|| v_proc, 5);
390: --
391: If p_sup_act_vers_id is not null Then
392: --
393: Open sel_version;

Line 423: hr_utility.set_location(' Leaving:'|| v_proc, 10);

419: Close sel_version;
420: --
421: End if;
422: --
423: hr_utility.set_location(' Leaving:'|| v_proc, 10);
424: --
425: End check_superseding_version;
426: --
427: -- ---------------------------------------------------------------------------

Line 460: hr_utility.set_location('Entering:'|| v_proc, 5);

456: );
457:
458: Begin
459: --
460: hr_utility.set_location('Entering:'|| v_proc, 5);
461: --
462: Open find_overlapping_vers;
463: Fetch find_overlapping_vers into overlapping_vers;
464: --

Line 478: hr_utility.set_location('Leaving:'|| v_proc, 10);

474: --
475: End if;
476: Close find_overlapping_vers;
477: --
478: hr_utility.set_location('Leaving:'|| v_proc, 10);
479: --
480: End find_overlapping_versions;
481: --
482: -- ---------------------------------------------------------------------------

Line 499: hr_utility.set_location('Entering:'|| v_proc, 5);

495: v_proc varchar2(72) := g_package||'check_user_status';
496: --
497: Begin
498: --
499: hr_utility.set_location('Entering:'|| v_proc, 5);
500: --
501: If p_user_status is not null Then
502: --
503: ota_general.check_domain_value( 'ACTIVITY_USER_STATUS', p_user_status);

Line 507: hr_utility.set_location(' Leaving:'|| v_proc, 10);

503: ota_general.check_domain_value( 'ACTIVITY_USER_STATUS', p_user_status);
504: --
505: End if;
506: --
507: hr_utility.set_location(' Leaving:'|| v_proc, 10);
508: --
509: End check_user_status;
510: --
511: -- ----------------------------------------------------------------------------

Line 528: hr_utility.set_location('Entering:'|| v_proc, 5);

524: v_proc varchar2(72) := g_package||'check_success_criteria';
525: --
526: Begin
527: --
528: hr_utility.set_location('Entering:'|| v_proc, 5);
529: --
530: IF p_succ_criteria is not null Then
531: --
532: ota_general.check_domain_value('ACTIVITY_SUCCESS_CRITERIA',p_succ_criteria);

Line 536: hr_utility.set_location(' Leaving:'|| v_proc, 10);

532: ota_general.check_domain_value('ACTIVITY_SUCCESS_CRITERIA',p_succ_criteria);
533: --
534: End if;
535: --
536: hr_utility.set_location(' Leaving:'|| v_proc, 10);
537: --
538: End check_success_criteria;
539: --
540: -- ----------------------------------------------------------------------------

Line 567: hr_utility.set_location('Entering:'|| v_proc, 5);

563:
564: --
565: Begin
566: --
567: hr_utility.set_location('Entering:'|| v_proc, 5);
568: --
569: If p_activity_id is not null AND p_version_name is not null Then
570: --
571: Open sel_version_id;

Line 600: hr_utility.set_location(' Leaving:'|| v_proc, 10);

596: );
597: --
598: End if;
599: --
600: hr_utility.set_location(' Leaving:'|| v_proc, 10);
601: --
602: End get_activity_version_id;
603: --
604: -- ----------------------------------------------------------------------------

Line 668: hr_utility.set_location('Entering:'|| v_proc, 5);

664: v_proc varchar2(72) := g_package||'check_start_end_dates';
665: --
666: Begin
667: --
668: hr_utility.set_location('Entering:'|| v_proc, 5);
669: --
670: ota_general.check_start_end_dates( p_start_date, p_end_date);
671: --
672: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 672: hr_utility.set_location(' Leaving:'|| v_proc, 10);

668: hr_utility.set_location('Entering:'|| v_proc, 5);
669: --
670: ota_general.check_start_end_dates( p_start_date, p_end_date);
671: --
672: hr_utility.set_location(' Leaving:'|| v_proc, 10);
673: --
674: End check_start_end_dates;
675: --
676: -- ----------------------------------------------------------------------------

Line 710: hr_utility.set_location('Entering:'|| v_proc, 5);

706: if hr_multi_message.no_error_message
707: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
708: ) then
709: --
710: hr_utility.set_location('Entering:'|| v_proc, 5);
711: --
712: Open sel_check_dates;
713: Fetch sel_check_dates into v_start_date
714: , v_end_date;

Line 752: hr_utility.set_location(' Leaving:'|| v_proc, 10);

748: End loop;
749: --
750: Close sel_check_dates;
751: --
752: hr_utility.set_location(' Leaving:'|| v_proc, 10);
753: --
754: end if;
755: exception
756: when app_exception.application_exception then

Line 761: hr_utility.set_location(' Leaving:'|| v_proc,70);

757: if hr_multi_message.exception_add
758: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
759: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
760: ) then
761: hr_utility.set_location(' Leaving:'|| v_proc,70);
762: raise;
763: end if;
764: hr_utility.set_location(' Leaving:'|| v_proc,80);
765: End check_dates_update_rud;

Line 764: hr_utility.set_location(' Leaving:'|| v_proc,80);

760: ) then
761: hr_utility.set_location(' Leaving:'|| v_proc,70);
762: raise;
763: end if;
764: hr_utility.set_location(' Leaving:'|| v_proc,80);
765: End check_dates_update_rud;
766: --
767: -- ----------------------------------------------------------------------------
768: -- |-------------------------< check_dates_update_ple >-----------------------|

Line 796: hr_utility.set_location('Entering:'|| v_proc, 5);

792: where ple.activity_version_id = p_activity_version_id;
793: --
794: Begin
795: --
796: hr_utility.set_location('Entering:'|| v_proc, 5);
797: --
798: Open sel_check_dates;
799: Fetch sel_check_dates into v_start_date
800: , v_end_date;

Line 823: hr_utility.set_location(' Leaving:'|| v_proc, 10);

819: End loop;
820: --
821: Close sel_check_dates;
822: --
823: hr_utility.set_location(' Leaving:'|| v_proc, 10);
824: --
825: End check_dates_update_ple;
826: --
827: -- ----------------------------------------------------------------------------

Line 856: hr_utility.set_location('Entering:'|| v_proc, 5);

852: where tbd.activity_version_id = p_activity_version_id;
853: --
854: Begin
855: --
856: hr_utility.set_location('Entering:'|| v_proc, 5);
857: --
858: Open sel_check_dates;
859: Fetch sel_check_dates into v_start_date
860: , v_end_date;

Line 883: hr_utility.set_location(' Leaving:'|| v_proc, 10);

879: End loop;
880: --
881: Close sel_check_dates;
882: --
883: hr_utility.set_location(' Leaving:'|| v_proc, 10);
884: --
885: End check_dates_update_tbd;
886: --
887: -- ----------------------------------------------------------------------------

Line 926: hr_utility.set_location('Entering:'|| v_proc, 5);

922: where off.activity_version_id = p_activity_version_id;
923: --
924: Begin
925: --
926: hr_utility.set_location('Entering:'|| v_proc, 5);
927: --
928: Open sel_check_dates;
929: Fetch sel_check_dates into v_start_date
930: , v_end_date;

Line 975: hr_utility.set_location(' Leaving:'|| v_proc, 10);

971: End loop;
972: --
973: Close sel_check_dates;
974: --
975: hr_utility.set_location(' Leaving:'|| v_proc, 10);
976: --
977: End check_dates_update_evt;
978: --
979: -- ----------------------------------------------------------------------------

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

1013: l_cat_start_date date;
1014: l_cat_end_date date;
1015:
1016: Begin
1017: hr_utility.set_location(' Entering:' || l_proc,10);
1018: --
1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

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

1040: CLOSE cur_cat_start_end_date;
1041: End IF;
1042: End IF;
1043: --
1044: hr_utility.set_location(' Leaving:' || l_proc,10);
1045: Exception
1046: when app_exception.application_exception then
1047: IF hr_multi_message.exception_add
1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

Line 1051: hr_utility.set_location(' Leaving:'|| l_proc,20);

1047: IF hr_multi_message.exception_add
1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1049: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1050: ) THEN
1051: hr_utility.set_location(' Leaving:'|| l_proc,20);
1052: raise;
1053: END IF;
1054:
1055: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

1051: hr_utility.set_location(' Leaving:'|| l_proc,20);
1052: raise;
1053: END IF;
1054:
1055: hr_utility.set_location(' Leaving:'|| l_proc,30);
1056: --
1057: End check_category_dates;
1058: --
1059: -- ----------------------------------------------------------------------------

Line 1084: hr_utility.set_location('Entering:'|| v_proc, 5);

1080: where evt.activity_version_id = p_activity_version_id;
1081: --
1082: Begin
1083: --
1084: hr_utility.set_location('Entering:'|| v_proc, 5);
1085: --
1086: Open sel_evt_exists;
1087: fetch sel_evt_exists into v_exists;
1088: --

Line 1103: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1099: end if;
1100: --
1101: close sel_evt_exists;
1102: --
1103: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1104: --
1105: End check_if_evt_exists;
1106: --
1107: -- ----------------------------------------------------------------------------

Line 1132: hr_utility.set_location('Entering:'|| v_proc, 5);

1128: where off.activity_version_id = p_activity_version_id;
1129: --
1130: Begin
1131: --
1132: hr_utility.set_location('Entering:'|| v_proc, 5);
1133: --
1134: Open sel_off_exists;
1135: fetch sel_off_exists into v_exists;
1136: --

Line 1151: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1147: end if;
1148: --
1149: close sel_off_exists;
1150: --
1151: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1152: --
1153: End check_if_off_exists;
1154: --
1155: -- ----------------------------------------------------------------------------

Line 1185: hr_utility.set_location('Entering:'|| v_proc, 5);

1181: l_dummy varchar2(1);
1182: --
1183: Begin
1184: --
1185: hr_utility.set_location('Entering:'|| v_proc, 5);
1186: --
1187: -- Check if the activity version is referenced in training plan members table
1188: open c_get_tpm_rows;
1189: fetch c_get_tpm_rows into l_dummy;

Line 1198: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1194: else
1195: close c_get_tpm_rows;
1196: end if;
1197: --
1198: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1199: --
1200: End check_if_tpm_exists;
1201: --
1202: -- ----------------------------------------------------------------------------

Line 1227: hr_utility.set_location('Entering:'|| v_proc, 5);

1223: where tbd.activity_version_id = p_activity_version_id;
1224: --
1225: Begin
1226: --
1227: hr_utility.set_location('Entering:'|| v_proc, 5);
1228: --
1229: Open sel_tbd_exists;
1230: fetch sel_tbd_exists into v_exists;
1231: --

Line 1246: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1242: end if;
1243: --
1244: close sel_tbd_exists;
1245: --
1246: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1247: --
1248: End check_if_tbd_exists;
1249: --
1250: -- ----------------------------------------------------------------------------

Line 1275: hr_utility.set_location('Entering:'|| v_proc, 5);

1271: where ple.activity_version_id = p_activity_version_id;
1272: --
1273: Begin
1274: --
1275: hr_utility.set_location('Entering:'|| v_proc, 5);
1276: --
1277: Open sel_ple_exists;
1278: fetch sel_ple_exists into v_exists;
1279: --

Line 1294: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1290: end if;
1291: --
1292: close sel_ple_exists;
1293: --
1294: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1295: --
1296: End check_if_ple_exists;
1297: --
1298: -- ----------------------------------------------------------------------------

Line 1323: hr_utility.set_location('Entering:'|| v_proc, 5);

1319: where pce.activity_version_id = p_activity_version_id;
1320: --
1321: Begin
1322: --
1323: hr_utility.set_location('Entering:'|| v_proc, 5);
1324: --
1325: Open sel_comp_exists;
1326: fetch sel_comp_exists into v_exists;
1327: --

Line 1342: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1338: end if;
1339: --
1340: close sel_comp_exists;
1341: --
1342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1343: --
1344: End check_if_comp_exists;
1345: --
1346:

Line 1373: hr_utility.set_location('Entering:'|| v_proc, 5);

1369: where lpm.activity_version_id = p_activity_version_id;
1370: --
1371: Begin
1372: --
1373: hr_utility.set_location('Entering:'|| v_proc, 5);
1374: --
1375: Open sel_lpm_exists;
1376: fetch sel_lpm_exists into v_exists;
1377: --

Line 1392: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1388: end if;
1389: --
1390: close sel_lpm_exists;
1391: --
1392: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1393: --
1394: End check_if_lpm_exists;
1395: --
1396:

Line 1423: hr_utility.set_location('Entering:'|| v_proc, 5);

1419: where tav.superseded_by_act_version_id = p_activity_version_id;
1420: --
1421: Begin
1422: --
1423: hr_utility.set_location('Entering:'|| v_proc, 5);
1424: --
1425: Open sel_tav_exists;
1426: fetch sel_tav_exists into v_exists;
1427: --

Line 1442: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1438: end if;
1439: --
1440: close sel_tav_exists;
1441: --
1442: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1443: --
1444: End check_if_tav_exists;
1445: --
1446: -- ----------------------------------------------------------------------------

Line 1471: hr_utility.set_location('Entering:'|| v_proc, 5);

1467: where tsp.activity_version_id = p_activity_version_id;
1468: --
1469: Begin
1470: --
1471: hr_utility.set_location('Entering:'|| v_proc, 5);
1472: --
1473: Open sel_tsp_exists;
1474: fetch sel_tsp_exists into v_exists;
1475: --

Line 1490: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1486: end if;
1487: --
1488: close sel_tsp_exists;
1489: --
1490: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1491: --
1492: End check_if_tsp_exists;
1493: --
1494:

Line 1512: hr_utility.set_location('Entering:'|| v_proc, 5);

1508: v_proc varchar2(72) := g_package||'check_duration_units';
1509: --
1510: Begin
1511: --
1512: hr_utility.set_location('Entering:'|| v_proc, 5);
1513: --
1514: If p_duration_units is not null Then
1515: --
1516: ota_general.check_domain_value( 'OTA_DURATION_UNITS', p_duration_units);

Line 1520: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1516: ota_general.check_domain_value( 'OTA_DURATION_UNITS', p_duration_units);
1517: --
1518: End if;
1519: --
1520: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1521: --
1522: End check_duration_units;
1523: --
1524: -- ----------------------------------------------------------------------------

Line 1541: hr_utility.set_location('Entering:'|| v_proc, 5);

1537: v_proc varchar2(72) := g_package||'check_duration';
1538: --
1539: Begin
1540: --
1541: hr_utility.set_location('Entering:'|| v_proc, 5);
1542: --
1543: If p_duration <= 0 Then
1544: --
1545: -- ** TEMP ** Add error message with the following text.

Line 1553: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1549: );
1550: --
1551: end if;
1552: --
1553: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1554: --
1555: End check_duration;
1556: --
1557: -- ----------------------------------------------------------------------------

Line 1579: hr_utility.set_location('Entering:'|| v_proc, 5);

1575: where lan.language_id = p_language_id;
1576: --
1577: Begin
1578: --
1579: hr_utility.set_location('Entering:'|| v_proc, 5);
1580: --
1581: Open sel_language;
1582: fetch sel_language into v_exists;
1583: --

Line 1602: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1598: End if;
1599: --
1600: close sel_language;
1601: --
1602: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1603: --
1604: End check_language;
1605: --
1606: -- ----------------------------------------------------------------------------

Line 1625: hr_utility.set_location('Entering:'|| v_proc, 5);

1621: v_proc varchar2(72) := g_package||'check_controlling_person';
1622: --
1623: Begin
1624: --
1625: hr_utility.set_location('Entering:'|| v_proc, 5);
1626: --
1627: If p_person_id is not null Then
1628: --
1629: If NOT ota_general.check_person( p_person_id, nvl(p_date,hr_api.g_sot)) Then

Line 1641: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1637: End if;
1638: --
1639: End if;
1640: --
1641: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1642: --
1643: End check_controlling_person;
1644: --
1645: -- ----------------------------------------------------------------------------

Line 1681: hr_utility.set_location('Entering:'|| v_proc, 5);

1677: and v_end_date >= nvl(tav.start_date,hr_api.g_sot);
1678: --
1679: Begin
1680: --
1681: hr_utility.set_location('Entering:'|| v_proc, 5);
1682: --
1683: if p_start_date is null then
1684: v_start_date := hr_api.g_sot;
1685: else

Line 1711: hr_utility.trace(to_char(v_start_date));

1707: else
1708: v_default_end_date := hr_api.g_eot;
1709: end if;
1710: --
1711: hr_utility.trace(to_char(v_start_date));
1712: hr_utility.trace(to_char(v_end_date));
1713: hr_utility.trace(to_char(v_default_end_date));
1714: --
1715: Open sel_versions;

Line 1712: hr_utility.trace(to_char(v_end_date));

1708: v_default_end_date := hr_api.g_eot;
1709: end if;
1710: --
1711: hr_utility.trace(to_char(v_start_date));
1712: hr_utility.trace(to_char(v_end_date));
1713: hr_utility.trace(to_char(v_default_end_date));
1714: --
1715: Open sel_versions;
1716: fetch sel_versions into v_exists;

Line 1713: hr_utility.trace(to_char(v_default_end_date));

1709: end if;
1710: --
1711: hr_utility.trace(to_char(v_start_date));
1712: hr_utility.trace(to_char(v_end_date));
1713: hr_utility.trace(to_char(v_default_end_date));
1714: --
1715: Open sel_versions;
1716: fetch sel_versions into v_exists;
1717: --

Line 1719: hr_utility.trace('Returning true');

1715: Open sel_versions;
1716: fetch sel_versions into v_exists;
1717: --
1718: if sel_versions%found then
1719: hr_utility.trace('Returning true');
1720: close sel_versions;
1721: return(true);
1722: else
1723: hr_utility.trace('Returning False');

Line 1723: hr_utility.trace('Returning False');

1719: hr_utility.trace('Returning true');
1720: close sel_versions;
1721: return(true);
1722: else
1723: hr_utility.trace('Returning False');
1724: close sel_versions;
1725: return(false);
1726: end if;
1727: --

Line 1728: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1724: close sel_versions;
1725: return(false);
1726: end if;
1727: --
1728: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1729: --
1730: End exist_multiple_versions;
1731: --
1732: --

Line 1761: hr_utility.set_location('Entering:'|| v_proc, 5);

1757: and tad.multiple_con_versions_flag = 'N' ;
1758: --
1759: Begin
1760: --
1761: hr_utility.set_location('Entering:'|| v_proc, 5);
1762: --
1763: Open sel_activity;
1764: Fetch sel_activity into v_exists ;
1765: --

Line 1784: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1780: End if;
1781: --
1782: Close sel_activity;
1783: --
1784: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1785: --
1786: End check_multiple_con_version;
1787: --
1788: --

Line 1832: hr_utility.set_location('Entering:'|| v_proc, 5);

1828: and tav2.activity_id = p_activity_id);
1829: --
1830: Begin
1831: --
1832: hr_utility.set_location('Entering:'|| v_proc, 5);
1833: --
1834: open get_previous_version;
1835: fetch get_previous_version into v_version_id,
1836: v_start_date,

Line 1868: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1864: end if;
1865: close get_previous_version;
1866: --
1867: --
1868: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1869: --
1870: End set_superseding_version;
1871: --
1872: -- ----------------------------------------------------------------------------

Line 1902: hr_utility.set_location('Entering:'|| v_proc, 5);

1898: order by tav.end_date desc;
1899: --
1900: Begin
1901: --
1902: hr_utility.set_location('Entering:'|| v_proc, 5);
1903: --
1904: Open get_versions;
1905: Fetch get_versions into v_max_end_date;
1906: --

Line 1919: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1915: End if;
1916: --
1917: Close get_versions;
1918: --
1919: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1920: --
1921: End set_superseding_start_date;
1922: --
1923: -- ---------------------------------------------------------------------------

Line 1964: hr_utility.set_location('Entering:'|| v_proc, 5);

1960: and tav.activity_version_id = pc_activity_version_id ;
1961: --
1962: Begin
1963: --
1964: hr_utility.set_location('Entering:'|| v_proc, 5);
1965: --
1966: Open sel_latest_version;
1967: Fetch sel_latest_version into v_act_version_id;
1968: --

Line 1997: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1993: End if;
1994: --
1995: close sel_latest_version;
1996: --
1997: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1998: --
1999: End check_version_after_supersede;
2000: --
2001:

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

2042: where activity_version_id = p_activity_version_id;
2043: --
2044: Begin
2045: --
2046: hr_utility.set_location('Entering:'|| l_proc, 5);
2047:
2048: OPEN csr_old_inventory;
2049: FETCH csr_old_inventory into l_old_inventory_item_id,
2050: l_old_organization_id;

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

2052: if ((p_activity_version_id is not null) and
2053: nvl(l_old_inventory_item_id,hr_api.g_number) <>
2054: nvl(p_inventory_item_id,hr_api.g_number)) then
2055: --
2056: hr_utility.set_location('Entering:'||l_proc, 10);
2057:
2058: --
2059: if p_inventory_item_id is null and l_old_inventory_item_id is not null then
2060: hr_utility.set_location('Entering:'||l_proc, 15);

Line 2060: hr_utility.set_location('Entering:'||l_proc, 15);

2056: hr_utility.set_location('Entering:'||l_proc, 10);
2057:
2058: --
2059: if p_inventory_item_id is null and l_old_inventory_item_id is not null then
2060: hr_utility.set_location('Entering:'||l_proc, 15);
2061: open csr_order_line_exist;
2062: fetch csr_order_line_exist into l_exists;
2063: if csr_order_line_exist%found then
2064: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');

Line 2068: hr_utility.set_location('Entering:'||l_proc, 20);

2064: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2065: fnd_message.raise_error;
2066: end if;
2067: close csr_order_line_exist;
2068: hr_utility.set_location('Entering:'||l_proc, 20);
2069:
2070:
2071: end if;
2072: if (p_inventory_item_id is not null and

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

2072: if (p_inventory_item_id is not null and
2073: p_organization_id is not null) and
2074: (l_old_inventory_item_id is not null and
2075: l_old_organization_id is not null) then
2076: hr_utility.set_location('Entering:'||l_proc, 25);
2077: open csr_order_line_exist;
2078: fetch csr_order_line_exist into l_exists;
2079: if csr_order_line_exist%found then
2080: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');

Line 2084: hr_utility.set_location('Entering:'||l_proc, 30);

2080: fnd_message.set_name('OTA','OTA_13695_TAV_INV_EXIST');
2081: fnd_message.raise_error;
2082: end if;
2083: close csr_order_line_exist;
2084: hr_utility.set_location('Entering:'||l_proc, 30);
2085: end if;
2086: --
2087: end if;
2088: hr_utility.set_location(' Leaving:'|| l_proc, 35);

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

2084: hr_utility.set_location('Entering:'||l_proc, 30);
2085: end if;
2086: --
2087: end if;
2088: hr_utility.set_location(' Leaving:'|| l_proc, 35);
2089: --
2090: exception
2091: when app_exception.application_exception then
2092: if hr_multi_message.exception_add

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

2091: when app_exception.application_exception then
2092: if hr_multi_message.exception_add
2093: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2094: ) then
2095: hr_utility.set_location(' Leaving:'|| l_proc,70);
2096: raise;
2097: end if;
2098: hr_utility.set_location(' Leaving:'|| l_proc,80);
2099: End check_OE_lines_exist;

Line 2098: hr_utility.set_location(' Leaving:'|| l_proc,80);

2094: ) then
2095: hr_utility.set_location(' Leaving:'|| l_proc,70);
2096: raise;
2097: end if;
2098: hr_utility.set_location(' Leaving:'|| l_proc,80);
2099: End check_OE_lines_exist;
2100:
2101: --
2102: -- ----------------------------------------------------------------------------

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

2154:
2155: Begin
2156: --
2157:
2158: hr_utility.set_location('Entering:'|| l_proc, 5);
2159: IF p_activity_version_id is not null THEN
2160: OPEN csr_old_inventory;
2161: FETCH csr_old_inventory into l_old_inventory_item_id,
2162: l_old_organization_id;

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

2169: nvl(l_old_organization_id,hr_api.g_number) <>
2170: nvl(p_organization_id,hr_api.g_number)))
2171: or (p_activity_version_id is null)) then
2172: --
2173: hr_utility.set_location('Entering:'||l_proc, 10);
2174:
2175: --
2176: if p_inventory_item_id is not null and
2177: p_organization_id is not null then

Line 2178: hr_utility.set_location('Entering:'||l_proc, 15);

2174:
2175: --
2176: if p_inventory_item_id is not null and
2177: p_organization_id is not null then
2178: hr_utility.set_location('Entering:'||l_proc, 15);
2179: open csr_inventory;
2180: fetch csr_inventory into l_exists;
2181: if csr_inventory%notfound then
2182: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');

Line 2186: hr_utility.set_location('Entering:'||l_proc, 20);

2182: fnd_message.set_name('OTA','OTA_13693_TAV_NO_INV');
2183: fnd_message.raise_error;
2184: end if;
2185: close csr_inventory;
2186: hr_utility.set_location('Entering:'||l_proc, 20);
2187: elsif p_inventory_item_id is not null and
2188: p_organization_id is null then
2189: fnd_message.set_name('OTA','OTA_13892_TAV_INV_COMB_INVALID');
2190: fnd_message.raise_error;

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

2225: end if;
2226:
2227:
2228:
2229: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2230: --
2231: exception
2232: when app_exception.application_exception then
2233: if hr_multi_message.exception_add

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

2232: when app_exception.application_exception then
2233: if hr_multi_message.exception_add
2234: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2235: ) then
2236: hr_utility.set_location(' Leaving:'|| l_proc,70);
2237: raise;
2238: end if;
2239: hr_utility.set_location(' Leaving:'|| l_proc,80);
2240: End check_inventory_item_id;

Line 2239: hr_utility.set_location(' Leaving:'|| l_proc,80);

2235: ) then
2236: hr_utility.set_location(' Leaving:'|| l_proc,70);
2237: raise;
2238: end if;
2239: hr_utility.set_location(' Leaving:'|| l_proc,80);
2240: End check_inventory_item_id;
2241:
2242: --
2243: -- ----------------------------------------------------------------------------

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

2267: where rco_id = p_rco_id;
2268:
2269: Begin
2270:
2271: hr_utility.set_location('Entering:'||l_proc, 5);
2272:
2273: if (((p_activity_version_id is not null) and
2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2275: nvl(p_rco_id,hr_api.g_number))

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

2274: nvl(ota_tav_shd.g_old_rec.rco_id,hr_api.g_number) <>
2275: nvl(p_rco_id,hr_api.g_number))
2276: or (p_activity_version_id is null)) then
2277: --
2278: hr_utility.set_location('Entering:'||l_proc, 10);
2279: if (p_rco_id is not null) then
2280: hr_utility.set_location('Entering:'||l_proc, 15);
2281: open csr_rco;
2282: fetch csr_rco into l_exists;

Line 2280: hr_utility.set_location('Entering:'||l_proc, 15);

2276: or (p_activity_version_id is null)) then
2277: --
2278: hr_utility.set_location('Entering:'||l_proc, 10);
2279: if (p_rco_id is not null) then
2280: hr_utility.set_location('Entering:'||l_proc, 15);
2281: open csr_rco;
2282: fetch csr_rco into l_exists;
2283: if csr_rco%found then
2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');

Line 2287: hr_utility.set_location('Leaving:'||l_proc, 20);

2283: if csr_rco%found then
2284: ota_tav_shd.constraint_error(p_constraint_name =>'OTA_ACTIVITY_VERSIONS_UK5');
2285: end if;
2286: close csr_rco;
2287: hr_utility.set_location('Leaving:'||l_proc, 20);
2288: end if;
2289: end if;
2290: exception
2291: when app_exception.application_exception then

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

2291: when app_exception.application_exception then
2292: if hr_multi_message.exception_add
2293: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.RCO_ID'
2294: ) then
2295: hr_utility.set_location(' Leaving:'|| l_proc,70);
2296: raise;
2297: end if;
2298: hr_utility.set_location(' Leaving:'|| l_proc,80);
2299: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 2298: hr_utility.set_location(' Leaving:'|| l_proc,80);

2294: ) then
2295: hr_utility.set_location(' Leaving:'|| l_proc,70);
2296: raise;
2297: end if;
2298: hr_utility.set_location(' Leaving:'|| l_proc,80);
2299: hr_utility.set_location('Leaving:'||l_proc, 30);
2300: End;
2301:
2302: --

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

2295: hr_utility.set_location(' Leaving:'|| l_proc,70);
2296: raise;
2297: end if;
2298: hr_utility.set_location(' Leaving:'|| l_proc,80);
2299: hr_utility.set_location('Leaving:'||l_proc, 30);
2300: End;
2301:
2302: --
2303: -- ----------------------------------------------------------------------------

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

2337: OR (lps.end_date_active IS NOT NULL AND l_start_date > lps.end_date_active));
2338:
2339: Begin
2340:
2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

Line 2382: hr_utility.set_location('Leaving:'||l_proc, 80);

2378: END IF;
2379: END IF;
2380: END IF;
2381:
2382: hr_utility.set_location('Leaving:'||l_proc, 80);
2383: End;
2384:
2385: -- ----------------------------------------------------------------------------
2386: -- |-------------------------< check_if_noth_exists >--------------------------|

Line 2411: hr_utility.set_location('Entering:'|| v_proc, 5);

2407: where nth.activity_version_id = p_activity_version_id;
2408: --
2409: Begin
2410: --
2411: hr_utility.set_location('Entering:'|| v_proc, 5);
2412: --
2413: Open sel_noth_exists;
2414: fetch sel_noth_exists into v_exists;
2415: --

Line 2430: hr_utility.set_location(' Leaving:'|| v_proc, 10);

2426: end if;
2427: --
2428: close sel_noth_exists;
2429: --
2430: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2431: --
2432:
2433: end check_if_noth_exists;
2434:

Line 2462: hr_utility.set_location('Entering:'|| v_proc, 5);

2458: and ctm.object_type = 'H';
2459: --
2460: Begin
2461: --
2462: hr_utility.set_location('Entering:'|| v_proc, 5);
2463: --
2464: Open sel_ctm_exists;
2465: fetch sel_ctm_exists into v_exists;
2466: --

Line 2481: hr_utility.set_location(' Leaving:'|| v_proc, 10);

2477: end if;
2478: --
2479: close sel_ctm_exists;
2480: --
2481: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2482: --
2483:
2484: end check_if_crt_exists;
2485:

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

2526:
2527:
2528: Begin
2529:
2530: hr_utility.set_location('Entering:'||l_proc, 5);
2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

Line 2571: hr_utility.set_location('Leaving:'||l_proc, 80);

2567: END IF;
2568: END IF;
2569: END IF;
2570:
2571: hr_utility.set_location('Leaving:'||l_proc, 80);
2572: End check_course_crt_dates;
2573: end ota_tav_api_business_rules;