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

Line 37: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

33: G_CALLED_FROM VARCHAR2(30) := NULL; --When Called from VWP For Department Change
34:
35: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- start
36: -- Constants added for performance improvement
37: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
38: G_CURRENT_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41:

Line 38: G_CURRENT_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

34:
35: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- start
36: -- Constants added for performance improvement
37: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
38: G_CURRENT_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41:
42: -- MANESING::NR Analysis, 03-Jun-2011, added following type to be used within this Package Body

Line 40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

36: -- Constants added for performance improvement
37: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
38: G_CURRENT_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41:
42: -- MANESING::NR Analysis, 03-Jun-2011, added following type to be used within this Package Body
43: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
44:

Line 3392: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3388: END IF;
3389: END IF;
3390: END IF;
3391:
3392: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3393: fnd_log.string(FND_LOG.LEVEL_STATEMENT,'ahl.plsql.AHL_PRD_WORKORDER_PVT.default_attributes',
3394: 'Acc Class code: ' || p_x_prd_workorder_rec.CLASS_CODE);
3395:
3396: END IF;

Line 3393: fnd_log.string(FND_LOG.LEVEL_STATEMENT,'ahl.plsql.AHL_PRD_WORKORDER_PVT.default_attributes',

3389: END IF;
3390: END IF;
3391:
3392: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3393: fnd_log.string(FND_LOG.LEVEL_STATEMENT,'ahl.plsql.AHL_PRD_WORKORDER_PVT.default_attributes',
3394: 'Acc Class code: ' || p_x_prd_workorder_rec.CLASS_CODE);
3395:
3396: END IF;
3397:

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

6027: AND p_x_prd_workorder_rec.master_workorder_flag = 'N'
6028: )
6029: THEN
6030:
6031: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6032: fnd_log.string
6033: (
6034: fnd_log.level_statement,
6035: l_debug_module,

Line 6032: fnd_log.string

6028: )
6029: THEN
6030:
6031: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6032: fnd_log.string
6033: (
6034: fnd_log.level_statement,
6035: l_debug_module,
6036: 'Cancelling Material Requirement for WO # ->'||p_x_prd_workorder_rec.JOB_NUMBER

Line 6034: fnd_log.level_statement,

6030:
6031: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6032: fnd_log.string
6033: (
6034: fnd_log.level_statement,
6035: l_debug_module,
6036: 'Cancelling Material Requirement for WO # ->'||p_x_prd_workorder_rec.JOB_NUMBER
6037: );
6038: fnd_log.string

Line 6038: fnd_log.string

6034: fnd_log.level_statement,
6035: l_debug_module,
6036: 'Cancelling Material Requirement for WO # ->'||p_x_prd_workorder_rec.JOB_NUMBER
6037: );
6038: fnd_log.string
6039: (
6040: fnd_log.level_statement,
6041: l_debug_module,
6042: 'Work Order status ->'||p_x_prd_workorder_rec.status_code

Line 6040: fnd_log.level_statement,

6036: 'Cancelling Material Requirement for WO # ->'||p_x_prd_workorder_rec.JOB_NUMBER
6037: );
6038: fnd_log.string
6039: (
6040: fnd_log.level_statement,
6041: l_debug_module,
6042: 'Work Order status ->'||p_x_prd_workorder_rec.status_code
6043: );
6044: END IF;

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

