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_TAD_API dependencies on HR_UTILITY

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

50: --
51: l_proc varchar2(72) := g_package||'return_api_dml_status';
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: Return (nvl(g_api_dml, false));
57: --
58: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: Return (nvl(g_api_dml, false));
57: --
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
59: End return_api_dml_status;
60: --
61: -- ----------------------------------------------------------------------------
62: -- |---------------------------< constraint_error >---------------------------|

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

104: --
105: l_proc varchar2(72) := g_package||'constraint_error';
106: --
107: Begin
108: hr_utility.set_location('Entering:'||l_proc, 5);
109: --
110: If (p_constraint_name = 'OTA_ACTIVITY_DEFINITIONS_FK1') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);

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

107: Begin
108: hr_utility.set_location('Entering:'||l_proc, 5);
109: --
110: If (p_constraint_name = 'OTA_ACTIVITY_DEFINITIONS_FK1') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then

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

108: hr_utility.set_location('Entering:'||l_proc, 5);
109: --
110: If (p_constraint_name = 'OTA_ACTIVITY_DEFINITIONS_FK1') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 113: hr_utility.set_message_token('STEP','5');

109: --
110: If (p_constraint_name = 'OTA_ACTIVITY_DEFINITIONS_FK1') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 114: hr_utility.raise_error;

110: If (p_constraint_name = 'OTA_ACTIVITY_DEFINITIONS_FK1') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');

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

112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else

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

113: hr_utility.set_message_token('STEP','5');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 119: hr_utility.raise_error;

115: ElsIf (p_constraint_name = 'OTA_TAD_MULTIPLE_CON_VERSI_CHK') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','15');

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

117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','15');
124: hr_utility.raise_error;
125: End If;

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

118: hr_utility.set_message_token('STEP','10');
119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','15');
124: hr_utility.raise_error;
125: End If;
126: --

Line 123: hr_utility.set_message_token('STEP','15');

119: hr_utility.raise_error;
120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','15');
124: hr_utility.raise_error;
125: End If;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 124: hr_utility.raise_error;

120: Else
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','15');
124: hr_utility.raise_error;
125: End If;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: End constraint_error;

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

123: hr_utility.set_message_token('STEP','15');
124: hr_utility.raise_error;
125: End If;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: End constraint_error;
129: --
130: -- ----------------------------------------------------------------------------
131: -- |--------------------------< call_error_message >--------------------------|

Line 136: -- hr_utility.

132: -- ----------------------------------------------------------------------------
133: --
134: -- Description:
135: -- Passes the error information to the procedure set_message of package
136: -- hr_utility.
137: --
138: Procedure call_error_message
139: (
140: p_error_appl varchar2

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

144: v_proc varchar2(72) := g_package||'call_error_message';
145: --
146: Begin
147: --
148: hr_utility.set_location('Entering:'|| v_proc, 5);
149: --
150: -- ** TEMP ** Add error message with the following text.
151: --
152: fnd_message.set_name ( p_error_appl ,p_error_txt);

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

151: --
152: fnd_message.set_name ( p_error_appl ,p_error_txt);
153: fnd_message.raise_error;
154: --
155: hr_utility.set_location(' Leaving:'|| v_proc, 10);
156: --
157: End call_error_message;
158: --
159: -- ----------------------------------------------------------------------------

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

182: and (p_activity_id is null or tad.activity_id <> p_activity_id);
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'|| v_proc, 5);
187: --
188: Open sel_unique_name;
189: fetch sel_unique_name into v_exists;
190: --

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

201: end if;
202: --
203: close sel_unique_name;
204: --
205: hr_utility.set_location(' Leaving:'|| v_proc, 10);
206: --
207: End check_unique_name;
208: --
209: -- ----------------------------------------------------------------------------

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

231: and tad.business_group_id = p_business_group_id;
232: --
233: Begin
234: --
235: hr_utility.set_location('Entering:'|| v_proc, 5);
236: --
237: If p_name is not null Then
238: --
239: Open sel_activity_id;

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

264: );
265: --
266: End if;
267: --
268: hr_utility.set_location(' Leaving:'|| v_proc, 10);
269: --
270: End get_activity_id;
271: --
272: -- ----------------------------------------------------------------------------

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

293: where tav.activity_id = p_activity_id;
294: --
295: Begin
296: --
297: hr_utility.set_location('Entering:'|| v_proc, 5);
298: --
299: Open sel_tav_exist;
300: fetch sel_tav_exist into v_exists;
301: --

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

312: end if;
313: --
314: close sel_tav_exist;
315: --
316: hr_utility.set_location(' Leaving:'|| v_proc, 10);
317: --
318: End check_tav_exist;
319: --
320: -- ----------------------------------------------------------------------------

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

346: l_dummy varchar2(1);
347: --
348: Begin
349: --
350: hr_utility.set_location('Entering:'|| v_proc, 5);
351: --
352: -- Check if the activity definition is referenced in training plan members table
353: open c_get_tpm_rows;
354: fetch c_get_tpm_rows into l_dummy;

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

359: else
360: close c_get_tpm_rows;
361: end if;
362: --
363: hr_utility.set_location(' Leaving:'|| v_proc, 10);
364: --
365: End check_if_tpm_exist;
366: --
367: -- ----------------------------------------------------------------------------

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

383: v_proc varchar2(72) := g_package||'check_overlapping_dates';
384: --
385: Begin
386: --
387: hr_utility.set_location('Entering:'||v_proc, 5);
388: --
389: -- Check whether the first startdate is between the second startdate and
390: -- the second enddate => Overlapping dates
391: --

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

431: Return( false);
432: --
433: End if;
434: --
435: hr_utility.set_location(' Leaving:'||v_proc, 10);
436: --
437: End check_overlapping_dates;
438: --
439: -- ----------------------------------------------------------------------------

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

477: order by activity_version_id;
478: --
479: Begin
480: --
481: hr_utility.set_location('Entering:'|| v_proc, 5);
482: --
483: Open sel_versions;
484: fetch sel_versions into v_version_id
485: , v_start_date

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

540: -- Multiple activity versions do not exist
541: --
542: Return( false);
543: --
544: hr_utility.set_location(' Leaving:'|| v_proc, 10);
545: --
546: End exist_multiple_versions;
547: --
548: -- ----------------------------------------------------------------------------

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

563: v_proc varchar2(72) := g_package||'check_concurrent_versions';
564: --
565: Begin
566: --
567: hr_utility.set_location('Entering:'|| v_proc, 5);
568: --
569: If p_flag <> 'Y' AND exist_multiple_versions( p_activity_id) THEN
570: --
571: -- ** TEMP ** Add error message with the following text.

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

575: );
576: --
577: End if;
578: --
579: hr_utility.set_location(' Leaving:'|| v_proc, 10);
580: --
581: End check_concurrent_versions;
582: --
583: -- ----------------------------------------------------------------------------

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

624: --
625: l_proc varchar2(72) := g_package||'insert_dml';
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc, 5);
629: p_rec.object_version_number := 1; -- Initialise the object version
630: --
631: g_api_dml := true; -- Set the api dml status
632: --

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

696: );
697: --
698: g_api_dml := false; -- Unset the api dml status
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: Exception
702: When hr_api.check_integrity_violated Then
703: -- A check constraint has been violated
704: g_api_dml := false; -- Unset the api dml status

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

759: --
760: l_proc varchar2(72) := g_package||'update_dml';
761: --
762: Begin
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: -- Increment the object version
766: --
767: p_rec.object_version_number := p_rec.object_version_number + 1;

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

804: where activity_id = p_rec.activity_id;
805: --
806: g_api_dml := false; -- Unset the api dml status
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
810: Exception
811: When hr_api.check_integrity_violated Then
812: -- A check constraint has been violated

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

866: --
867: l_proc varchar2(72) := g_package||'delete_dml';
868: --
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: g_api_dml := true; -- Set the api dml status
873: --
874: -- Delete the ota_activity_definitions row.

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

882: --
883: -- The row to be deleted was NOT found therefore a serious
884: -- error has occurred which MUST be reported.
885: --
886: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
887: hr_utility.set_message_token('PROCEDURE', l_proc);
888: hr_utility.set_message_token('STEP','5');
889: hr_utility.raise_error;
890: End If;

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

883: -- The row to be deleted was NOT found therefore a serious
884: -- error has occurred which MUST be reported.
885: --
886: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
887: hr_utility.set_message_token('PROCEDURE', l_proc);
888: hr_utility.set_message_token('STEP','5');
889: hr_utility.raise_error;
890: End If;
891: --

Line 888: hr_utility.set_message_token('STEP','5');

884: -- error has occurred which MUST be reported.
885: --
886: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
887: hr_utility.set_message_token('PROCEDURE', l_proc);
888: hr_utility.set_message_token('STEP','5');
889: hr_utility.raise_error;
890: End If;
891: --
892: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 889: hr_utility.raise_error;

885: --
886: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
887: hr_utility.set_message_token('PROCEDURE', l_proc);
888: hr_utility.set_message_token('STEP','5');
889: hr_utility.raise_error;
890: End If;
891: --
892: hr_utility.set_location(' Leaving:'||l_proc, 10);
893: --

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

888: hr_utility.set_message_token('STEP','5');
889: hr_utility.raise_error;
890: End If;
891: --
892: hr_utility.set_location(' Leaving:'||l_proc, 10);
893: --
894: Exception
895: When hr_api.child_integrity_violated then
896: -- Child integrity has been violated

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

942: --
943: Cursor C_Sel1 is select ota_activity_definitions_s.nextval from sys.dual;
944: --
945: Begin
946: hr_utility.set_location('Entering:'||l_proc, 5);
947: --
948: --
949: -- Select the next sequence number
950: --

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

951: Open C_Sel1;
952: Fetch C_Sel1 Into p_rec.activity_id;
953: Close C_Sel1;
954: --
955: hr_utility.set_location(' Leaving:'||l_proc, 10);
956: End pre_insert;
957: --
958: -- ----------------------------------------------------------------------------
959: -- |------------------------------< pre_update >------------------------------|

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

988: --
989: l_proc varchar2(72) := g_package||'pre_update';
990: --
991: Begin
992: hr_utility.set_location('Entering:'||l_proc, 5);
993: --
994: hr_utility.set_location(' Leaving:'||l_proc, 10);
995: End pre_update;
996: --

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

990: --
991: Begin
992: hr_utility.set_location('Entering:'||l_proc, 5);
993: --
994: hr_utility.set_location(' Leaving:'||l_proc, 10);
995: End pre_update;
996: --
997: -- ----------------------------------------------------------------------------
998: -- |------------------------------< pre_delete >------------------------------|

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

1027: --
1028: l_proc varchar2(72) := g_package||'pre_delete';
1029: --
1030: Begin
1031: hr_utility.set_location('Entering:'||l_proc, 5);
1032: --
1033: hr_utility.set_location(' Leaving:'||l_proc, 10);
1034: End pre_delete;
1035: --

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

1029: --
1030: Begin
1031: hr_utility.set_location('Entering:'||l_proc, 5);
1032: --
1033: hr_utility.set_location(' Leaving:'||l_proc, 10);
1034: End pre_delete;
1035: --
1036: -- ----------------------------------------------------------------------------
1037: -- |-----------------------------< post_insert >------------------------------|

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

1066: --
1067: l_proc varchar2(72) := g_package||'post_insert';
1068: --
1069: Begin
1070: hr_utility.set_location('Entering:'||l_proc, 5);
1071: --
1072: hr_utility.set_location(' Leaving:'||l_proc, 10);
1073: End post_insert;
1074: --

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

1068: --
1069: Begin
1070: hr_utility.set_location('Entering:'||l_proc, 5);
1071: --
1072: hr_utility.set_location(' Leaving:'||l_proc, 10);
1073: End post_insert;
1074: --
1075: -- ----------------------------------------------------------------------------
1076: -- |-----------------------------< post_update >------------------------------|

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

1105: --
1106: l_proc varchar2(72) := g_package||'post_update';
1107: --
1108: Begin
1109: hr_utility.set_location('Entering:'||l_proc, 5);
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 10);
1112: End post_update;
1113: --

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

1107: --
1108: Begin
1109: hr_utility.set_location('Entering:'||l_proc, 5);
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 10);
1112: End post_update;
1113: --
1114: -- ----------------------------------------------------------------------------
1115: -- |-----------------------------< post_delete >------------------------------|

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

1144: --
1145: l_proc varchar2(72) := g_package||'post_delete';
1146: --
1147: Begin
1148: hr_utility.set_location('Entering:'||l_proc, 5);
1149: --
1150: hr_utility.set_location(' Leaving:'||l_proc, 10);
1151: End post_delete;
1152: --

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

1146: --
1147: Begin
1148: hr_utility.set_location('Entering:'||l_proc, 5);
1149: --
1150: hr_utility.set_location(' Leaving:'||l_proc, 10);
1151: End post_delete;
1152: --
1153: -- ----------------------------------------------------------------------------
1154: -- |---------------------------------< lck >----------------------------------|

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

1240: --
1241: l_proc varchar2(72) := g_package||'lck';
1242: --
1243: Begin
1244: hr_utility.set_location('Entering:'||l_proc, 5);
1245: --
1246: -- Add any mandatory argument checking here:
1247: -- Example:
1248: -- hr_api.check_mandatory_arg_error

Line 1262: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

1258: -- a) The row does NOT exist.
1259: -- b) The row is NOT current (i.e. failure on the object version).
1260: --
1261: Close C_Sel1;
1262: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1263: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1264: hr_utility.raise_error;
1265: End If;
1266: Close C_Sel1;

Line 1263: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');

1259: -- b) The row is NOT current (i.e. failure on the object version).
1260: --
1261: Close C_Sel1;
1262: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1263: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1264: hr_utility.raise_error;
1265: End If;
1266: Close C_Sel1;
1267: --

Line 1264: hr_utility.raise_error;

1260: --
1261: Close C_Sel1;
1262: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1263: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1264: hr_utility.raise_error;
1265: End If;
1266: Close C_Sel1;
1267: --
1268: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1264: hr_utility.raise_error;
1265: End If;
1266: Close C_Sel1;
1267: --
1268: hr_utility.set_location(' Leaving:'||l_proc, 10);
1269: --
1270: -- We need to trap the ORA LOCK exception
1271: --
1272: Exception

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

1274: --
1275: -- The object is locked therefore we need to supply a meaningful
1276: -- error message.
1277: --
1278: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1279: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1280: hr_utility.raise_error;
1281: End lck;
1282: --

Line 1279: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');

1275: -- The object is locked therefore we need to supply a meaningful
1276: -- error message.
1277: --
1278: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1279: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1280: hr_utility.raise_error;
1281: End lck;
1282: --
1283: -- ----------------------------------------------------------------------------

Line 1280: hr_utility.raise_error;

1276: -- error message.
1277: --
1278: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1279: hr_utility.set_message_token('TABLE_NAME', 'ota_activity_definitions');
1280: hr_utility.raise_error;
1281: End lck;
1282: --
1283: -- ----------------------------------------------------------------------------
1284: -- |-----------------------------< convert_args >-----------------------------|

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

1345: l_proc varchar2(72) := g_package||'convert_args';
1346: --
1347: Begin
1348: --
1349: hr_utility.set_location('Entering:'||l_proc, 5);
1350: --
1351: -- Convert arguments into local l_rec structure.
1352: --
1353: l_rec.activity_id := p_activity_id;

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

1381: l_rec.category_usage_id := p_category_usage_id;
1382: --
1383: -- Return the plsql record structure.
1384: --
1385: hr_utility.set_location(' Leaving:'||l_proc, 10);
1386: Return(l_rec);
1387: --
1388: End convert_args;
1389: --

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

1432: l_proc varchar2(72) := g_package||'convert_defs';
1433: --
1434: Begin
1435: --
1436: hr_utility.set_location('Entering:'||l_proc, 5);
1437: --
1438: -- We must now examine each argument value in the
1439: -- p_rec plsql record structure
1440: -- to see if a system default is being used. If a system default

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

1524: End If;
1525: --
1526: -- Return the plsql record structure.
1527: --
1528: hr_utility.set_location(' Leaving:'||l_proc, 10);
1529: Return(p_rec);
1530: --
1531: End convert_defs;
1532: --

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

1563: --
1564: l_proc varchar2(72) := g_package||'insert_validate';
1565: --
1566: Begin
1567: hr_utility.set_location('Entering:'||l_proc, 5);
1568: --
1569: -- Call all supporting business operations
1570: --
1571: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1573: check_unique_name( p_rec.name
1574: , p_rec.business_group_id
1575: , p_rec.activity_id );
1576: --
1577: hr_utility.set_location(' Leaving:'||l_proc, 10);
1578: End insert_validate;
1579: --
1580: -- ----------------------------------------------------------------------------
1581: -- |---------------------------< update_validate >----------------------------|

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

1618: := ota_general.value_changed( g_old_rec.multiple_con_versions_flag
1619: , p_rec.multiple_con_versions_flag );
1620: --
1621: Begin
1622: hr_utility.set_location('Entering:'||l_proc, 5);
1623: --
1624: -- Call all supporting business operations
1625: --
1626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1639: , p_rec.multiple_con_versions_flag );
1640: --
1641: End if;
1642: --
1643: hr_utility.set_location(' Leaving:'||l_proc, 10);
1644: --
1645: End update_validate;
1646: --
1647: -- ----------------------------------------------------------------------------

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

