33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then
72: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE', l_proc);
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then
72: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE', l_proc);
74: hr_utility.set_message_token('STEP','5');
73: hr_utility.set_message_token('PROCEDURE', l_proc);
74: hr_utility.set_message_token('STEP','5');
75: hr_utility.raise_error;
76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
74: hr_utility.set_message_token('STEP','5');
75: hr_utility.raise_error;
76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: End constraint_error;