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_PRD_NONROUTINE_PVT dependencies on FND_LOG

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

418: */
419: -- NR MR ER - End
420:
421: -- NR MR ER - start
422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
423: fnd_log.string(
424: fnd_log.level_statement,
425: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
426: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT

Line 423: fnd_log.string(

419: -- NR MR ER - End
420:
421: -- NR MR ER - start
422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
423: fnd_log.string(
424: fnd_log.level_statement,
425: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
426: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT
427: );

Line 424: fnd_log.level_statement,

420:
421: -- NR MR ER - start
422: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
423: fnd_log.string(
424: fnd_log.level_statement,
425: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
426: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT
427: );
428: END IF;

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

445: x_msg_count => x_msg_count,
446: x_msg_data => x_msg_data
447: );
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string(
451: fnd_log.level_statement,
452: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
453: 'After calling Process_Mr...Return status->'||x_return_status

Line 450: fnd_log.string(

446: x_msg_data => x_msg_data
447: );
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string(
451: fnd_log.level_statement,
452: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
453: 'After calling Process_Mr...Return status->'||x_return_status
454: );

Line 451: fnd_log.level_statement,

447: );
448:
449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string(
451: fnd_log.level_statement,
452: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
453: 'After calling Process_Mr...Return status->'||x_return_status
454: );
455: END IF;

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

474: END IF;
475: -- Bug # 8267142 (FP for KAL Bug # 7667326) -- end
476: END IF;
477:
478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
479: fnd_log.string(
480: fnd_log.level_statement,
481: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
482: 'After Process_Mr API'

Line 479: fnd_log.string(

475: -- Bug # 8267142 (FP for KAL Bug # 7667326) -- end
476: END IF;
477:
478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
479: fnd_log.string(
480: fnd_log.level_statement,
481: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
482: 'After Process_Mr API'
483: );

Line 480: fnd_log.level_statement,

476: END IF;
477:
478: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
479: fnd_log.string(
480: fnd_log.level_statement,
481: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
482: 'After Process_Mr API'
483: );
484: END IF;

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

501: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
506: fnd_log.string(fnd_log.level_statement,
507: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
508: 'After Update_warranty_entitlements API');
509: END IF;

Line 506: fnd_log.string(fnd_log.level_statement,

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
506: fnd_log.string(fnd_log.level_statement,
507: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
508: 'After Update_warranty_entitlements API');
509: END IF;
510:

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

2284: -- Tamal [MEL/CDL PRD Integration] Ends here...
2285:
2286: -- MR NR ER -- start
2287:
2288: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string(
2290: fnd_log.level_statement,
2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before Updating Unit Effectivity with Originating WO detail..'

Line 2289: fnd_log.string(

2285:
2286: -- MR NR ER -- start
2287:
2288: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string(
2290: fnd_log.level_statement,
2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before Updating Unit Effectivity with Originating WO detail..'
2293: );

Line 2290: fnd_log.level_statement,

2286: -- MR NR ER -- start
2287:
2288: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2289: fnd_log.string(
2290: fnd_log.level_statement,
2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before Updating Unit Effectivity with Originating WO detail..'
2293: );
2294: fnd_log.string(

Line 2294: fnd_log.string(

2290: fnd_log.level_statement,
2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before Updating Unit Effectivity with Originating WO detail..'
2293: );
2294: fnd_log.string(
2295: fnd_log.level_statement,
2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_sr_task_rec.Originating_wo_id->'||p_x_sr_task_rec.Originating_wo_id||' , '
2298: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id

Line 2295: fnd_log.level_statement,

2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before Updating Unit Effectivity with Originating WO detail..'
2293: );
2294: fnd_log.string(
2295: fnd_log.level_statement,
2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_sr_task_rec.Originating_wo_id->'||p_x_sr_task_rec.Originating_wo_id||' , '
2298: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id
2299: );

Line 2390: l_log_procedure NUMBER := FND_LOG.level_procedure;

2386: l_full_name CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2387: l_tranit_tech_resp_id CONSTANT NUMBER := 64156;
2388: l_tech_resp_id CONSTANT NUMBER := 64157;
2389: l_data_clerk_resp_id CONSTANT NUMBER := 64158;
2390: l_log_procedure NUMBER := FND_LOG.level_procedure;
2391: l_log_statement NUMBER := FND_LOG.level_statement;
2392: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
2393:
2394: l_rec_count NUMBER := 0;

Line 2391: l_log_statement NUMBER := FND_LOG.level_statement;

2387: l_tranit_tech_resp_id CONSTANT NUMBER := 64156;
2388: l_tech_resp_id CONSTANT NUMBER := 64157;
2389: l_data_clerk_resp_id CONSTANT NUMBER := 64158;
2390: l_log_procedure NUMBER := FND_LOG.level_procedure;
2391: l_log_statement NUMBER := FND_LOG.level_statement;
2392: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
2393:
2394: l_rec_count NUMBER := 0;
2395: l_user_role VARCHAR2(5);

Line 2392: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

2388: l_tech_resp_id CONSTANT NUMBER := 64157;
2389: l_data_clerk_resp_id CONSTANT NUMBER := 64158;
2390: l_log_procedure NUMBER := FND_LOG.level_procedure;
2391: l_log_statement NUMBER := FND_LOG.level_statement;
2392: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
2393:
2394: l_rec_count NUMBER := 0;
2395: l_user_role VARCHAR2(5);
2396: l_warranty_entl_id NUMBER;

Line 2406: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'Entering Procedure');

2402: --
2403: BEGIN
2404:
2405: IF (l_log_procedure >= l_log_current_level) THEN
2406: FND_LOG.string(l_log_procedure, l_full_name || '.begin', 'Entering Procedure');
2407: END IF;
2408:
2409: -- condition 1 (conditions are given in Procedure Function above)
2410: IF (p_mr_asso_count = 0) THEN

Line 2426: FND_LOG.string(l_log_statement, l_full_name, 'invalid SR id for updating warranty entitlement record');

2422:
2423: IF (Get_warranty_entl_rec_csr%NOTFOUND) THEN
2424: -- invalid sr incident id
2425: IF (l_log_statement >= l_log_current_level) THEN
2426: FND_LOG.string(l_log_statement, l_full_name, 'invalid SR id for updating warranty entitlement record');
2427: END IF;
2428:
2429: x_return_status := FND_API.G_RET_STS_ERROR;
2430: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');

Line 2479: FND_LOG.string(l_log_statement, l_full_name, 'invalid visit task id for updating warranty entitlement record');

2475:
2476: IF (Get_workorder_id_csr%NOTFOUND) THEN
2477: -- invalid visit task id
2478: IF (l_log_statement >= l_log_current_level) THEN
2479: FND_LOG.string(l_log_statement, l_full_name, 'invalid visit task id for updating warranty entitlement record');
2480: END IF;
2481:
2482: x_return_status := FND_API.G_RET_STS_ERROR;
2483: FND_MESSAGE.set_name('AHL', 'AHL_LTP_TASK_ID_INVALID');

Line 2516: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'Exiting Procedure');

2512: );
2513: END IF;
2514:
2515: IF (l_log_procedure >= l_log_current_level) THEN
2516: FND_LOG.string(l_log_procedure, l_full_name || '.end', 'Exiting Procedure');
2517: END IF;
2518:
2519: END Update_warranty_entitlements;
2520:

Line 2691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2687: l_msg_data VARCHAR2(2000);
2688:
2689: BEGIN
2690:
2691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2693: END IF;
2694:
2695: FOR i in p_x_task_tbl.FIRST .. p_x_task_tbl.LAST

Line 2692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');

2688:
2689: BEGIN
2690:
2691: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2693: END IF;
2694:
2695: FOR i in p_x_task_tbl.FIRST .. p_x_task_tbl.LAST
2696: LOOP

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

2707: OPEN c_get_sr_details(p_x_task_tbl(i).Incident_id);
2708: FETCH c_get_sr_details INTO p_x_task_tbl(i).Incident_object_version_number;
2709: CLOSE c_get_sr_details;
2710:
2711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2712: fnd_log.string(
2713: fnd_log.level_statement,
2714: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2715: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'

Line 2712: fnd_log.string(

2708: FETCH c_get_sr_details INTO p_x_task_tbl(i).Incident_object_version_number;
2709: CLOSE c_get_sr_details;
2710:
2711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2712: fnd_log.string(
2713: fnd_log.level_statement,
2714: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2715: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2716: );

Line 2713: fnd_log.level_statement,

2709: CLOSE c_get_sr_details;
2710:
2711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2712: fnd_log.string(
2713: fnd_log.level_statement,
2714: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2715: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2716: );
2717: fnd_log.string(

Line 2717: fnd_log.string(

2713: fnd_log.level_statement,
2714: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2715: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2716: );
2717: fnd_log.string(
2718: fnd_log.level_statement,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2720: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2721: );

Line 2718: fnd_log.level_statement,

2714: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2715: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2716: );
2717: fnd_log.string(
2718: fnd_log.level_statement,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2720: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2721: );
2722: fnd_log.string(

Line 2722: fnd_log.string(

2718: fnd_log.level_statement,
2719: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2720: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2721: );
2722: fnd_log.string(
2723: fnd_log.level_statement,
2724: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2725: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2726: );

Line 2723: fnd_log.level_statement,

2719: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2720: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2721: );
2722: fnd_log.string(
2723: fnd_log.level_statement,
2724: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2725: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2726: );
2727: fnd_log.string(

Line 2727: fnd_log.string(

2723: fnd_log.level_statement,
2724: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2725: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2726: );
2727: fnd_log.string(
2728: fnd_log.level_statement,
2729: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2730: 'p_x_task_tbl(i).Incident_number'||p_x_task_tbl(i).Incident_number
2731: );

Line 2728: fnd_log.level_statement,

2724: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2725: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2726: );
2727: fnd_log.string(
2728: fnd_log.level_statement,
2729: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2730: 'p_x_task_tbl(i).Incident_number'||p_x_task_tbl(i).Incident_number
2731: );
2732: END IF;

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

2747: p_request_number => p_x_task_tbl(i).Incident_number,
2748: p_x_sr_mr_association_tbl => l_x_sr_mr_association_tbl
2749: );
2750:
2751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2752: fnd_log.string(
2753: fnd_log.level_statement,
2754: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2755: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status

Line 2752: fnd_log.string(

2748: p_x_sr_mr_association_tbl => l_x_sr_mr_association_tbl
2749: );
2750:
2751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2752: fnd_log.string(
2753: fnd_log.level_statement,
2754: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2755: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status
2756: );

Line 2753: fnd_log.level_statement,

2749: );
2750:
2751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2752: fnd_log.string(
2753: fnd_log.level_statement,
2754: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2755: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status
2756: );
2757: END IF;

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

2819: FETCH get_firm_planned_flag_csr into l_firm_planned_flag;
2820: CLOSE get_firm_planned_flag_csr;
2821: END IF;
2822:
2823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2824: fnd_log.string(
2825: fnd_log.level_statement,
2826: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2827: 'abh wo firm flag'|| p_x_task_tbl(i).firmWo_flag || 'l_firm_planned_flag' || l_firm_planned_flag ||

Line 2824: fnd_log.string(

2820: CLOSE get_firm_planned_flag_csr;
2821: END IF;
2822:
2823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2824: fnd_log.string(
2825: fnd_log.level_statement,
2826: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2827: 'abh wo firm flag'|| p_x_task_tbl(i).firmWo_flag || 'l_firm_planned_flag' || l_firm_planned_flag ||
2828: 'wo id' || l_workorder_id

Line 2825: fnd_log.level_statement,

2821: END IF;
2822:
2823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2824: fnd_log.string(
2825: fnd_log.level_statement,
2826: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2827: 'abh wo firm flag'|| p_x_task_tbl(i).firmWo_flag || 'l_firm_planned_flag' || l_firm_planned_flag ||
2828: 'wo id' || l_workorder_id
2829: );

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

2838: l_create_task_tbl(l_tsk_count).task_start_date := p_x_task_tbl(i).workorder_start_time;
2839: END IF;
2840: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- end
2841:
2842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2843: fnd_log.string(
2844: fnd_log.level_statement,
2845: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2846: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'

Line 2843: fnd_log.string(

2839: END IF;
2840: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- end
2841:
2842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2843: fnd_log.string(
2844: fnd_log.level_statement,
2845: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2846: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2847: );

Line 2844: fnd_log.level_statement,

2840: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- end
2841:
2842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2843: fnd_log.string(
2844: fnd_log.level_statement,
2845: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2846: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2847: );
2848: fnd_log.string(

Line 2848: fnd_log.string(

2844: fnd_log.level_statement,
2845: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2846: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2847: );
2848: fnd_log.string(
2849: fnd_log.level_statement,
2850: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2851: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2852: );

Line 2849: fnd_log.level_statement,

2845: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2846: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2847: );
2848: fnd_log.string(
2849: fnd_log.level_statement,
2850: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2851: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2852: );
2853: fnd_log.string(

Line 2853: fnd_log.string(

2849: fnd_log.level_statement,
2850: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2851: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2852: );
2853: fnd_log.string(
2854: fnd_log.level_statement,
2855: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2856: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2857: );

Line 2854: fnd_log.level_statement,

2850: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2851: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2852: );
2853: fnd_log.string(
2854: fnd_log.level_statement,
2855: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2856: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2857: );
2858: fnd_log.string(

Line 2858: fnd_log.string(

2854: fnd_log.level_statement,
2855: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2856: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2857: );
2858: fnd_log.string(
2859: fnd_log.level_statement,
2860: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2861: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2862: );

Line 2859: fnd_log.level_statement,

2855: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2856: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2857: );
2858: fnd_log.string(
2859: fnd_log.level_statement,
2860: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2861: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2862: );
2863: fnd_log.string(

Line 2863: fnd_log.string(

2859: fnd_log.level_statement,
2860: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2861: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2862: );
2863: fnd_log.string(
2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2866: 'p_x_task_tbl(i).service_type ->'||p_x_task_tbl(i).service_type
2867: );

Line 2864: fnd_log.level_statement,

2860: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2861: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2862: );
2863: fnd_log.string(
2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2866: 'p_x_task_tbl(i).service_type ->'||p_x_task_tbl(i).service_type
2867: );
2868: fnd_log.string(

Line 2868: fnd_log.string(

2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2866: 'p_x_task_tbl(i).service_type ->'||p_x_task_tbl(i).service_type
2867: );
2868: fnd_log.string(
2869: fnd_log.level_statement,
2870: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2871: 'l_create_task_tbl(l_tsk_count).service_type_code ->'||l_create_task_tbl(l_tsk_count).service_type_code
2872: );

Line 2869: fnd_log.level_statement,

2865: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2866: 'p_x_task_tbl(i).service_type ->'||p_x_task_tbl(i).service_type
2867: );
2868: fnd_log.string(
2869: fnd_log.level_statement,
2870: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2871: 'l_create_task_tbl(l_tsk_count).service_type_code ->'||l_create_task_tbl(l_tsk_count).service_type_code
2872: );
2873:

Line 2875: fnd_log.string(

2871: 'l_create_task_tbl(l_tsk_count).service_type_code ->'||l_create_task_tbl(l_tsk_count).service_type_code
2872: );
2873:
2874: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- start
2875: fnd_log.string(
2876: fnd_log.level_statement,
2877: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2878: 'p_x_task_tbl(i).workorder_start_time->'||p_x_task_tbl(i).workorder_start_time
2879: );

Line 2876: fnd_log.level_statement,

2872: );
2873:
2874: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- start
2875: fnd_log.string(
2876: fnd_log.level_statement,
2877: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2878: 'p_x_task_tbl(i).workorder_start_time->'||p_x_task_tbl(i).workorder_start_time
2879: );
2880: -- FP Bug # 7720088 (Mexicana Bug # 7697685) -- end

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

2889: x_msg_count => x_msg_count,
2890: x_msg_data => x_msg_data
2891: );
2892:
2893: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2894: fnd_log.string(
2895: fnd_log.level_statement,
2896: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2897: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status

Line 2894: fnd_log.string(

2890: x_msg_data => x_msg_data
2891: );
2892:
2893: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2894: fnd_log.string(
2895: fnd_log.level_statement,
2896: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2897: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status
2898: );

Line 2895: fnd_log.level_statement,

2891: );
2892:
2893: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2894: fnd_log.string(
2895: fnd_log.level_statement,
2896: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2897: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status
2898: );
2899: END IF;

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

2905: END IF;
2906:
2907: -- 3. Call VWP API to push tasks into production.
2908:
2909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2910: fnd_log.string(
2911: fnd_log.level_statement,
2912: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2913: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'

Line 2910: fnd_log.string(

2906:
2907: -- 3. Call VWP API to push tasks into production.
2908:
2909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2910: fnd_log.string(
2911: fnd_log.level_statement,
2912: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2913: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2914: );

Line 2911: fnd_log.level_statement,

2907: -- 3. Call VWP API to push tasks into production.
2908:
2909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2910: fnd_log.string(
2911: fnd_log.level_statement,
2912: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2913: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2914: );
2915: END IF;

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

2963:
2964: END IF;
2965: --FP for ER 5716489 -- end
2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string(
2969: fnd_log.level_statement,
2970: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2971: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status

Line 2968: fnd_log.string(

2964: END IF;
2965: --FP for ER 5716489 -- end
2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string(
2969: fnd_log.level_statement,
2970: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2971: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2972: );

Line 2969: fnd_log.level_statement,

2965: --FP for ER 5716489 -- end
2966:
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2968: fnd_log.string(
2969: fnd_log.level_statement,
2970: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2971: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2972: );
2973: END IF;

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

3060:
3061:
3062: IF l_rts_wip_id IS NOT NULL
3063: AND l_repair_batch_name IS NOT NULL THEN
3064: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3065: fnd_log.string(fnd_log.level_statement,
3066: L_DEBUG_KEY,
3067: 'Calling AHL_CMP_PVT.Move_To_InRepair_Locator');
3068: END IF;

Line 3065: fnd_log.string(fnd_log.level_statement,

3061:
3062: IF l_rts_wip_id IS NOT NULL
3063: AND l_repair_batch_name IS NOT NULL THEN
3064: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3065: fnd_log.string(fnd_log.level_statement,
3066: L_DEBUG_KEY,
3067: 'Calling AHL_CMP_PVT.Move_To_InRepair_Locator');
3068: END IF;
3069:

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

3079: x_msg_count => l_msg_count,
3080: x_msg_data => l_msg_data);
3081:
3082:
3083: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3084: fnd_log.string(fnd_log.level_statement,
3085: L_DEBUG_KEY,
3086: 'After Calling AHL_VWP_PROJ_PROD_PVT.Move_To_InRepair_Locator.' ||
3087: 'Return Status = ' || l_return_status );

Line 3084: fnd_log.string(fnd_log.level_statement,

3080: x_msg_data => l_msg_data);
3081:
3082:
3083: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3084: fnd_log.string(fnd_log.level_statement,
3085: L_DEBUG_KEY,
3086: 'After Calling AHL_VWP_PROJ_PROD_PVT.Move_To_InRepair_Locator.' ||
3087: 'Return Status = ' || l_return_status );
3088: END IF;

Line 3105: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3101: END IF;
3102: END LOOP;
3103: -- Kasridha : Changes for Bug# 13739171 Ends
3104: --amsriniv ER 6014567 End
3105: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
3107: END IF;
3108:
3109: END Process_Mr;

Line 3106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');

3102: END LOOP;
3103: -- Kasridha : Changes for Bug# 13739171 Ends
3104: --amsriniv ER 6014567 End
3105: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
3107: END IF;
3108:
3109: END Process_Mr;
3110: -- MR NR ER -- end

Line 3124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3120: l_count NUMBER;
3121: l_api_name VARCHAR2(200) := 'COPY_MR_DETAILS';
3122:
3123: BEGIN
3124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
3126: END IF;
3127:
3128: l_count := 0;

Line 3125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');

3121: l_api_name VARCHAR2(200) := 'COPY_MR_DETAILS';
3122:
3123: BEGIN
3124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
3126: END IF;
3127:
3128: l_count := 0;
3129:

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

3130: FOR j IN p_mr_assoc_tbl.FIRST .. p_mr_assoc_tbl.LAST
3131: LOOP
3132: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
3133:
3134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
3138: 'p_sr_table_index->'||p_sr_table_index

Line 3135: fnd_log.string(

3131: LOOP
3132: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
3133:
3134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
3138: 'p_sr_table_index->'||p_sr_table_index
3139: );

Line 3136: fnd_log.level_statement,

3132: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
3133:
3134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
3138: 'p_sr_table_index->'||p_sr_table_index
3139: );
3140: END IF;

Line 3153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3149: p_x_sr_mr_association_tbl(l_count).operation_flag := 'C';
3150: END IF;
3151: END LOOP;
3152:
3153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
3155: END IF;
3156:
3157: END Copy_Mr_Details;

Line 3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');

3150: END IF;
3151: END LOOP;
3152:
3153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
3155: END IF;
3156:
3157: END Copy_Mr_Details;
3158: -- MR NR ER -- end

Line 3194: -- FND Logging Constants

3190: Select unit_effectivity_id
3191: from AHL_UNIT_EFFECTIVITIES_B
3192: where cs_incident_id = p_incident_id;
3193:
3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3191: from AHL_UNIT_EFFECTIVITIES_B
3192: where cs_incident_id = p_incident_id;
3193:
3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3199:

Line 3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

3192: where cs_incident_id = p_incident_id;
3193:
3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3199:
3200: BEGIN

Line 3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

3193:
3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3199:
3200: BEGIN
3201:

Line 3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

3194: -- FND Logging Constants
3195: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3196: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3197: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
3198: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3199:
3200: BEGIN
3201:
3202: IF (l_debug_PROC >= l_debug_LEVEL) THEN

Line 3203: fnd_log.string

3199:
3200: BEGIN
3201:
3202: IF (l_debug_PROC >= l_debug_LEVEL) THEN
3203: fnd_log.string
3204: (l_debug_PROC,
3205: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.begin',
3206: 'At the start of PLSQL procedure');
3207: END IF;

Line 3228: fnd_log.string

3224: l_request_type := p_x_task_tbl(i).type_name;
3225: END IF;
3226:
3227: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3228: fnd_log.string
3229: (l_debug_STMT,
3230: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3231: 'After deriving request type:' || l_request_type);
3232: END IF;

Line 3255: fnd_log.string

3251: End if;
3252: Close GetOrgTaskDet;
3253:
3254: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3255: fnd_log.string
3256: (l_debug_STMT,
3257: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3258: 'After deriving originating visit task id:' || l_org_task_id);
3259:

Line 3275: fnd_log.string

3271: l_visit_task_name := p_x_task_tbl(i).visit_task_name;
3272: END IF;
3273:
3274: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3275: fnd_log.string
3276: (l_debug_STMT,
3277: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3278: 'After defaulting task name');
3279: END IF;

Line 3296: fnd_log.string

3292: l_create_job_task_tbl(i).unit_effectivity_id := l_unit_effectivity_id;
3293: --- END Changes by VSUNDARA for SR INTEGRATION
3294:
3295: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3296: fnd_log.string
3297: (l_debug_STMT,
3298: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3299: 'After deriving UE ID:' || l_unit_effectivity_id);
3300: END IF;

Line 3314: fnd_log.string

3310: l_create_job_task_tbl(i).operation_flag := l_operation_flag;
3311:
3312:
3313: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3314: fnd_log.string
3315: (l_debug_STMT,
3316: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3317: 'End loop for visit task name: ' || l_visit_task_name);
3318: END IF;

Line 3326: fnd_log.string

3322:
3323: IF l_create_job_task_tbl.count > 0 THEN
3324:
3325: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3326: fnd_log.string
3327: (l_debug_STMT,
3328: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3329: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3330: END IF;

Line 3354: fnd_log.string

3350:
3351: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_count > 0) THEN
3352:
3353: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
3354: fnd_log.string
3355: (l_debug_UEXP,
3356: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3357: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3358: END IF;

Line 3375: fnd_log.string

3371: FOR i IN p_x_task_tbl.FIRST..p_x_task_tbl.LAST LOOP
3372: IF ( upper(p_x_task_tbl(i).operation_type) = 'CREATE') THEN
3373:
3374: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3375: fnd_log.string
3376: (l_debug_STMT,
3377: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3378: 'Now processing for WO: ' || l_create_job_task_tbl(i).workorder_id);
3379: END IF;

Line 3393: fnd_log.string

3389: -- Fix for bug# 5261150.
3390: -- release workorder if user chooses to release wo.
3391: -- Default is to release wo.
3392: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3393: fnd_log.string
3394: (l_debug_STMT,
3395: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3396: 'Before calling AHL_PRD_WORKORDER_PVT.Release_visit_jobs for WO: ' || l_create_job_task_tbl(i).workorder_id);
3397: END IF;

Line 3417: fnd_log.string

3413: );
3414:
3415: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3416: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
3417: fnd_log.string
3418: (l_debug_UEXP,
3419: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3420: 'Error ' || x_return_status ||' returned from AHL_PRD_WORKORDER_PVT.Release_visit_jobs');
3421: END IF;

Line 3431: fnd_log.string

3427: END IF;
3428: END LOOP;
3429:
3430: IF (l_debug_PROC >= l_debug_LEVEL) THEN
3431: fnd_log.string
3432: (l_debug_PROC,
3433: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.End',
3434: 'At the end of PLSQL procedure');
3435: END IF;