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

Line 48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');

44: --
45: -- Key constraints
46: --
47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then
48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;

Line 49: fnd_message.raise_error;

45: -- Key constraints
46: --
47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then
48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then

Line 51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');

47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then
48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;

Line 52: fnd_message.raise_error;

48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then

Line 54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');

50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;

Line 55: fnd_message.raise_error;

51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then

Line 57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');

53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;

Line 58: fnd_message.raise_error;

54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */

Line 60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');

56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');

Line 61: fnd_message.raise_error;

57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;

Line 64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');

60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 65: fnd_message.raise_error;

61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);

Line 73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');

69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then
76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');
77: fnd_message.raise_error;

Line 74: fnd_message.raise_error;

70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then
76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');
77: fnd_message.raise_error;
78: --

Line 76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');

72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then
76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');
77: fnd_message.raise_error;
78: --
79: -- Check constraints
80: --

Line 77: fnd_message.raise_error;

73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then
76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');
77: fnd_message.raise_error;
78: --
79: -- Check constraints
80: --
81: ElsIf (p_constraint_name = 'OTA_EVT_ACTIVITY_BASED') Then

Line 82: fnd_message.set_name('OTA','OTA_13434_EVT_ACTIVITY_BASED');

78: --
79: -- Check constraints
80: --
81: ElsIf (p_constraint_name = 'OTA_EVT_ACTIVITY_BASED') Then
82: fnd_message.set_name('OTA','OTA_13434_EVT_ACTIVITY_BASED');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_EVT_ATTENDANCE') Then
85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;

Line 83: fnd_message.raise_error;

79: -- Check constraints
80: --
81: ElsIf (p_constraint_name = 'OTA_EVT_ACTIVITY_BASED') Then
82: fnd_message.set_name('OTA','OTA_13434_EVT_ACTIVITY_BASED');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_EVT_ATTENDANCE') Then
85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then

Line 85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');

81: ElsIf (p_constraint_name = 'OTA_EVT_ACTIVITY_BASED') Then
82: fnd_message.set_name('OTA','OTA_13434_EVT_ACTIVITY_BASED');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_EVT_ATTENDANCE') Then
85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then
88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;

Line 86: fnd_message.raise_error;

82: fnd_message.set_name('OTA','OTA_13434_EVT_ACTIVITY_BASED');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_EVT_ATTENDANCE') Then
85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then
88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;
90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then

Line 88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');

84: ElsIf (p_constraint_name = 'OTA_EVT_ATTENDANCE') Then
85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then
88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;
90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then
91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;

Line 89: fnd_message.raise_error;

85: fnd_message.set_name('OTA','OTA_13435_EVT_ATTENDEES');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then
88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;
90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then
91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then

Line 91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');

87: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NOT_NULL') Then
88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;
90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then
91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then
94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;

Line 92: fnd_message.raise_error;

88: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
89: fnd_message.raise_error;
90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then
91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then
94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then

Line 94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');

90: ElsIf (p_constraint_name = 'OTA_EVT_CATEGORY_NULL') Then
91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then
94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then
97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;

Line 95: fnd_message.raise_error;

91: fnd_message.set_name('OTA','OTA_13437_EVT_CATEGORY_NULL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then
94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then
97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;
99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then

Line 97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');

93: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_END_DATE') Then
94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then
97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;
99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then
100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;

Line 98: fnd_message.raise_error;

94: fnd_message.set_name('OTA','OTA_13438_EVT_COURSE_END_DATE');
95: fnd_message.raise_error;
96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then
97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;
99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then
100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then

Line 100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');

96: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_START_END_ORDER') Then
97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;
99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then
100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then
103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;

Line 101: fnd_message.raise_error;

97: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
98: fnd_message.raise_error;
99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then
100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then
103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then

Line 103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');

99: ElsIf (p_constraint_name = 'OTA_EVT_COURSE_TIMES_ORDER') Then
100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then
103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then
106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;

Line 104: fnd_message.raise_error;

100: fnd_message.set_name('OTA','OTA_13439_EVT_COURSE_DATES');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then
103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then
106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then

Line 106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');

102: ElsIf (p_constraint_name = 'OTA_EVT_CURRENCY') Then
103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then
106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then
109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;

Line 107: fnd_message.raise_error;

103: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
104: fnd_message.raise_error;
105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then
106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then
109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then

Line 109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');

105: ElsIf (p_constraint_name = 'OTA_EVT_DEVELOPMENT_TYPE') Then
106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then
109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then
112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;

Line 110: fnd_message.raise_error;

106: fnd_message.set_name('OTA','OTA_13441_EVT_DEV_TYPE');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then
109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then
112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;
114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then

Line 112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');

108: ElsIf (p_constraint_name = 'OTA_EVT_DURATION') Then
109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then
112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;
114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then
115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;

Line 113: fnd_message.raise_error;

109: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then
112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;
114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then
115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_EVT_END_TIME_FORMAT') Then

Line 115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');

111: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_AND_UNITS') Then
112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;
114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then
115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_EVT_END_TIME_FORMAT') Then
118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
119: fnd_message.raise_error;

Line 116: fnd_message.raise_error;

112: fnd_message.set_name('OTA','OTA_13442_EVT_DURATION');
113: fnd_message.raise_error;
114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then
115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_EVT_END_TIME_FORMAT') Then
118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
119: fnd_message.raise_error;
120: --Added for Bug 3405804

Line 118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');

114: ElsIf (p_constraint_name = 'OTA_EVT_DURATION_MORE_THAN_0') Then
115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_EVT_END_TIME_FORMAT') Then
118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
119: fnd_message.raise_error;
120: --Added for Bug 3405804
121: ElsIf (p_constraint_name = 'OTA_EVT_SESSION_TIMING') Then
122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');

Line 119: fnd_message.raise_error;

115: fnd_message.set_name('OTA','OTA_13443_EVT_DURATION_NOT_0');
116: fnd_message.raise_error;
117: ElsIf (p_constraint_name = 'OTA_EVT_END_TIME_FORMAT') Then
118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
119: fnd_message.raise_error;
120: --Added for Bug 3405804
121: ElsIf (p_constraint_name = 'OTA_EVT_SESSION_TIMING') Then
122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');
123: fnd_message.raise_error;

Line 122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');

118: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
119: fnd_message.raise_error;
120: --Added for Bug 3405804
121: ElsIf (p_constraint_name = 'OTA_EVT_SESSION_TIMING') Then
122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');
123: fnd_message.raise_error;
124: -- Added for Bug 3405804
125: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NOT_NULL') Then
126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');

Line 123: fnd_message.raise_error;

119: fnd_message.raise_error;
120: --Added for Bug 3405804
121: ElsIf (p_constraint_name = 'OTA_EVT_SESSION_TIMING') Then
122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');
123: fnd_message.raise_error;
124: -- Added for Bug 3405804
125: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NOT_NULL') Then
126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');
127: fnd_message.raise_error;

Line 126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');

122: fnd_message.set_name('OTA','OTA_13226_EVT_SESSION_TIMING');
123: fnd_message.raise_error;
124: -- Added for Bug 3405804
125: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NOT_NULL') Then
126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');
127: fnd_message.raise_error;
128: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NULL') Then
129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;

Line 127: fnd_message.raise_error;

123: fnd_message.raise_error;
124: -- Added for Bug 3405804
125: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NOT_NULL') Then
126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');
127: fnd_message.raise_error;
128: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NULL') Then
129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;
131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then

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

125: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NOT_NULL') Then
126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');
127: fnd_message.raise_error;
128: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NULL') Then
129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;
131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then
132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;

Line 130: fnd_message.raise_error;

126: fnd_message.set_name('OTA','OTA_13445_EVT_ENROL_DATES');
127: fnd_message.raise_error;
128: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NULL') Then
129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;
131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then
132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;
134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then

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

128: ElsIf (p_constraint_name = 'OTA_EVT_ENROLMENT_NULL') Then
129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;
131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then
132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;
134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then
135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;

Line 133: fnd_message.raise_error;

129: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
130: fnd_message.raise_error;
131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then
132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;
134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then
135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;
137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then

Line 135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');

131: ElsIf (p_constraint_name = 'OTA_EVT_ENROL_START_END_ORDER') Then
132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;
134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then
135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;
137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then
138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;

Line 136: fnd_message.raise_error;

132: fnd_message.set_name('OTA', 'OTA_13445_EVT_ENROL_DATES');
133: fnd_message.raise_error;
134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then
135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;
137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then
138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;
140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then

Line 138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');

134: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_STATUS_CHK') Then
135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;
137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then
138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;
140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then
141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;

Line 139: fnd_message.raise_error;

135: fnd_message.set_name('OTA', 'OTA_13446_EVT_INVALID_STATUS');
136: fnd_message.raise_error;
137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then
138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;
140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then
141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;
143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then

Line 141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');

137: ElsIf (p_constraint_name = 'OTA_EVT_EVENT_TYPE_CHK') Then
138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;
140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then
141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;
143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then
144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;

Line 142: fnd_message.raise_error;

138: fnd_message.set_name('OTA', 'OTA_13447_EVT_INVALID_TYPE');
139: fnd_message.raise_error;
140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then
141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;
143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then
144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;
146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then

Line 144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');

140: ElsIf (p_constraint_name = 'OTA_EVT_LANGUAGE') Then
141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;
143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then
144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;
146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then
147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;

Line 145: fnd_message.raise_error;

141: fnd_message.set_name('OTA', 'OTA_13448_EVT_INVALID_LANGUAGE');
142: fnd_message.raise_error;
143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then
144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;
146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then
147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;
149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then

Line 147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');

143: ElsIf (p_constraint_name = 'OTA_EVT_MAX_ATTENDEES_POSITIVE') Then
144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;
146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then
147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;
149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then
150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;

Line 148: fnd_message.raise_error;

144: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
145: fnd_message.raise_error;
146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then
147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;
149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then
150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;
152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then

Line 150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');

146: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNALS_POSITIVE') Then
147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;
149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then
150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;
152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then
153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;

Line 151: fnd_message.raise_error;

147: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
148: fnd_message.raise_error;
149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then
150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;
152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then
153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;
155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then

Line 153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');

149: ElsIf (p_constraint_name = 'OTA_EVT_MAX_INTERNAL_MAX_ORDER') Then
150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;
152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then
153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;
155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then
156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;

Line 154: fnd_message.raise_error;

150: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
151: fnd_message.raise_error;
152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then
153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;
155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then
156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;
158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then

Line 156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');

152: ElsIf (p_constraint_name = 'OTA_EVT_MIN_ATTENDEES_POSITIVE') Then
153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;
155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then
156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;
158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then
159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;

Line 157: fnd_message.raise_error;

153: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
154: fnd_message.raise_error;
155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then
156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;
158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then
159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;
161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then

Line 159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');

155: ElsIf (p_constraint_name = 'OTA_EVT_MIN_MAX_ORDER') Then
156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;
158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then
159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;
161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then
162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;

Line 160: fnd_message.raise_error;

156: fnd_message.set_name('OTA', 'OTA_13449_EVT_ATTENDEES_POS');
157: fnd_message.raise_error;
158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then
159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;
161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then
162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;
164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then

Line 162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');

158: ElsIf (p_constraint_name = 'OTA_EVT_NORMAL_STATUS_DATES') Then
159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;
161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then
162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;
164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then
165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;

Line 163: fnd_message.raise_error;

159: fnd_message.set_name('OTA', 'OTA_13218_EVT_NORMAL_STATUS');
160: fnd_message.raise_error;
161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then
162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;
164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then
165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;
167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then

Line 165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');

161: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NOT_NULL') Then
162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;
164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then
165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;
167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then
168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;

Line 166: fnd_message.raise_error;

162: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
163: fnd_message.raise_error;
164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then
165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;
167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then
168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;
170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then

Line 168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');

164: ElsIf (p_constraint_name = 'OTA_EVT_PARENT_NULL') Then
165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;
167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then
168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;
170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then
171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;

Line 169: fnd_message.raise_error;

165: fnd_message.set_name('OTA', 'OTA_13450_EVT_PARENT');
166: fnd_message.raise_error;
167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then
168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;
170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then
171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;
173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then

Line 171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');

167: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_APPLICABLE') Then
168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;
170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then
171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;
173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then
174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;

Line 172: fnd_message.raise_error;

168: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
169: fnd_message.raise_error;
170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then
171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;
173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then
174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;
176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then

Line 174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');

170: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS') Then
171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;
173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then
174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;
176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then
177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;

Line 175: fnd_message.raise_error;

171: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
172: fnd_message.raise_error;
173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then
174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;
176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then
177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;
179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then

Line 177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');

173: ElsIf (p_constraint_name = 'OTA_EVT_PRICE_BASIS_CHK') Then
174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;
176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then
177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;
179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then
180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;

Line 178: fnd_message.raise_error;

174: fnd_message.set_name('OTA', 'OTA_13451_EVT_INVALID_PB');
175: fnd_message.raise_error;
176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then
177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;
179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then
180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;
182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then

Line 180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');

176: ElsIf (p_constraint_name = 'OTA_EVT_PRICING_NULL') Then
177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;
179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then
180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;
182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then
183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;

Line 181: fnd_message.raise_error;

177: fnd_message.set_name('OTA', 'OTA_13440_EVT_CURR_PB');
178: fnd_message.raise_error;
179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then
180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;
182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then
183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;
185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then

Line 183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');

179: ElsIf (p_constraint_name = 'OTA_EVT_START_TIME_FORMAT') Then
180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;
182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then
183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;
185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then
186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;

Line 184: fnd_message.raise_error;

180: fnd_message.set_name('OTA','OTA_13444_EVT_TIME_FORMAT');
181: fnd_message.raise_error;
182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then
183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;
185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then
186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then

Line 186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');

182: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NOT_NULL') Then
183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;
185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then
186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;

Line 187: fnd_message.raise_error;

183: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
184: fnd_message.raise_error;
185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then
186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then

Line 189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');

185: ElsIf (p_constraint_name = 'OTA_EVT_STATUS_NULL') Then
186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then
192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');
193: fnd_message.raise_error;

Line 190: fnd_message.raise_error;

186: fnd_message.set_name('OTA','OTA_13452_EVT_STATUS');
187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then
192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');
193: fnd_message.raise_error;
194: --

Line 192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');

188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then
192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');
193: fnd_message.raise_error;
194: --
195: -- ?
196: --

Line 193: fnd_message.raise_error;

189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then
192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');
193: fnd_message.raise_error;
194: --
195: -- ?
196: --
197: Else

Line 198: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');

194: --
195: -- ?
196: --
197: Else
198: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
199: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
201: hr_utility.raise_error;
202: End If;

Line 199: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);

