821: -- if still null and its required then raise appropriate error
822: IF (l_argument(l_arg_cnt) IS NULL) AND l_arg_required_flag = 'Y' THEN
823: IF l_arg_value = 'UNSUPPORTED' THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: fnd_message.set_name('WSH', 'WSH_UNSUPPORTED_ARG');
826: -- bug 2389744
827: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
828: fnd_message.set_token('ARGUMENT',l_arg_name);
829: -- bug 2389744
823: IF l_arg_value = 'UNSUPPORTED' THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: fnd_message.set_name('WSH', 'WSH_UNSUPPORTED_ARG');
826: -- bug 2389744
827: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
828: fnd_message.set_token('ARGUMENT',l_arg_name);
829: -- bug 2389744
830: wsh_util_core.add_message(x_return_status);
831:
824: x_return_status := fnd_api.g_ret_sts_error;
825: fnd_message.set_name('WSH', 'WSH_UNSUPPORTED_ARG');
826: -- bug 2389744
827: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
828: fnd_message.set_token('ARGUMENT',l_arg_name);
829: -- bug 2389744
830: wsh_util_core.add_message(x_return_status);
831:
832: ELSE
830: wsh_util_core.add_message(x_return_status);
831:
832: ELSE
833: x_return_status := fnd_api.g_ret_sts_error;
834: fnd_message.set_name('WSH', 'WSH_NULL_ARG_IN_DOC');
835: --bug 1633386
836: fnd_message.set_token('ARGUMENT',l_arg_name);
837: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
838: --bug 1633386
832: ELSE
833: x_return_status := fnd_api.g_ret_sts_error;
834: fnd_message.set_name('WSH', 'WSH_NULL_ARG_IN_DOC');
835: --bug 1633386
836: fnd_message.set_token('ARGUMENT',l_arg_name);
837: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
838: --bug 1633386
839: wsh_util_core.add_message(x_return_status);
840:
833: x_return_status := fnd_api.g_ret_sts_error;
834: fnd_message.set_name('WSH', 'WSH_NULL_ARG_IN_DOC');
835: --bug 1633386
836: fnd_message.set_token('ARGUMENT',l_arg_name);
837: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
838: --bug 1633386
839: wsh_util_core.add_message(x_return_status);
840:
841: END IF;
911: END IF;
912: --
913: l_valid_params := FALSE;
914: x_return_status := wsh_util_core.g_ret_sts_warning;
915: fnd_message.set_name('WSH', 'WSH_NO_CRITERIA_FOR_DOC');
916: fnd_message.set_token('DOCUMENT_NAME',l_user_concurrent_program_name);
917: wsh_util_core.add_message(x_return_status);
918: END IF;
919: END IF;
912: --
913: l_valid_params := FALSE;
914: x_return_status := wsh_util_core.g_ret_sts_warning;
915: fnd_message.set_name('WSH', 'WSH_NO_CRITERIA_FOR_DOC');
916: fnd_message.set_token('DOCUMENT_NAME',l_user_concurrent_program_name);
917: wsh_util_core.add_message(x_return_status);
918: END IF;
919: END IF;
920:
1147:
1148: IF l_bol_count = 0 THEN
1149:
1150: IF l_ship_method_code IS NULL THEN
1151: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
1152: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1153: x_return_status := wsh_util_core.g_ret_sts_error;
1154: wsh_util_core.add_message(x_return_status);
1155: IF l_debug_on THEN
1148: IF l_bol_count = 0 THEN
1149:
1150: IF l_ship_method_code IS NULL THEN
1151: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
1152: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1153: x_return_status := wsh_util_core.g_ret_sts_error;
1154: wsh_util_core.add_message(x_return_status);
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);
1163: -- LE Uptake
1164: OPEN c_get_ledger_id(l_delivery_id);
1165: FETCH c_get_ledger_id INTO l_ledger_id;
1166: IF c_get_ledger_id%NOTFOUND THEN
1167: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1169: wsh_util_core.add_message(x_return_status);
1170: IF c_get_delivery_info%ISOPEN THEN
1171: CLOSE c_get_delivery_info;
1232: WSH_DEBUG_SV.logmsg(l_module_name,'l_ledger_id = '||l_ledger_id);
1233: END IF;
1234:
1235: IF m_get_ledger_id%NOTFOUND THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1238: wsh_util_core.add_message(x_return_status);
1239: RAISE wsh_create_document_error;
1240: END IF;
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1320: END IF;
1321: --
1322: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1323: fnd_message.set_token('CONC_PROG_NAME', document.user_concurrent_program_name);
1324: x_return_status := wsh_util_core.g_ret_sts_error;
1325: wsh_util_core.add_message(x_return_status);
1326: END IF; --} If template_code is not null
1319: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1320: END IF;
1321: --
1322: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1323: fnd_message.set_token('CONC_PROG_NAME', document.user_concurrent_program_name);
1324: x_return_status := wsh_util_core.g_ret_sts_error;
1325: wsh_util_core.add_message(x_return_status);
1326: END IF; --} If template_code is not null
1327: END IF; --} If l_output_file_type = 'XML'
1399: declare
1400: msg_buffer varchar2(2000);
1401: begin
1402:
1403: msg_buffer := fnd_message.get;
1404:
1405: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1406: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1407: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1401: begin
1402:
1403: msg_buffer := fnd_message.get;
1404:
1405: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1406: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1407: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1408: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1409:
1402:
1403: msg_buffer := fnd_message.get;
1404:
1405: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1406: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1407: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1408: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1409:
1410: wsh_util_core.add_message(x_return_status);
1403: msg_buffer := fnd_message.get;
1404:
1405: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1406: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1407: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1408: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1409:
1410: wsh_util_core.add_message(x_return_status);
1411:
1404:
1405: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1406: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1407: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1408: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1409:
1410: wsh_util_core.add_message(x_return_status);
1411:
1412: end;
1571: ELSE
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1574: END IF;
1575: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1576: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1577: x_return_status := wsh_util_core.g_ret_sts_error;
1578: wsh_util_core.add_message(x_return_status);
1579: END IF; --} l_template_code is not null
1572: IF l_debug_on THEN
1573: WSH_DEBUG_SV.logmsg(l_module_name, 'No template was specified for this report. Hence could not generate the pdf output' );
1574: END IF;
1575: fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1576: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1577: x_return_status := wsh_util_core.g_ret_sts_error;
1578: wsh_util_core.add_message(x_return_status);
1579: END IF; --} l_template_code is not null
1580: END IF; --} l_output_file_type = 'XML'
1654: declare
1655: msg_buffer varchar2(2000);
1656: begin
1657:
1658: msg_buffer := fnd_message.get;
1659:
1660: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1661: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1662: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1656: begin
1657:
1658: msg_buffer := fnd_message.get;
1659:
1660: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1661: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1662: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1663: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1664:
1657:
1658: msg_buffer := fnd_message.get;
1659:
1660: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1661: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1662: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1663: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1664:
1665: wsh_util_core.add_message(x_return_status);
1658: msg_buffer := fnd_message.get;
1659:
1660: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1661: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1662: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1663: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1664:
1665: wsh_util_core.add_message(x_return_status);
1666:
1659:
1660: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_DOC_SET_FAILED');
1661: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1662: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1663: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1664:
1665: wsh_util_core.add_message(x_return_status);
1666:
1667: end;
1689: -- probably because there werent any in the set (but may have had problems
1690: -- in fnd_request function
1691:
1692: x_return_status := fnd_api.g_ret_sts_error;
1693: fnd_message.set_name('WSH','WSH_NO_DOCS');
1694: wsh_util_core.add_message(x_return_status);
1695:
1696: ELSE
1697: -- everthing worked: any documents not submitted resulted
1704: WSH_DEBUG_SV.logmsg(l_module_name, 'SUBMITTED ' || TO_CHAR ( L_SUBMITTED_DOCS ) || ' OUT OF ' || TO_CHAR ( L_TOTAL_DOCS ) );
1705: END IF;
1706: --
1707:
1708: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1709: fnd_message.set_token('SUBMITTED_DOCS', l_submitted_docs);
1710: fnd_message.set_token('TOTAL_DOCS', l_total_docs);
1711: fnd_message.set_token('REQ_IDS', l_req_id_str);
1712: wsh_util_core.add_message(x_return_status);
1705: END IF;
1706: --
1707:
1708: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1709: fnd_message.set_token('SUBMITTED_DOCS', l_submitted_docs);
1710: fnd_message.set_token('TOTAL_DOCS', l_total_docs);
1711: fnd_message.set_token('REQ_IDS', l_req_id_str);
1712: wsh_util_core.add_message(x_return_status);
1713: END IF; --}
1706: --
1707:
1708: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1709: fnd_message.set_token('SUBMITTED_DOCS', l_submitted_docs);
1710: fnd_message.set_token('TOTAL_DOCS', l_total_docs);
1711: fnd_message.set_token('REQ_IDS', l_req_id_str);
1712: wsh_util_core.add_message(x_return_status);
1713: END IF; --}
1714:
1707:
1708: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1709: fnd_message.set_token('SUBMITTED_DOCS', l_submitted_docs);
1710: fnd_message.set_token('TOTAL_DOCS', l_total_docs);
1711: fnd_message.set_token('REQ_IDS', l_req_id_str);
1712: wsh_util_core.add_message(x_return_status);
1713: END IF; --}
1714:
1715: END LOOP; -- for loop
1723: WSH_DEBUG_SV.logmsg(l_module_name, 'NO REPORTS TO PROCESS' );
1724: END IF;
1725: --
1726: x_return_status := fnd_api.g_ret_sts_error;
1727: fnd_message.set_name('WSH','WSH_NO_REPORT_TO_PROCESS');
1728: wsh_util_core.add_message(x_return_status);
1729:
1730: WHEN No_Org_For_Entity THEN
1731: --
1735: WSH_DEBUG_SV.logmsg(l_module_name, 'NO ORGANIZATION FOUND FOR ENTITY' );
1736: END IF;
1737: --
1738: x_return_status := wsh_util_core.g_ret_sts_error;
1739: fnd_message.set_name('WSH','WSH_NO_ENTITY_ORG');
1740: wsh_util_core.add_message(x_return_status);
1741:
1742: WHEN wsh_create_document_error THEN
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1740: wsh_util_core.add_message(x_return_status);
1741:
1742: WHEN wsh_create_document_error THEN
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: -- FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CREATE_DOCUMENT_ERROR');
1745: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1746:
1747: --
1748: -- Debug Statements