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_UTIL_CORE

Line 291: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

287: IF delivery_leg_csr%NOTFOUND
288: THEN
289: CLOSE delivery_leg_csr;
290: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
291: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: CLOSE delivery_leg_csr;
295: --

Line 446: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
447:
448: OPEN type_csr;
449: FETCH type_csr INTO type_rec;
450: IF type_csr%NOTFOUND

Line 454: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

450: IF type_csr%NOTFOUND
451: THEN
452: CLOSE type_csr;
453: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');
454: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457: -- call FND API to get the sequence type information
458: l_seq_return := FND_SEQNUM.get_seq_info

Line 487: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

483: RETURN l_type;
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

Line 501: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

497: --
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

Line 519: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

515: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
516: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
517: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
518: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
519: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
520: WSH_UTIL_CORE.add_message (x_return_status);
521: --
522: -- Debug Statements
523: --

Line 520: WSH_UTIL_CORE.add_message (x_return_status);

516: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
517: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
518: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
519: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
520: WSH_UTIL_CORE.add_message (x_return_status);
521: --
522: -- Debug Statements
523: --
524: IF l_debug_on THEN

Line 630: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
631:
632: -- initially l_isfinal=FALSE, means no document is not final
633: l_isfinal := FND_API.G_false;
634:

Line 660: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

656:
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

Line 674: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

670: --
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

Line 692: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

688: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
689: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
690: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
691: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
692: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
693: WSH_UTIL_CORE.add_message (x_return_status);
694: --
695: -- Debug Statements
696: --

Line 693: WSH_UTIL_CORE.add_message (x_return_status);

689: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
690: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
691: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
692: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
693: WSH_UTIL_CORE.add_message (x_return_status);
694: --
695: -- Debug Statements
696: --
697: IF l_debug_on THEN

Line 805: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
806:
807: -- initialize l_temp_date to p_final_print_date
808: l_temp_date := p_final_print_date;
809:

Line 839: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
843: --

Line 854: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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: --
858: -- Debug Statements

Line 872: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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:

Line 873: WSH_UTIL_CORE.add_message (x_return_status);

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');
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: --

Line 1167: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
1168: OPEN category_csr;
1169: FETCH category_csr INTO category_rec;
1170: IF category_csr%NOTFOUND
1171: THEN

Line 1174: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1170: IF category_csr%NOTFOUND
1171: THEN
1172: CLOSE category_csr;
1173: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_CATEGORY_MISSING');
1174: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: l_doc_sequence_category_id := category_rec.doc_sequence_category_id;
1178: CLOSE category_csr;

Line 1189: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1185: FETCH assignment_csr INTO assignment_rec;
1186: IF assignment_csr%NOTFOUND THEN
1187: CLOSE assignment_csr;
1188: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');
1189: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: l_doc_sequence_id := assignment_rec.doc_sequence_id;
1193: CLOSE assignment_csr;

Line 1234: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1230: IF delivery_csr%NOTFOUND
1231: THEN
1232: CLOSE delivery_csr;
1233: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1234: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1235: RAISE FND_API.G_EXC_ERROR;
1236: END IF;
1237: CLOSE delivery_csr;
1238:

Line 1257: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1253: END IF;
1254:
1255: IF NOT l_delivery_id_tab.EXISTS(1) THEN
1256: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1257: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260:
1261:

Line 1351: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1347: END IF;
1348: IF NVL(l_sequence_number,0) = 0
1349: THEN
1350: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');
1351: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:
1355: /* l_document_number := LTRIM(RTRIM(category_rec.prefix)) ||

Line 1572: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1568:
1569: IF NVL(l_sequence_number,0) = 0
1570: THEN
1571: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');
1572: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1573: RAISE FND_API.G_EXC_ERROR;
1574: END IF;
1575:
1576: IF category_rec.prefix is not NULL THEN

Line 1694: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1690: AND wdl.delivery_leg_id = l_delivery_leg_id;
1691:
1692: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');
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 );

Line 1695: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);

1691:
1692: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');
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

Line 1710: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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: --
1714: -- Debug Statements

Line 1728: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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: --
1732: -- Debug Statements

Line 1750: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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:

Line 1751: WSH_UTIL_CORE.add_message (x_return_status);

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');
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: --

Line 1942: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
1943:
1944: -------------------------------------------------------------
1945: -- Initialize the entity_name based on the document type --
1946: -- If the entity is Delivery leg, look up its delivery id --

Line 1992: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

1988: END IF;
1989:
1990: IF NOT l_delivery_id_tab.EXISTS(1) THEN
1991: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1992: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;
1995:
1996: FOR ctr IN 1..l_delivery_id_tab.count LOOP

Line 2027: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2023: FETCH old_values_csr INTO old_values_rec;
2024: IF old_values_csr%NOTFOUND THEN
2025: CLOSE old_values_csr;
2026: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2027: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2028: RAISE FND_API.G_EXC_ERROR;
2029: END IF;
2030:
2031: -- if the document is cancelled, raise error

Line 2034: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2030:
2031: -- if the document is cancelled, raise error
2032: IF old_values_rec.status = 'CANCELLED' THEN
2033: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2034: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2035: RAISE FND_API.G_EXC_ERROR;
2036: END IF;
2037:
2038: -- need to change this update within loop to a bulk update later.

Line 2072: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
2076: --

Line 2086: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2090: --

Line 2104: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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: --

Line 2105: WSH_UTIL_CORE.add_message (x_return_status);

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');
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

Line 2264: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
2265:
2266: -------------------------------------------------------------
2267: -- Initialize the entity_name based on the document type --
2268: -- If the entity is Delivery leg, look up its delivery id --

Line 2317: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2313: END IF;
2314:
2315: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2316: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2317: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2318: RAISE FND_API.G_EXC_ERROR;
2319: END IF;
2320:
2321: FOR ctr IN 1..l_delivery_id_tab.count LOOP

Line 2352: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2348: FETCH status_csr INTO status_rec;
2349: IF status_csr%NOTFOUND THEN
2350: CLOSE status_csr;
2351: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2352: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2353: RAISE FND_API.G_EXC_ERROR;
2354: END IF;
2355:
2356: UPDATE wsh_document_instances

Line 2400: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
2404: --

Line 2414: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2418: --

Line 2432: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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: --

Line 2433: WSH_UTIL_CORE.add_message (x_return_status);

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');
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

Line 2583: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
2584:
2585: -------------------------------------------------------------
2586: -- Initialize the entity_name based on the document type --
2587: -- If the entity is Delivery leg, look up its delivery id --

Line 2633: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2629: END IF;
2630:
2631: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2632: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2633: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2634: RAISE FND_API.G_EXC_ERROR;
2635: END IF;
2636:
2637: FOR ctr IN 1..l_delivery_id_tab.count LOOP

Line 2668: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2664: FETCH status_csr INTO status_rec;
2665: IF status_csr%NOTFOUND THEN
2666: CLOSE status_csr;
2667: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2668: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2669: RAISE FND_API.G_EXC_ERROR;
2670: END IF;
2671:
2672: UPDATE wsh_document_instances

Line 2703: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
2707: --

Line 2717: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2721: --

Line 2735: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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: --

Line 2736: WSH_UTIL_CORE.add_message (x_return_status);

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');
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

Line 2887: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
2888:
2889: -------------------------------------------------------------
2890: -- Initialize the entity_name based on the document type --
2891: -- If the entity is Delivery leg, look up its delivery id --

Line 2937: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2933: END IF;
2934:
2935: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2936: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2937: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2938: RAISE FND_API.G_EXC_ERROR;
2939: END IF;
2940:
2941: FOR ctr IN 1..l_delivery_id_tab.count LOOP

Line 2972: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);

2968: FETCH status_csr INTO status_rec;
2969: IF status_csr%NOTFOUND THEN
2970: CLOSE status_csr;
2971: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2972: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2973: RAISE FND_API.G_EXC_ERROR;
2974: END IF;
2975:
2976: UPDATE wsh_document_instances

Line 3007: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
3011: --

Line 3021: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
3025: --

Line 3039: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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: --

Line 3040: WSH_UTIL_CORE.add_message (x_return_status);

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');
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

Line 3173: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
3174:
3175: -- call FND_REQUEST.SUBMIT_REQUEST to run the WSHRDPAK.rdf report
3176: l_conc_request_id := FND_REQUEST.SUBMIT_REQUEST
3177: ( 'WSH'

Line 3222: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3218: --
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: --

Line 3235: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

Line 3251: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3247: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3248: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
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: --

Line 3252: WSH_UTIL_CORE.add_message (x_return_status);

3248: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
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

Line 3373: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
3374:
3375: -- initially l_cum_qty=0
3376: l_cum_qty :=0;
3377:

Line 3489: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3485:
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

Line 3503: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3499: --
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

Line 3521: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3517: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3518: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3519: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3520: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3521: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3522: WSH_UTIL_CORE.add_message (x_return_status);
3523: --
3524: -- Debug Statements
3525: --

Line 3522: WSH_UTIL_CORE.add_message (x_return_status);

3518: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3519: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3520: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3521: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3522: WSH_UTIL_CORE.add_message (x_return_status);
3523: --
3524: -- Debug Statements
3525: --
3526: IF l_debug_on THEN

Line 3627: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
3628:
3629:
3630: UPDATE wsh_document_instances
3631: SET status = 'CANCELLED'

Line 3656: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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:
3660: --

Line 3670: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
3674: --

Line 3688: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
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: --

Line 3689: WSH_UTIL_CORE.add_message (x_return_status);

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');
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

Line 3831: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

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;
3832:
3833: -- Initialize the table
3834: --
3835: -- Debug Statements

Line 3903: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

3899: --
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: --

Line 3916: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

Line 3933: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3929: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3930: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
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: --

Line 3934: WSH_UTIL_CORE.add_message (x_return_status);

3930: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
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

Line 4364: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4360: WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
4361: WSH_DEBUG_SV.log(l_module_name,'P_REPORT',P_REPORT);
4362: END IF;
4363: --
4364: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4365:
4366: l_param_value_info.organization_id := p_organization_id;
4367: l_param_value_info.class_code(1) := 'XDO_TEMPLATE';
4368: l_param_value_info.param_name(1) := p_template_name;

Line 4375: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))

4371: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4372: END IF;
4373:
4374: wsh_shipping_params_pvt.get(l_param_value_info,l_return_status);
4375: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR))
4376: THEN
4377: IF l_debug_on THEN
4378: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_SHIPPING_PARAMS_PVT.Get returned '||l_return_status);
4379: END IF;

Line 4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4423: IF l_debug_on THEN
4424: wsh_debug_sv.log(l_module_name,'Return Status After Calling fnd_request.add_layout ',l_status);
4425: END IF;
4426: IF (l_status=FALSE) THEN
4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4428: wsh_util_core.add_message(x_return_status,l_module_name);
4429: END IF;
4430: --}
4431: END IF;

Line 4428: wsh_util_core.add_message(x_return_status,l_module_name);

4424: wsh_debug_sv.log(l_module_name,'Return Status After Calling fnd_request.add_layout ',l_status);
4425: END IF;
4426: IF (l_status=FALSE) THEN
4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4428: wsh_util_core.add_message(x_return_status,l_module_name);
4429: END IF;
4430: --}
4431: END IF;
4432: x_conc_prog_name := l_conc_prog_name;

Line 4440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4436: END IF;
4437:
4438: EXCEPTION
4439: WHEN get_shipping_param_err THEN
4440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4441: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4442: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
4443: wsh_util_core.get_org_name(p_organization_id));
4444: wsh_util_core.add_message(x_return_status,l_module_name);

Line 4443: wsh_util_core.get_org_name(p_organization_id));

4439: WHEN get_shipping_param_err THEN
4440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4441: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4442: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
4443: wsh_util_core.get_org_name(p_organization_id));
4444: wsh_util_core.add_message(x_return_status,l_module_name);
4445:
4446: --
4447: IF l_debug_on THEN

Line 4444: wsh_util_core.add_message(x_return_status,l_module_name);

4440: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4441: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');
4442: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',
4443: wsh_util_core.get_org_name(p_organization_id));
4444: wsh_util_core.add_message(x_return_status,l_module_name);
4445:
4446: --
4447: IF l_debug_on THEN
4448: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to get Shipping Parameters',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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 4455: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

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);
4459: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');