APPS.AHL_PRD_UTIL_PKG dependencies on AHL_PRD_UTIL_PKG

Line 1: PACKAGE BODY AHL_PRD_UTIL_PKG AS

1: PACKAGE BODY AHL_PRD_UTIL_PKG AS
2: /* $Header: AHLUPRDB.pls 120.20.12020000.2 2012/12/19 08:59:51 debadey ship $ */
3:
4: -- Purpose: Briefly explain the functionality of the package body
5: -- Contains common utility procedures to be used by parts change and material transactions.

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_UTIL_PKG';

10: --MANESING::NR Analysis, 02-Mar-2011, added common global constants and variables
11: ------------------------------------------------------------------------------------------------
12: -- Common constants and variables
13: ------------------------------------------------------------------------------------------------
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_UTIL_PKG';
15: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
16:
17: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
18: l_log_statement NUMBER := FND_LOG.level_statement;

Line 194: --dbms_output.put_line('ahl_prd_util_pkg - Condition id'|| p_condition_id);

190: FND_MSG_PUB.ADD;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192:
193: End if;
194: --dbms_output.put_line('ahl_prd_util_pkg - Condition id'|| p_condition_id);
195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);
196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
197: if (p_condition_id is not null
198: and

Line 195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);

191: x_return_status := FND_API.G_RET_STS_ERROR;
192:
193: End if;
194: --dbms_output.put_line('ahl_prd_util_pkg - Condition id'|| p_condition_id);
195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);
196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
197: if (p_condition_id is not null
198: and
199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and

Line 196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);

192:
193: End if;
194: --dbms_output.put_line('ahl_prd_util_pkg - Condition id'|| p_condition_id);
195: -- dbms_output.put_line('ahl_prd_util_pkg - status id'|| l_status_id);
196: --dbms_output.put_line('ahl_prd_util_pkg - org id'|| p_organization_id);
197: if (p_condition_id is not null
198: and
199: ( (FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE')is not null and
200: p_condition_id = FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_SERVICABLE'))

Line 1962: END AHL_PRD_UTIL_PKG; -- Package Body AHL_PRD_UTIL_PKG

1958: select organization_name into l_org_name from inv_organization_name_v where organization_id = P_org_id;
1959: return l_org_name;
1960: end get_Orgname_from_Orgid;
1961:
1962: END AHL_PRD_UTIL_PKG; -- Package Body AHL_PRD_UTIL_PKG