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 1173: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_CATEGORY_MISSING');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1743: END IF;
1744:
1745: ROLLBACK to WSH_Document_PVT;
1746: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
1747: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
1748: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
1749: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
1750: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1751: WSH_UTIL_CORE.add_message (x_return_status);

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

1744:
1745: ROLLBACK to WSH_Document_PVT;
1746: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
1747: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
1748: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
1749: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

1745: ROLLBACK to WSH_Document_PVT;
1746: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
1747: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
1748: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
1749: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

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

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

2096: END IF;
2097: --
2098: WHEN others THEN
2099: ROLLBACK to WSH_Document_PVT;
2100: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2101: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2104: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

2097: --
2098: WHEN others THEN
2099: ROLLBACK to WSH_Document_PVT;
2100: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2101: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2104: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2105: WSH_UTIL_CORE.add_message (x_return_status);

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

2098: WHEN others THEN
2099: ROLLBACK to WSH_Document_PVT;
2100: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2101: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

2099: ROLLBACK to WSH_Document_PVT;
2100: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2101: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2102: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2103: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

2424: END IF;
2425: --
2426: WHEN others THEN
2427: ROLLBACK to WSH_Document_PVT;
2428: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2429: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2432: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

2425: --
2426: WHEN others THEN
2427: ROLLBACK to WSH_Document_PVT;
2428: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2429: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2432: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2433: WSH_UTIL_CORE.add_message (x_return_status);

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

2426: WHEN others THEN
2427: ROLLBACK to WSH_Document_PVT;
2428: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2429: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

2427: ROLLBACK to WSH_Document_PVT;
2428: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2429: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2430: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2431: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

2727: END IF;
2728: --
2729: WHEN others THEN
2730: ROLLBACK to WSH_Document_PVT;
2731: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2732: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2735: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

2728: --
2729: WHEN others THEN
2730: ROLLBACK to WSH_Document_PVT;
2731: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2732: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
2735: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2736: WSH_UTIL_CORE.add_message (x_return_status);

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

2729: WHEN others THEN
2730: ROLLBACK to WSH_Document_PVT;
2731: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2732: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

2730: ROLLBACK to WSH_Document_PVT;
2731: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
2732: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
2733: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
2734: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

3031: END IF;
3032: --
3033: WHEN others THEN
3034: ROLLBACK to WSH_Document_PVT;
3035: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3036: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3039: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

3032: --
3033: WHEN others THEN
3034: ROLLBACK to WSH_Document_PVT;
3035: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3036: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3039: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3040: WSH_UTIL_CORE.add_message (x_return_status);

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

3033: WHEN others THEN
3034: ROLLBACK to WSH_Document_PVT;
3035: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3036: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

3034: ROLLBACK to WSH_Document_PVT;
3035: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3036: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3037: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3038: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3680: END IF;
3681: --
3682: WHEN others THEN
3683: ROLLBACK to WSH_Document_PVT;
3684: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3685: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3688: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

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

3681: --
3682: WHEN others THEN
3683: ROLLBACK to WSH_Document_PVT;
3684: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3685: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
3688: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3689: WSH_UTIL_CORE.add_message (x_return_status);

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

3682: WHEN others THEN
3683: ROLLBACK to WSH_Document_PVT;
3684: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3685: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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,

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

3683: ROLLBACK to WSH_Document_PVT;
3684: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');
3685: FND_MESSAGE.set_token ('PACKAGE',g_pkg_name);
3686: FND_MESSAGE.set_token ('ORA_ERROR',to_char(sqlcode));
3687: FND_MESSAGE.set_token ('ORA_TEXT','Failure in performing action');
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 );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4442: FND_MESSAGE.Set_Token('ORGANIZATION_CODE',

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