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 494: fnd_msg_pub.add;

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

Line 512: FND_MSG_PUB.Add;

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

Line 559: FND_MSG_PUB.Add;

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

Line 572: FND_MSG_PUB.Add;

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

Line 588: FND_MSG_PUB.ADD;

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

Line 609: FND_MSG_PUB.Add;

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

Line 618: FND_MSG_PUB.Add;

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

Line 632: FND_MSG_PUB.Add;

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;
633: END IF;
634: RETURN FALSE;
635: END Is_Valid_attrib_level_content;
636:

Line 662: FND_MSG_PUB.Add;

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

Line 692: FND_MSG_PUB.Add;

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

Line 719: FND_MSG_PUB.Add;

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

Line 745: FND_MSG_PUB.Add;

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

Line 772: FND_MSG_PUB.Add;

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

Line 781: FND_MSG_PUB.Add;

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

Line 811: FND_MSG_PUB.ADD;

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