62: EXCEPTION
63:
64: WHEN app_exception.application_exception THEN
65:
66: IF hr_multi_message.exception_add
67: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
68:
69: hr_utility.set_location(' Leaving:'||l_proc, 92);
70: RAISE;
144: EXCEPTION
145:
146: WHEN app_exception.application_exception THEN
147:
148: IF hr_multi_message.exception_add
149: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
150:
151: hr_utility.set_location(' Leaving:'||l_proc, 42);
152: RAISE;
239: EXCEPTION
240:
241: WHEN app_exception.application_exception THEN
242:
243: IF hr_multi_message.exception_add
244: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
245: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID') THEN
246:
247: hr_utility.set_location(' Leaving:'||l_proc, 102);
307: -- check mandatory parameters have been set.
308: --
309: hr_utility.set_location(' Step:'|| l_proc, 10);
310:
311: IF hr_multi_message.no_exclusive_error
312: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
313: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
314:
315: hr_api.mandatory_arg_error
388: EXCEPTION
389:
390: WHEN app_exception.application_exception THEN
391:
392: IF hr_multi_message.exception_add
393: (p_same_associated_columns => 'Y') THEN
394:
395: hr_utility.set_location(' Leaving:'||l_proc, 42);
396: RAISE;
469: -- check mandatory parameters have been set.
470: --
471: hr_utility.set_location(' Step:'|| l_proc, 30);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
475: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
476: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
477: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
568: EXCEPTION
569:
570: WHEN app_exception.application_exception THEN
571:
572: IF hr_multi_message.exception_add
573: (p_same_associated_columns => 'Y') THEN
574:
575: hr_utility.set_location(' Leaving:'||l_proc, 82);
576: RAISE;
611: --
612: --
613: hr_utility.set_location(' Step:'|| l_proc, 30);
614:
615: IF hr_multi_message.no_exclusive_error
616: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
617: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
618: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
619: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
662: EXCEPTION
663:
664: WHEN app_exception.application_exception THEN
665:
666: IF hr_multi_message.exception_add
667: (p_same_associated_columns => 'Y') THEN
668:
669: hr_utility.set_location(' Leaving:'||l_proc, 92);
670: RAISE;
712: --
713: --
714: hr_utility.set_location(' Step:'|| l_proc, 30);
715:
716: IF hr_multi_message.no_exclusive_error
717: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
718: ,p_check_column2 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_VERSION_ID'
719: ,p_check_column3 => 'OTA_TRAINING_PLAN_MEMBERS.ACTIVITY_DEFINITION_ID'
720: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
770: EXCEPTION
771:
772: WHEN app_exception.application_exception THEN
773:
774: IF hr_multi_message.exception_add
775: (p_same_associated_columns => 'Y') THEN
776:
777: hr_utility.set_location(' Leaving:'||l_proc, 92);
778: RAISE;
811: --
812: --
813: hr_utility.set_location(' Step:'|| l_proc, 30);
814:
815: IF hr_multi_message.no_exclusive_error
816: (p_check_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID'
817: ,p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TRAINING_PLAN_ID') THEN
818:
819:
852: EXCEPTION
853:
854: WHEN app_exception.application_exception THEN
855:
856: IF hr_multi_message.exception_add
857: (p_same_associated_columns => 'Y') THEN
858:
859: hr_utility.set_location(' Leaving:'||l_proc, 102);
860: RAISE;
915: EXCEPTION
916:
917: WHEN app_exception.application_exception THEN
918:
919: IF hr_multi_message.exception_add
920: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.SOURCE_FUNCTION') THEN
921:
922: hr_utility.set_location(' Leaving:'||l_proc, 42);
923: RAISE;
976: EXCEPTION
977:
978: WHEN app_exception.application_exception THEN
979:
980: IF hr_multi_message.exception_add
981: (p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.CANCELLATION_REASON') THEN
982:
983: hr_utility.set_location(' Leaving:'||l_proc, 42);
984: RAISE;
1139:
1140: WHEN app_exception.application_exception THEN
1141:
1142: IF l_flag ='END_DATE' THEN
1143: /* IF hr_multi_message.exception_add(
1144: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1145: -- ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1146:
1147: hr_utility.set_location(' Leaving:'||l_proc, 32);
1148: RAISE;
1149:
1150: END IF;
1151: ELSIF l_flag = 'END_DATE' THEN */
1152: IF hr_multi_message.exception_add(
1153: -- p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE') THEN
1154: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1155:
1156: hr_utility.set_location(' Leaving:'||l_proc, 35);
1157: RAISE;
1158:
1159: END IF;
1160: ELSE
1161: IF hr_multi_message.exception_add(
1162: p_associated_column1 => 'OTA_TRAINING_PLAN_MEMBERS.EARLIEST_START_DATE'
1163: ,p_associated_column2 => 'OTA_TRAINING_PLAN_MEMBERS.TARGET_COMPLETION_DATE') THEN
1164:
1165: hr_utility.set_location(' Leaving:'||l_proc, 36);