DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on FND_LOG

Line 1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1088: OPEN c_get_plan_flag(l_Resrc_Require_Rec.wip_entity_id);
1089: FETCH c_get_plan_flag INTO l_plan_flag;
1090: CLOSE c_get_plan_flag;
1091:
1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1093: THEN
1094: fnd_log.string(
1095: FND_LOG.LEVEL_STATEMENT,
1096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 1094: fnd_log.string(

1090: CLOSE c_get_plan_flag;
1091:
1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1093: THEN
1094: fnd_log.string(
1095: FND_LOG.LEVEL_STATEMENT,
1096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1097: 'l_plan_flag -> '||l_plan_flag
1098: );

Line 1095: FND_LOG.LEVEL_STATEMENT,

1091:
1092: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1093: THEN
1094: fnd_log.string(
1095: FND_LOG.LEVEL_STATEMENT,
1096: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1097: 'l_plan_flag -> '||l_plan_flag
1098: );
1099: END IF;

Line 1124: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1120: l_up_workorder_rec.SCHEDULED_END_DATE := l_visit_sch_end_date;
1121: l_up_workorder_rec.SCHEDULED_END_HR := TO_NUMBER(TO_CHAR(l_visit_sch_end_date, 'HH24'));
1122: l_up_workorder_rec.SCHEDULED_END_MI := TO_NUMBER(TO_CHAR(l_visit_sch_end_date, 'MI'));
1123:
1124: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: fnd_log.string(
1127: FND_LOG.LEVEL_STATEMENT,
1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 1126: fnd_log.string(

1122: l_up_workorder_rec.SCHEDULED_END_MI := TO_NUMBER(TO_CHAR(l_visit_sch_end_date, 'MI'));
1123:
1124: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: fnd_log.string(
1127: FND_LOG.LEVEL_STATEMENT,
1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'
1130: );

Line 1127: FND_LOG.LEVEL_STATEMENT,

1123:
1124: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: fnd_log.string(
1127: FND_LOG.LEVEL_STATEMENT,
1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'
1130: );
1131: fnd_log.string(

Line 1131: fnd_log.string(

1127: FND_LOG.LEVEL_STATEMENT,
1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'
1130: );
1131: fnd_log.string(
1132: FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'l_Resrc_Require_Rec.wip_entity_id -> '||l_Resrc_Require_Rec.wip_entity_id
1135: );

Line 1132: FND_LOG.LEVEL_STATEMENT,

1128: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1129: 'Before calling AHL_PRD_WORKORDER_PVT.update_job'
1130: );
1131: fnd_log.string(
1132: FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'l_Resrc_Require_Rec.wip_entity_id -> '||l_Resrc_Require_Rec.wip_entity_id
1135: );
1136: fnd_log.string(

Line 1136: fnd_log.string(

1132: FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'l_Resrc_Require_Rec.wip_entity_id -> '||l_Resrc_Require_Rec.wip_entity_id
1135: );
1136: fnd_log.string(
1137: FND_LOG.LEVEL_STATEMENT,
1138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1139: 'l_up_workorder_rec.WORKORDER_ID -> '||l_up_workorder_rec.WORKORDER_ID
1140: );

Line 1137: FND_LOG.LEVEL_STATEMENT,

1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'l_Resrc_Require_Rec.wip_entity_id -> '||l_Resrc_Require_Rec.wip_entity_id
1135: );
1136: fnd_log.string(
1137: FND_LOG.LEVEL_STATEMENT,
1138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1139: 'l_up_workorder_rec.WORKORDER_ID -> '||l_up_workorder_rec.WORKORDER_ID
1140: );
1141: fnd_log.string(

Line 1141: fnd_log.string(

1137: FND_LOG.LEVEL_STATEMENT,
1138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1139: 'l_up_workorder_rec.WORKORDER_ID -> '||l_up_workorder_rec.WORKORDER_ID
1140: );
1141: fnd_log.string(
1142: FND_LOG.LEVEL_STATEMENT,
1143: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1144: 'l_up_workorder_rec.SCHEDULED_END_DATE -> '||TO_CHAR(l_up_workorder_rec.SCHEDULED_END_DATE, 'DD-MON-YYYY HH24:MI:SS')
1145: );

Line 1142: FND_LOG.LEVEL_STATEMENT,

1138: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1139: 'l_up_workorder_rec.WORKORDER_ID -> '||l_up_workorder_rec.WORKORDER_ID
1140: );
1141: fnd_log.string(
1142: FND_LOG.LEVEL_STATEMENT,
1143: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1144: 'l_up_workorder_rec.SCHEDULED_END_DATE -> '||TO_CHAR(l_up_workorder_rec.SCHEDULED_END_DATE, 'DD-MON-YYYY HH24:MI:SS')
1145: );
1146: END IF;

Line 1170: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1166: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1167: RAISE FND_API.G_EXC_ERROR;
1168: END IF;
1169:
1170: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1171: THEN
1172: fnd_log.string(
1173: FND_LOG.LEVEL_STATEMENT,
1174: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

Line 1172: fnd_log.string(

1168: END IF;
1169:
1170: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1171: THEN
1172: fnd_log.string(
1173: FND_LOG.LEVEL_STATEMENT,
1174: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1175: 'After calling AHL_PRD_WORKORDER_PVT.update_job'
1176: );

Line 1173: FND_LOG.LEVEL_STATEMENT,

1169:
1170: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1171: THEN
1172: fnd_log.string(
1173: FND_LOG.LEVEL_STATEMENT,
1174: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1175: 'After calling AHL_PRD_WORKORDER_PVT.update_job'
1176: );
1177: END IF;