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_MESSAGE

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

70: x_abort_workflow_close_flag := NULL;
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: WHEN others THEN
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
75: FND_MESSAGE.set_token
76: ('P_TEXT'
77: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
78: );

Line 75: FND_MESSAGE.set_token

71: x_return_status := FND_API.G_RET_STS_ERROR;
72: WHEN others THEN
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
75: FND_MESSAGE.set_token
76: ('P_TEXT'
77: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
78: );
79: FND_MSG_PUB.ADD;

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

220: IF ((px_inp_rec.business_process_id IS NULL) OR
221: (px_inp_rec.severity_id IS NULL) OR
222: (px_inp_rec.time_zone_id IS NULL) )
223: THEN
224: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
225: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
226: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
227: ELSE
228: OKS_ENTITLEMENTS_PUB.get_contracts

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

247: x_contract_service_id := null ;
248: x_exp_resolution_date := null ;
249: x_obligation_date := null ;
250:
251: FND_MESSAGE.set_name('CS','CS_SR_UNABLE_DEF_CONTR');
252: FND_MSG_PUB.add_detail(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
253: -- in case of update API, this param is always passed as NULL
254: -- so this will not execute for update API
255:

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

647: END IF; -- check of FND_LOG.level_procedure
648: IF p_old_contract_service_id IS NOT NULL AND
649: NVL(p_sr_rec.contract_service_id,-99) <> p_old_contract_service_id
650: THEN
651: FND_MESSAGE.SET_NAME('CS','CS_SR_CONTRACT_ASSIGN_CHANGED');
652: FND_MSG_PUB.ADD_DETAIL(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
653: END IF ;
654: END IF; -- contract service or related attributes are null
655: -- move the above part to get_default_contract

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

656: END IF; -- if default contrct sla ind is 'Y'
657: IF l_contract_service_id_valid <> 'Y' AND
658: l_contract_defaulted <> 'Y'
659: THEN
660: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
661: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
662: FND_MSG_PUB.add;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;

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

657: IF l_contract_service_id_valid <> 'Y' AND
658: l_contract_defaulted <> 'Y'
659: THEN
660: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
661: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
662: FND_MSG_PUB.add;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: -- End of Default contract SLA processing

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

696: -- Start of owner assignment to service request
697: --
698: IF p_auto_assign NOT IN ('Y','N','y','n')
699: THEN
700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
701: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
702: FND_MSG_PUB.ADD;
703: END IF;
704: IF p_sr_rec.owner_id IS NULL AND

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

697: --
698: IF p_auto_assign NOT IN ('Y','N','y','n')
699: THEN
700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
701: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
702: FND_MSG_PUB.ADD;
703: END IF;
704: IF p_sr_rec.owner_id IS NULL AND
705: LOWER(p_auto_assign) = 'y' AND

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

764: END IF;
765: -- Add information message if AM API does not return anything
766: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
767: THEN
768: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
769: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
770: FND_MSG_PUB.ADD;
771: END IF;
772: p_sr_rec.territory_id := l_territory_id;

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

765: -- Add information message if AM API does not return anything
766: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
767: THEN
768: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
769: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
770: FND_MSG_PUB.ADD;
771: END IF;
772: p_sr_rec.territory_id := l_territory_id;
773: END IF; -- AM API returned with success

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

782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
787: FND_MESSAGE.set_token
788: ('P_TEXT'
789: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
790: );

Line 787: FND_MESSAGE.set_token

783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
787: FND_MESSAGE.set_token
788: ('P_TEXT'
789: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
790: );
791: FND_MSG_PUB.ADD;

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

1555:
1556:
1557: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
1558: THEN
1559: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
1560: FND_MESSAGE.set_token
1561: ( 'API_NAME'
1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1563: );

Line 1560: FND_MESSAGE.set_token

1556:
1557: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
1558: THEN
1559: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
1560: FND_MESSAGE.set_token
1561: ( 'API_NAME'
1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1563: );
1564: FND_MSG_PUB.ADD_DETAIL

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

1614: IF NVL(l_maintenance_flag,'N') <> 'Y'
1615: THEN
1616: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
1617: THEN
1618: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
1619: FND_MESSAGE.set_token
1620: ( 'API_NAME'
1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1622: );

Line 1619: FND_MESSAGE.set_token

1615: THEN
1616: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
1617: THEN
1618: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
1619: FND_MESSAGE.set_token
1620: ( 'API_NAME'
1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1622: );
1623: FND_MSG_PUB.ADD_DETAIL

Line 1854: FND_MESSAGE.set_name ('CS','CS_SR_OPERATING_UNIT_INVALID');

1850: if mo_global.check_access(p_org_id) ='Y' then
1851: l_org_id := p_org_id;
1852: else
1853: l_org_id := null;
1854: FND_MESSAGE.set_name ('CS','CS_SR_OPERATING_UNIT_INVALID');
1855: FND_MESSAGE.set_token ('OPERATING_UNIT',p_org_id);
1856: FND_MESSAGE.set_token ('USER_NAME',p_user_id);
1857: end if ;
1858: else --new profile set to NO. follow old logic

Line 1855: FND_MESSAGE.set_token ('OPERATING_UNIT',p_org_id);

1851: l_org_id := p_org_id;
1852: else
1853: l_org_id := null;
1854: FND_MESSAGE.set_name ('CS','CS_SR_OPERATING_UNIT_INVALID');
1855: FND_MESSAGE.set_token ('OPERATING_UNIT',p_org_id);
1856: FND_MESSAGE.set_token ('USER_NAME',p_user_id);
1857: end if ;
1858: else --new profile set to NO. follow old logic
1859: l_org_id := p_org_id;

Line 1856: FND_MESSAGE.set_token ('USER_NAME',p_user_id);

1852: else
1853: l_org_id := null;
1854: FND_MESSAGE.set_name ('CS','CS_SR_OPERATING_UNIT_INVALID');
1855: FND_MESSAGE.set_token ('OPERATING_UNIT',p_org_id);
1856: FND_MESSAGE.set_token ('USER_NAME',p_user_id);
1857: end if ;
1858: else --new profile set to NO. follow old logic
1859: l_org_id := p_org_id;
1860: end if;

Line 2179: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');

2175: x_location_id => l_incident_location_id
2176: );
2177:
2178: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2179: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
2180: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
2181: FND_MSG_PUB.ADD;
2182: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2183: --so that the new party_site_id gets stamped in the cs_incidents_all_b table

Line 2180: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');

2176: );
2177:
2178: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2179: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
2180: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
2181: FND_MSG_PUB.ADD;
2182: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2183: --so that the new party_site_id gets stamped in the cs_incidents_all_b table
2184: l_service_request_rec.incident_location_id := l_incident_location_id;

Line 2257: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');

2253: l_service_request_rec.addressee := null;
2254: l_service_request_rec.incident_addr_lines_phonetic := null;
2255: l_service_request_rec.incident_postal_plus4_code := null;
2256: --End of changes for bug 8594093
2257: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
2258: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
2259: FND_MSG_PUB.ADD;
2260: END IF;
2261:

Line 2258: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');

2254: l_service_request_rec.incident_addr_lines_phonetic := null;
2255: l_service_request_rec.incident_postal_plus4_code := null;
2256: --End of changes for bug 8594093
2257: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
2258: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
2259: FND_MSG_PUB.ADD;
2260: END IF;
2261:
2262: END IF;

Line 2306: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');

2302: l_service_request_rec.project_task_id := null; --FND_API.G_MISS_NUM;
2303: l_service_request_rec.expenditure_org_id := null;
2304:
2305: /*
2306: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
2307: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
2308: FND_MSG_PUB.ADD;
2309: */
2310: END IF;

Line 2307: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');

2303: l_service_request_rec.expenditure_org_id := null;
2304:
2305: /*
2306: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
2307: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
2308: FND_MSG_PUB.ADD;
2309: */
2310: END IF;
2311: END IF;

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

3450: Else
3451: x_sr_create_out_rec.auto_task_gen_attempted := FALSE;
3452:
3453: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3454: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3455: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458:

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

3451: x_sr_create_out_rec.auto_task_gen_attempted := FALSE;
3452:
3453: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3454: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3455: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458:
3459: End If; -- If p_auto_generate_tasks = 'Y'

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

3513: --- For BUG # 2933250
3514: WHEN invalid_install_site THEN
3515: ROLLBACK TO Create_ServiceRequest_PVT;
3516: x_return_status := FND_API.G_RET_STS_ERROR;
3517: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3518: FND_MSG_PUB.ADD;
3519: FND_MSG_PUB.Count_And_Get
3520: ( p_count => x_msg_count,
3521: p_data => x_msg_data

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

4341: END IF;
4342: -- check for item serial number. it must be null or G_miss_char
4343: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
4344: THEN
4345: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
4346: FND_MESSAGE.set_token
4347: ( 'API_NAME'
4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4349: );

Line 4346: FND_MESSAGE.set_token

4342: -- check for item serial number. it must be null or G_miss_char
4343: IF l_service_request_rec.item_serial_number <> FND_API.G_MISS_CHAR
4344: THEN
4345: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
4346: FND_MESSAGE.set_token
4347: ( 'API_NAME'
4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4349: );
4350: FND_MSG_PUB.ADD_DETAIL

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

4493: IF NVL(l_new_maintenance_flag,'N') <> 'Y'
4494: THEN
4495: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
4496: THEN
4497: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
4498: FND_MESSAGE.set_token
4499: ( 'API_NAME'
4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4501: );

Line 4498: FND_MESSAGE.set_token

4494: THEN
4495: IF p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM
4496: THEN
4497: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
4498: FND_MESSAGE.set_token
4499: ( 'API_NAME'
4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4501: );
4502: FND_MSG_PUB.ADD_DETAIL

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

4637:
4638: IF (l_sr_related_data.pending_approval_flag = 'Y' AND
4639: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES')
4640: THEN
4641: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
4642: FND_MESSAGE.set_token
4643: ( 'API_NAME'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );

Line 4642: FND_MESSAGE.set_token

4638: IF (l_sr_related_data.pending_approval_flag = 'Y' AND
4639: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES')
4640: THEN
4641: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
4642: FND_MESSAGE.set_token
4643: ( 'API_NAME'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );
4646: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);

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

4642: FND_MESSAGE.set_token
4643: ( 'API_NAME'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );
4646: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4647: FND_MSG_PUB.ADD_DETAIL
4648: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4649: );
4650: RAISE FND_API.G_EXC_ERROR;

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

4666: IF l_sr_related_data.old_disallow_request_update = 'Y' AND
4667: l_sr_related_data.intermediate_status_id IS NOT NULL AND
4668: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4669: THEN
4670: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4671: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4672: FND_MSG_PUB.Add_Detail
4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'

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

4667: l_sr_related_data.intermediate_status_id IS NOT NULL AND
4668: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4669: THEN
4670: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4671: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4672: FND_MSG_PUB.Add_Detail
4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4675: );

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

4920: -- is contact center, if, so do not throw the warning.
4921: IF(l_service_request_rec.last_update_program_code <> 'CSXSRTAB') THEN
4922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4923: THEN
4924: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4925: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4926: FND_MSG_PUB.Add_Detail
4927: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4928: , p_same_associated_columns => 'T'

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

4921: IF(l_service_request_rec.last_update_program_code <> 'CSXSRTAB') THEN
4922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4923: THEN
4924: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4925: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4926: FND_MSG_PUB.Add_Detail
4927: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4928: , p_same_associated_columns => 'T'
4929: );

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

5136: (p_service_request_rec.contract_service_id IS NOT NULL AND
5137: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
5138: )
5139: THEN
5140: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
5141: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
5142: FND_MSG_PUB.add;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;

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

5137: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
5138: )
5139: THEN
5140: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
5141: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
5142: FND_MSG_PUB.add;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145: END IF;

Line 5608: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');

5604: l_service_request_rec.incident_location_id := l_old_servicerequest_rec.incident_location_id;
5605: l_service_request_rec.incident_location_type := l_old_servicerequest_rec.incident_location_type;
5606: x_sr_update_out_rec.incident_location_id := l_old_servicerequest_rec.incident_location_id;
5607: --end changes for bug 8545879
5608: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
5609: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
5610: FND_MSG_PUB.ADD;
5611:
5612: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN

Line 5609: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');

5605: l_service_request_rec.incident_location_type := l_old_servicerequest_rec.incident_location_type;
5606: x_sr_update_out_rec.incident_location_id := l_old_servicerequest_rec.incident_location_id;
5607: --end changes for bug 8545879
5608: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
5609: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
5610: FND_MSG_PUB.ADD;
5611:
5612: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN
5613: --so that the new party_site_id gets stamped in the cs_incidents_all_b table

Line 5649: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_UPDATE_ERROR');

5645: x_return_status => l_return_status_onetime
5646: );
5647:
5648: IF (l_return_status_onetime <> FND_API.G_RET_STS_SUCCESS) THEN
5649: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_UPDATE_ERROR');
5650: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE_ONETIME_ADDRESS');
5651: FND_MSG_PUB.ADD;
5652:
5653: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN

Line 5650: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE_ONETIME_ADDRESS');

5646: );
5647:
5648: IF (l_return_status_onetime <> FND_API.G_RET_STS_SUCCESS) THEN
5649: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_UPDATE_ERROR');
5650: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE_ONETIME_ADDRESS');
5651: FND_MSG_PUB.ADD;
5652:
5653: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN
5654: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';

Line 5700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');

5696: l_service_request_rec.incident_country := l_old_servicerequest_rec.incident_country;
5697: l_service_request_rec.incident_addr_lines_phonetic := l_old_servicerequest_rec.incident_addr_lines_phonetic;
5698: l_service_request_rec.incident_postal_plus4_code := l_old_servicerequest_rec.incident_postal_plus4_code;
5699: --End of changes for bug 8594093
5700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
5701: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
5702: FND_MSG_PUB.ADD;
5703:
5704: END IF;

Line 5701: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');

5697: l_service_request_rec.incident_addr_lines_phonetic := l_old_servicerequest_rec.incident_addr_lines_phonetic;
5698: l_service_request_rec.incident_postal_plus4_code := l_old_servicerequest_rec.incident_postal_plus4_code;
5699: --End of changes for bug 8594093
5700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
5701: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
5702: FND_MSG_PUB.ADD;
5703:
5704: END IF;
5705: END IF;

Line 5759: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');

5755: x_return_status => l_project_info_status,
5756: x_error_msg => l_msg_data );
5757: END IF;
5758: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5759: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5760: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5761: FND_MSG_PUB.ADD;
5762: END IF;
5763:

Line 5760: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');

5756: x_error_msg => l_msg_data );
5757: END IF;
5758: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5759: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5760: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5761: FND_MSG_PUB.ADD;
5762: END IF;
5763:
5764: --validate all newly passed values

Line 5777: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');

5773: x_error_msg => l_msg_data );
5774: END IF;
5775:
5776: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5777: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5778: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5779: FND_MSG_PUB.ADD;
5780: END IF;
5781:

Line 5778: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');

5774: END IF;
5775:
5776: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5777: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5778: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5779: FND_MSG_PUB.ADD;
5780: END IF;
5781:
5782:

Line 5796: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');

5792:
5793: --if validation fails then dont update the SR raise error
5794: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5795: /*
5796: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5797: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE SERVICE_REQUEST');
5798: FND_MSG_PUB.ADD;
5799: */
5800: RAISE FND_API.G_EXC_ERROR ;

Line 5797: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE SERVICE_REQUEST');

5793: --if validation fails then dont update the SR raise error
5794: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5795: /*
5796: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5797: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE SERVICE_REQUEST');
5798: FND_MSG_PUB.ADD;
5799: */
5800: RAISE FND_API.G_EXC_ERROR ;
5801: --ROLLBACK TO Update_ServiceRequest_PVT;

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

7138: x_return_status := FND_API.G_RET_STS_SUCCESS;
7139: ELSE
7140: x_return_status := FND_API.G_RET_STS_ERROR;
7141: END IF;
7142: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
7143: FND_MSG_PUB.ADD;
7144: FND_MSG_PUB.Count_And_Get
7145: ( p_count => x_msg_count,
7146: p_data => x_msg_data

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

7150: IF (l_ServiceRequest_csr%ISOPEN) THEN
7151: CLOSE l_ServiceRequest_csr;
7152: END IF;
7153: x_return_status := FND_API.G_RET_STS_ERROR;
7154: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
7155: FND_MSG_PUB.ADD;
7156: FND_MSG_PUB.Count_And_Get
7157: ( p_count => x_msg_count,
7158: p_data => x_msg_data

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

7162: IF (l_ServiceRequest_csr%ISOPEN) THEN
7163: CLOSE l_ServiceRequest_csr;
7164: END IF;
7165: x_return_status := FND_API.G_RET_STS_SUCCESS;
7166: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
7167: FND_MSG_PUB.ADD;
7168: FND_MSG_PUB.Count_And_Get
7169: ( p_count => x_msg_count,
7170: p_data => x_msg_data

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

7174: IF (l_ServiceRequest_csr%ISOPEN) THEN
7175: CLOSE l_ServiceRequest_csr;
7176: END IF;
7177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7178: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
7179: FND_MSG_PUB.ADD;
7180: FND_MSG_PUB.Count_And_Get
7181: ( p_count => x_msg_count,
7182: p_data => x_msg_data

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

7185: --- For BUG # 2933250
7186: WHEN invalid_install_site THEN
7187: ROLLBACK TO Update_ServiceRequest_PVT;
7188: x_return_status := FND_API.G_RET_STS_ERROR;
7189: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
7190: FND_MSG_PUB.ADD;
7191: FND_MSG_PUB.Count_And_Get
7192: ( p_count => x_msg_count,
7193: p_data => x_msg_data

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

7609: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7610:
7611: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
7612: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);

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

7611: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
7612: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;

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

7612: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;
7620: END IF; -- l_pending approval flag is Y

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

7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;
7620: END IF; -- l_pending approval flag is Y
7621: END IF; -- if after get_status_details call

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

7636: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7637: THEN
7638: /*
7639: IF l_sr_related_data.pending_approval_flag = 'Y' THEN
7640: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
7641: FND_MESSAGE.set_token
7642: ( 'API_NAME'
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );

Line 7641: FND_MESSAGE.set_token

7637: THEN
7638: /*
7639: IF l_sr_related_data.pending_approval_flag = 'Y' THEN
7640: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
7641: FND_MESSAGE.set_token
7642: ( 'API_NAME'
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );
7645: FND_MESSAGE.set_token('STATUS_ID',p_status_id);

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

7641: FND_MESSAGE.set_token
7642: ( 'API_NAME'
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );
7645: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
7646: FND_MSG_PUB.ADD_DETAIL
7647: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
7648: );
7649: RAISE FND_API.G_EXC_ERROR;

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

8591: , x_return_status => l_return_status
8592: );
8593: IF l_sr_related_data.disallow_request_update = 'Y'
8594: THEN
8595: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
8596: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
8597: FND_MSG_PUB.add_detail
8598: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
8599: );

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

8592: );
8593: IF l_sr_related_data.disallow_request_update = 'Y'
8594: THEN
8595: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
8596: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
8597: FND_MSG_PUB.add_detail
8598: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
8599: );
8600: RAISE FND_API.G_EXC_ERROR;

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

8614: OR (l_ServiceRequest_rec.owner_group_id <> l_owner_group_id)
8615: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
8616: THEN
8617: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8618: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
8619: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
8620: FND_MSG_PUB.ADD;
8621: END IF;
8622: RAISE FND_API.G_EXC_ERROR;

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

8615: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
8616: THEN
8617: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8618: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
8619: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
8620: FND_MSG_PUB.ADD;
8621: END IF;
8622: RAISE FND_API.G_EXC_ERROR;
8623: END IF;

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

10287: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;
10288:
10289: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
10290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
10292: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
10293: FND_MSG_PUB.ADD;
10294: END IF;
10295: x_return_status := FND_API.G_RET_STS_ERROR;

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

10288:
10289: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
10290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
10292: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
10293: FND_MSG_PUB.ADD;
10294: END IF;
10295: x_return_status := FND_API.G_RET_STS_ERROR;
10296: RETURN;

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

11997: THEN
11998: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11999: l_service_request_rec.bill_to_party_id IS NULL) THEN
12000:
12001: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12002: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
12003: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12004: fnd_msg_pub.ADD;
12005:

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

11998: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
11999: l_service_request_rec.bill_to_party_id IS NULL) THEN
12000:
12001: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12002: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
12003: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12004: fnd_msg_pub.ADD;
12005:
12006: RAISE FND_API.G_EXC_ERROR;

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

11999: l_service_request_rec.bill_to_party_id IS NULL) THEN
12000:
12001: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12002: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
12003: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12004: fnd_msg_pub.ADD;
12005:
12006: RAISE FND_API.G_EXC_ERROR;
12007: END IF;

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

12014: THEN
12015: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12016: l_service_request_rec.bill_to_party_id IS NULL) THEN
12017:
12018: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12019: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
12020: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12021: fnd_msg_pub.ADD;
12022:

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

12015: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12016: l_service_request_rec.bill_to_party_id IS NULL) THEN
12017:
12018: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12019: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
12020: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12021: fnd_msg_pub.ADD;
12022:
12023: RAISE FND_API.G_EXC_ERROR;

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

12016: l_service_request_rec.bill_to_party_id IS NULL) THEN
12017:
12018: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12019: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
12020: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12021: fnd_msg_pub.ADD;
12022:
12023: RAISE FND_API.G_EXC_ERROR;
12024: END IF;

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

12031: THEN
12032: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12033: l_service_request_rec.bill_to_party_id IS NULL) THEN
12034:
12035: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12036: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
12037: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12038: fnd_msg_pub.ADD;
12039:

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

12032: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12033: l_service_request_rec.bill_to_party_id IS NULL) THEN
12034:
12035: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12036: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
12037: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12038: fnd_msg_pub.ADD;
12039:
12040: RAISE FND_API.G_EXC_ERROR;

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

12033: l_service_request_rec.bill_to_party_id IS NULL) THEN
12034:
12035: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12036: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
12037: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12038: fnd_msg_pub.ADD;
12039:
12040: RAISE FND_API.G_EXC_ERROR;
12041: END IF;

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

12048: THEN
12049: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12050: l_service_request_rec.bill_to_party_id IS NULL) THEN
12051:
12052: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12053: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
12054: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12055: fnd_msg_pub.ADD;
12056:

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

12049: IF (l_service_request_rec.bill_to_party_id = FND_API.G_MISS_NUM OR
12050: l_service_request_rec.bill_to_party_id IS NULL) THEN
12051:
12052: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12053: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
12054: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12055: fnd_msg_pub.ADD;
12056:
12057: RAISE FND_API.G_EXC_ERROR;

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

12050: l_service_request_rec.bill_to_party_id IS NULL) THEN
12051:
12052: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12053: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
12054: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12055: fnd_msg_pub.ADD;
12056:
12057: RAISE FND_API.G_EXC_ERROR;
12058: END IF;

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

12065: THEN
12066: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12067: l_service_request_rec.ship_to_party_id IS NULL) THEN
12068:
12069: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12070: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
12071: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12072: fnd_msg_pub.ADD;
12073:

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

12066: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12067: l_service_request_rec.ship_to_party_id IS NULL) THEN
12068:
12069: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12070: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
12071: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12072: fnd_msg_pub.ADD;
12073:
12074: RAISE FND_API.G_EXC_ERROR;

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

12067: l_service_request_rec.ship_to_party_id IS NULL) THEN
12068:
12069: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12070: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
12071: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12072: fnd_msg_pub.ADD;
12073:
12074: RAISE FND_API.G_EXC_ERROR;
12075: END IF;

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

12082: THEN
12083: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12084: l_service_request_rec.ship_to_party_id IS NULL) THEN
12085:
12086: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12087: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
12088: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12089: fnd_msg_pub.ADD;
12090:

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

12083: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12084: l_service_request_rec.ship_to_party_id IS NULL) THEN
12085:
12086: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12087: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
12088: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12089: fnd_msg_pub.ADD;
12090:
12091: RAISE FND_API.G_EXC_ERROR;

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

12084: l_service_request_rec.ship_to_party_id IS NULL) THEN
12085:
12086: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12087: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
12088: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12089: fnd_msg_pub.ADD;
12090:
12091: RAISE FND_API.G_EXC_ERROR;
12092: END IF;

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

12099: THEN
12100: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12101: l_service_request_rec.ship_to_party_id IS NULL) THEN
12102:
12103: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12104: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
12105: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12106: fnd_msg_pub.ADD;
12107:

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

12100: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12101: l_service_request_rec.ship_to_party_id IS NULL) THEN
12102:
12103: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12104: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
12105: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12106: fnd_msg_pub.ADD;
12107:
12108: RAISE FND_API.G_EXC_ERROR;

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

12101: l_service_request_rec.ship_to_party_id IS NULL) THEN
12102:
12103: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12104: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
12105: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12106: fnd_msg_pub.ADD;
12107:
12108: RAISE FND_API.G_EXC_ERROR;
12109: END IF;

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

12116: THEN
12117: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12118: l_service_request_rec.ship_to_party_id IS NULL) THEN
12119:
12120: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12121: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
12122: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12123: fnd_msg_pub.ADD;
12124:

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

12117: IF (l_service_request_rec.ship_to_party_id = FND_API.G_MISS_NUM OR
12118: l_service_request_rec.ship_to_party_id IS NULL) THEN
12119:
12120: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12121: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
12122: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12123: fnd_msg_pub.ADD;
12124:
12125: RAISE FND_API.G_EXC_ERROR;

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

12118: l_service_request_rec.ship_to_party_id IS NULL) THEN
12119:
12120: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12121: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
12122: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12123: fnd_msg_pub.ADD;
12124:
12125: RAISE FND_API.G_EXC_ERROR;
12126: END IF;

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

15947: l_service_request_rec.customer_id IS NULL THEN
15948: -- Check if one passed is same as old.
15949: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
15950:
15951: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15952: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
15953: FND_MSG_PUB.ADD;
15954: RAISE FND_API.G_EXC_ERROR;
15955: END IF; ---customer_id <> old customer_id

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

15948: -- Check if one passed is same as old.
15949: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
15950:
15951: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15952: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
15953: FND_MSG_PUB.ADD;
15954: RAISE FND_API.G_EXC_ERROR;
15955: END IF; ---customer_id <> old customer_id
15956: ELSE

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

15960: IF (l_service_request_rec.customer_number <> FND_API.G_MISS_CHAR)
15961: AND (l_service_request_rec.customer_number IS NOT NULL ) THEN
15962: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
15963:
15964: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15965: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
15966: FND_MSG_PUB.ADD;
15967: RAISE FND_API.G_EXC_ERROR;
15968: END IF; ---customer_number <> old customer_number

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

15961: AND (l_service_request_rec.customer_number IS NOT NULL ) THEN
15962: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
15963:
15964: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15965: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
15966: FND_MSG_PUB.ADD;
15967: RAISE FND_API.G_EXC_ERROR;
15968: END IF; ---customer_number <> old customer_number
15969: END IF; -- customer number is passed

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

16042: IF (l_service_request_rec.type_id <> FND_API.G_MISS_NUM) AND
16043: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
16044:
16045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16046: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
16047: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16048: FND_MSG_PUB.ADD;
16049: END IF;
16050: RAISE FND_API.G_EXC_ERROR;

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

16043: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
16044:
16045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16046: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
16047: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16048: FND_MSG_PUB.ADD;
16049: END IF;
16050: RAISE FND_API.G_EXC_ERROR;
16051: END IF;

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

16057: (l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM AND
16058: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
16059:
16060: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16061: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
16062: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16063: FND_MSG_PUB.ADD;
16064: END IF;
16065: RAISE FND_API.G_EXC_ERROR;

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

16058: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
16059:
16060: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16061: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
16062: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16063: FND_MSG_PUB.ADD;
16064: END IF;
16065: RAISE FND_API.G_EXC_ERROR;
16066: END IF;

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

16217:
16218: IF l_sr_related_data.old_pending_approval_flag = 'Y' AND
16219: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
16220: THEN
16221: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
16222: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16223: FND_MSG_PUB.ADD_DETAIL
16224: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
16225: );

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

16218: IF l_sr_related_data.old_pending_approval_flag = 'Y' AND
16219: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
16220: THEN
16221: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
16222: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16223: FND_MSG_PUB.ADD_DETAIL
16224: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
16225: );
16226: RAISE FND_API.G_EXC_ERROR;

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

16244: (NVL(l_service_request_rec.resource_type,'x') <> FND_API.G_MISS_CHAR AND
16245: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
16246: THEN
16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
16252: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'

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

16245: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
16246: THEN
16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
16252: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
16253: );

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

16303: END IF;
16304:
16305: IF l_cust_product_changed = 'Y' THEN
16306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16307: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16308: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16309: FND_MSG_PUB.ADD;
16310: END IF;
16311: END IF;

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

16304:
16305: IF l_cust_product_changed = 'Y' THEN
16306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16307: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16308: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16309: FND_MSG_PUB.ADD;
16310: END IF;
16311: END IF;
16312: --End of changes for bug 14242503

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

16343: l_service_request_rec.current_serial_number :=l_old_ServiceRequest_rec.current_serial_number;
16344: --Commented out below code and move the code up for bug 14242503
16345: /*
16346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16347: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16348: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16349: FND_MSG_PUB.ADD;
16350: END IF; */
16351: END IF;

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

16344: --Commented out below code and move the code up for bug 14242503
16345: /*
16346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16347: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16348: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16349: FND_MSG_PUB.ADD;
16350: END IF; */
16351: END IF;
16352: END IF; /* end of validation level check */

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

20721: OPEN C;
20722: FETCH C INTO RECINFO;
20723: IF (C%NOTFOUND) THEN
20724: CLOSE C;
20725: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
20726: FND_MSG_PUB.ADD;
20727: APP_EXCEPTION.RAISE_EXCEPTION;
20728: END IF;
20729: CLOSE C;

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

20730:
20731: IF (RECINFO.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER) THEN
20732: NULL;
20733: ELSE
20734: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
20735: FND_MSG_PUB.ADD;
20736: APP_EXCEPTION.RAISE_EXCEPTION;
20737: END IF;
20738:

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

21222: , 'p_processing_set_id should not be NULL.'
21223: );
21224: END IF ;
21225:
21226: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21227: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21228: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
21229: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
21230: FND_MSG_PUB.ADD;

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

21223: );
21224: END IF ;
21225:
21226: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21227: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21228: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
21229: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
21230: FND_MSG_PUB.ADD;
21231:

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

21224: END IF ;
21225:
21226: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21227: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21228: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
21229: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
21230: FND_MSG_PUB.ADD;
21231:
21232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

21225:
21226: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21227: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21228: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
21229: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
21230: FND_MSG_PUB.ADD;
21231:
21232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21233: END IF;

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

21246: , 'p_purge_source_with_open_task value is invalid.'
21247: );
21248: END IF ;
21249:
21250: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21251: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21252: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
21253: FND_MESSAGE.Set_Token
21254: (

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

21247: );
21248: END IF ;
21249:
21250: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21251: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21252: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
21253: FND_MESSAGE.Set_Token
21254: (
21255: 'CURRVAL'

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

21248: END IF ;
21249:
21250: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21251: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21252: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
21253: FND_MESSAGE.Set_Token
21254: (
21255: 'CURRVAL'
21256: , NVL(p_purge_source_with_open_task, 'NULL')

Line 21253: FND_MESSAGE.Set_Token

21249:
21250: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21251: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21252: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
21253: FND_MESSAGE.Set_Token
21254: (
21255: 'CURRVAL'
21256: , NVL(p_purge_source_with_open_task, 'NULL')
21257: );

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

21274: , 'p_audit_required value is invalid.'
21275: );
21276: END IF ;
21277:
21278: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21279: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21280: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
21281: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
21282: FND_MSG_PUB.ADD;

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

21275: );
21276: END IF ;
21277:
21278: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21279: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21280: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
21281: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
21282: FND_MSG_PUB.ADD;
21283:

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

21276: END IF ;
21277:
21278: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21279: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21280: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
21281: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
21282: FND_MSG_PUB.ADD;
21283:
21284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

21277:
21278: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21279: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21280: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
21281: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
21282: FND_MSG_PUB.ADD;
21283:
21284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21285: END IF;

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

21440: END IF ;
21441:
21442: WHEN OTHERS THEN
21443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21444: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
21445: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21446: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
21447: FND_MSG_PUB.ADD;
21448:

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

21441:
21442: WHEN OTHERS THEN
21443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21444: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
21445: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21446: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
21447: FND_MSG_PUB.ADD;
21448:
21449: FND_MSG_PUB.Count_And_Get

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

21442: WHEN OTHERS THEN
21443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21444: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
21445: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21446: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
21447: FND_MSG_PUB.ADD;
21448:
21449: FND_MSG_PUB.Count_And_Get
21450: (