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_HZ_SR_CONTACT_POINTS

Line 66: l_dup_role CS_HZ_SR_CONTACT_POINTS.party_role_code % TYPE;

62: l_party_role_code VARCHAR2(30);
63: l_contact_point_type VARCHAR2(30);
64: l_end_date_active DATE;
65: l_start_date_active DATE;
66: l_dup_role CS_HZ_SR_CONTACT_POINTS.party_role_code % TYPE;
67: BEGIN
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69: -- For SR Create API, no need to look for existing contact record because
70: -- there will be none.

Line 74: FROM cs_hz_sr_contact_points

70: -- there will be none.
71: IF p_mode <> 'CREATE'
72: THEN
73: l_sql := 'SELECT contact_type, party_id, party_role_code, contact_point_id, contact_point_type, start_date_active, end_date_active
74: FROM cs_hz_sr_contact_points
75: WHERE incident_id = :incident_id
76: /* AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
77: AND NVL(end_date_active , TRUNC(SYSDATE)) */';
78: IF p_updated_cp_qry <> ':1'

Line 238: FROM cs_hz_sr_contact_points

234: BEGIN
235: l_dt := TRUNC(SYSDATE);
236: SELECT COUNT(1)
237: INTO l_count
238: FROM cs_hz_sr_contact_points
239: WHERE incident_id = p_incident_id
240: AND party_role_code = 'CONTACT'
241: AND NVL(END_DATE_ACTIVE,sysdate) >= l_dt
242: ;

Line 395: l_party_type cs_hz_sr_contact_points.contact_type % TYPE;

391: , x_return_status OUT NOCOPY VARCHAR2
392: ) IS
393: l_api_name_full VARCHAR2(61);
394: l_employee_name VARCHAR2(80);
395: l_party_type cs_hz_sr_contact_points.contact_type % TYPE;
396: l_status hz_parties.status % TYPE;
397: p_mode VARCHAR2(30);
398: l_today DATE;
399: BEGIN

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 449: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'

445: THEN
446: CS_SERVICEREQUEST_UTIL.add_null_parameter_msg
447: ( p_token_an => l_api_name_full
448: , p_token_np => 'p_contacts.contact_type'
449: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
450: , p_column_name => 'CONTACT_TYPE'
451: );
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF (p_new_contact_rec.contact_type <> NVL(p_old_contact_rec.contact_type,'xx'))

Line 468: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'

464: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
465: ( p_token_an => l_api_name_full
466: , p_token_v => p_new_contact_rec.contact_type
467: , p_token_p => 'p_contacts.contact_type'
468: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
469: , p_column_name => 'CONTACT_TYPE'
470: );
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;

Line 488: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',

484: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
485: p_token_an => l_api_name_full,
486: p_token_v => p_new_contact_rec.contact_type,
487: p_token_p => 'p_contacts.contact_type' ,
488: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
489: p_column_name => 'CONTACT_TYPE');
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492: END IF; -- party_role_code = contact

Line 502: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',

498: THEN
499: CS_SERVICEREQUEST_UTIL.add_null_parameter_msg
500: ( p_token_an => l_api_name_full,
501: p_token_np => 'p_contacts.party_id',
502: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
503: p_column_name => 'PARTY_ID'
504: );
505: RAISE FND_API.G_EXC_ERROR;
506: ELSIF (p_new_contact_rec.contact_type <> NVL(p_old_contact_rec.contact_type , 'xx') OR

Line 537: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

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;
541: IF l_status <> 'A'

Line 547: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

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;
551: IF l_party_type <> p_new_contact_rec.contact_type

Line 557: ( p_associated_column1=>'CS_HZ_SR_CONTACT_POINTS.PARTY_ID'

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;
561: ELSE

Line 630: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'

626: CS_SERVICEREQUEST_UTIL.add_invalid_argument_msg
627: ( p_token_an => l_api_name_full
628: , p_token_v => p_new_contact_rec.contact_point_type
629: , p_token_p => 'p_contact_point_type'
630: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
631: , p_column_name => 'CONTACT_POINT_TYPE'
632: );
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: 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 780: cs_hz_sr_contact_points

776: , start_date_active
777: , end_date_active
778: , incident_id
779: FROM
780: cs_hz_sr_contact_points
781: WHERE sr_contact_point_id = p_sr_contact_point_id;
782: BEGIN
783: x_new_contact_tbl := p_new_contact_tbl;
784: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 976: SELECT cs_hz_sr_contact_points_s.NEXTVAL

972: FOR loop_index in p_contact_tbl.FIRST..p_contact_tbl.LAST LOOP
973: l_add_audit := 'N';
974: IF p_old_contact_tbl(loop_index).sr_contact_point_id is NULL
975: THEN
976: SELECT cs_hz_sr_contact_points_s.NEXTVAL
977: INTO l_sr_contact_point_id
978: FROM DUAL;
979: l_activity_code := 'C';
980: --

Line 982: INSERT INTO cs_hz_sr_contact_points

978: FROM DUAL;
979: l_activity_code := 'C';
980: --
981: l_add_audit := 'Y';
982: INSERT INTO cs_hz_sr_contact_points
983: ( sr_contact_point_id
984: , party_id
985: , incident_id
986: , contact_point_type

Line 1034: UPDATE cs_hz_sr_contact_points

1030: l_activity_code := 'U';
1031: l_sr_contact_point_id := p_contact_tbl(loop_index).sr_contact_point_id;
1032: -- update statement does not include party id, contact type and party role code because
1033: -- these attributes can not be updated.
1034: UPDATE cs_hz_sr_contact_points
1035: SET primary_flag = p_contact_tbl(loop_index).primary_flag
1036: , contact_point_id = p_contact_tbl(loop_index).contact_point_id
1037: , contact_point_type = p_contact_tbl(loop_index).contact_point_type
1038: , start_date_active = p_contact_tbl(loop_index).start_date_active

Line 1106: UPDATE cs_hz_sr_contact_points

1102: l_msg_data VARCHAR2(4000);
1103: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
1104: BEGIN
1105: l_audit_enabled := FND_PROFILE.value('CS_SR_CONT_PNT_AUDIT_ENABLED');
1106: UPDATE cs_hz_sr_contact_points
1107: SET primary_flag = 'N'
1108: WHERE incident_id = p_incident_id
1109: AND primary_flag = 'Y'
1110: AND sr_contact_point_id <> NVL(p_sr_contact_point_id,-9)

Line 1201: cs_hz_sr_contact_points

1197: SELECT
1198: party_id
1199: , DECODE(contact_point_type,'PHONE',contact_point_id,NULL)
1200: FROM
1201: cs_hz_sr_contact_points
1202: WHERE incident_id = p_incident_id
1203: AND primary_flag = 'Y';
1204: l_sr_contact_point_id_pri NUMBER;
1205: l_today DATE;

Line 1262: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'

1258: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
1259: ( p_token_an => l_api_name_full
1260: , p_token_v => 'Y'
1261: , p_token_p => 'p_contacts.primary_flag'
1262: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
1263: , p_column_name => 'PRIMARY_FLAG'
1264: );
1265: RAISE FND_API.G_EXC_ERROR;
1266: ELSIF l_primary_found = 0

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 1472: FROM cs_hz_sr_contact_points

1468:
1469: -- Get contact point details.
1470: CURSOR c_get_cp_details IS
1471: SELECT *
1472: FROM cs_hz_sr_contact_points
1473: WHERE sr_contact_point_id = p_sr_contact_point_id ;
1474:
1475: BEGIN
1476: -- Get contact point details for the passed contact point identifier.