DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIB_VLD_PVT dependencies on FND_MSG_PUB

Line 25: FND_MSG_PUB.Add;

21: IF p_instance_id IS NULL THEN
22: IF ( p_stack_err_msg = TRUE ) THEN
23: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
24: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
25: FND_MSG_PUB.Add;
26: END IF;
27: RETURN FALSE;
28: ELSE
29: BEGIN

Line 43: FND_MSG_PUB.Add;

39: IF p_event = 'INSERT' THEN
40: IF ( p_stack_err_msg = TRUE ) THEN
41: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
42: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
43: FND_MSG_PUB.Add;
44: END IF;
45: RETURN FALSE;
46: ELSIF p_event = 'UPDATE' THEN
47: IF ( p_stack_err_msg = TRUE ) THEN

Line 50: FND_MSG_PUB.Add;

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

Line 83: FND_MSG_PUB.Add;

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

Line 93: FND_MSG_PUB.Add;

89: WHEN OTHERS THEN
90: IF ( p_stack_err_msg = TRUE ) THEN
91: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
92: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
93: FND_MSG_PUB.Add;
94: END IF;
95: RETURN FALSE;
96: END Val_inst_id_for_update;
97:

Line 137: FND_MSG_PUB.Add;

133: (p_start_date > p_end_date)) THEN
134: l_return_value := FALSE;
135: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
136: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
137: FND_MSG_PUB.Add;
138: RETURN l_return_value;
139: END IF;
140:
141: OPEN c1;

Line 148: FND_MSG_PUB.Add;

144: l_return_value := FALSE;
145: IF ( p_stack_err_msg = TRUE ) THEN
146: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
147: FND_MESSAGE.SET_TOKEN('ENTITY','Pricing Attribute');
148: FND_MSG_PUB.Add;
149: END IF;
150: END IF;
151:
152: IF (p_start_date < l_date_rec.active_start_date)

Line 162: FND_MSG_PUB.Add;

158: l_return_value := FALSE;
159: IF ( p_stack_err_msg = TRUE ) THEN
160: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
161: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
162: FND_MSG_PUB.Add;
163: END IF;
164: END IF;
165: CLOSE c1;
166: RETURN l_return_value;

Line 208: FND_MSG_PUB.Add;

204: IF p_end_date < SYSDATE THEN
205: l_return_value := FALSE;
206: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');
207: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
208: FND_MSG_PUB.Add;
209: l_return_value := FALSE;
210: RETURN l_return_value;
211: END IF;
212: END IF;

Line 230: fnd_msg_pub.add;

226: IF l_transaction_date > p_end_date
227: THEN
228: fnd_message.set_name('CSI','CSI_HAS_TXNS');
229: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
230: fnd_msg_pub.add;
231: l_return_value := FALSE;
232: RETURN l_return_value;
233: END IF;
234: END IF;

Line 248: FND_MSG_PUB.Add;

244: l_return_value := FALSE;
245: IF ( p_stack_err_msg = TRUE ) THEN
246: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');
247: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
248: FND_MSG_PUB.Add;
249: END IF;
250: RETURN l_return_value;
251: END IF;
252: CLOSE c1;

Line 280: FND_MSG_PUB.Add;

276: IF p_pricing_attrib_id IS NULL THEN
277: IF ( p_stack_err_msg = TRUE ) THEN
278: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
279: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);
280: FND_MSG_PUB.Add;
281: END IF;
282: RETURN FALSE;
283: ELSE
284: SELECT '1'

Line 291: FND_MSG_PUB.Add;

287: WHERE pricing_attribute_id = p_pricing_attrib_id;
288: IF ( p_stack_err_msg = TRUE ) THEN
289: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
290: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);
291: FND_MSG_PUB.Add;
292: END IF;
293: RETURN FALSE;
294: END IF;
295:

Line 323: FND_MSG_PUB.Add;

319: IF p_pricing_attrib_id IS NULL THEN
320: IF ( p_stack_err_msg = TRUE ) THEN
321: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
322: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);
323: FND_MSG_PUB.Add;
324: END IF;
325: RETURN FALSE;
326: ELSE
327: -- Verify that pricing attribute id is passed

Line 582: FND_MSG_PUB.Add;

578: WHEN NO_DATA_FOUND THEN
579: IF ( p_stack_err_msg = TRUE ) THEN
580: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
581: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);
582: FND_MSG_PUB.Add;
583: END IF;
584: RETURN FALSE;
585: END Val_and_get_pri_att_id ;
586:

Line 752: FND_MSG_PUB.Add;

748: IF p_new_date = FND_API.G_MISS_DATE THEN
749: IF ( p_stack_err_msg = TRUE ) THEN
750: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
751: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
752: FND_MSG_PUB.Add;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: RETURN FALSE;
756: ELSE

Line 790: FND_MSG_PUB.Add;

786: WHEN OTHERS THEN
787: IF ( p_stack_err_msg = TRUE ) THEN
788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');
789: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',l_pricing_attrib_id);
790: FND_MSG_PUB.Add;
791: END IF;
792: END get_pricing_attrib_id;
793:
794:

Line 819: FND_MSG_PUB.Add;

815: WHEN OTHERS THEN
816: IF ( p_stack_err_msg = TRUE ) THEN
817: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_H_ID');
818: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_H_ID',l_pricing_attrib_h_id);
819: FND_MSG_PUB.Add;
820: END IF;
821: END get_pricing_attrib_h_id;
822:
823:

Line 846: FND_MSG_PUB.Add;

842: EXCEPTION
843: WHEN OTHERS THEN
844: IF ( p_stack_err_msg = TRUE ) THEN
845: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
846: FND_MSG_PUB.Add;
847: END IF;
848: END get_object_version_number ;
849:
850:

Line 873: FND_MSG_PUB.Add;

869: RETURN TRUE;
870: ELSE
871: IF ( p_stack_err_msg = TRUE ) THEN
872: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
873: FND_MSG_PUB.Add;
874: END IF;
875: RETURN FALSE;
876: END IF;
877:

Line 882: FND_MSG_PUB.Add;

878: EXCEPTION
879: WHEN OTHERS THEN
880: IF ( p_stack_err_msg = TRUE ) THEN
881: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
882: FND_MSG_PUB.Add;
883: RETURN FALSE;
884: END IF;
885: END Is_valid_obj_ver_num;
886:

Line 912: FND_MSG_PUB.ADD;

908: --
909: IF p_stack_err_msg = TRUE THEN
910: IF l_dump_frequency IS NULL THEN
911: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
912: FND_MSG_PUB.ADD;
913: END IF;
914: END IF;
915:
916: RETURN l_dump_frequency;