DBA Data[Home] [Help]

APPS.CSI_ORG_UNIT_VLD_PVT dependencies on FND_MESSAGE

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

20: BEGIN
21: -- Verify that instance id is passed
22: IF p_instance_id IS NULL THEN
23: IF ( p_stack_err_msg = TRUE ) THEN
24: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
25: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
26: FND_MSG_PUB.Add;
27: END IF;
28: RETURN FALSE;

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

21: -- Verify that instance id is passed
22: IF p_instance_id IS NULL THEN
23: IF ( p_stack_err_msg = TRUE ) THEN
24: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
25: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
26: FND_MSG_PUB.Add;
27: END IF;
28: RETURN FALSE;
29: 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_EXPIRED_INSTANCE_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_EXPIRED_INSTANCE_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_EXPIRED_INSTANCE_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 80: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');

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

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

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

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

86:
87: EXCEPTION
88: WHEN OTHERS THEN
89: IF ( p_stack_err_msg = TRUE ) THEN
90: FND_MESSAGE.SET_NAME('CSI','CSI_API_CANT_CHANGE_INST_ID');
91: FND_MESSAGE.SET_TOKEN('INSTANCE_ID_OLD',p_instance_id_old);
92: FND_MSG_PUB.Add;
93: END IF;
94: RETURN FALSE;

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

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

Line 129: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');

125: (p_end_date <> FND_API.G_MISS_DATE)
126: AND
127: (p_start_date > p_end_date)) THEN
128: l_return_value := FALSE;
129: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
130: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
131: FND_MSG_PUB.Add;
132: RETURN l_return_value;
133: END IF;

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

126: AND
127: (p_start_date > p_end_date)) THEN
128: l_return_value := FALSE;
129: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
130: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
131: FND_MSG_PUB.Add;
132: RETURN l_return_value;
133: END IF;
134:

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

136: FETCH c1 INTO l_date_rec;
137: IF c1%NOTFOUND THEN
138: l_return_value := FALSE;
139: IF ( p_stack_err_msg = TRUE ) THEN
140: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
141: FND_MESSAGE.SET_TOKEN('ENTITY','Operating Unit');
142: FND_MSG_PUB.Add;
143: END IF;
144: END IF;

Line 141: FND_MESSAGE.SET_TOKEN('ENTITY','Operating Unit');

137: IF c1%NOTFOUND THEN
138: l_return_value := FALSE;
139: IF ( p_stack_err_msg = TRUE ) THEN
140: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
141: FND_MESSAGE.SET_TOKEN('ENTITY','Operating Unit');
142: FND_MSG_PUB.Add;
143: END IF;
144: END IF;
145:

Line 159: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');

155: (p_start_date > SYSDATE)
156: THEN
157: l_return_value := FALSE;
158: IF ( p_stack_err_msg = TRUE ) THEN
159: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
160: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
161: FND_MSG_PUB.Add;
162: END IF;
163: END IF;

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

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

Line 199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');

195: IF ((p_instance_ou_id IS NULL) OR (p_instance_ou_id = FND_API.G_MISS_NUM)) THEN
196: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
197: IF p_end_date < sysdate THEN
198: l_return_value := FALSE;
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
200: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
201: FND_MSG_PUB.Add;
202: l_return_value := FALSE;
203: RETURN l_return_value;

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

196: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
197: IF p_end_date < sysdate THEN
198: l_return_value := FALSE;
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
200: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
201: FND_MSG_PUB.Add;
202: l_return_value := FALSE;
203: RETURN l_return_value;
204: END IF;

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

217: AND t.transaction_id <> p_txn_id;
218:
219: IF l_transaction_date > p_end_date
220: THEN
221: fnd_message.set_name('CSI','CSI_HAS_TXNS');
222: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
223: fnd_msg_pub.add;
224: l_return_value := FALSE;
225: RETURN l_return_value;

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