195: -- ?
196: --
197: Else
198: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
199: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
201: hr_utility.raise_error;
202: End If;
203: --

Line 200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);

196: --
197: Else
198: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13259_GEN_UNKN_CONSTRAINT');
199: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
200: FND_MESSAGE.SET_TOKEN ('CONSTRAINT', P_CONSTRAINT_NAME);
201: hr_utility.raise_error;
202: End If;
203: --
204: hr_utility.set_location (' Leaving:' || W_PROC, 10);

Line 835: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');

831: P_COURSE_END_DATE := G_FETCHED_REC.COURSE_END_DATE;
832: --
833: else
834: --
835: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
836: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
837: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', 'P_EVENT_ID does not identify a valid event');
838: FND_MESSAGE.RAISE_ERROR;
839: --

Line 836: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);

832: --
833: else
834: --
835: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
836: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
837: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', 'P_EVENT_ID does not identify a valid event');
838: FND_MESSAGE.RAISE_ERROR;
839: --
840: end if;

Line 837: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', 'P_EVENT_ID does not identify a valid event');

833: else
834: --
835: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
836: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
837: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', 'P_EVENT_ID does not identify a valid event');
838: FND_MESSAGE.RAISE_ERROR;
839: --
840: end if;
841: --

Line 838: FND_MESSAGE.RAISE_ERROR;

834: --
835: FND_MESSAGE.SET_NAME (810, 'OTA_13205_GEN_PARAMETERS');
836: FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
837: FND_MESSAGE.SET_TOKEN ('SPECIFIC_MESSAGE', 'P_EVENT_ID does not identify a valid event');
838: FND_MESSAGE.RAISE_ERROR;
839: --
840: end if;
841: --
842: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);