DBA Data[Home] [Help]

APPS.FTE_MLS_WRAPPER dependencies on FTE_MLS_WRAPPER

Line 1: PACKAGE BODY FTE_MLS_WRAPPER as

1: PACKAGE BODY FTE_MLS_WRAPPER as
2: /* $Header: FTEMLWRB.pls 120.25 2006/06/09 14:43:28 nltan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_WRAPPER';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_WRAPPER';

1: PACKAGE BODY FTE_MLS_WRAPPER as
2: /* $Header: FTEMLWRB.pls 120.25 2006/06/09 14:43:28 nltan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_MLS_WRAPPER';
5:
6: --------------
7: --No wrapper needed for delete delivery
8: -------------

Line 119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;

115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;
120: p_commit VARCHAR2(1);
121: l_stop_seq NUMBER;
122: l_count NUMBER;
123:

Line 236: 'FTE_MLS_WRAPPER.p_is_temp value ',p_is_temp);

232: --call public API
233:
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.log(l_module_name,
236: 'FTE_MLS_WRAPPER.p_is_temp value ',p_is_temp);
237: END IF;
238:
239:
240: IF (p_is_temp = 'N' OR

Line 272: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP x_return_status',x_return_status);

268:
269:
270: IF l_debug_on THEN
271: WSH_DEBUG_SV.log(l_module_name,
272: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP x_return_status',x_return_status);
273: END IF;
274:
275:
276: --# Bug 2911100 : HBHAGAVA

Line 287: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop Seq Number ',

283: l_stop_seq := pp_STOP_SEQUENCE_NUMBER;
284:
285: IF l_debug_on THEN
286: WSH_DEBUG_SV.log(l_module_name,
287: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop Seq Number ',
288: l_stop_seq);
289:
290: WSH_DEBUG_SV.log(l_module_name,
291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',

Line 291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',

287: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop Seq Number ',
288: l_stop_seq);
289:
290: WSH_DEBUG_SV.log(l_module_name,
291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',
292: p_new_stop_sequence);
293:
294: WSH_DEBUG_SV.log(l_module_name,
295: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop stop id ',

Line 295: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop stop id ',

291: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP New Stop Seq Number ',
292: p_new_stop_sequence);
293:
294: WSH_DEBUG_SV.log(l_module_name,
295: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Stop stop id ',
296: p_stop_info.stop_id);
297:
298: END IF;
299:

Line 310: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_stop_seq) := p_stop_info;

306: p_stop_info.STOP_SEQUENCE_NUMBER := p_new_stop_sequence;
307: END IF;
308:
309:
310: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_stop_seq) := p_stop_info;
311:
312: l_stop_seq_rec.OLD_STOP_SEQUENCE_NUMBER := l_stop_seq;
313: l_stop_seq_rec.NEW_STOP_SEQUENCE_NUMBER := p_new_stop_sequence;
314: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_stop_seq) := l_stop_seq_rec;

Line 314: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_stop_seq) := l_stop_seq_rec;

310: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_stop_seq) := p_stop_info;
311:
312: l_stop_seq_rec.OLD_STOP_SEQUENCE_NUMBER := l_stop_seq;
313: l_stop_seq_rec.NEW_STOP_SEQUENCE_NUMBER := p_new_stop_sequence;
314: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_stop_seq) := l_stop_seq_rec;
315: */
316: -- Changed based on shipping changes to stop seq id
317:
318:

Line 319: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(p_new_stop_sequence) := p_stop_info;

315: */
316: -- Changed based on shipping changes to stop seq id
317:
318:
319: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(p_new_stop_sequence) := p_stop_info;
320:
321: l_stop_seq_rec.OLD_STOP_SEQUENCE_NUMBER := l_stop_seq;
322: l_stop_seq_rec.NEW_STOP_SEQUENCE_NUMBER := p_new_stop_sequence;
323: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(p_new_stop_sequence) := l_stop_seq_rec;

Line 323: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(p_new_stop_sequence) := l_stop_seq_rec;

319: FTE_MLS_WRAPPER.G_STOPS_TAB_REC(p_new_stop_sequence) := p_stop_info;
320:
321: l_stop_seq_rec.OLD_STOP_SEQUENCE_NUMBER := l_stop_seq;
322: l_stop_seq_rec.NEW_STOP_SEQUENCE_NUMBER := p_new_stop_sequence;
323: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(p_new_stop_sequence) := l_stop_seq_rec;
324:
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.log(l_module_name,

Line 328: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Adding to temp table');

324:
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.log(l_module_name,
328: 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP Adding to temp table');
329: END IF;
330:
331: END IF;
332:

Line 792: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_MLS_WRAPPER.Delivery_Action');

788: END IF;
789:
790: WHEN OTHERS THEN
791: ROLLBACK TO DELIVERY_ACTION_PUB;
792: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_MLS_WRAPPER.Delivery_Action');
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: FND_MSG_PUB.Count_And_Get
795: (
796: p_count => x_msg_count,

Line 2636: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,

2632: null, --wf item key
2633: null,null,null,null,null,null,null,null,null);
2634:
2635:
2636: FTE_MLS_WRAPPER.Trip_Action (p_api_version_number => 1.0,
2637: p_init_msg_list => FND_API.G_TRUE,
2638: x_return_status => l_return_status,
2639: x_msg_count => l_msg_count,
2640: x_msg_data => l_msg_data,

Line 3378: FTE_MLS_WRAPPER.G_STOPS_TAB_REC.delete;

3374: END IF;
3375:
3376:
3377:
3378: FTE_MLS_WRAPPER.G_STOPS_TAB_REC.delete;
3379: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB.delete;
3380:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );

Line 3379: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB.delete;

3375:
3376:
3377:
3378: FTE_MLS_WRAPPER.G_STOPS_TAB_REC.delete;
3379: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB.delete;
3380:
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_TAB_REC ' );
3383: WSH_DEBUG_SV.logmsg(l_module_name, ' deleteing G_STOPS_SEQ_TAB ' );

Line 3560: l_stop_info := FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_index);

3556: l_idx := 1;
3557: WHILE l_index IS NOT NULL
3558: LOOP
3559:
3560: l_stop_info := FTE_MLS_WRAPPER.G_STOPS_TAB_REC(l_index);
3561:
3562: IF l_debug_on THEN
3563: WSH_DEBUG_SV.logmsg(l_module_name, ' Index ' || l_index);
3564: WSH_DEBUG_SV.logmsg(l_module_name,' stop seq ' || l_stop_info.STOP_SEQUENCE_NUMBER);

Line 3570: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).NEW_STOP_SEQUENCE_NUMBER;

3566: END IF;
3567:
3568: /** Changes based on the wsh stop seq changes
3569: l_stop_info.STOP_SEQUENCE_NUMBER :=
3570: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).NEW_STOP_SEQUENCE_NUMBER;
3571: */
3572: l_stop_info.STOP_SEQUENCE_NUMBER :=
3573: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).OLD_STOP_SEQUENCE_NUMBER;
3574:

Line 3573: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).OLD_STOP_SEQUENCE_NUMBER;

3569: l_stop_info.STOP_SEQUENCE_NUMBER :=
3570: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).NEW_STOP_SEQUENCE_NUMBER;
3571: */
3572: l_stop_info.STOP_SEQUENCE_NUMBER :=
3573: FTE_MLS_WRAPPER.G_STOPS_SEQ_TAB(l_index).OLD_STOP_SEQUENCE_NUMBER;
3574:
3575:
3576: IF (l_stop_info.STOP_ID IS NULL)
3577: THEN

Line 6536: FTE_MLS_WRAPPER.TENDER_TRIPS

6532: l_trip_id_tab := FTE_ID_TAB_TYPE();
6533: l_trip_id_tab.EXTEND;
6534: l_trip_id_tab(l_trip_id_tab.COUNT) := p_tripId;
6535:
6536: FTE_MLS_WRAPPER.TENDER_TRIPS
6537: ( p_api_version_number => 1.0,
6538: p_init_msg_list => FND_API.G_FALSE,
6539: p_trip_id_tab => l_trip_id_tab,
6540: p_caller => 'BE', --Back end

Line 6627: -- FTE_MLS_WRAPPER and raises appropriate select service

6623: --========================================================================
6624: -- PROCEDURE : UPDATE_SERVICE_TO_TRIP FTE wrapper
6625: --
6626: -- COMMENT : Procedure updates trip with new service by calling
6627: -- FTE_MLS_WRAPPER and raises appropriate select service
6628: -- or cancel service event.
6629: -- ORIG CALLER : FTE_UI: TripWB, DeliveryWB, ManageItinerary
6630: --
6631: -- SERVICE_ACTION: 'UPDATE' means overwriting existing service.

Line 6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');

6728: x_num_errors =>l_number_of_errors,
6729: p_msg_data =>l_msg_data);
6730:
6731: IF l_debug_on THEN
6732: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.CREATE_UPD_TRIP');
6733: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
6734: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
6735: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
6736: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);

Line 6916: END FTE_MLS_WRAPPER;

6912:
6913: END INITIALIZE_TRIP_REC;
6914:
6915: --
6916: END FTE_MLS_WRAPPER;