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

APPS.WSH_INTERFACE_GRP dependencies on FND_API

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

344: --========================================================================
345: -- PROCEDURE : Delivery_Action Wrapper API PUBLIC
346: --
347: -- PARAMETERS: p_api_version_number known api version error number
348: -- p_init_msg_list FND_API.G_TRUE to reset list
349: -- x_return_status return status
350: -- x_msg_count number of messages in the list
351: -- x_msg_data text of messages
352: -- p_action_prms Record of caller, phase, action_code and other

Line 365: p_commit IN VARCHAR2 , -- default fnd_api.g_false

361: --========================================================================
362: PROCEDURE Delivery_Action
363: ( p_api_version_number IN NUMBER,
364: p_init_msg_list IN VARCHAR2,
365: p_commit IN VARCHAR2 , -- default fnd_api.g_false
366: p_action_prms IN WSH_DELIVERIES_GRP.action_parameters_rectype,
367: p_delivery_id_tab IN wsh_util_core.id_tab_type,
368: x_delivery_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
369: x_return_status OUT NOCOPY VARCHAR2,

Line 377: l_commit VARCHAR2(100) := FND_API.G_FALSE;

373: --
374: l_num_warnings NUMBER := 0;
375: l_num_errors NUMBER := 0;
376: l_index NUMBER;
377: l_commit VARCHAR2(100) := FND_API.G_FALSE;
378: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
379: --
380: l_defaults_rec wsh_deliveries_grp.default_parameters_rectype;
381: --

Line 378: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;

374: l_num_warnings NUMBER := 0;
375: l_num_errors NUMBER := 0;
376: l_index NUMBER;
377: l_commit VARCHAR2(100) := FND_API.G_FALSE;
378: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
379: --
380: l_defaults_rec wsh_deliveries_grp.default_parameters_rectype;
381: --
382: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

Line 436: IF FND_API.to_Boolean( p_init_msg_list ) THEN

432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;
435: --
436: IF FND_API.to_Boolean( p_init_msg_list ) THEN
437: FND_MSG_PUB.initialize;
438: END IF;
439: --
440: Rtrim_deliveries_action(p_action_prms,l_action_prms);

Line 519: IF FND_API.To_Boolean( p_commit ) THEN

515: IF l_num_warnings > 0 THEN
516: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
517: END IF;
518: --
519: IF FND_API.To_Boolean( p_commit ) THEN
520: COMMIT WORK;
521: END IF;
522: --
523: FND_MSG_PUB.Count_And_Get (

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: WSH_DEBUG_SV.pop(l_module_name);
529: END IF;
530: --
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
534: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_And_Get
536: (

Line 539: p_encoded => FND_API.G_FALSE

535: FND_MSG_PUB.Count_And_Get
536: (
537: p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => FND_API.G_FALSE
540: );
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

539: p_encoded => FND_API.G_FALSE
540: );
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

540: );
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;

Line 547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.Count_And_Get
551: (

Line 554: p_encoded => FND_API.G_FALSE

550: FND_MSG_PUB.Count_And_Get
551: (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => FND_API.G_FALSE
555: );
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

555: );
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 568: p_encoded => FND_API.G_FALSE

564: FND_MSG_PUB.Count_And_Get
565: (
566: p_count => x_msg_count,
567: p_data => x_msg_data,
568: p_encoded => FND_API.G_FALSE
569: );
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 584: p_encoded => FND_API.G_FALSE

580: FND_MSG_PUB.Count_And_Get
581: (
582: p_count => x_msg_count,
583: p_data => x_msg_data,
584: p_encoded => FND_API.G_FALSE
585: );
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

748: --========================================================================
749: -- PROCEDURE : Create_Update_Delivery Wrapper API PUBLIC
750: --
751: -- PARAMETERS: p_api_version_number known api version error buffer
752: -- p_init_msg_list FND_API.G_TRUE to reset list
753: -- x_return_status return status
754: -- x_msg_count number of messages in the list
755: -- x_msg_data text of messages
756: -- p_in_rec Record for caller, phase

Line 768: p_commit IN VARCHAR2 , -- default fnd_api.g_false

764: --========================================================================
765: PROCEDURE Create_Update_Delivery
766: ( p_api_version_number IN NUMBER,
767: p_init_msg_list IN VARCHAR2,
768: p_commit IN VARCHAR2 , -- default fnd_api.g_false
769: p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
770: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
771: x_del_out_rec_tab OUT NOCOPY WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
772: x_return_status OUT NOCOPY VARCHAR2,

Line 786: l_commit VARCHAR2(100) := FND_API.G_FALSE;

782: --
783: l_debug_on BOOLEAN;
784: --
785: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_WRAPPER';
786: l_commit VARCHAR2(100) := FND_API.G_FALSE;
787: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
788: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
789: l_index NUMBER;
790: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;

Line 787: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;

783: l_debug_on BOOLEAN;
784: --
785: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_WRAPPER';
786: l_commit VARCHAR2(100) := FND_API.G_FALSE;
787: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
788: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
789: l_index NUMBER;
790: l_in_rec WSH_DELIVERIES_GRP.Del_In_Rec_Type;
791: --

Line 812: IF FND_API.to_Boolean( p_init_msg_list ) THEN

808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;
811: --
812: IF FND_API.to_Boolean( p_init_msg_list ) THEN
813: FND_MSG_PUB.initialize;
814: END IF;
815: --
816: l_in_rec := p_in_rec;

Line 851: IF FND_API.To_Boolean( p_commit ) THEN

847: IF l_num_warnings > 0 THEN
848: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
849: END IF;
850: --
851: IF FND_API.To_Boolean( p_commit ) THEN
852: COMMIT WORK;
853: END IF;
854: --
855: FND_MSG_PUB.Count_And_Get (

Line 864: WHEN FND_API.G_EXC_ERROR THEN

860: WSH_DEBUG_SV.pop(l_module_name);
861: END IF;
862: --
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR THEN
865: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
866: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
867: FND_MSG_PUB.Count_And_Get
868: (

Line 871: p_encoded => FND_API.G_FALSE

867: FND_MSG_PUB.Count_And_Get
868: (
869: p_count => x_msg_count,
870: p_data => x_msg_data,
871: p_encoded => FND_API.G_FALSE
872: );
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

871: p_encoded => FND_API.G_FALSE
872: );
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
876: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

872: );
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
876: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;

Line 879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
876: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
882: FND_MSG_PUB.Count_And_Get
883: (

Line 886: p_encoded => FND_API.G_FALSE

882: FND_MSG_PUB.Count_And_Get
883: (
884: p_count => x_msg_count,
885: p_data => x_msg_data,
886: p_encoded => FND_API.G_FALSE
887: );
888: --
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

887: );
888: --
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 900: p_encoded => FND_API.G_FALSE

896: FND_MSG_PUB.Count_And_Get
897: (
898: p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
901: );
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 916: p_encoded => FND_API.G_FALSE

912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE
917: );
918: --
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1036: IF FND_API.to_Boolean( p_init_msg_list )

1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1033: END IF;
1034: --
1035:
1036: IF FND_API.to_Boolean( p_init_msg_list )
1037: THEN
1038: FND_MSG_PUB.initialize;
1039: END IF;
1040: --

Line 1052: RAISE FND_API.G_EXC_ERROR;

1048: IF(p_detail_id_tab.count = 0) THEN
1049: IF l_debug_on THEN
1050: wsh_debug_sv.log (l_module_name,'Input Table Count Zero');
1051: END IF;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055:
1056: --Build the records to pass to the core group api

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: IF l_debug_on THEN
1086: wsh_debug_sv.log (l_module_name,'Invalid Delivery Detail');
1087: END IF;
1088: CLOSE det_cur;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091:
1092: CLOSE det_cur;
1093:

Line 1113: p_init_msg_list => FND_API.G_FALSE,

1109: END IF;
1110:
1111: wsh_delivery_details_grp.Delivery_Detail_Action(
1112: p_api_version_number => p_api_version_number,
1113: p_init_msg_list => FND_API.G_FALSE,
1114: p_commit => FND_API.G_FALSE,
1115: x_return_status => l_return_status,
1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data,

Line 1114: p_commit => FND_API.G_FALSE,

1110:
1111: wsh_delivery_details_grp.Delivery_Detail_Action(
1112: p_api_version_number => p_api_version_number,
1113: p_init_msg_list => FND_API.G_FALSE,
1114: p_commit => FND_API.G_FALSE,
1115: x_return_status => l_return_status,
1116: x_msg_count => l_msg_count,
1117: x_msg_data => l_msg_data,
1118: p_rec_attr_tab => l_rec_attr_tab,

Line 1142: IF FND_API.To_Boolean( p_commit ) THEN

1138: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1139: END IF;
1140:
1141: -- Standard check of p_commit.
1142: IF FND_API.To_Boolean( p_commit ) THEN
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1145: END IF;
1146: COMMIT WORK;

Line 1160: WHEN FND_API.G_EXC_ERROR THEN

1156: WSH_DEBUG_SV.pop(l_module_name);
1157: END IF;
1158: --
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1162: x_return_status := FND_API.G_RET_STS_ERROR ;
1163: FND_MSG_PUB.Count_And_Get
1164: (

Line 1162: x_return_status := FND_API.G_RET_STS_ERROR ;

1158: --
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1162: x_return_status := FND_API.G_RET_STS_ERROR ;
1163: FND_MSG_PUB.Count_And_Get
1164: (
1165: p_count => x_msg_count,
1166: p_data => x_msg_data,

Line 1167: p_encoded => FND_API.G_FALSE

1163: FND_MSG_PUB.Count_And_Get
1164: (
1165: p_count => x_msg_count,
1166: p_data => x_msg_data,
1167: p_encoded => FND_API.G_FALSE
1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1167: p_encoded => FND_API.G_FALSE
1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;

Line 1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: FND_MSG_PUB.Count_And_Get
1179: (

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178: FND_MSG_PUB.Count_And_Get
1179: (
1180: p_count => x_msg_count,
1181: p_data => x_msg_data,

Line 1182: p_encoded => FND_API.G_FALSE

1178: FND_MSG_PUB.Count_And_Get
1179: (
1180: p_count => x_msg_count,
1181: p_data => x_msg_data,
1182: p_encoded => FND_API.G_FALSE
1183: );
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1182: p_encoded => FND_API.G_FALSE
1183: );
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1183: );
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1196: p_encoded => FND_API.G_FALSE

1192: FND_MSG_PUB.Count_And_Get
1193: (
1194: p_count => x_msg_count,
1195: p_data => x_msg_data,
1196: p_encoded => FND_API.G_FALSE
1197: );
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1203: --
1204: WHEN OTHERS THEN
1205: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1206: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: FND_MSG_PUB.Count_And_Get
1209: (
1210: p_count => x_msg_count,
1211: p_data => x_msg_data,

Line 1212: p_encoded => FND_API.G_FALSE

1208: FND_MSG_PUB.Count_And_Get
1209: (
1210: p_count => x_msg_count,
1211: p_data => x_msg_data,
1212: p_encoded => FND_API.G_FALSE
1213: );
1214: --
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1433: IF FND_API.to_Boolean( p_init_msg_list )

1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1430: END IF;
1431: --
1432: -- Initialize message list if p_init_msg_list is set to TRUE.
1433: IF FND_API.to_Boolean( p_init_msg_list )
1434: THEN
1435: FND_MSG_PUB.initialize;
1436: END IF;
1437: --

Line 1469: p_init_msg_list => FND_API.G_FALSE,

1465: END LOOP;
1466:
1467: wsh_delivery_details_grp.Create_Update_Delivery_Detail(
1468: p_api_version_number => p_api_version_number,
1469: p_init_msg_list => FND_API.G_FALSE,
1470: p_commit => FND_API.G_FALSE,
1471: x_return_status => l_return_status,
1472: x_msg_count => l_msg_count,
1473: x_msg_data => l_msg_data,

Line 1470: p_commit => FND_API.G_FALSE,

1466:
1467: wsh_delivery_details_grp.Create_Update_Delivery_Detail(
1468: p_api_version_number => p_api_version_number,
1469: p_init_msg_list => FND_API.G_FALSE,
1470: p_commit => FND_API.G_FALSE,
1471: x_return_status => l_return_status,
1472: x_msg_count => l_msg_count,
1473: x_msg_data => l_msg_data,
1474: p_detail_info_tab => l_detail_info_tab,

Line 1496: IF FND_API.To_Boolean( p_commit ) THEN

1492: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1493: END IF;
1494:
1495: -- Standard check of p_commit.
1496: IF FND_API.To_Boolean( p_commit ) THEN
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1499: END IF;
1500: COMMIT WORK;

Line 1514: WHEN FND_API.G_EXC_ERROR THEN

1510: WSH_DEBUG_SV.pop(l_module_name);
1511: END IF;
1512: --
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1516: x_return_status := FND_API.G_RET_STS_ERROR ;
1517: FND_MSG_PUB.Count_And_Get
1518: (

Line 1516: x_return_status := FND_API.G_RET_STS_ERROR ;

1512: --
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1516: x_return_status := FND_API.G_RET_STS_ERROR ;
1517: FND_MSG_PUB.Count_And_Get
1518: (
1519: p_count => x_msg_count,
1520: p_data => x_msg_data,

Line 1521: p_encoded => FND_API.G_FALSE

1517: FND_MSG_PUB.Count_And_Get
1518: (
1519: p_count => x_msg_count,
1520: p_data => x_msg_data,
1521: p_encoded => FND_API.G_FALSE
1522: );
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1521: p_encoded => FND_API.G_FALSE
1522: );
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1522: );
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1530: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;

Line 1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1530: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532: FND_MSG_PUB.Count_And_Get
1533: (

Line 1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1530: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532: FND_MSG_PUB.Count_And_Get
1533: (
1534: p_count => x_msg_count,
1535: p_data => x_msg_data,

Line 1536: p_encoded => FND_API.G_FALSE

1532: FND_MSG_PUB.Count_And_Get
1533: (
1534: p_count => x_msg_count,
1535: p_data => x_msg_data,
1536: p_encoded => FND_API.G_FALSE
1537: );
1538:
1539: --
1540: IF l_debug_on THEN

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

1537: );
1538:
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1538:
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1551: p_encoded => FND_API.G_FALSE

1547: FND_MSG_PUB.Count_And_Get
1548: (
1549: p_count => x_msg_count,
1550: p_data => x_msg_data,
1551: p_encoded => FND_API.G_FALSE
1552: );
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1558: --
1559: WHEN OTHERS THEN
1560: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1561: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1563: FND_MSG_PUB.Count_And_Get
1564: (
1565: p_count => x_msg_count,
1566: p_data => x_msg_data,

Line 1567: p_encoded => FND_API.G_FALSE

1563: FND_MSG_PUB.Count_And_Get
1564: (
1565: p_count => x_msg_count,
1566: p_data => x_msg_data,
1567: p_encoded => FND_API.G_FALSE
1568: );
1569: --
1570:
1571: IF l_debug_on THEN

Line 1676: RAISE FND_API.G_EXC_ERROR;

1672: --fnd_message.set_token('ID',p_entity_id_tab(l_index));
1673: IF l_debug_on THEN
1674: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1675: END IF;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: l_rec_attr_tab(l_index).status_code := l_status_code;
1679: l_rec_attr_tab(l_index).trip_id := l_trip_id;
1680: l_rec_attr_tab(l_index).planned_flag := l_planned_flag;

Line 1739: WHEN FND_API.G_EXC_ERROR THEN

1735: WSH_DEBUG_SV.pop(l_module_name);
1736: END IF;
1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1741: FND_MSG_PUB.Count_And_Get
1742: ( p_count => x_msg_count
1743: , p_data => x_msg_data

Line 1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1745: IF l_debug_on THEN
1746: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1747: WSH_DEBUG_SV.pop(l_module_name);
1748: END IF;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data

Line 1886: RAISE FND_API.G_EXC_ERROR;

1882: CLOSE c_attributes;
1883: IF l_debug_on THEN
1884: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1885: END IF;
1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;
1888: CLOSE c_attributes;
1889: l_index := p_entity_id_tab.NEXT(l_index);
1890: END LOOP;

Line 1930: WHEN FND_API.G_EXC_ERROR THEN

1926: WSH_DEBUG_SV.pop(l_module_name);
1927: END IF;
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1932: FND_MSG_PUB.Count_And_Get
1933: ( p_count => x_msg_count
1934: , p_data => x_msg_data

Line 1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1936: IF l_debug_on THEN
1937: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1938: WSH_DEBUG_SV.pop(l_module_name);
1939: END IF;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1942: FND_MSG_PUB.Count_And_Get
1943: ( p_count => x_msg_count
1944: , p_data => x_msg_data

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

2064: --========================================================================
2065: -- PROCEDURE : Create_Update_Stop Wrapper API
2066: --
2067: -- PARAMETERS: p_api_version_number known api versionerror buffer
2068: -- p_init_msg_list FND_API.G_TRUE to reset list
2069: -- p_commit 'T'/'F'
2070: -- p_in_rec stopInRecType
2071: -- p_rec_attr_tab Table of Attributes for the stop entity
2072: -- p_stop_OUT_tab Table of Output Attributes for the stop entity

Line 2165: WHEN FND_API.G_EXC_ERROR THEN

2161: WSH_DEBUG_SV.pop(l_module_name);
2162: END IF;
2163: --
2164: EXCEPTION
2165: WHEN FND_API.G_EXC_ERROR THEN
2166: ROLLBACK TO create_update_stop_wrap_grp;
2167: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2168: FND_MSG_PUB.Count_And_Get
2169: (

Line 2172: p_encoded => FND_API.G_FALSE

2168: FND_MSG_PUB.Count_And_Get
2169: (
2170: p_count => x_msg_count,
2171: p_data => x_msg_data,
2172: p_encoded => FND_API.G_FALSE
2173: );
2174: --
2175: IF l_debug_on THEN
2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2172: p_encoded => FND_API.G_FALSE
2173: );
2174: --
2175: IF l_debug_on THEN
2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2177: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2173: );
2174: --
2175: IF l_debug_on THEN
2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2177: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO create_update_stop_wrap_grp;

Line 2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2177: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO create_update_stop_wrap_grp;
2182: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2183: FND_MSG_PUB.Count_And_Get
2184: (

Line 2187: p_encoded => FND_API.G_FALSE

2183: FND_MSG_PUB.Count_And_Get
2184: (
2185: p_count => x_msg_count,
2186: p_data => x_msg_data,
2187: p_encoded => FND_API.G_FALSE
2188: );
2189: --
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2188: );
2189: --
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2201: p_encoded => FND_API.G_FALSE

2197: FND_MSG_PUB.Count_And_Get
2198: (
2199: p_count => x_msg_count,
2200: p_data => x_msg_data,
2201: p_encoded => FND_API.G_FALSE
2202: );
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2216: p_encoded => FND_API.G_FALSE

2212: FND_MSG_PUB.Count_And_Get
2213: (
2214: p_count => x_msg_count,
2215: p_data => x_msg_data,
2216: p_encoded => FND_API.G_FALSE
2217: );
2218: --
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2312: --========================================================================
2313: -- PROCEDURE : Create_Update_Trip Wrapper API
2314: --
2315: -- PARAMETERS: p_api_version_number known api versionerror buffer
2316: -- p_init_msg_list FND_API.G_TRUE to reset list
2317: -- x_return_status return status
2318: -- x_msg_count number of messages in the list
2319: -- x_msg_data text of messages
2320: -- p_trip_info_tab Table of Attributes for the trip entity

Line 2409: WHEN FND_API.G_EXC_ERROR THEN

2405: WSH_DEBUG_SV.pop(l_module_name);
2406: END IF;
2407: --
2408: EXCEPTION
2409: WHEN FND_API.G_EXC_ERROR THEN
2410: ROLLBACK TO create_update_trip_wrap_grp;
2411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2412: FND_MSG_PUB.Count_And_Get
2413: (

Line 2416: p_encoded => FND_API.G_FALSE

2412: FND_MSG_PUB.Count_And_Get
2413: (
2414: p_count => x_msg_count,
2415: p_data => x_msg_data,
2416: p_encoded => FND_API.G_FALSE
2417: );
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2416: p_encoded => FND_API.G_FALSE
2417: );
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2417: );
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: ROLLBACK TO create_update_trip_wrap_grp;

Line 2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: ROLLBACK TO create_update_trip_wrap_grp;
2426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2427: FND_MSG_PUB.Count_And_Get
2428: (

Line 2431: p_encoded => FND_API.G_FALSE

2427: FND_MSG_PUB.Count_And_Get
2428: (
2429: p_count => x_msg_count,
2430: p_data => x_msg_data,
2431: p_encoded => FND_API.G_FALSE
2432: );
2433: --
2434: IF l_debug_on THEN
2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2432: );
2433: --
2434: IF l_debug_on THEN
2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2445: p_encoded => FND_API.G_FALSE

2441: FND_MSG_PUB.Count_And_Get
2442: (
2443: p_count => x_msg_count,
2444: p_data => x_msg_data,
2445: p_encoded => FND_API.G_FALSE
2446: );
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2460: p_encoded => FND_API.G_FALSE

2456: FND_MSG_PUB.Count_And_Get
2457: (
2458: p_count => x_msg_count,
2459: p_data => x_msg_data,
2460: p_encoded => FND_API.G_FALSE
2461: );
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2621: WHEN FND_API.G_EXC_ERROR THEN

2617: WSH_DEBUG_SV.pop(l_module_name);
2618: END IF;
2619: --
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_ERROR THEN
2622: ROLLBACK TO Create_Update_Freight_Costs_WG;
2623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2624: FND_MSG_PUB.Count_And_Get
2625: (

Line 2628: p_encoded => FND_API.G_FALSE

2624: FND_MSG_PUB.Count_And_Get
2625: (
2626: p_count => x_msg_count,
2627: p_data => x_msg_data,
2628: p_encoded => FND_API.G_FALSE
2629: );
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2628: p_encoded => FND_API.G_FALSE
2629: );
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2629: );
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: ROLLBACK TO Create_Update_Freight_Costs_WG;

Line 2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: ROLLBACK TO Create_Update_Freight_Costs_WG;
2638: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2639: FND_MSG_PUB.Count_And_Get
2640: (

Line 2643: p_encoded => FND_API.G_FALSE

2639: FND_MSG_PUB.Count_And_Get
2640: (
2641: p_count => x_msg_count,
2642: p_data => x_msg_data,
2643: p_encoded => FND_API.G_FALSE
2644: );
2645: --
2646: IF l_debug_on THEN
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2644: );
2645: --
2646: IF l_debug_on THEN
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2657: p_encoded => FND_API.G_FALSE

2653: FND_MSG_PUB.Count_And_Get
2654: (
2655: p_count => x_msg_count,
2656: p_data => x_msg_data,
2657: p_encoded => FND_API.G_FALSE
2658: );
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2672: p_encoded => FND_API.G_FALSE

2668: FND_MSG_PUB.Count_And_Get
2669: (
2670: p_count => x_msg_count,
2671: p_data => x_msg_data,
2672: p_encoded => FND_API.G_FALSE
2673: );
2674: --
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2683: --========================================================================
2684: -- PROCEDURE : Update_Delivery_Leg Wrapper API PUBLIC
2685: --
2686: -- PARAMETERS: p_api_version_number known api version error buffer
2687: -- p_init_msg_list FND_API.G_TRUE to reset list
2688: -- x_return_status return status
2689: -- x_msg_count number of messages in the list
2690: -- x_msg_data text of messages
2691: -- p_in_rec Record for caller, phase

Line 2700: -- fnd_api.g_miss_(num/char/date) value for that field. If a field

2696: -- initial version 1.0
2697: -- COMMENT : Updates a record in wsh_delivery_legs table with information
2698: -- specified in p_delivery_leg_tab. Please note that as per perfomance
2699: -- standards, if you need to update a field to null, then use the
2700: -- fnd_api.g_miss_(num/char/date) value for that field. If a field
2701: -- has a null value, it will not be updated.
2702:
2703: PROCEDURE Update_Delivery_Leg(
2704: p_api_version_number IN NUMBER,