1677: --
1678: l_proc varchar2(72) := g_package||'delete_validate';
1679: --
1680: Begin
1681: hr_utility.set_location('Entering:'||l_proc, 5);
1682: --
1683: -- Call all supporting business operations
1684:
1685: check_if_tpm_exist (p_rec.activity_id);

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

1684:
1685: check_if_tpm_exist (p_rec.activity_id);
1686: check_tav_exist ( p_rec.activity_id );
1687: --
1688: hr_utility.set_location(' Leaving:'||l_proc, 10);
1689: End delete_validate;
1690: --
1691: -- ----------------------------------------------------------------------------
1692: -- |---------------------------------< ins >----------------------------------|

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

1753: --
1754: l_proc varchar2(72) := g_package||'ins';
1755: --
1756: Begin
1757: hr_utility.set_location('Entering:'||l_proc, 5);
1758: --
1759: -- Determine if the business process is to be validated.
1760: --
1761: If p_validate then

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

1786: If p_validate then
1787: Raise HR_Api.Validate_Enabled;
1788: End If;
1789: --
1790: hr_utility.set_location(' Leaving:'||l_proc, 10);
1791: Exception
1792: When HR_Api.Validate_Enabled Then
1793: --
1794: -- As the Validate_Enabled exception has been raised

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

1873: l_rec g_rec_type;
1874: l_proc varchar2(72) := g_package||'ins';
1875: --
1876: Begin
1877: hr_utility.set_location('Entering:'||l_proc, 5);
1878: --
1879: -- Call conversion function to turn arguments into the
1880: -- p_rec structure.
1881: --

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

1923: --
1924: p_activity_id := l_rec.activity_id;
1925: p_object_version_number := l_rec.object_version_number;
1926: --
1927: hr_utility.set_location(' Leaving:'||l_proc, 10);
1928: End ins;
1929: --
1930: -- ----------------------------------------------------------------------------
1931: -- |---------------------------------< upd >----------------------------------|

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

1999: --
2000: l_proc varchar2(72) := g_package||'upd';
2001: --
2002: Begin
2003: hr_utility.set_location('Entering:'||l_proc, 5);
2004: --
2005: -- Determine if the business process is to be validated.
2006: --
2007: If p_validate then

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

2044: If p_validate then
2045: Raise HR_Api.Validate_Enabled;
2046: End If;
2047: --
2048: hr_utility.set_location(' Leaving:'||l_proc, 10);
2049: Exception
2050: When HR_Api.Validate_Enabled Then
2051: --
2052: -- As the Validate_Enabled exception has been raised

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

2131: l_rec g_rec_type;
2132: l_proc varchar2(72) := g_package||'upd';
2133: --
2134: Begin
2135: hr_utility.set_location('Entering:'||l_proc, 5);
2136: --
2137: -- Call conversion function to turn arguments into the
2138: -- l_rec structure.
2139: --

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

2177: --
2178: upd(l_rec, p_validate);
2179: p_object_version_number := l_rec.object_version_number;
2180: --
2181: hr_utility.set_location(' Leaving:'||l_proc, 10);
2182: End upd;
2183: --
2184: -- ----------------------------------------------------------------------------
2185: -- |---------------------------------< del >----------------------------------|

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

2244: --
2245: l_proc varchar2(72) := g_package||'del';
2246: --
2247: Begin
2248: hr_utility.set_location('Entering:'||l_proc, 5);
2249: --
2250: -- Determine if the business process is to be validated.
2251: --
2252: If p_validate then

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

2285: If p_validate then
2286: Raise HR_Api.Validate_Enabled;
2287: End If;
2288: --
2289: hr_utility.set_location(' Leaving:'||l_proc, 10);
2290: Exception
2291: When HR_Api.Validate_Enabled Then
2292: --
2293: -- As the Validate_Enabled exception has been raised

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

2345: l_rec g_rec_type;
2346: l_proc varchar2(72) := g_package||'del';
2347: --
2348: Begin
2349: hr_utility.set_location('Entering:'||l_proc, 5);
2350: --
2351: -- As the delete procedure accepts a plsql record structure we do need to
2352: -- convert the arguments into the record structure.
2353: -- We don't need to call the supplied conversion argument routine as we

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

2361: -- business process
2362: --
2363: del(l_rec, p_validate);
2364: --
2365: hr_utility.set_location(' Leaving:'||l_proc, 10);
2366: End del;
2367: --
2368: end ota_tad_api;