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_TENDER_PVT dependencies on FND_API

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FTE_TENDER_PVT';
10:
11:
12: PROCEDURE RAISE_TENDER_REQUEST(
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_tender_id IN NUMBER,

Line 43: IF FND_API.to_Boolean( p_init_msg_list )

39: IF l_debug_on THEN
40: WSH_DEBUG_SV.push(l_module_name);
41: END IF;
42:
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:

Line 122: p_encoded => FND_API.G_FALSE

118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count,
121: p_data => x_msg_data,
122: p_encoded => FND_API.G_FALSE
123: );
124:
125:
126: --

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132:
133: --}
134: EXCEPTION
135: --{
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.Count_And_Get
140: (

Line 138: x_return_status := FND_API.G_RET_STS_ERROR ;

134: EXCEPTION
135: --{
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.Count_And_Get
140: (
141: p_count => x_msg_count,
142: p_data => x_msg_data,

Line 143: p_encoded => FND_API.G_FALSE

139: FND_MSG_PUB.Count_And_Get
140: (
141: p_count => x_msg_count,
142: p_data => x_msg_data,
143: p_encoded => FND_API.G_FALSE
144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

141: p_count => x_msg_count,
142: p_data => x_msg_data,
143: p_encoded => FND_API.G_FALSE
144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: (

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

143: p_encoded => FND_API.G_FALSE
144: );
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: (
150: p_count => x_msg_count,
151: p_data => x_msg_data,

Line 152: p_encoded => FND_API.G_FALSE

148: FND_MSG_PUB.Count_And_Get
149: (
150: p_count => x_msg_count,
151: p_data => x_msg_data,
152: p_encoded => FND_API.G_FALSE
153: );
154: WHEN OTHERS THEN
155: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153: );
154: WHEN OTHERS THEN
155: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count,
161: p_data => x_msg_data,

Line 162: p_encoded => FND_API.G_FALSE

158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count,
161: p_data => x_msg_data,
162: p_encoded => FND_API.G_FALSE
163: );
164:
165: --}
166:

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

222: END COMPLETE_TENDER_NOTIFICATION;
223:
224:
225: PROCEDURE RAISE_TENDER_CANCEL(
226: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_item_key IN VARCHAR2,

Line 250: IF FND_API.to_Boolean( p_init_msg_list )

246:
247:
248: SAVEPOINT RAISE_TENDER_CANCEL_PUB;
249:
250: IF FND_API.to_Boolean( p_init_msg_list )
251: THEN
252: FND_MSG_PUB.initialize;
253: END IF;
254:

Line 316: p_encoded => FND_API.G_FALSE

312: FND_MSG_PUB.Count_And_Get
313: (
314: p_count => x_msg_count,
315: p_data => x_msg_data,
316: p_encoded => FND_API.G_FALSE
317: );
318: --
319: --
320:

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321:
322: --}
323: EXCEPTION
324: --{
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: (

Line 327: x_return_status := FND_API.G_RET_STS_ERROR ;

323: EXCEPTION
324: --{
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: (
330: p_count => x_msg_count,
331: p_data => x_msg_data,

Line 332: p_encoded => FND_API.G_FALSE

328: FND_MSG_PUB.Count_And_Get
329: (
330: p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

330: p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337: FND_MSG_PUB.Count_And_Get
338: (

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

332: p_encoded => FND_API.G_FALSE
333: );
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337: FND_MSG_PUB.Count_And_Get
338: (
339: p_count => x_msg_count,
340: p_data => x_msg_data,

Line 341: p_encoded => FND_API.G_FALSE

337: FND_MSG_PUB.Count_And_Get
338: (
339: p_count => x_msg_count,
340: p_data => x_msg_data,
341: p_encoded => FND_API.G_FALSE
342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,
350: p_data => x_msg_data,

Line 351: p_encoded => FND_API.G_FALSE

347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => FND_API.G_FALSE
352: );
353:
354: --}
355:

Line 362: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

358:
359:
360:
361: PROCEDURE RAISE_TENDER_ACCEPT(
362: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_msg_data OUT NOCOPY VARCHAR2,
366: p_item_key IN VARCHAR2,

Line 388: IF FND_API.to_Boolean( p_init_msg_list )

384:
385: BEGIN
386: SAVEPOINT RAISE_TENDER_ACCEPT_PUB;
387:
388: IF FND_API.to_Boolean( p_init_msg_list )
389: THEN
390: FND_MSG_PUB.initialize;
391: END IF;
392:

Line 466: p_encoded => FND_API.G_FALSE

462: FND_MSG_PUB.Count_And_Get
463: (
464: p_count => x_msg_count,
465: p_data => x_msg_data,
466: p_encoded => FND_API.G_FALSE
467: );
468: --
469: --
470:

Line 475: WHEN FND_API.G_EXC_ERROR THEN

471:
472: --}
473: EXCEPTION
474: --{
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: (

Line 477: x_return_status := FND_API.G_RET_STS_ERROR ;

473: EXCEPTION
474: --{
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: (
480: p_count => x_msg_count,
481: p_data => x_msg_data,

Line 482: p_encoded => FND_API.G_FALSE

478: FND_MSG_PUB.Count_And_Get
479: (
480: p_count => x_msg_count,
481: p_data => x_msg_data,
482: p_encoded => FND_API.G_FALSE
483: );
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

480: p_count => x_msg_count,
481: p_data => x_msg_data,
482: p_encoded => FND_API.G_FALSE
483: );
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get
488: (

Line 486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

482: p_encoded => FND_API.G_FALSE
483: );
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,
490: p_data => x_msg_data,

Line 491: p_encoded => FND_API.G_FALSE

487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE
492: );
493: WHEN OTHERS THEN
494: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: );
493: WHEN OTHERS THEN
494: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => x_msg_count,
500: p_data => x_msg_data,

Line 501: p_encoded => FND_API.G_FALSE

497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => x_msg_count,
500: p_data => x_msg_data,
501: p_encoded => FND_API.G_FALSE
502: );
503:
504: --}
505:

Line 516: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

512: --should not be updated. Because this is the key to identify the
513: -- workflow.
514:
515: PROCEDURE RAISE_TENDER_UPDATE(
516: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,
519: x_msg_data OUT NOCOPY VARCHAR2,
520: p_item_key IN VARCHAR2,

Line 544: IF FND_API.to_Boolean( p_init_msg_list )

540:
541: BEGIN
542: SAVEPOINT RAISE_TENDER_UPDATE_PUB;
543:
544: IF FND_API.to_Boolean( p_init_msg_list )
545: THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:

Line 647: p_encoded => FND_API.G_FALSE

643: FND_MSG_PUB.Count_And_Get
644: (
645: p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
648: );
649: --
650: --
651:

Line 656: WHEN FND_API.G_EXC_ERROR THEN

652:
653: --}
654: EXCEPTION
655: --{
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
658: x_return_status := FND_API.G_RET_STS_ERROR ;
659: FND_MSG_PUB.Count_And_Get
660: (

Line 658: x_return_status := FND_API.G_RET_STS_ERROR ;

654: EXCEPTION
655: --{
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
658: x_return_status := FND_API.G_RET_STS_ERROR ;
659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count,
662: p_data => x_msg_data,

Line 663: p_encoded => FND_API.G_FALSE

659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count,
662: p_data => x_msg_data,
663: p_encoded => FND_API.G_FALSE
664: );
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

661: p_count => x_msg_count,
662: p_data => x_msg_data,
663: p_encoded => FND_API.G_FALSE
664: );
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: FND_MSG_PUB.Count_And_Get
669: (

Line 667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

663: p_encoded => FND_API.G_FALSE
664: );
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: FND_MSG_PUB.Count_And_Get
669: (
670: p_count => x_msg_count,
671: p_data => x_msg_data,

Line 672: p_encoded => FND_API.G_FALSE

668: FND_MSG_PUB.Count_And_Get
669: (
670: p_count => x_msg_count,
671: p_data => x_msg_data,
672: p_encoded => FND_API.G_FALSE
673: );
674: WHEN OTHERS THEN
675: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: );
674: WHEN OTHERS THEN
675: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count,
681: p_data => x_msg_data,

Line 682: p_encoded => FND_API.G_FALSE

678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count,
681: p_data => x_msg_data,
682: p_encoded => FND_API.G_FALSE
683: );
684:
685: --}
686:

Line 691: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

687: END RAISE_TENDER_UPDATE;
688:
689:
690: PROCEDURE RAISE_TENDER_REJECT(
691: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
694: x_msg_data OUT NOCOPY VARCHAR2,
695: p_item_key IN VARCHAR2,

Line 718: IF FND_API.to_Boolean( p_init_msg_list )

714: BEGIN
715:
716: SAVEPOINT RAISE_TENDER_REJECT_PUB;
717:
718: IF FND_API.to_Boolean( p_init_msg_list )
719: THEN
720: FND_MSG_PUB.initialize;
721: END IF;
722:

Line 790: p_encoded => FND_API.G_FALSE

786: FND_MSG_PUB.Count_And_Get
787: (
788: p_count => x_msg_count,
789: p_data => x_msg_data,
790: p_encoded => FND_API.G_FALSE
791: );
792: --
793: --
794:

Line 798: WHEN FND_API.G_EXC_ERROR THEN

794:
795: --}
796: EXCEPTION
797: --{
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
800: x_return_status := FND_API.G_RET_STS_ERROR ;
801: FND_MSG_PUB.Count_And_Get
802: (

Line 800: x_return_status := FND_API.G_RET_STS_ERROR ;

796: EXCEPTION
797: --{
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
800: x_return_status := FND_API.G_RET_STS_ERROR ;
801: FND_MSG_PUB.Count_And_Get
802: (
803: p_count => x_msg_count,
804: p_data => x_msg_data,

Line 805: p_encoded => FND_API.G_FALSE

801: FND_MSG_PUB.Count_And_Get
802: (
803: p_count => x_msg_count,
804: p_data => x_msg_data,
805: p_encoded => FND_API.G_FALSE
806: );
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

803: p_count => x_msg_count,
804: p_data => x_msg_data,
805: p_encoded => FND_API.G_FALSE
806: );
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get
811: (

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

805: p_encoded => FND_API.G_FALSE
806: );
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get
811: (
812: p_count => x_msg_count,
813: p_data => x_msg_data,

Line 814: p_encoded => FND_API.G_FALSE

810: FND_MSG_PUB.Count_And_Get
811: (
812: p_count => x_msg_count,
813: p_data => x_msg_data,
814: p_encoded => FND_API.G_FALSE
815: );
816: WHEN OTHERS THEN
817: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');

Line 819: x_return_status := FND_API.G_RET_STS_ERROR;

815: );
816: WHEN OTHERS THEN
817: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,
823: p_data => x_msg_data,

Line 824: p_encoded => FND_API.G_FALSE

820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => FND_API.G_FALSE
825: );
826:
827: --}
828:

Line 1082: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1078: END GET_ITEM_KEY;
1079:
1080: PROCEDURE VALIDATE_TENDER_REQUEST(
1081: p_api_version_number IN NUMBER,
1082: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1083: x_return_status OUT NOCOPY VARCHAR2,
1084: x_msg_count OUT NOCOPY NUMBER,
1085: x_msg_data OUT NOCOPY VARCHAR2,
1086: p_trip_id IN NUMBER,

Line 1116: IF FND_API.to_Boolean( p_init_msg_list )

1112:
1113: SAVEPOINT VALIDATE_TENDER_REQUEST_PUB;
1114:
1115:
1116: IF FND_API.to_Boolean( p_init_msg_list )
1117: THEN
1118: FND_MSG_PUB.initialize;
1119: END IF;
1120: --

Line 1136: p_encoded => FND_API.G_FALSE

1132: FND_MSG_PUB.Count_And_Get
1133: (
1134: p_count => x_msg_count,
1135: p_data => x_msg_data,
1136: p_encoded => FND_API.G_FALSE
1137: );
1138: END IF;
1139: IF l_debug_on THEN
1140: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:26 ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1189: RAISE FND_API.G_EXC_ERROR;

1185: IF l_debug_on THEN
1186: wsh_debug_sv.pop(l_api_name);
1187: END IF;
1188:
1189: RAISE FND_API.G_EXC_ERROR;
1190:
1191: END IF;
1192:
1193:

Line 1213: RAISE FND_API.G_EXC_ERROR;

1209: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1210: l_trip_status));
1211: FND_MESSAGE.SET_TOKEN('TRIP_SEG_NAME',l_trip_name);
1212: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1213: RAISE FND_API.G_EXC_ERROR;
1214:
1215: END IF;
1216:
1217: IF l_debug_on THEN

Line 1228: p_encoded => FND_API.G_FALSE

1224: FND_MSG_PUB.Count_And_Get
1225: (
1226: p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => FND_API.G_FALSE
1229: );
1230:
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.pop(l_module_name);

Line 1240: WHEN FND_API.G_EXC_ERROR THEN

1236: --
1237: --}
1238:
1239: EXCEPTION
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:29 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;

Line 1245: x_return_status := FND_API.G_RET_STS_ERROR ;

1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:29 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1243: END IF;
1244: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1245: x_return_status := FND_API.G_RET_STS_ERROR ;
1246: FND_MSG_PUB.Count_And_Get
1247: (
1248: p_count => x_msg_count,
1249: p_data => x_msg_data,

Line 1250: p_encoded => FND_API.G_FALSE

1246: FND_MSG_PUB.Count_And_Get
1247: (
1248: p_count => x_msg_count,
1249: p_data => x_msg_data,
1250: p_encoded => FND_API.G_FALSE
1251: );
1252: IF l_debug_on THEN
1253: WSH_DEBUG_SV.pop(l_module_name);
1254: END IF;

Line 1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1251: );
1252: IF l_debug_on THEN
1253: WSH_DEBUG_SV.pop(l_module_name);
1254: END IF;
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:30 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;

Line 1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1256: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:30 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1261: FND_MSG_PUB.Count_And_Get
1262: (
1263: p_count => x_msg_count,
1264: p_data => x_msg_data,

Line 1265: p_encoded => FND_API.G_FALSE

1261: FND_MSG_PUB.Count_And_Get
1262: (
1263: p_count => x_msg_count,
1264: p_data => x_msg_data,
1265: p_encoded => FND_API.G_FALSE
1266: );
1267: IF l_debug_on THEN
1268: WSH_DEBUG_SV.pop(l_module_name);
1269: END IF;

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:31 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1273: END IF;
1274: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: FND_MSG_PUB.Count_And_Get
1278: (
1279: p_count => x_msg_count,
1280: p_data => x_msg_data,

Line 1281: p_encoded => FND_API.G_FALSE

1277: FND_MSG_PUB.Count_And_Get
1278: (
1279: p_count => x_msg_count,
1280: p_data => x_msg_data,
1281: p_encoded => FND_API.G_FALSE
1282: );
1283: IF l_debug_on THEN
1284: WSH_DEBUG_SV.pop(l_module_name);
1285: END IF;

Line 1317: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1313: -- ------------------------------------------------------------------------------- --
1314:
1315:
1316: PROCEDURE DELETE_TENDER_SNAPSHOT(
1317: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1318: p_tender_id IN NUMBER,
1319: x_return_status OUT NOCOPY VARCHAR2,
1320: x_msg_count OUT NOCOPY NUMBER,
1321: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1341: IF FND_API.to_Boolean( p_init_msg_list )

1337: --
1338: -- Initialize message list if p_init_msg_list is set to TRUE.
1339: --
1340: --
1341: IF FND_API.to_Boolean( p_init_msg_list )
1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345: --

Line 1368: p_encoded => FND_API.G_FALSE

1364: FND_MSG_PUB.Count_And_Get
1365: (
1366: p_count => x_msg_count,
1367: p_data => x_msg_data,
1368: p_encoded => FND_API.G_FALSE
1369: );
1370: --
1371: --
1372:

Line 1377: WHEN FND_API.G_EXC_ERROR THEN

1373:
1374: --}
1375: EXCEPTION
1376: --{
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1379: x_return_status := FND_API.G_RET_STS_ERROR ;
1380: FND_MSG_PUB.Count_And_Get
1381: (

Line 1379: x_return_status := FND_API.G_RET_STS_ERROR ;

1375: EXCEPTION
1376: --{
1377: WHEN FND_API.G_EXC_ERROR THEN
1378: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1379: x_return_status := FND_API.G_RET_STS_ERROR ;
1380: FND_MSG_PUB.Count_And_Get
1381: (
1382: p_count => x_msg_count,
1383: p_data => x_msg_data,

Line 1384: p_encoded => FND_API.G_FALSE

1380: FND_MSG_PUB.Count_And_Get
1381: (
1382: p_count => x_msg_count,
1383: p_data => x_msg_data,
1384: p_encoded => FND_API.G_FALSE
1385: );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1382: p_count => x_msg_count,
1383: p_data => x_msg_data,
1384: p_encoded => FND_API.G_FALSE
1385: );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389: FND_MSG_PUB.Count_And_Get
1390: (

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1384: p_encoded => FND_API.G_FALSE
1385: );
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389: FND_MSG_PUB.Count_And_Get
1390: (
1391: p_count => x_msg_count,
1392: p_data => x_msg_data,

Line 1393: p_encoded => FND_API.G_FALSE

1389: FND_MSG_PUB.Count_And_Get
1390: (
1391: p_count => x_msg_count,
1392: p_data => x_msg_data,
1393: p_encoded => FND_API.G_FALSE
1394: );
1395: WHEN OTHERS THEN
1396: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');

Line 1403: p_encoded => FND_API.G_FALSE

1399: FND_MSG_PUB.Count_And_Get
1400: (
1401: p_count => x_msg_count,
1402: p_data => x_msg_data,
1403: p_encoded => FND_API.G_FALSE
1404: );
1405:
1406: --}
1407:

Line 1437: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1433: -- ------------------------------------------------------------------------------- --
1434:
1435:
1436: PROCEDURE TAKE_TENDER_SNAPSHOT(
1437: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1438: p_tender_id IN NUMBER,
1439: p_trip_id IN NUMBER,
1440: p_stop_id IN NUMBER,
1441: p_total_weight IN NUMBER,

Line 1468: IF FND_API.to_Boolean( p_init_msg_list )

1464: --
1465: -- Initialize message list if p_init_msg_list is set to TRUE.
1466: --
1467: --
1468: IF FND_API.to_Boolean( p_init_msg_list )
1469: THEN
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472: --

Line 1514: FND_API.G_MISS_NUM,NULL,

1510:
1511: UPDATE FTE_TENDER_SNAPSHOT SET
1512: TOTAL_WEIGHT = decode(p_total_weight,
1513: NULL,total_weight,
1514: FND_API.G_MISS_NUM,NULL,
1515: p_total_weight),
1516: TOTAL_VOLUME = decode(p_total_volume,
1517: NULL,total_volume,
1518: FND_API.G_MISS_NUM,NULL,

Line 1518: FND_API.G_MISS_NUM,NULL,

1514: FND_API.G_MISS_NUM,NULL,
1515: p_total_weight),
1516: TOTAL_VOLUME = decode(p_total_volume,
1517: NULL,total_volume,
1518: FND_API.G_MISS_NUM,NULL,
1519: p_total_volume),
1520: WEIGHT_UOM =decode(p_weight_uom,
1521: NULL,weight_uom,
1522: FND_API.G_MISS_CHAR,NULL,

Line 1522: FND_API.G_MISS_CHAR,NULL,

1518: FND_API.G_MISS_NUM,NULL,
1519: p_total_volume),
1520: WEIGHT_UOM =decode(p_weight_uom,
1521: NULL,weight_uom,
1522: FND_API.G_MISS_CHAR,NULL,
1523: p_weight_uom),
1524: VOLUME_UOM =decode(p_volume_uom,
1525: NULL,volume_uom,
1526: FND_API.G_MISS_CHAR,NULL,

Line 1526: FND_API.G_MISS_CHAR,NULL,

1522: FND_API.G_MISS_CHAR,NULL,
1523: p_weight_uom),
1524: VOLUME_UOM =decode(p_volume_uom,
1525: NULL,volume_uom,
1526: FND_API.G_MISS_CHAR,NULL,
1527: p_volume_uom),
1528: SESSION_VALUE =decode(p_session_value,
1529: NULL,SESSION_VALUE,
1530: FND_API.G_MISS_CHAR,null,

Line 1530: FND_API.G_MISS_CHAR,null,

1526: FND_API.G_MISS_CHAR,NULL,
1527: p_volume_uom),
1528: SESSION_VALUE =decode(p_session_value,
1529: NULL,SESSION_VALUE,
1530: FND_API.G_MISS_CHAR,null,
1531: p_session_value),
1532: LAST_UPDATE_DATE = SYSDATE,
1533: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1534: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

Line 1550: p_encoded => FND_API.G_FALSE

1546: FND_MSG_PUB.Count_And_Get
1547: (
1548: p_count => x_msg_count,
1549: p_data => x_msg_data,
1550: p_encoded => FND_API.G_FALSE
1551: );
1552: --
1553: --
1554:

Line 1559: WHEN FND_API.G_EXC_ERROR THEN

1555:
1556: --}
1557: EXCEPTION
1558: --{
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: FND_MSG_PUB.Count_And_Get
1563: (

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557: EXCEPTION
1558: --{
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: FND_MSG_PUB.Count_And_Get
1563: (
1564: p_count => x_msg_count,
1565: p_data => x_msg_data,

Line 1566: p_encoded => FND_API.G_FALSE

1562: FND_MSG_PUB.Count_And_Get
1563: (
1564: p_count => x_msg_count,
1565: p_data => x_msg_data,
1566: p_encoded => FND_API.G_FALSE
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1564: p_count => x_msg_count,
1565: p_data => x_msg_data,
1566: p_encoded => FND_API.G_FALSE
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571: FND_MSG_PUB.Count_And_Get
1572: (

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1566: p_encoded => FND_API.G_FALSE
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571: FND_MSG_PUB.Count_And_Get
1572: (
1573: p_count => x_msg_count,
1574: p_data => x_msg_data,

Line 1575: p_encoded => FND_API.G_FALSE

1571: FND_MSG_PUB.Count_And_Get
1572: (
1573: p_count => x_msg_count,
1574: p_data => x_msg_data,
1575: p_encoded => FND_API.G_FALSE
1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

Line 1585: p_encoded => FND_API.G_FALSE

1581: FND_MSG_PUB.Count_And_Get
1582: (
1583: p_count => x_msg_count,
1584: p_data => x_msg_data,
1585: p_encoded => FND_API.G_FALSE
1586: );
1587:
1588: --}
1589:

Line 1596: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1592:
1593: --{
1594:
1595: PROCEDURE TAKE_TENDER_SNAPSHOT(
1596: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1597: p_trip_id IN NUMBER,
1598: p_action IN VARCHAR2,
1599: x_return_status OUT NOCOPY VARCHAR2,
1600: x_msg_count OUT NOCOPY NUMBER,

Line 1636: IF FND_API.to_Boolean( p_init_msg_list )

1632: --
1633: -- Initialize message list if p_init_msg_list is set to TRUE.
1634: --
1635: --
1636: IF FND_API.to_Boolean( p_init_msg_list )
1637: THEN
1638: FND_MSG_PUB.initialize;
1639: END IF;
1640: --

Line 1655: p_init_msg_list => FND_API.G_FALSE,

1651:
1652: IF (p_action = 'REPLACE')
1653: THEN
1654: DELETE_TENDER_SNAPSHOT(
1655: p_init_msg_list => FND_API.G_FALSE,
1656: p_tender_id => p_trip_id,
1657: x_return_status => l_return_status,
1658: x_msg_count => l_msg_count,
1659: x_msg_data => l_msg_data);

Line 1670: RAISE FND_API.G_EXC_ERROR;

1666:
1667: IF l_number_of_errors > 0
1668: THEN
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: RAISE FND_API.G_EXC_ERROR;
1671: ELSIF l_number_of_warnings > 0
1672: THEN
1673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1674: ELSE

Line 1687: p_init_msg_list => FND_API.G_FALSE,

1683: LOOP
1684: --{
1685:
1686: TAKE_TENDER_SNAPSHOT(
1687: p_init_msg_list => FND_API.G_FALSE,
1688: p_tender_id => p_trip_id,
1689: p_trip_id => p_trip_id,
1690: p_stop_id => get_trip_stop_info_rec.stop_id,
1691: p_total_weight => get_trip_stop_info_rec.departure_gross_weight,

Line 1713: RAISE FND_API.G_EXC_ERROR;

1709:
1710: IF l_number_of_errors > 0
1711: THEN
1712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF l_number_of_warnings > 0 THEN
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1716: ELSE
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1727: p_encoded => FND_API.G_FALSE

1723: FND_MSG_PUB.Count_And_Get
1724: (
1725: p_count => x_msg_count,
1726: p_data => x_msg_data,
1727: p_encoded => FND_API.G_FALSE
1728: );
1729: --
1730: --
1731:

Line 1736: WHEN FND_API.G_EXC_ERROR THEN

1732:
1733: --}
1734: EXCEPTION
1735: --{
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: FND_MSG_PUB.Count_And_Get
1740: (

Line 1738: x_return_status := FND_API.G_RET_STS_ERROR;

1734: EXCEPTION
1735: --{
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: FND_MSG_PUB.Count_And_Get
1740: (
1741: p_count => x_msg_count,
1742: p_data => x_msg_data,

Line 1743: p_encoded => FND_API.G_FALSE

1739: FND_MSG_PUB.Count_And_Get
1740: (
1741: p_count => x_msg_count,
1742: p_data => x_msg_data,
1743: p_encoded => FND_API.G_FALSE
1744: );
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1741: p_count => x_msg_count,
1742: p_data => x_msg_data,
1743: p_encoded => FND_API.G_FALSE
1744: );
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: FND_MSG_PUB.Count_And_Get
1749: (

Line 1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1743: p_encoded => FND_API.G_FALSE
1744: );
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: FND_MSG_PUB.Count_And_Get
1749: (
1750: p_count => x_msg_count,
1751: p_data => x_msg_data,

Line 1752: p_encoded => FND_API.G_FALSE

1748: FND_MSG_PUB.Count_And_Get
1749: (
1750: p_count => x_msg_count,
1751: p_data => x_msg_data,
1752: p_encoded => FND_API.G_FALSE
1753: );
1754: WHEN OTHERS THEN
1755: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

Line 1762: p_encoded => FND_API.G_FALSE

1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,
1761: p_data => x_msg_data,
1762: p_encoded => FND_API.G_FALSE
1763: );
1764:
1765: --}
1766:

Line 1779: -- P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1775: -- --
1776: -- NAME: CHECK_THRESHOLD_FOR_STOP --
1777: -- TYPE: PROCEDURE --
1778: -- PARAMETERS (IN): P_api_version IN NUMBER,
1779: -- P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1780: -- P_trip_segment_rec IN WSH_TRIPS_GRP.Trip_Pub_Rec_Type,
1781: -- P_old_segment_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
1782: -- P_new_segment_stop_rec IN WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type
1783: --

Line 1811: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1807:
1808:
1809: PROCEDURE CHECK_THRESHOLD_FOR_STOP(
1810: P_api_version IN NUMBER,
1811: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1812: X_return_status OUT NOCOPY VARCHAR2,
1813: X_msg_count OUT NOCOPY NUMBER,
1814: X_msg_data OUT NOCOPY VARCHAR2,
1815: P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,

Line 1893: x_return_status := FND_API.G_RET_STS_SUCCESS;

1889: --
1890: -- Standard Start of API savepoint
1891: SAVEPOINT CHECK_THRESHOLD_FOR_STOP_PUB;
1892: --
1893: x_return_status := FND_API.G_RET_STS_SUCCESS;
1894:
1895: IF l_debug_on THEN
1896: wsh_debug_sv.push(l_module_name);
1897: END IF;

Line 1902: IF FND_API.to_Boolean( p_init_msg_list )

1898: --
1899: -- Initialize message list if p_init_msg_list is set to TRUE.
1900: --
1901: --
1902: IF FND_API.to_Boolean( p_init_msg_list )
1903: THEN
1904: FND_MSG_PUB.initialize;
1905: END IF;
1906: --

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: IF (l_trip_id IS NULL)
1929: THEN
1930: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_ID_CHK');
1931: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934:
1935:
1936: -- If status is not tendered or accepted then

Line 1939: OR (l_tender_status = FND_API.G_MISS_CHAR)

1935:
1936: -- If status is not tendered or accepted then
1937: -- just return back
1938: IF ((l_tender_status IS NULL)
1939: OR (l_tender_status = FND_API.G_MISS_CHAR)
1940: OR (l_tender_status <> FTE_TENDER_PVT.S_TENDERED)
1941: AND (l_tender_status <> FTE_TENDER_PVT.S_ACCEPTED)
1942: AND (l_tender_status <> FTE_TENDER_PVT.S_AUTO_ACCEPTED))
1943: THEN

Line 1963: RAISE FND_API.G_EXC_ERROR;

1959: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_ACT_CNT_ADD_STOP');
1960: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_trip_segment_rec.name);
1961: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',l_tender_string);
1962: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1963: RAISE FND_API.G_EXC_ERROR;
1964: END IF;
1965:
1966:
1967: --[HBHAGAVA 10+ Location fix ]

Line 2016: RAISE FND_API.G_EXC_ERROR;

2012: IF (l_tender_number IS NULL)
2013: THEN
2014: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_NUMBER');
2015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2016: RAISE FND_API.G_EXC_ERROR;
2017: END IF;
2018:
2019:
2020: -- if found then proceed otherwise just take the snapshot

Line 2029: p_init_msg_list => FND_API.G_FALSE,

2025: WSH_DEBUG_SV.logmsg(l_module_name,'No snapshot of the stop. take the snapshot',WSH_DEBUG_SV.C_PROC_LEVEL);
2026: END IF;
2027:
2028: TAKE_TENDER_SNAPSHOT(
2029: p_init_msg_list => FND_API.G_FALSE,
2030: p_tender_id => l_tender_number,
2031: p_trip_id => l_trip_id,
2032: p_stop_id => l_stop_id,
2033: p_total_weight => P_new_segment_stop_rec.DEPARTURE_GROSS_WEIGHT,

Line 2052: RAISE FND_API.G_EXC_ERROR;

2048:
2049: IF l_number_of_errors > 0
2050: THEN
2051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_number_of_warnings > 0 THEN
2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2055: ELSE
2056: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2086: p_init_msg_list => FND_API.G_FALSE,

2082: END IF;
2083:
2084: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2085: ( p_api_version_number => 1.0,
2086: p_init_msg_list => FND_API.G_FALSE,
2087: p_action_code => 'UPDATE',
2088: p_action => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
2089: p_rec_TRIP_ID => l_trip_id,
2090: x_return_status => l_return_status,

Line 2105: p_init_msg_list => FND_API.G_FALSE,

2101:
2102: /**
2103: -- Delete tender snapshot
2104: TAKE_TENDER_SNAPSHOT(
2105: p_init_msg_list => FND_API.G_FALSE,
2106: p_tender_id => l_tender_number,
2107: p_trip_id => l_trip_id,
2108: p_stop_id => l_stop_id,
2109: p_total_weight => null,

Line 2146: p_encoded => FND_API.G_FALSE

2142: FND_MSG_PUB.Count_And_Get
2143: (
2144: p_count => x_msg_count,
2145: p_data => x_msg_data,
2146: p_encoded => FND_API.G_FALSE
2147: );
2148:
2149:
2150: IF l_debug_on THEN

Line 2162: AND p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM

2158: -- If weights on stop and snapshot are null then there
2159: -- there is no need to call threshold because we cannot compare anything
2160: IF (l_snap_tot_weight IS NULL
2161: AND l_snap_tot_volume IS NULL
2162: AND p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM
2163: AND p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2164: THEN
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.logmsg(l_module_name,'Weights/volume at stop and snap shot are null. No need to check anything. Just return back',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2163: AND p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)

2159: -- there is no need to call threshold because we cannot compare anything
2160: IF (l_snap_tot_weight IS NULL
2161: AND l_snap_tot_volume IS NULL
2162: AND p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM
2163: AND p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2164: THEN
2165: IF l_debug_on THEN
2166: WSH_DEBUG_SV.logmsg(l_module_name,'Weights/volume at stop and snap shot are null. No need to check anything. Just return back',WSH_DEBUG_SV.C_PROC_LEVEL);
2167: WSH_DEBUG_SV.pop(l_module_name);

Line 2193: p_encoded => FND_API.G_FALSE

2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count,
2192: p_data => x_msg_data,
2193: p_encoded => FND_API.G_FALSE
2194: );
2195: IF l_debug_on THEN
2196: WSH_DEBUG_SV.pop(l_module_name);
2197: END IF;

Line 2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2198: RETURN;
2199: ELSIF (x_return_status = 'U') THEN
2200: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_THRESHOLD_INFO');
2201: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: END IF;
2204:
2205: IF (l_site_trans_rec.WEIGHT_THRESHOLD_LOWER = NULL
2206: AND l_site_trans_rec.WEIGHT_THRESHOLD_UPPER = NULL

Line 2242: IF (l_stop_weight_uom = FND_API.G_MISS_CHAR)

2238: -- uom conversions.
2239: l_stop_weight_uom := p_new_segment_stop_rec.weight_uom_code;
2240: l_stop_volume_uom := p_new_segment_stop_rec.volume_uom_code;
2241:
2242: IF (l_stop_weight_uom = FND_API.G_MISS_CHAR)
2243: THEN
2244:
2245: -- Snap stop weight uom is not null
2246: -- convert stop weight and compare

Line 2251: l_stop_weight_uom := FND_API.G_MISS_CHAR; --l_snap_weight_uom;

2247: IF l_debug_on THEN
2248: WSH_DEBUG_SV.logmsg(l_module_name,'Stop weight uom is null. Convert stop weight to snap weight',WSH_DEBUG_SV.C_PROC_LEVEL);
2249: END IF;
2250:
2251: l_stop_weight_uom := FND_API.G_MISS_CHAR; --l_snap_weight_uom;
2252:
2253: ELSIF (l_stop_weight_uom <> FND_API.G_MISS_CHAR)
2254: THEN
2255:

Line 2253: ELSIF (l_stop_weight_uom <> FND_API.G_MISS_CHAR)

2249: END IF;
2250:
2251: l_stop_weight_uom := FND_API.G_MISS_CHAR; --l_snap_weight_uom;
2252:
2253: ELSIF (l_stop_weight_uom <> FND_API.G_MISS_CHAR)
2254: THEN
2255:
2256: IF (l_snap_weight_uom IS NULL)
2257: THEN

Line 2278: IF (l_stop_volume_uom = FND_API.G_MISS_CHAR)

2274:
2275: END IF;
2276:
2277: -- check volume
2278: IF (l_stop_volume_uom = FND_API.G_MISS_CHAR)
2279: THEN
2280: -- Snap stop volume uom is not null
2281: -- convert stop volume and compare
2282: IF l_debug_on THEN

Line 2286: l_stop_volume_uom := FND_API.G_MISS_CHAR; --l_snap_volume_uom;

2282: IF l_debug_on THEN
2283: WSH_DEBUG_SV.logmsg(l_module_name,'Stop volume uom is null. Convert stop volume to snap volume',WSH_DEBUG_SV.C_PROC_LEVEL);
2284: END IF;
2285:
2286: l_stop_volume_uom := FND_API.G_MISS_CHAR; --l_snap_volume_uom;
2287:
2288: ELSIF (l_stop_volume_uom <> FND_API.G_MISS_CHAR)
2289: THEN
2290:

Line 2288: ELSIF (l_stop_volume_uom <> FND_API.G_MISS_CHAR)

2284: END IF;
2285:
2286: l_stop_volume_uom := FND_API.G_MISS_CHAR; --l_snap_volume_uom;
2287:
2288: ELSIF (l_stop_volume_uom <> FND_API.G_MISS_CHAR)
2289: THEN
2290:
2291: IF (l_snap_volume_uom IS NULL)
2292: THEN

Line 2313: IF ((p_new_segment_stop_rec.departure_gross_weight <> FND_API.G_MISS_NUM)

2309:
2310: END IF;
2311:
2312:
2313: IF ((p_new_segment_stop_rec.departure_gross_weight <> FND_API.G_MISS_NUM)
2314: AND (l_snap_tot_weight IS NULL))
2315: THEN
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is not G_MISS_NUMM ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2323: ELSIF ((p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM)

2319: END IF;
2320:
2321: l_send_update := TRUE;
2322:
2323: ELSIF ((p_new_segment_stop_rec.departure_gross_weight = FND_API.G_MISS_NUM)
2324: AND (l_snap_tot_weight IS NOT NULL))
2325: THEN
2326: IF l_debug_on THEN
2327: WSH_DEBUG_SV.logmsg(l_module_name,' stop departure gross weight is G_MISS_NUM',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2335: IF ((p_new_segment_stop_rec.departure_volume <> FND_API.G_MISS_NUM)

2331:
2332: END IF;
2333:
2334:
2335: IF ((p_new_segment_stop_rec.departure_volume <> FND_API.G_MISS_NUM)
2336: AND (l_snap_tot_volume IS NULL))
2337: THEN
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is not G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2344: ELSIF ((p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)

2340: WSH_DEBUG_SV.logmsg(l_module_name,' Snapshot total volume is null send update ',WSH_DEBUG_SV.C_PROC_LEVEL);
2341: END IF;
2342: l_send_update := TRUE;
2343:
2344: ELSIF ((p_new_segment_stop_rec.departure_volume = FND_API.G_MISS_NUM)
2345: AND (l_snap_tot_volume IS NOT NULL))
2346: THEN
2347: IF l_debug_on THEN
2348: WSH_DEBUG_SV.logmsg(l_module_name,' Stop departure volume is G_MISS_NUM ',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2358: IF (l_site_trans_rec.WEIGHT_THRESHOLD_LOWER <> FND_API.G_MISS_NUM)

2354:
2355: IF (NOT l_send_update)
2356: THEN
2357: -- check threshold value
2358: IF (l_site_trans_rec.WEIGHT_THRESHOLD_LOWER <> FND_API.G_MISS_NUM)
2359: THEN
2360: -- Fix for Bug 2783938
2361: IF ( (ABS(l_snap_tot_weight - (l_snap_tot_weight*l_site_trans_rec.WEIGHT_THRESHOLD_LOWER*0.01)))
2362: > p_new_segment_stop_rec.departure_gross_weight)

Line 2372: IF (l_site_trans_rec.WEIGHT_THRESHOLD_UPPER <> FND_API.G_MISS_NUM)

2368:
2369: END IF;
2370: END IF;
2371:
2372: IF (l_site_trans_rec.WEIGHT_THRESHOLD_UPPER <> FND_API.G_MISS_NUM)
2373: THEN
2374: -- Fix for Bug 2783938
2375: IF ( (ABS(l_snap_tot_weight + (l_snap_tot_weight*l_site_trans_rec.WEIGHT_THRESHOLD_UPPER*0.01)))
2376: < p_new_segment_stop_rec.departure_gross_weight)

Line 2391: IF (l_site_trans_rec.VOLUME_THRESHOLD_LOWER <> FND_API.G_MISS_NUM)

2387: IF (NOT l_send_update)
2388: THEN
2389:
2390: -- check threshold value
2391: IF (l_site_trans_rec.VOLUME_THRESHOLD_LOWER <> FND_API.G_MISS_NUM)
2392: THEN
2393:
2394: -- Fix for Bug 2783938
2395: IF ( (ABS(l_snap_tot_volume - (l_snap_tot_volume*l_site_trans_rec.VOLUME_THRESHOLD_LOWER*0.01)))

Line 2406: IF (l_site_trans_rec.VOLUME_THRESHOLD_UPPER <> FND_API.G_MISS_NUM)

2402: l_send_update := TRUE;
2403: END IF;
2404: END IF;
2405:
2406: IF (l_site_trans_rec.VOLUME_THRESHOLD_UPPER <> FND_API.G_MISS_NUM)
2407: THEN
2408: -- Fix for Bug 2783938
2409: IF ( (ABS(l_snap_tot_volume + (l_snap_tot_volume*l_site_trans_rec.VOLUME_THRESHOLD_UPPER*0.01)))
2410: < p_new_segment_stop_rec.departure_volume)

Line 2444: p_init_msg_list => FND_API.G_FALSE,

2440:
2441: END IF;
2442:
2443: TAKE_TENDER_SNAPSHOT(
2444: p_init_msg_list => FND_API.G_FALSE,
2445: p_tender_id => l_tender_number,
2446: p_trip_id => l_trip_id,
2447: p_stop_id => l_stop_id,
2448: p_total_weight => P_new_segment_stop_rec.DEPARTURE_GROSS_WEIGHT,

Line 2498: p_init_msg_list => FND_API.G_FALSE,

2494: THEN
2495: -- update tender snapshot with session value
2496: -- so that we do not send another message to carrier
2497: TAKE_TENDER_SNAPSHOT(
2498: p_init_msg_list => FND_API.G_FALSE,
2499: p_tender_id => l_tender_number,
2500: p_trip_id => l_trip_id,
2501: p_stop_id => l_stop_id,
2502: p_total_weight => NULL,

Line 2534: p_init_msg_list => FND_API.G_FALSE,

2530: END IF;
2531:
2532: FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP
2533: ( p_api_version_number => 1.0,
2534: p_init_msg_list => FND_API.G_FALSE,
2535: p_action_code => 'UPDATE',
2536: p_action => FTE_TENDER_PVT.S_SHIPPER_UPDATED,
2537: p_rec_TRIP_ID => l_trip_id,
2538: x_return_status => l_return_status,

Line 2605: p_encoded => FND_API.G_FALSE

2601: FND_MSG_PUB.Count_And_Get
2602: (
2603: p_count => x_msg_count,
2604: p_data => x_msg_data,
2605: p_encoded => FND_API.G_FALSE
2606: );
2607: --
2608: --
2609:

Line 2613: WHEN FND_API.G_EXC_ERROR THEN

2609:
2610: --}
2611: EXCEPTION
2612: --{
2613: WHEN FND_API.G_EXC_ERROR THEN
2614: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2615: x_return_status := FND_API.G_RET_STS_ERROR ;
2616: FND_MSG_PUB.Count_And_Get
2617: (

Line 2615: x_return_status := FND_API.G_RET_STS_ERROR ;

2611: EXCEPTION
2612: --{
2613: WHEN FND_API.G_EXC_ERROR THEN
2614: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2615: x_return_status := FND_API.G_RET_STS_ERROR ;
2616: FND_MSG_PUB.Count_And_Get
2617: (
2618: p_count => x_msg_count,
2619: p_data => x_msg_data,

Line 2620: p_encoded => FND_API.G_FALSE

2616: FND_MSG_PUB.Count_And_Get
2617: (
2618: p_count => x_msg_count,
2619: p_data => x_msg_data,
2620: p_encoded => FND_API.G_FALSE
2621: );
2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.pop(l_module_name);
2624: END IF;

Line 2626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2622: IF l_debug_on THEN
2623: WSH_DEBUG_SV.pop(l_module_name);
2624: END IF;
2625:
2626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2627: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2629: FND_MSG_PUB.Count_And_Get
2630: (

Line 2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2624: END IF;
2625:
2626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2627: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2629: FND_MSG_PUB.Count_And_Get
2630: (
2631: p_count => x_msg_count,
2632: p_data => x_msg_data,

Line 2633: p_encoded => FND_API.G_FALSE

2629: FND_MSG_PUB.Count_And_Get
2630: (
2631: p_count => x_msg_count,
2632: p_data => x_msg_data,
2633: p_encoded => FND_API.G_FALSE
2634: );
2635: IF l_debug_on THEN
2636: WSH_DEBUG_SV.pop(l_module_name);
2637: END IF;

Line 2646: p_encoded => FND_API.G_FALSE

2642: FND_MSG_PUB.Count_And_Get
2643: (
2644: p_count => x_msg_count,
2645: p_data => x_msg_data,
2646: p_encoded => FND_API.G_FALSE
2647: );
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.pop(l_module_name);
2650: END IF;

Line 2683: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2679: -- ------------------------------------------------------------------------------- --
2680:
2681:
2682: PROCEDURE HANDLE_WF_ROLES(
2683: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2684: x_return_status OUT NOCOPY VARCHAR2,
2685: x_msg_count OUT NOCOPY NUMBER,
2686: x_msg_data OUT NOCOPY VARCHAR2,
2687: x_role_name OUT NOCOPY VARCHAR2,

Line 2923: p_encoded => FND_API.G_FALSE

2919: FND_MSG_PUB.Count_And_Get
2920: (
2921: p_count => x_msg_count,
2922: p_data => x_msg_data,
2923: p_encoded => FND_API.G_FALSE
2924: );
2925: --
2926: --
2927:

Line 2931: WHEN FND_API.G_EXC_ERROR THEN

2927:
2928: --}
2929: EXCEPTION
2930: --{
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2933: x_return_status := FND_API.G_RET_STS_ERROR ;
2934: FND_MSG_PUB.Count_And_Get
2935: (

Line 2933: x_return_status := FND_API.G_RET_STS_ERROR ;

2929: EXCEPTION
2930: --{
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2933: x_return_status := FND_API.G_RET_STS_ERROR ;
2934: FND_MSG_PUB.Count_And_Get
2935: (
2936: p_count => x_msg_count,
2937: p_data => x_msg_data,

Line 2938: p_encoded => FND_API.G_FALSE

2934: FND_MSG_PUB.Count_And_Get
2935: (
2936: p_count => x_msg_count,
2937: p_data => x_msg_data,
2938: p_encoded => FND_API.G_FALSE
2939: );
2940: IF l_debug_on THEN
2941: WSH_DEBUG_SV.pop(l_module_name);
2942: END IF;

Line 2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2940: IF l_debug_on THEN
2941: WSH_DEBUG_SV.pop(l_module_name);
2942: END IF;
2943:
2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2947: FND_MSG_PUB.Count_And_Get
2948: (

Line 2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2942: END IF;
2943:
2944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2945: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2947: FND_MSG_PUB.Count_And_Get
2948: (
2949: p_count => x_msg_count,
2950: p_data => x_msg_data,

Line 2951: p_encoded => FND_API.G_FALSE

2947: FND_MSG_PUB.Count_And_Get
2948: (
2949: p_count => x_msg_count,
2950: p_data => x_msg_data,
2951: p_encoded => FND_API.G_FALSE
2952: );
2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.pop(l_module_name);
2955: END IF;

Line 2959: x_return_status := FND_API.G_RET_STS_ERROR;

2955: END IF;
2956: WHEN OTHERS THEN
2957: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960: FND_MSG_PUB.Count_And_Get
2961: (
2962: p_count => x_msg_count,
2963: p_data => x_msg_data,

Line 2964: p_encoded => FND_API.G_FALSE

2960: FND_MSG_PUB.Count_And_Get
2961: (
2962: p_count => x_msg_count,
2963: p_data => x_msg_data,
2964: p_encoded => FND_API.G_FALSE
2965: );
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.pop(l_module_name);
2968: END IF;

Line 3012: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3008: -- ------------------------------------------------------------------------------- --
3009:
3010:
3011: PROCEDURE RAISE_TENDER_EVENT(
3012: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3013: x_return_status OUT NOCOPY VARCHAR2,
3014: x_msg_count OUT NOCOPY NUMBER,
3015: x_msg_data OUT NOCOPY VARCHAR2,
3016: p_tender_id IN NUMBER,

Line 3048: IF FND_API.to_Boolean( p_init_msg_list )

3044: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3045: x_msg_count := 0;
3046: x_msg_data := 0;
3047:
3048: IF FND_API.to_Boolean( p_init_msg_list )
3049: THEN
3050: FND_MSG_PUB.initialize;
3051: END IF;
3052:

Line 3070: p_init_msg_list => FND_API.G_FALSE,

3066: p_action = FTE_TENDER_PVT.S_SHIPPER_UPDATED)
3067: THEN
3068:
3069: HANDLE_WF_ROLES(
3070: p_init_msg_list => FND_API.G_FALSE,
3071: x_return_status => l_return_status,
3072: x_msg_count => l_msg_count,
3073: x_msg_data => l_msg_data,
3074: x_role_name => l_role_name,

Line 3086: RAISE FND_API.G_EXC_ERROR;

3082:
3083: IF l_number_of_errors > 0
3084: THEN
3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3086: RAISE FND_API.G_EXC_ERROR;
3087: ELSIF l_number_of_warnings > 0
3088: THEN
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3090: ELSE

Line 3172: p_encoded => FND_API.G_FALSE

3168: FND_MSG_PUB.Count_And_Get
3169: (
3170: p_count => x_msg_count,
3171: p_data => x_msg_data,
3172: p_encoded => FND_API.G_FALSE
3173: );
3174: --
3175: --
3176:

Line 3180: WHEN FND_API.G_EXC_ERROR THEN

3176:
3177: --}
3178: EXCEPTION
3179: --{
3180: WHEN FND_API.G_EXC_ERROR THEN
3181: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3182: x_return_status := FND_API.G_RET_STS_ERROR ;
3183: FND_MSG_PUB.Count_And_Get
3184: (

Line 3182: x_return_status := FND_API.G_RET_STS_ERROR ;

3178: EXCEPTION
3179: --{
3180: WHEN FND_API.G_EXC_ERROR THEN
3181: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3182: x_return_status := FND_API.G_RET_STS_ERROR ;
3183: FND_MSG_PUB.Count_And_Get
3184: (
3185: p_count => x_msg_count,
3186: p_data => x_msg_data,

Line 3187: p_encoded => FND_API.G_FALSE

3183: FND_MSG_PUB.Count_And_Get
3184: (
3185: p_count => x_msg_count,
3186: p_data => x_msg_data,
3187: p_encoded => FND_API.G_FALSE
3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3185: p_count => x_msg_count,
3186: p_data => x_msg_data,
3187: p_encoded => FND_API.G_FALSE
3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: FND_MSG_PUB.Count_And_Get
3193: (

Line 3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3187: p_encoded => FND_API.G_FALSE
3188: );
3189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3190: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: FND_MSG_PUB.Count_And_Get
3193: (
3194: p_count => x_msg_count,
3195: p_data => x_msg_data,

Line 3196: p_encoded => FND_API.G_FALSE

3192: FND_MSG_PUB.Count_And_Get
3193: (
3194: p_count => x_msg_count,
3195: p_data => x_msg_data,
3196: p_encoded => FND_API.G_FALSE
3197: );
3198: WHEN OTHERS THEN
3199: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');

Line 3201: x_return_status := FND_API.G_RET_STS_ERROR;

3197: );
3198: WHEN OTHERS THEN
3199: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,
3205: p_data => x_msg_data,

Line 3206: p_encoded => FND_API.G_FALSE

3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,
3205: p_data => x_msg_data,
3206: p_encoded => FND_API.G_FALSE
3207: );
3208:
3209: --}
3210:

Line 3292: p_encoded => FND_API.G_FALSE

3288: FND_MSG_PUB.Count_And_Get
3289: (
3290: p_count => x_msg_count,
3291: p_data => x_msg_data,
3292: p_encoded => FND_API.G_FALSE
3293: );
3294:
3295: wsh_util_core.api_post_call(
3296: p_return_status =>l_preturn_status,

Line 3303: RAISE FND_API.G_EXC_ERROR;

3299: p_msg_data =>x_msg_data);
3300:
3301: IF l_number_of_perrors > 0 THEN
3302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF l_number_of_pwarnings > 0 THEN
3305: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3306: ELSE
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3341: p_encoded => FND_API.G_FALSE

3337: FND_MSG_PUB.Count_And_Get
3338: (
3339: p_count => x_msg_count,
3340: p_data => x_msg_data,
3341: p_encoded => FND_API.G_FALSE
3342: );
3343:
3344: wsh_util_core.api_post_call(
3345: p_return_status =>l_dreturn_status,

Line 3352: RAISE FND_API.G_EXC_ERROR;

3348: p_msg_data =>x_msg_data);
3349:
3350: IF l_number_of_derrors > 0 THEN
3351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3352: RAISE FND_API.G_EXC_ERROR;
3353: ELSIF l_number_of_dwarnings > 0 THEN
3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3355: ELSE
3356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3369: WHEN FND_API.G_EXC_ERROR THEN

3365:
3366:
3367: EXCEPTION
3368:
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3371: x_return_status := FND_API.G_RET_STS_ERROR ;
3372: FND_MSG_PUB.Count_And_Get
3373: (

Line 3371: x_return_status := FND_API.G_RET_STS_ERROR ;

3367: EXCEPTION
3368:
3369: WHEN FND_API.G_EXC_ERROR THEN
3370: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3371: x_return_status := FND_API.G_RET_STS_ERROR ;
3372: FND_MSG_PUB.Count_And_Get
3373: (
3374: p_count => x_msg_count,
3375: p_data => x_msg_data,

Line 3376: p_encoded => FND_API.G_FALSE

3372: FND_MSG_PUB.Count_And_Get
3373: (
3374: p_count => x_msg_count,
3375: p_data => x_msg_data,
3376: p_encoded => FND_API.G_FALSE
3377: );
3378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3379: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3380: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3374: p_count => x_msg_count,
3375: p_data => x_msg_data,
3376: p_encoded => FND_API.G_FALSE
3377: );
3378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3379: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3380: x_return_status := FND_API.G_RET_STS_ERROR ;
3381: FND_MSG_PUB.Count_And_Get
3382: (

Line 3380: x_return_status := FND_API.G_RET_STS_ERROR ;

3376: p_encoded => FND_API.G_FALSE
3377: );
3378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3379: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3380: x_return_status := FND_API.G_RET_STS_ERROR ;
3381: FND_MSG_PUB.Count_And_Get
3382: (
3383: p_count => x_msg_count,
3384: p_data => x_msg_data,

Line 3385: p_encoded => FND_API.G_FALSE

3381: FND_MSG_PUB.Count_And_Get
3382: (
3383: p_count => x_msg_count,
3384: p_data => x_msg_data,
3385: p_encoded => FND_API.G_FALSE
3386: );
3387: WHEN OTHERS THEN
3388: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');

Line 3395: p_encoded => FND_API.G_FALSE

3391: FND_MSG_PUB.Count_And_Get
3392: (
3393: p_count => x_msg_count,
3394: p_data => x_msg_data,
3395: p_encoded => FND_API.G_FALSE
3396: );
3397: END LOG_CARRIER_ARR_EXC;
3398:
3399:

Line 3485: WHEN FND_API.G_EXC_ERROR THEN

3481:
3482:
3483: EXCEPTION
3484:
3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3487: x_return_status := FND_API.G_RET_STS_ERROR ;
3488: FND_MSG_PUB.Count_And_Get
3489: (

Line 3487: x_return_status := FND_API.G_RET_STS_ERROR ;

3483: EXCEPTION
3484:
3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3487: x_return_status := FND_API.G_RET_STS_ERROR ;
3488: FND_MSG_PUB.Count_And_Get
3489: (
3490: p_count => x_msg_count,
3491: p_data => x_msg_data,

Line 3492: p_encoded => FND_API.G_FALSE

3488: FND_MSG_PUB.Count_And_Get
3489: (
3490: p_count => x_msg_count,
3491: p_data => x_msg_data,
3492: p_encoded => FND_API.G_FALSE
3493: );
3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3495: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3496: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3490: p_count => x_msg_count,
3491: p_data => x_msg_data,
3492: p_encoded => FND_API.G_FALSE
3493: );
3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3495: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3496: x_return_status := FND_API.G_RET_STS_ERROR ;
3497: FND_MSG_PUB.Count_And_Get
3498: (

Line 3496: x_return_status := FND_API.G_RET_STS_ERROR ;

3492: p_encoded => FND_API.G_FALSE
3493: );
3494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3495: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3496: x_return_status := FND_API.G_RET_STS_ERROR ;
3497: FND_MSG_PUB.Count_And_Get
3498: (
3499: p_count => x_msg_count,
3500: p_data => x_msg_data,

Line 3501: p_encoded => FND_API.G_FALSE

3497: FND_MSG_PUB.Count_And_Get
3498: (
3499: p_count => x_msg_count,
3500: p_data => x_msg_data,
3501: p_encoded => FND_API.G_FALSE
3502: );
3503: WHEN OTHERS THEN
3504: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');

Line 3511: p_encoded => FND_API.G_FALSE

3507: FND_MSG_PUB.Count_And_Get
3508: (
3509: p_count => x_msg_count,
3510: p_data => x_msg_data,
3511: p_encoded => FND_API.G_FALSE
3512: );
3513: END CHECK_CARRIER_ARRIVAL_TIME;
3514:
3515:

Line 3529: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

3525: l_exception_msg_data varchar2(2000);
3526: l_dummy_exception_id NUMBER;
3527: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3528: l_msg VARCHAR2(2000);
3529: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3530:
3531: l_msg varchar2(2000);
3532: l_msg_count NUMBER ;
3533: l_msg_data VARCHAR2(200);

Line 3599: p_init_msg_list => FND_API.g_false,

3595: l_msg_data := NULL;
3596:
3597: WSH_XC_UTIL.change_status (
3598: p_api_version => 1.0,
3599: p_init_msg_list => FND_API.g_false,
3600: p_commit => FND_API.g_false,
3601: p_validation_level => l_validation_level,
3602: x_return_status => l_return_status,
3603: x_msg_count => l_msg_count,

Line 3600: p_commit => FND_API.g_false,

3596:
3597: WSH_XC_UTIL.change_status (
3598: p_api_version => 1.0,
3599: p_init_msg_list => FND_API.g_false,
3600: p_commit => FND_API.g_false,
3601: p_validation_level => l_validation_level,
3602: x_return_status => l_return_status,
3603: x_msg_count => l_msg_count,
3604: x_msg_data => l_msg_data,

Line 3607: p_set_default_status => FND_API.G_FALSE,

3603: x_msg_count => l_msg_count,
3604: x_msg_data => l_msg_data,
3605: p_exception_id => l_exception_id,
3606: p_old_status => l_status,
3607: p_set_default_status => FND_API.G_FALSE,
3608: x_new_status => l_new_status
3609: );
3610:
3611: END LOOP;

Line 3619: p_encoded => FND_API.G_FALSE

3615: FND_MSG_PUB.Count_And_Get
3616: (
3617: p_count => x_msg_count,
3618: p_data => x_msg_data,
3619: p_encoded => FND_API.G_FALSE
3620: );
3621: wsh_util_core.api_post_call(
3622: p_return_status =>l_return_status,
3623: x_num_warnings =>l_number_of_warnings,

Line 3630: RAISE FND_API.G_EXC_ERROR;

3626:
3627: IF l_number_of_errors > 0
3628: THEN
3629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3630: RAISE FND_API.G_EXC_ERROR;
3631: ELSIF l_number_of_warnings > 0
3632: THEN
3633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3634: ELSE

Line 3646: WHEN FND_API.G_EXC_ERROR THEN

3642:
3643:
3644: EXCEPTION
3645:
3646: WHEN FND_API.G_EXC_ERROR THEN
3647: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3648: x_return_status := FND_API.G_RET_STS_ERROR ;
3649: FND_MSG_PUB.Count_And_Get
3650: (

Line 3648: x_return_status := FND_API.G_RET_STS_ERROR ;

3644: EXCEPTION
3645:
3646: WHEN FND_API.G_EXC_ERROR THEN
3647: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3648: x_return_status := FND_API.G_RET_STS_ERROR ;
3649: FND_MSG_PUB.Count_And_Get
3650: (
3651: p_count => x_msg_count,
3652: p_data => x_msg_data,

Line 3653: p_encoded => FND_API.G_FALSE

3649: FND_MSG_PUB.Count_And_Get
3650: (
3651: p_count => x_msg_count,
3652: p_data => x_msg_data,
3653: p_encoded => FND_API.G_FALSE
3654: );
3655:
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;

Line 3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3652: p_data => x_msg_data,
3653: p_encoded => FND_API.G_FALSE
3654: );
3655:
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3658: x_return_status := FND_API.G_RET_STS_ERROR ;
3659: FND_MSG_PUB.Count_And_Get
3660: (

Line 3658: x_return_status := FND_API.G_RET_STS_ERROR ;

3654: );
3655:
3656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3657: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3658: x_return_status := FND_API.G_RET_STS_ERROR ;
3659: FND_MSG_PUB.Count_And_Get
3660: (
3661: p_count => x_msg_count,
3662: p_data => x_msg_data,

Line 3663: p_encoded => FND_API.G_FALSE

3659: FND_MSG_PUB.Count_And_Get
3660: (
3661: p_count => x_msg_count,
3662: p_data => x_msg_data,
3663: p_encoded => FND_API.G_FALSE
3664: );
3665:
3666: WHEN OTHERS THEN
3667: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;

Line 3674: p_encoded => FND_API.G_FALSE

3670: FND_MSG_PUB.Count_And_Get
3671: (
3672: p_count => x_msg_count,
3673: p_data => x_msg_data,
3674: p_encoded => FND_API.G_FALSE
3675: );
3676:
3677: END COMPLETE_CANCEL_TENDER;
3678:

Line 3724: IF FND_API.to_Boolean( p_init_msg_list )

3720: IF l_debug_on THEN
3721: WSH_DEBUG_SV.push(l_module_name);
3722: END IF;
3723:
3724: IF FND_API.to_Boolean( p_init_msg_list )
3725: THEN
3726: FND_MSG_PUB.initialize;
3727: END IF;
3728:

Line 3738: p_init_msg_list => FND_API.G_FALSE,

3734: l_number_of_errors := 0;
3735:
3736:
3737: HANDLE_WF_ROLES(
3738: p_init_msg_list => FND_API.G_FALSE,
3739: x_return_status => l_return_status,
3740: x_msg_count => l_msg_count,
3741: x_msg_data => l_msg_data,
3742: x_role_name => l_role_name,

Line 3754: p_init_msg_list => FND_API.G_FALSE,

3750:
3751:
3752: -- Take a snapshot
3753: TAKE_TENDER_SNAPSHOT(
3754: p_init_msg_list => FND_API.G_FALSE,
3755: p_trip_id => p_trip_info.trip_id,
3756: p_action => 'REPLACE',
3757: x_return_status => l_return_status,
3758: x_msg_count => l_msg_count,

Line 3770: RAISE FND_API.G_EXC_ERROR;

3766:
3767: IF l_number_of_errors > 0
3768: THEN
3769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSIF l_number_of_warnings > 0
3772: THEN
3773: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3774: ELSE

Line 3855: p_encoded => FND_API.G_FALSE

3851: FND_MSG_PUB.Count_And_Get
3852: (
3853: p_count => x_msg_count,
3854: p_data => x_msg_data,
3855: p_encoded => FND_API.G_FALSE
3856: );
3857:
3858:
3859: --

Line 3869: WHEN FND_API.G_EXC_ERROR THEN

3865:
3866: --}
3867: EXCEPTION
3868: --{
3869: WHEN FND_API.G_EXC_ERROR THEN
3870: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3871: x_return_status := FND_API.G_RET_STS_ERROR ;
3872: FND_MSG_PUB.Count_And_Get
3873: (

Line 3871: x_return_status := FND_API.G_RET_STS_ERROR ;

3867: EXCEPTION
3868: --{
3869: WHEN FND_API.G_EXC_ERROR THEN
3870: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3871: x_return_status := FND_API.G_RET_STS_ERROR ;
3872: FND_MSG_PUB.Count_And_Get
3873: (
3874: p_count => x_msg_count,
3875: p_data => x_msg_data,

Line 3876: p_encoded => FND_API.G_FALSE

3872: FND_MSG_PUB.Count_And_Get
3873: (
3874: p_count => x_msg_count,
3875: p_data => x_msg_data,
3876: p_encoded => FND_API.G_FALSE
3877: );
3878: IF l_debug_on THEN
3879: WSH_DEBUG_SV.pop(l_module_name);
3880: END IF;

Line 3883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3879: WSH_DEBUG_SV.pop(l_module_name);
3880: END IF;
3881:
3882:
3883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3884: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3886: FND_MSG_PUB.Count_And_Get
3887: (

Line 3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3881:
3882:
3883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3884: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3886: FND_MSG_PUB.Count_And_Get
3887: (
3888: p_count => x_msg_count,
3889: p_data => x_msg_data,

Line 3890: p_encoded => FND_API.G_FALSE

3886: FND_MSG_PUB.Count_And_Get
3887: (
3888: p_count => x_msg_count,
3889: p_data => x_msg_data,
3890: p_encoded => FND_API.G_FALSE
3891: );
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.pop(l_module_name);
3894: END IF;

Line 3900: x_return_status := FND_API.G_RET_STS_ERROR;

3896:
3897: WHEN OTHERS THEN
3898: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3900: x_return_status := FND_API.G_RET_STS_ERROR;
3901: FND_MSG_PUB.Count_And_Get
3902: (
3903: p_count => x_msg_count,
3904: p_data => x_msg_data,

Line 3905: p_encoded => FND_API.G_FALSE

3901: FND_MSG_PUB.Count_And_Get
3902: (
3903: p_count => x_msg_count,
3904: p_data => x_msg_data,
3905: p_encoded => FND_API.G_FALSE
3906: );
3907: IF l_debug_on THEN
3908: WSH_DEBUG_SV.pop(l_module_name);
3909: END IF;

Line 3986: IF FND_API.to_Boolean( p_init_msg_list )

3982: -- 11i11 Code
3983:
3984: SAVEPOINT UPDATE_CARRIER_RESPONSE_PUB;
3985:
3986: IF FND_API.to_Boolean( p_init_msg_list )
3987: THEN
3988: FND_MSG_PUB.initialize;
3989: END IF;
3990: --

Line 4073: p_init_msg_list =>FND_API.G_FALSE,

4069:
4070: WSH_INTERFACE_GRP.Create_Update_Trip
4071: (
4072: p_api_version_number =>1.0,
4073: p_init_msg_list =>FND_API.G_FALSE,
4074: p_commit =>FND_API.G_FALSE,
4075: x_return_status =>l_return_status,
4076: x_msg_count =>l_msg_count,
4077: x_msg_data =>l_msg_data,

Line 4074: p_commit =>FND_API.G_FALSE,

4070: WSH_INTERFACE_GRP.Create_Update_Trip
4071: (
4072: p_api_version_number =>1.0,
4073: p_init_msg_list =>FND_API.G_FALSE,
4074: p_commit =>FND_API.G_FALSE,
4075: x_return_status =>l_return_status,
4076: x_msg_count =>l_msg_count,
4077: x_msg_data =>l_msg_data,
4078: p_trip_info_tab =>p_trip_info_tab,

Line 4122: p_init_msg_list =>FND_API.G_FALSE,

4118:
4119: WSH_INTERFACE_GRP.Create_Update_Trip
4120: (
4121: p_api_version_number =>1.0,
4122: p_init_msg_list =>FND_API.G_FALSE,
4123: p_commit =>FND_API.G_FALSE,
4124: x_return_status =>l_return_status,
4125: x_msg_count =>l_msg_count,
4126: x_msg_data =>l_msg_data,

Line 4123: p_commit =>FND_API.G_FALSE,

4119: WSH_INTERFACE_GRP.Create_Update_Trip
4120: (
4121: p_api_version_number =>1.0,
4122: p_init_msg_list =>FND_API.G_FALSE,
4123: p_commit =>FND_API.G_FALSE,
4124: x_return_status =>l_return_status,
4125: x_msg_count =>l_msg_count,
4126: x_msg_data =>l_msg_data,
4127: p_trip_info_tab =>p_trip_info_tab,

Line 4152: RAISE FND_API.G_EXC_ERROR;

4148:
4149: IF l_number_of_errors > 0
4150: THEN
4151: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4152: RAISE FND_API.G_EXC_ERROR;
4153: ELSIF l_number_of_warnings > 0
4154: THEN
4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4156: ELSE

Line 4167: p_encoded => FND_API.G_FALSE

4163: FND_MSG_PUB.Count_And_Get
4164: (
4165: p_count => x_msg_count,
4166: p_data => x_msg_data,
4167: p_encoded => FND_API.G_FALSE
4168: );
4169: --
4170: --
4171:

Line 4181: RAISE FND_API.G_EXC_ERROR;

4177:
4178: IF l_number_of_errors > 0
4179: THEN
4180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4181: RAISE FND_API.G_EXC_ERROR;
4182: ELSIF l_number_of_warnings > 0
4183: THEN
4184: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4185: ELSE

Line 4197: WHEN FND_API.G_EXC_ERROR THEN

4193: END IF;
4194:
4195: EXCEPTION
4196:
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4199: x_return_status := FND_API.G_RET_STS_ERROR ;
4200: FND_MSG_PUB.Count_And_Get
4201: (

Line 4199: x_return_status := FND_API.G_RET_STS_ERROR ;

4195: EXCEPTION
4196:
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4199: x_return_status := FND_API.G_RET_STS_ERROR ;
4200: FND_MSG_PUB.Count_And_Get
4201: (
4202: p_count => x_msg_count,
4203: p_data => x_msg_data,

Line 4204: p_encoded => FND_API.G_FALSE

4200: FND_MSG_PUB.Count_And_Get
4201: (
4202: p_count => x_msg_count,
4203: p_data => x_msg_data,
4204: p_encoded => FND_API.G_FALSE
4205: );
4206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4207: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4202: p_count => x_msg_count,
4203: p_data => x_msg_data,
4204: p_encoded => FND_API.G_FALSE
4205: );
4206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4207: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4209: FND_MSG_PUB.Count_And_Get
4210: (

Line 4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4204: p_encoded => FND_API.G_FALSE
4205: );
4206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4207: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4209: FND_MSG_PUB.Count_And_Get
4210: (
4211: p_count => x_msg_count,
4212: p_data => x_msg_data,

Line 4213: p_encoded => FND_API.G_FALSE

4209: FND_MSG_PUB.Count_And_Get
4210: (
4211: p_count => x_msg_count,
4212: p_data => x_msg_data,
4213: p_encoded => FND_API.G_FALSE
4214: );
4215:
4216: WHEN OTHERS THEN
4217: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;

Line 4224: p_encoded => FND_API.G_FALSE

4220: FND_MSG_PUB.Count_And_Get
4221: (
4222: p_count => x_msg_count,
4223: p_data => x_msg_data,
4224: p_encoded => FND_API.G_FALSE
4225: );
4226:
4227:
4228: END UPDATE_CARRIER_RESPONSE;

Line 4274: IF FND_API.to_Boolean( p_init_msg_list )

4270: IF l_debug_on THEN
4271: WSH_DEBUG_SV.push(l_module_name);
4272: END IF;
4273:
4274: IF FND_API.to_Boolean( p_init_msg_list )
4275: THEN
4276: FND_MSG_PUB.initialize;
4277: END IF;
4278:

Line 4360: p_encoded => FND_API.G_FALSE

4356: FND_MSG_PUB.Count_And_Get
4357: (
4358: p_count => x_msg_count,
4359: p_data => x_msg_data,
4360: p_encoded => FND_API.G_FALSE
4361: );
4362:
4363:
4364: --

Line 4374: WHEN FND_API.G_EXC_ERROR THEN

4370:
4371: --}
4372: EXCEPTION
4373: --{
4374: WHEN FND_API.G_EXC_ERROR THEN
4375: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4376: x_return_status := FND_API.G_RET_STS_ERROR ;
4377: FND_MSG_PUB.Count_And_Get
4378: (

Line 4376: x_return_status := FND_API.G_RET_STS_ERROR ;

4372: EXCEPTION
4373: --{
4374: WHEN FND_API.G_EXC_ERROR THEN
4375: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4376: x_return_status := FND_API.G_RET_STS_ERROR ;
4377: FND_MSG_PUB.Count_And_Get
4378: (
4379: p_count => x_msg_count,
4380: p_data => x_msg_data,

Line 4381: p_encoded => FND_API.G_FALSE

4377: FND_MSG_PUB.Count_And_Get
4378: (
4379: p_count => x_msg_count,
4380: p_data => x_msg_data,
4381: p_encoded => FND_API.G_FALSE
4382: );
4383: IF l_debug_on THEN
4384: WSH_DEBUG_SV.pop(l_module_name);
4385: END IF;

Line 4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4384: WSH_DEBUG_SV.pop(l_module_name);
4385: END IF;
4386:
4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4391: FND_MSG_PUB.Count_And_Get
4392: (

Line 4390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4386:
4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4391: FND_MSG_PUB.Count_And_Get
4392: (
4393: p_count => x_msg_count,
4394: p_data => x_msg_data,

Line 4395: p_encoded => FND_API.G_FALSE

4391: FND_MSG_PUB.Count_And_Get
4392: (
4393: p_count => x_msg_count,
4394: p_data => x_msg_data,
4395: p_encoded => FND_API.G_FALSE
4396: );
4397: IF l_debug_on THEN
4398: WSH_DEBUG_SV.pop(l_module_name);
4399: END IF;

Line 4405: x_return_status := FND_API.G_RET_STS_ERROR;

4401:
4402: WHEN OTHERS THEN
4403: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406: FND_MSG_PUB.Count_And_Get
4407: (
4408: p_count => x_msg_count,
4409: p_data => x_msg_data,

Line 4410: p_encoded => FND_API.G_FALSE

4406: FND_MSG_PUB.Count_And_Get
4407: (
4408: p_count => x_msg_count,
4409: p_data => x_msg_data,
4410: p_encoded => FND_API.G_FALSE
4411: );
4412: IF l_debug_on THEN
4413: WSH_DEBUG_SV.pop(l_module_name);
4414: END IF;

Line 4464: IF FND_API.to_Boolean( p_init_msg_list )

4460: IF l_debug_on THEN
4461: WSH_DEBUG_SV.push(l_module_name);
4462: END IF;
4463:
4464: IF FND_API.to_Boolean( p_init_msg_list )
4465: THEN
4466: FND_MSG_PUB.initialize;
4467: END IF;
4468:

Line 4478: p_init_msg_list => FND_API.G_FALSE,

4474: l_number_of_errors := 0;
4475:
4476:
4477: UPDATE_CARRIER_RESPONSE(
4478: p_init_msg_list => FND_API.G_FALSE,
4479: p_carrier_response_rec => p_trip_info,
4480: x_return_status => l_return_status,
4481: x_msg_count => l_msg_count,
4482: x_msg_data => l_msg_data);

Line 4501: RAISE FND_API.G_EXC_ERROR;

4497:
4498: IF l_number_of_errors > 0
4499: THEN
4500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4501: RAISE FND_API.G_EXC_ERROR;
4502: ELSIF l_number_of_warnings > 0
4503: THEN
4504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4505: ELSE

Line 4517: p_init_msg_list => FND_API.G_FALSE,

4513: p_trip_info.response_source = FTE_TENDER_PVT.S_SOURCE_XML)
4514: THEN
4515:
4516: RELEASE_TENDER_BLOCK(
4517: p_init_msg_list => FND_API.G_FALSE,
4518: p_trip_info => p_trip_info,
4519: x_return_status => l_return_status,
4520: x_msg_count => l_msg_count,
4521: x_msg_data => l_msg_data);

Line 4533: RAISE FND_API.G_EXC_ERROR;

4529:
4530: IF l_number_of_errors > 0
4531: THEN
4532: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4533: RAISE FND_API.G_EXC_ERROR;
4534: ELSIF l_number_of_warnings > 0
4535: THEN
4536: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4537: ELSE

Line 4620: p_encoded => FND_API.G_FALSE

4616: FND_MSG_PUB.Count_And_Get
4617: (
4618: p_count => x_msg_count,
4619: p_data => x_msg_data,
4620: p_encoded => FND_API.G_FALSE
4621: );
4622:
4623:
4624: --

Line 4634: WHEN FND_API.G_EXC_ERROR THEN

4630:
4631: --}
4632: EXCEPTION
4633: --{
4634: WHEN FND_API.G_EXC_ERROR THEN
4635: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4636: x_return_status := FND_API.G_RET_STS_ERROR ;
4637: FND_MSG_PUB.Count_And_Get
4638: (

Line 4636: x_return_status := FND_API.G_RET_STS_ERROR ;

4632: EXCEPTION
4633: --{
4634: WHEN FND_API.G_EXC_ERROR THEN
4635: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4636: x_return_status := FND_API.G_RET_STS_ERROR ;
4637: FND_MSG_PUB.Count_And_Get
4638: (
4639: p_count => x_msg_count,
4640: p_data => x_msg_data,

Line 4641: p_encoded => FND_API.G_FALSE

4637: FND_MSG_PUB.Count_And_Get
4638: (
4639: p_count => x_msg_count,
4640: p_data => x_msg_data,
4641: p_encoded => FND_API.G_FALSE
4642: );
4643: IF l_debug_on THEN
4644: WSH_DEBUG_SV.pop(l_module_name);
4645: END IF;

Line 4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4644: WSH_DEBUG_SV.pop(l_module_name);
4645: END IF;
4646:
4647:
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4651: FND_MSG_PUB.Count_And_Get
4652: (

Line 4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4646:
4647:
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4651: FND_MSG_PUB.Count_And_Get
4652: (
4653: p_count => x_msg_count,
4654: p_data => x_msg_data,

Line 4655: p_encoded => FND_API.G_FALSE

4651: FND_MSG_PUB.Count_And_Get
4652: (
4653: p_count => x_msg_count,
4654: p_data => x_msg_data,
4655: p_encoded => FND_API.G_FALSE
4656: );
4657: IF l_debug_on THEN
4658: WSH_DEBUG_SV.pop(l_module_name);
4659: END IF;

Line 4665: x_return_status := FND_API.G_RET_STS_ERROR;

4661:
4662: WHEN OTHERS THEN
4663: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: FND_MSG_PUB.Count_And_Get
4667: (
4668: p_count => x_msg_count,
4669: p_data => x_msg_data,

Line 4670: p_encoded => FND_API.G_FALSE

4666: FND_MSG_PUB.Count_And_Get
4667: (
4668: p_count => x_msg_count,
4669: p_data => x_msg_data,
4670: p_encoded => FND_API.G_FALSE
4671: );
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.pop(l_module_name);
4674: END IF;

Line 4730: IF FND_API.to_Boolean( p_init_msg_list )

4726: IF l_debug_on THEN
4727: WSH_DEBUG_SV.push(l_module_name);
4728: END IF;
4729:
4730: IF FND_API.to_Boolean( p_init_msg_list )
4731: THEN
4732: FND_MSG_PUB.initialize;
4733: END IF;
4734:

Line 4763: p_init_msg_list =>FND_API.G_FALSE,

4759:
4760: WSH_INTERFACE_GRP.Create_Update_Trip
4761: (
4762: p_api_version_number =>1.0,
4763: p_init_msg_list =>FND_API.G_FALSE,
4764: p_commit =>FND_API.G_FALSE,
4765: x_return_status =>l_return_status,
4766: x_msg_count =>l_msg_count,
4767: x_msg_data =>l_msg_data,

Line 4764: p_commit =>FND_API.G_FALSE,

4760: WSH_INTERFACE_GRP.Create_Update_Trip
4761: (
4762: p_api_version_number =>1.0,
4763: p_init_msg_list =>FND_API.G_FALSE,
4764: p_commit =>FND_API.G_FALSE,
4765: x_return_status =>l_return_status,
4766: x_msg_count =>l_msg_count,
4767: x_msg_data =>l_msg_data,
4768: p_trip_info_tab =>p_trip_info_tab,

Line 4805: p_init_msg_list => FND_API.G_FALSE,

4801: p_msg_data =>l_msg_data);
4802:
4803:
4804: RELEASE_TENDER_BLOCK(
4805: p_init_msg_list => FND_API.G_FALSE,
4806: p_trip_info => p_trip_info,
4807: x_return_status => l_return_status,
4808: x_msg_count => l_msg_count,
4809: x_msg_data => l_msg_data);

Line 4820: RAISE FND_API.G_EXC_ERROR;

4816:
4817: IF l_number_of_errors > 0
4818: THEN
4819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4820: RAISE FND_API.G_EXC_ERROR;
4821: ELSIF l_number_of_warnings > 0
4822: THEN
4823: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4824: ELSE

Line 4902: p_encoded => FND_API.G_FALSE

4898: FND_MSG_PUB.Count_And_Get
4899: (
4900: p_count => x_msg_count,
4901: p_data => x_msg_data,
4902: p_encoded => FND_API.G_FALSE
4903: );
4904:
4905:
4906: --

Line 4916: WHEN FND_API.G_EXC_ERROR THEN

4912:
4913: --}
4914: EXCEPTION
4915: --{
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4918: x_return_status := FND_API.G_RET_STS_ERROR ;
4919: FND_MSG_PUB.Count_And_Get
4920: (

Line 4918: x_return_status := FND_API.G_RET_STS_ERROR ;

4914: EXCEPTION
4915: --{
4916: WHEN FND_API.G_EXC_ERROR THEN
4917: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4918: x_return_status := FND_API.G_RET_STS_ERROR ;
4919: FND_MSG_PUB.Count_And_Get
4920: (
4921: p_count => x_msg_count,
4922: p_data => x_msg_data,

Line 4923: p_encoded => FND_API.G_FALSE

4919: FND_MSG_PUB.Count_And_Get
4920: (
4921: p_count => x_msg_count,
4922: p_data => x_msg_data,
4923: p_encoded => FND_API.G_FALSE
4924: );
4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.pop(l_module_name);
4927: END IF;

Line 4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4926: WSH_DEBUG_SV.pop(l_module_name);
4927: END IF;
4928:
4929:
4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4931: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4933: FND_MSG_PUB.Count_And_Get
4934: (

Line 4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4928:
4929:
4930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4931: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4933: FND_MSG_PUB.Count_And_Get
4934: (
4935: p_count => x_msg_count,
4936: p_data => x_msg_data,

Line 4937: p_encoded => FND_API.G_FALSE

4933: FND_MSG_PUB.Count_And_Get
4934: (
4935: p_count => x_msg_count,
4936: p_data => x_msg_data,
4937: p_encoded => FND_API.G_FALSE
4938: );
4939: IF l_debug_on THEN
4940: WSH_DEBUG_SV.pop(l_module_name);
4941: END IF;

Line 4947: x_return_status := FND_API.G_RET_STS_ERROR;

4943:
4944: WHEN OTHERS THEN
4945: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');
4947: x_return_status := FND_API.G_RET_STS_ERROR;
4948: FND_MSG_PUB.Count_And_Get
4949: (
4950: p_count => x_msg_count,
4951: p_data => x_msg_data,

Line 4952: p_encoded => FND_API.G_FALSE

4948: FND_MSG_PUB.Count_And_Get
4949: (
4950: p_count => x_msg_count,
4951: p_data => x_msg_data,
4952: p_encoded => FND_API.G_FALSE
4953: );
4954: IF l_debug_on THEN
4955: WSH_DEBUG_SV.pop(l_module_name);
4956: END IF;

Line 4992: IF FND_API.to_Boolean( p_init_msg_list )

4988:
4989: BEGIN
4990: SAVEPOINT RAISE_TENDER_UPDATE_PUB;
4991:
4992: IF FND_API.to_Boolean( p_init_msg_list )
4993: THEN
4994: FND_MSG_PUB.initialize;
4995: END IF;
4996:

Line 5122: p_encoded => FND_API.G_FALSE

5118: FND_MSG_PUB.Count_And_Get
5119: (
5120: p_count => x_msg_count,
5121: p_data => x_msg_data,
5122: p_encoded => FND_API.G_FALSE
5123: );
5124: --
5125: --
5126:

Line 5131: WHEN FND_API.G_EXC_ERROR THEN

5127:
5128: --}
5129: EXCEPTION
5130: --{
5131: WHEN FND_API.G_EXC_ERROR THEN
5132: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5133: x_return_status := FND_API.G_RET_STS_ERROR ;
5134: FND_MSG_PUB.Count_And_Get
5135: (

Line 5133: x_return_status := FND_API.G_RET_STS_ERROR ;

5129: EXCEPTION
5130: --{
5131: WHEN FND_API.G_EXC_ERROR THEN
5132: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5133: x_return_status := FND_API.G_RET_STS_ERROR ;
5134: FND_MSG_PUB.Count_And_Get
5135: (
5136: p_count => x_msg_count,
5137: p_data => x_msg_data,

Line 5138: p_encoded => FND_API.G_FALSE

5134: FND_MSG_PUB.Count_And_Get
5135: (
5136: p_count => x_msg_count,
5137: p_data => x_msg_data,
5138: p_encoded => FND_API.G_FALSE
5139: );
5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5141: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5136: p_count => x_msg_count,
5137: p_data => x_msg_data,
5138: p_encoded => FND_API.G_FALSE
5139: );
5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5141: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5143: FND_MSG_PUB.Count_And_Get
5144: (

Line 5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5138: p_encoded => FND_API.G_FALSE
5139: );
5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5141: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5143: FND_MSG_PUB.Count_And_Get
5144: (
5145: p_count => x_msg_count,
5146: p_data => x_msg_data,

Line 5147: p_encoded => FND_API.G_FALSE

5143: FND_MSG_PUB.Count_And_Get
5144: (
5145: p_count => x_msg_count,
5146: p_data => x_msg_data,
5147: p_encoded => FND_API.G_FALSE
5148: );
5149: WHEN OTHERS THEN
5150: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');

Line 5152: x_return_status := FND_API.G_RET_STS_ERROR;

5148: );
5149: WHEN OTHERS THEN
5150: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');
5152: x_return_status := FND_API.G_RET_STS_ERROR;
5153: FND_MSG_PUB.Count_And_Get
5154: (
5155: p_count => x_msg_count,
5156: p_data => x_msg_data,

Line 5157: p_encoded => FND_API.G_FALSE

5153: FND_MSG_PUB.Count_And_Get
5154: (
5155: p_count => x_msg_count,
5156: p_data => x_msg_data,
5157: p_encoded => FND_API.G_FALSE
5158: );
5159:
5160: --}
5161: