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.FTE_TRIPS_PVT dependencies on WSH_DEBUG_SV

Line 70: -- wsh_debug_sv.start_debug ('FteTrip-' || pp_fte_trip_id);

66: p_trip_info fte_trip_rec_type;
67:
68: BEGIN
69:
70: -- wsh_debug_sv.start_debug ('FteTrip-' || pp_fte_trip_id);
71: wsh_debug_sv.start_debug ('FteTrip');
72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');
73:
74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);

Line 71: wsh_debug_sv.start_debug ('FteTrip');

67:
68: BEGIN
69:
70: -- wsh_debug_sv.start_debug ('FteTrip-' || pp_fte_trip_id);
71: wsh_debug_sv.start_debug ('FteTrip');
72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');
73:
74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);
75: wsh_debug_sv.dlog (c_debug,'Action',p_action_code);

Line 72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');

68: BEGIN
69:
70: -- wsh_debug_sv.start_debug ('FteTrip-' || pp_fte_trip_id);
71: wsh_debug_sv.start_debug ('FteTrip');
72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');
73:
74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);
75: wsh_debug_sv.dlog (c_debug,'Action',p_action_code);
76:

Line 74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);

70: -- wsh_debug_sv.start_debug ('FteTrip-' || pp_fte_trip_id);
71: wsh_debug_sv.start_debug ('FteTrip');
72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');
73:
74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);
75: wsh_debug_sv.dlog (c_debug,'Action',p_action_code);
76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call

Line 75: wsh_debug_sv.dlog (c_debug,'Action',p_action_code);

71: wsh_debug_sv.start_debug ('FteTrip');
72: wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');
73:
74: wsh_debug_sv.dlog (c_debug,'Name',pp_name);
75: wsh_debug_sv.dlog (c_debug,'Action',p_action_code);
76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call
79: ( l_api_version_number

Line 153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

149: p_count => x_msg_count
150: , p_data => x_msg_data
151: );
152:
153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);
155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);
156: wsh_debug_sv.dpop (c_sdebug);
157: wsh_debug_sv.stop_debug;

Line 154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);

150: , p_data => x_msg_data
151: );
152:
153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);
155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);
156: wsh_debug_sv.dpop (c_sdebug);
157: wsh_debug_sv.stop_debug;
158:

Line 155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);

151: );
152:
153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);
155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);
156: wsh_debug_sv.dpop (c_sdebug);
157: wsh_debug_sv.stop_debug;
158:
159: EXCEPTION

Line 156: wsh_debug_sv.dpop (c_sdebug);

152:
153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);
155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);
156: wsh_debug_sv.dpop (c_sdebug);
157: wsh_debug_sv.stop_debug;
158:
159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN

Line 157: wsh_debug_sv.stop_debug;

153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
154: wsh_debug_sv.dlog (c_debug,'Message Count',x_msg_count);
155: wsh_debug_sv.dlog (c_debug,'Message Data',x_msg_data);
156: wsh_debug_sv.dpop (c_sdebug);
157: wsh_debug_sv.stop_debug;
158:
159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;

Line 168: wsh_debug_sv.dlog (c_debug,'In error in Create_Update_Delete');

164: ( p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count
166: , p_data => x_msg_data
167: );
168: wsh_debug_sv.dlog (c_debug,'In error in Create_Update_Delete');
169: wsh_debug_sv.dpop (c_sdebug);
170: wsh_debug_sv.stop_debug;
171:
172:

Line 169: wsh_debug_sv.dpop (c_sdebug);

165: p_count => x_msg_count
166: , p_data => x_msg_data
167: );
168: wsh_debug_sv.dlog (c_debug,'In error in Create_Update_Delete');
169: wsh_debug_sv.dpop (c_sdebug);
170: wsh_debug_sv.stop_debug;
171:
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 170: wsh_debug_sv.stop_debug;

166: , p_data => x_msg_data
167: );
168: wsh_debug_sv.dlog (c_debug,'In error in Create_Update_Delete');
169: wsh_debug_sv.dpop (c_sdebug);
170: wsh_debug_sv.stop_debug;
171:
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 181: wsh_debug_sv.dlog (c_debug,'In Unexpected error in Create_Update_Delete');

177: ( p_encoded => FND_API.G_FALSE,
178: p_count => x_msg_count
179: , p_data => x_msg_data
180: );
181: wsh_debug_sv.dlog (c_debug,'In Unexpected error in Create_Update_Delete');
182: wsh_debug_sv.dpop (c_sdebug);
183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN

Line 182: wsh_debug_sv.dpop (c_sdebug);

178: p_count => x_msg_count
179: , p_data => x_msg_data
180: );
181: wsh_debug_sv.dlog (c_debug,'In Unexpected error in Create_Update_Delete');
182: wsh_debug_sv.dpop (c_sdebug);
183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN
186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');

Line 183: wsh_debug_sv.stop_debug;

179: , p_data => x_msg_data
180: );
181: wsh_debug_sv.dlog (c_debug,'In Unexpected error in Create_Update_Delete');
182: wsh_debug_sv.dpop (c_sdebug);
183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN
186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 193: wsh_debug_sv.dlog (c_debug,'In others in Create_Update_Delete');

189: ( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count
191: , p_data => x_msg_data
192: );
193: wsh_debug_sv.dlog (c_debug,'In others in Create_Update_Delete');
194: wsh_debug_sv.dpop (c_sdebug);
195: wsh_debug_sv.stop_debug;
196:
197: END Create_Update_Delete_Fte_Trip;

Line 194: wsh_debug_sv.dpop (c_sdebug);

190: p_count => x_msg_count
191: , p_data => x_msg_data
192: );
193: wsh_debug_sv.dlog (c_debug,'In others in Create_Update_Delete');
194: wsh_debug_sv.dpop (c_sdebug);
195: wsh_debug_sv.stop_debug;
196:
197: END Create_Update_Delete_Fte_Trip;
198:

Line 195: wsh_debug_sv.stop_debug;

191: , p_data => x_msg_data
192: );
193: wsh_debug_sv.dlog (c_debug,'In others in Create_Update_Delete');
194: wsh_debug_sv.dpop (c_sdebug);
195: wsh_debug_sv.stop_debug;
196:
197: END Create_Update_Delete_Fte_Trip;
198:
199:

Line 240: wsh_debug_sv.dpush (c_sdebug, 'Create_Trip');

236: wsh_duplicate_name EXCEPTION;
237:
238: BEGIN
239:
240: wsh_debug_sv.dpush (c_sdebug, 'Create_Trip');
241:
242: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_info.fte_trip_id);
243: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_info.name);
244:

Line 242: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_info.fte_trip_id);

238: BEGIN
239:
240: wsh_debug_sv.dpush (c_sdebug, 'Create_Trip');
241:
242: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_info.fte_trip_id);
243: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_info.name);
244:
245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
246:

Line 243: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_info.name);

239:
240: wsh_debug_sv.dpush (c_sdebug, 'Create_Trip');
241:
242: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_info.fte_trip_id);
243: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_info.name);
244:
245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
246:
247: x_trip_id := p_trip_info.fte_trip_id;

Line 250: wsh_debug_sv.dlog (c_debug,'about to validate trip id...');

246:
247: x_trip_id := p_trip_info.fte_trip_id;
248: x_name := p_trip_info.name;
249:
250: wsh_debug_sv.dlog (c_debug,'about to validate trip id...');
251:
252: IF (x_trip_id IS NULL) OR (x_trip_id = FND_API.G_MISS_NUM) THEN
253:
254: LOOP

Line 277: wsh_debug_sv.dlog (c_debug,'about to validate trip name...');

273:
274:
275: END IF;
276:
277: wsh_debug_sv.dlog (c_debug,'about to validate trip name...');
278:
279: IF (x_name IS NULL) OR (x_name = FND_API.G_MISS_CHAR) THEN
280: l_temp_id := x_trip_id;
281: LOOP

Line 305: wsh_debug_sv.dlog (c_debug,'about to call Validate_CreateTrip...');

301: x_name := l_name;
302:
303: ELSE
304:
305: wsh_debug_sv.dlog (c_debug,'about to call Validate_CreateTrip...');
306:
307: --validation
308: Validate_CreateTrip (p_trip_name =>x_name,
309: x_return_status=>x_return_status);

Line 319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');

315: END IF;
316:
317: END IF;
318:
319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');
320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);
321: wsh_debug_sv.dlog (c_debug,'name', x_name);
322:
323: INSERT INTO fte_trips(

Line 320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);