6052: FETCH c_wo_vtsk_id INTO p_x_prd_workorder_rec.VISIT_TASK_ID;
6053: CLOSE c_wo_vtsk_id;
6054: END IF;
6055:
6056: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6057: fnd_log.string
6058: (
6059: fnd_log.level_statement,
6060: l_debug_module,

Line 6057: fnd_log.string

6053: CLOSE c_wo_vtsk_id;
6054: END IF;
6055:
6056: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6057: fnd_log.string
6058: (
6059: fnd_log.level_statement,
6060: l_debug_module,
6061: 'Visit Task Id # ->'||p_x_prd_workorder_rec.VISIT_TASK_ID

Line 6059: fnd_log.level_statement,

6055:
6056: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6057: fnd_log.string
6058: (
6059: fnd_log.level_statement,
6060: l_debug_module,
6061: 'Visit Task Id # ->'||p_x_prd_workorder_rec.VISIT_TASK_ID
6062: );
6063: fnd_log.string

Line 6063: fnd_log.string

6059: fnd_log.level_statement,
6060: l_debug_module,
6061: 'Visit Task Id # ->'||p_x_prd_workorder_rec.VISIT_TASK_ID
6062: );
6063: fnd_log.string
6064: (
6065: fnd_log.level_statement,
6066: l_debug_module,
6067: 'Before calling AHL_LTP_REQST_MATRL_PVT.Update_Material_Reqrs_status'

Line 6065: fnd_log.level_statement,

6061: 'Visit Task Id # ->'||p_x_prd_workorder_rec.VISIT_TASK_ID
6062: );
6063: fnd_log.string
6064: (
6065: fnd_log.level_statement,
6066: l_debug_module,
6067: 'Before calling AHL_LTP_REQST_MATRL_PVT.Update_Material_Reqrs_status'
6068: );
6069: END IF;

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

6080: x_msg_count => x_msg_count,
6081: x_msg_data => x_msg_data
6082: );
6083:
6084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6085: fnd_log.string
6086: (
6087: fnd_log.level_statement,
6088: l_debug_module,

Line 6085: fnd_log.string

6081: x_msg_data => x_msg_data
6082: );
6083:
6084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6085: fnd_log.string
6086: (
6087: fnd_log.level_statement,
6088: l_debug_module,
6089: 'return status after call to Update_Material_Reqrs_status -> '|| x_return_status

Line 6087: fnd_log.level_statement,

6083:
6084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6085: fnd_log.string
6086: (
6087: fnd_log.level_statement,
6088: l_debug_module,
6089: 'return status after call to Update_Material_Reqrs_status -> '|| x_return_status
6090: );
6091: END IF;

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

6098:
6099: END IF;
6100:
6101: -- Bug # 8433227 (FP for Bug # 7453393) -- start
6102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6103: fnd_log.string
6104: (
6105: fnd_log.level_statement,
6106: l_api_name,

Line 6103: fnd_log.string

6099: END IF;
6100:
6101: -- Bug # 8433227 (FP for Bug # 7453393) -- start
6102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6103: fnd_log.string
6104: (
6105: fnd_log.level_statement,
6106: l_api_name,
6107: 'p_x_prd_workorder_rec.VISIT_TASK_ID -> '|| p_x_prd_workorder_rec.VISIT_TASK_ID

Line 6105: fnd_log.level_statement,

6101: -- Bug # 8433227 (FP for Bug # 7453393) -- start
6102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6103: fnd_log.string
6104: (
6105: fnd_log.level_statement,
6106: l_api_name,
6107: 'p_x_prd_workorder_rec.VISIT_TASK_ID -> '|| p_x_prd_workorder_rec.VISIT_TASK_ID
6108: );
6109: END IF;

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

6122: OPEN get_wo_sch_dates(p_x_prd_workorder_rec.wip_entity_id);
6123: FETCH get_wo_sch_dates INTO l_wo_sch_start_date, l_wo_sch_end_date;
6124: CLOSE get_wo_sch_dates; */
6125:
6126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6127: fnd_log.string
6128: (
6129: fnd_log.level_statement,
6130: l_api_name,

Line 6127: fnd_log.string

6123: FETCH get_wo_sch_dates INTO l_wo_sch_start_date, l_wo_sch_end_date;
6124: CLOSE get_wo_sch_dates; */
6125:
6126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6127: fnd_log.string
6128: (
6129: fnd_log.level_statement,
6130: l_api_name,
6131: 'p_x_prd_workorder_rec.visit_id -> '|| p_x_prd_workorder_rec.visit_id

Line 6129: fnd_log.level_statement,

6125:
6126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6127: fnd_log.string
6128: (
6129: fnd_log.level_statement,
6130: l_api_name,
6131: 'p_x_prd_workorder_rec.visit_id -> '|| p_x_prd_workorder_rec.visit_id
6132: );
6133: fnd_log.string

Line 6133: fnd_log.string

6129: fnd_log.level_statement,
6130: l_api_name,
6131: 'p_x_prd_workorder_rec.visit_id -> '|| p_x_prd_workorder_rec.visit_id
6132: );
6133: fnd_log.string
6134: (
6135: fnd_log.level_statement,
6136: l_api_name,
6137: 'l_visit_start_date -> '|| TO_DATE(l_visit_start_date , 'DD-MM-YYYY :HH24:MI:ss')

Line 6135: fnd_log.level_statement,

6131: 'p_x_prd_workorder_rec.visit_id -> '|| p_x_prd_workorder_rec.visit_id
6132: );
6133: fnd_log.string
6134: (
6135: fnd_log.level_statement,
6136: l_api_name,
6137: 'l_visit_start_date -> '|| TO_DATE(l_visit_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6138: );
6139: fnd_log.string

Line 6139: fnd_log.string

6135: fnd_log.level_statement,
6136: l_api_name,
6137: 'l_visit_start_date -> '|| TO_DATE(l_visit_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6138: );
6139: fnd_log.string
6140: (
6141: fnd_log.level_statement,
6142: l_api_name,
6143: 'l_visit_end_date -> '||TO_DATE(l_visit_end_date , 'DD-MM-YYYY :HH24:MI:ss')

Line 6141: fnd_log.level_statement,

6137: 'l_visit_start_date -> '|| TO_DATE(l_visit_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6138: );
6139: fnd_log.string
6140: (
6141: fnd_log.level_statement,
6142: l_api_name,
6143: 'l_visit_end_date -> '||TO_DATE(l_visit_end_date , 'DD-MM-YYYY :HH24:MI:ss')
6144: );
6145: fnd_log.string

Line 6145: fnd_log.string

6141: fnd_log.level_statement,
6142: l_api_name,
6143: 'l_visit_end_date -> '||TO_DATE(l_visit_end_date , 'DD-MM-YYYY :HH24:MI:ss')
6144: );
6145: fnd_log.string
6146: (
6147: fnd_log.level_statement,
6148: l_api_name,
6149: 'l_wo_sch_start_date -> '|| TO_DATE(l_wo_sch_start_date , 'DD-MM-YYYY :HH24:MI:ss')

Line 6147: fnd_log.level_statement,

6143: 'l_visit_end_date -> '||TO_DATE(l_visit_end_date , 'DD-MM-YYYY :HH24:MI:ss')
6144: );
6145: fnd_log.string
6146: (
6147: fnd_log.level_statement,
6148: l_api_name,
6149: 'l_wo_sch_start_date -> '|| TO_DATE(l_wo_sch_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6150: );
6151: fnd_log.string

Line 6151: fnd_log.string

6147: fnd_log.level_statement,
6148: l_api_name,
6149: 'l_wo_sch_start_date -> '|| TO_DATE(l_wo_sch_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6150: );
6151: fnd_log.string
6152: (
6153: fnd_log.level_statement,
6154: l_api_name,
6155: 'l_wo_sch_end_date -> '|| TO_DATE(l_wo_sch_end_date , 'DD-MM-YYYY :HH24:MI:ss')

Line 6153: fnd_log.level_statement,

6149: 'l_wo_sch_start_date -> '|| TO_DATE(l_wo_sch_start_date , 'DD-MM-YYYY :HH24:MI:ss')
6150: );
6151: fnd_log.string
6152: (
6153: fnd_log.level_statement,
6154: l_api_name,
6155: 'l_wo_sch_end_date -> '|| TO_DATE(l_wo_sch_end_date , 'DD-MM-YYYY :HH24:MI:ss')
6156: );
6157: END IF;

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

9597: * If All jobs under a MWO are cancelled(or valid statuses after that)
9598: * then cancel MWO else complete Master WO.
9599: */
9600: IF l_exists IS NULL THEN
9601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9602: fnd_log.string
9603: (
9604: fnd_log.level_statement,
9605: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

Line 9602: fnd_log.string

9598: * then cancel MWO else complete Master WO.
9599: */
9600: IF l_exists IS NULL THEN
9601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9602: fnd_log.string
9603: (
9604: fnd_log.level_statement,
9605: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9606: 'cancelling mwo->'||l_master_workorder_tbl(l_count).workorder_id

Line 9604: fnd_log.level_statement,

9600: IF l_exists IS NULL THEN
9601: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9602: fnd_log.string
9603: (
9604: fnd_log.level_statement,
9605: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9606: 'cancelling mwo->'||l_master_workorder_tbl(l_count).workorder_id
9607: );
9608: END IF;

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

9632: p_x_prd_workorder_tbl => l_copy_mwo_tbl,
9633: p_prd_workorder_rel_tbl => l_workorder_rel_cancel_tbl
9634: );
9635:
9636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9637: fnd_log.string
9638: (
9639: fnd_log.level_statement,
9640: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

Line 9637: fnd_log.string

9633: p_prd_workorder_rel_tbl => l_workorder_rel_cancel_tbl
9634: );
9635:
9636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9637: fnd_log.string
9638: (
9639: fnd_log.level_statement,
9640: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9641: 'return status after calling complete_master_wo: ' || l_mwo_return_status

Line 9639: fnd_log.level_statement,

9635:
9636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9637: fnd_log.string
9638: (
9639: fnd_log.level_statement,
9640: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9641: 'return status after calling complete_master_wo: ' || l_mwo_return_status
9642: );
9643: END IF;

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

9648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9649: END IF;
9650:
9651: ELSE
9652: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9653: fnd_log.string
9654: (
9655: fnd_log.level_statement,
9656: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

Line 9653: fnd_log.string

9649: END IF;
9650:
9651: ELSE
9652: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9653: fnd_log.string
9654: (
9655: fnd_log.level_statement,
9656: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9657: 'completing mwo->'||l_master_workorder_tbl(l_count).workorder_id

Line 9655: fnd_log.level_statement,

9651: ELSE
9652: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9653: fnd_log.string
9654: (
9655: fnd_log.level_statement,
9656: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9657: 'completing mwo->'||l_master_workorder_tbl(l_count).workorder_id
9658: );
9659: END IF;

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

9663: p_workorder_id => l_master_workorder_tbl(l_count).workorder_id,
9664: p_ue_id => null
9665: );
9666:
9667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9668: fnd_log.string
9669: (
9670: fnd_log.level_statement,
9671: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

Line 9668: fnd_log.string

9664: p_ue_id => null
9665: );
9666:
9667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9668: fnd_log.string
9669: (
9670: fnd_log.level_statement,
9671: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9672: 'return status after calling complete_master_wo: ' || l_mwo_return_status

Line 9670: fnd_log.level_statement,

9666:
9667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
9668: fnd_log.string
9669: (
9670: fnd_log.level_statement,
9671: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
9672: 'return status after calling complete_master_wo: ' || l_mwo_return_status
9673: );
9674: END IF;

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

10066: get_minmax_comp_schdates_rec get_minmax_comp_schedule_dates%ROWTYPE;
10067:
10068: BEGIN
10069:
10070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10071: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',
10072: 'At the start of PLSQL procedure');
10073: END IF;
10074: -- Standard start of API savepoint

Line 10071: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',

10067:
10068: BEGIN
10069:
10070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10071: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',
10072: 'At the start of PLSQL procedure');
10073: END IF;
10074: -- Standard start of API savepoint
10075: SAVEPOINT Reschedule_Visit_Jobs;

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

10085: END IF;
10086: -- Initialize API return status to success
10087: x_return_status:=FND_API.G_RET_STS_SUCCESS;
10088:
10089: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10090: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10091: 'Request for Rescheduling Workorders for Visit ID : ' || p_visit_id );
10092: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10093: 'Request for Rescheduling Workorder Schedule Start Date : ' || p_x_scheduled_start_date );

Line 10090: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

10086: -- Initialize API return status to success
10087: x_return_status:=FND_API.G_RET_STS_SUCCESS;
10088:
10089: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10090: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10091: 'Request for Rescheduling Workorders for Visit ID : ' || p_visit_id );
10092: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10093: 'Request for Rescheduling Workorder Schedule Start Date : ' || p_x_scheduled_start_date );
10094: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 10092: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

10088:
10089: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10090: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10091: 'Request for Rescheduling Workorders for Visit ID : ' || p_visit_id );
10092: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10093: 'Request for Rescheduling Workorder Schedule Start Date : ' || p_x_scheduled_start_date );
10094: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10095: 'Request for Rescheduling Workorder Schedule End Date : ' || p_x_scheduled_end_date );
10096: END IF;

Line 10094: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

10090: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10091: 'Request for Rescheduling Workorders for Visit ID : ' || p_visit_id );
10092: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10093: 'Request for Rescheduling Workorder Schedule Start Date : ' || p_x_scheduled_start_date );
10094: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
10095: 'Request for Rescheduling Workorder Schedule End Date : ' || p_x_scheduled_end_date );
10096: END IF;
10097:
10098: ---Begin of the Validation

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

10199: l_prd_workorder_tbl(1).BATCH_ID := check_workorder_exists_rec.wip_entity_id;
10200: l_prd_workorder_tbl(1).HEADER_ID := check_workorder_exists_rec.wip_entity_id;
10201:
10202:
10203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10204: fnd_log.string(fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10205: 'Before Calling Process Jobs ');
10206: END IF;
10207:

Line 10204: fnd_log.string(fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10200: l_prd_workorder_tbl(1).HEADER_ID := check_workorder_exists_rec.wip_entity_id;
10201:
10202:
10203: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10204: fnd_log.string(fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10205: 'Before Calling Process Jobs ');
10206: END IF;
10207:
10208: process_jobs

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

10222:
10223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10224: RAISE Fnd_Api.g_exc_error;
10225: END IF;
10226: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10227: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10228: 'After calling Process Jobs API to reschedule master workorder' );
10229: END IF;
10230: IF FND_API.to_boolean(p_commit) THEN

Line 10227: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10224: RAISE Fnd_Api.g_exc_error;
10225: END IF;
10226: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10227: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10228: 'After calling Process Jobs API to reschedule master workorder' );
10229: END IF;
10230: IF FND_API.to_boolean(p_commit) THEN
10231: COMMIT;

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

10244: l_offset_direction := -1;
10245: l_offset := l_offset * (-1);
10246: END IF;
10247:
10248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );
10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );
10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );

Line 10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );

10245: l_offset := l_offset * (-1);
10246: END IF;
10247:
10248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );
10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );
10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );
10253: END IF;

Line 10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );

10246: END IF;
10247:
10248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );
10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );
10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );
10253: END IF;
10254: -- fix for move visit issues. Bug 9462278

Line 10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );

10247:
10248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );
10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );
10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );
10253: END IF;
10254: -- fix for move visit issues. Bug 9462278
10255: --logging master work order dates prior to adjustment by CMRO

Line 10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );

10248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10249: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Rescheduled Wip Entity ID : ' || check_workorder_exists_rec.wip_entity_id );
10250: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Object Type Id : ' || l_object_type_id );
10251: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );
10253: END IF;
10254: -- fix for move visit issues. Bug 9462278
10255: --logging master work order dates prior to adjustment by CMRO
10256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

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

10252: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset Direction : ' || l_offset_direction );
10253: END IF;
10254: -- fix for move visit issues. Bug 9462278
10255: --logging master work order dates prior to adjustment by CMRO
10256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10257: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10258: fnd_log.string
10259: (
10260: fnd_log.level_statement,

Line 10258: fnd_log.string

10254: -- fix for move visit issues. Bug 9462278
10255: --logging master work order dates prior to adjustment by CMRO
10256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10257: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10258: fnd_log.string
10259: (
10260: fnd_log.level_statement,
10261: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10262: 'Original Scheduled start and completion dates : '

Line 10260: fnd_log.level_statement,

10256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10257: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10258: fnd_log.string
10259: (
10260: fnd_log.level_statement,
10261: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10262: 'Original Scheduled start and completion dates : '
10263: || '{mwo_rec.workorder_name : ' || mwo_rec.workorder_name || '}'
10264: || '{mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id || '}'

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

10273: l_dummy :=1;
10274: l_prd_workorder_tbl.DELETE;
10275: l_prev_workorder_id := -1;
10276: FOR mwo_rec IN mwos_for_comp_wos(p_visit_id,l_offset_direction,l_offset) LOOP
10277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );
10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );
10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );

Line 10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );

10274: l_prd_workorder_tbl.DELETE;
10275: l_prev_workorder_id := -1;
10276: FOR mwo_rec IN mwos_for_comp_wos(p_visit_id,l_offset_direction,l_offset) LOOP
10277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );
10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );
10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );
10282: END IF;

Line 10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );

10275: l_prev_workorder_id := -1;
10276: FOR mwo_rec IN mwos_for_comp_wos(p_visit_id,l_offset_direction,l_offset) LOOP
10277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );
10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );
10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );
10282: END IF;
10283: IF(mwo_rec.workorder_id <> l_prev_workorder_id) THEN

Line 10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );

10276: FOR mwo_rec IN mwos_for_comp_wos(p_visit_id,l_offset_direction,l_offset) LOOP
10277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );
10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );
10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );
10282: END IF;
10283: IF(mwo_rec.workorder_id <> l_prev_workorder_id) THEN
10284: IF(l_offset_direction = 1 AND mwo_rec.wip_entity_id <> check_workorder_exists_rec.wip_entity_id) THEN

Line 10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );

10277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10278: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'l_offset_direction : ' || l_offset_direction );
10279: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id );
10280: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'Offset : ' || l_offset );
10281: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':', 'check_workorder_exists_rec.wip_entity_id : ' || check_workorder_exists_rec.wip_entity_id );
10282: END IF;
10283: IF(mwo_rec.workorder_id <> l_prev_workorder_id) THEN
10284: IF(l_offset_direction = 1 AND mwo_rec.wip_entity_id <> check_workorder_exists_rec.wip_entity_id) THEN
10285: l_prd_workorder_tbl(l_dummy).SCHEDULED_START_DATE := mwo_rec.scheduled_start_date - l_offset;

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

10290: l_prd_workorder_tbl(l_dummy).WORKORDER_ID := mwo_rec.workorder_id;
10291: l_prd_workorder_tbl(l_dummy).OBJECT_VERSION_NUMBER := mwo_rec.object_version_number;
10292: l_prd_workorder_tbl(l_dummy).STATUS_CODE := mwo_rec.status_code;
10293: l_dummy := l_dummy + 1;
10294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10295: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10296: 'Expanding master work order{' || mwo_rec.workorder_id || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_START_DATE,'DD-MON-YYYY HH24:MI:SS')
10297: || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_END_DATE,'DD-MON-YYYY HH24:MI:SS') || '}' );
10298: END IF;

Line 10295: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10291: l_prd_workorder_tbl(l_dummy).OBJECT_VERSION_NUMBER := mwo_rec.object_version_number;
10292: l_prd_workorder_tbl(l_dummy).STATUS_CODE := mwo_rec.status_code;
10293: l_dummy := l_dummy + 1;
10294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10295: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10296: 'Expanding master work order{' || mwo_rec.workorder_id || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_START_DATE,'DD-MON-YYYY HH24:MI:SS')
10297: || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_END_DATE,'DD-MON-YYYY HH24:MI:SS') || '}' );
10298: END IF;
10299: ELSIF(l_offset_direction = -1) THEN

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

10305: l_prd_workorder_tbl(l_dummy).WORKORDER_ID := mwo_rec.workorder_id;
10306: l_prd_workorder_tbl(l_dummy).OBJECT_VERSION_NUMBER := mwo_rec.object_version_number;
10307: l_prd_workorder_tbl(l_dummy).STATUS_CODE := mwo_rec.status_code;
10308: l_dummy := l_dummy + 1;
10309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10310: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10311: 'Expanding master work order{' || mwo_rec.workorder_id || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_START_DATE,'DD-MON-YYYY HH24:MI:SS')
10312: || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_END_DATE,'DD-MON-YYYY HH24:MI:SS') || '}' );
10313: END IF;

Line 10310: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10306: l_prd_workorder_tbl(l_dummy).OBJECT_VERSION_NUMBER := mwo_rec.object_version_number;
10307: l_prd_workorder_tbl(l_dummy).STATUS_CODE := mwo_rec.status_code;
10308: l_dummy := l_dummy + 1;
10309: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10310: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10311: 'Expanding master work order{' || mwo_rec.workorder_id || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_START_DATE,'DD-MON-YYYY HH24:MI:SS')
10312: || '}{' || TO_CHAR(l_prd_workorder_tbl(l_dummy -1).SCHEDULED_END_DATE,'DD-MON-YYYY HH24:MI:SS') || '}' );
10313: END IF;
10314: END IF;

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

10334: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10335: RAISE Fnd_Api.g_exc_error;
10336: END IF;
10337:
10338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10339: fnd_log.string
10340: (
10341: fnd_log.level_statement,
10342: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

Line 10339: fnd_log.string

10335: RAISE Fnd_Api.g_exc_error;
10336: END IF;
10337:
10338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10339: fnd_log.string
10340: (
10341: fnd_log.level_statement,
10342: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10343: 'After calling Process Jobs API to reschedule master workorders expansion'

Line 10341: fnd_log.level_statement,

10337:
10338: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10339: fnd_log.string
10340: (
10341: fnd_log.level_statement,
10342: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10343: 'After calling Process Jobs API to reschedule master workorders expansion'
10344: );
10345: END IF;

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

10346: END IF;
10347: -- fix for move visit issues. Bug 9462278
10348:
10349: --logging master work order dates after adjustment by CMRO
10350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10351: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10352: fnd_log.string
10353: (
10354: fnd_log.level_statement,

Line 10352: fnd_log.string

10348:
10349: --logging master work order dates after adjustment by CMRO
10350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10351: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10352: fnd_log.string
10353: (
10354: fnd_log.level_statement,
10355: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10356: 'CMRO Updated but prior to EAM move - Scheduled start and completion dates : '

Line 10354: fnd_log.level_statement,

10350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10351: FOR mwo_rec IN log_mwos_for_comp_wos(p_visit_id) LOOP
10352: fnd_log.string
10353: (
10354: fnd_log.level_statement,
10355: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10356: 'CMRO Updated but prior to EAM move - Scheduled start and completion dates : '
10357: || '{mwo_rec.workorder_name : ' || mwo_rec.workorder_name || '}'
10358: || '{mwo_rec.wip_entity_id : ' || mwo_rec.wip_entity_id || '}'

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

10364: END LOOP;
10365: END IF;
10366:
10367: --Call Eam APi TO Move all the workorders
10368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10369: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10370: 'Before Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' );
10371: END IF;
10372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 10369: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10365: END IF;
10366:
10367: --Call Eam APi TO Move all the workorders
10368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10369: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10370: 'Before Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' );
10371: END IF;
10372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10373: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

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

10368: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10369: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10370: 'Before Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' );
10371: END IF;
10372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10373: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10374: '{' || TO_CHAR(p_x_scheduled_start_date,'DD-MON-YYYY HH24:MI:SS') || '}{' || TO_CHAR(l_scheduled_end_date,'DD-MON-YYYY HH24:MI:SS') || '}' );
10375: END IF;
10376:

Line 10373: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

10369: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10370: 'Before Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' );
10371: END IF;
10372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10373: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
10374: '{' || TO_CHAR(p_x_scheduled_start_date,'DD-MON-YYYY HH24:MI:SS') || '}{' || TO_CHAR(l_scheduled_end_date,'DD-MON-YYYY HH24:MI:SS') || '}' );
10375: END IF;
10376:
10377: -- this code will be executed only when offset is > 0

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

10397: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10398: RAISE Fnd_Api.g_exc_error;
10399: END IF;
10400:
10401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10402: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs', 'After Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' ||l_return_status );
10403: END IF;
10404:
10405: -- after rescheduling,update the visit master workorder start and end scheduled dates

Line 10402: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs', 'After Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' ||l_return_status );

10398: RAISE Fnd_Api.g_exc_error;
10399: END IF;
10400:
10401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10402: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs', 'After Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' ||l_return_status );
10403: END IF;
10404:
10405: -- after rescheduling,update the visit master workorder start and end scheduled dates
10406:

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

10416: l_prd_workorder_tbl(1).SCHEDULED_END_DATE := p_x_scheduled_end_date;
10417: l_prd_workorder_tbl(1).BATCH_ID := check_workorder_exists_rec.wip_entity_id;
10418: l_prd_workorder_tbl(1).HEADER_ID := check_workorder_exists_rec.wip_entity_id;
10419:
10420: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10421: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'calling process_jobs' );
10422: END IF;
10423:
10424: process_jobs

Line 10421: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'calling process_jobs' );

10417: l_prd_workorder_tbl(1).BATCH_ID := check_workorder_exists_rec.wip_entity_id;
10418: l_prd_workorder_tbl(1).HEADER_ID := check_workorder_exists_rec.wip_entity_id;
10419:
10420: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10421: fnd_log.string ( fnd_log.level_statement, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'calling process_jobs' );
10422: END IF;
10423:
10424: process_jobs
10425: (

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

10457: --
10458: IF FND_API.to_boolean(p_commit) THEN
10459: COMMIT;
10460: END IF;
10461: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10462: fnd_log.string ( fnd_log.level_procedure, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'At the end of PLSQL procedure' );
10463: END IF;
10464:
10465: EXCEPTION

Line 10462: fnd_log.string ( fnd_log.level_procedure, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'At the end of PLSQL procedure' );

10458: IF FND_API.to_boolean(p_commit) THEN
10459: COMMIT;
10460: END IF;
10461: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10462: fnd_log.string ( fnd_log.level_procedure, 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end', 'At the end of PLSQL procedure' );
10463: END IF;
10464:
10465: EXCEPTION
10466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

10539: l_count NUMBER;
10540: matchFound BOOLEAN;
10541:
10542: BEGIN
10543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10544: fnd_log.string
10545: (
10546: fnd_log.level_procedure,
10547: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',

Line 10544: fnd_log.string

10540: matchFound BOOLEAN;
10541:
10542: BEGIN
10543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10544: fnd_log.string
10545: (
10546: fnd_log.level_procedure,
10547: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',
10548: 'At the start of PLSQL procedure'

Line 10546: fnd_log.level_procedure,

10542: BEGIN
10543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10544: fnd_log.string
10545: (
10546: fnd_log.level_procedure,
10547: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',
10548: 'At the start of PLSQL procedure'
10549: );
10550: END IF;

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

10559: IF FND_API.To_Boolean( p_init_msg_list) THEN
10560: FND_MSG_PUB.Initialize;
10561: END IF;
10562:
10563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10564: fnd_log.string
10565: (
10566: fnd_log.level_statement,
10567: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

Line 10564: fnd_log.string

10560: FND_MSG_PUB.Initialize;
10561: END IF;
10562:
10563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10564: fnd_log.string
10565: (
10566: fnd_log.level_statement,
10567: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10568: 'p_init_message_list : ' || p_init_msg_list

Line 10566: fnd_log.level_statement,

10562:
10563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
10564: fnd_log.string
10565: (
10566: fnd_log.level_statement,
10567: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10568: 'p_init_message_list : ' || p_init_msg_list
10569: );
10570: fnd_log.string

Line 10570: fnd_log.string

10566: fnd_log.level_statement,
10567: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10568: 'p_init_message_list : ' || p_init_msg_list
10569: );
10570: fnd_log.string
10571: (
10572: fnd_log.level_statement,
10573: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10574: 'p_commit : ' || p_commit

Line 10572: fnd_log.level_statement,

10568: 'p_init_message_list : ' || p_init_msg_list
10569: );
10570: fnd_log.string
10571: (
10572: fnd_log.level_statement,
10573: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10574: 'p_commit : ' || p_commit
10575: );
10576: END IF;

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

10581: -- validate source object code
10582: IF(p_trunover_notes_tbl(i).source_object_code <> 'AHL_WO_TURNOVER_NOTES')THEN
10583: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_SOURCE');
10584: FND_MSG_PUB.ADD;
10585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10586: fnd_log.string
10587: (
10588: fnd_log.level_error,
10589: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

Line 10586: fnd_log.string

10582: IF(p_trunover_notes_tbl(i).source_object_code <> 'AHL_WO_TURNOVER_NOTES')THEN
10583: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_SOURCE');
10584: FND_MSG_PUB.ADD;
10585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10586: fnd_log.string
10587: (
10588: fnd_log.level_error,
10589: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10590: 'Invalid source object code for JTF notes' || p_trunover_notes_tbl(i).source_object_code

Line 10588: fnd_log.level_error,

10584: FND_MSG_PUB.ADD;
10585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10586: fnd_log.string
10587: (
10588: fnd_log.level_error,
10589: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10590: 'Invalid source object code for JTF notes' || p_trunover_notes_tbl(i).source_object_code
10591: );
10592: END IF;

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

10595: IF(p_trunover_notes_tbl(i).entered_date > SYSDATE)THEN
10596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_ENT_DT');
10597: FND_MESSAGE.Set_Token('ENTERED_DATE',p_trunover_notes_tbl(i).entered_date);
10598: FND_MSG_PUB.ADD;
10599: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10600: fnd_log.string
10601: (
10602: fnd_log.level_error,
10603: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

Line 10600: fnd_log.string

10596: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_ENT_DT');
10597: FND_MESSAGE.Set_Token('ENTERED_DATE',p_trunover_notes_tbl(i).entered_date);
10598: FND_MSG_PUB.ADD;
10599: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10600: fnd_log.string
10601: (
10602: fnd_log.level_error,
10603: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10604: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)

Line 10602: fnd_log.level_error,

10598: FND_MSG_PUB.ADD;
10599: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10600: fnd_log.string
10601: (
10602: fnd_log.level_error,
10603: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10604: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
10605: );
10606: END IF;

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

10608: -- validate that notes cant not be null
10609: IF(p_trunover_notes_tbl(i).notes IS NULL)THEN
10610: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_NOTES_NLL');
10611: FND_MSG_PUB.ADD;
10612: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10613: fnd_log.string
10614: (
10615: fnd_log.level_error,
10616: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

Line 10613: fnd_log.string

10609: IF(p_trunover_notes_tbl(i).notes IS NULL)THEN
10610: FND_MESSAGE.Set_Name('AHL','AHL_PRD_WO_NOTES_INV_NOTES_NLL');
10611: FND_MSG_PUB.ADD;
10612: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10613: fnd_log.string
10614: (
10615: fnd_log.level_error,
10616: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10617: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)

Line 10615: fnd_log.level_error,

10611: FND_MSG_PUB.ADD;
10612: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
10613: fnd_log.string
10614: (
10615: fnd_log.level_error,
10616: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
10617: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
10618: );
10619: END IF;

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

10687: IF(x_msg_count > 0 )THEN
10688: RAISE FND_API.G_EXC_ERROR;
10689: END IF;
10690:
10691: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10692: fnd_log.string
10693: (
10694: fnd_log.level_procedure,
10695: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.end',

Line 10692: fnd_log.string

10688: RAISE FND_API.G_EXC_ERROR;
10689: END IF;
10690:
10691: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10692: fnd_log.string
10693: (
10694: fnd_log.level_procedure,
10695: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.end',
10696: 'At the end of PLSQL procedure'

Line 10694: fnd_log.level_procedure,

10690:
10691: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10692: fnd_log.string
10693: (
10694: fnd_log.level_procedure,
10695: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.end',
10696: 'At the end of PLSQL procedure'
10697: );
10698: END IF;

Line 10960: fnd_log.string(

10956: CLOSE get_curr_wo_details;
10957:
10958: IF ( G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)
10959: THEN
10960: fnd_log.string(
10961: G_LEVEL_STATEMENT,
10962: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10963: 'Inside procedure Contract_Master_Wo_Dates first l_curr_wip_entity_id -> '||l_curr_wip_entity_id
10964: );

Line 10986: fnd_log.string(

10982: END LOOP;
10983:
10984: IF ( G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)
10985: THEN
10986: fnd_log.string(
10987: G_LEVEL_STATEMENT,
10988: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10989: 'l_curr_wip_entity_id -> '||l_curr_wip_entity_id
10990: );

Line 10991: fnd_log.string(

10987: G_LEVEL_STATEMENT,
10988: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10989: 'l_curr_wip_entity_id -> '||l_curr_wip_entity_id
10990: );
10991: fnd_log.string(
10992: G_LEVEL_STATEMENT,
10993: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10994: 'l_parent_wo_st_date -> '||TO_CHAR(l_parent_wo_st_date, 'DD-MON-YYYY HH24:MI:SS')
10995: );

Line 10996: fnd_log.string(

10992: G_LEVEL_STATEMENT,
10993: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10994: 'l_parent_wo_st_date -> '||TO_CHAR(l_parent_wo_st_date, 'DD-MON-YYYY HH24:MI:SS')
10995: );
10996: fnd_log.string(
10997: G_LEVEL_STATEMENT,
10998: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
10999: 'l_parent_wo_end_date -> '||TO_CHAR(l_parent_wo_end_date, 'DD-MON-YYYY HH24:MI:SS')
11000: );

Line 11388: fnd_log.string(

11384:
11385: BEGIN
11386:
11387: IF (G_LEVEL_PROCEDURE >= G_CURRENT_LOG_LEVEL)THEN
11388: fnd_log.string(
11389: G_LEVEL_PROCEDURE,
11390: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11391: 'At Begin of the Procedure Unclose_Workorder'
11392: );

Line 11429: fnd_log.string(

11425: FND_MSG_PUB.initialize;
11426: END IF;
11427:
11428: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
11429: fnd_log.string(
11430: G_LEVEL_STATEMENT,
11431: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11432: 'Before Basic Validations for the procedure.'
11433: );

Line 11452: fnd_log.string(

11448:
11449: l_user_associated := AHL_UTIL_PKG.Get_User_Role(l_function_name);
11450:
11451: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
11452: fnd_log.string(
11453: G_LEVEL_STATEMENT,
11454: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11455: ' Present Status l_job_status_code = '|| l_job_status_code ||
11456: 'AHL_UTIL_PKG.Get_User_Role(AHL_PRD_UNCLOSE_WORKORDERS) = '|| l_user_associated

Line 11585: fnd_log.string(

11581: END IF;
11582: END IF;
11583:
11584: IF (G_LEVEL_PROCEDURE >= G_CURRENT_LOG_LEVEL)THEN
11585: fnd_log.string(
11586: G_LEVEL_PROCEDURE,
11587: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11588: 'At END of the Procedure Unclose_Workorder'
11589: );

Line 11684: fnd_log.string(

11680: OPEN get_visit_wo_dates_csr(p_visit_id);
11681: FETCH get_visit_wo_dates_csr INTO get_visit_wo_dates_rec;
11682: IF (get_visit_wo_dates_csr%FOUND) THEN
11683: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL) THEN
11684: fnd_log.string(
11685: G_LEVEL_STATEMENT,
11686: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11687: ' Visit dates:Start Date:' || to_char(get_visit_wo_dates_rec.scheduled_start_date,'mm/dd/yyyy hh24:ss')
11688: || ': end date:' || to_char(get_visit_wo_dates_rec.scheduled_end_date, 'mm/dd/yyyy hh24:ss')

Line 11709: fnd_log.string(

11705:
11706: l_prd_workorder_tbl(i).FIRM_PLANNED_FLAG := 2; -- planned.
11707:
11708: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL) THEN
11709: fnd_log.string(
11710: G_LEVEL_STATEMENT,
11711: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11712: 'MWO: ' || i || ':workorder_id:' || l_wo_rec.workorder_id || ':level:' || l_wo_rec.level
11713: );

Line 11722: fnd_log.string(

11718:
11719: END LOOP;
11720: IF (l_prd_workorder_tbl.count > 0) THEN
11721: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL) THEN
11722: fnd_log.string(
11723: G_LEVEL_STATEMENT,
11724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11725: 'Before call to process jobs:Count:' || l_prd_workorder_tbl.count
11726: );

Line 11745: fnd_log.string( G_LEVEL_STATEMENT,

11741: );
11742:
11743: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11744: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL) THEN
11745: fnd_log.string( G_LEVEL_STATEMENT,
11746: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
11747: 'Process_Jobs return status:msg count:' || l_return_status || ':' || l_msg_count
11748: );
11749: END IF;

Line 12651: FND_LOG.STRING( G_LEVEL_PROCEDURE, 'ahl.plsql.'||G_PKG_NAME||'.'||

12647:
12648: BEGIN
12649:
12650: IF (G_LEVEL_PROCEDURE >= G_CURRENT_LOG_LEVEL)THEN
12651: FND_LOG.STRING( G_LEVEL_PROCEDURE, 'ahl.plsql.'||G_PKG_NAME||'.'||
12652: L_API_NAME, 'At the start of PLSQL procedure UPDATE_WO_AOG_STATUS');
12653: END IF;
12654:
12655: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN

Line 12656: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||

12652: L_API_NAME, 'At the start of PLSQL procedure UPDATE_WO_AOG_STATUS');
12653: END IF;
12654:
12655: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12656: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||
12657: L_API_NAME, ' No of Workorders to be updated for AOG Status - ' || p_workorder_id_tbl.COUNT);
12658: END IF;
12659:
12660: -- Standard Start of API savepoint

Line 12682: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||

12678: END IF;
12679:
12680: if (P_WORKORDER_ID_TBL.COUNT = 0) then
12681: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12682: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||
12683: L_API_NAME, ' No workorder details sent for updation, hence return.');
12684: END IF;
12685: RETURN;
12686: END IF;

Line 12698: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||

12694:
12695: l_sql_string := l_sql_string || ')';
12696:
12697: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12698: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||
12699: L_API_NAME, ' Dynamic cursor formed as - ' || l_sql_string);
12700: END IF;
12701:
12702: OPEN get_wo_details FOR L_SQL_STRING;

Line 12710: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, L_WORKORDER_NAME || ' has status - ' || L_WORKORDER_STATUS);

12706: IF(L_WORKORDER_STATUS_CODE in (4, 5, 7, 12, 15, 17, 22))
12707: THEN
12708: L_CURT_STATUS := 'E';
12709: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12710: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, L_WORKORDER_NAME || ' has status - ' || L_WORKORDER_STATUS);
12711: END IF;
12712: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_WORKORDER_STS_INVALID');
12713: FND_MESSAGE.SET_TOKEN('WORKORDER_NUM', L_WORKORDER_NAME);
12714: FND_MESSAGE.SET_TOKEN('WORKORDER_STATUS', L_WORKORDER_STATUS);

Line 12727: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'All workorder have proper status, lets update');

12723: RAISE INVALID_WORKORDER_STATUS;
12724: END IF;
12725:
12726: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12727: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'All workorder have proper status, lets update');
12728: END IF;
12729:
12730: -- Go for bulk update of AHL_WORKORDERS table
12731: FORALL I IN P_WORKORDER_ID_TBL.first .. P_WORKORDER_ID_TBL.last

Line 12743: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'Workorder updation over. Lets insert transaction details to AHL_WORKORDER_TXNS table');

12739: and OBJECT_VERSION_NUMBER = P_WORKORDER_ID_TBL(I).OBJ_VER_NUM;
12740:
12741:
12742: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12743: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'Workorder updation over. Lets insert transaction details to AHL_WORKORDER_TXNS table');
12744: END IF;
12745:
12746: FOR I IN P_WORKORDER_ID_TBL.first .. P_WORKORDER_ID_TBL.last
12747: LOOP

Line 12807: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'INVALID_WORKORDER_STATUS exception generated');

12803: EXCEPTION
12804: WHEN INVALID_WORKORDER_STATUS THEN
12805: ROLLBACK TO UPDATE_WO_AOG_STATUS;
12806: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12807: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'INVALID_WORKORDER_STATUS exception generated');
12808: END IF;
12809: X_return_status := FND_API.G_RET_STS_ERROR;
12810: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
12811: p_count => x_msg_count,

Line 12817: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'NO_DATA_FOUND exception generated');

12813:
12814: WHEN NO_DATA_FOUND THEN
12815: ROLLBACK TO UPDATE_WO_AOG_STATUS;
12816: IF (G_LEVEL_STATEMENT >= G_CURRENT_LOG_LEVEL)THEN
12817: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, 'NO_DATA_FOUND exception generated');
12818: END IF;
12819: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_WO_ID_MISSING');
12820: FND_MESSAGE.SET_TOKEN('WORKORDER', P_WORKORDER_ID_TBL(I).WORKORDER_ID);
12821: fnd_msg_pub.add;

Line 12848: FND_LOG.STRING( G_LEVEL_PROCEDURE, 'ahl.plsql.'||G_PKG_NAME||'.'||

12844: p_count => x_msg_count,
12845: p_data => x_msg_data);
12846:
12847: IF (G_LEVEL_PROCEDURE >= G_CURRENT_LOG_LEVEL)THEN
12848: FND_LOG.STRING( G_LEVEL_PROCEDURE, 'ahl.plsql.'||G_PKG_NAME||'.'||
12849: L_API_NAME, 'At the end of PLSQL procedure UPDATE_WO_AOG_STATUS');
12850: END IF;
12851:
12852: