DBA Data[Home] [Help]

APPS.CSI_ORG_UNIT_VLD_PVT dependencies on FND_MSG_PUB

Line 26: FND_MSG_PUB.Add;

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
30: 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_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;
54: END;

Line 82: FND_MSG_PUB.Add;

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

Line 92: FND_MSG_PUB.Add;

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

Line 131: FND_MSG_PUB.Add;

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

Line 142: FND_MSG_PUB.Add;

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:
146: --IF block for bug 5939688--

Line 161: FND_MSG_PUB.Add;

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

Line 201: FND_MSG_PUB.Add;

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

Line 223: fnd_msg_pub.add;

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

Line 240: FND_MSG_PUB.Add;

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

Line 283: FND_MSG_PUB.Add;

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

Line 318: FND_MSG_PUB.Add;

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

Line 361: FND_MSG_PUB.Add;

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

Line 372: FND_MSG_PUB.Add;

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

Line 401: FND_MSG_PUB.Add;

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

Line 485: FND_MSG_PUB.Add;

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

Line 555: FND_MSG_PUB.Add;

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

Line 590: FND_MSG_PUB.Add;

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:
594: /*----------------------------------------------------------*/

Line 617: FND_MSG_PUB.Add;

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

Line 643: FND_MSG_PUB.Add;

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

Line 669: FND_MSG_PUB.Add;

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

Line 678: FND_MSG_PUB.Add;

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

Line 709: FND_MSG_PUB.ADD;

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;
713: END get_full_dump_frequency;