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

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

651: IF FND_API.to_boolean( p_init_msg_list ) THEN
652: FND_MSG_PUB.initialize;
653: END IF;
654:
655: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
657: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
658: 'At the start of the procedure');
659: END IF;

Line 656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

652: FND_MSG_PUB.initialize;
653: END IF;
654:
655: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
657: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
658: 'At the start of the procedure');
659: END IF;
660:

Line 670: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

666: -- Set unit_config_status_code to 'DRAFT'
667: p_x_uc_header_rec.unit_config_status_code := 'DRAFT';
668: -- Nullify G_MISS values of optional fields
669: nullify_attributes(p_x_uc_header_rec);
670: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
673: ': after nullify_attributes');
674: END IF;

Line 671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

667: p_x_uc_header_rec.unit_config_status_code := 'DRAFT';
668: -- Nullify G_MISS values of optional fields
669: nullify_attributes(p_x_uc_header_rec);
670: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
672: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
673: ': after nullify_attributes');
674: END IF;
675:

Line 689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: --dbms_output.put_line('after mc_header validate and mc_name '|| p_x_uc_header_rec.mc_name);
689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
691: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
692: ': after validate_mc_header and l_relationship_id ='||l_relationship_id);
693: END IF;

Line 690: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: --dbms_output.put_line('after mc_header validate and mc_name '|| p_x_uc_header_rec.mc_name);
689: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
691: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
692: ': after validate_mc_header and l_relationship_id ='||l_relationship_id);
693: END IF;
694:

Line 717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: END IF;
715: END IF;
716:
717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
720: ': aafter validate_attributes');
721: END IF;

Line 718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

714: END IF;
715: END IF;
716:
717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
719: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
720: ': aafter validate_attributes');
721: END IF;
722:

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

865: END IF;
866: END IF;
867: END IF;
868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
871: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
872: END IF;
873:

Line 870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

958: IF FND_API.to_boolean( p_init_msg_list ) THEN
959: FND_MSG_PUB.initialize;
960: END IF;
961:
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
964: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
965: 'At the start of the procedure');
966: END IF;

Line 963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

959: FND_MSG_PUB.initialize;
960: END IF;
961:
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
964: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
965: 'At the start of the procedure');
966: END IF;
967:

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

972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
978: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
979: ': after convert_attributes');
980: END IF;

Line 977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
978: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
979: ': after convert_attributes');
980: END IF;
981:

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

995: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998: END IF;
999: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1001: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1002: ': after validate_attributes');
1003: END IF;

Line 1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998: END IF;
999: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1001: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1002: ': after validate_attributes');
1003: END IF;
1004:

Line 1037: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1033: attribute15 = p_x_uc_header_rec.attribute15
1034: WHERE unit_config_header_id = p_x_uc_header_rec.uc_header_id
1035: AND object_version_number = p_x_uc_header_rec.object_version_number;
1036: IF SQL%NOTFOUND THEN
1037: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1039: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','ovn='||p_x_uc_header_rec.object_version_number);
1040: END IF;
1041: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

Line 1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1034: WHERE unit_config_header_id = p_x_uc_header_rec.uc_header_id
1035: AND object_version_number = p_x_uc_header_rec.object_version_number;
1036: IF SQL%NOTFOUND THEN
1037: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1039: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','ovn='||p_x_uc_header_rec.object_version_number);
1040: END IF;
1041: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1042: FND_MSG_PUB.add;

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

1050: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1051: FND_MSG_PUB.add;
1052: END IF;
1053:
1054: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1056: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','before calling update_instance_attr');
1057: END IF;
1058:

Line 1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1051: FND_MSG_PUB.add;
1052: END IF;
1053:
1054: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1056: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','before calling update_instance_attr');
1057: END IF;
1058:
1059: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1055: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1056: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','before calling update_instance_attr');
1057: END IF;
1058:
1059: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1060: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','x_return_status='||x_return_status);
1062: END IF;
1063: --Call ahl_uc_instance_pvt.update_instance_attr to update the top node instance attributes

Line 1060: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1056: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','before calling update_instance_attr');
1057: END IF;
1058:
1059: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1060: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1061: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','x_return_status='||x_return_status);
1062: END IF;
1063: --Call ahl_uc_instance_pvt.update_instance_attr to update the top node instance attributes
1064: --In front end UI, if there is no change to the instance attributes, then the whole p_uc_instance_rec

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

1075: p_uc_header_id => p_x_uc_header_rec.uc_header_id,
1076: p_uc_instance_rec => p_uc_instance_rec,
1077: p_prod_user_flag => 'N');
1078:
1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1081: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After calling update_instance_attr');
1082: END IF;
1083:

Line 1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1076: p_uc_instance_rec => p_uc_instance_rec,
1077: p_prod_user_flag => 'N');
1078:
1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1081: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After calling update_instance_attr');
1082: END IF;
1083:
1084: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1081: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After calling update_instance_attr');
1082: END IF;
1083:
1084: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1086: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','x_return_status='||x_return_status);
1087: END IF;
1088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1081: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After calling update_instance_attr');
1082: END IF;
1083:
1084: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1085: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1086: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API','x_return_status='||x_return_status);
1087: END IF;
1088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1089: RAISE FND_API.G_EXC_ERROR;

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

1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: END IF;
1092:
1093: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1094: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1095: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'Before check message count');
1096: END IF;
1097:

Line 1094: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1090: END IF;
1091: END IF;
1092:
1093: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1094: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1095: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'Before check message count');
1096: END IF;
1097:
1098: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception

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

1101: x_msg_count := l_msg_count;
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1107: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'Before commit');
1108: END IF;
1109:

Line 1106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1107: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'Before commit');
1108: END IF;
1109:
1110: -- Perform the Commit (if requested)

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

1111: IF FND_API.to_boolean( p_commit ) THEN
1112: COMMIT;
1113: END IF;
1114:
1115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1117: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After commit');
1118: END IF;
1119:

Line 1116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1112: COMMIT;
1113: END IF;
1114:
1115: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1117: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': within API', 'After commit');
1118: END IF;
1119:
1120: -- Count and Get messages (optional)

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

1239: IF FND_API.to_boolean( p_init_msg_list ) THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242:
1243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1245: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1246: 'At the start of the procedure');
1247: END IF;

Line 1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1240: FND_MSG_PUB.initialize;
1241: END IF;
1242:
1243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1245: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
1246: 'At the start of the procedure');
1247: END IF;
1248:

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

1419: FND_MSG_PUB.add;
1420: END IF;
1421: END LOOP;
1422:
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1425: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
1426: END IF;
1427:

Line 1424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1420: END IF;
1421: END LOOP;
1422:
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1425: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
1426: END IF;
1427:
1428: -- Perform the Commit (if requested)