eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on FND_LOG

Line 306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

302: l_inst_id NUMBER := 0 ;
303:
304: BEGIN
305:
306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
308: END IF;
309:
310:

Line 307: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');

303:
304: BEGIN
305:
306: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
308: END IF;
309:
310:
311: ------------------------- Start of Body -------------------------------------

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

323: OPEN c_visit(p_x_task_Rec.visit_id);
324: FETCH c_visit INTO c_visit_rec;
325: CLOSE c_visit;
326:
327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
328: fnd_log.string(fnd_log.level_statement, l_full_name, 'tasktype= ' || p_x_task_Rec.task_type_code);
329:
330: END IF;
331: -- Check item name or item id

Line 328: fnd_log.string(fnd_log.level_statement, l_full_name, 'tasktype= ' || p_x_task_Rec.task_type_code);

324: FETCH c_visit INTO c_visit_rec;
325: CLOSE c_visit;
326:
327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
328: fnd_log.string(fnd_log.level_statement, l_full_name, 'tasktype= ' || p_x_task_Rec.task_type_code);
329:
330: END IF;
331: -- Check item name or item id
332: IF (p_x_task_Rec.inventory_item_id IS NOT NULL AND

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

341: x_org_id => l_org_id,
342: x_item_name => l_item_name,
343: x_return_status => l_return_status,
344: x_error_msg_code => l_msg_data);
345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
346: fnd_log.string(fnd_log.level_statement, l_full_name, 'item id, item name, orgid: ' || l_item_id || '**' || l_item_name || '**' || l_org_id);
347: END IF;
348: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
349: THEN

Line 346: fnd_log.string(fnd_log.level_statement, l_full_name, 'item id, item name, orgid: ' || l_item_id || '' || l_item_name || '' || l_org_id);

342: x_item_name => l_item_name,
343: x_return_status => l_return_status,
344: x_error_msg_code => l_msg_data);
345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
346: fnd_log.string(fnd_log.level_statement, l_full_name, 'item id, item name, orgid: ' || l_item_id || '**' || l_item_name || '**' || l_org_id);
347: END IF;
348: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
349: THEN
350: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');

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

359:
360:
361: ELSE -- Else of item id and item org id exists or not
362: IF p_x_task_Rec.item_name IS NULL OR p_x_task_Rec.item_name = FND_API.g_miss_char THEN
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement, l_full_name, 'Item name missing');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_ITEM_MISSING');
367: Fnd_Msg_Pub.ADD;

Line 364: fnd_log.string(fnd_log.level_statement, l_full_name, 'Item name missing');

360:
361: ELSE -- Else of item id and item org id exists or not
362: IF p_x_task_Rec.item_name IS NULL OR p_x_task_Rec.item_name = FND_API.g_miss_char THEN
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement, l_full_name, 'Item name missing');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_ITEM_MISSING');
367: Fnd_Msg_Pub.ADD;
368: RAISE Fnd_Api.G_EXC_ERROR;

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

367: Fnd_Msg_Pub.ADD;
368: RAISE Fnd_Api.G_EXC_ERROR;
369: ELSE
370: -- Item name is not null, but at least one of item id and org id is null
371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check item else condition.');
373: END IF;
374: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
375: Fnd_Msg_Pub.ADD;

Line 372: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check item else condition.');

368: RAISE Fnd_Api.G_EXC_ERROR;
369: ELSE
370: -- Item name is not null, but at least one of item id and org id is null
371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check item else condition.');
373: END IF;
374: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
375: Fnd_Msg_Pub.ADD;
376: RAISE Fnd_Api.G_EXC_ERROR;

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

428: p_x_task_Rec.instance_id := l_instance_id;
429: END IF;
430: ELSE
431: -- Neither Serial Number not Instance Id has been passed
432: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check serial not found else');
434: END IF;
435: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_SERIAL_MISSING');
436: Fnd_Msg_Pub.ADD;

Line 433: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check serial not found else');

429: END IF;
430: ELSE
431: -- Neither Serial Number not Instance Id has been passed
432: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check serial not found else');
434: END IF;
435: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_SERIAL_MISSING');
436: Fnd_Msg_Pub.ADD;
437: RAISE Fnd_Api.G_EXC_ERROR;

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

475: p_x_task_Rec.dept_name := NULL;
476: -- Post 11.5.10 changes by Senthil
477: p_x_task_Rec.department_id := c_visit_rec.department_id;
478: END IF;
479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
480: fnd_log.string(fnd_log.level_statement, l_full_name, 'Dept ID= ' || p_x_task_Rec.department_id);
481: END IF;
482: ELSE -- Else of if visit org not exists
483: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN

Line 480: fnd_log.string(fnd_log.level_statement, l_full_name, 'Dept ID= ' || p_x_task_Rec.department_id);

476: -- Post 11.5.10 changes by Senthil
477: p_x_task_Rec.department_id := c_visit_rec.department_id;
478: END IF;
479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
480: fnd_log.string(fnd_log.level_statement, l_full_name, 'Dept ID= ' || p_x_task_Rec.department_id);
481: END IF;
482: ELSE -- Else of if visit org not exists
483: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

480: fnd_log.string(fnd_log.level_statement, l_full_name, 'Dept ID= ' || p_x_task_Rec.department_id);
481: END IF;
482: ELSE -- Else of if visit org not exists
483: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_statement, l_full_name, 'NO ORGANIZATION FOR VISIT');
486: END IF;
487: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
488: Fnd_Msg_Pub.ADD;

Line 485: fnd_log.string(fnd_log.level_statement, l_full_name, 'NO ORGANIZATION FOR VISIT');

481: END IF;
482: ELSE -- Else of if visit org not exists
483: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_statement, l_full_name, 'NO ORGANIZATION FOR VISIT');
486: END IF;
487: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
488: Fnd_Msg_Pub.ADD;
489: RAISE Fnd_Api.G_EXC_ERROR;

Line 494: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

490: END IF;
491: END IF; -- End of if visit org exists
492:
493:
494: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
495: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'At the normal execution end of the procedure');
496: END IF;
497:
498:

Line 495: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'At the normal execution end of the procedure');

491: END IF; -- End of if visit org exists
492:
493:
494: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
495: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'At the normal execution end of the procedure');
496: END IF;
497:
498:
499: ------------------------- Finish of Body -------------------------------------

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

600: BEGIN
601: --------------------- initialize -----------------------
602: SAVEPOINT Create_Unplanned_Task;
603: -- Debug info.
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fnd_log.string(fnd_log.level_procedure, l_full_name || '.begin', 'Entering Procedure');
606: END IF;
607:
608: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 605: fnd_log.string(fnd_log.level_procedure, l_full_name || '.begin', 'Entering Procedure');

601: --------------------- initialize -----------------------
602: SAVEPOINT Create_Unplanned_Task;
603: -- Debug info.
604: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
605: fnd_log.string(fnd_log.level_procedure, l_full_name || '.begin', 'Entering Procedure');
606: END IF;
607:
608: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
609: Fnd_Msg_Pub.initialize;

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

644: IF l_instance_id = FND_API.g_miss_num THEN
645: l_instance_id := NULL;
646: END IF;
647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, l_full_name, 'Visitid , service, dept: ' || l_visit_id || '---' || '---' || l_department_id);
650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);
651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;

Line 649: fnd_log.string(fnd_log.level_statement, l_full_name, 'Visitid , service, dept: ' || l_visit_id || '---' || '---' || l_department_id);

645: l_instance_id := NULL;
646: END IF;
647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, l_full_name, 'Visitid , service, dept: ' || l_visit_id || '---' || '---' || l_department_id);
650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);
651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;
653:

Line 650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);

646: END IF;
647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, l_full_name, 'Visitid , service, dept: ' || l_visit_id || '---' || '---' || l_department_id);
650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);
651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;
653:
654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );

647:
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, l_full_name, 'Visitid , service, dept: ' || l_visit_id || '---' || '---' || l_department_id);
650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);
651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;
653:
654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
655: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY with p_mr_header_id = ' || l_mr_header_id || ' and p_instance_id = ' || l_instance_id);

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

650: fnd_log.string(fnd_log.level_statement, l_full_name, 'Serial, Item, Item Org: ' || l_instance_id || '---' ||l_item_id || '---' || l_org_id);
651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;
653:
654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
655: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY with p_mr_header_id = ' || l_mr_header_id || ' and p_instance_id = ' || l_instance_id);
656: END IF;
657:
658: AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY(

Line 655: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY with p_mr_header_id = ' || l_mr_header_id || ' and p_instance_id = ' || l_instance_id);

651: fnd_log.string(fnd_log.level_statement, l_full_name, 'mr_header:' ||l_mr_header_id );
652: END IF;
653:
654: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
655: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY with p_mr_header_id = ' || l_mr_header_id || ' and p_instance_id = ' || l_instance_id);
656: END IF;
657:
658: AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY(
659: p_api_version => 1.0,

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

663: p_mr_header_id => l_mr_header_id,
664: p_instance_id => l_instance_id,
665: x_orig_ue_id => l_ue_id);
666:
667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
668: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);
669: END IF;
670:
671: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN

Line 668: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);

664: p_instance_id => l_instance_id,
665: x_orig_ue_id => l_ue_id);
666:
667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
668: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);
669: END IF;
670:
671: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
672: X_msg_count := l_msg_count;

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

677:
678: p_x_task_Rec.task_type_code :='UNPLANNED';
679: p_x_task_Rec.unit_effectivity_id :=l_ue_id;
680:
681: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK');
683: END IF;
684:
685: AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK(

Line 682: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK');

678: p_x_task_Rec.task_type_code :='UNPLANNED';
679: p_x_task_Rec.unit_effectivity_id :=l_ue_id;
680:
681: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
682: fnd_log.string(fnd_log.level_statement, l_full_name, 'About to call AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK');
683: END IF;
684:
685: AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK(
686: p_api_version => 1.0,

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

688: x_return_status => l_return_status,
689: x_msg_count => l_msg_count,
690: x_msg_data => l_msg_data);
691:
692: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
693: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK. x_return_status = ' || l_return_status || ', p_x_task_rec.VISIT_TASK_ID = ' || p_x_task_rec.VISIT_TASK_ID);
694: END IF;
695:
696: IF l_msg_count > 0 THEN

Line 693: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK. x_return_status = ' || l_return_status || ', p_x_task_rec.VISIT_TASK_ID = ' || p_x_task_rec.VISIT_TASK_ID);

689: x_msg_count => l_msg_count,
690: x_msg_data => l_msg_data);
691:
692: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
693: fnd_log.string(fnd_log.level_statement, l_full_name, 'Returned from call to AHL_VWP_PLAN_TASKS_PVT.CREATE_PLANNED_TASK. x_return_status = ' || l_return_status || ', p_x_task_rec.VISIT_TASK_ID = ' || p_x_task_rec.VISIT_TASK_ID);
694: END IF;
695:
696: IF l_msg_count > 0 THEN
697: X_msg_count := l_msg_count;

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

713: CONNECT BY cost_parent_id = PRIOR visit_task_id
714: )
715: AND material_request_type = 'PLANNED';
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);
719: END IF;
720: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'
721: WHERE visit_id = l_visit_id

Line 718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);

714: )
715: AND material_request_type = 'PLANNED';
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement, l_full_name, 'Number of ahl_schedule_materials records updated: ' || SQL%ROWCOUNT);
719: END IF;
720: UPDATE ahl_visit_tasks_b SET task_type_code = 'UNPLANNED'
721: WHERE visit_id = l_visit_id
722: AND visit_task_id IN

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

