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_TPM_BUS1 dependencies on FND_MESSAGE

Line 53: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');

49: FETCH csr_training_plan_id INTO l_exists;
50: IF csr_training_plan_id%NOTFOUND THEN
51: CLOSE csr_training_plan_id;
52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
54: fnd_message.raise_error;
55: ELSE
56: hr_utility.set_location(' Step:'|| l_proc, 80);
57: CLOSE csr_training_plan_id;

Line 54: fnd_message.raise_error;

50: IF csr_training_plan_id%NOTFOUND THEN
51: CLOSE csr_training_plan_id;
52: hr_utility.set_location(' Step:'|| l_proc, 60);
53: fnd_message.set_name('OTA', 'OTA_13828_TPC_NO_TRAINING_PLAN');
54: fnd_message.raise_error;
55: ELSE
56: hr_utility.set_location(' Step:'|| l_proc, 80);
57: CLOSE csr_training_plan_id;
58: END IF;

Line 127: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');

123: OPEN csr_activity_definition_id;
124: FETCH csr_activity_definition_id INTO l_business_group_id;
125: IF csr_activity_definition_id%NOTFOUND THEN
126: CLOSE csr_activity_definition_id;
127: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
128: fnd_message.raise_error;
129: ELSE
130: IF l_business_group_id <> p_business_group_id THEN
131: CLOSE csr_activity_definition_id;

Line 128: fnd_message.raise_error;

124: FETCH csr_activity_definition_id INTO l_business_group_id;
125: IF csr_activity_definition_id%NOTFOUND THEN
126: CLOSE csr_activity_definition_id;
127: fnd_message.set_name('OTA', 'OTA_13848_TPM_BAD_ACT_DEF');
128: fnd_message.raise_error;
129: ELSE
130: IF l_business_group_id <> p_business_group_id THEN
131: CLOSE csr_activity_definition_id;
132: fnd_message.set_name('OTA', 'OTA_13849_TPM_WRONG_ACT_DEF');

Line 132: fnd_message.set_name('OTA', 'OTA_13849_TPM_WRONG_ACT_DEF');

128: fnd_message.raise_error;
129: ELSE
130: IF l_business_group_id <> p_business_group_id THEN
131: CLOSE csr_activity_definition_id;
132: fnd_message.set_name('OTA', 'OTA_13849_TPM_WRONG_ACT_DEF');
133: fnd_message.raise_error;
134: ELSE
135: hr_utility.set_location(' Step:'|| l_proc, 30);
136: CLOSE csr_activity_definition_id;

Line 133: fnd_message.raise_error;

129: ELSE
130: IF l_business_group_id <> p_business_group_id THEN
131: CLOSE csr_activity_definition_id;
132: fnd_message.set_name('OTA', 'OTA_13849_TPM_WRONG_ACT_DEF');
133: fnd_message.raise_error;
134: ELSE
135: hr_utility.set_location(' Step:'|| l_proc, 30);
136: CLOSE csr_activity_definition_id;
137: END IF;

Line 205: fnd_message.set_name('OTA', 'OTA_13877_TPM_ONE_MEMBER');

201: --
202: IF (p_activity_definition_id IS NOT NULL AND p_activity_version_id IS NOT NULL)
203: OR (p_activity_definition_id IS NULL AND p_activity_version_id IS NULL)
204: THEN
205: fnd_message.set_name('OTA', 'OTA_13877_TPM_ONE_MEMBER');
206: fnd_message.raise_error;
207: END IF;
208: --
209: --

Line 206: fnd_message.raise_error;

202: IF (p_activity_definition_id IS NOT NULL AND p_activity_version_id IS NOT NULL)
203: OR (p_activity_definition_id IS NULL AND p_activity_version_id IS NULL)
204: THEN
205: fnd_message.set_name('OTA', 'OTA_13877_TPM_ONE_MEMBER');
206: fnd_message.raise_error;
207: END IF;
208: --
209: --
210: l_api_updating := ota_tpm_shd.api_updating

Line 229: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');

225: FETCH csr_version_definition INTO l_exists;
226: IF csr_version_definition%FOUND THEN
227: CLOSE csr_version_definition;
228: hr_utility.set_location(' Step:'|| l_proc, 60);
229: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
230: fnd_message.raise_error;
231: ELSE
232: hr_utility.set_location(' Step:'|| l_proc, 70);
233: CLOSE csr_version_definition;

Line 230: fnd_message.raise_error;

226: IF csr_version_definition%FOUND THEN
227: CLOSE csr_version_definition;
228: hr_utility.set_location(' Step:'|| l_proc, 60);
229: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
230: fnd_message.raise_error;
231: ELSE
232: hr_utility.set_location(' Step:'|| l_proc, 70);
233: CLOSE csr_version_definition;
234: END IF;

Line 341: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');

337: OPEN csr_activity_version_id;
338: FETCH csr_activity_version_id INTO l_business_group_id;
339: IF csr_activity_version_id%NOTFOUND THEN
340: CLOSE csr_activity_version_id;
341: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
342: fnd_message.raise_error;
343: ELSE
344: IF l_business_group_id <> p_business_group_id THEN
345: CLOSE csr_activity_version_id;

Line 342: fnd_message.raise_error;

338: FETCH csr_activity_version_id INTO l_business_group_id;
339: IF csr_activity_version_id%NOTFOUND THEN
340: CLOSE csr_activity_version_id;
341: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
342: fnd_message.raise_error;
343: ELSE
344: IF l_business_group_id <> p_business_group_id THEN
345: CLOSE csr_activity_version_id;
346: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');

Line 346: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');

342: fnd_message.raise_error;
343: ELSE
344: IF l_business_group_id <> p_business_group_id THEN
345: CLOSE csr_activity_version_id;
346: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');
347: fnd_message.raise_error;
348: ELSE
349: hr_utility.set_location(' Step:'|| l_proc, 30);
350: CLOSE csr_activity_version_id;

Line 347: fnd_message.raise_error;

343: ELSE
344: IF l_business_group_id <> p_business_group_id THEN
345: CLOSE csr_activity_version_id;
346: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');
347: fnd_message.raise_error;
348: ELSE
349: hr_utility.set_location(' Step:'|| l_proc, 30);
350: CLOSE csr_activity_version_id;
351: END IF;

Line 371: fnd_message.set_name('OTA', 'OTA_443569_PLPM_VER_TOO_EARLY');

367: -- Test
368: --
369: IF NVL(l_version_end_date, hr_api.g_eot) < NVL(l_plan_start_date, hr_api.g_sot) THEN
370: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
371: fnd_message.set_name('OTA', 'OTA_443569_PLPM_VER_TOO_EARLY');
372: fnd_message.set_token('TP_STARTDATE',l_plan_start_date);
373: ELSE
374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');
375: END IF;

Line 372: fnd_message.set_token('TP_STARTDATE',l_plan_start_date);

368: --
369: IF NVL(l_version_end_date, hr_api.g_eot) < NVL(l_plan_start_date, hr_api.g_sot) THEN
370: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
371: fnd_message.set_name('OTA', 'OTA_443569_PLPM_VER_TOO_EARLY');
372: fnd_message.set_token('TP_STARTDATE',l_plan_start_date);
373: ELSE
374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');
375: END IF;
376: fnd_message.raise_error;

Line 374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');

370: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
371: fnd_message.set_name('OTA', 'OTA_443569_PLPM_VER_TOO_EARLY');
372: fnd_message.set_token('TP_STARTDATE',l_plan_start_date);
373: ELSE
374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');
375: END IF;
376: fnd_message.raise_error;
377: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(l_plan_end_date, hr_api.g_eot) THEN
378: fnd_message.set_name('OTA', 'OTA_13853_TPM_VER_TOO_LATE');

Line 376: fnd_message.raise_error;

372: fnd_message.set_token('TP_STARTDATE',l_plan_start_date);
373: ELSE
374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');
375: END IF;
376: fnd_message.raise_error;
377: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(l_plan_end_date, hr_api.g_eot) THEN
378: fnd_message.set_name('OTA', 'OTA_13853_TPM_VER_TOO_LATE');
379: fnd_message.raise_error;
380: END IF;

Line 378: fnd_message.set_name('OTA', 'OTA_13853_TPM_VER_TOO_LATE');

374: fnd_message.set_name('OTA', 'OTA_13852_TPM_VER_TOO_EARLY');
375: END IF;
376: fnd_message.raise_error;
377: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(l_plan_end_date, hr_api.g_eot) THEN
378: fnd_message.set_name('OTA', 'OTA_13853_TPM_VER_TOO_LATE');
379: fnd_message.raise_error;
380: END IF;
381: END IF;
382: END IF;

