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

Line 85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

81: -- Foreign keys
82: --
83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then
84: -- Business Group ID
85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

Line 86: FND_MESSAGE.SET_TOKEN ('STEP', '1');

82: --
83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then
84: -- Business Group ID
85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');

Line 89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

Line 90: FND_MESSAGE.SET_TOKEN ('STEP', '2');

86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');

Line 93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then
96: -- Event
97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

Line 94: FND_MESSAGE.SET_TOKEN ('STEP', '3');

90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then
96: -- Event
97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
98: FND_MESSAGE.SET_TOKEN ('STEP', '4');

Line 97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');

93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then
96: -- Event
97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
98: FND_MESSAGE.SET_TOKEN ('STEP', '4');
99: --
100: -- Primary key
101: --

Line 98: FND_MESSAGE.SET_TOKEN ('STEP', '4');

94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then
96: -- Event
97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
98: FND_MESSAGE.SET_TOKEN ('STEP', '4');
99: --
100: -- Primary key
101: --
102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then

Line 111: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13312_GEN_DATE_ORDER');

107: --
108: -- Check constraints
109: --
110: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_SEQ') then
111: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13312_GEN_DATE_ORDER');
112: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_DISCOUNT_CONTEXT') Then
113: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13242_TBD_DISCOUNT');
114: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_PREPURCH_CONTEXT') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');

Line 113: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13242_TBD_DISCOUNT');

109: --
110: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_SEQ') then
111: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13312_GEN_DATE_ORDER');
112: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_DISCOUNT_CONTEXT') Then
113: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13242_TBD_DISCOUNT');
114: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_PREPURCH_CONTEXT') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');
116: elsif (p_constraint_name = 'OTA_TBD_EXCLUSIVE_CONTEXT') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13231_TBD_EXCLUSIVE');

Line 115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');

111: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13312_GEN_DATE_ORDER');
112: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_DISCOUNT_CONTEXT') Then
113: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13242_TBD_DISCOUNT');
114: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_PREPURCH_CONTEXT') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');
116: elsif (p_constraint_name = 'OTA_TBD_EXCLUSIVE_CONTEXT') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13231_TBD_EXCLUSIVE');
118: elsif (p_constraint_name = 'OTA_TBD_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13243_TBD_TYPE');

Line 117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13231_TBD_EXCLUSIVE');

113: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13242_TBD_DISCOUNT');
114: ElsIf (p_constraint_name = 'OTA_TBD_CHECK_PREPURCH_CONTEXT') Then
115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');
116: elsif (p_constraint_name = 'OTA_TBD_EXCLUSIVE_CONTEXT') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13231_TBD_EXCLUSIVE');
118: elsif (p_constraint_name = 'OTA_TBD_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13243_TBD_TYPE');
120: --
121: -- Other errors (see below).

Line 119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13243_TBD_TYPE');

115: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13241_TBD_PREPURCH');
116: elsif (p_constraint_name = 'OTA_TBD_EXCLUSIVE_CONTEXT') Then
117: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13231_TBD_EXCLUSIVE');
118: elsif (p_constraint_name = 'OTA_TBD_TYPE_CHK') Then
119: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13243_TBD_TYPE');
120: --
121: -- Other errors (see below).
122: --
123: elsif (P_CONSTRAINT_NAME = 'DUPLICATE_NAME') then

Line 124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13468_TBD_NOT_UNIQUE');

120: --
121: -- Other errors (see below).
122: --
123: elsif (P_CONSTRAINT_NAME = 'DUPLICATE_NAME') then
124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13468_TBD_NOT_UNIQUE');
125: elsif (P_CONSTRAINT_NAME = 'INVALID_APPROVER') then
126: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13393_TBD_APPROVER');
127: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_BUS_GROUPS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');

Line 126: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13393_TBD_APPROVER');

122: --
123: elsif (P_CONSTRAINT_NAME = 'DUPLICATE_NAME') then
124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13468_TBD_NOT_UNIQUE');
125: elsif (P_CONSTRAINT_NAME = 'INVALID_APPROVER') then
126: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13393_TBD_APPROVER');
127: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_BUS_GROUPS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');
129: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_TPL') Then
130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');

Line 128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');

124: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13468_TBD_NOT_UNIQUE');
125: elsif (P_CONSTRAINT_NAME = 'INVALID_APPROVER') then
126: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13393_TBD_APPROVER');
127: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_BUS_GROUPS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');
129: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_TPL') Then
130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');
131: elsif (p_constraint_name = 'OTA_TBD_DATES_EVT') Then
132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');

Line 130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');

126: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13393_TBD_APPROVER');
127: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_BUS_GROUPS') then
128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');
129: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_TPL') Then
130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');
131: elsif (p_constraint_name = 'OTA_TBD_DATES_EVT') Then
132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');
133: elsif (p_constraint_name = 'OTA_TBD_DATES_TAV') Then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');

Line 132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');

128: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13244_TBD_BUS_GROUP');
129: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_DATES_TPL') Then
130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');
131: elsif (p_constraint_name = 'OTA_TBD_DATES_EVT') Then
132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');
133: elsif (p_constraint_name = 'OTA_TBD_DATES_TAV') Then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');
135: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_CATEGORY') then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');

Line 134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');

130: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13211_TBD_DATES_TPL');
131: elsif (p_constraint_name = 'OTA_TBD_DATES_EVT') Then
132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');
133: elsif (p_constraint_name = 'OTA_TBD_DATES_TAV') Then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');
135: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_CATEGORY') then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');
137: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_FINANCE_LINES') then
138: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13246_TBD_FINANCE_LINES');

Line 136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');

132: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13212_TBD_DATES_EVT');
133: elsif (p_constraint_name = 'OTA_TBD_DATES_TAV') Then
134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');
135: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_CATEGORY') then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');
137: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_FINANCE_LINES') then
138: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13246_TBD_FINANCE_LINES');
139: elsif (P_CONSTRAINT_NAME = 'NON-TRANSFERABLE BASIS') then
140: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13220_TBD_NON_TRANSFER');

Line 138: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13246_TBD_FINANCE_LINES');

134: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13213_TBD_DATES_TAV');
135: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_CATEGORY') then
136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');
137: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_FINANCE_LINES') then
138: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13246_TBD_FINANCE_LINES');
139: elsif (P_CONSTRAINT_NAME = 'NON-TRANSFERABLE BASIS') then
140: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13220_TBD_NON_TRANSFER');
141: --
142: -- ?

Line 140: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13220_TBD_NON_TRANSFER');

136: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13245_TBD_CATEGORY');
137: elsif (P_CONSTRAINT_NAME = 'OTA_TBD_FINANCE_LINES') then
138: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13246_TBD_FINANCE_LINES');
139: elsif (P_CONSTRAINT_NAME = 'NON-TRANSFERABLE BASIS') then
140: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13220_TBD_NON_TRANSFER');
141: --
142: -- ?
143: --
144: Else

Line 145: FND_MESSAGE.SET_NAME (801, 'HR_6153_ALL_PROCEDURE_FAIL');

141: --
142: -- ?
143: --
144: Else
145: FND_MESSAGE.SET_NAME (801, 'HR_6153_ALL_PROCEDURE_FAIL');
146: FND_MESSAGE.SET_TOKEN ('PROCEDURE', l_proc);
147: FND_MESSAGE.SET_TOKEN ('STEP','35');
148: End If;
149: --

Line 146: FND_MESSAGE.SET_TOKEN ('PROCEDURE', l_proc);

142: -- ?
143: --
144: Else
145: FND_MESSAGE.SET_NAME (801, 'HR_6153_ALL_PROCEDURE_FAIL');
146: FND_MESSAGE.SET_TOKEN ('PROCEDURE', l_proc);
147: FND_MESSAGE.SET_TOKEN ('STEP','35');
148: End If;
149: --
150: FND_MESSAGE.RAISE_ERROR;

Line 147: FND_MESSAGE.SET_TOKEN ('STEP','35');

143: --
144: Else
145: FND_MESSAGE.SET_NAME (801, 'HR_6153_ALL_PROCEDURE_FAIL');
146: FND_MESSAGE.SET_TOKEN ('PROCEDURE', l_proc);
147: FND_MESSAGE.SET_TOKEN ('STEP','35');
148: End If;
149: --
150: FND_MESSAGE.RAISE_ERROR;
151: --

Line 150: FND_MESSAGE.RAISE_ERROR;

146: FND_MESSAGE.SET_TOKEN ('PROCEDURE', l_proc);
147: FND_MESSAGE.SET_TOKEN ('STEP','35');
148: End If;
149: --
150: FND_MESSAGE.RAISE_ERROR;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: --
154: End constraint_error;

Line 367: fnd_message.set_name('OTA','OTA_13596_INVALID_ENROLLMENTS');

363: if l_after <> l_before then
364: --
365: -- Change results in some bookings becoming invalid
366: --
367: fnd_message.set_name('OTA','OTA_13596_INVALID_ENROLLMENTS');
368: fnd_message.raise_error;
369: --
370: end if;
371: --

Line 368: fnd_message.raise_error;

364: --
365: -- Change results in some bookings becoming invalid
366: --
367: fnd_message.set_name('OTA','OTA_13596_INVALID_ENROLLMENTS');
368: fnd_message.raise_error;
369: --
370: end if;
371: --
372: hr_utility.set_location('Leaving:'||l_proc,10);

Line 558: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');

554: HR_UTILITY.SET_LOCATION ('Entering: ' || W_PROCEDURE, 5);
555: --
556: if (P_APPROVED_BY_PERSON_ID is not null) then
557: if not ota_general.check_fnd_user(p_approved_by_person_id) then
558: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');
559: fnd_message.raise_error;
560: end if;
561:
562: end if;

Line 559: fnd_message.raise_error;

555: --
556: if (P_APPROVED_BY_PERSON_ID is not null) then
557: if not ota_general.check_fnd_user(p_approved_by_person_id) then
558: fnd_message.set_name ('OTA', 'OTA_13281_TFH_AUTHORIZER');
559: fnd_message.raise_error;
560: end if;
561:
562: end if;
563: --

Line 803: fnd_message.set_name('OTA','OTA_13496_TBD_PLACES_GT_EVENT');

799: --
800: if p_number_of_places is not null and
801: w_max_attendees is not null and
802: p_number_of_places > w_max_attendees then
803: fnd_message.set_name('OTA','OTA_13496_TBD_PLACES_GT_EVENT');
804: fnd_message.raise_error;
805: end if;
806: --
807: if w_price_basis not in ('C','S') then

Line 804: fnd_message.raise_error;

800: if p_number_of_places is not null and
801: w_max_attendees is not null and
802: p_number_of_places > w_max_attendees then
803: fnd_message.set_name('OTA','OTA_13496_TBD_PLACES_GT_EVENT');
804: fnd_message.raise_error;
805: end if;
806: --
807: if w_price_basis not in ('C','S') then
808: fnd_message.set_name('OTA','OTA_13497_TBD_PRICE_BASIS');

Line 808: fnd_message.set_name('OTA','OTA_13497_TBD_PRICE_BASIS');

804: fnd_message.raise_error;
805: end if;
806: --
807: if w_price_basis not in ('C','S') then
808: fnd_message.set_name('OTA','OTA_13497_TBD_PRICE_BASIS');
809: fnd_message.raise_error;
810: end if;
811: --
812: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);

Line 809: fnd_message.raise_error;

805: end if;
806: --
807: if w_price_basis not in ('C','S') then
808: fnd_message.set_name('OTA','OTA_13497_TBD_PRICE_BASIS');
809: fnd_message.raise_error;
810: end if;
811: --
812: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
813: --