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

Line 64: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

60: -------------
61: begin
62: --
63: if p_evt_id is null then
64: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
65: fnd_message.set_token('FIELD','Event');
66: fnd_message.set_token('OPTIONAL_EXTENSION','');
67: fnd_message.raise_error;
68: end if;

Line 65: fnd_message.set_token('FIELD','Event');

61: begin
62: --
63: if p_evt_id is null then
64: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
65: fnd_message.set_token('FIELD','Event');
66: fnd_message.set_token('OPTIONAL_EXTENSION','');
67: fnd_message.raise_error;
68: end if;
69: --

Line 66: fnd_message.set_token('OPTIONAL_EXTENSION','');

62: --
63: if p_evt_id is null then
64: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
65: fnd_message.set_token('FIELD','Event');
66: fnd_message.set_token('OPTIONAL_EXTENSION','');
67: fnd_message.raise_error;
68: end if;
69: --
70: open csr_evt_type;

Line 67: fnd_message.raise_error;

63: if p_evt_id is null then
64: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
65: fnd_message.set_token('FIELD','Event');
66: fnd_message.set_token('OPTIONAL_EXTENSION','');
67: fnd_message.raise_error;
68: end if;
69: --
70: open csr_evt_type;
71: fetch csr_evt_type into l_evt_type;

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

72: l_parent_exists := csr_evt_type%found;
73: close csr_evt_type;
74: --
75: if not l_parent_exists then
76: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
77: fnd_message.set_token('COLUMN_NAME','Event_id');
78: fnd_message.set_token('TABLE_NAME','OTA_EVENTS');
79: fnd_message.raise_error;
80: end if;

Line 77: fnd_message.set_token('COLUMN_NAME','Event_id');

73: close csr_evt_type;
74: --
75: if not l_parent_exists then
76: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
77: fnd_message.set_token('COLUMN_NAME','Event_id');
78: fnd_message.set_token('TABLE_NAME','OTA_EVENTS');
79: fnd_message.raise_error;
80: end if;
81: --

Line 78: fnd_message.set_token('TABLE_NAME','OTA_EVENTS');

74: --
75: if not l_parent_exists then
76: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
77: fnd_message.set_token('COLUMN_NAME','Event_id');
78: fnd_message.set_token('TABLE_NAME','OTA_EVENTS');
79: fnd_message.raise_error;
80: end if;
81: --
82: if not l_evt_type in ('AD-HOC','SCHEDULED','PROGRAMME') then

Line 79: fnd_message.raise_error;

75: if not l_parent_exists then
76: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
77: fnd_message.set_token('COLUMN_NAME','Event_id');
78: fnd_message.set_token('TABLE_NAME','OTA_EVENTS');
79: fnd_message.raise_error;
80: end if;
81: --
82: if not l_evt_type in ('AD-HOC','SCHEDULED','PROGRAMME') then
83: fnd_message.set_name('OTA','OTA_13288_TEA_WRONG_EVENT_TYPE');

Line 83: fnd_message.set_name('OTA','OTA_13288_TEA_WRONG_EVENT_TYPE');

79: fnd_message.raise_error;
80: end if;
81: --
82: if not l_evt_type in ('AD-HOC','SCHEDULED','PROGRAMME') then
83: fnd_message.set_name('OTA','OTA_13288_TEA_WRONG_EVENT_TYPE');
84: fnd_message.raise_error;
85: end if;
86: --
87: end check_event;

Line 84: fnd_message.raise_error;

80: end if;
81: --
82: if not l_evt_type in ('AD-HOC','SCHEDULED','PROGRAMME') then
83: fnd_message.set_name('OTA','OTA_13288_TEA_WRONG_EVENT_TYPE');
84: fnd_message.raise_error;
85: end if;
86: --
87: end check_event;
88: --==============================================================

Line 104: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');

100: ---------------
101: begin
102: --
103: if p_customer_id is null then
104: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
105: fnd_message.set_token('FIELD','Customer');
106: fnd_message.set_token('OPTIONAL_EXTENSION','');
107: fnd_message.raise_error;
108: end if;

Line 105: fnd_message.set_token('FIELD','Customer');

101: begin
102: --
103: if p_customer_id is null then
104: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
105: fnd_message.set_token('FIELD','Customer');
106: fnd_message.set_token('OPTIONAL_EXTENSION','');
107: fnd_message.raise_error;
108: end if;
109: --

Line 106: fnd_message.set_token('OPTIONAL_EXTENSION','');

102: --
103: if p_customer_id is null then
104: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
105: fnd_message.set_token('FIELD','Customer');
106: fnd_message.set_token('OPTIONAL_EXTENSION','');
107: fnd_message.raise_error;
108: end if;
109: --
110: open csr_customer;

Line 107: fnd_message.raise_error;

103: if p_customer_id is null then
104: fnd_message.set_name('OTA','OTA_13222_GEN_MANDATORY_VALUE');
105: fnd_message.set_token('FIELD','Customer');
106: fnd_message.set_token('OPTIONAL_EXTENSION','');
107: fnd_message.raise_error;
108: end if;
109: --
110: open csr_customer;
111: fetch csr_customer into l_dummy;

Line 116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');

112: l_customer_exists := csr_customer%found;
113: close csr_customer;
114: --
115: if not l_customer_exists then
116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');
118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');
119: fnd_message.raise_error;
120: end if;

Line 117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');

113: close csr_customer;
114: --
115: if not l_customer_exists then
116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');
118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');
119: fnd_message.raise_error;
120: end if;
121: --

Line 118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');

114: --
115: if not l_customer_exists then
116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');
118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');
119: fnd_message.raise_error;
120: end if;
121: --
122: end check_customer;

Line 119: fnd_message.raise_error;

115: if not l_customer_exists then
116: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
117: fnd_message.set_token('COLUMN_NAME','CUST_ACCOUNT_ID');
118: fnd_message.set_token('TABLE_NAME','HZ_CUST_ACCOUNTS');
119: fnd_message.raise_error;
120: end if;
121: --
122: end check_customer;
123: --==============================================================

Line 163: fnd_message.set_name('OTA','OTA_13594_EVT_INT_ASSOCIATION');

159: open c_get_internal_association;
160: fetch c_get_internal_association into l_exists;
161: if c_get_internal_association%found then
162: close c_get_internal_association;
163: fnd_message.set_name('OTA','OTA_13594_EVT_INT_ASSOCIATION');
164: fnd_message.raise_error;
165: end if;
166: close c_get_internal_association;
167: --

Line 164: fnd_message.raise_error;

160: fetch c_get_internal_association into l_exists;
161: if c_get_internal_association%found then
162: close c_get_internal_association;
163: fnd_message.set_name('OTA','OTA_13594_EVT_INT_ASSOCIATION');
164: fnd_message.raise_error;
165: end if;
166: close c_get_internal_association;
167: --
168: open csr_tea;

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

170: l_tea_exists := csr_tea%found;
171: close csr_tea;
172: --
173: if l_tea_exists then
174: fnd_message.set_name('OTA','OTA_13289_TEA_DUPLICATE_ROW');
175: fnd_message.raise_error;
176: end if;
177: --
178: end check_event_and_customer;

Line 175: fnd_message.raise_error;

171: close csr_tea;
172: --
173: if l_tea_exists then
174: fnd_message.set_name('OTA','OTA_13289_TEA_DUPLICATE_ROW');
175: fnd_message.raise_error;
176: end if;
177: --
178: end check_event_and_customer;
179: --==============================================================

Line 264: fnd_message.set_name('OTA','OTA_13595_EVT_CUST_ASSOCIATION');

260: open c_get_customer_association;
261: fetch c_get_customer_association into l_exists;
262: if c_get_customer_association%found then
263: close c_get_customer_association;
264: fnd_message.set_name('OTA','OTA_13595_EVT_CUST_ASSOCIATION');
265: fnd_message.raise_error;
266: end if;
267: close c_get_customer_association;
268: --

Line 265: fnd_message.raise_error;

261: fetch c_get_customer_association into l_exists;
262: if c_get_customer_association%found then
263: close c_get_customer_association;
264: fnd_message.set_name('OTA','OTA_13595_EVT_CUST_ASSOCIATION');
265: fnd_message.raise_error;
266: end if;
267: close c_get_customer_association;
268: --
269:

Line 275: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');

271: open check_org_job_pos_cross;
272: fetch check_org_job_pos_cross into l_exists;
273: if check_org_job_pos_cross%notfound then
274: close check_org_job_pos_cross;
275: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');
276: fnd_message.raise_error;
277: end if;
278: close check_org_job_pos_cross;
279: else

Line 276: fnd_message.raise_error;

272: fetch check_org_job_pos_cross into l_exists;
273: if check_org_job_pos_cross%notfound then
274: close check_org_job_pos_cross;
275: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');
276: fnd_message.raise_error;
277: end if;
278: close check_org_job_pos_cross;
279: else
280: open check_org_job_pos;

Line 284: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');

280: open check_org_job_pos;
281: fetch check_org_job_pos into l_exists;
282: if check_org_job_pos%notfound then
283: close check_org_job_pos;
284: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');
285: fnd_message.raise_error;
286: end if;
287: close check_org_job_pos;
288: end if;

Line 285: fnd_message.raise_error;

281: fetch check_org_job_pos into l_exists;
282: if check_org_job_pos%notfound then
283: close check_org_job_pos;
284: fnd_message.set_name('OTA','OTA_13529_TEA_ORG_JOB_POS');
285: fnd_message.raise_error;
286: end if;
287: close check_org_job_pos;
288: end if;
289: --

Line 294: fnd_message.set_name('OTA','OTA_13530_TEA_DUPLICATE_CRIT');

290: open get_duplicate_tea;
291: fetch get_duplicate_tea into l_exists;
292: if get_duplicate_tea%found then
293: close get_duplicate_tea;
294: fnd_message.set_name('OTA','OTA_13530_TEA_DUPLICATE_CRIT');
295: fnd_message.raise_error;
296: end if;
297: close get_duplicate_tea;
298: --

Line 295: fnd_message.raise_error;

291: fetch get_duplicate_tea into l_exists;
292: if get_duplicate_tea%found then
293: close get_duplicate_tea;
294: fnd_message.set_name('OTA','OTA_13530_TEA_DUPLICATE_CRIT');
295: fnd_message.raise_error;
296: end if;
297: close get_duplicate_tea;
298: --
299: end;

Line 463: fnd_message.set_name('OTA','OTA_13531_TEA_UNRESTRICTED_EVT');

459: --
460: if l_public_event_flag = 'N' then
461: null;
462: else
463: fnd_message.set_name('OTA','OTA_13531_TEA_UNRESTRICTED_EVT');
464: fnd_message.raise_error;
465: end if;
466: end check_public_event_flag;
467: --=======================================================

Line 464: fnd_message.raise_error;

460: if l_public_event_flag = 'N' then
461: null;
462: else
463: fnd_message.set_name('OTA','OTA_13531_TEA_UNRESTRICTED_EVT');
464: fnd_message.raise_error;
465: end if;
466: end check_public_event_flag;
467: --=======================================================
468: --=======================================================

Line 521: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');

517: open get_external_enrollments;
518: fetch get_external_enrollments into l_exists;
519: if get_external_enrollments%notfound then
520: close get_external_enrollments;
521: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');
522: fnd_message.raise_error;
523: end if;
524: close get_external_enrollments;
525: --

Line 522: fnd_message.raise_error;

518: fetch get_external_enrollments into l_exists;
519: if get_external_enrollments%notfound then
520: close get_external_enrollments;
521: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');
522: fnd_message.raise_error;
523: end if;
524: close get_external_enrollments;
525: --
526: elsif p_customer_id is null then

Line 554: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');

550: hr_utility.trace('step 5');
551:
552: if get_associations%notfound then
553: close get_associations;
554: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');
555: fnd_message.raise_error;
556: end if;
557: hr_utility.trace('step 6');
558: close get_associations;

Line 555: fnd_message.raise_error;

551:
552: if get_associations%notfound then
553: close get_associations;
554: fnd_message.set_name('OTA','OTA_13532_TEA_CRITERIA_UNMATCH');
555: fnd_message.raise_error;
556: end if;
557: hr_utility.trace('step 6');
558: close get_associations;
559: end if;

Line 585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');

581: open csr_combination;
582: fetch csr_combination into l_event_id,
583: l_customer_id;
584: if csr_combination%notfound then
585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');
587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');
588: fnd_message.raise_error;
589: end if;

Line 586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');

582: fetch csr_combination into l_event_id,
583: l_customer_id;
584: if csr_combination%notfound then
585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');
587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');
588: fnd_message.raise_error;
589: end if;
590: close csr_combination;

Line 587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');

583: l_customer_id;
584: if csr_combination%notfound then
585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');
587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');
588: fnd_message.raise_error;
589: end if;
590: close csr_combination;
591: --

Line 588: fnd_message.raise_error;

584: if csr_combination%notfound then
585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');
587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');
588: fnd_message.raise_error;
589: end if;
590: close csr_combination;
591: --
592: if l_customer_id is not null then

Line 594: fnd_message.set_name('OTA','OTA_13368_TEA_DEL_TDB_EXIST');

590: close csr_combination;
591: --
592: if l_customer_id is not null then
593: if tea_has_tdb(l_event_id,l_customer_id) then
594: fnd_message.set_name('OTA','OTA_13368_TEA_DEL_TDB_EXIST');
595: fnd_message.raise_error;
596: end if;
597: else
598: check_enrollments(l_event_id,

Line 595: fnd_message.raise_error;

591: --
592: if l_customer_id is not null then
593: if tea_has_tdb(l_event_id,l_customer_id) then
594: fnd_message.set_name('OTA','OTA_13368_TEA_DEL_TDB_EXIST');
595: fnd_message.raise_error;
596: end if;
597: else
598: check_enrollments(l_event_id,
599: p_event_association_id,

Line 670: fnd_message.set_name('OTA','OTA_13413_TEA_PRICE_LIST_ENTRY');

666: --
667: open csr_price;
668: fetch csr_price into l_price;
669: if csr_price%notfound then
670: fnd_message.set_name('OTA','OTA_13413_TEA_PRICE_LIST_ENTRY');
671: fnd_message.raise_error;
672: end if;
673: close csr_price;
674: return l_price;

Line 671: fnd_message.raise_error;

667: open csr_price;
668: fetch csr_price into l_price;
669: if csr_price%notfound then
670: fnd_message.set_name('OTA','OTA_13413_TEA_PRICE_LIST_ENTRY');
671: fnd_message.raise_error;
672: end if;
673: close csr_price;
674: return l_price;
675: -----------

Line 824: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');

820: else
821: /* bug no 3476078 */
822: select price_basis into l_price_basis from ota_events where event_id = p_rec.event_id;
823: if p_rec.customer_id is null and l_price_basis = 'C' then
824: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');
825: fnd_message.raise_error;
826: end if;
827: /* bug no 3476078 */
828: check_event_and_assignment(

Line 825: fnd_message.raise_error;

821: /* bug no 3476078 */
822: select price_basis into l_price_basis from ota_events where event_id = p_rec.event_id;
823: if p_rec.customer_id is null and l_price_basis = 'C' then
824: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');
825: fnd_message.raise_error;
826: end if;
827: /* bug no 3476078 */
828: check_event_and_assignment(
829: p_event_association_id => p_rec.event_association_id

Line 883: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');

879: else
880: /* bug no 3476078 */
881: select price_basis into l_price_basis from ota_events where event_id = p_rec.event_id;
882: if p_rec.customer_id is null and l_price_basis = 'C' then
883: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');
884: fnd_message.raise_error;
885: end if;
886: /* bug no 3476078 */
887:

Line 884: fnd_message.raise_error;

880: /* bug no 3476078 */
881: select price_basis into l_price_basis from ota_events where event_id = p_rec.event_id;
882: if p_rec.customer_id is null and l_price_basis = 'C' then
883: fnd_message.set_name('OTA','OTA_443659_ASG_LRNR_CUST_ERR');
884: fnd_message.raise_error;
885: end if;
886: /* bug no 3476078 */
887:
888: if l_organization_changed