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 871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

Line 872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 965: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 979: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1002: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1059: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1089: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1098: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1120: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1428: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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