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 478: -- fnd_msg_pub.initialize;

474: SAVEPOINT check_crossdock_sp;
475: l_progress := '10';
476:
477: -- Initialize message list to clear any existing messages
478: -- fnd_msg_pub.initialize;
479: l_progress := '20';
480: l_mol_criteria_tb.DELETE; --9695544
481:
482: -- Initialize API return status to success

Line 688: FND_MSG_PUB.ADD;

684: END IF;
685:
686: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
687: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR' );
688: FND_MSG_PUB.ADD;
689: RAISE FND_API.g_exc_unexpected_error;
690:
691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');

Line 693: FND_MSG_PUB.ADD;

689: RAISE FND_API.g_exc_unexpected_error;
690:
691: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: FND_MESSAGE.SET_NAME('WMS','WMS_XDOK_SEARCH_ERROR');
693: FND_MSG_PUB.ADD;
694: RAISE FND_API.g_exc_error;
695: END IF;
696:
697: l_progress := '110';

Line 738: FND_MSG_PUB.ADD;

734: END IF;
735:
736: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR' );
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.g_exc_unexpected_error;
740:
741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
742: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');

Line 743: FND_MSG_PUB.ADD;

739: RAISE FND_API.g_exc_unexpected_error;
740:
741: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
742: FND_MESSAGE.SET_NAME('WMS','WMS_OPP_XDOK_ERROR');
743: FND_MSG_PUB.ADD;
744: RAISE FND_API.g_exc_error;
745: END IF;
746:
747: l_progress := '120';

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

1385: END IF;
1386:
1387: ROLLBACK TO check_crossdock_sp;
1388: x_return_status := fnd_api.g_ret_sts_error;
1389: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1390: p_data => x_msg_data);
1391: IF (l_debug = 1) THEN
1392: mydebug('Exiting check_crossdock - Execution error: ' ||
1393: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

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

1412: END IF;
1413:
1414: ROLLBACK TO check_crossdock_sp;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1417: p_data => x_msg_data);
1418: IF (l_debug = 1) THEN
1419: mydebug('Exiting Opportunistic_Cross_Dock - Unexpected error: ' ||
1420: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

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

1437: END IF;
1438:
1439: ROLLBACK TO check_crossdock_sp;
1440: x_return_status := fnd_api.g_ret_sts_unexp_error;
1441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1442: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1445: p_data => x_msg_data);

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

1438:
1439: ROLLBACK TO check_crossdock_sp;
1440: x_return_status := fnd_api.g_ret_sts_unexp_error;
1441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1442: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1445: p_data => x_msg_data);
1446: IF (l_debug = 1) THEN

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

1440: x_return_status := fnd_api.g_ret_sts_unexp_error;
1441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1442: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1445: p_data => x_msg_data);
1446: IF (l_debug = 1) THEN
1447: mydebug('Exiting Opportunistic_Cross_Dock - Others exception: ' ||
1448: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 1732: FND_MSG_PUB.Add;

1728: mydebug('HdrID:'||l_mso_header_id);
1729: END IF;
1730: IF l_mso_header_id IS NULL THEN
1731: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
1732: FND_MSG_PUB.Add;
1733: RAISE fnd_api.g_exc_unexpected_error;
1734: END IF;
1735: IF (l_debug = 1) THEN
1736: mydebug('Get Dem src');

Line 1810: FND_MSG_PUB.Add;

1806: IF (l_debug = 1) THEN
1807: mydebug('Error in Query Reservation');
1808: END IF;
1809: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
1810: FND_MSG_PUB.Add;
1811: RAISE fnd_api.g_exc_unexpected_error;
1812: END IF;
1813:
1814:

Line 1876: FND_MSG_PUB.Add;

1872: IF (l_debug = 1) THEN
1873: mydebug('error in transfer reservation');
1874: END IF;
1875: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
1876: FND_MSG_PUB.Add;
1877: RAISE fnd_api.g_exc_unexpected_error;
1878: END IF;
1879:
1880: IF (l_primary_temp_qty <= 0) THEN

Line 1974: fnd_msg_pub.count_and_get

1970: );
1971:
1972:
1973:
1974: fnd_msg_pub.count_and_get
1975: ( p_count => l_msg_cnt
1976: , p_data => l_msg_data
1977: );
1978:

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

1989: IF (l_debug = 1) THEN
1990: mydebug('Not Successful2');
1991: END IF;
1992: For I in 1..l_msg_cnt LOOP
1993: l_msg_data := fnd_msg_pub.get(I,'F');
1994: IF (l_debug = 1) THEN
1995: mydebug(replace(l_msg_data,chr(0),' '));
1996: END IF;
1997: END LOOP;

Line 2008: FND_MSG_PUB.Add;

