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

Line 78: fnd_message.set_name('OTA', 'OTA_13867_TPS_DUPLICATE_TP');

74: FETCH csr_unique INTO l_exists;
75: IF csr_unique%FOUND THEN
76: CLOSE csr_unique;
77: hr_utility.set_location(' Step:'|| l_proc, 60);
78: fnd_message.set_name('OTA', 'OTA_13867_TPS_DUPLICATE_TP');
79: fnd_message.raise_error;
80: ELSE
81: CLOSE csr_unique;
82: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 79: fnd_message.raise_error;

75: IF csr_unique%FOUND THEN
76: CLOSE csr_unique;
77: hr_utility.set_location(' Step:'|| l_proc, 60);
78: fnd_message.set_name('OTA', 'OTA_13867_TPS_DUPLICATE_TP');
79: fnd_message.raise_error;
80: ELSE
81: CLOSE csr_unique;
82: hr_utility.set_location(' Step:'|| l_proc, 70);
83: END IF;

Line 129: fnd_message.set_name('OTA', 'OTA_13858_TPS_ORG_OR_PERSON');

125: */
126: IF ( (p_organization_id IS NOT NULL AND (p_person_id IS NOT NULL OR p_contact_id IS NOT NULL))
127: OR (p_organization_id IS NULL AND p_person_id IS NULL AND p_contact_id IS NULL)
128: OR (p_organization_id IS NULL AND p_person_id IS NOT NULL AND p_contact_id IS NOT NULL)) THEN
129: fnd_message.set_name('OTA', 'OTA_13858_TPS_ORG_OR_PERSON');
130: fnd_message.raise_error;
131: END IF;
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 130: fnd_message.raise_error;

126: IF ( (p_organization_id IS NOT NULL AND (p_person_id IS NOT NULL OR p_contact_id IS NOT NULL))
127: OR (p_organization_id IS NULL AND p_person_id IS NULL AND p_contact_id IS NULL)
128: OR (p_organization_id IS NULL AND p_person_id IS NOT NULL AND p_contact_id IS NOT NULL)) THEN
129: fnd_message.set_name('OTA', 'OTA_13858_TPS_ORG_OR_PERSON');
130: fnd_message.raise_error;
131: END IF;
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 20);
134:

Line 187: fnd_message.set_name('OTA', 'OTA_13859_TPS_BAD_ORG');

183: FETCH csr_organization_id INTO l_business_group_id;
184: IF csr_organization_id%NOTFOUND THEN
185: CLOSE csr_organization_id;
186: hr_utility.set_location(' Step:'|| l_proc, 40);
187: fnd_message.set_name('OTA', 'OTA_13859_TPS_BAD_ORG');
188: fnd_message.raise_error;
189: ELSIF l_business_group_id <> p_business_group_id THEN
190: CLOSE csr_organization_id;
191: fnd_message.set_name('OTA', 'OTA_13860_TPS_WRONG_ORG');

Line 188: fnd_message.raise_error;

184: IF csr_organization_id%NOTFOUND THEN
185: CLOSE csr_organization_id;
186: hr_utility.set_location(' Step:'|| l_proc, 40);
187: fnd_message.set_name('OTA', 'OTA_13859_TPS_BAD_ORG');
188: fnd_message.raise_error;
189: ELSIF l_business_group_id <> p_business_group_id THEN
190: CLOSE csr_organization_id;
191: fnd_message.set_name('OTA', 'OTA_13860_TPS_WRONG_ORG');
192: fnd_message.raise_error;

Line 191: fnd_message.set_name('OTA', 'OTA_13860_TPS_WRONG_ORG');

187: fnd_message.set_name('OTA', 'OTA_13859_TPS_BAD_ORG');
188: fnd_message.raise_error;
189: ELSIF l_business_group_id <> p_business_group_id THEN
190: CLOSE csr_organization_id;
191: fnd_message.set_name('OTA', 'OTA_13860_TPS_WRONG_ORG');
192: fnd_message.raise_error;
193: ELSE
194: CLOSE csr_organization_id;
195: END IF;

Line 192: fnd_message.raise_error;

188: fnd_message.raise_error;
189: ELSIF l_business_group_id <> p_business_group_id THEN
190: CLOSE csr_organization_id;
191: fnd_message.set_name('OTA', 'OTA_13860_TPS_WRONG_ORG');
192: fnd_message.raise_error;
193: ELSE
194: CLOSE csr_organization_id;
195: END IF;
196: END IF;

Line 253: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');

249: FETCH csr_person_id INTO l_business_group_id;
250: IF csr_person_id%NOTFOUND THEN
251: CLOSE csr_person_id;
252: hr_utility.set_location(' Step:'|| l_proc, 40);
253: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
254: fnd_message.raise_error;
255: /*
256: selected person can be from a business group other than
257: the one set up in the profiles.

Line 254: fnd_message.raise_error;

250: IF csr_person_id%NOTFOUND THEN
251: CLOSE csr_person_id;
252: hr_utility.set_location(' Step:'|| l_proc, 40);
253: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
254: fnd_message.raise_error;
255: /*
256: selected person can be from a business group other than
257: the one set up in the profiles.
258: ELSIF l_business_group_id <> p_business_group_id THEN

Line 260: fnd_message.set_name('OTA', 'OTA_13862_TPS_WRONG_PERSON');

256: selected person can be from a business group other than
257: the one set up in the profiles.
258: ELSIF l_business_group_id <> p_business_group_id THEN
259: CLOSE csr_person_id;
260: fnd_message.set_name('OTA', 'OTA_13862_TPS_WRONG_PERSON');
261: fnd_message.raise_error;
262: */
263: ELSE
264: CLOSE csr_person_id;

Line 261: fnd_message.raise_error;

257: the one set up in the profiles.
258: ELSIF l_business_group_id <> p_business_group_id THEN
259: CLOSE csr_person_id;
260: fnd_message.set_name('OTA', 'OTA_13862_TPS_WRONG_PERSON');
261: fnd_message.raise_error;
262: */
263: ELSE
264: CLOSE csr_person_id;
265: END IF;

Line 342: fnd_message.set_name('OTA', 'OTA_13865_TPS_BAD_TIME_PERIOD');

338: OPEN csr_time_period_id;
339: FETCH csr_time_period_id INTO l_exists;
340: IF csr_time_period_id%NOTFOUND THEN
341: CLOSE csr_time_period_id;
342: fnd_message.set_name('OTA', 'OTA_13865_TPS_BAD_TIME_PERIOD');
343: fnd_message.raise_error;
344: ELSE
345: CLOSE csr_time_period_id;
346: END IF;

Line 343: fnd_message.raise_error;

339: FETCH csr_time_period_id INTO l_exists;
340: IF csr_time_period_id%NOTFOUND THEN
341: CLOSE csr_time_period_id;
342: fnd_message.set_name('OTA', 'OTA_13865_TPS_BAD_TIME_PERIOD');
343: fnd_message.raise_error;
344: ELSE
345: CLOSE csr_time_period_id;
346: END IF;
347: END IF;

Line 361: fnd_message.set_name('OTA', 'OTA_13866_TPS_NO_CHANGE_TIME');

357: OPEN csr_members;
358: FETCH csr_members INTO l_exists;
359: IF csr_members%FOUND THEN
360: CLOSE csr_members;
361: fnd_message.set_name('OTA', 'OTA_13866_TPS_NO_CHANGE_TIME');
362: fnd_message.raise_error;
363: ELSE
364: CLOSE csr_members;
365: END IF;

Line 362: fnd_message.raise_error;

358: FETCH csr_members INTO l_exists;
359: IF csr_members%FOUND THEN
360: CLOSE csr_members;
361: fnd_message.set_name('OTA', 'OTA_13866_TPS_NO_CHANGE_TIME');
362: fnd_message.raise_error;
363: ELSE
364: CLOSE csr_members;
365: END IF;
366: END IF;

