DBA Data[Home] [Help]

APPS.CSI_EXTEND_ATTRIB_VLD_PVT dependencies on FND_MSG_PUB

Line 28: FND_MSG_PUB.Add;

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
32: BEGIN

Line 48: FND_MSG_PUB.Add;

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
52: IF ( p_stack_err_msg = TRUE ) THEN

Line 55: FND_MSG_PUB.Add;

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;
59: END;

Line 88: FND_MSG_PUB.Add;

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;
92:

Line 98: FND_MSG_PUB.Add;

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;
102:

Line 128: FND_MSG_PUB.Add;

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
132: BEGIN

Line 151: FND_MSG_PUB.Add;

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;
155: END IF;

Line 180: FND_MSG_PUB.Add;

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
184: BEGIN

Line 239: FND_MSG_PUB.Add;

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;
243: END IF;

Line 312: FND_MSG_PUB.Add;

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;
316: ELSE

Line 353: FND_MSG_PUB.Add;

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:
357: EXCEPTION

Line 402: FND_MSG_PUB.Add;

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:
406: OPEN c1;

Line 413: FND_MSG_PUB.Add;

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:
417: IF (p_start_date < l_date_rec.active_start_date)

Line 427: FND_MSG_PUB.Add;

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;
431: RETURN l_return_value;

Line 472: FND_MSG_PUB.Add;

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;
476: END IF;

Line 496: fnd_msg_pub.add;

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;
500: END IF;

Line 516: FND_MSG_PUB.Add;

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;
520: CLOSE c1;

Line 563: FND_MSG_PUB.Add;

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;
567:

Line 576: FND_MSG_PUB.Add;

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;
580:

Line 592: FND_MSG_PUB.ADD;

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;
596: --

Line 613: FND_MSG_PUB.Add;

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;
617: ELSE

Line 622: FND_MSG_PUB.Add;

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:
626: END IF;

Line 636: FND_MSG_PUB.Add;

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;
637: END IF;
638: RETURN FALSE;
639: END Is_Valid_attrib_level_content;
640:

Line 666: FND_MSG_PUB.Add;

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
670: WHEN NO_DATA_FOUND THEN

Line 696: FND_MSG_PUB.Add;

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:
700:

Line 723: FND_MSG_PUB.Add;

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:
727:

Line 749: FND_MSG_PUB.Add;

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:
753:

Line 776: FND_MSG_PUB.Add;

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;
780:

Line 785: FND_MSG_PUB.Add;

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;
789:

Line 815: FND_MSG_PUB.ADD;

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:
819: RETURN l_dump_frequency;