DBA Data[Home] [Help]

APPS.FTE_TENDER_WF dependencies on FND_API

Line 111: p_init_msg_list => FND_API.G_FALSE,

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',
113: p_parent_id => P_SHIPMENT_STATUS_ID,
114: p_failure_type => 'FTE_TENDER_XML_FAILURE',
115: p_failure_reason => 'FTE_XML_INVALID_TENDER',

Line 128: p_init_msg_list => FND_API.G_FALSE,

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',
130: p_parent_id => P_SHIPMENT_STATUS_ID,
131: p_failure_type => 'FTE_TENDER_XML_FAILURE',
132: p_failure_reason => 'FTE_XML_OLD_MESSAGE',

Line 157: p_init_msg_list => FND_API.G_FALSE,

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',
159: p_parent_id => P_SHIPMENT_STATUS_ID,
160: p_failure_type => 'FTE_TENDER_XML_FAILURE',
161: p_failure_reason => 'FTE_XML_INVALID_TENDER_STATUS',

Line 174: p_encoded => FND_API.G_FALSE

170: FND_MSG_PUB.Count_And_Get
171: (
172: p_count => l_msg_count,
173: p_data => l_msg_data,
174: p_encoded => FND_API.G_FALSE
175: );
176:
177: --}
178: EXCEPTION

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176:
177: --}
178: EXCEPTION
179: --{
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO VALIDATE_XML_INFO_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: (

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178: EXCEPTION
179: --{
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO VALIDATE_XML_INFO_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => l_msg_count,
186: p_data => l_msg_data,

Line 187: p_encoded => FND_API.G_FALSE

183: FND_MSG_PUB.Count_And_Get
184: (
185: p_count => l_msg_count,
186: p_data => l_msg_data,
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: p_count => l_msg_count,
186: p_data => l_msg_data,
187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get
193: (

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

187: p_encoded => FND_API.G_FALSE
188: );
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO VALIDATE_XML_INFO_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => l_msg_count,
195: p_data => l_msg_data,

Line 196: p_encoded => FND_API.G_FALSE

192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => l_msg_count,
195: p_data => l_msg_data,
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');

Line 206: p_encoded => FND_API.G_FALSE

202: FND_MSG_PUB.Count_And_Get
203: (
204: p_count => l_msg_count,
205: p_data => l_msg_data,
206: p_encoded => FND_API.G_FALSE
207: );
208:
209: --}
210:

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

239:
240:
241:
242: PROCEDURE GET_SERVICE_VEHICLE_INFO(
243: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
244: p_tender_id IN NUMBER,
245: x_vehicle_type OUT NOCOPY VARCHAR2,
246: x_vehicle_class OUT NOCOPY VARCHAR2,
247: x_service_level OUT NOCOPY VARCHAR2) IS

Line 291: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

287:
288: END GET_SERVICE_VEHICLE_INFO;
289:
290: PROCEDURE GET_MBOL_NUMBER(
291: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: p_tender_id IN NUMBER,
293: p_generate_mbol IN BOOLEAN,
294: x_mbol_number OUT NOCOPY VARCHAR2) IS
295:

Line 681: (p_init_msg_list => FND_API.G_FALSE,

677:
678:
679: -- org and shipment info
680: FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION
681: (p_init_msg_list => FND_API.G_FALSE,
682: p_tender_number => l_tender_id,
683: x_return_status => l_return_status,
684: x_msg_count => l_msg_count,
685: x_msg_data => l_msg_data,

Line 842: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

838: -- 2005 SHRAVISA Updated --
839: -- ------------------------------------------------------------------------------- --
840:
841: PROCEDURE UPDATE_CARRIER_RESPONSE(
842: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
843: p_tender_id IN NUMBER,
844: p_tender_status IN VARCHAR2,
845: p_wf_item_key IN VARCHAR2,
846: p_remarks IN VARCHAR2,

Line 890: IF FND_API.to_Boolean( p_init_msg_list )

886: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
887:
888: SAVEPOINT UPDATE_CARRIER_RESPONSE_PUB;
889:
890: IF FND_API.to_Boolean( p_init_msg_list )
891: THEN
892: FND_MSG_PUB.initialize;
893: END IF;
894: --

Line 947: p_init_msg_list => FND_API.G_TRUE,

943: null,null);
944:
945:
946: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
947: p_init_msg_list => FND_API.G_TRUE,
948: x_return_status => x_return_status,
949: x_msg_count => x_msg_count,
950: x_msg_data => x_msg_data,
951: x_action_out_rec => l_action_out_rec,

Line 964: p_encoded => FND_API.G_FALSE

960: FND_MSG_PUB.Count_And_Get
961: (
962: p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => FND_API.G_FALSE
965: );
966: --
967: --
968:

Line 977: WHEN FND_API.G_EXC_ERROR THEN

973:
974:
975: EXCEPTION
976:
977: WHEN FND_API.G_EXC_ERROR THEN
978: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: FND_MSG_PUB.Count_And_Get
981: (

Line 979: x_return_status := FND_API.G_RET_STS_ERROR ;

975: EXCEPTION
976:
977: WHEN FND_API.G_EXC_ERROR THEN
978: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: FND_MSG_PUB.Count_And_Get
981: (
982: p_count => x_msg_count,
983: p_data => x_msg_data,

Line 984: p_encoded => FND_API.G_FALSE

980: FND_MSG_PUB.Count_And_Get
981: (
982: p_count => x_msg_count,
983: p_data => x_msg_data,
984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

982: p_count => x_msg_count,
983: p_data => x_msg_data,
984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
989: FND_MSG_PUB.Count_And_Get
990: (

Line 988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

984: p_encoded => FND_API.G_FALSE
985: );
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
989: FND_MSG_PUB.Count_And_Get
990: (
991: p_count => x_msg_count,
992: p_data => x_msg_data,

Line 993: p_encoded => FND_API.G_FALSE

989: FND_MSG_PUB.Count_And_Get
990: (
991: p_count => x_msg_count,
992: p_data => x_msg_data,
993: p_encoded => FND_API.G_FALSE
994: );
995:
996: WHEN OTHERS THEN
997: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;

Line 1004: p_encoded => FND_API.G_FALSE

1000: FND_MSG_PUB.Count_And_Get
1001: (
1002: p_count => x_msg_count,
1003: p_data => x_msg_data,
1004: p_encoded => FND_API.G_FALSE
1005: );
1006:
1007:
1008: END UPDATE_CARRIER_RESPONSE;

Line 1145: p_init_msg_list => FND_API.G_TRUE,

1141: null,null);
1142:
1143:
1144: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
1145: p_init_msg_list => FND_API.G_TRUE,
1146: x_return_status => l_return_status,
1147: x_msg_count => l_msg_count,
1148: x_msg_data => l_msg_data,
1149: x_action_out_rec => l_action_out_rec,

Line 1307: p_init_msg_list => FND_API.G_TRUE,

1303: null,null);
1304:
1305:
1306: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
1307: p_init_msg_list => FND_API.G_TRUE,
1308: x_return_status => l_return_status,
1309: x_msg_count => l_msg_count,
1310: x_msg_data => l_msg_data,
1311: x_action_out_rec => l_action_out_rec,

Line 2080: p_init_msg_list => FND_API.G_TRUE,

2076: END IF;
2077:
2078:
2079: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
2080: p_init_msg_list => FND_API.G_TRUE,
2081: x_return_status => l_return_status,
2082: x_msg_count => l_msg_count,
2083: x_msg_data => l_msg_data,
2084: x_action_out_rec => l_action_out_rec,

Line 2243: p_init_msg_list => FND_API.G_TRUE,

2239: null,null);
2240:
2241:
2242: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
2243: p_init_msg_list => FND_API.G_TRUE,
2244: x_return_status => l_return_status,
2245: x_msg_count => l_msg_count,
2246: x_msg_data => l_msg_data,
2247: x_action_out_rec => l_action_out_rec,

Line 2383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2379: -- Get response by date, tendered date, handling info pickup date from GET_TENDER_INFO
2380: -- Reminder time
2381:
2382: PROCEDURE GET_TENDER_INFO(
2383: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2384: p_tender_id IN NUMBER,
2385: x_return_status OUT NOCOPY VARCHAR2,
2386: x_msg_count OUT NOCOPY NUMBER,
2387: x_msg_data OUT NOCOPY VARCHAR2,

Line 2429: IF FND_API.to_Boolean( p_init_msg_list )

2425: --
2426: -- Initialize message list if p_init_msg_list is set to TRUE.
2427: --
2428: --
2429: IF FND_API.to_Boolean( p_init_msg_list )
2430: THEN
2431: FND_MSG_PUB.initialize;
2432: END IF;
2433: --

Line 2486: RAISE FND_API.G_EXC_ERROR;

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);
2490: --l_respond_by_text := x_tendered_date + l_wait_time_days/(60*24);

Line 2514: RAISE FND_API.G_EXC_ERROR;

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);
2518: l_temp_value := l_temp_value - (l_rem_days*60*24);

Line 2539: p_encoded => FND_API.G_FALSE

2535: FND_MSG_PUB.Count_And_Get
2536: (
2537: p_count => x_msg_count,
2538: p_data => x_msg_data,
2539: p_encoded => FND_API.G_FALSE
2540: );
2541: --
2542: --
2543: IF l_debug_on THEN

Line 2550: WHEN FND_API.G_EXC_ERROR THEN

2546:
2547: --}
2548: EXCEPTION
2549: --{
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: ROLLBACK TO GET_TENDER_INFO_PUB;
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: FND_MSG_PUB.Count_And_Get
2554: (

Line 2552: x_return_status := FND_API.G_RET_STS_ERROR ;

2548: EXCEPTION
2549: --{
2550: WHEN FND_API.G_EXC_ERROR THEN
2551: ROLLBACK TO GET_TENDER_INFO_PUB;
2552: x_return_status := FND_API.G_RET_STS_ERROR ;
2553: FND_MSG_PUB.Count_And_Get
2554: (
2555: p_count => x_msg_count,
2556: p_data => x_msg_data,

Line 2557: p_encoded => FND_API.G_FALSE

2553: FND_MSG_PUB.Count_And_Get
2554: (
2555: p_count => x_msg_count,
2556: p_data => x_msg_data,
2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2555: p_count => x_msg_count,
2556: p_data => x_msg_data,
2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: FND_MSG_PUB.Count_And_Get
2563: (

Line 2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2557: p_encoded => FND_API.G_FALSE
2558: );
2559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2560: ROLLBACK TO GET_TENDER_INFO_PUB;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: FND_MSG_PUB.Count_And_Get
2563: (
2564: p_count => x_msg_count,
2565: p_data => x_msg_data,

Line 2566: p_encoded => FND_API.G_FALSE

2562: FND_MSG_PUB.Count_And_Get
2563: (
2564: p_count => x_msg_count,
2565: p_data => x_msg_data,
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');

Line 2576: p_encoded => FND_API.G_FALSE

2572: FND_MSG_PUB.Count_And_Get
2573: (
2574: p_count => x_msg_count,
2575: p_data => x_msg_data,
2576: p_encoded => FND_API.G_FALSE
2577: );
2578:
2579: --}
2580:

Line 2758: p_init_msg_list => FND_API.G_FALSE,

2754: l_delivery_leg_activity_rec.rank_version := l_rank_version;
2755:
2756:
2757: FTE_DELIVERY_ACTIVITY.ADD_HISTORY(
2758: p_init_msg_list => FND_API.G_FALSE,
2759: p_trip_id => l_trip_id,
2760: p_delivery_leg_activity_rec => l_delivery_leg_activity_rec,
2761: x_return_status => l_return_status,
2762: x_msg_count => l_msg_count,

Line 2984: P_INIT_MSG_LIST => FND_API.G_FALSE,

2980: null,l_appendFlag);
2981:
2982:
2983: FTE_SS_INTERFACE.SEARCH_SERVICES(
2984: P_INIT_MSG_LIST => FND_API.G_FALSE,
2985: P_API_VERSION_NUMBER => 1.0,
2986: P_COMMIT => FND_API.G_FALSE,
2987: P_CALLER => FTE_SS_INTERFACE.S_CALLER_WF,
2988: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,

Line 2986: P_COMMIT => FND_API.G_FALSE,

2982:
2983: FTE_SS_INTERFACE.SEARCH_SERVICES(
2984: P_INIT_MSG_LIST => FND_API.G_FALSE,
2985: P_API_VERSION_NUMBER => 1.0,
2986: P_COMMIT => FND_API.G_FALSE,
2987: P_CALLER => FTE_SS_INTERFACE.S_CALLER_WF,
2988: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,
2989: X_RATING_REQUEST_ID => l_rating_request_id,
2990: X_LIST_CREATE_TYPE => l_LIST_CREATE_TYPE,

Line 3109: p_init_msg_list => FND_API.G_TRUE,

3105: END IF;
3106:
3107:
3108: FTE_CARRIER_RANK_LIST_PVT.IS_RANK_LIST_EXHAUSTED(
3109: p_init_msg_list => FND_API.G_TRUE,
3110: x_is_exhausted => l_is_exhausted,
3111: x_return_status => l_return_status,
3112: x_msg_count => l_msg_count,
3113: x_msg_data => l_msg_data,

Line 3228: p_init_msg_list => FND_API.G_TRUE,

3224: l_trip_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TRIP_ID');
3225: l_priceRequestId := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PRICE_REQUEST_ID');
3226:
3227: FTE_CARRIER_RANK_LIST_PVT.REMOVE_SERVICE_APPLY_NEXT(
3228: p_init_msg_list => FND_API.G_TRUE,
3229: x_return_status => l_return_status,
3230: x_msg_count => l_msg_count,
3231: x_msg_data => l_msg_data,
3232: p_trip_id => l_trip_id,

Line 3348: p_init_msg_list => FND_API.G_TRUE,

3344: null,null);
3345:
3346: FTE_MLS_WRAPPER.Trip_Action (
3347: p_api_version_number => 1.0,
3348: p_init_msg_list => FND_API.G_TRUE,
3349: x_return_status => l_return_status,
3350: x_msg_count => l_msg_count,
3351: x_msg_data => l_msg_data,
3352: x_action_out_rec => l_action_out_rec,