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 1166: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

1162: FND_MSG_PUB.initialize;
1163: END IF;
1164:
1165: -- initialize API return status to success
1166: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
1167: OPEN category_csr;
1168: FETCH category_csr INTO category_rec;
1169: IF category_csr%NOTFOUND
1170: THEN

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

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

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

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

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

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

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

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

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

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

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

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

Line 1693: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1689: AND wdl.delivery_leg_id = l_delivery_leg_id;
1690:
1691: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');
1692: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
1693: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1694: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1695:
1696: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1697: p_data => x_msg_data );

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

1690:
1691: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');
1692: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
1693: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1694: wsh_util_core.add_message(WSH_UTIL_CORE.g_ret_sts_error,l_module_name);
1695:
1696: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1697: p_data => x_msg_data );
1698: IF l_debug_on THEN

Line 1709: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 1727: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

Line 1749: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
1749: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1750: WSH_UTIL_CORE.add_message (x_return_status);
1751: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1752: p_data => x_msg_data );
1753:

Line 1750: WSH_UTIL_CORE.add_message (x_return_status);

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');
1749: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1750: WSH_UTIL_CORE.add_message (x_return_status);
1751: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
1752: p_data => x_msg_data );
1753:
1754: --

Line 1941: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

1937: FND_MSG_PUB.initialize;
1938: END IF;
1939:
1940: -- initialize API return status to success
1941: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
1942:
1943: -------------------------------------------------------------
1944: -- Initialize the entity_name based on the document type --
1945: -- If the entity is Delivery leg, look up its delivery id --

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

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

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

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

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

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

Line 2071: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 2085: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2089: --

Line 2103: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
2103: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2104: WSH_UTIL_CORE.add_message (x_return_status);
2105: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2106: p_data => x_msg_data );
2107: --

Line 2104: WSH_UTIL_CORE.add_message (x_return_status);

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');
2103: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2104: WSH_UTIL_CORE.add_message (x_return_status);
2105: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2106: p_data => x_msg_data );
2107: --
2108: -- Debug Statements

Line 2263: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

2259: FND_MSG_PUB.initialize;
2260: END IF;
2261:
2262: -- initialize API return status to success
2263: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
2264:
2265: -------------------------------------------------------------
2266: -- Initialize the entity_name based on the document type --
2267: -- If the entity is Delivery leg, look up its delivery id --

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

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

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

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

Line 2399: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 2413: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2417: --

Line 2431: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
2431: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2432: WSH_UTIL_CORE.add_message (x_return_status);
2433: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2434: p_data => x_msg_data );
2435: --

Line 2432: WSH_UTIL_CORE.add_message (x_return_status);

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');
2431: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2432: WSH_UTIL_CORE.add_message (x_return_status);
2433: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2434: p_data => x_msg_data );
2435: --
2436: -- Debug Statements

Line 2582: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

2578: FND_MSG_PUB.initialize;
2579: END IF;
2580:
2581: -- initialize API return status to success
2582: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
2583:
2584: -------------------------------------------------------------
2585: -- Initialize the entity_name based on the document type --
2586: -- If the entity is Delivery leg, look up its delivery id --

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

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

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

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

Line 2702: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 2716: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
2720: --

Line 2734: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
2734: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2735: WSH_UTIL_CORE.add_message (x_return_status);
2736: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2737: p_data => x_msg_data );
2738: --

Line 2735: WSH_UTIL_CORE.add_message (x_return_status);

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');
2734: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2735: WSH_UTIL_CORE.add_message (x_return_status);
2736: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2737: p_data => x_msg_data );
2738: --
2739: -- Debug Statements

Line 2886: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

2882: FND_MSG_PUB.initialize;
2883: END IF;
2884:
2885: -- initialize API return status to success
2886: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
2887:
2888: -------------------------------------------------------------
2889: -- Initialize the entity_name based on the document type --
2890: -- If the entity is Delivery leg, look up its delivery id --

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

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

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

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

Line 3006: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 3020: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
3024: --

Line 3038: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
3038: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3039: WSH_UTIL_CORE.add_message (x_return_status);
3040: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3041: p_data => x_msg_data );
3042: --

Line 3039: WSH_UTIL_CORE.add_message (x_return_status);

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');
3038: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3039: WSH_UTIL_CORE.add_message (x_return_status);
3040: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3041: p_data => x_msg_data );
3042: --
3043: -- Debug Statements

Line 3172: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

3168: FND_MSG_PUB.initialize;
3169: END IF;
3170:
3171: -- initialize API return status to success
3172: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
3173:
3174: -- call FND_REQUEST.SUBMIT_REQUEST to run the WSHRDPAK.rdf report
3175: l_conc_request_id := FND_REQUEST.SUBMIT_REQUEST
3176: ( 'WSH'

Line 3221: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 3234: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.g_exc_unexpected_error THEN
3234: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3235: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3236: p_data => x_msg_data );
3237: --
3238: -- Debug Statements

Line 3250: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3246: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3247: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3248: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3249: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3250: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3251: WSH_UTIL_CORE.add_message (x_return_status);
3252: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3253: p_data => x_msg_data );
3254: --

Line 3251: WSH_UTIL_CORE.add_message (x_return_status);

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

Line 3372: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

3368: FND_MSG_PUB.initialize;
3369: END IF;
3370:
3371: -- initialize API return status to success
3372: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
3373:
3374: -- initially l_cum_qty=0
3375: l_cum_qty :=0;
3376:

Line 3488: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 3502: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

Line 3520: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

Line 3521: WSH_UTIL_CORE.add_message (x_return_status);

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

Line 3626: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

3622: FND_MSG_PUB.initialize;
3623: END IF;
3624:
3625: -- initialize API return status to success
3626: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
3627:
3628:
3629: UPDATE wsh_document_instances
3630: SET status = 'CANCELLED'

Line 3655: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 3669: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_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:
3673: --

Line 3687: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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');
3687: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3688: WSH_UTIL_CORE.add_message (x_return_status);
3689: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3690: p_data => x_msg_data );
3691: --

Line 3688: WSH_UTIL_CORE.add_message (x_return_status);

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');
3687: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3688: WSH_UTIL_CORE.add_message (x_return_status);
3689: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3690: p_data => x_msg_data );
3691: --
3692: -- Debug Statements

Line 3830: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

3826: FND_MSG_PUB.initialize;
3827: END IF;
3828:
3829: -- initialize API return status to success
3830: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
3831:
3832: -- Initialize the table
3833: --
3834: -- Debug Statements

Line 3902: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

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

Line 3915: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3912: END IF;
3913: --
3914: WHEN FND_API.g_exc_unexpected_error THEN
3915: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3916: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3917: p_data => x_msg_data );
3918:
3919: --

Line 3932: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

3928: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3929: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3930: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3931: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3932: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3933: WSH_UTIL_CORE.add_message (x_return_status);
3934: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3935: p_data => x_msg_data );
3936: --

Line 3933: WSH_UTIL_CORE.add_message (x_return_status);

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

Line 4363: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

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

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

Line 4426: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 4439: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 4442: wsh_util_core.get_org_name(p_organization_id));

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

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

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

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

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