DBA Data[Home] [Help]

APPS.FTE_TENDER_WF dependencies on WSH_UTIL_CORE

Line 27: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

23:
24: -- Standard Start of API savepoint
25: SAVEPOINT GET_DOCK_CLOSE_DATE_PUB;
26:
27: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
28: l_location_id := p_loc_id;
29: l_date := p_tender_date;
30:
31: WSH_CALENDAR_ACTIONS.Get_Shift_Times

Line 58: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: ROLLBACK TO GET_DOCK_CLOSE_DATE_PUB;
58: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
59:
60: END GET_DOCK_CLOSE_DATE;
61:
62:

Line 93: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

89: -- Standard Start of API savepoint
90: SAVEPOINT VALIDATE_XML_INFO_PUB;
91:
92:
93: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
94: l_msg_count := 0;
95: l_msg_data := '';
96:
97:

Line 108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

104: FETCH c_tender_check into l_trip_id , l_item_key;
105:
106: IF c_tender_check%NOTFOUND THEN
107:
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109:
110: FTE_FPA_UTIL.LOG_FAILURE_REASON(
111: p_init_msg_list => FND_API.G_FALSE,
112: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',

Line 125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

121: ELSE
122:
123: IF nvl(l_item_key,'-11') <> nvl(P_WF_ITEM_KEY,'-12') THEN
124:
125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
126:
127: FTE_FPA_UTIL.LOG_FAILURE_REASON(
128: p_init_msg_list => FND_API.G_FALSE,
129: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',

Line 144: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

140: END IF;
141:
142: CLOSE c_tender_check;
143:
144: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
145: RETURN;
146: END IF;
147:
148:

Line 154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

150: -- Check for Load Tender Status
151: ---------------------------------------------
152: IF P_TENDER_STATUS NOT IN (FTE_TENDER_PVT.S_ACCEPTED,FTE_TENDER_PVT.S_REJECTED) THEN
153:
154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
155:
156: FTE_FPA_UTIL.LOG_FAILURE_REASON(
157: p_init_msg_list => FND_API.G_FALSE,
158: p_parent_name => 'FTE_SHIPMENT_STATUS_HEADERS',

Line 200: wsh_util_core.default_handler('FTE_TENDER_WF.VALIDATE_XML_INFO_PUB');

196: p_encoded => FND_API.G_FALSE
197: );
198: WHEN OTHERS THEN
199: ROLLBACK TO VALIDATE_XML_INFO_PUB;
200: wsh_util_core.default_handler('FTE_TENDER_WF.VALIDATE_XML_INFO_PUB');
201: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get
203: (
204: p_count => l_msg_count,

Line 201: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

197: );
198: WHEN OTHERS THEN
199: ROLLBACK TO VALIDATE_XML_INFO_PUB;
200: wsh_util_core.default_handler('FTE_TENDER_WF.VALIDATE_XML_INFO_PUB');
201: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get
203: (
204: p_count => l_msg_count,
205: p_data => l_msg_data,

Line 586: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

582:
583: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
584: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_shipper_wait_time);
585: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM',l_wait_time_uom);
586: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
587: l_msg_string := FTE_MLS_UTIL.GET_MESSAGE(l_msg_count,l_msg_data);
588:
589:
590: wf_core.TOKEN('ERROR_STRING',l_msg_string);

Line 901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

897: END IF;
898:
899: --
900: -- Initialize API return status to success
901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
902: x_msg_count := 0;
903: x_msg_data := 0;
904:
905: WSH_DEBUG_SV.log(l_module_name,' ************ Parameters ********************* ');

Line 998: wsh_util_core.default_handler('FTE_TENDER_WF.UPDATE_CARRIER_RESPONSE');

994: );
995:
996: WHEN OTHERS THEN
997: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
998: wsh_util_core.default_handler('FTE_TENDER_WF.UPDATE_CARRIER_RESPONSE');
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1000: FND_MSG_PUB.Count_And_Get
1001: (
1002: p_count => x_msg_count,

Line 999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

995:
996: WHEN OTHERS THEN
997: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
998: wsh_util_core.default_handler('FTE_TENDER_WF.UPDATE_CARRIER_RESPONSE');
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1000: FND_MSG_PUB.Count_And_Get
1001: (
1002: p_count => x_msg_count,
1003: p_data => x_msg_data,

Line 2211: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2207: aname => 'CARRIER_NAME',
2208: avalue => wf_engine.GetItemAttrText(
2209: 'FTETEREQ', itemkey, 'CARRIER_NAME'));
2210:
2211: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2212: l_number_of_warnings := 0;
2213: l_number_of_errors := 0;
2214:
2215: l_tender_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TENDER_ID');

Line 2260: wsh_util_core.api_post_call(

2256: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
2257: END IF;
2258:
2259:
2260: wsh_util_core.api_post_call(
2261: p_return_status =>l_return_status,
2262: x_num_warnings =>l_number_of_warnings,
2263: x_num_errors =>l_number_of_errors,
2264: p_msg_data =>l_msg_data);

Line 2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2436: END IF;
2437:
2438: --
2439: -- Initialize API return status to success
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2441: x_msg_count := 0;
2442: x_msg_data := 0;
2443:
2444: --

Line 2485: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2481: THEN
2482: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2483: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_wait_time_days);
2484: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM','DAY');
2485: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2486: RAISE FND_API.G_EXC_ERROR;
2487: END IF;
2488:
2489: x_response_by := (x_tendered_date+l_wait_time_days);

Line 2513: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2509: THEN
2510: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_SHIP_WAITTIME');
2511: FND_MESSAGE.SET_TOKEN('WAIT_TIME',l_temp_value);
2512: FND_MESSAGE.SET_TOKEN('WAIT_TIME_UOM','MIN');
2513: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2514: RAISE FND_API.G_EXC_ERROR;
2515: END IF;
2516:
2517: l_rem_days := trunc(l_temp_value/(60*24),0);

Line 2570: wsh_util_core.default_handler('FTE_TENDER_WF.GET_TENDER_INFO');

2566: p_encoded => FND_API.G_FALSE
2567: );
2568: WHEN OTHERS THEN
2569: ROLLBACK TO GET_TENDER_INFO_PUB;
2570: wsh_util_core.default_handler('FTE_TENDER_WF.GET_TENDER_INFO');
2571: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2572: FND_MSG_PUB.Count_And_Get
2573: (
2574: p_count => x_msg_count,

Line 2571: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2567: );
2568: WHEN OTHERS THEN
2569: ROLLBACK TO GET_TENDER_INFO_PUB;
2570: wsh_util_core.default_handler('FTE_TENDER_WF.GET_TENDER_INFO');
2571: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2572: FND_MSG_PUB.Count_And_Get
2573: (
2574: p_count => x_msg_count,
2575: p_data => x_msg_data,

Line 2927: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2923: --
2924: IF (funcmode = 'RUN') THEN
2925: --
2926:
2927: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2928: l_number_of_warnings := 0;
2929: l_number_of_errors := 0;
2930:
2931:

Line 2949: wsh_util_core.api_post_call(

2945: x_first_stop_loc_id => l_first_stop_loc_id,
2946: x_last_stop_loc_id => l_last_stop_loc_id,
2947: p_trip_id => l_trip_id);
2948:
2949: wsh_util_core.api_post_call(
2950: p_return_status =>l_return_status,
2951: x_num_warnings =>l_number_of_warnings,
2952: x_num_errors =>l_number_of_errors,
2953: p_msg_data =>l_msg_data);

Line 2996: wsh_util_core.api_post_call(

2992: x_return_status => l_return_status,
2993: x_msg_count => l_msg_count,
2994: x_msg_data => l_msg_data);
2995:
2996: wsh_util_core.api_post_call(
2997: p_return_status =>l_return_status,
2998: x_num_warnings =>l_number_of_warnings,
2999: x_num_errors =>l_number_of_errors,
3000: p_msg_data =>l_msg_data);

Line 3096: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3092: WSH_DEBUG_SV.push(l_module_name);
3093: END IF;
3094:
3095:
3096: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3097: l_number_of_warnings := 0;
3098: l_number_of_errors := 0;
3099:
3100: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

Line 3220: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3216: --
3217: IF (funcmode = 'RUN') THEN
3218: --
3219:
3220: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3221: l_number_of_warnings := 0;
3222: l_number_of_errors := 0;
3223:
3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');

Line 3321: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3317: --
3318: IF (funcmode = 'RUN') THEN
3319: --
3320:
3321: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3322: l_number_of_warnings := 0;
3323: l_number_of_errors := 0;
3324:
3325: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');