DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIB_VLD_PVT dependencies on FND_MESSAGE

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

19: BEGIN
20: -- Verify that instance id is passed
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;

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

20: -- Verify that instance id is passed
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

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

37: EXCEPTION
38: WHEN NO_DATA_FOUND THEN
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;

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

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

Line 48: FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_PRI_INST_ID');

44: END IF;
45: RETURN FALSE;
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;

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

45: RETURN FALSE;
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;

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

77: IF (p_instance_id_old = p_instance_id_new) THEN
78: RETURN TRUE;
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;

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

78: RETURN TRUE;
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;

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

87:
88: EXCEPTION
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;

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

88: EXCEPTION
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;

Line 135: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');

131: (p_end_date <> FND_API.G_MISS_DATE)
132: AND
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;

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

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

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

142: FETCH c1 INTO l_date_rec;
143: IF c1%NOTFOUND THEN
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;

Line 147: FND_MESSAGE.SET_TOKEN('ENTITY','Pricing Attribute');

143: IF c1%NOTFOUND THEN
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: -- Fix for the bug 7333900

Line 160: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');

156: (to_date(p_start_date,'DD-MM-YY HH24:MI') > to_date(SYSDATE,'DD-MM-YY HH24:MI'))
157: THEN
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;

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

157: THEN
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;

Line 206: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');

202: IF ((p_end_date is NOT NULL) AND (p_end_date <> fnd_api.g_miss_date)) THEN
203:
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;

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

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

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

224: AND t.transaction_id <>nvl(p_txn_id, -99999);
225:
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;

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

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

Line 246: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');

242: (p_end_date < l_date_rec.active_start_date)
243: THEN
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;

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

243: THEN
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;

Line 278: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');

274: BEGIN
275: -- Verify that pricing attrib_id is valid
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;

Line 279: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);

275: -- Verify that pricing attrib_id is valid
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

Line 289: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');

285: INTO l_pricing_attrib_id
286: FROM csi_i_pricing_attribs
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;

Line 290: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);

286: FROM csi_i_pricing_attribs
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;

Line 321: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');

317: l_pricing_attrib_id NUMBER;
318: BEGIN
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;

Line 322: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);

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

Line 580: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');

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

Line 581: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',p_pricing_attrib_id);

577: EXCEPTION
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 ;

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

746: BEGIN
747: IF p_old_date < SYSDATE THEN
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;

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

747: IF p_old_date < SYSDATE THEN
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;

Line 788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PRI_ATT_ID');

784: RETURN l_pricing_attrib_id ;
785: EXCEPTION
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;

Line 789: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_ID',l_pricing_attrib_id);

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

Line 817: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ATT_H_ID');

813: RETURN l_pricing_attrib_h_id ;
814: EXCEPTION
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;

Line 818: FND_MESSAGE.SET_TOKEN('PRICING_ATTRIB_H_ID',l_pricing_attrib_h_id);

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

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

841: RETURN l_object_version_number;
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:

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

868: IF (p_obj_ver_numb_new = p_obj_ver_numb_old ) THEN
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;

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

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

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

907: l_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
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: