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

Line 26: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

22: BEGIN
23: -- Verify that instance id is passed
24: IF p_instance_id IS NULL THEN
25: IF ( p_stack_err_msg = TRUE ) THEN
26: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
27: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
28: FND_MSG_PUB.Add;
29: END IF;
30: RETURN FALSE;

Line 27: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);

23: -- Verify that instance id is passed
24: IF p_instance_id IS NULL THEN
25: IF ( p_stack_err_msg = TRUE ) THEN
26: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
27: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
28: FND_MSG_PUB.Add;
29: END IF;
30: RETURN FALSE;
31: ELSE

Line 46: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF p_event = 'INSERT' THEN
45: IF ( p_stack_err_msg = TRUE ) THEN
46: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
47: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
48: FND_MSG_PUB.Add;
49: END IF;
50: RETURN FALSE;

Line 47: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);

43: WHEN NO_DATA_FOUND THEN
44: IF p_event = 'INSERT' THEN
45: IF ( p_stack_err_msg = TRUE ) THEN
46: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
47: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
48: FND_MSG_PUB.Add;
49: END IF;
50: RETURN FALSE;
51: ELSIF p_event = 'UPDATE' THEN

Line 53: FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_EXT_INST_ID');

49: END IF;
50: RETURN FALSE;
51: ELSIF p_event = 'UPDATE' THEN
52: IF ( p_stack_err_msg = TRUE ) THEN
53: FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_EXT_INST_ID');
54: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
55: FND_MSG_PUB.Add;
56: END IF;
57: RETURN FALSE;

Line 54: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);

50: RETURN FALSE;
51: ELSIF p_event = 'UPDATE' THEN
52: IF ( p_stack_err_msg = TRUE ) THEN
53: FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_EXT_INST_ID');
54: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
55: FND_MSG_PUB.Add;
56: END IF;
57: RETURN FALSE;
58: END IF;

Line 86: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');

82: IF (p_instance_id_old = p_instance_id_new) THEN
83: RETURN TRUE;
84: ELSE
85: IF ( p_stack_err_msg = TRUE ) THEN
86: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');
87: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
88: FND_MSG_PUB.Add;
89: END IF;
90: RETURN FALSE;

Line 87: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);

83: RETURN TRUE;
84: ELSE
85: IF ( p_stack_err_msg = TRUE ) THEN
86: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');
87: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
88: FND_MSG_PUB.Add;
89: END IF;
90: RETURN FALSE;
91: END IF;

Line 96: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');

92:
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF ( p_stack_err_msg = TRUE ) THEN
96: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');
97: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
98: FND_MSG_PUB.Add;
99: END IF;
100: RETURN FALSE;

Line 97: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);

93: EXCEPTION
94: WHEN OTHERS THEN
95: IF ( p_stack_err_msg = TRUE ) THEN
96: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');
97: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
98: FND_MSG_PUB.Add;
99: END IF;
100: RETURN FALSE;
101: END Val_inst_id_for_update;

Line 126: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');

122: BEGIN
123: -- Verify that attribute id is passed
124: IF p_attribute_id IS NULL THEN
125: IF ( p_stack_err_msg = TRUE ) THEN
126: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);
128: FND_MSG_PUB.Add;
129: END IF;
130: RETURN FALSE;

Line 127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);

123: -- Verify that attribute id is passed
124: IF p_attribute_id IS NULL THEN
125: IF ( p_stack_err_msg = TRUE ) THEN
126: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);
128: FND_MSG_PUB.Add;
129: END IF;
130: RETURN FALSE;
131: ELSE

Line 149: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');

145: RETURN TRUE;
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: IF ( p_stack_err_msg = TRUE ) THEN
149: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);
151: FND_MSG_PUB.Add;
152: END IF;
153: RETURN FALSE;

Line 150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);

146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: IF ( p_stack_err_msg = TRUE ) THEN
149: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIBUTE_ID');
150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_ID',p_attribute_id);
151: FND_MSG_PUB.Add;
152: END IF;
153: RETURN FALSE;
154: END;

Line 178: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');

174: BEGIN
175: -- Verify that attribute id is passed
176: IF p_att_value_id IS NULL THEN
177: IF ( p_stack_err_msg = TRUE ) THEN
178: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);
180: FND_MSG_PUB.Add;
181: END IF;
182: RETURN FALSE;

Line 179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);

175: -- Verify that attribute id is passed
176: IF p_att_value_id IS NULL THEN
177: IF ( p_stack_err_msg = TRUE ) THEN
178: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);
180: FND_MSG_PUB.Add;
181: END IF;
182: RETURN FALSE;
183: ELSE

Line 237: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');

233: RETURN TRUE;
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: IF ( p_stack_err_msg = TRUE ) THEN
237: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);
239: FND_MSG_PUB.Add;
240: END IF;
241: RETURN FALSE;

Line 238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);

234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: IF ( p_stack_err_msg = TRUE ) THEN
237: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_att_value_id);
239: FND_MSG_PUB.Add;
240: END IF;
241: RETURN FALSE;
242: END;

Line 310: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');

306: BEGIN
307: IF p_old_date < SYSDATE THEN
308: IF p_new_date = FND_API.G_MISS_DATE THEN
309: IF ( p_stack_err_msg = TRUE ) THEN
310: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
311: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;

Line 311: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);

307: IF p_old_date < SYSDATE THEN
308: IF p_new_date = FND_API.G_MISS_DATE THEN
309: IF ( p_stack_err_msg = TRUE ) THEN
310: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
311: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: RETURN FALSE;

Line 351: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');

347: WHERE instance_id = p_instance_id
348: AND attribute_id = p_attribute_id;
349:
350: IF ( p_stack_err_msg = TRUE ) THEN
351: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');
352: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_attribute_id);
353: FND_MSG_PUB.Add;
354: END IF;
355: RETURN FALSE;

Line 352: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_attribute_id);

348: AND attribute_id = p_attribute_id;
349:
350: IF ( p_stack_err_msg = TRUE ) THEN
351: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');
352: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_attribute_id);
353: FND_MSG_PUB.Add;
354: END IF;
355: RETURN FALSE;
356:

Line 400: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');

396: (p_end_date <> FND_API.G_MISS_DATE)
397: AND
398: (p_start_date > p_end_date)) THEN
399: l_return_value := FALSE;
400: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
401: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
402: FND_MSG_PUB.Add;
403: RETURN l_return_value;
404: END IF;

Line 401: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

397: AND
398: (p_start_date > p_end_date)) THEN
399: l_return_value := FALSE;
400: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
401: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
402: FND_MSG_PUB.Add;
403: RETURN l_return_value;
404: END IF;
405:

Line 411: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');

407: FETCH c1 INTO l_date_rec;
408: IF c1%NOTFOUND THEN
409: l_return_value := FALSE;
410: IF ( p_stack_err_msg = TRUE ) THEN
411: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
412: FND_MESSAGE.SET_TOKEN('ENTITY','EXTENDED ATTRIBUTES');
413: FND_MSG_PUB.Add;
414: END IF;
415: END IF;

Line 412: FND_MESSAGE.SET_TOKEN('ENTITY','EXTENDED ATTRIBUTES');

408: IF c1%NOTFOUND THEN
409: l_return_value := FALSE;
410: IF ( p_stack_err_msg = TRUE ) THEN
411: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
412: FND_MESSAGE.SET_TOKEN('ENTITY','EXTENDED ATTRIBUTES');
413: FND_MSG_PUB.Add;
414: END IF;
415: END IF;
416:

Line 425: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');

421: (p_start_date > SYSDATE)
422: THEN
423: l_return_value := FALSE;
424: IF ( p_stack_err_msg = TRUE ) THEN
425: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
426: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
427: FND_MSG_PUB.Add;
428: END IF;
429: END IF;

Line 426: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

422: THEN
423: l_return_value := FALSE;
424: IF ( p_stack_err_msg = TRUE ) THEN
425: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
426: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
427: FND_MSG_PUB.Add;
428: END IF;
429: END IF;
430: CLOSE c1;

Line 470: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');

466: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN
467:
468: IF p_end_date < SYSDATE THEN
469: l_return_value := FALSE;
470: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
471: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
472: FND_MSG_PUB.Add;
473: l_return_value := FALSE;
474: RETURN l_return_value;

Line 471: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

467:
468: IF p_end_date < SYSDATE THEN
469: l_return_value := FALSE;
470: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
471: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
472: FND_MSG_PUB.Add;
473: l_return_value := FALSE;
474: RETURN l_return_value;
475: END IF;

Line 492: fnd_message.set_name('CSI','CSI_HAS_TXNS');

488: AND t.transaction_id <> nvl(p_txn_id, -99999);
489:
490: IF l_transaction_date > p_end_date
491: THEN
492: fnd_message.set_name('CSI','CSI_HAS_TXNS');
493: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
494: fnd_msg_pub.add;
495: l_return_value := FALSE;
496: RETURN l_return_value;

Line 493: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

489:
490: IF l_transaction_date > p_end_date
491: THEN
492: fnd_message.set_name('CSI','CSI_HAS_TXNS');
493: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
494: fnd_msg_pub.add;
495: l_return_value := FALSE;
496: RETURN l_return_value;
497: END IF;

Line 510: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');

506: (p_end_date < l_date_rec.active_start_date)
507: THEN
508: l_return_value := FALSE;
509: IF ( p_stack_err_msg = TRUE ) THEN
510: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
511: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
512: FND_MSG_PUB.Add;
513: END IF;
514: RETURN l_return_value;

Line 511: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

507: THEN
508: l_return_value := FALSE;
509: IF ( p_stack_err_msg = TRUE ) THEN
510: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
511: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
512: FND_MSG_PUB.Add;
513: END IF;
514: RETURN l_return_value;
515: END IF;

Line 556: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_ITEM');

552: (p_master_organization_id = p_orig_master_org_id)) THEN
553: RETURN TRUE;
554: ELSE
555: IF ( p_stack_err_msg = TRUE ) THEN
556: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_ITEM');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_master_organization_id);
559: FND_MSG_PUB.Add;
560: END IF;

Line 557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);

553: RETURN TRUE;
554: ELSE
555: IF ( p_stack_err_msg = TRUE ) THEN
556: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_ITEM');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_master_organization_id);
559: FND_MSG_PUB.Add;
560: END IF;
561: RETURN FALSE;

Line 558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_master_organization_id);

554: ELSE
555: IF ( p_stack_err_msg = TRUE ) THEN
556: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_ITEM');
557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
558: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_master_organization_id);
559: FND_MSG_PUB.Add;
560: END IF;
561: RETURN FALSE;
562: END IF;

Line 569: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_INST');

565: IF p_instance_id = p_orig_instance_id THEN
566: RETURN TRUE;
567: ELSE
568: IF ( p_stack_err_msg = TRUE ) THEN
569: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_INST');
570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST_ORIG',p_instance_id );
571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST',p_orig_instance_id );
572: FND_MSG_PUB.Add;
573: END IF;

Line 570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST_ORIG',p_instance_id );

566: RETURN TRUE;
567: ELSE
568: IF ( p_stack_err_msg = TRUE ) THEN
569: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_INST');
570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST_ORIG',p_instance_id );
571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST',p_orig_instance_id );
572: FND_MSG_PUB.Add;
573: END IF;
574: RETURN FALSE;

Line 571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST',p_orig_instance_id );

567: ELSE
568: IF ( p_stack_err_msg = TRUE ) THEN
569: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_INST');
570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST_ORIG',p_instance_id );
571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_INST',p_orig_instance_id );
572: FND_MSG_PUB.Add;
573: END IF;
574: RETURN FALSE;
575: END IF;

Line 587: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

583: --
584: IF l_category_set_id IS NULL THEN
585: csi_gen_utility_pvt.put_line('Category Set should be defined to have attributes at CATEGORY Level');
586: IF ( p_stack_err_msg = TRUE ) THEN
587: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
588: FND_MSG_PUB.ADD;
589: END IF;
590: RETURN FALSE;
591: END IF;

Line 605: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');

601: RETURN TRUE;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: IF ( p_stack_err_msg = TRUE ) THEN
605: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_orig_master_org_id);
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',p_item_category_id);
609: FND_MSG_PUB.Add;

Line 606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);

602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: IF ( p_stack_err_msg = TRUE ) THEN
605: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_orig_master_org_id);
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',p_item_category_id);
609: FND_MSG_PUB.Add;
610: END IF;

Line 607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_orig_master_org_id);

603: WHEN NO_DATA_FOUND THEN
604: IF ( p_stack_err_msg = TRUE ) THEN
605: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_orig_master_org_id);
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',p_item_category_id);
609: FND_MSG_PUB.Add;
610: END IF;
611: RETURN FALSE;

Line 608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',p_item_category_id);

604: IF ( p_stack_err_msg = TRUE ) THEN
605: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ATT_LEV_CAT');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ITEM',p_orig_inv_item_id);
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_ORG',p_orig_master_org_id);
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CAT',p_item_category_id);
609: FND_MSG_PUB.Add;
610: END IF;
611: RETURN FALSE;
612: END;

Line 616: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');

612: END;
613: ELSE
614: -- Invalid attribute level has been passed
615: IF ( p_stack_err_msg = TRUE ) THEN
616: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level);
618: FND_MSG_PUB.Add;
619: END IF;
620: RETURN FALSE;

Line 617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level);

613: ELSE
614: -- Invalid attribute level has been passed
615: IF ( p_stack_err_msg = TRUE ) THEN
616: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level);
618: FND_MSG_PUB.Add;
619: END IF;
620: RETURN FALSE;
621:

Line 627: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');

623:
624: EXCEPTION
625: WHEN OTHERS THEN
626: IF ( p_stack_err_msg = TRUE ) THEN
627: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level
629: ||' inventory_item_id '||p_orig_inv_item_id
630: ||' master_org_id '||p_orig_master_org_id
631: ||' item_category '|| p_item_category_id);

Line 628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level

624: EXCEPTION
625: WHEN OTHERS THEN
626: IF ( p_stack_err_msg = TRUE ) THEN
627: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATTRIB_LEVEL');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_LEVEL_CONTENT',p_attribute_level
629: ||' inventory_item_id '||p_orig_inv_item_id
630: ||' master_org_id '||p_orig_master_org_id
631: ||' item_category '|| p_item_category_id);
632: FND_MSG_PUB.Add;

Line 660: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');

656: INTO l_attribute_value_id
657: FROM csi_iea_values
658: WHERE attribute_value_id = p_attribute_value_id ;
659: IF ( p_stack_err_msg = TRUE ) THEN
660: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
661: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_attribute_value_id);
662: FND_MSG_PUB.Add;
663: END IF;
664: RETURN FALSE;

Line 661: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_attribute_value_id);

657: FROM csi_iea_values
658: WHERE attribute_value_id = p_attribute_value_id ;
659: IF ( p_stack_err_msg = TRUE ) THEN
660: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
661: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',p_attribute_value_id);
662: FND_MSG_PUB.Add;
663: END IF;
664: RETURN FALSE;
665: EXCEPTION

Line 690: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');

686: FROM dual;
687: RETURN l_attribute_value_id;
688: EXCEPTION
689: WHEN OTHERS THEN
690: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',l_attribute_value_id);
692: FND_MSG_PUB.Add;
693: END Get_attribute_value_id;
694:

Line 691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',l_attribute_value_id);

687: RETURN l_attribute_value_id;
688: EXCEPTION
689: WHEN OTHERS THEN
690: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',l_attribute_value_id);
692: FND_MSG_PUB.Add;
693: END Get_attribute_value_id;
694:
695:

Line 717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_H_ID');

713: FROM dual;
714: RETURN l_attribute_value_id;
715: EXCEPTION
716: WHEN OTHERS THEN
717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_H_ID');
718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_H_ID',l_attribute_value_id);
719: FND_MSG_PUB.Add;
720: END get_attribute_value_h_id;
721:

Line 718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_H_ID',l_attribute_value_id);

714: RETURN l_attribute_value_id;
715: EXCEPTION
716: WHEN OTHERS THEN
717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_H_ID');
718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_H_ID',l_attribute_value_id);
719: FND_MSG_PUB.Add;
720: END get_attribute_value_h_id;
721:
722:

Line 744: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');

740: RETURN l_object_version_number;
741: EXCEPTION
742: WHEN OTHERS THEN
743: IF ( p_stack_err_msg = TRUE ) THEN
744: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
745: FND_MSG_PUB.Add;
746: END IF;
747: END get_object_version_number ;
748:

Line 771: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');

767: IF (p_obj_ver_numb_new = p_obj_ver_numb_old ) THEN
768: RETURN TRUE;
769: ELSE
770: IF ( p_stack_err_msg = TRUE ) THEN
771: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
772: FND_MSG_PUB.Add;
773: END IF;
774: RETURN FALSE;
775: END IF;

Line 780: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');

776:
777: EXCEPTION
778: WHEN OTHERS THEN
779: IF ( p_stack_err_msg = TRUE ) THEN
780: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
781: FND_MSG_PUB.Add;
782: RETURN FALSE;
783: END IF;
784: END Is_valid_obj_ver_num;

Line 810: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');

806: l_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
807: --
808: IF ( p_stack_err_msg = TRUE ) THEN
809: IF l_dump_frequency IS NULL THEN
810: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
811: FND_MSG_PUB.ADD;
812: END IF;
813: END IF;
814: