eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIPS_PUB dependencies on FND_API

Line 18: -- p_init_msg_list FND_API.G_TRUE to reset list

14: --========================================================================
15: -- PROCEDURE : Trip_Action PUBLIC
16: --
17: -- PARAMETERS: p_api_version_number known api version error number
18: -- p_init_msg_list FND_API.G_TRUE to reset list
19: -- x_return_status return status
20: -- x_msg_count number of messages in the list
21: -- x_msg_data text of messages
22: -- p_action_code Trip action code. Valid action codes are

Line 91: IF NOT FND_API.Compatible_API_Call

87: wsh_debug_sv.log (l_module_name,'p_report_set_name',
88: p_report_set_name);
89: END IF;
90:
91: IF NOT FND_API.Compatible_API_Call
92: ( l_api_version_number
93: , p_api_version_number
94: , l_api_name
95: , G_PKG_NAME

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: , l_api_name
95: , G_PKG_NAME
96: )
97: THEN
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: -- Initialize message stack if required
102: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 102: IF FND_API.to_Boolean(p_init_msg_list) THEN

98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: -- Initialize message stack if required
102: IF FND_API.to_Boolean(p_init_msg_list) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: --

Line 118: AND p_report_set_name <> fnd_api.G_MISS_CHAR

114: raise trip_action_error;
115: END IF;
116:
117: IF p_report_set_name IS NOT NULL
118: AND p_report_set_name <> fnd_api.G_MISS_CHAR
119: AND p_action_code = 'PRINT-DOC-SETS' THEN
120: WSH_UTIL_VALIDATE.validate_report_set(
121: p_report_set_id => l_report_set_id,
122: p_report_set_name => p_report_set_name,

Line 146: p_init_msg_list => FND_API.G_FALSE,

142: l_action_prms.override_flag := p_wv_override_flag;
143:
144: WSH_INTERFACE_GRP.Trip_Action(
145: p_api_version_number => 1.0,
146: p_init_msg_list => FND_API.G_FALSE,
147: p_commit => FND_API.G_TRUE,
148: p_entity_id_tab => l_entity_id_tab,
149: p_action_prms => l_action_prms,
150: x_trip_out_rec => l_trip_out_rec,

Line 147: p_commit => FND_API.G_TRUE,

143:
144: WSH_INTERFACE_GRP.Trip_Action(
145: p_api_version_number => 1.0,
146: p_init_msg_list => FND_API.G_FALSE,
147: p_commit => FND_API.G_TRUE,
148: p_entity_id_tab => l_entity_id_tab,
149: p_action_prms => l_action_prms,
150: x_trip_out_rec => l_trip_out_rec,
151: x_return_status => l_return_status,

Line 164: ,p_encoded => FND_API.G_FALSE

160:
161: FND_MSG_PUB.Count_And_Get
162: ( p_count => x_msg_count
163: , p_data => x_msg_data
164: ,p_encoded => FND_API.G_FALSE
165: );
166:
167: IF l_debug_on THEN
168: WSH_DEBUG_SV.pop(l_module_name);

Line 182: ,p_encoded => FND_API.G_FALSE

178: wsh_util_core.add_message(x_return_status,l_module_name);
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count
181: , p_data => x_msg_data
182: ,p_encoded => FND_API.G_FALSE
183: );
184: IF l_debug_on THEN
185: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
186: WSH_DEBUG_SV.pop(l_module_name);

Line 189: WHEN FND_API.G_EXC_ERROR THEN

185: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
186: WSH_DEBUG_SV.pop(l_module_name);
187: END IF;
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: -- Get message count and data
192: FND_MSG_PUB.Count_And_Get
193: ( p_count => x_msg_count

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: WSH_DEBUG_SV.pop(l_module_name);
187: END IF;
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: -- Get message count and data
192: FND_MSG_PUB.Count_And_Get
193: ( p_count => x_msg_count
194: , p_data => x_msg_data

Line 195: ,p_encoded => FND_API.G_FALSE

191: -- Get message count and data
192: FND_MSG_PUB.Count_And_Get
193: ( p_count => x_msg_count
194: , p_data => x_msg_data
195: ,p_encoded => FND_API.G_FALSE
196: );
197: IF l_debug_on THEN
198: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
199: WSH_DEBUG_SV.pop(l_module_name);

Line 202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

198: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
199: WSH_DEBUG_SV.pop(l_module_name);
200: END IF;
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: -- Get message count and data
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

199: WSH_DEBUG_SV.pop(l_module_name);
200: END IF;
201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
204: -- Get message count and data
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count
207: , p_data => x_msg_data

Line 208: ,p_encoded => FND_API.G_FALSE

204: -- Get message count and data
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count
207: , p_data => x_msg_data
208: ,p_encoded => FND_API.G_FALSE
209: );
210: IF l_debug_on THEN
211: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
212: WSH_DEBUG_SV.pop(l_module_name);

Line 222: ,p_encoded => FND_API.G_FALSE

218: -- Get message count and data
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count
221: , p_data => x_msg_data
222: ,p_encoded => FND_API.G_FALSE
223: );
224: IF l_debug_on THEN
225: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
226: WSH_DEBUG_SV.pop(l_module_name);

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

227: END IF;
228:
229:
230: WHEN OTHERS THEN
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME

Line 243: ,p_encoded => FND_API.G_FALSE

239: -- Get message count and data
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count
242: , p_data => x_msg_data
243: ,p_encoded => FND_API.G_FALSE
244: );
245: IF l_debug_on THEN
246: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
247: WSH_DEBUG_SV.pop(l_module_name);

Line 257: -- p_init_msg_list FND_API.G_TRUE to reset list

253: --========================================================================
254: -- PROCEDURE : Trip_Action PUBLIC
255: --
256: -- PARAMETERS: p_api_version_number known api version error number
257: -- p_init_msg_list FND_API.G_TRUE to reset list
258: -- p_commit FND_API.G_TRUE to commit
259: -- x_return_status return status
260: -- x_msg_count number of messages in the list
261: -- x_msg_data text of messages

Line 258: -- p_commit FND_API.G_TRUE to commit

254: -- PROCEDURE : Trip_Action PUBLIC
255: --
256: -- PARAMETERS: p_api_version_number known api version error number
257: -- p_init_msg_list FND_API.G_TRUE to reset list
258: -- p_commit FND_API.G_TRUE to commit
259: -- x_return_status return status
260: -- x_msg_count number of messages in the list
261: -- x_msg_data text of messages
262: -- p_action_param_rec Action Parameters Valid action codes are

Line 339: IF NOT FND_API.Compatible_API_Call

335: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
336: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
337: END IF;
338:
339: IF NOT FND_API.Compatible_API_Call
340: ( l_api_version_number
341: , p_api_version_number
342: , l_api_name
343: , G_PKG_NAME

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

342: , l_api_name
343: , G_PKG_NAME
344: )
345: THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: -- Initialize message stack if required
350: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 350: IF FND_API.to_Boolean(p_init_msg_list) THEN

346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: -- Initialize message stack if required
350: IF FND_API.to_Boolean(p_init_msg_list) THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353:
354: --

Line 367: AND p_action_param_rec.report_set_name <> fnd_api.G_MISS_CHAR

363: END IF;
364:
365:
366: IF p_action_param_rec.report_set_name IS NOT NULL
367: AND p_action_param_rec.report_set_name <> fnd_api.G_MISS_CHAR
368: AND p_action_param_rec.action_code = 'PRINT-DOC-SETS' THEN
369: WSH_UTIL_VALIDATE.validate_report_set(
370: p_report_set_id => l_report_set_id,
371: p_report_set_name => p_action_param_rec.report_set_name,

Line 409: p_init_msg_list => FND_API.G_FALSE,

405: l_action_prms.actual_departure_date := p_action_param_rec.actual_departure_date;
406:
407: WSH_INTERFACE_GRP.Trip_Action(
408: p_api_version_number => 1.0,
409: p_init_msg_list => FND_API.G_FALSE,
410: p_commit => FND_API.G_FALSE,
411: p_entity_id_tab => l_entity_id_tab,
412: p_action_prms => l_action_prms,
413: x_trip_out_rec => l_trip_out_rec,

Line 410: p_commit => FND_API.G_FALSE,

406:
407: WSH_INTERFACE_GRP.Trip_Action(
408: p_api_version_number => 1.0,
409: p_init_msg_list => FND_API.G_FALSE,
410: p_commit => FND_API.G_FALSE,
411: p_entity_id_tab => l_entity_id_tab,
412: p_action_prms => l_action_prms,
413: x_trip_out_rec => l_trip_out_rec,
414: x_return_status => l_return_status,

Line 427: ,p_encoded => FND_API.G_FALSE

423:
424: FND_MSG_PUB.Count_And_Get
425: ( p_count => x_msg_count
426: , p_data => x_msg_data
427: ,p_encoded => FND_API.G_FALSE
428: );
429:
430: IF FND_API.to_boolean(p_commit) AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
431: COMMIT;

Line 430: IF FND_API.to_boolean(p_commit) AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

426: , p_data => x_msg_data
427: ,p_encoded => FND_API.G_FALSE
428: );
429:
430: IF FND_API.to_boolean(p_commit) AND x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
431: COMMIT;
432: END IF;
433:
434: IF l_debug_on THEN

Line 449: ,p_encoded => FND_API.G_FALSE

445: wsh_util_core.add_message(x_return_status,l_module_name);
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count
448: , p_data => x_msg_data
449: ,p_encoded => FND_API.G_FALSE
450: );
451: IF l_debug_on THEN
452: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
453: WSH_DEBUG_SV.pop(l_module_name);

Line 456: WHEN FND_API.G_EXC_ERROR THEN

452: wsh_debug_sv.log (l_module_name,'EXCEPTION:trip_action_error');
453: WSH_DEBUG_SV.pop(l_module_name);
454: END IF;
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: -- Get message count and data
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

453: WSH_DEBUG_SV.pop(l_module_name);
454: END IF;
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: -- Get message count and data
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count
461: , p_data => x_msg_data

Line 462: ,p_encoded => FND_API.G_FALSE

458: -- Get message count and data
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count
461: , p_data => x_msg_data
462: ,p_encoded => FND_API.G_FALSE
463: );
464: IF l_debug_on THEN
465: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
466: WSH_DEBUG_SV.pop(l_module_name);

Line 469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

465: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_EXC_ERROR');
466: WSH_DEBUG_SV.pop(l_module_name);
467: END IF;
468:
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: -- Get message count and data
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

466: WSH_DEBUG_SV.pop(l_module_name);
467: END IF;
468:
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: -- Get message count and data
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count
474: , p_data => x_msg_data

Line 475: ,p_encoded => FND_API.G_FALSE

471: -- Get message count and data
472: FND_MSG_PUB.Count_And_Get
473: ( p_count => x_msg_count
474: , p_data => x_msg_data
475: ,p_encoded => FND_API.G_FALSE
476: );
477: IF l_debug_on THEN
478: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
479: WSH_DEBUG_SV.pop(l_module_name);

Line 489: ,p_encoded => FND_API.G_FALSE

485: -- Get message count and data
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count
488: , p_data => x_msg_data
489: ,p_encoded => FND_API.G_FALSE
490: );
491: IF l_debug_on THEN
492: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_WARNING');
493: WSH_DEBUG_SV.pop(l_module_name);

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

494: END IF;
495:
496:
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME

Line 510: ,p_encoded => FND_API.G_FALSE

506: -- Get message count and data
507: FND_MSG_PUB.Count_And_Get
508: ( p_count => x_msg_count
509: , p_data => x_msg_data
510: ,p_encoded => FND_API.G_FALSE
511: );
512: IF l_debug_on THEN
513: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
514: WSH_DEBUG_SV.pop(l_module_name);

Line 554: x_pvt_trip_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;

550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551:
552: x_pvt_trip_rec.TRIP_ID := p_pub_trip_rec.TRIP_ID;
553: x_pvt_trip_rec.NAME := p_pub_trip_rec.NAME;
554: x_pvt_trip_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
555: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_ID := p_pub_trip_rec.ARRIVE_AFTER_TRIP_ID;
556: x_pvt_trip_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
557: x_pvt_trip_rec.VEHICLE_ITEM_ID := p_pub_trip_rec.VEHICLE_ITEM_ID;
558: x_pvt_trip_rec.VEHICLE_ORGANIZATION_ID := p_pub_trip_rec.VEHICLE_ORGANIZATION_ID;

Line 556: x_pvt_trip_rec.STATUS_CODE := FND_API.G_MISS_CHAR;

552: x_pvt_trip_rec.TRIP_ID := p_pub_trip_rec.TRIP_ID;
553: x_pvt_trip_rec.NAME := p_pub_trip_rec.NAME;
554: x_pvt_trip_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
555: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_ID := p_pub_trip_rec.ARRIVE_AFTER_TRIP_ID;
556: x_pvt_trip_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
557: x_pvt_trip_rec.VEHICLE_ITEM_ID := p_pub_trip_rec.VEHICLE_ITEM_ID;
558: x_pvt_trip_rec.VEHICLE_ORGANIZATION_ID := p_pub_trip_rec.VEHICLE_ORGANIZATION_ID;
559: x_pvt_trip_rec.VEHICLE_NUMBER := p_pub_trip_rec.VEHICLE_NUMBER;
560: x_pvt_trip_rec.VEHICLE_NUM_PREFIX := p_pub_trip_rec.VEHICLE_NUM_PREFIX;

Line 593: IF p_pub_trip_rec.freight_terms_name <> FND_API.G_MISS_CHAR

589: x_pvt_trip_rec.REQUEST_ID := p_pub_trip_rec.REQUEST_ID;
590: x_pvt_trip_rec.SERVICE_LEVEL := p_pub_trip_rec.SERVICE_LEVEL;
591: x_pvt_trip_rec.MODE_OF_TRANSPORT := p_pub_trip_rec.MODE_OF_TRANSPORT;
592:
593: IF p_pub_trip_rec.freight_terms_name <> FND_API.G_MISS_CHAR
594: AND p_pub_trip_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
595: --
596: l_freight_terms_code := NULL;
597: wsh_util_validate.validate_freight_terms(

Line 594: AND p_pub_trip_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

590: x_pvt_trip_rec.SERVICE_LEVEL := p_pub_trip_rec.SERVICE_LEVEL;
591: x_pvt_trip_rec.MODE_OF_TRANSPORT := p_pub_trip_rec.MODE_OF_TRANSPORT;
592:
593: IF p_pub_trip_rec.freight_terms_name <> FND_API.G_MISS_CHAR
594: AND p_pub_trip_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
595: --
596: l_freight_terms_code := NULL;
597: wsh_util_validate.validate_freight_terms(
598: p_freight_terms_code => l_freight_terms_code,

Line 613: AND p_pub_trip_rec.freight_Terms_code = FND_API.G_MISS_CHAR THEN

609: x_num_errors => l_num_errors);
610: --
611: ELSE
612: IF p_pub_trip_rec.freight_terms_name IS NULL
613: AND p_pub_trip_rec.freight_Terms_code = FND_API.G_MISS_CHAR THEN
614: l_freight_terms_code := NULL;
615: ELSE
616: l_freight_terms_code := p_pub_trip_rec.freight_terms_code;
617: END IF;

Line 621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;

617: END IF;
618: END IF;
619:
620: x_pvt_trip_rec.FREIGHT_TERMS_CODE := l_freight_terms_code;
621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;

Line 622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;

618: END IF;
619:
620: x_pvt_trip_rec.FREIGHT_TERMS_CODE := l_freight_terms_code;
621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;

Line 623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;

619:
620: x_pvt_trip_rec.FREIGHT_TERMS_CODE := l_freight_terms_code;
621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;
627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;

Line 624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;

620: x_pvt_trip_rec.FREIGHT_TERMS_CODE := l_freight_terms_code;
621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;
627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;
628: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_NAME := p_pub_trip_rec.ARRIVE_AFTER_TRIP_NAME;

Line 625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;

621: x_pvt_trip_rec.CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;
627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;
628: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_NAME := p_pub_trip_rec.ARRIVE_AFTER_TRIP_NAME;
629: x_pvt_trip_rec.SHIP_METHOD_NAME := p_pub_trip_rec.SHIP_METHOD_NAME;

Line 626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;

622: x_pvt_trip_rec.LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;
627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;
628: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_NAME := p_pub_trip_rec.ARRIVE_AFTER_TRIP_NAME;
629: x_pvt_trip_rec.SHIP_METHOD_NAME := p_pub_trip_rec.SHIP_METHOD_NAME;
630: x_pvt_trip_rec.VEHICLE_ITEM_DESC := p_pub_trip_rec.VEHICLE_ITEM_DESC;

Line 627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;

623: x_pvt_trip_rec.ROUTE_LANE_ID := FND_API.G_MISS_NUM;
624: x_pvt_trip_rec.LANE_ID := FND_API.G_MISS_NUM;
625: x_pvt_trip_rec.SCHEDULE_ID := FND_API.G_MISS_NUM;
626: x_pvt_trip_rec.BOOKING_NUMBER := FND_API.G_MISS_CHAR;
627: --x_pvt_trip_rec.ROWID := FND_API.G_MISS_CHAR;
628: x_pvt_trip_rec.ARRIVE_AFTER_TRIP_NAME := p_pub_trip_rec.ARRIVE_AFTER_TRIP_NAME;
629: x_pvt_trip_rec.SHIP_METHOD_NAME := p_pub_trip_rec.SHIP_METHOD_NAME;
630: x_pvt_trip_rec.VEHICLE_ITEM_DESC := p_pub_trip_rec.VEHICLE_ITEM_DESC;
631: x_pvt_trip_rec.VEHICLE_ORGANIZATION_CODE := p_pub_trip_rec.VEHICLE_ORGANIZATION_CODE;

Line 642: WHEN FND_API.G_EXC_ERROR THEN

638: WSH_DEBUG_SV.pop(l_module_name);
639: END IF;
640: --
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639: END IF;
640: --
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

642: WHEN FND_API.G_EXC_ERROR THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

643: x_return_status := FND_API.G_RET_STS_ERROR;
644: -- caller will handle this exception
645: IF l_debug_on THEN
646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

646: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: -- caller will handle this exception
653:
654: IF l_debug_on THEN

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
648: END IF;
649: --
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: -- caller will handle this exception
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: -- caller will handle this exception
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
657: END IF;
658: --
659:

Line 656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

652: -- caller will handle this exception
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
657: END IF;
658: --
659:
660: WHEN OTHERS THEN

Line 676: -- p_init_msg_list FND_API.G_TRUE to reset list

672: --========================================================================
673: -- PROCEDURE : Create_Update_Trip PUBLIC
674: --
675: -- PARAMETERS: p_api_version_number known api versionerror buffer
676: -- p_init_msg_list FND_API.G_TRUE to reset list
677: -- x_return_status return status
678: -- x_msg_count number of messages in the list
679: -- x_msg_data text of messages
680: -- p_trip_info Attributes for the trip entity

Line 698: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

694: x_msg_count OUT NOCOPY NUMBER,
695: x_msg_data OUT NOCOPY VARCHAR2,
696: p_action_code IN VARCHAR2,
697: p_trip_info IN OUT NOCOPY Trip_Pub_Rec_Type,
698: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
699: x_trip_id OUT NOCOPY NUMBER,
700: x_trip_name OUT NOCOPY VARCHAR2) IS
701:
702: l_api_version_number CONSTANT NUMBER := 1.0;

Line 728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN

724: IF l_debug_on THEN
725: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');
726: END IF;
727:
728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');
726: END IF;
727:
728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: IF FND_API.to_Boolean(p_init_msg_list) THEN
733: FND_MSG_PUB.initialize;

Line 732: IF FND_API.to_Boolean(p_init_msg_list) THEN

728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: IF FND_API.to_Boolean(p_init_msg_list) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: map_trippub_to_pvt (

Line 742: raise FND_API.G_EXC_ERROR;

738: x_pvt_trip_rec => l_pvt_trip_rec,
739: x_return_status => x_return_status);
740:
741: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
742: raise FND_API.G_EXC_ERROR;
743: END IF;
744:
745: l_in_rec.caller:='WSH_PUB';
746: l_in_rec.phase:= 1;

Line 749: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN

745: l_in_rec.caller:='WSH_PUB';
746: l_in_rec.phase:= 1;
747: l_in_rec.action_code:= p_action_code;
748:
749: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
750: l_pvt_trip_rec.name := p_trip_name;
751: END IF;
752:
753: IF (l_pvt_trip_rec.name IS NOT NULL AND l_pvt_trip_rec.name <> FND_API.G_MISS_CHAR

Line 753: IF (l_pvt_trip_rec.name IS NOT NULL AND l_pvt_trip_rec.name <> FND_API.G_MISS_CHAR

749: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
750: l_pvt_trip_rec.name := p_trip_name;
751: END IF;
752:
753: IF (l_pvt_trip_rec.name IS NOT NULL AND l_pvt_trip_rec.name <> FND_API.G_MISS_CHAR
754: and l_in_rec.action_code <> 'CREATE') THEN
755: wsh_util_validate.validate_trip_name( l_pvt_trip_rec.trip_id,
756: l_pvt_trip_rec.name,
757: x_return_status);

Line 760: raise FND_API.G_EXC_ERROR;

756: l_pvt_trip_rec.name,
757: x_return_status);
758:
759: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
760: raise FND_API.G_EXC_ERROR;
761: END IF;
762: END IF;
763:
764: IF (l_pvt_trip_rec.arrive_after_trip_name IS NOT NULL

Line 765: AND l_pvt_trip_rec.arrive_after_trip_name <> FND_API.G_MISS_CHAR) THEN

761: END IF;
762: END IF;
763:
764: IF (l_pvt_trip_rec.arrive_after_trip_name IS NOT NULL
765: AND l_pvt_trip_rec.arrive_after_trip_name <> FND_API.G_MISS_CHAR) THEN
766: wsh_util_validate.validate_trip_name( l_pvt_trip_rec.arrive_after_trip_id,
767: l_pvt_trip_rec.arrive_after_trip_name,
768: x_return_status);
769:

Line 771: raise FND_API.G_EXC_ERROR;

767: l_pvt_trip_rec.arrive_after_trip_name,
768: x_return_status);
769:
770: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
771: raise FND_API.G_EXC_ERROR;
772: END IF;
773: END IF;
774:
775: l_trip_info_tab(1):= l_pvt_trip_rec;

Line 805: WHEN FND_API.G_EXC_ERROR THEN

801: WSH_DEBUG_SV.pop(l_module_name);
802: END IF;
803:
804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
807: FND_MSG_PUB.Count_And_Get (
808: p_count => x_msg_count,
809: p_data => x_msg_data,

Line 810: p_encoded => FND_API.G_FALSE);

806: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
807: FND_MSG_PUB.Count_And_Get (
808: p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',

808: p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:

Line 814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

810: p_encoded => FND_API.G_FALSE);
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

813: WSH_DEBUG_SV.C_EXCEP_LEVEL);
814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
815: END IF;
816:
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
819: FND_MSG_PUB.Count_And_Get (
820: p_count => x_msg_count,
821: p_data => x_msg_data,

Line 822: p_encoded => FND_API.G_FALSE);

818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
819: FND_MSG_PUB.Count_And_Get (
820: p_count => x_msg_count,
821: p_data => x_msg_data,
822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

820: p_count => x_msg_count,
821: p_data => x_msg_data,
822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:

Line 826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

822: p_encoded => FND_API.G_FALSE);
823: IF l_debug_on THEN
824: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
825: WSH_DEBUG_SV.C_EXCEP_LEVEL);
826: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
827: END IF;
828:
829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 834: p_encoded => FND_API.G_FALSE);

830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
831: FND_MSG_PUB.Count_And_Get (
832: p_count => x_msg_count,
833: p_data => x_msg_data,
834: p_encoded => FND_API.G_FALSE);
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
837: WSH_DEBUG_SV.C_EXCEP_LEVEL);
838: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 847: p_encoded => FND_API.G_FALSE);

843: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
844: FND_MSG_PUB.Count_And_Get (
845: p_count => x_msg_count,
846: p_data => x_msg_data,
847: p_encoded => FND_API.G_FALSE);
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
850: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');