DBA Data[Home] [Help]

APPS.FTE_FPA_UTIL dependencies on WSH_UTIL_CORE

Line 89: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

85: END IF;
86: --
87: --
88: -- Initialize API return status to success
89: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
90: x_msg_count := 0;
91: x_msg_data := 0;
92:
93:

Line 185: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

181: WSH_DEBUG_SV.pop(l_module_name);
182: END IF;
183:
184: WHEN OTHERS THEN
185: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
186: FND_MSG_PUB.Count_And_Get
187: (
188: p_count => x_msg_count,
189: p_data => x_msg_data,

Line 1326: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1322: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1323: END IF;
1324:
1325: -- Initialize API return status to success
1326: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1327: x_msg_count := 0;
1328: x_msg_data := '';
1329:
1330:

Line 1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1528: END IF;
1529:
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1533: x_msg_data := ' Error Message = '||SQLERRM||' Code = '||SQLCODE;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.log(l_module_name,x_msg_data);

Line 1689: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1685: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1686: END IF;
1687:
1688: -- Initialize API return status to success
1689: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1690: x_msg_count := 0;
1691: x_msg_data := '';
1692:
1693:

Line 1868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1864:
1865: EXCEPTION
1866:
1867: WHEN OTHERS THEN
1868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1869: x_msg_data := ' Error Message = '||SQLERRM||' Code = '||SQLCODE;
1870:
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.log(l_module_name,x_msg_data);

Line 1983: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1979: NULL;
1980:
1981: SAVEPOINT GET_LEGAL_ENTITY_PUB;
1982:
1983: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1984: x_msg_data := '';
1985: x_msg_count := 0;
1986: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1987: l_number_of_warnings := 0;

Line 1986: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1982:
1983: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1984: x_msg_data := '';
1985: x_msg_count := 0;
1986: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1987: l_number_of_warnings := 0;
1988: l_number_of_errors := 0;
1989:
1990:

Line 2010: wsh_util_core.api_post_call(

2006: );
2007:
2008: x_legal_entity_id := l_inv_org_rec(1).legal_entity_id;
2009:
2010: wsh_util_core.api_post_call(
2011: p_return_status =>l_return_status,
2012: x_num_warnings =>l_number_of_warnings,
2013: x_num_errors =>l_number_of_errors,
2014: p_msg_data =>l_msg_data);

Line 2018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2014: p_msg_data =>l_msg_data);
2015:
2016:
2017: IF l_number_of_errors > 0 THEN
2018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2019: ELSIF l_number_of_warnings > 0 THEN
2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2021: ELSE
2022: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2016:
2017: IF l_number_of_errors > 0 THEN
2018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2019: ELSIF l_number_of_warnings > 0 THEN
2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2021: ELSE
2022: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2023: END IF;
2024:

Line 2022: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2019: ELSIF l_number_of_warnings > 0 THEN
2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2021: ELSE
2022: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2023: END IF;
2024:
2025: FND_MSG_PUB.Count_And_Get
2026: (

Line 2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2051:
2052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2053:
2054: ROLLBACK TO GET_LEGAL_ENTITY_PUB;
2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2056: FND_MSG_PUB.Count_And_Get
2057: (
2058: p_count => x_msg_count,
2059: p_data => x_msg_data,

Line 2069: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2065: END IF;
2066:
2067: WHEN OTHERS THEN
2068: ROLLBACK TO GET_LEGAL_ENTITY_PUB;
2069: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2070: FND_MSG_PUB.Count_And_Get
2071: (
2072: p_count => x_msg_count,
2073: p_data => x_msg_data,

Line 2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2468:
2469:
2470:
2471: IF l_result THEN
2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2473: ELSE
2474:
2475: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2476: IF l_debug_on THEN

Line 2475: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2471: IF l_result THEN
2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2473: ELSE
2474:
2475: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2476: IF l_debug_on THEN
2477:
2478: WSH_DEBUG_SV.log(l_module_name,'Error Message' , l_errmsg);
2479: END IF;

Line 2493: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2489: RETURN l_return_status;
2490:
2491: EXCEPTION
2492: WHEN OTHERS THEN
2493: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2494:
2495: IF l_debug_on THEN
2496: WSH_DEBUG_SV.log(l_module_name,'Unexpected Error occured in START_FRACCT_WF_PROCESS' || SQLERRM);
2497: WSH_DEBUG_SV.pop(l_module_name);

Line 2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2648: END IF;
2649: --
2650: --
2651: -- Initialize API return status to success
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2653: x_msg_count := 0;
2654: x_msg_data := 0;
2655:
2656: INSERT INTO FTE_FAILURE_REASONS

Line 2717: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

2713: p_encoded => FND_API.G_FALSE
2714: );
2715: WHEN OTHERS THEN
2716: ROLLBACK TO LOG_FAILURE_REASON_PUB;
2717: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
2718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2719: FND_MSG_PUB.Count_And_Get
2720: (
2721: p_count => x_msg_count,

Line 2718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2714: );
2715: WHEN OTHERS THEN
2716: ROLLBACK TO LOG_FAILURE_REASON_PUB;
2717: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
2718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2719: FND_MSG_PUB.Count_And_Get
2720: (
2721: p_count => x_msg_count,
2722: p_data => x_msg_data,