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.

[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on FND_PROFILE

Line 4: --G_DEBUG varchar2(1) := FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');

1: PACKAGE BODY AHL_OSP_ORDERS_PVT AS
2: /* $Header: AHLVOSPB.pls 120.24 2008/03/14 14:41:52 mpothuku ship $ */
3:
4: --G_DEBUG varchar2(1) := FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_OSP_ORDERS_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.';

Line 927: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_INIT_PO_REQ'), 'N') = 'Y') THEN

923: END IF;
924:
925: --If the Profile 'Initialize Purchase Requisition' is set, then set the status to G_OSP_REQ_SUBMITTED_STATUS
926: --if the passed status is G_OSP_SUBMITTED_STATUS and the old status is not G_OSP_SUBMITTED_STATUS
927: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_INIT_PO_REQ'), 'N') = 'Y') THEN
928: IF(p_x_osp_order_rec.order_type_code IN (G_OSP_ORDER_TYPE_SERVICE, G_OSP_ORDER_TYPE_EXCHANGE) AND
929: (p_x_osp_order_rec.status_code is not null and p_x_osp_order_rec.status_code = G_OSP_SUBMITTED_STATUS and
930: l_osp_order_rec.status_code <> G_OSP_SUBMITTED_STATUS)) THEN
931: p_x_osp_order_rec.status_code := G_OSP_REQ_SUBMITTED_STATUS;

Line 4557: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');

4553: /*IF Overwrite Svc Description profile set to No l_item_description would have been
4554: defaulted as the service item desc from inventory above, if the profile is Yes, we proceed below
4555: to override the value set from the inventory */
4556:
4557: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4558: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4559: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4560:
4561: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes

Line 4558: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');

4554: defaulted as the service item desc from inventory above, if the profile is Yes, we proceed below
4555: to override the value set from the inventory */
4556:
4557: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4558: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4559: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4560:
4561: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes
4562: IF(NVL(l_desc_update_flag, 'N') = 'N') THEN --Allow Description update set to No

Line 4559: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');

4555: to override the value set from the inventory */
4556:
4557: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4558: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4559: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4560:
4561: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes
4562: IF(NVL(l_desc_update_flag, 'N') = 'N') THEN --Allow Description update set to No
4563: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SVC_DESC_NOCHNG');

Line 4610: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

4606: AND trunc(nvl(IV.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4607: AND trunc(VC.active_start_date) <= trunc(SYSDATE)
4608: AND trunc(nvl(VC.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4609: ELSE
4610: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4611: END IF;
4612: EXCEPTION
4613: WHEN OTHERS THEN
4614: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

Line 4614: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

4610: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4611: END IF;
4612: EXCEPTION
4613: WHEN OTHERS THEN
4614: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4615: END;
4616: --In case service_duration returned from the above query is null
4617: IF l_service_duration IS NULL THEN
4618: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

Line 4618: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

4614: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4615: END;
4616: --In case service_duration returned from the above query is null
4617: IF l_service_duration IS NULL THEN
4618: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4619: END IF;
4620:
4621: -- yazhou 06-Jul-2006 starts
4622: -- bug fix#5376907

Line 4637: p_po_line_type_id => to_number(FND_PROFILE.VALUE('AHL_OSP_PO_LINE_TYPE_ID')),

4633: p_last_update_login => fnd_global.login_id,
4634: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4635: p_osp_line_number => l_osp_line_number,
4636: p_status_code => NULL, --Derived from header status when displaying
4637: p_po_line_type_id => to_number(FND_PROFILE.VALUE('AHL_OSP_PO_LINE_TYPE_ID')),
4638: p_service_item_id => p_x_osp_order_line_rec.service_item_id,
4639: p_service_item_description => l_item_description,
4640: p_service_item_uom_code => l_service_item_uom_code,
4641: p_need_by_date => TRUNC(SYSDATE+l_service_duration),

Line 4910: l_oe_lines_tbl(k).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');

4906: END IF;
4907:
4908: IF l_create_ship_line THEN
4909: l_oe_lines_tbl(k).header_id := l_oe_header_id;
4910: l_oe_lines_tbl(k).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');
4911: l_oe_lines_tbl(k).osp_order_id := p_osp_order_lines_tbl(i).osp_order_id;
4912: l_oe_lines_tbl(k).osp_line_id := p_osp_order_lines_tbl(i).osp_order_line_id;
4913: l_oe_lines_tbl(k).ship_from_org_id := p_osp_order_lines_tbl(i).inventory_org_id;
4914: /* The following will be derived from Shipment API

Line 4925: l_oe_lines_tbl(k+1).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');

4921: l_oe_lines_tbl(k).osp_line_flag := G_YES_FLAG;
4922: l_oe_lines_tbl(k).operation := G_OP_CREATE;
4923:
4924: l_oe_lines_tbl(k+1).header_id := l_oe_header_id;
4925: l_oe_lines_tbl(k+1).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
4926: l_oe_lines_tbl(k+1).osp_order_id := p_osp_order_lines_tbl(i).osp_order_id;
4927: l_oe_lines_tbl(k+1).osp_line_id := p_osp_order_lines_tbl(i).osp_order_line_id;
4928: l_oe_lines_tbl(k+1).ship_from_org_id := p_osp_order_lines_tbl(i).inventory_org_id;
4929: /* The following will be derived from Shipment API

Line 5852: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');

5848: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_LN_INV_SVC_ITEM');
5849: FND_MESSAGE.Set_Token('SERVICE_ITEM_ID', p_x_osp_order_line_rec.service_item_id);
5850: FND_MSG_PUB.ADD;
5851: END;
5852: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
5853: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
5854: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
5855:
5856: --Fix for the bug 5013047

Line 5853: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');

5849: FND_MESSAGE.Set_Token('SERVICE_ITEM_ID', p_x_osp_order_line_rec.service_item_id);
5850: FND_MSG_PUB.ADD;
5851: END;
5852: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
5853: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
5854: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
5855:
5856: --Fix for the bug 5013047
5857: /*

Line 5854: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');

5850: FND_MSG_PUB.ADD;
5851: END;
5852: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
5853: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
5854: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
5855:
5856: --Fix for the bug 5013047
5857: /*
5858: IF(l_desc_update_flag <> 'Y' AND