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

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: END IF;
91: --
92: EXCEPTION
93: --{
94: WHEN FND_API.G_EXC_ERROR THEN
95: ROLLBACK TO REVERT_TRIPS_GRP;
96: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
97: --
98: -- Debug Statements

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

97: --
98: -- Debug Statements
99: --
100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
102: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
103: END IF;
104: --
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

98: -- Debug Statements
99: --
100: IF l_debug_on THEN
101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
102: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
103: END IF;
104: --
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO REVERT_TRIPS_GRP;

Line 105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

101: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
102: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
103: END IF;
104: --
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: ROLLBACK TO REVERT_TRIPS_GRP;
107: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
108: --
109: -- Debug Statements

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

108: --
109: -- Debug Statements
110: --
111: IF l_debug_on THEN
112: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
114: END IF;
115: --
116: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

109: -- Debug Statements
110: --
111: IF l_debug_on THEN
112: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
113: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
114: END IF;
115: --
116: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
117: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 337: RAISE FND_API.G_EXC_ERROR;

333: --}
334: END IF;
335:
336: IF l_num_errors > 0 THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF l_num_warnings > 0 THEN
339: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
340: ELSE
341: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 353: WHEN FND_API.G_EXC_ERROR THEN

349: END IF;
350: --
351: EXCEPTION
352: --{
353: WHEN FND_API.G_EXC_ERROR THEN
354: ROLLBACK TO REVERT_DELIVERIES_GRP;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: --
357: -- Debug Statements

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

356: --
357: -- Debug Statements
358: --
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363: --
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

357: -- Debug Statements
358: --
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363: --
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO REVERT_DELIVERIES_GRP;

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

360: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
362: END IF;
363: --
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO REVERT_DELIVERIES_GRP;
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
367: --
368: -- Debug Statements

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

367: --
368: -- Debug Statements
369: --
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
373: END IF;
374: --
375: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

368: -- Debug Statements
369: --
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
373: END IF;
374: --
375: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
376: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 710: RAISE FND_API.G_EXC_ERROR;

706: --{
707: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DETAILS_PURGED');
708: x_return_status := wsh_util_core.g_ret_sts_error;
709: wsh_util_core.add_message(x_return_status, l_module_name);
710: RAISE FND_API.G_EXC_ERROR;
711: --}
712: END IF;
713: l_sum_returned_quantity := 0;
714: l_sum_returned_quantity2 := 0;

Line 743: RAISE FND_API.G_EXC_ERROR;

739: --{
740: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INSUFF_LINES_REVERT');
741: x_return_status := wsh_util_core.g_ret_sts_error;
742: wsh_util_core.add_message(x_return_status, l_module_name);
743: RAISE FND_API.G_EXC_ERROR;
744: --}
745: ELSIF l_sum_req_qty = l_sum_returned_quantity THEN
746: --{
747: -- This cursor is for locking all the delivery details for

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: p_action => 'GET',
1099: x_return_status => l_return_status);
1100:
1101: IF l_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.g_ret_sts_unexp_error) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: IF (l_return_status = wsh_util_core.g_ret_sts_warning) THEN
1106: --{

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: --}
1145: END LOOP;
1146: --
1147: IF l_num_errors > 0 THEN
1148: RAISE FND_API.G_EXC_ERROR;
1149: ELSIF l_num_warnings > 0 THEN
1150: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1151: ELSE
1152: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1162: p_encoded => FND_API.G_FALSE

1158: FND_MSG_PUB.Count_And_Get
1159: (
1160: p_count => x_msg_count,
1161: p_data => x_msg_data,
1162: p_encoded => FND_API.G_FALSE
1163: );
1164: --
1165: --}
1166: --

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

1185: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1186: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DD_LOCKED');
1187: END IF;
1188: --
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: ROLLBACK TO REVERT_DETAILS_GRP;
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1192: --
1193: FND_MSG_PUB.Count_And_Get

Line 1197: p_encoded => FND_API.G_FALSE

1193: FND_MSG_PUB.Count_And_Get
1194: (
1195: p_count => x_msg_count,
1196: p_data => x_msg_data,
1197: p_encoded => FND_API.G_FALSE
1198: );
1199: --
1200: --
1201: -- Debug Statements

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

1200: --
1201: -- Debug Statements
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1206: END IF;
1207: --
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1201: -- Debug Statements
1202: --
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1206: END IF;
1207: --
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO REVERT_DETAILS_GRP;

Line 1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1204: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1205: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1206: END IF;
1207: --
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO REVERT_DETAILS_GRP;
1210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1211: --
1212: FND_MSG_PUB.Count_And_Get

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: --
1220: -- Debug Statements

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

1219: --
1220: -- Debug Statements
1221: --
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1225: END IF;
1226: --
1227: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1220: -- Debug Statements
1221: --
1222: IF l_debug_on THEN
1223: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1225: END IF;
1226: --
1227: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1228: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1234: p_encoded => FND_API.G_FALSE

1230: FND_MSG_PUB.Count_And_Get
1231: (
1232: p_count => x_msg_count,
1233: p_data => x_msg_data,
1234: p_encoded => FND_API.G_FALSE
1235: );
1236: --
1237: --
1238: -- Debug Statements

Line 1254: p_encoded => FND_API.G_FALSE

1250: FND_MSG_PUB.Count_And_Get
1251: (
1252: p_count => x_msg_count,
1253: p_data => x_msg_data,
1254: p_encoded => FND_API.G_FALSE
1255: );
1256: --
1257: --}
1258: --

Line 1493: WHEN FND_API.G_EXC_ERROR THEN

1489: END IF;
1490: --
1491: EXCEPTION
1492: --{
1493: WHEN FND_API.G_EXC_ERROR THEN
1494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1495: --
1496: -- Debug Statements
1497: --

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

1495: --
1496: -- Debug Statements
1497: --
1498: IF l_debug_on THEN
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1501: END IF;
1502: --
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1496: -- Debug Statements
1497: --
1498: IF l_debug_on THEN
1499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1501: END IF;
1502: --
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1499: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1500: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1501: END IF;
1502: --
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1505: --
1506: -- Debug Statements
1507: --

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

1505: --
1506: -- Debug Statements
1507: --
1508: IF l_debug_on THEN
1509: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1511: END IF;
1512: --
1513: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

1506: -- Debug Statements
1507: --
1508: IF l_debug_on THEN
1509: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1511: END IF;
1512: --
1513: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1514: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1538: -- PROCEDURE : Get_Shipment_Lines This procedure is called only from
1539: -- the Inbound Reconciliation UI
1540: --
1541: -- PARAMETERS: p_api_version known api version error number
1542: -- p_init_msg_list FND_API.G_TRUE to reset list
1543: -- p_shipment_header_id Shipment Header Id of the transaction
1544: -- p_transaction_type transaction type (ASN or RECEIPT)
1545: -- p_view_only_flag Used to decide wether to query all
1546: -- rcv shipment lines or only the ones

Line 1874: IF FND_API.to_Boolean(p_init_msg_list) THEN

1870: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
1871: --WSH_DEBUG_SV.log(l_module_name,'P_MAX_RCV_TXN_ID',P_MAX_RCV_TXN_ID);
1872: END IF;
1873: --
1874: IF FND_API.to_Boolean(p_init_msg_list) THEN
1875: FND_MSG_PUB.initialize;
1876: END IF;
1877: --
1878: IF NOT FND_API.Compatible_API_Call

Line 1878: IF NOT FND_API.Compatible_API_Call

1874: IF FND_API.to_Boolean(p_init_msg_list) THEN
1875: FND_MSG_PUB.initialize;
1876: END IF;
1877: --
1878: IF NOT FND_API.Compatible_API_Call
1879: ( l_api_version_number,
1880: p_api_version_number,
1881: l_api_name,
1882: l_pkg_name

Line 1885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1881: l_api_name,
1882: l_pkg_name
1883: )
1884: THEN
1885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1886: END IF;
1887: --
1888: -- setting the return status
1889: x_return_status := wsh_util_core.g_ret_sts_success;

Line 1904: RAISE FND_API.G_EXC_ERROR;

1900: IF (NOT l_lock_obtained) THEN
1901: --{
1902: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
1903: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1904: RAISE FND_API.G_EXC_ERROR;
1905: --}
1906: END IF;
1907:
1908: --

Line 2371: RAISE FND_API.G_EXC_ERROR;

2367: IF x_shpmt_lines_out_rec.shipment_line_id_tab.count = 0 THEN
2368: FND_MESSAGE.SET_NAME('WSH','NO_DATA_FOUND');
2369: x_return_status := wsh_util_core.g_ret_sts_error;
2370: wsh_util_core.add_message(x_return_status, l_module_name);
2371: RAISE FND_API.G_EXC_ERROR;
2372: END IF;
2373: --
2374: FND_MSG_PUB.Count_And_Get
2375: (

Line 2378: p_encoded => FND_API.G_FALSE

2374: FND_MSG_PUB.Count_And_Get
2375: (
2376: p_count => x_msg_count,
2377: p_data => x_msg_data,
2378: p_encoded => FND_API.G_FALSE
2379: );
2380: --IF (x_msg_count IS NULL ) THEN
2381: -- x_msg_count := 0;
2382: -- END IF;

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

2406: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_LOCK_ERROR');
2407: wsh_util_core.add_message(x_return_status,l_module_name);
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2411: END IF;
2412: --
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2413: WHEN FND_API.G_EXC_ERROR THEN

2409: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2411: END IF;
2412: --
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2415: --
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: --
2424: -- Debug Statements

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

2423: --
2424: -- Debug Statements
2425: --
2426: IF l_debug_on THEN
2427: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2428: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2429: END IF;
2430: --
2431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 2431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2438: p_encoded => FND_API.G_FALSE

2434: FND_MSG_PUB.Count_And_Get
2435: (
2436: p_count => x_msg_count,
2437: p_data => x_msg_data,
2438: p_encoded => FND_API.G_FALSE
2439: );
2440: --
2441: --
2442: -- Debug Statements

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

2441: --
2442: -- Debug Statements
2443: --
2444: IF l_debug_on THEN
2445: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2446: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2447: END IF;
2448: --
2449: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

2442: -- Debug Statements
2443: --
2444: IF l_debug_on THEN
2445: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2446: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2447: END IF;
2448: --
2449: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2450: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2456: p_encoded => FND_API.G_FALSE

2452: FND_MSG_PUB.Count_And_Get
2453: (
2454: p_count => x_msg_count,
2455: p_data => x_msg_data,
2456: p_encoded => FND_API.G_FALSE
2457: );
2458: --
2459: --
2460: -- Debug Statements

Line 2475: p_encoded => FND_API.G_FALSE

2471: FND_MSG_PUB.Count_And_Get
2472: (
2473: p_count => x_msg_count,
2474: p_data => x_msg_data,
2475: p_encoded => FND_API.G_FALSE
2476: );
2477: --
2478: --}
2479: --

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

2491: -- the Inbound Reconciliation UI to
2492: -- revert a matched ASN or a Receipt
2493: --
2494: -- PARAMETERS: p_api_version known api version error number
2495: -- p_init_msg_list FND_API.G_TRUE to reset list
2496: -- p_shipment_header_id Shipment Header Id of the transaction
2497: -- p_transaction_type transaction type (ASN or RECEIPT)
2498: -- p_object_version_number current object version of the
2499: -- transaction record in

Line 2623: IF FND_API.to_Boolean(p_init_msg_list) THEN

2619: WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_TYPE',P_TRANSACTION_TYPE);
2620: WSH_DEBUG_SV.log(l_module_name,'P_OBJECT_VERSION_NUMBER',P_OBJECT_VERSION_NUMBER);
2621: END IF;
2622: --
2623: IF FND_API.to_Boolean(p_init_msg_list) THEN
2624: FND_MSG_PUB.initialize;
2625: END IF;
2626: --
2627: SAVEPOINT revert_matching_grp;

Line 2630: IF NOT FND_API.Compatible_API_Call

2626: --
2627: SAVEPOINT revert_matching_grp;
2628: x_return_status := wsh_util_core.g_ret_sts_success;
2629: --
2630: IF NOT FND_API.Compatible_API_Call
2631: ( l_api_version_number,
2632: p_api_version_number,
2633: l_api_name,
2634: l_pkg_name

Line 2637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2633: l_api_name,
2634: l_pkg_name
2635: )
2636: THEN
2637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2638: END IF;
2639: IF l_debug_on THEN
2640: WSH_DEBUG_SV.logmsg(l_module_name,'After checking Compatible_API_Call');
2641: END IF;

Line 2665: RAISE FND_API.G_EXC_ERROR;

2661: FND_MESSAGE.SET_NAME('WSH','WSH_IB_RECEIPT_MATCHED_ERR');
2662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receipt_num);
2663: x_return_status := wsh_util_core.g_ret_sts_error;
2664: wsh_util_core.add_message(x_return_status, l_module_name);
2665: RAISE FND_API.G_EXC_ERROR;
2666: --}
2667: ELSE
2668: --{
2669: l_cancel_asn_action_prms.action_code := 'REVERT_ASN';

Line 2876: RAISE FND_API.G_EXC_ERROR;

2872: END IF;
2873: --
2874:
2875: IF l_num_errors > 0 THEN
2876: RAISE FND_API.G_EXC_ERROR;
2877: ELSIF l_num_warnings > 0 THEN
2878: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2879: ELSE
2880: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2884: IF FND_API.To_Boolean( p_commit ) THEN

2880: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2881: END IF;
2882:
2883: -- Standard check of p_commit.
2884: IF FND_API.To_Boolean( p_commit ) THEN
2885:
2886: --bug 4070732
2887: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2888: --{

Line 2904: RAISE FND_API.G_EXC_ERROR;

2900: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2901: END IF;
2902:
2903: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2904: RAISE FND_API.G_EXC_ERROR;
2905: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2907: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2908: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 2906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2902:
2903: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2904: RAISE FND_API.G_EXC_ERROR;
2905: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2907: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2908: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2909: END IF;
2910:

Line 2924: IF FND_API.To_Boolean( p_commit ) THEN

2920: --{
2921: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2922: --{
2923:
2924: IF FND_API.To_Boolean( p_commit ) THEN
2925:
2926: IF l_debug_on THEN
2927: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2928: END IF;

Line 2956: IF NOT FND_API.To_Boolean( p_commit ) THEN

2952: END IF;
2953:
2954: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
2955: WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
2956: IF NOT FND_API.To_Boolean( p_commit ) THEN
2957: ROLLBACK TO REVERT_MATCHING_GRP;
2958: END IF;
2959: END IF;
2960:

Line 2972: p_encoded => FND_API.G_FALSE

2968: FND_MSG_PUB.Count_And_Get
2969: (
2970: p_count => x_msg_count,
2971: p_data => x_msg_data,
2972: p_encoded => FND_API.G_FALSE
2973: );
2974: --
2975:
2976: --}

Line 2986: WHEN FND_API.G_EXC_ERROR THEN

2982: END IF;
2983: --
2984: EXCEPTION
2985: --{
2986: WHEN FND_API.G_EXC_ERROR THEN
2987: ROLLBACK TO REVERT_MATCHING_GRP;
2988: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2989: --
2990: --

Line 3024: p_encoded => FND_API.G_FALSE

3020: FND_MSG_PUB.Count_And_Get
3021: (
3022: p_count => x_msg_count,
3023: p_data => x_msg_data,
3024: p_encoded => FND_API.G_FALSE
3025: );
3026: --
3027: --
3028: -- Debug Statements

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

3027: --
3028: -- Debug Statements
3029: --
3030: IF l_debug_on THEN
3031: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3032: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
3033: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
3034:
3035: FND_MESSAGE.SET_NAME('WSH','WSH_DEBUG_FILE_NAME');

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

3035: FND_MESSAGE.SET_NAME('WSH','WSH_DEBUG_FILE_NAME');
3036: FND_MESSAGE.SET_TOKEN('DEBUG_FILE_NAME',l_debugfile);
3037: wsh_util_core.add_message(x_return_status, l_module_name);
3038:
3039: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3040: END IF;
3041: --
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: ROLLBACK TO REVERT_MATCHING_GRP;

Line 3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3038:
3039: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3040: END IF;
3041: --
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: ROLLBACK TO REVERT_MATCHING_GRP;
3044: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3045: --
3046:

Line 3080: p_encoded => FND_API.G_FALSE

3076: FND_MSG_PUB.Count_And_Get
3077: (
3078: p_count => x_msg_count,
3079: p_data => x_msg_data,
3080: p_encoded => FND_API.G_FALSE
3081: );
3082: --
3083: -- Debug Statements
3084: --

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

3082: --
3083: -- Debug Statements
3084: --
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3087: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
3088: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
3089:
3090: FND_MESSAGE.SET_NAME('WSH','WSH_DEBUG_FILE_NAME');

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

3090: FND_MESSAGE.SET_NAME('WSH','WSH_DEBUG_FILE_NAME');
3091: FND_MESSAGE.SET_TOKEN('DEBUG_FILE_NAME',l_debugfile);
3092: wsh_util_core.add_message(x_return_status, l_module_name);
3093:
3094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3095: END IF;
3096: --
3097: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3098: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3140: p_encoded => FND_API.G_FALSE

3136: FND_MSG_PUB.Count_And_Get
3137: (
3138: p_count => x_msg_count,
3139: p_data => x_msg_data,
3140: p_encoded => FND_API.G_FALSE
3141: );
3142: --
3143: -- Debug Statements
3144: --

Line 3191: p_encoded => FND_API.G_FALSE

3187: FND_MSG_PUB.Count_And_Get
3188: (
3189: p_count => x_msg_count,
3190: p_data => x_msg_data,
3191: p_encoded => FND_API.G_FALSE
3192: );
3193: --
3194: -- Debug Statements
3195: --

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

3216: -- match a pending ASN or a pending
3217: -- Receipt or partially matched Receipt.
3218: --
3219: -- PARAMETERS: p_api_version known api version error number
3220: -- p_init_msg_list FND_API.G_TRUE to reset list
3221: -- p_shipment_header_id Shipment Header Id of the transaction
3222: -- p_transaction_type transaction type (ASN or RECEIPT)
3223: -- p_max_rcv_txn_id Not used any more.
3224: -- p_process_asn_rcv_flag Flag to decide whether to call

Line 3409: IF FND_API.to_Boolean(p_init_msg_list) THEN

3405: WSH_DEBUG_SV.log(l_module_name,'p_max_txn_id_tab.count',p_max_txn_id_tab.count);
3406: WSH_DEBUG_SV.log(l_module_name,'p_shipment_line_id_tab.count',p_shipment_line_id_tab.count);
3407: END IF;
3408: --
3409: IF FND_API.to_Boolean(p_init_msg_list) THEN
3410: FND_MSG_PUB.initialize;
3411: END IF;
3412: --
3413: SAVEPOINT MATCH_SHIPMENTS_GRP;

Line 3415: IF NOT FND_API.Compatible_API_Call

3411: END IF;
3412: --
3413: SAVEPOINT MATCH_SHIPMENTS_GRP;
3414: --
3415: IF NOT FND_API.Compatible_API_Call
3416: ( l_api_version_number,
3417: p_api_version_number,
3418: l_api_name,
3419: l_pkg_name

Line 3422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3418: l_api_name,
3419: l_pkg_name
3420: )
3421: THEN
3422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3423: END IF;
3424: --
3425: -- { IB-Phase-2
3426: -- For manual matching of Receipts, rating of Trips has to be done asynchronously.

Line 3723: IF FND_API.To_Boolean( p_commit ) THEN

3719: ELSE
3720: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3721: END IF;
3722: -- Standard check of p_commit.
3723: IF FND_API.To_Boolean( p_commit ) THEN
3724:
3725: --bug 4070732
3726: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3727: --{

Line 3743: RAISE FND_API.G_EXC_ERROR;

3739: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3740: END IF;
3741:
3742: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3743: RAISE FND_API.G_EXC_ERROR;
3744: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3747: RAISE WSH_UTIL_CORE.G_EXC_WARNING;

Line 3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3741:
3742: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3743: RAISE FND_API.G_EXC_ERROR;
3744: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3747: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
3748: END IF;
3749:

Line 3763: IF FND_API.To_Boolean( p_commit ) THEN

3759: --{
3760: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3761: --{
3762:
3763: IF FND_API.To_Boolean( p_commit ) THEN
3764:
3765: IF l_debug_on THEN
3766: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3767: END IF;

Line 3797: IF NOT FND_API.To_Boolean( p_commit ) THEN

3793: END IF;
3794:
3795: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
3796: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3797: IF NOT FND_API.To_Boolean( p_commit ) THEN
3798: ROLLBACK TO MATCH_SHIPMENTS_GRP;
3799: END IF;
3800: END IF;
3801:

Line 3813: p_encoded => FND_API.G_FALSE

3809: FND_MSG_PUB.Count_And_Get
3810: (
3811: p_count => x_msg_count,
3812: p_data => x_msg_data,
3813: p_encoded => FND_API.G_FALSE
3814: );
3815: --
3816: --}
3817: --

Line 3826: WHEN FND_API.G_EXC_ERROR THEN

3822: END IF;
3823: --
3824: EXCEPTION
3825: --{
3826: WHEN FND_API.G_EXC_ERROR THEN
3827: ROLLBACK TO MATCH_SHIPMENTS_GRP;
3828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3829: --
3830: --

Line 3863: p_encoded => FND_API.G_FALSE

3859: FND_MSG_PUB.Count_And_Get
3860: (
3861: p_count => x_msg_count,
3862: p_data => x_msg_data,
3863: p_encoded => FND_API.G_FALSE
3864: );
3865: --
3866: -- Debug Statements
3867: --

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

3865: --
3866: -- Debug Statements
3867: --
3868: IF l_debug_on THEN
3869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3871: END IF;
3872: --
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3866: -- Debug Statements
3867: --
3868: IF l_debug_on THEN
3869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3871: END IF;
3872: --
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: ROLLBACK TO MATCH_SHIPMENTS_GRP;

Line 3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3871: END IF;
3872: --
3873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3874: ROLLBACK TO MATCH_SHIPMENTS_GRP;
3875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3876: --
3877: --

Line 3910: p_encoded => FND_API.G_FALSE

3906: FND_MSG_PUB.Count_And_Get
3907: (
3908: p_count => x_msg_count,
3909: p_data => x_msg_data,
3910: p_encoded => FND_API.G_FALSE
3911: );
3912: -- Debug Statements
3913: --
3914: IF l_debug_on THEN

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

3911: );
3912: -- Debug Statements
3913: --
3914: IF l_debug_on THEN
3915: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3916:
3917: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_debugfile);
3918: l_debugfile := l_debugfile||'/'||WSH_DEBUG_SV.g_file;
3919:

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

3920: FND_MESSAGE.SET_NAME('WSH','WSH_DEBUG_FILE_NAME');
3921: FND_MESSAGE.SET_TOKEN('DEBUG_FILE_NAME',l_debugfile);
3922: wsh_util_core.add_message(x_return_status, l_module_name);
3923:
3924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3925: END IF;
3926: --
3927: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3928: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3972: p_encoded => FND_API.G_FALSE

3968: FND_MSG_PUB.Count_And_Get
3969: (
3970: p_count => x_msg_count,
3971: p_data => x_msg_data,
3972: p_encoded => FND_API.G_FALSE
3973: );
3974: -- Debug Statements
3975: --
3976: IF l_debug_on THEN

Line 4020: p_encoded => FND_API.G_FALSE

4016: FND_MSG_PUB.Count_And_Get
4017: (
4018: p_count => x_msg_count,
4019: p_data => x_msg_data,
4020: p_encoded => FND_API.G_FALSE
4021: );
4022: --
4023: -- Debug Statements
4024: --