DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on FND_MESSAGE

Line 69: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');

65: x_abort_workflow_close_flag := NULL;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: WHEN others THEN
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
70: FND_MESSAGE.set_token
71: ('P_TEXT'
72: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
73: );

Line 70: FND_MESSAGE.set_token

66: x_return_status := FND_API.G_RET_STS_ERROR;
67: WHEN others THEN
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
70: FND_MESSAGE.set_token
71: ('P_TEXT'
72: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
73: );
74: FND_MSG_PUB.ADD;

Line 201: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');

197: IF ((px_inp_rec.business_process_id IS NULL) OR
198: (px_inp_rec.severity_id IS NULL) OR
199: (px_inp_rec.time_zone_id IS NULL) )
200: THEN
201: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
202: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
203: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
204: ELSE
205: OKS_ENTITLEMENTS_PUB.get_contracts

Line 228: FND_MESSAGE.set_name('CS','CS_SR_UNABLE_DEF_CONTR');

224: x_contract_service_id := null ;
225: x_exp_resolution_date := null ;
226: x_obligation_date := null ;
227:
228: FND_MESSAGE.set_name('CS','CS_SR_UNABLE_DEF_CONTR');
229: FND_MSG_PUB.add_detail(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
230: -- in case of update API, this param is always passed as NULL
231: -- so this will not execute for update API
232: IF p_default_coverage_template_id is NOT NULL

Line 601: FND_MESSAGE.SET_NAME('CS','CS_SR_CONTRACT_ASSIGN_CHANGED');

597: END IF; -- check of FND_LOG.level_procedure
598: IF p_old_contract_service_id IS NOT NULL AND
599: NVL(p_sr_rec.contract_service_id,-99) <> p_old_contract_service_id
600: THEN
601: FND_MESSAGE.SET_NAME('CS','CS_SR_CONTRACT_ASSIGN_CHANGED');
602: FND_MSG_PUB.ADD_DETAIL(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
603: END IF ;
604: END IF; -- contract service or related attributes are null
605: -- move the above part to get_default_contract

Line 610: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');

606: END IF; -- if default contrct sla ind is 'Y'
607: IF l_contract_service_id_valid <> 'Y' AND
608: l_contract_defaulted <> 'Y'
609: THEN
610: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
611: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
612: FND_MSG_PUB.add;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;

Line 611: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );

607: IF l_contract_service_id_valid <> 'Y' AND
608: l_contract_defaulted <> 'Y'
609: THEN
610: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
611: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
612: FND_MSG_PUB.add;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615: -- End of Default contract SLA processing

Line 650: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');

646: -- Start of owner assignment to service request
647: --
648: IF p_auto_assign NOT IN ('Y','N','y','n')
649: THEN
650: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
651: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
652: FND_MSG_PUB.ADD;
653: END IF;
654: IF p_sr_rec.owner_id IS NULL AND

Line 651: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

647: --
648: IF p_auto_assign NOT IN ('Y','N','y','n')
649: THEN
650: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
651: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
652: FND_MSG_PUB.ADD;
653: END IF;
654: IF p_sr_rec.owner_id IS NULL AND
655: LOWER(p_auto_assign) = 'y' AND

Line 718: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');

714: END IF;
715: -- Add information message if AM API does not return anything
716: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
717: THEN
718: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
720: FND_MSG_PUB.ADD;
721: END IF;
722: p_sr_rec.territory_id := l_territory_id;

Line 719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

715: -- Add information message if AM API does not return anything
716: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
717: THEN
718: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
720: FND_MSG_PUB.ADD;
721: END IF;
722: p_sr_rec.territory_id := l_territory_id;
723: END IF; -- AM API returned with success

Line 736: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');

732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: WHEN OTHERS THEN
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
737: FND_MESSAGE.set_token
738: ('P_TEXT'
739: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
740: );

Line 737: FND_MESSAGE.set_token

733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: WHEN OTHERS THEN
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
737: FND_MESSAGE.set_token
738: ('P_TEXT'
739: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
740: );
741: FND_MSG_PUB.ADD;

Line 1497: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');

1493:
1494:
1495: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
1496: THEN
1497: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
1498: FND_MESSAGE.set_token
1499: ( 'API_NAME'
1500: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1501: );

Line 1498: FND_MESSAGE.set_token

1494:
1495: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
1496: THEN
1497: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
1498: FND_MESSAGE.set_token
1499: ( 'API_NAME'
1500: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1501: );
1502: FND_MSG_PUB.ADD_DETAIL

Line 1556: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');

1552: IF NVL(l_maintenance_flag,'N') <> 'Y'
1553: THEN
1554: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
1555: THEN
1556: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
1557: FND_MESSAGE.set_token
1558: ( 'API_NAME'
1559: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1560: );

Line 1557: FND_MESSAGE.set_token

1553: THEN
1554: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
1555: THEN
1556: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
1557: FND_MESSAGE.set_token
1558: ( 'API_NAME'
1559: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1560: );
1561: FND_MSG_PUB.ADD_DETAIL

Line 3114: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');

3110: Else
3111: x_sr_create_out_rec.auto_task_gen_attempted := FALSE;
3112:
3113: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3114: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3115: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3116: FND_MSG_PUB.ADD;
3117: END IF;
3118:

Line 3115: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

3111: x_sr_create_out_rec.auto_task_gen_attempted := FALSE;
3112:
3113: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3114: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3115: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3116: FND_MSG_PUB.ADD;
3117: END IF;
3118:
3119: End If; -- If p_auto_generate_tasks = 'Y'

Line 3177: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');

3173: --- For BUG # 2933250
3174: WHEN invalid_install_site THEN
3175: ROLLBACK TO Create_ServiceRequest_PVT;
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3178: FND_MSG_PUB.ADD;
3179: FND_MSG_PUB.Count_And_Get
3180: ( p_count => x_msg_count,
3181: p_data => x_msg_data

Line 3975: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');

3971: END IF;
3972: -- check for item serial number. it must be null or G_miss_char
3973: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
3974: THEN
3975: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
3976: FND_MESSAGE.set_token
3977: ( 'API_NAME'
3978: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
3979: );

Line 3976: FND_MESSAGE.set_token

3972: -- check for item serial number. it must be null or G_miss_char
3973: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
3974: THEN
3975: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
3976: FND_MESSAGE.set_token
3977: ( 'API_NAME'
3978: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
3979: );
3980: FND_MSG_PUB.ADD_DETAIL

Line 4127: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');

4123: IF NVL(l_new_maintenance_flag,'N') <> 'Y'
4124: THEN
4125: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
4126: THEN
4127: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
4128: FND_MESSAGE.set_token
4129: ( 'API_NAME'
4130: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4131: );

Line 4128: FND_MESSAGE.set_token

4124: THEN
4125: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
4126: THEN
4127: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
4128: FND_MESSAGE.set_token
4129: ( 'API_NAME'
4130: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4131: );
4132: FND_MSG_PUB.ADD_DETAIL

Line 4271: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');

4267:
4268: IF (l_sr_related_data.pending_approval_flag = 'Y' AND
4269: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES')
4270: THEN
4271: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
4272: FND_MESSAGE.set_token
4273: ( 'API_NAME'
4274: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4275: );

Line 4272: FND_MESSAGE.set_token

4268: IF (l_sr_related_data.pending_approval_flag = 'Y' AND
4269: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES')
4270: THEN
4271: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
4272: FND_MESSAGE.set_token
4273: ( 'API_NAME'
4274: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4275: );
4276: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);

Line 4276: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);

4272: FND_MESSAGE.set_token
4273: ( 'API_NAME'
4274: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4275: );
4276: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4277: FND_MSG_PUB.ADD_DETAIL
4278: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4279: );
4280: RAISE FND_API.G_EXC_ERROR;

Line 4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');

4296: IF l_sr_related_data.old_disallow_request_update = 'Y' AND
4297: l_sr_related_data.intermediate_status_id IS NOT NULL AND
4298: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4299: THEN
4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4302: FND_MSG_PUB.Add_Detail
4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'

Line 4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

4297: l_sr_related_data.intermediate_status_id IS NOT NULL AND
4298: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4299: THEN
4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4302: FND_MSG_PUB.Add_Detail
4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4305: );

Line 4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');

4515: -- for bug # 3640344 - pkesani added the parameter p_closed_date.
4516: -- Give a message to user
4517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4518: THEN
4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4521: FND_MSG_PUB.Add_Detail
4522: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4523: , p_same_associated_columns => 'T'

Line 4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

4516: -- Give a message to user
4517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4518: THEN
4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4521: FND_MSG_PUB.Add_Detail
4522: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4523: , p_same_associated_columns => 'T'
4524: );

Line 4719: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');

4715: (p_service_request_rec.contract_service_id IS NOT NULL AND
4716: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
4717: )
4718: THEN
4719: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
4720: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
4721: FND_MSG_PUB.add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;

Line 4720: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );

4716: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
4717: )
4718: THEN
4719: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
4720: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
4721: FND_MSG_PUB.add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;
4724: END IF;

Line 6348: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');

6344: x_return_status := FND_API.G_RET_STS_SUCCESS;
6345: ELSE
6346: x_return_status := FND_API.G_RET_STS_ERROR;
6347: END IF;
6348: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
6349: FND_MSG_PUB.ADD;
6350: FND_MSG_PUB.Count_And_Get
6351: ( p_count => x_msg_count,
6352: p_data => x_msg_data

Line 6360: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');

6356: IF (l_ServiceRequest_csr%ISOPEN) THEN
6357: CLOSE l_ServiceRequest_csr;
6358: END IF;
6359: x_return_status := FND_API.G_RET_STS_ERROR;
6360: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
6361: FND_MSG_PUB.ADD;
6362: FND_MSG_PUB.Count_And_Get
6363: ( p_count => x_msg_count,
6364: p_data => x_msg_data

Line 6372: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');

6368: IF (l_ServiceRequest_csr%ISOPEN) THEN
6369: CLOSE l_ServiceRequest_csr;
6370: END IF;
6371: x_return_status := FND_API.G_RET_STS_SUCCESS;
6372: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
6373: FND_MSG_PUB.ADD;
6374: FND_MSG_PUB.Count_And_Get
6375: ( p_count => x_msg_count,
6376: p_data => x_msg_data

Line 6384: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');

6380: IF (l_ServiceRequest_csr%ISOPEN) THEN
6381: CLOSE l_ServiceRequest_csr;
6382: END IF;
6383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6384: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
6385: FND_MSG_PUB.ADD;
6386: FND_MSG_PUB.Count_And_Get
6387: ( p_count => x_msg_count,
6388: p_data => x_msg_data

Line 6395: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');

6391: --- For BUG # 2933250
6392: WHEN invalid_install_site THEN
6393: ROLLBACK TO Update_ServiceRequest_PVT;
6394: x_return_status := FND_API.G_RET_STS_ERROR;
6395: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
6396: FND_MSG_PUB.ADD;
6397: FND_MSG_PUB.Count_And_Get
6398: ( p_count => x_msg_count,
6399: p_data => x_msg_data

Line 6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');

6795: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6796:
6797: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
6798: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);

Line 6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');

6797: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
6798: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
6805: RAISE FND_API.G_EXC_ERROR;

Line 6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');

6798: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF; -- l_pending approval flag is Y

Line 6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);

6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF; -- l_pending approval flag is Y
6807: END IF; -- if after get_status_details call

Line 6826: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');

6822: IF l_return_status = FND_API.G_RET_STS_SUCCESS
6823: THEN
6824: /*
6825: IF l_sr_related_data.pending_approval_flag = 'Y' THEN
6826: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
6827: FND_MESSAGE.set_token
6828: ( 'API_NAME'
6829: , 'CS_SERVICEREQUEST_PVT.update_status'
6830: );

Line 6827: FND_MESSAGE.set_token

6823: THEN
6824: /*
6825: IF l_sr_related_data.pending_approval_flag = 'Y' THEN
6826: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
6827: FND_MESSAGE.set_token
6828: ( 'API_NAME'
6829: , 'CS_SERVICEREQUEST_PVT.update_status'
6830: );
6831: FND_MESSAGE.set_token('STATUS_ID',p_status_id);

Line 6831: FND_MESSAGE.set_token('STATUS_ID',p_status_id);

6827: FND_MESSAGE.set_token
6828: ( 'API_NAME'
6829: , 'CS_SERVICEREQUEST_PVT.update_status'
6830: );
6831: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
6832: FND_MSG_PUB.ADD_DETAIL
6833: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
6834: );
6835: RAISE FND_API.G_EXC_ERROR;

Line 7653: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');

7649: , x_return_status => l_return_status
7650: );
7651: IF l_sr_related_data.disallow_request_update = 'Y'
7652: THEN
7653: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
7654: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
7655: FND_MSG_PUB.add_detail
7656: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
7657: );

Line 7654: FND_MESSAGE.set_token('API_NAME', l_api_name_full);

7650: );
7651: IF l_sr_related_data.disallow_request_update = 'Y'
7652: THEN
7653: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
7654: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
7655: FND_MSG_PUB.add_detail
7656: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
7657: );
7658: RAISE FND_API.G_EXC_ERROR;

Line 7676: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');

7672: OR (l_ServiceRequest_rec.owner_group_id <> l_owner_group_id)
7673: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
7674: THEN
7675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7676: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
7677: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
7678: FND_MSG_PUB.ADD;
7679: END IF;
7680: RAISE FND_API.G_EXC_ERROR;

Line 7677: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

7673: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
7674: THEN
7675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7676: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
7677: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
7678: FND_MSG_PUB.ADD;
7679: END IF;
7680: RAISE FND_API.G_EXC_ERROR;
7681: END IF;

Line 9279: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');

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');
9280: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
9281: FND_MSG_PUB.ADD;
9282: END IF;
9283: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9280: FND_MESSAGE.Set_Token('API_NAME', p_api_name);

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');
9280: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
9281: FND_MSG_PUB.ADD;
9282: END IF;
9283: x_return_status := FND_API.G_RET_STS_ERROR;
9284: RETURN;

Line 10970: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

10966: THEN
10967: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
10968: l_service_request_rec.bill_to_party_id IS NULL) THEN
10969:
10970: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10971: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
10972: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10973: fnd_msg_pub.ADD;
10974:

Line 10971: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');

10967: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
10968: l_service_request_rec.bill_to_party_id IS NULL) THEN
10969:
10970: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10971: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
10972: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10973: fnd_msg_pub.ADD;
10974:
10975: RAISE FND_API.G_EXC_ERROR;

Line 10972: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');

10968: l_service_request_rec.bill_to_party_id IS NULL) THEN
10969:
10970: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10971: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
10972: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10973: fnd_msg_pub.ADD;
10974:
10975: RAISE FND_API.G_EXC_ERROR;
10976: END IF;

Line 10987: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

10983: THEN
10984: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
10985: l_service_request_rec.bill_to_party_id IS NULL) THEN
10986:
10987: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10988: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
10989: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10990: fnd_msg_pub.ADD;
10991:

Line 10988: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');

10984: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
10985: l_service_request_rec.bill_to_party_id IS NULL) THEN
10986:
10987: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10988: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
10989: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10990: fnd_msg_pub.ADD;
10991:
10992: RAISE FND_API.G_EXC_ERROR;

Line 10989: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');

10985: l_service_request_rec.bill_to_party_id IS NULL) THEN
10986:
10987: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10988: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
10989: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10990: fnd_msg_pub.ADD;
10991:
10992: RAISE FND_API.G_EXC_ERROR;
10993: END IF;

Line 11004: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11000: THEN
11001: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11002: l_service_request_rec.bill_to_party_id IS NULL) THEN
11003:
11004: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11005: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
11006: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11007: fnd_msg_pub.ADD;
11008:

Line 11005: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');

11001: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11002: l_service_request_rec.bill_to_party_id IS NULL) THEN
11003:
11004: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11005: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
11006: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11007: fnd_msg_pub.ADD;
11008:
11009: RAISE FND_API.G_EXC_ERROR;

Line 11006: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');

11002: l_service_request_rec.bill_to_party_id IS NULL) THEN
11003:
11004: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11005: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
11006: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11007: fnd_msg_pub.ADD;
11008:
11009: RAISE FND_API.G_EXC_ERROR;
11010: END IF;

Line 11021: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11017: THEN
11018: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11019: l_service_request_rec.bill_to_party_id IS NULL) THEN
11020:
11021: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11022: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
11023: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11024: fnd_msg_pub.ADD;
11025:

Line 11022: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');

11018: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11019: l_service_request_rec.bill_to_party_id IS NULL) THEN
11020:
11021: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11022: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
11023: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11024: fnd_msg_pub.ADD;
11025:
11026: RAISE FND_API.G_EXC_ERROR;

Line 11023: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');

11019: l_service_request_rec.bill_to_party_id IS NULL) THEN
11020:
11021: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11022: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
11023: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11024: fnd_msg_pub.ADD;
11025:
11026: RAISE FND_API.G_EXC_ERROR;
11027: END IF;

Line 11038: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11034: THEN
11035: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11036: l_service_request_rec.ship_to_party_id IS NULL) THEN
11037:
11038: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11039: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
11040: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11041: fnd_msg_pub.ADD;
11042:

Line 11039: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');

11035: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11036: l_service_request_rec.ship_to_party_id IS NULL) THEN
11037:
11038: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11039: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
11040: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11041: fnd_msg_pub.ADD;
11042:
11043: RAISE FND_API.G_EXC_ERROR;

Line 11040: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');

11036: l_service_request_rec.ship_to_party_id IS NULL) THEN
11037:
11038: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11039: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
11040: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11041: fnd_msg_pub.ADD;
11042:
11043: RAISE FND_API.G_EXC_ERROR;
11044: END IF;

Line 11055: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11051: THEN
11052: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11053: l_service_request_rec.ship_to_party_id IS NULL) THEN
11054:
11055: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11056: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
11057: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11058: fnd_msg_pub.ADD;
11059:

Line 11056: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');

11052: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11053: l_service_request_rec.ship_to_party_id IS NULL) THEN
11054:
11055: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11056: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
11057: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11058: fnd_msg_pub.ADD;
11059:
11060: RAISE FND_API.G_EXC_ERROR;

Line 11057: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');

11053: l_service_request_rec.ship_to_party_id IS NULL) THEN
11054:
11055: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11056: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
11057: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11058: fnd_msg_pub.ADD;
11059:
11060: RAISE FND_API.G_EXC_ERROR;
11061: END IF;

Line 11072: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11068: THEN
11069: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11070: l_service_request_rec.ship_to_party_id IS NULL) THEN
11071:
11072: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11073: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
11074: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11075: fnd_msg_pub.ADD;
11076:

Line 11073: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');

11069: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11070: l_service_request_rec.ship_to_party_id IS NULL) THEN
11071:
11072: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11073: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
11074: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11075: fnd_msg_pub.ADD;
11076:
11077: RAISE FND_API.G_EXC_ERROR;

Line 11074: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');

11070: l_service_request_rec.ship_to_party_id IS NULL) THEN
11071:
11072: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11073: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
11074: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11075: fnd_msg_pub.ADD;
11076:
11077: RAISE FND_API.G_EXC_ERROR;
11078: END IF;

Line 11089: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');

11085: THEN
11086: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11087: l_service_request_rec.ship_to_party_id IS NULL) THEN
11088:
11089: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11090: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
11091: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11092: fnd_msg_pub.ADD;
11093:

Line 11090: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');

11086: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
11087: l_service_request_rec.ship_to_party_id IS NULL) THEN
11088:
11089: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11090: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
11091: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11092: fnd_msg_pub.ADD;
11093:
11094: RAISE FND_API.G_EXC_ERROR;

Line 11091: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');

11087: l_service_request_rec.ship_to_party_id IS NULL) THEN
11088:
11089: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11090: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
11091: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11092: fnd_msg_pub.ADD;
11093:
11094: RAISE FND_API.G_EXC_ERROR;
11095: END IF;

Line 14741: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');

14737: l_service_request_rec.customer_id IS NULL THEN
14738: -- Check if one passed is same as old.
14739: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
14740:
14741: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14742: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
14743: FND_MSG_PUB.ADD;
14744: RAISE FND_API.G_EXC_ERROR;
14745: END IF; ---customer_id <> old customer_id

Line 14742: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');

14738: -- Check if one passed is same as old.
14739: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
14740:
14741: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14742: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
14743: FND_MSG_PUB.ADD;
14744: RAISE FND_API.G_EXC_ERROR;
14745: END IF; ---customer_id <> old customer_id
14746: ELSE

Line 14754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');

14750: IF (l_service_request_rec.customer_number <> FND_API.G_MISS_CHAR)
14751: AND (l_service_request_rec.customer_number IS NOT NULL ) THEN
14752: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
14753:
14754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14755: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
14756: FND_MSG_PUB.ADD;
14757: RAISE FND_API.G_EXC_ERROR;
14758: END IF; ---customer_number <> old customer_number

Line 14755: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');

14751: AND (l_service_request_rec.customer_number IS NOT NULL ) THEN
14752: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
14753:
14754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14755: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
14756: FND_MSG_PUB.ADD;
14757: RAISE FND_API.G_EXC_ERROR;
14758: END IF; ---customer_number <> old customer_number
14759: END IF; -- customer number is passed

Line 14836: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');

14832: IF (l_service_request_rec.type_id <> FND_API.G_MISS_NUM) AND
14833: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
14834:
14835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14836: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
14837: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14838: FND_MSG_PUB.ADD;
14839: END IF;
14840: RAISE FND_API.G_EXC_ERROR;

Line 14837: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

14833: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
14834:
14835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14836: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
14837: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14838: FND_MSG_PUB.ADD;
14839: END IF;
14840: RAISE FND_API.G_EXC_ERROR;
14841: END IF;

Line 14851: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');

14847: (l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM AND
14848: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
14849:
14850: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14851: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
14852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14853: FND_MSG_PUB.ADD;
14854: END IF;
14855: RAISE FND_API.G_EXC_ERROR;

Line 14852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

14848: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
14849:
14850: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14851: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
14852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14853: FND_MSG_PUB.ADD;
14854: END IF;
14855: RAISE FND_API.G_EXC_ERROR;
14856: END IF;

Line 15011: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');

15007:
15008: IF l_sr_related_data.old_pending_approval_flag = 'Y' AND
15009: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
15010: THEN
15011: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
15012: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15013: FND_MSG_PUB.ADD_DETAIL
15014: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
15015: );

Line 15012: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

15008: IF l_sr_related_data.old_pending_approval_flag = 'Y' AND
15009: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
15010: THEN
15011: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
15012: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15013: FND_MSG_PUB.ADD_DETAIL
15014: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
15015: );
15016: RAISE FND_API.G_EXC_ERROR;

Line 15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');

15034: (NVL(l_service_request_rec.resource_type,'x') <> FND_API.G_MISS_CHAR AND
15035: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
15036: THEN
15037: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'

Line 15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

15035: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
15036: THEN
15037: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
15043: );

Line 15082: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');

15078: l_service_request_rec.inventory_item_id := l_old_ServiceRequest_rec.inventory_item_id;
15079: l_service_request_rec.current_serial_number :=l_old_ServiceRequest_rec.current_serial_number;
15080:
15081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15082: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
15083: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15084: FND_MSG_PUB.ADD;
15085: END IF;
15086: END IF;

Line 15083: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

15079: l_service_request_rec.current_serial_number :=l_old_ServiceRequest_rec.current_serial_number;
15080:
15081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15082: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
15083: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15084: FND_MSG_PUB.ADD;
15085: END IF;
15086: END IF;
15087: END IF; /* end of validation level check */

Line 19209: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

19205: OPEN C;
19206: FETCH C INTO RECINFO;
19207: IF (C%NOTFOUND) THEN
19208: CLOSE C;
19209: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
19210: FND_MSG_PUB.ADD;
19211: APP_EXCEPTION.RAISE_EXCEPTION;
19212: END IF;
19213: CLOSE C;

Line 19218: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

19214:
19215: IF (RECINFO.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER) THEN
19216: NULL;
19217: ELSE
19218: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
19219: FND_MSG_PUB.ADD;
19220: APP_EXCEPTION.RAISE_EXCEPTION;
19221: END IF;
19222:

Line 19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

19706: , 'p_processing_set_id should not be NULL.'
19707: );
19708: END IF ;
19709:
19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
19714: FND_MSG_PUB.ADD;

Line 19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

19707: );
19708: END IF ;
19709:
19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
19714: FND_MSG_PUB.ADD;
19715:

Line 19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');

19708: END IF ;
19709:
19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
19714: FND_MSG_PUB.ADD;
19715:
19716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));

19709:
19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
19714: FND_MSG_PUB.ADD;
19715:
19716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19717: END IF;

Line 19734: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

19730: , 'p_purge_source_with_open_task value is invalid.'
19731: );
19732: END IF ;
19733:
19734: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19735: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19736: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
19737: FND_MESSAGE.Set_Token
19738: (

Line 19735: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

19731: );
19732: END IF ;
19733:
19734: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19735: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19736: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
19737: FND_MESSAGE.Set_Token
19738: (
19739: 'CURRVAL'

Line 19736: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');

19732: END IF ;
19733:
19734: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19735: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19736: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
19737: FND_MESSAGE.Set_Token
19738: (
19739: 'CURRVAL'
19740: , NVL(p_purge_source_with_open_task, 'NULL')

Line 19737: FND_MESSAGE.Set_Token

19733:
19734: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19735: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19736: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
19737: FND_MESSAGE.Set_Token
19738: (
19739: 'CURRVAL'
19740: , NVL(p_purge_source_with_open_task, 'NULL')
19741: );

Line 19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');

19758: , 'p_audit_required value is invalid.'
19759: );
19760: END IF ;
19761:
19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
19766: FND_MSG_PUB.ADD;

Line 19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

19759: );
19760: END IF ;
19761:
19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
19766: FND_MSG_PUB.ADD;
19767:

Line 19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');

19760: END IF ;
19761:
19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
19766: FND_MSG_PUB.ADD;
19767:
19768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));

19761:
19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
19766: FND_MSG_PUB.ADD;
19767:
19768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19769: END IF;

Line 19926: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');

19922: END IF ;
19923:
19924: WHEN OTHERS THEN
19925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19926: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
19929: FND_MSG_PUB.ADD;
19930:

Line 19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);

19923:
19924: WHEN OTHERS THEN
19925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19926: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
19929: FND_MSG_PUB.ADD;
19930:
19931: FND_MSG_PUB.Count_And_Get

Line 19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);

19924: WHEN OTHERS THEN
19925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19926: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
19929: FND_MSG_PUB.ADD;
19930:
19931: FND_MSG_PUB.Count_And_Get
19932: (