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.26.12020000.2 2012/12/07 07:59:01 sareepar 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.26.12020000.2 2012/12/07 07:59:01 sareepar 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_mr_asso_count IN NUMBER,
20: p_module_type IN VARCHAR2,
21: x_return_status OUT NOCOPY VARCHAR2
22: );

Line 26: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

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

Line 49: p_x_sr_task_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type,

45: p_commit IN VARCHAR2,
46: p_validation_level IN NUMBER,
47: p_module_type IN VARCHAR2,
48: p_mr_asso_count IN NUMBER,
49: p_x_sr_task_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2
53: );

Line 64: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

60: -- MR NR ER -- end
61:
62: -- Create VWP Task
63: PROCEDURE Create_task(
64: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
65: x_return_status OUT NOCOPY VARCHAR2
66: );
67:
68: -- Update Service Request

Line 70: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

66: );
67:
68: -- Update Service Request
69: PROCEDURE Update_sr(
70: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
71: x_return_status OUT NOCOPY VARCHAR2
72: );
73:
74: -- Get Message Token

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

79: x_instance_number OUT NOCOPY VARCHAR2
80: );
81:
82: -- Get Note and note detail from Message.
83: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
84: x_note OUT NOCOPY VARCHAR2,
85: x_note_detail OUT NOCOPY VARCHAR2
86: );
87: -- procedure to write the input parameters to log

Line 88: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type

84: x_note OUT NOCOPY VARCHAR2,
85: x_note_detail OUT NOCOPY VARCHAR2
86: );
87: -- procedure to write the input parameters to log
88: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type
89: );
90: -- procedure to write the SR API input parameters to log
91: Procedure write_sr_to_log
92: (

Line 147: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

143: p_module_type IN VARCHAR2 := 'JSP',
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
148: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type
149: )
150: IS
151: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_NONROUTINE_JOB';

Line 148: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type

144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_x_sr_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
148: p_x_mr_asso_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type
149: )
150: IS
151: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_NONROUTINE_JOB';
152: l_api_version CONSTANT NUMBER := 1.0;

Line 156: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;

152: l_api_version CONSTANT NUMBER := 1.0;
153: l_return_status VARCHAR2(3);
154: l_msg_count NUMBER;
155: l_msg_data VARCHAR2(2000);
156: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;
157: l_err_msg_count NUMBER;
158: l_convert_validate_status VARCHAR2(3);
159: l_sr_status_id NUMBER;
160: -- Removing this cursor as status_code is obsoleted as per the update from SR Team and we should use

Line 678: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

674: -- Convert_val_to_id procedure will convert
675: -- values to id's only if the id's are null
676: ----------------------------------------------
677: PROCEDURE Convert_val_to_id(
678: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
679: x_return_status OUT NOCOPY VARCHAR2
680: ) IS
681:
682: l_customer_id NUMBER;

Line 1391: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

1387: -- it will either default the values or return an
1388: -- error message and status.
1389: ------------------------------------------------------------
1390: PROCEDURE Default_and_validate_param(
1391: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
1392: p_mr_asso_count IN NUMBER,
1393: p_module_type IN VARCHAR2,
1394: x_return_status OUT NOCOPY VARCHAR2
1395: ) IS

Line 2066: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

2062: -- Create service request public api.
2063: ----------------------------------------------
2064:
2065: PROCEDURE Create_sr(
2066: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
2067: x_return_status OUT NOCOPY VARCHAR2
2068: )IS
2069:
2070: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

Line 2347: -- p_x_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type Required

2343: -- Parameters :
2344: --
2345: -- Update_warranty_entitlements Parameters:
2346: -- p_mr_asso_count IN NUMBER Required
2347: -- p_x_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type Required
2348: --
2349: -- End of Comments.
2350: PROCEDURE Update_warranty_entitlements
2351: (

Line 2358: p_x_sr_task_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type,

2354: p_commit IN VARCHAR2,
2355: p_validation_level IN NUMBER,
2356: p_module_type IN VARCHAR2,
2357: p_mr_asso_count IN NUMBER,
2358: p_x_sr_task_tbl IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type,
2359: x_return_status OUT NOCOPY VARCHAR2,
2360: x_msg_count OUT NOCOPY NUMBER,
2361: x_msg_data OUT NOCOPY VARCHAR2
2362: )

Line 2400: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;

2396: l_warranty_entl_id NUMBER;
2397: l_object_version_number NUMBER;
2398: l_visit_task_id NUMBER;
2399: l_workorder_id NUMBER;
2400: l_sr_task_rec ahl_prd_nonroutine_pvt.sr_task_rec_type;
2401: l_warranty_entl_tbl ahl_warranty_entl_pvt.warranty_entl_tbl_type;
2402: --
2403: BEGIN
2404:

Line 3164: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,

3160: --------------------------------------------
3161: -- Create VWP Task
3162: --------------------------------------------
3163: PROCEDURE Create_task(
3164: p_x_task_tbl IN OUT NOCOPY ahl_prd_nonroutine_pvt.sr_task_tbl_type,
3165: x_return_status OUT NOCOPY VARCHAR2
3166: ) IS
3167:
3168: l_create_job_task_tbl AHL_VWP_PROJ_PROD_PVT.Task_tbl_type;

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

3201:
3202: IF (l_debug_PROC >= l_debug_LEVEL) THEN
3203: fnd_log.string
3204: (l_debug_PROC,
3205: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.begin',
3206: 'At the start of PLSQL procedure');
3207: END IF;
3208:
3209: FOR i IN p_x_task_tbl.FIRST..p_x_task_tbl.LAST LOOP

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

3226:
3227: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3228: fnd_log.string
3229: (l_debug_STMT,
3230: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3231: 'After deriving request type:' || l_request_type);
3232: END IF;
3233:
3234: -- Derive the originating visit id

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

3253:
3254: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3255: fnd_log.string
3256: (l_debug_STMT,
3257: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3258: 'After deriving originating visit task id:' || l_org_task_id);
3259:
3260: END IF;
3261:

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

3273:
3274: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3275: fnd_log.string
3276: (l_debug_STMT,
3277: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3278: 'After defaulting task name');
3279: END IF;
3280:
3281: --- Begin Changes by VSUNDARA for SR INTEGRATION

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

3294:
3295: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3296: fnd_log.string
3297: (l_debug_STMT,
3298: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3299: 'After deriving UE ID:' || l_unit_effectivity_id);
3300: END IF;
3301:
3302: -- Assign the Create Job Tasks values

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

3312:
3313: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3314: fnd_log.string
3315: (l_debug_STMT,
3316: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3317: 'End loop for visit task name: ' || l_visit_task_name);
3318: END IF;
3319:
3320: END IF;

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

3324:
3325: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3326: fnd_log.string
3327: (l_debug_STMT,
3328: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3329: 'Before calling AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3330: END IF;
3331:
3332: AHL_VWP_PROJ_PROD_PVT.Create_job_tasks(

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

3352:
3353: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
3354: fnd_log.string
3355: (l_debug_UEXP,
3356: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3357: 'Error ' || x_return_status ||' returned from AHL_VWP_PROJ_PROD_PVT.Create_job_tasks');
3358: END IF;
3359:
3360: RAISE FND_API.G_EXC_ERROR;

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

3373:
3374: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3375: fnd_log.string
3376: (l_debug_STMT,
3377: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3378: 'Now processing for WO: ' || l_create_job_task_tbl(i).workorder_id);
3379: END IF;
3380:
3381: p_x_task_tbl(i).visit_task_id := l_create_job_task_tbl(i).visit_task_id;

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

3391: -- Default is to release wo.
3392: IF (l_debug_STMT >= l_debug_LEVEL) THEN
3393: fnd_log.string
3394: (l_debug_STMT,
3395: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3396: 'Before calling AHL_PRD_WORKORDER_PVT.Release_visit_jobs for WO: ' || l_create_job_task_tbl(i).workorder_id);
3397: END IF;
3398:
3399: AHL_PRD_WORKORDER_PVT.Release_visit_jobs

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

3415: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3416: IF (l_debug_UEXP >= l_debug_LEVEL) THEN
3417: fnd_log.string
3418: (l_debug_UEXP,
3419: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task',
3420: 'Error ' || x_return_status ||' returned from AHL_PRD_WORKORDER_PVT.Release_visit_jobs');
3421: END IF;
3422: RAISE FND_API.G_EXC_ERROR;
3423: END IF;

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

3429:
3430: IF (l_debug_PROC >= l_debug_LEVEL) THEN
3431: fnd_log.string
3432: (l_debug_PROC,
3433: 'ahl.plsql.AHL_PRD_NONROUTINE_PVT.Create_task.End',
3434: 'At the end of PLSQL procedure');
3435: END IF;
3436:
3437: EXCEPTION

Line 3453: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,

3449: -- the service request record and calls the
3450: -- update_servicerquest public api.
3451: ----------------------------------------------
3452: PROCEDURE Update_sr(
3453: p_x_sr_task_rec IN OUT NOCOPY AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
3454: x_return_status OUT NOCOPY VARCHAR2
3455: ) IS
3456:
3457: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

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

3554:
3555: -----------------------------------------
3556: -- Get Note Information from the Message
3557: -----------------------------------------
3558: Procedure get_note_value(p_sr_task_rec IN AHL_PRD_NONROUTINE_PVT.sr_task_rec_type,
3559: x_note OUT NOCOPY VARCHAR2,
3560: x_note_detail OUT NOCOPY VARCHAR2)
3561: IS
3562: l_part_number VARCHAR2(80);

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

3610: -- Write to Log
3611: -- This procedure writes the input
3612: -- values to a log file
3613: -----------------------------------
3614: Procedure write_to_log(p_sr_tasK_tbl IN ahl_prd_nonroutine_pvt.sr_task_tbl_type)
3615: IS
3616: BEGIN
3617: FOR i IN p_sr_task_tbl.FIRST..p_sr_task_tbl.LAST LOOP
3618: AHL_DEBUG_PUB.debug('INPUT - Type Id('||i||'):'||p_sr_task_tbl(i).type_id);

Line 3689: END AHL_PRD_NONROUTINE_PVT;

3685: AHL_DEBUG_PUB.debug('note_context_type_01:'||p_notes_table(1).note_context_type_01);
3686: END write_sr_to_log;
3687:
3688:
3689: END AHL_PRD_NONROUTINE_PVT;