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 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.28.12020000.2 2012/12/07 01:32:16 sareepar 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 948: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_INIT_PO_REQ'), 'N') = 'Y') THEN

944: END IF;
945:
946: --If the Profile 'Initialize Purchase Requisition' is set, then set the status to G_OSP_REQ_SUBMITTED_STATUS
947: --if the passed status is G_OSP_SUBMITTED_STATUS and the old status is not G_OSP_SUBMITTED_STATUS
948: IF (NVL(FND_PROFILE.VALUE('AHL_OSP_INIT_PO_REQ'), 'N') = 'Y') THEN
949: IF(p_x_osp_order_rec.order_type_code IN (G_OSP_ORDER_TYPE_SERVICE, G_OSP_ORDER_TYPE_EXCHANGE) AND
950: (p_x_osp_order_rec.status_code is not null and p_x_osp_order_rec.status_code = G_OSP_SUBMITTED_STATUS and
951: l_osp_order_rec.status_code <> G_OSP_SUBMITTED_STATUS)) THEN
952: p_x_osp_order_rec.status_code := G_OSP_REQ_SUBMITTED_STATUS;

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

4895: /*IF Overwrite Svc Description profile set to No l_item_description would have been
4896: defaulted as the service item desc from inventory above, if the profile is Yes, we proceed below
4897: to override the value set from the inventory */
4898:
4899: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4900: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4901: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4902:
4903: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes

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

4896: defaulted as the service item desc from inventory above, if the profile is Yes, we proceed below
4897: to override the value set from the inventory */
4898:
4899: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4900: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4901: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4902:
4903: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes
4904: IF(NVL(l_desc_update_flag, 'N') = 'N') THEN --Allow Description update set to No

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

4897: to override the value set from the inventory */
4898:
4899: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
4900: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
4901: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
4902:
4903: IF(l_owrite_svc_desc_prf = 'Y') THEN --Overwrite Svc Description profile set to Yes
4904: IF(NVL(l_desc_update_flag, 'N') = 'N') THEN --Allow Description update set to No
4905: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_SVC_DESC_NOCHNG');

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

4956: AND trunc(nvl(IV.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
4957: AND trunc(VC.active_start_date) <= trunc(SYSDATE)
4958: AND trunc(nvl(VC.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
4959: ELSE
4960: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4961: END IF;
4962: EXCEPTION
4963: WHEN OTHERS THEN
4964: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

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

4960: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4961: END IF;
4962: EXCEPTION
4963: WHEN OTHERS THEN
4964: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4965: END;
4966: --In case service_duration returned from the above query is null
4967: IF l_service_duration IS NULL THEN
4968: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');

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

4964: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4965: END;
4966: --In case service_duration returned from the above query is null
4967: IF l_service_duration IS NULL THEN
4968: l_service_duration := FND_PROFILE.value('AHL_VENDOR_SERVICE_DURATION');
4969: END IF;
4970:
4971: -- yazhou 06-Jul-2006 starts
4972: -- bug fix#5376907

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

4983: p_last_update_login => fnd_global.login_id,
4984: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4985: p_osp_line_number => l_osp_line_number,
4986: p_status_code => NULL, --Derived from header status when displaying
4987: p_po_line_type_id => to_number(FND_PROFILE.VALUE('AHL_OSP_PO_LINE_TYPE_ID')),
4988: p_service_item_id => p_x_osp_order_line_rec.service_item_id,
4989: p_service_item_description => l_item_description,
4990: p_service_item_uom_code => l_service_item_uom_code,
4991: p_need_by_date => TRUNC(SYSDATE+l_service_duration),

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

5256: END IF;
5257:
5258: IF l_create_ship_line THEN
5259: l_oe_lines_tbl(k).header_id := l_oe_header_id;
5260: l_oe_lines_tbl(k).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_SHIP_ONLY_ID');
5261: l_oe_lines_tbl(k).osp_order_id := p_osp_order_lines_tbl(i).osp_order_id;
5262: l_oe_lines_tbl(k).osp_line_id := p_osp_order_lines_tbl(i).osp_order_line_id;
5263: l_oe_lines_tbl(k).ship_from_org_id := p_osp_order_lines_tbl(i).inventory_org_id;
5264: /* The following will be derived from Shipment API

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

5271: l_oe_lines_tbl(k).osp_line_flag := G_YES_FLAG;
5272: l_oe_lines_tbl(k).operation := G_OP_CREATE;
5273:
5274: l_oe_lines_tbl(k+1).header_id := l_oe_header_id;
5275: l_oe_lines_tbl(k+1).line_type_id := FND_PROFILE.VALUE('AHL_OSP_OE_RETURN_ID');
5276: l_oe_lines_tbl(k+1).osp_order_id := p_osp_order_lines_tbl(i).osp_order_id;
5277: l_oe_lines_tbl(k+1).osp_line_id := p_osp_order_lines_tbl(i).osp_order_line_id;
5278: l_oe_lines_tbl(k+1).ship_from_org_id := p_osp_order_lines_tbl(i).inventory_org_id;
5279: /* The following will be derived from Shipment API

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

6279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_OSP_LN_INV_SVC_ITEM');
6280: FND_MESSAGE.Set_Token('SERVICE_ITEM_ID', p_x_osp_order_line_rec.service_item_id);
6281: FND_MSG_PUB.ADD;
6282: END;
6283: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
6284: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
6285: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
6286:
6287: --Fix for the bug 5013047

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

6280: FND_MESSAGE.Set_Token('SERVICE_ITEM_ID', p_x_osp_order_line_rec.service_item_id);
6281: FND_MSG_PUB.ADD;
6282: END;
6283: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
6284: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
6285: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
6286:
6287: --Fix for the bug 5013047
6288: /*

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

6281: FND_MSG_PUB.ADD;
6282: END;
6283: l_owrite_svc_desc_prf := NVL(FND_PROFILE.VALUE('AHL_OSP_OWRITE_SVC_DESC'), 'N');
6284: l_item_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_ITEM_PREFIX');
6285: l_serial_prefix := FND_PROFILE.VALUE('AHL_OSP_POL_SER_PREFIX');
6286:
6287: --Fix for the bug 5013047
6288: /*
6289: IF(l_desc_update_flag <> 'Y' AND