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 860: wsh_util_core.add_message(x_return_status);

856: -- bug 2389744
857: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
858: fnd_message.set_token('ARGUMENT',l_arg_name);
859: -- bug 2389744
860: wsh_util_core.add_message(x_return_status);
861:
862: ELSE
863: x_return_status := fnd_api.g_ret_sts_error;
864: fnd_message.set_name('WSH', 'WSH_NULL_ARG_IN_DOC');

Line 869: wsh_util_core.add_message(x_return_status);

865: --bug 1633386
866: fnd_message.set_token('ARGUMENT',l_arg_name);
867: fnd_message.set_token('DOCUMENT',l_user_concurrent_program_name);
868: --bug 1633386
869: wsh_util_core.add_message(x_return_status);
870:
871: END IF;
872: -- set error_flags to stop processing this document
873: l_valid_params := FALSE;

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

871: END IF;
872: -- set error_flags to stop processing this document
873: l_valid_params := FALSE;
874: l_error_in_a_doc := TRUE;
875: wsh_util_core.PrintMsg('The document ' || l_concurrent_program_name || ' cannot be generated' ||
876: ' because argument ' || l_arg_name || ' is not supported or has null value');
877: END IF;
878:
879: IF l_parameter_name IN

Line 944: x_return_status := wsh_util_core.g_ret_sts_warning;

940: WSH_DEBUG_SV.logmsg(l_module_name, 'THE DOCUMENT ' || L_CONCURRENT_PROGRAM_NAME || ' DOES NOT HAVE A PARAM SPECIFIED.' );
941: END IF;
942: --
943: l_valid_params := FALSE;
944: x_return_status := wsh_util_core.g_ret_sts_warning;
945: fnd_message.set_name('WSH', 'WSH_NO_CRITERIA_FOR_DOC');
946: fnd_message.set_token('DOCUMENT_NAME',l_user_concurrent_program_name);
947: wsh_util_core.add_message(x_return_status);
948: END IF;

Line 947: wsh_util_core.add_message(x_return_status);

943: l_valid_params := FALSE;
944: x_return_status := wsh_util_core.g_ret_sts_warning;
945: fnd_message.set_name('WSH', 'WSH_NO_CRITERIA_FOR_DOC');
946: fnd_message.set_token('DOCUMENT_NAME',l_user_concurrent_program_name);
947: wsh_util_core.add_message(x_return_status);
948: END IF;
949: END IF;
950:
951: IF l_valid_params THEN --{

Line 1079: wsh_util_core.add_message(x_return_status);

1075: IF x_return_status IN ( fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error ) THEN
1076: IF l_debug_on THEN --{
1077: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status );
1078: END IF; --}
1079: wsh_util_core.add_message(x_return_status);
1080: END IF;
1081: IF l_debug_on THEN --{
1082: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1083: END IF; --}

Line 1116: wsh_util_core.add_message(x_return_status);

1112: IF l_debug_on THEN --{
1113:
1114: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1115: END IF; --}
1116: wsh_util_core.add_message(x_return_status);
1117: raise no_data_found ;
1118: end if;
1119: ELSE
1120: -- Exit loop since all nls requests are submitted

Line 1140: WSH_UTIL_CORE.api_post_call(

1136: p_trip_id => l_argument(1),
1137: x_sequence_number => l_document_number,
1138: x_return_status => l_return_status );
1139:
1140: WSH_UTIL_CORE.api_post_call(
1141: p_return_status => l_return_status,
1142: x_num_warnings => l_num_warning,
1143: x_num_errors => l_num_errors,
1144: p_raise_error_flag => FALSE );

Line 1158: WSH_UTIL_CORE.api_post_call(

1154: WSH_MBOLS_PVT.Generate_BOLs(
1155: p_trip_id => l_argument(6),
1156: x_return_status => l_return_status );
1157:
1158: WSH_UTIL_CORE.api_post_call(
1159: p_return_status => l_return_status,
1160: x_num_warnings => l_num_warning,
1161: x_num_errors => l_num_errors,
1162: p_raise_error_flag => FALSE );

Line 1193: x_return_status := wsh_util_core.g_ret_sts_error;

1189:
1190: IF l_ship_method_code IS NULL THEN
1191: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
1192: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1193: x_return_status := wsh_util_core.g_ret_sts_error;
1194: wsh_util_core.add_message(x_return_status);
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);
1197: END IF;

Line 1194: wsh_util_core.add_message(x_return_status);

1190: IF l_ship_method_code IS NULL THEN
1191: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NULL_SHIP_METHOD_ERROR');
1192: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
1193: x_return_status := wsh_util_core.g_ret_sts_error;
1194: wsh_util_core.add_message(x_return_status);
1195: IF l_debug_on THEN
1196: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status for BOL = '||x_return_status);
1197: END IF;
1198: IF c_get_delivery_info%ISOPEN THEN

Line 1208: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1204: OPEN c_get_ledger_id(l_delivery_id);
1205: FETCH c_get_ledger_id INTO l_ledger_id;
1206: IF c_get_ledger_id%NOTFOUND THEN
1207: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1208: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1209: wsh_util_core.add_message(x_return_status);
1210: IF c_get_delivery_info%ISOPEN THEN
1211: CLOSE c_get_delivery_info;
1212: END IF;

Line 1209: wsh_util_core.add_message(x_return_status);

1205: FETCH c_get_ledger_id INTO l_ledger_id;
1206: IF c_get_ledger_id%NOTFOUND THEN
1207: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1208: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1209: wsh_util_core.add_message(x_return_status);
1210: IF c_get_delivery_info%ISOPEN THEN
1211: CLOSE c_get_delivery_info;
1212: END IF;
1213: RAISE wsh_create_document_error;

Line 1238: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1234: , p_consolidate_option => 'BOTH'
1235: , p_manual_sequence_number => 200
1236: , x_document_number => l_document_number);
1237:
1238: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1239: IF c_get_delivery_info%ISOPEN THEN
1240: CLOSE c_get_delivery_info;
1241: END IF;
1242: RAISE wsh_create_document_error;

Line 1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1273: END IF;
1274:
1275: IF m_get_ledger_id%NOTFOUND THEN
1276: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: wsh_util_core.add_message(x_return_status);
1279: RAISE wsh_create_document_error;
1280: END IF;
1281:

Line 1278: wsh_util_core.add_message(x_return_status);

1274:
1275: IF m_get_ledger_id%NOTFOUND THEN
1276: FND_MESSAGE.SET_NAME('WSH','WSH_LEDGER_ID_NOT_FOUND');
1277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: wsh_util_core.add_message(x_return_status);
1279: RAISE wsh_create_document_error;
1280: END IF;
1281:
1282: IF m_get_ledger_id%ISOPEN THEN

Line 1305: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1301: , p_consolidate_option => 'BOTH'
1302: , p_manual_sequence_number => 200
1303: , x_document_number => l_document_number);
1304:
1305: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1306: RAISE wsh_create_document_error;
1307: END IF;
1308:
1309: END IF;

Line 1411: wsh_util_core.add_message(x_return_status);

1407: ELSE
1408: IF l_debug_on THEN
1409: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1410: END IF;
1411: wsh_util_core.add_message(x_return_status);
1412: END IF;
1413: --}
1414: ELSE
1415: --{

Line 1423: x_return_status := wsh_util_core.g_ret_sts_error;

1419: --
1420: --Bug 9255258 continue with report submission.
1421: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1422: fnd_message.set_token('CONC_PROG_NAME', document.user_concurrent_program_name);
1423: x_return_status := wsh_util_core.g_ret_sts_error;
1424: wsh_util_core.add_message(x_return_status);*/
1425: l_print_pdf := 'Y';
1426: END IF; --} If template_code is not null
1427: END IF; --} If l_output_file_type = 'XML'

Line 1424: wsh_util_core.add_message(x_return_status);*/

1420: --Bug 9255258 continue with report submission.
1421: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1422: fnd_message.set_token('CONC_PROG_NAME', document.user_concurrent_program_name);
1423: x_return_status := wsh_util_core.g_ret_sts_error;
1424: wsh_util_core.add_message(x_return_status);*/
1425: l_print_pdf := 'Y';
1426: END IF; --} If template_code is not null
1427: END IF; --} If l_output_file_type = 'XML'
1428:

Line 1510: wsh_util_core.add_message(x_return_status);

1506: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1507: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1508: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1509:
1510: wsh_util_core.add_message(x_return_status);
1511:
1512: end;
1513: end if;--}
1514:

Line 1594: wsh_util_core.add_message(x_return_status);

1590: IF l_debug_on THEN --{
1591: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from Get_NLS_Lang :'||x_return_status
1592: );
1593: END IF; --}
1594: wsh_util_core.add_message(x_return_status);
1595: END IF;
1596: IF l_debug_on THEN --{
1597: WSH_DEBUG_SV.logmsg(l_module_name, 'Number of NLS languages :'||l_nls_lang.COUNT );
1598: END IF; --}

Line 1635: wsh_util_core.add_message(x_return_status);

1631: numeric_characters => l_numeric_characters)) then
1632: IF l_debug_on THEN --{
1633: WSH_DEBUG_SV.logmsg(l_module_name, 'fnd_request.set_options returned false');
1634: END IF; --}
1635: wsh_util_core.add_message(x_return_status);
1636: raise no_data_found ;
1637: end if;
1638: ELSE
1639: -- Exit loop since all nls requests are submitted

Line 1744: wsh_util_core.add_message(x_return_status);

1740: ELSE
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.logmsg(l_module_name, 'Error returning from fnd_request.add_layout :'||x_return_status);
1743: END IF;
1744: wsh_util_core.add_message(x_return_status);
1745: END IF;
1746: --}
1747: ELSE
1748: IF l_debug_on THEN

Line 1754: x_return_status := wsh_util_core.g_ret_sts_error;

1750: END IF;
1751: --Bug 9255258 continue with report submission.
1752: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1753: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1754: x_return_status := wsh_util_core.g_ret_sts_error;
1755: wsh_util_core.add_message(x_return_status);*/
1756: l_print_pdf := 'Y';
1757: END IF; --} l_template_code is not null
1758: END IF; --} l_output_file_type = 'XML'

Line 1755: wsh_util_core.add_message(x_return_status);*/

1751: --Bug 9255258 continue with report submission.
1752: /*fnd_message.set_name('WSH', 'WSH_NO_DEFAULT_TEMPLATE');
1753: fnd_message.set_token('CONC_PROG_NAME', document.concurrent_program_name);
1754: x_return_status := wsh_util_core.g_ret_sts_error;
1755: wsh_util_core.add_message(x_return_status);*/
1756: l_print_pdf := 'Y';
1757: END IF; --} l_template_code is not null
1758: END IF; --} l_output_file_type = 'XML'
1759:

Line 1843: wsh_util_core.add_message(x_return_status);

1839: FND_MESSAGE.SET_TOKEN('RELEASE_TYPE', entity_type);
1840: FND_MESSAGE.SET_TOKEN('NAME', entity_name);
1841: FND_MESSAGE.SET_TOKEN('UNDERLYING_ERROR', msg_buffer);
1842:
1843: wsh_util_core.add_message(x_return_status);
1844:
1845: end;
1846: end if;--}
1847:

Line 1880: wsh_util_core.add_message(x_return_status);

1876: -- in fnd_request function
1877:
1878: x_return_status := fnd_api.g_ret_sts_error;
1879: fnd_message.set_name('WSH','WSH_NO_DOCS');
1880: wsh_util_core.add_message(x_return_status);
1881:
1882: ELSE
1883: -- everthing worked: any documents not submitted resulted
1884: -- from problem in fnd_request

Line 1898: wsh_util_core.add_message(x_return_status);

1894: fnd_message.set_name('WSH', 'WSH_DOCS_SUBMITTED');
1895: fnd_message.set_token('SUBMITTED_DOCS', l_submitted_docs);
1896: fnd_message.set_token('TOTAL_DOCS', l_total_docs);
1897: fnd_message.set_token('REQ_IDS', l_req_id_str);
1898: wsh_util_core.add_message(x_return_status);
1899: END IF; --}
1900:
1901: END LOOP; -- for loop
1902:

Line 1914: wsh_util_core.add_message(x_return_status);

1910: END IF;
1911: --
1912: x_return_status := fnd_api.g_ret_sts_error;
1913: fnd_message.set_name('WSH','WSH_NO_REPORT_TO_PROCESS');
1914: wsh_util_core.add_message(x_return_status);
1915:
1916: WHEN No_Org_For_Entity THEN
1917: --
1918: -- Debug Statements

Line 1924: x_return_status := wsh_util_core.g_ret_sts_error;

1920: IF l_debug_on THEN
1921: WSH_DEBUG_SV.logmsg(l_module_name, 'NO ORGANIZATION FOUND FOR ENTITY' );
1922: END IF;
1923: --
1924: x_return_status := wsh_util_core.g_ret_sts_error;
1925: fnd_message.set_name('WSH','WSH_NO_ENTITY_ORG');
1926: wsh_util_core.add_message(x_return_status);
1927:
1928: WHEN wsh_create_document_error THEN

Line 1926: wsh_util_core.add_message(x_return_status);

1922: END IF;
1923: --
1924: x_return_status := wsh_util_core.g_ret_sts_error;
1925: fnd_message.set_name('WSH','WSH_NO_ENTITY_ORG');
1926: wsh_util_core.add_message(x_return_status);
1927:
1928: WHEN wsh_create_document_error THEN
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930: -- FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CREATE_DOCUMENT_ERROR');

Line 1931: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1927:
1928: WHEN wsh_create_document_error THEN
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930: -- FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CREATE_DOCUMENT_ERROR');
1931: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1932:
1933: --
1934: -- Debug Statements
1935: --

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

1937: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');
1939: END IF;
1940: WHEN OTHERS THEN
1941: wsh_util_core.default_handler('WSH_UTIL_CORE.PRINT_DOCUMENT_SETS');
1942: x_return_status := fnd_api.g_ret_sts_unexp_error;
1943: END;
1944: --
1945: -- Debug Statements