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.

[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on FND_LOG

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

399: */
400: -- NR MR ER - End
401:
402: -- NR MR ER - start
403: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
404: fnd_log.string(
405: fnd_log.level_statement,
406: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
407: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT

Line 404: fnd_log.string(

400: -- NR MR ER - End
401:
402: -- NR MR ER - start
403: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
404: fnd_log.string(
405: fnd_log.level_statement,
406: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
407: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT
408: );

Line 405: fnd_log.level_statement,

401:
402: -- NR MR ER - start
403: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
404: fnd_log.string(
405: fnd_log.level_statement,
406: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
407: 'p_x_mr_asso_tbl.COUNT ->'||p_x_mr_asso_tbl.COUNT
408: );
409: END IF;

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

426: x_msg_count => x_msg_count,
427: x_msg_data => x_msg_data
428: );
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
431: fnd_log.string(
432: fnd_log.level_statement,
433: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
434: 'After calling Process_Mr...Return status->'||x_return_status

Line 431: fnd_log.string(

427: x_msg_data => x_msg_data
428: );
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
431: fnd_log.string(
432: fnd_log.level_statement,
433: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
434: 'After calling Process_Mr...Return status->'||x_return_status
435: );

Line 432: fnd_log.level_statement,

428: );
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
431: fnd_log.string(
432: fnd_log.level_statement,
433: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
434: 'After calling Process_Mr...Return status->'||x_return_status
435: );
436: END IF;

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

441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: END IF;
444:
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
446: fnd_log.string(
447: fnd_log.level_statement,
448: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
449: 'After Process_Mr API'

Line 446: fnd_log.string(

442: END IF;
443: END IF;
444:
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
446: fnd_log.string(
447: fnd_log.level_statement,
448: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
449: 'After Process_Mr API'
450: );

Line 447: fnd_log.level_statement,

443: END IF;
444:
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
446: fnd_log.string(
447: fnd_log.level_statement,
448: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
449: 'After Process_Mr API'
450: );
451: END IF;

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

2036: -- Tamal [MEL/CDL PRD Integration] Ends here...
2037:
2038: -- MR NR ER -- start
2039:
2040: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2041: fnd_log.string(
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2044: 'Before Updating Unit Effectivity with Originating WO detail..'

Line 2041: fnd_log.string(

2037:
2038: -- MR NR ER -- start
2039:
2040: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2041: fnd_log.string(
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2044: 'Before Updating Unit Effectivity with Originating WO detail..'
2045: );

Line 2042: fnd_log.level_statement,

2038: -- MR NR ER -- start
2039:
2040: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2041: fnd_log.string(
2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2044: 'Before Updating Unit Effectivity with Originating WO detail..'
2045: );
2046: fnd_log.string(

Line 2046: fnd_log.string(

2042: fnd_log.level_statement,
2043: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2044: 'Before Updating Unit Effectivity with Originating WO detail..'
2045: );
2046: fnd_log.string(
2047: fnd_log.level_statement,
2048: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2049: 'p_x_sr_task_rec.Originating_wo_id->'||p_x_sr_task_rec.Originating_wo_id||' , '
2050: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id

Line 2047: fnd_log.level_statement,

2043: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2044: 'Before Updating Unit Effectivity with Originating WO detail..'
2045: );
2046: fnd_log.string(
2047: fnd_log.level_statement,
2048: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2049: 'p_x_sr_task_rec.Originating_wo_id->'||p_x_sr_task_rec.Originating_wo_id||' , '
2050: ||'p_x_sr_task_rec.incident_id->'||p_x_sr_task_rec.incident_id
2051: );

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

2174: l_workorder_id NUMBER;
2175:
2176: BEGIN
2177:
2178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2180: END IF;
2181:
2182:

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

2175:
2176: BEGIN
2177:
2178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2180: END IF;
2181:
2182:
2183: FOR i in p_x_task_tbl.FIRST .. p_x_task_tbl.LAST

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

2195: OPEN c_get_sr_details(p_x_task_tbl(i).Incident_id);
2196: FETCH c_get_sr_details INTO p_x_task_tbl(i).Incident_object_version_number;
2197: CLOSE c_get_sr_details;
2198:
2199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2200: fnd_log.string(
2201: fnd_log.level_statement,
2202: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2203: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'

Line 2200: fnd_log.string(

2196: FETCH c_get_sr_details INTO p_x_task_tbl(i).Incident_object_version_number;
2197: CLOSE c_get_sr_details;
2198:
2199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2200: fnd_log.string(
2201: fnd_log.level_statement,
2202: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2203: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2204: );

Line 2201: fnd_log.level_statement,

2197: CLOSE c_get_sr_details;
2198:
2199: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2200: fnd_log.string(
2201: fnd_log.level_statement,
2202: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2203: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2204: );
2205: fnd_log.string(

Line 2205: fnd_log.string(

2201: fnd_log.level_statement,
2202: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2203: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2204: );
2205: fnd_log.string(
2206: fnd_log.level_statement,
2207: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2208: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2209: );

Line 2206: fnd_log.level_statement,

2202: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2203: 'Before calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...'
2204: );
2205: fnd_log.string(
2206: fnd_log.level_statement,
2207: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2208: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2209: );
2210: fnd_log.string(

Line 2210: fnd_log.string(

2206: fnd_log.level_statement,
2207: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2208: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2209: );
2210: fnd_log.string(
2211: fnd_log.level_statement,
2212: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2213: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2214: );

Line 2211: fnd_log.level_statement,

2207: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2208: 'p_x_task_tbl(i).Incident_id ->'||p_x_task_tbl(i).Incident_id
2209: );
2210: fnd_log.string(
2211: fnd_log.level_statement,
2212: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2213: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2214: );
2215: fnd_log.string(

Line 2215: fnd_log.string(

2211: fnd_log.level_statement,
2212: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2213: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2214: );
2215: fnd_log.string(
2216: fnd_log.level_statement,
2217: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2218: 'p_x_task_tbl(i).Incident_number'||p_x_task_tbl(i).Incident_number
2219: );

Line 2216: fnd_log.level_statement,

2212: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2213: 'p_x_task_tbl(i).Incident_object_version_number'||p_x_task_tbl(i).Incident_object_version_number
2214: );
2215: fnd_log.string(
2216: fnd_log.level_statement,
2217: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2218: 'p_x_task_tbl(i).Incident_number'||p_x_task_tbl(i).Incident_number
2219: );
2220: END IF;

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

2235: p_request_number => p_x_task_tbl(i).Incident_number,
2236: p_x_sr_mr_association_tbl => l_x_sr_mr_association_tbl
2237: );
2238:
2239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2240: fnd_log.string(
2241: fnd_log.level_statement,
2242: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2243: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status

Line 2240: fnd_log.string(

2236: p_x_sr_mr_association_tbl => l_x_sr_mr_association_tbl
2237: );
2238:
2239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2240: fnd_log.string(
2241: fnd_log.level_statement,
2242: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2243: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status
2244: );

Line 2241: fnd_log.level_statement,

2237: );
2238:
2239: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2240: fnd_log.string(
2241: fnd_log.level_statement,
2242: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2243: 'After calling AHL_UMP_SR_PVT.Process_SR_MR_Associations...Return status->'||x_return_status
2244: );
2245: END IF;

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

2284: l_create_task_tbl(l_tsk_count).unit_effectivity_id := l_unit_effectivity_id;
2285: l_create_task_tbl(l_tsk_count).task_type_code := 'PLANNED';
2286: l_create_task_tbl(l_tsk_count).operation_flag := 'C';
2287: l_create_task_tbl(l_tsk_count).quantity := p_x_task_tbl(i).instance_quantity; --amsriniv. Issue 105 ER 6014567
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 calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'

Line 2289: fnd_log.string(

2285: l_create_task_tbl(l_tsk_count).task_type_code := 'PLANNED';
2286: l_create_task_tbl(l_tsk_count).operation_flag := 'C';
2287: l_create_task_tbl(l_tsk_count).quantity := p_x_task_tbl(i).instance_quantity; --amsriniv. Issue 105 ER 6014567
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 calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2293: );

Line 2290: fnd_log.level_statement,

2286: l_create_task_tbl(l_tsk_count).operation_flag := 'C';
2287: l_create_task_tbl(l_tsk_count).quantity := p_x_task_tbl(i).instance_quantity; --amsriniv. Issue 105 ER 6014567
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 calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
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 calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2293: );
2294: fnd_log.string(
2295: fnd_log.level_statement,
2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2298: );

Line 2295: fnd_log.level_statement,

2291: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2292: 'Before calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...'
2293: );
2294: fnd_log.string(
2295: fnd_log.level_statement,
2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2298: );
2299: fnd_log.string(

Line 2299: fnd_log.string(

2295: fnd_log.level_statement,
2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2298: );
2299: fnd_log.string(
2300: fnd_log.level_statement,
2301: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2302: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2303: );

Line 2300: fnd_log.level_statement,

2296: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2297: 'p_x_task_tbl(i).visit_id->'||p_x_task_tbl(i).visit_id
2298: );
2299: fnd_log.string(
2300: fnd_log.level_statement,
2301: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2302: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2303: );
2304: fnd_log.string(

Line 2304: fnd_log.string(

2300: fnd_log.level_statement,
2301: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2302: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2303: );
2304: fnd_log.string(
2305: fnd_log.level_statement,
2306: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2307: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2308: );

Line 2305: fnd_log.level_statement,

2301: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2302: 'p_x_task_tbl(i).incident_id->'||p_x_task_tbl(i).incident_id
2303: );
2304: fnd_log.string(
2305: fnd_log.level_statement,
2306: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2307: 'l_unit_effectivity_id->'||l_unit_effectivity_id
2308: );
2309: END IF;

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

2317: x_msg_count => x_msg_count,
2318: x_msg_data => x_msg_data
2319: );
2320:
2321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2322: fnd_log.string(
2323: fnd_log.level_statement,
2324: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2325: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status

Line 2322: fnd_log.string(

2318: x_msg_data => x_msg_data
2319: );
2320:
2321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2322: fnd_log.string(
2323: fnd_log.level_statement,
2324: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2325: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status
2326: );

Line 2323: fnd_log.level_statement,

2319: );
2320:
2321: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2322: fnd_log.string(
2323: fnd_log.level_statement,
2324: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2325: 'After calling AHL_VWP_TASKS_PVT.CREATE_PUP_TASKS...Return status->'||x_return_status
2326: );
2327: END IF;

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

2333: END IF;
2334:
2335: -- 3. Call VWP API to push tasks into production.
2336:
2337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2338: fnd_log.string(
2339: fnd_log.level_statement,
2340: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2341: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'

Line 2338: fnd_log.string(

2334:
2335: -- 3. Call VWP API to push tasks into production.
2336:
2337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2338: fnd_log.string(
2339: fnd_log.level_statement,
2340: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2341: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2342: );

Line 2339: fnd_log.level_statement,

2335: -- 3. Call VWP API to push tasks into production.
2336:
2337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2338: fnd_log.string(
2339: fnd_log.level_statement,
2340: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2341: 'Before calling AHL_VWP_PROJ_PROD_PVT.Release_MR...'
2342: );
2343: END IF;

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

2378:
2379: END IF;
2380: --FP for ER 5716489 -- end
2381:
2382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2383: fnd_log.string(
2384: fnd_log.level_statement,
2385: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2386: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status

Line 2383: fnd_log.string(

2379: END IF;
2380: --FP for ER 5716489 -- end
2381:
2382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2383: fnd_log.string(
2384: fnd_log.level_statement,
2385: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2386: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2387: );

Line 2384: fnd_log.level_statement,

2380: --FP for ER 5716489 -- end
2381:
2382: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2383: fnd_log.string(
2384: fnd_log.level_statement,
2385: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2386: 'After calling AHL_VWP_PROJ_PROD_PVT.Release_MR...Return status ->'||x_return_status
2387: );
2388: END IF;

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

2436: x_msg_data => x_msg_data
2437: );
2438: END IF;
2439: --amsriniv ER 6014567 End
2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
2442: END IF;
2443:
2444: END Process_Mr;

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

2437: );
2438: END IF;
2439: --amsriniv ER 6014567 End
2440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
2442: END IF;
2443:
2444: END Process_Mr;
2445: -- MR NR ER -- end

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

2455: l_count NUMBER;
2456: l_api_name VARCHAR2(200) := 'COPY_MR_DETAILS';
2457:
2458: BEGIN
2459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2461: END IF;
2462:
2463: l_count := 0;

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

2456: l_api_name VARCHAR2(200) := 'COPY_MR_DETAILS';
2457:
2458: BEGIN
2459: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.begin', 'Entering Procedure');
2461: END IF;
2462:
2463: l_count := 0;
2464:

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

2465: FOR j IN p_mr_assoc_tbl.FIRST .. p_mr_assoc_tbl.LAST
2466: LOOP
2467: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
2468:
2469: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2470: fnd_log.string(
2471: fnd_log.level_statement,
2472: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2473: 'p_sr_table_index->'||p_sr_table_index

Line 2470: fnd_log.string(

2466: LOOP
2467: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
2468:
2469: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2470: fnd_log.string(
2471: fnd_log.level_statement,
2472: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2473: 'p_sr_table_index->'||p_sr_table_index
2474: );

Line 2471: fnd_log.level_statement,

2467: IF p_sr_table_index = p_mr_assoc_tbl(j).sr_tbl_index THEN
2468:
2469: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2470: fnd_log.string(
2471: fnd_log.level_statement,
2472: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME||':',
2473: 'p_sr_table_index->'||p_sr_table_index
2474: );
2475: END IF;

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

2484: p_x_sr_mr_association_tbl(l_count).operation_flag := 'C';
2485: END IF;
2486: END LOOP;
2487:
2488: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
2490: END IF;
2491:
2492: END Copy_Mr_Details;

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

2485: END IF;
2486: END LOOP;
2487:
2488: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || l_api_name || '.end', 'Exiting Procedure');
2490: END IF;
2491:
2492: END Copy_Mr_Details;
2493: -- MR NR ER -- end

Line 2529: -- FND Logging Constants

2525: Select unit_effectivity_id
2526: from AHL_UNIT_EFFECTIVITIES_B
2527: where cs_incident_id = p_incident_id;
2528:
2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2531: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
2532: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
2533: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

2526: from AHL_UNIT_EFFECTIVITIES_B
2527: where cs_incident_id = p_incident_id;
2528:
2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2531: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
2532: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
2533: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
2534:

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

2527: where cs_incident_id = p_incident_id;
2528:
2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2531: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
2532: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
2533: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
2534:
2535: BEGIN

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

2528:
2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2531: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
2532: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
2533: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
2534:
2535: BEGIN
2536:

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

2529: -- FND Logging Constants
2530: l_debug_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2531: l_debug_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
2532: l_debug_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
2533: l_debug_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
2534:
2535: BEGIN
2536:
2537: IF (l_debug_PROC >= l_debug_LEVEL) THEN

Line 2538: fnd_log.string

2534:
2535: BEGIN
2536:
2537: IF (l_debug_PROC >= l_debug_LEVEL) THEN
2538: fnd_log.string
2539: (l_debug_PROC,
2540: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.begin',
2541: 'At the start of PLSQL procedure');
2542: END IF;

Line 2563: fnd_log.string

2559: l_request_type := p_x_task_tbl(i).type_name;
2560: END IF;
2561:
2562: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2563: fnd_log.string
2564: (l_debug_STMT,
2565: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2566: 'After deriving request type:' || l_request_type);
2567: END IF;

Line 2590: fnd_log.string

2586: End if;
2587: Close GetOrgTaskDet;
2588:
2589: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2590: fnd_log.string
2591: (l_debug_STMT,
2592: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2593: 'After deriving originating visit task id:' || l_org_task_id);
2594:

Line 2610: fnd_log.string

2606: l_visit_task_name := p_x_task_tbl(i).visit_task_name;
2607: END IF;
2608:
2609: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2610: fnd_log.string
2611: (l_debug_STMT,
2612: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2613: 'After defaulting task name');
2614: END IF;

Line 2631: fnd_log.string

2627: l_create_job_task_tbl(i).unit_effectivity_id := l_unit_effectivity_id;
2628: --- END Changes by VSUNDARA for SR INTEGRATION
2629:
2630: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2631: fnd_log.string
2632: (l_debug_STMT,
2633: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2634: 'After deriving UE ID:' || l_unit_effectivity_id);
2635: END IF;

Line 2649: fnd_log.string

2645: l_create_job_task_tbl(i).operation_flag := l_operation_flag;
2646:
2647:
2648: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2649: fnd_log.string
2650: (l_debug_STMT,
2651: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2652: 'End loop for visit task name: ' || l_visit_task_name);
2653: END IF;

Line 2661: fnd_log.string

2657:
2658: IF l_create_job_task_tbl.count > 0 THEN
2659:
2660: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2661: fnd_log.string
2662: (l_debug_STMT,
2663: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2664: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2665: END IF;

Line 2689: fnd_log.string

2685:
2686: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_count > 0) THEN
2687:
2688: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
2689: fnd_log.string
2690: (l_debug_UEXP,
2691: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2692: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2693: END IF;

Line 2710: fnd_log.string

2706: FOR i IN p_x_task_tbl.FIRST..p_x_task_tbl.LAST LOOP
2707: IF ( upper(p_x_task_tbl(i).operation_type) = 'CREATE') THEN
2708:
2709: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2710: fnd_log.string
2711: (l_debug_STMT,
2712: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2713: 'Now processing for WO: ' || l_create_job_task_tbl(i).workorder_id);
2714: END IF;

Line 2728: fnd_log.string

2724: -- Fix for bug# 5261150.
2725: -- release workorder if user chooses to release wo.
2726: -- Default is to release wo.
2727: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2728: fnd_log.string
2729: (l_debug_STMT,
2730: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2731: 'Before calling AHL_PRD_WORKORDER_PVT.Release_visit_jobs for WO: ' || l_create_job_task_tbl(i).workorder_id);
2732: END IF;

Line 2752: fnd_log.string

2748: );
2749:
2750: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2751: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
2752: fnd_log.string
2753: (l_debug_UEXP,
2754: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2755: 'Error ' || x_return_status ||' returned from AHL_PRD_WORKORDER_PVT.Release_visit_jobs');
2756: END IF;

Line 2766: fnd_log.string

2762: END IF;
2763: END LOOP;
2764:
2765: IF (l_debug_PROC >= l_debug_LEVEL) THEN
2766: fnd_log.string
2767: (l_debug_PROC,
2768: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.End',
2769: 'At the end of PLSQL procedure');
2770: END IF;