APPS.OTA_TPS_BUS1 dependencies on HR_MULTI_MESSAGE

Line 41: IF hr_multi_message.no_exclusive_error

37: --
38: --
39: hr_utility.set_location(' Step:'|| l_proc, 45);
40:
41: IF hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
43: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
44: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
45: ,p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'

Line 94: IF hr_multi_message.exception_add(

90: EXCEPTION
91:
92: WHEN app_exception.application_exception THEN
93:
94: IF hr_multi_message.exception_add(
95: p_same_associated_columns => 'Y') THEN
96:
97: hr_utility.set_location(' Leaving:'||l_proc, 92);
98: RAISE;

Line 140: IF hr_multi_message.exception_add(

136: EXCEPTION
137:
138: WHEN app_exception.application_exception THEN
139:
140: IF hr_multi_message.exception_add(
141: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
142: ,p_associated_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
143: ,p_associated_column3 => 'OTA_TRAINING_PLANS.CONTACT_ID') THEN
144:

Line 205: IF hr_multi_message.exception_add(

201: EXCEPTION
202:
203: WHEN app_exception.application_exception THEN
204:
205: IF hr_multi_message.exception_add(
206: p_associated_column1 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID') THEN
207:
208: hr_utility.set_location(' Leaving:'||l_proc, 52);
209: RAISE;

Line 275: IF hr_multi_message.exception_add(

271: EXCEPTION
272:
273: WHEN app_exception.application_exception THEN
274:
275: IF hr_multi_message.exception_add(
276: p_associated_column1 => 'OTA_TRAINING_PLANS.PERSON_ID') THEN
277:
278: hr_utility.set_location(' Leaving:'||l_proc, 52);
279: RAISE;

Line 374: IF hr_multi_message.exception_add(

370: EXCEPTION
371:
372: WHEN app_exception.application_exception THEN
373:
374: IF hr_multi_message.exception_add(
375: p_associated_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID') THEN
376:
377: hr_utility.set_location(' Leaving:'||l_proc, 62);
378: RAISE;

Line 431: IF hr_multi_message.exception_add(

427: EXCEPTION
428:
429: WHEN app_exception.application_exception THEN
430:
431: IF hr_multi_message.exception_add(
432: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID') THEN
433:
434: hr_utility.set_location(' Leaving:'||l_proc, 32);
435: RAISE;

Line 498: IF hr_multi_message.no_exclusive_error

494:
495:
496: --MULTI MESSAGE SUPPORT
497:
498: IF hr_multi_message.no_exclusive_error
499: (p_check_column1 => 'OTA_TRAINING_PLANS.TIME_PERIOD_ID'
500: ,p_check_column2 => 'OTA_TRAINING_PLANS.PERSON_ID'
501: ,p_check_column3 => 'OTA_TRAINING_PLANS.ORGANIZATION_ID'
502: ,p_check_column4 => 'OTA_TRAINING_PLANS.PLAN_STATUS_TYPE_ID'

Line 574: IF hr_multi_message.exception_add

570: EXCEPTION
571:
572: WHEN app_exception.application_exception THEN
573:
574: IF hr_multi_message.exception_add
575: (p_same_associated_columns => 'Y') THEN
576:
577: hr_utility.set_location(' Leaving:'||l_proc, 82);
578: RAISE;

Line 658: IF hr_multi_message.exception_add(

654: EXCEPTION
655:
656: WHEN app_exception.application_exception THEN
657:
658: IF hr_multi_message.exception_add(
659: p_associated_column1 => 'OTA_TRAINING_PLANS.BUDGET_CURRENCY') THEN
660:
661: hr_utility.set_location(' Leaving:'||l_proc, 92);
662: RAISE;

Line 763: IF hr_multi_message.exception_add(

759: EXCEPTION
760:
761: WHEN app_exception.application_exception THEN
762:
763: IF hr_multi_message.exception_add(
764: p_associated_column1 => 'OTA_TRAINING_PLANS.NAME') THEN
765:
766: hr_utility.set_location(' Leaving:'||l_proc, 12);
767: RAISE;

Line 875: IF hr_multi_message.exception_add(

871: EXCEPTION
872:
873: WHEN app_exception.application_exception THEN
874:
875: IF hr_multi_message.exception_add(
876: p_associated_column1 => 'OTA_TRAINING_PLANS.PLAN_SOURCE') THEN
877:
878: hr_utility.set_location(' Leaving:'||l_proc, 42);
879: RAISE;

Line 1031: /* IF hr_multi_message.exception_add(

1027: WHEN app_exception.application_exception THEN
1028:
1029: IF l_flag = 'END_DATE' THEN
1030:
1031: /* IF hr_multi_message.exception_add(
1032: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE') THEN
1033: hr_utility.set_location(' Leaving:'||l_proc, 32);
1034: RAISE;
1035:

Line 1039: IF hr_multi_message.exception_add(

1035:
1036: END IF;
1037: ELSIF l_flag = 'END_DATE' THEN */
1038:
1039: IF hr_multi_message.exception_add(
1040: p_associated_column1 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1041:
1042: hr_utility.set_location(' Leaving:'||l_proc, 34);
1043: RAISE;

Line 1049: IF hr_multi_message.exception_add(

1045: END IF;
1046:
1047: ELSE
1048:
1049: IF hr_multi_message.exception_add(
1050: p_associated_column1 => 'OTA_TRAINING_PLANS.START_DATE'
1051: ,p_associated_column2 => 'OTA_TRAINING_PLANS.END_DATE') THEN
1052:
1053: hr_utility.set_location(' Leaving:'||l_proc, 36);