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 WSH_DOCUMENT_PVT

Line 1: PACKAGE BODY WSH_Document_PVT AS

1: PACKAGE BODY WSH_Document_PVT AS
2: -- $Header: WSHVPACB.pls 120.5.12020000.2 2013/03/05 11:40:26 sunilku ship $
3:
4: ---------------------
5: -- TYPE DECLARATIONS

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';

10: ------------
11: -- CONSTANTS
12: ------------
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
15:
16: --------------------
17: -- GLOBAL VARIABLES
18: --------------------

Line 789: SAVEPOINT WSH_Document_PVT;

785: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
786: WSH_DEBUG_SV.log(l_module_name,'P_FINAL_PRINT_DATE',P_FINAL_PRINT_DATE);
787: END IF;
788: --
789: SAVEPOINT WSH_Document_PVT;
790:
791: -- standard call to check for call compatibility.
792: IF NOT FND_API.Compatible_API_Call ( l_api_version,
793: p_api_version,

Line 838: ROLLBACK to WSH_Document_PVT;

834: EXCEPTION
835:
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:

Line 853: ROLLBACK to WSH_Document_PVT;

849: END IF;
850: --
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: --

Line 867: ROLLBACK to WSH_Document_PVT;

863: END IF;
864: --
865: WHEN others THEN
866:
867: ROLLBACK to WSH_Document_PVT;
868: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
869: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
870: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
871: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 1150: SAVEPOINT WSH_Document_PVT;

1146: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1147: WSH_DEBUG_SV.log(l_module_name,'P_MANUAL_SEQUENCE_NUMBER',P_MANUAL_SEQUENCE_NUMBER);
1148: END IF;
1149: --
1150: SAVEPOINT WSH_Document_PVT;
1151:
1152: -- standard call to check for call compatibility.
1153: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1154: p_api_version,

Line 1685: ROLLBACK to WSH_Document_PVT;

1681:
1682: IF (get_lock_on_leg%ISOPEN) THEN
1683: CLOSE get_lock_on_leg;
1684: END IF;
1685: ROLLBACK to WSH_Document_PVT;
1686:
1687: SELECT wnd.name INTO l_delivery_name
1688: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
1689: WHERE wnd.delivery_id = wdl.delivery_id

Line 1709: ROLLBACK to WSH_Document_PVT;

1705: IF (get_lock_on_leg%ISOPEN) THEN
1706: CLOSE get_lock_on_leg;
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: --

Line 1727: ROLLBACK to WSH_Document_PVT;

1723: IF (get_lock_on_leg%ISOPEN) THEN
1724: CLOSE get_lock_on_leg;
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: --

Line 1745: ROLLBACK to WSH_Document_PVT;

1741: IF (get_lock_on_leg%ISOPEN) THEN
1742: CLOSE get_lock_on_leg;
1743: END IF;
1744:
1745: ROLLBACK to WSH_Document_PVT;
1746: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
1747: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
1748: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
1749: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 1925: SAVEPOINT WSH_Document_PVT;

1921: WSH_DEBUG_SV.log(l_module_name,'P_LEDGER_ID',P_LEDGER_ID); -- LE Uptake
1922: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
1923: END IF;
1924: --
1925: SAVEPOINT WSH_Document_PVT;
1926:
1927: -- standard call to check for call compatibility.
1928: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1929: p_api_version,

Line 2071: ROLLBACK to WSH_Document_PVT;

2067: --
2068: EXCEPTION
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:

Line 2085: ROLLBACK to WSH_Document_PVT;

2081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2082: END IF;
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:

Line 2099: ROLLBACK to WSH_Document_PVT;

2095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2096: END IF;
2097: --
2098: WHEN others THEN
2099: ROLLBACK to WSH_Document_PVT;
2100: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2101: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 2168: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';

2164: , p_document_type IN VARCHAR2
2165: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
2166: )
2167: IS
2168: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2169: L_API_VERSION CONSTANT NUMBER := 1.0;
2170: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2171: l_table_count NUMBER;
2172: l_entity_name wsh_document_instances.entity_name%type;

Line 2247: SAVEPOINT WSH_Document_PVT;

2243: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2244: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2245: END IF;
2246: --
2247: SAVEPOINT WSH_Document_PVT;
2248:
2249: -- standard call to check for call compatibility.
2250: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2251: p_api_version,

Line 2399: ROLLBACK to WSH_Document_PVT;

2395: --
2396: EXCEPTION
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:

Line 2413: ROLLBACK to WSH_Document_PVT;

2409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2410: END IF;
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:

Line 2427: ROLLBACK to WSH_Document_PVT;

2423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2424: END IF;
2425: --
2426: WHEN others THEN
2427: ROLLBACK to WSH_Document_PVT;
2428: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2429: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 2495: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';

2491: , p_document_type IN VARCHAR2
2492: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
2493: )
2494: IS
2495: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2496: L_API_VERSION CONSTANT NUMBER := 1.0;
2497: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2498: l_table_count NUMBER;
2499: l_entity_name wsh_document_instances.entity_name%type;

Line 2566: SAVEPOINT WSH_Document_PVT;

2562: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2563: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2564: END IF;
2565: --
2566: SAVEPOINT WSH_Document_PVT;
2567:
2568: -- standard call to check for call compatibility.
2569: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2570: p_api_version,

Line 2702: ROLLBACK to WSH_Document_PVT;

2698: --
2699: EXCEPTION
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:

Line 2716: ROLLBACK to WSH_Document_PVT;

2712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2713: END IF;
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:

Line 2730: ROLLBACK to WSH_Document_PVT;

2726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2727: END IF;
2728: --
2729: WHEN others THEN
2730: ROLLBACK to WSH_Document_PVT;
2731: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2732: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 2799: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';

2795: , p_document_type IN VARCHAR2
2796: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
2797: )
2798: IS
2799: L_API_NAME CONSTANT VARCHAR2(30) := 'WSH_Document_PVT';
2800: L_API_VERSION CONSTANT NUMBER := 1.0;
2801: l_delivery_id_tab delivery_id_tabtype := delivery_id_tabtype();
2802: l_table_count NUMBER;
2803: l_entity_name wsh_document_instances.entity_name%type;

Line 2870: SAVEPOINT WSH_Document_PVT;

2866: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
2867: WSH_DEBUG_SV.log(l_module_name,'P_CONSOLIDATE_OPTION',P_CONSOLIDATE_OPTION);
2868: END IF;
2869: --
2870: SAVEPOINT WSH_Document_PVT;
2871:
2872: -- standard call to check for call compatibility.
2873: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2874: p_api_version,

Line 3006: ROLLBACK to WSH_Document_PVT;

3002: --
3003: EXCEPTION
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:

Line 3020: ROLLBACK to WSH_Document_PVT;

3016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3017: END IF;
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:

Line 3034: ROLLBACK to WSH_Document_PVT;

3030: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3031: END IF;
3032: --
3033: WHEN others THEN
3034: ROLLBACK to WSH_Document_PVT;
3035: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3036: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 3611: SAVEPOINT WSH_Document_PVT;

3607: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3608: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3609: END IF;
3610: --
3611: SAVEPOINT WSH_Document_PVT;
3612:
3613: -- standard call to check for call compatibility.
3614: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3615: p_api_version,

Line 3655: ROLLBACK to WSH_Document_PVT;

3651: --
3652: EXCEPTION
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:

Line 3669: ROLLBACK to WSH_Document_PVT;

3665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3666: END IF;
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:

Line 3683: ROLLBACK to WSH_Document_PVT;

3679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3680: END IF;
3681: --
3682: WHEN others THEN
3683: ROLLBACK to WSH_Document_PVT;
3684: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3685: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

Line 4454: wsh_util_core.default_handler('WSH_DOCUMENT_PVT.set_template',l_module_name);

4450: END IF;
4451:
4452: WHEN OTHERS THEN
4453:
4454: wsh_util_core.default_handler('WSH_DOCUMENT_PVT.set_template',l_module_name);
4455: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4456: --
4457: IF l_debug_on THEN
4458: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4464: END WSH_Document_PVT;

4460: END IF;
4461: End set_template;
4462:
4463:
4464: END WSH_Document_PVT;