218:
219: IF l_transaction_date > p_end_date
220: THEN
221: fnd_message.set_name('CSI','CSI_HAS_TXNS');
222: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
223: fnd_msg_pub.add;
224: l_return_value := FALSE;
225: RETURN l_return_value;
226: END IF;

Line 238: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');

234: (p_end_date < l_date_rec.active_start_date)
235: THEN
236: l_return_value := FALSE;
237: IF ( p_stack_err_msg = TRUE ) THEN
238: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
239: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
240: FND_MSG_PUB.Add;
241: END IF;
242: RETURN l_return_value;

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

235: THEN
236: l_return_value := FALSE;
237: IF ( p_stack_err_msg = TRUE ) THEN
238: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
239: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
240: FND_MSG_PUB.Add;
241: END IF;
242: RETURN l_return_value;
243: END IF;

Line 281: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');

277:
278: EXCEPTION
279: WHEN NO_DATA_FOUND THEN
280: IF ( p_stack_err_msg = TRUE ) THEN
281: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');
282: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_operating_unit_id);
283: FND_MSG_PUB.Add;
284: END IF;
285: RETURN FALSE;

Line 282: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_operating_unit_id);

278: EXCEPTION
279: WHEN NO_DATA_FOUND THEN
280: IF ( p_stack_err_msg = TRUE ) THEN
281: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');
282: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_operating_unit_id);
283: FND_MSG_PUB.Add;
284: END IF;
285: RETURN FALSE;
286: END;

Line 316: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REL_TYPE_CODE');

312: RETURN TRUE;
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: IF ( p_stack_err_msg = TRUE ) THEN
316: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REL_TYPE_CODE');
317: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type_code);
318: FND_MSG_PUB.Add;
319: END IF;
320: RETURN FALSE;

Line 317: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type_code);

313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: IF ( p_stack_err_msg = TRUE ) THEN
316: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REL_TYPE_CODE');
317: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type_code);
318: FND_MSG_PUB.Add;
319: END IF;
320: RETURN FALSE;
321: END Is_Valid_rel_type_code;

Line 359: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');

355: AND instance_ou_id <> l_instance_ou_id
356: AND relationship_type_code = p_relationship_type_code;
357:
358: IF ( p_stack_err_msg = TRUE ) THEN
359: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
360: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);
361: FND_MSG_PUB.Add;
362: END IF;
363: RETURN FALSE;

Line 360: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);

356: AND relationship_type_code = p_relationship_type_code;
357:
358: IF ( p_stack_err_msg = TRUE ) THEN
359: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
360: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);
361: FND_MSG_PUB.Add;
362: END IF;
363: RETURN FALSE;
364:

Line 370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');

366: WHEN NO_DATA_FOUND THEN
367: RETURN TRUE;
368: WHEN OTHERS THEN
369: IF ( p_stack_err_msg = TRUE ) THEN
370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
371: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);
372: FND_MSG_PUB.Add;
373: END IF;
374: RETURN FALSE;

Line 371: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);

367: RETURN TRUE;
368: WHEN OTHERS THEN
369: IF ( p_stack_err_msg = TRUE ) THEN
370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
371: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',p_instance_id||' '||p_relationship_type_code);
372: FND_MSG_PUB.Add;
373: END IF;
374: RETURN FALSE;
375: END Alternate_PK_exists;

Line 399: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');

395: FROM csi_i_org_assignments
396: WHERE instance_ou_id = p_instance_ou_id;
397:
398: IF ( p_stack_err_msg = TRUE ) THEN
399: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
400: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);
401: FND_MSG_PUB.Add;
402: END IF;
403: RETURN FALSE;

Line 400: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);

396: WHERE instance_ou_id = p_instance_ou_id;
397:
398: IF ( p_stack_err_msg = TRUE ) THEN
399: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
400: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);
401: FND_MSG_PUB.Add;
402: END IF;
403: RETURN FALSE;
404:

Line 483: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');

479:
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: IF ( p_stack_err_msg = TRUE ) THEN
483: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
484: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);
485: FND_MSG_PUB.Add;
486: END IF;
487: RETURN FALSE;

Line 484: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);

480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: IF ( p_stack_err_msg = TRUE ) THEN
483: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
484: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',p_instance_ou_id);
485: FND_MSG_PUB.Add;
486: END IF;
487: RETURN FALSE;
488: END Val_and_get_inst_ou_id;

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

549: BEGIN
550: IF p_old_date < SYSDATE THEN
551: IF p_new_date = FND_API.G_MISS_DATE THEN
552: IF ( p_stack_err_msg = TRUE ) THEN
553: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
554: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
555: FND_MSG_PUB.Add;
556: END IF;
557: RETURN FALSE;

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

550: IF p_old_date < SYSDATE THEN
551: IF p_new_date = FND_API.G_MISS_DATE THEN
552: IF ( p_stack_err_msg = TRUE ) THEN
553: FND_MESSAGE.SET_NAME('CSI','CSI_API_NOT_UPDATABLE');
554: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_old_date);
555: FND_MSG_PUB.Add;
556: END IF;
557: RETURN FALSE;
558: ELSE

Line 588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');

584: RETURN l_instance_ou_id;
585: EXCEPTION
586: WHEN OTHERS THEN
587: IF ( p_stack_err_msg = TRUE ) THEN
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
589: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',l_instance_ou_id);
590: FND_MSG_PUB.Add;
591: END IF;
592: END Get_instance_ou_id;

Line 589: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',l_instance_ou_id);

585: EXCEPTION
586: WHEN OTHERS THEN
587: IF ( p_stack_err_msg = TRUE ) THEN
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');
589: FND_MESSAGE.SET_TOKEN('INSTANCE_OU_ID',l_instance_ou_id);
590: FND_MSG_PUB.Add;
591: END IF;
592: END Get_instance_ou_id;
593:

Line 615: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ORG_ASS_H_ID');

611: RETURN l_cis_i_org_assign_h_id;
612: EXCEPTION
613: WHEN OTHERS THEN
614: IF ( p_stack_err_msg = TRUE ) THEN
615: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ORG_ASS_H_ID');
616: FND_MESSAGE.SET_TOKEN('ORG_ASSIGN_H_ID',l_cis_i_org_assign_h_id);
617: FND_MSG_PUB.Add;
618: END IF;
619: END get_cis_i_org_assign_h_id;

Line 616: FND_MESSAGE.SET_TOKEN('ORG_ASSIGN_H_ID',l_cis_i_org_assign_h_id);

612: EXCEPTION
613: WHEN OTHERS THEN
614: IF ( p_stack_err_msg = TRUE ) THEN
615: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ORG_ASS_H_ID');
616: FND_MESSAGE.SET_TOKEN('ORG_ASSIGN_H_ID',l_cis_i_org_assign_h_id);
617: FND_MSG_PUB.Add;
618: END IF;
619: END get_cis_i_org_assign_h_id;
620:

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

638: RETURN l_object_version_number;
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF ( p_stack_err_msg = TRUE ) THEN
642: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
643: FND_MSG_PUB.Add;
644: END IF;
645: END get_object_version_number ;
646:

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

664: IF (p_obj_ver_numb_new = p_obj_ver_numb_old ) THEN
665: RETURN TRUE;
666: ELSE
667: IF ( p_stack_err_msg = TRUE ) THEN
668: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
669: FND_MSG_PUB.Add;
670: END IF;
671: RETURN FALSE;
672: END IF;

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

673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: IF ( p_stack_err_msg = TRUE ) THEN
677: FND_MESSAGE.SET_NAME('CSI','CSI_API_OBJ_VER_MISMATCH');
678: FND_MSG_PUB.Add;
679: END IF;
680: RETURN FALSE;
681: END Is_valid_obj_ver_num;

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

704: l_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
705: --
706: IF p_stack_err_msg = TRUE THEN
707: IF l_dump_frequency IS NULL THEN
708: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
709: FND_MSG_PUB.ADD;
710: END IF;
711: END IF;
712: RETURN l_dump_frequency;