DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PUB dependencies on FND_LOG

Line 187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

183: IF FND_API.to_boolean(p_init_msg_list) THEN
184: FND_MSG_PUB.initialize;
185: END IF;
186:
187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
189: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
190: 'At the start of the procedure');
191: END IF;

Line 188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

184: FND_MSG_PUB.initialize;
185: END IF;
186:
187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
189: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
190: 'At the start of the procedure');
191: END IF;
192:

Line 249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

245: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
252: END IF;
253:

Line 250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
252: END IF;
253:
254: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

345: IF FND_API.to_boolean(p_init_msg_list) THEN
346: FND_MSG_PUB.initialize;
347: END IF;
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
351: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
352: 'At the start of the procedure');
353: END IF;

Line 350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

346: FND_MSG_PUB.initialize;
347: END IF;
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
351: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
352: 'At the start of the procedure');
353: END IF;
354:

Line 411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

407: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
413: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
414: END IF;
415:

Line 412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
413: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
414: END IF;
415:
416: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

505: IF FND_API.to_boolean(p_init_msg_list) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
511: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
512: 'At the start of the procedure');
513: END IF;

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
511: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
512: 'At the start of the procedure');
513: END IF;
514:

Line 546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

542: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545:
546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
548: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
549: END IF;
550:

Line 547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545:
546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
548: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
549: END IF;
550:
551: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

645: IF FND_API.to_boolean(p_init_msg_list) THEN
646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
651: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
652: 'At the start of the procedure');
653: END IF;

Line 650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
651: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
652: 'At the start of the procedure');
653: END IF;
654:

Line 698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

694: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
700: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
701: END IF;
702:

Line 699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
700: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
701: END IF;
702:
703: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

797: IF FND_API.to_boolean(p_init_msg_list) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
803: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
804: 'At the start of the procedure');
805: END IF;

Line 802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
803: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
804: 'At the start of the procedure');
805: END IF;
806:

Line 872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

868: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END IF;
871:
872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
874: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
875: END IF;
876:

Line 873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END IF;
871:
872: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
874: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
875: END IF;
876:
877: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

975: IF FND_API.to_boolean(p_init_msg_list) THEN
976: FND_MSG_PUB.initialize;
977: END IF;
978:
979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
981: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
982: 'At the start of the procedure');
983: END IF;

Line 980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

976: FND_MSG_PUB.initialize;
977: END IF;
978:
979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
981: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
982: 'At the start of the procedure');
983: END IF;
984:

Line 1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1056: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1062: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
1063: END IF;
1064:

Line 1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1062: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
1063: END IF;
1064:
1065: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

Line 1136: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1132: l_msg_count NUMBER;
1133: l_msg_data VARCHAR2(2000);
1134:
1135: BEGIN
1136: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1137: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
1138: END IF;
1139:
1140: -- Standard start of API savepoint

Line 1137: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');

1133: l_msg_data VARCHAR2(2000);
1134:
1135: BEGIN
1136: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1137: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
1138: END IF;
1139:
1140: -- Standard start of API savepoint
1141: SAVEPOINT create_unassigned_instance;

Line 1200: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1196: p_data => x_msg_data,
1197: p_encoded => FND_API.G_FALSE
1198: );
1199:
1200: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1201: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
1202: END IF;
1203:
1204: EXCEPTION

Line 1201: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');

1197: p_encoded => FND_API.G_FALSE
1198: );
1199:
1200: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1201: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
1202: END IF;
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN