141:
142: -- Validate parameters
143: IF (p_incident_id is null) THEN
144: aso_debug_pub.add(l_api_name_full || ': invalid input parameter: p_incident_id', 1, 'Y');
145: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
146: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
147: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
148: FND_MSG_PUB.Add;
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: -- Validate parameters
143: IF (p_incident_id is null) THEN
144: aso_debug_pub.add(l_api_name_full || ': invalid input parameter: p_incident_id', 1, 'Y');
145: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
146: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
147: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
148: FND_MSG_PUB.Add;
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
143: IF (p_incident_id is null) THEN
144: aso_debug_pub.add(l_api_name_full || ': invalid input parameter: p_incident_id', 1, 'Y');
145: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
146: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
147: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
148: FND_MSG_PUB.Add;
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
283: );
284: WHEN OTHERS THEN
285: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
286: ROLLBACK TO CS_MultiOrg_PVT;
287: fnd_message.set_name('CS','CS_CHG_Get_OrgId_FAILED');
288: fnd_message.set_token('ROUTINE',l_api_name_full);
289: fnd_message.set_token('REASON',g_oraerrmsg);
290: FND_MSG_PUB.Add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: WHEN OTHERS THEN
285: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
286: ROLLBACK TO CS_MultiOrg_PVT;
287: fnd_message.set_name('CS','CS_CHG_Get_OrgId_FAILED');
288: fnd_message.set_token('ROUTINE',l_api_name_full);
289: fnd_message.set_token('REASON',g_oraerrmsg);
290: FND_MSG_PUB.Add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292: IF FND_MSG_PUB.Check_Msg_Level
285: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
286: ROLLBACK TO CS_MultiOrg_PVT;
287: fnd_message.set_name('CS','CS_CHG_Get_OrgId_FAILED');
288: fnd_message.set_token('ROUTINE',l_api_name_full);
289: fnd_message.set_token('REASON',g_oraerrmsg);
290: FND_MSG_PUB.Add;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292: IF FND_MSG_PUB.Check_Msg_Level
293: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)