eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: --Added by Lakshmi for 12.1.2 project,Added another 'AND' condition ,
675: --To throw an error is a primary contact is endated and Profile 'CS_SR_CONTACT_MANDATORY' is set to Yes.

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

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

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

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

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

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

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

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

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

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

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

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

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

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');
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327: END IF;*/
1328: -- Comment ends for 12.1.2 project ,end-dating contact points

Line 1423: FND_MSG_PUB.add;

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:
1427: --End of changes for 12.1.2 -End Dating Contact by Lakshmi

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

1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1439: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
1440: END IF;
1441: END process;
1442:

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

1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1439: FND_MSG_PUB.Add_Exc_Msg('aa', l_api_name_full);
1440: END IF;
1441: END process;
1442:
1443: --------------------------------------------------------------------------------

Line 1493: FND_MSG_PUB.Count_And_Get

1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493: FND_MSG_PUB.Count_And_Get
1494: ( p_count => x_msg_count,
1495: p_data => x_msg_data);
1496: RAISE;
1497: END Populate_CP_Audit_Rec;