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 AHL_PRD_WORKORDER_PVT

Line 1: PACKAGE BODY AHL_PRD_WORKORDER_PVT AS

1: PACKAGE BODY AHL_PRD_WORKORDER_PVT AS
2: /* $Header: AHLVPRJB.pls 120.74.12020000.3 2012/12/17 07:33:07 jkjain ship $ */
3:
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_PVT';

Line 5: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_PVT';

1: PACKAGE BODY AHL_PRD_WORKORDER_PVT AS
2: /* $Header: AHLVPRJB.pls 120.74.12020000.3 2012/12/17 07:33:07 jkjain ship $ */
3:
4:
5: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_PVT';
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7:
8: -- Operation Statuses
9: G_OP_STATUS_UNCOMPLETE VARCHAR2(2) := '2'; --Uncomplete

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 3862: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'B', 'C' )) then

3858: AHL_DEBUG_PUB.enable_debug;
3859: END IF;
3860:
3861: -- User Hooks
3862: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'B', 'C' )) then
3863: ahl_prd_workorder_CUHK.create_job_pre(
3864: p_prd_workorder_rec => p_x_prd_workorder_rec,
3865: x_msg_count => l_msg_count,
3866: x_msg_data => l_msg_data,

Line 4317: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'A', 'C' )) then

4313: COMMIT;
4314: END IF;
4315:
4316: -- User Hooks
4317: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'A', 'C' )) then
4318: ahl_prd_workorder_CUHK.create_job_post(
4319: p_prd_workorder_rec => p_x_prd_workorder_rec,
4320: p_operation_tbl => x_operation_tbl ,
4321: p_resource_tbl => x_resource_tbl,

Line 4402: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.UPDATE_JOB';

4398: l_wo_status_code VARCHAR2(30);
4399: -- ER#10257011 Supplier Warranty manisaga
4400: l_entitlement_rec AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type;
4401:
4402: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.UPDATE_JOB';
4403: l_dummy VARCHAR2(1); -- Fix for Bug 9439418
4404: --sukhwsin::SB Effectivity - Variable Declaration for uom conversion- starts
4405: l_prim_quantity NUMBER;
4406: l_prim_uom_code VARCHAR2(3);

Line 4586: L_X_PRD_WORKORDER_REC AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

4582: l_operation_seq_num NUMBER;
4583: l_resource_seq_num NUMBER;
4584: l_workorder_name ahl_workorders.workorder_name%TYPE;
4585:
4586: L_X_PRD_WORKORDER_REC AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
4587: L_OPERATION_TBL AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
4588: L_MATERIAL_REQ_TBL AHL_PP_MATERIALS_PVT.REQ_MATERIAL_TBL_TYPE;
4589: L_RESOURCE_REQ_TBL AHL_PP_RESRC_REQUIRE_PVT.RESRC_REQUIRE_TBL_TYPE;
4590:

Line 4810: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'B', 'C' )) THEN

4806: END IF;*/
4807: G_CALLED_FROM := p_module_type;
4808: AHL_DEBUG_PUB.debug( FND_MSG_PUB.count_msg || ' skp1 FND_MSG_PUB.count_msg= '||FND_MSG_PUB.count_msg );
4809: -- User Hooks
4810: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'B', 'C' )) THEN
4811: AHL_DEBUG_PUB.debug( FND_MSG_PUB.count_msg || ' skp2 FND_MSG_PUB.count_msg= '||FND_MSG_PUB.count_msg );
4812: ahl_prd_workorder_CUHK.update_job_pre(
4813: p_prd_workorder_rec => p_x_prd_workorder_rec,
4814: p_prd_workoper_tbl => p_x_prd_workoper_tbl,

Line 5754: ahl_prd_workorder_pvt.expand_mwo_dates(p_x_prd_workorder_rec.workorder_id, p_x_prd_workorder_rec.visit_id);

5750: END IF;
5751:
5752: -- Expand MWO if firm flag is changed from firm to planned for ER# 9368251
5753: IF (l_expand_mwo_flag) THEN
5754: ahl_prd_workorder_pvt.expand_mwo_dates(p_x_prd_workorder_rec.workorder_id, p_x_prd_workorder_rec.visit_id);
5755: END IF;
5756:
5757: IF ( G_DEBUG = 'Y' )
5758: THEN

Line 5923: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(l_resource_tbl(l_res_count).workorder_id);

5919: END IF;
5920: --apattark end changes for ER #9368251
5921: IF l_plan_flag = 2 THEN
5922:
5923: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(l_resource_tbl(l_res_count).workorder_id);
5924:
5925: END IF;
5926: END LOOP;
5927: -- added to fix ER #9368251

Line 5929: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(p_x_prd_workorder_rec.workorder_id);

5925: END IF;
5926: END LOOP;
5927: -- added to fix ER #9368251
5928: ELSIF (l_expand_mwo_flag) THEN
5929: AHL_PRD_WORKORDER_PVT.Update_Master_Wo_Dates(p_x_prd_workorder_rec.workorder_id);
5930: END IF;
5931: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
5932:
5933: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 6210: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'A', 'C' )) THEN

6206: COMMIT;
6207: END IF;
6208:
6209: -- User Hooks
6210: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'A', 'C' )) THEN
6211:
6212: ahl_prd_workorder_CUHK.update_job_post(
6213: p_prd_workorder_rec => p_x_prd_workorder_rec,
6214: p_prd_workoper_tbl => p_x_prd_workoper_tbl,

Line 9605: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

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;
9609: -- Bug # 6815689 (FP for Bug # 68156890) -- start

Line 9640: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

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;
9644:

Line 9656: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

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;
9660:

Line 9671: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

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;
9675:

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 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 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 10261: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

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 || '}'
10265: || '{ mwo_rec.status_code : ' || mwo_rec.status_code || '}'

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 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 10342: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

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;
10346: END IF;

Line 10355: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',

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 || '}'
10359: || '{ mwo_rec.status_code : ' || mwo_rec.status_code || '}'

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 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 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 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 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 10506: p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type

10502: p_module_type IN VARCHAR2 := Null,
10503: x_return_status OUT NOCOPY VARCHAR2,
10504: x_msg_count OUT NOCOPY NUMBER,
10505: x_msg_data OUT NOCOPY VARCHAR2,
10506: p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type
10507: ) IS
10508:
10509: l_api_version CONSTANT NUMBER := 1.0;
10510: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TURNOVER_NOTES';

Line 10547: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.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;
10551: -- Standard start of API savepoint

Line 10567: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

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
10571: (

Line 10573: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

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;
10577: -- Initialize API return status to success

Line 10589: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

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;
10593: END IF;

Line 10603: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

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;
10607: END IF;

Line 10616: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',

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;
10620: END IF;

Line 10695: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.end',

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;
10699:

Line 10777: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC

10773: -- This is a supplementary procedure for procedure Update_Master_Wo_Dates.
10774: --------------------------------------------------------------------------------------------------
10775: PROCEDURE default_missing_wo_attributes(
10776:
10777: p_x_prd_workorder_rec IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC
10778:
10779: )
10780: IS
10781: CURSOR get_workorder_rec(c_workorder_id NUMBER)

Line 10935: l_x_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

10931: AND parent_object_id = c_wip_entity_id
10932: AND relationship_type = 1
10933: );
10934:
10935: l_x_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
10936: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
10937: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
10938: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
10939:

Line 11382: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;

11378: l_date_completed DATE;
11379: l_msg_data VARCHAR2(2000);
11380: l_return_status VARCHAR2(1);
11381: l_msg_count NUMBER;
11382: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
11383: l_user_associated VARCHAR2(30);
11384:
11385: BEGIN
11386:

Line 11408: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'B', 'C' )) THEN

11404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11405: END IF;
11406:
11407: -- User Hooks
11408: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'B', 'C' )) THEN
11409: ahl_prd_workorder_CUHK.update_job_pre(
11410: p_prd_workorder_rec => p_x_prd_workorder_rec,
11411: p_prd_workoper_tbl => l_prd_workoper_tbl,
11412: x_msg_count => l_msg_count,

Line 11568: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'A', 'C' )) THEN

11564: END IF;
11565:
11566:
11567: -- User Hooks
11568: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'A', 'C' )) THEN
11569:
11570: ahl_prd_workorder_CUHK.update_job_post(
11571: p_prd_workorder_rec => p_x_prd_workorder_rec,
11572: p_prd_workoper_tbl => l_prd_workoper_tbl,

Line 11803: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

11799: AND vst.department_id = nvl(p_department_id, vst.department_id)
11800: AND vst.organization_id = nvl(p_organization_id, vst.organization_id);
11801:
11802: -- Local variables section
11803: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
11804: l_wo_count NUMBER;
11805: l_msg_count NUMBER;
11806: l_msg_data VARCHAR2(2000);
11807: l_return_status VARCHAR2(1);

Line 11973: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.POPULATE_ENTITLEMENTS';

11969: l_entl_status VARCHAR2(30);
11970: l_contract_id NUMBER;
11971:
11972:
11973: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.POPULATE_ENTITLEMENTS';
11974:
11975: CURSOR get_contract_id ( c_contract_number NUMBER, c_visit_task_id NUMBER) IS
11976: SELECT WARRANTY_CONTRACT_ID
11977: FROM AHL_WARRANTY_CONTRACTS_B AWCB,

Line 12190: l_turnover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;

12186: l_msg_count NUMBER;
12187: l_msg_data VARCHAR2(2000);
12188: l_return_status VARCHAR2(1);
12189: l_insert_flag VARCHAR2(1);
12190: l_turnover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;
12191: l_workorder_id NUMBER;
12192: l_jtf_note_id NUMBER;
12193: BEGIN
12194: -- Initialize return status to success

Line 12855: END AHL_PRD_WORKORDER_PVT;

12851:
12852:
12853: END UPDATE_WO_AOG_STATUS;
12854:
12855: END AHL_PRD_WORKORDER_PVT;