DBA Data[Home] [Help]

APPS.OTA_LPE_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'LP_ENROLLMENT_ID')
67: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

Line 380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

376: IF NOT ota_lpe_shd.api_updating
377: (p_lp_enrollment_id => p_rec.lp_enrollment_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;

Line 381: fnd_message.set_token('PROCEDURE ', l_proc);

377: (p_lp_enrollment_id => p_rec.lp_enrollment_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --

Line 382: fnd_message.set_token('STEP ', '5');

378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
386: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 383: fnd_message.raise_error;

379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385: --
386: -- EDIT_HERE: Add checks to ensure non-updateable args have
387: -- not been updated.

Line 438: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');

434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
437: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
438: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
439: fnd_message.raise_error;
440: END IF;
441: hr_utility.set_location('Leaving:'||l_proc, 10);
442: End chk_person_contact;

Line 439: fnd_message.raise_error;

435: hr_utility.set_location('Entering:'||l_proc, 5);
436: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
437: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
438: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
439: fnd_message.raise_error;
440: END IF;
441: hr_utility.set_location('Leaving:'||l_proc, 10);
442: End chk_person_contact;
443:

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

466: FETCH csr_person_id INTO l_exists;
467: IF csr_person_id%NOTFOUND THEN
468: CLOSE csr_person_id;
469: hr_utility.set_location(' Step:'|| l_proc, 40);
470: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
471: fnd_message.raise_error;
472: ELSE
473: CLOSE csr_person_id;
474: END IF;

Line 471: fnd_message.raise_error;

467: IF csr_person_id%NOTFOUND THEN
468: CLOSE csr_person_id;
469: hr_utility.set_location(' Step:'|| l_proc, 40);
470: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
471: fnd_message.raise_error;
472: ELSE
473: CLOSE csr_person_id;
474: END IF;
475: END IF;

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

518: ,p_lookup_type => 'OTA_LEARNING_PATH_STATUS'
519: ,p_lookup_code => p_path_status_code
520: ) THEN
521: -- Error, lookup not available
522: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
523: fnd_message.raise_error;
524: END IF;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 523: fnd_message.raise_error;

519: ,p_lookup_code => p_path_status_code
520: ) THEN
521: -- Error, lookup not available
522: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
523: fnd_message.raise_error;
524: END IF;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 30);
527:

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

566: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
567: ,p_lookup_code => p_enrollment_source_code
568: ) THEN
569: -- Error, lookup not available
570: fnd_message.set_name('OTA', 'OTA_13176_TPM_PLN_SRC_INVLD');
571: fnd_message.raise_error;
572: END IF;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 571: fnd_message.raise_error;

567: ,p_lookup_code => p_enrollment_source_code
568: ) THEN
569: -- Error, lookup not available
570: fnd_message.set_name('OTA', 'OTA_13176_TPM_PLN_SRC_INVLD');
571: fnd_message.raise_error;
572: END IF;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 30);
575:

Line 624: fnd_message.set_name('OTA', 'OTA_13078_LPS_LPM_EXIST');

620: FETCH csr_lp_enr_id INTO l_exists;
621: IF csr_lp_enr_id%FOUND THEN
622: CLOSE csr_lp_enr_id;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13078_LPS_LPM_EXIST');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_lp_enr_id;
628: END IF;

Line 625: fnd_message.raise_error;

621: IF csr_lp_enr_id%FOUND THEN
622: CLOSE csr_lp_enr_id;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13078_LPS_LPM_EXIST');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_lp_enr_id;
628: END IF;
629:

Line 696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');

692: ,p_customer_id => NULL
693: ,p_contact_id => p_contact_id);
694:
695: hr_utility.set_location(' Step:'|| l_proc, 10);
696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
697: fnd_message.set_token('LEARNER_NAME', l_person_name);
698: fnd_message.set_token('OBJECT_TYPE', l_object_type);
699: fnd_message.raise_error;
700: ELSE

Line 697: fnd_message.set_token('LEARNER_NAME', l_person_name);

693: ,p_contact_id => p_contact_id);
694:
695: hr_utility.set_location(' Step:'|| l_proc, 10);
696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
697: fnd_message.set_token('LEARNER_NAME', l_person_name);
698: fnd_message.set_token('OBJECT_TYPE', l_object_type);
699: fnd_message.raise_error;
700: ELSE
701: CLOSE csr_lp_enr_id;

Line 698: fnd_message.set_token('OBJECT_TYPE', l_object_type);

694:
695: hr_utility.set_location(' Step:'|| l_proc, 10);
696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
697: fnd_message.set_token('LEARNER_NAME', l_person_name);
698: fnd_message.set_token('OBJECT_TYPE', l_object_type);
699: fnd_message.raise_error;
700: ELSE
701: CLOSE csr_lp_enr_id;
702: END IF;

Line 699: fnd_message.raise_error;

695: hr_utility.set_location(' Step:'|| l_proc, 10);
696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
697: fnd_message.set_token('LEARNER_NAME', l_person_name);
698: fnd_message.set_token('OBJECT_TYPE', l_object_type);
699: fnd_message.raise_error;
700: ELSE
701: CLOSE csr_lp_enr_id;
702: END IF;
703: