DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on FND_MESSAGE

Line 18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

14: p_api_name IN VARCHAR2
15: ) IS
16: BEGIN
17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;
22: RAISE FND_API.G_EXC_ERROR;

Line 19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

15: ) IS
16: BEGIN
17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;

Line 20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

16: BEGIN
17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;
24: END Check_Reqd_Param_num;

Line 39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

35: p_api_name IN VARCHAR2
36: ) IS
37: BEGIN
38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;
43: RAISE FND_API.G_EXC_ERROR;

Line 40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

36: ) IS
37: BEGIN
38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;

Line 41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

37: BEGIN
38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45: END Check_Reqd_Param_char;

Line 60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

56: p_api_name IN VARCHAR2
57: ) IS
58: BEGIN
59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;
64: RAISE FND_API.G_EXC_ERROR;

Line 61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

57: ) IS
58: BEGIN
59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;

Line 62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

58: BEGIN
59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: END Check_Reqd_Param_date;

Line 101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');

97: and NVL(contact_ip_id,fnd_api.g_miss_num) = nvl(p_contact_ip_id,fnd_api.g_miss_num)
98: and ((active_end_date is null) OR (active_end_date >= sysdate));
99:
100: IF ( p_stack_err_msg = TRUE ) THEN
101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
102: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','||to_char(p_party_id)||','||p_relationship_type||','||to_char(p_contact_ip_id));
103: FND_MSG_PUB.Add;
104: END IF;
105: RETURN l_return_value;

Line 102: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','||to_char(p_party_id)||','||p_relationship_type||','||to_char(p_contact_ip_id));

98: and ((active_end_date is null) OR (active_end_date >= sysdate));
99:
100: IF ( p_stack_err_msg = TRUE ) THEN
101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
102: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','||to_char(p_party_id)||','||p_relationship_type||','||to_char(p_contact_ip_id));
103: FND_MSG_PUB.Add;
104: END IF;
105: RETURN l_return_value;
106: EXCEPTION

Line 113: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');

109: RETURN l_return_value;
110: WHEN TOO_MANY_ROWS THEN
111: l_return_value := TRUE;
112: IF ( p_stack_err_msg = TRUE ) THEN
113: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');
114: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','|| to_char(p_party_id)||','||p_relationship_type||','|| to_char(p_contact_ip_id));
115: FND_MSG_PUB.Add;
116: END IF;
117: RETURN l_return_value;

Line 114: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','|| to_char(p_party_id)||','||p_relationship_type||','|| to_char(p_contact_ip_id));

110: WHEN TOO_MANY_ROWS THEN
111: l_return_value := TRUE;
112: IF ( p_stack_err_msg = TRUE ) THEN
113: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');
114: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(p_instance_id) ||','||p_party_source_table||','|| to_char(p_party_id)||','||p_relationship_type||','|| to_char(p_contact_ip_id));
115: FND_MSG_PUB.Add;
116: END IF;
117: RETURN l_return_value;
118: END Is_Party_Rel_Comb_Exists;

Line 138: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

134: INTO l_dummy
135: FROM csi_i_parties
136: WHERE instance_party_id = p_Instance_party_id;
137: IF ( p_stack_err_msg = TRUE ) THEN
138: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
139: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
140: FND_MSG_PUB.Add;
141: END IF;
142: RETURN l_return_value;

Line 139: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

135: FROM csi_i_parties
136: WHERE instance_party_id = p_Instance_party_id;
137: IF ( p_stack_err_msg = TRUE ) THEN
138: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
139: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
140: FND_MSG_PUB.Add;
141: END IF;
142: RETURN l_return_value;
143: EXCEPTION

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

169: FETCH c1 INTO l_dummy;
170: IF c1%NOTFOUND THEN
171: l_return_value := FALSE;
172: IF ( p_stack_err_msg = TRUE ) THEN
173: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
174: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
175: FND_MSG_PUB.Add;
176: END IF;
177: END IF;

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

170: IF c1%NOTFOUND THEN
171: l_return_value := FALSE;
172: IF ( p_stack_err_msg = TRUE ) THEN
173: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
174: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
175: FND_MSG_PUB.Add;
176: END IF;
177: END IF;
178: CLOSE c1;

Line 210: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');

206: FETCH c1 INTO l_dummy;
207: IF c1%NOTFOUND THEN
208: l_return_value := FALSE;
209: IF ( p_stack_err_msg = TRUE ) THEN
210: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
211: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table);
212: FND_MSG_PUB.Add;
213: END IF;
214: END IF;

Line 211: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table);

207: IF c1%NOTFOUND THEN
208: l_return_value := FALSE;
209: IF ( p_stack_err_msg = TRUE ) THEN
210: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
211: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table);
212: FND_MSG_PUB.Add;
213: END IF;
214: END IF;
215: CLOSE c1;

Line 282: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');

278: AND ((end_date_active is null) OR (end_date_active >= sysdate));
279: ELSE
280: l_return_value := FALSE;
281: IF ( p_stack_err_msg = TRUE ) THEN
282: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
283: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table );
284: FND_MSG_PUB.Add;
285: END IF;
286: END IF;

Line 283: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table );

279: ELSE
280: l_return_value := FALSE;
281: IF ( p_stack_err_msg = TRUE ) THEN
282: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
283: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_source_table );
284: FND_MSG_PUB.Add;
285: END IF;
286: END IF;
287: RETURN l_return_value;

Line 292: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');

288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
290: l_return_value := FALSE;
291: IF ( p_stack_err_msg = TRUE ) THEN
292: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');
293: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
294: FND_MSG_PUB.Add;
295: END IF;
296: RETURN l_return_value;

Line 293: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

289: WHEN NO_DATA_FOUND THEN
290: l_return_value := FALSE;
291: IF ( p_stack_err_msg = TRUE ) THEN
292: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');
293: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
294: FND_MSG_PUB.Add;
295: END IF;
296: RETURN l_return_value;
297: END Is_Party_Valid;

Line 342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');

338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: l_return_value := FALSE;
341: IF ( p_stack_err_msg = TRUE ) THEN
342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
343: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rel_type_code);
344: FND_MSG_PUB.Add;
345: END IF;
346: RETURN l_return_value;

Line 343: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rel_type_code);

339: WHEN NO_DATA_FOUND THEN
340: l_return_value := FALSE;
341: IF ( p_stack_err_msg = TRUE ) THEN
342: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
343: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rel_type_code);
344: FND_MSG_PUB.Add;
345: END IF;
346: RETURN l_return_value;
347: END Is_Pty_Rel_type_Valid ;

Line 409: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');

405: FETCH C1 INTO l_party_id, l_party_source_table;
406: IF C1%NOTFOUND THEN
407: l_return_value := FALSE;
408: IF ( p_stack_err_msg = TRUE ) THEN
409: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
410: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
411: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
412: FND_MSG_PUB.Add;
413: END IF;

Line 410: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);

406: IF C1%NOTFOUND THEN
407: l_return_value := FALSE;
408: IF ( p_stack_err_msg = TRUE ) THEN
409: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
410: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
411: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
412: FND_MSG_PUB.Add;
413: END IF;
414: CLOSE C1;

Line 411: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);

407: l_return_value := FALSE;
408: IF ( p_stack_err_msg = TRUE ) THEN
409: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
410: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
411: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
412: FND_MSG_PUB.Add;
413: END IF;
414: CLOSE C1;
415: RETURN l_return_value;

Line 426: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');

422: FETCH C2 INTO l_dummy;
423: IF C2%NOTFOUND THEN
424: l_return_value := FALSE;
425: IF ( p_stack_err_msg = TRUE ) THEN
426: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
427: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
428: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
429: FND_MSG_PUB.Add;
430: END IF;

Line 427: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);

423: IF C2%NOTFOUND THEN
424: l_return_value := FALSE;
425: IF ( p_stack_err_msg = TRUE ) THEN
426: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
427: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
428: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
429: FND_MSG_PUB.Add;
430: END IF;
431: CLOSE C2;

Line 428: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);

424: l_return_value := FALSE;
425: IF ( p_stack_err_msg = TRUE ) THEN
426: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
427: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_contact_party_id);
428: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_contact_source_table);
429: FND_MSG_PUB.Add;
430: END IF;
431: CLOSE C2;
432: END IF;

Line 467: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');

463: BEGIN
464: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
465: IF p_start_date > p_end_date THEN
466: l_return_value := FALSE;
467: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
468: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
469: FND_MSG_PUB.Add;
470: RETURN l_return_value;
471: END IF;

Line 468: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

464: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
465: IF p_start_date > p_end_date THEN
466: l_return_value := FALSE;
467: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
468: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
469: FND_MSG_PUB.Add;
470: RETURN l_return_value;
471: END IF;
472: END IF;

Line 479: FND_MESSAGE.SET_NAME('CSI','CSI_API_INST_STARTDATE_NOT_EXT');

475: FETCH c1 INTO l_instance_start_date,l_instance_end_date;
476: IF c1%NOTFOUND THEN
477: l_return_value := FALSE;
478: IF ( p_stack_err_msg = TRUE ) THEN
479: FND_MESSAGE.SET_NAME('CSI','CSI_API_INST_STARTDATE_NOT_EXT');
480: FND_MSG_PUB.Add;
481: END IF;
482: CLOSE c1;
483: RETURN l_return_value;

Line 491: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');

487: OR ((l_instance_end_date IS NOT NULL) AND (p_start_date > l_instance_end_date))
488: OR (p_start_date > SYSDATE)) THEN
489: l_return_value := FALSE;
490: IF ( p_stack_err_msg = TRUE ) THEN
491: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
492: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
493: FND_MSG_PUB.Add;
494: END IF;
495: END IF;

Line 492: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

488: OR (p_start_date > SYSDATE)) THEN
489: l_return_value := FALSE;
490: IF ( p_stack_err_msg = TRUE ) THEN
491: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
492: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
493: FND_MSG_PUB.Add;
494: END IF;
495: END IF;
496: RETURN l_return_value;

Line 528: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');

524: BEGIN
525: IF p_end_date is NOT NULL THEN
526: IF p_end_date < sysdate THEN
527: l_return_value := FALSE;
528: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
529: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
530: FND_MSG_PUB.Add;
531: RETURN l_return_value;
532: END IF;

Line 529: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

525: IF p_end_date is NOT NULL THEN
526: IF p_end_date < sysdate THEN
527: l_return_value := FALSE;
528: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
529: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
530: FND_MSG_PUB.Add;
531: RETURN l_return_value;
532: END IF;
533: END IF;

Line 543: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');

539: IF ((p_end_date > l_instance_end_date) OR
540: (p_end_date < l_instance_start_date))THEN
541: l_return_value := FALSE;
542: IF ( p_stack_err_msg = TRUE ) THEN
543: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
544: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
545: FND_MSG_PUB.Add;
546: END IF;
547: END IF;

Line 544: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

540: (p_end_date < l_instance_start_date))THEN
541: l_return_value := FALSE;
542: IF ( p_stack_err_msg = TRUE ) THEN
543: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
544: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
545: FND_MSG_PUB.Add;
546: END IF;
547: END IF;
548: END IF;

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

584:
585: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
586: IF p_end_date < sysdate THEN
587: l_return_value := FALSE;
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
589: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
590: FND_MSG_PUB.Add;
591: RETURN l_return_value;
592: END IF;

Line 589: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

585: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
586: IF p_end_date < sysdate THEN
587: l_return_value := FALSE;
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
589: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
590: FND_MSG_PUB.Add;
591: RETURN l_return_value;
592: END IF;
593: END IF;

Line 619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');

615: IF ((p_end_date > l_instance_end_date) OR
616: (p_end_date < l_instance_start_date))THEN
617: l_return_value := FALSE;
618: IF ( p_stack_err_msg = TRUE ) THEN
619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
620: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
621: FND_MSG_PUB.Add;
622: END IF;
623: END IF;

Line 620: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

616: (p_end_date < l_instance_start_date))THEN
617: l_return_value := FALSE;
618: IF ( p_stack_err_msg = TRUE ) THEN
619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
620: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
621: FND_MSG_PUB.Add;
622: END IF;
623: END IF;
624: END IF;

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

668: AND t.transaction_id <>nvl(p_txn_id, -99999);
669:
670: IF l_transaction_date > p_end_date
671: THEN
672: fnd_message.set_name('CSI','CSI_HAS_TXNS');
673: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
674: fnd_msg_pub.add;
675: l_return_value := FALSE;
676: RETURN l_return_value;

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

669:
670: IF l_transaction_date > p_end_date
671: THEN
672: fnd_message.set_name('CSI','CSI_HAS_TXNS');
673: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
674: fnd_msg_pub.add;
675: l_return_value := FALSE;
676: RETURN l_return_value;
677: END IF;

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

688: AND t.transaction_id <> nvl(p_txn_id, -99999);
689:
690: IF l_transaction_date > p_end_date
691: THEN
692: fnd_message.set_name('CSI','CSI_HAS_TXNS');
693: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
694: fnd_msg_pub.add;
695: l_return_value := FALSE;
696: RETURN l_return_value;

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

689:
690: IF l_transaction_date > p_end_date
691: THEN
692: fnd_message.set_name('CSI','CSI_HAS_TXNS');
693: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
694: fnd_msg_pub.add;
695: l_return_value := FALSE;
696: RETURN l_return_value;
697: END IF;

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

710: AND t.transaction_id <> nvl(p_txn_id, -99999);
711:
712: IF l_transaction_date > p_end_date
713: THEN
714: fnd_message.set_name('CSI','CSI_HAS_TXNS');
715: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
716: fnd_msg_pub.add;
717: l_return_value := FALSE;
718: RETURN l_return_value;

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

711:
712: IF l_transaction_date > p_end_date
713: THEN
714: fnd_message.set_name('CSI','CSI_HAS_TXNS');
715: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
716: fnd_msg_pub.add;
717: l_return_value := FALSE;
718: RETURN l_return_value;
719: END IF;

Line 760: FND_MESSAGE.SET_NAME('CSI','CSI_API_OWNER_ALREADY_EXISTS');

756: OPEN C1;
757: FETCH C1 INTO l_dummy;
758: IF C1%FOUND THEN
759: IF ( p_stack_err_msg = TRUE ) THEN
760: FND_MESSAGE.SET_NAME('CSI','CSI_API_OWNER_ALREADY_EXISTS');
761: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
762: FND_MSG_PUB.Add;
763: END IF;
764: ELSE

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

757: FETCH C1 INTO l_dummy;
758: IF C1%FOUND THEN
759: IF ( p_stack_err_msg = TRUE ) THEN
760: FND_MESSAGE.SET_NAME('CSI','CSI_API_OWNER_ALREADY_EXISTS');
761: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
762: FND_MSG_PUB.Add;
763: END IF;
764: ELSE
765: l_return_value := FALSE;

Line 862: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');

858: and party_account_id = p_party_account_id
859: and relationship_type_code = p_relationship_type
860: and ((active_end_date is null) OR (active_end_date >= sysdate));
861: IF ( p_stack_err_msg = TRUE ) THEN
862: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');
863: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',p_instance_party_id ||', '
864: ||p_party_account_id ||', '||p_relationship_type);
865: FND_MSG_PUB.Add;
866: END IF;

Line 863: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',p_instance_party_id ||', '

859: and relationship_type_code = p_relationship_type
860: and ((active_end_date is null) OR (active_end_date >= sysdate));
861: IF ( p_stack_err_msg = TRUE ) THEN
862: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');
863: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',p_instance_party_id ||', '
864: ||p_party_account_id ||', '||p_relationship_type);
865: FND_MSG_PUB.Add;
866: END IF;
867: RETURN l_return_value;

Line 893: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');

889: FROM csi_ip_accounts
890: WHERE ip_account_id = p_ip_account_id
891: and ((active_end_date is null) OR (active_end_date >= sysdate));
892: IF ( p_stack_err_msg = TRUE ) THEN
893: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');
894: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_ip_account_id);
895: FND_MSG_PUB.Add;
896: END IF;
897: RETURN l_return_value;

Line 894: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_ip_account_id);

890: WHERE ip_account_id = p_ip_account_id
891: and ((active_end_date is null) OR (active_end_date >= sysdate));
892: IF ( p_stack_err_msg = TRUE ) THEN
893: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');
894: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_ip_account_id);
895: FND_MSG_PUB.Add;
896: END IF;
897: RETURN l_return_value;
898: EXCEPTION

Line 977: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

973: WHERE instance_party_id = p_Instance_party_id;
974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: l_return_value := FALSE;
977: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
978: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
979: FND_MSG_PUB.Add;
980: END;
981: -- End addition for bug 3550541

Line 978: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);

974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: l_return_value := FALSE;
977: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
978: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
979: FND_MSG_PUB.Add;
980: END;
981: -- End addition for bug 3550541
982: ELSE

Line 985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

981: -- End addition for bug 3550541
982: ELSE
983: l_return_value := FALSE;
984: IF p_stack_err_msg = TRUE THEN
985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
986: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
987: FND_MSG_PUB.Add;
988: END IF;
989: END IF;

Line 986: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);

982: ELSE
983: l_return_value := FALSE;
984: IF p_stack_err_msg = TRUE THEN
985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
986: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_INSTANCE_PARTY_ID);
987: FND_MSG_PUB.Add;
988: END IF;
989: END IF;
990: RETURN l_return_value;

Line 1054: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

1050: WHERE instance_party_id = p_instance_party_id;
1051: EXCEPTION
1052: WHEN NO_DATA_FOUND THEN
1053: l_return_value := FALSE;
1054: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1055: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1056: FND_MSG_PUB.Add;
1057: -- Errored, No need to proceed further
1058: RETURN l_return_value;

Line 1055: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

1051: EXCEPTION
1052: WHEN NO_DATA_FOUND THEN
1053: l_return_value := FALSE;
1054: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1055: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1056: FND_MSG_PUB.Add;
1057: -- Errored, No need to proceed further
1058: RETURN l_return_value;
1059: END;

Line 1064: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

1060: -- End addition for bug 3550541
1061: ELSE
1062: l_return_value := FALSE;
1063: IF ( p_stack_err_msg = TRUE ) THEN
1064: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1065: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: CLOSE C3;

Line 1065: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

1061: ELSE
1062: l_return_value := FALSE;
1063: IF ( p_stack_err_msg = TRUE ) THEN
1064: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1065: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: CLOSE C3;
1069: -- Errored, No need to proceed further

Line 1084: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');

1080: THEN
1081: l_return_value := FALSE;
1082: IF ( p_stack_err_msg = TRUE )
1083: THEN
1084: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
1085: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1086: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_id);
1087: FND_MSG_PUB.Add;
1088: END IF;

Line 1085: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);

1081: l_return_value := FALSE;
1082: IF ( p_stack_err_msg = TRUE )
1083: THEN
1084: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
1085: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1086: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_id);
1087: FND_MSG_PUB.Add;
1088: END IF;
1089: END IF;

Line 1086: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_id);

1082: IF ( p_stack_err_msg = TRUE )
1083: THEN
1084: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
1085: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1086: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_id);
1087: FND_MSG_PUB.Add;
1088: END IF;
1089: END IF;
1090: CLOSE c2;

Line 1099: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');

1095: THEN
1096: l_return_value := FALSE;
1097: IF ( p_stack_err_msg = TRUE )
1098: THEN
1099: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
1100: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1101: FND_MSG_PUB.Add;
1102: END IF;
1103: END IF;

Line 1100: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);

1096: l_return_value := FALSE;
1097: IF ( p_stack_err_msg = TRUE )
1098: THEN
1099: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
1100: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_party_account_id);
1101: FND_MSG_PUB.Add;
1102: END IF;
1103: END IF;
1104: CLOSE c1;

Line 1136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');

1132: FETCH c1 INTO l_dummy;
1133: IF c1%NOTFOUND THEN
1134: l_return_value := FALSE;
1135: IF ( p_stack_err_msg = TRUE ) THEN
1136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
1137: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_acct_rel_type_code);
1138: FND_MSG_PUB.Add;
1139: END IF;
1140: END IF;

Line 1137: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_acct_rel_type_code);

1133: IF c1%NOTFOUND THEN
1134: l_return_value := FALSE;
1135: IF ( p_stack_err_msg = TRUE ) THEN
1136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
1137: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_acct_rel_type_code);
1138: FND_MSG_PUB.Add;
1139: END IF;
1140: END IF;
1141: CLOSE c1;

Line 1171: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');

1167: IF (p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE) THEN
1168:
1169: IF p_start_date > p_end_date THEN
1170: l_return_value := FALSE;
1171: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1172: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1173: FND_MSG_PUB.Add;
1174: RETURN l_return_value;
1175: END IF;

Line 1172: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

1168:
1169: IF p_start_date > p_end_date THEN
1170: l_return_value := FALSE;
1171: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1172: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1173: FND_MSG_PUB.Add;
1174: RETURN l_return_value;
1175: END IF;
1176: END IF;

Line 1183: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PTY_START_DATE');

1179: FETCH c1 INTO l_inst_party_start_date;
1180: IF c1%NOTFOUND THEN
1181: l_return_value := FALSE;
1182: IF ( p_stack_err_msg = TRUE ) THEN
1183: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PTY_START_DATE');
1184: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1185: FND_MSG_PUB.Add;
1186: END IF;
1187: CLOSE c1;

Line 1184: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

1180: IF c1%NOTFOUND THEN
1181: l_return_value := FALSE;
1182: IF ( p_stack_err_msg = TRUE ) THEN
1183: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PTY_START_DATE');
1184: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1185: FND_MSG_PUB.Add;
1186: END IF;
1187: CLOSE c1;
1188: RETURN l_return_value;

Line 1198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');

1194: IF (p_start_date < l_inst_party_start_date)
1195: OR (p_start_date > SYSDATE) THEN
1196: l_return_value := FALSE;
1197: IF ( p_stack_err_msg = TRUE ) THEN
1198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1199: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: END IF;

Line 1199: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

1195: OR (p_start_date > SYSDATE) THEN
1196: l_return_value := FALSE;
1197: IF ( p_stack_err_msg = TRUE ) THEN
1198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
1199: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);
1200: FND_MSG_PUB.Add;
1201: END IF;
1202: END IF;
1203: RETURN l_return_value;

Line 1234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');

1230: BEGIN
1231: IF p_end_date is NOT NULL THEN
1232: IF p_end_date < sysdate THEN
1233: l_return_value := FALSE;
1234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1235: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1236: FND_MSG_PUB.Add;
1237: RETURN l_return_value;
1238: END IF;

Line 1235: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

1231: IF p_end_date is NOT NULL THEN
1232: IF p_end_date < sysdate THEN
1233: l_return_value := FALSE;
1234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1235: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1236: FND_MSG_PUB.Add;
1237: RETURN l_return_value;
1238: END IF;
1239: END IF;

Line 1248: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');

1244: IF l_instance_end_date is NOT NULL THEN
1245: IF p_end_date > l_instance_end_date THEN
1246: l_return_value := FALSE;
1247: IF ( p_stack_err_msg = TRUE ) THEN
1248: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1249: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1250: FND_MSG_PUB.Add;
1251: END IF;
1252: END IF;

Line 1249: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

1245: IF p_end_date > l_instance_end_date THEN
1246: l_return_value := FALSE;
1247: IF ( p_stack_err_msg = TRUE ) THEN
1248: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1249: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1250: FND_MSG_PUB.Add;
1251: END IF;
1252: END IF;
1253: END IF;

Line 1293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');

1289: THEN
1290: IF p_end_date < sysdate
1291: THEN
1292: l_return_value := FALSE;
1293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1294: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1295: FND_MSG_PUB.Add;
1296: l_return_value := FALSE;
1297: RETURN l_return_value;

Line 1294: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

1290: IF p_end_date < sysdate
1291: THEN
1292: l_return_value := FALSE;
1293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1294: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1295: FND_MSG_PUB.Add;
1296: l_return_value := FALSE;
1297: RETURN l_return_value;
1298: END IF;

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

1311: AND t.transaction_id <> nvl(p_txn_id, -99999);
1312:
1313: IF l_transaction_date > p_end_date
1314: THEN
1315: fnd_message.set_name('CSI','CSI_HAS_TXNS');
1316: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
1317: fnd_msg_pub.add;
1318: l_return_value := FALSE;
1319: RETURN l_return_value;

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

1312:
1313: IF l_transaction_date > p_end_date
1314: THEN
1315: fnd_message.set_name('CSI','CSI_HAS_TXNS');
1316: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
1317: fnd_msg_pub.add;
1318: l_return_value := FALSE;
1319: RETURN l_return_value;
1320: END IF;

Line 1332: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');

1328: IF l_instance_end_date is NOT NULL THEN
1329: IF p_end_date > l_instance_end_date THEN
1330: l_return_value := FALSE;
1331: IF ( p_stack_err_msg = TRUE ) THEN
1332: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1333: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1334: FND_MSG_PUB.Add;
1335: END IF;
1336: END IF;

Line 1333: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

1329: IF p_end_date > l_instance_end_date THEN
1330: l_return_value := FALSE;
1331: IF ( p_stack_err_msg = TRUE ) THEN
1332: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
1333: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);
1334: FND_MSG_PUB.Add;
1335: END IF;
1336: END IF;
1337: END IF;

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

1403: FETCH c1 INTO l_instance_start_date,l_instance_end_date;
1404: IF c1%NOTFOUND THEN
1405: l_return_value := FALSE;
1406: IF ( p_stack_err_msg = TRUE ) THEN
1407: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
1408: FND_MESSAGE.SET_TOKEN('ENTITY','VERSION LABEL');
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: CLOSE c1;

Line 1408: FND_MESSAGE.SET_TOKEN('ENTITY','VERSION LABEL');

1404: IF c1%NOTFOUND THEN
1405: l_return_value := FALSE;
1406: IF ( p_stack_err_msg = TRUE ) THEN
1407: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
1408: FND_MESSAGE.SET_TOKEN('ENTITY','VERSION LABEL');
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: CLOSE c1;
1412: RETURN l_return_value;

Line 1419: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TIMESTAMP');

1415: IF ((p_datetimestamp < l_instance_start_date) AND
1416: ( p_datetimestamp > l_instance_end_date)) THEN
1417: l_return_value := FALSE;
1418: IF ( p_stack_err_msg = TRUE ) THEN
1419: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TIMESTAMP');
1420: FND_MSG_PUB.Add;
1421: END IF;
1422: END IF;
1423: RETURN l_return_value;

Line 1465: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VER_LABEL_ID');

1461: FROM csi_i_version_labels
1462: WHERE version_label_id = p_version_label_id
1463: and ((active_end_date is null) OR (active_end_date >= sysdate));
1464: IF ( p_stack_err_msg = TRUE ) THEN
1465: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VER_LABEL_ID');
1466: FND_MESSAGE.SET_TOKEN('VERSION_LABEL_ID',p_version_label_id);
1467: FND_MSG_PUB.Add;
1468: END IF;
1469: RETURN l_return_value;

Line 1466: FND_MESSAGE.SET_TOKEN('VERSION_LABEL_ID',p_version_label_id);

1462: WHERE version_label_id = p_version_label_id
1463: and ((active_end_date is null) OR (active_end_date >= sysdate));
1464: IF ( p_stack_err_msg = TRUE ) THEN
1465: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VER_LABEL_ID');
1466: FND_MESSAGE.SET_TOKEN('VERSION_LABEL_ID',p_version_label_id);
1467: FND_MSG_PUB.Add;
1468: END IF;
1469: RETURN l_return_value;
1470: EXCEPTION

Line 1536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

1532: FROM csi_i_assets
1533: WHERE instance_asset_id = p_instance_asset_id ;
1534:
1535: IF ( p_stack_err_msg = TRUE ) THEN
1536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
1537: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
1538: FND_MSG_PUB.Add;
1539: END IF;
1540: RETURN l_return_value;

Line 1537: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);

1533: WHERE instance_asset_id = p_instance_asset_id ;
1534:
1535: IF ( p_stack_err_msg = TRUE ) THEN
1536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
1537: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
1538: FND_MSG_PUB.Add;
1539: END IF;
1540: RETURN l_return_value;
1541: EXCEPTION

Line 1575: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');

1571: FETCH c1 INTO l_dummy;
1572: IF c1%NOTFOUND THEN
1573: l_return_value := FALSE;
1574: IF ( p_stack_err_msg = TRUE ) THEN
1575: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1576: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
1577: FND_MSG_PUB.Add;
1578: END IF;
1579: END IF;

Line 1576: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);

1572: IF c1%NOTFOUND THEN
1573: l_return_value := FALSE;
1574: IF ( p_stack_err_msg = TRUE ) THEN
1575: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1576: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
1577: FND_MSG_PUB.Add;
1578: END IF;
1579: END IF;
1580: CLOSE c1;

Line 1600: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');

1596: l_return_status BOOLEAN := TRUE;
1597: BEGIN
1598: IF (NVL(p_asset_quantity,-1) <= 0 ) THEN
1599: l_return_status := FALSE;
1600: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');
1601: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);
1602: FND_MSG_PUB.Add;
1603: END IF;
1604:

Line 1601: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);

1597: BEGIN
1598: IF (NVL(p_asset_quantity,-1) <= 0 ) THEN
1599: l_return_status := FALSE;
1600: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');
1601: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);
1602: FND_MSG_PUB.Add;
1603: END IF;
1604:
1605: RETURN l_return_status;

Line 1653: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');

1649: EXCEPTION
1650: WHEN NO_DATA_FOUND THEN
1651: l_return_value := FALSE;
1652: IF ( p_stack_err_msg = TRUE ) THEN
1653: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1654: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);
1655: FND_MSG_PUB.Add;
1656: END IF;
1657: RETURN l_return_value;

Line 1654: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);

1650: WHEN NO_DATA_FOUND THEN
1651: l_return_value := FALSE;
1652: IF ( p_stack_err_msg = TRUE ) THEN
1653: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1654: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);
1655: FND_MSG_PUB.Add;
1656: END IF;
1657: RETURN l_return_value;
1658: END Is_Asset_Comb_Valid;

Line 1685: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');

1681: EXCEPTION
1682: WHEN NO_DATA_FOUND THEN
1683: l_return_value := FALSE;
1684: IF ( p_stack_err_msg = TRUE ) THEN
1685: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1686: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);
1687: FND_MSG_PUB.Add;
1688: END IF;
1689: RETURN l_return_value;

Line 1686: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);

1682: WHEN NO_DATA_FOUND THEN
1683: l_return_value := FALSE;
1684: IF ( p_stack_err_msg = TRUE ) THEN
1685: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1686: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);
1687: FND_MSG_PUB.Add;
1688: END IF;
1689: RETURN l_return_value;
1690: END Is_Asset_Location_Valid;

Line 1766: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');

1762: EXCEPTION
1763: WHEN NO_DATA_FOUND THEN
1764: l_return_value := FALSE;
1765: IF ( p_stack_err_msg = TRUE ) THEN
1766: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');
1767: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_bill_to_add_id );
1768: FND_MSG_PUB.Add;
1769: END IF;
1770: RETURN l_return_value;

Line 1767: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_bill_to_add_id );

1763: WHEN NO_DATA_FOUND THEN
1764: l_return_value := FALSE;
1765: IF ( p_stack_err_msg = TRUE ) THEN
1766: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');
1767: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_bill_to_add_id );
1768: FND_MSG_PUB.Add;
1769: END IF;
1770: RETURN l_return_value;
1771:

Line 1798: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');

1794: EXCEPTION
1795: WHEN NO_DATA_FOUND THEN
1796: l_return_value := FALSE;
1797: IF ( p_stack_err_msg = TRUE ) THEN
1798: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
1799: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_ship_to_add_id );
1800: FND_MSG_PUB.Add;
1801: END IF;
1802: RETURN l_return_value;

Line 1799: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_ship_to_add_id );

1795: WHEN NO_DATA_FOUND THEN
1796: l_return_value := FALSE;
1797: IF ( p_stack_err_msg = TRUE ) THEN
1798: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
1799: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_ship_to_add_id );
1800: FND_MSG_PUB.Add;
1801: END IF;
1802: RETURN l_return_value;
1803:

Line 1833: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');

1829: WHERE instance_party_id = p_instance_party_id
1830: and relationship_type_code = p_relationship_type
1831: and ((active_end_date is null) OR (active_end_date > sysdate));
1832: IF ( p_stack_err_msg = TRUE ) THEN
1833: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');
1834: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type);
1835: FND_MSG_PUB.Add;
1836: END IF;
1837:

Line 1834: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type);

1830: and relationship_type_code = p_relationship_type
1831: and ((active_end_date is null) OR (active_end_date > sysdate));
1832: IF ( p_stack_err_msg = TRUE ) THEN
1833: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');
1834: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_relationship_type);
1835: FND_MSG_PUB.Add;
1836: END IF;
1837:
1838: -- Vaidate if owner accounts are created, the party is also an owner

Line 1845: FND_MESSAGE.SET_NAME('CSI','CSI_OWNER_ACCT_REQ_OWNER_PTY');

1841:
1842: IF ((p_relationship_type = 'OWNER')
1843: AND (l_party_relation <> 'OWNER')) THEN
1844: IF ( p_stack_err_msg = TRUE ) THEN
1845: FND_MESSAGE.SET_NAME('CSI','CSI_OWNER_ACCT_REQ_OWNER_PTY');
1846: FND_MSG_PUB.Add;
1847: END IF;
1848: END IF;
1849: RETURN l_return_value;

Line 1879: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');

1875: AND contact_flag = 'Y';
1876:
1877: l_return_value := FALSE;
1878: IF ( p_stack_err_msg = TRUE ) THEN
1879: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');
1880: FND_MSG_PUB.Add;
1881: END IF;
1882: RETURN l_return_value;
1883: EXCEPTION

Line 1890: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');

1886: RETURN l_return_value;
1887: WHEN TOO_MANY_ROWS THEN
1888: l_return_value := FALSE;
1889: IF ( p_stack_err_msg = TRUE ) THEN
1890: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_CONTACT_EXISTS');
1891: FND_MSG_PUB.Add;
1892: END IF;
1893: RETURN l_return_value;
1894: END Is_Party_Contact_Exists;

Line 1917: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

1913: RETURN l_rel_type_code;
1914: EXCEPTION
1915: WHEN NO_DATA_FOUND THEN
1916: IF ( p_stack_err_msg = TRUE ) THEN
1917: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1918: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1919: FND_MSG_PUB.Add;
1920: END IF;
1921: RETURN NULL;

Line 1918: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

1914: EXCEPTION
1915: WHEN NO_DATA_FOUND THEN
1916: IF ( p_stack_err_msg = TRUE ) THEN
1917: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
1918: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
1919: FND_MSG_PUB.Add;
1920: END IF;
1921: RETURN NULL;
1922: END Get_Party_relation;

Line 2001: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

1997: RETURN TRUE;
1998: EXCEPTION
1999: WHEN NO_DATA_FOUND THEN
2000: IF ( p_stack_err_msg = TRUE ) THEN
2001: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
2002: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
2003: FND_MSG_PUB.Add;
2004: END IF;
2005: RETURN FALSE;

Line 2002: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

1998: EXCEPTION
1999: WHEN NO_DATA_FOUND THEN
2000: IF ( p_stack_err_msg = TRUE ) THEN
2001: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
2002: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);
2003: FND_MSG_PUB.Add;
2004: END IF;
2005: RETURN FALSE;
2006: END Get_Party_Record;

Line 2411: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');

2407: OPEN C1;
2408: FETCH C1 INTO l_dummy;
2409: IF C1%FOUND THEN
2410: IF ( p_stack_err_msg = TRUE ) THEN
2411: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2412: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2413: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2414: FND_MSG_PUB.Add;
2415: END IF;

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

2408: FETCH C1 INTO l_dummy;
2409: IF C1%FOUND THEN
2410: IF ( p_stack_err_msg = TRUE ) THEN
2411: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2412: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2413: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2414: FND_MSG_PUB.Add;
2415: END IF;
2416: ELSE

Line 2413: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);

2409: IF C1%FOUND THEN
2410: IF ( p_stack_err_msg = TRUE ) THEN
2411: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2412: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2413: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2414: FND_MSG_PUB.Add;
2415: END IF;
2416: ELSE
2417: l_return_value := FALSE;

Line 2463: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');

2459: OPEN C1;
2460: FETCH C1 INTO l_dummy;
2461: IF C1%FOUND THEN
2462: IF ( p_stack_err_msg = TRUE ) THEN
2463: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2464: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2465: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2466: FND_MSG_PUB.Add;
2467: END IF;

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

2460: FETCH C1 INTO l_dummy;
2461: IF C1%FOUND THEN
2462: IF ( p_stack_err_msg = TRUE ) THEN
2463: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2464: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2465: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2466: FND_MSG_PUB.Add;
2467: END IF;
2468: ELSE

Line 2465: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);

2461: IF C1%FOUND THEN
2462: IF ( p_stack_err_msg = TRUE ) THEN
2463: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2464: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2465: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2466: FND_MSG_PUB.Add;
2467: END IF;
2468: ELSE
2469: l_return_value := FALSE;

Line 2511: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');

2507: OPEN C1;
2508: FETCH C1 INTO l_dummy;
2509: IF C1%FOUND THEN
2510: IF ( p_stack_err_msg = TRUE ) THEN
2511: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2512: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2513: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2514: FND_MSG_PUB.Add;
2515: END IF;

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

2508: FETCH C1 INTO l_dummy;
2509: IF C1%FOUND THEN
2510: IF ( p_stack_err_msg = TRUE ) THEN
2511: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2512: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2513: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2514: FND_MSG_PUB.Add;
2515: END IF;
2516: ELSE

Line 2513: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);

2509: IF C1%FOUND THEN
2510: IF ( p_stack_err_msg = TRUE ) THEN
2511: FND_MESSAGE.SET_NAME('CSI','CSI_API_PREFERRED_PTY_EXISTS');
2512: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2513: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2514: FND_MSG_PUB.Add;
2515: END IF;
2516: ELSE
2517: l_return_value := FALSE;

Line 2561: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');

2557: OPEN C1;
2558: FETCH C1 INTO l_dummy;
2559: IF C1%FOUND THEN
2560: IF ( p_stack_err_msg = TRUE ) THEN
2561: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2562: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2563: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2564: FND_MSG_PUB.Add;
2565: END IF;

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

2558: FETCH C1 INTO l_dummy;
2559: IF C1%FOUND THEN
2560: IF ( p_stack_err_msg = TRUE ) THEN
2561: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2562: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2563: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2564: FND_MSG_PUB.Add;
2565: END IF;
2566: ELSE

Line 2563: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);

2559: IF C1%FOUND THEN
2560: IF ( p_stack_err_msg = TRUE ) THEN
2561: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
2562: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
2563: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',p_relationship_type);
2564: FND_MSG_PUB.Add;
2565: END IF;
2566: ELSE
2567: l_return_value := FALSE;