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.32.12010000.5 2009/01/12 23:31:35 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

1: PACKAGE BODY AHL_PRD_WORKORDER_PVT AS
2: /* $Header: AHLVPRJB.pls 120.32.12010000.5 2009/01/12 23:31:35 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- Operation Statuses
8: G_OP_STATUS_UNCOMPLETE VARCHAR2(2) := '2'; --Uncomplete

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

2588: END IF;
2589: END IF;
2590:
2591: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2592: fnd_log.string(FND_LOG.LEVEL_STATEMENT,'ahl.plsql.AHL_PRD_WORKORDER_PVT.default_attributes',
2593: 'Acc Class code: ' || p_x_prd_workorder_rec.CLASS_CODE);
2594:
2595: END IF;
2596:

Line 2899: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'B', 'C' )) then

2895: AHL_DEBUG_PUB.enable_debug;
2896: END IF;
2897:
2898: -- User Hooks
2899: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'B', 'C' )) then
2900: ahl_prd_workorder_CUHK.create_job_pre(
2901: p_prd_workorder_rec => p_x_prd_workorder_rec,
2902: x_msg_count => l_msg_count,
2903: x_msg_data => l_msg_data,

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

3268: COMMIT;
3269: END IF;
3270:
3271: -- User Hooks
3272: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'CREATE_JOB', 'A', 'C' )) then
3273: ahl_prd_workorder_CUHK.create_job_post(
3274: p_prd_workorder_rec => p_x_prd_workorder_rec,
3275: p_operation_tbl => x_operation_tbl ,
3276: p_resource_tbl => x_resource_tbl,

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

3351: l_parent_workoper_tbl prd_workoper_tbl;
3352: l_wo_status VARCHAR2(80);
3353: l_wo_status_code VARCHAR2(30);
3354:
3355: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.UPDATE_JOB';
3356:
3357: -- Bug # 7643668 (FP for Bug # 6493302) -- start
3358: CURSOR get_parent_workorders( c_child_wip_entity_id NUMBER )
3359: IS

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

3575: END IF;*/
3576: G_CALLED_FROM := p_module_type;
3577:
3578: -- User Hooks
3579: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'B', 'C' )) THEN
3580: ahl_prd_workorder_CUHK.update_job_pre(
3581: p_prd_workorder_rec => p_x_prd_workorder_rec,
3582: p_prd_workoper_tbl => p_x_prd_workoper_tbl,
3583: x_msg_count => l_msg_count,

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

4442: COMMIT;
4443: END IF;
4444:
4445: -- User Hooks
4446: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_WORKORDER_PVT', 'UPDATE_JOB', 'A', 'C' )) THEN
4447:
4448: ahl_prd_workorder_CUHK.update_job_post(
4449: p_prd_workorder_rec => p_x_prd_workorder_rec,
4450: p_prd_workoper_tbl => p_x_prd_workoper_tbl,

Line 7149: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

7145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7146: fnd_log.string
7147: (
7148: fnd_log.level_statement,
7149: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
7150: 'cancelling mwo->'||l_master_workorder_tbl(l_count).workorder_id
7151: );
7152: END IF;
7153: -- Bug # 6815689 (FP for Bug # 68156890) -- start

Line 7184: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

7180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7181: fnd_log.string
7182: (
7183: fnd_log.level_statement,
7184: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
7185: 'return status after calling complete_master_wo: ' || l_mwo_return_status
7186: );
7187: END IF;
7188:

Line 7200: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

7196: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7197: fnd_log.string
7198: (
7199: fnd_log.level_statement,
7200: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
7201: 'completing mwo->'||l_master_workorder_tbl(l_count).workorder_id
7202: );
7203: END IF;
7204:

Line 7215: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',

7211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7212: fnd_log.string
7213: (
7214: fnd_log.level_statement,
7215: 'ahl.AHL_PRD_WORKORDER_PVT.Cancel_Visit_Jobs',
7216: 'return status after calling complete_master_wo: ' || l_mwo_return_status
7217: );
7218: END IF;
7219:

Line 7491: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',

7487: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
7488: fnd_log.string
7489: (
7490: fnd_log.level_procedure,
7491: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',
7492: 'At the start of PLSQL procedure'
7493: );
7494: END IF;
7495: -- Standard start of API savepoint

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

7607: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7608: fnd_log.string
7609: (
7610: fnd_log.level_statement,
7611: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
7612: 'After Validate workorder details '
7613: );
7614:
7615: END IF;

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

7647: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7648: fnd_log.string
7649: (
7650: fnd_log.level_statement,
7651: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
7652: 'Before Calling Process Jobs '
7653: );
7654:
7655: END IF;

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

7676: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7677: fnd_log.string
7678: (
7679: fnd_log.level_statement,
7680: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
7681: 'After calling Process Jobs API to reschedule master workorder'
7682: );
7683:
7684: END IF;

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

7733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7734: fnd_log.string
7735: (
7736: fnd_log.level_statement,
7737: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
7738: 'Before Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO '
7739: );
7740:
7741: END IF;

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

7770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7771: fnd_log.string
7772: (
7773: fnd_log.level_statement,
7774: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs',
7775: 'After Calling EAM_WO_NETWORK_UTIL_PVT.Move_WO ' ||l_return_status
7776: );
7777:
7778: END IF;

Line 7853: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end',

7849: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
7850: fnd_log.string
7851: (
7852: fnd_log.level_procedure,
7853: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.end',
7854: 'At the end of PLSQL procedure'
7855: );
7856: END IF;
7857:

Line 7899: p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type

7895: p_module_type IN VARCHAR2 := Null,
7896: x_return_status OUT NOCOPY VARCHAR2,
7897: x_msg_count OUT NOCOPY NUMBER,
7898: x_msg_data OUT NOCOPY VARCHAR2,
7899: p_trunover_notes_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type
7900: ) IS
7901:
7902: l_api_version CONSTANT NUMBER := 1.0;
7903: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TURNOVER_NOTES';

Line 7940: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',

7936: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
7937: fnd_log.string
7938: (
7939: fnd_log.level_procedure,
7940: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',
7941: 'At the start of PLSQL procedure'
7942: );
7943: END IF;
7944: -- Standard start of API savepoint

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

7956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7957: fnd_log.string
7958: (
7959: fnd_log.level_statement,
7960: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
7961: 'p_init_message_list : ' || p_init_msg_list
7962: );
7963: fnd_log.string
7964: (

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

7962: );
7963: fnd_log.string
7964: (
7965: fnd_log.level_statement,
7966: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
7967: 'p_commit : ' || p_commit
7968: );
7969: END IF;
7970: -- Initialize API return status to success

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

7978: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
7979: fnd_log.string
7980: (
7981: fnd_log.level_error,
7982: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
7983: 'Invalid source object code for JTF notes' || p_trunover_notes_tbl(i).source_object_code
7984: );
7985: END IF;
7986: END IF;

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

7992: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
7993: fnd_log.string
7994: (
7995: fnd_log.level_error,
7996: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
7997: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
7998: );
7999: END IF;
8000: END IF;

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

8005: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
8006: fnd_log.string
8007: (
8008: fnd_log.level_error,
8009: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES',
8010: 'Invalid enterded date' || to_char(p_trunover_notes_tbl(i).entered_date)
8011: );
8012: END IF;
8013: END IF;

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

8084: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
8085: fnd_log.string
8086: (
8087: fnd_log.level_procedure,
8088: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.end',
8089: 'At the end of PLSQL procedure'
8090: );
8091: END IF;
8092:

Line 8163: END AHL_PRD_WORKORDER_PVT;

8159: END IF;
8160: RETURN l_date;
8161: END get_date_and_time;
8162:
8163: END AHL_PRD_WORKORDER_PVT;