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

Line 6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

2: /* $Header: AHLPPNRB.pls 120.0.12010000.1 2008/11/30 21:06:57 sikumar noship $ */
3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 7: l_log_statement NUMBER := fnd_log.level_statement;

3: ------------------------------------
4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

Line 8: l_log_procedure NUMBER := fnd_log.level_procedure;

4: -- Common constants and variables --
5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
12:

Line 9: l_log_error NUMBER := fnd_log.level_error;

5: ------------------------------------
6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
12:
13: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');

Line 10: l_log_unexpected NUMBER := fnd_log.level_unexpected;

6: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
7: l_log_statement NUMBER := fnd_log.level_statement;
8: l_log_procedure NUMBER := fnd_log.level_procedure;
9: l_log_error NUMBER := fnd_log.level_error;
10: l_log_unexpected NUMBER := fnd_log.level_unexpected;
11: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
12:
13: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');
14:

Line 133: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

129: x_return_status := init_user_and_role(p_user_id);
130:
131: -- Log API entry point
132: IF (l_log_procedure >= l_log_current_level) THEN
133: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
134: END IF;
135:
136: -- If the originator wo id is present
137: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)

Line 147: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job');

143: POPULATE_CREATE_SR_INPUT_REC(p_create_nr_input_rec,x_sr_task_rec);
144: p_x_sr_task_tbl(1) := x_sr_task_rec;
145:
146: IF (l_log_statement >= l_log_current_level) THEN
147: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job');
148: END IF;
149: -- Call the API to create the SR and workorder
150: AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job (
151: 1.0,

Line 164: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job');

160: l_mr_asso_tbl
161: );
162:
163: IF (l_log_statement >= l_log_current_level) THEN
164: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job');
165: END IF;
166:
167: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
168: IF (l_log_statement >= l_log_current_level) THEN

Line 169: fnd_log.string(fnd_log.level_statement,l_debug_module,'Call to AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job, Not Success');

165: END IF;
166:
167: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
168: IF (l_log_statement >= l_log_current_level) THEN
169: fnd_log.string(fnd_log.level_statement,l_debug_module,'Call to AHL_PRD_NONROUTINE_PVT.Process_nonroutine_job, Not Success');
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:

Line 189: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling POPULATE_CREATE_MTRL_INPUT_REC');

185: (p_material_req_rec.ITEM_NUMBER IS NOT NULL AND p_material_req_rec.ITEM_NUMBER <> FND_API.G_MISS_CHAR )
186: )
187: THEN
188: IF (l_log_statement >= l_log_current_level) THEN
189: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling POPULATE_CREATE_MTRL_INPUT_REC');
190: END IF;
191: POPULATE_CREATE_MTRL_INPUT_REC(p_matrl_reqrs_for_nr_tbl,p_sr_task_rec.Nonroutine_wo_id,x_req_material_tbl);
192: IF (l_log_statement >= l_log_current_level) THEN
193: fnd_log.string(fnd_log.level_statement,l_debug_module,'After POPULATE_CREATE_MTRL_INPUT_REC');

Line 193: fnd_log.string(fnd_log.level_statement,l_debug_module,'After POPULATE_CREATE_MTRL_INPUT_REC');

189: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling POPULATE_CREATE_MTRL_INPUT_REC');
190: END IF;
191: POPULATE_CREATE_MTRL_INPUT_REC(p_matrl_reqrs_for_nr_tbl,p_sr_task_rec.Nonroutine_wo_id,x_req_material_tbl);
192: IF (l_log_statement >= l_log_current_level) THEN
193: fnd_log.string(fnd_log.level_statement,l_debug_module,'After POPULATE_CREATE_MTRL_INPUT_REC');
194: END IF;
195: IF (l_log_statement >= l_log_current_level) THEN
196: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
197: END IF;

Line 196: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst');

192: IF (l_log_statement >= l_log_current_level) THEN
193: fnd_log.string(fnd_log.level_statement,l_debug_module,'After POPULATE_CREATE_MTRL_INPUT_REC');
194: END IF;
195: IF (l_log_statement >= l_log_current_level) THEN
196: fnd_log.string(fnd_log.level_statement,l_debug_module,'Calling AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
197: END IF;
198:
199: SAVEPOINT CREATE_NON_ROUTINE_MTRLS_SP;
200:

Line 216: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');

212: );
213:
214: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
215: IF (l_log_statement >= l_log_current_level) THEN
216: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
217: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
218: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');
219: FND_MSG_PUB.ADD;
220: END IF;

Line 227: fnd_log.string(fnd_log.level_statement,l_debug_module,'No Materials Requirements to be added');

223:
224:
225: ELSE
226: IF (l_log_statement >= l_log_current_level) THEN
227: fnd_log.string(fnd_log.level_statement,l_debug_module,'No Materials Requirements to be added');
228: END IF;
229: END IF;
230: END IF;
231: /* ADD MATERIAL REQUIREMENTS TO THE JOB CREATED : END */

Line 249: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_UMP_NONROUTINES_PVT.Create_SR');

245: x_msg_data,
246: x_nr_task_rec
247: );
248: IF (l_log_statement >= l_log_current_level) THEN
249: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_UMP_NONROUTINES_PVT.Create_SR');
250: END IF;
251:
252: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: IF (l_log_statement >= l_log_current_level) THEN

Line 254: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_UMP_NONROUTINES_PVT.Create_SR');

250: END IF;
251:
252: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: IF (l_log_statement >= l_log_current_level) THEN
254: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_UMP_NONROUTINES_PVT.Create_SR');
255: END IF;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: POPULATE_CREATE_NR_OUTPUT_REC(x_create_nr_output_rec,x_nr_task_rec);

Line 337: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

333:
334: BEGIN
335: -- Log API entry point
336: IF (l_log_procedure >= l_log_current_level) THEN
337: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
338: END IF;
339:
340: -- If Workorder ID as well Workorder number are present, honour the id
341: IF( (p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID IS NOT NULL AND p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID <> FND_API.G_MISS_NUM)

Line 445: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the start of PL SQL procedure ');

441:
442:
443: -- Log API exit point
444: IF (l_log_procedure >= l_log_current_level) THEN
445: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the start of PL SQL procedure ');
446: END IF;
447: END POPULATE_CREATE_SR_INPUT_REC;
448:
449: -----------------------------------------------------------------------------------------------------------------

Line 469: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.Begin','At the start of PL SQL procedure ');

465: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'ahl_non_routine_pub'||'.'||'populate_create_mtrl_input_rec';
466: BEGIN
467: -- Log API entry point
468: IF (l_log_procedure >= l_log_current_level) THEN
469: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.Begin','At the start of PL SQL procedure ');
470: END IF;
471: IF p_matrl_reqrs_for_nr_tbl.COUNT > 0 THEN
472: FOR i IN p_matrl_reqrs_for_nr_tbl.FIRST..p_matrl_reqrs_for_nr_tbl.LAST
473: LOOP

Line 486: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.End','At the end of PL SQL procedure ');

482: END LOOP;
483: END IF;
484: -- Log API exit point
485: IF (l_log_procedure >= l_log_current_level) THEN
486: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.End','At the end of PL SQL procedure ');
487: END IF;
488: END POPULATE_CREATE_MTRL_INPUT_REC;
489:
490: ------------------------------------------------------------------------------------------------------------------

Line 519: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

515: AND uch.csi_item_instance_id = csi.instance_id;
516: BEGIN
517: -- Log API entry point
518: IF (l_log_procedure >= l_log_current_level) THEN
519: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
520: END IF;
521: -- populate the request date
522: x_nr_task_rec.INCIDENT_DATE := p_create_nr_input_rec.service_request_date;
523: -- populate the summary

Line 567: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');

563: END IF;
564:
565: -- Log API exit point
566: IF (l_log_procedure >= l_log_current_level) THEN
567: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');
568: END IF;
569: END POPULATE_CREATE_NR_INPUT_REC;
570:
571:

Line 591: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

587: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'ahl_non_routine_pub'||'.'||'populate_create_nr_output_rec';
588: BEGIN
589: -- Log API entry point
590: IF (l_log_procedure >= l_log_current_level) THEN
591: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
592: END IF;
593:
594: -- Populate the OUT params
595: x_create_nr_output_rec.SERVICE_REQUEST_ID := p_nr_task_rec.INCIDENT_ID;

Line 705: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');

701: NULL;
702: END;
703: -- Log API exit point
704: IF (l_log_procedure >= l_log_current_level) THEN
705: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');
706: END IF;
707: END POPULATE_CREATE_NR_OUTPUT_REC;
708:
709: ------------------------------------------------------------------------------------------------------------------

Line 728: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');

724: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'ahl_non_routine_pub'||'.'||'populate_create_sr_output_rec';
725: BEGIN
726: -- Log API start point
727: IF (l_log_procedure >= l_log_current_level) THEN
728: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.begin','At the start of PL SQL procedure ');
729: END IF;
730:
731: x_create_nr_output_rec.SERVICE_REQUEST_ID := p_sr_task_rec.Incident_id;
732: -- Populate the OUT params

Line 767: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating workorder_number, p_sr_task_rec.Nonroutine_wo_id:' || p_sr_task_rec.Nonroutine_wo_id);

763:
764: x_create_nr_output_rec.originator_workorder_id := p_sr_task_rec.ORIGINATING_WO_ID;
765:
766: IF (l_log_statement >= l_log_current_level) THEN
767: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating workorder_number, p_sr_task_rec.Nonroutine_wo_id:' || p_sr_task_rec.Nonroutine_wo_id);
768: END IF;
769: BEGIN
770: SELECT workorder_name
771: INTO x_create_nr_output_rec.WORKORDER_NUMBER

Line 780: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating Originator Details, WO id :' || p_sr_task_rec.ORIGINATING_WO_ID );

776: NULL;
777: END;
778:
779: IF (l_log_statement >= l_log_current_level) THEN
780: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating Originator Details, WO id :' || p_sr_task_rec.ORIGINATING_WO_ID );
781: END IF;
782: BEGIN
783: SELECT workorder_name,vst.visit_id,visit_number,visit_task_id
784: INTO x_create_nr_output_rec.ORIGINATOR_WORKORDER_NUMBER,

Line 798: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating Prob, Res Codes, SERVICE_REQUEST_ID:' || x_create_nr_output_rec.service_request_id );

794: NULL;
795: END;
796:
797: IF (l_log_statement >= l_log_current_level) THEN
798: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating Prob, Res Codes, SERVICE_REQUEST_ID:' || x_create_nr_output_rec.service_request_id );
799: END IF;
800: -- Populate the problem,resolution codes and meanings
801: BEGIN
802: SELECT CS.PROBLEM_CODE,FLVT.MEANING,CS.RESOLUTION_CODE ,FLVT1.MEANING

Line 823: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating status_code, Status_id:' || p_sr_task_rec.Status_id);

819: NULL;
820: END;
821:
822: IF (l_log_statement >= l_log_current_level) THEN
823: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating status_code, Status_id:' || p_sr_task_rec.Status_id);
824: END IF;
825: BEGIN
826: SELECT status_code
827: INTO x_create_nr_output_rec.SERVICE_REQUEST_STATUS_CODE

Line 836: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating status_code, Status_id:' || p_sr_task_rec.Status_id);

832: NULL;
833: END;
834:
835: IF (l_log_statement >= l_log_current_level) THEN
836: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating status_code, Status_id:' || p_sr_task_rec.Status_id);
837: END IF;
838: BEGIN
839: SELECT incident_subtype
840: INTO x_create_nr_output_rec.SERVICE_REQUEST_TYPE_CODE

Line 849: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating ITEM_NUMBER,SERIAL_NUMBER instance_id:' || p_sr_task_rec.instance_id);

845: NULL;
846: END;
847:
848: IF (l_log_statement >= l_log_current_level) THEN
849: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating ITEM_NUMBER,SERIAL_NUMBER instance_id:' || p_sr_task_rec.instance_id);
850: END IF;
851: BEGIN
852: SELECT mtl.concatenated_segments,csi.serial_number
853: INTO x_create_nr_output_rec.ITEM_NUMBER,x_create_nr_output_rec.SERIAL_NUMBER

Line 864: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating unit_name, instance_id:' || p_sr_task_rec.instance_id);

860: NULL;
861: END;
862:
863: IF (l_log_statement >= l_log_current_level) THEN
864: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating unit_name, instance_id:' || p_sr_task_rec.instance_id);
865: END IF;
866: BEGIN
867: SELECT AHL_UTIL_UC_PKG.get_unit_name(p_sr_task_rec.instance_id)
868: INTO x_create_nr_output_rec.UNIT_NAME

Line 876: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating severity_name, severity_id:' || p_sr_task_rec.severity_id);

872: NULL;
873: END;
874:
875: IF (l_log_statement >= l_log_current_level) THEN
876: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating severity_name, severity_id:' || p_sr_task_rec.severity_id);
877: END IF;
878: BEGIN
879: SELECT name
880: INTO x_create_nr_output_rec.SEVERITY_NAME

Line 889: fnd_log.string(fnd_log.level_procedure,l_debug_module,'After populating.......');

885: NULL;
886: END;
887:
888: IF (l_log_procedure >= l_log_current_level) THEN
889: fnd_log.string(fnd_log.level_procedure,l_debug_module,'After populating.......');
890: END IF;
891:
892: -- Log API exit point
893: IF (l_log_procedure >= l_log_current_level) THEN

Line 894: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');

890: END IF;
891:
892: -- Log API exit point
893: IF (l_log_procedure >= l_log_current_level) THEN
894: fnd_log.string(fnd_log.level_procedure,l_debug_module||'.end','At the end of PL SQL procedure ');
895: END IF;
896: END POPULATE_CREATE_SR_OUTPUT_REC;
897:
898: END AHL_PRD_NONROUTINE_PUB;