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 494: fnd_message.set_name('CSI','CSI_HAS_TXNS');

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

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

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

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

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

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

511: THEN
512: l_return_value := FALSE;
513: IF ( p_stack_err_msg = TRUE ) THEN
514: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
515: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
516: FND_MSG_PUB.Add;
517: END IF;
518: RETURN l_return_value;
519: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

690: FROM dual;
691: RETURN l_attribute_value_id;
692: EXCEPTION
693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',l_attribute_value_id);
696: FND_MSG_PUB.Add;
697: END Get_attribute_value_id;
698:

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

691: RETURN l_attribute_value_id;
692: EXCEPTION
693: WHEN OTHERS THEN
694: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_ID');
695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_ID',l_attribute_value_id);
696: FND_MSG_PUB.Add;
697: END Get_attribute_value_id;
698:
699:

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

717: FROM dual;
718: RETURN l_attribute_value_id;
719: EXCEPTION
720: WHEN OTHERS THEN
721: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_H_ID');
722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_H_ID',l_attribute_value_id);
723: FND_MSG_PUB.Add;
724: END get_attribute_value_h_id;
725:

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

718: RETURN l_attribute_value_id;
719: EXCEPTION
720: WHEN OTHERS THEN
721: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_VAL_H_ID');
722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_H_ID',l_attribute_value_id);
723: FND_MSG_PUB.Add;
724: END get_attribute_value_h_id;
725:
726:

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

744: RETURN l_object_version_number;
745: EXCEPTION
746: WHEN OTHERS THEN
747: IF ( p_stack_err_msg = TRUE ) THEN
748: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
749: FND_MSG_PUB.Add;
750: END IF;
751: END get_object_version_number ;
752:

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

771: IF (p_obj_ver_numb_new = p_obj_ver_numb_old ) THEN
772: RETURN TRUE;
773: ELSE
774: IF ( p_stack_err_msg = TRUE ) THEN
775: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
776: FND_MSG_PUB.Add;
777: END IF;
778: RETURN FALSE;
779: END IF;

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

780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: IF ( p_stack_err_msg = TRUE ) THEN
784: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
785: FND_MSG_PUB.Add;
786: RETURN FALSE;
787: END IF;
788: END Is_valid_obj_ver_num;

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

810: l_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
811: --
812: IF ( p_stack_err_msg = TRUE ) THEN
813: IF l_dump_frequency IS NULL THEN
814: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
815: FND_MSG_PUB.ADD;
816: END IF;
817: END IF;
818: