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.WMS_CROSS_DOCK_PVT dependencies on FND_MSG_PUB

Line 252: -- fnd_msg_pub.initialize;

248: SAVEPOINT check_crossdock_sp;
249: l_progress := '10';
250:
251: -- Initialize message list to clear any existing messages
252: -- fnd_msg_pub.initialize;
253: l_progress := '20';
254:
255: -- Initialize API return status to success
256: x_return_status := fnd_api.g_ret_sts_success;

Line 456: FND_MSG_PUB.ADD;

452: END IF;
453:
454: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR' );
456: FND_MSG_PUB.ADD;
457: RAISE FND_API.g_exc_unexpected_error;
458:
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
460: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');

Line 461: FND_MSG_PUB.ADD;

457: RAISE FND_API.g_exc_unexpected_error;
458:
459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
460: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');
461: FND_MSG_PUB.ADD;
462: RAISE FND_API.g_exc_error;
463: END IF;
464:
465: l_progress := '110';

Line 506: FND_MSG_PUB.ADD;

502: END IF;
503:
504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
505: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR' );
506: FND_MSG_PUB.ADD;
507: RAISE FND_API.g_exc_unexpected_error;
508:
509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');

Line 511: FND_MSG_PUB.ADD;

507: RAISE FND_API.g_exc_unexpected_error;
508:
509: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');
511: FND_MSG_PUB.ADD;
512: RAISE FND_API.g_exc_error;
513: END IF;
514:
515: l_progress := '120';

Line 1114: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1110: END IF;
1111:
1112: ROLLBACK TO check_crossdock_sp;
1113: x_return_status := fnd_api.g_ret_sts_error;
1114: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1115: p_data => x_msg_data);
1116: IF (l_debug = 1) THEN
1117: mydebug('Exiting check_crossdock - Execution error: ' ||
1118: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 1141: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1137: END IF;
1138:
1139: ROLLBACK TO check_crossdock_sp;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1142: p_data => x_msg_data);
1143: IF (l_debug = 1) THEN
1144: mydebug('Exiting Opportunistic_Cross_Dock - Unexpected error: ' ||
1145: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1162: END IF;
1163:
1164: ROLLBACK TO check_crossdock_sp;
1165: x_return_status := fnd_api.g_ret_sts_unexp_error;
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1170: p_data => x_msg_data);

Line 1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1163:
1164: ROLLBACK TO check_crossdock_sp;
1165: x_return_status := fnd_api.g_ret_sts_unexp_error;
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1170: p_data => x_msg_data);
1171: IF (l_debug = 1) THEN

Line 1169: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1165: x_return_status := fnd_api.g_ret_sts_unexp_error;
1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1170: p_data => x_msg_data);
1171: IF (l_debug = 1) THEN
1172: mydebug('Exiting Opportunistic_Cross_Dock - Others exception: ' ||
1173: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 1441: FND_MSG_PUB.Add;

1437: mydebug('HdrID:'||l_mso_header_id);
1438: END IF;
1439: IF l_mso_header_id IS NULL THEN
1440: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
1441: FND_MSG_PUB.Add;
1442: RAISE fnd_api.g_exc_unexpected_error;
1443: END IF;
1444: IF (l_debug = 1) THEN
1445: mydebug('Get Dem src');

Line 1514: FND_MSG_PUB.Add;

1510: IF (l_debug = 1) THEN
1511: mydebug('Error in Query Reservation');
1512: END IF;
1513: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
1514: FND_MSG_PUB.Add;
1515: RAISE fnd_api.g_exc_unexpected_error;
1516: END IF;
1517:
1518:

Line 1576: FND_MSG_PUB.Add;

1572: IF (l_debug = 1) THEN
1573: mydebug('error in transfer reservation');
1574: END IF;
1575: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
1576: FND_MSG_PUB.Add;
1577: RAISE fnd_api.g_exc_unexpected_error;
1578: END IF;
1579:
1580: IF (l_primary_temp_qty <= 0) THEN

Line 1674: fnd_msg_pub.count_and_get

1670: );
1671:
1672:
1673:
1674: fnd_msg_pub.count_and_get
1675: ( p_count => l_msg_cnt
1676: , p_data => l_msg_data
1677: );
1678:

Line 1693: l_msg_data := fnd_msg_pub.get(I,'F');

1689: IF (l_debug = 1) THEN
1690: mydebug('Not Successful2');
1691: END IF;
1692: For I in 1..l_msg_cnt LOOP
1693: l_msg_data := fnd_msg_pub.get(I,'F');
1694: IF (l_debug = 1) THEN
1695: mydebug(replace(l_msg_data,chr(0),' '));
1696: END IF;
1697: END LOOP;

Line 1708: FND_MSG_PUB.Add;

1704: mydebug('error in create reservation');
1705: END IF;
1706: -- ROLLBACK TO Process_Line_PVT;
1707: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CR_RSV_ERROR');
1708: FND_MSG_PUB.Add;
1709: RAISE fnd_api.g_exc_unexpected_error;
1710: END IF;
1711: END IF;
1712:

Line 1736: FND_MSG_PUB.ADD;

1732:
1733:
1734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1735: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR' );
1736: FND_MSG_PUB.ADD;
1737: RAISE FND_API.g_exc_unexpected_error;
1738:
1739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1740: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');

Line 1741: FND_MSG_PUB.ADD;

1737: RAISE FND_API.g_exc_unexpected_error;
1738:
1739: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1740: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');
1741: FND_MSG_PUB.ADD;
1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: IF (l_debug = 1) THEN

Line 1836: FND_MSG_PUB.ADD;

1832: END IF;
1833:
1834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1835: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
1836: FND_MSG_PUB.ADD;
1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 1841: FND_MSG_PUB.ADD;

1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845:

Line 1898: FND_MSG_PUB.ADD;

1894: END IF;
1895:
1896: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1897: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.g_exc_unexpected_error;
1900:
1901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 1903: FND_MSG_PUB.ADD;

1899: RAISE FND_API.g_exc_unexpected_error;
1900:
1901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1902: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
1903: FND_MSG_PUB.ADD;
1904: RAISE FND_API.G_EXC_ERROR;
1905: END IF;
1906:
1907:

Line 1966: FND_MSG_PUB.ADD;

1962: END IF;
1963:
1964: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1965: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
1966: FND_MSG_PUB.ADD;
1967: RAISE FND_API.g_exc_unexpected_error;
1968:
1969: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1970: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 1971: FND_MSG_PUB.ADD;

1967: RAISE FND_API.g_exc_unexpected_error;
1968:
1969: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1970: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
1971: FND_MSG_PUB.ADD;
1972: RAISE FND_API.G_EXC_ERROR;
1973: END IF;
1974:
1975:

Line 2026: FND_MSG_PUB.ADD;

2022: END IF;
2023:
2024: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2025: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2026: FND_MSG_PUB.ADD;
2027: RAISE FND_API.g_exc_unexpected_error;
2028:
2029: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2030: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2031: FND_MSG_PUB.ADD;

2027: RAISE FND_API.g_exc_unexpected_error;
2028:
2029: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2030: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2031: FND_MSG_PUB.ADD;
2032: RAISE FND_API.G_EXC_ERROR;
2033: END IF;
2034:
2035:

Line 2074: fnd_msg_pub.count_and_get

2070: x_return_status => l_return_status
2071: );
2072:
2073:
2074: fnd_msg_pub.count_and_get
2075: ( p_count => l_msg_cnt
2076: , p_data => l_msg_data
2077: );
2078:

Line 2093: l_msg_data := fnd_msg_pub.get(I,'F');

2089: IF (l_debug = 1) THEN
2090: mydebug('Not Successful2');
2091: END IF;
2092: For I in 1..l_msg_cnt LOOP
2093: l_msg_data := fnd_msg_pub.get(I,'F');
2094: IF (l_debug = 1) THEN
2095: mydebug(replace(l_msg_data,chr(0),' '));
2096: END IF;
2097: END LOOP;

Line 2106: FND_MSG_PUB.ADD;

2102: END IF;
2103:
2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2106: FND_MSG_PUB.ADD;
2107: RAISE FND_API.g_exc_unexpected_error;
2108:
2109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2110: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2111: FND_MSG_PUB.ADD;

2107: RAISE FND_API.g_exc_unexpected_error;
2108:
2109: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2110: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: END IF;
2114:
2115: IF (l_debug = 1) THEN

Line 2134: FND_MSG_PUB.ADD;

2130: AND ROWNUM=1;
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN
2133: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_DEL_LPN_ERROR');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: END;
2137:
2138: IF (l_debug = 1) THEN

Line 2263: FND_MSG_PUB.ADD;

2259:
2260:
2261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2263: FND_MSG_PUB.ADD;
2264: RAISE FND_API.g_exc_unexpected_error;
2265:
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');

Line 2268: FND_MSG_PUB.ADD;

2264: RAISE FND_API.g_exc_unexpected_error;
2265:
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2268: FND_MSG_PUB.ADD;
2269: l_return_status :=FND_API.g_ret_sts_success;
2270: END IF;
2271:
2272: x_return_status:=l_return_status;

Line 2285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2281: EXCEPTION
2282: WHEN FND_API.G_EXC_ERROR THEN
2283: x_return_status := FND_API.G_RET_STS_ERROR;
2284: -- Get message count and data
2285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2286:
2287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289: -- Get message count and data

Line 2290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2286:
2287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289: -- Get message count and data
2290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2291:
2292: WHEN OTHERS THEN
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2294: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );

Line 2295: FND_MSG_PUB.ADD;

2291:
2292: WHEN OTHERS THEN
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2294: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );
2295: FND_MSG_PUB.ADD;
2296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2297:
2298:
2299: END complete_crossdock;

Line 2296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2292: WHEN OTHERS THEN
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2294: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );
2295: FND_MSG_PUB.ADD;
2296: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2297:
2298:
2299: END complete_crossdock;
2300:

Line 2343: FND_MSG_PUB.ADD;

2339: END IF;
2340:
2341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2342: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2343: FND_MSG_PUB.ADD;
2344: RAISE FND_API.g_exc_unexpected_error;
2345:
2346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2347: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2348: FND_MSG_PUB.ADD;

2344: RAISE FND_API.g_exc_unexpected_error;
2345:
2346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2347: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2348: FND_MSG_PUB.ADD;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2351:
2352:

Line 2362: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);

2358: WHEN FND_API.G_EXC_ERROR THEN
2359: x_ret := FND_API.G_RET_STS_ERROR;
2360: x_return_status:=l_return_status;
2361: -- Get message count and data
2362: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2363:
2364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2365: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: x_return_status:=l_return_status;

Line 2368: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);

2364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2365: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: x_return_status:=l_return_status;
2367: -- Get message count and data
2368: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2369:
2370: WHEN OTHERS THEN
2371: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2372: x_return_status:=l_return_status;

Line 2374: FND_MSG_PUB.ADD;

2370: WHEN OTHERS THEN
2371: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2372: x_return_status:=l_return_status;
2373: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MD_ERROR');
2374: FND_MSG_PUB.ADD;
2375: fnd_msg_pub.count_and_get
2376: ( p_count => x_msg_count
2377: , p_data => x_msg_data
2378: );

Line 2375: fnd_msg_pub.count_and_get

2371: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2372: x_return_status:=l_return_status;
2373: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MD_ERROR');
2374: FND_MSG_PUB.ADD;
2375: fnd_msg_pub.count_and_get
2376: ( p_count => x_msg_count
2377: , p_data => x_msg_data
2378: );
2379:

Line 2440: fnd_msg_pub.count_and_get(p_count => x_msg_count

2436: EXCEPTION
2437: WHEN OTHERS THEN
2438: mydebug('CANCEL_WIP_CROSSDOCK_TASK:ERROR! Unexpected Error:'||SQLCODE);
2439: x_return_status := fnd_api.g_ret_sts_unexp_error;
2440: fnd_msg_pub.count_and_get(p_count => x_msg_count
2441: , p_data => x_msg_data);
2442:
2443: END cancel_wip_crossdock_task;
2444:

Line 2524: fnd_msg_pub.count_and_get(p_count => x_msg_count

2520: EXCEPTION
2521: WHEN no_data_found THEN
2522: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Invalid Transaction Temp ID: '||p_transaction_temp_id);
2523: x_return_status := fnd_api.g_ret_sts_error;
2524: fnd_msg_pub.count_and_get(p_count => x_msg_count
2525: , p_data => x_msg_data);
2526: WHEN fnd_api.g_exc_error THEN
2527: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2528: x_return_status := fnd_api.g_ret_sts_error;

Line 2529: fnd_msg_pub.count_and_get(p_count => x_msg_count

2525: , p_data => x_msg_data);
2526: WHEN fnd_api.g_exc_error THEN
2527: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2528: x_return_status := fnd_api.g_ret_sts_error;
2529: fnd_msg_pub.count_and_get(p_count => x_msg_count
2530: , p_data => x_msg_data);
2531: WHEN OTHERS THEN
2532: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2534: fnd_msg_pub.count_and_get(p_count => x_msg_count

2530: , p_data => x_msg_data);
2531: WHEN OTHERS THEN
2532: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
2534: fnd_msg_pub.count_and_get(p_count => x_msg_count
2535: , p_data => x_msg_data);
2536:
2537: END cancel_crossdock_task;
2538: