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 2788: l_shipment_IDs_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;

2784: l_interface_header_id NUMBER;
2785: l_return_status VARCHAR2(1);
2786: l_msg_count NUMBER;
2787: l_msg_data VARCHAR2(1000);
2788: l_shipment_IDs_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;
2789: CURSOR val_all_wo_closed(p_osp_order_id IN NUMBER) IS
2790: --Modified by mpothuku on 27-Feb-06 to use ahl_workorders instead of ahl_workorders_osp_v
2791: --to fix the Perf Bug #4919164
2792: SELECT 'x' from ahl_osp_order_lines OL, ahl_workorders WO

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

2999: END IF;
3000:
3001: -- ask SO whether can close
3002: IF(p_x_osp_order_rec.oe_header_id IS NOT NULL) THEN
3003: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3004: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3005: FND_MSG_PUB.ADD;
3006: END IF;
3007: END IF;

Line 3067: AHL_OSP_SHIPMENT_PUB.Book_Order(

3063: IF FND_MSG_PUB.count_msg > 0 THEN
3064: RAISE FND_API.G_EXC_ERROR;
3065: ELSE
3066: l_shipment_IDs_Tbl(1) := p_x_osp_order_rec.oe_header_id;
3067: AHL_OSP_SHIPMENT_PUB.Book_Order(
3068: p_api_version => 1.0,
3069: p_init_msg_list => FND_API.G_FALSE,
3070: p_commit => FND_API.G_FALSE,
3071: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

3086: IF(p_x_osp_order_rec.oe_header_id IS NULL) THEN
3087: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_OE_NLL');
3088: FND_MSG_PUB.ADD;
3089: ELSE
3090: --dbms_output.put_line('Sales order closed ' || AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id));
3091: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3092: --dbms_output.put_line('Sales order is not closed');
3093: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3094: FND_MSG_PUB.ADD;

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

3087: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_OE_NLL');
3088: FND_MSG_PUB.ADD;
3089: ELSE
3090: --dbms_output.put_line('Sales order closed ' || AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id));
3091: IF NOT(FND_API.TO_BOOLEAN(AHL_OSP_SHIPMENT_PUB.Is_Order_Header_Closed( p_x_osp_order_rec.oe_header_id))) THEN
3092: --dbms_output.put_line('Sales order is not closed');
3093: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_INV_CL_SO_OPEN');
3094: FND_MSG_PUB.ADD;
3095: END IF;

Line 3121: l_Ship_ID_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;

3117: p_oe_header_id IN NUMBER,
3118: p_del_cancel_so_lines_tbl IN del_cancel_so_lines_tbl_type,
3119: p_cancel_flag IN VARCHAR2 := FND_API.G_FALSE
3120: ) IS
3121: l_Ship_ID_Tbl AHL_OSP_SHIPMENT_PUB.Ship_ID_Tbl_Type;
3122: l_return_status VARCHAR2(1);
3123: l_msg_count NUMBER;
3124: l_msg_data VARCHAR2(1000);
3125: CURSOR can_del_ship_line_csr(p_osp_order_id IN NUMBER, p_oe_ship_line_id IN NUMBER) IS

Line 3150: 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);

3146: END IF;
3147: IF(p_oe_header_id IS NOT NULL) THEN
3148: -- CALL SO to delete/cancel SO
3149: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3150: 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);
3151: END IF;
3152: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3153: p_api_version => 1.0,
3154: p_oe_header_id => p_oe_header_id,

Line 3152: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

3148: -- CALL SO to delete/cancel SO
3149: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3150: 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);
3151: END IF;
3152: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3153: p_api_version => 1.0,
3154: p_oe_header_id => p_oe_header_id,
3155: p_oe_lines_tbl => l_Ship_ID_Tbl,
3156: p_cancel_flag => p_cancel_flag,

Line 3245: 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);

3241: -- CALL SO API with consolidated list of line IDs
3242: IF(l_Ship_ID_Tbl.COUNT > 0) THEN
3243: -- CALL SO to delete/cancel SO
3244: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3245: 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);
3246: END IF;
3247: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3248: p_api_version => 1.0,
3249: p_oe_header_id => NULL,

Line 3247: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (

3243: -- CALL SO to delete/cancel SO
3244: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3245: 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);
3246: END IF;
3247: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
3248: p_api_version => 1.0,
3249: p_oe_header_id => NULL,
3250: p_oe_lines_tbl => l_Ship_ID_Tbl,
3251: p_cancel_flag => p_cancel_flag,

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

4362: --END IF;
4363: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4364: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
4365: G_LOG_PREFIX || '.update_osp_order_header',
4366: 'Before calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change');
4367: END IF;
4368: IF ((l_oe_header_id IS NOT NULL) AND
4369: ((p_x_osp_order_rec.vendor_id IS NOT NULL AND l_vendor_id IS NULL) OR
4370: (p_x_osp_order_rec.vendor_id <> l_vendor_id) OR

Line 4375: AHL_OSP_SHIPMENT_PUB.handle_vendor_change(

4371: -- Added by jaramana on January 10, 2008 to fix the issue with the SO Customer change if the Vendor Site is Changed, Bug 6521712.
4372: (p_x_osp_order_rec.vendor_site_id IS NOT NULL AND l_vendor_site_id IS NULL) OR
4373: (p_x_osp_order_rec.vendor_site_id <> l_vendor_site_id ))) THEN
4374: --Only if vendor gets changed, then call the shipment API to handle the change
4375: AHL_OSP_SHIPMENT_PUB.handle_vendor_change(
4376: p_osp_order_id => p_x_osp_order_rec.osp_order_id,
4377: p_vendor_id => p_x_osp_order_rec.vendor_id,
4378: p_vendor_loc_id => p_x_osp_order_rec.vendor_site_id,
4379: x_return_status => l_return_status,

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

4381: x_msg_data => l_msg_data);
4382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4384: G_LOG_PREFIX || '.update_osp_order_header',
4385: 'Normally exit after calling AHL_OSP_SHIPMENT_PUB.handle_vendor_change'||
4386: 'x_return_status='||l_return_status);
4387: END IF;
4388: END IF;
4389: END update_osp_order_header;

Line 4762: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;

4758: --yazhou 07-Aug-2006 ends
4759:
4760: IS
4761: l_oe_header_id NUMBER;
4762: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;
4763: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;
4764: l_return_status VARCHAR2(1);
4765: l_msg_count NUMBER;
4766: l_msg_data VARCHAR2(2000);

Line 4763: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;

4759:
4760: IS
4761: l_oe_header_id NUMBER;
4762: l_oe_header_rec AHL_OSP_SHIPMENT_PUB.ship_header_rec_type;
4763: l_oe_lines_tbl AHL_OSP_SHIPMENT_PUB.ship_line_tbl_type;
4764: l_return_status VARCHAR2(1);
4765: l_msg_count NUMBER;
4766: l_msg_data VARCHAR2(2000);
4767: l_create_shipment BOOLEAN;

Line 4806: -- in AHL_OSP_SHIPMENT_PUB.process_order

4802: END IF;
4803: ELSE
4804: -- turn on create shipment flag if shipments for the same physical item
4805: -- already exist, so that shipment can be associated to new OSP order line
4806: -- in AHL_OSP_SHIPMENT_PUB.process_order
4807: OPEN check_ship_line_exists(p_osp_order_lines_tbl(i).inventory_item_id,
4808: p_osp_order_lines_tbl(i).inventory_org_id,
4809: p_osp_order_lines_tbl(i).serial_number,
4810: p_osp_order_lines_tbl(i).osp_order_id);

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

4854: l_oe_header_rec.header_id := NULL;
4855:
4856: --yazhou 03-Aug-2006 starts
4857: -- bug fix#5442904
4858: -- osp_order_id is used in AHL_OSP_SHIPMENT_PUB.Process_Line_Tbl to fetch vendor info
4859:
4860: -- l_oe_header_rec.osp_order_id := NULL;
4861:
4862: --yazhou 03-Aug-2006 ends

Line 4950: AHL_OSP_SHIPMENT_PUB.process_order(

4946: 'oe_header='||l_oe_header_rec.header_id||' header_oper_flag='||l_oe_header_rec.operation||
4947: '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||
4948: 'oe_line_operation='||l_oe_lines_tbl(1).operation);
4949: END IF;
4950: AHL_OSP_SHIPMENT_PUB.process_order(
4951: p_api_version => 1.0,
4952: p_init_msg_list => FND_API.G_FALSE,
4953: p_commit => FND_API.G_FALSE,
4954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 7283: AHL_OSP_SHIPMENT_PUB.convert_subtxn_type(

7279: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7280: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl
7281: --nullify_exchange_instance(p_osp_order_rec.osp_order_id, p_x_osp_order_lines_tbl);
7282: END IF;
7283: AHL_OSP_SHIPMENT_PUB.convert_subtxn_type(
7284: p_api_version => 1.0,
7285: p_init_msg_list => FND_API.G_FALSE,
7286: p_commit => FND_API.G_FALSE,
7287: p_validation_level => FND_API.G_VALID_LEVEL_FULL,