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 CS_SRCONTACT_PKG

Line 1: Package BODY CS_SRCONTACT_PKG AS

1: Package BODY CS_SRCONTACT_PKG AS
2: /* $Header: cssrcpb.pls 120.9.12010000.4 2010/05/14 22:20:58 siahmed ship $*/
3: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4: --------------------------------------------------------------------------------
5: -- Procedure Name : check_duplicates

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 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 400: l_api_name_full := 'CS_SRCONTACT_PKG.validate_contact';

396: l_status hz_parties.status % TYPE;
397: p_mode VARCHAR2(30);
398: l_today DATE;
399: BEGIN
400: l_api_name_full := 'CS_SRCONTACT_PKG.validate_contact';
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402: l_today := TRUNC(SYSDATE);
403: -- set p_mode variable.
404: -- This could be passed to this procedure too

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 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 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 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 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 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 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 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 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 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 1208: l_api_name_full := 'CS_SRCONTACT_PKG.process';

1204: l_sr_contact_point_id_pri NUMBER;
1205: l_today DATE;
1206: --
1207: BEGIN
1208: l_api_name_full := 'CS_SRCONTACT_PKG.process';
1209: x_return_Status := FND_API.G_RET_STS_SUCCESS;
1210: l_today := TRUNC(SYSDATE);
1211: l_primary_found := 0;
1212: IF p_contact_tbl.COUNT = 0

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