eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DOCUMENT_PVT dependencies on FND_MESSAGE

Line 290: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

286: FETCH delivery_leg_csr INTO l_delivery_leg_id;
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;

Line 453: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');

449: FETCH type_csr INTO type_rec;
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

Line 515: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

511: --
512: RETURN null;
513:
514: WHEN others THEN
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;

Line 516: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

512: RETURN null;
513:
514: WHEN others THEN
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);

Line 517: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

513:
514: WHEN others THEN
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: --

Line 518: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

514: WHEN others THEN
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

Line 688: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

684: --
685: RETURN null;
686:
687: WHEN others THEN
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;

Line 689: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

685: RETURN null;
686:
687: WHEN others THEN
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);

Line 690: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

686:
687: WHEN others THEN
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: --

Line 691: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

687: WHEN others THEN
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

Line 868: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

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');
872: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 869: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
872: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
873: WSH_UTIL_CORE.add_message (x_return_status);

Line 870: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 871: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 1172: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_CATEGORY_MISSING');

1168: FETCH category_csr INTO category_rec;
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;

Line 1187: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');

1183: OPEN assignment_csr(category_rec.category_code);
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;

Line 1232: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

1228: FETCH delivery_csr INTO delivery_rec;
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;

Line 1255: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

1251: l_delivery_id_tab(l_table_count+1) := l_delivery_id;
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:

Line 1349: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');

1345: , docseq_id => l_sequence_id );
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:

Line 1570: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');

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

Line 1691: FND_MESSAGE.SET_NAME('WSH',' WSH_DLVY_DEL_LEG_LOCK');

1687: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
1688: WHERE wnd.delivery_id = wdl.delivery_id
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:

Line 1692: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);

1688: WHERE wnd.delivery_id = wdl.delivery_id
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,

Line 1745: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

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');
1749: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 1746: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
1749: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1750: WSH_UTIL_CORE.add_message (x_return_status);

Line 1747: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 1748: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 1990: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

1986: l_delivery_id_tab(l_table_count+1) := l_delivery_id;
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:

Line 2025: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');

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

Line 2032: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

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

Line 2099: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_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');
2103: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 2100: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
2103: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2104: WSH_UTIL_CORE.add_message (x_return_status);

Line 2101: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 2102: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 2315: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

2311: l_delivery_id_tab(l_table_count+1) := l_delivery_id;
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:

Line 2350: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');

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

Line 2427: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_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');
2431: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 2428: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
2431: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2432: WSH_UTIL_CORE.add_message (x_return_status);

Line 2429: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 2430: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 2631: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

2627: l_delivery_id_tab(l_table_count+1) := l_delivery_id;
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:

Line 2666: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');

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

Line 2730: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_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');
2734: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 2731: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
2734: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2735: WSH_UTIL_CORE.add_message (x_return_status);

Line 2732: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 2733: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 2935: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');

2931: l_delivery_id_tab(l_table_count+1) := l_delivery_id;
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:

Line 2970: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');

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

Line 3034: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_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');
3038: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3035: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
3038: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3039: WSH_UTIL_CORE.add_message (x_return_status);

Line 3036: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 3037: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 3246: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3243: END IF;
3244: --
3245: WHEN others THEN
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;

Line 3247: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

3243: END IF;
3244: --
3245: WHEN others THEN
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);

Line 3248: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

3244: --
3245: WHEN others THEN
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,

Line 3249: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

3245: WHEN others THEN
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 );

Line 3516: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

3512: --
3513: RETURN null;
3514:
3515: WHEN others THEN
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;

Line 3517: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

3513: RETURN null;
3514:
3515: WHEN others THEN
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);

Line 3518: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

3514:
3515: WHEN others THEN
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: --

Line 3519: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

3515: WHEN others THEN
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

Line 3683: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_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');
3687: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3684: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

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');
3687: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3688: WSH_UTIL_CORE.add_message (x_return_status);

Line 3685: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

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

Line 3686: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

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

Line 3928: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

3924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3925: END IF;
3926: --
3927: WHEN others THEN
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;

Line 3929: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);

3925: END IF;
3926: --
3927: WHEN others THEN
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);

Line 3930: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));

3926: --
3927: WHEN others THEN
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,

Line 3931: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');

3927: WHEN others THEN
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 );

Line 4182: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');

4178: FETCH lock_csr INTO lock_rec;
4179: IF lock_csr%NOTFOUND
4180: THEN
4181: CLOSE lock_csr;
4182: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
4183: APP_EXCEPTION.raise_exception;
4184: END IF;
4185: CLOSE lock_csr;
4186:

Line 4284: FND_MESSAGE.set_name('FND','FORM_RECORD_CHANGED');

4280: END IF;
4281: --
4282: return;
4283: ELSE
4284: FND_MESSAGE.set_name('FND','FORM_RECORD_CHANGED');
4285: APP_EXCEPTION.raise_exception;
4286: END IF;
4287:
4288: --

Line 4440: FND_MESSAGE.Set_Name('WSH', 'WSH_PARAM_NOT_DEFINED');

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

Line 4441: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',

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);
4444:
4445: --