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.3.12000000.2 2007/01/23 18:32:52 rlanka 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 1149: SAVEPOINT WSH_Document_PVT;

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

Line 1684: ROLLBACK to WSH_Document_PVT;

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

Line 1708: ROLLBACK to WSH_Document_PVT;

1704: IF (get_lock_on_leg%ISOPEN) THEN
1705: CLOSE get_lock_on_leg;
1706: END IF;
1707:
1708: ROLLBACK to WSH_Document_PVT;
1709: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1710: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1711: p_data => x_msg_data );
1712: --

Line 1726: ROLLBACK to WSH_Document_PVT;

1722: IF (get_lock_on_leg%ISOPEN) THEN
1723: CLOSE get_lock_on_leg;
1724: END IF;
1725:
1726: ROLLBACK to WSH_Document_PVT;
1727: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1728: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1729: p_data => x_msg_data );
1730: --

Line 1744: ROLLBACK to WSH_Document_PVT;

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

Line 1924: SAVEPOINT WSH_Document_PVT;

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

Line 2070: ROLLBACK to WSH_Document_PVT;

2066: --
2067: EXCEPTION
2068:
2069: WHEN FND_API.g_exc_error THEN
2070: ROLLBACK to WSH_Document_PVT;
2071: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2072: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2073: p_data => x_msg_data );
2074:

Line 2084: ROLLBACK to WSH_Document_PVT;

2080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2081: END IF;
2082: --
2083: WHEN FND_API.g_exc_unexpected_error THEN
2084: ROLLBACK to WSH_Document_PVT;
2085: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2086: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2087: p_data => x_msg_data );
2088:

Line 2098: ROLLBACK to WSH_Document_PVT;

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

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

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

Line 2246: SAVEPOINT WSH_Document_PVT;

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

Line 2398: ROLLBACK to WSH_Document_PVT;

2394: --
2395: EXCEPTION
2396:
2397: WHEN FND_API.g_exc_error THEN
2398: ROLLBACK to WSH_Document_PVT;
2399: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2400: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2401: p_data => x_msg_data );
2402:

Line 2412: ROLLBACK to WSH_Document_PVT;

2408: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2409: END IF;
2410: --
2411: WHEN FND_API.g_exc_unexpected_error THEN
2412: ROLLBACK to WSH_Document_PVT;
2413: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2414: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2415: p_data => x_msg_data );
2416:

Line 2426: ROLLBACK to WSH_Document_PVT;

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

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

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

Line 2565: SAVEPOINT WSH_Document_PVT;

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

Line 2701: ROLLBACK to WSH_Document_PVT;

2697: --
2698: EXCEPTION
2699:
2700: WHEN FND_API.g_exc_error THEN
2701: ROLLBACK to WSH_Document_PVT;
2702: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2703: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2704: p_data => x_msg_data );
2705:

Line 2715: ROLLBACK to WSH_Document_PVT;

2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2712: END IF;
2713: --
2714: WHEN FND_API.g_exc_unexpected_error THEN
2715: ROLLBACK to WSH_Document_PVT;
2716: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2717: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2718: p_data => x_msg_data );
2719:

Line 2729: ROLLBACK to WSH_Document_PVT;

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

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

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

Line 2869: SAVEPOINT WSH_Document_PVT;

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

Line 3005: ROLLBACK to WSH_Document_PVT;

3001: --
3002: EXCEPTION
3003:
3004: WHEN FND_API.g_exc_error THEN
3005: ROLLBACK to WSH_Document_PVT;
3006: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3007: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3008: p_data => x_msg_data );
3009:

Line 3019: ROLLBACK to WSH_Document_PVT;

3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3016: END IF;
3017: --
3018: WHEN FND_API.g_exc_unexpected_error THEN
3019: ROLLBACK to WSH_Document_PVT;
3020: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3021: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3022: p_data => x_msg_data );
3023:

Line 3033: ROLLBACK to WSH_Document_PVT;

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

Line 3610: SAVEPOINT WSH_Document_PVT;

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

Line 3654: ROLLBACK to WSH_Document_PVT;

3650: --
3651: EXCEPTION
3652:
3653: WHEN FND_API.g_exc_error THEN
3654: ROLLBACK to WSH_Document_PVT;
3655: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3656: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3657: p_data => x_msg_data );
3658:

Line 3668: ROLLBACK to WSH_Document_PVT;

3664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3665: END IF;
3666: --
3667: WHEN FND_API.g_exc_unexpected_error THEN
3668: ROLLBACK to WSH_Document_PVT;
3669: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3670: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3671: p_data => x_msg_data );
3672:

Line 3682: ROLLBACK to WSH_Document_PVT;

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

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

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

Line 4463: END WSH_Document_PVT;

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