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_VWP_PROJ_PROD_PVT dependencies on FND_PROFILE

Line 6: --G_DEBUG VARCHAR2(1):= FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');

2: /* $Header: AHLVPRDB.pls 120.50 2008/06/05 07:09:32 sathapli ship $ */
3:
4: -- Global CONSTANTS
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_PROJ_PROD_PVT';
6: --G_DEBUG VARCHAR2(1):= FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: G_PM_PRODUCT_CODE CONSTANT VARCHAR2(30) := 'AHL';
10:

Line 1153: l_project_status_code := nvl(FND_PROFILE.VALUE('AHL_INITIAL_PROJECT_STATUS'),'SUBMITTED');

1149: END IF;
1150:
1151: --Bug#5587893
1152: /*sowsubra - starts */
1153: l_project_status_code := nvl(FND_PROFILE.VALUE('AHL_INITIAL_PROJECT_STATUS'),'SUBMITTED');
1154:
1155: /*
1156: IF (l_project_status_code IS NULL) THEN
1157: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 1204: CREATED_FROM_PROJECT_ID := nvl(FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID'),0);

1200: -- RROY
1201: IF c_visit_rec.project_template_id IS NOT NULL THEN
1202: CREATED_FROM_PROJECT_ID := c_visit_rec.project_template_id;
1203: ELSE
1204: CREATED_FROM_PROJECT_ID := nvl(FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID'),0);
1205: END IF;
1206:
1207: IF (l_log_statement >= l_log_current_level) THEN
1208: fnd_log.string(l_log_statement,L_DEBUG_KEY,'CREATED_FROM_PROJECT_ID = '||CREATED_FROM_PROJECT_ID);

Line 1214: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);

1210:
1211: -- yazhou 26Sept2005 starts
1212: -- ER#4618348
1213:
1214: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);
1215: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);
1216:
1217: IF (l_log_statement >= l_log_current_level) THEN
1218: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_project_num_prefix = '||l_project_num_prefix);

Line 1215: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);

1211: -- yazhou 26Sept2005 starts
1212: -- ER#4618348
1213:
1214: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);
1215: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);
1216:
1217: IF (l_log_statement >= l_log_current_level) THEN
1218: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_project_num_prefix = '||l_project_num_prefix);
1219: END IF;

Line 1446: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(c_visit_rec.organization_id));

1442: -- Changes made by jaramana on May 5, 2006 to accommodate PJM Bug 5197977/5194650
1443: IF (l_log_statement >= l_log_current_level) THEN
1444: FND_LOG.STRING(l_log_statement, L_DEBUG_KEY, 'About to set MFG_ORGANIZATION_ID Profile with ' || c_visit_rec.organization_id);
1445: END IF;
1446: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(c_visit_rec.organization_id));
1447:
1448: PJM_PROJECT_PARAM_PUB.Create_Project_Parameter(
1449: p_api_version => 1.0,
1450: p_init_msg_list => l_init_msg_list,

Line 1748: CREATED_FROM_PROJECT_ID := nvl(FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID'),0);

1744:
1745: IF c_visit_rec.project_template_id IS NOT NULL THEN
1746: CREATED_FROM_PROJECT_ID := c_visit_rec.project_template_id;
1747: ELSE
1748: CREATED_FROM_PROJECT_ID := nvl(FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID'),0);
1749: END IF;
1750:
1751: -- yazhou 26Sept2005 starts
1752: -- ER#4618348

Line 1754: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);

1750:
1751: -- yazhou 26Sept2005 starts
1752: -- ER#4618348
1753:
1754: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);
1755: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);
1756:
1757: IF (l_log_statement >= l_log_current_level) THEN
1758: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_project_num_prefix = ' || l_project_num_prefix);

Line 1755: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);

1751: -- yazhou 26Sept2005 starts
1752: -- ER#4618348
1753:
1754: --l_project_name_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_PREFIX'),1,10);
1755: l_project_num_prefix := SUBSTR(FND_PROFILE.VALUE('AHL_PROJECT_NUM_PREFIX'),1,10);
1756:
1757: IF (l_log_statement >= l_log_current_level) THEN
1758: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_project_num_prefix = ' || l_project_num_prefix);
1759: END IF;

Line 3967: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');

3963: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3964: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
3965: /* Begin Changes by Shkalyan */
3966: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
3967: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
3968: l_visit_wo_id NUMBER;
3969: l_visit_wo_ovn NUMBER;
3970: l_visit_wo_status VARCHAR2(30);
3971: l_visit_wo_start_time DATE;

Line 6384: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');

6380: idx NUMBER := 0;
6381: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
6382: l_manual_summ_task_flag VARCHAR2(1) ;
6383: l_task_cnt NUMBER := 0;
6384: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
6385:
6386: BEGIN
6387: IF (l_log_procedure >= l_log_current_level) THEN
6388: fnd_log.string(l_log_procedure,

Line 7731: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value( 'AHL_PRD_FIRM_PLANNED_FLAG' );

7727: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_MR_to_Production';
7728: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
7729: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
7730: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
7731: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value( 'AHL_PRD_FIRM_PLANNED_FLAG' );
7732: l_return_status VARCHAR2(1);
7733: l_msg_count NUMBER;
7734: l_msg_data VARCHAR2(2000);
7735: l_init_msg_list VARCHAR2(1) := 'F';

Line 9058: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');

9054: l_msg_data VARCHAR2(2000);
9055: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
9056: /* Begin Changes by Shkalyan */
9057: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
9058: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
9059: l_visit_wo_id NUMBER;
9060: l_visit_wo_ovn NUMBER;
9061: /* End Changes by Shkalyan */
9062: l_visit_end_time DATE;