Line 379: fnd_message.raise_error;

375: END IF;
376: fnd_message.raise_error;
377: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(l_plan_end_date, hr_api.g_eot) THEN
378: fnd_message.set_name('OTA', 'OTA_13853_TPM_VER_TOO_LATE');
379: fnd_message.raise_error;
380: END IF;
381: END IF;
382: END IF;
383: --

Line 530: fnd_message.set_name('OTA', 'OTA_13843_TPM_BAD_STATUS');

526: ,p_lookup_type => 'OTA_MEMBER_USER_STATUS_TYPE'
527: ,p_lookup_code => p_member_status_type_id
528: ) THEN
529: -- Error, lookup not available
530: fnd_message.set_name('OTA', 'OTA_13843_TPM_BAD_STATUS');
531: fnd_message.raise_error;
532: END IF;
533: --
534: -- If the status is not CANCELLED, test no parents (children) are in

Line 531: fnd_message.raise_error;

527: ,p_lookup_code => p_member_status_type_id
528: ) THEN
529: -- Error, lookup not available
530: fnd_message.set_name('OTA', 'OTA_13843_TPM_BAD_STATUS');
531: fnd_message.raise_error;
532: END IF;
533: --
534: -- If the status is not CANCELLED, test no parents (children) are in
535: -- the same plan, whose status is also not cancelled.

Line 545: fnd_message.set_name('OTA', 'OTA_443567_PLPM_OTHER_MEM_V');

541: CLOSE csr_seek_statuses;
542: hr_utility.set_location(' Step:'|| l_proc, 60);
543: IF p_activity_version_id IS NOT NULL THEN
544: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
545: fnd_message.set_name('OTA', 'OTA_443567_PLPM_OTHER_MEM_V');
546: Else
547: fnd_message.set_name('OTA', 'OTA_13846_TPM_OTHER_MEMBERS_V');
548: END IF;
549: fnd_message.raise_error;

Line 547: fnd_message.set_name('OTA', 'OTA_13846_TPM_OTHER_MEMBERS_V');

543: IF p_activity_version_id IS NOT NULL THEN
544: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
545: fnd_message.set_name('OTA', 'OTA_443567_PLPM_OTHER_MEM_V');
546: Else
547: fnd_message.set_name('OTA', 'OTA_13846_TPM_OTHER_MEMBERS_V');
548: END IF;
549: fnd_message.raise_error;
550: ELSE
551: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN

Line 549: fnd_message.raise_error;

545: fnd_message.set_name('OTA', 'OTA_443567_PLPM_OTHER_MEM_V');
546: Else
547: fnd_message.set_name('OTA', 'OTA_13846_TPM_OTHER_MEMBERS_V');
548: END IF;
549: fnd_message.raise_error;
550: ELSE
551: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
552: fnd_message.set_name('OTA', 'OTA_443568_PLPM_OTHER_MEM_D');
553: Else

Line 552: fnd_message.set_name('OTA', 'OTA_443568_PLPM_OTHER_MEM_D');

548: END IF;
549: fnd_message.raise_error;
550: ELSE
551: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
552: fnd_message.set_name('OTA', 'OTA_443568_PLPM_OTHER_MEM_D');
553: Else
554: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
555: END IF;
556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');

Line 554: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');

550: ELSE
551: IF (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_training_plan_id)) THEN
552: fnd_message.set_name('OTA', 'OTA_443568_PLPM_OTHER_MEM_D');
553: Else
554: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
555: END IF;
556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
557: fnd_message.raise_error;
558: END IF;

Line 556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');

552: fnd_message.set_name('OTA', 'OTA_443568_PLPM_OTHER_MEM_D');
553: Else
554: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
555: END IF;
556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
557: fnd_message.raise_error;
558: END IF;
559: ELSE
560: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 557: fnd_message.raise_error;

553: Else
554: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
555: END IF;
556: fnd_message.set_name('OTA', 'OTA_13847_TPM_OTHER_MEMBERS_D');
557: fnd_message.raise_error;
558: END IF;
559: ELSE
560: hr_utility.set_location(' Step:'|| l_proc, 70);
561: CLOSE csr_seek_statuses;

Line 651: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');

