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.

[Home] [Help]

APPS.AHL_UMP_UNPLANNED_PVT dependencies on FND_LOG

Line 12: -- FND Logging Constants

8:
9: G_USER_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.USER_ID);
10: G_LOGIN_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.LOGIN_ID);
11:
12: -- FND Logging Constants
13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9: G_USER_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.USER_ID);
10: G_LOGIN_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.LOGIN_ID);
11:
12: -- FND Logging Constants
13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

10: G_LOGIN_ID CONSTANT NUMBER := TO_NUMBER(FND_GLOBAL.LOGIN_ID);
11:
12: -- FND Logging Constants
13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
18:

Line 15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

11:
12: -- FND Logging Constants
13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
18:
19: -------------------

Line 16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

12: -- FND Logging Constants
13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
18:
19: -------------------
20: -- Spec Procedure Signatures --

Line 17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

13: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
17: G_DEBUG_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
18:
19: -------------------
20: -- Spec Procedure Signatures --
21: -------------------

Line 145: fnd_log.string

141: BEGIN
142:
143: -- Log API entry point
144: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
145: fnd_log.string
146: (
147: G_DEBUG_PROC,
148: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
149: 'At the start of PLSQL procedure'

Line 177: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );

173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL ) THEN
177: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );
178: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_appln_code: ' || l_appln_code);
179: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_return_status: ' || l_return_status);
180: END IF;
181:

Line 178: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_appln_code: ' || l_appln_code);

174: END IF;
175:
176: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL ) THEN
177: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );
178: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_appln_code: ' || l_appln_code);
179: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_return_status: ' || l_return_status);
180: END IF;
181:
182:

Line 179: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_return_status: ' || l_return_status);

175:
176: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL ) THEN
177: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );
178: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_appln_code: ' || l_appln_code);
179: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' l_return_status: ' || l_return_status);
180: END IF;
181:
182:
183: IF (p_init_msg_list = FND_API.G_TRUE) THEN

Line 199: fnd_log.string

195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
197: FND_MSG_PUB.ADD;
198: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
199: fnd_log.string
200: (
201: G_DEBUG_ERROR,
202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
203: 'Invalid Procedure Call'

Line 218: fnd_log.string

214: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_MR_NOT_FOUND');
215: FND_MSG_PUB.ADD;
216: CLOSE check_mr_exists;
217: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
218: fnd_log.string
219: (
220: G_DEBUG_ERROR,
221: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
222: 'MR is not found'

Line 238: fnd_log.string

234: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE'); --message reused
235: FND_MSG_PUB.ADD;
236: CLOSE check_instance_exists;
237: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
238: fnd_log.string
239: (
240: G_DEBUG_ERROR,
241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
242: 'Instance Number is invalid'

Line 255: fnd_log.string

251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
253: FND_MSG_PUB.add;
254: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
255: fnd_log.string
256: (
257: G_DEBUG_ERROR,
258: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
259: 'Application Usage Mode is not defined or is invalid'

Line 307: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
307: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_COMMON_PVT.Populate_Appl_MRs to populate AHL_APPLICABLE_MRS');
308: END IF;
309:
310: --loop not need as only one record.The Top Group MR is returned.
311: OPEN Get_all_appl_mrs ( p_mr_header_id , p_instance_id );

Line 344: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_PVT.GET_APPLICABLE_MRS to validate MR-Instance applicability' );

340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
344: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'AFTER Calling AHL_FMP_PVT.GET_APPLICABLE_MRS to validate MR-Instance applicability' );
345: END IF;
346:
347: l_mr_applicable_flag := false;
348: IF (l_applicable_mr_tbl.COUNT > 0) THEN

Line 376: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'Fleet header id derived -> '||l_fleet_header_id);

372:
373: l_fleet_header_id := AHL_UMP_UTIL_PKG.Get_Associated_Fleet(AHL_UTIL_UC_PKG.get_uc_header_id(p_instance_id => p_instance_id),sysdate,null);
374:
375: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
376: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , 'Fleet header id derived -> '||l_fleet_header_id);
377: END IF;
378:
379: -- BACHANDR - NR project end
380:

Line 476: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
476: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance to populate AHL_APPLICABLE_MR_RELNS' );
477: END IF;
478:
479:
480: -- create Unit Effectivities from Related MRs also

Line 483: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

479:
480: -- create Unit Effectivities from Related MRs also
481:
482: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
483: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' BEFORE Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
484: END IF;
485:
486: FOR l_appl_mrs_relns IN Get_Appl_Mr_Relns
487: LOOP

Line 594: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );

590:
591: END LOOP;
592:
593: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
594: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row for Related MRs from AHL_APPLICABLE_MR_RELNS' );
595: END IF;
596:
597: -- to update the AHL_UE_RELATIONSHIPS table with the Unit Effectivity Relationships
598:

Line 650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );

646: );
647: END LOOP;
648:
649: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );
651: END IF;
652: END IF;
653:
654:

Line 661: fnd_log.string

657:
658: -- Log API exit point
659: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
660: THEN
661: fnd_log.string
662: (
663: G_DEBUG_PROC,
664: L_DEBUG_MODULE||'.end',
665: 'At the end of PLSQL procedure'

Line 682: fnd_log.string

678: WHEN FND_API.G_EXC_ERROR THEN
679: Rollback to sp_create_unit_effectivity;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
682: fnd_log.string
683: (
684: G_DEBUG_ERROR,
685: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
686: 'Expected error'

Line 700: fnd_log.string

696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
697: Rollback to sp_create_unit_effectivity;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
700: fnd_log.string
701: (
702: G_DEBUG_ERROR,
703: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
704: 'Unexpected error'

Line 727: fnd_log.string

723: p_error_text => SUBSTR(SQLERRM,1,240)
724: );
725: END IF;
726: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
727: fnd_log.string
728: (
729: G_DEBUG_ERROR,
730: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
731: 'Other errors'

Line 812: fnd_log.string

808:
809: -- Log API entry point
810: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
811: THEN
812: fnd_log.string
813: (
814: G_DEBUG_PROC,
815: L_DEBUG_MODULE||'.begin',
816: 'At the start of PLSQL procedure'

Line 851: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER finding the originator UE id '|| l_originator_ue_id );

847: END IF;
848: CLOSE GetOrigUeId;
849:
850: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
851: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER finding the originator UE id '|| l_originator_ue_id );
852: END IF;
853:
854:
855: -- if the ue id to be deleted is not found

Line 875: fnd_log.string

871: AND l_object_type = 'SR')THEN
872: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
873: FND_MSG_PUB.ADD;
874: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
875: fnd_log.string
876: (
877: G_DEBUG_ERROR,
878: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
879: 'Cannot delete UE'

Line 910: fnd_log.string

906: ELSE
907: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
908: FND_MSG_PUB.ADD;
909: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
910: fnd_log.string
911: (
912: G_DEBUG_ERROR,
913: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
914: 'Cannot delete UE'

Line 924: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting all related UE s and their relationships');

920:
921: END LOOP;
922:
923: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
924: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting all related UE s and their relationships');
925: END IF;
926:
927: -- added for SB Enh for 'Chain' case
928: BEGIN

Line 944: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting the originator UE ');

940:
941: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(l_originator_ue_id);
942:
943: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
944: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER deleting the originator UE ');
945: END IF;
946: -- API body ends here
947:
948: -- Log API exit point

Line 951: fnd_log.string

947:
948: -- Log API exit point
949: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
950: THEN
951: fnd_log.string
952: (
953: G_DEBUG_PROC,
954: L_DEBUG_MODULE||'.end',
955: 'At the end of PLSQL procedure'

Line 979: fnd_log.string

975: WHEN FND_API.G_EXC_ERROR THEN
976: Rollback to sp_delete_unit_effectivity;
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
979: fnd_log.string
980: (
981: G_DEBUG_ERROR,
982: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
983: 'Expected error'

Line 997: fnd_log.string

993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: Rollback to sp_delete_unit_effectivity;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
997: fnd_log.string
998: (
999: G_DEBUG_ERROR,
1000: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1001: 'Unexpected error'

Line 1024: fnd_log.string

1020: p_error_text => SUBSTR(SQLERRM,1,240)
1021: );
1022: END IF;
1023: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
1024: fnd_log.string
1025: (
1026: G_DEBUG_ERROR,
1027: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1028: 'Other errors'