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_SERVICEREQUEST_PVT dependencies on FND_PROFILE

Line 374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;

370: l_log_module VARCHAR2(255) ;
371: l_contract_defaulted VARCHAR2(1);
372: l_msg_count NUMBER;
373: l_msg_data VARCHAR2(2000);
374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;

Line 658: l_auto_assign_level := fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');

654: IF p_sr_rec.owner_id IS NULL AND
655: LOWER(p_auto_assign) = 'y' AND
656: NVL(p_sr_related_data.old_disallow_request_update,'N') = 'N'
657: THEN
658: l_auto_assign_level := fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
659: -- For bug 3702091 - AM API should not be called even if the Auto Assignment is ON
660: -- and the Assignment level is Group and Owner is passed
661: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR
662: (l_auto_assign_level = 'GROUP' AND p_sr_rec.owner_group_id is null))

Line 1376: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

1372: -- local variable for validate owner
1373: lx_owner_name VARCHAR2(240);
1374: lx_owner_id NUMBER;
1375: x_msg_index_out NUMBER;
1376: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
1377:
1378: -- Local variable to store the request_id, to be passed to IEU procedure.
1379: q_request_id NUMBER;
1380: l_note_status VARCHAR2(3);

Line 1585: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');

1581:
1582: -- Initialize the value of the parameter from profile cs_sr_restrict_ib
1583: -- by shijain 4th dec 2002
1584:
1585: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');
1586:
1587: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1588: THEN
1589: FND_LOG.String

Line 1725: l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));

1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: END IF;
1723: IF p_org_id IS NULL
1724: THEN
1725: l_org_id := to_number(FND_PROFILE.value('CS_SR_ORG_ID'));
1726:
1727: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1728: THEN
1729: FND_LOG.String

Line 2630: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);

2626: -- Call to Enqueuer API if it is in Maintenance Mode
2627: -- added b'coz l_req_num will always be null,when request_number is passed
2628: l_enqueue_number := NVL(l_request_number,l_req_num);
2629:
2630: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);
2631:
2632: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2633: THEN
2634: FND_LOG.String

Line 3838: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');

3834:
3835: -- Initialize the value of the parameter from profile cs_sr_restrict_ib
3836: -- by shijain 4th dec 2002
3837:
3838: g_restrict_ib:= fnd_profile.value('CS_SR_RESTRICT_IB');
3839:
3840: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3841: THEN
3842: FND_LOG.String

Line 5430: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);

5426:
5427:
5428: ---- Call to Enqueue API if it is in maintenance Mode
5429:
5430: FND_PROFILE.get('APPS_MAINTENANCE_MODE', l_maintenance_mode);
5431:
5432: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
5433: THEN
5434: FND_LOG.String

Line 9275: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;

9271:
9272: IF (p_service_request_rec.publish_flag <> FND_API.G_MISS_CHAR) AND
9273: p_sr_mode <> 'CREATE' THEN
9274:
9275: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;
9276:
9277: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
9278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9279: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');

Line 10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

10861: l_bill_to_site_id NUMBER;
10862: l_ship_to_site_id NUMBER;
10863: l_bill_to_site_use_id NUMBER;
10864: l_ship_to_site_use_id NUMBER;
10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
10866: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
10867: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
10869: l_territory_id number;

Line 11822: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');

11818: -- Added to fix issue in bug # 3288806.
11819: IF ((l_service_request_rec.category_id IS NOT NULL) AND (l_service_request_rec.category_id <> FND_API.G_MISS_NUM)) THEN
11820: l_service_request_val_rec.category_id := l_service_request_rec.category_id ;
11821: IF (l_service_request_rec.category_set_id = FND_API.G_MISS_NUM) THEN
11822: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
11823: END IF;
11824: l_service_request_val_rec.category_set_id := l_service_request_rec.category_set_id ;
11825: END IF ;
11826:

Line 14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=

14360: l_ship_to_site_id NUMBER;
14361: l_bill_to_site_use_id NUMBER;
14362: l_ship_to_site_use_id NUMBER;
14363:
14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;

Line 14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');

14361: l_bill_to_site_use_id NUMBER;
14362: l_ship_to_site_use_id NUMBER;
14363:
14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
14369: l_territory_id number;

Line 15289: l_service_request_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');

15285: --
15286: IF (l_service_request_rec.group_type = FND_API.G_MISS_CHAR AND
15287: l_old_servicerequest_rec.group_type is null AND
15288: l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM) THEN
15289: l_service_request_rec.group_type := nvl( FND_PROFILE.value('CS_SR_DEFAULT_GROUP_TYPE'), 'RS_GROUP');
15290: END IF;
15291: IF (l_service_request_rec.group_type = FND_API.G_MISS_CHAR) OR
15292: (nvl(l_service_request_rec.group_type,'-99') = nvl(l_old_ServiceRequest_rec.group_type,'-99')) THEN
15293: l_service_request_rec.group_type := l_old_ServiceRequest_rec.group_type;

Line 16195: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');

16191: l_SR_Validation_rec.category_id := l_service_request_rec.category_id;
16192: IF (l_service_request_rec.category_id IS NOT NULL AND
16193: l_service_request_rec.category_set_id = FND_API.G_MISS_NUM AND
16194: l_old_servicerequest_rec.category_set_id IS NULL) THEN
16195: l_service_request_rec.category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
16196: END IF;
16197: END IF;
16198:
16199: IF (l_service_request_rec.category_set_id = FND_API.G_MISS_NUM) THEN