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_OTM_RIQ_XML dependencies on WSH_OTM_RIQ_XML

Line 1: PACKAGE BODY WSH_OTM_RIQ_XML as

1: PACKAGE BODY WSH_OTM_RIQ_XML as
2: /* $Header: WSHGLRXB.pls 120.5.12010000.3 2008/08/22 14:32:03 anvarshn ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_RIQ_XML';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_RIQ_XML';

1: PACKAGE BODY WSH_OTM_RIQ_XML as
2: /* $Header: WSHGLRXB.pls 120.5.12010000.3 2008/08/22 14:32:03 anvarshn ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_OTM_RIQ_XML';
6: --
7: --XPATH expressions
8: --Status Code
9: G_XPATH_SM_STATUS_PREFIX CONSTANT VARCHAR2(200):='/RemoteQueryReply/OrderRoutingRuleReply';

Line 331: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_OTM_RIQ_XML.DERIVE_RIQ_DATES',l_module_name);

327: CLOSE c_get_line_dates_csr;
328: END IF;
329:
330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
331: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_OTM_RIQ_XML.DERIVE_RIQ_DATES',l_module_name);
332:
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
335: WSH_DEBUG_SV.logmsg(l_module_name,

Line 423: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_CLOB',l_module_name);

419: END IF;
420:
421: WHEN others THEN
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
423: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_CLOB',l_module_name);
424:
425: IF l_debug_on THEN
426: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
427: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 551: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_line_tab',l_module_name);

547: END IF;
548:
549: WHEN others THEN
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
551: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_line_tab',l_module_name);
552:
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 661: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_header_tab',l_module_name);

657: END IF;
658:
659: WHEN others THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_source_header_tab',l_module_name);
662:
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 774: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);

770: END IF;
771:
772: WHEN others THEN
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
774: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
775:
776: IF l_debug_on THEN
777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
778: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 886: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);

882: END IF;
883:
884: WHEN others THEN
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
886: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.print_rates_tab',l_module_name);
887:
888: IF l_debug_on THEN
889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1063: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Carrier',l_module_name);

1059: END IF;
1060:
1061: WHEN others THEN
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1063: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Carrier',l_module_name);
1064:
1065: IF l_debug_on THEN
1066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1150: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Look_Up_NoCase',l_module_name);

1146: END IF;
1147:
1148: WHEN others THEN
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1150: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Look_Up_NoCase',l_module_name);
1151:
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1256: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_OTM_To_EBS_UOM',l_module_name);

1252: END IF;
1253:
1254: WHEN others THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1256: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_OTM_To_EBS_UOM',l_module_name);
1257:
1258: IF l_debug_on THEN
1259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1346: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM',l_module_name);

1342: END IF;
1343:
1344: WHEN others THEN
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1346: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM',l_module_name);
1347:
1348: IF l_debug_on THEN
1349: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1350: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1429: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Carrier_Info',l_module_name);

1425: END IF;
1426:
1427: WHEN others THEN
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1429: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Carrier_Info',l_module_name);
1430:
1431: IF l_debug_on THEN
1432: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1433: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1542: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Sort',l_module_name);

1538: END IF;
1539:
1540: WHEN others THEN
1541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1542: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Sort',l_module_name);
1543: --
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1643: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Transit_Time',l_module_name);

1639: END IF;
1640:
1641: WHEN others THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1643: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Validate_Transit_Time',l_module_name);
1644:
1645: IF l_debug_on THEN
1646: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1729: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Ship_Method_Code',l_module_name);

1725: END IF;
1726:
1727: WHEN others THEN
1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1729: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Ship_Method_Code',l_module_name);
1730:
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1911: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Location_Info',l_module_name);

1907: --
1908: EXCEPTION
1909: WHEN others THEN
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1911: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Get_Location_Info',l_module_name);
1912: --
1913: IF l_debug_on THEN
1914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1915: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2205: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Format_Line_Input_For_Xml',l_module_name);

2201: END IF;
2202:
2203: WHEN others THEN
2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2205: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Format_Line_Input_For_Xml',l_module_name);
2206:
2207: IF l_debug_on THEN
2208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2592: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.FORMAT_HEADER_INPUT_FOR_XML',l_module_name);

2588: END IF;
2589:
2590: WHEN others THEN
2591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2592: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.FORMAT_HEADER_INPUT_FOR_XML',l_module_name);
2593:
2594: IF l_debug_on THEN
2595: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2596: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3217: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Create_RIQ_XML',l_module_name);

3213: END IF;
3214:
3215: WHEN others THEN
3216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3217: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Create_RIQ_XML',l_module_name);
3218:
3219: IF l_debug_on THEN
3220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3283: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Fetch_XML_Match',l_module_name);

3279: END IF;
3280:
3281: WHEN others THEN
3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3283: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Fetch_XML_Match',l_module_name);
3284: --
3285: IF l_debug_on THEN
3286: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3287: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3450: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Check_Response_Status',l_module_name);

3446: END IF;
3447:
3448: WHEN others THEN
3449: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3450: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Check_Response_Status',l_module_name);
3451: --
3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3658: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Single_Cost',l_module_name);

3654: END IF;
3655:
3656: WHEN others THEN
3657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3658: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Single_Cost',l_module_name);
3659: --
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3890: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Rate',l_module_name);

3886: END IF;
3887:
3888: WHEN others THEN
3889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3890: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Rate',l_module_name);
3891: --
3892: IF l_debug_on THEN
3893: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3894: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4088: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Ship_Method',l_module_name);

4084: END IF;
4085:
4086: WHEN others THEN
4087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4088: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Extract_Ship_Method',l_module_name);
4089: --
4090: IF l_debug_on THEN
4091: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4092: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4266: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_SM_Result',l_module_name);

4262: END IF;
4263:
4264: WHEN others THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4266: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_SM_Result',l_module_name);
4267: --
4268: IF l_debug_on THEN
4269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4270: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4522: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Allocate_rates',l_module_name);

4518: END IF;
4519:
4520: WHEN others THEN
4521: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4522: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Allocate_rates',l_module_name);
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4676: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_FC_Result',l_module_name);

4672: END IF;
4673:
4674: WHEN others THEN
4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4676: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Get_FC_Result',l_module_name);
4677: --
4678: IF l_debug_on THEN
4679: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4680: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4858: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Choose_SM_Result',l_module_name);

4854: END IF;
4855:
4856: WHEN others THEN
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4858: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Populate_Choose_SM_Result',l_module_name);
4859: --
4860: IF l_debug_on THEN
4861: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5047: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_SM_Response',l_module_name);

5043: END IF;
5044:
5045: WHEN others THEN
5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5047: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_SM_Response',l_module_name);
5048: --
5049: IF l_debug_on THEN
5050: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5227: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_FC_Response',l_module_name);

5223: END IF;
5224:
5225: WHEN others THEN
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5227: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Get_FC_Response',l_module_name);
5228: -- in case the exception occured while working on
5229: -- cursor c_get_currency
5230: IF c_get_currency%ISOPEN THEN
5231: CLOSE c_get_currency;

Line 5559: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Choose_SM_Response',l_module_name);

5555: END IF;
5556:
5557: WHEN others THEN
5558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5559: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Handle_Choose_SM_Response',l_module_name);
5560: --
5561: IF l_debug_on THEN
5562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5748: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Parse_RIQ_Output_XML',l_module_name);

5744: END IF;
5745:
5746: WHEN others THEN
5747: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5748: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Parse_RIQ_Output_XML',l_module_name);
5749: --
5750: IF l_debug_on THEN
5751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5874: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Init_Globals',l_module_name);

5870: END IF;
5871:
5872: WHEN others THEN
5873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5874: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Init_Globals',l_module_name);
5875: --
5876: IF l_debug_on THEN
5877: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5878: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5937: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Clear_Globals',l_module_name);

5933: END IF;
5934:
5935: WHEN others THEN
5936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5937: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Clear_Globals',l_module_name);
5938: --
5939: IF l_debug_on THEN
5940: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5941: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6220: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Process_One_Header',l_module_name);

6216: END IF;
6217:
6218: WHEN others THEN
6219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6220: wsh_util_core.default_handler('WSH_OTM_RIQ_XML.Process_One_Header',l_module_name);
6221: --
6222: IF l_debug_on THEN
6223: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6648: --wsh_util_core.default_handler('WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM',l_module_name);

6644: p_count => x_msg_count,
6645: p_data => x_msg_data,
6646: p_encoded => FND_API.G_FALSE
6647: );
6648: --wsh_util_core.default_handler('WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM',l_module_name);
6649: --
6650: IF l_debug_on THEN
6651: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
6652: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);

Line 6661: END WSH_OTM_RIQ_XML;

6657: --
6658: END CALL_OTM_FOR_OM;
6659:
6660:
6661: END WSH_OTM_RIQ_XML;