647: FETCH csr_unique INTO l_exists;
648: IF csr_unique%FOUND THEN
649: CLOSE csr_unique;
650: hr_utility.set_location(' Step:'|| l_proc, 60);
651: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
652: fnd_message.raise_error;
653: ELSE
654: CLOSE csr_unique;
655: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 652: fnd_message.raise_error;

648: IF csr_unique%FOUND THEN
649: CLOSE csr_unique;
650: hr_utility.set_location(' Step:'|| l_proc, 60);
651: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
652: fnd_message.raise_error;
653: ELSE
654: CLOSE csr_unique;
655: hr_utility.set_location(' Step:'|| l_proc, 70);
656: END IF;

Line 755: fnd_message.set_name('OTA', 'OTA_13189_TPM_CANCEL_EXISTS');

751: IF csr_unique%FOUND THEN
752: CLOSE csr_unique;
753: hr_utility.set_location(' Step:'|| l_proc, 60);
754: if l_member_status_type_id = 'CANCELLED' then
755: fnd_message.set_name('OTA', 'OTA_13189_TPM_CANCEL_EXISTS');
756: else
757: fnd_message.set_name('OTA', 'OTA_13182_TPM_ACT_NOT_UNIQUE');
758: end if;
759: fnd_message.raise_error;

Line 757: fnd_message.set_name('OTA', 'OTA_13182_TPM_ACT_NOT_UNIQUE');

753: hr_utility.set_location(' Step:'|| l_proc, 60);
754: if l_member_status_type_id = 'CANCELLED' then
755: fnd_message.set_name('OTA', 'OTA_13189_TPM_CANCEL_EXISTS');
756: else
757: fnd_message.set_name('OTA', 'OTA_13182_TPM_ACT_NOT_UNIQUE');
758: end if;
759: fnd_message.raise_error;
760: ELSE
761: CLOSE csr_unique;

Line 759: fnd_message.raise_error;

755: fnd_message.set_name('OTA', 'OTA_13189_TPM_CANCEL_EXISTS');
756: else
757: fnd_message.set_name('OTA', 'OTA_13182_TPM_ACT_NOT_UNIQUE');
758: end if;
759: fnd_message.raise_error;
760: ELSE
761: CLOSE csr_unique;
762: hr_utility.set_location(' Step:'|| l_proc, 70);
763: END IF;

Line 842: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');

838: FETCH csr_chk_delete INTO l_exists;
839: IF csr_chk_delete%FOUND THEN
840: CLOSE csr_chk_delete;
841: hr_utility.set_location(' Step:'|| l_proc, 60);
842: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
843: fnd_message.raise_error;
844: ELSE
845: hr_utility.set_location(' Step:'|| l_proc, 70);
846: CLOSE csr_chk_delete;

Line 843: fnd_message.raise_error;

839: IF csr_chk_delete%FOUND THEN
840: CLOSE csr_chk_delete;
841: hr_utility.set_location(' Step:'|| l_proc, 60);
842: fnd_message.set_name('OTA', 'OTA_13845_TPM_HAS_BUDGET_RECS');
843: fnd_message.raise_error;
844: ELSE
845: hr_utility.set_location(' Step:'|| l_proc, 70);
846: CLOSE csr_chk_delete;
847: END IF;

Line 905: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');

901: IF hr_api.not_exists_in_hr_lookups
902: (p_effective_date => p_effective_date
903: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
904: ,p_lookup_code => p_source_FUNCTION) THEN
905: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');
906: fnd_message.raise_error;
907: END IF;
908: hr_utility.set_location(' Leaving:'||l_proc, 30);
909:

Line 906: fnd_message.raise_error;

902: (p_effective_date => p_effective_date
903: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
904: ,p_lookup_code => p_source_FUNCTION) THEN
905: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');
906: fnd_message.raise_error;
907: END IF;
908: hr_utility.set_location(' Leaving:'||l_proc, 30);
909:
910: END IF;

Line 966: fnd_message.set_name('OTA','OTA_13177_TPM_CANCL_RSN_INVLD');

962: IF hr_api.not_exists_in_hr_lookups
963: (p_effective_date => p_effective_date
964: ,p_lookup_type => 'OTA_PLAN_CANCELLATION_SOURCE'
965: ,p_lookup_code => p_cancellation_reason) THEN
966: fnd_message.set_name('OTA','OTA_13177_TPM_CANCL_RSN_INVLD');
967: fnd_message.raise_error;
968: END IF;
969: hr_utility.set_location(' Leaving:'||l_proc, 30);
970:

Line 967: fnd_message.raise_error;

963: (p_effective_date => p_effective_date
964: ,p_lookup_type => 'OTA_PLAN_CANCELLATION_SOURCE'
965: ,p_lookup_code => p_cancellation_reason) THEN
966: fnd_message.set_name('OTA','OTA_13177_TPM_CANCL_RSN_INVLD');
967: fnd_message.raise_error;
968: END IF;
969: hr_utility.set_location(' Leaving:'||l_proc, 30);
970:
971: END IF;

Line 1073: fnd_message.set_name('OTA', 'OTA_13179_TPM_STRT_DATE');

1069: NVL(p_earliest_start_date, hr_api.g_date)) THEN
1070:
1071: IF ( p_earliest_start_date < TRUNC(SYSDATE))THEN
1072: l_flag := 'START_DATE';
1073: fnd_message.set_name('OTA', 'OTA_13179_TPM_STRT_DATE');
1074: fnd_message.raise_error;
1075:
1076: END IF;
1077:

Line 1074: fnd_message.raise_error;

1070:
1071: IF ( p_earliest_start_date < TRUNC(SYSDATE))THEN
1072: l_flag := 'START_DATE';
1073: fnd_message.set_name('OTA', 'OTA_13179_TPM_STRT_DATE');
1074: fnd_message.raise_error;
1075:
1076: END IF;
1077:
1078: END IF;*/

Line 1088: fnd_message.set_name('OTA', 'OTA_13994_TPS_TPM_DATES');

1084: FETCH csr_comp_tpc_tp_dates INTO l_exists,l_start_date,l_end_date;
1085: IF csr_comp_tpc_tp_dates%FOUND THEN
1086: CLOSE csr_comp_tpc_tp_dates;
1087:
1088: fnd_message.set_name('OTA', 'OTA_13994_TPS_TPM_DATES');
1089: fnd_message.set_token('TP_STARTDATE',l_start_date);
1090: fnd_message.set_token('TP_ENDDATE',l_end_date);
1091: fnd_message.raise_error;
1092: ELSE

Line 1089: fnd_message.set_token('TP_STARTDATE',l_start_date);

1085: IF csr_comp_tpc_tp_dates%FOUND THEN
1086: CLOSE csr_comp_tpc_tp_dates;
1087:
1088: fnd_message.set_name('OTA', 'OTA_13994_TPS_TPM_DATES');
1089: fnd_message.set_token('TP_STARTDATE',l_start_date);
1090: fnd_message.set_token('TP_ENDDATE',l_end_date);
1091: fnd_message.raise_error;
1092: ELSE
1093:

Line 1090: fnd_message.set_token('TP_ENDDATE',l_end_date);

1086: CLOSE csr_comp_tpc_tp_dates;
1087:
1088: fnd_message.set_name('OTA', 'OTA_13994_TPS_TPM_DATES');
1089: fnd_message.set_token('TP_STARTDATE',l_start_date);
1090: fnd_message.set_token('TP_ENDDATE',l_end_date);
1091: fnd_message.raise_error;
1092: ELSE
1093:
1094: CLOSE csr_comp_tpc_tp_dates;

Line 1091: fnd_message.raise_error;

1087:
1088: fnd_message.set_name('OTA', 'OTA_13994_TPS_TPM_DATES');
1089: fnd_message.set_token('TP_STARTDATE',l_start_date);
1090: fnd_message.set_token('TP_ENDDATE',l_end_date);
1091: fnd_message.raise_error;
1092: ELSE
1093:
1094: CLOSE csr_comp_tpc_tp_dates;
1095: END IF;

Line 1103: fnd_message.set_name('OTA', 'OTA_13181_TPM_ACT_VRSN_EARLY');

1099: FETCH csr_version_date_range INTO l_version_start_date, l_version_end_date;
1100: CLOSE csr_version_date_range;
1101: --
1102: IF NVL(l_version_end_date, hr_api.g_eot) < NVL(p_earliest_start_date, hr_api.g_sot) THEN
1103: fnd_message.set_name('OTA', 'OTA_13181_TPM_ACT_VRSN_EARLY');
1104: fnd_message.raise_error;
1105: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(p_target_completion_date, hr_api.g_eot) THEN
1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;

Line 1104: fnd_message.raise_error;

1100: CLOSE csr_version_date_range;
1101: --
1102: IF NVL(l_version_end_date, hr_api.g_eot) < NVL(p_earliest_start_date, hr_api.g_sot) THEN
1103: fnd_message.set_name('OTA', 'OTA_13181_TPM_ACT_VRSN_EARLY');
1104: fnd_message.raise_error;
1105: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(p_target_completion_date, hr_api.g_eot) THEN
1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;
1108: elsif (l_version_start_date>p_earliest_start_date) or (l_version_end_date

Line 1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');

1102: IF NVL(l_version_end_date, hr_api.g_eot) < NVL(p_earliest_start_date, hr_api.g_sot) THEN
1103: fnd_message.set_name('OTA', 'OTA_13181_TPM_ACT_VRSN_EARLY');
1104: fnd_message.raise_error;
1105: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(p_target_completion_date, hr_api.g_eot) THEN
1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;
1108: elsif (l_version_start_date>p_earliest_start_date) or (l_version_end_date 1109: fnd_message.set_name('OTA', 'OTA_13188_TPM_DATES_RANGE');
1110: fnd_message.raise_error;

Line 1107: fnd_message.raise_error;

1103: fnd_message.set_name('OTA', 'OTA_13181_TPM_ACT_VRSN_EARLY');
1104: fnd_message.raise_error;
1105: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(p_target_completion_date, hr_api.g_eot) THEN
1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;
1108: elsif (l_version_start_date>p_earliest_start_date) or (l_version_end_date 1109: fnd_message.set_name('OTA', 'OTA_13188_TPM_DATES_RANGE');
1110: fnd_message.raise_error;
1111: END IF;

Line 1109: fnd_message.set_name('OTA', 'OTA_13188_TPM_DATES_RANGE');

1105: ELSIF NVL(l_version_start_date, hr_api.g_sot) > NVL(p_target_completion_date, hr_api.g_eot) THEN
1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;
1108: elsif (l_version_start_date>p_earliest_start_date) or (l_version_end_date 1109: fnd_message.set_name('OTA', 'OTA_13188_TPM_DATES_RANGE');
1110: fnd_message.raise_error;
1111: END IF;
1112:
1113: OPEN csr_tpm_overlap;

Line 1110: fnd_message.raise_error;

1106: fnd_message.set_name('OTA', 'OTA_13180_TPM_ACT_VRSN_LATE');
1107: fnd_message.raise_error;
1108: elsif (l_version_start_date>p_earliest_start_date) or (l_version_end_date 1109: fnd_message.set_name('OTA', 'OTA_13188_TPM_DATES_RANGE');
1110: fnd_message.raise_error;
1111: END IF;
1112:
1113: OPEN csr_tpm_overlap;
1114: FETCH csr_tpm_overlap INTO l_exists;

Line 1118: fnd_message.set_name('OTA', 'OTA_13184_TPM_DATES_OVERLAP');

1114: FETCH csr_tpm_overlap INTO l_exists;
1115: IF csr_tpm_overlap%FOUND THEN
1116: CLOSE csr_tpm_overlap;
1117:
1118: fnd_message.set_name('OTA', 'OTA_13184_TPM_DATES_OVERLAP');
1119: fnd_message.raise_error;
1120: ELSE
1121:
1122: CLOSE csr_tpm_overlap;

Line 1119: fnd_message.raise_error;

1115: IF csr_tpm_overlap%FOUND THEN
1116: CLOSE csr_tpm_overlap;
1117:
1118: fnd_message.set_name('OTA', 'OTA_13184_TPM_DATES_OVERLAP');
1119: fnd_message.raise_error;
1120: ELSE
1121:
1122: CLOSE csr_tpm_overlap;
1123: END IF;

Line 1128: fnd_message.set_name('OTA', 'OTA_13993_TPM_DATES');

1124:
1125:
1126: ELSE
1127: l_flag := 'END_DATE';
1128: fnd_message.set_name('OTA', 'OTA_13993_TPM_DATES');
1129: fnd_message.raise_error;
1130: END IF;
1131:
1132:

Line 1129: fnd_message.raise_error;

1125:
1126: ELSE
1127: l_flag := 'END_DATE';
1128: fnd_message.set_name('OTA', 'OTA_13993_TPM_DATES');
1129: fnd_message.raise_error;
1130: END IF;
1131:
1132:
1133: END IF;