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_INTEGRATION dependencies on FND_API

Line 8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as

4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTEGRATION';
6:
7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);

Line 11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,

7: -- Global variable holding transaction_id
8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);
13:
14:
15: G_InvPCRec InvPCRecType;

Line 12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);

8: --Bug#5104847:Assigning default value FND_API.G_MISS_NUM to trx_id and trx_temp_id as
9: -- WMS is not calling the API WSH_INTEGRATION.Set_Inv_PC_Attributes to set trx ids.
10: TYPE InvPCRecType IS RECORD
11: ( transaction_id NUMBER DEFAULT FND_API.G_MISS_NUM,
12: transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM);
13:
14:
15: G_InvPCRec InvPCRecType;
16:

Line 62: x_return_status := FND_API.G_RET_STS_ERROR;

58: IF ( p_in_attributes.source_code IS NULL )
59: THEN
60: x_msg_count := 1;
61: x_msg_data := 'INVALID SOURCE_CODE';
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: END IF;
64:
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DETAILS_VALIDATIONS.Get_Min_Max_Tolerance_Quantity');

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

118: END IF;
119:
120: EXCEPTION
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
123:
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count
126: , p_data => x_msg_data

Line 127: ,p_encoded => FND_API.G_FALSE

123:
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count
126: , p_data => x_msg_data
127: ,p_encoded => FND_API.G_FALSE
128: );
129:
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: IF ( p_in_attributes.source_code IS NULL )
197: THEN
198: x_msg_count := 1;
199: x_msg_data := 'INVALID SOURCE_CODE';
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: x_msg_data := 'INVALID SOURCE_CODE';
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:
205: l_closing_fm_date := p_in_attributes.closing_fm_date;
206: l_closing_to_date := p_in_attributes.closing_to_date;
207: l_organization_id := p_in_attributes.organization_id;

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

329: END IF;
330:
331: EXCEPTION
332: WHEN OTHERS THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data

Line 338: ,p_encoded => FND_API.G_FALSE

334:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data
338: ,p_encoded => FND_API.G_FALSE
339: );
340:
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: IF ( p_in_attributes.source_code IS NULL )
375: THEN
376: x_msg_count := 1;
377: x_msg_data := 'INVALID SOURCE_CODE';
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: x_msg_data := 'INVALID SOURCE_CODE';
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: l_line_id := p_in_attributes.line_id;
384:
385: BEGIN

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: p_out_attributes.nonintf_line_qty := l_nonintf_line_qty;
407:
408: EXCEPTION
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411:
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data

Line 415: ,p_encoded => FND_API.G_FALSE

411:
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data
415: ,p_encoded => FND_API.G_FALSE
416: );
417:
418: END Get_Nonintf_Shpg_Line_Qty;
419:

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474: WSH_DEBUG_SV.log(l_module_name,'ship_model_id',p_backorder_rec.ship_model_id);
475: END IF;
476:
477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480: -- Standard call to check for call compatibility
481: IF NOT FND_API.Compatible_API_Call
482: ( l_api_version_number

Line 481: IF NOT FND_API.Compatible_API_Call

477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480: -- Standard call to check for call compatibility
481: IF NOT FND_API.Compatible_API_Call
482: ( l_api_version_number
483: , p_api_version_number
484: , l_api_name
485: , G_PKG_NAME

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: , l_api_name
485: , G_PKG_NAME
486: )
487: THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list.
492:

Line 493: IF FND_API.to_Boolean(p_init_msg_list) THEN

489: END IF;
490:
491: -- Initialize message list.
492:
493: IF FND_API.to_Boolean(p_init_msg_list) THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497:

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: IF ( p_source_code IS NULL ) OR (p_source_code <> 'INV' ) THEN
499:
500: x_msg_count := 1;
501: x_msg_data := 'INVALID SOURCE CODE';
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: ELSIF ( p_backorder_rec.move_order_line_id IS NULL AND p_backorder_rec.delivery_detail_id IS NULL )
505: OR ( p_backorder_rec.ship_set_id IS NULL AND p_backorder_rec.ship_model_id IS NULL ) THEN
506:

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: OR ( p_backorder_rec.ship_set_id IS NULL AND p_backorder_rec.ship_model_id IS NULL ) THEN
506:
507: x_msg_count := 1;
508: x_msg_data := 'INVALID RECORD';
509: x_return_status := FND_API.G_RET_STS_ERROR;
510:
511: ELSE
512:
513: l_cnt := G_BackorderRec_Tbl.LAST;

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: WSH_DEBUG_SV.log(l_module_name,'p_printer_name',p_printer_name);
653: WSH_DEBUG_SV.log(l_module_name,'p_enabled_flag',p_enabled_flag);
654: END IF;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657: l_application_id := p_application_id;
658:
659: trace('******** Mobile Printer Sign On **********');
660:

Line 675: x_return_status := fnd_api.g_ret_sts_error;

671: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NAME_REQUIRED');
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
674: , p_data => x_msg_data );
675: x_return_status := fnd_api.g_ret_sts_error;
676: IF l_debug_on THEN
677: wsh_debug_sv.pop(l_module_name,'RETURN');
678: END IF;
679:

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NOT_SIGNON');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: , p_data => x_msg_data );
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: IF l_debug_on THEN
719: wsh_debug_sv.pop(l_module_name,'RETURN');
720: END IF;
721: RETURN;

Line 937: WHEN fnd_api.g_exc_error THEN

933: wsh_debug_sv.pop(l_module_name);
934: wsh_debug_sv.stop_debug;
935: END IF;
936: EXCEPTION
937: WHEN fnd_api.g_exc_error THEN
938: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name);
939: trace('ERROR CODE = ' || SQLCODE);
940: trace('ERROR MESSAGE = ' || SQLERRM);
941: IF l_debug_on THEN

Line 947: WHEN fnd_api.g_exc_unexpected_error THEN

943: wsh_debug_sv.stop_debug;
944: END IF;
945: ROLLBACK;
946:
947: WHEN fnd_api.g_exc_unexpected_error THEN
948: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name);
949: trace('ERROR CODE = ' || SQLCODE);
950: trace('ERROR MESSAGE = ' || SQLERRM);
951: IF l_debug_on THEN

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979: l_api_version_number CONSTANT NUMBER := 1.0;
980: l_api_name CONSTANT VARCHAR2(30):= 'Set_Inv_PC_Attributes';
981:
982: BEGIN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Standard call to check for call compatibility
986: IF NOT FND_API.Compatible_API_Call
987: ( l_api_version_number

Line 986: IF NOT FND_API.Compatible_API_Call

982: BEGIN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Standard call to check for call compatibility
986: IF NOT FND_API.Compatible_API_Call
987: ( l_api_version_number
988: , p_in_attributes.api_version_number
989: , l_api_name
990: , G_PKG_NAME

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: , l_api_name
990: , G_PKG_NAME
991: )
992: THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995: IF ( p_in_attributes.source_code IS NULL ) OR (p_in_attributes.source_code
996: <> 'INV' ) THEN
997: x_msg_count := 1;

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995: IF ( p_in_attributes.source_code IS NULL ) OR (p_in_attributes.source_code
996: <> 'INV' ) THEN
997: x_msg_count := 1;
998: x_msg_data := 'INVALID SOURCE CODE';
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: ELSE
1001: G_InvPCRec.transaction_id := p_in_attributes.transaction_id;
1002: G_InvPCRec.transaction_temp_id := p_in_attributes.transaction_temp_id;
1003: END IF;

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

1024: x_msg_count OUT NOCOPY NUMBER,
1025: x_msg_data OUT NOCOPY VARCHAR2
1026: ) IS
1027: BEGIN
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: p_out_attributes.transaction_id := G_InvPCRec.transaction_id;
1031: p_out_attributes.transaction_temp_id := G_InvPCRec.transaction_temp_id;
1032:

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: wsh_util_core.add_message(x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1149: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1246:
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: wsh_util_core.add_message(x_return_status,l_module_name);
1252:
1253: IF l_debug_on THEN
1254: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366:
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: END IF;
1468:
1469: IF l_attr_tab.COUNT > 1 THEN
1470: --{
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF l_debug_on THEN
1473: --{
1474: WSH_DEBUG_SV.log(l_module_name, 'p_attr_tab.count for ''MATCH_GROUPS'' > 1 and hence exiting..');
1475: WSH_DEBUG_SV.pop(l_module_name);

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR;

1531: END IF;
1532:
1533: EXCEPTION
1534: WHEN NO_DATA_FOUND THEN
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: IF l_debug_on THEN
1537: --{
1538: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail doesnt exists in WDD', l_del_det_id);
1539: WSH_DEBUG_SV.pop(l_module_name);

Line 1545: x_return_status := FND_API.G_RET_STS_ERROR;

1541: END IF;
1542: RETURN;
1543:
1544: WHEN OTHERS THEN
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: --{
1548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1556: x_return_status := FND_API.G_RET_STS_ERROR;

1552: RETURN;
1553: END;
1554:
1555: ELSE -- Delivery Detail is Invalid
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: IF l_debug_on THEN
1558: --{
1559: WSH_DEBUG_SV.logmsg(l_module_name,'Invalid Delivery_detail_id',l_del_det_id);
1560: WSH_DEBUG_SV.pop(l_module_name);

Line 1628: -- x_return_status -- Return Status [ Fnd api- Return Status: Sucess, Error , UnExpected Error ]

1624: -- Output :
1625: -- x_cancel_qty_allowed -- Qty. that is allowed to be Cancelled in Source Ordered Qty. UOM
1626: -- If there is No Qty. that can be cancelled, then this parameter will return 0 (Zero)
1627: --
1628: -- x_return_status -- Return Status [ Fnd api- Return Status: Sucess, Error , UnExpected Error ]
1629: -- x_msg_count,data -- Number of Messages, Message Data Stored
1630: PROCEDURE Get_Cancel_Qty_Allowed
1631: ( p_source_code IN VARCHAR2,
1632: p_source_line_id IN NUMBER,

Line 1670: x_return_status := FND_API.G_RET_STS_ERROR;

1666: IF ( p_source_code IS NULL )
1667: THEN
1668: x_msg_count := 1;
1669: x_msg_data := 'INVALID SOURCE_CODE';
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.log(l_module_name,'Invalid source code: ', p_source_code);
1673: WSH_DEBUG_SV.pop(l_module_name);
1674: END IF;

Line 1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

1674: END IF;
1675: return;
1676: END IF;
1677:
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: BEGIN
1681: -- select stmt.
1682:

Line 1709: x_return_status := fnd_api.g_ret_sts_error;

1705: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1706: FND_MSG_PUB.ADD;
1707: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1708: , p_data => x_msg_data );
1709: x_return_status := fnd_api.g_ret_sts_error;
1710: return;
1711: END;
1712: --
1713: x_cancel_qty_allowed := l_cancel_qty_allowed;

Line 1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1745: EXCEPTION
1746:
1747: WHEN OTHERS THEN
1748: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1750:
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data

Line 1754: ,p_encoded => FND_API.G_FALSE

1750:
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data
1754: ,p_encoded => FND_API.G_FALSE
1755: );
1756:
1757: IF l_debug_on THEN
1758: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||