Line 416: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');

412: ,p_lookup_code => p_plan_status_type_id
413: ) THEN
414: -- Error, lookup not available
415: If (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan()) THEN
416: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
417: Else
418: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
419: END IF;
420: fnd_message.raise_error;

Line 418: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');

414: -- Error, lookup not available
415: If (OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan()) THEN
416: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
417: Else
418: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
419: END IF;
420: fnd_message.raise_error;
421: END IF;
422: --

Line 420: fnd_message.raise_error;

416: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
417: Else
418: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
419: END IF;
420: fnd_message.raise_error;
421: END IF;
422: --
423: --
424: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 560: fnd_message.set_name('OTA', 'OTA_13863_TPS_OVERLAP_PLANS');

556: FETCH csr_plan_overlap INTO l_exists;
557: IF csr_plan_overlap%FOUND THEN
558: CLOSE csr_plan_overlap;
559: hr_utility.set_location(' Step:'|| l_proc, 70);
560: fnd_message.set_name('OTA', 'OTA_13863_TPS_OVERLAP_PLANS');
561: fnd_message.raise_error;
562: ELSE
563: CLOSE csr_plan_overlap;
564: END IF;

Line 561: fnd_message.raise_error;

557: IF csr_plan_overlap%FOUND THEN
558: CLOSE csr_plan_overlap;
559: hr_utility.set_location(' Step:'|| l_proc, 70);
560: fnd_message.set_name('OTA', 'OTA_13863_TPS_OVERLAP_PLANS');
561: fnd_message.raise_error;
562: ELSE
563: CLOSE csr_plan_overlap;
564: END IF;
565: END IF;

Line 642: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');

638: OPEN csr_currency_code;
639: FETCH csr_currency_code INTO l_exists;
640: IF csr_currency_code%NOTFOUND THEN
641: CLOSE csr_currency_code;
642: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
643: fnd_message.set_token('CODE', p_budget_currency);
644: fnd_message.raise_error;
645: ELSE
646: CLOSE csr_currency_code;

Line 643: fnd_message.set_token('CODE', p_budget_currency);

639: FETCH csr_currency_code INTO l_exists;
640: IF csr_currency_code%NOTFOUND THEN
641: CLOSE csr_currency_code;
642: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
643: fnd_message.set_token('CODE', p_budget_currency);
644: fnd_message.raise_error;
645: ELSE
646: CLOSE csr_currency_code;
647: END IF;

Line 644: fnd_message.raise_error;

640: IF csr_currency_code%NOTFOUND THEN
641: CLOSE csr_currency_code;
642: fnd_message.set_name('AOL', 'MC_INVALID_CURRENCY');
643: fnd_message.set_token('CODE', p_budget_currency);
644: fnd_message.raise_error;
645: ELSE
646: CLOSE csr_currency_code;
647: END IF;
648: END IF;

Line 738: fnd_message.set_name('OTA', 'OTA_443572_PLP_UNIQUE_NAME');

734: OPEN csr_plp_name;
735: FETCH csr_plp_name INTO l_exists;
736: IF csr_plp_name%FOUND THEN
737: CLOSE csr_plp_name;
738: fnd_message.set_name('OTA', 'OTA_443572_PLP_UNIQUE_NAME');
739: fnd_message.raise_error;
740: ELSE
741: CLOSE csr_plp_name;
742: END IF;

Line 739: fnd_message.raise_error;

735: FETCH csr_plp_name INTO l_exists;
736: IF csr_plp_name%FOUND THEN
737: CLOSE csr_plp_name;
738: fnd_message.set_name('OTA', 'OTA_443572_PLP_UNIQUE_NAME');
739: fnd_message.raise_error;
740: ELSE
741: CLOSE csr_plp_name;
742: END IF;
743: ELSE

Line 748: fnd_message.set_name('OTA', 'OTA_13897_TPS_UNIQUE_NAME');

