APPS.AHL_PRD_DF_PVT dependencies on FND_LOG

Line 166: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
163: l_warning_msg_data VARCHAR2(4000);
164:
165: BEGIN
166: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
167: fnd_log.string
168: (
169: fnd_log.level_procedure,
170: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.begin',

Line 167: fnd_log.string

163: l_warning_msg_data VARCHAR2(4000);
164:
165: BEGIN
166: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
167: fnd_log.string
168: (
169: fnd_log.level_procedure,
170: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.begin',
171: 'At the start of PLSQL procedure'

Line 169: fnd_log.level_procedure,

165: BEGIN
166: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
167: fnd_log.string
168: (
169: fnd_log.level_procedure,
170: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.begin',
171: 'At the start of PLSQL procedure'
172: );
173: END IF;

Line 188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

184: IF FND_API.To_Boolean( p_init_msg_list) THEN
185: FND_MSG_PUB.Initialize;
186: END IF;
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string
190: (
191: fnd_log.level_statement,
192: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 189: fnd_log.string

185: FND_MSG_PUB.Initialize;
186: END IF;
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string
190: (
191: fnd_log.level_statement,
192: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
193: 'p_init_message_list : ' || p_init_msg_list

Line 191: fnd_log.level_statement,

187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string
190: (
191: fnd_log.level_statement,
192: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
193: 'p_init_message_list : ' || p_init_msg_list
194: );
195: fnd_log.string

Line 195: fnd_log.string

191: fnd_log.level_statement,
192: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
193: 'p_init_message_list : ' || p_init_msg_list
194: );
195: fnd_log.string
196: (
197: fnd_log.level_statement,
198: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
199: 'p_commit : ' || p_commit

Line 197: fnd_log.level_statement,

193: 'p_init_message_list : ' || p_init_msg_list
194: );
195: fnd_log.string
196: (
197: fnd_log.level_statement,
198: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
199: 'p_commit : ' || p_commit
200: );
201: fnd_log.string

Line 201: fnd_log.string

197: fnd_log.level_statement,
198: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
199: 'p_commit : ' || p_commit
200: );
201: fnd_log.string
202: (
203: fnd_log.level_statement,
204: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
205: 'p_validation_level : ' || p_validation_level

Line 203: fnd_log.level_statement,

199: 'p_commit : ' || p_commit
200: );
201: fnd_log.string
202: (
203: fnd_log.level_statement,
204: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
205: 'p_validation_level : ' || p_validation_level
206: );
207: fnd_log.string

Line 207: fnd_log.string

203: fnd_log.level_statement,
204: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
205: 'p_validation_level : ' || p_validation_level
206: );
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
211: 'p_module_type : ' || p_module_type

Line 209: fnd_log.level_statement,

205: 'p_validation_level : ' || p_validation_level
206: );
207: fnd_log.string
208: (
209: fnd_log.level_statement,
210: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
211: 'p_module_type : ' || p_module_type
212: );
213: END IF;

Line 217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

213: END IF;
214: -- Initialize API return status to success
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
218: fnd_log.string
219: (
220: fnd_log.level_statement,
221: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 218: fnd_log.string

214: -- Initialize API return status to success
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
218: fnd_log.string
219: (
220: fnd_log.level_statement,
221: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
222: 'Logging deferral header record prior to processing'

Line 220: fnd_log.level_statement,

216:
217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
218: fnd_log.string
219: (
220: fnd_log.level_statement,
221: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
222: 'Logging deferral header record prior to processing'
223: );
224: log_df_header(p_df_header_rec => p_x_df_header_rec);

Line 231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

227: process_df_header(
228: p_x_df_header_rec => p_x_df_header_rec
229: );
230:
231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
232: fnd_log.string
233: (
234: fnd_log.level_statement,
235: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 232: fnd_log.string

228: p_x_df_header_rec => p_x_df_header_rec
229: );
230:
231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
232: fnd_log.string
233: (
234: fnd_log.level_statement,
235: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
236: 'Logging deferral header record after processing'

Line 234: fnd_log.level_statement,

230:
231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
232: fnd_log.string
233: (
234: fnd_log.level_statement,
235: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
236: 'Logging deferral header record after processing'
237: );
238: log_df_header(p_df_header_rec => p_x_df_header_rec);

Line 242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

238: log_df_header(p_df_header_rec => p_x_df_header_rec);
239: END IF;
240:
241:
242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
243: fnd_log.string
244: (
245: fnd_log.level_statement,
246: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 243: fnd_log.string

239: END IF;
240:
241:
242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
243: fnd_log.string
244: (
245: fnd_log.level_statement,
246: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
247: 'Number of records in schedules : ' || p_x_df_schedules_tbl.count

Line 245: fnd_log.level_statement,

241:
242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
243: fnd_log.string
244: (
245: fnd_log.level_statement,
246: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
247: 'Number of records in schedules : ' || p_x_df_schedules_tbl.count
248: );
249: fnd_log.string

Line 249: fnd_log.string

245: fnd_log.level_statement,
246: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
247: 'Number of records in schedules : ' || p_x_df_schedules_tbl.count
248: );
249: fnd_log.string
250: (
251: fnd_log.level_statement,
252: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
253: 'Logging deferral schedule records before processing'

Line 251: fnd_log.level_statement,

247: 'Number of records in schedules : ' || p_x_df_schedules_tbl.count
248: );
249: fnd_log.string
250: (
251: fnd_log.level_statement,
252: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
253: 'Logging deferral schedule records before processing'
254: );
255: IF(p_x_df_schedules_tbl.count > 0)THEN

Line 268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

264: process_df_schedules(
265: p_df_header_rec => p_x_df_header_rec,
266: p_x_df_schedules_tbl => p_x_df_schedules_tbl
267: );
268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
269: fnd_log.string
270: (
271: fnd_log.level_statement,
272: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 269: fnd_log.string

265: p_df_header_rec => p_x_df_header_rec,
266: p_x_df_schedules_tbl => p_x_df_schedules_tbl
267: );
268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
269: fnd_log.string
270: (
271: fnd_log.level_statement,
272: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
273: 'Logging deferral schedule records after processing'

Line 271: fnd_log.level_statement,

267: );
268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
269: fnd_log.string
270: (
271: fnd_log.level_statement,
272: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
273: 'Logging deferral schedule records after processing'
274: );
275: log_df_schedules(p_df_schedules_tbl => p_x_df_schedules_tbl);

Line 289: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN

285: );
286: END IF;
287:
288: IF G_OP_SUBMIT_FOR_APPROVAL THEN
289: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
290: fnd_log.string
291: (
292: fnd_log.level_event,
293: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',

Line 290: fnd_log.string

286: END IF;
287:
288: IF G_OP_SUBMIT_FOR_APPROVAL THEN
289: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
290: fnd_log.string
291: (
292: fnd_log.level_event,
293: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
294: 'Submitting for Aprroval Unit Deferral ID : ' || p_x_df_header_rec.unit_deferral_id ||

Line 292: fnd_log.level_event,

288: IF G_OP_SUBMIT_FOR_APPROVAL THEN
289: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
290: fnd_log.string
291: (
292: fnd_log.level_event,
293: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral',
294: 'Submitting for Aprroval Unit Deferral ID : ' || p_x_df_header_rec.unit_deferral_id ||
295: ' Object Version Number : ' || p_x_df_header_rec.object_version_number
296: );

Line 327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

323: x_msg_count := 1;
324: x_msg_data := l_warning_msg_data;
325: END IF;
326:
327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
328: fnd_log.string
329: (
330: fnd_log.level_procedure,
331: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.end',

Line 328: fnd_log.string

324: x_msg_data := l_warning_msg_data;
325: END IF;
326:
327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
328: fnd_log.string
329: (
330: fnd_log.level_procedure,
331: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.end',
332: 'At the end of PLSQL procedure'

Line 330: fnd_log.level_procedure,

326:
327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
328: fnd_log.string
329: (
330: fnd_log.level_procedure,
331: 'ahl.plsql.AHL_PRD_DF_PVT.process_deferral.end',
332: 'At the end of PLSQL procedure'
333: );
334: END IF;

Line 475: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

471: l_exists VARCHAR2(1);
472:
473:
474: BEGIN
475: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
476: fnd_log.string
477: (
478: fnd_log.level_procedure,
479: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.begin',

Line 476: fnd_log.string

472:
473:
474: BEGIN
475: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
476: fnd_log.string
477: (
478: fnd_log.level_procedure,
479: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.begin',
480: 'At the start of PLSQL procedure'

Line 478: fnd_log.level_procedure,

474: BEGIN
475: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
476: fnd_log.string
477: (
478: fnd_log.level_procedure,
479: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.begin',
480: 'At the start of PLSQL procedure'
481: );
482: END IF;

Line 511: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

507: -- raise error if input keys are wrong.
508: IF(l_input_key_error_flag)THEN
509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
510: FND_MSG_PUB.ADD;
511: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
512: fnd_log.string
513: (
514: fnd_log.level_unexpected,
515: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',

Line 512: fnd_log.string

508: IF(l_input_key_error_flag)THEN
509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
510: FND_MSG_PUB.ADD;
511: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
512: fnd_log.string
513: (
514: fnd_log.level_unexpected,
515: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
516: 'Input Keys are missing or invalid'

Line 514: fnd_log.level_unexpected,

510: FND_MSG_PUB.ADD;
511: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
512: fnd_log.string
513: (
514: fnd_log.level_unexpected,
515: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
516: 'Input Keys are missing or invalid'
517: );
518: END IF;

Line 533: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

529: l_manually_planned_flag;
530: IF(unit_effectivity_info_csr%NOTFOUND) THEN
531: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
532: FND_MSG_PUB.ADD;
533: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
534: fnd_log.string
535: (
536: fnd_log.level_unexpected,
537: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',

Line 534: fnd_log.string

530: IF(unit_effectivity_info_csr%NOTFOUND) THEN
531: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
532: FND_MSG_PUB.ADD;
533: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
534: fnd_log.string
535: (
536: fnd_log.level_unexpected,
537: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
538: 'unit effectivity record not found'

Line 536: fnd_log.level_unexpected,

532: FND_MSG_PUB.ADD;
533: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
534: fnd_log.string
535: (
536: fnd_log.level_unexpected,
537: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
538: 'unit effectivity record not found'
539: );
540: END IF;

Line 547: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

543: ELSE
544: IF(l_orig_deferral_ue_id IS NOT NULL) THEN
545: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
546: FND_MSG_PUB.ADD;
547: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
548: fnd_log.string
549: (
550: fnd_log.level_unexpected,
551: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',

Line 548: fnd_log.string

544: IF(l_orig_deferral_ue_id IS NOT NULL) THEN
545: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
546: FND_MSG_PUB.ADD;
547: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
548: fnd_log.string
549: (
550: fnd_log.level_unexpected,
551: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
552: 'unit effectivity record not found'

Line 550: fnd_log.level_unexpected,

546: FND_MSG_PUB.ADD;
547: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
548: fnd_log.string
549: (
550: fnd_log.level_unexpected,
551: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
552: 'unit effectivity record not found'
553: );
554: END IF;

Line 561: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

557: ELSIF((NVL(l_ue_status_code,'x') IN ('ACCOMPLISHED','DEFERRED','EXCEPTION','TERMINATED','CANCELLED','MR-TERMINATE'))
558: OR (NVL(l_def_status_code,'x')IN ('DEFERRED','DEFERRAL_PENDING','TERMINATED','CANCELLED')))THEN
559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
560: FND_MSG_PUB.ADD;
561: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
562: fnd_log.string
563: (
564: fnd_log.level_error,
565: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',

Line 562: fnd_log.string

558: OR (NVL(l_def_status_code,'x')IN ('DEFERRED','DEFERRAL_PENDING','TERMINATED','CANCELLED')))THEN
559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
560: FND_MSG_PUB.ADD;
561: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
562: fnd_log.string
563: (
564: fnd_log.level_error,
565: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
566: 'Status of MR or SR is not valid for deferral'

Line 564: fnd_log.level_error,

560: FND_MSG_PUB.ADD;
561: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
562: fnd_log.string
563: (
564: fnd_log.level_error,
565: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
566: 'Status of MR or SR is not valid for deferral'
567: );
568: END IF;

Line 607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

603: END IF;
604: -- doing defaulting before validation because of future OA needs
605: default_unchanged_df_header(p_x_df_header_rec => p_x_df_header_rec);
606:
607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
608: fnd_log.string
609: (
610: fnd_log.level_statement,
611: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',

Line 608: fnd_log.string

604: -- doing defaulting before validation because of future OA needs
605: default_unchanged_df_header(p_x_df_header_rec => p_x_df_header_rec);
606:
607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
608: fnd_log.string
609: (
610: fnd_log.level_statement,
611: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
612: 'Dumping deferral header record prior to validating'

Line 610: fnd_log.level_statement,

606:
607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
608: fnd_log.string
609: (
610: fnd_log.level_statement,
611: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header',
612: 'Dumping deferral header record prior to validating'
613: );
614: log_df_header(p_df_header_rec => p_x_df_header_rec);

Line 736: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

732: IF(FND_MSG_PUB.count_msg > 0)THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
737: fnd_log.string
738: (
739: fnd_log.level_procedure,
740: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.end',

Line 737: fnd_log.string

733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
737: fnd_log.string
738: (
739: fnd_log.level_procedure,
740: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.end',
741: 'At the end of PLSQL procedure'

Line 739: fnd_log.level_procedure,

735:
736: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
737: fnd_log.string
738: (
739: fnd_log.level_procedure,
740: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_header.end',
741: 'At the end of PLSQL procedure'
742: );
743: END IF;

Line 753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

749: PROCEDURE log_df_header(
750: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type) IS
751:
752: BEGIN
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
754: fnd_log.string
755: (
756: fnd_log.level_statement,
757: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',

Line 754: fnd_log.string

750: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type) IS
751:
752: BEGIN
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
754: fnd_log.string
755: (
756: fnd_log.level_statement,
757: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
758: 'p_x_df_header_rec.operation_flag : ' || p_df_header_rec.operation_flag

Line 756: fnd_log.level_statement,

752: BEGIN
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
754: fnd_log.string
755: (
756: fnd_log.level_statement,
757: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
758: 'p_x_df_header_rec.operation_flag : ' || p_df_header_rec.operation_flag
759: );
760: fnd_log.string

Line 760: fnd_log.string

756: fnd_log.level_statement,
757: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
758: 'p_x_df_header_rec.operation_flag : ' || p_df_header_rec.operation_flag
759: );
760: fnd_log.string
761: (
762: fnd_log.level_statement,
763: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
764: 'p_x_df_header_rec.unit_deferral_id : ' || p_df_header_rec.unit_deferral_id

Line 762: fnd_log.level_statement,

758: 'p_x_df_header_rec.operation_flag : ' || p_df_header_rec.operation_flag
759: );
760: fnd_log.string
761: (
762: fnd_log.level_statement,
763: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
764: 'p_x_df_header_rec.unit_deferral_id : ' || p_df_header_rec.unit_deferral_id
765: );
766: fnd_log.string

Line 766: fnd_log.string

762: fnd_log.level_statement,
763: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
764: 'p_x_df_header_rec.unit_deferral_id : ' || p_df_header_rec.unit_deferral_id
765: );
766: fnd_log.string
767: (
768: fnd_log.level_statement,
769: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
770: 'p_x_df_header_rec.object_version_number : ' || p_df_header_rec.object_version_number

Line 768: fnd_log.level_statement,

764: 'p_x_df_header_rec.unit_deferral_id : ' || p_df_header_rec.unit_deferral_id
765: );
766: fnd_log.string
767: (
768: fnd_log.level_statement,
769: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
770: 'p_x_df_header_rec.object_version_number : ' || p_df_header_rec.object_version_number
771: );
772: fnd_log.string

Line 772: fnd_log.string

768: fnd_log.level_statement,
769: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
770: 'p_x_df_header_rec.object_version_number : ' || p_df_header_rec.object_version_number
771: );
772: fnd_log.string
773: (
774: fnd_log.level_statement,
775: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
776: 'p_x_df_header_rec.unit_effectivity_id : ' || p_df_header_rec.unit_effectivity_id

Line 774: fnd_log.level_statement,

770: 'p_x_df_header_rec.object_version_number : ' || p_df_header_rec.object_version_number
771: );
772: fnd_log.string
773: (
774: fnd_log.level_statement,
775: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
776: 'p_x_df_header_rec.unit_effectivity_id : ' || p_df_header_rec.unit_effectivity_id
777: );
778: fnd_log.string

Line 778: fnd_log.string

774: fnd_log.level_statement,
775: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
776: 'p_x_df_header_rec.unit_effectivity_id : ' || p_df_header_rec.unit_effectivity_id
777: );
778: fnd_log.string
779: (
780: fnd_log.level_statement,
781: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
782: 'p_x_df_header_rec.defer_reason_code : ' || p_df_header_rec.defer_reason_code

Line 780: fnd_log.level_statement,

776: 'p_x_df_header_rec.unit_effectivity_id : ' || p_df_header_rec.unit_effectivity_id
777: );
778: fnd_log.string
779: (
780: fnd_log.level_statement,
781: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
782: 'p_x_df_header_rec.defer_reason_code : ' || p_df_header_rec.defer_reason_code
783: );
784: fnd_log.string

Line 784: fnd_log.string

780: fnd_log.level_statement,
781: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
782: 'p_x_df_header_rec.defer_reason_code : ' || p_df_header_rec.defer_reason_code
783: );
784: fnd_log.string
785: (
786: fnd_log.level_statement,
787: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
788: 'p_x_df_header_rec.remarks : ' || p_df_header_rec.remarks

Line 786: fnd_log.level_statement,

782: 'p_x_df_header_rec.defer_reason_code : ' || p_df_header_rec.defer_reason_code
783: );
784: fnd_log.string
785: (
786: fnd_log.level_statement,
787: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
788: 'p_x_df_header_rec.remarks : ' || p_df_header_rec.remarks
789: );
790: fnd_log.string

Line 790: fnd_log.string

786: fnd_log.level_statement,
787: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
788: 'p_x_df_header_rec.remarks : ' || p_df_header_rec.remarks
789: );
790: fnd_log.string
791: (
792: fnd_log.level_statement,
793: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
794: 'p_x_df_header_rec.skip_mr_flag : ' || p_df_header_rec.skip_mr_flag

Line 792: fnd_log.level_statement,

788: 'p_x_df_header_rec.remarks : ' || p_df_header_rec.remarks
789: );
790: fnd_log.string
791: (
792: fnd_log.level_statement,
793: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
794: 'p_x_df_header_rec.skip_mr_flag : ' || p_df_header_rec.skip_mr_flag
795: );
796: fnd_log.string

Line 796: fnd_log.string

792: fnd_log.level_statement,
793: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
794: 'p_x_df_header_rec.skip_mr_flag : ' || p_df_header_rec.skip_mr_flag
795: );
796: fnd_log.string
797: (
798: fnd_log.level_statement,
799: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
800: 'p_x_df_header_rec.affect_due_calc_flag : ' || p_df_header_rec.affect_due_calc_flag

Line 798: fnd_log.level_statement,

794: 'p_x_df_header_rec.skip_mr_flag : ' || p_df_header_rec.skip_mr_flag
795: );
796: fnd_log.string
797: (
798: fnd_log.level_statement,
799: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
800: 'p_x_df_header_rec.affect_due_calc_flag : ' || p_df_header_rec.affect_due_calc_flag
801: );
802: fnd_log.string

Line 802: fnd_log.string

798: fnd_log.level_statement,
799: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
800: 'p_x_df_header_rec.affect_due_calc_flag : ' || p_df_header_rec.affect_due_calc_flag
801: );
802: fnd_log.string
803: (
804: fnd_log.level_statement,
805: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
806: 'p_x_df_header_rec.set_due_date : ' || p_df_header_rec.set_due_date

Line 804: fnd_log.level_statement,

800: 'p_x_df_header_rec.affect_due_calc_flag : ' || p_df_header_rec.affect_due_calc_flag
801: );
802: fnd_log.string
803: (
804: fnd_log.level_statement,
805: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
806: 'p_x_df_header_rec.set_due_date : ' || p_df_header_rec.set_due_date
807: );
808: fnd_log.string

Line 808: fnd_log.string

804: fnd_log.level_statement,
805: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
806: 'p_x_df_header_rec.set_due_date : ' || p_df_header_rec.set_due_date
807: );
808: fnd_log.string
809: (
810: fnd_log.level_statement,
811: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
812: 'p_x_df_header_rec.deferral_effective_on : ' || p_df_header_rec.deferral_effective_on

Line 810: fnd_log.level_statement,

806: 'p_x_df_header_rec.set_due_date : ' || p_df_header_rec.set_due_date
807: );
808: fnd_log.string
809: (
810: fnd_log.level_statement,
811: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
812: 'p_x_df_header_rec.deferral_effective_on : ' || p_df_header_rec.deferral_effective_on
813: );
814: fnd_log.string

Line 814: fnd_log.string

810: fnd_log.level_statement,
811: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
812: 'p_x_df_header_rec.deferral_effective_on : ' || p_df_header_rec.deferral_effective_on
813: );
814: fnd_log.string
815: (
816: fnd_log.level_statement,
817: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
818: 'p_x_df_header_rec.deferral_type : ' || p_df_header_rec.deferral_type

Line 816: fnd_log.level_statement,

812: 'p_x_df_header_rec.deferral_effective_on : ' || p_df_header_rec.deferral_effective_on
813: );
814: fnd_log.string
815: (
816: fnd_log.level_statement,
817: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
818: 'p_x_df_header_rec.deferral_type : ' || p_df_header_rec.deferral_type
819: );
820: fnd_log.string

Line 820: fnd_log.string

816: fnd_log.level_statement,
817: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
818: 'p_x_df_header_rec.deferral_type : ' || p_df_header_rec.deferral_type
819: );
820: fnd_log.string
821: (
822: fnd_log.level_statement,
823: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
824: 'p_x_df_header_rec.mr_repetitive_flag : ' || p_df_header_rec.mr_repetitive_flag

Line 822: fnd_log.level_statement,

818: 'p_x_df_header_rec.deferral_type : ' || p_df_header_rec.deferral_type
819: );
820: fnd_log.string
821: (
822: fnd_log.level_statement,
823: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
824: 'p_x_df_header_rec.mr_repetitive_flag : ' || p_df_header_rec.mr_repetitive_flag
825: );
826: fnd_log.string

Line 826: fnd_log.string

822: fnd_log.level_statement,
823: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
824: 'p_x_df_header_rec.mr_repetitive_flag : ' || p_df_header_rec.mr_repetitive_flag
825: );
826: fnd_log.string
827: (
828: fnd_log.level_statement,
829: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
830: 'p_x_df_header_rec.reset_counter_flag : ' || p_df_header_rec.reset_counter_flag

Line 828: fnd_log.level_statement,

824: 'p_x_df_header_rec.mr_repetitive_flag : ' || p_df_header_rec.mr_repetitive_flag
825: );
826: fnd_log.string
827: (
828: fnd_log.level_statement,
829: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
830: 'p_x_df_header_rec.reset_counter_flag : ' || p_df_header_rec.reset_counter_flag
831: );
832: fnd_log.string

Line 832: fnd_log.string

828: fnd_log.level_statement,
829: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
830: 'p_x_df_header_rec.reset_counter_flag : ' || p_df_header_rec.reset_counter_flag
831: );
832: fnd_log.string
833: (
834: fnd_log.level_statement,
835: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
836: 'p_x_df_header_rec.manually_planned_flag : ' || p_df_header_rec.manually_planned_flag

Line 834: fnd_log.level_statement,

830: 'p_x_df_header_rec.reset_counter_flag : ' || p_df_header_rec.reset_counter_flag
831: );
832: fnd_log.string
833: (
834: fnd_log.level_statement,
835: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
836: 'p_x_df_header_rec.manually_planned_flag : ' || p_df_header_rec.manually_planned_flag
837: );
838: fnd_log.string

Line 838: fnd_log.string

834: fnd_log.level_statement,
835: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
836: 'p_x_df_header_rec.manually_planned_flag : ' || p_df_header_rec.manually_planned_flag
837: );
838: fnd_log.string
839: (
840: fnd_log.level_statement,
841: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
842: 'user id : ' || FND_GLOBAL.USER_ID()

Line 840: fnd_log.level_statement,

836: 'p_x_df_header_rec.manually_planned_flag : ' || p_df_header_rec.manually_planned_flag
837: );
838: fnd_log.string
839: (
840: fnd_log.level_statement,
841: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
842: 'user id : ' || FND_GLOBAL.USER_ID()
843: );
844: fnd_log.string

Line 844: fnd_log.string

840: fnd_log.level_statement,
841: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
842: 'user id : ' || FND_GLOBAL.USER_ID()
843: );
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
848: 'resp id : ' || FND_GLOBAL.RESP_ID()

Line 846: fnd_log.level_statement,

842: 'user id : ' || FND_GLOBAL.USER_ID()
843: );
844: fnd_log.string
845: (
846: fnd_log.level_statement,
847: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
848: 'resp id : ' || FND_GLOBAL.RESP_ID()
849: );
850: fnd_log.string

Line 850: fnd_log.string

846: fnd_log.level_statement,
847: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
848: 'resp id : ' || FND_GLOBAL.RESP_ID()
849: );
850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
854: 'resp appl id : ' || FND_GLOBAL.resp_appl_id()

Line 852: fnd_log.level_statement,

848: 'resp id : ' || FND_GLOBAL.RESP_ID()
849: );
850: fnd_log.string
851: (
852: fnd_log.level_statement,
853: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_header',
854: 'resp appl id : ' || FND_GLOBAL.resp_appl_id()
855: );
856: END IF;

Line 962: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

958: l_serial_number csi_item_instances.serial_number%TYPE;
959:
960: BEGIN
961:
962: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
963: fnd_log.string
964: (
965: fnd_log.level_procedure,
966: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.begin',

Line 963: fnd_log.string

959:
960: BEGIN
961:
962: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
963: fnd_log.string
964: (
965: fnd_log.level_procedure,
966: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.begin',
967: 'At the start of PLSQL procedure'

Line 965: fnd_log.level_procedure,

961:
962: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
963: fnd_log.string
964: (
965: fnd_log.level_procedure,
966: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.begin',
967: 'At the start of PLSQL procedure'
968: );
969: END IF;

Line 974: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

970:
971: IF(p_df_header_rec.operation_flag IS NOT NULL AND p_df_header_rec.operation_flag NOT IN(G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE))THEN
972: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_FLAG');
973: FND_MSG_PUB.ADD;
974: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
975: fnd_log.string
976: (
977: fnd_log.level_unexpected,
978: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 975: fnd_log.string

971: IF(p_df_header_rec.operation_flag IS NOT NULL AND p_df_header_rec.operation_flag NOT IN(G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE))THEN
972: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_FLAG');
973: FND_MSG_PUB.ADD;
974: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
975: fnd_log.string
976: (
977: fnd_log.level_unexpected,
978: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
979: 'Operation Flag is invalid in the header record'

Line 977: fnd_log.level_unexpected,

973: FND_MSG_PUB.ADD;
974: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
975: fnd_log.string
976: (
977: fnd_log.level_unexpected,
978: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
979: 'Operation Flag is invalid in the header record'
980: );
981: END IF;

Line 1012: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1008: IF(valid_deferral_csr%NOTFOUND)
1009: THEN
1010: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1011: FND_MSG_PUB.ADD;
1012: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1013: THEN
1014: fnd_log.string
1015: (
1016: fnd_log.level_unexpected,

Line 1014: fnd_log.string

1010: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1011: FND_MSG_PUB.ADD;
1012: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1013: THEN
1014: fnd_log.string
1015: (
1016: fnd_log.level_unexpected,
1017: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1018: 'invalid mr or sr status invalid for update or delete 1'

Line 1016: fnd_log.level_unexpected,

1012: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1013: THEN
1014: fnd_log.string
1015: (
1016: fnd_log.level_unexpected,
1017: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1018: 'invalid mr or sr status invalid for update or delete 1'
1019: );
1020: END IF;

Line 1038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1034: FETCH is_orig_ue_nonserial INTO l_serial_number;
1035: IF (is_orig_ue_nonserial%FOUND AND l_serial_number IS NULL) THEN
1036: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_NS_DF_INVALID');
1037: FND_MSG_PUB.ADD;
1038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1039: fnd_log.string
1040: (
1041: fnd_log.level_unexpected,
1042: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1039: fnd_log.string

1035: IF (is_orig_ue_nonserial%FOUND AND l_serial_number IS NULL) THEN
1036: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_NS_DF_INVALID');
1037: FND_MSG_PUB.ADD;
1038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1039: fnd_log.string
1040: (
1041: fnd_log.level_unexpected,
1042: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1043: 'cannot defer child MR when parent MR is based on non-serial SR'

Line 1041: fnd_log.level_unexpected,

1037: FND_MSG_PUB.ADD;
1038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1039: fnd_log.string
1040: (
1041: fnd_log.level_unexpected,
1042: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1043: 'cannot defer child MR when parent MR is based on non-serial SR'
1044: );
1045: END IF;

Line 1062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1058: FETCH valid_deferral_csr INTO l_exists;
1059: IF(valid_deferral_csr%NOTFOUND)THEN
1060: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1061: FND_MSG_PUB.ADD;
1062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1063: fnd_log.string
1064: (
1065: fnd_log.level_unexpected,
1066: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1063: fnd_log.string

1059: IF(valid_deferral_csr%NOTFOUND)THEN
1060: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1061: FND_MSG_PUB.ADD;
1062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1063: fnd_log.string
1064: (
1065: fnd_log.level_unexpected,
1066: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1067: 'invalid mr or sr status invalid for update or delete 1'

Line 1065: fnd_log.level_unexpected,

1061: FND_MSG_PUB.ADD;
1062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1063: fnd_log.string
1064: (
1065: fnd_log.level_unexpected,
1066: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1067: 'invalid mr or sr status invalid for update or delete 1'
1068: );
1069: END IF;

Line 1086: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1082: FETCH deferral_rec_exists_csr INTO l_exists;
1083: IF(deferral_rec_exists_csr%FOUND)THEN
1084: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_REXIST');
1085: FND_MSG_PUB.ADD;
1086: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string
1088: (
1089: fnd_log.level_unexpected,
1090: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1087: fnd_log.string

1083: IF(deferral_rec_exists_csr%FOUND)THEN
1084: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_REXIST');
1085: FND_MSG_PUB.ADD;
1086: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string
1088: (
1089: fnd_log.level_unexpected,
1090: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1091: 'Deferral record exist while operation flag is create'

Line 1089: fnd_log.level_unexpected,

1085: FND_MSG_PUB.ADD;
1086: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string
1088: (
1089: fnd_log.level_unexpected,
1090: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1091: 'Deferral record exist while operation flag is create'
1092: );
1093: END IF;

Line 1103: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1099: -- check whether status is nothing but draft while creating record for deferral
1100: IF(p_df_header_rec.approval_status_code <> 'DRAFT')THEN
1101: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1102: FND_MSG_PUB.ADD;
1103: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1104: fnd_log.string
1105: (
1106: fnd_log.level_unexpected,
1107: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1104: fnd_log.string

1100: IF(p_df_header_rec.approval_status_code <> 'DRAFT')THEN
1101: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1102: FND_MSG_PUB.ADD;
1103: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1104: fnd_log.string
1105: (
1106: fnd_log.level_unexpected,
1107: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1108: 'approval status is not DRAFT while creating a deferral record'

Line 1106: fnd_log.level_unexpected,

1102: FND_MSG_PUB.ADD;
1103: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1104: fnd_log.string
1105: (
1106: fnd_log.level_unexpected,
1107: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1108: 'approval status is not DRAFT while creating a deferral record'
1109: );
1110: END IF;

Line 1122: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1118: FETCH valid_deferral_up_csr INTO l_exists;
1119: IF(valid_deferral_up_csr%NOTFOUND)THEN
1120: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1121: FND_MSG_PUB.ADD;
1122: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1123: fnd_log.string
1124: (
1125: fnd_log.level_unexpected,
1126: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1123: fnd_log.string

1119: IF(valid_deferral_up_csr%NOTFOUND)THEN
1120: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1121: FND_MSG_PUB.ADD;
1122: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1123: fnd_log.string
1124: (
1125: fnd_log.level_unexpected,
1126: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1127: 'approval status invalid for update or delete : ue_id : ' || p_df_header_rec.unit_deferral_id

Line 1125: fnd_log.level_unexpected,

1121: FND_MSG_PUB.ADD;
1122: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1123: fnd_log.string
1124: (
1125: fnd_log.level_unexpected,
1126: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1127: 'approval status invalid for update or delete : ue_id : ' || p_df_header_rec.unit_deferral_id
1128: );
1129: END IF;

Line 1146: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1142: FETCH valid_mr_csr INTO l_exists;
1143: IF(valid_mr_csr%NOTFOUND)THEN
1144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
1145: FND_MSG_PUB.ADD;
1146: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1147: fnd_log.string
1148: (
1149: fnd_log.level_error,
1150: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1147: fnd_log.string

1143: IF(valid_mr_csr%NOTFOUND)THEN
1144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
1145: FND_MSG_PUB.ADD;
1146: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1147: fnd_log.string
1148: (
1149: fnd_log.level_error,
1150: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1151: 'Associated MR has been terminated in FMP'

Line 1149: fnd_log.level_error,

1145: FND_MSG_PUB.ADD;
1146: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1147: fnd_log.string
1148: (
1149: fnd_log.level_error,
1150: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1151: 'Associated MR has been terminated in FMP'
1152: );
1153: END IF;

Line 1168: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1164: -- general validations for flags
1165: IF(p_df_header_rec.skip_mr_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1166: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1167: FND_MSG_PUB.ADD;
1168: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1169: fnd_log.string
1170: (
1171: fnd_log.level_unexpected,
1172: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1169: fnd_log.string

1165: IF(p_df_header_rec.skip_mr_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1166: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1167: FND_MSG_PUB.ADD;
1168: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1169: fnd_log.string
1170: (
1171: fnd_log.level_unexpected,
1172: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1173: 'Skip flag is not Y or N'

Line 1171: fnd_log.level_unexpected,

1167: FND_MSG_PUB.ADD;
1168: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1169: fnd_log.string
1170: (
1171: fnd_log.level_unexpected,
1172: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1173: 'Skip flag is not Y or N'
1174: );
1175: END IF;

Line 1181: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1177: END IF;
1178: IF(p_df_header_rec.affect_due_calc_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1180: FND_MSG_PUB.ADD;
1181: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1182: fnd_log.string
1183: (
1184: fnd_log.level_unexpected,
1185: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1182: fnd_log.string

1178: IF(p_df_header_rec.affect_due_calc_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1180: FND_MSG_PUB.ADD;
1181: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1182: fnd_log.string
1183: (
1184: fnd_log.level_unexpected,
1185: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1186: 'Affect Due Calc Flag is not Y or N'

Line 1184: fnd_log.level_unexpected,

1180: FND_MSG_PUB.ADD;
1181: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1182: fnd_log.string
1183: (
1184: fnd_log.level_unexpected,
1185: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1186: 'Affect Due Calc Flag is not Y or N'
1187: );
1188: END IF;

Line 1212: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1208: IF(p_df_header_rec.mr_repetitive_flag = G_NO_FLAG AND p_df_header_rec.manually_planned_flag = G_NO_FLAG)THEN
1209: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1210: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1211: FND_MSG_PUB.ADD;
1212: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_unexpected,
1216: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1213: fnd_log.string

1209: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1210: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1211: FND_MSG_PUB.ADD;
1212: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_unexpected,
1216: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1217: 'Skip MR flag is Y while MR is not repetitive'

Line 1215: fnd_log.level_unexpected,

1211: FND_MSG_PUB.ADD;
1212: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_unexpected,
1216: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1217: 'Skip MR flag is Y while MR is not repetitive'
1218: );
1219: END IF;

Line 1232: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1228: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG AND
1229: p_df_header_rec.reset_counter_flag = G_YES_FLAG) THEN
1230: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1231: FND_MSG_PUB.ADD;
1232: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_unexpected,
1236: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1233: fnd_log.string

1229: p_df_header_rec.reset_counter_flag = G_YES_FLAG) THEN
1230: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1231: FND_MSG_PUB.ADD;
1232: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_unexpected,
1236: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1237: 'MR has resettable counters so affect due cal flag cant be N '

Line 1235: fnd_log.level_unexpected,

1231: FND_MSG_PUB.ADD;
1232: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_unexpected,
1236: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1237: 'MR has resettable counters so affect due cal flag cant be N '
1238: );
1239: END IF;

Line 1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1242: ELSE
1243: IF(p_df_header_rec.affect_due_calc_flag = G_YES_FLAG) THEN
1244: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1245: FND_MSG_PUB.ADD;
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_unexpected,
1250: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1247: fnd_log.string

1243: IF(p_df_header_rec.affect_due_calc_flag = G_YES_FLAG) THEN
1244: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1245: FND_MSG_PUB.ADD;
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_unexpected,
1250: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1251: 'MR skip flag is Y so affect due cal flag can not be Y '

Line 1249: fnd_log.level_unexpected,

1245: FND_MSG_PUB.ADD;
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (
1249: fnd_log.level_unexpected,
1250: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1251: 'MR skip flag is Y so affect due cal flag can not be Y '
1252: );
1253: END IF;

Line 1263: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1259: /* SR cancellation allowed for non-serialized items.
1260: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1261: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1262: FND_MSG_PUB.ADD;
1263: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1264: fnd_log.string
1265: (
1266: fnd_log.level_unexpected,
1267: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1264: fnd_log.string

1260: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1261: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1262: FND_MSG_PUB.ADD;
1263: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1264: fnd_log.string
1265: (
1266: fnd_log.level_unexpected,
1267: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1268: 'For SR, skip flag cant be Y '

Line 1266: fnd_log.level_unexpected,

1262: FND_MSG_PUB.ADD;
1263: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1264: fnd_log.string
1265: (
1266: fnd_log.level_unexpected,
1267: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1268: 'For SR, skip flag cant be Y '
1269: );
1270: END IF;

Line 1277: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1273: */
1274: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG)THEN
1275: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1276: FND_MSG_PUB.ADD;
1277: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1278: fnd_log.string
1279: (
1280: fnd_log.level_unexpected,
1281: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1278: fnd_log.string

1274: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG)THEN
1275: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1276: FND_MSG_PUB.ADD;
1277: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1278: fnd_log.string
1279: (
1280: fnd_log.level_unexpected,
1281: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1282: 'For SR, affect due date flag can not be N '

Line 1280: fnd_log.level_unexpected,

1276: FND_MSG_PUB.ADD;
1277: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1278: fnd_log.string
1279: (
1280: fnd_log.level_unexpected,
1281: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1282: 'For SR, affect due date flag can not be N '
1283: );
1284: END IF;

Line 1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1292: trunc(p_df_header_rec.set_due_date) < trunc(SYSDATE))) THEN
1293: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_DT');
1294: FND_MESSAGE.Set_Token('SET_DUE_DATE',p_df_header_rec.set_due_date);
1295: FND_MSG_PUB.ADD;
1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_error,
1300: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1297: fnd_log.string

1293: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_DT');
1294: FND_MESSAGE.Set_Token('SET_DUE_DATE',p_df_header_rec.set_due_date);
1295: FND_MSG_PUB.ADD;
1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_error,
1300: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1301: 'Set due date cant be null or less than system date '

Line 1299: fnd_log.level_error,

1295: FND_MSG_PUB.ADD;
1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1297: fnd_log.string
1298: (
1299: fnd_log.level_error,
1300: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1301: 'Set due date cant be null or less than system date '
1302: );
1303: END IF;

Line 1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1306: p_df_header_rec.deferral_effective_on > SYSDATE) THEN
1307: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
1308: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
1309: FND_MSG_PUB.ADD;
1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1311: fnd_log.string
1312: (
1313: fnd_log.level_error,
1314: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',

Line 1311: fnd_log.string

1307: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
1308: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
1309: FND_MSG_PUB.ADD;
1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1311: fnd_log.string
1312: (
1313: fnd_log.level_error,
1314: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1315: 'Deferral Effective On Date can not be null or greater than system date '

Line 1313: fnd_log.level_error,

1309: FND_MSG_PUB.ADD;
1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1311: fnd_log.string
1312: (
1313: fnd_log.level_error,
1314: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header',
1315: 'Deferral Effective On Date can not be null or greater than system date '
1316: );
1317: END IF;

Line 1326: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1322: IF(FND_MSG_PUB.count_msg > 0)THEN
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325:
1326: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1327: fnd_log.string
1328: (
1329: fnd_log.level_procedure,
1330: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.end',

Line 1327: fnd_log.string

1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325:
1326: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1327: fnd_log.string
1328: (
1329: fnd_log.level_procedure,
1330: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.end',
1331: 'At the end of PLSQL procedure'

Line 1329: fnd_log.level_procedure,

1325:
1326: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1327: fnd_log.string
1328: (
1329: fnd_log.level_procedure,
1330: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_header.end',
1331: 'At the end of PLSQL procedure'
1332: );
1333: END IF;

Line 1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1353:
1354: l_exists VARCHAR2(1);
1355:
1356: BEGIN
1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1358: fnd_log.string
1359: (
1360: fnd_log.level_procedure,
1361: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.begin',

Line 1358: fnd_log.string

1354: l_exists VARCHAR2(1);
1355:
1356: BEGIN
1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1358: fnd_log.string
1359: (
1360: fnd_log.level_procedure,
1361: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.begin',
1362: 'At the start of PLSQL procedure'

Line 1360: fnd_log.level_procedure,

1356: BEGIN
1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1358: fnd_log.string
1359: (
1360: fnd_log.level_procedure,
1361: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.begin',
1362: 'At the start of PLSQL procedure'
1363: );
1364: END IF;

Line 1375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1371: FETCH val_reason_code_csr INTO l_exists;
1372: IF(val_reason_code_csr%NOTFOUND) THEN
1373: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1374: FND_MSG_PUB.ADD;
1375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1376: fnd_log.string
1377: (
1378: fnd_log.level_unexpected,
1379: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',

Line 1376: fnd_log.string

1372: IF(val_reason_code_csr%NOTFOUND) THEN
1373: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1374: FND_MSG_PUB.ADD;
1375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1376: fnd_log.string
1377: (
1378: fnd_log.level_unexpected,
1379: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',
1380: 'Reason code is not defined in lookups '

Line 1378: fnd_log.level_unexpected,

1374: FND_MSG_PUB.ADD;
1375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1376: fnd_log.string
1377: (
1378: fnd_log.level_unexpected,
1379: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',
1380: 'Reason code is not defined in lookups '
1381: );
1382: END IF;

Line 1395: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1391: FETCH val_reason_code_csr INTO l_exists;
1392: IF(val_reason_code_csr%NOTFOUND) THEN
1393: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1394: FND_MSG_PUB.ADD;
1395: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1396: fnd_log.string
1397: (
1398: fnd_log.level_unexpected,
1399: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',

Line 1396: fnd_log.string

1392: IF(val_reason_code_csr%NOTFOUND) THEN
1393: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1394: FND_MSG_PUB.ADD;
1395: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1396: fnd_log.string
1397: (
1398: fnd_log.level_unexpected,
1399: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',
1400: 'Reason code is not defined in lookups '

Line 1398: fnd_log.level_unexpected,

1394: FND_MSG_PUB.ADD;
1395: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1396: fnd_log.string
1397: (
1398: fnd_log.level_unexpected,
1399: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes',
1400: 'Reason code is not defined in lookups '
1401: );
1402: END IF;

Line 1417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1413: IF(FND_MSG_PUB.count_msg > 0)THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:
1417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1418: fnd_log.string
1419: (
1420: fnd_log.level_procedure,
1421: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.end',

Line 1418: fnd_log.string

1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:
1417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1418: fnd_log.string
1419: (
1420: fnd_log.level_procedure,
1421: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.end',
1422: 'At the end of PLSQL procedure'

Line 1420: fnd_log.level_procedure,

1416:
1417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1418: fnd_log.string
1419: (
1420: fnd_log.level_procedure,
1421: 'ahl.plsql.AHL_PRD_DF_PVT.validate_reason_codes.end',
1422: 'At the end of PLSQL procedure'
1423: );
1424: END IF;

Line 1449: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1445:
1446: l_df_header_rec AHL_PRD_DF_PVT.df_header_Rec_type;
1447:
1448: BEGIN
1449: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1452: fnd_log.level_procedure,
1453: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.begin',

Line 1450: fnd_log.string

1446: l_df_header_rec AHL_PRD_DF_PVT.df_header_Rec_type;
1447:
1448: BEGIN
1449: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1452: fnd_log.level_procedure,
1453: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.begin',
1454: 'At the start of PLSQL procedure'

Line 1452: fnd_log.level_procedure,

1448: BEGIN
1449: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1452: fnd_log.level_procedure,
1453: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.begin',
1454: 'At the start of PLSQL procedure'
1455: );
1456: END IF;

Line 1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1469: l_df_header_rec.attribute15;
1470: IF (df_header_csr%NOTFOUND) THEN
1471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
1472: FND_MSG_PUB.ADD;
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1474: fnd_log.string
1475: (
1476: fnd_log.level_error,
1477: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1474: fnd_log.string

1470: IF (df_header_csr%NOTFOUND) THEN
1471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
1472: FND_MSG_PUB.ADD;
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1474: fnd_log.string
1475: (
1476: fnd_log.level_error,
1477: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1478: 'Missing Deferral Header Record'

Line 1476: fnd_log.level_error,

1472: FND_MSG_PUB.ADD;
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1474: fnd_log.string
1475: (
1476: fnd_log.level_error,
1477: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1478: 'Missing Deferral Header Record'
1479: );
1480: END IF;

Line 1487: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1483: p_x_df_header_rec.unit_effectivity_id := l_df_header_rec.unit_effectivity_id;
1484: ELSIF(p_x_df_header_rec.unit_effectivity_id <> l_df_header_rec.unit_effectivity_id ) THEN
1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1486: FND_MSG_PUB.ADD;
1487: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1488: fnd_log.string
1489: (
1490: fnd_log.level_unexpected,
1491: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1488: fnd_log.string

1484: ELSIF(p_x_df_header_rec.unit_effectivity_id <> l_df_header_rec.unit_effectivity_id ) THEN
1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1486: FND_MSG_PUB.ADD;
1487: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1488: fnd_log.string
1489: (
1490: fnd_log.level_unexpected,
1491: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1492: 'Unit Effectivity ID does not match with deferral header record'

Line 1490: fnd_log.level_unexpected,

1486: FND_MSG_PUB.ADD;
1487: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1488: fnd_log.string
1489: (
1490: fnd_log.level_unexpected,
1491: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1492: 'Unit Effectivity ID does not match with deferral header record'
1493: );
1494: END IF;

Line 1504: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1500: p_x_df_header_rec.unit_deferral_type := l_df_header_rec.unit_deferral_type;
1501: ELSIF(p_x_df_header_rec.unit_deferral_type <> l_df_header_rec.unit_deferral_type) THEN
1502: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDF_TYPE');
1503: FND_MSG_PUB.ADD;
1504: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_unexpected,
1508: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1505: fnd_log.string

1501: ELSIF(p_x_df_header_rec.unit_deferral_type <> l_df_header_rec.unit_deferral_type) THEN
1502: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDF_TYPE');
1503: FND_MSG_PUB.ADD;
1504: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_unexpected,
1508: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1509: 'Unit Deferral Type does not match with deferral header record'

Line 1507: fnd_log.level_unexpected,

1503: FND_MSG_PUB.ADD;
1504: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_unexpected,
1508: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1509: 'Unit Deferral Type does not match with deferral header record'
1510: );
1511: END IF;

Line 1521: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1517: p_x_df_header_rec.approval_status_code := l_df_header_rec.approval_status_code;
1518: ELSIF(p_x_df_header_rec.approval_status_code <> l_df_header_rec.approval_status_code) THEN
1519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1520: FND_MSG_PUB.ADD;
1521: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1522: fnd_log.string
1523: (
1524: fnd_log.level_unexpected,
1525: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1522: fnd_log.string

1518: ELSIF(p_x_df_header_rec.approval_status_code <> l_df_header_rec.approval_status_code) THEN
1519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1520: FND_MSG_PUB.ADD;
1521: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1522: fnd_log.string
1523: (
1524: fnd_log.level_unexpected,
1525: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1526: 'Approval status code can not be modified'

Line 1524: fnd_log.level_unexpected,

1520: FND_MSG_PUB.ADD;
1521: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1522: fnd_log.string
1523: (
1524: fnd_log.level_unexpected,
1525: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1526: 'Approval status code can not be modified'
1527: );
1528: END IF;

Line 1574: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1570: p_x_df_header_rec.approver_notes := l_df_header_rec.approver_notes;
1571: ELSIF(p_x_df_header_rec.approver_notes <> l_df_header_rec.approver_notes) THEN
1572: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_NOTES');
1573: FND_MSG_PUB.ADD;
1574: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1575: fnd_log.string
1576: (
1577: fnd_log.level_unexpected,
1578: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1575: fnd_log.string

1571: ELSIF(p_x_df_header_rec.approver_notes <> l_df_header_rec.approver_notes) THEN
1572: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_NOTES');
1573: FND_MSG_PUB.ADD;
1574: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1575: fnd_log.string
1576: (
1577: fnd_log.level_unexpected,
1578: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1579: 'approver notes can not be updated by this API'

Line 1577: fnd_log.level_unexpected,

1573: FND_MSG_PUB.ADD;
1574: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1575: fnd_log.string
1576: (
1577: fnd_log.level_unexpected,
1578: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1579: 'approver notes can not be updated by this API'
1580: );
1581: END IF;

Line 1689: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1685: IF (p_x_df_header_rec.unit_effectivity_id IS NULL OR
1686: p_x_df_header_rec.unit_effectivity_id = FND_API.G_MISS_NUM) THEN
1687: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1688: FND_MSG_PUB.ADD;
1689: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1690: fnd_log.string
1691: (
1692: fnd_log.level_unexpected,
1693: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',

Line 1690: fnd_log.string

1686: p_x_df_header_rec.unit_effectivity_id = FND_API.G_MISS_NUM) THEN
1687: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1688: FND_MSG_PUB.ADD;
1689: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1690: fnd_log.string
1691: (
1692: fnd_log.level_unexpected,
1693: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1694: 'Unit effectivity ID can not be null while creating deferral header record'

Line 1692: fnd_log.level_unexpected,

1688: FND_MSG_PUB.ADD;
1689: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1690: fnd_log.string
1691: (
1692: fnd_log.level_unexpected,
1693: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header',
1694: 'Unit effectivity ID can not be null while creating deferral header record'
1695: );
1696: END IF;

Line 1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1806: IF(FND_MSG_PUB.count_msg > 0)THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1811: fnd_log.string
1812: (
1813: fnd_log.level_procedure,
1814: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.end',

Line 1811: fnd_log.string

1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1811: fnd_log.string
1812: (
1813: fnd_log.level_procedure,
1814: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.end',
1815: 'At the end of PLSQL procedure'

Line 1813: fnd_log.level_procedure,

1809:
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1811: fnd_log.string
1812: (
1813: fnd_log.level_procedure,
1814: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_header.end',
1815: 'At the end of PLSQL procedure'
1816: );
1817: END IF;

Line 1836: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1832: l_counter_id NUMBER;
1833:
1834: BEGIN
1835:
1836: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1837: fnd_log.string
1838: (
1839: fnd_log.level_procedure,
1840: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.begin',

Line 1837: fnd_log.string

1833:
1834: BEGIN
1835:
1836: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1837: fnd_log.string
1838: (
1839: fnd_log.level_procedure,
1840: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.begin',
1841: 'At the start of PLSQL procedure'

Line 1839: fnd_log.level_procedure,

1835:
1836: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1837: fnd_log.string
1838: (
1839: fnd_log.level_procedure,
1840: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.begin',
1841: 'At the start of PLSQL procedure'
1842: );
1843: END IF;

Line 1850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1846: -- key requirements
1847: IF(p_x_df_schedules_tbl(i).operation_flag NOT IN (G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE)) THEN
1848: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1849: FND_MSG_PUB.ADD;
1850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1851: fnd_log.string
1852: (
1853: fnd_log.level_unexpected,
1854: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1851: fnd_log.string

1847: IF(p_x_df_schedules_tbl(i).operation_flag NOT IN (G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE)) THEN
1848: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1849: FND_MSG_PUB.ADD;
1850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1851: fnd_log.string
1852: (
1853: fnd_log.level_unexpected,
1854: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1855: 'Operation Flag is invalid in the schedule record : ' || i

Line 1853: fnd_log.level_unexpected,

1849: FND_MSG_PUB.ADD;
1850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1851: fnd_log.string
1852: (
1853: fnd_log.level_unexpected,
1854: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1855: 'Operation Flag is invalid in the schedule record : ' || i
1856: );
1857: END IF;

Line 1864: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1860: IF(p_x_df_schedules_tbl(i).unit_threshold_id IS NULL OR
1861: p_x_df_schedules_tbl(i).object_version_number IS NULL) THEN
1862: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_KEY_MISS');
1863: FND_MSG_PUB.ADD;
1864: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_unexpected,
1868: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1865: fnd_log.string

1861: p_x_df_schedules_tbl(i).object_version_number IS NULL) THEN
1862: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_KEY_MISS');
1863: FND_MSG_PUB.ADD;
1864: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_unexpected,
1868: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1869: 'Object version number or key missing in schedule record : ' || i

Line 1867: fnd_log.level_unexpected,

1863: FND_MSG_PUB.ADD;
1864: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_unexpected,
1868: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1869: 'Object version number or key missing in schedule record : ' || i
1870: );
1871: END IF;

Line 1877: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1873: ELSIF (p_x_df_schedules_tbl(i).unit_deferral_id IS NOT NULL AND
1874: p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id) THEN
1875: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1876: FND_MSG_PUB.ADD;
1877: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1878: fnd_log.string
1879: (
1880: fnd_log.level_unexpected,
1881: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1878: fnd_log.string

1874: p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id) THEN
1875: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1876: FND_MSG_PUB.ADD;
1877: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1878: fnd_log.string
1879: (
1880: fnd_log.level_unexpected,
1881: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1882: 'Unit Deferral ID does not match in schedule record : ' || i

Line 1880: fnd_log.level_unexpected,

1876: FND_MSG_PUB.ADD;
1877: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1878: fnd_log.string
1879: (
1880: fnd_log.level_unexpected,
1881: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1882: 'Unit Deferral ID does not match in schedule record : ' || i
1883: );
1884: END IF;

Line 1892: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1888: IF(p_x_df_schedules_tbl(i).unit_threshold_id IS NOT NULL OR
1889: p_x_df_schedules_tbl(i).object_version_number IS NOT NULL) THEN
1890: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1891: FND_MSG_PUB.ADD;
1892: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1893: fnd_log.string
1894: (
1895: fnd_log.level_unexpected,
1896: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1893: fnd_log.string

1889: p_x_df_schedules_tbl(i).object_version_number IS NOT NULL) THEN
1890: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1891: FND_MSG_PUB.ADD;
1892: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1893: fnd_log.string
1894: (
1895: fnd_log.level_unexpected,
1896: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1897: 'For Create Operation, Unit Threshold ID or Object Version Number is not null in schedule record : ' || i

Line 1895: fnd_log.level_unexpected,

1891: FND_MSG_PUB.ADD;
1892: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1893: fnd_log.string
1894: (
1895: fnd_log.level_unexpected,
1896: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1897: 'For Create Operation, Unit Threshold ID or Object Version Number is not null in schedule record : ' || i
1898: );
1899: END IF;

Line 1908: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

1904: p_x_df_schedules_tbl(i).unit_deferral_id := p_df_header_rec.unit_deferral_id;
1905: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id)THEN
1906: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1907: FND_MSG_PUB.ADD;
1908: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1909: fnd_log.string
1910: (
1911: fnd_log.level_unexpected,
1912: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1909: fnd_log.string

1905: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id)THEN
1906: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1907: FND_MSG_PUB.ADD;
1908: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1909: fnd_log.string
1910: (
1911: fnd_log.level_unexpected,
1912: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1913: 'For Create Operation, Header Unit Deferral ID does not match with same in schedule record : ' || i

Line 1911: fnd_log.level_unexpected,

1907: FND_MSG_PUB.ADD;
1908: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1909: fnd_log.string
1910: (
1911: fnd_log.level_unexpected,
1912: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1913: 'For Create Operation, Header Unit Deferral ID does not match with same in schedule record : ' || i
1914: );
1915: END IF;

Line 1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1923: IF(counter_id_csr%NOTFOUND)THEN
1924: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
1925: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
1926: FND_MSG_PUB.ADD;
1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1928: fnd_log.string
1929: (
1930: fnd_log.level_error,
1931: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1928: fnd_log.string

1924: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
1925: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
1926: FND_MSG_PUB.ADD;
1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1928: fnd_log.string
1929: (
1930: fnd_log.level_error,
1931: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1932: 'Invalid Counter name for schedule record : ' || i

Line 1930: fnd_log.level_error,

1926: FND_MSG_PUB.ADD;
1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1928: fnd_log.string
1929: (
1930: fnd_log.level_error,
1931: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1932: 'Invalid Counter name for schedule record : ' || i
1933: );
1934: END IF;

Line 1949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1945: END IF;
1946:
1947: default_unchanged_df_schedules(p_x_df_schedules_tbl => p_x_df_schedules_tbl);
1948:
1949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1950: fnd_log.string
1951: (
1952: fnd_log.level_statement,
1953: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',

Line 1950: fnd_log.string

1946:
1947: default_unchanged_df_schedules(p_x_df_schedules_tbl => p_x_df_schedules_tbl);
1948:
1949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1950: fnd_log.string
1951: (
1952: fnd_log.level_statement,
1953: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1954: 'Logging deferral schedule records prior to validations'

Line 1952: fnd_log.level_statement,

1948:
1949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1950: fnd_log.string
1951: (
1952: fnd_log.level_statement,
1953: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules',
1954: 'Logging deferral schedule records prior to validations'
1955: );
1956: log_df_schedules(p_df_schedules_tbl => p_x_df_schedules_tbl);

Line 2061: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2057: IF(FND_MSG_PUB.count_msg > 0)THEN
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:
2061: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string
2063: (
2064: fnd_log.level_procedure,
2065: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.end',

Line 2062: fnd_log.string

2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:
2061: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string
2063: (
2064: fnd_log.level_procedure,
2065: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.end',
2066: 'At the end of PLSQL procedure'

Line 2064: fnd_log.level_procedure,

2060:
2061: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string
2063: (
2064: fnd_log.level_procedure,
2065: 'ahl.plsql.AHL_PRD_DF_PVT.process_df_schedules.end',
2066: 'At the end of PLSQL procedure'
2067: );
2068: END IF;

Line 2078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2074: PROCEDURE log_df_schedules(
2075: p_df_schedules_tbl IN AHL_PRD_DF_PVT.df_schedules_tbl_type) IS
2076:
2077: BEGIN
2078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2079: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,

Line 2080: fnd_log.string

2076:
2077: BEGIN
2078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2079: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,
2083: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2084: 'p_df_schedules_tbl('|| i ||').operation_flag : ' || p_df_schedules_tbl(i).operation_flag

Line 2082: fnd_log.level_statement,

2078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2079: FOR i IN p_df_schedules_tbl.FIRST..p_df_schedules_tbl.LAST LOOP
2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,
2083: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2084: 'p_df_schedules_tbl('|| i ||').operation_flag : ' || p_df_schedules_tbl(i).operation_flag
2085: );
2086: fnd_log.string

Line 2086: fnd_log.string

2082: fnd_log.level_statement,
2083: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2084: 'p_df_schedules_tbl('|| i ||').operation_flag : ' || p_df_schedules_tbl(i).operation_flag
2085: );
2086: fnd_log.string
2087: (
2088: fnd_log.level_statement,
2089: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2090: 'p_df_schedules_tbl('|| i ||').unit_threshold_id : ' || p_df_schedules_tbl(i).unit_threshold_id

Line 2088: fnd_log.level_statement,

2084: 'p_df_schedules_tbl('|| i ||').operation_flag : ' || p_df_schedules_tbl(i).operation_flag
2085: );
2086: fnd_log.string
2087: (
2088: fnd_log.level_statement,
2089: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2090: 'p_df_schedules_tbl('|| i ||').unit_threshold_id : ' || p_df_schedules_tbl(i).unit_threshold_id
2091: );
2092: fnd_log.string

Line 2092: fnd_log.string

2088: fnd_log.level_statement,
2089: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2090: 'p_df_schedules_tbl('|| i ||').unit_threshold_id : ' || p_df_schedules_tbl(i).unit_threshold_id
2091: );
2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2096: 'p_df_schedules_tbl('|| i ||').object_version_number : ' || p_df_schedules_tbl(i).object_version_number

Line 2094: fnd_log.level_statement,

2090: 'p_df_schedules_tbl('|| i ||').unit_threshold_id : ' || p_df_schedules_tbl(i).unit_threshold_id
2091: );
2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2096: 'p_df_schedules_tbl('|| i ||').object_version_number : ' || p_df_schedules_tbl(i).object_version_number
2097: );
2098: fnd_log.string

Line 2098: fnd_log.string

2094: fnd_log.level_statement,
2095: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2096: 'p_df_schedules_tbl('|| i ||').object_version_number : ' || p_df_schedules_tbl(i).object_version_number
2097: );
2098: fnd_log.string
2099: (
2100: fnd_log.level_statement,
2101: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2102: 'p_df_schedules_tbl('|| i ||').unit_deferral_id : ' || p_df_schedules_tbl(i).unit_deferral_id

Line 2100: fnd_log.level_statement,

2096: 'p_df_schedules_tbl('|| i ||').object_version_number : ' || p_df_schedules_tbl(i).object_version_number
2097: );
2098: fnd_log.string
2099: (
2100: fnd_log.level_statement,
2101: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2102: 'p_df_schedules_tbl('|| i ||').unit_deferral_id : ' || p_df_schedules_tbl(i).unit_deferral_id
2103: );
2104: fnd_log.string

Line 2104: fnd_log.string

2100: fnd_log.level_statement,
2101: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2102: 'p_df_schedules_tbl('|| i ||').unit_deferral_id : ' || p_df_schedules_tbl(i).unit_deferral_id
2103: );
2104: fnd_log.string
2105: (
2106: fnd_log.level_statement,
2107: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2108: 'p_df_schedules_tbl('|| i ||').counter_id : ' || p_df_schedules_tbl(i).counter_id

Line 2106: fnd_log.level_statement,

2102: 'p_df_schedules_tbl('|| i ||').unit_deferral_id : ' || p_df_schedules_tbl(i).unit_deferral_id
2103: );
2104: fnd_log.string
2105: (
2106: fnd_log.level_statement,
2107: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2108: 'p_df_schedules_tbl('|| i ||').counter_id : ' || p_df_schedules_tbl(i).counter_id
2109: );
2110: fnd_log.string

Line 2110: fnd_log.string

2106: fnd_log.level_statement,
2107: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2108: 'p_df_schedules_tbl('|| i ||').counter_id : ' || p_df_schedules_tbl(i).counter_id
2109: );
2110: fnd_log.string
2111: (
2112: fnd_log.level_statement,
2113: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2114: 'p_df_schedules_tbl('|| i ||').counter_name : ' || p_df_schedules_tbl(i).counter_name

Line 2112: fnd_log.level_statement,

2108: 'p_df_schedules_tbl('|| i ||').counter_id : ' || p_df_schedules_tbl(i).counter_id
2109: );
2110: fnd_log.string
2111: (
2112: fnd_log.level_statement,
2113: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2114: 'p_df_schedules_tbl('|| i ||').counter_name : ' || p_df_schedules_tbl(i).counter_name
2115: );
2116: fnd_log.string

Line 2116: fnd_log.string

2112: fnd_log.level_statement,
2113: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2114: 'p_df_schedules_tbl('|| i ||').counter_name : ' || p_df_schedules_tbl(i).counter_name
2115: );
2116: fnd_log.string
2117: (
2118: fnd_log.level_statement,
2119: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2120: 'p_df_schedules_tbl('|| i ||').ctr_value_type_code : ' || p_df_schedules_tbl(i).ctr_value_type_code

Line 2118: fnd_log.level_statement,

2114: 'p_df_schedules_tbl('|| i ||').counter_name : ' || p_df_schedules_tbl(i).counter_name
2115: );
2116: fnd_log.string
2117: (
2118: fnd_log.level_statement,
2119: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2120: 'p_df_schedules_tbl('|| i ||').ctr_value_type_code : ' || p_df_schedules_tbl(i).ctr_value_type_code
2121: );
2122: fnd_log.string

Line 2122: fnd_log.string

2118: fnd_log.level_statement,
2119: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2120: 'p_df_schedules_tbl('|| i ||').ctr_value_type_code : ' || p_df_schedules_tbl(i).ctr_value_type_code
2121: );
2122: fnd_log.string
2123: (
2124: fnd_log.level_statement,
2125: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2126: 'p_df_schedules_tbl('|| i ||').counter_value : ' || p_df_schedules_tbl(i).counter_value

Line 2124: fnd_log.level_statement,

2120: 'p_df_schedules_tbl('|| i ||').ctr_value_type_code : ' || p_df_schedules_tbl(i).ctr_value_type_code
2121: );
2122: fnd_log.string
2123: (
2124: fnd_log.level_statement,
2125: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2126: 'p_df_schedules_tbl('|| i ||').counter_value : ' || p_df_schedules_tbl(i).counter_value
2127: );
2128: fnd_log.string

Line 2128: fnd_log.string

2124: fnd_log.level_statement,
2125: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2126: 'p_df_schedules_tbl('|| i ||').counter_value : ' || p_df_schedules_tbl(i).counter_value
2127: );
2128: fnd_log.string
2129: (
2130: fnd_log.level_statement,
2131: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2132: 'p_df_schedules_tbl('|| i ||').unit_of_measure : ' || p_df_schedules_tbl(i).unit_of_measure

Line 2130: fnd_log.level_statement,

2126: 'p_df_schedules_tbl('|| i ||').counter_value : ' || p_df_schedules_tbl(i).counter_value
2127: );
2128: fnd_log.string
2129: (
2130: fnd_log.level_statement,
2131: 'ahl.plsql.AHL_PRD_DF_PVT.log_df_schedules',
2132: 'p_df_schedules_tbl('|| i ||').unit_of_measure : ' || p_df_schedules_tbl(i).unit_of_measure
2133: );
2134: END LOOP;

Line 2170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2166: l_exists VARCHAR2(1);
2167: --l_current_counter_value NUMBER;
2168:
2169: BEGIN
2170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_procedure,
2174: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.begin',

Line 2171: fnd_log.string

2167: --l_current_counter_value NUMBER;
2168:
2169: BEGIN
2170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_procedure,
2174: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.begin',
2175: 'At the start of PLSQL procedure'

Line 2173: fnd_log.level_procedure,

2169: BEGIN
2170: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2171: fnd_log.string
2172: (
2173: fnd_log.level_procedure,
2174: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.begin',
2175: 'At the start of PLSQL procedure'
2176: );
2177: END IF;

Line 2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2185: IF(valid_counter_csr%NOTFOUND)THEN
2186: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2187: FND_MESSAGE.Set_Token('COUNTER_NAME',p_df_schedules_tbl(i).counter_name);
2188: FND_MSG_PUB.ADD;
2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string
2191: (
2192: fnd_log.level_error,
2193: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',

Line 2190: fnd_log.string

2186: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2187: FND_MESSAGE.Set_Token('COUNTER_NAME',p_df_schedules_tbl(i).counter_name);
2188: FND_MSG_PUB.ADD;
2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string
2191: (
2192: fnd_log.level_error,
2193: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',
2194: 'Invalid Counter name for associated item instance in schedule record : ' || i

Line 2192: fnd_log.level_error,

2188: FND_MSG_PUB.ADD;
2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string
2191: (
2192: fnd_log.level_error,
2193: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',
2194: 'Invalid Counter name for associated item instance in schedule record : ' || i
2195: );
2196: END IF;

Line 2217: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2213: FETCH valid_df_rec_del_csr INTO l_exists;
2214: IF(valid_df_rec_del_csr%NOTFOUND) THEN
2215: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2216: FND_MSG_PUB.ADD;
2217: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2218: fnd_log.string
2219: (
2220: fnd_log.level_error,
2221: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',

Line 2218: fnd_log.string

2214: IF(valid_df_rec_del_csr%NOTFOUND) THEN
2215: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2216: FND_MSG_PUB.ADD;
2217: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2218: fnd_log.string
2219: (
2220: fnd_log.level_error,
2221: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',
2222: 'Record for delete operation not found with keys in schedule record : ' || i

Line 2220: fnd_log.level_error,

2216: FND_MSG_PUB.ADD;
2217: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2218: fnd_log.string
2219: (
2220: fnd_log.level_error,
2221: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules',
2222: 'Record for delete operation not found with keys in schedule record : ' || i
2223: );
2224: END IF;

Line 2235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2231: IF(FND_MSG_PUB.count_msg > 0)THEN
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234:
2235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2236: fnd_log.string
2237: (
2238: fnd_log.level_procedure,
2239: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.end',

Line 2236: fnd_log.string

2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234:
2235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2236: fnd_log.string
2237: (
2238: fnd_log.level_procedure,
2239: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.end',
2240: 'At the end of PLSQL procedure'

Line 2238: fnd_log.level_procedure,

2234:
2235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2236: fnd_log.string
2237: (
2238: fnd_log.level_procedure,
2239: 'ahl.plsql.AHL_PRD_DF_PVT.validate_df_schedules.end',
2240: 'At the end of PLSQL procedure'
2241: );
2242: END IF;

Line 2260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2256:
2257: l_df_schedules_rec AHL_PRD_DF_PVT.df_schedules_rec_type;
2258:
2259: BEGIN
2260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2261: fnd_log.string
2262: (
2263: fnd_log.level_procedure,
2264: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.begin',

Line 2261: fnd_log.string

2257: l_df_schedules_rec AHL_PRD_DF_PVT.df_schedules_rec_type;
2258:
2259: BEGIN
2260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2261: fnd_log.string
2262: (
2263: fnd_log.level_procedure,
2264: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.begin',
2265: 'At the start of PLSQL procedure'

Line 2263: fnd_log.level_procedure,

2259: BEGIN
2260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2261: fnd_log.string
2262: (
2263: fnd_log.level_procedure,
2264: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.begin',
2265: 'At the start of PLSQL procedure'
2266: );
2267: END IF;

Line 2282: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2278: l_df_schedules_rec.attribute12, l_df_schedules_rec.attribute13, l_df_schedules_rec.attribute14, l_df_schedules_rec.attribute15;
2279: IF (df_schedules_csr%NOTFOUND) THEN
2280: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2281: FND_MSG_PUB.ADD;
2282: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2283: fnd_log.string
2284: (
2285: fnd_log.level_error,
2286: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2283: fnd_log.string

2279: IF (df_schedules_csr%NOTFOUND) THEN
2280: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2281: FND_MSG_PUB.ADD;
2282: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2283: fnd_log.string
2284: (
2285: fnd_log.level_error,
2286: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2287: 'Missing Deferral Schedule Record : ' || i

Line 2285: fnd_log.level_error,

2281: FND_MSG_PUB.ADD;
2282: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2283: fnd_log.string
2284: (
2285: fnd_log.level_error,
2286: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2287: 'Missing Deferral Schedule Record : ' || i
2288: );
2289: END IF;

Line 2296: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2292: p_x_df_schedules_tbl(i).unit_deferral_id := l_df_schedules_rec.unit_deferral_id;
2293: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> l_df_schedules_rec.unit_deferral_id) THEN
2294: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
2295: FND_MSG_PUB.ADD;
2296: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2297: fnd_log.string
2298: (
2299: fnd_log.level_unexpected,
2300: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2297: fnd_log.string

2293: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> l_df_schedules_rec.unit_deferral_id) THEN
2294: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
2295: FND_MSG_PUB.ADD;
2296: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2297: fnd_log.string
2298: (
2299: fnd_log.level_unexpected,
2300: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2301: 'Unit Deferral ID does not match with deferral schedule record : ' || i

Line 2299: fnd_log.level_unexpected,

2295: FND_MSG_PUB.ADD;
2296: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2297: fnd_log.string
2298: (
2299: fnd_log.level_unexpected,
2300: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2301: 'Unit Deferral ID does not match with deferral schedule record : ' || i
2302: );
2303: END IF;

Line 2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2309: p_x_df_schedules_tbl(i).counter_id := l_df_schedules_rec.counter_id;
2310: ELSIF(p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2311: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2314: fnd_log.string
2315: (
2316: fnd_log.level_error,
2317: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2314: fnd_log.string

2310: ELSIF(p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2311: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2314: fnd_log.string
2315: (
2316: fnd_log.level_error,
2317: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2318: 'Missing counter ID in schedule Record : ' || i

Line 2316: fnd_log.level_error,

2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2314: fnd_log.string
2315: (
2316: fnd_log.level_error,
2317: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2318: 'Missing counter ID in schedule Record : ' || i
2319: );
2320: END IF;

Line 2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2327: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2332: fnd_log.string
2333: (
2334: fnd_log.level_error,
2335: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2332: fnd_log.string

2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2332: fnd_log.string
2333: (
2334: fnd_log.level_error,
2335: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2336: 'Missing counter Value in schedule Record : ' || i

Line 2334: fnd_log.level_error,

2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2332: fnd_log.string
2333: (
2334: fnd_log.level_error,
2335: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2336: 'Missing counter Value in schedule Record : ' || i
2337: );
2338: END IF;

Line 2346: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2342: p_x_df_schedules_tbl(i).ctr_value_type_code := l_df_schedules_rec.ctr_value_type_code;
2343: ELSIF(p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2344: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2345: FND_MSG_PUB.ADD;
2346: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2347: fnd_log.string
2348: (
2349: fnd_log.level_unexpected,
2350: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2347: fnd_log.string

2343: ELSIF(p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2344: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2345: FND_MSG_PUB.ADD;
2346: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2347: fnd_log.string
2348: (
2349: fnd_log.level_unexpected,
2350: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2351: 'Invalid counter value type code in deferral schedule record : ' || i

Line 2349: fnd_log.level_unexpected,

2345: FND_MSG_PUB.ADD;
2346: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2347: fnd_log.string
2348: (
2349: fnd_log.level_unexpected,
2350: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2351: 'Invalid counter value type code in deferral schedule record : ' || i
2352: );
2353: END IF;

Line 2462: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2458: IF (p_x_df_schedules_tbl(i).unit_deferral_id IS NULL OR
2459: p_x_df_schedules_tbl(i).unit_deferral_id = FND_API.G_MISS_NUM) THEN
2460: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDID');
2461: FND_MSG_PUB.ADD;
2462: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_unexpected,
2466: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2463: fnd_log.string

2459: p_x_df_schedules_tbl(i).unit_deferral_id = FND_API.G_MISS_NUM) THEN
2460: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDID');
2461: FND_MSG_PUB.ADD;
2462: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_unexpected,
2466: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2467: 'Missing Unit Deferral ID for create operation in deferral schedule record : ' || i

Line 2465: fnd_log.level_unexpected,

2461: FND_MSG_PUB.ADD;
2462: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (
2465: fnd_log.level_unexpected,
2466: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2467: 'Missing Unit Deferral ID for create operation in deferral schedule record : ' || i
2468: );
2469: END IF;

Line 2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2474: p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2475: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2476: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2477: FND_MSG_PUB.ADD;
2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2479: fnd_log.string
2480: (
2481: fnd_log.level_error,
2482: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2479: fnd_log.string

2475: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2476: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2477: FND_MSG_PUB.ADD;
2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2479: fnd_log.string
2480: (
2481: fnd_log.level_error,
2482: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2483: 'Missing counter ID in schedule Record : ' || i

Line 2481: fnd_log.level_error,

2477: FND_MSG_PUB.ADD;
2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2479: fnd_log.string
2480: (
2481: fnd_log.level_error,
2482: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2483: 'Missing counter ID in schedule Record : ' || i
2484: );
2485: END IF;

Line 2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2491: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2496: fnd_log.string
2497: (
2498: fnd_log.level_error,
2499: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2496: fnd_log.string

2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2496: fnd_log.string
2497: (
2498: fnd_log.level_error,
2499: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2500: 'Missing or invalid counter Value in schedule Record : ' || i

Line 2498: fnd_log.level_error,

2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2496: fnd_log.string
2497: (
2498: fnd_log.level_error,
2499: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2500: 'Missing or invalid counter Value in schedule Record : ' || i
2501: );
2502: END IF;

Line 2509: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2505: IF (p_x_df_schedules_tbl(i).ctr_value_type_code IS NULL OR
2506: p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2507: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2508: FND_MSG_PUB.ADD;
2509: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2510: fnd_log.string
2511: (
2512: fnd_log.level_unexpected,
2513: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',

Line 2510: fnd_log.string

2506: p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2507: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2508: FND_MSG_PUB.ADD;
2509: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2510: fnd_log.string
2511: (
2512: fnd_log.level_unexpected,
2513: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2514: 'Invalid counter value type code in deferral schedule record : ' || i

Line 2512: fnd_log.level_unexpected,

2508: FND_MSG_PUB.ADD;
2509: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2510: fnd_log.string
2511: (
2512: fnd_log.level_unexpected,
2513: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules',
2514: 'Invalid counter value type code in deferral schedule record : ' || i
2515: );
2516: END IF;

Line 2592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2588: IF(FND_MSG_PUB.count_msg > 0)THEN
2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2593: fnd_log.string
2594: (
2595: fnd_log.level_procedure,
2596: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.end',

Line 2593: fnd_log.string

2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2593: fnd_log.string
2594: (
2595: fnd_log.level_procedure,
2596: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.end',
2597: 'At the end of PLSQL procedure'

Line 2595: fnd_log.level_procedure,

2591:
2592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2593: fnd_log.string
2594: (
2595: fnd_log.level_procedure,
2596: 'ahl.plsql.AHL_PRD_DF_PVT.default_unchanged_df_schedules.end',
2597: 'At the end of PLSQL procedure'
2598: );
2599: END IF;

Line 2673: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2669: l_next_due_date DATE;
2670:
2671:
2672: BEGIN
2673: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2674: fnd_log.string
2675: (
2676: fnd_log.level_procedure,
2677: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.begin',

Line 2674: fnd_log.string

2670:
2671:
2672: BEGIN
2673: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2674: fnd_log.string
2675: (
2676: fnd_log.level_procedure,
2677: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.begin',
2678: 'At the start of PLSQL procedure'

Line 2676: fnd_log.level_procedure,

2672: BEGIN
2673: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2674: fnd_log.string
2675: (
2676: fnd_log.level_procedure,
2677: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.begin',
2678: 'At the start of PLSQL procedure'
2679: );
2680: END IF;

Line 2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2687: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);
2688: IF(l_count1 <> l_count2) THEN
2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_CNT_NAME_REP');
2690: FND_MSG_PUB.ADD;
2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2692: fnd_log.string
2693: (
2694: fnd_log.level_error,
2695: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',

Line 2692: fnd_log.string

2688: IF(l_count1 <> l_count2) THEN
2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_CNT_NAME_REP');
2690: FND_MSG_PUB.ADD;
2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2692: fnd_log.string
2693: (
2694: fnd_log.level_error,
2695: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2696: 'Counters are repeating in schedules'

Line 2694: fnd_log.level_error,

2690: FND_MSG_PUB.ADD;
2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2692: fnd_log.string
2693: (
2694: fnd_log.level_error,
2695: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2696: 'Counters are repeating in schedules'
2697: );
2698: END IF;

Line 2705: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2701: IF(l_count2 = 0)THEN
2702: IF(p_df_header_rec.set_due_date IS NULL)THEN
2703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_MAND');
2704: FND_MSG_PUB.ADD;
2705: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2706: fnd_log.string
2707: (
2708: fnd_log.level_error,
2709: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',

Line 2706: fnd_log.string

2702: IF(p_df_header_rec.set_due_date IS NULL)THEN
2703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_MAND');
2704: FND_MSG_PUB.ADD;
2705: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2706: fnd_log.string
2707: (
2708: fnd_log.level_error,
2709: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2710: 'Set due date or counter values are mandatory '

Line 2708: fnd_log.level_error,

2704: FND_MSG_PUB.ADD;
2705: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2706: fnd_log.string
2707: (
2708: fnd_log.level_error,
2709: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2710: 'Set due date or counter values are mandatory '
2711: );
2712: END IF;

Line 2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2718: IF(p_df_header_rec.deferral_effective_on IS NULL OR p_df_header_rec.deferral_effective_on > SYSDATE)THEN
2719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
2720: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
2721: FND_MSG_PUB.ADD;
2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2723: fnd_log.string
2724: (
2725: fnd_log.level_error,
2726: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',

Line 2723: fnd_log.string

2719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
2720: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
2721: FND_MSG_PUB.ADD;
2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2723: fnd_log.string
2724: (
2725: fnd_log.level_error,
2726: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2727: 'Deferral Effective On Date can not be null or greater than system date '

Line 2725: fnd_log.level_error,

2721: FND_MSG_PUB.ADD;
2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2723: fnd_log.string
2724: (
2725: fnd_log.level_error,
2726: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2727: 'Deferral Effective On Date can not be null or greater than system date '
2728: );
2729: END IF;

Line 2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_LS_CNTVAL');
2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);
2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);
2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2762: fnd_log.string
2763: (
2764: fnd_log.level_error,
2765: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',

Line 2762: fnd_log.string

2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);
2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);
2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2762: fnd_log.string
2763: (
2764: fnd_log.level_error,
2765: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2766: 'Defer to counter value is less than current counter value for counter name : ' || l_counter_name

Line 2764: fnd_log.level_error,

2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2762: fnd_log.string
2763: (
2764: fnd_log.level_error,
2765: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2766: 'Defer to counter value is less than current counter value for counter name : ' || l_counter_name
2767: );
2768: END IF;

Line 2796: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2792: x_msg_count => l_msg_count);
2793: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2794: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_DUE_DT_CALC_ERR');
2795: FND_MSG_PUB.ADD;
2796: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2797: fnd_log.string
2798: (
2799: fnd_log.level_unexpected,
2800: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',

Line 2797: fnd_log.string

2793: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2794: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_DUE_DT_CALC_ERR');
2795: FND_MSG_PUB.ADD;
2796: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2797: fnd_log.string
2798: (
2799: fnd_log.level_unexpected,
2800: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2801: 'Calculate Due Date API threw Error'

Line 2799: fnd_log.level_unexpected,

2795: FND_MSG_PUB.ADD;
2796: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2797: fnd_log.string
2798: (
2799: fnd_log.level_unexpected,
2800: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates',
2801: 'Calculate Due Date API threw Error'
2802: );
2803: END IF;

Line 2848: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2844: END IF;
2845:
2846: x_warning_msg_data := l_msg_data;
2847:
2848: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2849: fnd_log.string
2850: (
2851: fnd_log.level_procedure,
2852: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.end',

Line 2849: fnd_log.string

2845:
2846: x_warning_msg_data := l_msg_data;
2847:
2848: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2849: fnd_log.string
2850: (
2851: fnd_log.level_procedure,
2852: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.end',
2853: 'At the end of PLSQL procedure'

Line 2851: fnd_log.level_procedure,

2847:
2848: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2849: fnd_log.string
2850: (
2851: fnd_log.level_procedure,
2852: 'ahl.plsql.AHL_PRD_DF_PVT.validate_deferral_updates.end',
2853: 'At the end of PLSQL procedure'
2854: );
2855: END IF;

Line 2874: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2870:
2871: l_new_status_code VARCHAR2(30);
2872:
2873: BEGIN
2874: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2875: fnd_log.string
2876: (
2877: fnd_log.level_procedure,
2878: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.begin',

Line 2875: fnd_log.string

2871: l_new_status_code VARCHAR2(30);
2872:
2873: BEGIN
2874: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2875: fnd_log.string
2876: (
2877: fnd_log.level_procedure,
2878: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.begin',
2879: 'At the start of PLSQL procedure'

Line 2877: fnd_log.level_procedure,

2873: BEGIN
2874: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2875: fnd_log.string
2876: (
2877: fnd_log.level_procedure,
2878: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.begin',
2879: 'At the start of PLSQL procedure'
2880: );
2881: END IF;

Line 2886: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

2882:
2883: IF(p_df_header_rec.approval_status_code NOT IN('DRAFT','DEFERRAL_REJECTED'))THEN
2884: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_APPR_STS');
2885: FND_MSG_PUB.ADD;
2886: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_unexpected,
2890: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2887: fnd_log.string

2883: IF(p_df_header_rec.approval_status_code NOT IN('DRAFT','DEFERRAL_REJECTED'))THEN
2884: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_APPR_STS');
2885: FND_MSG_PUB.ADD;
2886: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_unexpected,
2890: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2891: 'Can not submit for approval because current status is : ' || p_df_header_rec.approval_status_code

Line 2889: fnd_log.level_unexpected,

2885: FND_MSG_PUB.ADD;
2886: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_unexpected,
2890: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2891: 'Can not submit for approval because current status is : ' || p_df_header_rec.approval_status_code
2892: );
2893: END IF;

Line 2900: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2896:
2897: IF(valid_for_submission( p_df_header_rec.unit_effectivity_id) = FALSE)THEN
2898: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_PRC_STS');
2899: FND_MSG_PUB.ADD;
2900: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2901: fnd_log.string
2902: (
2903: fnd_log.level_error,
2904: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2901: fnd_log.string

2897: IF(valid_for_submission( p_df_header_rec.unit_effectivity_id) = FALSE)THEN
2898: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_PRC_STS');
2899: FND_MSG_PUB.ADD;
2900: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2901: fnd_log.string
2902: (
2903: fnd_log.level_error,
2904: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2905: 'Can not submit for approval because a parent or child is in pending deferral approval status'

Line 2903: fnd_log.level_error,

2899: FND_MSG_PUB.ADD;
2900: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2901: fnd_log.string
2902: (
2903: fnd_log.level_error,
2904: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2905: 'Can not submit for approval because a parent or child is in pending deferral approval status'
2906: );
2907: END IF;

Line 2931: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2927: p_workorder_id => NULL
2928: );
2929: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
2930: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2931: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2932: fnd_log.string
2933: (
2934: fnd_log.level_error,
2935: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2932: fnd_log.string

2928: );
2929: -- if workorders under UE has external dependencies, dont submit for approval, raise error.
2930: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2931: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2932: fnd_log.string
2933: (
2934: fnd_log.level_error,
2935: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2936: 'Can not go ahead with aubmission of approval because Workorder dependencies exists'

Line 2934: fnd_log.level_error,

2930: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2931: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2932: fnd_log.string
2933: (
2934: fnd_log.level_error,
2935: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2936: 'Can not go ahead with aubmission of approval because Workorder dependencies exists'
2937: );
2938: END IF;

Line 2951: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2947: x_item_type =>l_item_type,
2948: x_return_status=>l_return_status,
2949: x_msg_count =>l_msg_count,
2950: x_msg_data =>l_msg_data);
2951: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2952: fnd_log.string
2953: (
2954: fnd_log.level_statement,
2955: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2952: fnd_log.string

2948: x_return_status=>l_return_status,
2949: x_msg_count =>l_msg_count,
2950: x_msg_data =>l_msg_data);
2951: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2952: fnd_log.string
2953: (
2954: fnd_log.level_statement,
2955: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2956: 'Workflow active flag : ' || l_active

Line 2954: fnd_log.level_statement,

2950: x_msg_data =>l_msg_data);
2951: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2952: fnd_log.string
2953: (
2954: fnd_log.level_statement,
2955: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2956: 'Workflow active flag : ' || l_active
2957: );
2958: fnd_log.string

Line 2958: fnd_log.string

2954: fnd_log.level_statement,
2955: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2956: 'Workflow active flag : ' || l_active
2957: );
2958: fnd_log.string
2959: (
2960: fnd_log.level_statement,
2961: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2962: 'l_process_name : ' || l_process_name

Line 2960: fnd_log.level_statement,

2956: 'Workflow active flag : ' || l_active
2957: );
2958: fnd_log.string
2959: (
2960: fnd_log.level_statement,
2961: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2962: 'l_process_name : ' || l_process_name
2963: );
2964: fnd_log.string

Line 2964: fnd_log.string

2960: fnd_log.level_statement,
2961: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2962: 'l_process_name : ' || l_process_name
2963: );
2964: fnd_log.string
2965: (
2966: fnd_log.level_statement,
2967: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2968: 'l_item_type : ' || l_item_type

Line 2966: fnd_log.level_statement,

2962: 'l_process_name : ' || l_process_name
2963: );
2964: fnd_log.string
2965: (
2966: fnd_log.level_statement,
2967: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2968: 'l_item_type : ' || l_item_type
2969: );
2970:

Line 2977: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2973: IF((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
2974: ( l_active <> G_YES_FLAG))THEN
2975: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_WF_INACTIVE');
2976: FND_MSG_PUB.ADD;
2977: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2978: fnd_log.string
2979: (
2980: fnd_log.level_error,
2981: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2978: fnd_log.string

2974: ( l_active <> G_YES_FLAG))THEN
2975: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_WF_INACTIVE');
2976: FND_MSG_PUB.ADD;
2977: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2978: fnd_log.string
2979: (
2980: fnd_log.level_error,
2981: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2982: 'Can not submit for approval because workflow is not active for Deferral'

Line 2980: fnd_log.level_error,

2976: FND_MSG_PUB.ADD;
2977: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2978: fnd_log.string
2979: (
2980: fnd_log.level_error,
2981: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2982: 'Can not submit for approval because workflow is not active for Deferral'
2983: );
2984: END IF;

Line 2986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2982: 'Can not submit for approval because workflow is not active for Deferral'
2983: );
2984: END IF;
2985: RAISE FND_API.G_EXC_ERROR;*/
2986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2987: fnd_log.string
2988: (
2989: fnd_log.level_statement,
2990: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 2987: fnd_log.string

2983: );
2984: END IF;
2985: RAISE FND_API.G_EXC_ERROR;*/
2986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2987: fnd_log.string
2988: (
2989: fnd_log.level_statement,
2990: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2991: 'Workflow is not active so going for automatic approval'

Line 2989: fnd_log.level_statement,

2985: RAISE FND_API.G_EXC_ERROR;*/
2986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2987: fnd_log.string
2988: (
2989: fnd_log.level_statement,
2990: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
2991: 'Workflow is not active so going for automatic approval'
2992: );
2993: END IF;

Line 3006: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3002: x_return_status => l_return_status);
3003:
3004:
3005: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3006: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3007: fnd_log.string
3008: (
3009: fnd_log.level_error,
3010: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 3007: fnd_log.string

3003:
3004:
3005: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3006: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3007: fnd_log.string
3008: (
3009: fnd_log.level_error,
3010: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3011: 'Can not go ahead with approval because AHL_PRD_DF_PVT.process_approval_initiated threw error'

Line 3009: fnd_log.level_error,

3005: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3006: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3007: fnd_log.string
3008: (
3009: fnd_log.level_error,
3010: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3011: 'Can not go ahead with approval because AHL_PRD_DF_PVT.process_approval_initiated threw error'
3012: );
3013: END IF;

Line 3017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3013: END IF;
3014: RAISE FND_API.G_EXC_ERROR;
3015: END IF;
3016:
3017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3018: fnd_log.string
3019: (
3020: fnd_log.level_statement,
3021: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 3018: fnd_log.string

3014: RAISE FND_API.G_EXC_ERROR;
3015: END IF;
3016:
3017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3018: fnd_log.string
3019: (
3020: fnd_log.level_statement,
3021: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3022: 'Workflow active flag : ' || l_active

Line 3020: fnd_log.level_statement,

3016:
3017: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3018: fnd_log.string
3019: (
3020: fnd_log.level_statement,
3021: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3022: 'Workflow active flag : ' || l_active
3023: );
3024: END IF;

Line 3055: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3051: p_object_version_number => p_df_header_rec.object_version_number,
3052: p_new_status => l_new_status_code,
3053: x_return_status => l_return_status);
3054: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3055: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_error,
3059: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',

Line 3056: fnd_log.string

3052: p_new_status => l_new_status_code,
3053: x_return_status => l_return_status);
3054: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3055: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_error,
3059: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3060: 'Can not go ahead with automatic approval because AHL_PRD_DF_PVT.process_approval_approved threw error'

Line 3058: fnd_log.level_error,

3054: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3055: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_error,
3059: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval',
3060: 'Can not go ahead with automatic approval because AHL_PRD_DF_PVT.process_approval_approved threw error'
3061: );
3062: END IF;

Line 3073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3069: RAISE FND_API.G_EXC_ERROR;
3070: END IF;
3071:
3072:
3073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3074: fnd_log.string
3075: (
3076: fnd_log.level_procedure,
3077: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.end',

Line 3074: fnd_log.string

3070: END IF;
3071:
3072:
3073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3074: fnd_log.string
3075: (
3076: fnd_log.level_procedure,
3077: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.end',
3078: 'At the end of PLSQL procedure'

Line 3076: fnd_log.level_procedure,

3072:
3073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3074: fnd_log.string
3075: (
3076: fnd_log.level_procedure,
3077: 'ahl.plsql.AHL_PRD_DF_PVT.submit_for_approval.end',
3078: 'At the end of PLSQL procedure'
3079: );
3080: END IF;

Line 3138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3134: p_new_status IN VARCHAR2,
3135: x_return_status OUT NOCOPY VARCHAR2)IS
3136:
3137: BEGIN
3138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3139: fnd_log.string
3140: (
3141: fnd_log.level_procedure,
3142: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.begin',

Line 3139: fnd_log.string

3135: x_return_status OUT NOCOPY VARCHAR2)IS
3136:
3137: BEGIN
3138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3139: fnd_log.string
3140: (
3141: fnd_log.level_procedure,
3142: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.begin',
3143: 'At the start of PLSQL procedure'

Line 3141: fnd_log.level_procedure,

3137: BEGIN
3138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3139: fnd_log.string
3140: (
3141: fnd_log.level_procedure,
3142: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.begin',
3143: 'At the start of PLSQL procedure'
3144: );
3145: END IF;

Line 3155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3151: p_object_version_number => p_object_version_number,
3152: p_approval_result_code => G_DEFERRAL_INITIATED,
3153: x_return_status => x_return_status );
3154:
3155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3156: fnd_log.string
3157: (
3158: fnd_log.level_statement,
3159: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',

Line 3156: fnd_log.string

3152: p_approval_result_code => G_DEFERRAL_INITIATED,
3153: x_return_status => x_return_status );
3154:
3155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3156: fnd_log.string
3157: (
3158: fnd_log.level_statement,
3159: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3160: 'unit_deferral_id : ' || p_unit_deferral_id

Line 3158: fnd_log.level_statement,

3154:
3155: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3156: fnd_log.string
3157: (
3158: fnd_log.level_statement,
3159: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3160: 'unit_deferral_id : ' || p_unit_deferral_id
3161: );
3162: fnd_log.string

Line 3162: fnd_log.string

3158: fnd_log.level_statement,
3159: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3160: 'unit_deferral_id : ' || p_unit_deferral_id
3161: );
3162: fnd_log.string
3163: (
3164: fnd_log.level_statement,
3165: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3166: 'object_version_number : ' || p_object_version_number

Line 3164: fnd_log.level_statement,

3160: 'unit_deferral_id : ' || p_unit_deferral_id
3161: );
3162: fnd_log.string
3163: (
3164: fnd_log.level_statement,
3165: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3166: 'object_version_number : ' || p_object_version_number
3167: );
3168: fnd_log.string

Line 3168: fnd_log.string

3164: fnd_log.level_statement,
3165: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3166: 'object_version_number : ' || p_object_version_number
3167: );
3168: fnd_log.string
3169: (
3170: fnd_log.level_statement,
3171: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3172: 'Return status after process_workorders API call : ' || x_return_status

Line 3170: fnd_log.level_statement,

3166: 'object_version_number : ' || p_object_version_number
3167: );
3168: fnd_log.string
3169: (
3170: fnd_log.level_statement,
3171: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3172: 'Return status after process_workorders API call : ' || x_return_status
3173: );
3174: END IF;

Line 3177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3173: );
3174: END IF;
3175:
3176: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3178: fnd_log.string
3179: (
3180: fnd_log.level_unexpected,
3181: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',

Line 3178: fnd_log.string

3174: END IF;
3175:
3176: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3178: fnd_log.string
3179: (
3180: fnd_log.level_unexpected,
3181: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3182: 'process_workorders API API threw error'

Line 3180: fnd_log.level_unexpected,

3176: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3177: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3178: fnd_log.string
3179: (
3180: fnd_log.level_unexpected,
3181: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3182: 'process_workorders API API threw error'
3183: );
3184: END IF;

Line 3197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3193: p_new_status => NULL,
3194: x_return_status => x_return_status);
3195:
3196: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3198: fnd_log.string
3199: (
3200: fnd_log.level_unexpected,
3201: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',

Line 3198: fnd_log.string

3194: x_return_status => x_return_status);
3195:
3196: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3198: fnd_log.string
3199: (
3200: fnd_log.level_unexpected,
3201: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3202: 'process_unit_maint_plan API threw error'

Line 3200: fnd_log.level_unexpected,

3196: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3198: fnd_log.string
3199: (
3200: fnd_log.level_unexpected,
3201: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated',
3202: 'process_unit_maint_plan API threw error'
3203: );
3204: END IF;

Line 3213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3209: SET approval_status_code = p_new_status
3210: WHERE unit_deferral_id = p_unit_deferral_id
3211: AND object_version_number = p_object_version_number;--same transaction of caller API and update already happened
3212:
3213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3214: fnd_log.string
3215: (
3216: fnd_log.level_procedure,
3217: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.end',

Line 3214: fnd_log.string

3210: WHERE unit_deferral_id = p_unit_deferral_id
3211: AND object_version_number = p_object_version_number;--same transaction of caller API and update already happened
3212:
3213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3214: fnd_log.string
3215: (
3216: fnd_log.level_procedure,
3217: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.end',
3218: 'At the end of PLSQL procedure'

Line 3216: fnd_log.level_procedure,

3212:
3213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3214: fnd_log.string
3215: (
3216: fnd_log.level_procedure,
3217: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_initiated.end',
3218: 'At the end of PLSQL procedure'
3219: );
3220: END IF;

Line 3259: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3255: l_exists VARCHAR2(1);*/
3256:
3257:
3258: BEGIN
3259: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3260: fnd_log.string
3261: (
3262: fnd_log.level_procedure,
3263: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.begin',

Line 3260: fnd_log.string

3256:
3257:
3258: BEGIN
3259: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3260: fnd_log.string
3261: (
3262: fnd_log.level_procedure,
3263: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.begin',
3264: 'At the start of PLSQL procedure'

Line 3262: fnd_log.level_procedure,

3258: BEGIN
3259: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3260: fnd_log.string
3261: (
3262: fnd_log.level_procedure,
3263: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.begin',
3264: 'At the start of PLSQL procedure'
3265: );
3266: END IF;

Line 3276: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

3272: FETCH valid_mr_csr INTO l_exists;
3273: IF(valid_mr_csr%NOTFOUND)THEN
3274: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
3275: FND_MSG_PUB.ADD;
3276: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3277: fnd_log.string
3278: (
3279: fnd_log.level_error,
3280: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',

Line 3277: fnd_log.string

3273: IF(valid_mr_csr%NOTFOUND)THEN
3274: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
3275: FND_MSG_PUB.ADD;
3276: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3277: fnd_log.string
3278: (
3279: fnd_log.level_error,
3280: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
3281: 'Associated MR has been terminated in FMP'

Line 3279: fnd_log.level_error,

3275: FND_MSG_PUB.ADD;
3276: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3277: fnd_log.string
3278: (
3279: fnd_log.level_error,
3280: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
3281: 'Associated MR has been terminated in FMP'
3282: );
3283: END IF;

Line 3289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3285: CLOSE valid_mr_csr;
3286: RETURN;
3287: END IF;
3288: CLOSE valid_mr_csr; */
3289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3290: fnd_log.string
3291: (
3292: fnd_log.level_statement,
3293: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3290: fnd_log.string

3286: RETURN;
3287: END IF;
3288: CLOSE valid_mr_csr; */
3289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3290: fnd_log.string
3291: (
3292: fnd_log.level_statement,
3293: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3294: 'unit_deferral_id : ' || p_unit_deferral_id

Line 3292: fnd_log.level_statement,

3288: CLOSE valid_mr_csr; */
3289: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3290: fnd_log.string
3291: (
3292: fnd_log.level_statement,
3293: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3294: 'unit_deferral_id : ' || p_unit_deferral_id
3295: );
3296: fnd_log.string

Line 3296: fnd_log.string

3292: fnd_log.level_statement,
3293: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3294: 'unit_deferral_id : ' || p_unit_deferral_id
3295: );
3296: fnd_log.string
3297: (
3298: fnd_log.level_statement,
3299: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3300: 'object_version_number : ' || p_object_version_number

Line 3298: fnd_log.level_statement,

3294: 'unit_deferral_id : ' || p_unit_deferral_id
3295: );
3296: fnd_log.string
3297: (
3298: fnd_log.level_statement,
3299: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3300: 'object_version_number : ' || p_object_version_number
3301: );
3302: END IF;

Line 3312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3308: p_object_version_number => p_object_version_number,
3309: p_approval_result_code => G_DEFERRAL_APPROVED,
3310: x_return_status => x_return_status);
3311:
3312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3313: fnd_log.string
3314: (
3315: fnd_log.level_statement,
3316: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3313: fnd_log.string

3309: p_approval_result_code => G_DEFERRAL_APPROVED,
3310: x_return_status => x_return_status);
3311:
3312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3313: fnd_log.string
3314: (
3315: fnd_log.level_statement,
3316: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3317: 'Return status after process_workorders API call : ' || x_return_status

Line 3315: fnd_log.level_statement,

3311:
3312: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3313: fnd_log.string
3314: (
3315: fnd_log.level_statement,
3316: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3317: 'Return status after process_workorders API call : ' || x_return_status
3318: );
3319: END IF;

Line 3322: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3318: );
3319: END IF;
3320:
3321: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3322: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3323: fnd_log.string
3324: (
3325: fnd_log.level_unexpected,
3326: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3323: fnd_log.string

3319: END IF;
3320:
3321: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3322: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3323: fnd_log.string
3324: (
3325: fnd_log.level_unexpected,
3326: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3327: 'process_workorders API threw error'

Line 3325: fnd_log.level_unexpected,

3321: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3322: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3323: fnd_log.string
3324: (
3325: fnd_log.level_unexpected,
3326: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3327: 'process_workorders API threw error'
3328: );
3329: END IF;

Line 3344: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3340: x_return_status => x_return_status);
3341:
3342: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3343:
3344: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3345: fnd_log.string
3346: (
3347: fnd_log.level_unexpected,
3348: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3345: fnd_log.string

3341:
3342: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3343:
3344: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3345: fnd_log.string
3346: (
3347: fnd_log.level_unexpected,
3348: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3349: 'process_unit_maint_plan API threw error'

Line 3347: fnd_log.level_unexpected,

3343:
3344: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3345: fnd_log.string
3346: (
3347: fnd_log.level_unexpected,
3348: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3349: 'process_unit_maint_plan API threw error'
3350: );
3351: END IF;

Line 3363: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN

3359: WHERE unit_deferral_id = p_unit_deferral_id
3360: AND object_version_number = p_object_version_number;
3361:
3362:
3363: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_event,
3367: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3364: fnd_log.string

3360: AND object_version_number = p_object_version_number;
3361:
3362:
3363: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_event,
3367: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3368: 'Succesfully approved deferral for unit_deferral_id : ' || p_unit_deferral_id

Line 3366: fnd_log.level_event,

3362:
3363: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_event,
3367: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3368: 'Succesfully approved deferral for unit_deferral_id : ' || p_unit_deferral_id
3369: );
3370: END IF;

Line 3378: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3374: );
3375: FETCH csi_item_instance_id_csr INTO l_csi_item_instance_id;
3376: IF(csi_item_instance_id_csr%NOTFOUND)THEN
3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3378: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3379: fnd_log.string
3380: (
3381: fnd_log.level_unexpected,
3382: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3379: fnd_log.string

3375: FETCH csi_item_instance_id_csr INTO l_csi_item_instance_id;
3376: IF(csi_item_instance_id_csr%NOTFOUND)THEN
3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3378: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3379: fnd_log.string
3380: (
3381: fnd_log.level_unexpected,
3382: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3383: 'Unit Effectivity record not found when fetching item instance id'

Line 3381: fnd_log.level_unexpected,

3377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3378: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3379: fnd_log.string
3380: (
3381: fnd_log.level_unexpected,
3382: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3383: 'Unit Effectivity record not found when fetching item instance id'
3384: );
3385: END IF;

Line 3389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3385: END IF;
3386: CLOSE csi_item_instance_id_csr;
3387: RETURN;
3388: ELSE
3389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3390: fnd_log.string
3391: (
3392: fnd_log.level_statement,
3393: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3390: fnd_log.string

3386: CLOSE csi_item_instance_id_csr;
3387: RETURN;
3388: ELSE
3389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3390: fnd_log.string
3391: (
3392: fnd_log.level_statement,
3393: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3394: 'p_csi_item_instance_id : ' || l_csi_item_instance_id

Line 3392: fnd_log.level_statement,

3388: ELSE
3389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3390: fnd_log.string
3391: (
3392: fnd_log.level_statement,
3393: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3394: 'p_csi_item_instance_id : ' || l_csi_item_instance_id
3395: );
3396: END IF;

Line 3404: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3400: p_csi_item_instance_id => l_csi_item_instance_id
3401: );
3402:
3403: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3404: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3405: fnd_log.string
3406: (
3407: fnd_log.level_unexpected,
3408: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3405: fnd_log.string

3401: );
3402:
3403: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3404: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3405: fnd_log.string
3406: (
3407: fnd_log.level_unexpected,
3408: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3409: 'Could not calculate due date'

Line 3407: fnd_log.level_unexpected,

3403: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3404: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3405: fnd_log.string
3406: (
3407: fnd_log.level_unexpected,
3408: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3409: 'Could not calculate due date'
3410: );
3411: END IF;

Line 3416: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3412: RETURN;
3413: END IF;
3414: END IF;
3415:
3416: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3417: fnd_log.string
3418: (
3419: fnd_log.level_procedure,
3420: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.end',

Line 3417: fnd_log.string

3413: END IF;
3414: END IF;
3415:
3416: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3417: fnd_log.string
3418: (
3419: fnd_log.level_procedure,
3420: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.end',
3421: 'At the end of PLSQL procedure'

Line 3419: fnd_log.level_procedure,

3415:
3416: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3417: fnd_log.string
3418: (
3419: fnd_log.level_procedure,
3420: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved.end',
3421: 'At the end of PLSQL procedure'
3422: );
3423: END IF;

Line 3447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3443: l_msg_count NUMBER;
3444: l_msg_data VARCHAR2(4000);
3445:
3446: BEGIN
3447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_procedure,
3451: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.begin',

Line 3448: fnd_log.string

3444: l_msg_data VARCHAR2(4000);
3445:
3446: BEGIN
3447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_procedure,
3451: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.begin',
3452: 'At the start of PLSQL procedure'

Line 3450: fnd_log.level_procedure,

3446: BEGIN
3447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_procedure,
3451: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.begin',
3452: 'At the start of PLSQL procedure'
3453: );
3454: END IF;

Line 3479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3475: END IF;
3476:
3477: -- submit request
3478: --IF(l_can_submit_request)THEN
3479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3480: fnd_log.string
3481: (
3482: fnd_log.level_statement,
3483: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3480: fnd_log.string

3476:
3477: -- submit request
3478: --IF(l_can_submit_request)THEN
3479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3480: fnd_log.string
3481: (
3482: fnd_log.level_statement,
3483: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3484: 'Submitting concurrent request to calculate due date for p_csi_item_instance_id : ' || p_csi_item_instance_id

Line 3482: fnd_log.level_statement,

3478: --IF(l_can_submit_request)THEN
3479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3480: fnd_log.string
3481: (
3482: fnd_log.level_statement,
3483: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3484: 'Submitting concurrent request to calculate due date for p_csi_item_instance_id : ' || p_csi_item_instance_id
3485: );
3486: END IF;

Line 3493: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3489: l_req_id := fnd_request.submit_request('AHL','AHLUEFF',NULL,NULL,FALSE,NULL,NULL,p_csi_item_instance_id,NULL,NULL,1);
3490:
3491: IF (l_req_id = 0 ) THEN
3492: l_concurrent_request_sucess := FALSE;
3493: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3494: fnd_log.string
3495: (
3496: fnd_log.level_statement,
3497: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3494: fnd_log.string

3490:
3491: IF (l_req_id = 0 ) THEN
3492: l_concurrent_request_sucess := FALSE;
3493: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3494: fnd_log.string
3495: (
3496: fnd_log.level_statement,
3497: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3498: 'Tried to submit concurrent request but failed'

Line 3496: fnd_log.level_statement,

3492: l_concurrent_request_sucess := FALSE;
3493: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3494: fnd_log.string
3495: (
3496: fnd_log.level_statement,
3497: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3498: 'Tried to submit concurrent request but failed'
3499: );
3500: END IF;

Line 3503: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3499: );
3500: END IF;
3501: ELSE
3502: l_concurrent_request_sucess := TRUE;
3503: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3504: fnd_log.string
3505: (
3506: fnd_log.level_statement,
3507: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3504: fnd_log.string

3500: END IF;
3501: ELSE
3502: l_concurrent_request_sucess := TRUE;
3503: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3504: fnd_log.string
3505: (
3506: fnd_log.level_statement,
3507: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3508: 'Concurrent request to calculate due date successful'

Line 3506: fnd_log.level_statement,

3502: l_concurrent_request_sucess := TRUE;
3503: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3504: fnd_log.string
3505: (
3506: fnd_log.level_statement,
3507: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3508: 'Concurrent request to calculate due date successful'
3509: );
3510: END IF;

Line 3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3513:
3514: /* -- launching concurrent program always
3515: IF NOT (l_concurrent_request_sucess) THEN
3516: -- submit online request
3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3518: fnd_log.string
3519: (
3520: fnd_log.level_statement,
3521: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',

Line 3518: fnd_log.string

3514: /* -- launching concurrent program always
3515: IF NOT (l_concurrent_request_sucess) THEN
3516: -- submit online request
3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3518: fnd_log.string
3519: (
3520: fnd_log.level_statement,
3521: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3522: 'Calculating due date online'

Line 3520: fnd_log.level_statement,

3516: -- submit online request
3517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3518: fnd_log.string
3519: (
3520: fnd_log.level_statement,
3521: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_approved',
3522: 'Calculating due date online'
3523: );
3524: END IF;

Line 3536: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3532: p_csi_item_instance_id => p_csi_item_instance_id,
3533: p_concurrent_flag => 'N');
3534:
3535: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3536: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3537: fnd_log.string
3538: (
3539: fnd_log.level_unexpected,
3540: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date',

Line 3537: fnd_log.string

3533: p_concurrent_flag => 'N');
3534:
3535: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3536: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3537: fnd_log.string
3538: (
3539: fnd_log.level_unexpected,
3540: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date',
3541: 'AHL_UMP_PROCESSUNIT_PVT.Process_Unit API threw error'

Line 3539: fnd_log.level_unexpected,

3535: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3536: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3537: fnd_log.string
3538: (
3539: fnd_log.level_unexpected,
3540: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date',
3541: 'AHL_UMP_PROCESSUNIT_PVT.Process_Unit API threw error'
3542: );
3543: END IF;

Line 3550: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3546: END IF; */
3547:
3548: x_return_status := FND_API.G_RET_STS_SUCCESS;
3549:
3550: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_procedure,
3554: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.end',

Line 3551: fnd_log.string

3547:
3548: x_return_status := FND_API.G_RET_STS_SUCCESS;
3549:
3550: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_procedure,
3554: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.end',
3555: 'At the end of PLSQL procedure'

Line 3553: fnd_log.level_procedure,

3549:
3550: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3551: fnd_log.string
3552: (
3553: fnd_log.level_procedure,
3554: 'ahl.plsql.AHL_PRD_DF_PVT.calculate_due_date.end',
3555: 'At the end of PLSQL procedure'
3556: );
3557: END IF;

Line 3569: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3565: p_object_version_number IN NUMBER,
3566: p_new_status IN VARCHAR2,
3567: x_return_status OUT NOCOPY VARCHAR2)IS
3568: BEGIN
3569: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3570: fnd_log.string
3571: (
3572: fnd_log.level_procedure,
3573: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.begin',

Line 3570: fnd_log.string

3566: p_new_status IN VARCHAR2,
3567: x_return_status OUT NOCOPY VARCHAR2)IS
3568: BEGIN
3569: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3570: fnd_log.string
3571: (
3572: fnd_log.level_procedure,
3573: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.begin',
3574: 'At the start of PLSQL procedure'

Line 3572: fnd_log.level_procedure,

3568: BEGIN
3569: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3570: fnd_log.string
3571: (
3572: fnd_log.level_procedure,
3573: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.begin',
3574: 'At the start of PLSQL procedure'
3575: );
3576: END IF;

Line 3589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3585: p_object_version_number => p_object_version_number,
3586: p_approval_result_code => G_DEFERRAL_REJECTED,
3587: x_return_status => x_return_status);
3588:
3589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3590: fnd_log.string
3591: (
3592: fnd_log.level_statement,
3593: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',

Line 3590: fnd_log.string

3586: p_approval_result_code => G_DEFERRAL_REJECTED,
3587: x_return_status => x_return_status);
3588:
3589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3590: fnd_log.string
3591: (
3592: fnd_log.level_statement,
3593: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3594: 'unit_deferral_id : ' || p_unit_deferral_id

Line 3592: fnd_log.level_statement,

3588:
3589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3590: fnd_log.string
3591: (
3592: fnd_log.level_statement,
3593: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3594: 'unit_deferral_id : ' || p_unit_deferral_id
3595: );
3596: fnd_log.string

Line 3596: fnd_log.string

3592: fnd_log.level_statement,
3593: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3594: 'unit_deferral_id : ' || p_unit_deferral_id
3595: );
3596: fnd_log.string
3597: (
3598: fnd_log.level_statement,
3599: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3600: 'object_version_number : ' || p_object_version_number

Line 3598: fnd_log.level_statement,

3594: 'unit_deferral_id : ' || p_unit_deferral_id
3595: );
3596: fnd_log.string
3597: (
3598: fnd_log.level_statement,
3599: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3600: 'object_version_number : ' || p_object_version_number
3601: );
3602: fnd_log.string

Line 3602: fnd_log.string

3598: fnd_log.level_statement,
3599: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3600: 'object_version_number : ' || p_object_version_number
3601: );
3602: fnd_log.string
3603: (
3604: fnd_log.level_statement,
3605: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3606: 'Return status after process_workorders API call : ' || x_return_status

Line 3604: fnd_log.level_statement,

3600: 'object_version_number : ' || p_object_version_number
3601: );
3602: fnd_log.string
3603: (
3604: fnd_log.level_statement,
3605: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3606: 'Return status after process_workorders API call : ' || x_return_status
3607: );
3608: fnd_log.string

Line 3608: fnd_log.string

3604: fnd_log.level_statement,
3605: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3606: 'Return status after process_workorders API call : ' || x_return_status
3607: );
3608: fnd_log.string
3609: (
3610: fnd_log.level_statement,
3611: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3612: 'New approval status : ' || p_new_status

Line 3610: fnd_log.level_statement,

3606: 'Return status after process_workorders API call : ' || x_return_status
3607: );
3608: fnd_log.string
3609: (
3610: fnd_log.level_statement,
3611: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3612: 'New approval status : ' || p_new_status
3613: );
3614: END IF;

Line 3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3613: );
3614: END IF;
3615:
3616: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',

Line 3618: fnd_log.string

3614: END IF;
3615:
3616: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3622: 'process_workorders API threw error'

Line 3620: fnd_log.level_unexpected,

3616: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3617: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3618: fnd_log.string
3619: (
3620: fnd_log.level_unexpected,
3621: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3622: 'process_workorders API threw error'
3623: );
3624: END IF;

Line 3638: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3634: p_new_status => NULL,
3635: x_return_status => x_return_status);
3636:
3637: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3638: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3639: fnd_log.string
3640: (
3641: fnd_log.level_unexpected,
3642: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',

Line 3639: fnd_log.string

3635: x_return_status => x_return_status);
3636:
3637: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3638: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3639: fnd_log.string
3640: (
3641: fnd_log.level_unexpected,
3642: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3643: 'process_unit_maint_plan API threw error'

Line 3641: fnd_log.level_unexpected,

3637: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3638: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3639: fnd_log.string
3640: (
3641: fnd_log.level_unexpected,
3642: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected',
3643: 'process_unit_maint_plan API threw error'
3644: );
3645: END IF;

Line 3655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3651: object_version_number = p_object_version_number + 1
3652: WHERE unit_deferral_id = p_unit_deferral_id
3653: AND object_version_number = p_object_version_number;
3654:
3655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3656: fnd_log.string
3657: (
3658: fnd_log.level_procedure,
3659: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.end',

Line 3656: fnd_log.string

3652: WHERE unit_deferral_id = p_unit_deferral_id
3653: AND object_version_number = p_object_version_number;
3654:
3655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3656: fnd_log.string
3657: (
3658: fnd_log.level_procedure,
3659: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.end',
3660: 'At the end of PLSQL procedure'

Line 3658: fnd_log.level_procedure,

3654:
3655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3656: fnd_log.string
3657: (
3658: fnd_log.level_procedure,
3659: 'ahl.plsql.AHL_PRD_DF_PVT.process_approval_rejected.end',
3660: 'At the end of PLSQL procedure'
3661: );
3662: END IF;

Line 3800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3796:
3797: l_status_meaning VARCHAR2(80);
3798:
3799: BEGIN
3800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3801: fnd_log.string
3802: (
3803: fnd_log.level_procedure,
3804: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.begin',

Line 3801: fnd_log.string

3797: l_status_meaning VARCHAR2(80);
3798:
3799: BEGIN
3800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3801: fnd_log.string
3802: (
3803: fnd_log.level_procedure,
3804: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.begin',
3805: 'At the start of PLSQL procedure'

Line 3803: fnd_log.level_procedure,

3799: BEGIN
3800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3801: fnd_log.string
3802: (
3803: fnd_log.level_procedure,
3804: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.begin',
3805: 'At the start of PLSQL procedure'
3806: );
3807: END IF;

Line 3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3807: END IF;
3808:
3809: x_return_status := FND_API.G_RET_STS_SUCCESS;
3810:
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3812: fnd_log.string

3808:
3809: x_return_status := FND_API.G_RET_STS_SUCCESS;
3810:
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3816: 'unit_deferral_id : ' || p_unit_deferral_id

Line 3814: fnd_log.level_statement,

3810:
3811: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3812: fnd_log.string
3813: (
3814: fnd_log.level_statement,
3815: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3816: 'unit_deferral_id : ' || p_unit_deferral_id
3817: );
3818: fnd_log.string

Line 3818: fnd_log.string

3814: fnd_log.level_statement,
3815: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3816: 'unit_deferral_id : ' || p_unit_deferral_id
3817: );
3818: fnd_log.string
3819: (
3820: fnd_log.level_statement,
3821: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3822: 'object_version_number : ' || p_object_version_number

Line 3820: fnd_log.level_statement,

3816: 'unit_deferral_id : ' || p_unit_deferral_id
3817: );
3818: fnd_log.string
3819: (
3820: fnd_log.level_statement,
3821: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3822: 'object_version_number : ' || p_object_version_number
3823: );
3824: fnd_log.string

Line 3824: fnd_log.string

3820: fnd_log.level_statement,
3821: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3822: 'object_version_number : ' || p_object_version_number
3823: );
3824: fnd_log.string
3825: (
3826: fnd_log.level_statement,
3827: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3828: 'Approval Result Code : ' || p_approval_result_code

Line 3826: fnd_log.level_statement,

3822: 'object_version_number : ' || p_object_version_number
3823: );
3824: fnd_log.string
3825: (
3826: fnd_log.level_statement,
3827: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3828: 'Approval Result Code : ' || p_approval_result_code
3829: );
3830: END IF;

Line 3838: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3834: IF(unit_effectivity_id_csr%NOTFOUND)THEN
3835: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
3836: FND_MSG_PUB.ADD;
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3839: fnd_log.string
3840: (
3841: fnd_log.level_unexpected,
3842: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3839: fnd_log.string

3835: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
3836: FND_MSG_PUB.ADD;
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3839: fnd_log.string
3840: (
3841: fnd_log.level_unexpected,
3842: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3843: 'Unit Effectivity Record not found for unit deferral id : ' || p_unit_deferral_id

Line 3841: fnd_log.level_unexpected,

3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3839: fnd_log.string
3840: (
3841: fnd_log.level_unexpected,
3842: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3843: 'Unit Effectivity Record not found for unit deferral id : ' || p_unit_deferral_id
3844: );
3845: END IF;

Line 3853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3849: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3850: RETURN;
3851: END IF;
3852:
3853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3854: fnd_log.string
3855: (
3856: fnd_log.level_statement,
3857: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3854: fnd_log.string

3850: RETURN;
3851: END IF;
3852:
3853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3854: fnd_log.string
3855: (
3856: fnd_log.level_statement,
3857: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3858: 'unit_effectivity_id : ' || l_unit_effectivity_id

Line 3856: fnd_log.level_statement,

3852:
3853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3854: fnd_log.string
3855: (
3856: fnd_log.level_statement,
3857: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3858: 'unit_effectivity_id : ' || l_unit_effectivity_id
3859: );
3860: END IF;

Line 3869: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3865: IF(validate_approver_privilages%NOTFOUND)THEN
3866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_SETUP');
3867: FND_MSG_PUB.ADD;
3868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3869: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3870: fnd_log.string
3871: (
3872: fnd_log.level_unexpected,
3873: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3870: fnd_log.string

3866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_SETUP');
3867: FND_MSG_PUB.ADD;
3868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3869: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3870: fnd_log.string
3871: (
3872: fnd_log.level_unexpected,
3873: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3874: 'Approver client information not same as the requester. workorders not found for approver'

Line 3872: fnd_log.level_unexpected,

3868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3869: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3870: fnd_log.string
3871: (
3872: fnd_log.level_unexpected,
3873: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3874: 'Approver client information not same as the requester. workorders not found for approver'
3875: );
3876: END IF;

Line 3925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3921: END IF;
3922: -- rroy
3923: -- ACL Changes
3924:
3925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3926: fnd_log.string
3927: (
3928: fnd_log.level_statement,
3929: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3926: fnd_log.string

3922: -- rroy
3923: -- ACL Changes
3924:
3925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3926: fnd_log.string
3927: (
3928: fnd_log.level_statement,
3929: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3930: 'workorder_id : ' || l_prd_workorder_rec.workorder_id

Line 3928: fnd_log.level_statement,

3924:
3925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3926: fnd_log.string
3927: (
3928: fnd_log.level_statement,
3929: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3930: 'workorder_id : ' || l_prd_workorder_rec.workorder_id
3931: );
3932: fnd_log.string

Line 3932: fnd_log.string

3928: fnd_log.level_statement,
3929: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3930: 'workorder_id : ' || l_prd_workorder_rec.workorder_id
3931: );
3932: fnd_log.string
3933: (
3934: fnd_log.level_statement,
3935: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3936: 'object_version_number : ' || l_prd_workorder_rec.object_version_number

Line 3934: fnd_log.level_statement,

3930: 'workorder_id : ' || l_prd_workorder_rec.workorder_id
3931: );
3932: fnd_log.string
3933: (
3934: fnd_log.level_statement,
3935: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3936: 'object_version_number : ' || l_prd_workorder_rec.object_version_number
3937: );
3938: fnd_log.string

Line 3938: fnd_log.string

3934: fnd_log.level_statement,
3935: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3936: 'object_version_number : ' || l_prd_workorder_rec.object_version_number
3937: );
3938: fnd_log.string
3939: (
3940: fnd_log.level_statement,
3941: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3942: 'Current Workorder status : ' || l_prd_workorder_rec.status_code

Line 3940: fnd_log.level_statement,

3936: 'object_version_number : ' || l_prd_workorder_rec.object_version_number
3937: );
3938: fnd_log.string
3939: (
3940: fnd_log.level_statement,
3941: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3942: 'Current Workorder status : ' || l_prd_workorder_rec.status_code
3943: );
3944: END IF;

Line 3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3975: END IF;
3976:
3977: -- call production API to update job status or complete job
3978: IF(l_update_flag)THEN
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3980: fnd_log.string
3981: (
3982: fnd_log.level_statement,
3983: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 3980: fnd_log.string

3976:
3977: -- call production API to update job status or complete job
3978: IF(l_update_flag)THEN
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3980: fnd_log.string
3981: (
3982: fnd_log.level_statement,
3983: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3984: 'Workorder Update Flag :TRUE '

Line 3982: fnd_log.level_statement,

3978: IF(l_update_flag)THEN
3979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3980: fnd_log.string
3981: (
3982: fnd_log.level_statement,
3983: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3984: 'Workorder Update Flag :TRUE '
3985: );
3986: fnd_log.string

Line 3986: fnd_log.string

3982: fnd_log.level_statement,
3983: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3984: 'Workorder Update Flag :TRUE '
3985: );
3986: fnd_log.string
3987: (
3988: fnd_log.level_statement,
3989: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3990: 'new Workorder status/Update : ' || l_prd_workorder_rec.status_code

Line 3988: fnd_log.level_statement,

3984: 'Workorder Update Flag :TRUE '
3985: );
3986: fnd_log.string
3987: (
3988: fnd_log.level_statement,
3989: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
3990: 'new Workorder status/Update : ' || l_prd_workorder_rec.status_code
3991: );
3992: END IF;

Line 4027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4023: x_msg_data => l_msg_data,
4024: p_x_prd_workorder_rec => l_prd_workorder_rec,
4025: p_x_prd_workoper_tbl => l_prd_workoper_tbl
4026: );
4027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4028: fnd_log.string
4029: (
4030: fnd_log.level_statement,
4031: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4028: fnd_log.string

4024: p_x_prd_workorder_rec => l_prd_workorder_rec,
4025: p_x_prd_workoper_tbl => l_prd_workoper_tbl
4026: );
4027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4028: fnd_log.string
4029: (
4030: fnd_log.level_statement,
4031: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4032: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status

Line 4030: fnd_log.level_statement,

4026: );
4027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4028: fnd_log.string
4029: (
4030: fnd_log.level_statement,
4031: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4032: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4033: );
4034: END IF;

Line 4038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4034: END IF;
4035: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4036: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4037: FND_MSG_PUB.ADD;
4038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4039: fnd_log.string
4040: (
4041: fnd_log.level_unexpected,
4042: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4039: fnd_log.string

4035: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4036: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4037: FND_MSG_PUB.ADD;
4038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4039: fnd_log.string
4040: (
4041: fnd_log.level_unexpected,
4042: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4043: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

Line 4041: fnd_log.level_unexpected,

4037: FND_MSG_PUB.ADD;
4038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4039: fnd_log.string
4040: (
4041: fnd_log.level_unexpected,
4042: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4043: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4044: );
4045: END IF;

Line 4050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4046: EXIT;
4047: END IF;
4048: /* sracha: commented out as workorder completion is no longer needed. */
4049: /* ELSIF(l_complete_flag)THEN
4050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4051: fnd_log.string
4052: (
4053: fnd_log.level_statement,
4054: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4051: fnd_log.string

4047: END IF;
4048: /* sracha: commented out as workorder completion is no longer needed. */
4049: /* ELSIF(l_complete_flag)THEN
4050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4051: fnd_log.string
4052: (
4053: fnd_log.level_statement,
4054: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4055: 'Workorder Complete Flag :TRUE '

Line 4053: fnd_log.level_statement,

4049: /* ELSIF(l_complete_flag)THEN
4050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4051: fnd_log.string
4052: (
4053: fnd_log.level_statement,
4054: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4055: 'Workorder Complete Flag :TRUE '
4056: );
4057: fnd_log.string

Line 4057: fnd_log.string

4053: fnd_log.level_statement,
4054: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4055: 'Workorder Complete Flag :TRUE '
4056: );
4057: fnd_log.string
4058: (
4059: fnd_log.level_statement,
4060: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4061: 'new Workorder status/Complete : ' || l_prd_workorder_rec.status_code

Line 4059: fnd_log.level_statement,

4055: 'Workorder Complete Flag :TRUE '
4056: );
4057: fnd_log.string
4058: (
4059: fnd_log.level_statement,
4060: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4061: 'new Workorder status/Complete : ' || l_prd_workorder_rec.status_code
4062: );
4063: END IF;

Line 4086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4082: x_msg_data => l_msg_data,
4083: p_x_prd_workorder_rec => l_prd_workorder_rec,
4084: p_x_prd_workoper_tbl => l_prd_workoper_tbl
4085: );
4086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4087: fnd_log.string
4088: (
4089: fnd_log.level_statement,
4090: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4087: fnd_log.string

4083: p_x_prd_workorder_rec => l_prd_workorder_rec,
4084: p_x_prd_workoper_tbl => l_prd_workoper_tbl
4085: );
4086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4087: fnd_log.string
4088: (
4089: fnd_log.level_statement,
4090: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4091: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status

Line 4089: fnd_log.level_statement,

4085: );
4086: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4087: fnd_log.string
4088: (
4089: fnd_log.level_statement,
4090: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4091: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4092: );
4093: END IF;

Line 4097: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4093: END IF;
4094: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4095: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4096: FND_MSG_PUB.ADD;
4097: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4098: fnd_log.string
4099: (
4100: fnd_log.level_unexpected,
4101: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4098: fnd_log.string

4094: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4095: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4096: FND_MSG_PUB.ADD;
4097: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4098: fnd_log.string
4099: (
4100: fnd_log.level_unexpected,
4101: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4102: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '

Line 4100: fnd_log.level_unexpected,

4096: FND_MSG_PUB.ADD;
4097: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4098: fnd_log.string
4099: (
4100: fnd_log.level_unexpected,
4101: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4102: 'AHL_PRD_WORKORDER_PVT.update_job API returned error '
4103: );
4104: END IF;

Line 4129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4125: x_msg_data => l_msg_data,
4126: p_workorder_id => l_prd_workorder_rec.workorder_id,
4127: p_object_version_no => l_prd_workorder_rec.object_version_number
4128: );
4129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4130: fnd_log.string
4131: (
4132: fnd_log.level_statement,
4133: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4130: fnd_log.string

4126: p_workorder_id => l_prd_workorder_rec.workorder_id,
4127: p_object_version_no => l_prd_workorder_rec.object_version_number
4128: );
4129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4130: fnd_log.string
4131: (
4132: fnd_log.level_statement,
4133: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4134: 'Status after AHL_COMPLETIONS_PVT.defer_workorder API call : ' || x_return_status

Line 4132: fnd_log.level_statement,

4128: );
4129: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4130: fnd_log.string
4131: (
4132: fnd_log.level_statement,
4133: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4134: 'Status after AHL_COMPLETIONS_PVT.defer_workorder API call : ' || x_return_status
4135: );
4136: END IF;

Line 4140: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4136: END IF;
4137: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4138: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4139: FND_MSG_PUB.ADD;
4140: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4141: fnd_log.string
4142: (
4143: fnd_log.level_unexpected,
4144: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4141: fnd_log.string

4137: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4138: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4139: FND_MSG_PUB.ADD;
4140: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4141: fnd_log.string
4142: (
4143: fnd_log.level_unexpected,
4144: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4145: 'AHL_COMPLETIONS_PVT.defer_workorder API returned error '

Line 4143: fnd_log.level_unexpected,

4139: FND_MSG_PUB.ADD;
4140: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4141: fnd_log.string
4142: (
4143: fnd_log.level_unexpected,
4144: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4145: 'AHL_COMPLETIONS_PVT.defer_workorder API returned error '
4146: );
4147: END IF;

Line 4154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4150: END IF;
4151: END IF;
4152: END LOOP;
4153:
4154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4155: fnd_log.string
4156: (
4157: fnd_log.level_statement,
4158: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',

Line 4155: fnd_log.string

4151: END IF;
4152: END LOOP;
4153:
4154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4155: fnd_log.string
4156: (
4157: fnd_log.level_statement,
4158: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4159: 'Workorder Cancel Visits Jobs '

Line 4157: fnd_log.level_statement,

4153:
4154: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4155: fnd_log.string
4156: (
4157: fnd_log.level_statement,
4158: 'before ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4159: 'Workorder Cancel Visits Jobs '
4160: );
4161: END IF;

Line 4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4164: IF(FND_MSG_PUB.count_msg > 0)THEN
4165: RETURN;
4166: END IF;
4167:
4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4169: fnd_log.string
4170: (
4171: fnd_log.level_statement,
4172: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',

Line 4169: fnd_log.string

4165: RETURN;
4166: END IF;
4167:
4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4169: fnd_log.string
4170: (
4171: fnd_log.level_statement,
4172: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4173: 'Workorder Cancel Visits Jobs '

Line 4171: fnd_log.level_statement,

4167:
4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4169: fnd_log.string
4170: (
4171: fnd_log.level_statement,
4172: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.cancel_visit_jobs',
4173: 'Workorder Cancel Visits Jobs '
4174: );
4175: END IF;

Line 4197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4193: );
4194: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4195: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4196: FND_MSG_PUB.ADD;
4197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_unexpected,
4201: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',

Line 4198: fnd_log.string

4194: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4195: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4196: FND_MSG_PUB.ADD;
4197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_unexpected,
4201: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4202: 'AHL_PRD_WORKORDERS_PVT.cancel_visit_jobs API returned error '

Line 4200: fnd_log.level_unexpected,

4196: FND_MSG_PUB.ADD;
4197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (
4200: fnd_log.level_unexpected,
4201: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders',
4202: 'AHL_PRD_WORKORDERS_PVT.cancel_visit_jobs API returned error '
4203: );
4204: END IF;

Line 4208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4204: END IF;
4205: END IF;
4206: END IF;
4207:
4208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4209: fnd_log.string
4210: (
4211: fnd_log.level_procedure,
4212: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.end',

Line 4209: fnd_log.string

4205: END IF;
4206: END IF;
4207:
4208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4209: fnd_log.string
4210: (
4211: fnd_log.level_procedure,
4212: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.end',
4213: 'At the end of PLSQL procedure'

Line 4211: fnd_log.level_procedure,

4207:
4208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4209: fnd_log.string
4210: (
4211: fnd_log.level_procedure,
4212: 'ahl.plsql.AHL_PRD_DF_PVT.process_workorders.end',
4213: 'At the end of PLSQL procedure'
4214: );
4215: END IF;

Line 4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4377: l_status_id NUMBER;
4378:
4379: BEGIN
4380:
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.begin',

Line 4382: fnd_log.string

4378:
4379: BEGIN
4380:
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.begin',
4386: 'At the start of PLSQL procedure'

Line 4384: fnd_log.level_procedure,

4380:
4381: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4382: fnd_log.string
4383: (
4384: fnd_log.level_procedure,
4385: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.begin',
4386: 'At the start of PLSQL procedure'
4387: );
4388: END IF;

Line 4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4394: IF(unit_effectivity_id_csr%NOTFOUND)THEN
4395: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
4396: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',p_unit_deferral_id);
4397: FND_MSG_PUB.ADD;
4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4399: fnd_log.string
4400: (
4401: fnd_log.level_unexpected,
4402: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',

Line 4399: fnd_log.string

4395: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
4396: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',p_unit_deferral_id);
4397: FND_MSG_PUB.ADD;
4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4399: fnd_log.string
4400: (
4401: fnd_log.level_unexpected,
4402: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
4403: 'Deferral record details not found for unit deferral id : ' || p_unit_deferral_id

Line 4401: fnd_log.level_unexpected,

4397: FND_MSG_PUB.ADD;
4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4399: fnd_log.string
4400: (
4401: fnd_log.level_unexpected,
4402: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
4403: 'Deferral record details not found for unit deferral id : ' || p_unit_deferral_id
4404: );
4405: END IF;

Line 4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

4597: THEN
4598: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_INVALID_INCIDENT_ID');
4599: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', l_cs_incident_id);
4600: FND_MSG_PUB.ADD;
4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_unexpected,
4605: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',

Line 4602: fnd_log.string

4598: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_INVALID_INCIDENT_ID');
4599: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', l_cs_incident_id);
4600: FND_MSG_PUB.ADD;
4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_unexpected,
4605: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
4606: 'Wrong SR incident id: ' || l_cs_incident_id

Line 4604: fnd_log.level_unexpected,

4600: FND_MSG_PUB.ADD;
4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (
4604: fnd_log.level_unexpected,
4605: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
4606: 'Wrong SR incident id: ' || l_cs_incident_id
4607: );
4608: END IF;

Line 4780: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4776: END IF;
4777: END LOOP;
4778: END IF;
4779:
4780: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4781: fnd_log.string
4782: (
4783: fnd_log.level_procedure,
4784: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.end',

Line 4781: fnd_log.string

4777: END LOOP;
4778: END IF;
4779:
4780: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4781: fnd_log.string
4782: (
4783: fnd_log.level_procedure,
4784: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.end',
4785: 'At the end of PLSQL procedure'

Line 4783: fnd_log.level_procedure,

4779:
4780: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4781: fnd_log.string
4782: (
4783: fnd_log.level_procedure,
4784: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan.end',
4785: 'At the end of PLSQL procedure'
4786: );
4787: END IF;

Line 4859: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4855: WHERE unit_deferral_id = p_unit_deferral_id;
4856:
4857:
4858: BEGIN
4859: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4860: fnd_log.string
4861: (
4862: fnd_log.level_procedure,
4863: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.begin',

Line 4860: fnd_log.string

4856:
4857:
4858: BEGIN
4859: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4860: fnd_log.string
4861: (
4862: fnd_log.level_procedure,
4863: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.begin',
4864: 'At the start of PLSQL procedure'

Line 4862: fnd_log.level_procedure,

4858: BEGIN
4859: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4860: fnd_log.string
4861: (
4862: fnd_log.level_procedure,
4863: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.begin',
4864: 'At the start of PLSQL procedure'
4865: );
4866: END IF;

Line 4868: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4864: 'At the start of PLSQL procedure'
4865: );
4866: END IF;
4867:
4868: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4869: fnd_log.string
4870: (
4871: fnd_log.level_statement,
4872: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',

Line 4869: fnd_log.string

4865: );
4866: END IF;
4867:
4868: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4869: fnd_log.string
4870: (
4871: fnd_log.level_statement,
4872: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',
4873: 'deleting redundant ue, relationships and marking as exception if assigned to visit'

Line 4871: fnd_log.level_statement,

4867:
4868: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4869: fnd_log.string
4870: (
4871: fnd_log.level_statement,
4872: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',
4873: 'deleting redundant ue, relationships and marking as exception if assigned to visit'
4874: );
4875: END IF;

Line 4956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4952: END IF;
4953: CLOSE assigned_to_visit_csr;
4954: END LOOP;
4955:
4956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4957: fnd_log.string
4958: (
4959: fnd_log.level_statement,
4960: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',

Line 4957: fnd_log.string

4953: CLOSE assigned_to_visit_csr;
4954: END LOOP;
4955:
4956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4957: fnd_log.string
4958: (
4959: fnd_log.level_statement,
4960: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',
4961: 'deleting un-necessary deferral records'

Line 4959: fnd_log.level_statement,

4955:
4956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4957: fnd_log.string
4958: (
4959: fnd_log.level_statement,
4960: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals',
4961: 'deleting un-necessary deferral records'
4962: );
4963: END IF;

Line 4973: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4969: AHL_UNIT_DEFERRALS_PKG.delete_row(redundant_deferral_rec.unit_deferral_id);
4970: END LOOP;
4971:
4972:
4973: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4974: fnd_log.string
4975: (
4976: fnd_log.level_procedure,
4977: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.end',

Line 4974: fnd_log.string

4970: END LOOP;
4971:
4972:
4973: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4974: fnd_log.string
4975: (
4976: fnd_log.level_procedure,
4977: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.end',
4978: 'At the end of PLSQL procedure'

Line 4976: fnd_log.level_procedure,

4972:
4973: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4974: fnd_log.string
4975: (
4976: fnd_log.level_procedure,
4977: 'ahl.plsql.AHL_PRD_DF_PVT.process_prior_ump_deferrals.end',
4978: 'At the end of PLSQL procedure'
4979: );
4980: END IF;

Line 5112: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5108: i NUMBER := 0;
5109: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
5110:
5111: BEGIN
5112: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5113: fnd_log.string
5114: (
5115: fnd_log.level_procedure,
5116: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.begin',

Line 5113: fnd_log.string

5109: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
5110:
5111: BEGIN
5112: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5113: fnd_log.string
5114: (
5115: fnd_log.level_procedure,
5116: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.begin',
5117: 'At the start of PLSQL procedure'

Line 5115: fnd_log.level_procedure,

5111: BEGIN
5112: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5113: fnd_log.string
5114: (
5115: fnd_log.level_procedure,
5116: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.begin',
5117: 'At the start of PLSQL procedure'
5118: );
5119: END IF;

Line 5127: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

5123: END IF;
5124: -- Initialize API return status to success
5125: x_return_status := FND_API.G_RET_STS_SUCCESS;
5126:
5127: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5128: fnd_log.string
5129: (
5130: fnd_log.level_statement,
5131: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5128: fnd_log.string

5124: -- Initialize API return status to success
5125: x_return_status := FND_API.G_RET_STS_SUCCESS;
5126:
5127: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5128: fnd_log.string
5129: (
5130: fnd_log.level_statement,
5131: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5132: 'Got request for deferral record of Unit effectivity ID : ' || p_unit_effectivity_id

Line 5130: fnd_log.level_statement,

5126:
5127: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5128: fnd_log.string
5129: (
5130: fnd_log.level_statement,
5131: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5132: 'Got request for deferral record of Unit effectivity ID : ' || p_unit_effectivity_id
5133: );
5134: END IF;

Line 5139: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

5135:
5136: IF(p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM)THEN
5137: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
5138: FND_MSG_PUB.ADD;
5139: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5140: fnd_log.string
5141: (
5142: fnd_log.level_unexpected,
5143: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5140: fnd_log.string

5136: IF(p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM)THEN
5137: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
5138: FND_MSG_PUB.ADD;
5139: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5140: fnd_log.string
5141: (
5142: fnd_log.level_unexpected,
5143: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5144: 'Invalid request, Unit Effectivity IS NULL'

Line 5142: fnd_log.level_unexpected,

5138: FND_MSG_PUB.ADD;
5139: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5140: fnd_log.string
5141: (
5142: fnd_log.level_unexpected,
5143: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5144: 'Invalid request, Unit Effectivity IS NULL'
5145: );
5146: END IF;

Line 5161: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

5157: IF(l_applicable_ue_id IS NULL)THEN
5158: l_applicable_ue_id := p_unit_effectivity_id;
5159: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
5160: FND_MSG_PUB.ADD;
5161: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
5162: fnd_log.string
5163: (
5164: fnd_log.level_error,
5165: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5162: fnd_log.string

5158: l_applicable_ue_id := p_unit_effectivity_id;
5159: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
5160: FND_MSG_PUB.ADD;
5161: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
5162: fnd_log.string
5163: (
5164: fnd_log.level_error,
5165: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5166: 'Status of MR or SR is not valid for deferral'

Line 5164: fnd_log.level_error,

5160: FND_MSG_PUB.ADD;
5161: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
5162: fnd_log.string
5163: (
5164: fnd_log.level_error,
5165: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5166: 'Status of MR or SR is not valid for deferral'
5167: );
5168: END IF;*/

Line 5183: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

5179:
5180: IF(context_info_csr%NOTFOUND)THEN
5181: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5182: FND_MSG_PUB.ADD;
5183: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5184: fnd_log.string
5185: (
5186: fnd_log.level_unexpected,
5187: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5184: fnd_log.string

5180: IF(context_info_csr%NOTFOUND)THEN
5181: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5182: FND_MSG_PUB.ADD;
5183: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5184: fnd_log.string
5185: (
5186: fnd_log.level_unexpected,
5187: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5188: 'Unit Effectivity record not found'

Line 5186: fnd_log.level_unexpected,

5182: FND_MSG_PUB.ADD;
5183: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5184: fnd_log.string
5185: (
5186: fnd_log.level_unexpected,
5187: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5188: 'Unit Effectivity record not found'
5189: );
5190: END IF;

Line 5204: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

5200: FETCH mr_status_meaning_csr INTO l_df_header_info_rec.ue_status_meaning;
5201: IF(mr_status_meaning_csr%NOTFOUND)THEN
5202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_MR');
5203: FND_MSG_PUB.ADD;
5204: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5205: fnd_log.string
5206: (
5207: fnd_log.level_unexpected,
5208: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5205: fnd_log.string

5201: IF(mr_status_meaning_csr%NOTFOUND)THEN
5202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_MR');
5203: FND_MSG_PUB.ADD;
5204: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5205: fnd_log.string
5206: (
5207: fnd_log.level_unexpected,
5208: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5209: 'Invalid unit effectivity record, mr status meaning not found'

Line 5207: fnd_log.level_unexpected,

5203: FND_MSG_PUB.ADD;
5204: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5205: fnd_log.string
5206: (
5207: fnd_log.level_unexpected,
5208: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5209: 'Invalid unit effectivity record, mr status meaning not found'
5210: );
5211: END IF;

Line 5224: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

5220: /* R12: UMP Deferral.
5221: IF(visit_info_csr%NOTFOUND)THEN
5222: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_VISIT');
5223: FND_MSG_PUB.ADD;
5224: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5225: fnd_log.string
5226: (
5227: fnd_log.level_unexpected,
5228: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',

Line 5225: fnd_log.string

5221: IF(visit_info_csr%NOTFOUND)THEN
5222: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_VISIT');
5223: FND_MSG_PUB.ADD;
5224: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5225: fnd_log.string
5226: (
5227: fnd_log.level_unexpected,
5228: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5229: 'Visit Information not found'

Line 5227: fnd_log.level_unexpected,

5223: FND_MSG_PUB.ADD;
5224: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5225: fnd_log.string
5226: (
5227: fnd_log.level_unexpected,
5228: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details',
5229: 'Visit Information not found'
5230: );
5231: END IF;

Line 5323: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5319: x_df_header_info_rec := l_df_header_info_rec;
5320: x_df_schedules_tbl := l_df_schedules_tbl;
5321:
5322:
5323: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5324: fnd_log.string
5325: (
5326: fnd_log.level_procedure,
5327: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.end',

Line 5324: fnd_log.string

5320: x_df_schedules_tbl := l_df_schedules_tbl;
5321:
5322:
5323: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5324: fnd_log.string
5325: (
5326: fnd_log.level_procedure,
5327: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.end',
5328: 'At the end of PLSQL procedure'

Line 5326: fnd_log.level_procedure,

5322:
5323: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5324: fnd_log.string
5325: (
5326: fnd_log.level_procedure,
5327: 'ahl.plsql.AHL_PRD_DF_PVT.get_deferral_details.end',
5328: 'At the end of PLSQL procedure'
5329: );
5330: END IF;

Line 5386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

5382: l_def_status_code;
5383: IF(applicable_ue_csr%NOTFOUND)THEN
5384: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5385: FND_MSG_PUB.ADD;
5386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5387: fnd_log.string
5388: (
5389: fnd_log.level_unexpected,
5390: 'ahl.plsql.AHL_PRD_DF_PVT.get_applicable_ue',

Line 5387: fnd_log.string

5383: IF(applicable_ue_csr%NOTFOUND)THEN
5384: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5385: FND_MSG_PUB.ADD;
5386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5387: fnd_log.string
5388: (
5389: fnd_log.level_unexpected,
5390: 'ahl.plsql.AHL_PRD_DF_PVT.get_applicable_ue',
5391: 'Unit Effectivity record not found'

Line 5389: fnd_log.level_unexpected,

5385: FND_MSG_PUB.ADD;
5386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5387: fnd_log.string
5388: (
5389: fnd_log.level_unexpected,
5390: 'ahl.plsql.AHL_PRD_DF_PVT.get_applicable_ue',
5391: 'Unit Effectivity record not found'
5392: );
5393: END IF;