316:
317: END IF;
318:
319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');
320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);
321: wsh_debug_sv.dlog (c_debug,'name', x_name);
322:
323: INSERT INTO fte_trips(
324: FTE_TRIP_ID ,

Line 321: wsh_debug_sv.dlog (c_debug,'name', x_name);

317: END IF;
318:
319: wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');
320: wsh_debug_sv.dlog (c_debug,'trip id ', x_trip_id);
321: wsh_debug_sv.dlog (c_debug,'name', x_name);
322:
323: INSERT INTO fte_trips(
324: FTE_TRIP_ID ,
325: NAME ,

Line 390: wsh_debug_sv.dlog (c_debug,'right after insert statement---');

386: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15),
387: decode(p_trip_info.route_id, FND_API.G_MISS_NUM, NULL, p_trip_info.route_id)
388: );
389:
390: wsh_debug_sv.dlog (c_debug,'right after insert statement---');
391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);
392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);
393:
394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);

387: decode(p_trip_info.route_id, FND_API.G_MISS_NUM, NULL, p_trip_info.route_id)
388: );
389:
390: wsh_debug_sv.dlog (c_debug,'right after insert statement---');
391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);
392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);
393:
394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
395: wsh_debug_sv.dpop (c_sdebug);

Line 392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);

388: );
389:
390: wsh_debug_sv.dlog (c_debug,'right after insert statement---');
391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);
392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);
393:
394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
395: wsh_debug_sv.dpop (c_sdebug);
396:

Line 394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

390: wsh_debug_sv.dlog (c_debug,'right after insert statement---');
391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);
392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);
393:
394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
395: wsh_debug_sv.dpop (c_sdebug);
396:
397: EXCEPTION
398: WHEN wsh_duplicate_name THEN

Line 395: wsh_debug_sv.dpop (c_sdebug);

391: wsh_debug_sv.dlog (c_debug,'SQL%FOUND', SQL%FOUND);
392: wsh_debug_sv.dlog (c_debug,'SQL%ROWCOUNT', SQL%ROWCOUNT);
393:
394: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
395: wsh_debug_sv.dpop (c_sdebug);
396:
397: EXCEPTION
398: WHEN wsh_duplicate_name THEN
399: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');

Line 403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

399: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN

Line 404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');

400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');

Line 405: wsh_debug_sv.dpop (c_sdebug);

401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');
413: wsh_debug_sv.dpop (c_sdebug);
414:
415: END Create_Trip;

Line 412: wsh_debug_sv.dlog (c_debug,'others exception');

408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');
413: wsh_debug_sv.dpop (c_sdebug);
414:
415: END Create_Trip;
416:

Line 413: wsh_debug_sv.dpop (c_sdebug);

409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');
413: wsh_debug_sv.dpop (c_sdebug);
414:
415: END Create_Trip;
416:
417:

Line 434: wsh_debug_sv.dpush (c_sdebug, 'Validate_CreateTrip');

430: wsh_duplicate_name EXCEPTION;
431:
432: BEGIN
433:
434: wsh_debug_sv.dpush (c_sdebug, 'Validate_CreateTrip');
435:
436: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_id);
437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);
438:

Line 436: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_id);

432: BEGIN
433:
434: wsh_debug_sv.dpush (c_sdebug, 'Validate_CreateTrip');
435:
436: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_id);
437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);
438:
439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440:

Line 437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);

433:
434: wsh_debug_sv.dpush (c_sdebug, 'Validate_CreateTrip');
435:
436: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_id);
437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);
438:
439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440:
441: wsh_debug_sv.dlog (c_debug,'about to check trip name... ');

Line 441: wsh_debug_sv.dlog (c_debug,'about to check trip name... ');

437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);
438:
439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440:
441: wsh_debug_sv.dlog (c_debug,'about to check trip name... ');
442:
443: OPEN check_trip_names(p_trip_name);
444: FETCH check_trip_names INTO l_row_check;
445:

Line 452: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

448: RAISE wsh_duplicate_name;
449: END IF;
450: CLOSE check_trip_names;
451:
452: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
453: wsh_debug_sv.dpop (c_sdebug);
454:
455: EXCEPTION
456: WHEN wsh_duplicate_name THEN

Line 453: wsh_debug_sv.dpop (c_sdebug);

449: END IF;
450: CLOSE check_trip_names;
451:
452: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
453: wsh_debug_sv.dpop (c_sdebug);
454:
455: EXCEPTION
456: WHEN wsh_duplicate_name THEN
457: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');

Line 461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

457: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
460:
461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN

Line 462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');

458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
460:
461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');

Line 463: wsh_debug_sv.dpop (c_sdebug);

459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
460:
461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');
471: wsh_debug_sv.dpop (c_sdebug);
472:
473: END Validate_CreateTrip;

Line 470: wsh_debug_sv.dlog (c_debug,'others exception');

466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');
471: wsh_debug_sv.dpop (c_sdebug);
472:
473: END Validate_CreateTrip;
474:

Line 471: wsh_debug_sv.dpop (c_sdebug);

467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');
471: wsh_debug_sv.dpop (c_sdebug);
472:
473: END Validate_CreateTrip;
474:
475:

Line 769: wsh_debug_sv.start_debug ('FteTrip-' || p_trip_id);

765: others EXCEPTION;
766:
767: BEGIN
768:
769: wsh_debug_sv.start_debug ('FteTrip-' || p_trip_id);
770: wsh_debug_sv.dpush (c_sdebug, 'Validate_Trip');
771:
772: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
773:

Line 770: wsh_debug_sv.dpush (c_sdebug, 'Validate_Trip');

766:
767: BEGIN
768:
769: wsh_debug_sv.start_debug ('FteTrip-' || p_trip_id);
770: wsh_debug_sv.dpush (c_sdebug, 'Validate_Trip');
771:
772: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
773:
774: IF p_trip_id IS NOT NULL THEN

Line 784: wsh_debug_sv.dlog (c_debug,'segment number unique check');

780: -- next seq num.)
781: l_segment_sequencenum_next:=l_trip_segments.sequence_number;
782: if ((l_segment_sequencenum_prev=l_segment_sequencenum_next)) then
783:
784: wsh_debug_sv.dlog (c_debug,'segment number unique check');
785:
786: UPDATE FTE_TRIPS SET validation_required='Y'
787: where fte_trip_id=p_trip_id;
788:

Line 803: wsh_debug_sv.dpop (c_sdebug);

799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
801: wsh_util_core.add_message(x_return_status);
802:
803: wsh_debug_sv.dpop (c_sdebug);
804: wsh_debug_sv.stop_debug;
805:
806: FND_MSG_PUB.Count_And_Get
807: ( p_encoded => FND_API.G_FALSE,

Line 804: wsh_debug_sv.stop_debug;

800: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
801: wsh_util_core.add_message(x_return_status);
802:
803: wsh_debug_sv.dpop (c_sdebug);
804: wsh_debug_sv.stop_debug;
805:
806: FND_MSG_PUB.Count_And_Get
807: ( p_encoded => FND_API.G_FALSE,
808: p_count => x_msg_count

Line 825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');

821: x_return_status =>x_return_status
822: );
823:
824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
827: UPDATE FTE_TRIPS SET validation_required='Y'
828: where fte_trip_id=p_trip_id;
829: IF (SQL%NOTFOUND) THEN

Line 833: wsh_debug_sv.dpop (c_sdebug);

829: IF (SQL%NOTFOUND) THEN
830: RAISE no_data_found;
831: END IF;
832:
833: wsh_debug_sv.dpop (c_sdebug);
834: wsh_debug_sv.stop_debug;
835:
836: FND_MSG_PUB.Count_And_Get
837: ( p_encoded => FND_API.G_FALSE,

Line 834: wsh_debug_sv.stop_debug;

830: RAISE no_data_found;
831: END IF;
832:
833: wsh_debug_sv.dpop (c_sdebug);
834: wsh_debug_sv.stop_debug;
835:
836: FND_MSG_PUB.Count_And_Get
837: ( p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count

Line 854: wsh_debug_sv.dlog (c_debug,'segment shud have atleast 2 stops');

850:
851: --1. segment shud have atleast 2 stops
852: if ((trip_stops%ROWCOUNT<2)) then
853: CLOSE trip_stops;
854: wsh_debug_sv.dlog (c_debug,'segment shud have atleast 2 stops');
855: UPDATE FTE_TRIPS SET validation_required='Y'
856: where fte_trip_id=p_trip_id;
857:
858: IF (SQL%NOTFOUND) THEN

Line 866: wsh_debug_sv.dpop (c_sdebug);

862: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_trip_segment_name);
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: wsh_util_core.add_message(x_return_status);
865:
866: wsh_debug_sv.dpop (c_sdebug);
867: wsh_debug_sv.stop_debug;
868: FND_MSG_PUB.Count_And_Get
869: ( p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count

Line 867: wsh_debug_sv.stop_debug;

863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: wsh_util_core.add_message(x_return_status);
865:
866: wsh_debug_sv.dpop (c_sdebug);
867: wsh_debug_sv.stop_debug;
868: FND_MSG_PUB.Count_And_Get
869: ( p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count
871: ,p_data => x_msg_data

Line 881: wsh_debug_sv.dlog (c_debug,'origin of 1st segment!=dest. of next segment');

877:
878:
879: --2.origin of 1st segment=dest. of next segment
880: if ((l_count>1) AND (l_segment_dest<>l_segment_origin)) then
881: wsh_debug_sv.dlog (c_debug,'origin of 1st segment!=dest. of next segment');
882: UPDATE FTE_TRIPS SET validation_required='Y'
883: where fte_trip_id=p_trip_id;
884: IF (SQL%NOTFOUND) THEN
885: RAISE no_data_found;

Line 898: wsh_debug_sv.dpop (c_sdebug);

894: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CONNECT_SEGMENT');
895: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: wsh_util_core.add_message(x_return_status);
898: wsh_debug_sv.dpop (c_sdebug);
899: wsh_debug_sv.stop_debug;
900:
901: FND_MSG_PUB.Count_And_Get
902: ( p_encoded => FND_API.G_FALSE,

Line 899: wsh_debug_sv.stop_debug;

895: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: wsh_util_core.add_message(x_return_status);
898: wsh_debug_sv.dpop (c_sdebug);
899: wsh_debug_sv.stop_debug;
900:
901: FND_MSG_PUB.Count_And_Get
902: ( p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count

Line 917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');

913: x_return_status =>x_return_status
914: );
915:
916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919:
920: UPDATE FTE_TRIPS SET validation_required='Y'
921: where fte_trip_id=p_trip_id;

Line 925: wsh_debug_sv.dpop (c_sdebug);

921: where fte_trip_id=p_trip_id;
922: IF (SQL%NOTFOUND) THEN
923: RAISE no_data_found;
924: END IF;
925: wsh_debug_sv.dpop (c_sdebug);
926: wsh_debug_sv.stop_debug;
927:
928: RETURN;
929: END IF;

Line 926: wsh_debug_sv.stop_debug;

922: IF (SQL%NOTFOUND) THEN
923: RAISE no_data_found;
924: END IF;
925: wsh_debug_sv.dpop (c_sdebug);
926: wsh_debug_sv.stop_debug;
927:
928: RETURN;
929: END IF;
930:

Line 935: wsh_debug_sv.dlog (c_debug,'validation success');

931:
932: END LOOP;
933:
934: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
935: wsh_debug_sv.dlog (c_debug,'validation success');
936: UPDATE FTE_TRIPS SET validation_required='N'
937: where fte_trip_id=p_trip_id;
938: IF (SQL%NOTFOUND) THEN
939: RAISE no_data_found;

Line 946: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

942: else
943: raise no_data_found;
944: END IF;
945:
946: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
947: wsh_debug_sv.dpop (c_sdebug);
948: wsh_debug_sv.stop_debug;
949:
950: EXCEPTION

Line 947: wsh_debug_sv.dpop (c_sdebug);

943: raise no_data_found;
944: END IF;
945:
946: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
947: wsh_debug_sv.dpop (c_sdebug);
948: wsh_debug_sv.stop_debug;
949:
950: EXCEPTION
951: WHEN no_data_found THEN

Line 948: wsh_debug_sv.stop_debug;

944: END IF;
945:
946: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
947: wsh_debug_sv.dpop (c_sdebug);
948: wsh_debug_sv.stop_debug;
949:
950: EXCEPTION
951: WHEN no_data_found THEN
952: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');

Line 955: wsh_debug_sv.dpop (c_sdebug);

951: WHEN no_data_found THEN
952: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
954: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
955: wsh_debug_sv.dpop (c_sdebug);
956: wsh_debug_sv.stop_debug;
957: -- Get message count and data
958: FND_MSG_PUB.Count_And_Get
959: ( p_encoded => FND_API.G_FALSE,

Line 956: wsh_debug_sv.stop_debug;

952: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
954: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
955: wsh_debug_sv.dpop (c_sdebug);
956: wsh_debug_sv.stop_debug;
957: -- Get message count and data
958: FND_MSG_PUB.Count_And_Get
959: ( p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count

Line 966: wsh_debug_sv.dpop (c_sdebug);

962: );
963: WHEN others THEN
964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
966: wsh_debug_sv.dpop (c_sdebug);
967: wsh_debug_sv.stop_debug;
968: -- Get message count and data
969: FND_MSG_PUB.Count_And_Get
970: ( p_encoded => FND_API.G_FALSE,

Line 967: wsh_debug_sv.stop_debug;

963: WHEN others THEN
964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
966: wsh_debug_sv.dpop (c_sdebug);
967: wsh_debug_sv.stop_debug;
968: -- Get message count and data
969: FND_MSG_PUB.Count_And_Get
970: ( p_encoded => FND_API.G_FALSE,
971: p_count => x_msg_count