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 438: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 523: IF FND_API.To_Boolean( p_commit ) THEN

519: IF l_num_warnings > 0 THEN
520: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
521: END IF;
522: --
523: IF FND_API.To_Boolean( p_commit ) THEN
524: COMMIT WORK;
525: END IF;
526: --
527: FND_MSG_PUB.Count_And_Get (

Line 536: WHEN FND_API.G_EXC_ERROR THEN

532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534: --
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: (

Line 543: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 558: p_encoded => FND_API.G_FALSE

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

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

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

Line 572: p_encoded => FND_API.G_FALSE

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

Line 588: p_encoded => FND_API.G_FALSE

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

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

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

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

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

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

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

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

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

Line 816: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 855: IF FND_API.To_Boolean( p_commit ) THEN

851: IF l_num_warnings > 0 THEN
852: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
853: END IF;
854: --
855: IF FND_API.To_Boolean( p_commit ) THEN
856: COMMIT WORK;
857: END IF;
858: --
859: FND_MSG_PUB.Count_And_Get (

Line 868: WHEN FND_API.G_EXC_ERROR THEN

864: WSH_DEBUG_SV.pop(l_module_name);
865: END IF;
866: --
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
870: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get
872: (

Line 875: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 890: p_encoded => FND_API.G_FALSE

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

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

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

Line 904: p_encoded => FND_API.G_FALSE

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

Line 920: p_encoded => FND_API.G_FALSE

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

Line 1040: IF FND_API.to_Boolean( p_init_msg_list )

1036: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1037: END IF;
1038: --
1039:
1040: IF FND_API.to_Boolean( p_init_msg_list )
1041: THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: --

Line 1056: RAISE FND_API.G_EXC_ERROR;

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

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: IF l_debug_on THEN
1090: wsh_debug_sv.log (l_module_name,'Invalid Delivery Detail');
1091: END IF;
1092: CLOSE det_cur;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: CLOSE det_cur;
1097:

Line 1117: p_init_msg_list => FND_API.G_FALSE,

1113: END IF;
1114:
1115: wsh_delivery_details_grp.Delivery_Detail_Action(
1116: p_api_version_number => p_api_version_number,
1117: p_init_msg_list => FND_API.G_FALSE,
1118: p_commit => FND_API.G_FALSE,
1119: x_return_status => l_return_status,
1120: x_msg_count => l_msg_count,
1121: x_msg_data => l_msg_data,

Line 1118: p_commit => FND_API.G_FALSE,

1114:
1115: wsh_delivery_details_grp.Delivery_Detail_Action(
1116: p_api_version_number => p_api_version_number,
1117: p_init_msg_list => FND_API.G_FALSE,
1118: p_commit => FND_API.G_FALSE,
1119: x_return_status => l_return_status,
1120: x_msg_count => l_msg_count,
1121: x_msg_data => l_msg_data,
1122: p_rec_attr_tab => l_rec_attr_tab,

Line 1146: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1164: WHEN FND_API.G_EXC_ERROR THEN

1160: WSH_DEBUG_SV.pop(l_module_name);
1161: END IF;
1162: --
1163: EXCEPTION
1164: WHEN FND_API.G_EXC_ERROR THEN
1165: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1166: x_return_status := FND_API.G_RET_STS_ERROR ;
1167: FND_MSG_PUB.Count_And_Get
1168: (

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR ;

1162: --
1163: EXCEPTION
1164: WHEN FND_API.G_EXC_ERROR THEN
1165: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1166: x_return_status := FND_API.G_RET_STS_ERROR ;
1167: FND_MSG_PUB.Count_And_Get
1168: (
1169: p_count => x_msg_count,
1170: p_data => x_msg_data,

Line 1171: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1177: END IF;
1178: --
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182: FND_MSG_PUB.Count_And_Get
1183: (
1184: p_count => x_msg_count,
1185: p_data => x_msg_data,

Line 1186: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 1200: p_encoded => FND_API.G_FALSE

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

Line 1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1216: p_encoded => FND_API.G_FALSE

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

Line 1437: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1473: p_init_msg_list => FND_API.G_FALSE,

1469: END LOOP;
1470:
1471: wsh_delivery_details_grp.Create_Update_Delivery_Detail(
1472: p_api_version_number => p_api_version_number,
1473: p_init_msg_list => FND_API.G_FALSE,
1474: p_commit => FND_API.G_FALSE,
1475: x_return_status => l_return_status,
1476: x_msg_count => l_msg_count,
1477: x_msg_data => l_msg_data,

Line 1474: p_commit => FND_API.G_FALSE,

1470:
1471: wsh_delivery_details_grp.Create_Update_Delivery_Detail(
1472: p_api_version_number => p_api_version_number,
1473: p_init_msg_list => FND_API.G_FALSE,
1474: p_commit => FND_API.G_FALSE,
1475: x_return_status => l_return_status,
1476: x_msg_count => l_msg_count,
1477: x_msg_data => l_msg_data,
1478: p_detail_info_tab => l_detail_info_tab,

Line 1500: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1518: WHEN FND_API.G_EXC_ERROR THEN

1514: WSH_DEBUG_SV.pop(l_module_name);
1515: END IF;
1516: --
1517: EXCEPTION
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: FND_MSG_PUB.Count_And_Get
1522: (

Line 1520: x_return_status := FND_API.G_RET_STS_ERROR ;

1516: --
1517: EXCEPTION
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: FND_MSG_PUB.Count_And_Get
1522: (
1523: p_count => x_msg_count,
1524: p_data => x_msg_data,

Line 1525: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1531: END IF;
1532: --
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1536: FND_MSG_PUB.Count_And_Get
1537: (
1538: p_count => x_msg_count,
1539: p_data => x_msg_data,

Line 1540: p_encoded => FND_API.G_FALSE

1536: FND_MSG_PUB.Count_And_Get
1537: (
1538: p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => FND_API.G_FALSE
1541: );
1542:
1543: --
1544: IF l_debug_on THEN

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

1541: );
1542:
1543: --
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1547: END IF;
1548: --
1549: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

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

Line 1555: p_encoded => FND_API.G_FALSE

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

Line 1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1571: p_encoded => FND_API.G_FALSE

1567: FND_MSG_PUB.Count_And_Get
1568: (
1569: p_count => x_msg_count,
1570: p_data => x_msg_data,
1571: p_encoded => FND_API.G_FALSE
1572: );
1573: --
1574:
1575: IF l_debug_on THEN

Line 1680: RAISE FND_API.G_EXC_ERROR;

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

Line 1743: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1890: RAISE FND_API.G_EXC_ERROR;

1886: CLOSE c_attributes;
1887: IF l_debug_on THEN
1888: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1889: END IF;
1890: RAISE FND_API.G_EXC_ERROR;
1891: END IF;
1892: CLOSE c_attributes;
1893: l_index := p_entity_id_tab.NEXT(l_index);
1894: END LOOP;

Line 1934: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 2169: WHEN FND_API.G_EXC_ERROR THEN

2165: WSH_DEBUG_SV.pop(l_module_name);
2166: END IF;
2167: --
2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN
2170: ROLLBACK TO create_update_stop_wrap_grp;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: FND_MSG_PUB.Count_And_Get
2173: (

Line 2176: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2191: p_encoded => FND_API.G_FALSE

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

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

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

Line 2205: p_encoded => FND_API.G_FALSE

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

Line 2220: p_encoded => FND_API.G_FALSE

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

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

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

Line 2413: WHEN FND_API.G_EXC_ERROR THEN

2409: WSH_DEBUG_SV.pop(l_module_name);
2410: END IF;
2411: --
2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO create_update_trip_wrap_grp;
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2416: FND_MSG_PUB.Count_And_Get
2417: (

Line 2420: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2435: p_encoded => FND_API.G_FALSE

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

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

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

Line 2449: p_encoded => FND_API.G_FALSE

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

Line 2464: p_encoded => FND_API.G_FALSE

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

Line 2625: WHEN FND_API.G_EXC_ERROR THEN

2621: WSH_DEBUG_SV.pop(l_module_name);
2622: END IF;
2623: --
2624: EXCEPTION
2625: WHEN FND_API.G_EXC_ERROR THEN
2626: ROLLBACK TO Create_Update_Freight_Costs_WG;
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2628: FND_MSG_PUB.Count_And_Get
2629: (

Line 2632: p_encoded => FND_API.G_FALSE

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

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

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

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

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

Line 2640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2647: p_encoded => FND_API.G_FALSE

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

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

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

Line 2661: p_encoded => FND_API.G_FALSE

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

Line 2676: p_encoded => FND_API.G_FALSE

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

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

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

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

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