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.XLE_ASSOC_VALIDATIONS_PVT dependencies on FND_MESSAGE

Line 25: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');

21: IS
22: BEGIN
23:
24: IF (p_param_value IS NULL OR p_param_value = FND_API.G_MISS_CHAR) THEN
25: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');
26: FND_MSG_PUB.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28: END IF;
29: EXCEPTION

Line 65: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');

61: OPEN Context_Cursor;
62: FETCH Context_Cursor INTO l_association_type_id;
63:
64: IF (Context_Cursor%NOTFOUND) THEN
65: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
66: FND_MESSAGE.SET_TOKEN ('PARAM', 'Context');
67: FND_MSG_PUB.ADD;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;

Line 66: FND_MESSAGE.SET_TOKEN ('PARAM', 'Context');

62: FETCH Context_Cursor INTO l_association_type_id;
63:
64: IF (Context_Cursor%NOTFOUND) THEN
65: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
66: FND_MESSAGE.SET_TOKEN ('PARAM', 'Context');
67: FND_MSG_PUB.ADD;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70: CLOSE Context_Cursor;

Line 123: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');

119: OPEN OBJECT_Type_Cursor;
120: FETCH OBJECT_Type_Cursor INTO l_OBJECT_type_rec;
121:
122: IF (OBJECT_Type_Cursor%NOTFOUND) THEN
123: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
124: FND_MESSAGE.SET_TOKEN ('PARAM', p_param1_name);
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;

Line 124: FND_MESSAGE.SET_TOKEN ('PARAM', p_param1_name);

120: FETCH OBJECT_Type_Cursor INTO l_OBJECT_type_rec;
121:
122: IF (OBJECT_Type_Cursor%NOTFOUND) THEN
123: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
124: FND_MESSAGE.SET_TOKEN ('PARAM', p_param1_name);
125: FND_MSG_PUB.ADD;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: CLOSE OBJECT_Type_Cursor;

Line 145: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');

141:
142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:
144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
145: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;

Line 146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);

142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:
144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
145: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 193: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');

189: WHERE ASSOCIATION_ID = p_association_id;
190:
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
194: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: WHEN OTHERS THEN

Line 194: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');

190:
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
194: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: WHEN OTHERS THEN
198: -- dbms_output.put_line('-- SQLCODE : ' || SQLCODE || ' ' || SQLERRM);

Line 240: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');

236: AND OBJECT_TYPE_ID = p_object_type;
237:
238: EXCEPTION
239: WHEN NO_DATA_FOUND THEN
240: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: WHEN OTHERS THEN
244: RAISE;

Line 288: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');

284: AND OT.NAME = upper (P_OBJECT_TYPE);
285:
286: EXCEPTION
287: WHEN NO_DATA_FOUND THEN
288: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');
289: FND_MSG_PUB.ADD;
290: RAISE FND_API.G_EXC_ERROR;
291: WHEN OTHERS THEN
292: RAISE;

Line 356: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');

352: OPEN Association_Type_Cursor;
353: FETCH Association_Type_Cursor INTO l_association_type_rec;
354:
355: IF (Association_Type_Cursor%NOTFOUND) THEN
356: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');
357: FND_MSG_PUB.ADD;
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360: CLOSE Association_Type_Cursor;

Line 368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');

364: FETCH Association_Subject_Cursor INTO l_association_subject_rec;
365:
366: IF (Association_Subject_Cursor%FOUND) THEN
367: IF (l_association_subject_rec.object_id <> p_object_id) THEN
368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);
370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);
371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);
372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);

Line 369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);

365:
366: IF (Association_Subject_Cursor%FOUND) THEN
367: IF (l_association_subject_rec.object_id <> p_object_id) THEN
368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);
370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);
371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);
372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);
373: FND_MSG_PUB.ADD;

Line 370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);

366: IF (Association_Subject_Cursor%FOUND) THEN
367: IF (l_association_subject_rec.object_id <> p_object_id) THEN
368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);
370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);
371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);
372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);
373: FND_MSG_PUB.ADD;
374: RAISE FND_API.G_EXC_ERROR;

Line 371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);

367: IF (l_association_subject_rec.object_id <> p_object_id) THEN
368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);
370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);
371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);
372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);
373: FND_MSG_PUB.ADD;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;

Line 372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);

368: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
369: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_subject_id);
370: FND_MESSAGE.SET_TOKEN ('TYPE1', p_subject_type);
371: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_subject_rec.object_id);
372: FND_MESSAGE.SET_TOKEN ('TYPE2', p_object_type);
373: FND_MSG_PUB.ADD;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376: END IF;

Line 386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');

382: FETCH Association_Object_Cursor INTO l_association_object_rec;
383:
384: IF (Association_Object_Cursor%FOUND) THEN
385: IF (l_association_object_rec.subject_id <> p_subject_id) THEN
386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);
388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);
389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);
390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);

Line 387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);

383:
384: IF (Association_Object_Cursor%FOUND) THEN
385: IF (l_association_object_rec.subject_id <> p_subject_id) THEN
386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);
388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);
389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);
390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);
391: FND_MSG_PUB.ADD;

Line 388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);

384: IF (Association_Object_Cursor%FOUND) THEN
385: IF (l_association_object_rec.subject_id <> p_subject_id) THEN
386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);
388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);
389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);
390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;

Line 389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);

385: IF (l_association_object_rec.subject_id <> p_subject_id) THEN
386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);
388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);
389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);
390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;

Line 390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);

386: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_CARDINALITY');
387: FND_MESSAGE.SET_TOKEN ('TYPE1', p_object_type);
388: FND_MESSAGE.SET_TOKEN ('OBJECT1' , p_object_id);
389: FND_MESSAGE.SET_TOKEN ('TYPE2', p_subject_type);
390: FND_MESSAGE.SET_TOKEN ('OBJECT2' , l_association_object_rec.subject_id);
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394: END IF;

Line 432: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');

428: WHERE ASSOCIATION_ID = p_association_id;
429:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
432: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
433: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');
434: FND_MSG_PUB.ADD;
435: RAISE FND_API.G_EXC_ERROR;
436: WHEN OTHERS THEN

Line 433: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');

429:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
432: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
433: FND_MESSAGE.SET_TOKEN ('PARAM', 'Association Id');
434: FND_MSG_PUB.ADD;
435: RAISE FND_API.G_EXC_ERROR;
436: WHEN OTHERS THEN
437: RAISE;

Line 519: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');

515: OPEN Association_Type_Cursor;
516: FETCH Association_Type_Cursor INTO l_association_type_rec;
517:
518: IF (Association_Type_Cursor%NOTFOUND) THEN
519: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION_TYPE');
520: FND_MSG_PUB.ADD;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: CLOSE Association_Type_Cursor;

Line 527: FND_MESSAGE.SET_NAME ('XLE', 'XLE_EFF_FROM_TO_DATE_ERR');

523: CLOSE Association_Type_Cursor;
524:
525: -- Validates the Association Effective From Date is not posterior to the Effective To Date
526: IF (trunc(p_effective_from) > NVL(p_effective_to, p_effective_from)) THEN
527: FND_MESSAGE.SET_NAME ('XLE', 'XLE_EFF_FROM_TO_DATE_ERR');
528: FND_MSG_PUB.ADD;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:

Line 536: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_EFF_DATE');

532: -- Validates the Association Effective Dates are between the Association Types Effective Dates
533: IF (trunc(p_effective_from) NOT BETWEEN trunc(l_association_type_rec.effective_from) AND NVL(l_association_type_rec.effective_to, trunc(p_effective_from))) OR
534: (p_effective_to IS NOT NULL AND
535: p_effective_to NOT BETWEEN trunc(l_association_type_rec.effective_from) AND NVL(l_association_type_rec.effective_to, p_effective_to)) THEN
536: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_EFF_DATE');
537: FND_MSG_PUB.ADD;
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540:

Line 608: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_EXISTS_WARN');

604:
605: FOR l_association_rec IN Association_Cursor
606: LOOP
607: IF (p_association_id IS NULL AND l_association_rec.effective_to IS NULL) THEN
608: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_EXISTS_WARN');
609: FND_MSG_PUB.ADD;
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:

Line 616: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_OVERLAP_DATES');

612:
613: IF (p_association_id IS NULL) OR (p_association_id IS NOT NULL AND l_association_rec.association_id <> p_association_id) THEN
614: IF (is_date_overlap (l_effective_from, l_effective_to,
615: l_association_rec.effective_from, l_association_rec.effective_to)) THEN
616: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_OVERLAP_DATES');
617: FND_MSG_PUB.ADD;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;

Line 768: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION');

764: AND effective_to IS NULL;
765:
766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN
768: FND_MESSAGE.SET_NAME ('XLE', 'XLE_NO_ASSOCIATION');
769: FND_MSG_PUB.ADD;
770: RAISE FND_API.G_EXC_ERROR;
771: WHEN OTHERS THEN
772: RAISE;

Line 812: FND_MESSAGE.SET_TOKEN('NAME', le2_name);

808: WHERE le1.legal_entity_id = p_subject_id
809: AND le2.legal_entity_id = p_object_id;
810:
811: IF (le1_transacting <> 'Y' AND le2_transacting <> 'Y') THEN
812: FND_MESSAGE.SET_TOKEN('NAME', le2_name);
813: FND_MESSAGE.SET_NAME('XLE', 'XLE_REL_IC_ENABLED_WARN');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;

Line 813: FND_MESSAGE.SET_NAME('XLE', 'XLE_REL_IC_ENABLED_WARN');

809: AND le2.legal_entity_id = p_object_id;
810:
811: IF (le1_transacting <> 'Y' AND le2_transacting <> 'Y') THEN
812: FND_MESSAGE.SET_TOKEN('NAME', le2_name);
813: FND_MESSAGE.SET_NAME('XLE', 'XLE_REL_IC_ENABLED_WARN');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817:

Line 1036: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');

1032:
1033: -- **** Check Effective From Date is not set to NULL
1034:
1035: IF (p_effective_from = FND_API.G_MISS_DATE) THEN
1036: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');
1037: FND_MSG_PUB.ADD;
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040:

Line 1045: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');

1041: -- **** Check that at least one new Effective Date (From or To) is provided or Developer Flexfields
1042:
1043: IF (p_effective_from IS NULL) AND (p_effective_to = FND_API.G_MISS_DATE OR p_effective_to IS NULL) AND
1044: (p_assoc_information_context IS NULL) THEN
1045: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_MISSING_PARAM');
1046: FND_MSG_PUB.ADD;
1047: RAISE FND_API.G_EXC_ERROR;
1048: END IF;
1049: