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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 817: FND_MESSAGE.set_token

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

Line 821: FND_MESSAGE.set_token

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

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

1292: THEN
1293: IF NVL(l_new_contact_tbl(loop_index).end_date_active, l_today) >= l_today OR
1294: contact_role_count(p_incident_id) > 1
1295: THEN
1296: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1297: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1298: FND_MESSAGE.set_token
1299: ( 'INC_ID'
1300: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)

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

1293: IF NVL(l_new_contact_tbl(loop_index).end_date_active, l_today) >= l_today OR
1294: contact_role_count(p_incident_id) > 1
1295: THEN
1296: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1297: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1298: FND_MESSAGE.set_token
1299: ( 'INC_ID'
1300: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)
1301: );

Line 1298: FND_MESSAGE.set_token

1294: contact_role_count(p_incident_id) > 1
1295: THEN
1296: FND_MESSAGE.set_name('CS', 'CS_SR_NO_PRIMARY_LEFT');
1297: FND_MESSAGE.set_token ('API_NAME','cs_srcontact_pkg.process');
1298: FND_MESSAGE.set_token
1299: ( 'INC_ID'
1300: , TO_CHAR(l_new_contact_tbl(loop_index).sr_contact_point_id)
1301: );
1302: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');