eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_PRD_NONROUTINE_PVT

Line 1: PACKAGE BODY AHL_PRD_NONROUTINE_PVT AS

1: PACKAGE BODY AHL_PRD_NONROUTINE_PVT AS
2: /* $Header: AHLVPNRB.pls 120.10.12010000.3 2008/12/25 15:20:54 bachandr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_NONROUTINE_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_NONROUTINE_PVT';

1: PACKAGE BODY AHL_PRD_NONROUTINE_PVT AS
2: /* $Header: AHLVPNRB.pls 120.10.12010000.3 2008/12/25 15:20:54 bachandr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_NONROUTINE_PVT';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
6: -----------------------------------
7: -- Declare Local Procedures --
8: -----------------------------------

Line 12: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

8: -----------------------------------
9:
10: -- Convert value to id
11: PROCEDURE Convert_val_to_id(
12: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
13: x_return_status OUT NOCOPY VARCHAR2
14: );
15:
16: -- Default and validate the parameters

Line 18: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

14: );
15:
16: -- Default and validate the parameters
17: PROCEDURE Default_and_validate_param(
18: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
19: p_module_type IN VARCHAR2,
20: x_return_status OUT NOCOPY VARCHAR2
21: );
22:

Line 25: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

21: );
22:
23: -- Create Service Request
24: PROCEDURE Create_sr(
25: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
26: x_return_status OUT NOCOPY VARCHAR2
27: );
28:
29: -- MR NR ER -- start

Line 48: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

44: -- MR NR ER -- end
45:
46: -- Create VWP Task
47: PROCEDURE Create_task(
48: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
49: x_return_status OUT NOCOPY VARCHAR2
50: );
51:
52: -- Update Service Request

Line 54: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

50: );
51:
52: -- Update Service Request
53: PROCEDURE Update_sr(
54: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
55: x_return_status OUT NOCOPY VARCHAR2
56: );
57:
58: -- Get Message Token

Line 67: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

63: x_instance_number OUT NOCOPY VARCHAR2
64: );
65:
66: -- Get Note and note detail from Message.
67: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
68: x_note OUT NOCOPY VARCHAR2,
69: x_note_detail OUT NOCOPY VARCHAR2
70: );
71: -- procedure to write the input parameters to log

Line 72: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type

68: x_note OUT NOCOPY VARCHAR2,
69: x_note_detail OUT NOCOPY VARCHAR2
70: );
71: -- procedure to write the input parameters to log
72: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type
73: );
74: -- procedure to write the SR API input parameters to log
75: Procedure write_sr_to_log
76: (

Line 131: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

127: p_module_type IN VARCHAR2 := 'JSP',
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
132: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type
133: )
134: IS
135: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_NONROUTINE_JOB';

Line 132: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type

128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
132: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type
133: )
134: IS
135: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_NONROUTINE_JOB';
136: l_api_version CONSTANT NUMBER := 1.0;

Line 140: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;

136: l_api_version CONSTANT NUMBER := 1.0;
137: l_return_status VARCHAR2(3);
138: l_msg_count NUMBER;
139: l_msg_data VARCHAR2(2000);
140: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;
141: l_err_msg_count NUMBER;
142: l_convert_validate_status VARCHAR2(3);
143: l_sr_status_id NUMBER;
144: -- Removing this cursor as status_code is obsoleted as per the update from SR Team and we should use

Line 621: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

617: -- Convert_val_to_id procedure will convert
618: -- values to id's only if the id's are null
619: ----------------------------------------------
620: PROCEDURE Convert_val_to_id(
621: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
622: x_return_status OUT NOCOPY VARCHAR2
623: ) IS
624:
625: l_customer_id NUMBER;

Line 1255: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

1251: -- it will either default the values or return an
1252: -- error message and status.
1253: ------------------------------------------------------------
1254: PROCEDURE Default_and_validate_param(
1255: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
1256: p_module_type IN VARCHAR2,
1257: x_return_status OUT NOCOPY VARCHAR2
1258: ) IS
1259:

Line 1880: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

1876: -- Create service request public api.
1877: ----------------------------------------------
1878:
1879: PROCEDURE Create_sr(
1880: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
1881: x_return_status OUT NOCOPY VARCHAR2
1882: )IS
1883:
1884: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

Line 2499: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

2495: --------------------------------------------
2496: -- Create VWP Task
2497: --------------------------------------------
2498: PROCEDURE Create_task(
2499: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
2500: x_return_status OUT NOCOPY VARCHAR2
2501: ) IS
2502:
2503: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;

Line 2540: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.begin',

2536:
2537: IF (l_debug_PROC >= l_debug_LEVEL) THEN
2538: fnd_log.string
2539: (l_debug_PROC,
2540: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.begin',
2541: 'At the start of PLSQL procedure');
2542: END IF;
2543:
2544: FOR i IN p_x_task_tbl.FIRST..p_x_task_tbl.LAST LOOP

Line 2565: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2561:
2562: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2563: fnd_log.string
2564: (l_debug_STMT,
2565: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2566: 'After deriving request type:' || l_request_type);
2567: END IF;
2568:
2569: -- Derive the originating visit id

Line 2592: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2588:
2589: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2590: fnd_log.string
2591: (l_debug_STMT,
2592: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2593: 'After deriving originating visit task id:' || l_org_task_id);
2594:
2595: END IF;
2596:

Line 2612: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2608:
2609: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2610: fnd_log.string
2611: (l_debug_STMT,
2612: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2613: 'After defaulting task name');
2614: END IF;
2615:
2616: --- Begin Changes by VSUNDARA for SR INTEGRATION

Line 2633: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2629:
2630: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2631: fnd_log.string
2632: (l_debug_STMT,
2633: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2634: 'After deriving UE ID:' || l_unit_effectivity_id);
2635: END IF;
2636:
2637: -- Assign the Create Job Tasks values

Line 2651: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

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

Line 2663: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

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

Line 2691: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2687:
2688: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
2689: fnd_log.string
2690: (l_debug_UEXP,
2691: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2692: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
2693: END IF;
2694:
2695: RAISE FND_API.G_EXC_ERROR;

Line 2712: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2708:
2709: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2710: fnd_log.string
2711: (l_debug_STMT,
2712: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2713: 'Now processing for WO: ' || l_create_job_task_tbl(i).workorder_id);
2714: END IF;
2715:
2716: p_x_task_tbl(i).visit_task_id := l_create_job_task_tbl(i).visit_task_id;

Line 2730: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

2726: -- Default is to release wo.
2727: IF (l_debug_STMT >= l_debug_LEVEL) THEN
2728: fnd_log.string
2729: (l_debug_STMT,
2730: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
2731: 'Before calling AHL_PRD_WORKORDER_PVT.Release_visit_jobs for WO: ' || l_create_job_task_tbl(i).workorder_id);
2732: END IF;
2733:
2734: AHL_PRD_WORKORDER_PVT.Release_visit_jobs

Line 2754: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',

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

Line 2768: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.End',

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

Line 2788: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

2784: -- the service request record and calls the
2785: -- update_servicerquest public api.
2786: ----------------------------------------------
2787: PROCEDURE Update_sr(
2788: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
2789: x_return_status OUT NOCOPY VARCHAR2
2790: ) IS
2791:
2792: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

Line 2893: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

2889:
2890: -----------------------------------------
2891: -- Get Note Information from the Message
2892: -----------------------------------------
2893: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
2894: x_note OUT NOCOPY VARCHAR2,
2895: x_note_detail OUT NOCOPY VARCHAR2)
2896: IS
2897: l_part_number VARCHAR2(80);

Line 2949: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type)

2945: -- Write to Log
2946: -- This procedure writes the input
2947: -- values to a log file
2948: -----------------------------------
2949: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type)
2950: IS
2951: BEGIN
2952: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
2953: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);

Line 3023: END AHL_PRD_NONROUTINE_PVT;

3019: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3020: END write_sr_to_log;
3021:
3022:
3023: END AHL_PRD_NONROUTINE_PVT;