744: OPEN csr_name;
745: FETCH csr_name INTO l_exists;
746: IF csr_name%FOUND THEN
747: CLOSE csr_name;
748: fnd_message.set_name('OTA', 'OTA_13897_TPS_UNIQUE_NAME');
749: fnd_message.raise_error;
750: ELSE
751: CLOSE csr_name;
752: END IF;

Line 749: fnd_message.raise_error;

745: FETCH csr_name INTO l_exists;
746: IF csr_name%FOUND THEN
747: CLOSE csr_name;
748: fnd_message.set_name('OTA', 'OTA_13897_TPS_UNIQUE_NAME');
749: fnd_message.raise_error;
750: ELSE
751: CLOSE csr_name;
752: END IF;
753: END IF;

Line 814: fnd_message.set_name('OTA', 'OTA_13868_TPS_CHILD_RECORDS');

810: FETCH csr_del_training_plan_id INTO l_exists;
811: IF csr_del_training_plan_id%FOUND THEN
812: CLOSE csr_del_training_plan_id;
813: hr_utility.set_location(' Step:'|| l_proc, 10);
814: fnd_message.set_name('OTA', 'OTA_13868_TPS_CHILD_RECORDS');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_del_training_plan_id;
818: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 815: fnd_message.raise_error;

811: IF csr_del_training_plan_id%FOUND THEN
812: CLOSE csr_del_training_plan_id;
813: hr_utility.set_location(' Step:'|| l_proc, 10);
814: fnd_message.set_name('OTA', 'OTA_13868_TPS_CHILD_RECORDS');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_del_training_plan_id;
818: hr_utility.set_location(' Leaving:'||l_proc, 20);
819: --

Line 860: fnd_message.set_name('OTA','OTA_13176_TPM_PLN_SRC_INVLD');

856: IF hr_api.not_exists_in_hr_lookups
857: (p_effective_date => p_effective_date
858: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
859: ,p_lookup_code => p_plan_source) THEN
860: fnd_message.set_name('OTA','OTA_13176_TPM_PLN_SRC_INVLD');
861: fnd_message.raise_error;
862: END IF;
863: hr_utility.set_location(' Leaving:'||l_proc, 30);
864:

Line 861: fnd_message.raise_error;

857: (p_effective_date => p_effective_date
858: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
859: ,p_lookup_code => p_plan_source) THEN
860: fnd_message.set_name('OTA','OTA_13176_TPM_PLN_SRC_INVLD');
861: fnd_message.raise_error;
862: END IF;
863: hr_utility.set_location(' Leaving:'||l_proc, 30);
864:
865: END IF;

Line 955: fnd_message.set_name('OTA', 'OTA_13999_TPS_STRT_DATE');

951: NVL( p_start_date, hr_api.g_date )) THEN
952:
953: IF ( p_start_date < TRUNC(SYSDATE) ) THEN
954: l_flag :='START_DATE';
955: fnd_message.set_name('OTA', 'OTA_13999_TPS_STRT_DATE');
956: fnd_message.raise_error;
957: END IF;
958:
959: END IF;*/

Line 956: fnd_message.raise_error;

952:
953: IF ( p_start_date < TRUNC(SYSDATE) ) THEN
954: l_flag :='START_DATE';
955: fnd_message.set_name('OTA', 'OTA_13999_TPS_STRT_DATE');
956: fnd_message.raise_error;
957: END IF;
958:
959: END IF;*/
960: if p_end_date is not null then

Line 975: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');

971:
972: OPEN csr_max_tpm_tcd;
973: FETCH csr_max_tpm_tcd into l_target_completion_date;
974: CLOSE csr_max_tpm_tcd;
975: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
976: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
977: fnd_message.raise_error;
978: ELSE
979: CLOSE csr_get_TPM;

Line 976: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);

972: OPEN csr_max_tpm_tcd;
973: FETCH csr_max_tpm_tcd into l_target_completion_date;
974: CLOSE csr_max_tpm_tcd;
975: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
976: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
977: fnd_message.raise_error;
978: ELSE
979: CLOSE csr_get_TPM;
980: END IF;

Line 977: fnd_message.raise_error;

973: FETCH csr_max_tpm_tcd into l_target_completion_date;
974: CLOSE csr_max_tpm_tcd;
975: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
976: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
977: fnd_message.raise_error;
978: ELSE
979: CLOSE csr_get_TPM;
980: END IF;
981: -- Bug 3529382 ELSIF ( p_start_date > p_end_date ) THEN

Line 984: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');

980: END IF;
981: -- Bug 3529382 ELSIF ( p_start_date > p_end_date ) THEN
982: ELSE
983: l_flag :='END_DATE';
984: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
985: -- Bug 3484721
986: fnd_message.set_token('TP_STARTDATE',p_start_date);
987: fnd_message.raise_error;
988:

Line 986: fnd_message.set_token('TP_STARTDATE',p_start_date);

982: ELSE
983: l_flag :='END_DATE';
984: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
985: -- Bug 3484721
986: fnd_message.set_token('TP_STARTDATE',p_start_date);
987: fnd_message.raise_error;
988:
989: END IF;
990: */

Line 987: fnd_message.raise_error;

983: l_flag :='END_DATE';
984: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
985: -- Bug 3484721
986: fnd_message.set_token('TP_STARTDATE',p_start_date);
987: fnd_message.raise_error;
988:
989: END IF;
990: */
991:

Line 1004: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');

1000: OPEN csr_max_tpm_tcd;
1001: FETCH csr_max_tpm_tcd into l_target_completion_date;
1002: CLOSE csr_max_tpm_tcd;
1003: l_flag :='END_DATE';
1004: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
1005: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
1006: fnd_message.raise_error;
1007: --When there are no components created yet
1008: ELSIF (p_end_date < p_start_date) THEN

Line 1005: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);

1001: FETCH csr_max_tpm_tcd into l_target_completion_date;
1002: CLOSE csr_max_tpm_tcd;
1003: l_flag :='END_DATE';
1004: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
1005: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
1006: fnd_message.raise_error;
1007: --When there are no components created yet
1008: ELSIF (p_end_date < p_start_date) THEN
1009: CLOSE csr_get_TPM;

Line 1006: fnd_message.raise_error;

1002: CLOSE csr_max_tpm_tcd;
1003: l_flag :='END_DATE';
1004: fnd_message.set_name('OTA', 'OTA_443687_TPS_MAX_TPM_DATE');
1005: fnd_message.set_token('MAX_TPC_TARGET_DATE',l_target_completion_date);
1006: fnd_message.raise_error;
1007: --When there are no components created yet
1008: ELSIF (p_end_date < p_start_date) THEN
1009: CLOSE csr_get_TPM;
1010: l_flag :='END_DATE';

Line 1011: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');

1007: --When there are no components created yet
1008: ELSIF (p_end_date < p_start_date) THEN
1009: CLOSE csr_get_TPM;
1010: l_flag :='END_DATE';
1011: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
1012: fnd_message.set_token('TP_STARTDATE',p_start_date);
1013: fnd_message.raise_error;
1014: ELSE
1015: CLOSE csr_get_TPM;

Line 1012: fnd_message.set_token('TP_STARTDATE',p_start_date);

1008: ELSIF (p_end_date < p_start_date) THEN
1009: CLOSE csr_get_TPM;
1010: l_flag :='END_DATE';
1011: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
1012: fnd_message.set_token('TP_STARTDATE',p_start_date);
1013: fnd_message.raise_error;
1014: ELSE
1015: CLOSE csr_get_TPM;
1016: END IF;

Line 1013: fnd_message.raise_error;

1009: CLOSE csr_get_TPM;
1010: l_flag :='END_DATE';
1011: fnd_message.set_name('OTA', 'OTA_13992_TPS_DATES');
1012: fnd_message.set_token('TP_STARTDATE',p_start_date);
1013: fnd_message.raise_error;
1014: ELSE
1015: CLOSE csr_get_TPM;
1016: END IF;
1017: