163:
164: WHEN OTHERS THEN
165: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
164: WHEN OTHERS THEN
165: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
169: FND_MSG_PUB.ADD;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
172: p_data => x_msg_data);
286:
287: EXCEPTION
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
291: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_count => x_msg_count,
287: EXCEPTION
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
291: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_count => x_msg_count,
295: p_data => x_msg_data);
424:
425: WHEN OTHERS THEN
426: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
429: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_count => x_msg_count,
425: WHEN OTHERS THEN
426: ROLLBACK TO CREATE_INCIDENTLINK_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
429: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_count => x_msg_count,
433: p_data => x_msg_data);
611:
612: WHEN OTHERS THEN
613: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
617: FND_MSG_PUB.ADD;
618: FND_MSG_PUB.Count_And_Get(
619: p_count => x_msg_count,
612: WHEN OTHERS THEN
613: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
617: FND_MSG_PUB.ADD;
618: FND_MSG_PUB.Count_And_Get(
619: p_count => x_msg_count,
620: p_data => x_msg_data );
731:
732: EXCEPTION
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(
739: p_count => x_msg_count,
732: EXCEPTION
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
736: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(
739: p_count => x_msg_count,
740: p_data => x_msg_data);
866:
867: WHEN OTHERS THEN
868: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
871: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_count => x_msg_count,
867: WHEN OTHERS THEN
868: ROLLBACK TO UPDATE_INCIDENTLINK_PUB;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
871: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_count => x_msg_count,
875: p_data => x_msg_data );
975: WHEN OTHERS THEN
976: ROLLBACK TO DELETE_INCIDENTLINK_PUB;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
980: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
981: FND_MSG_PUB.ADD;
982: FND_MSG_PUB.Count_And_Get(
983: p_count => x_msg_count,
976: ROLLBACK TO DELETE_INCIDENTLINK_PUB;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
980: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
981: FND_MSG_PUB.ADD;
982: FND_MSG_PUB.Count_And_Get(
983: p_count => x_msg_count,
984: p_data => x_msg_data);
1161: p_data => x_msg_data);
1162:
1163: WHEN OTHERS THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1166: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.Count_And_Get(
1169: p_count => x_msg_count,
1162:
1163: WHEN OTHERS THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1166: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.Count_And_Get(
1169: p_count => x_msg_count,
1170: p_data => x_msg_data);
1450: p_data => x_msg_data);
1451:
1452: WHEN OTHERS THEN
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1455: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1456: FND_MSG_PUB.ADD;
1457: FND_MSG_PUB.Count_And_Get(
1458: p_count => x_msg_count,
1451:
1452: WHEN OTHERS THEN
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1455: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1456: FND_MSG_PUB.ADD;
1457: FND_MSG_PUB.Count_And_Get(
1458: p_count => x_msg_count,
1459: p_data => x_msg_data);
1611: p_data => x_msg_data);
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1617: FND_MSG_PUB.ADD;
1618: FND_MSG_PUB.Count_And_Get(
1619: p_count => x_msg_count,
1612:
1613: WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1616: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1617: FND_MSG_PUB.ADD;
1618: FND_MSG_PUB.Count_And_Get(
1619: p_count => x_msg_count,
1620: p_data => x_msg_data);