DBA Data[Home] [Help]

APPS.CS_SRCONTACT_PKG dependencies on FND_MESSAGE

Line 198: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_CONTACT_PARTY');

194: THEN
195: x_return_status := FND_API.g_ret_sts_error;
196: IF l_dup_role = 'CONTACT'
197: THEN
198: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_CONTACT_PARTY');
199: ELSE
200: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_ASSOC_PARTY');
201: END IF;
202: FND_MESSAGE.set_token ('API_NAME','CS_SRCONTACT_PKG.check_duplicates');

Line 200: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_ASSOC_PARTY');

196: IF l_dup_role = 'CONTACT'
197: THEN
198: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_CONTACT_PARTY');
199: ELSE
200: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_ASSOC_PARTY');
201: END IF;
202: FND_MESSAGE.set_token ('API_NAME','CS_SRCONTACT_PKG.check_duplicates');
203: FND_MSG_PUB.ADD;
204: END IF;

Line 202: FND_MESSAGE.set_token ('API_NAME','CS_SRCONTACT_PKG.check_duplicates');

198: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_CONTACT_PARTY');
199: ELSE
200: FND_MESSAGE.set_name ('CS', 'CS_SR_DUP_ASSOC_PARTY');
201: END IF;
202: FND_MESSAGE.set_token ('API_NAME','CS_SRCONTACT_PKG.check_duplicates');
203: FND_MSG_PUB.ADD;
204: END IF;
205: END IF;
206: EXCEPTION

Line 210: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');

206: EXCEPTION
207: WHEN OTHERS
208: THEN
209: x_return_status := FND_API.g_ret_sts_error;
210: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
211: FND_MESSAGE.set_token('P_TEXT','CS_SRCONTACT_PKG.check_duplicates:'||'-'||SQLERRM);
212: FND_MSG_PUB.ADD;
213: END check_duplicates;
214: --------------------------------------------------------------------------------

Line 211: FND_MESSAGE.set_token('P_TEXT','CS_SRCONTACT_PKG.check_duplicates:'||'-'||SQLERRM);

207: WHEN OTHERS
208: THEN
209: x_return_status := FND_API.g_ret_sts_error;
210: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
211: FND_MESSAGE.set_token('P_TEXT','CS_SRCONTACT_PKG.check_duplicates:'||'-'||SQLERRM);
212: FND_MSG_PUB.ADD;
213: END check_duplicates;
214: --------------------------------------------------------------------------------
215: -- Function Name : contact_role_count

Line 419: FND_MESSAGE.set_name ('CS','CS_SR_CP_CONTACT_TYPE_UPD_NA');

415: THEN
416: -- check contact type update
417: IF p_new_contact_rec.contact_type <> p_old_contact_rec.contact_type
418: THEN
419: FND_MESSAGE.set_name ('CS','CS_SR_CP_CONTACT_TYPE_UPD_NA');
420: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
421: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.CONTACT_TYPE');
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;

Line 420: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');

416: -- check contact type update
417: IF p_new_contact_rec.contact_type <> p_old_contact_rec.contact_type
418: THEN
419: FND_MESSAGE.set_name ('CS','CS_SR_CP_CONTACT_TYPE_UPD_NA');
420: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
421: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.CONTACT_TYPE');
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: -- check party_id update

Line 427: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ID_UPD_NA');

423: END IF;
424: -- check party_id update
425: IF p_new_contact_rec.party_id <> p_old_contact_rec.party_id
426: THEN
427: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ID_UPD_NA');
428: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
429: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID');
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;

Line 428: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');

424: -- check party_id update
425: IF p_new_contact_rec.party_id <> p_old_contact_rec.party_id
426: THEN
427: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ID_UPD_NA');
428: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
429: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID');
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432: -- check party_role_code update

Line 435: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ROLE_UPD_NA');

431: END IF;
432: -- check party_role_code update
433: IF p_new_contact_rec.party_role_code <> p_old_contact_rec.party_role_code
434: THEN
435: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ROLE_UPD_NA');
436: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
437: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ROLE_CODE');
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;

Line 436: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');

432: -- check party_role_code update
433: IF p_new_contact_rec.party_role_code <> p_old_contact_rec.party_role_code
434: THEN
435: FND_MESSAGE.set_name ('CS','CS_SR_CP_PARTY_ROLE_UPD_NA');
436: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.validate_contact');
437: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ROLE_CODE');
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF; -- p_mode = 'UPDATE'

Line 533: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_NE');

529: , x_return_status => x_return_status
530: );
531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_NE');
534: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
535: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
536: FND_MSG_PUB.add_detail
537: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

Line 534: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

530: );
531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_NE');
534: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
535: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
536: FND_MSG_PUB.add_detail
537: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
538: );

Line 535: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);

531: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
532: THEN
533: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_NE');
534: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
535: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
536: FND_MSG_PUB.add_detail
537: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
538: );
539: RAISE FND_API.G_EXC_ERROR;

Line 543: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_INACTIVE');

539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: IF l_status <> 'A'
542: THEN
543: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_INACTIVE');
544: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
545: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
546: FND_MSG_PUB.add_detail
547: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

Line 544: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

540: END IF;
541: IF l_status <> 'A'
542: THEN
543: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_INACTIVE');
544: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
545: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
546: FND_MSG_PUB.add_detail
547: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
548: );

Line 545: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);

541: IF l_status <> 'A'
542: THEN
543: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTY_INACTIVE');
544: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
545: FND_MESSAGE.set_token('PARTY_ID',p_new_contact_rec.party_id);
546: FND_MSG_PUB.add_detail
547: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
548: );
549: RAISE FND_API.G_EXC_ERROR;

Line 553: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTYTYPE_MISMATCH');

549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551: IF l_party_type <> p_new_contact_rec.contact_type
552: THEN
553: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTYTYPE_MISMATCH');
554: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
555: FND_MESSAGE.set_token('CONTACT_TYPE',l_party_type);
556: FND_MSG_PUB.add_detail
557: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

Line 554: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

550: END IF;
551: IF l_party_type <> p_new_contact_rec.contact_type
552: THEN
553: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTYTYPE_MISMATCH');
554: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
555: FND_MESSAGE.set_token('CONTACT_TYPE',l_party_type);
556: FND_MSG_PUB.add_detail
557: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
558: );

Line 555: FND_MESSAGE.set_token('CONTACT_TYPE',l_party_type);

551: IF l_party_type <> p_new_contact_rec.contact_type
552: THEN
553: FND_MESSAGE.set_name('CS','CS_SR_ASSOC_PARTYTYPE_MISMATCH');
554: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
555: FND_MESSAGE.set_token('CONTACT_TYPE',l_party_type);
556: FND_MSG_PUB.add_detail
557: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'
558: );
559: RAISE FND_API.G_EXC_ERROR;

Line 669: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_CONTACT_ROLE');

665: -- validate primary flag and party role combination
666: IF p_new_contact_rec.primary_flag = 'Y' AND
667: p_new_contact_rec.party_role_code <> 'CONTACT'
668: THEN
669: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_CONTACT_ROLE');
670: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
671: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;

Line 670: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

666: IF p_new_contact_rec.primary_flag = 'Y' AND
667: p_new_contact_rec.party_role_code <> 'CONTACT'
668: THEN
669: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_CONTACT_ROLE');
670: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
671: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: --Added by Lakshmi for 12.1.2 project,Added another 'AND' condition ,

Line 680: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_END_DATED');

676: IF p_new_contact_rec.primary_flag = 'Y' AND
677: p_new_contact_rec.end_date_active IS NOT NULL AND
678: FND_PROFILE.value('CS_SR_CONTACT_MANDATORY') = 'Y'
679: THEN
680: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_END_DATED');
681: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
682: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;

Line 681: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

677: p_new_contact_rec.end_date_active IS NOT NULL AND
678: FND_PROFILE.value('CS_SR_CONTACT_MANDATORY') = 'Y'
679: THEN
680: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_END_DATED');
681: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
682: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685: --

Line 689: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_FUTURE_DATED');

685: --
686: IF p_new_contact_rec.primary_flag = 'Y' AND
687: p_new_contact_rec.start_date_active > l_today
688: THEN
689: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_FUTURE_DATED');
690: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
691: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;

Line 690: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

686: IF p_new_contact_rec.primary_flag = 'Y' AND
687: p_new_contact_rec.start_date_active > l_today
688: THEN
689: FND_MESSAGE.set_name('CS','CS_SR_PRIMARY_FUTURE_DATED');
690: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
691: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');
692: RAISE FND_API.G_EXC_ERROR;
693: END IF;
694: -- validate Start and End date

Line 700: FND_MESSAGE.set_name('CS','CS_SR_CP_ENDDT_LT_STARTDT');

696: IF p_new_contact_rec.end_date_active IS NOT NULL AND
697: p_new_contact_rec.start_date_active IS NOT NULL AND
698: p_new_contact_rec.end_date_active < p_new_contact_rec.start_date_active
699: THEN
700: FND_MESSAGE.set_name('CS','CS_SR_CP_ENDDT_LT_STARTDT');
701: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
702: FND_MESSAGE.set_token('END_DT',to_char(p_new_contact_rec.end_date_active));
703: FND_MESSAGE.set_token('START_DT',to_char(p_new_contact_rec.start_date_active));
704: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.END_DATE_ACITVE');

Line 701: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');

697: p_new_contact_rec.start_date_active IS NOT NULL AND
698: p_new_contact_rec.end_date_active < p_new_contact_rec.start_date_active
699: THEN
700: FND_MESSAGE.set_name('CS','CS_SR_CP_ENDDT_LT_STARTDT');
701: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
702: FND_MESSAGE.set_token('END_DT',to_char(p_new_contact_rec.end_date_active));
703: FND_MESSAGE.set_token('START_DT',to_char(p_new_contact_rec.start_date_active));
704: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.END_DATE_ACITVE');
705: RAISE FND_API.G_EXC_ERROR;

Line 702: FND_MESSAGE.set_token('END_DT',to_char(p_new_contact_rec.end_date_active));

698: p_new_contact_rec.end_date_active < p_new_contact_rec.start_date_active
699: THEN
700: FND_MESSAGE.set_name('CS','CS_SR_CP_ENDDT_LT_STARTDT');
701: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
702: FND_MESSAGE.set_token('END_DT',to_char(p_new_contact_rec.end_date_active));
703: FND_MESSAGE.set_token('START_DT',to_char(p_new_contact_rec.start_date_active));
704: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.END_DATE_ACITVE');
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;

Line 703: FND_MESSAGE.set_token('START_DT',to_char(p_new_contact_rec.start_date_active));

699: THEN
700: FND_MESSAGE.set_name('CS','CS_SR_CP_ENDDT_LT_STARTDT');
701: FND_MESSAGE.set_token('API_NAME','cs_srcontact_pkg.validate_contact');
702: FND_MESSAGE.set_token('END_DT',to_char(p_new_contact_rec.end_date_active));
703: FND_MESSAGE.set_token('START_DT',to_char(p_new_contact_rec.start_date_active));
704: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.END_DATE_ACITVE');
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707:

Line 818: FND_MESSAGE.set_name('CS', 'CS_SR_CP_DO_NOT_BELONGS');

814: THEN
815: -- in case of insert, p_incident_id will be null
816: IF NVL(p_incident_id,-1) <> l_incident_id
817: THEN
818: FND_MESSAGE.set_name('CS', 'CS_SR_CP_DO_NOT_BELONGS');
819: FND_MESSAGE.set_token
820: ( 'CP_ID'
821: , TO_CHAR(x_new_contact_tbl(i).sr_contact_point_id)
822: );

Line 819: FND_MESSAGE.set_token

815: -- in case of insert, p_incident_id will be null
816: IF NVL(p_incident_id,-1) <> l_incident_id
817: THEN
818: FND_MESSAGE.set_name('CS', 'CS_SR_CP_DO_NOT_BELONGS');
819: FND_MESSAGE.set_token
820: ( 'CP_ID'
821: , TO_CHAR(x_new_contact_tbl(i).sr_contact_point_id)
822: );
823: FND_MESSAGE.set_token

Line 823: FND_MESSAGE.set_token

819: FND_MESSAGE.set_token
820: ( 'CP_ID'
821: , TO_CHAR(x_new_contact_tbl(i).sr_contact_point_id)
822: );
823: FND_MESSAGE.set_token
824: ( 'INC_ID'
825: , TO_CHAR(p_incident_id)
826: );
827: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.SR_CONTACT_POINT_ID');

Line 1318: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');

1314: THEN
1315: IF NVL(l_new_contact_tbl(loop_index).end_date_active, l_today) >= l_today OR
1316: contact_role_count(p_incident_id) > 1
1317: THEN
1318: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1319: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1320: FND_MESSAGE.set_token
1321: ( 'INC_ID'
1322: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)

Line 1319: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');

1315: IF NVL(l_new_contact_tbl(loop_index).end_date_active, l_today) >= l_today OR
1316: contact_role_count(p_incident_id) > 1
1317: THEN
1318: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1319: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1320: FND_MESSAGE.set_token
1321: ( 'INC_ID'
1322: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)
1323: );

Line 1320: FND_MESSAGE.set_token

1316: contact_role_count(p_incident_id) > 1
1317: THEN
1318: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1319: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1320: FND_MESSAGE.set_token
1321: ( 'INC_ID'
1322: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)
1323: );
1324: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');

Line 1414: FND_MESSAGE.set_name ('CS','CS_SR_CONTACT_POINT_MANDATORY');

1410: and r.directional_flag = 'F';
1411: END IF;
1412: IF l_prm_contact_mand = 'Y'
1413: THEN
1414: FND_MESSAGE.set_name ('CS','CS_SR_CONTACT_POINT_MANDATORY');
1415: ELSIF l_inact_prm_contact = 'Y'
1416: THEN
1417: FND_MESSAGE.set_name ('CS','CS_SR_INACT_PRIMARY_CONTACT');
1418: END IF;

Line 1417: FND_MESSAGE.set_name ('CS','CS_SR_INACT_PRIMARY_CONTACT');

1413: THEN
1414: FND_MESSAGE.set_name ('CS','CS_SR_CONTACT_POINT_MANDATORY');
1415: ELSIF l_inact_prm_contact = 'Y'
1416: THEN
1417: FND_MESSAGE.set_name ('CS','CS_SR_INACT_PRIMARY_CONTACT');
1418: END IF;
1419:
1420:
1421: FND_MESSAGE.set_token ('CONTACT_LAST_NAME',l_last_name);

Line 1421: FND_MESSAGE.set_token ('CONTACT_LAST_NAME',l_last_name);

1417: FND_MESSAGE.set_name ('CS','CS_SR_INACT_PRIMARY_CONTACT');
1418: END IF;
1419:
1420:
1421: FND_MESSAGE.set_token ('CONTACT_LAST_NAME',l_last_name);
1422: FND_MESSAGE.set_token ('CONTACT_FIRST_NAME',l_first_name);
1423: FND_MSG_PUB.add;
1424: RAISE FND_API.G_EXC_ERROR;
1425: END IF;

Line 1422: FND_MESSAGE.set_token ('CONTACT_FIRST_NAME',l_first_name);

1418: END IF;
1419:
1420:
1421: FND_MESSAGE.set_token ('CONTACT_LAST_NAME',l_last_name);
1422: FND_MESSAGE.set_token ('CONTACT_FIRST_NAME',l_first_name);
1423: FND_MSG_PUB.add;
1424: RAISE FND_API.G_EXC_ERROR;
1425: END IF;
1426: