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_DOCUMENT_PVT dependencies on FND_MSG_PUB

Line 442: FND_MSG_PUB.initialize;

438:
439: -- initialize message list if p_init_msg_list is set to TRUE.
440:
441: IF FND_API.to_boolean( p_init_msg_list ) THEN
442: FND_MSG_PUB.initialize;
443: END IF;
444:
445: -- initialize API return status to success
446: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 488: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

484: EXCEPTION
485:
486: WHEN FND_API.g_exc_error THEN
487: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
489: p_data => x_msg_data );
490: --
491: -- Debug Statements
492: --

Line 502: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

498: RETURN null;
499:
500: WHEN FND_API.g_exc_unexpected_error THEN
501: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
502: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
503: p_data => x_msg_data );
504: --
505: -- Debug Statements
506: --

Line 626: FND_MSG_PUB.initialize;

622: END IF;
623:
624: -- initialize message list if p_init_msg_list is set to TRUE.
625: IF FND_API.to_boolean( p_init_msg_list ) THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- initialize API return status to success
630: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 661: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

657: EXCEPTION
658:
659: WHEN FND_API.g_exc_error THEN
660: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
661: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
662: p_data => x_msg_data );
663: --
664: -- Debug Statements
665: --

Line 675: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

671: RETURN null;
672:
673: WHEN FND_API.g_exc_unexpected_error THEN
674: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
675: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
676: p_data => x_msg_data );
677: --
678: -- Debug Statements
679: --

Line 801: FND_MSG_PUB.initialize;

797: END IF;
798:
799: -- initialize message list if p_init_msg_list is set to TRUE.
800: IF FND_API.to_boolean( p_init_msg_list ) THEN
801: FND_MSG_PUB.initialize;
802: END IF;
803:
804: -- initialize API return status to success
805: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 819: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

815: AND doc.entity_name='WSH_NEW_DELIVERIES'
816: AND doc.document_type=p_document_type;
817:
818: -- get message count and the message itself (if only one message)
819: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
820: p_data => x_msg_data);
821:
822: -- Standard check of p_commit.
823: IF FND_API.to_boolean( p_commit ) THEN

Line 840: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

836: WHEN FND_API.g_exc_error THEN
837:
838: ROLLBACK to WSH_Document_PVT;
839: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
840: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
841: p_data => x_msg_data );
842:
843: --
844: -- Debug Statements

Line 855: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

851: WHEN FND_API.g_exc_unexpected_error THEN
852:
853: ROLLBACK to WSH_Document_PVT;
854: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
855: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
856: p_data => x_msg_data );
857: --
858: -- Debug Statements
859: --

Line 874: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

870: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
871: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
872: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
873: WSH_UTIL_CORE.add_message (x_return_status);
874: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
875: p_data => x_msg_data );
876:
877: --
878: -- Debug Statements

Line 1163: FND_MSG_PUB.initialize;

1159:
1160: -- initialize message list if p_init_msg_list is set to TRUE.
1161:
1162: IF FND_API.to_boolean( p_init_msg_list ) THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:
1166: -- initialize API return status to success
1167: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 1662: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1658: );
1659: END IF;--for l_entity_name <> 'WSH_TRIPS'
1660:
1661: -- get message count and the message itself (if only one message)
1662: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1663: p_data => x_msg_data);
1664:
1665: -- Standard check of p_commit.
1666: IF FND_API.to_boolean( p_commit ) THEN

Line 1697: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

1693: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
1694: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1695: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1696:
1697: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1698: p_data => x_msg_data );
1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock delivery leg for update');
1701: END IF;

Line 1711: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

1707: END IF;
1708:
1709: ROLLBACK to WSH_Document_PVT;
1710: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1711: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1712: p_data => x_msg_data );
1713: --
1714: -- Debug Statements
1715: --

Line 1729: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

1725: END IF;
1726:
1727: ROLLBACK to WSH_Document_PVT;
1728: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1729: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1730: p_data => x_msg_data );
1731: --
1732: -- Debug Statements
1733: --

Line 1752: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

1748: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
1749: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
1750: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1751: WSH_UTIL_CORE.add_message (x_return_status);
1752: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1753: p_data => x_msg_data );
1754:
1755: --
1756: -- Debug Statements

Line 1938: FND_MSG_PUB.initialize;

1934:
1935: -- initialize message list if p_init_msg_list is set to TRUE.
1936:
1937: IF FND_API.to_boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- initialize API return status to success
1942: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2051: CLOSE old_values_csr;
2052: END IF;
2053:
2054: -- get message count and the message itself (if only one message)
2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data);
2057: -- Standard check of p_commit.
2058: IF FND_API.to_boolean( p_commit ) THEN
2059: COMMIT WORK;

Line 2073: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2069:
2070: WHEN FND_API.g_exc_error THEN
2071: ROLLBACK to WSH_Document_PVT;
2072: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2073: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2074: p_data => x_msg_data );
2075:
2076: --
2077: -- Debug Statements

Line 2087: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2083: --
2084: WHEN FND_API.g_exc_unexpected_error THEN
2085: ROLLBACK to WSH_Document_PVT;
2086: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2087: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2088: p_data => x_msg_data );
2089:
2090: --
2091: -- Debug Statements

Line 2106: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2104: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2105: WSH_UTIL_CORE.add_message (x_return_status);
2106: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2107: p_data => x_msg_data );
2108: --
2109: -- Debug Statements
2110: --

Line 2260: FND_MSG_PUB.initialize;

2256:
2257: -- initialize message list if p_init_msg_list is set to TRUE.
2258:
2259: IF FND_API.to_boolean( p_init_msg_list ) THEN
2260: FND_MSG_PUB.initialize;
2261: END IF;
2262:
2263: -- initialize API return status to success
2264: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 2383: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2379: AND status in ('OPEN', 'PLANNED');
2380:
2381: END IF;
2382: -- get message count and the message itself (if only one message)
2383: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2384: p_data => x_msg_data);
2385: -- Standard check of p_commit.
2386: IF FND_API.to_boolean( p_commit ) THEN
2387: COMMIT WORK;

Line 2401: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2397:
2398: WHEN FND_API.g_exc_error THEN
2399: ROLLBACK to WSH_Document_PVT;
2400: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2401: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2402: p_data => x_msg_data );
2403:
2404: --
2405: -- Debug Statements

Line 2415: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2411: --
2412: WHEN FND_API.g_exc_unexpected_error THEN
2413: ROLLBACK to WSH_Document_PVT;
2414: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2415: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2416: p_data => x_msg_data );
2417:
2418: --
2419: -- Debug Statements

Line 2434: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2432: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2433: WSH_UTIL_CORE.add_message (x_return_status);
2434: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2435: p_data => x_msg_data );
2436: --
2437: -- Debug Statements
2438: --

Line 2579: FND_MSG_PUB.initialize;

2575:
2576: -- initialize message list if p_init_msg_list is set to TRUE.
2577:
2578: IF FND_API.to_boolean( p_init_msg_list ) THEN
2579: FND_MSG_PUB.initialize;
2580: END IF;
2581:
2582: -- initialize API return status to success
2583: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 2686: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2682: CLOSE status_csr;
2683: END IF;
2684:
2685: -- get message count and the message itself (if only one message)
2686: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2687: p_data => x_msg_data);
2688: -- Standard check of p_commit.
2689: IF FND_API.to_boolean( p_commit ) THEN
2690: COMMIT WORK;

Line 2704: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2700:
2701: WHEN FND_API.g_exc_error THEN
2702: ROLLBACK to WSH_Document_PVT;
2703: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2704: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2705: p_data => x_msg_data );
2706:
2707: --
2708: -- Debug Statements

Line 2718: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2714: --
2715: WHEN FND_API.g_exc_unexpected_error THEN
2716: ROLLBACK to WSH_Document_PVT;
2717: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2718: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2719: p_data => x_msg_data );
2720:
2721: --
2722: -- Debug Statements

Line 2737: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2735: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2736: WSH_UTIL_CORE.add_message (x_return_status);
2737: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2738: p_data => x_msg_data );
2739: --
2740: -- Debug Statements
2741: --

Line 2883: FND_MSG_PUB.initialize;

2879:
2880: -- initialize message list if p_init_msg_list is set to TRUE.
2881:
2882: IF FND_API.to_boolean( p_init_msg_list ) THEN
2883: FND_MSG_PUB.initialize;
2884: END IF;
2885:
2886: -- initialize API return status to success
2887: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 2990: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2986: CLOSE status_csr;
2987: END IF;
2988:
2989: -- get message count and the message itself (if only one message)
2990: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2991: p_data => x_msg_data);
2992: -- Standard check of p_commit.
2993: IF FND_API.to_boolean( p_commit ) THEN
2994: COMMIT WORK;

Line 3008: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3004:
3005: WHEN FND_API.g_exc_error THEN
3006: ROLLBACK to WSH_Document_PVT;
3007: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3008: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3009: p_data => x_msg_data );
3010:
3011: --
3012: -- Debug Statements

Line 3022: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3018: --
3019: WHEN FND_API.g_exc_unexpected_error THEN
3020: ROLLBACK to WSH_Document_PVT;
3021: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3022: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3023: p_data => x_msg_data );
3024:
3025: --
3026: -- Debug Statements

Line 3041: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3039: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3040: WSH_UTIL_CORE.add_message (x_return_status);
3041: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3042: p_data => x_msg_data );
3043: --
3044: -- Debug Statements
3045: --

Line 3169: FND_MSG_PUB.initialize;

3165:
3166: -- initialize message list if p_init_msg_list is set to TRUE.
3167:
3168: IF FND_API.to_boolean( p_init_msg_list ) THEN
3169: FND_MSG_PUB.initialize;
3170: END IF;
3171:
3172: -- initialize API return status to success
3173: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 3208: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

3204:
3205: x_conc_request_id := l_conc_request_id;
3206:
3207: -- get message count and the message itself (if only one message)
3208: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3209: p_data => x_msg_data);
3210:
3211: --
3212: -- Debug Statements

Line 3223: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3219: EXCEPTION
3220:
3221: WHEN FND_API.g_exc_error THEN
3222: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3223: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3224: p_data => x_msg_data );
3225:
3226: --
3227: -- Debug Statements

Line 3236: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3232: END IF;
3233: --
3234: WHEN FND_API.g_exc_unexpected_error THEN
3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3236: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3237: p_data => x_msg_data );
3238: --
3239: -- Debug Statements
3240: --

Line 3253: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3249: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3250: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3251: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3252: WSH_UTIL_CORE.add_message (x_return_status);
3253: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3254: p_data => x_msg_data );
3255: --
3256: -- Debug Statements
3257: --

Line 3369: FND_MSG_PUB.initialize;

3365: END IF;
3366:
3367: -- initialize message list if p_init_msg_list is set to TRUE.
3368: IF FND_API.to_boolean( p_init_msg_list ) THEN
3369: FND_MSG_PUB.initialize;
3370: END IF;
3371:
3372: -- initialize API return status to success
3373: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 3490: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3486: EXCEPTION
3487:
3488: WHEN FND_API.g_exc_error THEN
3489: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3490: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3491: p_data => x_msg_data );
3492: --
3493: -- Debug Statements
3494: --

Line 3504: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3500: RETURN null;
3501:
3502: WHEN FND_API.g_exc_unexpected_error THEN
3503: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3504: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3505: p_data => x_msg_data );
3506: --
3507: -- Debug Statements
3508: --

Line 3623: FND_MSG_PUB.initialize;

3619: END IF;
3620:
3621: -- initialize message list if p_init_msg_list is set to TRUE.
3622: IF FND_API.to_boolean( p_init_msg_list ) THEN
3623: FND_MSG_PUB.initialize;
3624: END IF;
3625:
3626: -- initialize API return status to success
3627: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 3639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

3635: WHERE entity_name = p_entity_name
3636: AND entity_id = p_entity_id;
3637:
3638: -- get message count and the message itself (if only one message)
3639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3640: p_data => x_msg_data);
3641: -- Standard check of p_commit.
3642: IF FND_API.to_boolean( p_commit ) THEN
3643: COMMIT WORK;

Line 3657: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3653:
3654: WHEN FND_API.g_exc_error THEN
3655: ROLLBACK to WSH_Document_PVT;
3656: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3657: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3658: p_data => x_msg_data );
3659:
3660: --
3661: -- Debug Statements

Line 3671: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3667: --
3668: WHEN FND_API.g_exc_unexpected_error THEN
3669: ROLLBACK to WSH_Document_PVT;
3670: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3671: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3672: p_data => x_msg_data );
3673:
3674: --
3675: -- Debug Statements

Line 3690: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3688: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3689: WSH_UTIL_CORE.add_message (x_return_status);
3690: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3691: p_data => x_msg_data );
3692: --
3693: -- Debug Statements
3694: --

Line 3827: FND_MSG_PUB.initialize;

3823: END IF;
3824:
3825: -- initialize message list if p_init_msg_list is set to TRUE.
3826: IF FND_API.to_boolean( p_init_msg_list ) THEN
3827: FND_MSG_PUB.initialize;
3828: END IF;
3829:
3830: -- initialize API return status to success
3831: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 3886: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

3882: i := i + 1;
3883: END LOOP;
3884:
3885: -- get message count and the message itself (if only one message)
3886: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3887: p_data => x_msg_data);
3888: -- Standard check of p_commit.
3889: IF FND_API.to_boolean( p_commit ) THEN
3890: COMMIT WORK;

Line 3904: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3900: EXCEPTION
3901:
3902: WHEN FND_API.g_exc_error THEN
3903: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3904: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3905: p_data => x_msg_data );
3906:
3907: --
3908: -- Debug Statements

Line 3917: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3913: END IF;
3914: --
3915: WHEN FND_API.g_exc_unexpected_error THEN
3916: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3917: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3918: p_data => x_msg_data );
3919:
3920: --
3921: -- Debug Statements

Line 3935: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

3931: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3932: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3933: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3934: WSH_UTIL_CORE.add_message (x_return_status);
3935: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3936: p_data => x_msg_data );
3937: --
3938: -- Debug Statements
3939: --