DBA Data[Home] [Help]

APPS.CS_SRCONTACT_PKG dependencies on FND_MSG_PUB

Line 203: FND_MSG_PUB.ADD;

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
207: WHEN OTHERS

Line 212: FND_MSG_PUB.ADD;

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

Line 421: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.CONTACT_TYPE');

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
425: IF p_new_contact_rec.party_id <> p_old_contact_rec.party_id

Line 429: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID');

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
433: IF p_new_contact_rec.party_role_code <> p_old_contact_rec.party_role_code

Line 437: FND_MSG_PUB.add_detail( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ROLE_CODE');

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

Line 536: FND_MSG_PUB.add_detail

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

Line 546: FND_MSG_PUB.add_detail

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

Line 556: FND_MSG_PUB.add_detail

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

Line 671: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');

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: --
675: IF p_new_contact_rec.primary_flag = 'Y' AND

Line 680: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');

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: --
684: IF p_new_contact_rec.primary_flag = 'Y' AND

Line 689: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');

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

Line 702: FND_MSG_PUB.add_detail(p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.END_DATE_ACITVE');

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

Line 713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: WHEN OTHERS THEN
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
714: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
715: END IF;
716: END validate_contact;
717: --------------------------------------------------------------------------------

Line 714: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: WHEN OTHERS THEN
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
714: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
715: END IF;
716: END validate_contact;
717: --------------------------------------------------------------------------------
718: -- Procedure Name : process_g_miss

Line 825: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.SR_CONTACT_POINT_ID');

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');
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: EXIT;
828: END IF;
829: l_updated_cp_index := l_updated_cp_index + 1;

Line 1302: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.PRIMARY_FLAG');

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');
1303: RAISE FND_API.G_EXC_ERROR;
1304: END IF;
1305: END IF;
1306: validate_contact

Line 1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: WHEN OTHERS THEN
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
1345: END IF;
1346: END process;
1347:

Line 1344: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);

1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: WHEN OTHERS THEN
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1344: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
1345: END IF;
1346: END process;
1347:
1348: --------------------------------------------------------------------------------

Line 1398: FND_MSG_PUB.Count_And_Get

1394:
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_count => x_msg_count,
1400: p_data => x_msg_data);
1401: RAISE;
1402: END Populate_CP_Audit_Rec;