[Home] [Help]
106:
107:
108: BEGIN
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: --logging the input parameters
113:
114: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
193: );
194: END IF;
195:
196:
197: IF NOT FND_API.Compatible_API_Call
198: (
199: L_API_VERSION
200: , p_api_version_number
201: , L_API_NAME
206: (
207: p_count => x_msg_count
208: , p_data => x_msg_data
209: );
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF ;
212:
213: IF FND_API.to_Boolean(p_init_msg_list)
214: THEN
209: );
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF ;
212:
213: IF FND_API.to_Boolean(p_init_msg_list)
214: THEN
215: FND_MSG_PUB.initialize;
216: END IF ;
217:
449:
450: FND_MESSAGE.Set_Name('CS', 'CS_SR_SUBMIT_CHILD_FAILED');
451: FND_MSG_PUB.ADD;
452:
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
457: THEN
655: FND_MESSAGE.Set_Name('CS', 'CS_SR_GET_CHILD_STAT_FAILED');
656: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
657: FND_MSG_PUB.ADD;
658:
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: END IF;
661:
662: END LOOP;
663:
754: THEN
755: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_RET_STAT');
756: FND_MSG_PUB.ADD;
757:
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761:
762: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
876:
877: EXCEPTION
878:
879: WHEN L_EXC_COST_WARNING THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881:
882: -- setting the completion status as WARNING since
883: -- there was a warning in the execution of this
884: -- request.
938: END LOOP;
939: END IF ;
940: END IF ;
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944:
945: -- setting the completion status as ERROR since
946: -- there was an error in the execution of this
939: END IF ;
940: END IF ;
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944:
945: -- setting the completion status as ERROR since
946: -- there was an error in the execution of this
947: -- request.
972: FND_LOG.String
973: (
974: FND_LOG.level_unexpected
975: , L_LOG_MODULE || 'error'
976: , 'Inside WHEN FND_API.G_EXC_ERROR of ' || L_API_NAME_FULL
977: );
978:
979: x_msg_count := FND_MSG_PUB.Count_Msg;
980:
1000: END LOOP;
1001: END IF ;
1002: END IF ;
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1006:
1007: -- setting the completion status as ERROR since
1008: -- there was an unexpected error in the execution
1001: END IF ;
1002: END IF ;
1003:
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1006:
1007: -- setting the completion status as ERROR since
1008: -- there was an unexpected error in the execution
1009: -- of this request.
1035: FND_LOG.String
1036: (
1037: FND_LOG.level_unexpected
1038: , L_LOG_MODULE || 'unexpected_error'
1039: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
1040: );
1041:
1042: x_msg_count := FND_MSG_PUB.Count_Msg;
1043:
1064: END IF ;
1065: END IF ;
1066:
1067: WHEN OTHERS THEN
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069:
1070: FND_MESSAGE.Set_Name('CS', 'CS_SR_COST_MAIN_FAIL');
1071: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
1072: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
1174:
1175: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_COST_PARAMS');
1176: FND_MSG_PUB.ADD;
1177:
1178: RAISE FND_API.G_EXC_ERROR;
1179:
1180:
1181:
1182: END IF;
1245: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
1246: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
1247: FND_MSG_PUB.ADD;
1248:
1249: RAISE FND_API.G_EXC_ERROR;
1250:
1251:
1252:
1253:
1318: FND_MESSAGE.Set_Token('DATEFIELDNAME', l_prompt);
1319: FND_MESSAGE.Set_Token('FORMAT', fnd_date.user_mask);
1320: FND_MSG_PUB.ADD;
1321:
1322: RAISE FND_API.G_EXC_ERROR;
1323:
1324:
1325:
1326: END IF;
1441:
1442: FND_MESSAGE.Set_Token('DATEFIELDNAME2', l_prompt);
1443: FND_MSG_PUB.ADD;
1444:
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447:
1448: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1449: THEN
1679:
1680:
1681: BEGIN
1682:
1683: x_return_status := FND_API.G_RET_STS_SUCCESS;
1684:
1685: -- capturing the request id of the
1686: -- worker thread into a local variable.
1687:
1705:
1706: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_PARAM_NULL');
1707: FND_MSG_PUB.ADD;
1708:
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711:
1712: BEGIN
1713: SELECT
1738:
1739: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKER_COSTSET_INV');
1740: FND_MSG_PUB.ADD;
1741:
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END;
1744:
1745: -- Opening the cursor inside the loop to avoid
1746: -- the ORA-1555 snapshot too old problem
1787: );
1788:
1789:
1790:
1791: IF x_return_status = FND_API.G_RET_STS_SUCCESS then
1792: p_estimate_detail_id := l_temp_count;
1793:
1794: OPEN c_check_cost;
1795: FETCH c_check_cost into l_cost_id;
1804: WHERE estimate_detail_id = l_temp_count ;
1805: end if;
1806: CLOSE c_check_cost;
1807:
1808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1809: OR x_return_status = FND_API.G_RET_STS_ERROR
1810:
1811: -- If there was an error or unexpected error
1812: -- while executing the SR delete API
1805: end if;
1806: CLOSE c_check_cost;
1807:
1808: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1809: OR x_return_status = FND_API.G_RET_STS_ERROR
1810:
1811: -- If there was an error or unexpected error
1812: -- while executing the SR delete API
1813: