DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_SETS dependencies on WSH_UTIL_CORE

Line 43: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,

39: --
40: PROCEDURE Print_Document_Sets
41: (p_report_set_id IN NUMBER,
42: p_organization_id IN NUMBER,
43: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
44: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
45: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
46: p_document_param_info IN WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE,
47: x_return_status IN OUT NOCOPY VARCHAR2)

Line 44: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,

40: PROCEDURE Print_Document_Sets
41: (p_report_set_id IN NUMBER,
42: p_organization_id IN NUMBER,
43: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
44: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
45: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
46: p_document_param_info IN WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE,
47: x_return_status IN OUT NOCOPY VARCHAR2)
48: IS

Line 45: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,

41: (p_report_set_id IN NUMBER,
42: p_organization_id IN NUMBER,
43: p_trip_ids IN WSH_UTIL_CORE.Id_Tab_Type,
44: p_stop_ids IN WSH_UTIL_CORE.Id_Tab_Type,
45: p_delivery_ids IN WSH_UTIL_CORE.Id_Tab_Type,
46: p_document_param_info IN WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE,
47: x_return_status IN OUT NOCOPY VARCHAR2)
48: IS
49:

Line 830: wsh_util_core.add_message(x_return_status);

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
833: x_return_status := fnd_api.g_ret_sts_error;
834: fnd_message.set_name('WSH', 'WSH_NULL_ARG_IN_DOC');

Line 839: wsh_util_core.add_message(x_return_status);

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;
842: -- set error_flags to stop processing this document
843: l_valid_params := FALSE;

Line 845: wsh_util_core.PrintMsg('The document ' || l_concurrent_program_name || ' cannot be generated' ||

841: END IF;
842: -- set error_flags to stop processing this document
843: l_valid_params := FALSE;
844: l_error_in_a_doc := TRUE;
845: wsh_util_core.PrintMsg('The document ' || l_concurrent_program_name || ' cannot be generated' ||
846: ' because argument ' || l_arg_name || ' is not supported or has null value');
847: END IF;
848:
849: IF l_parameter_name IN

Line 914: x_return_status := wsh_util_core.g_ret_sts_warning;

910: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' DOES NOT HAVE A PARAM SPECIFIED.' );
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;

Line 917: wsh_util_core.add_message(x_return_status);

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:
921: IF l_valid_params THEN --{

Line 1049: wsh_util_core.add_message(x_return_status);

1045: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1046: IF l_debug_on THEN --{
1047: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status );
1048: END IF; --}
1049: wsh_util_core.add_message(x_return_status);
1050: END IF;
1051: IF l_debug_on THEN --{
1052: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1053: END IF; --}

Line 1076: wsh_util_core.add_message(x_return_status);

1072: territory => l_nls_lang(l_nls_count).nls_territory)) then
1073: IF l_debug_on THEN --{
1074: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1075: END IF; --}
1076: wsh_util_core.add_message(x_return_status);
1077: raise no_data_found ;
1078: end if;
1079: ELSE
1080: -- Exit loop since all nls requests are submitted

Line 1100: WSH_UTIL_CORE.api_post_call(

1096: p_trip_id => l_argument(1),
1097: x_sequence_number => l_document_number,
1098: x_return_status => l_return_status );
1099:
1100: WSH_UTIL_CORE.api_post_call(
1101: p_return_status => l_return_status,
1102: x_num_warnings => l_num_warning,
1103: x_num_errors => l_num_errors,
1104: p_raise_error_flag => FALSE );

Line 1118: WSH_UTIL_CORE.api_post_call(

1114: WSH_MBOLS_PVT.Generate_BOLs(
1115: p_trip_id => l_argument(6),
1116: x_return_status => l_return_status );
1117:
1118: WSH_UTIL_CORE.api_post_call(
1119: p_return_status => l_return_status,
1120: x_num_warnings => l_num_warning,
1121: x_num_errors => l_num_errors,
1122: p_raise_error_flag => FALSE );

Line 1153: x_return_status := wsh_util_core.g_ret_sts_error;

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

Line 1154: wsh_util_core.add_message(x_return_status);

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);
1157: END IF;
1158: IF c_get_delivery_info%ISOPEN THEN

Line 1168: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1169: wsh_util_core.add_message(x_return_status);

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;
1172: END IF;
1173: RAISE wsh_create_document_error;

Line 1198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1194: , p_consolidate_option => 'BOTH'
1195: , p_manual_sequence_number => 200
1196: , x_document_number => l_document_number);
1197:
1198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1199: IF c_get_delivery_info%ISOPEN THEN
1200: CLOSE c_get_delivery_info;
1201: END IF;
1202: RAISE wsh_create_document_error;

Line 1237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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;
1241:

Line 1238: wsh_util_core.add_message(x_return_status);

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;
1241:
1242: IF m_get_ledger_id%ISOPEN THEN

Line 1265: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1261: , p_consolidate_option => 'BOTH'
1262: , p_manual_sequence_number => 200
1263: , x_document_number => l_document_number);
1264:
1265: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1266: RAISE wsh_create_document_error;
1267: END IF;
1268:
1269: END IF;

Line 1313: wsh_util_core.add_message(x_return_status);

1309: ELSE
1310: IF l_debug_on THEN
1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1312: END IF;
1313: wsh_util_core.add_message(x_return_status);
1314: END IF;
1315: --}
1316: ELSE
1317: --{

Line 1324: x_return_status := wsh_util_core.g_ret_sts_error;

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'
1328:

Line 1325: wsh_util_core.add_message(x_return_status);

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'
1328:
1329: -- End of XDO Integration Changes

Line 1410: wsh_util_core.add_message(x_return_status);

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;
1413: end if;--}
1414:

Line 1486: wsh_util_core.add_message(x_return_status);

1482: IF l_debug_on THEN --{
1483: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status
1484: );
1485: END IF; --}
1486: wsh_util_core.add_message(x_return_status);
1487: END IF;
1488: IF l_debug_on THEN --{
1489: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1490: END IF; --}

Line 1518: wsh_util_core.add_message(x_return_status);

1514: territory => l_nls_lang(l_nls_count).nls_territory)) then
1515: IF l_debug_on THEN --{
1516: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1517: END IF; --}
1518: wsh_util_core.add_message(x_return_status);
1519: raise no_data_found ;
1520: end if;
1521: ELSE
1522: -- Exit loop since all nls requests are submitted

Line 1568: wsh_util_core.add_message(x_return_status);

1564: ELSE
1565: IF l_debug_on THEN
1566: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1567: END IF;
1568: wsh_util_core.add_message(x_return_status);
1569: END IF;
1570: --}
1571: ELSE
1572: IF l_debug_on THEN

Line 1577: x_return_status := wsh_util_core.g_ret_sts_error;

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'
1581:

Line 1578: wsh_util_core.add_message(x_return_status);

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'
1581:
1582: -- End of XDO Integration Changes

Line 1665: wsh_util_core.add_message(x_return_status);

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;
1668: end if;--}
1669:

Line 1694: wsh_util_core.add_message(x_return_status);

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
1698: -- from problem in fnd_request

Line 1712: wsh_util_core.add_message(x_return_status);

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

Line 1728: wsh_util_core.add_message(x_return_status);

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

Line 1738: x_return_status := wsh_util_core.g_ret_sts_error;

1734: IF l_debug_on THEN
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

Line 1740: wsh_util_core.add_message(x_return_status);

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;
1744: -- FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CREATE_DOCUMENT_ERROR');

Line 1745: -- 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
1749: --

Line 1755: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');

1751: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1753: END IF;
1754: WHEN OTHERS THEN
1755: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');
1756: x_return_status := fnd_api.g_ret_sts_unexp_error;
1757: END;
1758: --
1759: -- Debug Statements