33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
36: If (p_constraint_name = 'OTA_NOTRNG_HISTORIES_PK') Then
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
37: fnd_message.set_name('OTA', 'OTA_13698_NHS_PRIMARY_KEY');
38: fnd_message.raise_error;
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
39: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK1') Then
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
40: fnd_message.set_name('OTA', 'OTA_13699_NHS_FOREIGN_KEY1');
41: fnd_message.raise_error;
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
42: Elsif (p_constraint_name = 'OTA_NOTRNG_HISTORIES_FK2') Then
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
43: fnd_message.set_name('OTA', 'OTA_13303_TAV_NOT_EXISTS');
44: fnd_message.raise_error;
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
51: Else
45: Elsif (p_constraint_name = 'OTA_NTH_CUSTOMER_ID_NOT_NULL') Then
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
47: fnd_message.raise_error;
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT', p_constraint_name);
48: Elsif (p_constraint_name = 'OTA_NTH_ORGANIZATION_NOT_NULL') Then
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT', p_constraint_name);
55: hr_utility.raise_error;
56: End If;
49: fnd_message.set_name('OTA', 'OTA_13883_NHS_CUS_ORG_EXISTS');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT', p_constraint_name);
55: hr_utility.raise_error;
56: End If;
57: --
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT', p_constraint_name);
55: hr_utility.raise_error;
56: End If;
57: --
58: hr_utility.set_location(' Leaving:'||l_proc, 10);