765: p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768:
769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_procedure, l_full_name ||'.end', 'Exiting procedure');
771: END IF;
772:
773: EXCEPTION

Line 770: fnd_log.string(fnd_log.level_procedure, l_full_name ||'.end', 'Exiting procedure');

766: p_data => x_msg_data
767: );
768:
769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
770: fnd_log.string(fnd_log.level_procedure, l_full_name ||'.end', 'Exiting procedure');
771: END IF;
772:
773: EXCEPTION
774: WHEN Fnd_Api.g_exc_error THEN

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

854: --------------------- initialize -----------------------
855: SAVEPOINT Update_Unplanned_Task;
856:
857: -- Debug info.
858: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
859: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************Start*************************');
860: END IF;
861:
862: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 859: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Start');

855: SAVEPOINT Update_Unplanned_Task;
856:
857: -- Debug info.
858: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
859: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************Start*************************');
860: END IF;
861:
862: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
863: Fnd_Msg_Pub.initialize;

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

884: OPEN c_Task(l_Task_rec.visit_task_id);
885: FETCH c_Task INTO c_Task_rec;
886: CLOSE c_Task;
887:
888: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);

Line 889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);

885: FETCH c_Task INTO c_Task_rec;
886: CLOSE c_Task;
887:
888: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);

Line 890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);

886: CLOSE c_Task;
887:
888: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);

Line 891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );

887:
888: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);

Line 892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);

888: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );

Line 893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);

889: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );

Line 894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);

890: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );
898: END IF;

Line 895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);

891: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );
898: END IF;
899:

Line 896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );

892: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );
898: END IF;
899:
900: ----------- Start defining and validate all LOVs on Create Visit's Task UI Screen---

Line 897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );

893: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Object version number = ' || l_task_rec.object_version_number);
894: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Duration from record = ' || l_task_rec.duration);
895: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
896: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
897: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': department_id = ' || l_task_rec.department_id );
898: END IF;
899:
900: ----------- Start defining and validate all LOVs on Create Visit's Task UI Screen---
901: --

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

921: --Assign the returned value
922: l_task_rec.department_id := l_department_id;
923: END IF;
924:
925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Dept ID= ' || l_Task_rec.department_id );
927: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent= ' || l_Task_rec.cost_parent_number);
928: END IF;
929:

Line 926: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Dept ID= ' || l_Task_rec.department_id );

922: l_task_rec.department_id := l_department_id;
923: END IF;
924:
925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Dept ID= ' || l_Task_rec.department_id );
927: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent= ' || l_Task_rec.cost_parent_number);
928: END IF;
929:
930: --

Line 927: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent= ' || l_Task_rec.cost_parent_number);

923: END IF;
924:
925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Dept ID= ' || l_Task_rec.department_id );
927: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent= ' || l_Task_rec.cost_parent_number);
928: END IF;
929:
930: --
931: -- For COST PARENT TASK

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

951: --Assign the returned value
952: l_Task_rec.cost_parent_id := l_cost_parent_id;
953: END IF;
954:
955: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
956: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent ID = ' || l_Task_rec.cost_parent_id);
957: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: Start -- For COST PARENT ');
958: END IF;
959:

Line 956: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent ID = ' || l_Task_rec.cost_parent_id);

952: l_Task_rec.cost_parent_id := l_cost_parent_id;
953: END IF;
954:
955: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
956: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent ID = ' || l_Task_rec.cost_parent_id);
957: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: Start -- For COST PARENT ');
958: END IF;
959:
960: -- To Check for cost parent task id not forming loop

Line 957: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: Start -- For COST PARENT ');

953: END IF;
954:
955: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
956: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Cost parent ID = ' || l_Task_rec.cost_parent_id);
957: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: Start -- For COST PARENT ');
958: END IF;
959:
960: -- To Check for cost parent task id not forming loop
961: IF (l_Task_rec.cost_parent_id IS NOT NULL AND

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

968: );
969:
970: END IF;
971:
972: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
973: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: End -- For COST PARENT ');
974: END IF;
975:
976: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---

Line 973: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: End -- For COST PARENT ');

969:
970: END IF;
971:
972: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
973: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Validation: End -- For COST PARENT ');
974: END IF;
975:
976: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---
977:

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

977:
978:
979: ----------------------- validate ----------------------
980:
981: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
982: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Validate');
983: END IF;
984:
985: -- For all optional fields check if its g_miss_num/g_miss_char/g_miss_date

Line 982: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Validate');

978:
979: ----------------------- validate ----------------------
980:
981: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
982: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Validate');
983: END IF;
984:
985: -- For all optional fields check if its g_miss_num/g_miss_char/g_miss_date
986: -- then Null else the value call Default_Missing_Attribs procedure

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

1032: RAISE Fnd_Api.G_EXC_ERROR;
1033: END IF;
1034:
1035: -------------------------- update --------------------
1036: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1037: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Update');
1038: END IF;
1039:
1040: --Modified by mpothuku to fix LTP forum issue #208 on 04/19/05

Line 1037: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Update');

1033: END IF;
1034:
1035: -------------------------- update --------------------
1036: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1037: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Update');
1038: END IF;
1039:
1040: --Modified by mpothuku to fix LTP forum issue #208 on 04/19/05
1041: IF( nvl(p_module_type,'XXX') <> 'LTP') THEN

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

1134: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
1135: p_task_rec => l_task_rec,
1136: x_warranty_entl_tbl => l_entl_rec_tbl);
1137:
1138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1139: fnd_log.string(fnd_log.level_statement,
1140: 'ahl.plsql.'||l_full_name,
1141: 'Before calling AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements.');
1142: END IF;

Line 1139: fnd_log.string(fnd_log.level_statement,

1135: p_task_rec => l_task_rec,
1136: x_warranty_entl_tbl => l_entl_rec_tbl);
1137:
1138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1139: fnd_log.string(fnd_log.level_statement,
1140: 'ahl.plsql.'||l_full_name,
1141: 'Before calling AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements.');
1142: END IF;
1143:

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

1148: x_return_status => l_return_status,
1149: x_msg_count => l_msg_count,
1150: x_msg_data => l_msg_data);
1151:
1152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1153: fnd_log.string(fnd_log.level_statement,
1154: 'ahl.plsql.'||l_full_name ,
1155: 'After calling AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements. Return Status = ' ||
1156: l_return_status);

Line 1153: fnd_log.string(fnd_log.level_statement,

1149: x_msg_count => l_msg_count,
1150: x_msg_data => l_msg_data);
1151:
1152: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1153: fnd_log.string(fnd_log.level_statement,
1154: 'ahl.plsql.'||l_full_name ,
1155: 'After calling AHL_WARRANTY_ENTL_PVT.Process_Warranty_Entitlements. Return Status = ' ||
1156: l_return_status);
1157: END IF;

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

1220: x_return_status => l_return_status,
1221: x_msg_count => l_msg_count,
1222: x_msg_data => l_msg_data );
1223:
1224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1225: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
1226: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.',l_full_name ||'Planned Order Flag : ' || l_planned_order_flag);
1227: END IF;
1228:

Line 1225: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

1221: x_msg_count => l_msg_count,
1222: x_msg_data => l_msg_data );
1223:
1224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1225: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
1226: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.',l_full_name ||'Planned Order Flag : ' || l_planned_order_flag);
1227: END IF;
1228:
1229: IF l_return_status <> 'S' THEN

Line 1226: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.',l_full_name ||'Planned Order Flag : ' || l_planned_order_flag);

1222: x_msg_data => l_msg_data );
1223:
1224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1225: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
1226: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.',l_full_name ||'Planned Order Flag : ' || l_planned_order_flag);
1227: END IF;
1228:
1229: IF l_return_status <> 'S' THEN
1230: RAISE Fnd_Api.G_EXC_ERROR;

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

1254: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1255: COMMIT;
1256: END IF;
1257:
1258: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1259: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************END*************************');
1260: END IF;
1261:
1262:

Line 1259: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':END');

1255: COMMIT;
1256: END IF;
1257:
1258: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1259: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************END*************************');
1260: END IF;
1261:
1262:
1263: EXCEPTION

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

1330: --------------------- initialize -----------------------
1331: SAVEPOINT Delete_Unplanned_Task;
1332:
1333: -- Check if API is called in debug mode. If yes, enable debug.
1334: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1335: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************START*************************');
1336: END IF;
1337:
1338: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 1335: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':START');

1331: SAVEPOINT Delete_Unplanned_Task;
1332:
1333: -- Check if API is called in debug mode. If yes, enable debug.
1334: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1335: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************START*************************');
1336: END IF;
1337:
1338: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1339: Fnd_Msg_Pub.initialize;

Line 1355: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1351: RAISE Fnd_Api.g_exc_unexpected_error;
1352: END IF;
1353:
1354: ------------------------Start of API Body------------------------------------
1355: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1356: THEN
1357: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Task Id' || p_visit_task_ID);
1358: END IF;
1359:

Line 1357: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Task Id' || p_visit_task_ID);

1353:
1354: ------------------------Start of API Body------------------------------------
1355: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1356: THEN
1357: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':Task Id' || p_visit_task_ID);
1358: END IF;
1359:
1360: -- To check if the input taskid exists in task entity.
1361:

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

1374: l_origin_id:= c_task_rec.originating_task_id;
1375:
1376: IF l_origin_id IS NOT NULL THEN
1377:
1378: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1379: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Before Call to Delete Summary task ');
1380: END IF;
1381:
1382: AHL_VWP_TASKS_PVT.Delete_Summary_Task(

Line 1379: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Before Call to Delete Summary task ');

1375:
1376: IF l_origin_id IS NOT NULL THEN
1377:
1378: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1379: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Before Call to Delete Summary task ');
1380: END IF;
1381:
1382: AHL_VWP_TASKS_PVT.Delete_Summary_Task(
1383: p_api_version => p_api_version,

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

1420: IF l_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1421: X_msg_count := l_msg_count;
1422: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1423:
1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1425: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Error Before Commit---> After Delete Summary task call');
1426: END IF;
1427:
1428: RAISE Fnd_Api.G_EXC_ERROR;

Line 1425: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Error Before Commit---> After Delete Summary task call');

1421: X_msg_count := l_msg_count;
1422: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1423:
1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1425: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', ' Error Before Commit---> After Delete Summary task call');
1426: END IF;
1427:
1428: RAISE Fnd_Api.G_EXC_ERROR;
1429: END IF;

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

1433: IF Fnd_Api.to_boolean (p_commit) THEN
1434: COMMIT;
1435: END IF;
1436:
1437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1438: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************END*************************');
1439: END IF;
1440: EXCEPTION
1441: WHEN Fnd_Api.g_exc_error THEN

Line 1438: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':END');

1434: COMMIT;
1435: END IF;
1436:
1437: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1438: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************END*************************');
1439: END IF;
1440: EXCEPTION
1441: WHEN Fnd_Api.g_exc_error THEN
1442: ROLLBACK TO Delete_Unplanned_Task;

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

1490: -- Validate required items.
1491:
1492: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1493:
1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1495: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Task_Items' || ':Before Check_Visit_Task_Req_Items');
1496: END IF;
1497: Check_Visit_Task_Req_Items (
1498: p_task_rec => p_task_rec,

Line 1495: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Task_Items' || ':Before Check_Visit_Task_Req_Items');

1491:
1492: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1493:
1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1495: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Task_Items' || ':Before Check_Visit_Task_Req_Items');
1496: END IF;
1497: Check_Visit_Task_Req_Items (
1498: p_task_rec => p_task_rec,
1499: x_return_status => x_return_status

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

1500: );
1501: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1502: RETURN;
1503: END IF;
1504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1505: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', 'Check_Task_Items' || ':After Check_Visit_Task_Req_Items');
1506: END IF;
1507:
1508: --

Line 1505: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', 'Check_Task_Items' || ':After Check_Visit_Task_Req_Items');

1501: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1502: RETURN;
1503: END IF;
1504: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1505: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', 'Check_Task_Items' || ':After Check_Visit_Task_Req_Items');
1506: END IF;
1507:
1508: --
1509: -- Validate uniqueness.

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

1506: END IF;
1507:
1508: --
1509: -- Validate uniqueness.
1510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1511: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');
1512: END IF;
1513: Check_Visit_Task_UK_Items (
1514: p_task_rec => p_task_rec,

Line 1511: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');

1507:
1508: --
1509: -- Validate uniqueness.
1510: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1511: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');
1512: END IF;
1513: Check_Visit_Task_UK_Items (
1514: p_task_rec => p_task_rec,
1515: p_validation_mode => p_validation_mode,

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

1517: );
1518: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1519: RETURN;
1520: END IF;
1521: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1522: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');
1523: END IF;
1524: END Check_Task_Items;
1525:

Line 1522: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');

1518: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1519: RETURN;
1520: END IF;
1521: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1522: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME, 'Check_Task_Items' ||':Before Check_Visit_Task_UK_Items');
1523: END IF;
1524: END Check_Task_Items;
1525:
1526: ---------------------------------------------------------------------

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

1576:
1577: BEGIN
1578:
1579: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1580: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1581: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items: = Start Check_Visit_Task_Req_Items ');
1582: END IF;
1583: -- TASK NAME ==== NAME
1584: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN

Line 1581: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items: = Start Check_Visit_Task_Req_Items ');

1577: BEGIN
1578:
1579: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1580: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1581: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items: = Start Check_Visit_Task_Req_Items ');
1582: END IF;
1583: -- TASK NAME ==== NAME
1584: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN
1585: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');

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

1586: Fnd_Msg_Pub.ADD;
1587: x_return_status := Fnd_Api.g_ret_sts_error;
1588: RETURN;
1589: END IF;
1590: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1591: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items:Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);
1592: END IF;
1593: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
1594: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN

Line 1591: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items:Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);

1587: x_return_status := Fnd_Api.g_ret_sts_error;
1588: RETURN;
1589: END IF;
1590: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1591: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_Req_Items:Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);
1592: END IF;
1593: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
1594: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN
1595: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');

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

1617: l_valid_flag VARCHAR2(1);
1618:
1619: BEGIN
1620: x_return_status := Fnd_Api.g_ret_sts_success;
1621: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1622: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items: = Start Check_Visit_Task_UK_Items ');
1623: END IF;
1624: --
1625: -- For Task, when ID is passed in, we need to

Line 1622: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items: = Start Check_Visit_Task_UK_Items ');

1618:
1619: BEGIN
1620: x_return_status := Fnd_Api.g_ret_sts_success;
1621: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1622: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items: = Start Check_Visit_Task_UK_Items ');
1623: END IF;
1624: --
1625: -- For Task, when ID is passed in, we need to
1626: -- check if this ID is unique.

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

1624: --
1625: -- For Task, when ID is passed in, we need to
1626: -- check if this ID is unique.
1627: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
1628: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items : = Check_Visit_Task_UK_Items Uniqueness Of ID');
1630: END IF;
1631: -- FOR CREATION
1632: IF Ahl_Utility_Pvt.check_uniqueness(

Line 1629: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items : = Check_Visit_Task_UK_Items Uniqueness Of ID');

1625: -- For Task, when ID is passed in, we need to
1626: -- check if this ID is unique.
1627: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
1628: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items : = Check_Visit_Task_UK_Items Uniqueness Of ID');
1630: END IF;
1631: -- FOR CREATION
1632: IF Ahl_Utility_Pvt.check_uniqueness(
1633: 'Ahl_Visit_Tasks_vl',