2004: mydebug('error in create reservation');
2005: END IF;
2006: -- ROLLBACK TO Process_Line_PVT;
2007: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CR_RSV_ERROR');
2008: FND_MSG_PUB.Add;
2009: RAISE fnd_api.g_exc_unexpected_error;
2010: END IF;
2011: END IF;
2012:

Line 2036: FND_MSG_PUB.ADD;

2032:
2033:
2034: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2035: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR' );
2036: FND_MSG_PUB.ADD;
2037: RAISE FND_API.g_exc_unexpected_error;
2038:
2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');

Line 2041: FND_MSG_PUB.ADD;

2037: RAISE FND_API.g_exc_unexpected_error;
2038:
2039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_RSV_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044:
2045: IF (l_debug = 1) THEN

Line 2158: FND_MSG_PUB.ADD;

2154: IF (l_debug = 1) THEN mydebug('after update shipping attributes'); END IF;
2155:
2156: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2157: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2158: FND_MSG_PUB.ADD;
2159: RAISE FND_API.g_exc_unexpected_error;
2160:
2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2162: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2163: FND_MSG_PUB.ADD;

2159: RAISE FND_API.g_exc_unexpected_error;
2160:
2161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2162: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;
2166:
2167: ELSE

Line 2234: FND_MSG_PUB.ADD;

2230:
2231:
2232: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2234: FND_MSG_PUB.ADD;
2235: RAISE FND_API.g_exc_unexpected_error;
2236:
2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2238: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2239: FND_MSG_PUB.ADD;

2235: RAISE FND_API.g_exc_unexpected_error;
2236:
2237: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2238: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2239: FND_MSG_PUB.ADD;
2240: RAISE FND_API.G_EXC_ERROR;
2241: END IF;
2242:
2243: END IF;

Line 2312: FND_MSG_PUB.ADD;

2308:
2309:
2310: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2311: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2312: FND_MSG_PUB.ADD;
2313: RAISE FND_API.g_exc_unexpected_error;
2314:
2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2317: FND_MSG_PUB.ADD;

2313: RAISE FND_API.g_exc_unexpected_error;
2314:
2315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END IF;
2320:
2321:

Line 2385: FND_MSG_PUB.ADD;

2381:
2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2385: FND_MSG_PUB.ADD;
2386: RAISE FND_API.g_exc_unexpected_error;
2387:
2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2390: FND_MSG_PUB.ADD;

2386: RAISE FND_API.g_exc_unexpected_error;
2387:
2388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2390: FND_MSG_PUB.ADD;
2391: RAISE FND_API.G_EXC_ERROR;
2392: END IF;
2393:
2394:

Line 2430: fnd_msg_pub.count_and_get

2426: x_return_status => l_return_status
2427: );
2428:
2429:
2430: fnd_msg_pub.count_and_get
2431: ( p_count => l_msg_cnt
2432: , p_data => l_msg_data
2433: );
2434:

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

2445: IF (l_debug = 1) THEN
2446: mydebug('Not Successful2');
2447: END IF;
2448: For I in 1..l_msg_cnt LOOP
2449: l_msg_data := fnd_msg_pub.get(I,'F');
2450: IF (l_debug = 1) THEN
2451: mydebug(replace(l_msg_data,chr(0),' '));
2452: END IF;
2453: END LOOP;

Line 2462: FND_MSG_PUB.ADD;

2458: END IF;
2459:
2460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2461: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2462: FND_MSG_PUB.ADD;
2463: RAISE FND_API.g_exc_unexpected_error;
2464:
2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2466: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2467: FND_MSG_PUB.ADD;

2463: RAISE FND_API.g_exc_unexpected_error;
2464:
2465: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2466: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2467: FND_MSG_PUB.ADD;
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2470:
2471: IF (l_debug = 1) THEN

Line 2490: FND_MSG_PUB.ADD;

2486: AND ROWNUM=1;
2487: EXCEPTION
2488: WHEN NO_DATA_FOUND THEN
2489: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_DEL_LPN_ERROR');
2490: FND_MSG_PUB.ADD;
2491: RAISE FND_API.G_EXC_ERROR;
2492: END;
2493:
2494: IF (l_debug = 1) THEN

Line 2619: FND_MSG_PUB.ADD;

2615:
2616:
2617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.g_exc_unexpected_error;
2621:
2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2623: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');

Line 2624: FND_MSG_PUB.ADD;

2620: RAISE FND_API.g_exc_unexpected_error;
2621:
2622: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2623: FND_MESSAGE.SET_NAME('INV','INV_RCV_CRT_PRINT_LAB_FAIL');
2624: FND_MSG_PUB.ADD;
2625: l_return_status :=FND_API.g_ret_sts_success;
2626: END IF;
2627:
2628: x_return_status:=l_return_status;

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

2637: EXCEPTION
2638: WHEN FND_API.G_EXC_ERROR THEN
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: -- Get message count and data
2641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2645: -- Get message count and data

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

2642:
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2645: -- Get message count and data
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2647:
2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2650: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );

Line 2651: FND_MSG_PUB.ADD;

2647:
2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2650: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );
2651: FND_MSG_PUB.ADD;
2652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2653:
2654:
2655: END complete_crossdock;

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

2648: WHEN OTHERS THEN
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2650: FND_MESSAGE.SET_NAME('WMS','WMS_TD_CCDOCK_ERROR' );
2651: FND_MSG_PUB.ADD;
2652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2653:
2654:
2655: END complete_crossdock;
2656:

Line 2699: FND_MSG_PUB.ADD;

2695: END IF;
2696:
2697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2698: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR' );
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.g_exc_unexpected_error;
2701:
2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2703: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');

Line 2704: FND_MSG_PUB.ADD;

2700: RAISE FND_API.g_exc_unexpected_error;
2701:
2702: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2703: FND_MESSAGE.SET_NAME('WMS','WMS_TD_UPD_SHP_ERROR');
2704: FND_MSG_PUB.ADD;
2705: RAISE FND_API.G_EXC_ERROR;
2706: END IF;
2707:
2708:

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

2714: WHEN FND_API.G_EXC_ERROR THEN
2715: x_ret := FND_API.G_RET_STS_ERROR;
2716: x_return_status:=l_return_status;
2717: -- Get message count and data
2718: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2719:
2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2722: x_return_status:=l_return_status;

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

2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2722: x_return_status:=l_return_status;
2723: -- Get message count and data
2724: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count, p_data => l_msg_data);
2725:
2726: WHEN OTHERS THEN
2727: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2728: x_return_status:=l_return_status;

Line 2730: FND_MSG_PUB.ADD;

2726: WHEN OTHERS THEN
2727: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2728: x_return_status:=l_return_status;
2729: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MD_ERROR');
2730: FND_MSG_PUB.ADD;
2731: fnd_msg_pub.count_and_get
2732: ( p_count => x_msg_count
2733: , p_data => x_msg_data
2734: );

Line 2731: fnd_msg_pub.count_and_get

2727: x_ret := FND_API.G_RET_STS_UNEXP_ERROR ;
2728: x_return_status:=l_return_status;
2729: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MD_ERROR');
2730: FND_MSG_PUB.ADD;
2731: fnd_msg_pub.count_and_get
2732: ( p_count => x_msg_count
2733: , p_data => x_msg_data
2734: );
2735:

Line 2796: fnd_msg_pub.count_and_get(p_count => x_msg_count

2792: EXCEPTION
2793: WHEN OTHERS THEN
2794: mydebug('CANCEL_WIP_CROSSDOCK_TASK:ERROR! Unexpected Error:'||SQLCODE);
2795: x_return_status := fnd_api.g_ret_sts_unexp_error;
2796: fnd_msg_pub.count_and_get(p_count => x_msg_count
2797: , p_data => x_msg_data);
2798:
2799: END cancel_wip_crossdock_task;
2800:

Line 2880: fnd_msg_pub.count_and_get(p_count => x_msg_count

2876: EXCEPTION
2877: WHEN no_data_found THEN
2878: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Invalid Transaction Temp ID: '||p_transaction_temp_id);
2879: x_return_status := fnd_api.g_ret_sts_error;
2880: fnd_msg_pub.count_and_get(p_count => x_msg_count
2881: , p_data => x_msg_data);
2882: WHEN fnd_api.g_exc_error THEN
2883: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2884: x_return_status := fnd_api.g_ret_sts_error;

Line 2885: fnd_msg_pub.count_and_get(p_count => x_msg_count

2881: , p_data => x_msg_data);
2882: WHEN fnd_api.g_exc_error THEN
2883: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Error raised by the API: '||SQLCODE);
2884: x_return_status := fnd_api.g_ret_sts_error;
2885: fnd_msg_pub.count_and_get(p_count => x_msg_count
2886: , p_data => x_msg_data);
2887: WHEN OTHERS THEN
2888: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);
2889: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2890: fnd_msg_pub.count_and_get(p_count => x_msg_count

2886: , p_data => x_msg_data);
2887: WHEN OTHERS THEN
2888: mydebug('CANCEL_CROSSDOCK_TASK: ERROR! Unexpected Error: '||SQLCODE);
2889: x_return_status := fnd_api.g_ret_sts_unexp_error;
2890: fnd_msg_pub.count_and_get(p_count => x_msg_count
2891: , p_data => x_msg_data);
2892:
2893: END cancel_crossdock_task;
2894: