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.AHL_OSP_ORDERS_PVT dependencies on AHL_OSP_SHIPMENT_PUB

Line 2809: l_shipment_IDs_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;

2805: l_interface_header_id NUMBER;
2806: l_return_status VARCHAR2(1);
2807: l_msg_count NUMBER;
2808: l_msg_data VARCHAR2(1000);
2809: l_shipment_IDs_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;
2810: CURSOR val_all_wo_closed(p_osp_order_id IN NUMBER) IS
2811: --Modified by mpothuku on 27-Feb-06 to use ahl_workorders instead of ahl_workorders_osp_v
2812: --to fix the Perf Bug #4919164
2813: SELECT 'x' from ahl_osp_order_lines OL, ahl_workorders WO

Line 3031: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN

3027: END IF;
3028:
3029: -- ask SO whether can close
3030: IF(p_x_osp_order_rec.oe_header_id IS NOT NULL) THEN
3031: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3032: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3033: FND_MSG_PUB.ADD;
3034: END IF;
3035: END IF;

Line 3105: AHL_OSP_SHIPMENT_PUB.Book_Order(

3101: IF FND_MSG_PUB.count_msg > 0 THEN
3102: RAISE FND_API.G_EXC_ERROR;
3103: ELSE
3104: l_shipment_IDs_Tbl(1) := p_x_osp_order_rec.oe_header_id;
3105: AHL_OSP_SHIPMENT_PUB.Book_Order(
3106: p_api_version => 1.0,
3107: p_init_msg_list => FND_API.G_FALSE,
3108: p_commit => FND_API.G_FALSE,
3109: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3128: --dbms_output.put_line('Sales order closed ' || AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id));

3124: IF(p_x_osp_order_rec.oe_header_id IS NULL) THEN
3125: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_OE_NLL');
3126: FND_MSG_PUB.ADD;
3127: ELSE
3128: --dbms_output.put_line('Sales order closed ' || AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id));
3129: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3130: --dbms_output.put_line('Sales order is not closed');
3131: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3132: FND_MSG_PUB.ADD;

Line 3129: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN

3125: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_OE_NLL');
3126: FND_MSG_PUB.ADD;
3127: ELSE
3128: --dbms_output.put_line('Sales order closed ' || AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id));
3129: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3130: --dbms_output.put_line('Sales order is not closed');
3131: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3132: FND_MSG_PUB.ADD;
3133: END IF;

Line 3159: l_Ship_ID_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;

3155: p_oe_header_id IN NUMBER,
3156: p_del_cancel_so_lines_tbl IN del_cancel_so_lines_tbl_type,
3157: p_cancel_flag IN VARCHAR2 := FND_API.G_FALSE
3158: ) IS
3159: l_Ship_ID_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;
3160: l_return_status VARCHAR2(1);
3161: l_msg_count NUMBER;
3162: l_msg_data VARCHAR2(1000);
3163: CURSOR can_del_ship_line_csr(p_osp_order_id IN NUMBER, p_oe_ship_line_id IN NUMBER) IS

Line 3188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with p_oe_header_id = ' || p_oe_header_id);

3184: END IF;
3185: IF(p_oe_header_id IS NOT NULL) THEN
3186: -- CALL SO to delete/cancel SO
3187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with p_oe_header_id = ' || p_oe_header_id);
3189: END IF;
3190: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3191: p_api_version => 1.0,
3192: p_oe_header_id => p_oe_header_id,

Line 3190: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

3186: -- CALL SO to delete/cancel SO
3187: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3188: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with p_oe_header_id = ' || p_oe_header_id);
3189: END IF;
3190: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3191: p_api_version => 1.0,
3192: p_oe_header_id => p_oe_header_id,
3193: p_oe_lines_tbl => l_Ship_ID_Tbl,
3194: p_cancel_flag => p_cancel_flag,

Line 3283: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with l_Ship_ID_Tbl.COUNT = ' || l_Ship_ID_Tbl.COUNT);

3279: -- CALL SO API with consolidated list of line IDs
3280: IF(l_Ship_ID_Tbl.COUNT > 0) THEN
3281: -- CALL SO to delete/cancel SO
3282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3283: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with l_Ship_ID_Tbl.COUNT = ' || l_Ship_ID_Tbl.COUNT);
3284: END IF;
3285: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3286: p_api_version => 1.0,
3287: p_oe_header_id => NULL,

Line 3285: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

3281: -- CALL SO to delete/cancel SO
3282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3283: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Calling AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order with l_Ship_ID_Tbl.COUNT = ' || l_Ship_ID_Tbl.COUNT);
3284: END IF;
3285: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3286: p_api_version => 1.0,
3287: p_oe_header_id => NULL,
3288: p_oe_lines_tbl => l_Ship_ID_Tbl,
3289: p_cancel_flag => p_cancel_flag,

Line 4708: 'Before calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change');

4704: --END IF;
4705: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4706: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
4707: G_LOG_PREFIX || '.update_osp_order_header',
4708: 'Before calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change');
4709: END IF;
4710: IF ((l_oe_header_id IS NOT NULL) AND
4711: ((p_x_osp_order_rec.vendor_id IS NOT NULL AND l_vendor_id IS NULL) OR
4712: (p_x_osp_order_rec.vendor_id <> l_vendor_id) OR

Line 4717: AHL_OSP_SHIPMENT_PUB.handle_vendor_change(

4713: -- Added by jaramana on January 10, 2008 to fix the issue with the SO Customer change if the Vendor Site is Changed, Bug 6521712.
4714: (p_x_osp_order_rec.vendor_site_id IS NOT NULL AND l_vendor_site_id IS NULL) OR
4715: (p_x_osp_order_rec.vendor_site_id <> l_vendor_site_id ))) THEN
4716: --Only if vendor gets changed, then call the shipment API to handle the change
4717: AHL_OSP_SHIPMENT_PUB.handle_vendor_change(
4718: p_osp_order_id => p_x_osp_order_rec.osp_order_id,
4719: p_vendor_id => p_x_osp_order_rec.vendor_id,
4720: p_vendor_loc_id => p_x_osp_order_rec.vendor_site_id,
4721: x_return_status => l_return_status,

Line 4727: 'Normally exit after calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change'||

4723: x_msg_data => l_msg_data);
4724: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4725: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4726: G_LOG_PREFIX || '.update_osp_order_header',
4727: 'Normally exit after calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change'||
4728: 'x_return_status='||l_return_status);
4729: END IF;
4730: END IF;
4731: END update_osp_order_header;

Line 5112: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;

5108: --yazhou 07-Aug-2006 ends
5109:
5110: IS
5111: l_oe_header_id NUMBER;
5112: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;
5113: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;
5114: l_return_status VARCHAR2(1);
5115: l_msg_count NUMBER;
5116: l_msg_data VARCHAR2(2000);

Line 5113: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;

5109:
5110: IS
5111: l_oe_header_id NUMBER;
5112: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;
5113: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;
5114: l_return_status VARCHAR2(1);
5115: l_msg_count NUMBER;
5116: l_msg_data VARCHAR2(2000);
5117: l_create_shipment BOOLEAN;

Line 5156: -- in AHL_OSP_SHIPMENT_PUB.process_order

5152: END IF;
5153: ELSE
5154: -- turn on create shipment flag if shipments for the same physical item
5155: -- already exist, so that shipment can be associated to new OSP order line
5156: -- in AHL_OSP_SHIPMENT_PUB.process_order
5157: OPEN check_ship_line_exists(p_osp_order_lines_tbl(i).inventory_item_id,
5158: p_osp_order_lines_tbl(i).inventory_org_id,
5159: p_osp_order_lines_tbl(i).serial_number,
5160: p_osp_order_lines_tbl(i).osp_order_id);

Line 5208: -- osp_order_id is used in AHL_OSP_SHIPMENT_PUB.Process_Line_Tbl to fetch vendor info

5204: l_oe_header_rec.header_id := NULL;
5205:
5206: --yazhou 03-Aug-2006 starts
5207: -- bug fix#5442904
5208: -- osp_order_id is used in AHL_OSP_SHIPMENT_PUB.Process_Line_Tbl to fetch vendor info
5209:
5210: -- l_oe_header_rec.osp_order_id := NULL;
5211:
5212: --yazhou 03-Aug-2006 ends

Line 5300: AHL_OSP_SHIPMENT_PUB.process_order(

5296: 'oe_header='||l_oe_header_rec.header_id||' header_oper_flag='||l_oe_header_rec.operation||
5297: 'oe_line1_osp_order_id='||l_oe_lines_tbl(1).osp_order_id||'oe_line2_osp_line_id='||l_oe_lines_tbl(1).osp_line_id||
5298: 'oe_line_operation='||l_oe_lines_tbl(1).operation);
5299: END IF;
5300: AHL_OSP_SHIPMENT_PUB.process_order(
5301: p_api_version => 1.0,
5302: p_init_msg_list => FND_API.G_FALSE,
5303: p_commit => FND_API.G_FALSE,
5304: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5902: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(

5898: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5899: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling Delete_IB_Transaction ' );
5900: END IF;
5901:
5902: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(
5903: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
5904: p_commit => FND_API.G_FALSE,
5905: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5906: x_return_status => l_return_status,

Line 5926: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(

5922: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5923: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before calling Create_IB_Transaction ' );
5924: END IF;
5925:
5926: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(
5927: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
5928: p_commit => FND_API.G_FALSE,
5929: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5930: x_return_status => l_return_status,

Line 7732: AHL_OSP_SHIPMENT_PUB.convert_subtxn_type(

7728: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7729: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl
7730: --nullify_exchange_instance(p_osp_order_rec.osp_order_id, p_x_osp_order_lines_tbl);
7731: END IF;
7732: AHL_OSP_SHIPMENT_PUB.convert_subtxn_type(
7733: p_api_version => 1.0,
7734: p_init_msg_list => FND_API.G_FALSE,
7735: p_commit => FND_API.G_FALSE,
7736: p_validation_level => FND_API.G_VALID_LEVEL_FULL,